How to view database query log?

I

ince2019-02-21 10:06:51

Oracle

ince, 2019-02-21 10:06:51

Is it possible to see the database query log? Is this being done?
Does the base have such functionality?

spoiler

Is there something like v$sql

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

Konstantin Tsvetkov, 2019-02-21
@tsklab

alter session set sql_trace=true
Tracing in Oracle .

X

xtender, 2019-03-12
@xtender

Disabled by default, because logging all requests will gobble up a lot of space. If necessary, of course, you can temporarily enable it - read about audit: https://docs.oracle.com/cd/E11882_01/server.112/e1...