Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information managem ent problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Each feature is taught in a proof-by-example manner, n ot only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book. Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focus es solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you. In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the New Features update exam, Oracle 9i Funamentals I Exam Cram 2 can help you get certified. This efficient guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i Fundamentals I Exam Cram 2 is your smartest way to get certified.

Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.

PL/SQL Server Pages is a technology introduced by Oracle for developing Web applications by using Oracle's PL/SQL language as a server-side scripting language. This book is written with the objective of allowing the student to learn development of database-driven Web applications through the utilization of SQL and PL/SQL languages for relational database processing. It provides a hands-on approach toward Web development. To facilitate development of PL/SQL Server Pages, NetObject Fusion Web auth oring software is adopted to supplement the HTML coding of a Web page. There are sample databases, numerous examples and tutorials in the book to explain the various concepts. Each chapter ends with Review Questions and Problem Solving Exercises. The book is written for college students and moves at a pace suitable for students.

A reference for RAC and TAF technology, this book demonstrates how to optimize Oracle clustered server environment for optimal performance and flexibility. Covering all areas of RAC continuous availability and transparent application failover, this book is indispensable for any Oracle DBA who is charged with configuring and implementing a RAC clusters database. Described are the secrets for successful design of RAC clusters and the expert internals of shared disk technology, raw devices and RAID with RAC. Exposed is the internal concurrency and PCM locking mechanisms within RAC and the configuration of Transparent Application Failover is explained. Also provided are tips for monitoring and tuning RAC applications as well as tricks for using Oracle9i RAC Cluster Guard.

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and shows proven techniques that can be used to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle DBA's this guide focuses on proactive tuning and scripting, and shows how to collect historical data and use it to develop signatures for all memo ry areas. Using these metrics DBAs will be able to develop scripts that will anticipate and correct upcoming SGA performance problems. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.

This is the only real Oracle 9i Database Administration book on the market! This 1,000 page book enables a beginner or intermediate level Oracle DBA of Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases. "Expert Oracle9i Database Administration" is thorough in covering all aspects of the 9i database and also includes a UNIX primer, as well as an introduction to SQL and PL/SQL. Sam R. Alapati covers the entire spectrum of the new Oracle 9i RDBMS softwa re and clearly explains how to use all of its powerful features. Currently, there is no one book that combines the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. Sam R. Alapati's book fills that gap well, by providing all the necessary material in one comprehensive volume. "Expert Oracle9i Database Administration" is designed as the most complete Oracle 9i database text available today. It takes several courses, as well as mastery of several Oracle manuals, to become a proficient DBA. A major focus of this book is on the most important features of the Oracle 9i database. Readers will be able to become expert Oracle DBAs by using this book.

From the exclusive publisher of Oracle Press books comes this thorough guide to Oracle's Java development tool, JDeveloper -- new for 9i. This book explains the JDeveloper IDE and how to build JSPs, Java applications, business components for Java (BC4J), and more.

From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world!

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

"Oracle9i PL/SQL: A Developer's Guide" is intended both for intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9i features. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy. "Oracle9i PL/SQL: A Developer's Guide" is a solid source for the development of Oracle9i PLSQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial. Bulusu Lakshman is an experienced Oracle develope r with more than 10 years of software design and development experience using Oracle and its related tools, including PL/SQL and Java. He's the author of "Oracle Developer Forms Techniques" and "Oracle and Java Development", both of which have been well received. He also holds an Oracle Master credential from the Oracle Corporation, is an Oracle Certified Professional (OCP) application developer, and is a double honors graduate in computer science and engineering and mathematics. He has presente d at numerous international and national conferences on Oracle and its tools, and published articles in various technical magazines and journals. Lakshman is currently employed by Compunnel Software Group Inc., a leading technical consulting firm based in New Jersey.

From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle's free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

The latest version of this popular guide introduces the fundamental commands and techniques used in Oracle 9i database systems, and how to develop applications using Oracle and SQL. The authors also review PL/SQL structures, object-oriented and Java features in the Oracle database, the data dictionary, database optimizers, and the application server. The CD-ROM contains an electronic version of the book and tables. Master all the powerful features of Oracle9i using the exclusive information ins ide this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.

Your Oracle career starts here! Ideal for those new to Oracle technology, this introductory guide explains in easy-to-follow detail the day-to-day duties of a database administrator (DBA), as well as essential database installation, monitoring, and managing techniques.

