CODEWITHSUNDEEP
oracle-databaseoracle10goracle-sqldeveloper
Below the Radar
Below the Radar

Reputation: 7635

Oracle 10g - bar chart of queries statistics for a set of tables

I would like to have a bar chart that compile usage statistics on a set of tables for a given period.

However I have to mention that I do not have rigths to access V$SEGMENTS or V$SESSION tables.

Is there a tool or a plugin in SQL Developer 3 that can achieve that even withouth those access?

Bump!

Upvotes: 1

Views: 78

Answers (2)

shane54
shane54

Reputation: 76

You can always query ALL_TABLES in order to know, which tables/views are available for you to select from. Remember, that view will show you both tables and views, even that is not important within your current case (join ALL_TABLES and ALL_SEGMENTS in order to distinguish, what is table, what is view)

Upvotes: 1

Eugene Kryukov
Eugene Kryukov

Reputation: 135

For DML stats you can use USER_TAB_MODIFICATIONS/ALL_TAB_MODIFICATIONS.

Note: /*ALL_TAB_MODIFICATIONS describes tables accessible to the current user that have been modified since the last time statistics were gathered on the tables. */

For query stat - only system view as V$SEGSTAT, v$db_object_cache, etc

Upvotes: 1

Related Questions