WANT VIDEO TUTORIALS

1Z0-007	Oracle 9i- Introduction toSQL	http://linkrapidshare.wordpress.com/2008/03/15/introduction-to-oracle9i-sql/
1z0-031	Oracle 9i- DBA Fundamentals I	http://www.xdownx.org/index.php?showtopic=28344%20-%2068k
1z0-032	Oracle 9i- DBA Fundamentals II	http://www.technolib.net/2007/01/06/vtc-oracle-database-administration-fundamentals-ii/

BOOKS/NOTES/QN BANK FREE DOWNLOAD

Oracle Certifications
Sl	Certification	File Name	Type	Pages	Size
02	OCA/OCP	Oracle DBA Made Simple	.pdf	350	3MB
02	OCA/OCP	Oracle DBA Guide	.pdf	160	700kb
03	OCA/OCP	Oracle DBA Interview Qns	.doc	26	90kb
04	OCP	1Z0-033/Oracle 9i DBA Performance Tuning(60Qns)	.pdf	115	450kb
05	OCP	1Z0-033/Oracle 9i DBA Performance Tuning(326 Qns)	.pdf	200	700kb
If any of the above links violates copy-right laws, please inform me so that I will be able to remove them

CLICK HERE TO DOWNLOAD STUDY MATERIAL

The Index of this book given below.

