Oracle database - What is ORADEBUG? Explain its uses? posted by
Babu Kunwar
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.
More links
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)......................
|
