Author: Rick Greenwald,Robert Stackowiak,Jonathan Stern
Publisher: "O'Reilly Media, Inc."
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutions
As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book’s timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.
A complete guide to SQL*Loader, a utility used to move data from external files into an Oracle database, offers step-by-step instruction in the various applications of SQL*Loader, providing a task-oriented approach that covers the latest Oracle 8 and Oracle 8i features. Original. (Beginner/Intermediate)
Author: Rick Greenwald,Robert Stackowiak,Donald Bales
Publisher: "O'Reilly Media, Inc."
The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server. This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web caching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, the authors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server. More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, Oracle Application Server 10g Essentials offers Oracle application developers and administrators everything they need to know about this powerful server.
Oracle Languages - Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database.
Author: Robert Stackowiak,Joseph Rayman,Rick Greenwald
Publisher: John Wiley & Sons
Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations. Avoid many common pitfalls while learning best practices for: Leveraging Oracle technologies to design, build, and manage data warehouses Integrating specific database and business intelligence solutions from other vendors Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more Handling typical data warehouse performance challenges Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk
Thousands of IT organizations have adopted clustering to improve the availability of mission-critical software services. Today, with the rapid growth of cloud computing environments, clustering is even more crucial. Now, there’s a comprehensive, authoritative guide to the industry’s most stable, robust clustering platform: the Oracle Solaris Cluster. Oracle® Solaris Cluster Essentials thoroughly covers both Oracle Solaris Cluster 3.2 and Oracle Solaris Cluster Geographic Edition, offering start-to-finish lifecycle guidance for planning, implementation, management, and troubleshooting. Authored by Oracle Solaris Cluster expert Tim Read, this book covers both high availability and disaster recovery features, and offers detailed guidance for both Oracle and non-Oracle database environments. It also presents several example implementations that can be used to quickly construct effective proofs-of-concept. Whether you’re new to clustering or upgrading from older solutions,this bookbrings together all the information you’ll need to maximize the value, reliability, and performance of any Oracle Solaris Cluster environment. You’ll learn how to Understand Oracle Solaris Cluster’s product features and architecture, and their implications for design and performance Establish requirements and design clustered systems that reflect them Master best practices for integrating clustering with virtualization Implement proven disaster recovery planning techniques Efficiently maintain Oracle Solaris Cluster environments Part of the Solaris System Administration Series, Oracle® Solaris Cluster Essentials combines a complete technology introduction and hands-on guide for every architect, administrator, and IT manager responsible for high availability and business continuity.
If you are a data analyst, developer, or simply someone who wants to use Hive to explore and analyze data in Hadoop, this is the book for you. Whether you are new to big data or an expert, with this book, you will be able to master both the basic and the advanced features of Hive. Since Hive is an SQL-like language, some previous experience with the SQL language and databases is useful to have a better understanding of this book.
This is a practical guide to Oracle Fusion Applications, which illustrates concepts using handson examples. It is comprehensive and covers all the essentials of Oracle Fusion Applications administration. This book is ideal for application and database administrators who are looking to get an understanding of administering Oracle Fusion Applications. Familiarity with Oracle Database Administration and an operational Oracle Fusion Applications environment would be useful, but is not required.
Annotation Oracle RAC or Real Application Clusters is a grid computing solution that allows multiple nodes (servers) in a clustered system to mount and open a single database that resides on shared disk storage. Should a single system (node) fail, the database service will still be available on the remaining nodes. Oracle RAC is an integral part of the Oracle database setup. You have one database with multiple users accessing it, in real time. This book will enable DBAs to get their finger on the pulse of the Oracle 11g RAC environment quickly and easily. This book will cover all areas of the Oracle RAC environment and is indispensable if you are an Oracle DBA who is charged with configuring and implementing Oracle11g R1, with bonus R2 information included. This book presents a complete method for the configuration, installation, and design of Oracle 11g RAC, ultimately enabling rapid administration of Oracle 11g RAC environments. This practical handbook documents how to administer a complex Oracle 11g RAC environment. Packed with real world examples, expert tips and troubleshooting advice, the book begins by introducing the concept of Oracle RAC and High Availability. It then dives deep into the world of RAC configuration, installation and design, enabling you to support complex RAC environments for real world deployments. Chapters cover Oracle RAC and High Availability, Oracle 11g RAC Architecture, Oracle 11g RAC Installation, Automatic Storage Management, Troubleshooting, Workload Management and much more. By following the practical examples in this book, you will learn every concept of the RAC environment and how to successfully support complex Oracle 11g R1 and R2 RAC environments for various deployments within real world situations. This book is the updated release of our previous Oracle 11g R1/R2 Real Application Clusters Handbook. If you already own a copy of that Handbook, there is no need to upgrade to this book.
This book is packed with real world examples that cover the design and discipline of the software and service of CRMOD. If you are a CRMOD Administrator, Business Analyst or a CRM implementation specialist looking forward to implement CRM On Demand or enhance and maintain an existing CRM On Demand deployment, then this is the guide for you.
"Learning Oracle PL/SQL" introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle. A consistent and understandable example application--the development of a library's electronic catalog system--runs through the chapters.