Home » RDBMS Server » Performance Tuning » problem with statspack
problem with statspack [message #266774] Tue, 11 September 2007 11:06 Go to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

hi to everyone
i have a problem, and i cant find a solution
the problem is that i was working (without problem) with statspack and including today few hours ago...
but repently i had errors on the database and when i try to use statspack and try to get a snap i get
exec statspack.snap(i_snap_level => 6);
ORA-03113: end-of-file on communication channel
and the sqlplus connection crash
i tried to drop and create again (spdrop and spcreate) but the problem continues.

can someone give me a tip? (i have not a metalink user)
Re: problem with statspack [message #266775 is a reply to message #266774] Tue, 11 September 2007 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 22495
Registered: January 2009
Senior Member
In some/many/most cases ORA-03113 will generate a trace file which can contain meaningful clues.
Re: problem with statspack [message #266777 is a reply to message #266775] Tue, 11 September 2007 11:18 Go to previous messageGo to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

i get this from alert_sid.log
Tue Sep 11 12:55:33 2007
Errors in file /u07/trace/udump/educar_ora_13554.trc:
ORA-07445: exception encountered: core dump [msqsub()+23] [SIGSEGV] [Address not mapped to object] [0x5B3F] [] []
Tue Sep 11 12:56:07 2007
SMON: Parallel transaction recovery tried

###################################


and the user dump show me that

cat trc.txt
TKPROF: Release 10.2.0.1.0 - Production on Tue Sep 11 13:14:01 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Trace file: /u07/trace/udump/educar_ora_13554.trc
Sort options: default

********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: /u07/trace/udump/educar_ora_13554.trc
Trace file compatibility: 10.01.00
Sort options: default

       1  session in tracefile.
       0  user  SQL statements in trace file.
       0  internal SQL statements in trace file.
       0  SQL statements in trace file.
       0  unique SQL statements in trace file.
   68159  lines in trace file.
       0  elapsed seconds in trace file.




but i don't think that may help
or i am wrong?

[Updated on: Wed, 12 September 2007 08:26]

Report message to a moderator

Re: problem with statspack [message #266783 is a reply to message #266774] Tue, 11 September 2007 11:35 Go to previous messageGo to next message
BlackSwan
Messages: 22495
Registered: January 2009
Senior Member
My assessment is that you are hitting a new bug with no known work around; at least according the feedback from MetaStink's ORA-07445 Lookup Tool to my input.
Re: problem with statspack [message #266914 is a reply to message #266777] Wed, 12 September 2007 00:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

In Addition,
you should submit your alert_sid.log or TRACE files to Oracle Support.

Regards
Mohammed Taj
Re: problem with statspack [message #266937 is a reply to message #266777] Wed, 12 September 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition,
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.

Regards
Michel
Re: problem with statspack [message #577929 is a reply to message #266774] Thu, 21 February 2013 17:48 Go to previous messageGo to next message
remikb
Messages: 1
Registered: February 2013
Location: Poland
Junior Member
Hello,

looks like I am hitting the same bug. In my case it is happening only on Windows platform, on 10.2.0.4 and when the statspack snapschot level is set to 6 (from default 5).

Greetings
Remigiusz Boguszewicz
Re: problem with statspack [message #577954 is a reply to message #577929] Fri, 22 February 2013 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only Oracle can help you.
First check on Metalink/MOS for any workaround, then none then upgrade in 10.2.0.5, if it does not work then download the patch, if there is any.

Regards
Michel
Re: problem with statspack [message #578625 is a reply to message #266777] Sat, 02 March 2013 08:07 Go to previous messageGo to next message
LNossov
Messages: 284
Registered: July 2011
Location: Germany
Senior Member
I suppose, it is the bug 7022234.
[Edit MC: remove workaround from Metalink note, this is copyrighted information.]
Alternatively you can apply the corresponding oneoff.

[Updated on: Sat, 02 March 2013 08:11] by Moderator

Report message to a moderator

Re: problem with statspack [message #578627 is a reply to message #578625] Sat, 02 March 2013 08:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not post information from any Metalink/MOS note.
These are copyrighted materials and it is illegal to post them.

Regards
Michel
Re: problem with statspack [message #578644 is a reply to message #578627] Sat, 02 March 2013 14:47 Go to previous messageGo to next message
LNossov
Messages: 284
Registered: July 2011
Location: Germany
Senior Member
Hello Michel

just for my understanding. Is it illegal to reference MOS? It is new for me. There are a lot of books, that reference MOS.
Perhaps I should have written "the work around from the note nnn of MOS is so and so". But the bug number is practically the note number.

Regards
Leonid
Re: problem with statspack [message #578645 is a reply to message #578644] Sat, 02 March 2013 15:04 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can reference MOS with the number of the note, it is illegal to post what is inside the note.

Regards
Michel
Re: problem with statspack [message #578658 is a reply to message #578645] Sun, 03 March 2013 02:49 Go to previous messageGo to next message
LNossov
Messages: 284
Registered: July 2011
Location: Germany
Senior Member
If someone references an issue, it is legal to write for ex. "in [1] is proven, that 2 + 2 = 4". So I cannot understand, why it is not legal to write "in the note 1111.1 of MOS the following workaround is suggested". Or there is a special copyright for Oracle issues?

Regards
Leonid
Re: problem with statspack [message #578662 is a reply to message #578658] Sun, 03 March 2013 03:23 Go to previous message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not special, it is clearly stated in Legal Notices and Terms of Use at the bottom of each MOS page:

Quote:
You may not use, disclose, reproduce, transmit, or otherwise copy in any form or by any means the information contained in the Materials for any purpose, other than to support your authorized use of the Oracle programs and/or hardware for which you hold a current support contract from Oracle, without the prior written permission of Oracle.


(Materials is defined in the Introduction, in short anything that is in the site.)

Note that this is also in your contract with Oracle.

Regards
Michel
Previous Topic: Explain plan - cost(CPU%)
Next Topic: PARALLEL when I don't want it
Goto Forum:
  


Current Time: Fri Jul 25 06:59:44 CDT 2014

Total time taken to generate the page: 0.06703 seconds