Oracle Exadata Survival Guide

Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle’s Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart FlashCache, hybrid columnar compression, and more. You’ll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle’s powerful, new environment. The authors also cover migration from other servers.

Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle’s important new platform.

Helps transfer your skills to the platform of the future
Covers the important ground without going too deep
Takes a practical and hands-on approach to everyday tasks
What you’ll learn

Learn the components and basic architecture of an Exadata machine
Reduce data transfer overhead by processing queries in the storage layer
Examine and take action on Exadata-specific performance metrics
Deploy Hybrid Columnar Compression to reduce storage and I/O needs
Create worry-free migrations from existing databases into Exadata
Understand and address issues specific to ERP migrations
Who this book is for

Oracle Exadata Survival Guide is for the busy enterprise Oracle DBA who has suddenly been thrust into the Exadata arena. Readers should have a sound grasp of traditional Oracle database administration, and be prepared to learn new aspects that are specific to the Exadata appliance.

Oracle Exadata Survival Guide

Read more...

Maintain a high-performance, fully integrated security foundation across your enterprise using the detailed information in this Oracle Press guide. Designing an IAM Framework with Oracle Identity and Access Management Suite explains how to reduce risk exposure by effectively managing your full spectrum of users. Learn how to create and provision accounts, employ strong authentication and authorization, integrate legacy applications, and handle regulatory compliance. The latest performance-testing, self-auditing, and business intelligence reporting techniques are also covered in this comprehensive resource.

Establish company requirements and develop implementation plans
Build and execute your identity business case
Set up accounts, roles, and provisioning workflows using Oracle Identity Manager and Analysis
Authenticate and authorize users with Oracle Access Manager
Enact strong authorization policies using Oracle Entitlements Server
Identify anomalous behavior and create proactive fraud prevention rules with Oracle Adaptive Access Manager
Enforce regulatory compliance and generate audit-ready reports
Learn about latest additions from the acquired Sun stack

Jeff Scheidel - Designing an IAM Framework with Oracle Identity and Access Management Suite

Read more...

Oracle 11g SQL 2 Edition

Oracle 11g SQL - 2 Edition

Read more...

Oracle ADF Enterprise Application Development - Made Simple

With Application Development Framework (ADF), Oracle gives you the tool its own developers use. Modern enterprise applications must be user-friendly, visually attractive, and fast performing and Oracle Fusion Applications are just that; but to get the desired output you need proven methods to use this powerful and flexible tool to achieve success in developing your enterprise applications.


Just as you need to know more than how to wield a hammer to build a house, you need more than knowing ADF to build a successful enterprise application. This book explains how to use the technology, create a blueprint, and organize your work to ensure success.


This book takes you through an entire enterprise application development project using ADF. The book begins with a proof of concept, demonstrating the basics of the ADF technology, and then moves on to estimating the effort. You will then learn the necessary skills required to structure your project, your code, and how to build a successful enterprise project with ADF.


Additional topics allow you to explore the support tools required for source control and issue tracking, learn to integrate them into your development environment, and use them productively to develop an enterprise application. Out-of-the-box functionalities such as skinning, customization, and internationalization are discussed at length.


All you need to know about building enterprise applications with Oracle ADF-not just the technology, but its organization, tools, and best practices.


What you will learn from this book :
• Develop an ADF application quickly using database tables together with common ADF user interface components and data visualization components
• Estimate the effort required to build an ADF enterprise application
• Organize the development team, choose support tools, and write development guidelines to ensure a uniform development approach
• Set up the necessary infrastructure and configure a development workstation
• Develop necessary templates and framework classes to allow productive and flexible development
• Build a complete application using all the enterprise support tools
• Test your ADF enterprise application at the component, integration, and system levels
• Use skinning to change the look of the application to correspond to the enterprise’s visual identity
• Customize the application to meet the needs and expectations of different users
• Secure the enterprise application and assign roles for specific functionality




Oracle ADF Enterprise Application Development - Made Simple

Read more...

Oracle Service Bus 11g Development Cookbook By Guido Schmutz, Edwin Biemond, Jan van Zoggel, Mischa Kölliker, Eric Elzinga

Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios.
This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further.
Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes.


