Understanding the General Query Log
Posted by: Veronica Mayer
Date: June 10, 2012 10:31AM

Can anybody help me interpret what's in the General Query Log?

My output looks something like this:


1 Init DB wheresmysh_t
1 Query call GetObjectsFromContainer (10)
1 Init DB wheresmysh_t
1 Query SELECT * FROM Container WHERE parentContainerId = 60
1 Init DB wheresmysh_t
1 Query call GetObjectsFromContainer (60)
1 Init DB wheresmysh_t
1 Query SELECT * FROM Container WHERE parentContainerId = 24

What does the 1 mean? Does "Init DB" mean that there's a new client connection? Would you expect there to be some sort of "Disconnect DB" statement in there?

I haven't seen any information on the web about how to read this file's contents, so if anyone knows of one...

Options: ReplyQuote


Subject
Written By
Posted
Understanding the General Query Log
June 10, 2012 10:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.