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

At the end of the year, the performance health check of the responsible database is hereby recorded.

* os layer check

# check the oracle process

Ps-ef | grep ora | wc-l

Crs_stat-t-v

Top

Glance

Crsctl check cluster (cssd)

Vmstat 3600 6

* View basic information

# database profile information check

# check the basic information of database

Select * from v$version

Select name, open_mode,log_mode from v$database

Select instance_number,instance_name, status from gv$instance

Show parameter cpu_c

Show parameter block_size

Select group#,thread#,members,bytes/1024/1024 from gv$log

Show sga

Select count (*) from v$controlfile

Select count (*) from v$tempfile

Select count (*) from v$datafile

* * View data file information

# check tablespace data file information

Col tablespace_name for a30

Select tablespace_name, sum (bytes) / 1024 plus 1024 from dba_temp_files group by tablespace_name

# check tablespace

SELECT TABLESPACE_NAME,EXTENT_MANAGEMENT,ALLOCATION_TYPE,SEGMENT_SPACE_MANAGEMENT FROM DBA_TABLESPACES

# check the status of the data file

Select count (*), status from v$datafile group by status

# check tablespace usage

Select

F.tablespace_name

A.total

F.free, (a.total-f.free) / 1024 "used SIZE (G)"

, round ((f.free/a.total) * 100) "% Free"

From

(select tablespace_name, sum (bytes/ (1024-1024)) total from dba_data_files group by tablespace_name) a

(select tablespace_name, round (sum (bytes/ (1024-1024) free from dba_free_space group by tablespace_name) f

WHERE a.tablespace_name = f.tablespace_name (+)

Order by "Free"

/

# query temporary segment usage

COL username FORMAT a10

COL segtype FORMAT a10

SELECT username, segtype, extents "Extents Allocated"

, blocks "Blocks Allocated"

FROM v$tempseg_usage

# View the information of data files. If there are more files, you can sort and output top 10 according to the required fields.

SELECT fs.phyrds "Reads", fs.phywrts "Writes"

, fs.avgiotim "Average Imax O Time", df.name "Datafile"

FROM v$datafile df, v$filestat fs WHERE df.file# = fs.file#

# check all the data files iCompo. If there are too many files, you can rewrite them to top 10 select * (order by xx desc) where rownum.

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.