- 博客(3)
- 收藏
- 关注
RSS订阅原创 如何管理undo
如何管理undo 一、监控undo SQL> select file_name from dba_data_files; FILE_NAME -------------------------------------------------------------------------------------------------------------------------
2017-05-02 11:24:29
633
原创 DG swithover
primary操作： SQL> select switchover_status from v$database; SWITCHOVER_STATUS -------------------- SESSIONS ACTIVE SQL> alter database commit to switchover to physical standby with session
2017-05-02 09:29:10
505
转载 undo长事务查询脚本
---创建视图 create or replace view v$sqlarea_total as select sql_id,sql_text from gv$sqlarea union all select sql_id,to_char(SUBSTR(SQL_TEXT,1,4000)) from Dba_Hist_Sqltext; ---创建function CREATE
2017-05-02 09:27:07
498
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人