Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips&Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. Properly index and partition Oracle Database 11g Release 2 Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Efficiently manage disk drives, RAID arrays, and memory Tune queries with Oracle SQL hints and the TRACE utility Troubleshoot databases using V$ views and X$ tables Distribute workload using Oracle Real Application Testing Generate reports using Oracle's Statspack and Automatic Workload Repository tools Use sar, vmstat, and iostat to monitor system statistics “This is a timely update of Rich’s classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products.” --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies

Oracle SQL by Example, Third Edition is a convenient, quick way to master Oracle SQL. This unique integrated book-and-Web learning solution teaches all the SQL skills you will need to succeed in an Oracle environment. Through hands-on, real-world labs, exercises, projects, and a superb Web-based training site, the book teaches administrators and programemrs alike the core skills required for their jobs. Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions. Each chapter contains review exercises that help the reader master the important skills before they move on.

Find tips for creating efficient PL/SQL codeIf you know a bit about SQL, this book will make PL/SQL programming painless!The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.Discover how toWrite efficient, easy-to-maintain codeTest and debug PL/SQL routinesIntegrate SQL and PL/SQLApply PL/SQL best practicesUse new features introduced in Oracle 9i and 10g

For Database Management and Database Systems courses. Reacting to the current business environment, Modern Database Management, 6/e addresses current issues in the market, such as Internet, data warehousing and object-orientation. While sufficient technical explanations are given, the text instructs from a business perspective, allowing students to understand the role of database management within a business.

Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.Create, debug, and manage Oracle-driven PL/SQL programsUse PL/SQL structures, delimiters, operators, variables, and statementsIdentify and eliminate errors using PLSQL_WARNINGS and exception handlersWork with functions, procedures, packages, collections, and triggersDefine and deploy varray, nested table, and associative array data typesHandle external routines, object types, large objects, and secure filesCommunicate between parallel sessions using DBMS_ALERT and DBMS_PIPECall external procedures through Oracle Net Services and PL/SQL wrappersIntegrate internal and server-side Java class libraries using Oracle JVMDevelop robust Web applications using PL/SQL Gateway and Web Toolkit

Insider Look at Silicon Valley Scheduled for Updated Paperback Robert X. Cringely paints a witty, irreverent, and revealing portrait of the personal computer industry in the updated paperback edition of Accidental Empires: How the Boys of Silicon Valley Make Their Millions, Battle Foreign Competition, and Still Can't Get a Date. Cringely's astute analysis of the PC business is the subject of a 3- hour PBS Television miniseries titled "Triumph of the Nerds." Hosted by Cringely himself, the miniseries, like the book, reveals the circumstances that allowed a major industry to grow up largely by accident under the guidance of a group of inexperienced nerds, misfits, and social outcasts. According to Cringely, former gossip columnist for the computer trade weekly InfoWorld, one of America's largest industries has been shaped by the quirks and insecurities of its leading figures, from Steve Wozniak's invention of the Apple to impress his friends in the Homebrew Computer Club, to Microsoft founder Bill Gates' single-minded quest for monopoly over all aspects of the fledgling industry. Cringely describes the engineers who launched the computer revolution as insecure and socially inept "nerds," with little or no business experience. They made up their rules as they went along, resulting in Silicon Valley's notoriously laid-back corporate culture, but also in companies that frequently reflect the shortcomings of their founders. Cringely describes these erratic, but often brilliant, amateurs with sympathy, insight and illuminating anecdotes. In the process, he also traces the history of the industry, from its initial outgrowth from the semiconductor industry, to the astounding innovations of the Xerox PARC research group (most of which the copy machine giant failed to follow up on), to the growth of such key companies as Apple, Microsoft, and Adobe, to the dramatic claim by Larry Ellison of Oracle Systems that the personal computer is merely a transitional technology. Cringely's appreciation of the eccentricities of individuals is matched by his grasp of the dynamics of the industry as a whole.

Officially endorsed by Oracle Corporation, this detailed resource from Oracle Press explains how to maximize the centralized planning, accounting, treasury, purchasing, and management features of Oracle Financials--and revolutionize your company's finance infrastructure.

Like most PL/SQL programmers, you've found Oracle PL/SQL Programming to be a reference book you can't do without. Packed with examples and recommendations, it's a book that has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. But you can't always carry it with you, and even at your desk there are times when you just need a reminder, a quick answer to a problem you're up against. For times like those, PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes have written a new edition of Oracle PL/SQL Language Pocket Reference. Updated for Oracle9i, this little book is easy to take with you and use anywhere for quick problem solving.The second edition of the Oracle PL/SQL Language Pocket Reference boils down the most vital information from Oracle PL/SQL Programming into a convenient quick reference to PL/SQL basics. This compact book will be indispensable for new and seasoned Oracle database developers alike. It summarizes features available in Oracle9i and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java classes from PL/SQL.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.

