Spatial DBA - Oracle and ArcSDE

Note: Oracle 11g R1

This is a list of Oracle data dictionary views (DBA_VIEWS). It also serves as the index page of related Oracle articles in this blog.

AUDIT_ACTIONS

DBA_2PC_NEIGHBORS

DBA_2PC_PENDING

DBA_ADDM_FDG_BREAKDOWN

DBA_ADDM_FINDINGS

DBA_ADDM_INSTANCES

DBA_ADDM_SYSTEM_DIRECTIVES

DBA_ADDM_TASKS

DBA_ADDM_TASK_DIRECTIVES

DBA_ADVISOR_ACTIONS

DBA_ADVISOR_COMMANDS

DBA_ADVISOR_DEFINITIONS

DBA_ADVISOR_DEF_PARAMETERS

DBA_ADVISOR_DIR_DEFINITIONS

DBA_ADVISOR_DIR_INSTANCES

DBA_ADVISOR_DIR_TASK_INST

DBA_ADVISOR_EXECUTIONS

DBA_ADVISOR_EXECUTION_TYPES

DBA_ADVISOR_EXEC_PARAMETERS

DBA_ADVISOR_FDG_BREAKDOWN

DBA_ADVISOR_FINDINGS

DBA_ADVISOR_FINDING_NAMES

DBA_ADVISOR_JOURNAL

DBA_ADVISOR_LOG

DBA_ADVISOR_OBJECTS

DBA_ADVISOR_OBJECT_TYPES

DBA_ADVISOR_PARAMETERS

DBA_ADVISOR_PARAMETERS_PROJ

DBA_ADVISOR_RATIONALE

DBA_ADVISOR_RECOMMENDATIONS

DBA_ADVISOR_SQLA_COLVOL

DBA_ADVISOR_SQLA_REC_SUM

DBA_ADVISOR_SQLA_TABLES

DBA_ADVISOR_SQLA_TABVOL

DBA_ADVISOR_SQLA_WK_MAP

DBA_ADVISOR_SQLA_WK_STMTS

DBA_ADVISOR_SQLA_WK_SUM

DBA_ADVISOR_SQLPLANS

DBA_ADVISOR_SQLSTATS

DBA_ADVISOR_SQLW_COLVOL

DBA_ADVISOR_SQLW_JOURNAL

DBA_ADVISOR_SQLW_PARAMETERS

DBA_ADVISOR_SQLW_STMTS

DBA_ADVISOR_SQLW_SUM

DBA_ADVISOR_SQLW_TABLES

DBA_ADVISOR_SQLW_TABVOL

DBA_ADVISOR_SQLW_TEMPLATES

DBA_ADVISOR_TASKS

DBA_ADVISOR_TEMPLATES

DBA_ADVISOR_USAGE

DBA_ALERT_ARGUMENTS

DBA_ALERT_HISTORY

DBA_ALL_TABLES

DBA_ANALYZE_OBJECTS

DBA_APPLICATION_ROLES

DBA_APPLY

DBA_APPLY_CONFLICT_COLUMNS

DBA_APPLY_DML_HANDLERS

DBA_APPLY_ENQUEUE

DBA_APPLY_ERROR

DBA_APPLY_EXECUTE

DBA_APPLY_INSTANTIATED_GLOBAL

DBA_APPLY_INSTANTIATED_OBJECTS

DBA_APPLY_INSTANTIATED_SCHEMAS

DBA_APPLY_KEY_COLUMNS

DBA_APPLY_PARAMETERS

DBA_APPLY_PROGRESS

DBA_APPLY_SPILL_TXN

DBA_APPLY_TABLE_COLUMNS

DBA_ATTRIBUTE_TRANSFORMATIONS

DBA_AUDIT_EXISTS: Notes on Auditing in Oracle Database

DBA_AUDIT_OBJECT: Notes on Auditing in Oracle Database

DBA_AUDIT_POLICIES: Notes on Auditing in Oracle Database

DBA_AUDIT_POLICY_COLUMNS: Notes on Auditing in Oracle Database

DBA_AUDIT_SESSION: Notes on Auditing in Oracle Database

DBA_AUDIT_STATEMENT: Notes on Auditing in Oracle Database

DBA_AUDIT_TRAIL: Notes on Auditing in Oracle Database

DBA_AUTO_SEGADV_CTL

DBA_AUTOTASK_CLIENT

DBA_AUTOTASK_CLIENT_HISTORY

DBA_AUTOTASK_CLIENT_JOB

DBA_AUTOTASK_JOB_HISTORY

DBA_AUTOTASK_OPERATION

DBA_AUTOTASK_SCHEDULE

DBA_AUTOTASK_TASK

DBA_AUTOTASK_WINDOW_CLIENTS

DBA_AUTOTASK_WINDOW_HISTORY

DBA_AWS

DBA_AW_OBJ

DBA_AW_PROP

DBA_AW_PS

DBA_BASE_TABLE_MVIEWS

DBA_BLOCKERS

DBA_CACHEABLE_NONTABLE_OBJECTS

DBA_CACHEABLE_OBJECTS

DBA_CACHEABLE_OBJECTS_BASE

DBA_CACHEABLE_TABLES

DBA_CACHEABLE_TABLES_BASE

DBA_CAPTURE

DBA_CAPTURE_EXTRA_ATTRIBUTES

DBA_CAPTURE_PARAMETERS

DBA_CAPTURE_PREPARED_DATABASE

