Common Space Management ProblemsRunning Out of Free Space in a TablespaceInsufficient Space for Temporary SegmentsToo Much or Too Little Undo Space AllocatedFragmented Tablespaces and SegmentsOracle Segments, Extents, and BlocksData BlocksExtentsSegmentsData Dictionary Views and Dynamic Performance ViewsDBA_TABLESPACESDBA_SEGMENTSDBA_EXTENTSDBA_FREE_SPACEDBA_LMT_FREE_SPACEDBA_THRESHOLDSDBA_OUTSTANDING_ALERTSDBA_ALERT_HISTORYV$ALERT_TYPESV$UNDOSTATV$OBJECT_USAGEV$SORT_SEGMENTV$TEMPSEG_USAGESpace Management MethodologiesLocally Managed TablespacesUsing OMF to Manage SpaceBigfile TablespacesAutomatic Storage ManagementUndo Management ConsiderationsSYSAUX Monitoring and UsageArchived Redo Log File ManagementBuilt-in Space Management ToolsSegment AdvisorUndo Advisor and the Automatic Workload RepositoryIndex UsageSpace Usage Warning LevelsResumable Space AllocationOS Space ManagementSpace Management ScriptsSegments That Cannot Allocate Additional ExtentsUsed and Free Space by Tablespace and DatafileAutomating and Streamlining the Notification ProcessUsing DBMS_SCHEDULEROEM Job Control and Monitoring