I’ve recently came across excelent article/how-to for Oracle 11g RAC na Oracle Enterprise Linux 4(Update 5) a VMware Server 1.0.3. Thank you Frikkie.

Too much log switching is no good for database, you should see numbers not bigger than 6 per hour. Increasing the size of redo log groups is one way to lower log switch frequency, please refer to Oracle documentation on how to lower log switch frequency.
You can use the following query to determine your log [...]

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=..

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