Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Read books on your computer or other mobile devices with our FREE Kindle Reading Apps.
Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database (Oracle Press)
 
 

Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database (Oracle Press) [Kindle Edition]

Bob Bryla , Kevin Loney
3.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £39.99
Kindle Price: £22.79 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £17.20 (43%)
Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £22.79  
Paperback £30.39  

Customers Who Bought This Item Also Bought


Product Description

Product Description

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.

About the Author

Bob Bryla has more than 20 years of MIS experience as a database designer, systems analyst, and DBA. He currently handles the DBA activities on Lands' End's Oracle Internet databases. Bob is the coauthor, with Kevin Loney, of the previous edition of this book.

Kevin Loney is a veteran Oracle consultant, developer, and DBA. He is a regular presenter at Oracle User Group conferences and is the bestselling author of several Oracle Press titles.


Product details


More About the Authors

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?


Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items.
Your tags: Add your first tag
 

Customer Reviews

5 star
0
4 star
0
2 star
0
1 star
0
Most Helpful Customer Reviews
1 of 2 people found the following review helpful
Oracle 11g DBA 23 April 2008
Format:Paperback
Hi there

I'm studying for Oracle 11g OCA exam (1z0-052), this was the only book available on 11g.

On chapter 6 so far...

Comments :

Very descriptive...so far explains areas covered relatively easily (NB On chapter 6). But, definite requires more pratical examples to back up the material.

Is it worth getting ?..can't say...at the time only book on 11g....can't compare...
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:  3 reviews
Bogus information for Becoming Another User! 19 Mar 2012
By Reginald - Published on Amazon.com
Format:Paperback|Amazon Verified Purchase
In the book and ebook in Chapter 9 Database Security and Auditing , the authors have cut and pasted the classic Becoming Another User method used in previous issues of their book and previous versions of Oracle.

select password from dba_users
2 where username = 'SKING';
PASSWORD
------------------------------
83C7CBD27A941428
1 row selected.

In 11g their method does not work. If you select on the dba_users table for the password you only get a null return for it. So their classic method does not work. Instead the correct method is to query using some built in functions, like so:

select
'alter user "'||username||'" identified by values '''||extract(xmltype(dbms_metadata.get_xml('USER',username)),'//USER_T/PASSWORD/text()').getStringVal()||''';' old_password
from dba_users where username = 'USERNAME';

This will yield the following output string :

alter user "USERNAME" identified by values 'F894844C34402B67'

I would expect an suthor of Mr. Loney's caliber and Mr. Bryla's stature to have adequately done their homework. If they got this little item wrong, what other items did they get wrong in their book?
I have read every one of the Handbooks since Oracle7 and I have enjoyed them tremendously. They have saved the day for myself and many other DBAs. But when you are a trusted source, we expect you to have validated your work and assumptions. I realize it is one minor gaff, but the repercussions could be huge.

I am glad my boss asked me to verify that the Becoming Another User method in your book actually worked, otherwise I would have been left in a bad situation.

I hope you guys put out an errata to correct these errors. Is there a web site with the corrections? For the owners of the printed copy (I own the printed copy and the ebook) getting the word to them might be a little more difficult.

The rest of the book was good, but no longer so excellent. If this error has already been identified and addressed, then thank you.
If not, shame on you and your technical proofer for not finding it.
0 of 1 people found the following review helpful
Can`t live without it. 30 Oct 2011
By Allan Victor - Published on Amazon.com
Format:Paperback|Amazon Verified Purchase
This is a book you should have always with you. A very helpful handbook I recommend to anyone who`s willing to learn more about Oracle Database.
2 of 36 people found the following review helpful
A best buy 11 Sep 2008
By Oti Ukubeyinje - Published on Amazon.com
Format:Paperback
Bought this product as a gift for my bookworm cousin. It was brand new, delivered so quick and a little bit more than i expected in every sense. Highly recommended for the Oracle freak or novice.
Search Customer Reviews
Only search this product's reviews

Popular Highlights

 (What's this?)
&quote;
If two or more tables are frequently accessed together &quote;
Highlighted by 6 Kindle users
&quote;
Dictionary-managed tablespaces must be read-only in databases with a locally managed SYSTEM tablespace. &quote;
Highlighted by 5 Kindle users
&quote;
An Oracle instance is composed of a large block of memory allocated in an area called the System Global Area (SGA), along with a number of background processes that interact between the SGA and the database files on disk. &quote;
Highlighted by 5 Kindle users

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums


Customers Who Highlighted This Item Also Highlighted


Look for similar items by category


Look for similar items by subject


Amazon Media EU S.à r.l. GB Privacy Statement Amazon Media EU S.à r.l. GB Delivery Information Amazon Media EU S.à r.l. GB Returns & Exchanges