Category: Scripting

Clone a Database User by Query

Script to pull/show a database user’s privileges or clone a user by query.

Continue reading

How to Show All Privileges for a User in Oracle Database

Sometimes DBA needs to generate the report to provide audit team or management about the users access information on database. In this article, I will show how to get list of access for oracle user. Query to find all privileges for all users in Database:

Continue reading

Patch (PSU) Automation

Applying patch is one the main maintenance task for a DBA. DBA team needs to give lots of effort to apply patch in every quarter. To minimize the manual effort I tried to make patching automation which will support following environments: It will support for 11g and 12c Databases Including RAC and Standalone It will …

Continue reading

Multiple Tables Record Count by a Single Query

Sometimes DBA need to verify or compare multiple tables record count. It is really time consuming to compare one by one table count. So, by using this query, you will able to get record count report for multiple tables in Oracle.

Continue reading

DBA Scripts

Monitoring: Load by Users Generate Kill Sessions from query List Privilege Load by Users Process Details Schema Size Tables Record Count