Topic: Oracle monitoring
|
|
Szikra
User
Fresh Boarder
| Posts: 7 |   |
Karma: 0
|
|
Oracle monitoring
|
|
Posted: 2007/10/26 03:46 |
|
|
|
|
May I ask you to write in few steps how to implement an sql monitoring in anydac?
(Delphi 7 ent. / Indy 10 / Oracle 10g)
|
|
Diman
Admin
Admin
| Posts: 1470 | |
Karma: 18
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/26 04:06 |
|
|
|
|
1) If you upgraded / installed Indy scince the AnyDAC installation, then goto AnyDACbuild folder and run there updateEnv.bat. Then rebuild AnyDAC packages. And build ToolMonitorADMonitor.
2) Add MonitorBy=Indy to your connection definition.
3) Run ADMonitor.
4) Connect to DB, run query, you should see output in ADMonitor.
Regards,
Dmitry
|
|
Szikra
User
Fresh Boarder
| Posts: 7 | |
Karma: 0
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/26 05:17 |
|
|
|
|
|
Thanks, I did it, but it is still not working. I can see my application has started in the admonitor, but the sql trace is not visible. How can I get that Info?
|
|
Diman
Admin
Admin
| Posts: 1470 | |
Karma: 18
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/26 06:00 |
|
|
|
|
Hello
Check, that:
1) ADMonitor Pause/Resume button is not pressed.
2) ADMonitor Options-> Trace Options -> Categories. All items are marked.
Regards,
Dmitry
|
|
Szikra
User
Fresh Boarder
| Posts: 7 | |
Karma: 0
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/26 06:17 |
|
|
|
|
Hello,
I checked, both of them ok. I don't know if I expect the right thing from anydac monitoring.
If I add (width notify()) a new row with manually, than it appears in the monitor, but I would like to see the sql commands, and parameters automatically.
What can I do wrong?
Andras
|
|
Diman
Admin
Admin
| Posts: 1470 | |
Karma: 18
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/27 00:23 |
|
|
|
|
Hello
1) Your expectations from ADMonitor are right.
2) Check that your AnyDACDBADConnectionDefs.ini has following parameter:
[AnyDACSettings]
.......
MonitorCategories=$FFFF
.......
|
Regards,
Dmitry
|
|
Szikra
User
Fresh Boarder
| Posts: 7 | |
Karma: 0
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/27 02:30 |
|
|
|
|
Sorry, but I have no such file.
Andras
|
|
Szikra
User
Fresh Boarder
| Posts: 7 | |
Karma: 0
|
|
Re:Oracle monitoring
|
|
Posted: 2007/10/27 03:58 |
|
|
|
|
Hello!
I have found the error!
Sorry, it was my fault.
I forgot that I reassemble the database.params after the program start, but before db connect. I set the monitor option in the wizard, but I forgot put that line while reassembling.
Thank you for your kind help,
and sorry again.
Andras
|
|
|
