| problem with statspack [message #266774] |
Tue, 11 September 2007 11:06  |
thorin666
Messages: 144
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 #266777 is a reply to message #266775] |
Tue, 11 September 2007 11:18  |
thorin666
Messages: 144
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 #578662 is a reply to message #578658] |
Sun, 03 March 2013 03:23 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
