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

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

Hard parses in a OLTP system(many small transactions) are expensive in both terms of CPU used and number of shared pool latches. Binding reuses cached sql statements, while hard parsing SQL statement always loads a new version of SQL to the shared pool. Bacause each new SQL consumes memory, some already cached statements may need [...]

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 [...]