数据库oracle常用命令(3)

%vi .cshrc 修改PATH行在该行添加如下内容： :$ORACLE_HOME/Opatch: %cd 6650132 %opatch apply opatch version opatch lsinventory vi $ORACLE_HOME/bin/dbshut "6") sqldba command=shutdown immediate;; 以root用户登录实际物理库所在主机，执行下面操作 $mkdir -p /ba

ckup/bin $mkdir -p /backup/log $/backup/bin目录放置备份脚本程序 SELECT S.SID SESSION_ID, ERNAME, DECODE(LMODE, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR(LMODE)) MODE_HELD, DECODE(REQUEST, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR(REQUEST)) MODE_REQUESTED, O.OWNER||'.'||O.OBJECT_NAME||' ('||O.OBJECT_TYPE||')', S.TYPE LOCK_TYPE, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2 FROM V$LOCK L, SYS.DBA_OBJECTS O, V$SESSION S select owner,table_name, NUM_ROWS,BLOCKS*db_block_size /1024/1024 "Size M", EMPTY_BLOCKS, LAST_ANALYZED from dba_tables ; select sum(bytes)/(1024*1024) as "size(M)" from user_segments where segment_name=upper('&table_name'); select sum(bytes)/(1024*1024) as "size(M)" from user_segments where segment_name=upper('&index_name'); select * from v$version SELECT * FROM V$INSTANCE; SELECT * FROM V$PARAMETER WHERE NAME LIKE 'proc%'; 或者show parameter processes select * from v$license; alter system set processes=500 scope=spfile; SQL>SET AUTOTRACE ON ; SQL>SELECT * FROM TABLE; OR SQL>SELECT * FROM v$filestat ; SELECT b.tablespace, b.segfile#, b.segblk#, b.blocks, a.sid, a.serial#, ername, a.osuser, a.status FROM v$session a,v$sort_usage b WHERE a.saddr = b.session_addr ORDER BY b.tablespace, b.segfile#, b.segblk#, b.blocks ; select /*+ ORDERED */ sql_text from v$sqltext a where a.hash_value = ( select sql_hash_value from v$session b where b.sid = &sid and b.serial# = &serial) order by piece asc ; select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order by 4; select * from v$session_longops select name, waits, gets, waits/gets "Ratio" from v$rollstat C, v$rollname D where n = n; select B.tablespace_name name,B.file_name "file",A.phyrds pyr, A.phyblkrd pbr,A.phywrts pyw, A.phyblkwrt pbw from v$filestat A, dba_data_files B where A.file# = B.file_id order by B.tablespace_name; select substr(C.file#,1,2) "#", substr(,1,30) "Name", C.status, C.bytes, D.phyrds, D.phywrts from v$datafile C, v$filestat D where C.file# = D.file#;

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说医药卫生数据库oracle常用命令(3)在线全文阅读。