Why Must Roman Catholics Go to Mass Every Sunday? | justmecatholicfaith OracleOCP10g | Oracle Database | Test (Assessment)
Uploaded by ctsaa
Presented by Howard Horowitz
10g, 9i, 8i hhorow6801@aol.com Howard.horowitz@adeccona.com
    Strategies for preparing for the exam Resources used to prepare for each exam Format of the exams Overview of the 10g upgrade exam including a few of the less known, least used Oracle 10g features that are likely to be on the exam
Part 1 ± OCP Format, Structure, and Strategies
 What is OCP?
 How is it measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues?
OCP is a valuable industryindustryrecognized credential that signifies a proven level of knowledge and ability.What Is OCP ? Oracle Certification was developed by Oracle and Sylvan Prometric.´ / By Rich Niemiec March/April 2002 Oracle Magazine ³Getting Good At What You Do´ 4 . ³Taking the time to get certified creates several positive career benefits and gives you a balance between doing and learning that is so desperately needed in information technology. An Oracle Certified Professional establishes a standard of competence in a specific job role.
Structure. and Strategies  What is OCP?  How is OCP measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues? 5 .OCP Format.
How is OCP measured in the industry ?  Oracle Certified Professionals were found to earn the highest average salaries as compared to any other DBA or Developer professionals.com/news/CRN/30947.asp 6 .html?w hycert_employer.certmag.com/education/certification/index.channelsupersearch. as these conclusions from a research study by International Data Corporation** suggest http://www. professionals Certification Magazine ± http://www.oracle.com  Hiring certified professionals has a direct impact on a company's bottom line.html  The results from the 2001 CRN Certification Study show Oracle certifications offer the best ROI for larger solution providers http://crn.
and Strategies  What is OCP?  How is it measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues? 7 . Structure.OCP Format.
)  Increased job opportunities (OCP members site and other job sites). Depends on economy (job market). and access to OCA and OCP websites)  Special discounts and offers (35% off Oracle Press Books)  Exposure to features you haven¶t used 8 .  Use of Oracle certification program logo for endorsement of your proven skill by Oracle corporation. business card. logo.  Invaluable experience as a result of preparing  New tricks and skills to add to your arsenal  Looks good on resume (Receive certificate.What are the benefits from being Certified?  Valuable to hiring managers  Added credibility (Excellent for contractors who sell narrow skill sets and must claim to be immediately productive.
OCP Format. Structure. and Strategies  What is OCP?  How is it measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues? 9 .
Take 4.html Oracle University .Prepare for the test 2.What are the required steps for getting certified? 1.Prepare 3.Schedule 3.Select a track 2.html?starthere.(800) 529-0165 52910 .Schedule the test 4.com/education/certification/ind ex.oracle.Take each test in the track http://www.
OCP.Tracks (FOCUS ON) Oracle Database Administrator:  Oracle 10g DBA (OCA. OCM) Oracle 9i Forms Developer:  Oracle 9i PL/SQL Developer Certified Associate  Oracle 9i Forms Developer Certified Professional Oracle Forms 6i Developer Oracle Application Server 10g:  Oracle Application Server 10g Administrator Certified Associate (OCA)  Oracle Application Server 10g Administrator Certified Professional (OCP) Oracle 9i Application Server:  Oracle9iAS Web Administrator Certified Associate 11 . OCP. OCM)  Oracle 9i DBA (OCA.
Schedule 3.Take each test in the track 12 .Take 4.Schedule the test 4.Select 2.Prepare for the test 3.Select a track 1.What are the required steps for getting certified? 1.
Self-Test and OPN offer discounts Selfhttp://www.com/education.com/education. Software simulates actual exam. http://www.com. Test voucher¶s included for each exam. Quickest route with 2-3+ years exp 2 TBT¶s and Self-Test Software.com.com. and availability 13 (Cost more / Less experience) .oracle. experience.2test.oracle.oracle. http://www.com.selftestsoftware. $125 to take More experience) the exam. $70 for the two books. Beta exams. 1(Cost less / Cost: $99 per practice exam. Self(250http://www. Might get lucky and find 1-2 questions on the actual exam. Oracle Technical Based Training Selfhttp://www. Selfhttp://www.com/education Cost: $3000 for each class. 0-1 0years exp  Bottom line: depends on individual.2test. 1-2 years exp  Instructor based training and Self-Test Software.selftestsoftware.Prepare for the test  Self-Test Software (250-300 questions) and SYBEX OCP Books. http://www. Cost: $3000+ for the OCP (Recommended) bundle.
Prepare for the test Ocp: Oracle 10g New Features For Administrators : Study Guide (Certification Study Guide) by Bob Bryla. Bob Bryla. Doug Stuns. Matthew Weishan 14 . Chip Dawes. Johnson. Biju Thomas Amazon .Mostly 4-5 star customer reviews OCP: Oracle 10g Certification Kit (1Z0-042 and 1Z0-043) by Tim Buterbaugh. Joseph C.
com  Sybex flash cards ± Included on CD with Book (Palm V)  http://www.com  University Certificate programs (Columbia.oracle.html  http://technet.  Oracle doc set ± http://technet. «etc) (Comes out of a separate budget) 15 . NYU.com/docs/content. and registration material).com/training/content.dbdomain. preparation.Additional resources used to prepare for the exams  Oracle University .html  http://metalink.oracle.oracle. Hofstra ± includes student kit.(800) 529-0165 529 Oracle Candidate Guide (test topics.
Schedule the test 1800-891-exam or http://www.What are the required steps for getting certified? 1. Prepare for the test 3. Take each test in the track 16 . Select a track 2.com (Need 2 days notice) 4.2test.
Prepare for the test 3. Schedule the test 4.What are the required steps for getting certified? 1.Take each test in the track 17 . Select a track 2.
Select courses from the following website: http://www.(OCM) Oracle Certified Master 2 classes + OCM practicum exam.OCP 1Z01Z0-033 Oracle 9i: Performance and Tuning ± OCP ± ± ± ± ± Oracle 9i Special Accreditation ± Managing 9i on Linux ± 1Z01Z0-036 Managing Oracle 9i on Linux (Mo Money!) Oracle 9i DBA .html 18 .com/education/certification/index.Database Administrator Exams 9i Oracle 9i upgrade exam ± (Recommended Oracle Used by most companies) 1Z01Z0-030 Oracle 9i Database: New features for Administrators (8i -> 9i) 9i DBA 1Z01Z0-007 Oracle 9i: SQL (available online for $90) ± OCA (available $90) 1Z01Z0-031 Oracle 9i: Fundamentals I ± OCA Attend an Approved Hands-On Training Course Hands1Z01Z0-032 Oracle 9i: Fundamentals II .html?dba9i_ocm.oracle.
(OCM) Oracle Certified Master 2 days hands-on handsOCM practicum exam.BETA Oracle 10g DBA ± ± ± 1Z01Z0-042 Oracle 10g: Administration I ± OCA Attend an Approved Hands-On Training Course Hands1Z01Z0-043 Oracle 10g: Administration II ± OCP Oracle 10g Special Accreditation ± (Mo Money!) Details to follow in the coming months Oracle 10g DBA .Database Administrator Exams 10g Oracle 10g upgrade exam ± ± 1Z01Z0-040 Oracle 10g Database: New features for Administrators (9i -> 10g) 1Z11Z1-045 Oracle 10g Database: New features for Administrators (8i -> 10g) . ± Details to follow in the coming months 19 .
and Strategies  What is OCP?  How is it measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues? 20 .OCP Format. Structure.
 Incorrect answers are not subtracted from score.  Allowed at least 90 minutes per exam. experience.Exam Content / Structure  Tests knowledge of Oracle concepts.  Each exam consists of 60-80 multiple choice 60questions and given via computer.  Beware of trick questions: Recommended vs Required 21 . Guess if you don¶t know the answer  Receive your grade back as soon as the exam is finished. practical experience. and training.
and Strategies  What is OCP?  How is it measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues? 22 . Structure.OCP Format.
5 hours Not available at this time.How are the exams scored ? On average. 9i 9i 9i 9i 9i EXAM # 1Z0040 1Z1045 1Z0042 1Z1043 1Z0030 1Z0035 1Z0007 1Z0001 1Z0031 1Z0032 1Z0033 1Z0036 EXAM TITLE Oracle Database 10g New Features for Administrators Oracle Database 10g New Features for Oracle8i OCPs Oracle Database 10g: Administration I Oracle Database 10g: Administration II Oracle9i Database: New Features for Administrators TOTAL QUESTIONS 61 QUESTIONS CORRECT 37 PASSING % 57% DURATION 1. 75 not yet available 53 n/a n/a n/a 49 n/a 37 65% n/a 70% 2 hours n/a 1.5 hours 23 2 hours . allowed up to 17 questions wrong to pass TRACK 9i to 10g Upgrade Exam 8i to 10g Upgrade Exam 10g 10g 8i to 9i Upgrade Exam 7.3 to 9i Upgrade Exam 9i. 8i 8i.5 hours Oracle9i DBA: New Features for Oracle7.5 hours 1.5 hours 1.3 and Oracle8 OCPs Introduction to Oracle9i: SQL Introduction to Oracle: SQL and PL/SQL Oracle9i Database: Fundamentals I Oracle9i Database: Fundamentals II Oracle9i Database: Performance Tuning Managing Oracle9i on Linux 84 58 69% 2 hours 57 57 60 63 59 59 40 39 44 49 38 34 71% 69% 74% 78% 65% 57% 2 hours 2 hours 1.
Structure.OCP Format. and Strategies  What is OCP?  How is it measured in the industry?  What are the benefits from being certified?  What are the required steps for getting certified?  What¶s the exam content / structure?  How are the exams scored?  Miscellaneous issues? 24 .
(Unless they announce retirement of track)  Beta exams offer discounts  Certification is valid for 6 months following a general announcement of re-certification.Miscellaneous Issues  Takes approx 1.5 years) usually follows a new release. (Valid refor approx 1. 9i. 8i.5 ± 3 months to get certified.10g«etc 25 . (approx 40 hours preparation time per exam)  Wait 30 days to retake exams  No time limit between passing first and last exam.
9i.horowitz@adeccona.com 26 . 8i hhorow6801@aol.Oracle 10g (OCP) Certification Preparation (end of part 1) ANY QUESTIONS ? Presented by Howard Horowitz 10g.com Howard.
Part 2 ± What will I be expected to know for the exam? 10g New Features for Administrators (You will be tested on the same material for Admin I and II) 27 .
Each file containing different values for the SGA parameters and automated via shell and Cron/Autosys. Workaround You have to shutdown the database and manually change the values. This could be done programmatically with multiple init<SID>. 28 .ora files.10g New Features for Administrators Automatic Shared Memory Management 8i method for automating SGA management There is no method.
Cron and Autosys to automate. 29 . Still not doable. Manual / programmatic effort is required if the behavior of your database changes and SGA changes are needed. Workaround You have to use the alter system/session commands and also rely on the v$shared_pool_advice and db_cache_advice views for proper settings. you can dynamically change many of the values without shutting down the database.10g New Features for Administrators Automatic Shared Memory Management 9i method for automating SGA management. however.
alter system set sga_target=µx¶.10g New Features for Administrators Automatic Shared Memory Management 10g method for automating SGA management. 30 .
This parameter is new in Oracle Database 10g and reflects the total size of memory an SGA can consume.10g New Features for Administrators Automatic Shared Memory Management sga_target -. Shared pool Buffer cache Java Pool Large Pool 31 .
10g New Features for Administrators Automatic Shared Memory Management Online Users Buffer Cache Large Batch Jobs Buffer Cache Large Pool Large Pool SQL Cache Java Pool SQL Cache Java Pool sort sort  Automatically adapts to workload changes  Maximizes memory utilization  Single Parameter SGA Pool makes it easier to use PGA Pool  Helps eliminate out of memory errors  Can help improve performance 32 .
 Does not apply to the following parameters. other block sizes) Streams Pool (new in Oracle Database 10g) Fixed SGA and other internal allocations  Can be adjusted via EM or command line.     Log Buffer Other Buffer Caches (KEEP/RECYCLE. 33 . Can not exceed sga_max_size.  A new background process named Memory Manager (MMAN) manages the automatic shared memory.10g New Features for Administrators Automatic Shared Memory Management  Requires an SPFILE and SGA_TARGET > 0.
7 Oracle 9i Release 1 ± 9.1.6 -> 8.5 -> 8.2.1.1 ± 8.1.0 Indirect methods require you to perform two upgrades to get to 10g ± 8. Direct methods allow you to upgrade directly to 10g from the following Oracle releases: ± ± ± ± Oracle 8 Release 8.2.10g New Features for Administrators Upgrading the database Definition ± You can upgrade an earlier release of Oracle to Oracle 10g by using direct or indirect methods.1.0.1 ± 7. Depending on the method will determine whether you use the manual and/or DBUA utility to perform the upgrade.6 Oracle 8i Release 8.0.4 -> 9.7 -> 10.1 Oracle 9i Release 2 ± 9.0 -> 10.7 -> 10.1 36 .1.3.
N/A  8i / 9i method for importing and exporting data via PL/SQL. N/A  8i / 9i method for remapping tablespaces and datafiles. N/A Data Pump  8i / 9i method for controlling the number of threads/processes. tables. procedures. N/A  8i / 9i method for monitoring export and import¶s. N/A  8i / 9i method for exporting/importing pre-defined objects via include or exclude keywords (grants. N/A 41 . Supports like and not like clause.. N/A  8i / 9i method for direct mode imports. functions.etc).10g New Features for Administrators  8i / 9i method for suspending exports and imports. N/A  8i / 9i method for restarting failed exports and imports at point of failure.
As with Export. the job can be parallelized for even more improvement dynamically. 42 . Creates a separate dump file for each degree of parallelism. whereas Data Pump Import uses the Direct Path method of loading.10g New Features for Administrators Data Pump High performance import and export  60% faster than 9i export (single thread)  15x-45x faster than 9i import (single thread) The reason it is so much faster is that Conventional Import uses only conventional mode inserts.
10g New Features for Administrators Time is money. 000 1500 Data Pump Time i s 1000 500 0 Export Or Import 43 . Data Pump has cut down data movement/processing times significantly.
Shutdown the database 2. Restore all of the datafiles from last backup 3. Recover database until (SCN or Time) 5. Apply the necessary redo/archive logs 6. Startup the database in mount state 4. Open the database ± open resetlogs 48 .10g New Features for Administrators Flashback Database 8i / 9i method for point-in-time recovery 1.
10g New Features for Administrators Flashback Database 10g method for point-in-time recovery 1. Open the database ± open resetlogs 49 . Startup the database in mount state 3. SQL> flashback database to timestamp to_timestamp(µ2004-12-16 16:10:00¶. Shutdown the database 2. µYYYY-MM-DD HH24:MI:SS¶). 4.
Flashback Database 
New strategy for point-in-time recovery  Flashback Log captures old versions of changed blocks. Disk Write New Block Version Old Block Version
   Think of it as a continuous backup Replay log to restore DB to time Restores just changed blocks
Like a ³Rewind´ button for the Database 
It¶s fast - recovers in minutes, not hours. More over, this feature removes the need for database incomplete Flashback Log recoveries that require physical movement of datafiles/restores.  It¶s easy - single command restore
 SQL> Flashback Database to scn 1329643
 Not used for Media failure errors. Used for Logical/User errors.  The database control file has been restored or re-created.  Previous tablespace has been dropped.  The database data file that contains the object to be queried has been shrunk.  A recovery through the resetlogs command has occurred. Views for Monitoring  V$Database  V$Flashback_Database_Log  V$Flashback_Database_Stat
± Segment Shrink compresses the data blocks in a table or index and optionally moves the HWM down, making the unused space available for other segments in the tablespace. Prior to 10g, the HWM could be moved down only if the segment was moved or truncated. Online table redefinition and/or CTAS operations can also provide similar results, however, these methods must temporarily provide double the amount of space occupied by the table. Segment shrink is online and in place.
1. Alter table hr.employees enable row movement; (prerequisite) 2. Alter table hr.employees shrink space compact; (Compress the rows without moving the HWM to prevent I/O throughput from decreasing). 3. Alter table hr.employees shrink space; (Move the HWM and complete the operation when the database isn¶t as busy). A small number of rows are locked for a brief amount of time. 4. Alter table hr.employees shrink space cascade; (Also shrinks dependent objects ± indexes). 5. Alter index hr.emp_emp_id_pk shrink space; (Without cascade, need 55 to identify indexs from dba_indexes and shrink each one separately).
± ± ± ± Heap-organized and index-organized tables HeapindexIndexes Partitions and subpartitions Materialized Views and materialized view logs
± ± ± ± ± ± Clustered tables Tables with Long Columns Tables with on-commit or ROWID-based MV¶s onROWIDLOB segments IOT mapping tables or overflow segments Tables with function-based indexes function-
EM database control and Segment Advisor can assist you in identifying segments that can leverage from segment shrink.
60 .arc.bak.etc. *.10g New Features for Administrators RMAN Backupset Compression 8i / 9i method for compressing backups (Compression utility) gzip *. *.ctl«.
± RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG.10g New Features for Administrators RMAN Backupset Compression 10g method for compressing backups ± RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET. The resulting backupsets do not need to be uncompressed during recovery. this didn¶t help for large databases with little free space. however. Prior to Oracle 10g. The AS COMPRESSED BACKUPSET option of the BACKUP command allows RMAN to perform binary compression of backupsets. This was great for databases that were over-sized. RMAN reduced the size of backup images by backing up only used blocks. 61 .
10g New Features for Administrators RMAN Backupset Compression Pros:  Backupsets were compressed by 78% when compared to a regular backupset. Cons:  Creating compressed backupsets imposes some extra CPU overhead during backup and restore. 62 . you can use increased parallelism to run jobs on multiple CPUs and thus improve performance. which can slow the backup process. If you have more than one CPU.
A new background process is introduced . It uses a change-tracking-file to track the physical location of all database change-trackingchanges. you only need to specify db_create_file_dest parameter to /u04/oradata. RMAN uses the change tracking file to identify only the blocks that have changed.dbf¶.CTWR 65 . as opposed to reading the entire datafile to determine which blocks have changed. Alter database enable block change tracking using file µ/u04/oradata/ord/changetracking/chg01. During an RMAN Incremental backup.10g New Features for Administrators RMAN Fast Incremental Backups Definition ± Speeds up RMAN Incremental backups by identifying those data blocks that have already changed since the previous backup. Syntax ± OR ± You can configure via EM Database Control NOTES ± ± When using OMF.
Side-Note .You were able to flush the shared pool SQL> ALTER SYSTEM FLUSH SHARED_POOL.10g New Features for Administrators Flush Buffer Cache 8i/9i method for flushing the buffer cache Prior to 10g. 69 . this wasn¶t possible without shutting down and restarting the database or using the following undocumented commands:   SQL> alter session set events = 'immediate trace name flush_cache'. alter tablespace offline/online to flush the buffer cache of blocks relating to that tablespace (As per Tom Kytes Article).
70 .10g New Features for Administrators Flush Buffer Cache 10g method for flushing the buffer cache 10g has provided the ability to flush the buffer cache. This isn¶t suggested for a production environment. That results in longer search times. SQL> ALTER SYSTEM FLUSH BUFFER_CACHE. the larger the LRU and dirty list becomes. if the buffer cache is undersized. In addition to decreasing free buffer waits. The bigger the cache. However. but might be useful for QA/Testing. than running the following command can improve performance and take the burden off the DBWR.
Drop the original tablespace and datafile(s) after the objects are moved to the newly named tablespace. 2. 3. depending on the size of the tablespace). Create a new tablespace with the same size as the original one. (You have to make sure you have enough room on disk to store a duplicate copy). (This could take a while. this might require additional analysis of the original tablespace to determine if the new tablespace can be resized/reorged. Space pending.10g New Features for Administrators Rename Tablespace 8i / 9i method for renaming tablespaces 1. Move objects from the original tablespace to the new one. 72 .
10g New Features for Administrators Rename Tablespace 10g method for renaming tablespaces SQL> alter tablespace users rename to users3. 73 .
Elapsed: 00:00:00. A simple alter tablespace command is all you need. SQL> alter tablespace users rename to users3.10g New Features for Administrators Rename Tablespace Oracle allows the renaming of tablespaces in 10g. Tablespace altered.05 SQL> alter tablespace users3 rename to users. Tablespace altered. Elapsed: 00:00:00.02 74 .
Temporary. 75 .10g New Features for Administrators Rename Tablespace  Rename tablespace feature has lessened the workload for TTS operations.  Doesn¶t Support System or Sysaux tablespaces  Supports Default. There¶s no need to delete tablespaces on the target prior to impdp metadata. and Undo Tablespaces (dynamically changes the spfile).
It¶s used to store many of the objects that used to be stored in the System tablespace.10g New Features for Administrators Sysaux Tablespace Definition ± The Sysaux tablespace is a required tablespace for Oracle 10g. It removes a lot of the I/O and fragmentation that used to occur in the System tablespace. Requirements (same characteristics as System) ± ± ± ± ± Online Permanent Read Write Extent Management Local Segment Space Management Auto Restrictions ± ± ± ± Can¶t be OFFLINE Can¶t be Temporary Can¶t be Read Only Can¶t be Dictionary Managed 78 .
move_procedure. Only some of the objects can be moved. 79 . Restrictions ± An occupant without a move procedure can¶t be moved out of the Sysaux tablespace. space_usage_kbytes from v$sysaux_occupants.10g New Features for Administrators Sysaux Tablespace Contents ± Some of the objects/occupants stored in the Sysaux tablespace:           Logmnr Logstdby Streams AO Statspack ODM Text WM EM Job_scheduler Syntax ± Select occupant_name.
Part 2 ± What will I be expected to know for the exam? 10g New Features for Administrators A few more practice questions on some nice features. 83 .
backups. It¶s built in)  utl_compress (compression of binary data (blobs and raw data). Support of regular expressions (Unix commands in PL/SQL) Default temporary and user tablespaces 84 .   Similar to gzip. RMAN> drop database including backups. and spfile). control files. archive logs.Part 2 ± What will I be expected to know for the exam? Additional 10g features worth mentioning  Drop database command (includes datafiles.  Automated Storage Management  utl_mail (no need to reference utl_smtp protocol.
html (Oracle IT Manager News.oracle.com  http://www.References Books and Software:  OCP Oracle 10g New Features for Administrators by Bob Bryla and Biju Thomas  Self-Test Software SelfWeb Sites:  http://www. ³Certifying with Oracle´ / By Mike Serpe ± Global Director for Oracle University) 90 .com/education/certification  http://www.oracle.dbdomain.com/newsletters/itmanagers/itcurrent.
com Howard.Oracle 10g (OCP) Certification Preparation ANY QUESTIONS ? hhorow6801@aol.com 91 .Horowitz@adeccona.
Documents Similar To OracleOCP10g
Oca Oracle SQL
Oracle DB Security_Customers