You can determine users idle time using the following query:

List of DBA Views SELECT * FROM DICT WHERE TABLE_NAME LIKE 'DBA\_%' ESCAPE '\' List of Dynamic Performance Views (these are only synonyms for SYS.GV_$) SELECT * FROM DICT WHERE TABLE_NAME LIKE 'V$%' List of Global Dynamic Performance Views used in RAC (these are only synonyms for SYS.GV_$) SELECT * FROM DICT WHERE TABLE_NAME LIKE [...]

It is possible to speed up creation/rebuild process of a large index using keywords PARALLEL, and NOLOGGING: ALTER SESSION ENABLE PARALLEL DDL; CREATE INDEX INDEX_OWNER.INDEX_NAME ON TABLE_NAME ( col1 , col2, ..) NOLOGGING PARALLEL TABLESPACE TABLESPACE_NAME / — or ALTER INDEX INDEX_OWNER.INDEX_NAME REBUILD NOLOGGING PARALLEL / Don’t forget to set back LOGGING and NOPARALLEL options, [...]

You can use the following techniques to speed up search in the code: Packages, functions, and procedures: SELECT –+ORDERED PARALLEL(A) B.OBJECT_NAME, A.LINE, A.SOURCE FROM SYS.SOURCE$ A, DBA_OBJECTS B WHERE UPPER (A.SOURCE) LIKE '%SEARCH STRING%' AND B.OWNER = 'OBJ_OWNER' AND A.OBJ# = B.OBJECT_ID / Views: — create tmp table CREATE TABLE VIEW_CONVERT ( OWNER VARCHAR2(255), VIEW_NAME [...]