Oracle Database 10G Dba Handbook

Sinopsis

Everything a DBA needs to know in one volumethis is the musthave reference for anyone working with the Oracle database, and it`s been fully revised and updated for Oracle Database 10 g . Coauthor Kevin Loney is the alltime, bestselling Oracle Press author. The Essential Resource for All Oracle Database Administrators Maintain a highperformance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advantage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more. Plan tablespacesincluding bigfiles and multiple temporary tablespacesand physical database layout Manage disk space and CPU usage Use Automatic Undo Management to manage transactions Tune queries using the SQL Access Advisor Monitor and tune your database with the Automated Workload Repository and STATSPACK Implement finegrained security using authentication, authorization, and auditing techniques Automate the management of the memory areas Enable high availability using Oracle Real Application Clusters Perform backup and recovery with Oracle Recovery Manager Use Oracle Data Guard and the flashback features for data protection and disaster recovery Manage Very Large Databases (VLDB) and distributed databases About the Authors: Kevin Loney is a senior technical management consultant with TUSC, a Chicagobased consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine's Editors' Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups. Bob Bryla is an Oracle 8, 8i, 9 and 10g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands' End in Dodgeville, Wisconsin.