Database Reference
In-Depth Information
SETINST <instance# .. | all> Set instance list in double quotes
SGATOFILE <SGA dump dir> Dump SGA to file; dirname in double quotes
DMPCOWSGA <SGA dump dir> Dump & map SGA as COW; dirname in double quotes
MAPCOWSGA <SGA dump dir> Map SGA as COW; dirname in double quotes
HANGANALYZE [level] [syslevel] Analyze system hang
FFBEGIN Flash Freeze the Instance
FFDEREGISTER FF deregister instance from cluster
FFTERMINST Call exit and terminate instance
FFRESUMEINST Resume the flash frozen instance
FFSTATUS Flash freeze status of instance
SKDSTTPCS <ifname> <ofname> Helps translate PCs to names
WATCH <address> <len> <self|exist|all|target> Watch a region of memory
DELETE <local|global|target> watchpoint <id> Delete a watchpoint
SHOW <local|global|target> watchpoints Show watchpoints
DIRECT_ACCESS <set/enable/disable command | select query> Fixed table access
CORE Dump core without crashing process
IPC Dump ipc information
UNLIMIT Unlimit the size of the trace file
PROCSTAT Dump process statistics
This tool helps in identifying any specific issues with the database, such as the following examples:
1.
In Chapter 13, we used this tool to relocate the master from one instance in the cluster to
another:
SQL> oradebug lkdebug -m pkey 492984
Statement processed.
The preceding command will relocate the object identified by 492984 mastered on another instance to
the current instance. LKDEBUG is a RAC-specific command to collect global cache data:
2.
In Chapter 14, we discussed how this tool could be helpful to understand what IP address
for interconnect is registered with the database:
SQL> ORADEBUG SETMYPID
ORADEBUG IPC
EXIT
The preceding command will dump the interconnect details registered with the Oracle kernel.
SSKGXPT 0x3671e28 flags SSKGXPT_READPENDING info for network
socket no 9 IP 172.16.193.1 UDP 59084
sflags SSKGXPT_WRITESSKGXPT_UP
info for network 1
socket no 0 IP 0.0.0.0 UDP 0
sflags SSKGXPT_DOWN
context timestamp 0x4402d
no ports
 
Search WWH ::




Custom Search