Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
 

ARCHIVE LOG Clauses


Oracle Tips by Burleson
 

A Detailed Look at ARCHIVE LOG Clauses

For Oracle8 much of  the ARCHIVE LOG command is removed from SVRMGR  (except for the pull-down display) and is placed under the ALTER SYSTEM command (shown above). The new command has additional clauses to handle the more complex archive log scheme under Oracle8, Oracle8i and Oracle. The new syntax handles the threads and groups associated with the new archive logs. The new syntax follows:

ALTER SYSTEM ARCHIVE LOG clause;

ARCHIVE LOG clauses:

       THREAD n

        [SEQUENCE n] [TO 'location']

        [CHANGE n] [TO 'location']

        [CURRENT] [TO 'location']

        [GROUP n] [TO 'location']

        [LOGFILE 'filename'] [TO 'location']

        [NEXT] [TO 'location']

        [ALL] [TO 'location']

        [START] [TO 'location']

        [STOP]

where:

THREAD.  This specifies the particular redo log thread to affect. If this isn’t specified then the current instance redo log thread is affected.

SEQUENCE.  This archives the redo log group that corresponds to the integer specified by the integer given as the argument.

CHANGE.  This corresponds to the SCN (system change number) for the transaction you want to archive. It will force archival of the log containing the transaction with the SCN that matches the integer given as the argument to the CHANGE argument.

GROUP.  This manually archives the redo logs in the specified group. If both THREAD and GROUP are specified, the group must belong to the specified thread.

CURRENT.  This causes all nonarchived redo log members of the current group to be archived.

LOGFILE.  This manually archives the group that contains the file specified by ‘filespec’. If thread is specified the file must be in a group contained in the thread specified.

NEXT.  This forces manual archival of the next on-line redo log that requires it. If no thread is specified, Oracle archives the earliest available unarchived redo log.

ALL.  This archives all on-line archive logs that are part of the current thread that haven’t been archived. If no thread is specified then all unarchived logs from all threads are archived.

START.  Starts automatic archiving of redo log file groups. This only applies to the thread assigned to the current instance.

TO.  This specifies the location to archive the logs to. This must be a full path specification.

STOP.  This disables automatic archiving of redo file log groups. This applies to your current instance.

The ARCHIVE LOG command can still be used under SVRMGR in Oracle versions that support it to LIST the current status of the archive log system.

The Init<sid>.Ora (Initialization File) Parameters

It should be obvious that the most important file regarding database setup and operation is probably the INIT<sid>.ORA, or initialization file. This file contains the assignments for the database initialization parameters.

For Oracle7, version 7.3, there are 154 initialization parameters; for Oracle8, version 8.0.5, there are 184. In Oracle8i, there are 194. In Oracle, version 9.0.1 there are 251. Table 2.1 lists the Oracle INIT.ORA parameters, their default values, and descriptions. Note that on your platform there may be more or less than this number of parameters.

Table 2.1 Oracle Initialization Parameters

NAME

VALUE

DESCRIPTION

ACTIVE_INSTANCE_COUNT

Null

Number of active instances in the cluster database.

AQ_TM_PROCESSES

0

Number of AQ Time Managers to start.

ARCHIVE_LAG_TARGET

0

Maximum number of seconds of redos the standby could lose. 

AUDIT_FILE_DEST

?/rdbms/audit

Directory in which Auditing files are to reside.

AUDIT_TRAIL

NONE

Enable system auditing.

BACKGROUND_CORE_DUMP

partial

Core size for background processes.

BACKGROUND_DUMP_DEST

SD

Detached process dump directory.

BACKUP_TAPE_IO_SLAVES

FALSE

BACKUP Tape I/O slaves.

BITMAP_MERGE_AREA_SIZE

1048576

Maximum memory allow for BITMAP MERGE.

BLANK_TRIMMING

FALSE

Blank trimming semantics parameter.

BUFFER_POOL_KEEP

NULL

Number of database blocks/latches in keep buffer pool.

BUFFER_POOL_RECYCLE

NULL

Number of database blocks/latches in recycle buffer pool.

CIRCUITS

170

Max number of circuits.

CLUSTER_DATABASE

FALSE

If TRUE, start up in cluster database mode.

