Creative GD Topics
1. The Wheel is Turning Round and Round2. If I was the Finance Minister/Prime Minister
3. There is no right way to do a wrong thing
4. Group Task: How can we have Mount Everest in India?
5. Do Beauty and Brains Go Together?
6. When I woke up in the morning I saw…
7. A ship docked in harbor cannot face the storms
8. Up the Down Staircase
9. Just as we have smoke free zones, we should have child free zones
10. Marriage is a social trap
2 comments:
Hi There,
A really interesting, clear and easily readable
Freshers World - Freshers Jobs article of interesting and different perspectives.I will clap. So much is so well covered here.
I have a job which picks a record from a cursor and then it calls a stored procedure which processes the record picked up from the cursor.
The stored procedure has multiple queries to process the record. In all, procedure takes about 0.3 seconds to process a single record picked up by the cursor but since cursor contains more than 1 Lac records it takes hours to complete the job.
The queries in the stored procedure are all optimized
I was thinking of making the procedure run in multi threaded way as in java and other programming language.
Can it be done in oracle? or is there any other way I can reduce the run time of my job.
Follow my new blog if you interested in just tag along me in any social media platforms!
Merci,
Preethi
Greetings Mate,
This is indeed great! But I think perhaps you are generally referring
Freshers World - Freshers Jobs
which is getting unsustainable.
I need some help from you experts on this stored procedure..
There are 4-5 batch procedures that will call this stored procedure. The batch will call the stored procedure with 'I' parameter in the beginning of the batch process. The batch will call the stored procedure with 'O' parameter at the end of the batch process. The stored procedure should write the details into the auditing table.
But great job man, do keep posted with the new updates.
Shukran,
Radhey
Post a Comment