DBA_CAPTURE_PREPARED_SCHEMAS

DBA_CAPTURE_PREPARED_TABLES

DBA_CATALOG

DBA_CHANGE_NOTIFICATION_REGS

DBA_CLUSTERS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_CLU_COLUMNS

DBA_COLL_TYPES

DBA_COL_COMMENTS

DBA_COL_PENDING_STATS

DBA_COL_PRIVS

DBA_COMMON_AUDIT_TRAIL

DBA_COMPARISON

DBA_COMPARISON_COLUMNS

DBA_COMPARISON_ROW_DIF

DBA_COMPARISON_SCAN

DBA_COMPARISON_SCAN_SUMMARY

DBA_COMPARISON_SCAN_VALUES

DBA_CONNECT_ROLE_GRANTEES

DBA_CONSTRAINTS

DBA_CONS_COLUMNS

DBA_CONS_OBJ_COLUMNS

DBA_CONTEXT

DBA_CPOOL_INFO

DBA_CPU_USAGE_STATISTICS

DBA_CQ_NOTIFICATION_QUERIES

DBA_CUBES

DBA_CUBE_ATTRIBUTES

DBA_CUBE_ATTR_VISIBILITY

DBA_CUBE_BUILD_PROCESSES

DBA_CUBE_CALCULATED_MEMBERS

DBA_CUBE_DIMENSIONALITY

DBA_CUBE_DIMENSIONS

DBA_CUBE_DIM_LEVELS

DBA_CUBE_DIM_MODELS

DBA_CUBE_DIM_VIEWS

DBA_CUBE_DIM_VIEW_COLUMNS

DBA_CUBE_HIERARCHIES

DBA_CUBE_HIER_LEVELS

DBA_CUBE_HIER_VIEWS

DBA_CUBE_HIER_VIEW_COLUMNS

DBA_CUBE_MEASURES

DBA_CUBE_VIEWS

DBA_CUBE_VIEW_COLUMNS

DBA_DATAPUMP_JOBS

DBA_DATAPUMP_SESSIONS

DBA_DATA_FILES: Calculate Oracle database size and used storage

DBA_DIM_ATTRIBUTES

DBA_DIM_CHILD_OF

DBA_DIM_HIERARCHIES

DBA_DIM_JOIN_KEY

DBA_DIM_LEVELS

DBA_DIM_LEVEL_KEY

DBA_DIRECTORIES

DBA_DML_LOCKS

DBA_DMT_FREE_SPACE

DBA_DMT_USED_EXTENTS

DBA_EDITIONING_VIEWS

DBA_EDITIONING_VIEWS_AE

DBA_EDITIONING_VIEW_COLS

DBA_EDITIONING_VIEW_COLS_AE

DBA_EDITIONS

DBA_EDITION_COMMENTS

DBA_ENABLED_AGGREGATIONS

DBA_ENABLED_TRACES

DBA_ENCRYPTED_COLUMNS

DBA_EPG_DAD_AUTHORIZATION

DBA_ERRORS

DBA_ERRORS_AE

DBA_EVALUATION_CONTEXTS

DBA_EVALUATION_CONTEXT_TABLES

DBA_EVALUATION_CONTEXT_VARS

DBA_EXPORT_OBJECTS

DBA_EXTERNAL_LOCATIONS

DBA_EXTERNAL_TABLES

DBA_FEATURE_USAGE_STATISTICS

DBA_FGA_AUDIT_TRAIL

DBA_FILE_GROUPS

DBA_FILE_GROUP_EXPORT_INFO

DBA_FILE_GROUP_FILES

DBA_FILE_GROUP_TABLES

DBA_FILE_GROUP_TABLESPACES

DBA_FILE_GROUP_VERSIONS

DBA_FLASHBACK_ARCHIVE

DBA_FLASHBACK_ARCHIVE_TABLES

DBA_FLASHBACK_ARCHIVE_TS

DBA_FLASHBACK_TXN_REPORT

DBA_FLASHBACK_TXN_STATE

DBA_FREE_SPACE: Using DBA_FREE_SPACE

DBA_FREE_SPACE_COALESCED: Using DBA_FREE_SPACE

DBA_GLOBAL_CONTEXT

DBA_HIGH_WATER_MARK_STATISTICS

DBA_HIST_ACTIVE_SESS_HISTORY

DBA_HIST_BASELINE

DBA_HIST_BASELINE_DETAILS

DBA_HIST_BASELINE_METADATA

DBA_HIST_BASELINE_TEMPLATE

DBA_HIST_BG_EVENT_SUMMARY

DBA_HIST_BUFFERED_QUEUES

DBA_HIST_BUFFERED_SUBSCRIBERS

DBA_HIST_BUFFER_POOL_STAT

DBA_HIST_CLUSTER_INTERCON

DBA_HIST_COLORED_SQL

DBA_HIST_COMP_IOSTAT

DBA_HIST_CR_BLOCK_SERVER

DBA_HIST_CURRENT_BLOCK_SERVER

DBA_HIST_DATABASE_INSTANCE

DBA_HIST_DATAFILE

DBA_HIST_DB_CACHE_ADVICE

DBA_HIST_DLM_MISC

DBA_HIST_ENQUEUE_STAT

DBA_HIST_EVENT_HISTOGRAM

DBA_HIST_EVENT_NAME

DBA_HIST_FILEMETRIC_HISTORY

DBA_HIST_FILESTATXS

DBA_HIST_IC_CLIENT_STATS

