Oracle Internals: Tips, Tricks, and Techniques for DBAs

ISBN-13: 9781138416550 / Angielski / Twarda / 2017 / 900 str.

John Beresniewicz;Donald K. Burleson; North Car Kittrell Donald K. Burleson (Burleson Consulting

Opis

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.

Recenzje

Winner of the 2004 Referenceware Excellence Award!
co-sponsored by Books24x7 and Waterside Productions

Promo Copy

Spis treści

Oracle Applications Development Techniques A Practical Example of Data Conversion, C. Banyay Using Wizards in an Oracle Developer 6i Form, J.A. Palinski Using Oracle's Developer 6i to Create a Record Directory, J.A. Palinski Using Hierarchical Tree Items in Oracle's Developer 6I, J.A. Palinski Populating Oracle Form Hierarchies Incrementally at Run Time, J.A. Palinski Oracle Designer 2.1.2.API: Enforcing Column Naming Standards, H. Deschamps Oracle Web Development Building a .com from the Ground Up, B.D. Brown and E. Robinson Rapid Web Deployment with WebDB, S. Shestakov and D. Petrov Introduction to iAS for the OAS Administrator, B.D. Brown Viewing Performance Data with OAS, S. Shestakov Top DBA Scripts for Web Developers, B.D. Brown and T. Calalano Web-Based Testing and Capacity Planning, T. Clarke HTTP Listeners, B.D. Brown Introduction to UTL_HTTP, B.D. Brown Portal 3.0: Moving Folders across Content Areas with Its API, H. Deschamps Not WebDB 3.0, not iPortal, but Oracle Portal, B.D. Brown Java and Oracle The Fast Track to Java with Oracle, B.D. Brown Building a Java Applet for Monitoring Oracle, S. Shestakov Oracle and UNIX UNIX Scripts for Oracle Administration, S. Shestakov UNIX Tips and Tricks for the Oracle DBA, D. Burleson File Exchange Solutions: SQL*Leader, PL/SQL, and Pro*C, S. Shestakov and D. Petrov Gauging How Linux May Change the DBMS Market, P. Korzeniowski Oracle Backup and Recovery Strategies for an Archives Management Program, M.J.D. Sutton Scripting Oracle Backups with RMAN and EBU, H. Fosdick Alert Mechanisms for RMAN Backups, G.S. Wan Tips and Scripts for Implementing RMAN, G.S. Wan Paging People with Oracle 8i Out of the Box, H. Deschamps Oracle SQL Tuning Cost-Based Optimization: Whys and Hows, R. Greenwald Analytic Functions, J. Lewis Piranhas in the Pool: Investigations into Literal SQL and Oracle Shared Pool Performance, J. Beresniewicz Managing Database Objects in Sets, J. Gennick Oracle's Joins, R. Earp and S. Bagui To_Format, A. Shrivastava Oracle Disk Management Exploring Disk Size and Oracle Disk I/O Performance, B.D. Rodgers Adaptive Strategies for Disk Performance in Oracle, B.D. Rodgers RAID and ORACLE, D.C. Sisk Visualizing the I/O Signature, G.E. Sharpe Distributed Oracle Systems Automating Distribution of Oracle Client Software, C. Mansfield SQL*Net Diagnostics and Performance Tuning, S. Shestakov and D. Petrov Oracle Buffer and SGA Management Pinning Packages in the SGA, D. Burleson Investigating the Multiple Buffer Pool Feature of Oracle8, J. Beresniewicz Diving Into the Shared Pool, M.R. Ault Managing Multiple Buffer Pools in Oracle8, M.R. Ault Oracle8i Buffer Cache: New Features, J. Beresniewicz Oracle Table Management How I Reorganized a Large Database, B. Thomas Partition and Conquer, R. Pande Eliminating Space Reorganizations in Oracle8i, R. Schumacher Determining the Table Rebuild Ratio for Oracle Tables, R. Kab Oracle Parallel Query, D. Burleson Managing Oracle Table Freelists, D. Burleson Oracle Security Using Roles in Oracle Security, M.B. Wallace Managing Row Level Security in Oracle8i, M.R. Ault Auditing Oracle, F. Gallegos and J.C. Yin Oracle Data Warehouses What's Wrong with My Data? J. Feldman Oracle Express Development in the Enterprise, P. Mundell An Approach to Load Analysis and Stress Testing, J.B. Sastry Undocumented Express, W.G. Brown Enterprise Transformation and Data Management, R. Lee Oracle Database Internals Management Getting a Quick Start with Oracle 8i, R. Kab Oracle Sessions Monitoring, S. Shestakov and D. Petrov The Object/Relational Features of Oracle8, D. Burleson Hardware Considerations, B.D. Brown Oracle Extras, B.D. Brown Oracle's Triggers, R. Earp and S. Bagui Concurrency, R. Greenwald The Supporting GROUPS, A. Shrivastava Registering a Metadata Schema, A. Watts ORADEBUG: A Useful (Undocumented?) Utility, B. Thomas Using the DBMS_LOCK Built-in Package, J. Beresniewicz Index

O autorze

Donald K. Burleson (Burleson Consulting, Kittrell, North Carolina, USA)