• Computers

Effective Oracle by Design


Author: Thomas Kyte
Publisher: McGraw Hill Professional
ISBN: 0071776788
Category: Computers
Page: 688
View: 4524
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.

    • Computers

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning


Author: Richmond Shee,Kirtikumar Deshpande,K Gopalakrishnan
Publisher: McGraw Hill Professional
ISBN: 0071483756
Category: Computers
Page: 384
View: 3768
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.

    • Computers

Oracle Database 10g: A Beginner's Guide


Author: Ian Abramson,Michael Abbey,Michael Corey
Publisher: McGraw Hill Professional
ISBN: 9780071706773
Category: Computers
Page: 416
View: 7630
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

    • Computers

Oracle SQL Tricks and Workarounds

Expert Guide to Oracle SQL Excellence
Author: Zahar Hilkevich
Publisher: AuthorHouse
ISBN: 1463421354
Category: Computers
Page: 252
View: 4430
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.

    • Computers

Oracle JDeveloper 3 Handbook


Author: Paul Dorsey,Peter Koletzke
Publisher: McGraw-Hill Osborne Media
ISBN: 9780072127164
Category: Computers
Page: 593
View: 1032
Introduces the integrated Java development and deployment environment, offering an object-oriented approach to building Web and database application.

    • Computers

Oracle Database Performance and Scalability

A Quantitative Approach
Author: Henry H. Liu
Publisher: John Wiley & Sons
ISBN: 111805699X
Category: Computers
Page: 694
View: 5928
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.

    • Computers

Pro Oracle SQL


Author: Karen Morton,Kerry Osborne,Robyn Sands,Riyaj Shamsudeen,Jared Still
Publisher: Apress
ISBN: 1430262206
Category: Computers
Page: 580
View: 9725
Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You’ll learn analytic functions, the MODEL clause, and advanced grouping syntax—features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You’ll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more. You’ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You’ll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance Comprehensive—goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. Performance focused—teaches you how to measure the performance of your SQL statements and not just the syntax. What you’ll learn Master powerful SQL features implemented in the Oracle Database Understand how the Oracle Optimizer develops execution plans Read and interpret SQL execution plans Quickly diagnose and fix badly performing SQL Control execution plans through hints, profiles, and plan baselines Optimize queries within packaged applications without touching the code Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL, Second Edition is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle’s specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and the WITH clause (subquery factoring) that are designed to help developers and database administrators exert control over their SQL environment and its execution. Table of Contents Core SQL SQL Execution Access and Join Methods SQL is About Sets It’s About the Question SQL Execution Plans Advanced Grouping Analytic Functions The Model Clause Subquery Factoring Semi-joins and Anti-joins Indexes Beyond the SELECT Transaction Processing Testing and Quality Assurance Plan Stability Plan Management/Control Cool SQL Constructs

    • Computers

Oracle Hyperion Financial Management Tips And Techniques

Design, Implementation & Support
Author: Peter Fugere
Publisher: McGraw Hill Professional
ISBN: 0071770453
Category: Computers
Page: 512
View: 8873
Master Oracle Hyperion Financial Management Consolidate financial data and maintain a scalable compliance framework with expert instruction from an Oracle ACE. Oracle Hyperion Financial Management Tips & Techniques provides advanced, time-saving procedures not documented in user manuals or help files. Find out how to configure Oracle Hyperion Financial Management, import and reconcile data, deliver dynamic business reports, and automate administrative tasks. Stragegies for supporting, testing, and tuning your application are also covered in this comprehensive Oracle Press guide. Establish objectives and develop an effective rollout plan Set up and customize Oracle Hyperion Financial Management Create rules using VBScript and the Calculation Manager feature of Oracle Hyperion Foundation Services Load, test, and reconcile your data with Oracle Data Integrator and Oracle Hyperion Financial Data Quality Management Design, update, and distribute Web-based business reports Integrate content from Microsoft Excel, Word, and PowerPoint using SmartView Work with the Lifecycle Management feature of Oracle Hyperion Foundation Services Identify and resolve performance, design, and capacity problems

    • Computers

JD Edwards EnterpriseOne, The Complete Reference


Author: Allen Jacot,Joseph Miller,Michael Jacot,John Stern
Publisher: McGraw Hill Professional
ISBN: 007159874X
Category: Computers
Page: 1296
View: 3969
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

    • Computers

Oracle CRM On Demand Deployment Guide


Author: Jeff Saenger,Tim Koehler,Louis Peters
Publisher: McGraw Hill Professional
ISBN: 0071717625
Category: Computers
Page: 240
View: 636
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

    • Computers

Managing Oracle Fusion Applications


Author: Richard Bingham
Publisher: McGraw Hill Professional
ISBN: 0071750347
Category: Computers
Page: 352
View: 9782
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

    • Computers

Oracle Database 11g PL/SQL Programming


Author: Michael McLaughlin
Publisher: McGraw Hill Professional
ISBN: 0071643567
Category: Computers
Page: 835
View: 391
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

    • Computers

Expert Oracle Database Architecture

Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
Author: Thomas Kyte
Publisher: Apress
ISBN: 1430229462
Category: Computers
Page: 832
View: 4624
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

    • Computers

Oracle Performance Tuning 101


Author: Kirtikumar Deshpande,John Kostelac
Publisher: McGraw-Hill Osborne Media
ISBN: 9780072131451
Category: Computers
Page: 404
View: 6093
Tuning Oracle databases or Oracle Performance Management (OPM) is what database administrators (DBAs) do to help the database run optimally. With the increase in e-commerce and deployment of databases and applications on the Internet, the task of keeping databases running is becoming increasingly important. This entry-level study teaches the essentials of keeping databases running at top performance. The guide covers releases 7.3 through 8i for NT, Linux and Unix platforms.

    • Computers

Optimizing Oracle Performance

A Practitioner's Guide to Optimizing Response Time
Author: Cary Millsap,Jeff Holt
Publisher: "O'Reilly Media, Inc."
ISBN: 1449366783
Category: Computers
Page: 418
View: 6296
Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes.Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old.Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.The price of this essential book will be paid back in hours saved the first time its methods are used.

    • Computers

Expert Oracle Database Architecture


Author: Thomas Kyte,Darl Kuhn
Publisher: Apress
ISBN: 1430262990
Category: Computers
Page: 824
View: 5991
Now in its third edition, this best-selling book 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 Kyte and Darl Kuhn share 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 third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. 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. Revised to cover Oracle Database 12c Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Database’s most powerful features

    • Computers

Expert One-on-One Oracle


Author: Thomas Kyte
Publisher: Apress
ISBN: 9781430212799
Category: Computers
Page: 1328
View: 9222
* 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.

    • Computers

Oracle Database 10g The Complete Reference


Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 0071770496
Category: Computers
Page: 1392
View: 5002
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.

    • Computers

Expert One-on-One Oracle


Author: Thomas Kyte
Publisher: Apress
ISBN: 9781430200192
Category: Computers
Page: 1328
View: 4672
* 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.