Oracle 10g/11g Data and Database Management Utilities

[patris1]

Oracle 10g/11g Data and Database Management Utilities by Hector R. Madrid
Publisher: P-Pu (June 26, 2009) | 432 pages | ISBN: 1847196284 | PDF | 4.8 MB

Master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database tasks

* Optimize time-consuming tasks efficiently using the Oracle database utilities
* Perform data loads on the fly and replace the functionality of the old export and import utilities using Data Pump or SQL*Loader
* Boost database defenses with Oracle Wallet Manager and Security
* A handbook with lots of practical content with real-life scenarios

In Detail Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.

You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work.

Data management is one of the most frequently required tasks; doing a backup is a must-do task for any company. Data management includes several tasks such as data transfers, data uploading and downloading, reorganizing data, and data cloning, among many others. If people learn to use a tool and things appear to go well, few will question if their approach is optimal. Often it is only when maintenance windows start shrinking, due to the amount of data and business availability, that problems with any particular approach get identified. If people get used to the old export/import utilities to perform data management and if it works, they probably will consider the problem solved and will continue to use an obsolete tool. This book explores further possibilities and new tools. It makes the user question if his/her current environment is optimized and teaches how to adopt more optimized data management techniques focusing to the tools and the requirements most frequently seen in modern production environments.

What you will learn from this book?

* Improve performance and manageability using the advanced features of direct export/import utilities among different databases
* Optimize your maintenance windows related to data management tasks such as importing data from one database to another using Data Pump and SQL*Loader
* Perform more than just the ETL processes by taking advantage of the external tables feature
* Use Oracle Scheduler to specify maintenance windows, assign priorities, configure job classes and many more features, and take decisions based on the task outcome
* Get acquainted with all the possibilities the Oracle Universal Installer tool offers to make the installation task more efficient
* Execute effective database creations: not just default creations, but comprehensive database creations
* Configure and manage an ASM environment using DBCA
* Improve performance and reduce the impact of recovery manager database backups in production environments
* Increase the security in an Oracle environment, protect the backups, and manage certificates using Oracle Wallet Manager
* Perform installations in batch environments and manage your software updates related to Critical Patch Updates (CPU) or individual patches using OPatch

Approach

This book is written using a practical approach that guides you through different practical scenarios. It provides a brief introduction to the topics; this way you can quickly get to know the main features, start being productive with the tool, and grow with it at a fast pace. You won't have to spend too much time getting to the basics of the tool and can immediately progress towards the advanced tips.

Using this practical approach you don't have to spend valuable time trying to decipher arid reference manuals; you can easily set up the practical scenarios, and try to follow up the presentations. The images used in the book come from real scenarios, and the output is always explained so you can easily interpret what is being displayed on the screen after issuing the commands.

Who this book is written for?

This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it.

Entry-level users will get acquainted with the best practices to get their job done in a timely and efficient manner. Advanced users will find useful tips and How-Tos that will help them focus on getting the most out of the database utilities and fine-tune batch processing.

About the Author
Hector R. Madrid

Hector Madrid is currently working as a freelance consultant. He collaborates with Oracle University as a certified instructor for the DBA and Java curriculum tracks. He is a highly respected Oracle professional with 20 years of experience as a full time DBA. He works with a wide range of DBA requirements from the daily DBA routine duties to tasks related to mission-critical and high availability systems. He was the first Oracle Certified Master in Latin America and he holds the certificate for all Oracle Version starting with 7.0 and up to 11g.

He obtained a Masters Degree in Computer Sciences from the Metropolitan Autonomous University (UAM) and he has presented different technical papers at several Oracle conferences.


DoWnLoAd FiLe

mirror

mirror

[patris1]

Oracle Data Guard 11g Handbook

Product Description
Master Oracle Data Guard 11g
Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download.

• Develop a disaster recovery plan for your Oracle database to meet your organization’s requirements
• Configure and deploy Oracle Data Guard for your environment
• Tune and troubleshoot your physical and logical standby databases
• Implement the Oracle Data Guard Broker management framework
• Integrate with Oracle Grid Control
• Monitor your Oracle Data Guard environment
• Enable read-only services and disaster recovery with Oracle Active Data Guard
• Configure seamless database and application failover
• Minimize planned downtime using Oracle Data Guard switchover
• Handle backup and recovery with Oracle Recovery Manager

download

Oracle Application Express Forms Converter

Product Description
Convert your Oracle Forms applications to Oracle APEX successfully

• Convert your Oracle Forms Applications to Oracle APEX
• Master the different stages of a successful Oracle Forms to APEX conversion project
• Packed with screenshots and clear explanations to facilitate learning

• A step-by-step tutorial providing a proper understanding of Oracle conversion concepts