CLUSTER_DATABASE_INSTANCES

1

Number of instances to use for sizing cluster db SGA structures.

CLUSTER_INTERCONNECTS

NULL

Interconnects for RAC use.

COMMIT_POINT_STRENGTH

1

Bias this node has toward not preparing in a two-phase commit.

COMPATIBLE

9.0.0

Database will be completely compatible with this software version number .

CONTROL_FILES

SD

Control filenames list.

CONTROL_FILE_RECORD_KEEP_TIME

7

Control file record; keep time in days.

CORE_DUMP_DEST

SD

Core dump directory.

CPU_COUNT

SD

Initial number of CPUs for this instance.

CREATE_BITMAP_AREA_SIZE

8388608

Size of create bitmap buffer for bitmap index.

CURSOR_SHARING

EXACT

Cursor sharing mode.

CURSOR_SPACE_FOR_TIME

FALSE

Use more memory in order to get faster execution.

DBLINK_ENCRYPT_LOGIN

FALSE

Enforce password for distributed login always be encrypted.

DBWR_IO_SLAVES

0

Number of DBWR I/O slaves.

DB_16K_CACHE_SIZE

0

Size of cache for 16K buffers.

DB_2K_CACHE_SIZE

0

Size of cache for 2K buffers.

DB_32K_CACHE_SIZE

0

Size of cache for 32K buffers.

DB_4K_CACHE_SIZE

0

Size of cache for 4K buffers.

DB_8K_CACHE_SIZE

0

Size of cache for 8K buffers.

DB_BLOCK_BUFFERS

0

Number of database blocks cached in memory.

DB_BLOCK_CHECKING

FALSE

Data and index block checking.

DB_BLOCK_CHECKSUM

TRUE

Store checksum in db blocks and check during reads.

DB_BLOCK_SIZE

8192

Size of database block in bytes.

DB_CACHE_ADVICE

OFF

Buffer cache sizing advisory.

DB_CACHE_SIZE

67108864

Size of DEFAULT buffer pool for standard blocksize buffers.

DB_CREATE_FILE_DEST

NULL

Default database location.

DB_CREATE_ONLINE_LOG_DEST_1

NULL

Online log/controlfile Destination #1.     

DB_CREATE_ONLINE_LOG_DEST_2

NULL

Online log/controlfile Destination #2.

DB_CREATE_ONLINE_LOG_DEST_3

NULL

Online log/controlfile Destination #3.

DB_CREATE_ONLINE_LOG_DEST_4

NULL

Online log/controlfile Destination #4.

DB_CREATE_ONLINE_LOG_DEST_5

NULL

Online log/controlfile Destination #5.

DB_DOMAIN

SD

Directory part of global database name stored with CREATE DATABASE.

DB_FILES

200

Max allowable # db files (soft limit).

DB_FILE_MULTIBLOCK_READ_COUNT

8

DB block to be read each I/O.

DB_FILE_NAME_CONVERT

NULL

Datafile name convert patterns and strings for standby/clone db.

DB_KEEP_CACHE_SIZE

0

Size of KEEP buffer pool for standard blocksize buffers.

DB_NAME

SD

Database name specified in CREATE DATABASE.

DB_RECYCLE_CACHE_SIZE

0

Size of RECYCLE buffer pool for standard block size buffers.

DB_WRITER_PROCESSES

1

Number of background database writer processes to start.

DISK_ASYNCH_IO

TRUE

Use asynch I/O for random-access devices.

DISPATCHERS

(PROTOCOL=TCP) (SER=MODOSE), (PROTOCOL=TCP) (PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)

Specifications of dispatchers.

DISTRIBUTED_TRANSACTIONS

46

Max. number of concurrent distributed transactions.

DML_LOCKS

748

DML locks: one for each table modified in a transaction.

DRS_START

FALSE

Start DR Server framework (DMON process).

ENQUEUE_RESOURCES

968

Resources for enqueues.

EVENT

NULL

Debug event control; default null string.

FAL_CLIENT

NULL

FAL client.

FAL_SERVER

NULL

FAL server list.

FAST_START_IO_TARGET

0

Upper bound on recovery reads

FAST_START_MTTR_TARGET

300

MTTR target of forward crash recovery in seconds

