RE: V$RESOURCE_LIMIT ????

Larry,  

Did you try the ORA-7445 and/or stack trace lookup tool? (See ML doc id 153788.1.)  

-Mark  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest/CSA 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry -

lwolfs
Sent: Friday, April 27, 2007 3:32 PM
To: oracle-l_at_freelists.org
Subject: V$RESOURCE_LIMIT ????


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.
************************************************************************
*

--
http://www.freelists.org/webpage/oracle-l