Description |
xviii, 598 pages : illustrations ; 24 cm + 1 CD-ROM (4 3/4 in.) |
Contents |
1. Oracle9i - Specific Scripts -- Database Properties -- Server Parameter File (spfile) -- Native Compilation of PL/SQL Program Units -- Managing Undo Space -- Obtaining Advice About Database Cache Size -- Working with Nonstandard Block Sizes -- Determine Non-Standard Block Sizes in Use -- 2. Scripts for Managing Performance -- Looking Inside the SGA -- Multiblock Read Setting -- Enqueue Resources -- Full Table Scans of Large Tables -- Sort Area -- Parallel Query Server Processes -- Effectiveness of Redo Copy Latches -- Effectiveness of Multithreaded Server -- Effectiveness of Database Writer Process -- Beyond the SGA -- Using utlbstat/utlestat -- Statspack -- Autotuning with SPFILE.ORA -- 3. Transaction Management -- Rollback Segments -- Locking -- 4. Data Management -- Diagnostic Scripts -- Utilities -- 5. Object Management -- Diagnostics -- Utilities -- 6. Space Management -- Diagnostics -- Utilities -- 7. User Management -- Diagnostic Scripts -- Utilities |
|
The following chapters are on the accompanying CD -- 8. Database Management -- 9. Managing Java in the Database -- A. PL/SQL, Dynamic PL/SQL, and Procedures |
Notes |
Includes index |
SUBJECT |
Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760
|
Subject |
PL/SQL (Computer program language)
|
|
Relational databases.
|
|
SQL (Computer program language)
|
Author |
Carmichael, Rachel.
|
|
Thakkar, Meghraj.
|
LC no. |
2002277476 |
ISBN |
0072132183 |
|
0072132191 (book) |
|
0072132205 (CD-ROM) |
|