OCS is becoming the dominant product for large-scale collaboration--blending core functions of e-mail, file serving, and diary management with the additional functionality of web conferencing, instant messaging, and wireless access. Pro Oracle Collaboration Suite 10g provides all you need to know to install and configure OCS for use, but this book is much more than a to-do list. It covers the architecture of the server processes and the applications, giving you the theoretical background to tak e OCS beyond the basics. There's no need to worry if you're new to the Oracle database, Oracle Components for Java environment (OC4J), HTTP web servers, or LDAP Internet directories--everything is explained carefully. But if you are already familiar with these topics, you'll learn how to fully exploit them in order to optimize your OCS installation.

Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many ot her topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.

Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux servers--all in an easy reading and quick-to-navigate fo rmat. Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Appli cations Release 12 and Fusion.

If you are constantly under time pressure from SLAs or product release deadlines, then pick up a copy of Pro Oracle 10g Performance Tuning. This practical field guide will help you diagnose and resolve common, everyday problems such as poorly performing SQL queries, database and session hang, and sudden slow performance of a production database. Author Soumendra Paik includes comprehensive demos of the Oracle performance diagnostic toolkit. You will learn to identify and analyze a performance b ottleneck, isolate the root cause, apply different possible resolutions, and then quantify performance improvements&emdash;all in a quick and effective manner.

JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the author's other book, JDBC Recipes: A Problem-Solution Approach, leaves off. This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developer's application development.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong? If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL. The cost-based optimizer is simply a piece of code that contains a model of how Oracl e databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples--not just "showcase" examples. This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring O racle DBA needs to build and admisiter complex Oracle 10g databases.

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.