What you will learn from this book

• Design components of a Data Mart to use as data source, maintain meta-data, and support drill-through reporting.
• Setup a Data Source and Minischema in Essbase Studio so that metadata elements can be manipulated and hierarchies built.
• Create an Essbase Model, Cube Schema, drill-through report, and deploy both a Block Storage (BSO) and Aggregate Storage (ASO) application.
• Use Essbase Administration Services (EAS) to create applications, create and use substitution variables, and add complex outline formulas in both the Block Storage (BSO) and Aggregate Storage (ASO) models.
• Create dimension build rules, flat file load rules, and SQL load rules.
• Create complex calculations using the Calculation Script Editor, optimize a cube for calculations, and run allocation calculations off an Aggregate Storage database.
• Automate processes via MaxL scripts and integrate data between Essbase databases and to relational databases
• Design effective security and build dynamic reports

Oracle Service Bus 11g Development
Password: amaderforum

Read more...

MySQL Troubleshooting: What To Do When Queries Don't Work By Sveta Smirnova

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL.
Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence.

• Understand the source of a problem, even when the solution is simple
• Handle problems that occur when applications run in multiple threads
• Debug and fix problems caused by configuration options
• Discover how operating system tuning can affect your server
• Use troubleshooting techniques specific to replication issues
• Get a reference to additional troubleshooting techniques and tools, including third-party solutions
• Learn best practices for safe and effective troubleshooting—and for preventing problems

MySQL Troubleshooting: What To Do When Queries Don't Work By Sveta Smirnova
Password: amaderforum

Read more...

PeopleSoft for the Oracle DBA By David Kurtz

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.


You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment.

• Explains PeopleSoft’s technical architecture as it relates to Oracle Database
• Demonstrates how to instrument and measure the performance of PeopleSoft
• Provides techniques to troubleshoot and resolve performance problems

What you’ll learn

• Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database
• Measure performance of the various tiers in the application
• Pinpoint and resolve performance problems within the code
• Configure server processes for optimal performance
• Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager
• Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44

Who this book is for
PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment.

PeopleSoft for the Oracle DBA By David Kurtz
Password: amaderforum

Read more...

Oracle JDeveloper 11gR2 Cookbook By Nick Haralabidis

Oracle's Application Development Framework (ADF) for Fusion Web Applications leverages Java EE best practices and proven design patterns to simplify constructing complex web solutions with JDeveloper, and this hands-on, task-based cookbook enables you to realize those complex, enterprise-scale applications. With the help of real-world implementations, practical recipes cover everything from design and construction, to deployment, testing, debugging and optimization.
This practical, task-based cookbook takes you, the ADF developer, on a practical journey for building Fusion Web Applications. By implementing a range of real world use cases, you will gain invaluable and applicable knowledge for utilizing the ADF framework with JDeveloper 11gR2.
"Oracle JDeveloper 11gR2 Cookbook" is a task-based guide to the complete lifecycle of Fusion Web Application development using Oracle JDeveloper 11gR2 and ADF.
You will get quickly up and running with concepts like setting up Application Workspaces and Projects, before delving into specific Business Components such as Entity Objects, View Objects, Application Modules and more. Along the way you will encounter even more practical recipes about ADF Faces UI components and Backing Beans, and the book rounds off by covering security, session timeouts and exceptions.
With "Oracle JDeveloper 11gR2 Cookbook" in hand you will be equipped with the practical knowledge of a range of ready to use implementation cases which can be applied to your own Fusion Web ADF Applications.


What you will learn from this book

• Get quickly up and running by downloading, installing and optimizing JDeveloper on Linux
• Absorb the foundational techniques presented for laying out the Fusion Web ADF Application during the application architectural phases
• Get to grips with using custom properties and property sets for generic programming and overriding doDML() to populate sequence attribute
• Work with View objects, List-of-Values, Bind Variables and View Criteria
• Handle security, exceptions, logging and session timeouts
• Create and use generic extension interfaces, service-enabling Application Modules and shared Applications Modules
• Go further with ADF Faces techniques like using custom listeners for query panel operations and programmatically executing operation binding
• Master Task Flow techniques such as using a Method Call activity to initialize a page and using Task Flow Initializers

