3月24日廣州DBA課程筆記

sqlplus / as sysdba

select host_name,instance_name from v$instance;

set ORACLE_SID=oracle

select username,account_status from dba_users;

alter user scott account unlock;

alter user scott identified by tiger;

select * from tab;

desc dept

set line 200
set pagesize 200

l a c del i edit ed
define _editor=vi
save c:emp.sql
get c:emp.sql
@ c:emp
spool c:emp.txt
select * from emp;
spool off

select 'select count(*) from '||tname||';' from tab;

D:oracleproduct10.2.0db_1installportlist.ini

isqlplusctl start|stop
http://192.168.0.1:5560/isqlplus/

emctl start|stop dbconsole
http://192.168.0.1:1158/em

select sql_text from v$sqlarea where sql_text like '%from scott.emp%';

var a number
exec :a=7900
select sql_text from v$sqlarea where sql_text like '%from scott.emp%';

show parameter pool
show parameter cache

select pool,sum(bytes)/1024 k from v$sgastat
group by pool;

select name,pool,bytes from v$sgastat where pool is null;

alter system set sga_target=0 scope=spfile;
alter system set shared_pool_size=80m scope=spfile;
alter system set db_cache_size=48m scope=spfile;

startup force
alter system set sga_target=160m;

[@more@]