/sql

Sql scripts for the day to day stuff and some specific operations

Primary LanguagePLSQL

sql

Sql scripts for the day to day stuff and some specific operations

awrMiscOps.sql

Get awr informations, like the retention time, the snap interval, the dbid's present on your awr and other stuff

awrTimeBreakdown.sql

Get the wait events and present them on the timeline

awrTopEvents.sql

Get the wait events for the whole period

cleanSchema.sql

Drop all objects from a given schema. Usefull for process where you want to reimport all objects of a schema or just clean it without having to bother about the user privileges or password or tablespace appointment etc...

SQL> @cleanSchema.sql <schema_name>

createUser.sql

Just a simple plsql to create a user and grant all the basic permission

OBS: this one is still in building phase, with basically no error treatment or flexibility to unpredicted stuff

findObject.sql

Find all objects wich the name constains the string passed to the script, it returns the owner, object name, object type, creation date and object status

SQL> @findObject.sql <string>

getAsmDGInfo.sql

getDesyncSequences.sql

getGrants.sql

getInstStatus.sql

Get the status of the database, it shows the instance name(s), status, if logins are allowed and their hostnames.

getKillSessCmd.sql

getUserInfo.sql

selectivity.sql

Get statistics of the distribution of the values on a column or group of columns to help on the decision making of create/alter/drop indexes