Home    Flying Sideways - Oracle    Back   

Oracle


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.

Links

Oracle Home Page Oracle Support : Metalink Oracle UK
JL Comp Home Page Shared Pool Scripts Oracle Technology Network (OTN)
Script and Code Exchange Tom's Oracle links Utilities
Performance Ask Tom

Top    Home    Back

Let us have your views ...