Without turning trace on, can someone recommend a way to monitor user access or activity to an Oracle database? We are worried about users performing long-running queries using columns that are not keys or indexed.

Is there a table that has information about a particular user such as last connect time, how long connected, etc?

Thank you.