When I use the Database Probe on an 11g database, it seems to get stuck on the "Querying SGA" step. It just says "Querying SGA" in the bottom left portion of the window and the green progress bar continues to run on the right side.
Run statistics on the 11g database. You can run statistics by executing the following statements.
exec dbms_stats.gather_dictionary_stats;
exec dbms_stats.gather_fixed_objects_stats;
Note the SGA will need to be flushed for the above commands to take effect immediately.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center