Oracle- memorized by rote

Lsnrctl start netca name enables listening

Startup enables an instance

Shutdown immediate shuts down the instance

Netca create links, etc.

Dbca creates a database

Select * from* View

Alter user name account unlock unlocked user

Alter user name identified by password change password

Grent connect/ link permissions / resource/ additions, deletions, modifications, queries, etc. / dba/ database management on library name. Indicate who to @ IP identified by password

Create tablespace tablespace name

Datafile'/ opt/.dbf' specifies the tablespace file location

Size 10m autoentend on automatic growth

Alter tablespace tablespaces add files in space

Add datafile

'/ opt.dbf' size 20m

Autoextend on turns on automatic growth

Alter tablespace tablespace read only/ read-only write/ read-write set space permissions

Drop tablespace space name including contents delete space

Create user user name

Identified by password

Default tablespace tablespace name

Temporary tablespace temporary space

Quota unlimited on space names have no space restrictions.

Password expire login for the first time to change the password

Oracle Architecture SGA PGA UGA

SGA has shared pool data buffers, log buffers

Shared pools directly affect overall performance

Compile and analyze the syntax, make up of library cache and data dictionary, and cache statements

Data buffer

Save data and improve reading speed in memory

Log buffer

Record a log, and when a rule is reached, it will be written to the log file

Daichi

Used for backup and restore of a large amount of data

Java Pool

Used to process java instructions

When writing data to text, logging needs to go through the background process of the system

PMON automatically cleans up the failure process, releases resources, and so on

SMON replies to the free space occupied by the failed startup of the instance

DBWR manages the data buffer and writes to the

LGWR manages log buffers, writing to log files

CKPT ensures the synchronization of data files and log files

Sys is a super user.

System is the database administrator.