Linux Recipes for Oracle DBAs is an example–based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task–oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done. Takes you directly from problem to solution Covers the “right” mix of Linux user and administration tasks for database administrators Respects your time by being succinct and to–the–point What you’ll learn Execute Linux commands applicable to Oracle Database administration. Write shell scripts to automate critical DBA tasks. Monitor, tune, and optimize a Linux server to run Oracle Database. Perform Linux system administration tasks relevant to Oracle Database. Implement Oracle real application clusters on Linux. Implement Oracle automatic storage management on Linux. Remotely (and securely!) manage Oracle on Linux. Who this book is for Linux Recipes for Oracle DBAs is a book for Oracle database administrators who want to expertly operate Oracle databases on the Linux operating system. If you’re new to Linux, or are migrating from a Unix platform, or just want detailed solutions for tasks that Oracle DBAs perform on Linux servers, this book is for you.

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers.   One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice.   This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes         • Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL’s role in           PL/SQL         • Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements         • Efficiently handling errors and exceptions         • Working with cursors and triggers, including Oracle 11g’s powerful new compound triggers         • Using stored procedures, functions, and packages to write modular code that other programs can execute         • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced PL/SQL capabilities         • Handy reference appendices: PL/SQL formatting guide, sample database schema, ANSI SQL standards reference, and           more   Benjamin Rosenzweig is a Software Development Manager at Misys. Previously he was a Principal Consultant at Oracle. His experience ranges from creating an electronic Tibetan—English Dictionary in Kathmandu, Nepal, to supporting presentation centers at Goldman Sachs and managing trading systems at TIAA-CREF. As an instructor at Columbia University’s Computer Technology and Application Program, he was awarded the Outstanding Teaching Award. Rosenzweig wrote and presented Oracle Forms Developer: The Complete Video Course, and coauthored Oracle Web Application Programming for PL/SQL Developers.   Elena Silvestrova Rakhimov is Senior Developer and Team Lead at Alea Software. She has more than fifteen years of experience in database development in a wide spectrum of enterprise and business environments, ranging from non-profit organizations to Wall Street. She has taught database programming at Columbia University.   Contents Acknowledgments xiv About the Authors xv Introduction xvii   CHAPTER 1 PL/SQL Concepts 1     LAB 1.1 PL/SQL in Client/Server Architecture 2         1.1.1 Use PL/SQL Anonymous Blocks 8         1.1.2 Understand How PL/SQL Gets Executed 10     LAB 1.2 PL/SQL in SQL*Plus 12         1.2.1 Use Substitution Variables 16         1.2.2 Use the DBMS_OUTPUT.PUT_LINE Statement 17 Chapter 1 Try It Yourself 19   CHAPTER 2 General Programming Language Fundamentals 21     LAB 2.1 PL/SQL Programming Fundamentals 22         2.1.1 Make Use of PL/SQL Language Components 23         2.1.2 Make Use of PL/SQL Variables 24         2.1.3 Handle PL/SQL Reserved Words 26         2.1.4 Make Use of Identifiers in PL/SQL 27         2.1.5 Make Use of Anchored Datatypes 28         2.1.6 Declare and Initialize Variables 31         2.1.7 Understand the Scope of a Block, Nested Blocks, and Labels 34 Chapter 2 Try It Yourself 37   CHAPTER 3 SQL in PL/SQL 39     LAB 3.1 Making Use of DML in PL/SQL 40         3.1.1 Use the Select INTO Syntax for Variable Initialization 41         3.1.2 Use DML in a PL/SQL Block 42         3.1.3 Make Use of a Sequence in a PL/SQL Block 44     LAB 3.2 Making Use of SAVEPOINT 45         3.2.1 Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PL/SQL Block 48 Chapter 3 Try It Yourself 51   CHAPTER 4 Conditional Control: IF Statements 53     LAB 4.1 IF Statements 54         4.1.1 Use the IF-THEN Statement 58         4.1.2 Use the IF-THEN-ELSE Statement 62     LAB 4.2 ELSIF Statements 65         4.2.1 Use the ELSIF Statement 69     LAB 4.3 Nested IF Statements 74         4.3.1 Use Nested IF Statements 76 Chapter 4 Try It Yourself 80   CHAPTER 5 Conditional Control: CASE Statements 81     LAB 5.1 CASE Statements 82         5.1.1 Use the CASE Statement 89         5.1.2 Use the Searched CASE Statement 91     LAB 5.2 CASE Expressions 96         5.2.1 Use the CASE Expression 100     LAB 5.3 NULLIF and COALESCE Functions 103         5.3.1 The NULLIF Function 107         5.3.2 Use the COALESCE Function 109 Chapter 5 Try It Yourself 112   CHAPTER 6 Iterative Control: Part I 113     LAB 6.1 Simple Loops 114         6.1.1 Use Simple Loops with EXIT Conditions 118         6.1.2 Use Simple Loops with EXIT WHEN Conditions 120     LAB 6.2 WHILE Loops 124         6.2.1 Use WHILE Loops 128     LAB 6.3 Numeric FOR Loops 132         6.3.1 Use Numeric FOR Loops with the IN Option 137         6.3.2 Use Numeric FOR Loops with the REVERSE Option 139 Chapter 6 Try It Yourself 142   CHAPTER 7 Iterative Control: Part II 143     LAB 7.1 The CONTINUE Statement 144         7.1.1 Use t...