Oracle
莫薇
荆棘之上仰望的人会看透风尘
展开
-
sql优化
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...原创 2019-02-25 21:45:09 · 234 阅读 · 0 评论 -
oracle日常运维
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;--解开...原创 2019-02-25 21:41:02 · 12130 阅读 · 0 评论 -
ORA-23421: 作业编号在作业队列中不是一个作业
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);原创 2019-02-25 21:46:35 · 3014 阅读 · 0 评论 -
物化视图调优
物化视图跑的慢DROP 物化视图日志;DROP 物化视图;CRAETE 物化视图日志;CREATE 物化视图;是不是有碎片select * from v$session_longops ab where ab.SID='5005' and ab.SERIAL#='7425';select * from dba_mview_logsselect bytes/1024/1024/102...原创 2019-02-25 21:39:24 · 383 阅读 · 0 评论 -
ORA-38760: This database instance failed to turn on flashback database
SYS@d3vip> startup ORACLE instance started.Total System Global Area 8589934592 bytesFixed Size 7663544 bytesVariable Size 5335154760 bytesDatabase Buffers...原创 2019-02-25 21:46:43 · 1373 阅读 · 0 评论 -
Oracle 闪回日志
闪回,读的是undo表空间 ======================闪回日志===================================SQL> show parameter undoNAME TYPE VALUE---------------------...原创 2019-02-25 21:42:13 · 1539 阅读 · 0 评论 -
oracle数据文件大小
Oracle数据文件的大小原创 2019-02-25 21:46:53 · 1264 阅读 · 0 评论 -
等待事件
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;原创 2019-02-25 21:40:27 · 191 阅读 · 0 评论