All Questions
2 questions
0
votes
1
answer
1k
views
How to get the SQL_ID that is blocking another SQL?
Well, I'm personalizing a useful script that I found and I need put in this script what is the sql_id of the SQL that is blocking another SQL.
Here is my script, if you try this, You never will get ...
- 841
1
vote
1
answer
757
views
Improve performance for my plsql block
First of all let me make kind of a disclaimer here:
1) i'm a developer, not an administrator;
2) and i dont have admin rights on my database.
3) table specs :
-- oulp_path_attendance_base_t - 5....
- 111