디버그

[디버그] 티베로에서 TBR-8033: Specified schema object was not found.at line 1, column 50 of null:SELECT /*+ no_outline */ PLAN_HASH_VALUE FROM V$SQL_PLAN WHERE SQL_ID = ? AND ^TBS-70035: Unable to display plan: ch

Dong's Universe 2024. 12. 26. 09:43

sys 계정에서 아래 커맨드 입력

drop role plustrace;
create role plustrace;
grant select on vt_autotracestat to plustrace;
grant select on v$sql_plan to plustrace;
grant select on v$sql_plan_statistics to plustrace;
grant plustrace to dba with admin option;
Grant plustrace to HIFIOWN;

 

Reference


https://novice-data.tistory.com/73

 

[Tibero] PLUSTRACE ROLE 생성

PLUSTRACE ROLE 이란? https://novice-data.tistory.com/71 위 링크의 Excution plan(실행 계획)을 보기 위해서는 V$SQL_PLAN을 확인해야 한다. DBA 권한이 없다면, V$SQL_PLAN 에 대한 접근 권한이 없다. Role 생성은 DBA권한

novice-data.tistory.com