Oracle Internals: Tips, Tricks, and Techniques for DBAs

Front Cover
Donald K. Burleson
CRC Press, Jul 30, 2001 - Computers - 896 pages
0 Reviews
If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology. You need Oracle Internals: Tips, Tricks, and Techniques for DBAs.
Oracle has evolved from a simple relational database into one of the most complex e-commerce platforms ever devised. It's not enough for you to understand just the Oracle database. You must also understand the components of the Web server technology, XML, Oracle Security, Oracle and Java, and a host of other issues in order to do your job properly.
This book is a compendium of the best and most useful articles from Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators and other Oracle professionals. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information not found in any other book, information only available from peers and consultants. The chapters focus on the truly tough stuff - proven techniques learned in the trenches.
You could get this information from other sources, but you'd have to hunt and peck for it. Can you afford that kind of time? Oracle Internals: Tips, Tricks, and Techniques for DBAs gives you knowledge and advice directly applicable to your work in one easy-to-use resource.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

37 Visualizing the IO Signature
445
38 Automating Distribution of Oracle Client Software
465
39 SQLNet Diagnostics and Performance Tuning
475
40 Pinning Packages in the SGA
491
41 Investigating the Multiple Buffer Pool Feature of Oracle8
499
42 Diving into the Shared Pool
515
43 Managing Multiple Buffer Pools in Oracle8
537
New Features
543

9 Introduction to iAS for the OAS Administrator
89
10 Viewing Performance Data with OAS
109
11 Top DBA Scripts for Web Developers
117
12 WebBased Testing and Capacity Planning
125
13 HTTP Listeners
133
14 Introduction to UTL_HTTP
139
Moving Folders Across Content Areas with Its API
149
16 Not WebDB 30 Not iPortal But Oracle Portal
159
17 The Fast Track to Java with Oracle
179
18 Building a Java Applet for Monitoring Oracle
193
19 UNIX Scripts for Oracle Administration
217
20 UNIX Tips and Tricks for the Oracle DBA
233
SQLLoader PLSQL and ProC
251
22 Gauging How Linux May Change the DBMS Market
269
23 Strategies for an Archives Management Program
279
24 Scripting Oracle Backups with RMAN and EBU
291
25 Alert Mechanisms for RMAN Backups
301
26 Tips and Scripts for Implementing RMAN
331
27 Paging People with Oracle8i Out of the Box
339
Whys and Hows
349
29 Analytic Functions
353
Investigations into Literal SQL and Oracle Shared Pool Performance
361
31 Managing Database Objects in Sets
385
32 Oracle8217s Joins
391
33 To_Format
405
34 Exploring Disk Size and Oracle Disk IO Performance
415
35 Adaptive Strategies for Disk Performance in Oracle
421
36 RAID and Oracle
431
45 How I Reorganized a Large Database
553
46 Partition and Conquer
575
47 Eliminating Space Reorganizations in Oracle8i
591
48 Determining the Table Rebuild Ratio for Oracle Tables
605
49 Oracle Parallel Query
613
50 Managing Oracle Table Freelists
619
51 Using Roles in Oracle Security
635
52 Managing RowLevel Security in Oracle8i
643
53 Auditing Oracle
651
54 What8217s Wrong with My Data?
665
55 Oracle Express Development in the Enterprise
677
56 An Approach to Load Analysis and Stress Testing
685
57 Undocumented Express
701
58 Enterprise Transformation and Data Management
717
59 Getting a Quick Start with Oracle8i
727
60 Oracle Sessions Monitoring
741
61 The ObjectRelational Features of Oracle8
759
62 Hardware Considerations
769
63 Oracle Extras
781
64 Oracle8217s Triggers
791
65 Concurrency
801
66 The Supporting GROUPS
809
67 Registering a Metadata Schema
817
A Useful Undocumented? Utility
825
69 Using the DBMS_LOCK BuiltIn Package
835
Index
851
Copyright

Other editions - View all

Common terms and phrases

Popular passages

Page iii - Peltier ISBN: 0-8493-0880-1 Information Technology Control and Audit Frederick Gallegos. Sandra Allen-Senft. and Daniel P. Manson ISBN: 0-8493-9994-7 New Directions in Internet Management Sanjiv Purba. Editor ISBN: 0-8493-1 160-8 New Directions in Project Management Paul C. Tinnirello. Editor ISBN: 0-8493-1 190-X A Practical Guide to Security Engineering and Information Assurance Debra Herrmann ISBN: 0-8493-1 163-2 The Privacy Papers: Managing Technology and Consumers. Employee. and Legislative Action...
Page iii - A Technical Guide to IPSec Virtual Private Networks James S. Tiller ISBN: 0-8493-0876-3 Building an Information Security Awareness Program Mark B. Desman ISBN: 0-8493-01 16-5 Computer Telephony Integration William Yarberry, Jr.
Page iii - Information Security Risk Analysis Thomas Peltier ISBN: 0-8493-0880-1 Information Technology Control and Audit Frederick Gallegos. Sandra Allen-Senft. and Daniel P. Manson ISBN: 0-8493-9994-7 New Directions in Internet Management Sanjiv Purba.

Bibliographic information