Jump to Navigation


Oracle Configuration.


You can check AUDIT_TRAIL parameter as the following. If it is "OS", audit information is stored in the AUDIT_FILE_DEST.

SQL> show parameters AUDIT_TRAIL

SQL> show parameters AUDIT_FILE_DEST


300 - Move Audit Trail Tables

1. Tablespace Check

SQL> SELECT table_name, tablespace_name FROM   dba_tables WHERE  table_name IN ('AUD$', 'FGA_LOG$') ORDER BY table_name;


2. Create a new table space for Audit Trail

299 - Oracle Audit Management

From 11g, Oracle by default enable auditing with 'DB' option. 
That means audit information will be stored in database table.
This information is useful, but apart from lot of benefits, the auditing raises performance issues and
disk space problem.

 * Too much activity especially unnecessary information will being audited.
 * AUD$ table still placed in the SYSTEM tablespace since the database creation.
 * SYSTEM tablespace is growing forever and occupied the disk space.

287 - Oracle Advanced Compression

Advanced Compression provides storage reduction through compression of all data types. It also provides performance improvements in several cases
as compressed blocks result in more data being moved per I/O. It further improves memory efficiency as Oracle Database keeps data compressed in memory.
All these benefits cascade through all the environments such as staging, QA, development, standby, backup, etc., magnifying the benefits several times.

286 - How to know Oracle Version and Patches

Version information is stored in a table called v$version. In this table you can find version information on Oracle, PL/SQL, etc.
To retrieve the version information for Oracle, you execute the following
SQL statement:

SQL> select * from v$version;

285 - Resizing Temporary Tablespace

If you try to drop the temp tablespace, you get the error message as the following.

drop tablespace temp
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace


1. Create a second temp acheter viagra tablespace.

284 - How to fix ORA-01652

You encounter ORA-01652 while rinning a long SQL.

ORA-01652: unable to extend temp segment by string in tablespace string.

Cause: Failed to allocate an extent of the required number of blocks for a temporary
segment in the tablespace indicated.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

1. Add a new file to the tablespace.

274 - libXp.so.6

When you are installing openmotif21-2.1.30-11 into the linux server for Oracle EBS  & Database, you encounter the following
error. You need to install another package before openmotif.

1. install openmotif21-2.1.30-11.EL5.i386.rpm

# rpm -ihv openmotif21-2.1.30-11.EL5.i386.rpm

error: Failed dependencies:
libXp.so.6 is needed by openmotif21-2.1.30-11.EL5.i386

272 - Oracle APPS Temporary File

$APPLTMP is a directory configured in Oracle APPS for a temporary file.

This URL looks like :

URL   http://loadbalancer.company.com:80/OA_CGI/FNDWRR.exe?temp_id=nnnnnnnnnn

Piecewise the URL is like this :

1. http://loadbalancer.us.oracle.com:80

241 - Auto Memory Management (AMM)


MEMORY_TARGET specifies the Oracle system-wide usable memory. The database tunes memory to the MEMORY_TARGET value,
reducing or enlarging the SGA and PGA as needed.


MEMORY_MAX_TARGET specifies the maximum value to which a DBA can set the MEMORY_TARGET initialization parameter.
See the description of MEMORY_TARGET for more information about how the settings of MEMORY_MAX_TARGET and
MEMORY_TARGET affect each other.



Subscribe to RSS - configuration

Main menu 2

by Dr. Radut