Contents 1 Postinstallation Database Creation Before You Create a Database............ 1-2 Naming Conventions for Oracle Databases . 1-2 Accessing Data Files and Log Files on Remote Computers ............. 1-3 Creating a Database Using Tools ...... 1-4 Using Oracle Database Configuration Assistant................. 1-4 Create a Database ....... 1-5 Importing Sample Schemas .. 1-8 iv Delete a Database..... 1-10 Creating a Database Manually ........ 1-10 How to Create a Database .......... 1-11 Creating Directories.. 1-11 Exporting an Existing Database. 1-12 Deleting Database Files............... 1-13 Modifying the init.ora file........... 1-14 Creating and Starting an Oracle Service...... 1-16 Putting the CREATE DATABASE Statement in a Script ................ 1-16 Creating a Database.. 1-17 Importing a Database.................. 1-18 Updating the ORACLE_SID in the Registry.................. 1-19 Backing Up the New Database .. 1-21 Using the ORADIM Utility to Administer an Oracle Instance ......... 1-22 Creating an Instance. 1-23 Starting an Instance .. 1-25 Stopping an Instance 1-25 Modifying an Instance ................ 1-26 Deleting an Instance . 1-27 2 Postinstallation Configuration Tasks Oracle interMedia ............. 2-2 Audio........ 2-2 Video......... 2-2 Image ........ 2-2 Locator...... 2-2 Oracle Text ...... 2-2 Oracle interMedia Audio, Video, Image, and Locator Configuration Responsibilities...... 2-3 Configuring Oracle interMedia Audio, Video, Image, and Locator 2-3 Configuring Oracle interMedia, Audio, Video, Image, and Locator Demos .... 2-4 Oracle Text Configuration Responsibilities .. 2-4 Oracle Spatial. 2-7 Configuring Oracle Spatial........... 2-8 Shared Server Support ..... 2-9 Enabling Shared Server Support for IIOP Clients......... 2-11 v Enabling Shared Server Support for Two-Task Oracle Net Clients................. 2-11 Disabling Shared Server Support for Two-Task Oracle Net Clients................ 2-12 Advanced Replication... 2-13 Task 1: Checking Tablespace and Rollback Segment Requirements ............... 2-13 Task 2: Checking Initialization Parameters 2-14 Task 3: Monitoring Data Dictionary Tables 2-14 3 Administering a Database Managing Oracle Services.................. 3-2 Oracle Service Naming Conventions for Multiple Oracle Homes .. 3-2 Available Oracle Services ............. 3-4 Starting Oracle Services ................ 3-5 Stopping Oracle Services .............. 3-6 Auto-starting Oracle Services ...... 3-8 Starting and Shutting Down a Database with SQL*Plus .. 3-9 Starting and Shutting Down a Database Using Services. 3-11 Running Multiple Instances............ 3-14 Creating Password Files 3-15 Viewing Password Files.............. 3-17 Deleting Password Files 3-18 Connecting Remotely to the Database as SYS 3-18 Encrypting Database Passwords..... 3-18 Creating Control, Data, and Log Files on Remote Computers........... 3-19 Archiving Redo Log Files................. 3-20 Task 1: Change the Archive Mode to ARCHIVELOG . 3-20 Task 2: Enable Automatic Archiving........... 3-21 Using the ORADEBUG Utility ....... 3-23 4 Monitoring a Database Database Monitoring Overview....... 4-2 Using Oracle for Windows NT Performance Monitor ...... 4-2 Registry Information.. 4-3 Accessing Oracle for Windows NT Performance Monitor............... 4-4 Monitoring Oracle9i Objects ........ 4-5 Understanding Oracle Performance Objects 4-6 vi Oracle for Windows NT Performance Monitor Troubleshooting Information 4-8 Using the Event Viewer ... 4-9 Accessing the Event Viewer ......... 4-9 Reading the Event Viewer .......... 4-10 Using the Event Viewer .............. 4-11 Managing the Event Viewer....... 4-12 Using Trace and Alert Files .............. 4-13 Viewing Threads Using the Oracle Administration Assistant for Windows NT................. 4-14 5 Tuning Windows NT to Optimize Oracle9i Overview ........ 5-2 Reduce Priority of Foreground Applications on the Server Console . 5-3 Configure Windows NT Server to Be an Application Server .............. 5-4 Disable Unnecessary Services ........... 5-6 Remove Unused Network Protocols .................. 5-7 Reset the Network Protocol Bind Order............. 5-8 Apply Latest Reliable Windows NT Server Service Pack 5-10 Use Hardware or Operating System Striping . 5-11 Multiple Striped Volumes for Sequential and Random Access..... 5-16 Span Windows NT Server Virtual Memory Paging File Across Physical Volumes ............ 5-16 General Page File Sizing Tip ...... 5-16 Close All Unnecessary Foreground Applications ............. 5-17 Startup Folder........... 5-17 Virtual DOS Machines ................ 5-17 Screen Savers ............. 5-17 6 Backing Up and Recovering Database Files Selecting a Backup and Recovery Tool ............... 6-2 Integrating RMAN with a Media Manager on Windows NT .............. 6-3 Backing Up Files with the OCOPY Utility......... 6-4 Recovering Files with the OCOPY Utility ......... 6-6 Using Legato Storage Manager ......... 6-7 Settings for Multiple Tape Devices ................ 6-7 Japanese Version of Legato Storage Manager ................. 6-7 vii 7 Oracle9i Database Specifications for Windows Initialization Parameter File (init.ora) Overview................ 7-2 Location of the Initialization Parameter File 7-2 Editing the Initialization Parameter File ....... 7-2 Sample File ................. 7-3 SGA_MAX_SIZE parameter ........ 7-4 Initialization Parameters Without Windows NT-Specific Values....... 7-4 Displaying Initialization Parameter Values.. 7-5 Database Initialization Parameters ................ 7-6 Calculating Database Limits.............. 7-6 A Storing Tablespaces on Raw Partitions Raw Partition Overview.. A-2 Disk Definition ............ A-2 Raw Partition Definition............... A-3 Physical Disk ........ A-3 Logical Partition .. A-4 Physical Disk and Logical Partition Considerations.................. A-4 Frequently Asked Questions A-5 Compatibility Issues .............. A-6 Creating an Extended Partition......... A-7 Creating Logical Partitions in an Extended Partition..... A-8 Creating a Tablespace in a Raw Partition.......... A-9 Glossary Index