- 博客(5)
- 收藏
- 关注
翻译 闪回技术11g
SQL> GRANT FLASHBACK ON employees TO salapatiGrant succeeded.SQL>Or you could use a statement like this:SQL> GRANT FLASHBACK ANY TABLE TO salapati;Grant succeeded.SQL>You can grant
2013-07-27 11:56:34 343
翻译 数据库中最长的查询语句
SQL> SELECT MAX(maxquerylen) FROM v$undostat;MAX(MAXQUERYLEN)---------------- 210
2013-07-25 22:29:10 679
转载 DG 检查
SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;(主库执行)正常的时候LNS: Standby redo logfile selected for thread 1 sequence 1171 for destination LOG_ARCHIVE_DEST_2LNS: Standby redo logfile selected for thre
2013-07-20 16:04:14 730
翻译 block session
SYS@sales 2013-07-16 23:30:21> select username,blocking_session,blocking_session_status from v$session where blocking_session_status='VALID';USERNAME BLOCKING_SESSION BLOCKING_SE--
2013-07-16 15:45:52 807
翻译 当前session id
HR@sales 2013-07-16 23:30:38> select userenv('sid') from dual;USERENV('SID')-------------- 27HR@sales 2013-07-16 23:31:06>
2013-07-16 15:43:16 373
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人