AWS Commands (CLI)
AWS CLI (command Line Interface) in a nutshell
Oracle Database Scripts:
| Category | Script Details | Script Link |
| Oracle DB: | Database size in TBs | DB 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 MBs | Database size in MBs |
| Oracle DB: | DB Admin: Tablesapces size(MB), free(MB) % used and %f | Tablesapces 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 Gb | DB 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 Mb | DB Admin: Used, auto and max space of datafile/s of the given tablespace in Mb |
| Oracle DB: | In-built scripts with the database | In-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 consistent | Expdp/impdp directory, SCN, timestamp and consistent |
| Oracle DB Backup and recovery: | Expdp/impdp estimate the dump size without real export | Expdp/impdp estimate the dump size without real export |
| Oracle DB Backup and recovery: | Expdp/impdp database full export | Expdp/impdp database full export |
| Oracle DB Backup and recovery: | Expdp/impdp database full export without password | Expdp/impdp database full export without password |
| Oracle DB Backup and recovery: | Expdp and impdp complete reference | Expdp and impdp complete reference |
| Performance: | List Hit Ratios, Rollback Seg wait and Dispatcher workload | List Hit Ratios, Rollback Seg wait and Dispatcher workload |
| Performance: | List all current sessions in whole RAC | List all current sessions in whole RAC |
| ASM: | Space used in ASM Disk Groups | Space used in ASM Disk Groups |
| ASM: | Disks within a disk group | Disks within a disk group |
| ASM: | List of ASM files and its volume details | List of ASM files and its volume details |
| ASM: | Disks performance metric | Disks performance metric |
| RAC: | List all locked objects for all instances in RAC | List 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 RAC | Displays 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 standby | Scripts 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 repository | Git commands to clone a repository. |
| Git: | Basic Git Commands | Basic Git Commands |
Oracle database scripts