SNO Day Topic 1 1 Introduction to D2K, O/S Total Days= 12 2 1 RDBMS Consepts Total HR= 70 3 1 Arch-1 4 1 Arch-2 5 1 Arch-3 6 1 Installatin of linux 7 1 Installatin of Oracle 8 2 Sql and Pl/Sql 9 2 Creating of DB 10 2 Oracles Files 11 2 TS-Management 12 2 TS-Management 13 2 RBS 14 2 UNDO Segments 15 3 Index Segments 16 3 Data Segments 17 3 Extents Managments 18 3 User-Managent 19 3 Deffred RBS 20 3 Load-Balancing 21 3 Snap-Shot error 22 4 Flash-Back query 23 4 Oracle-Networking 24 4 DB-Link 25 4 Materlize-View 26 4 Export and Import 27 4 Cold Bkup 28 4 Hot Bkup 29 Practical 10 Cases 30 5 Rman 31 5 Controlfile 32 5 Redo Logs 33 5 Archive logs 34 5 Changing DB Name 35 5 ArchiveMode 36 5 Auditing 37 6 SP-File 38 6 PT-Hardware 39 6 Diff bet 8i,9i,10g 40 6 PT-App Tuning 41 6 Explain plan 42 6 Tkproof 43 6 Sql-Tuneing 44 7 Sql * Loader 45 7 Indexing 46 7 Optimazation 47 7 Networking Tune 48 7 Query Rewrite 49 8 Partationing 50 8 Data-Gurd 51 8 Memory-Tuning 52 8 Logminer 53 8 Online-Redefenation 54 9 Row Migration 55 9 Row Chaining 56 9 Stack-Pack 57 9 Raw-Devices 58 10 OMF 59 10 OEM 60 10 OPQ 61 10 Distribution Tx 62 10 Two-Phace Commit 63 10 Data-Pump 64 10 External-Table 65 11 Rman-10g 66 11 TTS 67 11 AWR(Automatic Work-Load Repository 68 11 ADDM(Automatic DB Diagnostic Monitor 69 11 ASMM(Automatic Shared Memory Management) 70 12 Resumable Space Allocation 71 12 ASM(Automatic storage Management) 72 12 Flash-Back DB 73 12 Streams Replication 74 12 Rman-Point in Time Recovery 75 12 OEM-Jobs and Events 76 12 DBMS-Built in Packages 77 12 Virtual Private DB 78 12 DB-Cloning