Shulou(Shulou.com)06/01 Report--

1. Check the name and archive status of the database

SQL > select name,log_mode from v$database

2. Check the instance name and status of the database

SQL > select instance_name,status from v$instance

3. View the name, status and management of the tablespace

SQL > select tablespace_name,status,extent_management from dba_tablespaces

4. View the location and name of the control file

SQL > select name from v$controlfile

5. View the group name, number of members, status and size of the log file

SQL > select group#,members,bytes,status from v$log

6. View the location of the log file

SQL > select group#,member from v$logfile

7. View the location and size of the data file

SQL > select name,bytes from v$datafile

8. View the objects and types owned by the user

SQL > select object_name,object_type from dba_objects where owner='SCOTT'

9. View the information of temporary files

SQL > select name,bytes from v$tempfile

10. View archive log information

SQL > select name, FIRST_CHANGE#,next_change# from v$archived_log

Dynamic performance View:

one

V$datafile

Data file information used by the database

two

V$librarycache

Governance information of sql statements in a shared pool

three

V$lock

Information about the lock

four

V$log

Extract information about redo log groups from the control file

five

V$logfile

Information about log group files

six

V$parameter

Parameters.

seven

V$process

Current process information

eight

V$rollname

Rollback segment information

nine

V$rollstat

Statistics of rollback segment of connected machine

ten

V$rowcache

In-memory data dictionary activity / performance information

eleven

V$session

Information about the active session

twelve

V$sesstat

Report statistics for the current session in V$session

thirteen

V$sqlarea

Information about using the current cursor in a shared pool

fourteen

V$statname

The meaning of the statistics reported in V$sesstat

fifteen

V$sysstat

System statistics based on the current operation session

sixteen

V$waitstat

Waiting for relevant information

About the dba view:

one

Dba_data_files

Information about database files

two

Dba_db_links

All database links in the database

three

Dba_extents

Include all partitions in the database

four

Dba_free_space

Free partitioning in all tablespaces

five

Dba_indexes

Description of all indexes in the database

six

Dba_ind_columns

Columns that compress indexes on all tables and clusters

seven

Dba_objects

All the objects in the database

eight

Dba_rollback_segs

Description of the rollback segment

nine

Dba_segments

Storage space allocated for all database segments

ten

Dba_sequences

Description of all sequence books in the database

eleven

Dba_synonyms

All synonyms in the database

twelve

Dba_tables

Description of all tables in the database

thirteen

Dba_tablespaces

Description of all tablespaces in the database

fourteen

Dba_tab_columns

Columns for all table descriptions, views, and clusters

fifteen

Dba_tab_grants

Permissions granted by objects in the database

sixteen

Dba_tab_privs

Permissions granted by objects in the database

seventeen

Dba_ts_quotas

All user tablespace limits

eighteen

Dba_users

All user information about the database

nineteen

Dba_views

All views in the database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.