| File | Purpose | Description |
|---|---|---|
| Create db 1 | Create database |
Example 1. Multiple log file groups with single member. |
| Create db 2 | " |
Example 2. Multiple log file groups with mirrored members. |
| DB Information | List DB Information |
List information such as db name, block size, block buffer size, shared pool size etc. |
| DB Space | Reports space Usage |
Gives Tablespace name, size, percent free, largest contiguous free space, largest next extent. |
| Extents | Segment information |
Lists segments (with space usage) with less than 70 extents before they hit max extents |
| Rollback Info | Rollback information |
Lists rollback segments (with space usage) and online/offline status. |
| Segment Size | Lists segments size |
Lists a given segment's space usage along with it's indexes. |
Disclaimer
These scripts are examples only and should you choose to use them it is at your own risk.