HOME NEW LISTING MOST POPULAR HIGHEST RATED SCRIPTS ADD SCRIPT DOWNLOADS FORUM Blog
 Search:     
TUTORIALS
 ASP.Net & C#
  ASP
  Perl and PHP
  Java Scripts
  C and C++
  Ajax Tutorials
  J2ee, J2Me, Java
  Python & Ruby Rail
  Crystal Report
  Sap
  CGI
  XML
  Cold Fusion & CFML
  HTML, DHTML & CSS
  Dreamweaver
  FLASH
  Photoshop/Web Designing
  Tools & Utilities
  Oracle/D2K
  Sql Server
  MySql
  Domain Name Registration
  Remotely Hosting
  Web/Server Application
  Hotel Marketing
  Internet and Law
  Search Engine Optimization/SEO
  E-Commerce
  Interview Questions
Database >> Oracle
DBA Scripts in Oracle (2)DBA Scripts in Oracle (0)
check_parameter.sql
Discription:

   Use this script to find the value of an Oracle initialisation parameter. It handles undocument ("_" underscore) parameters as well as normal ones. You can also pass in the value that the parameter should have and the procedure indicates if the setting violates this or not. The output can be directed to either the screen via dbms_output or to a file via utl_file. The method is decided at run time by choosing either 'S' for screen or 'F' for File. If File is chosen then a filename and output directory are needed. The output directory needs to be enabled via utl_file_dir prior to 9iR2 and a directory object after.
freePlateform(s): LinuxUpdate: 12/30/200Vistor Rating: 3Rating: 3
find_all_privs.sql
Discription:

   Use this script to find which privileges have been granted to a particular user. This scripts lists ROLES, SYSTEM privileges and object privileges granted to a user. If a ROLE is found then it is checked recursively.The output can be directed to either the screen via dbms_output or to a file via utl_file. The method is decided at run time by choosing either 'S' for screen or 'F' for File. If File is chosen then a filename and output directory are needed. The output directory needs to be enabled via utl_file_dir prior to 9iR2 and a directory object after.
freePlateform(s): LinuxUpdate: 12/30/200Vistor Rating: 4Rating: 3
who_has_priv.sql
Discription:

   Use this script to find which users have been granted the privilege passed in. The script checks hierarchically for each user granted the privileges via a role.The output can be directed to either the screen via dbms_output or to a file via utl_file. The method is decided at run time by choosing either 'S' for screen or 'F' for File. If File is chosen then a filename and output directory are needed. The output directory needs to be enabled via utl_file_dir prior to 9iR2 and a directory object after.
freePlateform(s): LinuxUpdate: 12/30/200Vistor Rating: 4Rating: 3
DBA Sample Scripts
Discription:

   Generic Scipts covering Oracle Database 10g Release 2 and later
11gPlateform(s): LinuxUpdate: 12/3/2008Vistor Rating: 1Rating: 1
Oracle Scripts
Discription:

   Oracle Backup and Recovery methods
9iPlateform(s): LinuxUpdate: 12/4/2008Vistor Rating: 2Rating: 1
  Copyright 2000-2006 © SoloScript.com, All rights reserved.