Data Dictionary Views


Data Dictionary Views


1: Dictionary Views
2: User Management Views
3: Logical Backup Views
4: Schema Object Views
5: UNDO Management Views
6: Audit Views
7: Partition Views
8: Index Views
9: Large Object Views
10: Virtual Private Database Views
11: Stream Pool Views
12: PL/SQL Views
13: Resumable Space Views
14: Distrubuted Transaction Views
15: Materialized Views
16: Performance Tuning Views
17: Replication Views
18: Tablespace Management Views
19: User Object Views
20: Recycle Bin Views
21: External Table Views
22: Schema Segment Views
23: Package Info Views
24: Logminer Views
25: Data Guard Views
26: Datapump Views
27: Context Views
28: Networl View
29: Redefinition Online Views
30: Schedular Views
31: Streamed Pool Views
32: Resource Consumer Group Views
33: Automatic Workload Repository Views
34: Other Views


Streamed Pool Views


1: DBA_FILE_GROUP_EXPORT_INFO
2: DBA_FILE_GROUP_TABLES
3: DBA_STREAMS_SCHEMA_RULES
4: DBA_STREAMS_RULES
5: DBA_STREAMS_UNSUPPORTED
6: DBA_STREAMS_RENAME_SCHEMA
7: DBA_STREAMS_RENAME_COLUMN
8: DBA_RECOVERABLE_SCRIPT_PARAMS
9: DBA_TSM_SOURCE
10: DBA_FILE_GROUPS
11: DBA_FILE_GROUPS_FILES
12: DBA_STREAMS_MESSAGE_CONSUMERS
13: DBA_STREAMS_TABLE_RULES
14: DBA_STREAMS_TRANSFORM_FUNCTION
15: DBA_STREAMS_NEWLY_SUPPORTED
16: DBA_STREAMS_RENAME_TABLE
17: DBA_STREAMS_ADD_COLUMN
18: DBA_RECOVERABLE_SCRIPT_BLOCKS
19: DBA_TSM_DESTINATION
20: DBA_FILE_GROUP_VERSIONS
21: DBA_FILE_GROUP_TABLESPACES
22: DBA_STREAMS_GLOBAL_RULES
23: DBA_STREAMS_MESSAGE_RULES
24: DBA_STREAMS_ADMINISTRATOR
25: DBA_STREAMS_TRANSFORMATIONS
26: DBA_STREAMS_DELETE_COLUMN
27: DBA_RECOVERABLE_SCRIPT
28: DBA_RECOVERABLE_SCRIPT_ERRORS
29: DBA_TSM_HISTORY
30: DBA_PROPAGATION


Schedular Views


1: DBA_SCHEDULER_JOBS
2: DBA_SCHEDULER_PROGRAM_ARGS
3: DBA_SCHEDULER_JOB_RUN_DETAILS
4: DBA_SCHEDULER_WINDOW_GROUPS
5: DBA_SCHEDULER_RUNNING_JOBS
6: DBA_SCHEDULER_CHAIN_RULES
7: DBA_SCHEDULER_JOB_CLASSES
8: DBA_SCHEDULER_JOB_ARGS
9: DBA_SCHEDULER_WINDOW_LOG
10: DBA_SCHEDULER_WINGROUP_MEMBERS
11: DBA_SCHEDULER_GLOBAL_ATTRIBUTE
12: DBA_SCHEDULER_CHAIN_STEPS
13: DBA_SCHEDULER_PROGRAMS
14: DBA_SCHEDULER_WINDOWS
15: DBA_SCHEDULER_JOB_LOG
16: DBA_SCHEDULER_SCHEDULES
17: DBA_SCHEDULER_WINDOW_DETAILS
18: DBA_SCHEDULER_SCHEDULES
19: DBA_SCHEDULER_CHAINS
20: DBA_SCHEDULER_RUNNING_CHAINS


Redefinition Online Views


1: DBA_REDEFINITION_ERRORS
2: DBA_REDEFINITION_OBJECTS


Datapump Views


1: DBA_DATAPUMP_JOBS
2: DBA_DATAPUMP_SESSIONS


Data Guard Views


1: DBA_LOGSTDBY_PARAMETERS
2: DBA_LOGSTDBY_SKIP_TRANSACTION
3: DBA_LOGSTDBY_HISTORY
4: DBA_LOGSTDBY_PROGRESS
5: DBA_LOGSTDBY_LOG
6: DBA_LOGSTDBY_SKIP
7: DBA_LOGSTDBY_EVENTS


Logminer Views


1: DBA_LOGMNR_LOG
2: DBA_LOGMNR_SESSION
3: DBA_LOGMNR_PURGED_LOG


Package Info Views

1: DBA_SOURCE


Schema Segment Views


1: DBA_EXTENTS
2: DBA_SEGMENTS_OLD


External Table Views


1: DBA_EXTERNAL_TABLES
2: DBA_EXTERNAL_LOCATIONS


Recycle Bin Views

1: DBA_RECYCLEBIN


User Object Views


1: DBA_SUMMARY_AGGREGATES
2: DBA_SUMMARY_JOINS


Tablespace Management Views