With Oracle in the process of de-supporting SQLJ, JDBC is now really the only recommended means of interfacing between Java and Oracle. Consequently, this book is a must have for any developer building an Oracle Java application. Many Java developers tend to treat Oracle as a "black box"; as a consequence, developers tend to write incorrect, non-scalable code. If you don't intimately know how Oracle works and expects you to program, you might avoid Oracle extensions to the standard for fear of your code becoming database-dependent. If you give in to that fear, you'll miss out on the extensive out-of-the-box functionality that Oracle offers. This book teaches you how to build efficient, high-performance, and robust Oracle-based JDBC applications. You'll discover the full details of Oracle's implementation of the JDBC 3.0 standard (what it supports, what it doesn't and what extensions Oracle provides), and more. This book tackles issues head-on, detailing concisely and clearly the vita l details of Oracle's architecture and mode of operation that directly impact the manner in which JDBC applications should be written. Only when armed with this knowledge, a willingness to exploit the database to its full potential in your JDBC code, and the ability to use Oracle's SQL and PL/SQL features when appropriate, is it possible to write truly efficient, robust, scalable and high performance applications.

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte--it's very tempting to call him an Oracle oracle--seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is emin ently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment--and alternative ways of looking at the more familiar ones--solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Oracle d atabases.

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database. This book is an effective tool for you to w rite effective SQL for the Oracle database. The text is fully compliant with the latest version of the ANSI SQL standard, and fully update for the Oracle 10g database. This book is a translation of popular Netherlands college text (currently in its third edition). Author Lex de Haan is highly experienced with the Oracle database, and has twenty-five years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.

This book offers Oracle DBAs training appropriate for understanding and handling PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Written by a field expert, this book answers common questions and misunderstandings that arise from use of PeopleSoft on an Oracle database. The result is a highly effective training manual for any Oracle DBA charged with the maintenance of a PeopleSoft sys tem.

Oracle Spatial is changing the way spatial information is used in organizations. This book addresses: (1) the special nature of spatial data and its role in professional and consumer applications, (2) the issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data; (3) the Oracle Spatial solution and the integration of spatial data into enterprise databases; and (4) how spatial information is used to understand business and support decisions, to manage cust omer relations, and to better serve private and corporate users. Pro Oracle Spatial shows how any Oracle application that has a spatial element (e.g. postcode) can take advantage of Spatial functionality. Thoroughly tech reviewed, this book contains case studies of more advanced applications of spatial in healthcare, telecom, retail, and distribution industries. Pro Oracle Spatial is based on extensive feedback from training courses, discussion lists, and customers. It recommends best practice approaches to the most common problems with which developers struggle.

This book never loses sight of its instructional mission: to effectively utilize the Oracle database from the .NET environment. Though Visual Studio and Oracle form a popular and powerful duo, there is a noticeable lack of written material in this area. The result: projects that often turn out with less-than-optimal solutions, due to lack of "synergy" between the application developer and the database. The primary code in the book will be C#, but the code download will also be available in VB.N ET (with an appendix describing terms of use). Hence, this book provides a one-stop reference for any VS.NET programmer using Oracle. The author maintains solid focus on databases - emphasizing the use of specific features from a Visual Studio application. The text also includes crucial aspects of developing Oracle-based applications. Assumably, you are already comfortable with the VS.NET environment, and with the aid of this book, you will come to work effectively with the Oracle database as we ll.

This book is based on the very latest version of Oracle's fully J2EE- certified Application Server (previously called Oracle9iAS). Oracle Corp.Adoption interest is growing rapidly amidst favorable reports regarding performance and reliability. Deploying J2EE applications and configuring the application server are known to be the most tricky and non-standard elements of J2EE development, and thus they receive scant attention in general J2EE texts. This book provides a focused, no-frills guide to getting J2EE applications up and running on 10G. It covers Oracle's J2EE container, OC4J (available for free for development purposes), in full detail and then moves on to explain how to configure and use the various enterprise-level features that come with the commercial editions.

Apress has gathered 12 of the most talented and famous Oracle experts in the world to bring you Oracle Insights, Tales of the Oak Table. Eleven of the talented 12-author team are members of the prestigious Oak Table society and, each author has contributed by writing a single chapter. With a combined 90 years of Oracle experience, this impressive team has worked on some of the very largest and most complex (and in some cases, most infamous) Oracle projects in the world. Oracle Insights, Tales of the Oak Table is the collected experiences of the Oak Table team, placed against the backdrop of Oracle's evolution, and highlights some of the groundbreaking software and techniques that the authors invented in response to the challenges facing them, and how these techniques are relevant today. Each chapter of Oracle Insights, Tales of the Oak Table, is based on the author's real life experiences working with Oracle on various significant projects. The chapters are written in an anecdotal, hu morous manner, with the underlying intent to teach readers the general lessons learned from these projects and, more specifically, the techniques that emerged or evolved as a result of these projects. As described in Oracle Insights, Tales of the Oak Table, some of the authors will have crossed paths during certain projects described in the book. The book will provide a foldout color map, which attempts to show the time, and project where the authors met which, helps the readers to understand t he incredible relationship, both professional and personal, that the Oak Table experts have.

Stop dreaming small, or you will always be small. From the beginning of time, people have been working for a living and, chances are, you're carrying on this tradition. Whether you labor as a frontline worker or toil in high-level management, this book is for you. This isn't a Greek tragedy nor a retelling of the woes of the business world that we hear about every day in the news, and it's not a comedy that pokes fun at the idiocies that people witness daily in the workplace. Unite the Tribes: E nding Turf Wars for Career and Business Success shows the imaginary lines that divide companies into separate "tribes," with each fighting the other in small and petty turf wars. From this new perspective, you'll see how such internal divisiveness weakens your business and makes employees vulnerable to competitors in the marketplace.

Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription - it involves matching application-specific knowledge with what's happening inside the database. Based on the author's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success. The Art and Science of Oracle Performance Tuning shows you: A proven process for performance tuning How to objectively categorize the problem The human and business aspects of tuning as well as the technical know-how How to trace problems to their root cause Analyzing the cost of SQL statements Gathering statistics - achieving quantifiable results Devising and testing a solution Case studies throughout illustrate key points

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.

"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.

2001-2007 Oracle-Books.com