Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

SQL and PL/SQL Scripts Procedure To ENABLE/DISABLE Triggerson all Tables in a Schema By: S K Jun 20, 2007 This procedure Enables or Disables the triggers on all the tables in the schema its currently being executed. It can be used as a sql script to run it any schema Script to convert Report to Excel By: shadab ali Jan 08, 2006 Script to convert Report to Excel Script to convert table data into comma delimited format By: Puneet Sharma Dec 11, 2004 This script convert table data into comma delimited format. Database Administration Generating script for Tablespace from current database By: Azaz Husain Apr 26, 2008 Generating script for Tablespace from current database. Script generated can be use to create tablespace in event of system failure or creating replica of the same database. Script to get list of all jobs By: Murtuja Khokhar Apr 25, 2008 This script to list of all jobs. Script to view and count number of sessions to the database By: Pritpal Singh Jan 09, 2008 Script to view and count number of sessions to the database. Script to find locks in the database By: Babu B Dec 27, 2007 Script to find locks in the database Script to compile invalid objects in DB after refreshing By: Vinod Udapudi Sep 19, 2007 Script to compile invalid objects in DB after refreshing Query to see the Reserved, Used and Free space of your database By: Seju Thomas Sep 03, 2007 Query to see the Reserved, Used and Free space of your database. Script to Find out the running session By: Ramesh Jois Aug 07, 2007 Script to Find out the session running with system name, OS and DB username and the application. Script to calculate free, used and total space and to display in MB By: Muhammad Yoonus Jul 23, 2007 This script will calculate free, used and total space and to display in MB Script to display free space in tablespace By: S K Jun 25, 2007 The following script will execute and display the free space faster and saves the user time. Script to send mails using UTL_SMTP By: Devesh Ghule Mar 28, 2007 Script to send mails using UTL_SMTP Script to Show Used/free space by tablespace name By: Sanjay Tiwari Mar 13, 2007 Show Used/free space in Meg by tablespace name Script to display uptime By: Sanjay Tiwari Mar 13, 2007 Display database uptime in days and hours Tracking the execution of an Oracle import progress By: Nasir Mahmood Jun 13, 2006 One of the more perplexing issues for an Oracle administrator is tracking the execution of an Oracle import. When a production system is down, IT managers are anxious to know the progress of the Oracle Import utility. For very large tables, the Oracle Import utility can take many hours, and the DBA needs to know the rate at which the utility is adding rows to the table. To monitor how fast rows are imported from a running import job, try the following method. I got it from somewhere. Script to Generate Emails through Forms By: shadab ali Jan 15, 2006 Script to Generate Emails through Forms. Rebuild schema with minimal downtime By: Arulselvaraj A Jan 03, 2006 This script rebuilds the schema with minimal downtime as it rebuilds table and associated index in a sequence. Script to report constraints in for a table By: Vigyan Kaushik Sep 22, 2005 This script will report constraints for a give table. Script to generate create index statement By: Vigyan Kaushik Sep 22, 2005 This script will generate create index statements for you. Package for generating a sql file for Table/Indexes By: Ankur Shah Apr 06, 2005 Generate a sql file for Table/Indexes DDL from remote database using Oracle 9i DBMS_METADATA package and dblink. Script to enable/disable constraints By: Jyoti Salunkhe Apr 06, 2005 Script to enable/disable constraints. Script to Get Os user name with terminal name By: maxtardiveau  Feb 17, 2004 This script will give you connect users details with terminal. Performance Monitoring Script to find top SQL By: Ramesh Jois Sep 06, 2007 Script to find top SQL. Script for Dictionary Hit ratio By: Ramesh Jois Sep 06, 2007 Script for Dictionary Hit ratio. Script for finding Library Cache Hit ratio By: Ramesh Jois Sep 06, 2007 Script for finding Library Cache Hit ratio Script to find sql with high disk reads. By: Ramesh Jois Sep 06, 2007 Script to find sql with high disk reads. Script to Report SGA Memory Map By: Ahmed Abd El Latif Jul 19, 2007 This script will give you a report of SGA memory map. Display rollback segment statistics By: Sanjay Tiwari Mar 23, 2007 Script to display rollback segment statistics Script to measure the Buffer Cache Hit Ratio By: Sanjay Tiwari Mar 23, 2007 This script helps you measure the buffer Cache Hit ratio Script to tune sorts By: Aravind Kannan May 30, 2006 This Script will help you to tune sorts. Script to tune buffer cache hit ratio By: Aravind Kannan May 30, 2006 This script will help you to tune buffer cache hit ratio. Script to tune log buffer By: Aravind Kannan May 30, 2006 This script will help you to tune log buffer. Script to tune library cache By: Aravind Kannan May 30, 2006 This script will help you in tuning the library cache Script to tune cache hit ratio By: Aravind Kannan May 30, 2006 This script will help you to tune cache hit ratio. Space Management Show database growth in Meg per month for the last year By: Gopu Gopi Apr 22, 2008 This script shows database growth in Meg per month for the last year. List objects in the SYSTEM tablespace that doesn't belong By: Gopu Gopi Apr 22, 2008 Script to list objects in the SYSTEM tablespace that doesn't belong. Shows current size, used & freespace within the datafiles By: Gopu Gopi Apr 22, 2008 Script shows current size, used & freespace within the datafiles. List control file structures with usage limits By: Gopu Gopi Apr 22, 2008 Script to list control file structures with usage limits. Script to check next extent requirement By: Vigyan Kaushik Sep 22, 2005 This script will help you to figure out space requirement for extents in the database. Backup and Recovery Script to perform cold backup By: Babu Uppu Sep 12, 2008 Following script should be executed by dba account. This script will create batch file and will take a cold backup of your database. Shutdown and Startup will be handled by Script. Script to monitor RMAN status, while a backup is running with details By: Gopu Gopi Apr 28, 2008 Monitor RMAN status, while a backup is running with details. Script to take all tablespaces out of backup mode. By: Gopu Gopi Apr 28, 2008 This script will create a file called end_backup_script.sql run it to take all tablespaces out of backup mode. Script to list backups registered in RMAN catalog database By: Gopu Gopi Apr 28, 2008 List backups registered in RMAN catalog database Exporting Entire Oracle Database backup using a Shell script By: Azaz Husain Apr 25, 2008 Exporting Entire Oracle Database backup using a Shell script and copy to remote machine using samba. Database Security Find User's Privileges and Roles By: Ghazanfar Ali Apr 25, 2008 This script generates the information about the user's privileges and roles and privileges assign to those roles, it is very usefull when doing IT security audit

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor