
P281
ʼ
CONN  sys/syspwd@orcl AS SYSDBA 
SHOW PARAMETER db_block_size
CONN  sys/syspwd@orcl AS SYSDBA 
SELECT name,value FROM v$parameter WHERE name='db_cache_size';
CONN scott/tiger@orcl
ALTER SESSION SET nls_date_format='yyyy-mm-dd';
SELECT sysdate FROM dual;
CONN sys/syspwd@orcl AS SYSDBA 
ALTER SYSTEM SET utl_file_dir='d:\data' SCOPE=MEMORY;

P284
11.1
CONNECT sys/syspwd@orcl AS SYSDBA
SHUTDOWN IMMEDIATE
CONN / AS SYSDBA
STARTUP PFILE = C:\oracle\product\10.2.0\db_1\database\initorcl.ora

P287
11.2
CONN / as sysdba
SHUTDOWN IMMEDIATE
STARTUP NOMOUNT
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
CONN scott/tiger@orcl
CONN / AS SYSDBA
ALTER SYSTEM DISABLE RESTRICTED SESSION;
CONN scott/tiger@orcl
SELECT * FROM dept;

P291
11.3
CONN sys/syspwd@orcl AS SYSDBA
SELECT * FROM V$LOGFILE;
ALTER DATABASE ADD LOGFILE GROUP 4 
  ('%ORACLE_BASE%\oradata\orcl\redo4_1.log', 
   '%ORACLE_BASE%\oradata\orcl\redo4_2.log') size 20M;
SET  LINESIZE 100
COL member FORMAT A60
SELECT * FROM V$LOGFILE ORDER BY group#,member;
 
P292
11.4 
ALTER DATABASE ADD LOGFILE MEMBER 
  '%ORACLE_BASE%\oradata\orcl\redo4_3.log' TO GROUP 4;
ALTER DATABASE ADD LOGFILE MEMBER '%ORACLE_BASE%\oradata\orcl\redo4_4.log'
  TO ('%ORACLE_BASE%\oradata\orcl\redo4_1.log',
      '%ORACLE_BASE%\oradata\orcl\redo4_2.log',
      '%ORACLE_BASE%\oradata\orcl\redo4_3.log');
SET  LINESIZE 100
COL member FORMAT A60
SELECT * FROM V$LOGFILE ORDER BY group#,member;
ALTER DATABASE DROP LOGFILE
  MEMBER '%ORACLE_BASE%\oradata\orcl\redo4_4.log';
ALTER DATABASE DROP LOGFILE GROUP 4;

