Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 723 of 2,288    |
|    Frank to Majkl Najt    |
|    Re: Monitor SQL queries    |
|    26 Nov 03 21:36:55    |
      From: fbortel@nescape.net              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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca