|
Daniel Stein
@
Daniel_Wandern
|
|
Oracle & Wandern. Beides Hobbies. Zum Glück finanziert das eine das andere 🙏 Oracle-Tuner @Debeka
|
|
|
280
Tweetovi
|
88
Pratim
|
56
Osobe koje vas prate
|
| Tweetovi |
| Daniel Stein proslijedio/la je tweet | ||
|
Eatsbluecrayon
@eatsbluecrayon
|
31. sij |
|
Okay, das ist lustig.
#Picard pic.twitter.com/AFXEKtfwAy
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
30. sij |
|
Okay thanks for the information.
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
30. sij |
|
Great progress - but i don’t belive that our network was that fast (<0,0000001 ms for 2000 packets... )
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
30. sij |
|
This is by no means an reproach. I admire your work (including the Block tool) and I think STADO is another brilliant idea. I will continue to test it and have one or two feature ideas once it is running smoothly - there were 1000 not 109 execs in the pcap file 😜
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
30. sij |
|
@ora600pl the promised testcase with pcap : github.com/tbo007/stado/b…
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
29. sij |
|
I will also update my testcase and send it to you including the pcap
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
29. sij |
|
WOW that was quick. I‘ve retested my app with STADO. Now i get an output. But i don‘t trust it: eg. I know that most cursors are executed more than once (prepared Stmt rexecuted without an close) and more than one packet is def. needed to execute each cursor...😢 pic.twitter.com/ww75h7GJmI
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
29. sij |
|
@ora600pl I wrote a testapp witch fetches dummy data. STADO worked with ojdbc7_g 12.1 tcpdump but fails with ojdbc8 19.3. The pcap file: github.com/tbo007/stado/b…
Hope it helps.
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
28. sij |
|
I‘ll give it a spin with the jdbc.jar i‘m using and if it fails I‘ll send the tcpdump to @ora600pl
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
28. sij |
|
I start tcpdump before my app connects to the database. My jdbc is ojdbc8 19.3.
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
28. sij |
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
27. sij |
|
It is a tcpdump from work. I‘ll redo it with dummy data an send it to you.
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
27. sij |
|
Great idea - thanks Kamil - don‘t work for me 😢Result table is always empty. Debug info shows that packets to and from the DB are processed and sql ids are found... What am I doing wrong?
|
||
|
|
||
| Daniel Stein proslijedio/la je tweet | ||
|
Kamil Stawiarski
@ora600pl
|
22. sij |
|
And here it is! STADO (SQL TCPDump Analyzer Designed for Oracle). #SMARTDB
blog.ora-600.pl/2020/01/22/whe… twitter.com/ora600pl/statu… pic.twitter.com/GpxRmF5XwF
|
||
|
|
||
| Daniel Stein proslijedio/la je tweet | ||
|
Richard Feynman
@ProfFeynman
|
14. pro |
|
1. See failure as a beginning.
2. Never stop learning.
3. Assume nothing, question everything.
4. Teach others what you know.
5. Analyze objectively.
6. Practice humility.
7. Respect constructive criticism.
8. Take initiative.
9. Give credit where it's due.
10. Love what you do.
|
||
|
|
||
| Daniel Stein proslijedio/la je tweet | ||
|
Franck Pachot
@FranckPachot
|
6. pro |
|
A new blog post with a strange title for something that ends like a small Friday Philosophy.
medium.com/@FranckPachot/…
|
||
|
|
||
| Daniel Stein proslijedio/la je tweet | ||
|
Steven Feuerstein
@sfonplsql
|
2. pro |
|
Got this question on Facebook today:
Q: Hi Sir, From many of the people I heard that RDBMS will be replaced by Hadoop and Nosql in future market and oracle sql will be not avail in future. So,may I know it will be true or what???
A: NOT TRUE
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
28. stu |
|
So am I right that LTC took 3826 sec?
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
28. stu |
|
You‘re right. I‘ll post the problem on Oracle Dev Forum and post the link here. The observed runtime of the query was 8323 sec. The Db runs on AiX. This is why cpu and waits don‘t sum up to elapsed time.
|
||
|
|
||
|
Daniel Stein
@Daniel_Wandern
|
28. stu |
|
I think most is the insert (please have a look at my cur. post abd correct me if i‘m wrong). I thought that BUFG in snapper only works in oracle < 11? And we are on 19. 10200 / 10201 only records cons gets as far as i know. What about curr gets? Thanks
|
||
|
|
||