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

Catalogue

one。 Database basic status and information 4

two。 Database parameter information 4

2.1 Common parameters 4

2.2 Common implied parameters 5

three。 Database objects and backup Information 5

3.1 Database object Information 5

3.2 invalid object 5

3.3 large table TOP10 5

3.4 Database backup information 5

four。 Database file information 6

4.1 Tablespace information 6

4.2 data file information 6

4.3 temporary file information 6

4.4 Control file information 6

4.5 Control File limits 6

4.6 Log file information 7

4.7 Roll back Segment 7

4.8 filing frequency 7

4.9 Parameter file directory 7

5.0 listening files 7

five。 Database connection Information 8

six。 Database resource limit 9

seven。 Database permissions 9

eight。 Database high water level 10

nine。 Performance 10

9.1 TOP SQL Information 10

9.2 wait for event 10

9.3 Database load in each time period 10

9.4 View system statistics 11

ten。 Database alarm log information 11

eleven。 Database Patch Information 11

twelve。 Operating system Info 12

thirteen。 Inspection script 12

one。 Basic status and information of database

DBID

961602659

NAME

CJCDB01

VERSION

11.2.0. 4. 0

LOG_MODE

ARCHIVELOG

CREATED

2020-6-13 6:28:51

Startup time

2020-6-14 20:08:37

Running time

0 days 5 hours 0 minutes 50 seconds

STATUS

OPEN

Architecture

Single instance

two。 Database Parameter Information 2.1 Common parameters

2.2 Common implied parameters

three。 Database objects and backup Information 3.1 Database object Information

User name

Size

Table

Indexes

Temporary watch

View

Stored procedure

Trigger

J ob

Failure

CJC

270.43G

6363

6642

one hundred and fifty seven

one hundred and eight

four

0

0

0

CHEN

2.35G

5821

9213

seven

ninety-eight

three

0

0

0

3.2 invalid object

3.3 large table TOP10

3.4 Database backup information

Backup

EXPDP

Backup start time

Backup time

RMAN

Backup start time

Backup time

CJC

116.3G

22:00

91min

285.81G

01:00

24min

CHEN

1.25G

23:31

6min

four。 Database file information 4.1 tablespace information

4.2 data file information

4.3 temporary file information

4.4 Control file information

4.5 Control File limits

MAXLOGFILES

sixteen

MAXLOGMEMBERS

three

MAXDATAFILES

one hundred

MAXINSTANCES

eight

MAXLOGHISTORY

2 92

4.6 Log file information

4.7 rollback segment

4.8 filing frequency

4.9 Parameter file directory

5.0 listening for Fil

-listener.ora

-tnsname.ora

five。 Database connection information

six。 Database resource limit

seven。 Database permissions

Role

System permissions

Table permissions

Column permissions

eight。 Database high water level

nine。 Performance 9.1 TOP SQL Information

9.2 waiting event

……

9.3 Database load in each time period

9.4 View system statistics

ten。 Database alarm log information

[oracle@cjcos01 samples] $cd / u01/app/oracle/diag/rdbms/cjcdb01/cjcdb01/trace/

[oracle@cjcos01 trace] $vim alert_cjcdb01.log

eleven。 Database patch information

[oracle@cjcos01 OPatch] $pwd

/ u01/app/oracle/product/11.2.0/dbhome_1/OPatch

[oracle@cjcos01 OPatch] $. / opatch lsinventory

twelve。 Operating system information

Project

Value

Operating system name

Microsoft Windows Server 2012 R2 Standard

System name

Cjcos01

System manufacturer

Vmware,Inc.

System model

VMware Virtual Platform

Processor

Intel (R) Core (TM) i5-8265U, 1 CPU

Physical memory

2G

Disk space

/ dev/sda3 48G 23G 23G 51% / 13. Inspection script

For the contents of the inspection, see my blog column "Oracle daily operation and maintenance-summary of common scripts"

Script link: http://blog.itpub.net/29785807/viewspace-2698290/

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

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.