ora:600 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ora:600 error

  1. #1
    Join Date
    Dec 2001
    Posts
    120
    I am getting ORA:600 error when trying to select * from a particular view. If I directly query the base table on which the view is based then this error is not coming. the query is fetching rows properly from the view but at the end of it waits for few seconds and gives the error ORA:600. I don't know how to tackle this problem. Can anybody pls guide me to solve this problem.
    I am running oracle 8.1.0.5 on win NT (service pack 5). I am also runnig oracle 9iAPS and APACHE on linux servers. We are not using OPS (for info pls).

    Parijat Paul



    [Edited by parijat67 on 01-24-2002 at 07:25 AM]

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    ORA:600 is something you need to contact oracle support about.

    They'll ask you to send in some trace files and run a utility or two to gather info for them to decide what's wrong.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi

    This error means a space (memory) leak has been detected in the UGA. The argument is the number of bytes leaked.

    There is NO data corruption as a result of this error. It is purely an internal memory housekeeping problem.

    So, Please try to bounce your Database and Restart your Server.


    Anandharaj
    a_anandharaj@yahoo.com

  4. #4
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi,

    Since "ORA-00600" is internal error code, We can not find the exact solution. So, if you send the trace file, we can further explore...
    Anandharaj
    a_anandharaj@yahoo.com

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Before vall to oracle suport u can little bit explain problem.
    U need - 1 number in error message - ora-600 ... [1 number],[],[]...
    and alert log files.

    1 number can say to u layer where error occured, for example -
    [00000] - service layer
    ...
    [17000] - generic layer
    ...
    (all list u can find on metalink)

    and u can check alert files in $ORACLE_BASE/$ORACLE_SID/bdump/...

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