A practical developer handbook for creating mobile applications on the Oracle platform, Oracle Mobile is the definitive resource for Web designers, Java programmers, non-Java programmers, consultants, project managers, IT managers, Oracle DBAs, and content managers.

Save 20% on four books! Prepare for the Oracle Certified Professional exams using this complete Oracle Press study system. In each book, you'll find in-depth details on all the material covered on these challenging exams, followed by practice questions and chapter summaries to highlight what you've learned. Books and CD-ROMs combined contain 1,200+ practice exam questions. This boxed set includes: OCP Introduction to Oracle9i: SQL Exam Guide, OCP Oracle9i Database: Fundamentals I Exam Guide, OCP Oracle9i Database: Fundamentals II Exam Guide, OCP Oracle9i Database: Performance Tuning Exam Guide.

Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

The perfect way to prepare for the Oracle9i Performance Tuning exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.

In this book, Mr. Price takes you from making simple database connections to using object-relational features and covers such essential topics as Oracle9iAS Containers for J2EE (OC4J), JDeveloper, and performance tuning. Read this book and learn how to leverage the full power of Oracle's implementation of JDBC. From the authentic Oracle Press comes the definitive guide to writing JDBC programs for use with the Oracle8i and Oracle9i databases, including details on Oracle extensions. In addition, JDBC support in the Oracle9i database as well as in Oracle9i Internet Application Server (via the containers for J2EE) is covered.

The perfect way to prepare for the Oracle9i DBA Fundamentals II exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book. The book you need to prepare for Exam 1Z1-032 Oracle 9i Database: Fundamentals II. Provides indepth coverage of official exam objectives and hundreds of challenging review questions. CD-ROM included.

This authorized guide from Oracle Press explains how to implement the Oracle9i Server on Windows NT/2000. You'll get details on operating system fundamentals, installation, and configuration, plus intermediate and advanced topics such as architecture, migration, clustering, parallel server

Here's the book you need to prepare for Exam 1Z1-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managi ng Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Featured on the CD The enclosed CD is packed with vital preparation tools and materials, beginning with the Sybex EdgeTest testing engine for the Oracle9i Fundamentals I exam. Loaded with hundreds of practice questions, it lets you test yourself chapter by chapter or according to objective areas. You'll also find electronic flashcards for your PC and Palm handhelds and two bonus exams that will help you prepare for the test. Also included is a complete electronic version of the book.

Step-by-step configuration guide for Tru64 UNIX 5.1 TruCluster and Oracle9i RAC. Oracle9i RAC installation and configuration tips. Command summary included in each chapter. This quick reference provides step-by-step instructions on setting up Oracle9i RAC to run on a Tru64 UNIX cluster. Configuration information is included from start to finish. Command summary guides are built into each chapter for quick information retrieval. Examples and step-by-step instructions assist in the complete inst allation of a Tru64 UNIX 5.1A and Oracle9i. Designed as an introduction to Tru64 UNIX and Oracle9i RAC, Tru64 UNIX-Oracle9i Cluster Quick Reference will give intermediate and advanced administrators an invaluable resource for quickly locating vital information.

Get Certified with Official Exam Prep Material from Oracle Press. Prepare for the Oracle Certified Professional Oracle9i Database: Performance Tuning exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Performance Tuning exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Explains how to use the Oracle STATSPACK utility to proactively monitor and tune a database by looking at historical trends and performance patterns. The author progressively walks through tuning the Oracle server environment, the global parameters that affect the Oracle database, individual table and indexes within the database, and individual SQL queries. Modified scripts for reading data from the STATSPACK tables and creating reports are provided. Get complete coverage of STATSPACK--Oracle's powerful tuning tool--inside this official guide. Including ready-to-use STATSPACK scripts youll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

Prepare for the Oracle Certified Professional Oracle9i Database: New Features for Administrators exam--a required exam for upgrading your Oracle8i or earlier DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive pr eparation tool available for the Oracle9i Database: New Features for Administrators exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Like the earlier versions, this manual is intended for beginners and is not a reference book. This manual covers basics and advanced topics of SQL covering Oracle 8i version. This book is a training manual where anyone can learn SQL. This book has lot of exercises and solutions at the end of each chapter.