FAST_START_PARALLEL_ROLLBACK

LOW

Max number of parallel recovery slaves that may be used.

FIXED_DATE

NULL

Fixed SYSDATE value.

GC_FILES_TO_LOCKS

NULL

Mapping between file numbers and global cache locks (DFS).

GLOBAL_CONTEXT_POOL_SIZE

NULL

Global Application Context pool size in bytes.

GLOBAL_NAMES

FALSE

Enforce that database links have same name as remote database.

HASH_AREA_SIZE

1048576

Size of in-memory hash work area.

HASH_JOIN_ENABLED

TRUE

Enable/disable hash join.

HI_SHARED_MEMORY_ADDRESS

0

SGA starting address (high-order 32 bits on 64-bit platforms).

HS_AUTOREGISTER

TRUE

Enable automatic server DD updates in HS agent self-registration.

IFILE

NULL

Include file in init.ora.

INSTANCE_GROUPS

NULL

List of instance group names.

INSTANCE_NAME

SD

Instance name supported by the instance.

INSTANCE_NUMBER

0

Instance number.

JAVA_MAX_SESSIONSPACE_SIZE

0

Max allowed size in bytes of a Java sessionspace.

JAVA_POOL_SIZE

117440512

Size in bytes of the Java pool.

JAVA_SOFT_SESSIONSPACE_LIMIT

0

Warning limit on size in bytes of a Java sessionspace.

JOB_QUEUE_PROCESSES

0

Number of job queue slave processes.

LARGE_POOL_SIZE

1048576

Size in bytes of the large allocation pool.

LICENSE_MAX_SESSIONS

0

Maximum number of nonsystem user sessions allowed.

LICENSE_MAX_USERS

0

Maximum number of named users that can be created in the database.

LICENSE_SESSIONS_WARNING

0

Warning level for number of nonsystem user sessions.

LOCAL_LISTENER

NULL

Local listener.

LOCK_NAME_SPACE

NULL

Lock name space used for generating lock names for standby/clone.

LOCK_SGA

FALSE

Lock entire SGA in physical memory.

LOGMNR_MAX_PERSISTENT_SESSIONS

1

Maximum number of threads to mine.

LOG_ARCHIVE_DEST

NULL

Archival destination text string.

LOG_ARCHIVE_DEST_1

NULL

Archival destination #1 text string.

LOG_ARCHIVE_DEST_10

NULL

Archival destination #10 text string.

LOG_ARCHIVE_DEST_2

NULL

Archival destination #2 text string.

LOG_ARCHIVE_DEST_3

NULL

Archival destination #3 text string.

LOG_ARCHIVE_DEST_4

NULL

Archival destination #4 text string.

LOG_ARCHIVE_DEST_5

NULL

Archival destination #5 text string.

LOG_ARCHIVE_DEST_6

NULL

Archival destination #6 text string.

LOG_ARCHIVE_DEST_7

NULL

Archival destination #7 text string.

LOG_ARCHIVE_DEST_8

NULL

Archival destination #8 text string.

LOG_ARCHIVE_DEST_9

NULL

Archival destination #9 text string.

LOG_ARCHIVE_DEST_STATE_1

enable

Archival destination #1 state text string.

LOG_ARCHIVE_DEST_STATE_10

enable

 Archival destination #10 state text string.

LOG_ARCHIVE_DEST_STATE_2

enable

Archival destination #2 state text string.

LOG_ARCHIVE_DEST_STATE_3

enable

Archival destination #3 state text string.

LOG_ARCHIVE_DEST_STATE_4

enable

Archival destination #4 state text string.

LOG_ARCHIVE_DEST_STATE_5

enable

Archival destination #5 state text string.

LOG_ARCHIVE_DEST_STATE_6

enable

Archival destination #6 state text string.

LOG_ARCHIVE_DEST_STATE_7

enable

Archival destination #7 state text string.

LOG_ARCHIVE_DEST_STATE_8

enable

Archival destination #8 state text string.

LOG_ARCHIVE_DEST_STATE_9

enable

Archival destination #9 state text string.

LOG_ARCHIVE_DUPLEX_DEST

NULL

Duplex archival destination text string.

LOG_ARCHIVE_FORMAT

