Microsoft Windows (1.7 GB) Linux x86 (1.7 GB) Linux x86-64 (1.8 GB)

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

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

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

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