18 Apr 2003 evilrobots   » (Observer)

  • misc dba sqlplus commands
    sql> select sid, serial# from v$session
        where audsid = sys_context('userenv','sessionid')
    
    

    sql> select namespace, gets, getshits, pins, reloads, invalidations from sys.v_$librarycache where gets >0 order by 2 desc;

  • Latest blog entries     Older blog entries

    X
    Share this page