%t_%s.dbf

Archival destination format.

LOG_ARCHIVE_MAX_PROCESSES

1

Maximum number of active ARCH processes.

LOG_ARCHIVE_MIN_SUCCEED_DEST

1

Minimum number of archive destinations that must succeed.

LOG_ARCHIVE_START

FALSE

Start archival process on SGA initialization.

LOG_ARCHIVE_TRACE

0

Establish archivelog operation tracing level.

LOG_BUFFER

524288

Redo circular buffer size.

LOG_CHECKPOINTS_TO_ALERT

FALSE

Log checkpoint begin/end to alert file.

LOG_CHECKPOINT_INTERVAL

0

Number of  redo blocks checkpoint threshold.

LOG_CHECKPOINT_TIMEOUT

1800

Maximum time interval between checkpoints in seconds.

LOG_FILE_NAME_CONVERT

NULL

Logfile name-convert patterns and strings for standby/clone db.

MAX_COMMIT_PROPAGATION_DELAY

700

Max age of new snapshot in .01 seconds.

MAX_DISPATCHERS

5

Max number of dispatchers.

MAX_DUMP_FILE_SIZE

UNLIMITED

Maximum size (blocks) of dump file.

MAX_ENABLED_ROLES

30

Max number of roles a user can have enabled.

MAX_ROLLBACK_SEGMENTS

37

Max. number of rollback segments in SGA cache.        

MAX_SHARED_SERVERS

20

Max number of shared servers. 

MAX_TRANSACTION_BRANCHES

8

Max. number of branches per distributed transaction.

MTS_CIRCUITS

170

Max number of circuits.

MTS_DISPATCHERS

(PROTOCOL=TCP) (SER=MODOSE), (PROTOCOL=TCP) (PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)

Specifications of dispatchers.

MTS_LISTENER_ADDRESS

NULL

Address(es) of network listener.

MTS_MAX_DISPATCHERS

5

Max number of dispatchers.

MTS_MAX_SERVERS

20

Max number of shared servers.

MTS_MULTIPLE_LISTENERS

FALSE

Are multiple listeners enabled?

MTS_SERVERS

NULL

Number of shared servers to start up at DB start.

MTS_SERVICE

SD

Service name supported by dispatchers.

MTS_SESSIONS

 

165

Max number of shared server sessions.

NLS_CALENDAR

NULL

NLS calendar system name.

NLS_COMP

NULL

NLS comparison.

NLS_CURRENCY

NULL

NLS local currency symbol .

NLS_DATE_FORMAT

NULL

NLS Oracle date format.

NLS_DATE_LANGUAGE

NULL

NLS date language name.

NLS_DUAL_CURRENCY

NULL

Dual currency symbol.

NLS_ISO_CURRENCY

NULL

NLS ISO currency territory name.

NLS_LANGUAGE

AMERICAN

NLS language name.

NLS_LENGTH_SEMANTICS

BYTE

Create columns using byte or char semantics by default.

NLS_NCHAR_CONV_EXCP

FALSE

NLS raise an exception instead of allowing implicit conversion.

NLS_NUMERIC_CHARACTERS

NULL

NLS numeric characters.

NLS_SORT

NULL

NLS linguistic definition name.

NLS_TERRITORY

AMERICA

NLS territory name.

NLS_TIMESTAMP_FORMAT

NULL

Timestamp format.

NLS_TIMESTAMP_TZ_FORMAT

NULL

Timestamp with timezone format.

NLS_TIME_FORMAT

NULL

Time format.
NLS_TIME_TZ_FORMAT

NULL

Time with timezone format.

O7_DICTIONARY_ACCESSIBILITY

FALSE

Version 7 Dictionary Accessibility Support.

OBJECT_CACHE_MAX_SIZE_PERCENT

10

Percentage of maximum size over optimal of the user session's object cache.

OBJECT_CACHE_OPTIMAL_SIZE

102400

Optimal size of the user session's object cache in bytes.

OPEN_CURSORS

300

Max # cursors per session.

OPEN_LINKS

4

Max # open links per session.

OPEN_LINKS_PER_INSTANCE

4

Max # open links per instance.

OPTIMIZER_FEATURES_ENABLE

9.0.1

