What is ORADEBUG? Explain its uses?

          

What is ORADEBUG? Explain its uses?


Oracle database - What is ORADEBUG? Explain its uses? posted by Babu Kunwar
<<Previous   Next>>

What is ORADEBUG? Explain its uses?

ORADEBUG is a utility that allows users to perform the following operations:

  • Start and stop tracing for any session.
  • Dump SGA and other memory structures.
  • Wakeup oracle processes such as SMON or PMON
  • Suspend and resume processing in a SID.

Uses of ORADEBUG utility:

  • Monitoring the Current Session With the oradebug setmypid.
  • Debug enqueue services.
  • Debug the CGS name service.
  • Dump core files and IPC information.


Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
More links
SQL number functions

Define, syntax and an example with output for: ABS(number), CEIL(number), FLOOR(number), MOD(number, divisor), POWER(number, power), SIGN(number), ROUND(number, precision), SQRT(number), TRUNC(number, precision)......................

Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring