Home » SQL & PL/SQL » SQL & PL/SQL » Pl/Sql code
Pl/Sql code [message #275596] Mon, 22 October 2007 00:15 Go to next message
vkrmhj
Messages: 9
Registered: May 2007
Junior Member
Can anyone pls. help me with a pl/sql code?
I want to run several sql queries parallely and store the result into a table through DBMS_job function.
Now i need to check whether all the queries has completed running(user_jobs table).
when all the queries has completed, i want to union all the query data.
The tool(data junction) i am using can call a function(select package_name.function_name from dual.)So i need to do all the above mentioned through a function?
Re: Pl/Sql code [message #275606 is a reply to message #275596] Mon, 22 October 2007 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what did you already try?

Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Re: Pl/Sql code [message #275609 is a reply to message #275606] Mon, 22 October 2007 01:20 Go to previous messageGo to next message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

i hav perform these steps

1.conn /as sysdba
2.create tablespace perfstat
3@$O_H/rdbms/admin/spcreate.sql
4.conn user perfstat/perfstat
5.exec statspack.snap
6.@$O_H/rdbms/admin/spreport.sql

Regards
Mujtaba
Re: Pl/Sql code [message #275625 is a reply to message #275609] Mon, 22 October 2007 02:01 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You post it in the wrong topic. I moved your question to a new topic called "Statspack report".
Don't hijack a topic create your own if the question has no relation with the initial one.
Now repost this in the correct topic.

Regards
Michel

[Updated on: Mon, 22 October 2007 02:02]

Report message to a moderator

Previous Topic: oops
Next Topic: proble in sql?
Goto Forum:
  


Current Time: Wed Dec 07 18:29:28 CST 2016

Total time taken to generate the page: 0.11836 seconds