DBA_HIST_IC_DEVICE_STATS

DBA_HIST_INSTANCE_RECOVERY

DBA_HIST_INST_CACHE_TRANSFER

DBA_HIST_INTERCONNECT_PINGS

DBA_HIST_IOSTAT_FILETYPE

DBA_HIST_IOSTAT_FILETYPE_NAME

DBA_HIST_IOSTAT_FUNCTION

DBA_HIST_IOSTAT_FUNCTION_NAME

DBA_HIST_JAVA_POOL_ADVICE

DBA_HIST_LATCH

DBA_HIST_LATCH_CHILDREN

DBA_HIST_LATCH_MISSES_SUMMARY

DBA_HIST_LATCH_NAME

DBA_HIST_LATCH_PARENT

DBA_HIST_LIBRARYCACHE

DBA_HIST_LOG

DBA_HIST_MEMORY_RESIZE_OPS

DBA_HIST_MEMORY_TARGET_ADVICE

DBA_HIST_MEM_DYNAMIC_COMP

DBA_HIST_METRIC_NAME

DBA_HIST_MTTR_TARGET_ADVICE

DBA_HIST_MUTEX_SLEEP

DBA_HIST_OPTIMIZER_ENV

DBA_HIST_OSSTAT

DBA_HIST_OSSTAT_NAME

DBA_HIST_PARAMETER

DBA_HIST_PARAMETER_NAME

DBA_HIST_PERSISTENT_QUEUES

DBA_HIST_PERSISTENT_SUBS

DBA_HIST_PGASTAT

DBA_HIST_PGA_TARGET_ADVICE

DBA_HIST_PROCESS_MEM_SUMMARY

DBA_HIST_RESOURCE_LIMIT

DBA_HIST_ROWCACHE_SUMMARY

DBA_HIST_RSRC_CONSUMER_GROUP

DBA_HIST_RSRC_PLAN

DBA_HIST_RULE_SET

DBA_HIST_SEG_STAT

DBA_HIST_SEG_STAT_OBJ

DBA_HIST_SERVICE_NAME

DBA_HIST_SERVICE_STAT

DBA_HIST_SERVICE_WAIT_CLASS

DBA_HIST_SESSMETRIC_HISTORY

DBA_HIST_SESS_TIME_STATS

DBA_HIST_SGA

DBA_HIST_SGASTAT

DBA_HIST_SGA_TARGET_ADVICE

DBA_HIST_SHARED_POOL_ADVICE

DBA_HIST_SNAPSHOT

DBA_HIST_SNAP_ERROR

DBA_HIST_SQLBIND

DBA_HIST_SQLSTAT

DBA_HIST_SQLTEXT

DBA_HIST_SQL_BIND_METADATA

DBA_HIST_SQL_PLAN

DBA_HIST_SQL_SUMMARY

DBA_HIST_SQL_WORKAREA_HSTGRM

DBA_HIST_STAT_NAME

DBA_HIST_STREAMS_APPLY_SUM

DBA_HIST_STREAMS_CAPTURE

DBA_HIST_STREAMS_POOL_ADVICE

DBA_HIST_SYSMETRIC_HISTORY

DBA_HIST_SYSMETRIC_SUMMARY

DBA_HIST_SYSSTAT

DBA_HIST_SYSTEM_EVENT

DBA_HIST_SYS_TIME_MODEL

DBA_HIST_TABLESPACE_STAT

DBA_HIST_TBSPC_SPACE_USAGE

DBA_HIST_TEMPFILE

DBA_HIST_TEMPSTATXS

DBA_HIST_THREAD

DBA_HIST_UNDOSTAT

DBA_HIST_WAITCLASSMET_HISTORY

DBA_HIST_WAITSTAT

DBA_HIST_WR_CONTROL

DBA_IAS_CONSTRAINT_EXP

DBA_IAS_GEN_STMTS

DBA_IAS_GEN_STMTS_EXP

DBA_IAS_OBJECTS

DBA_IAS_OBJECTS_BASE

DBA_IAS_OBJECTS_EXP

DBA_IAS_POSTGEN_STMTS

DBA_IAS_PREGEN_STMTS

DBA_IAS_SITES

DBA_IAS_TEMPLATES

DBA_IDENTIFIERS

DBA_INDEXES

DBA_INDEXTYPES

DBA_INDEXTYPE_ARRAYTYPES

DBA_INDEXTYPE_COMMENTS

DBA_INDEXTYPE_OPERATORS

DBA_IND_COLUMNS

DBA_IND_EXPRESSIONS

DBA_IND_PARTITIONS

DBA_IND_PENDING_STATS

DBA_IND_STATISTICS

DBA_IND_SUBPARTITIONS

DBA_INTERNAL_TRIGGERS

DBA_INVALID_OBJECTS

DBA_JAVA_ARGUMENTS

DBA_JAVA_CLASSES

DBA_JAVA_COMPILER_OPTIONS

DBA_JAVA_DERIVATIONS

DBA_JAVA_FIELDS

DBA_JAVA_IMPLEMENTS

DBA_JAVA_INNERS

DBA_JAVA_LAYOUTS

DBA_JAVA_METHODS

DBA_JAVA_NCOMPS

DBA_JAVA_POLICY

DBA_JAVA_RESOLVERS

DBA_JAVA_THROWS

DBA_JOBS:

DBA_JOBS_RUNNING

DBA_JOIN_IND_COLUMNS

DBA_KEEPSIZES

DBA_KGLLOCK

DBA_LOB_SUBPARTITIONS

DBA_LOB_TEMPLATES

DBA_LOCK

DBA_LOCK_INTERNAL

DBA_LOCKS

DBA_LOGMNR_LOG

DBA_LOGMNR_PURGED_LOG

DBA_LOGMNR_SESSION

DBA_LOGSTDBY_EVENTS

DBA_LOGSTDBY_HISTORY

DBA_LOGSTDBY_LOG

DBA_LOGSTDBY_NOT_UNIQUE

DBA_LOGSTDBY_PARAMETERS

DBA_LOGSTDBY_PROGRESS

DBA_LOGSTDBY_SKIP

DBA_LOGSTDBY_SKIP_TRANSACTION

DBA_LOGSTDBY_UNSUPPORTED

DBA_LOGSTDBY_UNSUPPORTED_TABLE

DBA_LOG_GROUPS

DBA_LOG_GROUP_COLUMNS

DBA_MEASURE_FOLDERS

DBA_MEASURE_FOLDER_CONTENTS

DBA_METHOD_PARAMS

DBA_METHOD_RESULTS

DBA_MINING_MODELS

DBA_MINING_MODEL_ATTRIBUTES

DBA_MINING_MODEL_SETTINGS

DBA_MINING_MODEL_TABLES

DBA_MVIEW_DETAIL_PARTITION

DBA_MVIEW_DETAIL_RELATIONS

DBA_MVIEW_DETAIL_SUBPARTITION

DBA_MVIEW_JOINS

DBA_MVIEW_KEYS

DBA_MVIEW_LOGS

DBA_MVIEW_LOG_FILTER_COLS

DBA_MVIEW_REFRESH_TIMES

DBA_NESTED_TABLES

DBA_NESTED_TABLE_COLS

DBA_NETWORK_ACLS

DBA_NETWORK_ACL_PRIVILEGES

DBA_OBJECTS_AE

DBA_OBJ_COLATTRS

DBA_OLDIMAGE_COLUMNS

DBA_OPANCILLARY

DBA_OPARGUMENTS

DBA_OPBINDINGS

DBA_OPERATORS

DBA_OPERATOR_COMMENTS

DBA_OPTSTAT_OPERATIONS

DBA_OUTLINES

DBA_OUTLINE_HINTS

DBA_OUTSTANDING_ALERTS

DBA_PARTIAL_DROP_TABS

DBA_PART_COL_STATISTICS

DBA_PART_HISTOGRAMS

DBA_PART_INDEXES

DBA_PART_KEY_COLUMNS

DBA_PART_LOBS

DBA_PART_TABLES

DBA_PENDING_CONV_TABLES

DBA_PENDING_TRANSACTIONS

DBA_PLSQL_OBJECT_SETTINGS

DBA_POLICIES

DBA_POLICY_CONTEXTS

DBA_POLICY_GROUPS

DBA_PRIV_AUDIT_OPTS

DBA_PROCEDURES

DBA_PROFILES

DBA_PROPAGATION

DBA_PROXIES

DBA_PUBLISHED_COLUMNS

DBA_QUEUES

DBA_QUEUE_PUBLISHERS

DBA_QUEUE_SCHEDULES

DBA_QUEUE_SUBSCRIBERS

DBA_QUEUE_TABLES

DBA_RCHILD

DBA_RECOVERABLE_SCRIPT

DBA_RECOVERABLE_SCRIPT_BLOCKS

DBA_RECOVERABLE_SCRIPT_ERRORS

DBA_RECOVERABLE_SCRIPT_PARAMS

DBA_REGISTERED_ARCHIVED_LOG

DBA_REGISTERED_MVIEWS

DBA_REGISTERED_MVIEW_GROUPS

DBA_REGISTERED_SNAPSHOTS

DBA_REGISTERED_SNAPSHOT_GROUPS

DBA_REGISTRY

DBA_REGISTRY_DATABASE

DBA_REGISTRY_DEPENDENCIES

DBA_REGISTRY_HIERARCHY

DBA_REGISTRY_HISTORY

DBA_REGISTRY_LOG

DBA_REGISTRY_PROGRESS

DBA_REPAUDIT_ATTRIBUTE

DBA_REPAUDIT_COLUMN

DBA_REPCAT

DBA_REPCATLOG

DBA_REPCAT_EXCEPTIONS

DBA_REPCOLUMN

DBA_REPCOLUMN_GROUP

DBA_REPCONFLICT

DBA_REPDDL

DBA_REPEXTENSIONS

DBA_REPFLAVORS

DBA_REPFLAVOR_COLUMNS

DBA_REPFLAVOR_OBJECTS

DBA_REPGENERATED

DBA_REPGENOBJECTS

DBA_REPGROUP

DBA_REPGROUPED_COLUMN

DBA_REPGROUP_PRIVILEGES

DBA_REPKEY_COLUMNS

DBA_REPOBJECT

DBA_REPPARAMETER_COLUMN

DBA_REPPRIORITY

DBA_REPPRIORITY_GROUP

DBA_REPPROP

DBA_REPRESOLUTION

DBA_REPRESOLUTION_METHOD

DBA_REPRESOLUTION_STATISTICS

DBA_REPRESOL_STATS_CONTROL

DBA_REPSCHEMA

DBA_REPSITES

DBA_REPSITES_NEW

DBA_RESOURCE_INCARNATIONS

DBA_RESUMABLE

