How can we help you today?
90.1863 sql history contains many copies of SQL including errors
3 CommentsSorted by Oldest First
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: 90.1863 sql history contains many copies of SQL including errors
Re: 90.1863 sql history contains many copies of SQL including errors
Ronald,
The SQL History keeps bot successful and failed scripts.
If executing the same script multiple times after each other only a single entry is saved and a counter is increased showing how many times it has been executed.
If running SELECT A two times and then a single SELECT B and finally a single SELECT A there will be 3 history entries (last executed first):
SELECT A 1
SELECT B 1
SELECT A 2
Last Integer showing number of times executed.
The collection of identical executions can be controlled in Tool Properties->General->SQL History.
I hope this explains.
Regards
Roger
[This reply is migrated from our old forums. The original author name has been removed]
Re: 90.1863 sql history contains many copies of SQL including errors
Re: 90.1863 sql history contains many copies of SQL including errors
Thanks for the explanation Roger,
I now changed the setting to ignore error entries.
I already had 'collect duplicate into same'
When just running one SQL 10 times in a rows without anything in between I get 10 entries. (running 90.1863)
I do see some SQL's with a counter > 1 but at the moment I can not reproduce this. (getting a counter increment)
So: I still think there is a problem with that. I have my sessions running long times. Could that cause a problem?
Using the 11.2.0.3 jdbc driver
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: 90.1863 sql history contains many copies of SQL including errors
Re: 90.1863 sql history contains many copies of SQL including errors
Hi Ronald,
We'll fix this.
Thanks!
Regards
Roger
anonymous