Welcome to Oracle-Experts.info
All articles are based on real time industry experience. If you have something to share and want to publish on this website then please email to submission@oracle-experts.info with your name and well formatted article. We will publish article on your name.
DBA Tasks:
A DBA is like an insurance card; you use insurance in case of an emergency. Just like management uses a DBA when there is a data disaster.
* Oracle Installation,OEM use, * RMAN backup,recovery,DR planning * knowledge of dynamic performance views like how to find OS Pid and seid, sql statements * Oracle CPU patch - MUST , how to patch enviroments - OPatch * Security, Profile and Resource management * Perform database tuning and performance monitoring * Perform application tuning and performance monitoring,Tuning - explain plan and tkprof ( tkprof levels like 12,8,4) * Setup and maintain documentation and standards * Capacity planning * On Call DBA - 24*7 * Statspack/AWR analysis, knowledge of wait events * Interaction with Oracle Corporation for technical support.
|