| Scripts |
Everyone has a pocketful of scripts to do things. These are some of mine. |
| DBA_ Views |
List of the more commonly used DBA_ views |
| V$ Views |
List of the more commonly used V$ views - under construction |
| Grants |
Privilege grants available in 8.1.6 |
| Session Tracing |
Tracing of individual sessions |
| Data Copy |
A generic process which copies data from a remote database at specified times. The list of tables
to copy is held in a table on the receiving schema, thus allowing changes to the requirements
without changing code.
This was originally designed to promote analysis of space usage ( by copying DBA_SEGMENTS, DBA_TABLES etc ),
but can be used in any situation where a regular copy of data is required.
|
| Pinning Code in Memory |
A method of pinning code objects in memory which can be applied independently of application differences.
|
| Analyse SGA |
Captures sql from the SGA and analyses it through explain plan.
|
| Format Strings |
Date and Character format strings. |
| General Unix commands |
List of most of the more commonly used commands. |
| Basic vi commands (Unix) |
Reminder list. |