Search
free ebooks website


Posts Present in Oracle Category
Oracle E-Business Suite Financials Handbook

Officially endorsed by Oracle Corporation, this detailed resource from Oracle Press explains how to maximize the centralized planning, accounting, treasury, purchasing, and management features of Oracle Financials–and revolutionize your company’s finance infrastructure.

 Author Name: David James (Author) , Simon Russell (Author) , Graham H. Seibert (Author)

Publisher: McGraw-Hill Osborne Media

Linux Recipes for Oracle DBAs

Linux Recipes for Oracle DBAs is an example–based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task–oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done.

Takes you directly from problem to solution
Covers the “right” mix of Linux user and administration tasks for database administrators
Respects your time by being succinct and to–the–point

What you’ll learn

  • Execute Linux commands applicable to Oracle Database administration.
  • Write shell scripts to automate critical DBA tasks.
  • Monitor, tune, and optimize a Linux server to run Oracle Database.
  • Perform Linux system administration tasks relevant to Oracle Database.
  • Implement Oracle real application clusters on Linux.
  • Implement Oracle automatic storage management on Linux.
  • Remotely (and securely!) manage Oracle on Linux.

 

Author Name: Darl Kuhn (Author) , Bernard Lopuz (Author) , Charles Kim (Author)

Publisher: Apress

Oracle PL SQL For Dummies

If you know a bit about SQL, this book will make PL/SQL programming painless!

The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it’ll be a breeze with this book! You’ll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.

Discover how to

Write efficient, easy-to-maintain code
Test and debug PL/SQL routines
Integrate SQL and PL/SQL
Apply PL/SQL best practices
Use new features introduced in Oracle 9i and 10g

 

Author Name: Michael Rosenblum (Author), Paul Dorsey (Author)

Publisher: For Dummies

Mastering Oracle SQL

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle’s implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.

This book shows you how to:

Leverage Oracle’s vast library of built-in SQL functions
Query time-based data, and write joins involving date and time ranges
Use Oracle SQL’s hierarchical query features to deal with data best represented in a tree format
Use DECODE and CASE to implement conditional logic in your queries
Use Oracle’s new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
Join data from two or more tables using the newly supported SQL92 join syntax

 

Author Name: Sanjay Mishra (Author), Alan Beaulieu (Author)

Publisher: O’Reilly Media

Effective Oracle by Design

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.

 Author Name: Thomas Kyte

Publisher: McGraw-Hill Osborne Media

Oracle Database 11g Performance Tuning Recipes: A Problem-solution Approach

Performance problems are rarely “problems” per se. They are more often “crises” during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers. Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are “recipes,” showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book.

* Provides proven solutions to real-life Oracle performance problems

* Offers relevant background and theory to support each solution

* Written by a team of experienced database administrators successful in their careers What you’ll learn

* Optimize the use of memory and storage

* Monitor performance and troubleshoot problems

* Identify and improve poorly-performing SQL statements

* Adjust the most important optimizer parameters to your advantage

* Create indexes that get used and make a positive impact upon performance

* Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines

Author Name: Sam Alapati (Author), Darl Kuhn (Author), Bill Padfield (Author)

Publisher: APress

Oracle Database 11g DBA Handbook

The Essential Resource for Oracle DBAs–Fully Updated and Expanded
Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.

Plan and deploy permanent, temporary, and bigfile tablespaces
Optimize disk allocation, CPU usage, I/O throughput, and SQL queries
Develop powerful database management applications
Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management
Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets
Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control
Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard
Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor
Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import
Work with networked databases, data warehouses, and VLDBs
Put the latest Oracle Database 11g tools to work–Oracle Total Recall, Oracle Flashback Data Archive, and more

 Author Name: Bob Bryla (Author), Kevin Loney (Author)

Publisher: McGraw-Hill Osborne Media

SQL in a Nutshell

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today’s most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You’ll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts — all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

  • Background on the Relational Database Model, including current and previous SQL standards
  • Fundamental concepts necessary for understanding relational databases and SQL commands
  • An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
  • The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
  • An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
  • Platform-specific functions unique to each implementation 

Author Name: Kevin Kline (Author), Brand Hunt (Author), Daniel Kline (Author)

Publisher: O’Reilly Media

Oracle Application Server 10g J2EE Deployment and Administration

This guide walks through an OC4J (Oracle application server containers for J2EE) standalone edition installation, Java naming and directory interface (JNDI) and Java message service (JMS) configuration, the J2EE security model for Oracle 10g AS, and the JavaMail and XML APIs. The second half of the book focuses on the architecture, administration, and features available for the full enterprise edition of the Oracle 10g application server.

 Author Name: Michael Wessler

Publisher: Apress Publications

Oracle Enterprise Manager 10g Grid Control Implementation Guide

Build a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. You’ll also get full coverage of backup and recovery strategies and high-availability techniques.
• Prepare infrastructure…
• Install the Oracle management repository, service, and agents
• Select the Grid Control installation options that fit your needs
• Discover and manage host, database, and application server targets
• Set target metrics and policies according to best practices
• Optimize performance and availability of your Grid Control framework
• Secure the Grid Control framework to protect data transmitted between components

Author Name: Michael New

Publisher: McGraw-Hill

free ebooks website
Subscribe

Subscribe via RSS Feed stay updated with Latest Ebooks

Subscribe via email address:

Enter your email address:


 
Members Login
Username:
Password:
Forgot password? Register

 
Live Help