Expert Oracle9i Database Administration:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Berkeley, CA
APress
2003
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XLII, 1202 S. Ill. |
| ISBN: | 1590590228 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV016488914 | ||
| 003 | DE-604 | ||
| 005 | 20030514 | ||
| 007 | t | ||
| 008 | 030203s2003 a||| |||| 00||| eng d | ||
| 020 | |a 1590590228 |9 1-59059-022-8 | ||
| 035 | |a (OCoLC)51839038 | ||
| 035 | |a (DE-599)BVBBV016488914 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-20 | ||
| 050 | 0 | |a QA76.9.D3 | |
| 082 | 0 | |a 005.75/85 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Alapati, Sam R. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Expert Oracle9i Database Administration |c Sam R. Alapati |
| 264 | 1 | |a Berkeley, CA |b APress |c 2003 | |
| 300 | |a XLII, 1202 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a Oracle (Computer file) |
| 650 | 4 | |a Database management | |
| 650 | 0 | 7 | |a ORACLE 9i |0 (DE-588)4646123-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE 9i |0 (DE-588)4646123-1 |D s |
| 689 | 0 | 1 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch Darmstadt |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010192005&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-010192005 | ||
Datensatz im Suchindex
| _version_ | 1804129812221001728 |
|---|---|
| adam_text | EXPERT ORACLE9I DATABASE ADMINISTRATION SAMR.ALAPATI HLUHB DARMSTADT
LLLLLLLLLLLLLLL 15959894 ILLLLLILLLL _ , SKI APRESS* CONTENTS ABOUT THE
AUTHOR XXXI ABOUT THE TECHNICAL REVIEWER XXXII ACKNOWLEDGMENTS XXXIII
INTRODUCTION XXXV PART ONE DATABASE BASICS, DATA MODELING, AND
UNIX/LINUX : I CHAPTER 1 THE ORACLE DBA S WORLD 3 THE ORACLE DBA S ROLE
3 THE DBA S SECURITY ROLE 4 THE DBA S SYSTEM MANAGEMENT ROLE 6 THE DBA S
DATABASE DESIGN ROLE 8 DIFFERENT DBA JOB CLASSIFICATIONS 10 TYPES OF
DATABASES 10 ONLINE TRANSACTION PROCESSING AND DECISION SUPPORT SYSTEM
DATABASES 11 DEVELOPMENT, TEST, AND PRODUCTION DATABASES 11 BACKGROUND
AND TRAINING . 12 BACKGROUND AND TRAINING FOR AN ORACLE DBA 12
CERTIFICATION 15 RESOURCES AND ORGANIZATIONS FOR ORACLE DBAS 16 MANAGING
HIGH-PERFORMANCE DATABASES 18 IMPROVING YOUR TROUBLESHOOTING SKILLS 19
THE DAILY ROUTINE OF A TYPICAL ORACLE DBA 21 SOME GENERAL ADVICE 21
KNOWWHENYOU NEED HELP 22 REMEMBER YOU ARE NOT ALONE 22 THINK OUTSIDE THE
BOX 22 SUMMARY 23 CONTENTS CHAPTER 2 RELATIONAL DATABASE MODELING AND
DATABASE DESIGN 25 RELATIONAL DATABASES: A BRIEF INTRODUCTION 26 THE
RELATIONAL DATABASE MODEL 26 DATABASE SCHEMAS 27 DATA DEFINITION AND
DATA MANIPULATION LANGUAGES 27 RELATIONAL ALGEBRA ! 28 RELATIONAL
CALCULUS 29 SQL AND RELATIONAL THEORY 29 RELATIONAL DATABASE LIFE CYCLE
30 REQUIREMENTS GATHERING AND ANALYSIS 30 LOGICAL DATABASE DESIGN 31
ENTITY-RELATIONSHIP MODELING 32 NORMALIZATION 38 THE NORMAL FORMS 40 ERM
TOOLS: THE ORACLE DESIGNER 44 PHYSICAL DATABASE DESIGN 45 TRANSFORMATION
OF ENTITIES AND RELATIONSHIPS 46 DESIGNING DIFFERENT TYPES OF TABLES 47
TABLE STRUCTURES AND NAMING CONVENTIONS 47 COLUMN SPECIFICATIONS AND
CHOOSING DATA TYPES 47 BUSINESS RULES AND DATA INTEGRITY 47
IMPLEMENTATION OF THE PHYSICAL DESIGN 48 DATABASE SIZING AND DATABASE
STORAGE 48 IMPLEMENTING DATABASE SECURITY 48 MOVING TO THE NEW SYSTEM .
49 REVERSE ENGINEERING A DATABASE 49 OBJECT-RELATIONAL AND OBJECT
DATABASES 49 THE RELATIONAL MODEL 50 THE OBJECT MODEL 50 THE
OBJECT-RELATIONAL MODEL 51 SUMMARY . 53 CHAPTER 3 ESSENTIAL UNIX (AND
LINUX) FOR THE ORACLE DBA 55 OVERVIEW OF THE UNIX OPERATING SYSTEM 55
UNDERSTANDING THE UNIX SHELL(S) 57 ACCESSING THE UNIX SYSTEM 58 LOGGING
INTO AND LOGGING OUT OF UNIX 58 OVERVIEW OF BASIC UNIX COMMANDS 60 CONTE
INTRODUCING THE UNIX ENVIRONMENT 63 DISPLAYING THE ENVIRONMENT 64
WORKING WITH SHELL VARIABLES 65 MODIFYING THE ENVIRONMENT 65 INPUT AND
OUTPUT IN UNIX 65 NAVIGATING FILES AND DIRECTORIES IN UNIX 66 FILES IN
THE UNIX SYSTEM 67 TYPES OF FILES 67 LINKING FILES 67 MANAGING FILES 68
PERMISSIONS: READING FROM OR WRITING TO FILES IN UNIX 69 UNIX DIRECTORY
STRUCTURE 72 DIRECTORY MANAGEMENT 72 IMPORTANT UNIX DIRECTORIES 73
WRITING FILES WITH THE VI EDITOR 74 CREATING AND MODIFYING FILES USING
VI 74 USING THE HEAD AND TAIL COMMANDS 75 SHELL SCRIPTING 76 CREATING A
SIMPLE UNIX SHELL PROGRAM 76 USING SHELL VARIABLES 76 CONTROL FLOW
STRUCTURES IN KORN SHELL PROGRAMMING 79 LOOPING 79 CONDITIONAL BRANCHING
81 DEALING WITH UNIX PROCESSES 82 RUNNING PROGRAMS IN THE BACKGROUND
WITH NOHUP 83 TERMINATING PROCESSES WITH THE KILL COMMAND 83 UNIX SYSTEM
ADMINISTRATION AND THE ORACLE DBA 84 UNIX BACKUP AND RESTORE UTILITIES
84 THE CRONTAB AND AUTOMATION OF SCRIPTS 85 USINGTELNET 86 REMOTE LOGIN
AND REMOTE COPY 87 USING SSH, THE SECURE SHELL 87 USING FTP TO SEND AND
RECEIVE FILES 87 UNIX SYSTEM PERFORMANCE MONITORING TOOLS 88 DISKS AND
STORAGE IN UNIX 92 DISK STORAGE CONFIGURATION CHOICES 92 MONITORING DISK
USAGE 93 DISK STORAGE, PERFORMANCE, AND AVAILABILITY 94 RAID SYSTEMS 95
RAID LEVELS 96 CHOOSING THE IDEAL DISK CONFIGURATION 98 REDUNDANT DISK
CONTROLLERS 100 RAID AND BACKUPS 100 RAID AND ORACLE : 101 CONTENTS
STORAGE TECHNOLOGIES 101 STORAGE AREA NETWORKS 102 NETWORKED ATTACHED
STORAGE 102 INFINIBAND 103 ORACLE AND STORAGE SYSTEM COMPATIBILITY 103
SUMMARY .-. 104 PART TWO THE ORACLE RDBMS 105 CHAPTER 4 INSTALLING THE
0RACLE9I RDBMS 107 INSTALLING ORACLE ON UNIX SYSTEMS 107 REVIEWING THE
DOCUMENTATION 108 DETERMINING DISK AND MEMORY REQUIREMENTS 109 FOLLOWING
THE OPTIMAL FLEXIBLE ARCHITECTURE 110 MOUNT POINTS 112 DIRECTORY AND
FILE NAMING CONVENTIONS 112 PERFORMING PREINSTALLATION TASKS 115 UNIX
SYSTEM ADMINISTRATOR S TASKS 116 ORACLE OWNER S TASKS 120 A FINAL
CHECKLIST FOR THE INSTALLATION 122 INSTALLING THE ORACLE SOFTWARE 123
AFTER THE INSTALLATION 134 UNIX POST-INSTALLATION TASKS 134 USER ORACLE
POST-INSTALLATION TASKS 135 UNINSTALLING ORACLE 136 SUMMARY 137 CHAPTER
5 INTRODUCTION TO THE 0RACLE9I ARCHITECTURE 139 ORACLE DATABASE
STRUCTURES 139 THE LOGICAL STRUCTURES 140 PHYSICAL DATABASE STRUCTURES
146 TRACE FILES 152 DATA FILES AND TABLESPACES 152 AUTOMATIC UNDO
MANAGEMENT 157 ORACLE MANAGED FILES 159 ORACLE PROCESSES 159 INTERACTION
BETWEEN THE USER AND ORACLE PROCESSES 160 THE SERVER PROCESS 160 THE
BACKGROUND PROCESSES 161 ORACLE MEMORY STRUCTURES 166 ORACLE SYSTEM
GLOBAL AREA (SGA) 167 THE PROGRAM GLOBAL AREA (PGA) 175 MONITORING
MEMORY ALLOCATION 178 DYNAMICALLY MODIFYING THE SGA 181 USING ORACLE S
SGA AND PGA ADVISORIES 183 MANAGING MEMORY PARAMETERS WITH ORACLE
ENTERPRISE MANAGER ....185 A SIMPLE ORACLE DATABASE TRANSACTION 187 DATA
CONSISTENCY AND DATA CONCURRENCY 189 THE DATABASE WRITER AND THE WRITE
AHEAD PROTOCOL 190 THE SYSTEM CHANGE NUMBER 190 THE CENTRAL ROLE OF THE
ORACLE CONTROL FILE 191 THE ORACLE DATA DICTIONARY AND THE DYNAMIC
PERFORMANCE VIEWS 192 THE ORACLE DATA DICTIONARY 192 THE DYNAMIC
PERFORMANCE (V$) VIEWS 193 THE ORACLE OPTIMIZER 194 ORACLE ENTERPRISE
MANAGER 195 SUMMARY 195 CHAPTER 6 USING SQL*PLUS AND ISQL*PLUS 197
SOL*PLUS FOR THE DBA 197 USING SQL*PLUS IN INTERACTIVE AND
NONINTERACTIVE MODES 198 SQL*PLUS COMMANDS AND SQL COMMANDS 198 SQL*PLUS
SECURITY 199 SETTING THE SQL*PLUS ENVIRONMENT WITH THE SET COMMAND 202
SETTING COMMON SQLTLUS VARIABLES 203 SQL*PLUS COMMAND LINE ARGUMENTS 206
REMOVING SETTINGS WITH THE CLEAR COMMAND ..207 THE STORE COMMAND 208 THE
SHOW COMMAND 208 EXITING SQL*PLUS 208 KEY SQL*PLUS PERFORMING COMMANDS
209 THE SQLPROMPT COMMAND 209 THE DESCRIBE COMMAND 209 THE HOST COMMAND
210 THE SPOOL COMMAND 210 THE ACCEPT AND PROMPT COMMANDS 211 THE EXECUTE
COMMAND 211 THE PAUSE COMMAND 211 CREATING COMMAND FILES IN SQL*PLUS 212
SAVING SQL COMMANDS TO A FILE 212 EXECUTING SQL*PLUS SCRIPTS 213 XI
EXECUTING A SQL*PLUS COMMAND SCRIPT 213 CREATING AWINDOWS BATCH SCRIPT
215 THE DEFINE AND UNDEFINE COMMANDS 216 USING COMMENTS IN SQL*PLUS 217
LISTING YOUR SQL COMMANDS 217 EDITING WITHIN SQL*PLUS 218 INSERTING AND
DELETING LINES IN SQL*PLUS ....219 ADDING TO TEXT 221 INCORPORATING
COMMENTS WITH THE REMARK COMMAND 221 COPYING TABLES WITH THE COPY
COMMAND 221 MAKING DML CHANGES PERMANENT WITH SQL*PLUS 222 CREATING WEB
PAGES USING SQL*PLUS 222 KEY SOL*PLUS DATABASE ADMINISTRATION COMMANDS
223 THE RECOVER COMMAND 223 THE START AND SHUTDOWN COMMANDS 223 THE
ARCHIVELOG COMMAND 223 COMMANDS FOR FORMATTING SQL*PLUS OUTPUT AND
CREATING REPORTS 224 THE BREAK COMMAND 224 THE COLUMN COMMAND 224 THE
COMPUTE COMMAND 225 THE REPFOOTER COMMAND 225 THE REPHEADER COMMAND 225
THE BTITLE ANDTTITLE COMMANDS 225 USING SQL TO GENERATE SQL : 226
INTRODUCING THE 0RACLE9I ISQL*PLUS INTERFACE 227 INSTALLING THE ISQLTLUS
SOFTWARE 228 CONFIGURING ISQL*PLUS ..228 USING THE ISQLTLUS INTERFACE
230 AUTHENTICATION LEVELS 233 EXECUTING STATEMENTS 235 A SECURITY
WARNING FOR ISQL*PLUS 236 SUMMARY ; 236 XU CHAPTER 7 SCHEMA MANAGEMENT
IN ORACLE9I 237 TYPES OF SQL STATEMENTS IN ORACLE 237 SYSTEM CONTROL
STATEMENTS 238 SESSION CONTROL STATEMENTS 239 DATA MANIPULATION
STATEMENTS 239 TRANSACTION CONTROL STATEMENTS 240 DATA DEFINITION
STATEMENTS 240 ORACLE SCHEMA MANAGEMENT 241 CREATING AND MANAGING
TABLESPACES 242 LOCALLY AND DICTIONARY MANAGED TABLESPACES 243 CREATING
LOCALLY MANAGED TABLESPACES 244 CREATING A SIMPLE TABLE 256 SPECIAL
ORACLE TABLES 261 TEMPORARY TABLES 261 INDEX-ORGANIZED TABLES 263
EXTERNAL TABLES 265 PARTITIONED TABLES 267 DATA DICTIONARY VIEWS FOR
MANAGING TABLES 274 CLUSTERS 277 HASH CLUSTERS 277 ORACLE INDEXES 277
GUIDELINES FOR CREATING INDEXES 279 ORACLE INDEX SCHEMES ...: 280
CREATING A SIMPLE INDEX 281 BITMAP INDEXES 281 REVERSE KEY INDEXES 282
FUNCTION-BASED INDEXES 282 PARTITIONED INDEXES 282 MONITORING INDEX
USAGE 284 INDEX MAINTENANCE 285 DATABASE INTEGRITY CONSTRAINT MANAGEMENT
285 PRIMARY KEY CONSTRAINTS 286 NOT NULL CONSTRAINTS 287 CHECK
CONSTRAINTS 287 UNIQUE CONSTRAINTS 287 REFERENTIAL INTEGRITY CONSTRAINTS
288 YIN INTEGRITY CONSTRAINT STATES 288 DISABLING INTEGRITY CONSTRAINTS
289 RELY CONSTRAINTS 290 DEFERRABLE AND IMMEDIATE CONSTRAINTS 290 USING
SYNONYMS 291 CREATING A PUBLIC SYNONYM 292 CREATING A PRIVATE SYNONYM
293 VIEWING INFORMATION ON SYNONYMS .294 USING SEQUENCES 294 USING
TRIGGERS ...296 USING VIEWS 296 USING MATERIALIZED VIEWS 297 USING THE
SUMMARY ADVISOR 298 CREATING MATERIALIZED VIEWS 303 SUMMARY 307 CHAPTER
8 ORACLE TRANSACTION MANAGEMENT 309 TRANSACTIONS 310 ANATOMY OF A SQL
TRANSACTION 311 PARSING 311 BINDING 372 EXECUTION : 312 TRANSACTION
PROPERTIES 312 TRANSACTION CONCURRENCY CONTROL 313 CONCURRENCY PROBLEMS
314 SCHEDULES AND SERIALIZABILITY 315 THE ISO TRANSACTION STANDARD 315
ORACLE TRANSACTION MANAGEMENT 316 ORACLE S ISOLATION LEVELS 318 CHANGING
THE DEFAULT ISOLATION LEVEL 319 THE READ-ONLY ISOLATION LEVEL 320 THE
SERIALIZABLE ISOLATION LEVEL , 320 THE READ COMMITTED VS. THE
SERIALIZABLE LEVEL OF ISOLATION 320 IMPLEMENTING ORACLE S CONCURRENCY
CONTROL 322 ORACLE LOCKING METHODS 323 ORACLE LOCK TYPES 324 ORACLE LOCK
MODES 325 EXPLICIT LOCKING IN ORACLE 328 MANAGING ORACLE LOCKS , 330
USING UNDO RECORDS TO PROVIDE READ CONSISTENCY 332 AUTOMATIC UNDO
MANAGEMENT 333 XIV QUERYING OLD DATA WITH ORACLE FLASHBACK 340
IMPLEMENTING FLASHBACK QUERY 342 DISCRETE TRANSACTIONS 346 AUTONOMOUS
TRANSACTIONS 346 RESUMABLE STORAGE ALLOCATION 349 RESUMABLE OPERATIONS
349 COMMON RESUMABLE ERRORS 350 USING THE RESUMABLE SPACE ALLOCATION
FEATURE 350 NOTIFICATION OF SUSPENDED OPERATIONS 351 MONITORING
RESUMABLE SPACE ALLOCATION 352 MANAGING LONG TRANSACTIONS 352 BENEFITS
OF USING THE WORKSPACE MANAGER 353 TABLE VERSIONING AND WORKSPACES 353
MANAGING THE WORKSPACE MANAGER 359 SUMMARY 360 PART THREE DATABASE
CREATION, CONNECTIVITY, AND USER MANAGEMENT 261 CHAPTER 9 CREATING AN
ORACLE DATABASE 363 GETTING READY TO CREATE THE DATABASE 364 INSTALLING
THE SOFTWARE 364 CREATING THE FILE SYSTEM FOR THE DATABASE 365 ENSURING
ENOUGH MEMORY IS ALLOCATED 367 GETTING NECESSARY AUTHORIZATIONS 367
SETTING THE OPERATING SYSTEM ENVIRONMENT VARIABLES 367 CREATING THE
INITIALIZATION FILE 368 IMPORTANT ORACLE9I INITIALIZATION PARAMETERS 370
ROLLBACK SEGMENT PARAMETERS 383 UNDOCUMENTED INITIALIZATION PARAMETERS
391 VIEWING THE CURRENT INITIALIZATION PARAMETER VALUES 391 READING THE
INITORA FILE (OR THE SPFILE) 392 THE V$PARAMETER TABLE 392 THE SHOW
PARAMETER COMMAND 392 CREATING THE DATABASE 393 SETTING OPERATING SYSTEM
VARIABLES 394 ENSURING YOU HAVE THE PRIVILEGES TO CREATE DATABASES 394
CREATING THE INITORA FILE 395 STARTING THE ORACLE INSTANCE 396 XV THE
CREATE DATABASE SCRIPT 399 RUNNING ORACLE SCRIPTS TO CREATE DATA
DICTIONARY OBJECTS 403 CREATING ADDITIONAL TABLESPACES 404 CHANGING THE
PASSWORDS FOR THE DEFAULT USERS 406 CHANGING THE ARCHIVE LOGGING MODE
406 RUNNING THE PUPBLD.SQL FILE 408 WHAT NEXT? 409 THE SERVER PARAMETER
FILE (SPFILE) 409 CREATING A SERVER PARAMETER FILE 410 SCOPE OF DYNAMIC
PARAMETER CHANGES 413 STARTING AND SHUTTING DOWN THE DATABASE 414
STARTING THE DATABASE 414 RESTRICTING DATABASE ACCESS 417 SHUTTING DOWN
THE DATABASE 418 QUIESCING A DATABASE ..421 SUSPENDING A DATABASE 423
USING V$VIEWS TO MONITOR DATABASE STATUS 423 SUMMARY 424 CHAPTER 10
CONNECTIVITY AND NETWORKING 425 ORACLE NETWORKING AND DATABASE
CONNECTIVITY 426 NETWORKING CONCEPTS: HOW ORACLE NETWORKING WORKS 427
DATABASE INSTANCE NAME 428 DATABASE SERVICE NAME 428 CONNECT DESCRIPTORS
..429 CONNECT IDENTIFIERS : 429 CONNECT STRINGS 430 THE LISTENER AND
CONNECTIVITY 431 AUTOMATIC SERVICE REGISTRATION 432 LISTENER COMMANDS
433 LISTENER MANAGEMENT :.... 434 NAMING AND CONNECTIVITY 435 LOCAL
NAMING 436 HOST NAMING METHOD 439 EXTERNAL NAMING METHOD 439 ORACLE
NAMES 440 THE DIRECTORY NAMING METHOD 440 ORACLE AND JAVA DATABASE
CONNECTIVITY 461 ESTABLISHING DATABASE CONNECTIVITY 461 WORKING WITH THE
DATABASE 462 A COMPLETE PROGRAM 465 CONNECTIVITY TROUBLESHOOTING 466
SUMMARY 468 XVI CHAPTER 11 USER MANAGEMENT AND DATABASE SECURITY 469
MANAGING USERS 470 PRELIMINARY TASKS BEFORE CREATING USERS 470 CREATING
A NEW USER 471 USER PROFILES AND RESOURCE MANAGEMENT 472 PROFILE
PARAMETERS AND LIMITS 473 USING THE DATABASE RESOURCE MANAGER 477 USING
THE DATABASE RESOURCE MANAGER 478 CREATING RESOURCE PLANS AND PLAN
DIRECTIVES 483 ENABLING THE DATABASE RESOURCE MANAGER 485 MANAGING
ACCESS TO DATA 486 PRIVILEGES IN AN ORACLE DATABASE 486 ROLES AND
PRIVILEGES 490 USING VIEWS AND STORED PROCEDURES TO MANAGE PRIVILEGES
493 FINE-GRAINED DATA SECURITY 493 USING VIRTUAL PRIVATE DATABASES 494
LABEL-BASED ACCESS CONTROL 500 AUDITING DATABASE USAGE 501 CUSTOMIZING
DATABASE AUDITING WITH THE HELP OF TRIGGERS 501 ENABLING AUDITING 505
ORACLE DEFAULT AUDITING 506 AUDIT LEVELS 508 TURNING AUDITING ON 508
TURNING AUDITING OFF 509 USING FINE-GRAINED AUDITING 509 MANAGING THE
AUDIT TRAIL 511 USER AUTHENTICATION 511 DATABASE AUTHENTICATION OF USERS
511 EXTERNAL AUTHENTICATION 516 PROXY AUTHENTICATION 517 CENTRALIZED
USER AUTHORIZATION ...517 ENTERPRISE USER SECURITY 517 SHARED SCHEMAS
518 SINGLE SIGN-ON 518 DATA ENCRYPTION 518 USING ORACLE INTERNET
DIRECTORY FOR SECURITY MANAGEMENT 518 DATABASE SECURITY DO S AND DON TS
519 USER ACCOUNTS 519 PASSWORDS 519 OPERATING SYSTEM AUTHENTICATION 520
AUDIT YOUR DATABASE 520 GRANT PRIVILEGES APPROPRIATELY 520 XVU SET
APPROPRIATE PERMISSIONS 521 SAFEGUARD THE NETWORK AND THE LISTENER 522
KEEP UP-TO-DATE 523 USE ORACLE S ADVANCED SECURITY FEATURE 523 TAKE CARE
OF APPLICATION SECURITY 524 USEFUL TECHNIQUES FOR MANAGING USERS 524 HOW
TO ALTER A PROFILE 524 HOW TO LIST USER INFORMATION 525 HOW TO FIND OUT
THE MEMORY USE FOR EACH ACTIVE SESSION 525 WHAT SQL IS A USER CURRENTLY
EXECUTING? 526 HOW TO LOG IN AS A DIFFERENT USER 526 USEFUL DBA VIEWS TO
MONITOR USER ROLES AND PRIVILEGES 527 HOW TO KILL A USER S SESSION 527
SUMMARY 529 PART FOUR DATA LOADING, BACKUP, AND RECOVERY 531 CHAPTER 12
LOADING AND TRANSFORMING DATA 533 INTRODUCTION TO DATA LOADING AND
TRANSFORMATION 533 LOADING DATA WITH ETL 534 LOADING DATA WITH THE
ORACLE9 /WAREHOUSE BUILDER 535 THE SQL*LOADER UTILITY 536 DIFFERENT
METHODS OF DATA LOADING 536 THE SQL*LOADER CONTROL FILE 537 GENERATING
DATA DURING THE LOAD 547 INVOKING SQL*LOADER 548 USING EXTERNAL TABLES
TO LOAD DATA 555 USING EXTERNAL TABLES FOR DATA LOADING 556 IMPORTANT
ACCESS PARAMETERS FOR EXTERNAL TABLES 558 USING SQL*LOADER TO GENERATE
EXTERNAL TABLE CREATION STATEMENTS 559 TRANSFORMING DATA 562 DERIVING
THE DATA FROM EXISTING TABLES 563 USING PL/SQL TO TRANSFORM DATA 564
USING SQL TO TRANSFORM DATA 564 SOME USEFUL SQL*LOADER DATA-LOADING
TECHNIQUES 573 USING THE WHEN CLAUSE DURING LOADS 573 LOADING THE
USERNAME INTO ATABLE ..574 LOADING LARGE DATA FIELDS INTO A TABLE 574
LOADING A SEQUENCE NUMBER INTO ATABLE 575 XVIII LOADING DATA FROM A
TABLE INTO AN ASCII FILE 575 IDENTIFYING AND REMOVING DUPLICATE DATA 575
DROPPING INDEXES BEFORE BULK DATA LOADS 576 LOADING INTO MULTIPLE TABLES
576 TRAPPING ERROR CODES FROM SQL*LOADER 576 LOADING XML DATA INTO AN
ORACLE XML DATABASE 577 SUMMARY 577 CHAPTER 13 USING THE EXPORT AND
IMPORT UTILITIES .....579 EXPORTING AND IMPORTING DATA 579 USING THE
EXPORT UTILITY 580 EXPORT PARAMETERS 581 INVOKING THE EXPORT UTILITY 587
USING THE IMPORT UTILITY 590 THE ORDER OF IMPORTING 590 IMPORT
PARAMETERS 590 INVOKING THE IMPORT UTILITY 598 TRANSPORTABLE TABLESPACES
599 USES OF TRANSPORTABLE TABLESPACES 600 TRANSPORTING A TABLESPACE 600
SOME EXPORT AND IMPORT TECHNIQUES 604 AVOIDING COMMON EXPORT/IMPORT
ERRORS 605 USING THE STATISTICS PARAMETER APPROPRIATELY 605
UNDERSTANDING THE LIMITATIONS OF THE EXPORT AND IMPORT UTILITIES 606
PERFORMING AN EFFICIENT DATABASE MIGRATION 606 RESTORING A DATABASE
USING THE EXPORT AND IMPORT UTILITIES 607 EXPORTING AND IMPORTING LARGE
DATABASES 607 UNIX SHELL SCRIPT TO AUTOMATE EXPORTS 608 ENSURING THE
VALIDITY OF THE EXPORTS 608 OPTIMIZING EXPORTS AND IMPORTS 609 SUMMARY
610 CHAPTER 14 BACKING UP DATABASES 611 BACKING UP ORACLE DATABASES 611
IMPORTANT BACKUP TERMS .....612 BACKUP STRATEGIES 614 BACKING UP THE
OTHER FILES 619 A SUMMARY OF BACKUP METHODS 619 XIX ORACLE RECOVERY
MANAGER 619 BENEFITS OF RMAN 620 RMAN ARCHITECTURE ...621 CONNECTING TO
RMAN 622 SCRIPTING WITH RMAN 624 IMPORTANT RMAN TERMS 625 RMAN COMMANDS
627 CONFIGURING RMAN 631 CREATING THE RECOVERY CATALOG 637 EXAMPLES
OFVARIOUS BACKUPS USING RMAN 642 PERFORMING INCREMENTAL BACKUPS 645
USING RMAN TO PERFORM ONLINE BACKUPS 646 USING A MEDIA MANAGEMENT LAYER
WITH RMAN ....647 USING LEGATO SINGLE SERVER VERSION WITH RMAN 648 THE
LSSV ARCHITECTURE 649 INSTALLING LSSV .....650 USING LSSV 651 LSSV AND
RMAN 652 CREATING BACKUPS WITH OPERATING SYSTEM COMMANDS 655 MAKING
WHOLE DATABASE BACKUPS 656 PARTIAL DATABASE BACKUPS 661 MONITORING
USER-MANAGED ONLINE BACKUPS 662 ENHANCED DATA PROTECTION FOR DISASTER
RECOVERY 662 ORACLE DATA GUARD AND STANDBY DATABASES 663 PHYSICAL AND
LOGICAL STANDBY DATABASES 664 PROTECTION MODES 665 DATABASE CORRUPTION
AND TESTING BACKUPS 666 ORACLE DATA BLOCK CORRUPTION 666 DETECTING DATA
BLOCK CORRUPTION 667 VERIFICATION OF RMAN BACKUPS 669 ORACLE S HARD
INITIATIVE 670 TECHNIQUES AND TROUBLESHOOTING 670 MONITORING RMAN 670
THE ORA_00257 ERROR 671 SUMMARY 671 CHAPTER 15 DATABASE RECOVERY 673
TYPES OF DATABASE FAILURES 673 SYSTEM FAILURE 673 FAST-START FAULT
RECOVERY 674 DATA CENTER DISASTERS 675 HUMAN ERROR 675 MEDIA FAILURES
676 XX EXTENT OF DATABASE FAILURE AND TYPES OF RECOVERY 677 RESTORING
VS. RECOVERING A DATABASE 677 TIME NEEDED FOR RECOVERY 678 COMPLETE AND
INCOMPLETE RECOVERY 679 OPEN AND CLOSED RECOVERY 679 REDUCING YOUR
VULNERABILITY 679 PERFORMING RECOVERY WITH RMAN 680 WHY RMAN IS BEST FOR
RECOVERY 680 USER-MANAGED RECOVERY OF A DATABASE 682 TYPICAL MEDIA
RECOVERY SCENARIOS 683 COMPLETE RECOVERY OF AWHOLE DATABASE 683
RECOVERING A TABLESPACE 686 RECOVERING A DATA FILE 688 INCOMPLETE
RECOVERY 690 RECOVERING FROM THE LOSS OF CONTROL FILES 693 RECOVERING A
DATA FILE WITHOUT A BACKUP 697 CLONING A DATABASE 698 USINGRMAN : 698
CLONING A DATABASE MANUALLY 702 TECHNIQUES FOR GRANULAR RECOVERY 703
TABLESPACE POINT-IN-TIME RECOVERY 704 USING RMAN FOR TSPITR 704 USING
LOGMINER FOR PRECISION RECOVERY 705 USING FLASHBACK QUERY FOR RECOVERY
711 REPAIRING DATA CORRUPTION AND TRIAL RECOVERY 714 BLOCK MEDIA
RECOVERY 714 TRIAL RECOVERY 715 TROUBLESHOOTING RECOVERY 716 THE
ORA-01194 ERROR 716 THE ORA-01152 ERROR 717 THE ORA-00376 ERROR 718
SUMMARY 719 PART FIVE MANAGING THE OPERATIONAL ORACLE DATABASE ...721
CHAPTER 16 MANAGING THE OPERATIONAL DATABASE 723 ORACLE S AUTOMATIC
MANAGEMENT FEATURES 723 FULLY LOCALLY MANAGED DATABASES 724 AUTOMATIC
UNDO MANAGEMENT 726 RESUMABLE SPACE ALLOCATION 730 AUTOMATING AND
MONITORING RECOVERY TIME 734 XXI EASY FILE MANAGEMENT WITH OMF 736
BENEFITS OF USING OMF 737 CREATING ORACLE MANAGED FILES 737 ONLINE
CAPABILITIES OF 0RADE9I 742 ONLINE DATA REORGANIZATION 742 ONLINE TABLE
REDEFINITION 745 DYNAMIC RESOURCE MANAGEMENT 751 ONLINE DATABASE BLOCK
CHANGES 753 DYNAMIC MEMORY RECONFIGURATION 755 USING DATABASE QUIESCING
FOR ONLINE MAINTENANCE 759 SUSPENDING THE DATABASE 760 MANAGING THE
ONLINE REDO LOGS 760 MANAGING THE ARCHIVED LOGS 764 MANAGING A DATABASE
LINK 764 MAPPING ORACLE FILES TO PHYSICAL DEVICES 766 ARCHITECTURE OF
FILE MAPPING 766 SETTING UP FILE MAPPING 767 TIPS AND TROUBLESHOOTING
768 PROBLEMS DURING QUIESCING A DATABASE 768 FAILED ONLINE TABLE
REDEFINITIONS 768 PROBLEMS DURING ONLINE INDEX REBUILDS 769 SUMMARY 769
CHAPTER 17 USING 0RADE9I ENTERPRISE MANAGER 771 ORACLE ENTERPRISE
MANAGER 771 BENEFITS OF USING OEM TO MANAGE DATABASES 773 THE VARIOUS
SYSTEMS OF OEM 775 THE OEM ARCHITECTURE AND COMPONENTS 776 CONFIGURING
OEM 778 CONFIGURING THE INTELLIGENT AGENT 778 CONFIGURING THE MANAGEMENT
SERVER 780 CONFIGURING THE OEM CONSOLE 785 CONFIGURING REPORTING 788
RUNNING THE CONSOLE FROM A WEB BROWSER 791 USING THE OEM CONSOLE 792
DISCOVERING SERVICES 792 THE SERVICES, ORA FILE 792 DATABASE MANAGEMENT
THROUGH OEM ....793 DATABASE INSTANCE MANAGEMENT 794 DATABASE SCHEMA
MANAGEMENT 795 DATABASE SECURITY MANAGEMENT 796 DATABASE STORAGE
MANAGEMENT 796 DISTRIBUTED DATABASE MANAGEMENT 797 XXU USING THE OEM
WIZARDS 799 THE EXPORT AND IMPORT WIZARDS 800 THE ANALYZE WIZARD 801 THE
BACKUP WIZARD 802 USING THE OEM REPORTING FEATURES 803 PREBUILT AND
CUSTOM REPORTS 804 ACCESSING THE REPORTING WEB SITE 804 MANAGING JOBS
WITH OEM 806 THE JOB DETAIL VIEW 807 CREATING A JOB ..807 MANAGING
EVENTS WITH OEM 810 CREATING EVENTS 810 SPECIFYING THE TEST CONDITIONS
810 SELECTING THE TEST CRITERIA ...811 SCHEDULING THE EVENT :...812
CONFIGURING E-MAIL AND PAGING NOTIFICATION 8J2 CONFIGURING PAGING
NOTIFICATION 812 CONFIGURING E-MAIL NOTIFICATION 814 ORACLE MANAGEMENT
PACKS 814 ORACLE DIAGNOSTICS PACK . 814 ORACLE TUNING PACK 817 ORACLE
CHANGE MANAGEMENT PACK ..817 TROUBLESHOOTING OEM 817 SUMMARY 818 PART
SIX PERFORMANCE TUNING AND TROUBLESHOOTING THE PRODUCTION DATABASE 819
CHAPTER 18 IMPROVING DATABASE PERFORMANCE: SOL QUERY OPTIMIZATION 821 AN
APPROACH TO ORACLE PERFORMANCE TUNING 821 A SYSTEMATIC APPROACH TO
PERFORMANCE TUNING 822 REACTIVE PERFORMANCE TUNING 822 SQL CODING
PRACTICES 823 OPTIMIZING ORACLE QUERY PROCESSING 824 PARSING 824
OPTIMIZATION 824 QUERY EXECUTION 828 XXUI QUERY OPTIMIZATION AND THE
ORACLE COST-BASED OPTIMIZER 828 CHOOSING YOUR OPTIMIZATION MODE 829
PROVIDING STATISTICS ABOUT THE OBJECTS TO THE OPTIMIZER 829 SETTING THE
OPTIMIZER MODE 830 SETTING THE OPTIMIZER LEVEL 831 WHAT DOES THE
OPTIMIZER DO? 831 DRAWBACKS OF THE CBO 833 PROVIDING STATISTICS TO THE
CBO 834 WRITING EFFICIENT SQL 839 EFFICIENT WHERE CLAUSES 839 USING
HINTS TO INFLUENCE THE EXECUTION PLAN 842 SELECTING THE BEST JOIN METHOD
843 USING BITMAP JOIN INDEXES 843 SELECTING THE BEST JOIN ORDER 845
INDEXING STRATEGY 845 USING THE OEM INDEX TUNING WIZARD 849 MONITORING
INDEX UTILIZATION 850 REMOVING UNNECESSARY INDEXES 851 USING SIMILAR SQL
STATEMENTS 851 REDUCING SQL OVERHEAD VIA INLINE FUNCTIONS 851 USING
BIND VARIABLES 852 AVOIDING IMPROPER USE OFVIEWS 853 AVOIDING
UNNECESSARY FULL TABLE SCANS 853 HOW THE DBA CAN HELP IMPROVE SQL
PROCESSING 853 USING PARTITIONED TABLES 854 USING COMPRESSION TECHNIQUES
854 USING MATERIALIZED VIEWS 855 USING STORED OUTLINES TO STABILIZE THE
CBO 855 USING PARALLEL EXECUTION 859 OTHER DBA TASKS 859 SQL PERFORMANCE
TUNING TOOLS 860 USING THE EXPLAIN PLAN 861 USING AUTOTRACE 865 USING
SQL TRACE AND TKPROF 870 USING V$SQLAREA TO FIND INEFFICIENT SQL 877
USING GUI TOOLS IN TUNING.. 879 A SIMPLE APPROACH TO TUNING SQL
STATEMENTS 884 IDENTIFY PROBLEM STATEMENTS 884 LOCATE THE SOURCE OF THE
INEFFICIENCY 885 TUNE THE STATEMENT 885 COMPARE PERFORMANCE 885 SUMMARY
886 XXIV CHAPTER 19 PERFORMANCE TUNING: TUNING THE INSTANCE : 887 AN
INTRODUCTION TO INSTANCE TUNING 887 TUNING ORACLE MEMORY 890 TUNING THE
SHARED POOL 892 TUNING THE BUFFER CACHE 906 TUNING THE LARGE POOL 911
TUNING PGA MEMORY 911 AUTOMATIC PGA MEMORY MANAGEMENT 911 EVALUATING
SYSTEM PERFORMANCE 912 CPU PERFORMANCE 912 DISKL/O 919 MEASURING I/O
PERFORMANCE 920 IS THE I/O OPTIMALLY DISTRIBUTED? 921 REDUCING DISK
CONTENTION 922 THE ORACLE SAME GUIDELINES FOR OPTIMAL DISK USAGE 922
COLLECTING INSTANCE PERFORMANCE STATISTICS WITH STATSPACK ....922
INSTALLING STATSPACK 923 USING STATSPACK ; . ..925 MEASURING INSTANCE
PERFORMANCE .... 936 DATABASE HIT RATIOS 937 DATABASE WAIT STATISTICS
938 KNOW YOUR APPLICATION 952 OPERATING SYSTEM MEMORY MANAGEMENT 954
WHEN A DATABASE HANGS 954 HANDLING A STUCK ARCHIVER PROCESS 954 SYSTEM
UTILIZATION PROBLEMS 956 EXCESSIVE CONTENTION FOR RESOURCES 957 LOCKING
ISSUES 957 ABNORMAL INCREASE IN PROCESS SIZE 958 DELAYS DUE TO SHARED
POOL PROBLEMS 960 PROBLEMS DUE TO BAD STATISTICS 960 COLLECTING
INFORMATION DURING A DATABASE HANG 960 A SIMPLE APPROACH TO INSTANCE
TUNING 963 WHAT S HAPPENING IN THE DATABASE? 963 ARE THERE ANY
LONG-RUNNING TRANSACTIONS? 964 IS ORACLE THE PROBLEM? 965 IS THE NETWORK
OKAY? 965 IS THE SYSTEM CPU BOUND? 966 IS THE SYSTEM I/O BOUND? 968
CHECKING MEMORY-RELATED ISSUES 969 XXV IS THE SYSTEM WAIT BOUND? 969
ELIMINATING THE CONTENTION 970 SUMMARY 972 CHAPTER 20 THE ORACLE DATA
DICTIONARY AND THE DYNAMIC PERFORMANCE VIEWS 973 THE ORACLE DATA
DICTIONARY 973 HOW IS THE DATA DICTIONARY CREATED? 974 USING THE DATA
DICTIONARY STATIC VIEWS 975 GENERAL VIEWS 975 USER MANAGEMENT-RELATED
VIEWS 979 AUDIT-RELATED VIEWS 987 STORAGE-RELATED VIEWS 989 VIEWS FOR
MONITORING TRANSACTIONS 993 CONSTRAINT- AND INDEX-RELATED VIEWS 995
VIEWS FOR MANAGING DATABASE OBJECTS 999 VIEWS FOR MANAGING TABLES AND
VIEWS 999 USING THE DYNAMIC PERFORMANCE TABLES 1003 MEMORY-RELATED VIEWS
1004 BACKUP-RELATEDVIEWS 1008 SESSION-AND USER-RELATED VIEWS . . 1010
REDO LOG- AND ARCHIVE LOG-RELATED VIEWS 1012 RECOVERY-RELATED VIEWS 1015
PERFORMANCE MONITORING VIEWS 1016 SQL-RELATED VIEWS 1018 OPERATIONAL
PERFORMANCE-RELATED VIEWS 1018 GENERAL VIEWS 1022 STORAGE-AND
FILE-RELATED VIEWS 1026 SUMMARY 1027 CHAPTER 21 USING ORACLE PL/SQL
PACKAGES 1029 OVERVIEW OF THE ORACLE-SUPPLIED PL/SQL PACKAGES 1029 WHO
CREATES THE ORACLE PACKAGES? 1029 HOW DO YOU USE THE ORACLE PACKAGES?
...1030 DBMSJOB . .1031 USING THE DBMS JOB PACKAGE IO32 OTHER DBMS JOB
PROCEDURES 1033 DBMS_APPLICATION_INFO 1033 DBMS_SESSION ....1035
SETJLOLE 1036 SET_SQL_TRACE 1036 SWITCHJ3URRENTJCONSUMER_GROUP 1037 XXVI
DBMS_SYSTEM 1037 SET_SQL_TRACEJN_SESSION 1039 SETJNTJ?ARAMJN_SESSION
1039 SETJ3OOLPARAMJN_SESSION 1039 SETJSV 1040 DBMS_OUTPUT 1040
DBMS_REPAIR 1042 USING THE DBMS JIEPAIR PACKAGE 1043 FIXING BLOCK
CORRUPTION 1044 DBMSJOUTLN AND DBMS_OUTLN_EDIT 1045 USING THE DBMS
J3UTLN PACKAGE TO MANAGE STORED OUTLINES 1045 TRACKING THE OUTLINES IN
THE DATABASE 1046 DBMS_SPACE 1047 DBMS_SPACE_ADMIN 1049 DBMSJROFILER
1050 A USEFUL PACKAGE FOR DEVELOPERS 1050 INSTALLING THE DBMSJ ROFILER
PACKAGE 1051 USING THE DBMSJ?ROFILER PACKAGE 1051 UTLJILE 4 1053 USING
THE UTLJ ILE PACKAGE 1054 A SIMPLE EXAMPLE USING THE UTLJILE PACKAGE
1056 UTLJMTP 1057 PROCEDURES IN THE UTL_SMTP PACKAGE 1057 USING THE
UTL_SMTP PACKAGE 1060 DBMS_SHARED_POOL 1060 DBMS_LOGSTDBY 1062 ORACLE
PACKAGES IN EARLIER CHAPTERS 1063 THE DBMS_STATS PACKAGE 1063 DBMSJILS
1064 DBMSJFGA 1065 DBMSJTESOURCEJVLANAGER 1065 DBMSJIESUMABLE 1066
DBMSJDLAP 1066 DBMS.MVTEW 1068 DBMS.METADATA 1069 DBMSJIEDEFINITION 1069
DBMSJLASHBACK .....1070 DBMS_WM 1070 DBMSJJ3GMNR 1071 DBMSJIEFRESH 1072
DBMS_TTS 1073 DBMSJJTILITY 1074 DBMS_STORAGEJVIAP 1075 SUMMARY 1076
XXVII CHAPTER 22 MANAGING ORACLE DATABASES ON WINDOWS AND LINUX SYSTEMS
1077 0RADE9I AND WINDOWS 1077 DATABASE ACCESS METHODS 1078 ORACLE
SUPPORT FOR .NET 1078 INTEGRATION WITH WINDOWS SERVICES 1079 ESSENTIAL
DIFFERENCES IN MANAGING ORACLE ON WINDOWS AND UNIX 1080 PROCESSES VS.
THREADS 1080 ORACLE SERVICE THREADS J083 SERVICES AND DAEMONS 1084
TUNING MEMORY RESOURCES 1085 CPU AND MEMORY CONSIDERATIONS 1086
AUTOMATIC START-UP AND SHUTDOWN 1086 USERS AND GROUPS 1086 THE FILE
SYSTEMS 1087 THE WINDOWS COPY UTILITIES 1087 DIFFERENCES IN THE USE OF
THE GUI 1087 AUTOMATING JOBS J087 DIAGNOSTIC TOOLS 1088 INSTALLING
0RADE9I ON A WINDOWS SYSTEM 1088 THE WINDOWS REGISTRY 1089 USING THE
REGISTRY 1089 MANAGING ORACLE ON WINDOWS SYSTEMS 1090 ORACLE SERVICES
1090 STARTING UP AND SHUTTING DOWN THE ORACLE DATABASE 1094 USING THE
ORACLE ADMINISTRATION ASSISTANT FOR NT 1097 UNINSTALLING ORACLE ON
WINDOWS 1100 0RADE9I AND LINUX LIOI ORACLE S COMMITMENT TO LINUX 1102
ENSURING YOU HAVE A STABLE VERSION OF LINUX 1102 MANAGING ORACLE ON
LINUX 1103 SUMMARY ~...U03 APPENDIX A BRIEF 0RADE9I SQL AND PL/SOL
PRIMER 1105 THE 0RADE9I SAMPLE SCHEMAS 1106 BASIC SQL 1107 THE SELECT
STATEMENT 1107 THE INSERT STATEMENT 1109 XXVUI THE DELETE STATEMENT 1109
THE UPDATE STATEMENT 1110 FILTERING DATA 1111 SORTING THE RESULTS OF A
QUERY NIL THE ORDER BY CLAUSE 1111 SORTING ORDER 1111 SORTING BY
MULTIPLE COLUMNS 1111 OPERATORS 1112 COMPARISON OPERATORS 1112 LOGICAL
OPERATORS 1112 THE SET OPERATORS 1113 SQL FUNCTIONS 1113 SINGLE-ROW
FUNCTIONS 1113 AGGREGATE FUNCTIONS 1114 NUMBER AND DATE FUNCTIONS 1114
GENERAL FUNCTIONS AND CONDITIONAL EXPRESSIONS 1115 SQL ANALYTICAL
FUNCTIONS 1116 HIERARCHICAL RETRIEVAL OF DATA 1117 SELECTING DATA FROM
MULTIPLE TABLES 1118 THE CARTESIAN PRODUCT 1118 THE FOUR TYPES OF ORACLE
JOINS 1119 GROUPING OPERATIONS 1120 NESTING GROUP FUNCTIONS 1121 THE
GROUP BY CLAUSE WITH A ROLLUP OPERATOR ....1121 THE GROUP BY CLAUSE WITH
A CUBE OPERATOR 1122 THE GROUP BY CLAUSE WITH A GROUPING OPERATOR 1122
THE GROUP BY CLAUSE WITH A GROUPING SETS OPERATOR 1122 THE HAVING CLAUSE
1123 WRITING SUBQUERIES 1123 TOP N ANALYSIS 1123 SINGLE-ROW SUBQUERIES
1124 MULTIPLE-ROW SUBQUERIES 1124 MULTIPLE-COLUMN SUBQUERIES 1124
ADVANCED SUBQUERIES 1124 THE EXISTS AND NOT EXISTS OPERATORS 1124
ABSTRACT DATA TYPES 1125 THE CREATE TYPE COMMAND 1125 OBJECT TABLES 1125
COLLECTIONS 1126 TYPE INHERITANCE 1126 THE CAST OPERATOR 1127 XXIX
ONTENTS USING PL/SOL II27 THE BASIC PL/SQL BLOCK 1128 DECLARING
VARIABLES 1128 WRITING EXECUTABLE STATEMENTS 1129 HANDLING ERRORS 1129
PL/SQL CONTROL STRUCTURES 1130 CONDITIONAL CONTROL 1130 PL/SQL LOOPING
CONSTRUCTS 1130 CURSORS IJ32 IMPLICIT CURSORS II32 EXPLICIT CURSORS IJ32
CURSOR ATTRIBUTES 1133 CURSOR FOR LOOPS 1134 PL/SQL RECORDS 1134 CURSOR
VARIABLES 1134 FUNCTIONS 1135 PACKAGES 1135 ORACLE XML DB 1136 STORING
XML IN ORACLE XML DB 1137 THE ORACLE XML DB REPOSITORY 1139 SETTING UP
AN XML SCHEMA 1140 CREATING A RELATIONAL VIEW FROM AN XML DOCUMENT 1140
0RADE9I AND JAVA 1141 USING JAVA WITH ORACLE 1141 SUMMARY 1143 INDEX
1145 XXX
|
| any_adam_object | 1 |
| author | Alapati, Sam R. |
| author_facet | Alapati, Sam R. |
| author_role | aut |
| author_sort | Alapati, Sam R. |
| author_variant | s r a sr sra |
| building | Verbundindex |
| bvnumber | BV016488914 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)51839038 (DE-599)BVBBV016488914 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01390nam a2200385 c 4500</leader><controlfield tag="001">BV016488914</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20030514 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">030203s2003 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1590590228</subfield><subfield code="9">1-59059-022-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)51839038</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV016488914</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-20</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Alapati, Sam R.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Expert Oracle9i Database Administration</subfield><subfield code="c">Sam R. Alapati</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">APress</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XLII, 1202 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 9i</subfield><subfield code="0">(DE-588)4646123-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE 9i</subfield><subfield code="0">(DE-588)4646123-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch Darmstadt</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010192005&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-010192005</subfield></datafield></record></collection> |
| id | DE-604.BV016488914 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T19:11:05Z |
| institution | BVB |
| isbn | 1590590228 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-010192005 |
| oclc_num | 51839038 |
| open_access_boolean | |
| owner | DE-20 |
| owner_facet | DE-20 |
| physical | XLII, 1202 S. Ill. |
| publishDate | 2003 |
| publishDateSearch | 2003 |
| publishDateSort | 2003 |
| publisher | APress |
| record_format | marc |
| spelling | Alapati, Sam R. Verfasser aut Expert Oracle9i Database Administration Sam R. Alapati Berkeley, CA APress 2003 XLII, 1202 S. Ill. txt rdacontent n rdamedia nc rdacarrier Oracle (Computer file) Database management ORACLE 9i (DE-588)4646123-1 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf ORACLE 9i (DE-588)4646123-1 s Datenbankverwaltung (DE-588)4389357-0 s DE-604 HEBIS Datenaustausch Darmstadt application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010192005&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Alapati, Sam R. Expert Oracle9i Database Administration Oracle (Computer file) Database management ORACLE 9i (DE-588)4646123-1 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4646123-1 (DE-588)4389357-0 |
| title | Expert Oracle9i Database Administration |
| title_auth | Expert Oracle9i Database Administration |
| title_exact_search | Expert Oracle9i Database Administration |
| title_full | Expert Oracle9i Database Administration Sam R. Alapati |
| title_fullStr | Expert Oracle9i Database Administration Sam R. Alapati |
| title_full_unstemmed | Expert Oracle9i Database Administration Sam R. Alapati |
| title_short | Expert Oracle9i Database Administration |
| title_sort | expert oracle9i database administration |
| topic | Oracle (Computer file) Database management ORACLE 9i (DE-588)4646123-1 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | Oracle (Computer file) Database management ORACLE 9i Datenbankverwaltung |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010192005&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT alapatisamr expertoracle9idatabaseadministration |