Oracle Course archive, day sixth

Architecture:

Instance: Example

Database: Databases

RAC: Multi-instance to one database

SGA: Maximum total (System global Zone) buffers

PGA: One of these is also a buffer

Server process: Servers processes

Shared pool: Share value (execution plan for maximum SQL statement) ★

Sql> Show parameter display parameters ★

Sql> Show SGA Display settings for SGA ★

Sql> SELECT * FROM v$sgainfo: Dynamic performance View ★

Butter cache: Buffer buffers (database cache, blocks read into memory)

Sql> Show parameter db_block_size; Blocks Size BLOCK: block

Sql> Show parameter db_cache_size; The size of the buffer

DataFile: Data files

Old Image: Older image

Redo Log Buffer (write the new image log here)

New Image: A fresh look

Show parameter Log_buffer; View the size of the log

Large pool: Big pond

Description

Select Name,description from v$bgprocess where paddr<> ' 00 '; Querying background processes

Ora_, you want to check the _ORCL OS fixed mode

Commit: Commit. End

Background process:
Sql> select name from v$bgprocess where paddr<> ' 00 ';
Sql>! Ps-ef | grep Ora_
Sql> Show Parameter db_writer_processes

Data files: ★
$ ll/u01/app/oracle/oradata/orcl/*.dbf
Sql> select name from V$datafile;
Sql> select name from V$tempfile;

Control File: ★
$ Find/u01-name ' Control0[12].ctl '
Sql> select name from V$controlfile;
Sql> Select TYPE, Record_size, Records_total, records_used from V$controlfile_record_section;

Redo LOG: ★
$ ll/u01/app/oracle/oradata/orcl/*.log
Sql> Select group#, member from V$logfile;

Parameter file:
$ ll $ORACLE _home/dbs/spfile*.ora
$ Strings $ORACLE _home/dbs/spfileorcl.ora
Sql> Show parameter SPFile;
Sql> Show parameter

Password file:
$ ll $ORACLE _home/dbs/orapw*

Archive log:
Sql> select name from V$archived_log;

Warning LOG:
$ Find/u01-name ' Alert_*.log

Oracle Course archive, day sixth