Oracle 11g For Dummies

November 4, 2009

Publisher: For Dummies
Paperback: 408 pages
File size: 5.5 MB

Product Description:
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 in tiptop 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 for implementation
  • 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 potential threats 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 logs and 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 newest release 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.

download:

http://hotfile.com/dl/15285587/918366e/0470277653.pdf.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Oracle High Performance Tuning for 9i and 10g

November 4, 2009


Publisher: Digital Press
Paperback: 544 pages
File size: 10.5 Mb

Product Description:
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.
A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.
Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.
*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:

http://hotfile.com/dl/16550139/a5e729f/1555583059.zip.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Oracle Application Express Forms Converter

November 4, 2009

Publisher: Packt Publishing
Paperback: 172 pages
File size: 5.7 Mb

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:

http://hotfile.com/dl/16549858/ccd6b3b/1847197760.zip.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Oracle Application Server 10g: J2EE Deployment and Administration

November 4, 2009


Publisher: Apress
Paperback: 600 pages
File size: 13.4 Mb

Product Description:
Oracle Application Server 10g: J2EE Deployment and Administration focuses on the latest version of Oracle’s fully J2EE-certified application server (previously called Oracle9iAS). Oracle Corp. is aggressively attacking this market with a new lost-cost version of the server, as well as a program to move BEA customers onto Oracle free of charge. Adoption interest is growing rapidly amidst favorable reports regarding performance and reliability.
Deploying and configuring J2EE applications are some of the trickiest processes in J2EE development, and they unfortunately receive scant attention in general J2EE texts. This book is a focused, no-frills guide to getting J2EE applications up and running on 10g. It covers Oracle’s J2EE container, OC4J (available free of charge for development purposes), in full detail. It moves on to explain how to best configure and use the various enterprise-level features that come with the commercial editions. This is the book for anyone wanting to stay ahead in the world of Oracle’s application servers.

download:

http://hotfile.com/dl/16550944/08e7110/1590592352.zip.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Oracle Unleashed

September 3, 2009

Publisher: Sams
Paperback: 1500 pages
File size: 3.60 MB

Product Description:
Oracle Unleashed, Second Edition is broken into several parts to help readers find the information they need.

  • This second edition covers the new object-oriented architecture of Oracle8, Oracle’s component assembly product, and how to utilize J/SQL to build Client, Application Server, and Data Cartridges.
  • The most comprehensive manual written to be used with Oracle
  • Each chapter covers a single issue of extreme importance to experienced Oracle programmers and administrators.

download:

http://depositfiles.com/files/jondt9va6

Notes:
- Click here to learn how to download from Depositfiles.com
- Click here to check more Oracle books

Secrets of the Oracle Database

September 3, 2009


Publisher: Apress
Paperback: 450 pages
File size: 9.7 MB

Product Description:
Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.
Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.
What you’ll learn

  • Take advantage of Oracle’s built–in Perl DBI distribution to write applications for monitoring, benchmarking, data extraction, and more.
  • Interpret the undocumented, extended trace file format to pinpoint performance problems that TKPROF reports overlook and obscure.
  • Get the most out of Statspack by using undocumented report formatting options, accessing its scarcely–documented repository, and integrating with SQL Trace.
  • Take control of your instance through the ill–documented ORADEBUG command, enabling you to control processes, trace SQL statements, dump process state, monitor wait events and the call stack, and much more.
  • Leverage undocumented features in Oracle’s built–in scheduler to better automate your workload.
  • Take full advantage of Transparent Application Failover and Cluster Database Services in a Real Application Cluster environment.

download:

http://hotfile.com/dl/15285601/399c1d6/1430219521.zip.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Oracle Database 11g PL/SQL Programming

September 3, 2009


Publisher: McGraw-Hill Osborne
Paperback: 835 pages
File size: 12.6 MB

Product Description:
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

download:

http://hotfile.com/dl/15285580/4640154/0071494456.zip.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Oracle Database 10g: The Complete Reference

September 3, 2009


Publisher: McGraw-Hill Osborne
Paperback: 1200 pages
File size: 6.2 MB

Product Description:
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.

download:

http://hotfile.com/dl/15285585/3a967b2/0072253517.zip.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Beginning Oracle Database 11g Administration: From Novice to Professional

September 3, 2009


Product Description:
This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.
The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter.
In this book, you’ll find information that you won’t find in other books on Oracle Database. Here you’ll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author’s favorite chapter is “The Big Picture and the Ten Deliverables.” If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

download:

http://hotfile.com/dl/15285604/a113e82/1590599683.pdf.html

Notes:
- Click here to learn how to download from hotfile.com
- Click here to check more Oracle books

Mastering Oracle SQL and SQL*Plus

September 3, 2009


Publisher: Apress
Paperback: 488 pages
File size: 3.36 MB

Product Description:
This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book’s guidance.
This book is fully compliant with the latest version of the ANSI SQL standard, and fully updated for the Oracle 10g database. Furthermore, this book is based on a popular Netherlands college textbook (currently in its third edition). And author Lex de Haan is vastly experienced with the Oracle database, and has twenty-five years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.

download:

http://depositfiles.com/files/o5tubu5m3

Notes:
- Click here to learn how to download from Depositfiles.com
- Click here to check more Oracle books


Follow

Get every new post delivered to your Inbox.