How to Enable AUTOTRACE
Enable AUTOTRACE To get full AUTOTRACE feature in your session, you should take the following steps. Need PLAN_TABLE table to be accessed in user's schema.… Read More »How to Enable AUTOTRACE
PLUSTRACE
How to Install PLUSTRACE Role
PLUSTRACE Before enabling AUTOTRACE feature in your session, you not only need to create PLAN_TABLE table, but also need PLUSTRACE role, which is not native… Read More »How to Install PLUSTRACE Role
How to Install PLAN_TABLE Table
PLAN_TABLE Before enabling AUTOTRACE feature in your session, you not only need PLUSTRACE role to be installed, but also need to create PLAN_TABLE table, which… Read More »How to Install PLAN_TABLE Table
How to Resolve ORA-01919: role does not exist
ORA-01919 ORA-01919 means that Oracle cannot find any privilege you specified, so it turned to search for the name in roles, but still no luck.… Read More »How to Resolve ORA-01919: role does not exist