1: DBA_FREE_SPACE
2: DBA_FREE_SPACE_COALESCED_TMP1
3: DBA_FREE_SPACE_COALESCED_TMP4
4: DBA_FREE_SPACE_COALESCED
5: DBA_TEMP_FILES
6: DBA_AUTO_SEGADV_CLT
7: DBA_LMT_USED_EXTENTS
8: DBA_LMT_FREE_SPACE
9: DBA_FREE_SPACE_COALESCED_TMP2
10: DBA_FREE_SPACE_COALESCED_TMP5
11: DBA_DATA_FILES
12: DBA_TABLESPACE_GROUPS
13: DBA_DMT_USED_EXTENTS
14: DBA_DMT_FREE_SPACE
15: DBA_FREE_SPACE_COALESCED_TMP3
16: DBA_FREE_SPACE_COALESCED_TMP6
17: DBA_TABLESPACES
18: DBA_TABLESPACE_USAGE_METRICS
19: DBA_TS_QUOTAS


Replication Views


1: DBA_JOBS
2: DBA_ERRORS
3: DBA_JOBS_RUNNING



Performance Tuning Views


1: DBA_ADVISOR_DEFINITIONS
2: DBA_ADVISOR_USAGE
3: DBA_ADVISOR_LOG
4: DBA_ADVISOR_PARAMETERS_PROJ
5: DBA_ADVISOR_RECOMMENDATIONS
6: DBA_ADVISOR_DIRECTIVES
7: DBA_ADVISOR_SQLA_WK_STMTS
8: DBA_ADVISOR_SQLW_TEMPLATES
9: DBA_ADVISOR_SQLW_TABVOL
10: DBA_ADVISOR_SQLW_JOURNAL
11: DBA_TAB_STATS_HISTORY
12: DBA_ADVISOR_COMMENTS
13: DBA_ADVISOR_TASKS
14: DBA_ADVISOR_DEF_PARAMETERS
15: DBA_ADVISOR_OBJECTS
16: DBA_ADVISOR_ACTIONS
17: DBA_ADVISOR_JOURNAL
18: DBA_ADVISOR_SQLA_REC_SUM
19: DBA_ADVISOR_SQLW_STMTS
20: DBA_ADVISOR_SQLW_COLVOL
21: DBA_HIST_PGA_TARGET_ADVICE
22: DBA_HIST_JAVA_POOL_ADVICE
23: DBA_HIST_SYSSTAT
24: DBA_HIST_OSSTAT
25: DBA_HIST_UNDOSTAT
26: DBA_HIST_METRIC_NAME
27: DBA_HIST_SESSMETRIC_HISTORY
28: DBA_AUTO_SEGADV_SUMMARY
29: DBA_ANALYZE_OBJECTS
30: DBA_ADVISOR_OBJECT_TYPES
31:DBA_ADVISOR_TEMPLATES
32: DBA_ADVISOR_PARAMETERS
33: DBA_ADVISOR_FINDINGS
34: DBA_ADVISOR_RATIONALE
35: DBA_ADVISOR_SQLA_WK_MAP
36: DBA_ADVISOR_SQLW_SUM
37: DBA_ADVISOR_SQLW_TABLES
38: DBA_ADVISOR_SQLW_PARAMETERS
39: DBA_HIST_SGA_TARGET_ADVICE
40: DBA_HIST_THREAD
41: DBA_HIST_SYS_TIME_MODEL
42: DBA_HIST_PARAMETER_NAME
43: DBA_HIST_SEGSTAT
44: DBA_HIST_SYSMETRIC_HISTORY
45: DBA_HIST_FILEMETRIC_HISTORY
46: DBA_OUTLINE_HINTS
47: DBA_SEC_RELEVANT_COLS



Materialized Views


1: DBA_MVIEW_AGGREGATES
2: DBA_MVIEW_JOINS
3: DBA_MVIEWS_DETAIL_RELATIONS
4: DBA_MVIEW_COMMENTS
5: DBA_TUNE_MVIEW
6: DBA_MVIEW_ANALYSIS
7: DBA_MVIEW_KEYS
8: DBA_MVIEW_EQUIVALANCES
9: DBA_SNAPSHOT_LOGS
10: DBA_REFRESH
11: DBA_MVIEWS
12: DBA_BASE_TABLE_MVIEWS
13: DBA_REFRESH_CHILDREN
14: DBA_MVIEW_REFRESH_TIMES
15: DBA_REGISTERED_MVIEWS
16: DBA_SNAPSHOTS
17: DBA_REGISTERED_SNAPSHOTS
18: DBA_MVIEW_LOGS
19: DBA_MVIEW_LOG_FILTER_COLS



Distribution Transaction Views


1: DBA_2PC_PENDING
2: DBA_PENDING_TRANSACTIONS


Resumable Space Views

1: DBA_RESUMABLE


PL/SQL Views


1: DBA_PROCEDURES
2: DBA_TRIGGERS
3: DBA_INTERNAL_TRIGGER
4: DBA_TRIGGER_COLS
5: DBA_WARNING_SETTINGS
6: DBA_TRIGGER_COLS


Stream Pool Views


1: DBA_LOG_GROUPS
2: DBA_LOG_GROUP_COLUMNS

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...