Oracle Database 11g DBA Handbook (Anglais) Broché – 1 janvier 2008
|Neuf à partir de||Occasion à partir de|
- Choisissez parmi 17 000 points de collecte en France
- Les membres du programme Amazon Premium bénéficient de livraison gratuites illimitées
- Trouvez votre point de collecte et ajoutez-le à votre carnet d’adresses
- Sélectionnez cette adresse lors de votre commande
Il y a une édition plus récente de cet article:
Les clients ayant acheté cet article ont également acheté
Descriptions du produit
Présentation de l'éditeur
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
Biographie de l'auteur
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.
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre ou numéro de téléphone mobile.
Détails sur le produit
Commentaires en ligne
Commentaires client les plus utiles sur Amazon.com (beta)
select password from dba_users
2 where username = 'SKING';
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:
'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.
There are some topics that are simply appetite-whetters too, requiring a further search for information before whatever it is can be of use.
People often say, and in this specific case they are right, that there is no substitute for the Oracle Manual. I guess this was intended as a more detailed quick-start guide than the 2-day admin manuals.
Good, useful, but in no way indispensable.
It touches every important topic. It is indeed a great hand book.