[Db Admin] 2.Using administration Tools

* Server Manager Commands
 

Command	Description
EXIT	Exits Server Manager line mode or closes a SQL Worksheet
REMARK	Enters a comment, typically in SQL script files
SET	Sets or changes characteristics of the current command line mode session
SHOW	Shows settings currently in effect
SPOOL	Enables or disables spooling of output to a specified file
CONNECT/  DISCONNECT	Connects to or disconnects from a database
DESCRIBE	Describes a function, package, package body, procedure, table, object,  or view
EXECUTE	Executes a one-line PL/SQL statement
SHOW  ERRORS	Shows the errors generated from the last compilation of a procedure,  package, or function
SHOW  PARAMETER	Displays the current values for one or more initialization parameters
SHOW SGA	Displays information about the SGA of the current instance
CONNECT/AS SYSDBA	Enables privileged connection to the database
ARCHIVE LOG	Starts or stops automatic archiving of online redo log files, manually  archives specified redo log files, or displays information about redo  log files
RECOVER DATABASE	Performs media recovery on one or more tablespaces, one or more,  or the entire database
STARTUP/  SHUTDOWN	Starts up or shuts down a currently running Oracle instance

---

[ Lab ]

---

1. Database buffer cache의 크기는 얼마입니까?
$ svrmgrl
SVRMGR> connect system/manager
SVRMGR> show sga

2. SGA(System Gloval Area)의 크기는 얼마입니까?
SVRMGR> show sga

3. data dictionary view DBA_TABLES의 OWNER, TABLE_NAME, TABLESPACE_NAME열을 나열하고 출력을 포맷하십시오. (10개 정도의 데이터이면 충분합니다.)
SVRMGR> select owner, table_name, tablespace_name
     2  from dba_tables
     3  where rownum < 10 ;

4. Server Manager를 시작하고 출력파일 para.lst에 모든 초기화 매개변수와 설정되어 있는 값을 spool하십시오.
SVRMGR> connect system/manager
SVRMGR> spool para.lst
SVRMGR> show parameter
SVRMGR> spool off

5. $ORACLE_HOME/LABS/scott.sql을 실행하십시오.
SVRMGR> @?LABS/scott  --> ?: $ORACLE_HOME