You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for SPACE


1 to 20 of 1659 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Reclaiming Wasted Spacepockets 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

Concepts, 10g Release 1 (10.1)

14 Manageability

Space ManagementThe 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

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Planning Space Usage and Location for the Flash Recovery Areaamount 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

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Resumable Space Allocation OverviewThis section provides an overview of resumable space allocation. It describes how resumable spaceSpace 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

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Reclaiming Unused SpaceOver 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

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Deallocating Unused SpaceWhen 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 … .

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Managing Space in TablespacesOracle 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

Concepts, 10g Release 1 (10.1)

2 Data Blocks, Extents, and Segments

Free Space ManagementFree 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

Concepts, 10g Release 1 (10.1)

14 Manageability

Free Space ManagementOr 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.

Concepts, 10g Release 1 (10.1)

14 Manageability

Transparent Space ReclamationThe 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.

Concepts, 10g Release 1 (10.1)

14 Manageability

Proactive Space ManagementOracle 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

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

log buffer spaceWaiting for space in the log buffer because the session is writing data into the log buffer faster

Concepts, 10g Release 1 (10.1)

3 Tablespaces, Datafiles, and Control Files

Managing Space in TablespacesTablespaces 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

Performance Tuning Guide, 10g Release 1 (10.1)

4 Configuring a Database for Performance

Configuring Undo SpaceOracle 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

Upgrade Guide, 10g Release 1 (10.1)

5 Compatibility and Interoperability

Transaction and Spacewhere the space is only reused when it is needed. This allows an object to be undropped using the

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Managing Resumable Space Allocationdatabase 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

Performance Tuning Guide, 10g Release 1 (10.1)

4 Configuring a Database for Performance

Reclaiming Unused SpaceOver 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

Concepts, 10g Release 1 (10.1)

4 Transaction Management

Resumable Space Allocationoperations 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

Performance Tuning Guide, 10g Release 1 (10.1)

10 Instance Tuning Using Performance Views

log buffer spaceThis 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

Advanced Replication Management API Reference, 10g Release 1 (10.1)

8 Managing a Materialized View Replication Environment

Managing Materialized View Log Spacepossible 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