Home Page Logo
Copyright 2021 © QuinStreet Inc. All Rights Reserved
SQL Scripts & Samples
What Backups Do I Have?
As a DBA you need to check periodically to make sure you have backups. I would …
Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE
To improve the performance of your code that uses numerous table variables, consider …
TYPE Definition Change in Oracle 21c
Oracle 21c now offers the possibility of using some PL/SQL data types in …
Tip 74 – Changing Cost Threshold for Parallelism
Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer …
Use this script to find object dependencies.
Database Size Growth
History to analyze the growth of the databases size over a given period. Additional to …
Disk Space Usage
Find how much disk space is used on a database in a week. (Between disk space usage …
Lock Monitoring Scripts
This sequence of scripts can help identify tables that are being blocked and quantify …
Find Objects Referenced Inside a Stored Procedure
Not all tools provide a GUI interface, making it difficult to find Oracle's object …
Monitor CPU Usage Information
This script will monitor CPU Usage Information.
Generate Random Passwords
Use this script to generate a random password.
User Login Permission Detail
Use this stored procedure to quickly capture all login information when needed, …
Practice INSERT into.
Search All Stored Procedures in All Databases
Piece of code to search all stored procedures in all databases for keyword.
All Database Space Used and Free
Helps DBA to find out quickly which database takes a lot of space and which file could …
Mobile Site |
Acceptable Use Policy
Terms of Service
California - Do Not Sell My Information