Oracle Database Administration for Microsoft SQL Server DBAs (Osborne ORACLE Press Series)

Apply Your SQL Server DBA Skills to Oracle Database Administration Use 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 Contents......Page 10 Acknowledgments......Page 16 Introduction......Page 18 1 The Database Administrator......Page 20 General DBA Skills......Page 21 Where Do DBAs Belong in an Organization?......Page 23 Leveraging Skills......Page 24 Database Migrations......Page 28 Summary......Page 32 2 Oracle Internals......Page 34 Memory Structures......Page 35 Oracle Memory Parameters......Page 36 Sizing the SGA and PGA......Page 39 Where Are the master, msdb, and tempdb Databases?......Page 41 System-level Information......Page 42 Data Dictionary Views......Page 45 Templates and Temporary Tables......Page 47 Services and Processes......Page 48 sp_Configure Options and Parameters......Page 51 Viewing and Setting Parameters......Page 52 Getting Started with Some Parameters......Page 53 Transaction Logs Versus Redo Logs......Page 57 Undo and Beyond......Page 58 Summary......Page 61 3 Oracle Installation......Page 62 Operating Systems......Page 63 Windows Setup......Page 65 Useful Linux/Unix Commands......Page 67 Linux Setup......Page 69 Storage Requirements......Page 74 Disk Storage......Page 75 Storage Management with ASM......Page 76 Oracle Files......Page 80 Oracle Database Components......Page 82 Oracle Software Installation......Page 83 Using a Response File......Page 86 Upgrading the Database......Page 87 Applying Patches......Page 89 Summary......Page 90 4 Database Definitions and Setup......Page 92 Servers, Databases, Instances, and Schemas......Page 93 SQL Server Setup Versus Oracle Setup......Page 96 Using the DBCA......Page 98 Duplicating Databases with Templates and Scripts......Page 102 Creating the Listener......Page 104 Choosing a Character Set......Page 108 Security......Page 113 Permissions for the Server......Page 114 Permissions for Schemas......Page 117 DBA Roles and Responsibilities Revisited......Page 120 Summary......Page 121 5 DBA Tools......Page 122 Overview of Tools for Typical Database Tasks......Page 123 OEM Navigation......Page 124 Storage Management......Page 126 Database Configuration......Page 127 Security......Page 128 Enterprise Manager Configuration......Page 130 SQL*Plus......Page 131 SQL Developer......Page 136 Client Connections......Page 138 Client Connection Configuration......Page 139 Aliases......Page 142 My Oracle Support......Page 143 Summary......Page 144 6 Database Backup, Restore, and Recovery......Page 146 Backup Strategies......Page 147 Backup and Restore Commands......Page 148 RMAN Configuration for Backups......Page 150 Backup Options......Page 154 OEM Backup Jobs......Page 156 What Can Go Wrong?......Page 160 Restore and Recover Options......Page 162 Data Recovery Advisor......Page 166 Copying the Database......Page 168 Viewing Backups......Page 171 Purging Obsolete Files......Page 174 Copying Objects at the Table and Schema Level......Page 175 Using Data Pump......Page 176 Recycle Bin......Page 180 Flashback......Page 183 Summary......Page 188 7 Database Maintenance......Page 190 Maintenance Tasks......Page 191 Consistency Checks......Page 192 Health Checks......Page 193 Update Statistics......Page 195 System Statistics......Page 196 Object Statistics......Page 197 Index Rebuild......Page 200 Table Reorganization......Page 203 Invalid Objects......Page 206 Grants......Page 208 Synonyms......Page 209 Creating a Job in Oracle Scheduler......Page 210 Using DBMS_SCHEDULER......Page 213 Setting Up System and User Jobs......Page 215 Shrinking and Resizing Files......Page 216 Tablespace Monitoring......Page 219 Error Logs, Alert Logs, and Trace Files......Page 222 Summary......Page 223 8 Performance and Tuning......Page 226 Better-Performing Systems......Page 227 Indexes......Page 228 Index Types......Page 229 Locking......Page 238 Current Activity Views......Page 240 Current Sessions......Page 241 Activity Monitors......Page 242 Waits......Page 244 Viewing Explain Plans......Page 245 Tuning Using Explain Plans......Page 247 AWR Reports......Page 252 Library Cache for SQL Statements......Page 255 Summary......Page 257 9 PL/SQL......Page 258 Database Coding Practices......Page 259 Packages and Package Bodies......Page 262 Triggers......Page 265 Updates and Conditions......Page 268 Transactions......Page 269 Beginning a Transaction......Page 270 Defining Commits......Page 272 Cursor Processing......Page 273 Processing with FORALL......Page 276 Functions......Page 277 Debugging Procedures and Unit Testing......Page 281 Error Handling......Page 283 Error Handling Packages......Page 285 Standard Error Messages......Page 287 Using DBMS Packages......Page 289 Summary......Page 290 10 High-Availability Architecture......Page 292 Options for High Availability......Page 293 Clustering with RAC......Page 295 Configuring RAC......Page 297 Testing RAC......Page 301 Setting Up Client Failover......Page 302 Setting Up RAC Listeners......Page 304 Deploying RAC......Page 305 Configuring and Monitoring RAC Instances......Page 306 Primary and Standby Databases......Page 308 Using Active Standby Databases......Page 309 Setting Up a Standby Database......Page 311 Managing ASM Disk Groups......Page 316 Viewing ASM Information......Page 321 Oracle Streams......Page 323 Summary......Page 326 Appendix......Page 328 A......Page 334 B......Page 335 C......Page 336 D......Page 337 F......Page 339 H......Page 340 L......Page 341 M......Page 342 O......Page 343 P......Page 345 R......Page 346 S......Page 348 T......Page 350 U......Page 351 V......Page 352 W......Page 353 "Use 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 internals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide"-- Provided by publisher