Oracle dictionary and Dynamic View

Dictionary and dynamic view

Oracle dictionary and Dynamic View

The oracle service displays all the system statistics in the v $ sysstat view. It also uses many views to display oracle performance and problematic snapshot information.

You can query these views to find the overall information of the started instance.

The oracle service displays data storage statistics in the DBA_xxx view and can be used to find storage faults (tables, clusters, and indexes)

Utlbstat and utlestat tools

You may need to collect performance characteristics during business time. You can use utlbstata. SQL and utlbstat. SQL scripts. Experienced users can use these two tools to obtain data to optimize the project.

Oracle wait event

If you are troubleshooting the database system, you need to know the waiting processes.

Oracle provides a list of waiting events, and some dictionary views also provide sessions waiting

Oracle diagnosis and optimization package

You can use the graphical interface tool provided by oracle for diagnosis and optimization during optimization. Sample monitoring, analysis, and automatic optimization.

Dictionary and dedicated View

After the analysis command is run, the dictionary and the dedicated view provide useful statistics. For example:

Dba_tables dba_tab_columns dba_clusters dba_indexs, dba_index_stats, index_histogram, dba_histogams.

Below are dynamic snapshots and performance attempts

V $ view v $ fixed_table
X $ tables

The following lists available statistical views.
Database instance information

V $ database
V $ instance
V $ option
V $ parameter
V $ backup
V $ process
V $ waritstat
V $ system_event

Disk Information

V $ datafile
V $ filestat
V $ log
V $ log_history
V $ dbfile
V $ tempfile
V $ tempstat

User and session information

V $ lock
V $ oper_cursor
V $ process
V $ sort_usage
V $ session
V $ sessstat
V $ transaction
V $ session_event
V $ session_wait
V $ px_sesstat
V $ px_session
V $ session_object_cache

Memory Information

V $ buffer_pool_statistics
V $ db_object_cache
V $ librarycache
V $ rowcache
V $ comment
V $ sgastat

Competition information

V $ lock
V $ rollname
V $ rollstat
V $ waitstat
V $ latch

Oracle materialized view creation reports ORA-00942 error resolution

Refresh the materialized view of Oracle stored procedures

Use of Oracle Materialized View

Materialized View for two-way synchronization of Oracle database tables

Oracle materialized view application notes