디버그
[디버그] 티베로에서 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