Oracle³£ÓÃÃüÁî

1. ÐÞ¸Äredo log file´óС
SQL> select group#,status from v$log;
SQL> alter database add logfile group 4 'F:\oracle\product\10.2.0\oradata\orcl\REDO04.LOG' size 512m;
SQL> alter system switch logfile;
SQL> select group#,status from v$log;
2. ÐÞ¸Älarge_pool_size´óС
SQL> alter   system   set   large_pool_size=150m   scope=both;
3. ²é¿´oracle°æ±¾
select * from product_component_version;
4. ²é¿´ËùÓÐdirectory
select * from dba_directories;
5. ´´½¨Ò»¸ödirectory
create directory dmpdir as 'c:\temp\dump';
GRANT READ,WRITE ON DIRECTORY dmpdir to system;
6. ɾ³ýdirectory
drop directory dmpdir
6. È·ÈÏÒÑÓеıí¿Õ¼ä
select a.TS# ,a.NAME , b.NAME from v$tablespace a,v$datafile b where a.TS# = b.TS#;