log all sql commands

Is it possible to log all the sql that oracle 8i runs ?
maybe add the querys in a db and delete them when older than a selected
time.
there are some problems on the server and we want to check if there is a
strange query that block all the server (linux) for a lot of minutes.

thanks
Lenny


.

Relevant Pages

  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm writing for them. ... How do I get a free Oracle client installed, if possible, so I can test some SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm writing ... How do I get a free Oracle ... client installed, if possible, so I can test some SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • Re: Exporting and Importing SQL Statement Cache
    ... the SQL Statement Cache in Oracle 8i? ... If we swap servers after a few days the ... new live server gets overloaded. ...
    (comp.databases.oracle.server)
  • Re: Exporting and Importing SQL Statement Cache
    ... the SQL Statement Cache in Oracle 8i? ... If we swap servers after a few days the ... new live server gets overloaded. ...
    (comp.databases.oracle.server)