You can determine users idle time using the following query:

Our Linux OAS should be started using the same NLS_LANG as client is using, in our case NLS_LANG=SLOVAK_SLOVAKIA.EE8MSWIN1250

export NLS_LANG=SLOVAK_SLOVAKIA.EE8MSWIN1250

cd $ORACLE_HOME/opmn/bin

# restart OAS
./opmnctl stopall
opmnctl: stopping opmn and all managed processes…

./opmnctl startall
opmnctl: starting opmn and all managed processes…

Assuming that there are eastern european characters used in your FMB files in labels, etc..
You need to recompile all the [...]

exp [SINGLE_QUOTE][DOUBLE_QUOTE] sys/pass@TNS as sysdba [DOUBLE_QUOTE][SINGLE_QUOTE] ..

exp '"sys/pass@TNS as sysdba"' FILE=..

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 'GV$%'

Note: The content of V$ and GV$ views [...]

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, because create/rebuild will set these options.

ALTER INDEX INDEX_OWNER.INDEX_NAME LOGGING NOPARALLEL;

Estimate statistics:

BEGIN
DBMS_STATS.GATHER_INDEX_STATS(
OWNNAME [...]

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 VARCHAR2(255),
VIEW_TEXT CLOB
)
NOLOGGING PARALLEL PCTFREE 0
/

– fill table and convert long column
INSERT –+APPEND
INTO VIEW_CONVERT NOLOGGING
SELECT –+PARALLEL(AA)
OWNER
, VIEW_NAME
, TO_LOB(TEXT)
FROM [...]