Optimizer plan compatibility parameter.

OPTIMIZER_INDEX_CACHING

0

Optimizer percent index caching.

OPTIMIZER_INDEX_COST_ADJ

100

Optimizer index cost adjustment.

OPTIMIZER_MAX_PERMUTATIONS

2000

Optimizer maximum join permutations per query block.

OPTIMIZER_MODE

CHOOSE

Optimizer mode.

ORACLE_TRACE_COLLECTION_NAME

NULL

Oracle TRACE default collection name.

ORACLE_TRACE_COLLECTION_PATH

?/otrace/admin/

Oracle TRACE collection path cdf.

ORACLE_TRACE_COLLECTION_SIZE

5242880

Oracle TRACE collection file max. size.

ORACLE_TRACE_ENABLE

FALSE

Oracle TRACE enabled/disabled.

ORACLE_TRACE_FACILITY_NAME

Oracled

Oracle TRACE default facility name.

ORACLE_TRACE_FACILITY_PATH

?/otrace/admin/

Oracle TRACE facility path fdf.

OS_AUTHENT_PREFIX

ops$

Prefix for auto-logon accounts.

OS_ROLES

FALSE

Retrieve roles from the operating system.

PARALLEL_ADAPTIVE_MULTI_USER

FALSE

Enable adaptive setting of degree for multiple user streams.

PARALLEL_AUTOMATIC_TUNING

FALSE

 

Enable intelligent defaults for parallel execution parameters.

PARALLEL_BROADCAST_ENABLED

 

FALSE

 

Enable broadcasting of small inputs to hash and sort merge joins.

PARALLEL_EXECUTION_MESSAGE_SIZE

2148

Message buffer size for parallel execution.

PARALLEL_INSTANCE_GROUP

NULL

Instance group to use for all parallel operations.

PARALLEL_MAX_SERVERS

5

Maximum parallel query servers per instance

PARALLEL_MIN_PERCENT

0

Minimum percent of threads required for parallel query.

PARALLEL_MIN_SERVERS

0

Minimum parallel query servers per instance.

PARALLEL_SERVER

FALSE

If TRUE, start up in parallel server mode

PARALLEL_SERVER_INSTANCES

1

Number of instances to use for sizing OPS SGA structures.

PARALLEL_THREADS_PER_CPU

2

Number of parallel execution threads per CPU.

PARTITION_VIEW_ENABLED

FALSE

Enable/disable partitioned views.

PGA_AGGREGATE_TARGET

0

Target size for the aggregate PGA memory consumed by the instance.

PLSQL_COMPILER_FLAGS

INTERPRETED

PL/SQL compiler flags.

PLSQL_NATIVE_C_COMPILER

NULL

PL/SQL native C compiler.

PLSQL_NATIVE_LIBRARY_DIR

NULL

PL/SQL native library directory.

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT

0

PL/SQL native library number of subdirectories.

PLSQL_NATIVE_LINKER

NULL

PL/SQL native linker.

PLSQL_NATIVE_MAKE_FILE_NAME

NULL

PL/SQL native compilation make file. 

PLSQL_NATIVE_MAKE_UTILITY

NULL

PL/SQL native compilation make utility. 

PLSQL_V2_COMPATIBILITY

FALSE

 

PL/SQL version 2.x compatibility flag.

PRE_PAGE_SGA

FALSE

Prepage SGA for process.

PROCESSES

150

Max user processes.

QUERY_REWRITE_ENABLED

FALSE

Allows rewrite of queries using materialized views or function-based, indexes if enabled.

QUERY_REWRITE_INTEGRITY

Enforced

Perform rewrite using materialized views with desired integrity

RDBMS_SERVER_DN

NULL

RDBMS's Distinguished Name.

READ_ONLY_OPEN_DELAYED

FALSE

If TRUE, delay opening of read-only files until first access.

RECOVERY_PARALLELISM

0

Number of server processes to use for parallel recovery.

REMOTE_ARCHIVE_ENABLE

TRUE

Remote archivelog destinations enabled. 

REMOTE_DEPENDENCIES_MODE

TIMESTAMP

Remote-procedure-call dependencies mode parameter.

REMOTE_LISTENER

NULL

Remote listener identification.

