V$RESOURCE_LIMIT ????
- From: "Wolfson Larry - lwolfs" <lawrence.wolfson@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Apr 2007 14:32:01 -0500
DB 9.2.0.6.0
HP-UX B.11.23 U ia64 3621536037
I ran a script against V$RESOURCE_LIMIT and got :
*** SESSION ID:(77.16224) 2007-04-27 12:33:01.413
Exception signal: 4 (SIGILL), code: 1 (Illegal opcode), addr:
0x60000000004d16c2, PC: [0x60000000004d16c2, _etext_f()+2305
843009103587938]
r1: 400000000119dac0 r20: 40000000008fbb40 br5:
0
r2: c0000000be143000 r21: 9fffffffbf564b28 br6:
60000000004d16c0
r3: 802b r22: 8 br7:
e00000011c001400
r4: 9fffffffbf569d0c r23: 656e71756575655f ip:
60000000004d16c2
r5: c0000000b6c04330 r24: 8 iipa:
0
r6: c0000000b6c04408 r25: 8 cfm:
3
r7: 9fffffffbf5699c8 r26: 40000000008fbb48 um:
3a
r8: 60000000004d16c0 r27: 9fffffffbf564b30 rsc:
1f
r9: 9fffffffbf75b030 r28: 40000000008fbb40 bsp:
9fffffffbf8006d0
r10: 0 r29: 9fffffffbf564b28 bspstore:
9fffffffbf8006d0
r11: 60000000004de7f8 r30: 0 rnat:
0
r12: 9fffffffffff8ba0 r31: 0 ccv:
0
r13: 9fffffffbf5a9420 NaTs: 0 unat:
0
r14: 7265736f75726365 PRs: c86b fpsr:
9804c8274433f
r15: 656e71756575655f br0: 40000000028b2a80 pfs:
c00000000000060f
r16: 2 br1: 0 lc:
0
r17: 60000000005b112d br2: 0 ec:
0
r18: 34 br3: 0 isr:
9fffffffbf8006d0
r19: 73 br4: 0 ifa:
c0000000b64864d8
Reason code: 0054
*** 2007-04-27 12:33:01.422
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump
[_etext_f()+2305843009103587938] [SIGILL] [Illegal opcode]
[0x60000000004D16C2
] [] []
Current SQL statement for this session:
SELECT name
,RESOURCE_NAME RESOURCES
,CURRENT_UTILIZATION CURR
,MAX_UTILIZATION MAX
,INITIAL_ALLOCATION INITIALLY
,LIMIT_VALUE
,to_char(SYSDATE,'mm/dd/yy hh24:mi:ss') timestamp
FROM V$RESOURCE_LIMIT
,DB
Then just :
14:22:28 LNW>SELECT * FROM V$RESOURCE_LIMIT;
ERROR:
ORA-03113: end-of-file on communication channel
14:27:11 LNW>desc V$RESOURCE_LIMIT
Name Null? Type
---------------------------- --------
----------------------------------------
RESOURCE_NAME VARCHAR2(30)
CURRENT_UTILIZATION NUMBER
MAX_UTILIZATION NUMBER
INITIAL_ALLOCATION VARCHAR2(10)
LIMIT_VALUE VARCHAR2(10)
ML hasn't been much help. Anyone have an idea?
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Apr 27 14:27:08 2007
TIA,
Larry
*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
Other related posts:
