Oracle PL/SQL for DBAs - Softcover

Arup Nanda; Steven Feuerstein

Softcover

ISBN 10: 0596005873 ISBN 13: 9780596005870

Publisher: O'Reilly Media, 2005

Synopsis

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:

• A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running
• Extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE); Row-Level Security (RLS), Fine-Grained Auditing (FGA); and random value generation
• Methods for DBAs to improve query and database performance with cursors and table functions
• Coverage of Oracle scheduling, which allows jobs such as database monitoring and statistics gathering to be scheduled for regular execution

Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM, DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

About this title

About the Author

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is also the author of Oracle PL/SQL Programming (O'Reilly & Associates, Second Edition, 1997) and Advanced Oracle PL/SQL Programming with Packages (O'Reilly & Associates, 1996). Steven has been developing software since 1980 and worked for Oracle Corporation from 1987 to 1992. He is a partner with RevealNet, Inc. (www.revealnet.com) and is the chief architect of the RevealNet products, PL/SQL Knowledge Base and PL/Vision (a code library of prebuilt PL/SQL packages which accelerates PL/SQL-based application development). Steven also sysops RevealNet's "PL/SQL Pipeline," an online community for PL/SQL developers (www.revealnet.com/plsql-pipeline). He can be reached through email at feuerstein@revealnet.com. Steven is also president of PL/Solutions, which offers training and consulting on both PL/Vision and PL/SQL (www.plsolutions.com). Finally (on the Oracle side of Steven's life), he serves as codirector of the Oracle Practice at SSC, a systems management consulting firm based in Chicago (www.saraswati.com). Arup Nanda is a Senior Oracle DBA with 10 years of experience with a variety of projects using skills in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, XML, System Design, Object-Based Design, Data Modeling, PL/SQL, Pro*C, C, Unix, NT, Shell Scripting. He has an MBA from Xavier Institute of Management, India.

Edition details

• Publisher: O'Reilly Media
• Publication date: 2005
• ISBN 10: 0596005873
• ISBN 13: 9780596005870
• Binding: Paperback
• Language: English
• Number of pages: 456