기본 콘텐츠로 건너뛰기

dbms_xplan 권한 부여


GRANT SELECT ON V_$SESSION TO SCOTT;
GRANT SELECT ON V_$SQL TO SCOTT;
GRANT SELECT ON V_$SQL_PLAN TO SCOTT;
GRANT SELECT ON V_$SQL_PLAN_STATISTICS_ALL TO SCOTT;

라벨:

댓글

댓글 쓰기

이 블로그의 인기 게시물

redo log list

-------------------------------------------------------------------------------- SELECT GROUP#, STATUS, TYPE, MEMBER, IS_RECOVERY_DEST_FILE   FROM GV$LOGFILE  ORDER BY GROUP#, MEMBER; -------------------------------------------------------------------------------- SELECT *   FROM V$LOG  ORDER BY GROUP#; -------------------------------------------------------------------------------- SELECT A.GROUP#, A.MEMBER, B.STATUS, B.BYTES/1024/1024 AS MBytes   FROM V$LOGFILE A, V$LOG B WHERE A.GROUP# = B.GROUP#  ORDER BY A.GROUP#, A.MEMBER; -------------------------------------------------------------------------------- SELECT *   FROM V$LOG_HISTORY  ORDER BY SEQUENCE# DESC; --------------------------------------------------------------------------------
댓글 쓰기
자세한 내용 보기