Printable View
Hi
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.
thanks
regs
mubeen
may be you should start by learning the architecture then basic administration
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.
Hi, 15th May 2001 18:27 hrs *******
look at this link for more information of your interest.
http://www.dbasupport.com/forums/sho...threadid=10596
Cheers
Padmam