REMOTE_LOGIN_PASSWORDFILE

EXCLUSIVE

Password file usage parameter.

REMOTE_OS_AUTHENT

FALSE

Allow nonsecure remote clients to use autologon accounts.

REMOTE_OS_ROLES

FALSE

 Allow nonsecure remote clients to use OS roles.

REPLICATION_DEPENDENCY_TRACKING

TRUE

 Tracking dependency for replication parallel propagation.

RESOURCE_LIMIT

FALSE

Master switch for resource limit.

RESOURCE_MANAGER_PLAN

SYSTEM_PLAN

Resource mgr top plan.

ROLLBACK_SEGMENTS

NULL

Undo segment list.

ROW_LOCKING

always

Row-locking .                  

SERIALIZABLE

FALSE

Reuse the frame segments. .      

 SERIAL_REUSE

DISABLE

Serializable

SERVICE_NAMES

SD

Service names supported by the instance.

SESSIONS

170

User and system sessions.

SESSION_CACHED_CURSORS

0

Number of cursors to save in the session cursor cache.

SESSION_MAX_OPEN_FILES

10

Maximum number of open files allowed per session.

SGA_MAX_SIZE

336356520

Max total SGA size.

SHADOW_CORE_DUMP

partial

Core size for shadow processes.

SHARED_MEMORY_ADDRESS

0

SGA starting address (low-order 32 bits on 64-bit platforms).

SHARED_POOL_RESERVED_SIZE

5872025

Size in bytes of reserved area of shared pool.

SHARED_POOL_SIZE

117440512

Size in bytes of shared pool.

SHARED_SERVERS

1

Number of shared servers to start up.

SHARED_SERVER_SESSIONS

165

Max number of shared server sessions.

SORT_AREA_RETAINED_SIZE

0

Size of in-memory sort work area retained between fetch calls.

SORT_AREA_SIZE

524288

Size of in-memory sort work area.

SPFILE

`

Server parameter file.

SQL92_SECURITY

FALSE

Require select privilege for searched update/delete.

SQL_TRACE

FALSE

Enable SQL trace.

SQL_VERSION

NATIVE

SQL language version parameter for compatibility issues.

STANDBY_ARCHIVE_DEST

?/dbs/arch

Standby database archivelog destination text string

STANDBY_FILE_MANAGEMENT

MANUAL

If auto, then files are created/dropped automatically on standby.

STANDBY_PRESERVES_NAMES

FALSE

Filenames on standby are the same as on the primary..

STAR_TRANSFORMATION_ENABLED

FALSE

Enable the use of star transformation.

TAPE_ASYNCH_IO

TRUE

Use asynch I/O requests for tape devices.

THREAD

0

Redo thread to mount.

TIMED_OS_STATISTICS

0 Internal OS statistic-gathering interval, in seconds.

TIMED_STATISTICS

TRUE

Maintain internal timing statistics.

TRACEFILE_IDENTIFIER

NULL

Trace file custom identifier.

 TRACE_ENABLED

TRUE

Enable KST tracing.

TRANSACTIONS

187

 

Max. number of concurrent active transactions.

TRANSACTIONS_PER_ROLLBACK_SEGMENT

5

Number of active transactions per rollback segment.

TRANSACTION_AUDITING

TRUE

Transaction auditing records generated in the redo log.

UNDO_MANAGEMENT

AUTO

Instance runs in SMU mode if TRUE, else in RBU mode.

UNDO_RETENTION

900

Undo retention in seconds.    

UNDO_SUPPRESS_ERRORS

FALSE

Suppress RBU errors in SMU mode.

UNDO_TABLESPACE

UNDOTBS

Use/switch undo tablespace.

USER_DUMP_DEST

SD

User process dump directory.

USE_INDIRECT_DATA_BUFFERS

FALSE

Enable indirect data buffers (very large SGA on 32-bit platforms)

UTL_FILE_DIR

NULL

utl_file-accessible directories list.

WORKAREA_SIZE_POLICY

MANUAL

Policy used to size SQL working areas (MANUAL/AUTO)

 


See Code Depot for Full Scripts


This is an excerpt from Mike Ault, bestselling author of "Oracle 10g Grid and Real Application Clusters".

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.
  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter