How to collect information on what the process is actually doing This section will only discuss Oracle server processes. You should have determined with the methods discusses in the previous sections, that one or more oracle server processes is responsible for the memory consumption. Remember it is not always the process getting the ORA that is responsible for the memory consumption. It happens to be the process not getting the memory it requests.
For processes steadily increasing their memory, we can have a look while it runs. General suggestions on avoiding this error As mentioned before, some operations just require a lot of memory. When more memory is required to complete the search, the server process will use a temporary segment. Review the optimizer strategy, some access paths might need more memory due to sort operations, the use of functions on more rows, Make sure your operating system and oracle limits are set reasonably.
Himanshu, don't you think that you violate Oracle Copyright by publishing their notes? I should ask you to be more lawful, because this site owners may suffer from your carelessness. Him, Thank you very much for your kind offer of help. It's very much appreciated. Thanks Dima, I was not aware of this. I'll take care in future. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The Tek-Tips staff will check this out and take appropriate action.
Click Here to join Tek-Tips and talk with other members! Already a Member? Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free!
Already a member? Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. With PAE, the page directories and page tables are extended from 4 byte to 8 byte formats, thus allowing for the base address of page tables to be increased from 20 bits to 24 bits.
You need to edit the boot. You are commenting using your WordPress. You are commenting using your Google account.
You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account.
Notify me of new comments via email. Notify me of new posts via email. Miracle Benelux Better in Oracle. Better in SQL. Better in IT. I will update later with some more info. Share this: Twitter Facebook. Like this: Like Loading By: Nayyar Ahmad on February 20, at pm Reply. By: akolk on February 20, at pm Reply. By: Mario on February 25, at pm Reply. By: Marco Gralike on March 4, at pm Reply. By: Colin 't Hart on March 31, at pm Reply.
0コメント