SQL Script to find the top 50 tables by size

by

Here is a SQL to identify the top 50 tables. When I say table, it could be a table, partitioned table or materialized view. Takes into consideration the indexes defined on the table and lob segments in the table, thus gives a complete picture of the table size. When you truncate the table, this much … Read more

Script to Grant Privileges and Create Synonyms

by

Extending the previous post Granting privileges on all or multiple objects to user/role , here is another script. Often we have a requirement to create read only accounts for a schema. Typically these accounts are named _QUERY. The script when executed will prompt for the user name of the read only account, and the schema name where … Read more