Scripts

AWS Commands (CLI)

AWS CLI (command Line Interface) in a nutshell


Oracle Database Scripts:

CategoryScript DetailsScript Link

Oracle DB:
Database size in TBsDB Size in TBs.sql

Oracle DB:

TABLESAPCES SIZE(MB), FREE(MB) % USED AND %FREE
Tablespace Usage in %

Oracle DB:

Database size in GBs
Database size in Gbs

Oracle DB:
Database size in MBsDatabase size in MBs

Oracle DB:
DB Admin: Tablesapces size(MB), free(MB) % used and %fTablesapces size(MB), free(MB) % used and %f

Oracle DB:

Tablespace usage history

Tablespace usage history

Oracle DB:
DB Admin: Used, auto and max space of datafile/s of given tablespace in GbDB Admin: Used, auto and max space of datafile/s of given tablespace in Gb

Oracle DB:
DB Admin: Used, auto and max space of datafile/s of the given tablespace in MbDB Admin: Used, auto and max space of datafile/s of the given tablespace in Mb

Oracle DB:
In-built scripts with the databaseIn-built scripts with the database

Oracle DB:

SCRIPT TO DROP EVERYTHING FROM A SCHEMA

SCRIPT TO DROP EVERYTHING FROM A SCHEMA

Oracle DB Backup and recovery:
Expdp/impdp directory, SCN, timestamp and consistentExpdp/impdp directory, SCN, timestamp and consistent

Oracle DB Backup and recovery:
Expdp/impdp estimate the dump size without real exportExpdp/impdp estimate the dump size without real export

Oracle DB Backup and recovery:
Expdp/impdp database full exportExpdp/impdp database full export

Oracle DB Backup and recovery:
Expdp/impdp database full export without passwordExpdp/impdp database full export without password

Oracle DB Backup and recovery:
Expdp and impdp complete referenceExpdp and impdp complete reference
Performance:List Hit Ratios, Rollback Seg wait and Dispatcher workloadList Hit Ratios, Rollback Seg wait and Dispatcher workload

Performance:
List all current sessions in whole RACList all current sessions in whole RAC
ASM:Space used in ASM Disk GroupsSpace used in ASM Disk Groups

ASM:
Disks within a disk groupDisks within a disk group

ASM:
List of ASM files and its volume detailsList of ASM files and its volume details

ASM:
Disks performance metricDisks performance metric
RAC:List all locked objects for all instances in RACList all locked objects for all instances in RAC

RAC:
List details for sessions wait from all instances in RAC.List details for sessions wait from all instances in RAC.

RAC:
Displays memory allocations for all current sessions in whole RACDisplays memory allocations for all current sessions in whole RAC

RAC:
List all current sessions in whole RAC List all current sessions in whole RAC

RAC:
List info of all long operations in whole RAC List info of all long operations in whole RAC
High Availability:Scripts to check if archive logs are being shipped and applied to standbyScripts to check if archive logs are being shipped and applied to standby
E-Business Suite:
E-Business Suite:

E-Business Suite:
Workflow Mailer:Workflow Mailer Script to check service status Workflow Mailer Script to check service status
Workflow Mailer:
Workflow Mailer Script to check mailer status

Workflow Mailer Script to check mailer status
Workflow Mailer:
Workflow Mailer Script to stop notification mailer

Workflow Mailer Script to stop notification mailer
Workflow Mailer:
Workflow Mailer Script to start notification mailer

Workflow Mailer Script to start notification mailer
Weblogic Scripts

Weblogic:

Weblogic: Scripts to start/stop Weblogic

Scripts to start/stop Weblogic
Git Commands
Git:Git: How to connect to Github and Clone a repositoryGit commands to clone a repository.
Git:Basic Git CommandsBasic Git Commands




Oracle database scripts´╗┐

Scroll Up