interpreting trace file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: interpreting trace file

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    interpreting trace file

    Hi All

    Our oracle database in open VMS suddenly went down ..

    i suspect this happened because of huge I/O ..

    could anybody give their views .....

    appreciate your help ..
    I need to give explanation for this in my office ...

    Dump file DSA5:[ORACLE8.DB_SPAR.TRACE]SPARKY_SPAR_BG_SMON_006.trc
    19-MAY-2004 15:37:03.70:
    Parallel server mode inactive
    ------------------------------------------------------------
    Proc: 0x20600162 ORA_SPAR_SMON User: [277,100] ORACLE8 Term:
    Image: DSA4:[ORACLE8.RDBMS]ORACLE.EXE
    CPU Time Used (10ms): a
    $CREPRC flags: 200, Current Privs: 7319e8a5
    Event Flags 0-31/32-63/Mask: e0001001/80000000/d
    Job Subprocesses/Current Mode/PHD Flags: 0/0/7b354848
    ASTs Active/Avail./Enabled/Limit: 0/499/15/500
    Buffered IO Count Avail./Limit: 99/100
    Buffered IO Byte Count Avail./Limit: 3991744/3991744
    Direct IO Count Avail./Limit/Operations: 100/100/25
    Enqueue Count Avail./Limit: 49995/50000
    Open File Count Avail./Limit/ShFilLm: 29958/30000/0
    Page File Count Avail./Limit/Location: 1478432/1500000/50331648
    Active Page Table Count: 0, Page Faults: 924
    Pages in Working Set - Global/Process-Private: 6160/5904
    FreePTEs (unsigned longwords 0:1): 4259748384:3
    Subprocess Count/Limit: 0/10
    Timer Queue Count Avail/Limit: 100/100
    Working Set Max. Size/Max. Extent/Quota: 20000/656112/20000
    Working Set Current Extent/Size/Peak: 656112/17600/12064
    ------------------------------------------------------------
    vsnsql=f vsnxtr=3
    Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production With the Partitionin
    cpu ALPH 80000000 vms V7.2-1 clustered with 2 nodes
    Node name: SPARKY
    scsnd: SPARKY , ndname: SPARKY, sys$node = SPARKY::
    hwmdl: 1820 hwnm: Compaq AlphaServer ES40 cpus: FFFFFFFF cpush: 0 active: 4, av
    locktbl size 6400 max 3352463 resource hash size 16384
    Instance name: SPAR
    Redo thread mounted by this instance: 1
    Oracle process number: 6
    VMS process pid: 20600162, image: ORACLE


    *** SESSION ID:(5.1) 2004-05-19 15:37:03.655
    Using 5 slaves for 5 dead transactions
    Recovered xid: 0x000a.004.000045b5 in 10 milliseconds; nchk=0, size=70
    Recovered xid: 0x0008.006.0000465c in 0 milliseconds; nchk=0, size=155
    Recovered xid: 0x0007.018.00004df2 in 10 milliseconds; nchk=0, size=183
    Recovered xid: 0x0009.006.0000494b in 10 milliseconds; nchk=0, size=569

    *** 2004-05-19 17:30:24.473
    Using 5 slaves for 1 dead transactions
    Recovered xid: 0x0002.00f.00004458 in 0 milliseconds; nchk=0, size=135
    [End of file]

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Well, your first problem is that you're running Compaq.

    second, you're on 8.1.7.3 if you're not going to upgrade to a version that's not going to be supported anymore come the end of the year at least upgrade to the .4

    and lastly, if your database is crashing, open a TAR with Oracle. Asking for advice here on what to tell your management is the last place you should be asking.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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