jing_flower的博客

sql优化 ================================================================== 1.查找索引 SELECT m.table_owner,m.index_name,n.COLUMN_POSITION,n.COLUMN_NAME,m.distinct_keys,m.num_rows from dba_indexes m,dba_i...

1.解锁用户 select username,account_status from dba_users b where b.username=upper('<username>'); alter user <username> account unlock; --解锁 alter user <username> identified by sh;--解开...

select job from dba_jobs; select a.PRIV_USER from dba_jobs a where a.JOB=67; PRIV_USER ------------------------------ PATA 非当前用户 EXEC SYS.DBMS_IJOB.BROKEN(67, FALSE);  

物化视图跑的慢 DROP 物化视图日志； DROP 物化视图； CRAETE 物化视图日志； CREATE 物化视图； 是不是有碎片 select * from v$session_longops ab where ab.SID='5005' and ab.SERIAL#='7425'; select * from dba_mview_logs select bytes/1024/1024/102...

SYS@d3vip> startup            ORACLE instance started. Total System Global Area 8589934592 bytes Fixed Size                  7663544 bytes Variable Size            5335154760 bytes Database Buffers...

闪回，读的是undo表空间     ======================闪回日志=================================== SQL> show parameter undo NAME TYPE VALUE ---------------------...

Oracle数据文件的大小

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 desc;