• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

tracing sql queries

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hallo, everybody. Does anobody know a way to trace sql queries that application sends to database (Oracle 8). I tried already OracleLog but it seems he write only driver's method's invocations . Like this:

0000000144 Wed Sep 14 14:26:36 GMT 2005 DRVR 1 OPER main Enabled logging (moduleMask 0x0fffffff, categoryMask 0x0fffffff)
0000000145 Wed Sep 14 14:26:36 GMT 2005 DRVR 0 DBG1 main doDefaultTypes
0000000146 Wed Sep 14 14:26:36 GMT 2005 DRVR 0 DBG1 main doDefinesFromTypes
0000000147 Wed Sep 14 14:26:36 GMT 2005 DRVR 0 DBG1 main Statement.getResultSet
0000000148 Wed Sep 14 14:26:36 GMT 2005 DRVR 0 DBG1 main doDefaultTypes
[/CODE]
Also, I tried to supply FileOutputStream object to DriverManager.setLogStream method, but it produces no output at all. I will appreciate any help on this subject. Thank you in advance.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Take a look at P6Spy. It performs database logging, and is free to use.
[ September 14, 2005: Message edited by: Ulf Dittmer ]
 
Ranch Hand
Posts: 293
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You can tell Oracle to dump all the SQL that it executes out to log files. I can't quite remember how to do this, but your DBA should be able to help.
reply
    Bookmark Topic Watch Topic
  • New Topic