Oracle JDeveloper 11gR2 Cookbook By Nick Haralabidis
Password: amaderforum

Read more...

Oracle 12 Books in one single link

1) Oracle 9i Introduction to oracle 9i PL SQL Part 2
2) Oracle4pros
3) Oracle9i The Complete Reference
4) oracle 8i complete reference
5) Oracle 9i Introduction to oracle 9i PL SQL Part 1
6) Oracle 9i Introduction to oracle 9i PL SQL Part 3
7) Oracle Database 10G - The Complete Reference 2004
8) Oracle Database 10g New Features_Robert G. Freeman
9) Oracle Database 10g XML & SQL Design, Build & Manage XML Applications in Java, C, C++ & PLSQL_Mark V. Scardina, Ben Chang and Jinyu
10) Oracle Database 10g, A Beginner's Guide_Ian Abramson
11) Oracle Introduction to SQL
12) oracle press. oracle 9i - the complete reference

Oracle 12 Books in one single link

Read more...

Oracle Administration Video Tutorial

Oracle Administration Video Tutorial - 22 lessons

Very good Video guide for Beginners.

Download all 22 lessons as a single file.

Oracle Administration Video Tutorial

Read more...

Pattern Discovery Using Sequence Data Mining Applications and Studies

Sequential data from Web server logs, online transaction logs, and performance measurements is collected each day. This sequential data is a valuable source of information, as it allows individuals to search for a particular value or event and also facilitates analysis of the frequency of certain events or sets of related events. Finding patterns in sequences is of utmost importance in many areas of science, engineering, and business scenarios.


Pattern Discovery Using Sequence Data Mining: Applications and Studies provides a comprehensive view of sequence mining techniques and presents current research and case studies in pattern discovery in sequential data by researchers and practitioners. This research identifies industry applications introduced by various sequence mining approaches.

Pattern Discovery Using Sequence Data Mining Applications and Studies


password : amaderforum

Read more...

R12 Extend Oracle Applications Customizing OA Framework Applications Student Guide

Volume 1
Volume 2
Volume 3

Read more...

Oracle JDEdwards EnterpriseOne 8 - Administration Guide

Oracle JDEdwards EnterpriseOne 8 - Administration Guide

Read more...

Oracle SOA Infrastructure Implementation Certification Handbook (1Z0-451)

Successfully ace the 1Z0-451 Oracle SOA Foundation Practitioner exam with this hands on Certification guide

• Successfully clear the first stepping stone towards becoming an Oracle Service Oriented Architecture Infrastructure Implementation Certified Expert
• The only book available to guide you through the prescribed syllabus for the 1Z0-451 Oracle SOA Foundation Practitioner exam
• Learn from a range of self-test questions to fully equip you with the knowledge to pass this exam

Oracle SOA Infrastructure Implementation Certification Handbook (1Z0-451)

Read more...

Getting Started with Oracle Data Integrator 11g : A Hands-on Tutorial

Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide

• Discover the comprehensive and sophisticated orchestration of data integration tasks made possible with ODI, including monitoring and error-management
• Get to grips with the product architecture and building data integration processes with technologies including Oracle, Microsoft SQL Server and XML files
• A comprehensive tutorial packed with tips, images and best practices

Getting Started with Oracle Data Integrator 11g : A Hands-on Tutorial

Read more...

Oracle Advanced PL/SQL Developer Professional Guide

The Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the Associate level Oracle professionals aspiring for Professional level. The topics covered and demonstrated are in line with the Oracle University prescription for Oracle Professional certification, which justify the version updates to be advanced and not complex. The book is under publication from Packt publishers and all set for its release in May, 2012.


The OCP 1Z0-146 certification is the second milestone for the Associate level Oracle professionals. The journey from Associate to Professional level enhances your reliability and credibility with the Oracle technology, catalyzes your employability, and job effectiveness. Apart from focusing the certification preparation, the book contains ample demonstrations and best programming practices which can be employed in day to day assignments.


The book aims to cover the advanced features of PL/SQL which are required to design and optimize the PL/SQL code. The recapitulation of PL/SQL programming and advanced features like collections, external procedures, server side result caching, implementing VPD to enforce row level security, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.