DBA_REWRITE_EQUIVALENCES

DBA_RSRC_CAPABILITY

DBA_RSRC_CATEGORIES

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_GROUP_MAPPINGS

DBA_RSRC_INSTANCE_CAPABILITY

DBA_RSRC_IO_CALIBRATE

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_MAPPING_PRIORITY

DBA_RSRC_PLANS

DBA_RSRC_PLAN_DIRECTIVES

DBA_RSRC_STORAGE_POOL_MAPPING

DBA_RULES

DBA_RULESETS

DBA_RULE_SETS

DBA_RULE_SET_RULES

DBA_SCHEDULER_CHAINS

DBA_SCHEDULER_CHAIN_RULES

DBA_SCHEDULER_CHAIN_STEPS

DBA_SCHEDULER_CREDENTIALS

DBA_SCHEDULER_GLOBAL_ATTRIBUTE

DBA_SCHEDULER_JOBS

DBA_SCHEDULER_JOB_ARGS

DBA_SCHEDULER_JOB_CLASSES

DBA_SCHEDULER_JOB_LOG

DBA_SCHEDULER_JOB_ROLES

DBA_SCHEDULER_JOB_RUN_DETAILS

DBA_SCHEDULER_PROGRAMS

DBA_SCHEDULER_PROGRAM_ARGS

DBA_SCHEDULER_REMOTE_DATABASES

DBA_SCHEDULER_REMOTE_JOBSTATE

DBA_SCHEDULER_RUNNING_CHAINS

DBA_SCHEDULER_SCHEDULES

DBA_SCHEDULER_WINDOWS

DBA_SCHEDULER_WINDOW_DETAILS

DBA_SCHEDULER_WINDOW_GROUPS

DBA_SCHEDULER_WINDOW_LOG

DBA_SCHEDULER_WINGROUP_MEMBERS

DBA_SECONDARY_OBJECTS

DBA_SEC_RELEVANT_COLS

DBA_SEGMENTS: Calculate Oracle database size and used storage

DBA_SEGMENTS_OLD

DBA_SEQUENCES

DBA_SERVER_REGISTRY

DBA_SNAPSHOTS

DBA_SNAPSHOT_LOGS

DBA_SOURCE

DBA_SOURCE_AE

DBA_SOURCE_TABLES

DBA_SQLJ_TYPES

DBA_SQLJ_TYPE_ATTRS

DBA_SQLJ_TYPE_METHODS

DBA_SQLSET

DBA_SQLSET_BINDS

DBA_SQLSET_PLANS

DBA_SQLSET_REFERENCES

DBA_SQLSET_STATEMENTS

DBA_SQLTUNE_BINDS

DBA_SQLTUNE_PLANS

DBA_SQLTUNE_RATIONALE_PLAN

DBA_SQLTUNE_STATISTICS

DBA_SQL_PATCHES

DBA_SQL_PLAN_BASELINES

DBA_SQL_PROFILES

DBA_SSCR_CAPTURE

DBA_SSCR_RESTORE

DBA_STAT_EXTENSIONS

DBA_STMT_AUDIT_OPTS

DBA_STORED_SETTINGS

DBA_STREAMS_ADD_COLUMN

DBA_STREAMS_ADMINISTRATOR

DBA_STREAMS_COLUMNS

DBA_STREAMS_DELETE_COLUMN

DBA_STREAMS_GLOBAL_RULES

DBA_STREAMS_MESSAGE_CONSUMERS

DBA_STREAMS_MESSAGE_RULES

DBA_STREAMS_NEWLY_SUPPORTED

DBA_STREAMS_RENAME_COLUMN

DBA_STREAMS_RENAME_SCHEMA

DBA_STREAMS_RENAME_TABLE

DBA_STREAMS_RULES

DBA_STREAMS_SCHEMA_RULES

DBA_STREAMS_TABLE_RULES

DBA_STREAMS_TP_COMPONENT

DBA_STREAMS_TP_COMPONENT_LINK

DBA_STREAMS_TP_COMPONENT_STAT

DBA_STREAMS_TP_DATABASE

DBA_STREAMS_TP_PATH_BOTTLENECK

DBA_STREAMS_TP_PATH_STAT

DBA_STREAMS_TRANSFORMATIONS

DBA_STREAMS_TRANSFORM_FUNCTION

DBA_STREAMS_UNSUPPORTED

DBA_SUBPARTITION_TEMPLATES

DBA_SUBPART_COL_STATISTICS

DBA_SUBPART_HISTOGRAMS

DBA_SUBPART_KEY_COLUMNS

DBA_SUBSCRIBED_COLUMNS

DBA_SUBSCRIBED_TABLES

DBA_SUBSCRIPTIONS

DBA_SUBSCR_REGISTRATIONS

DBA_SUMMARIES

DBA_SYNC_CAPTURE

DBA_SYNC_CAPTURE_PREPARED_TABS

DBA_SYNC_CAPTURE_TABLES

DBA_TABLESPACE_GROUPS

DBA_TABLESPACE_USAGE_METRICS

DBA_TAB_COLS

DBA_TAB_COLUMNS

DBA_TAB_COL_STATISTICS

DBA_TAB_COMMENTS

DBA_TAB_HISTGRM_PENDING_STATS

DBA_TAB_HISTOGRAMS

DBA_TAB_MODIFICATIONS

DBA_TAB_PARTITIONS

DBA_TAB_PENDING_STATS

DBA_TAB_PRIVS

