RE: revoking "ALTER SESSION"

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 09 Apr 2003 09:25:43 -0800
Message-ID: <F001.0057E12B.20030409092543@fatcity.com>

in 9202 lib cache dump at level 10 ...
/var/opt/oracle/logs/CRMDEV/crmdev1_ora_6864914.trc Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
ORACLE_HOME = /usr/opt/oracle/current
System name: AIX

Node name:      rhea
Release:        1
Version:        5
Machine:        002357CA4C00

Instance name: CRMDEV1
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 6864914, image: oracle_at_rhea <mailto:oracle_at_rhea> (TNS V1-V3)  

...... [ much later in the file ]  

BUCKET 113773:
  LIBRARY OBJECT HANDLE: handle=700000005737b08   name=alter user a identified by b
  hash=4867bc6d timestamp=04-09-2003 12:21:27   namespace=CRSR flags=RON/TIM/PN0/SML/[12010000]   kkkk-dddd-llll=0000-0001-0001 lock=0 pin=0 latch#=11   lwt=700000005737b38[700000005737b38,700000005737b38] ltm=700000005737b48[700000005737b48,700000005737b48]   pwt=700000005737b68[700000005737b68,700000005737b68] ptm=700000005737bf8[700000005737bf8,700000005737bf8]   ref=700000005737b18[700000005737b18, 700000005737b18] lnd=700000005737c10[700000005737c10,700000005737c10]

    LIBRARY OBJECT: object=700000005733a30     type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0     CHILDREN: size=16
    child# table reference handle

• -------- --------- -------- 0 70000000573c408 70000000573c1c8 700000005737910 DATA BLOCKS: data# heap pointer status pins change
  • -------- -------- ------ ---- ------ 0 700000005737a48 700000005733b28 I/-/A 0 NONE

Raj

---

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 09 2003 - 12:25:43 CDT