DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2001
    I'v got a problem: sometimes when I make desc of any object SQL+ get a error:

    SQL> desc live.SERIAL_TBL;
    Name Null? Type
    ----------------------------------------------------------------------- SESSION_IDNUMBER(15)
    Segmentation fault (core dumped)
    [oracle@www2 oracle]$ sqlplus system

    Is anybody knows what the reason of that?
    Is it Oracle's problem or HD? As for HD we have RAID 5.
    NOthing in the trace files.
    Thank you.

    [Edited by kgb on 05-08-2001 at 08:46 AM]

  2. #2
    Join Date
    Jul 2000

    I found this on the metalink, and i think this is what is happening to you:

    "Segmentation Fault (coredump) occurs whenever I use describe on a table in the datadictionary (ie. describe dba_objects)

    I have discovered that changing the linesize corrects this problem in the active sqlplus session. Upon starting sqlplus the linesize is 200, and the describe utility coredumps everytime I try to describe a dba_ table (I am connected as a user with DBA privileges when this happens). I then restart sqlplu and "set linesize 120", and describe works without dumping core. "

    the answer was:

    This is the bug #842965 in version 8.1.5 and has been fixed in 8.1.6

    In 8.1.5,you will get the coredump whenever the linesize is set to greater than 132.

    hope this helps

  3. #3
    Join Date
    Mar 2001
    Thank you!!!
    Very much!

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