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