Oracle - Free Ebooks Portal BluePortal.org

ISBN: 0470277653, Author: Chris Zeis, Publisher: For Dummies, Pages: 408, Publication Date: 2009-01-14

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running intiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements forimplementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potentialthreats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logsand other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newestrelease of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

» Oracle Space Management Handbook

Donald K. Burleson, Jonathan Lewis, Dave Ensor, "Oracle Space Management Handbook"
Rampant TechPress | 2003 | ISBN: 0974435503 | 311 pages | PDF | 1,2 MB

Written by some of the world's most widely-read authors, this exciting eBook provides you with everything that you need to know to manage Oracle storage. You will learn how to monitor and reduce disk I/O, how to set-up your tablespaces for maximum efficiency and how to define Oracle tables and indexes to make the most efficient use of disk storage. Not for the beginner, this is a guru-level advanced Oracle handbook with highly-detailed explanations of Oracle storage internals. This eBook is laden with useful scripts that will allow you to quickly see inside your data files and tablespaces and tune them for optimal performance.

» Expert Oracle JDBC Programming

Apress; 1 edition (May 30, 2005)

PDF | 708 pages | English | 4mb(rar)

Expert Oracle JDBC Programming/by R.M. Menon (Author)

Description

JDBC is the most commonly used API in Java to access and manipulate data in a database. Oracle is one of the most popular and scalable databases in the world. This book is a must-have for any developer building an application that employs JDBC on Oracle database. Unlike other JDBC books, this book has been written to complement not rehash the contents of Oracle JDBC documentation and the JDBC specification.

The book teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC though it does assume basic knowledge of SQL and PL/SQL. It covers JDBC with a focus on writing high-performing, scalable and secure applications for Oracle 10g and 9i. Using this book you will learn, among other things:

* How to efficiently query, insert, update and delete data using JDBC

* How to exploit knowledge of Oracle fundamentals in building applications

* What transaction isolation levels are, which ones Oracle supports and how to write your transactions effectively on Oracle

* How to use proxy authentication to make your programs more secure

* How to use Oracle objects and collections effectively in your applications

* How to deal with the phenomenon of "lost updates" using variants of optimistic and pessimistic locking strageties

* How to exploit statement caching and connection pooling to increase performance and scalability of your application

» Forecasting Oracle Performance

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place.

» ORACLE Database 10G Workshop Courses

ORACLE Database 10G Workshop Courses
Oracle University | 2005 - 2006 | PDF | 16.9 Mb

this course introduces students to the new features in Oracle Database 10g Release 2 - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security changes that students need to understand. Hands-on practice sessions give students an opportunity to examine many of the new features, and to practice database administration with Enterprise Manager Database Control.

D17090GC30 : Oracle Database 10g: Administration Workshop I Release 2

this course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

D17312GC30 : Oracle Database 10g: Administration Workshop II Release 2

This course advances your success as an Oracle professional in the area of database administration. In this class, you'll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. You will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. You will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database. The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

[Page 1] [2] [3] [4] [5] [6]