[디버그] 티베로에서 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
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(실행 계획)을 보기 위해서는 VSQLPLAN을확인해야한다.DBA권한이없다면,VSQL_PLAN 에 대한 접근 권한이 없다. Role 생성은 DBA권한
novice-data.tistory.com
'디버그' 카테고리의 다른 글
[디버그] TBR-12033 : Lock acquisition failed in NOWAIT mode. (0) | 2025.01.09 |
---|---|
[디버그] authorization required but no authorization protocol specified xhost: unable to open display: 0 (0) | 2024.12.17 |
[디버그] Vue 뒤로가기가 안될때 (0) | 2024.05.22 |
[디버그] myBatis resultMap 사용시 주의사항 (0) | 2024.05.18 |
[디버그] 스프링 시큐리티 + CORS (0) | 2024.05.11 |