I am basically a developer. I want to switch over to DBA side. I am confident about backup & recovery. But at the same time I want command over Database administration, performance tuning (topics/papers of OCP) such as SGA sizing etc.
Can one guide me how/where should I start.
may be you should start by learning the architecture then basic administration
Focus on the details
1)How Oracle Database Engine internally process when you run a Query/Update/Delete/Insert.
2)How Oracle communicates from CLient to Server thru Middle tiers and what are the components involved
3)As for as Performance is concerned its on going process, you have to see where you have bottle necks, whiuch components of Oracle(Memory, I/O, RBS, REDO etc.,) making the response slow and start from there investigating and tuning.
Not mentioning anything about Backup and recovery as you know it.
Look this link
Hi, 15th May 2001 18:27 hrs *******
look at this link for more information of your interest.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width