oracle11g - Is there a tool for tracing SQLs executed on Oracle -


is there tool (that comes oracle) tracing sqls have been executed? in db2 there called 'event monitor' use track tables have been updated. there equivalent tool in oracle?

i plan to

  • enable tracing
  • go on website (that uses db) , change entry
  • disable tracing
  • see output file , record table has been updated.

there table looking should updated when entry changed. not know name of table (and there many tables), , need trace sql executed find out.

i have tried:

  alter session set sql_trace = true;   -- go on website , change entry   alter session set sql_trace = false;    tkprof the_trace_file.trc file.out explain=system/manager sys=no

however when following steps above, no sqls recorded.

is there tool oracle provides? (i avoid downloading external software)

there table looking should updated when entry changed. not know name of table (and there many tables), , need trace sql executed find out.

i'm thinking using word "trace" here meaning meant in oracle world.

you hit button in app, , looking @ sql queries running, want find table code referencing? did right?
in case, have @ v$sql, , @ columns sql_text , sql_fulltext.


Comments

Post a Comment

Popular posts from this blog

apache - Add omitted ? to URLs -

i working on website cms reads page name of query string, e.g. http://exmaple.com/?pagename . trying create rewrite rule rewrite ? . so, user types in /pagename , taken /?pagename try this: rewriteengine on rewritecond %{request_filename} !-d rewritecond %{request_filename} !-f rewriterule ^/?(.*) index.php?$1 [l]
Read more

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

i using bbpress installation without wordpress integration. the redirect of rewriteengine @ forum site works: rewriteengine on rewritecond %{http_host} ^forum.mysite.com$ rewriterule (.*)$ http://www.forum.mysite.com/$1 [r=301,l] the problem login pppress. bbpress login not recognize: http://www.forum.mysite/bb-login.php . it redirects to: http://forum.mysite.com/bb-login.php . i tried permalink settings none , name based, same issue. does uses redirect in bbpress or how can eliminate "double" content , redirect permanently www.? i redirected www.forum.mysite.com forum.mysite.com , achieved eliminate "double" content.
Read more

php - How can I stop spam on my custom forum/blog? -

so have custom built forum & blog system of late has been dealing lot of spam. if wordpress use akismet, if different common platform i'm sure i'd find plugin. there kind of static class can download this? using php. i'd still go akismet, if it. uses outside of wordpress, may have pay fee it, depending on use -- check terms , conditions -- it's option , easy implement in php using api. use api key wordpress. com account access. basically, grab whichever php client library takes fancy -- use alex potsides' php5 library -- plug in key, , it's handful of lines of code. here's bare bones of validation straight 1 of live sites: ... if ($akismet) { $akismet->setcommentauthor($name); $akismet->setcommentauthoremail($session->userinfo["email"]); $akismet->setcommentauthorurl(""); $akismet->setcommentcontent($sentence);...
Read more