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#;