How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
AUDIT → Purpose Use the AUDIT statement to: Track the issuance of SQL statements in subsequent user … To audit issuances of a SQL statement, you must have the AUDIT SYSTEM system privilege. However … , the AUDIT SYSTEM system privilege is not required when you use the IN SESSION CURRENT clause. To … whether auditing is
Table 13-1 SQL Statement Shortcuts for Auditing → SESSION Logons SYNONYM CREATE SYNONYM DROP SYNONYM SYSTEM AUDIT AUDIT sql_statements NOAUDIT … ALTER TYPE DROP TYPE DROP TYPE BODY USER CREATE USER ALTER USER DROP USER Notes: AUDIT USER audits … these three SQL statements. Use AUDIT ALTER USER to audit statements that require the ALTER USER system
Table 13-2 Additional SQL Statement Shortcuts for Auditing → SQL Statement Shortcut SQL Statements and Operations Audited ALTER SEQUENCE ALTER SEQUENCE ALTER TABLE ALTER TABLE COMMENT TABLE COMMENT ON TABLE table, view, materialized view COMMENT ON COLUMN table. column, view. column, materialized view. column DELETE TABLE DELETE FROM table, view EXECUTE PROCEDURE CALL Execution of any procedure or function or access to any variable, library, or cursor inside
Table 13-3 Schema Object Auditing Options → Object SQL Operations Table ALTER AUDIT COMMENT DELETE FLASHBACK (Note 3) GRANT INDEX INSERT LOCK … RENAME SELECT UPDATE View AUDIT COMMENT DELETE FLASHBACK (Note 3) GRANT INSERT LOCK RENAME SELECT … UPDATE Sequence ALTER AUDIT GRANT SELECT Procedure, Function, Package (Note 1) AUDIT EXECUTE GRANT … Materialized
5.2.9 Running RACcheck Configuration Audit Tool → 5.2.9 R unning RACcheck Configuration Audit Tool Oracle recommends that you run the Oracle Real … Application Clusters (Oracle RAC) Configuration Audit Tool (RACcheck) to check your Oracle Database
4.9.1 Audit Data Management → Simplify the management of audit data created by the Oracle Database to facilitate compliance with
Purging Audit Trail Records → This section contains: About Purging Audit Trail Records Selecting an Audit Trail Purge Method … Scheduling an Automatic Purge Job for the Audit Trail Manually Purging the Audit Trail Purging a Subset … of Records from the Database Audit Trail Other Audit Trail Purge Operations Example:
Managing Audit Trail Records → This section contains: About Audit Records Managing the Database Audit Trail Managing the Operating System Audit Trail
Audit Trail Cleanup Subprograms → Audit trail cleanup subprograms help you perform cleanup related operations on the audit trail … records. Table 27-6 Audit Trail Cleanup Subprograms Subprogram Description CLEAN_AUDIT_TRAIL Procedure … Deletes audit trail records/files that have been archived CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure … a purge job
Recommended Audit Settings → Database schema or structure changes. Use the following AUDIT statement settings: AUDIT ALTER ANY … PROCEDURE BY ACCESS; AUDIT ALTER ANY TABLE BY ACCESS; AUDIT ALTER DATABASE BY ACCESS; AUDIT ALTER … SYSTEM BY ACCESS; AUDIT CREATE ANY EDITION; AUDIT CREATE ANY JOB BY
About Audit Records → Audit records include information about the operation that was audited, the user who performed the … choose, you can write audit records to data dictionary tables, called the database audit trail, or in … operating system files, called the operating system audit trail. If you choose to write audit records
Audit Trail Management Subprograms → Audit trail management subprograms enable you to manage audit trail properties. Table 27-5 Audit … value for the audit trail property that you specify SET_AUDIT_TRAIL_LOCATION Procedure Moves the audit … Procedure Sets an audit trail property for the audit trail type
1.3.6 Oracle Database Vault Default Audit Policy and Initialization Parameters → Administrator's Guide for more information about the database audit policy
Creating an Audit Trail for Fine-Grained Audit Records → You designate the audit trail format for fine-grained auditing by setting the audit_trail parameter … parameter) when you create the audit policy. Setting this parameter to XML or XML+EXTENDED writes the … records to the operating system files in XML format. If you prefer to write the fine-grained audit records … to DB or DB+EXTENDED.
Manually Purging the Audit Trail → You can manually purge the audit trail right away, without scheduling a purge job. Similar to a … purge job, you can purge audit trail records that were created before an archive timestamp date or all … the records in the audit trail. Note the following about the DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL PL … /SQL procedure: Only the
Change to AUDIT BY SESSION → The BY SESSION clause of the AUDIT statement now writes one audit record for every audited event … . In previous releases, BY SESSION wrote one audit record for all SQL statements or operations of the … SESSION and BY ACCESS write one audit record for each audit operation. In addition, there are separate
Other Audit Trail Purge Operations → This section contains: Verifying That the Audit Trail Is Initialized for Cleanup Setting the … Default Audit Trail Purge Interval for Any Audit Trail Type Cancelling the Initialization Cleanup Settings … Enabling or Disabling an Audit Trail Purge Job Setting the Default Audit Trail Purge Job Interval
Managing the Database Audit Trail → This section contains: Database Audit Trail Contents Controlling the Size of the Database Audit … Trail Moving the Database Audit Trail to a Different Tablespace Protecting the Database Audit Trail … Auditing the Database Audit Trail Archiving the Database Audit Trail See Also: \"Purging
About Purging Audit Trail Records → You should periodically archive and then delete (purge) audit trail records, because the audit … can use to purge both the database and operating system audit trail records. You can purge a subset … of database audit trail records. For both database and operating system audit trail types, you can
Deleting the Audit Trail Views → If you disable auditing and no longer need the audit trail views, then delete them by connecting to … application users who are recognized in the database using the CLIENT_IDENTIFIER attribute. To audit this type … of user, you can use a fine-grained audit policy. See \"Auditing Specific Activities with Fine