Oracle Database Administration for Microsoft SQL Server DBAs

Erscheinungsjahr 2010
ISBN: 978-0-07-174431-7
Verlag: McGraw-Hill Education

Buch, Englisch, 352 Seiten, Format (B × H): 191 mm x 235 mm, Gewicht: 661 g

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Apply Your SQL Server DBA Skills to Oracle Database AdministrationUse your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. - Install and configure Oracle Database on Windows or Linux systems
- Administer and monitor databases from Oracle Enterprise Manager
- Implement robust security using roles, permissions, and privileges
- Back up and restore databases with Oracle Recovery Manager
- Use the Oracle cost-based optimizer to tune performance
- Write, debug, and execute PL/SQL queries using Oracle SQL Developer
- Maximize availability with Oracle Real Application Clusters
- Build standby and failover servers using Oracle Data Guard

Autoren/Hrsg.

Malcher, Michelle

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

Chapter 1: The Database Administrator; Chapter 2: Oracle Internals; Chapter 3: Oracle Installation; Chapter 4: Database Definitions and Setup; Chapter 5: DBA Tools; Chapter 6: Database Backup, Restore, and Recovery; Chapter 7: Database Maintenance; Chapter 8: Performance and Tuning; Chapter 9: PL/SQL; Chapter 10: High-Availability Architecture; Appendix; Index

Über Autor(innen)

Malcher, Michelle
IOUG Board of Directors President and DBA Team Lead, DRW Holdings
Michelle is an Oracle ACE Director and the DBA Team Lead at DRW Holdings in Chicago, with several years experience in database development, design and administration. She has expertise in security, performance tuning, data modeling and database architecture of very large database environments. When she is not applying CPU patches or securing her own company's databases, she writes articles and gives presentations on security and compliance topics as well as other database administrative areas such as RAC, ASM and recovery. She is also a contributing author for multiple books including the IOUG Best Practices Tip Booklet. She has been very involved in the IOUG, and is currently serving as president on the Board of Directors.

Michelle Malcher, Oracle ACE, is a senior database administrator with more than 11 years’ experience in database development, design, and administration. She is a contributing author to Oracle Database 11g: A Beginner’s Guide and to the IOUG Best Practices Tip Booklet. Michelle is on the Board of the Independent Oracle User Group (IOUG).