Monitor SQL queries

[Majkl Najt]

Hi!

Is it possible to see what statements has been executed to database?
Is there any tool or log to look into?

I am new to Oracle and have been mainly doing things with MySQL where
you can enable logging and then just watch logs.

Any hints?

Thanks.

[Frank]

Majkl Najt wrote:

Hi!

Is it possible to see what statements has been executed to database?
Is there any tool or log to look into?

I am new to Oracle and have been mainly doing things with MySQL where
you can enable logging and then just watch logs.

Any hints?

Thanks.

Yes - seems a bit deep for a beginner, though.
v$sqlarea, column sqltext, gives the statement
Do a describe on v$sqlarea.

Tools: TOAD (there's a free download, still), TORA (works
on Linux, too), SQL*Plus, Oracle Enterprise Manager, ...
--
Regards, Frank van Bortel