发表于: 2007.04.05 08:51
分类: Oracle EBS 11i
出处: http://bomei.itpub.net/post/16555/277473
---------------------------------------------------------------
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
<n> 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;
