Oracle First Step

Oracle Startup Database

Startup [nomount| Mount| open| Force] [Restrict] [pfile=filename]

Launch the instance, load the database, start the database

Oracle shuts down the database

Shutdown [Immediate|normal|trasanctional|abort]

Close the database, unload the database, close the instance

Select * from V$parameter;

Data File V￥datafile

Control file V$contrlfile

Log file V$logfile

Database internal system table V$fixed_view_definition

Show server parameters using show parameter

Query view V$parameter, which uses the dynamic performance view to determine whether the default value of the parameter has been modified and whether it can be modified with the ALTER SYSTEM and ALTER session commands.

Alter System Set db_block_size=8096

Password file

The password file is stored by default in the directory Databas directory, the password File command format is pwd<sid>, where SID is the instance name, creating a password file can either be created automatically when the DB instance is created, or it can be created manually using the Orapwd.exe tool.

Orapwd file-filename password=xxxx entries=<max-users>

Password file name, Internal/sys account password allows the maximum number of users to log in to the database with/SYSDBA/SYSOPR permissions.

Warning log files are used to store running information and error messages for the database's system.

Parameter name Background_dump_dest.

Y User trace file path

User_demp_dest

File name <sid>_ora_<spid>.trc

The background process trace file path is initialized to Background_dump_dest.

File name <sid>_<process_name>_<spid>.trc

System global Zone, is a memory area shared by all user processes, that is, the data resources in the SGA can be used by multiple users, the SGA mainly includes high-speed data flooding, shared pools, VC red do log buffers, Java pools and large pools and other memory structures, with the database boot two loaded into memory,

Oracle data dictionary.

Oracle Main Process

Sqlplus command Line

Help Index view command list

Help | Set [Topic]

Help |? [Topic]

Spool filename Create|replace|append|off|out

Saves the record to the specified file.

Spool off End

End of file is only written after using spool off/spoolout

Spool C:\txt

Select * from User_objects;

Spool off

Select * from User_objects;

Save C:\TXTX

Clear buffer Buffers

Get file List\nolist

Loading files into the cache

/execute

Column format col_name ailias SSS

Col heading xx aaaa

Ttitile/btitile

Col comm Null "Text"

Oracle First Step