Not able to drop user Oracle10.2.0.3 Ent Ed.

[Ramakanta Sahoo]

Hi All,

I created some users and now I am not able to drop them as system user also. Though I'm able to drop the tablespaces.
Its throwing below errors:

SQL> drop user amr cascade;
drop user amr cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


What could be wrong with database settings or any other params required???


Thanks,
-Ricky

[Jeanne Boyarsky]

What user are you logged in when running this? What tool are you running it through? (sql plus or something else)

[Paul Campbell]

alter session set sql_trace=true;

drop user amr cascade;

from the trace file you should be able to identify your issue or there should be enough info to help you resolve the problem.

[Ramakanta Sahoo]

Jeanne Boyarsky wrote:What user are you logged in when running this? What tool are you running it through? (sql plus or something else)

Sqlplus only.

No other tool

User : system

[Paul Campbell]

did you run the SQL trace and determine your constraints?

[Ramakanta Sahoo]

Paul Campbell wrote:did you run the SQL trace and determine your constraints?

Hi Idid what you said please find the below attched file.
Sorry for putting it in code as I'm not able to attach the file.

   
Dump file d:\oracle\product\10.2.0\admin\s156db\udump\s156db_ora_1936.trc

Mon Mar 02 18:08:39 2009

ORACLE V10.2.0.3.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Windows NT Version V5.2 Service Pack 2

CPU                 : 2 - type 8664, 1 Physical Cores

Process Affinity    : 0x0000000000000000

Memory (Avail/Total): Ph:1800M/3839M, Ph+PgF:6720M/8636M

Instance name: s156db



Redo thread mounted by this instance: 1



Oracle process number: 15



Windows thread id: 1936, image: ORACLE.EXE (SHAD)





*** 2009-03-02 18:08:39.142

*** ACTION NAME:() 2009-03-02 18:08:39.111

*** MODULE NAME:(SQL*Plus) 2009-03-02 18:08:39.111

*** SERVICE NAME:(s156db) 2009-03-02 18:08:39.111

*** SESSION ID:(126.50527) 2009-03-02 18:08:39.111

XCTEND rlbk=0, rd_only=1

=====================

PARSING IN CURSOR #2 len=21 dep=0 uid=5 oct=53 lid=5 tim=267382270020 hv=0 ad='7a9fc08'

drop user amr cascade

END OF STMT

PARSE #2:c=31250,e=30806,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=267382270013

=====================

PARSING IN CURSOR #1 len=652 dep=1 uid=38 oct=47 lid=38 tim=267382277334 hv=3055982128 ad='c4799208'

BEGIN

  BEGIN

    IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN

      xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);

    END IF;

  EXCEPTION

    WHEN OTHERS THEN

     null;

  END;

  BEGIN

    IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN

      xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);

    END IF;

  EXCEPTION

    WHEN OTHERS THEN

     null;

  END;

END;

END OF STMT

PARSE #1:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=267382277326

=====================

PARSING IN CURSOR #3 len=51 dep=2 uid=38 oct=3 lid=38 tim=267382306686 hv=397653107 ad='c48cc650'

SELECT USER_ID FROM ALL_USERS WHERE USERNAME = :B1 

END OF STMT

PARSE #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267382306678

EXEC #3:c=0,e=96,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267382313707

FETCH #3:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267382315262

EXEC #3:c=0,e=83,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267382316994

FETCH #3:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267382318611

EXEC #1:c=0,e=14021,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=267382320321

=====================

PARSING IN CURSOR #1 len=524 dep=1 uid=46 oct=47 lid=46 tim=267382322055 hv=2633728740 ad='c45b6250'

declare

   stmt varchar2(200);

   rdf_exception EXCEPTION;   pragma exception_init(rdf_exception, -20000);