DBA_TAB_STATISTICS

DBA_TAB_STATS_HISTORY

DBA_TAB_STAT_PREFS

DBA_TAB_SUBPARTITIONS

DBA_TEMPLATE_REFGROUPS

DBA_TEMPLATE_TARGETS

DBA_TEMP_FILES: Calculate Oracle database size and used storage

DBA_TEMP_FREE_SPACE

DBA_THRESHOLDS

DBA_TRANSFORMATIONS

DBA_TRIGGERS

DBA_TRIGGER_COLS

DBA_TRIGGER_ORDERING

DBA_TSM_DESTINATION

DBA_TSM_HISTORY

DBA_TSM_SOURCE

DBA_TS_QUOTAS

DBA_TUNE_MVIEW

DBA_TYPES

DBA_TYPE_ATTRS

DBA_TYPE_METHODS

DBA_TYPE_VERSIONS

DBA_UNDO_EXTENTS

DBA_UNUSED_COL_TABS

DBA_UPDATABLE_COLUMNS

DBA_USERS: How to Interpret the ACCOUNT_STATUS Column in DBA_USERS

DBA_USERS_WITH_DEFPWD

DBA_VIEWS_AE

DBA_WORKLOAD_CAPTURES

DBA_WORKLOAD_CONNECTION_MAP

DBA_WORKLOAD_FILTERS

DBA_WORKLOAD_REPLAYS

DBA_WORKLOAD_REPLAY_DIVERGENCE

DBA_XDS_ATTRIBUTE_SECS

DBA_XDS_INSTANCE_SETS

DBA_XDS_OBJECTS

DBA_XML_INDEXES

DBA_XML_SCHEMAS

DBA_XML_TABLES

DBA_XML_TAB_COLS

DBA_XML_VIEWS

DBA_XML_VIEW_COLS

DBA_APPLY_VALUE_DEPENDENCIES

DBA_APPLY_OBJECT_DEPENDENCIES

DBA_SQLSET_DEFINITIONS

DBA_HISTOGRAMS

DBA_LOCKS

DBA_SNAPSHOT_LOG_FILTER_COLS

DBA_SNAPSHOT_REFRESH_TIMES

DEPTREE
DICT
DICT_COLUMNS
DICTIONARY
DOCUMENT_LINKS
ERROR_SIZE
EXCEPTIONS
FLASHBACK_TRANSACTION_QUERY
GLOBAL_NAME
HS_ALL_CAPS
HS_ALL_DD
HS_ALL_INITS
HS_BASE_CAPS
HS_BASE_DD
HS_CLASS_CAPS
HS_CLASS_DD
HS_CLASS_INIT
HS_EXTERNAL_OBJECT_PRIVILEGES
HS_EXTERNAL_OBJECTS
HS_EXTERNAL_USER_PRIVILEGES
HS_FDS_CLASS
HS_FDS_INST
HS_INST_CAPS
HS_INST_DD
HS_INST_INIT
IDEPTREE
IND
INDEX_HISTOGRAM
INDEX_STATS
MAP_OBJECT
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
OBJ
PLAN_TABLE
PLUGGABLE_SET_CHECK
PRODUCT_COMPONENT_VERSION
PROXY_USERS
PSTUBTBL
PUBLIC_DEPENDENCY
PUBLICSYN
QUEUE_PRIVILEGES
RECYCLEBIN
RESOURCE_COST
RESOURCE_MAP
RESOURCE_VIEW
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SEQ
SESSION_CONTEXT
SESSION_PRIVS
SESSION_ROLES
SOURCE_SIZE
STMT_AUDIT_OPTION_MAP
SYN
SYNONYMS
SYS_OBJECTS
SYSCATALOG
SYSFILES
SYSSEGOBJ
SYSTEM_PRIVILEGE_MAP
TAB
TABLE_PRIVILEGE_MAP
TABQUOTAS
TABS
TRUSTED_SERVERS
TS_PITR_CHECK
TS_PITR_OBJECTS_TO_BE_DROPPED
UNI_PLUGGABLE_SET_CHECK

Monday, May 26, 2008

Oracle export and read only Oracle 8i database

When doing a whole database export from a read-only Oracle 8i database, got the following error near the end of exporting:

......
. about to export USERA's tables via Conventional Path ...

. exporting referential integrity constraints

. exporting synonyms

EXP-00008: ORACLE error 1682 encountered

ORA-01682: read-only DB cannot allocate temporary space in tablespace TEMP

EXP-00000: Export terminated unsuccessfully

Oracle exp uses TEMP tablespace while doing the export. So the solution is to open the database in normal mode, change tablespaces to read only except SYSTEM, RBS, RBSBIG and TEMP. Then perform the export.

Oracle parameter audit_trail and "alter database open read only"

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

=================================================================

! Oracle database auditing has to be turned off before altering the database in READ ONLY mode.

1. Got ORA-16006 when running "alter database open read only":

Error: ORA-16006

Text: audit_trail destination incompatible with database open mode

---------------------------------------------------------------------------

Cause: The audit_trail initialization parameter was set to "DB" (or TRUE),

which is incompatible with a database opened for read-only access.

Action: When the database is opened for read-only access, the audit_trail

initialization parameter can only be set to "OS" or "NONE" (FALSE).

2. change the value of audit_trail=none in initnanprod1.ora

audit_trail = none

3. open the database in read only mode

sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Mon May 26 13:26:43 2008

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 178227688 bytes

Fixed Size 104936 bytes

