Skip navigation.

DBA Scripts and Articles

Syndicate content
This blog is intended to share my knowledge on Oracle and various scripts that I use as an oracle DBA.
Updated: 18 hours 11 min ago

Datafile space reclaimable report.

Thu, 2014-09-18 14:45

This script will help you find the space reclaimable in your datafiles, it finds the High Water Mark of all your datafiles (the minimum size) and then report the following information: Datafile Size Datafile HWM Percentage of space reclaimable Command to resize the datafile Total space reclaimable in your datafiles Percentage of space reclaimable in your datafiles Find space reclaimable [...]

The post Datafile space reclaimable report. appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

SQL Tuning Health Check (SQLHC)

Thu, 2014-08-14 09:12

What is SQL Tuning Health Check? The SQL Tuning Health Check is provided by Oracle (Doc ID 1366133.1) in order to check the environment where the problematic SQL query runs. It checks the statistics, the metadata, initialization parameters and other elements that may influence the performance of the SQL being analyzed. The script generates an [...]

The post SQL Tuning Health Check (SQLHC) appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

Space used by objects

Thu, 2014-08-07 12:35

Calculate the space used by a single object This script will help you calculate the size of a single object : [crayon-541ed4c2203be593318662/] Calculate the space used by a whole schema If you want the space used by a whole schema, then here is a variation of the first query : [crayon-541ed4c2203ca960156886/]

The post Space used by objects appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

Keep jobs active with screen command

Thu, 2014-06-12 12:00

What is the screen command ? When you have long running jobs, you need to keep them active when you disconnect from server. The screen command allows you to detach your terminal from you session. By doing this there is no link between your session and your terminal and you can disconnect from server while [...]

The post Keep jobs active with screen command appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs