memory allocation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: memory allocation

  1. #1
    Join Date
    Feb 2001
    Posts
    2

    Angry

    already 3 days I worry about a problem of being kicked off the database.
    I can connect to Oracle 8.1.5 using VB application. But after any SELECT with a GROUP or an ORDER I dont get back an curser and loose connection. The sqlnet.log says "Protocol adater error".
    There is also a trace on the server with "internal or fatal error". In addition to this there comes an ORA-00600 and a stack trace. There are words like HEAP SIZE, BUCKET and FREE SPACE with not to large values - thats why I thing there may be a parameter problem with the memory sizes.
    The server gots 640MB RAM. Oracle installation:
    SHARED_POOL_SIZE=64M
    LARGE_POOL_SIZE=32M
    SORT_AREA_SIZE=32000000
    DB_BLOCK_BUFFERS=121525 (block_size=2048)

    Please give a hint.
    Thanks

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    Generally, if you have 600 errors, you'd call Oracle support.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you try running the query on the sqlprompt. IF not try that and could you post the status of the issue. Though they say ORA-6000 need to be reported, they aren't that fatel to panic. Lets see what happens when you get to execute the query on the sqlplus. Might be a poor design of query.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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


Click Here to Expand Forum to Full Width