Variable Size 110841856 bytes

Database Buffers 67108864 bytes

Redo Buffers 172032 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open read only;

Database altered.

4. log in as system

create user test identified by aaa;

ORA-00604: error occurred at recursive SQL level 1

ORA-00372: file 1 cannot be modified at this time

ORA-01110: data file 1: '/fs/u01/oracle_data/testdb/system01.dbf'

Tuesday, May 6, 2008

Solaris tip web sites

The following web pages contain very good stuff for Solaris tips.

http://www.pcnetcom.net/solaris.htm: Solaris tips

http://www.columbia.edu/~rtt2101/iaoq/: Solaris Infrequently Asked and Obscure Questions

http://www.bolthole.com/solaris/solaris_hints.html: Solaris hints

/dev/null 2>&1

In UNIX environment, the following situation happens frequently:
script.sh > /dev/null 2>&1

What is this for?

"> /dev/null" means send standard output to the 'bit bucket" or in other words, throw it away.

"2>&1" means "redirect standard error (2) to the same place as standard output (1.)

Friday, March 21, 2008

2008 ESRI Developer Summit (DevSummit)

I went to Palm Springs to attend the 2008 ESRI Developer Summit (DevSummit) this week March 16-20. This is the first time I attended developer summit, and the first time to the United States.

The conference provided tons of information through various sessions. I really enjoyed it.

Session details can be found at the following link. Some powperpoints have been available to download:
Developer Summit 2008 Details

James Fee posted his reflection on the 2008 ESRI Developer Summit (DevSummit):
Reflection on the 2008 ESRI Developer Summit

Since I am not a developer, I really do not have too much interest in those technically detailed coding sessions. But I had the chance to talk with ESRI product engineers and developers about my problems and concerns. They were happy to help and log my issues. Another good thing I enjoyed is the chance to meet those GIS professionals from all over the world and chat about what they are doing with ESRI products.

I liked the Microsoft SQL Server session, which was informative, vivid, interesting, beers, T-shirts, one of the best session I ever had.

Thursday, March 20, 2008

FME Worldwide User Conference 2008

I attended the FME Worldwide User Conference 2008 in Vancouver during March 6-7. It was a very productive event. I enjoyed the sessions.

Safe has post the presentatins on the web: FME USER CONFERENCE PRESENTATIONS.

There are two blog postings:
FME User Conference report
KML Goodness from the FME User Conference

Tuesday, January 22, 2008

SDO_GEOMETRY Layers and -g Option in ArcSDE Commands

“-g” option in some ArcSDE administration commands is used to specify particularities for creating a spatial index, such as “sdelayer -o add”.

For ArcSDE to store geometries in Oracle Spatial’s SDO_GEOMETRY data type, there are three types of spatial indexes: RTREE, FIXED and HYBRID. Oracle and ESRI recommend using RTREE spatial indexes since Oracle 9i. So “-g RTREE” is used in ArcSDE commands that accept “-g” option.

SDO_GEOMETRY layers cannot use the grid-based spatial index used with ArcSDE compressed binary storage.

Examples:

-- load shapefile to a layer of SDO_GEOMETRY
shp2sde -o create -l sdo_layer,shape -f shape_file -a all -g RTREE -e a -u SDE_USER

-- register a SDO_GEOMETRY table as an ArcSDE layer
sdelayer -o register -l sdo_layer,GEOM -e a+ -g RTREE -C OBJECTID,USER -R 2 -i 5151 -s sde_server -u sde_user

Refer to ESRI Technical Article 26511.

Get Area and Length of Features Stored in Oracle Spatial

The area and length of features are not pre-calculated and stored by Oracle’s SDO_GEOMETRY data type constructor functions. SDO_GEOMETRY type does not have places to store area and length values.

Geometric functions SDO_GEO.SDO_AREA and SDO_GEOM.SDO_LENGTH can be used to calculate the values in SQL queries when needed.

-- calculate the area
SELECT OBJECTID, SDO_GEOM.SDO_AREA(SHAPE, 0.005) FROM THE_LAYER;

-- calculate the length
SELECT OBJECTID, SDO_GEOM.SDO_LENGTH(SHAPE, 0.005) FROM THE_LAYER;

0.005 is the tolerance.

Saturday, January 19, 2008

Notes on Auditing in Oracle Database

Notes on Auditing in Oracle Database (10g)

Auditing purposes:
--auditing what kinds of privileges are being used to uncover abuse or misuse of privileges
--auditing what objects are being accessed

Auditing location depending on initialization parameter AUDIT_TRAIL (SYS.AUD$, OS file):
--NONE, FALSE: disable auditing
--OS: enable auditing. Send audit results to an OS file
--DB, TRUE: enable auditing and send to SYS.AUD$
--DB_EXTENDED: enable auditing and send results to SYS.AUD$, store additional info in BLOB columns SQLBIND and SQLTEXT.

Auditing types

1. Statement auditing: audit SQL statements by the type of statement regardless of the specific schema objects being accessed. One or more users can be specified to be audited for a particular statement.