Learn the ins and outs of 9i with the OCA/OCP: Introduction to Oracle9i SQL Study Guide. This release from Sybex will prepare you for Exam 1Z0-007, Introduction to Oracle9i: SQL. You get hundreds of challenging review questions in the book and on the CD and authoritative coverage of all exam objectives. Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: In-depth coverage of official exam objectives Practical information on using SQL in a real-world Oracle9i en Hundr eds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Writing basic SQL SELECT statements Restricting and sorting data Displaying data from multiple tables Aggregating data using group functions Producing readable output with iSQL*Plus Creating and managing tables Controlling user access.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals II exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals II exam.

This is a very interesting read for any Unix DBA, full of comprehensive explanations and diagrams on the way in which Oracle interacts with the Unix server. There are many detailed Unix Scripts to help you monitor your instances, which can be run via Statspack (dbms_job) and/or via the Unix cron. There is additional information on some more complicated UNIX commands, and copious small tips and tricks that will help in everyday Database Administration tasks. The book also covers commands for all different Unix environments Solaris, HP-UX, Tru64, AIX etc and help you interpret results from vmstat, sar and other Unix admin utilities.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i D atabase: Fundamentals I exam.

Maximize all of the enhanced capabilities of Oracle9i using the precise information presented in this convenient resource, officially authorized by Oracle Corporation. Inside, you'll find full details on all the new Oracle9i features, including database administration and management improvements, architecture changes, performance enhancements, security advancements, and high-availability innovations.

Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.

From the authorized Oracle Press comes a unique volume, packed with undocumented tips ; techniques from Oracle experts, for maximizing Oracle9i on the Windows 2000 platform. You'll get full coverage of critical high-end features such as clustering and standbys and methods for ensuring high availability. You'll also get full details on all the features new to Oracle9i. Take full advantage of the strength and reliability of Oracle9i and the management features of Windows 2000. Written by the expe rts and authorized by Oracle Corporation, Oracle9i for Windows 2000 Tips & Techniques presents insider best practices for installation, upgrades, migration, tuning, backup and recovery, clustering, and high availability. You'll also get in-depth details on the new features of Oracle9i.

If you have Oracle9i, you have the database to beat all databases. Besides being among the cream of the crop when it comes to relational database packages, Oracle9i is one of the more complex. Oracle9i does some amazingly fancy things, but the easy things are sometimes tricky. Oracle9i For Dummies covers the tough stuff in a straightforward and conversational manner, touching on key points and new features. This friendly guide leads you through a complete tour of Oracle9i, hitting the highlight s the object relational world and these important product components: Enterprise Manager Console, Major DBA tools, SQL *Plus, XML Developer's Kit, Dataspeak & Java applets.

From the official Oracle Press comes a comprehensive guide to developing XML-based e-Commerce applications on the Oracle Internet Platform. Written by the Oracle XML Development Team, this insider's resource explains how to take full advantage of the Oracle XML Developer's Kit (XDKs) and maximize Oracle9i's XML-enabled features. Create and deploy cross-platform, transaction-based applications on Oracle9i with XML--the industry standard for describing data for e-business application integration a nd business-to-business exchanges. Written by members of the Oracle XML Development Team, this insider's resource explains how to take full advantage of the Oracle XML Developer Kit (XDK) to build, manipulate, transform, and view XML documents. You'll also learn from real-world case studies

From the official publishers of Oracle Press books, here is an essential handbook for developers and administrators working with Oracle Portal. The book explains how to build and deploy portal-driven Web sites using Oracle Portal. Step-by-step walkthroughs and significant code samples demonstrate methods for rapidly creating robust forms, reports, charts,and content management applications. Written by a member of the Oracle Portal Customer Advisory Board (CAB) and a member of the IOUG-A Portal S pecial Interest Group (SIG), this Oracle-authorized resource includes Oracle 9i Application Server 1.0.2.2 on CD-ROM.

A quick glance at this book reveals an elaborate mix of information-presentation techniques. Procedures, complete with numbered steps, intermingle with bulleted lists that document options, and tables that explain alternative parameters that may be used in code to achieve different effects. The result is a guide that's handy for getting your initial familiarity with Portal (you can just follow the steps without deviation) as well as for reference when you're more expert (you can use the index to locate the tables and facts you need to see in order to solve problems). Read this one if you need to build Portal applications and don't have time for training.

2001-2011 Oracle-Books.com