Examining Oracle Net Trace Files
I lost a count how many times I had to trace sqlnet clients and collect trace files .Many times I tried to read them and understand what is realy going on, but these files are hard to read and understand without detail explanation of Oracle Net protocol.Ultimatelly Oracle support will analyze them and send explanation. … Read more
Procedure to kill blocking session in RAC 11g
Many times I tried to kill session in RAC and then get message back saying that session cannot be killed because my session is connected to different instance.Then I would login to instance where blocking sessions runs and kill it. Starting with 11g , Oracle included instance name in alter system kill command (3thd parameter or @instance_id … Read more
