oracle dba training | oracle dba online training | oracle dba course
TRANSCRIPT
L/O/G/O
Oracle 11g DBA Online Training
http://oracle11g-dbatrainingonline.blogspot.in/
Contents
Oracle architecture
Network Administration
Performance & Tuning
Other Misc topics4
1
2
3
Oracle Architecture
Memory structures and background processes
Logical and physical structure Data dictionary objects Creating database manually and using wizard
on both windows and UNIX platforms Working with initialization parameter file Multiplexing control and online redo log files Oracle managed files Tablespaces Oracle block level concepts Working with segments Managing users with profiles
Network Administration
Oracle NET Sqlnet.ora, tnsnames.ora, and listener.ora Creating and managing listeners Configuring sqlnet.ora and tnsnames.ora Database links
Backup and Recovery
Logical backups using datapump Recovery manager (RMAN) concepts and
advantages Cold backup using manual and RMAN Hot backup using manual and RMAN Restoring from backups using manual and
RMAN Full recovery of databases using manual and
RMAN Incomplete recovery of databases using
manual and RMAN Flashback Log miner
Performance & Tuning
Instance hit ratios Working with more dynamic performance
views Working with AWR, ADDM, ASH Optimizer Statistics Diferent types of indexes Working with different advisors Hints Explain plan
Other Misc topics
Applying patches and patchsets Working with Oracle support Copying files between servers using ftp, scp,
and sftp Upgrading databases Working with zip and tar utilities Crontab and scheduled tasks
L/O/G/O
Thank You!