Latch Free

[CarlosRicardo]

Hello,
I have PL/SQL Developer version 6.0.5 against Oracle 9.2.0.8 and each time I open the Developer it creates two Oracle sessions, one inactive and the other active this one with the event "latch free" on the Oracle Wait Events. Is that normal?
Thank you

 

[KJlt]

I'm not sure about latch free event, but several sessions from one plsqldev instance it's normal. You can adjust it with "Session mode" parameter. Not sure about 6.0.5, but try to search something like this: Preferences -> Connection -> Session mode. Options are Multi Session, Dual Session, Single Session. I would advise not to use Single session if you don't have session limit on DB. Disadvantages are you can't work in a window while there is some execution in another, you can't break your query, you can't debug, you can't kill your session from this plsqldev instance, plsqldev hangs while long query is executed. I do prefer Multi Session whitch creates main session + 1 session per window.

 

[CarlosRicardo]

Thank you for your reply. I have Multi Session on "Session Mode" parameter. My question is because as soon as I log in, without do anything more, it creates two Oracle sessions and one of them stay always Active with the "latch free".