I'm testing connection pooling and also how to use audit and mix it up with information I have only inside our system.
Nice and valuable tips
But is this case I just went back to basics, to my first class of Oracle, and create 02 more index that were missing on the columns recording sid and the time of logoff.
This avoided FTS and gave me an Index Scan
I got seriously depressed realizing I did not do the basics before thinking complicated.