Skip to content

Tagar/dba

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DBA scripts

various scripts for an Oracle DBA

check_oratabs.pl - checks (and updates) oratab files in a cluster, according to settings in clusterware.

orion/orion_3d_plot.r - plots 3D graphs for ORION IO test results.

sas/sas2oraextab.pl - SAS to Oracle external table DDLs generator. Comes up with column names based on description, creates multiple tables if there are more than 1000 columns in source SAS file.

check_multipath.pl - runs iostat for each multipath device group and prints disbalance. If multipath wouldn’t be used, devices wouldn’t be used equally for reads or for writes. Had a problem when some oracleasm devices in /dev/oracleasm/disks/ were pointing to sd and not dm devices. check_multipath.pl script detects such problems.

About

various scripts for an Oracle DBA

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published