??SGA??

ALTER SYSTEM SET shared_pool_size=64M;ALTER SYSTEM SET db_cache_size=64M;ALTER SYSTEM SET large_pool_size=64M;

??SGA??

• ????????????????SQL????
• ????????????????????
• ???????????????????????
• ?????????Java????????????

?????

startup nomountstartup mount dbnamestartup open dbname

• startup nomount????SGA??????????
• startup mount dbname?????????????????
• startup open dbname???????????????

?????

shutdown immediateshutdown normal

• shutdown immediate????????????????
• shutdown normal??????????????????

??????

ALTER DATABASE ADD REDO LOG;ALTER DATABASE DROP REDO LOG;

????

CREATE USER username IDENTIFIED BY password;ALTER USER username IDENTIFIED BY new_password;

???????

lsnrctl startlsnrctl statuslsnrctl stop

• ??????lsnrctl start
• ????????lsnrctl status
• ??????lsnrctl stop

????

net start OracleServiceOrcl

• ???????sqlplus /@testdb as sysdba

??????

emctl start dbconsole

• ??????http://localhost:1158/em/

???????

SHOW ALLSET SERVEROUTPUT ON

???????????

• ??startup nomount????????????
• ??startup mount dbname?????????
• ??startup open dbname??????????

???????

ALTER DATABASE RECOVER;ALTER DATABASE RENAME FILE; -- ?????

?????

CREATE TABLESPACE backup_table AS SELECT * FROM users;