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
Disabling the Retention Policy → When you disable the retention policy, RMAN does not consider any backup as obsolete. To disable … the retention policy, run this command: CONFIGURE RETENTION POLICY TO NONE; Configuring the retention … policy to NONE is different from clearing it. Clearing it returns it to its default setting of … REDUNDANCY
15.6.2 Purging Policy → A weekly scheduled purging task manages the disk space used by SQL plan management. The task runs as an automated task in the maintenance window. The database purges plans not used for more than 53 weeks, as identified by the LAST_EXECUTED timestamp stored in the SMB for that plan. The 53-week period ensures plan information is available during any yearly SQL processing. The unused plan retention
Configuring the Backup Retention Policy → As explained in \"Backup Retention Policies\", the backup retention policy specifies which backups … must be retained to meet your data recovery requirements. This policy can be based on a recovery … window or redundancy. Use the CONFIGURE RETENTION POLICY command to specify the retention policy. See
The Importance of Establishing a Security Policy for Your Database → It is important to develop a security policy for every database. The security policy establishes … administrator, who is responsible for implementing and maintaining the database security policy If the
Configuring a Recovery Window-Based Retention Policy → window. Run the CONFIGURE RETENTION POLICY command at the RMAN prompt. This example ensures that you … can recover the database to any point within the last week: CONFIGURE RETENTION POLICY TO RECOVERY
Configuring a Redundancy-Based Retention Policy → The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command specifies how many full or level … considers the extra backups as obsolete. The default retention policy is REDUNDANCY 1. As you produce more … backups. Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the following example … : CONFIGURE RETENTION
Enabling an Archived Redo Log Deletion Policy → This section explains how to configure an archived redo log deletion policy. By default the policy … is set to NONE. To enable an archived redo log deletion policy: Start RMAN and connect to a target … database and a recovery catalog (if used). Run the CONFIGURE ARCHIVELOG DELETION POLICY command with … at least
Configuring an Archived Redo Log Deletion Policy → You can use RMAN to create a persistent configuration that governs when archived redo logs are eligible for deletion from disk.
Reporting on Files Needing a Backup Under a Retention Policy → retention policy. With no arguments, REPORT NEED BACKUP reports which objects need backup under the … currently configured retention policy. The output for a configured retention policy of REDUNDANCY 1 … is similar to this example: RMAN> REPORT NEED BACKUP; RMAN retention policy will be applied to the … command
Backup Retention Policy and Fast Recovery Area Deletion Rules → The RMAN status OBSOLETE is always determined in reference to a retention policy. For example, if a … that are no longer needed to meet the configured retention policy. These backups have status … OBSOLETE and are eligible for deletion to satisfy the disk quota rules. The retention policy is never … logs to tape, then the retention
1.3.6 Oracle Database Vault Default Audit Policy and Initialization Parameters → Oracle Database Vault installs a baseline database auditing policy. This policy covers the access … Administrator's Guide for more information about the database audit policy
Using a Password Management Policy → , Oracle Database uses a password management policy. Database administrators and security officers … control this policy through user profiles, enabling greater control of database security. Use the
retention policy → See backup retention policy
Configuring an Oracle Virtual Private Database Policy → This section contains: About Oracle Virtual Private Database Policies Attaching a Policy to a … Display of Column Data with Policies Working with Oracle Virtual Private Database Policy Groups … Optimizing Performance by Using Oracle Virtual Private Database Policy Types
Policy-Based Cluster and Capacity Management → resources used by a database called policy-based management. This section contains the following topics … : Overview of Server Pools and Policy-Based Management Server Attributes Assigned by Oracle Clusterware
Table 7-2 DBMS_RLS.ADD_POLICY Policy Types → Policy Types When the Policy Function Executes Usage Example Shared Across Multiple Objects … ? DYNAMIC Policy function re-executes every time a policy-protected database object is accessed … . Applications where policy predicates must be generated for each query, such as time-dependent policies where
Table 125-4 DBMS_RLS.ADD_POLICY Policy Types → Policy Type Description STATIC Predicate is assumed to be the same regardless of the runtime … environment. Static policy functions are executed once and then cached in SGA. Statements accessing the … same object do not reexecute the policy function. However, each execution of the same cursor could … policy function
Entries Policy Creators Policy Administrators Databases → cn=Policies can modify no access no access cn=Admins,cn=Policy1 can modify no access no access uniqueMember: cn=Policy1 can browse can browse can modify cn=PolicyCreators no access Foot 1 no access no access cn=Levels,cn=Policy1 can browse and delete can modify no access cn=Compartments,cn=Policy1 can browse and delete can modify no access cn=Groups,cn=Policy1 can browse and delete can modify no
Optimizing Performance by Using Oracle Virtual Private Database Policy Types → This section contains: About Oracle Virtual Private Database Policy Types Using the Dynamic Policy … Type to Automatically Rerun Policy Functions Using a Static Policy to Prevent Policy Functions from … Rerunning for Each Query Using a Shared Static Policy to Share a Policy
Tutorial: Creating a Simple Oracle Virtual Private Database Policy → : Create a Policy Function Step 3: Create the Oracle Virtual Private Database Policy Step 4: Test … the Policy Step 5: Remove the Components for This Tutorial About This Tutorial Suppose you wanted to … create a simple Oracle Virtual Private Database policy that limits access to all orders in the … OE.ORDERS table