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
Reclaiming Wasted Space → pockets of empty space that individually are not big enough to be reused. Collectively these … pockets can combine to form large amounts of wasted space. Oracle lets you reclaim wasted space through a … shrink operation. In a shrink operation, data is compacted to the front of the table. Free space can … will
Space Management → The Oracle Database automatically manages its space consumption, sends alerts on potential space … problems, and recommends possible solutions. Oracle features that help you to easily manage space … include the following: Automatic Undo Management Oracle-Managed Files Free Space Management Proactive … Space
Planning Space Usage and Location for the Flash Recovery Area → amount of disk space to allocate for the flash recovery area depends upon the size and activity levels of … them. Retention Policy and the Flash Recovery Area Space management in the flash recovery area is … window. This strategy thus offers both wastes disk space usage and results in poor recovery … performance. A redundancy-based
Resumable Space Allocation Overview → This section provides an overview of resumable space allocation. It describes how resumable space … Space Allocation Works The following is an overview of how resumable space allocation works. Details … been enabled for resumable space allocation by one of the following actions: The RESUMABLE_TIMEOUT
Reclaiming Unused Space → Over time, it is common for segment space to become fragmented or for a segment to acquire a lot of … free space as the result of update and delete operations. The resulting sparsely populated objects … you determine which objects have space available for reclamation. If the Segment Advisor indicates … that an object does have
Deallocating Unused Space → When you deallocate unused space, the database frees the unused space at the unused (high water … mark) end of the database segment and makes the space available for other segments in the tablespace … returns information about the position of the high water mark and the amount of unused space in a segment … .
Managing Space in Tablespaces → Oracle Database provides proactive help in managing tablespace disk space use by alerting you when … tablespaces run low on available space. Two alert thresholds are defined by default: warning and … critical. The warning threshold is the limit at which space is beginning to run low. The critical … Automatic Workload Repository
Free Space Management → Free space can be managed automatically or manually. Free space can be managed automatically inside … database segments. The in-segment free/used space is tracked using bitmaps, as opposed to free … lists. Automatic segment-space management offers the following benefits: Ease of use Better space
Free Space Management → Or acle allows for managing free space within a table with bitmaps, as well as traditional … dictionary based space management. The bitmapped implementation eliminates much space-related tuning of … files. Database administrators do not need to manually track and reorganize the space usage in all the database files.
Transparent Space Reclamation → The Oracle Database provides in place reorganization of data for optimal space utilization by … shrinking it. Shrinking of a segment makes unused space available to other segments in the tablespace and … compacts the space used in a segment and then deallocates it from the segment. The deallocated space … place.
Proactive Space Management → Oracle Database introduces a non-intrusive and timely check for space utilization monitoring. It … automatically monitors space utilization during normal space allocation and de-allocation operations … and alerts you if the free space availability falls below the pre-defined thresholds. Space
log buffer space → Waiting for space in the log buffer because the session is writing data into the log buffer faster
Managing Space in Tablespaces → Tablespaces allocate space in extents. Tablespaces can use two different methods to keep track of … their free and used space: Locally managed tablespaces: Extent management by the tablespace … choose one of these methods of space management. Later, you can change the management method with the … tablespaces: Local management
Configuring Undo Space → Oracle needs undo space to keep information for read consistency, for recovery, and for actual … view contains statistics for monitoring and tuning undo space. Using this view, you can better … estimate the amount of undo space required for the current workload. Oracle also uses this information to … Administrator's Guide for
Transaction and Space → where the space is only reused when it is needed. This allows an object to be undropped using the
Managing Resumable Space Allocation → database operations in the event of space allocation failures. This enables you to take corrective action … corrected, the suspended operation automatically resumes. This feature is called resumable space … following topics: Resumable Space Allocation Overview Enabling and Disabling Resumable Space … Allocation
Reclaiming Unused Space → Over time, it is common for segment space to become fragmented or for a segment to acquire a lot of … free space as the result of update and delete operations. The resulting sparsely populated objects … Segment Advisor that provides advice on whether an object has space available for reclamation based on … the level of space
Resumable Space Allocation → operations in the event of space allocation failures. This enables an administrator to take corrective … statement. Resumable space allocation is suspended when one of the following conditions occur: Out of … space condition Maximum extents reached condition Space quota exceeded condition For nonresumable … space
log buffer space → This event occurs when server processes are waiting for free space in the log buffer, because all … redo logs reside do not suffer from I/O contention. The log buffer space wait event could be indicative
Managing Materialized View Log Space → possible to minimize the database space that it uses. To remove rows from a materialized view log and … make space for newer log records, you can perform one of the following actions: Refresh the … grows and allocates many extents, then purging the log of rows does not reduce the amount of space … materialized view log. To reduce