Getting differences between users when they are querying the same object (procedures) with the same users.
The Spool SQL shows that one Toad queries dba_procedures and the other queries all_procedures instead.
Why does Toad query different tables?
Option View | Toad Options | StartUp |Check for Access to DBA views is checked in one Toad and it is not in the other.
Please go to View | Toad Options | StartUp and, on the right pannel, select or unselect the checkbox "Check for Access to DBA views".
We recommend to check this opton if you have access to the DBA views. At session startup, Toad will see if DBA views are available to that particular user schema. If so, Toad will query the Oracle Dictionary using the DBA views instead of the ALL views. DBA views are much faster than ALL views because the DBA views do not have the security checks. No security checks means faster queries.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center