Results 1 to 10 of 19

Thread: Ora-04031: unable to allocate nnnnn bytes of shared memory

Thread Tools
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

Previous Post

Next Post

03-21-2003, 01:34 AM #10
SANJAY_G

View Profile

View Forum Posts

Senior Advisor
Join Date

Feb 2000

Location

Singapore

Posts

1,758
As Pando said, your SORT_AREA_SIZE is too big. If there are 5 sessions doing sorts concurrently, 1 GB of memory will be taken up by this 5 sessions.

Sanjay G.
Oracle Certified Professional 8i, 9i.

"The degree of normality in a database is inversely proportional to that of its DBA"

Reply With Quote

« Previous Thread | Next Thread »

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
[VIDEO] code is On
HTML code is On

Click Here to Expand Forum to Full Width

Terms and Conditions | About Us | Privacy Notice | Contact Us | Advertise | Sitemap| California - Do Not Sell My Info

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

All times are GMT -4. The time now is 08:01 AM.