In Detail Although Oracle Forms remains popular, many developers now see Oracle APEX as a preferred technology. Oracle Forms to Oracle APEX conversion projects follow a well-defined procedure, but sub-procedures and complexities can arise that make such conversion projects a challenging job.
This book will take you through a real Oracle Forms to APEX conversion project. It explains all the elements of the conversion, from generating XML files to the deployment of a working APEX application. By the end of this book, you will have mastered the process of Forms conversion.
The book starts with the details of the Forms project, and prepares you for the conversion process. You will use the rwconverter and Reports Builder in Oracle Developer Suite to generate XML and other useful files. You will plan and define the business logic for your conversion project. You will use the Forms Converter in Oracle APEX to convert and customize your Oracle Forms applications. Finally, you will deploy your application.
With this book you will understand what a Forms Conversion project in Oracle APEX means, what needs to be done, and what steps are necessary in order to create a fully functional and meaningful conversion project. This book shows the best way to convert applications from Forms to APEX.

download

Oracle 10g RAC Grid, Services & Clustering

Product Description
Grid architecture is Oracle’s strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC.
Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.
* Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database
version 10g Release 2
* Provides extensive coverage of usage, day-to-day functions and operations
* Includes tips and techniques such as script samples
to illustrate various features of RAC
* A jumpstart into all the key features of 10g R2 RAC

download

Oracle Performance Tuning for 10gR2, Second Edition

Product Description
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.
Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.
* Fully updated for version 10gR2 and provides all necessary transition material from version 9i
* Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective

download

Oracle 10g Data Warehousing

Book Description
New edition of successful book with Oracle employees and consultants as authors.

download

[patris1]

Product Description
Virtualization is taking the technology world by storm and dramatically helping organizations save money. Oracle VM is free and forked from the open source Xen hypervisor, which brings down your upfront costs for an agile data center. The robust capabilities and easy-to-use web interface of Oracle VM Manager helps administrators manage their Internal Data Center from anywhere in the world, helping us come closer to ubiquitous computing.


This practical book will give you hands-on experience on how to manage your Virtual Machines using Oracle VM Manager. Equipped with step-by-step installation and management information you will not only learn to manage your Virtual Data Center but also will include this guide among the books you consider most essential.

This book will take you into the various methods of importing Virtual Machines. You will learn to import VMs through HTTP/FTP, Repository servers, and even import other VM formats such as VMware VMs. You will also learn about the Xen utilities such as xm, xentop, and virsh. You will learn to manage your VMs through the simple and intuitive web interface of Oracle VM Manager. No matter how compact it may seem, this book covers all the essentials while keeping your learning experience to the point. The book has been deliberately written in a conversational manner so that you feel at home while learning Oracle VM Manager.

Manage a Flexible and Elastic Data Center with Oracle VM Manager
Learn quickly to install Oracle VM Manager and Oracle VM Servers
Learn to manage your Virtual Data Center using Oracle VM Manager
Import VMs from the Web, template, repositories, and other VM formats such as VMware
Learn powerful Xen Hypervisor utilities such as xm, xentop, and virsh
A practical hands-on book with step-by-step instructions

What you will learn from this book?
Understand virtualization and learn to install Oracle VM Server
Install/Upgrade Oracle VM Manager
Manage VMs using Oracle VM Manager
Secure Oracle VM Manager
Learn Xen utilities such as xm, xentop, and virsh
Import VMs through HTTP/FTP, Repository, CD, and VMware VMs
Import Templates through HTTP/FTP, Repository servers, VMware templates and more

Approach

This is a practical, hands-on book with precise, step-by-step instructions. We go about installing Oracle VM Servers and Oracle VM Manager. The writing style is conversational and the book also gives you a graphical view of the steps that are carried out.

The book starts by looking at the important features of virtualization and then takes you directly to installation. The motive is to get you started right away and have you excited enough to use the complete book as an essential guide to not only learning but implementing your Oracle VM farm within your data center.

Who this book is written for?

This book is for anyone who wants to learn virtualization with Oracle VM Manager and has some understanding and experience with virtualization; it is not an introductory book on virtualization but goes into detail explaining Oracle VM Servers and managing those VM Servers with Oracle VM Manager.

The book is aimed at IT managers or administrators looking to learn a new set of skills to enhance their careers as well as those looking for more consolidated and comprehensive tools to manage virtual infrastructures. It will be helpful to VMware, Microsoft, and other virtualization administrators who are looking for robust and cheaper alternatives to otherwise expensive and proprietary virtualization software. Generally IT managers and non-core-IT staff may also benefit from chapters that teach how to manage the life-cycle of VMs and generally integrate the technology process into the people and processes of their organization.
Product Details
Paperback: 300 pages
Publisher: Packt Publishing (July 20, 2009)
Language: English
ISBN-10: 1847197124
ISBN-13: 978-1847197122
Code: RapidShare: 1-CLICK Web hosting - Easy Filehosting