BEGIN

     if dictionary_obj_type = 'USER' THEN

       BEGIN

         EXECUTE IMMEDIATE

          'begin ' ||

            'mdsys.rdf_apis_internal.' ||

            'notify_drop_user(''' ||

             dbms_assert.QUALIFIED_SQL_NAME(dictionary_obj_name) || '''); ' ||

          'end;';

         EXCEPTION

           WHEN rdf_exception THEN RAISE;

           WHEN OTHERS        THEN NULL;

       END;

    end if;

end;

END OF STMT

PARSE #1:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=267382322047

=====================

PARSING IN CURSOR #4 len=59 dep=2 uid=46 oct=47 lid=46 tim=267382370515 hv=957049659 ad='c46757f8'

begin mdsys.rdf_apis_internal.notify_drop_user('AMR'); end;

END OF STMT

PARSE #4:c=0,e=135,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267382370507

=====================

PARSING IN CURSOR #5 len=57 dep=3 uid=46 oct=3 lid=46 tim=267382382824 hv=2379380151 ad='c41b3970'

select count(*) from mdsys.rdf_rulebase$ where owner = :1

END OF STMT

PARSE #5:c=0,e=329,p=0,cr=0,cu=0,mis=1,r=0,dep=3,og=1,tim=267382382816

=====================

PARSE ERROR #5:len=57 dep=3 uid=46 oct=3 lid=46 tim=267382390285 err=942

select count(*) from mdsys.rdf_rulebase$ where owner = :

EXEC #4:c=0,e=12721,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,tim=267382394869

EXEC #1:c=0,e=27318,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=267382396766

=====================

PARSING IN CURSOR #4 len=58 dep=1 uid=46 oct=3 lid=46 tim=267382398972 hv=1385655277 ad='c46e3a10'

select dummy from dual where  ora_dict_obj_type = 'TABLE'

END OF STMT

PARSE #4:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=267382398964

EXEC #4:c=0,e=311,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=267382408684

FETCH #4:c=0,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=267382410566

STAT #4 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER  (cr=0 pr=0 pw=0 time=246 us)'

STAT #4 id=2 cnt=0 pid=1 pos=1 obj=258 op='TABLE ACCESS FULL DUAL (cr=0 pr=0 pw=0 time=0 us)'

=====================

PARSING IN CURSOR #1 len=83 dep=1 uid=0 oct=3 lid=0 tim=267382416871 hv=3891323434 ad='c446a090'

select obj# from RecycleBin$ where owner#=:1 and    to_number(bitand(flags, 4)) = 4

END OF STMT

PARSE #1:c=0,e=99,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382416863

EXEC #1:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382427012

FETCH #1:c=0,e=123,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=267382429032

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=702 op='TABLE ACCESS FULL RECYCLEBIN$ (cr=3 pr=0 pw=0 time=121 us)'

=====================

PARSING IN CURSOR #4 len=90 dep=1 uid=0 oct=3 lid=0 tim=267382433206 hv=2674841749 ad='a4f1f888'

select obj#, type#, flags, related, bo, purgeobj, con#    from RecycleBin$ where owner#=:1

END OF STMT

PARSE #4:c=0,e=168,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382433198

EXEC #4:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382442320

FETCH #4:c=0,e=87,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=267382444296

STAT #4 id=1 cnt=0 pid=0 pos=1 obj=702 op='TABLE ACCESS FULL RECYCLEBIN$ (cr=3 pr=0 pw=0 time=85 us)'

=====================

PARSING IN CURSOR #1 len=234 dep=1 uid=0 oct=3 lid=0 tim=267382448246 hv=1224355993 ad='c4878578'

select u.name, o2.name, o2.obj# from ind$ i, obj$ o1, obj$ o2, user$ u where o1.owner# = :1  and o1.type# = 2 and i.type# = 9 and i.bo# = o1.obj#  and i.obj# = o2.obj# and o2.owner# = u.user# and i.type# = 9 and o1.owner# != o2.owner#

END OF STMT

PARSE #1:c=0,e=123,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382448238

EXEC #1:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382457473

FETCH #1:c=62500,e=374111,p=960,cr=1033,cu=0,mis=0,r=0,dep=1,og=4,tim=267382833495

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  (cr=1033 pr=960 pw=0 time=374124 us)'

STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=1033 pr=960 pw=0 time=374112 us)'

STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS  (cr=1033 pr=960 pw=0 time=374100 us)'

STAT #1 id=4 cnt=0 pid=3 pos=1 obj=18 op='TABLE ACCESS FULL OBJ$ (cr=1033 pr=960 pw=0 time=374089 us)'

STAT #1 id=5 cnt=0 pid=3 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=6 cnt=0 pid=5 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=7 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=8 cnt=0 pid=7 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=9 cnt=0 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=10 cnt=0 pid=9 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)'

=====================

PARSING IN CURSOR #1 len=129 dep=1 uid=0 oct=3 lid=0 tim=267382854901 hv=3859726735 ad='c4653ee8'

select u.name, o.name, o.obj# from obj$ o, user$ u, ind$ i where o.owner#=:1 and o.owner#=u.user# and o.obj#=i.obj# and i.type#=9

END OF STMT

PARSE #1:c=0,e=119,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382854893

EXEC #1:c=0,e=89,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267382864143

FETCH #1:c=78125,e=533882,p=962,cr=2401,cu=0,mis=0,r=0,dep=1,og=4,tim=267383399945

=====================

PARSING IN CURSOR #4 len=46 dep=1 uid=0 oct=47 lid=0 tim=267383405592 hv=2120878900 ad='c4795e08'

begin sys.dbms_cdc_utility.drop_user(:1); end;

END OF STMT

PARSE #4:c=0,e=1342,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383405578

=====================

PARSING IN CURSOR #6 len=63 dep=2 uid=0 oct=3 lid=0 tim=267383417653 hv=751738010 ad='c43c4618'

SELECT NAME FROM SYS.OBJ$ WHERE NAME='CDC_CREATE_CTABLE_BEFORE'

END OF STMT

PARSE #6:c=0,e=81,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383417645

EXEC #6:c=0,e=108,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383419996

FETCH #6:c=0,e=900,p=0,cr=55,cu=0,mis=0,r=1,dep=2,og=1,tim=267383420987

=====================

PARSING IN CURSOR #7 len=85 dep=2 uid=0 oct=3 lid=0 tim=267383421258 hv=2351691721 ad='c43c4348'

SELECT CHANGE_TABLE_NAME FROM SYS.CDC_CHANGE_TABLES$ WHERE CHANGE_TABLE_SCHEMA = :B1 

END OF STMT

PARSE #7:c=0,e=130,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421254

EXEC #7:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421384

FETCH #7:c=0,e=57,p=0,cr=3,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421488

=====================

PARSING IN CURSOR #8 len=61 dep=2 uid=0 oct=3 lid=0 tim=267383421628 hv=3690938140 ad='c4382b48'

SELECT HANDLE FROM SYS.CDC_SUBSCRIBERS$ WHERE USERNAME = :B1 

END OF STMT

PARSE #8:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421576

EXEC #8:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421721

FETCH #8:c=0,e=32,p=0,cr=3,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421792

=====================

PARSING IN CURSOR #9 len=64 dep=2 uid=0 oct=3 lid=0 tim=267383421889 hv=4239647650 ad='c4382878'

SELECT SET_NAME FROM SYS.CDC_CHANGE_SETS$ WHERE PUBLISHER = :B1 

END OF STMT

PARSE #9:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421885

EXEC #9:c=0,e=24,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383421972

FETCH #9:c=0,e=39,p=0,cr=3,cu=0,mis=0,r=0,dep=2,og=1,tim=267383422044

=====================

PARSING IN CURSOR #10 len=225 dep=2 uid=0 oct=3 lid=0 tim=267383422129 hv=2932064780 ad='c48e9cb0'

SELECT SOURCE_NAME FROM SYS.CDC_CHANGE_SOURCES$ WHERE PUBLISHER = :B1 AND BITAND(SOURCE_TYPE, 324) != 324 UNION ALL SELECT SOURCE_NAME FROM SYS.CDC_CHANGE_SOURCES$ WHERE LOGFILE_SUFFIX = :B1 AND BITAND(SOURCE_TYPE, 324) = 324

END OF STMT

PARSE #10:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383422125

EXEC #10:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=267383422226

FETCH #10:c=0,e=72,p=0,cr=6,cu=0,mis=0,r=0,dep=2,og=1,tim=267383422332

EXEC #4:c=0,e=5113,p=0,cr=70,cu=0,mis=0,r=1,dep=1,og=4,tim=267383422384

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=2401 pr=962 pw=0 time=533898 us)'

STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=2401 pr=962 pw=0 time=533873 us)'

STAT #1 id=3 cnt=1366 pid=2 pos=1 obj=18 op='TABLE ACCESS FULL OBJ$ (cr=1033 pr=962 pw=0 time=387404 us)'

STAT #1 id=4 cnt=0 pid=2 pos=2 obj=19 op='TABLE ACCESS BY INDEX ROWID IND$ (cr=1368 pr=0 pw=0 time=28592 us)'

STAT #1 id=5 cnt=0 pid=4 pos=1 obj=39 op='INDEX UNIQUE SCAN I_IND1 (cr=1368 pr=0 pw=0 time=13118 us)'

STAT #1 id=6 cnt=0 pid=1 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=7 cnt=0 pid=6 pos=1 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us)'

STAT #1 id=8 cnt=0 pid=7 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)'

=====================

PARSING IN CURSOR #1 len=54 dep=1 uid=0 oct=3 lid=0 tim=267383422716 hv=2890690606 ad='c41ade10'

select name from obj$ where owner# = :1 and type# = 82

END OF STMT

PARSE #1:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383422712

EXEC #1:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383422852

FETCH #1:c=46875,e=386058,p=956,cr=1033,cu=0,mis=0,r=0,dep=1,og=4,tim=267383808942

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS FULL OBJ$ (cr=1033 pr=956 pw=0 time=386060 us)'

=====================

PARSING IN CURSOR #1 len=124 dep=1 uid=0 oct=3 lid=0 tim=267383809317 hv=2995259865 ad='c482d1c0'

select vname from sys.snap$ where sowner = :1 and instsite = 0  and (bitand(flag, 268435456) = 0 or bitand(objflag, 32) = 0)

END OF STMT

PARSE #1:c=0,e=105,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383809313

EXEC #1:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383809462

FETCH #1:c=0,e=52,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=267383809542

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=212 op='TABLE ACCESS FULL SNAP$ (cr=3 pr=0 pw=0 time=51 us)'

=====================

PARSING IN CURSOR #1 len=54 dep=1 uid=0 oct=3 lid=0 tim=267383809767 hv=4209876465 ad='c4836520'

select name from sys.transformations$ where owner = :1

END OF STMT

PARSE #1:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383809763

EXEC #1:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383809869

FETCH #1:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=267383809931

=====================

PARSING IN CURSOR #4 len=65 dep=1 uid=0 oct=3 lid=0 tim=267383810059 hv=2506485734 ad='c43d97f0'

select queue_name from "_DBA_STREAMS_QUEUES" where queue_owner=:1

END OF STMT

PARSE #4:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383810055

EXEC #4:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=267383810190

FETCH #4:c=0,e=165,p=0,cr=10,cu=0,mis=0,r=0,dep=1,og=4,tim=267383810383

STAT #4 id=1 cnt=0 pid=0 pos=1 obj=8322 op='VIEW  _DBA_STREAMS_QUEUES (cr=10 pr=0 pw=0 time=203 us)'

STAT #4 id=2 cnt=0 pid=1 pos=1 obj=0 op='SORT UNIQUE (cr=10 pr=0 pw=0 time=192 us)'

STAT #4 id=3 cnt=0 pid=2 pos=1 obj=0 op='UNION-ALL  (cr=10 pr=0 pw=0 time=149 us)'

STAT #4 id=4 cnt=0 pid=3 pos=1 obj=606 op='TABLE ACCESS FULL STREAMS$_CAPTURE_PROCESS (cr=3 pr=0 pw=0 time=30 us)'

STAT #4 id=5 cnt=0 pid=3 pos=2 obj=616 op='INDEX RANGE SCAN STREAMS$_PROP_P_I2 (cr=1 pr=0 pw=0 time=25 us)'

STAT #4 id=6 cnt=0 pid=3 pos=3 obj=610 op='TABLE ACCESS FULL STREAMS$_APPLY_PROCESS (cr=3 pr=0 pw=0 time=14 us)'

STAT #4 id=7 cnt=0 pid=3 pos=4 obj=679 op='TABLE ACCESS FULL STREAMS$_MESSAGE_CONSUMERS (cr=3 pr=0 pw=0 time=18 us)'

=====================

PARSING IN CURSOR #11 len=77 dep=1 uid=0 oct=7 lid=0 tim=267383810851 hv=1318146514 ad='c44bd718'

delete from system.aq$_internet_agent_privs WHERE db_username = NLS_UPPER(:1)

END OF STMT

PARSE #11:c=0,e=280,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=267383810846

=====================

PARSE ERROR #11:len=77 dep=1 uid=0 oct=7 lid=0 tim=267383810994 err=942

delete from system.aq$_internet_agent_privs WHERE db_username = NLS_UPPER(:1

EXEC #2:c=375000,e=1534032,p=2878,cr=4559,cu=0,mis=0,r=0,dep=0,og=1,tim=267383811113

ERROR #2:err=604 tim=26737662

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=4434 op='TABLE ACCESS FULL TRANSFORMATIONS$ (cr=3 pr=0 pw=0 time=38 us)'

XCTEND rlbk=0, rd_only=1

STAT #3 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS  (cr=0 pr=0 pw=0 time=99 us)'

STAT #3 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=0 pr=0 pw=0 time=75 us)'

STAT #3 id=3 cnt=0 pid=2 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=52 us)'

STAT #3 id=4 cnt=0 pid=3 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=23 us)'

STAT #3 id=5 cnt=0 pid=2 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=0 pr=0 pw=0 time=0 us)'

STAT #3 id=6 cnt=0 pid=5 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=0 pr=0 pw=0 time=0 us)'

STAT #3 id=7 cnt=0 pid=1 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=0 pr=0 pw=0 time=0 us)'

STAT #3 id=8 cnt=0 pid=7 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=0 pr=0 pw=0 time=0 us)'

 

Thanks.
-Ricky

[Paul Campbell]

I believe your user is tied to existing stream... I will try to look at this tonight after I get in from work.