About Gary Parker

This author has not yet filled in any details.
So far Gary Parker has created 6 blog entries.

Move Oracle DB Audit Trails To A New Tablespace

There are times when it is necessary to move Oracle DB audit trails to a new table space.  Auditing is the monitoring and recording of selected user database actions. In standard auditing, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, and schema objects, and network and [...]

By |2018-01-18T20:34:36+00:00January 18th, 2018|Database|Comments Off on Move Oracle DB Audit Trails To A New Tablespace

Move Oracle Database Audit Trails To A New Tablespace Continued

  Create a new tablespace and size it large enough to hold the audit data:   SQL> CREATE tablespace "SYSAUD" datafile size 1G autoextend on;   Tablespace created.     Move the audit trail tables using procedure DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION.   -- -- Move the SYS.AUD$ table -- SQL> exec DBMS_AUDIT_MGMT.set_audit_trail_location( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, audit_trail_location_value => [...]

By |2018-05-18T16:40:56+00:00November 9th, 2017|Database|Comments Off on Move Oracle Database Audit Trails To A New Tablespace Continued

Move Oracle Database Audit Trails To A New Tablespace

Move Oracle Database Audit Trails To A New Tablespace Auditing is the monitoring and recording of selected user database actions. For Oracle Database, the Oracle Database Audit Trails assist in the auditing process.  In standard auditing, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, and schema [...]

By |2018-05-18T16:41:04+00:00November 9th, 2017|Database|Comments Off on Move Oracle Database Audit Trails To A New Tablespace

How to Multiplex the Oracle Controlfile in ASM

You may face a situation where you have to multiplex the controlfile across multiple diskgroups, especially after the database is created. However with ASM, this activity is not as simple as it is with filesystems where you can copy files from one folder/directory to another and then edit the init.ora parameter file to add [...]

By |2017-09-20T08:45:42+00:00September 11th, 2013|Tips|Comments Off on How to Multiplex the Oracle Controlfile in ASM

Linux Huge Pages for Oracle

When Linux servers that host Oracle database environments are configured with 16GB or more of memory and the total SGA of the Oracle databases is 5GB or more, it is strongly recommended to configure Linux HugePages at the OS level. With HugePages, the Linux memory page size is set at 2MB (instead of the [...]

By |2017-09-20T08:46:00+00:00September 11th, 2013|Tips|Comments Off on Linux Huge Pages for Oracle

AWR Data: How-to Extract & Load

Oracle Automatic Workload Repository (AWR) maintains performance statistics for detecting problems in the Database by collecting and processing data needed for self-tuning. The data gathered resides both in memory as well as in the database. You can utilize both reports and views to access this data. Oracle allows you to transport the data AWR [...]

By |2017-09-20T08:46:11+00:00September 11th, 2013|Tips|Comments Off on AWR Data: How-to Extract & Load