oracle 常用的一些sql
--
set wrap off
set linesize 300
set autocommit on
--
select * from V$bgprocess;
select * from V$controlfile;
select * from V$datafile;
select * from V$logfile;
select * from v$pwfile_users;
select * from v$system_parameter;
--
show parameter shared
show parameter db_cache
show parameter log
show parameter db
show parameter log_buffer
show sga
------
select * from authors;
-------
alter system set db_cache_advice=on;
alter system set large_pool_size=20M;/error
---
grant sysdba to kong;
revoke sysdba from kong;
---
shutdown immediate
startup
---
SELECT * FROM DBA_OBJECTS
---
help index
@G:\database\oracle\orahome92\sqlplus\admin\help\hlpbld.sql
helpus.sql
