Oracle Internals Tips and Technical Trips
Ch. V.N.Sanyasi Rao1, Tiruveedula Gopi Krishna2
1Ch.V. N. Sanyasi Rao, Assoc. Project Manager, HCL, Bangalore, India.
2Tiruveedula Gopi Krishna, Sirt University Lecturer, Department of Computer Science, Hoon, Libya.
Manuscript received on March 06, 2015. | Revised Manuscript received on March 11, 2015. | Manuscript published on March 15, 2015. | PP: 28-32 | Volume-3 Issue-4, March 2015. | Retrieval Number: D0819033415/2015©BEIESP
Open Access | Ethics and Policies | Cite | Mendeley
© The Authors. Published By: Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: The Study or knowledge of internal structures of Oracle is necessary for an advanced performance tuning and trouble-shooting. To understand Oracle Optimizes these internal structures are useful. Oracle uses hidden parameters also. It is advisable to know them but not to play with them. Understanding online backup functionality the knowledge of internals helps a lot. Oracle documentation on tuning the database, a good reading helps to Improve Database Performance. This paper describes oracle internals mainly into the following aspects such as parsing oracle statements, locks contention internals, cursor sharing internals, soring operations Internals and shared pool internals.
Keywords: Oracle internals; parsing; lock contention; cursor sharing; shared pool.