The book gives a deeper insight to transform the readers from mid-level programmers to professional database designers. The advanced concepts covered through this book would surely agitate the readers to dig upon and explore more on the topics.
The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs. It is under production stage and will be released by 15th May, 2012. The book is on pre sales on Packt's website, Amazon and all leading technical book distributors.

Oracle Advanced PL/SQL Developer Professional Guide

Read more...

PeopleSoft for the Oracle DBA

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz’s book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.

You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment.

Explains PeopleSoft’s technical architecture as it relates to Oracle Database
Demonstrates how to instrument and measure the performance of PeopleSoft
Provides techniques to troubleshoot and resolve performance problems

What you’ll learn

Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database
Measure performance of the various tiers in the application
Pinpoint and resolve performance problems within the code
Configure server processes for optimal performance
Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager
Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44

Who this book is for
PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment.

PeopleSoft for the Oracle DBA, 2nd Edition

Read more...

Expert Indexing in Oracle Database 11g

Expert Indexing in Oracle Database 11g is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer.

Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Indexing in Oracle Database 11g helps by bringing together information indexing and how to use it into one, convenient and blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indices available and when each is best applied. Recognize when queries aren’t using indices as you intend. Manage your indexing for maximum performance. Let Expert Indexing in Oracle Database 11g be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database.

Explains how indices work, how they help, and how they hinder
Demystifies the various index choices
Describes the database administration chores associated with indices

What you’ll learn

Create an overall indexing strategy to guide your decisions
Choose the correct indexing mechanisms for your applications
Manage and maintain indices to avoid degradation and preserve efficiency
Take better advantage of underused index types such as index-organized tables
Choose the appropriate columns to index, with confidence
Blend partitioning and materialized views into your indexing strategy

Who this book is for
Expert Indexing in Oracle Database 11g is for all levels of database administrators and application developers who are struggling with the database performance and scalability challenge. Any database administrator involved with indexing, which is any database administrator period, will appreciate the wealth of advice packed into this gem of a book.

Expert Indexing in Oracle Database 11g

Read more...

How to Stop Oracle from Fragmenting

In this paper, we provided an overview of the various kinds of fragmentation which can occur in Oracle and the techniques to avoid, detect and rectify them. We discussed common policies which can be deployed to avoid fragmentation for most of the cases. Though fragmentation is not necessarily always avoidable the authors believe that this subject has been overly exposed and the time spent on this matter could probably be well spent otherwise. We encourage Oracle DBAs to further refine this document with their own policies and techniques. We would also like to thank Jonathan Klein, Franco Putzolu, Alex Tsukerman and Richard Sarwal amongst others for kindly taking the time to review this document and helping making it accurate and hopefully complete.

How to Stop Oracle from Fragmenting

Read more...

Oracle Service Bus 11g Development Cookbook

 

In Detail
Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios.
This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further.
Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes.

What you will learn from this book

• Design components of a Data Mart to use as data source, maintain meta-data, and support drill-through reporting.
• Setup a Data Source and Minischema in Essbase Studio so that metadata elements can be manipulated and hierarchies built.
• Create an Essbase Model, Cube Schema, drill-through report, and deploy both a Block Storage (BSO) and Aggregate Storage (ASO) application.
• Use Essbase Administration Services (EAS) to create applications, create and use substitution variables, and add complex outline formulas in both the Block Storage (BSO) and Aggregate Storage (ASO) models.
• Create dimension build rules, flat file load rules, and SQL load rules.
• Create complex calculations using the Calculation Script Editor, optimize a cube for calculations, and run allocation calculations off an Aggregate Storage database.
• Automate processes via MaxL scripts and integrate data between Essbase databases and to relational databases
• Design effective security and build dynamic reports

Approach
This cookbook is full of immediately useable recipes showing you the advanced development techniques when building Essbase Applications and how to take these applications further.
This cookbook offers practical, task-based, and immediately usable recipes covering a wide range of advanced development techniques to build Essbase Applications and take them further. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in Essbase and wants to improve. The book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order.

Oracle Service Bus 11g Development Cookbook

or

Oracle Service Bus 11g Development Cookbook

Read more...