Oracle Database Administration for Microsoft SQL Server DBAs part 35 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 322 Oracle Database Administration for Microsoft SQL Server DBAs home directory ASM installation on 58 Oracle installation in Linux on 51 Oracle installation in Windows on 46 47 Oracle software installation on 64 hot backups 130 I identity column SQL Server 242 immediate shutdowns 85 implicit cursors Oracle transactions 254-255 importing with Data Movement tab in OEM 106 with Data Pump utility 157-161 incremental backups 134-135 Independent Oracle User Group IOUG 124 index_stats table 182 indexed views 214-215 indexes bitmap 215-216 detecting corruption between tables and 173-174 enabling monitoring 210 function-based 212-214 260 general tasks 173 invisible 218-219 overview of 209-210 partitioned 217 primary key 211-212 rebuilding 181-184 191-192 218 reorganizing tables 184-187 reverse key 216-217 tuning using explain plans 228-230 types of 210-211 updating statistics for 178-181 230-231 views 214-215 index-organized table IOT creating primary key index with 211-212 Initialization Parameters OEM Server tab Database Configuration 108 file 287-288 insert operations with PL SQL FORALL loop 257-258 triggers for 247 using implicit cursors 255 inst_id parameter RAC 288 instance terminology used in this book 310 Instance Activity OEM 224-225 INSTANCE_TYPE parameter ASM 298 instant client 120 integrity database 173 intent locks SQL Server 220 interface DBAs responsibility for 4 internal locks and latches 221 Internet Directory Oracle 121-122 invalid objects database maintenance 187-188 invalid synonyms database maintenance 189 invisible indexes 218-219 I O events storage for 56 IOT index-organized table creating primary key index with 211-212 IOUG Independent Oracle User Group 124 IP addresses configuring RAC 279-280 ipcs-b system command 19 isolation SQL Server 219 J JAVA_POOL_SIZE parameter 17 JDBC Java Database Connectivity client failover in RAC 284 connections 123 managing SQL Server databases 10 JOB_QUEUE_PROCESSES parameter scheduling jobs 37 82 jobs Data .