AUDIT sql_statement_clause BY {SESSION ACCESS} WHENEVER [NOT] SUCCESSFUL;
--ACCESS: every time
--SESSION: once, default
--WHENEVER SUCCESSFUL: successful action, statement did not generate an error
--WHENEVER NOT SUCCESSFUL: unsuccessful action, statement fails for insufficient privilege, syntax error, running out of space in the tablespace
--statement option:
--all, includes CLUSTER, CONTEXT, DATABASE_LINK, DIMENSION, DIRECTORY, INDEX, MATERIALIZED VIEW, NOT EXISTS, PROCEDURE, PROFILE, PUBLIC SYNONYM, ROLE, ROLLBACK SEGMENT, SEQUENCE, SESSION, SYNONYM, SYSTEM AUDIT, SYSTEM GRANT, TABLE, TABLESPACE, TRIGGER, TYPE, USER, VIEW.
--explicitly specified statements: ALTER SEQUENCE, ALTER TABLE, COMMENT TABLE, DELETE TABLE, EXECUTE PROCEDURE, GRANT DIRECTORY, GRANT PROCEDURE, GRANT SEQUENCE, GRANT TABLE, GRANT TYPE, INSERT TABLE, LOCK TABLE, SELECT SEQUENCE, SELECT TABLE, UPDATE TABLE

--example 1: audit index by scott
SQL>audit index by scott whenever successful;
SQL>select username, to_char(timestamp, 'MM/DD/YY HH24:MI') timestamp, obj_name, action_name, sql_text from dba_audit_trail where username='SCOTT';
SQL>noaudit index by scott;

--example 2: login audit
SQL>audit session whenever successful;
SQL>audit session whenever not successful;
SQL>select username, to_char(timestamp, 'MM/DD/YY HH24:MI') timestamp, obj_name, returncode, action_name, sql_text from dba_audit_trail where action_name in ('LOGON','LOGOFF') order by timestamp desc;

--example 3: Oracle database startup and shutdown audit
--shutdown immediate in SYS.AUD$
--startup: folder $ORACLE_HOME/rdbms/audit/ (determined by init parameter audit_file_dest)

--example: protect audit trail
SQL>audit all on sys.aud$ by access;

2. Privilege auditing: audit system privileges, such as CREATE TABLE, ALTER INDEX. Can specify one or more particular users as target of the audit.
--audit SYSDBA and SYSOPER privilege:
--set initialization parameter audit_sys_operations=true
--audit OS files sent to audit_file_dest

--example 1: audit every time
SQL>audit ALTER TABLESPACE by access whenever successful;

3. Schema object auditing: audit specific statements operating on a specific schema object (UPDATE). Applies to all users in the database.
--AUDIT schema_audit_clause BY {SESSION ACCESS} WHENEVER [NOT] SUCCESSFUL;
--schema_audit_clause: ALTER, AUDIT, COMMENT, DELETE, FLASHBACK, GRANT, INDEX, INSERT, LOCK, READ, RENAME, SELECT, UPDATE

--example 1:
SQL>audit insert, update on hr.jobs by access whenever successful;

4. Fine-grained auditing (FGA): audit table access and privileges based on the contents of the objects being accessed. DBMS_FGA to set up a policy.
--ADD_POLICY, DROP_POLICY, DISABLE_POLICY, ENABLE_POLICY
--DBA_FGA_AUDIT_TRAIL

--example: audit access to salary column
begin
dbms_fga.add_policy(
object_schema => 'HR',
object_name => 'EMPLOYESS',
policy_name => 'SAL_SELECT_AUDIT',
audit_condition => 'instr(job_id, ''_MAN'') > 0',
audit_column => 'SALARY'
);
end;

Auditing-related dictionary views
AUDIT_ACTIONS
DBA_AUDIT_OBJECT
DBA_AUDIT_POLICIES
DBA_AUDIT_SESSION
DBA_AUDIT_STATEMENT
DBA_AUDIT_TRAIL
DBA_FGA_AUDIT_TRAIL
DBA_COMMON_AUDIT_TRAIL
DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS

Notes:
1. A non-DBA user within an Oracle database cannot enable the auditing features.

2. If auditing has been enabled, there are data dictionary views that anyone can use to view the audit trail.

3. The single audit trail table: SYS.AUD$.

4. USER_AUDIT_TRAIL: all audit records for many different types of actions, many of the columns may be inapplicable for any given row.
USER_AUDIT_OBJECT: for statements concerning objects
USER_AUDIT_SESSION: for connections and disconnections
USER_AUDIT_STATEMENT: for grant, revoke, audit, noaudit, and alter system commands issued by the user

DBA_AUDIT_TRAIL:
DBA_AUDIT_OBJECT: for statements concerning objects
DBA_AUDIT_SESSION: for connections and disconnections
DBA_AUDIT_STATEMENT: for grant, revoke, audit, noaudit, and alter system commands

5. View audit options:
DBA_OBJ_AUDIT_OPTS: describes auditing options on all objects.
USER_OBJ_AUDIT_OPTS: describes auditing options on all objects owned by the current user. This view does not display the OWNER column.
ALL_DEF_AUDIT_OPTS: contains default object-auditing options that will be applied when objects are created.
-/-: no default auditing
S/-: auditing whenever successful
-/S: auditing whenever not successful

6. View commands that can be audited:
AUDIT_ACTIONS: describes audit trail action type codes. This table can be used to map action type numbers to action type names.

7. DBA views without USER counterparts:
DBA_AUDIT_EXISTS:
DBA_PRIV_AUDIT_OPTS:
DBA_STMT_AUDIT_OPTS:
STMT_AUDIT_OPTION_MAP:

Reference: Oracle 10g DBA Handbook

Spatial DBA - Oracle and ArcSDE

Tuesday, May 27, 2008

Oracle dynamic performance views

Oracle data dictionary views