Effective Oracle by Design

Author: Thomas Kyte
Publisher: McGraw Hill Professional
ISBN: 9780071776783
Release Date: 2003-09-12
Genre: Computers

Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Oracle Wait Interface A Practical Guide to Performance Diagnostics Tuning

Author: Richmond Shee
Publisher: McGraw Hill Professional
ISBN: 9780071483759
Release Date: 2004-07-16
Genre: Computers

Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Oracle SQL Tricks and Workarounds

Author: Zahar Hilkevich
Publisher: AuthorHouse
ISBN: 9781463421359
Release Date: 2011-08-01
Genre: Computers

This book introduces a relatively new approach to mastering one’s Oracle SQL skills. This book will teach you how to leverage your existing Oracle SQL knowledge as well as how you can benefit from a variety of SQL tricks and techniques we present thereafter. This is a text book rather than a reference, and it aims to teach you how to become a better SQL specialist. Even though the recommendations found in this book may be applied to a variety of SQL flavors, Oracle SQL is the main subject of this book. Our goal was not to impress you with clever tricks and sophisticated techniques, but rather give you a roadmap to excellence in writing Oracle SQL queries. No doubt, this book presents tricks and classy approaches, which still serve the main goal – to let you master your Oracle SQL skills.

JD Edwards EnterpriseOne The Complete Reference

Author: Allen Jacot
Publisher: McGraw Hill Professional
ISBN: 9780071598743
Release Date: 2008-12-15
Genre: Computers

Your definitive guide to JD Edwards EnterpriseOne Implement and maintain a fully integrated, SOA-based ERP framework across your entire corporation. JD Edwards EnterpriseOne: The Complete Reference explains how to install and administer JD Edwards EnterpriseOne, store BI information in data marts and warehouses, manage servers and portals, and develop customized applications and kernel processes. You'll also learn how to create and distribute packages, use the security workbench, optimize performance, and apply the latest JD Edwards EnterpriseOne updates and tools releases. Set up and configure the JD Edwards EnterpriseOne applications suite Work with Oracle, SQL Server, DB2, MSDE, and SSE data sources Define JD Edwards EnterpriseOne path codes, task views, and environments Deploy the object configuration manager and solution explorer Build client and server packages, media objects, and data warehouses Secure JD Edwards EnterpriseOne using LDAP, single sign-on, and third-party tools Administer portals and Web sites using JD Edwards EnterpriseOne's HTML server and server manager Troubleshoot and tune your system using the performance workbench Covers Release 8.12

Oracle CRM On Demand Deployment Guide

Author: Jeff Saenger
Publisher: McGraw Hill Professional
ISBN: 9780071717625
Release Date: 2010-06-05
Genre: Computers

Master Oracle CRM On Demand Foster long-term customer relationships and accelerate productivity using the proven strategies and best practices in this Oracle Press guide. Oracle CRM On Demand Deployment Guide shows how to set up, customize, and manage a dynamic software-as-a-service solution across your enterprise. Develop implementation plans, maximize user adoption, build applets and portals, integrate Web 2.0 features, and use analytics dashboards. The latest design, tuning, and data security techniques are also covered in this practical resource. Establish business objectives, project requirements, and key success metrics Staff an implementation team and develop effective rollout plans Configure, deploy, and administer Oracle CRM On Demand Manage users and restrict access using roles and privileges Customize sales, marketing, and service processes with the object model Embed external content and URLs using the web services API Distribute real-time BI using dashboards and advanced reporting tools Incorporate web tabs, mashups, Google services, and RSS feeds Use workflow to automate business process management

Expert One on One Oracle

Author: Thomas Kyte
Publisher: Apress
ISBN: 1430212799
Release Date: 2010-11-16
Genre: Computers

* A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.

Oracle JDeveloper 3 Handbook

Author: Paul Dorsey
Publisher: McGraw-Hill Osborne Media
ISBN: 0072127163
Release Date: 2001
Genre: Computers

Introduces the integrated Java development and deployment environment, offering an object-oriented approach to building Web and database application.

Oracle Database Performance and Scalability

Author: Henry H. Liu
Publisher: John Wiley & Sons
ISBN: 9781118056998
Release Date: 2011-11-22
Genre: Computers

A data-driven, fact-based, quantitative text on Oracleperformance and scalability With database concepts and theories clearly explained inOracle's context, readers quickly learn how to fully leverageOracle's performance and scalability capabilities at every stage ofdesigning and developing an Oracle-based enterprise application.The book is based on the author's more than ten years of experienceworking with Oracle, and is filled with dependable, tested, andproven performance optimization techniques. Oracle Database Performance and Scalability is dividedinto four parts that enable readers to progressively learn andapply new skills: Part 1, Getting Started with Oracle, describes how to set up aworking Oracle environment, offering a quick tour to illustratemajor database concepts Part 2, Oracle Architecture from Performance and ScalabilityPerspectives, explains all the major database concepts andarchitectural features that readers need to know to optimize Oracleperformance and scalability Part 3, Optimizing Oracle Performance and Scalability, offershands-on instructions to optimize and fine-tune performance andscalability for all database applications Part 4, Case Studies: Oracle Meeting Real-World Performance andScalability Challenges, sets forth quantitative case studies basedon the author's first-hand experience that demonstrate how readerscan apply proven techniques to dramatically improve the performanceand scalability of actual database products In addition to case studies, this book offers a detailed secureonline banking application as an example, making it possible forreaders to fully explore Oracle's performance and scalabilityfeatures on their own. Oracle Database Performance andScalability is an ideal text for pre-conditioning collegestudents and training software developers.

