Skip to content

transient-sepia/check-locks

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

The script writes the output to the file assigned to the $logfile variable.
Default is '/u01/log/nagios/check_locks.log'. You should create it beforehand.

        check_locks.pl - check if there are locks in database.

        check_locks.pl [-hnst] -d <DATABASE> [-l <TIME_LIMIT>] -u <USER> -p <PWD>

        -d - database name.
        -h - print this message.
        -l - optional time limit when to alert about possible locks (in seconds).
        -n - no html formatting.
        -p - user password.
        -s - silent output (only number of locks, if any).
        -t - table locks.
        -u - database user.

About

Check Oracle instance for session locks.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages