admin - Tue, 11/25/2014 - 11:59
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
|
admin - Tue, 11/25/2014 - 11:46
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
admin - Tue, 11/25/2014 - 11:39
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.
admin - Wed, 02/27/2013 - 10:46
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.
admin - Wed, 02/27/2013 - 10:42
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; |
admin - Tue, 02/26/2013 - 11:45
If you try to drop the temp tablespace, you get the error message as the following.
SQL> DROP TABLESPACE temp; drop tablespace temp * ERROR at line 1: ORA-12906: cannot drop default temporary tablespace |
1. Create a second temp acheter viagra tablespace.
admin - Tue, 02/26/2013 - 11:17
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.
admin - Fri, 01/18/2013 - 11:04
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 |
admin - Fri, 12/21/2012 - 14:01
admin - Mon, 07/23/2012 - 14:30
1. MEMORY_TARGET
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.
2. MEMORY_MAX_TARGET
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.
3. MEMORY_TARGET and MEMORY_MAX_TARGET
Pages