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
Monitoring → Oracle Database provides multiple tools and techniques for monitoring user activity. Database … Auditing Database auditing is the monitoring and recording of selected user database actions. You can use … their accountability Investigating, monitoring, and recording suspicious activity Addressing auditing … network with detailed
Monitoring Locks → Monitoring Data Dictionary Views\" Oracle Database Concepts contains more information about locks.
Monitoring Performance → Monitoring database performance is covered in detail in Oracle Database Performance Tuning Guide … . Here are some additional topics with details that are not covered in that guide: Monitoring Locks … Monitoring Wait Events Performance Monitoring Data Dictionary Views
Monitoring Jobs → … Monitoring Jobs There are several ways to monitor Scheduler jobs: Viewing the job log The job log … See \"Monitoring Job State with Events Raised by the Scheduler\" Configuring jobs to send e-mail … notifications upon a state change See \"Monitoring Job State with E-mail Notifications\"
Monitoring Disk Group Usage → Perform the following procedures to monitor disk group usage: To view Oracle ASM disk group usage and free space: Access the Oracle Automatic Storage Management Home page. See Also: \"Oracle Automatic Storage Management Home Page\" for instructions about how to access the home page Click the Disk Groups link to view the Disk Groups property page. If the Oracle ASM Login page appears, then log in as
Monitoring General Oracle ASM Performance → You can monitor Oracle ASM performance with the Oracle Enterprise Manager Performance page, shown in Figure 9-15. Figure 9-15 Oracle Automatic Storage Management Performance Page Description of \"Figure 9-15 Oracle Automatic Storage Management Performance Page\" To monitor Oracle ASM performance: Access the Oracle Automatic Storage Management Home page. See Also: \"Oracle Automatic Storage Management
8 Monitoring Database Operations → you recognize when something is wrong. In this chapter: Monitoring Errors and Alerts Monitoring Performance
Monitoring Wait Events → Wait events are statistics that are incremented by a server process to indicate that it had to wait for an event to complete before being able to continue processing. A session could wait for a variety of reasons, including waiting for more input, waiting for the operating system to complete a service such as a disk write, or it could wait for a lock or latch. When a session is waiting for resources,
Monitoring Errors and Alerts → topics: Monitoring Errors with Trace Files and the Alert Log Monitoring Database Operations with … monitoring, using data dictionary views, PL/SQL packages, and other command-line facilities.
Monitoring Multiple Destination Jobs → contents of the job monitoring views for multiple-destination jobs. Table 29-12 Scheduler Data
Monitoring Index Usage → Oracle Database provides a means of monitoring indexes to determine whether they are being used. If … start monitoring the usage of an index, issue this statement: ALTER INDEX index MONITORING USAGE … ; Later, issue the following statement to stop the monitoring: ALTER INDEX index NOMONITORING USAGE; The … monitoring
Monitoring Running Chains → Monito ring Running Chains You can view the status of running chains with the following two views: *_SCHEDULER_RUNNING_JOBS *_SCHEDULER_RUNNING_CHAINS The *_SCHEDULER_RUNNING_JOBS views contain one row for the chain job and one row for each running step. The *_SCHEDULER_RUNNING_CHAINS views contain one row for each chain step (including any nested chains) and include run status for each step ( NOT_STARTED,
Monitoring Oracle Database Resource Manager → Use the following dynamic performance views to help you monitor the results of your Oracle Database Resource Manager settings: V$RSRC_PLAN V$RSRC_CONSUMER_GROUP V$RSRC_SESSION_INFO V$RSRC_PLAN_HISTORY V$RSRC_CONS_GROUP_HISTORY V$RSRCMGRMETRIC V$RSRCMGRMETRIC_HISTORY These views provide: Current status information History of resource plan activations Current and historical statistics on resource consumption
Monitoring and Managing the Scheduler → Monitoring and Mana ging the Scheduler The following sections discuss how to monitor and manage the … Currently Running Jobs Monitoring and Managing Window and Job Logs Managing Scheduler Security
Monitoring Space Use of Indexes → If key values in an index are inserted, updated, and deleted frequently, the index can lose its acquired space efficiency over time. Monitor index efficiency of space usage at regular intervals by first analyzing the index structure, using the ANALYZE INDEX...VALIDATE STRUCTURE statement, and then querying the INDEX_STATS view: SELECT PCT_USED FROM INDEX_STATS WHERE NAME = 'index'; The percentage
Performance Monitoring Data Dictionary Views → This section lists some of the data dictionary views that you can use to monitor an Oracle Database instance. These views are general in their scope. Other views, more specific to a process, are discussed in the section of this book where the process is described. View Description V$LOCK Lists the locks currently held by Oracle Database and outstanding requests for a lock or latch DBA_BLOCKERS Displays
Monitoring Oracle ASM Performance with Oracle Enterprise Manager → tasks: Monitoring General Oracle ASM Performance Checking Disk Group Integrity
Monitoring Flashback Database → When you use Flashback Database to rewind a database to a past target time, Flashback Database determines which blocks changed after the target time and restores them from the flashback logs. This is called the restore phase. After this phase completes, Flashback Database then uses redo logs to reapply changes that were made after these blocks were written to the flashback logs. This is called the
10.4.1 SQL Plan Monitoring → Real-time SQL monitoring also includes monitoring statistics for each operation in the execution