Oracle Database 11g PL SQL Programming

Author: Michael McLaughlin
Publisher: McGraw Hill Professional
ISBN: 9780071643566
Release Date: 2008-04-19
Genre: Computers

Design Feature-Rich PL/SQL Applications Deliver 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 programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit

Managing Oracle Fusion Applications

Author: Richard Bingham
Publisher: McGraw Hill Professional
ISBN: 9780071750349
Release Date: 2011-03-08
Genre: Computers

Master Oracle Fusion Applications Administer a fully integrated application management framework across your enterprise using the detailed information contained in this Oracle Press guide. Managing Oracle Fusion Applications first explains key principles and then logically groups utilities into practical, ready-to-use toolboxes. Learn how to build lifecycle models, deliver dynamic business intelligence, optimize performance, mitigate risk, and integrate the latest Web 2.0 and social networking features. Compliance, security, and testing techniques are also covered in this comprehensive resource. Understand the components and architecture of Oracle Fusion Applications Plan, develop, and implement an effective application management plan Resolve reliability issues with Oracle Enterprise Manager Configure and deploy applications from the Oracle WebLogic Server Administration Console Adjust run-time parameters using Java Management Extensions and MBeans Generate and distribute reports using Oracle Business Intelligence 11g Establish solid user authentication, access control, and data protection policies Work with Oracle Fusion Governance, Risk, and Compliance Intelligence

Effective Oracle by Design

Author: Thomas Kyte
Publisher: McGraw Hill Professional
ISBN: 9780072230659
Release Date: 2003-08-22
Genre: Computers

Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Oracle Database 12c Release 2 Performance Tuning Tips Techniques

Author: Richard Niemiec
Publisher: McGraw Hill Professional
ISBN: 9781259589690
Release Date: 2017-03-22
Genre: Computers

Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 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 12c Release 2 Performance Tuning Tips and Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, 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 12c Release 2 • Work effectively with Oracle Cloud, Oracle Exadata, and Oracle Enterprise Manager • Efficiently manage disk drives, ASM, RAID arrays, and memory • Tune queries with Oracle SQL hints and the Trace utility • Troubleshoot databases using V$ views and X$ tables • Create your first cloud database service and prepare for hybrid cloud • Generate reports using Oracle’s Statspack and Automatic Workload Repository tools • Use sar, vmstat, and iostat to monitor operating system statistics

Expert Oracle Database Architecture

Author: Thomas Kyte
Publisher: Apress
ISBN: 9781430229469
Release Date: 2010-07-26
Genre: Computers

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 management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the developments up to 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. Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. Fully revised to cover Oracle Database 11g Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Databases’s most powerful features What you’ll learn Develop an evidence-based approach to problem solving Manage transactions in highly concurrent environments Speed access to data through table and index design Manage files and memory structures for performance and reliability Scale up through partitioning and parallel processing Load and unload data to interface with external systems Think for yourself; don’t take Tom’s word for it! Who this book is for This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go-to book for those wishing to create efficient and scalable applications. Table of Contents Developing Successful Oracle Applications Architecture Overview Files Memory Structures Oracle Processes Locking and Latching Concurrency and Multi-versioning Transactions Redo and Undo Database Tables Indexes Datatypes Partitioning Parallel Execution Data Loading and Unloading Data Encryption

Oracle E Business Suite Development Extensibility Handbook

Author: Anil Passi
Publisher: McGraw Hill Professional
ISBN: 9780071629416
Release Date: 2009-10-06
Genre: Computers

Extend and Customize Oracle E-Business Suite Transform your Oracle E-Business Suite infrastructure to suit enterprise requirements using the comprehensive development methods in this Oracle Press guide. Oracle E-Business Suite Development & Extensibility Handbook lays out each tool alongside reusable code and step-by-step examples. Learn how to create multiorg objects, integrate Java and PL/SQL, design custom user interfaces, and use Oracle Application Framework and Oracle Workflow. This detailed volume also explains how to work with Oracle XML Gateway, publish dynamic business intelligence reports, and tune your configuration. Manage an efficient development platform with Oracle Application Object Library Develop concurrent programs, customized forms, and personalized graphical user interfaces Securely share data between organizations Distribute business communiqués through Oracle Reports and Oracle Business Intelligence Publisher Develop Java extensions with Oracle JDeveloper and Oracle Application Framework Capture and graphically map business processes using Oracle Workflow Exchange data between applications via Oracle XML Gateway Change the appearance of applications using Custom Look and Feel Integrate Oracle E-Business Suite with service-oriented architecture using Oracle Applications Adapter On Demand

Oracle Database 10g The Complete Reference

Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 9780071770491
Release Date: 2004-09-28
Genre: Computers

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.