Here, you will start learning OARCLE's powerful SQL query.
Workers must be good,
1.SQL * Plus Worksheet with SQL * Plus
SQL * Plus Worksheet is a bit similar to the query analyzer in MS SQL Server, but compared to the SQL * Plus Worksheet function.
SQL * Plus is a query of the command line mode. Unix users may habit this.
2. Create a database
example:
Create Database $ {ORACLE_SID} - SiD Database User Sys Identified by Sys --sys User and Default Password User System Identified by System --System User and Default Password Logfile Group 1 ('$ {Oracle_Base} / ORADATA / $ { Oracle_sid} /redo01.log ') Size 10M, Group 2 (' $ {Oracle_Base} / oradata / $ {oracle_sid} /redo02.log ') Size 10M, Group 3 (' $ {Oracle_Base} / oradata / $ {oracle_sid} /REDO03.log ') Size 10M - log files (redo) MaxLogfiles 5 MaxLogmembers 5 MaxLoghistory 1 maxdatafiles 254 - Maximum Database File MaxInstances 1 - Max Database Instance ArchiveLog Character Set ZHS16GBK National Character Set Al16UTF16
DataFile - Data File '$ {Oracle_Base} / ORADATA / $ {Oracle_sid} /system01.dbf' size 300m Default Temporary TableSpace TBSTEMP TEMPFILE - Temporary Table Space
'$ {ORACLE_BASE} / oradata / $ {ORACLE_SID} /temp01.dbf' size 500M undo tablespace tbsundo datafile - rollback tablespace '$ {ORACLE_BASE} / oradata / $ {ORACLE_SID} /undo01.dbf' size 500M;
3.Show parameter command
Show paramert is displayed
Show parameter sql_version
SHOW parameter db_cache_size
Show Parameter SGA_MAX_SIZE
4
Control file information can be obtained from V $ ControlFile;
Select Name from V $ dataFile; view data file;
View the log group through V $ log, V $ logfile can view the specific member file;
You can view the information of the archive log file via V $ Archived_log and V $ log_history;
You can query the current parameter settings via the V $ Parameter view.
