| job scheduling [message #321447] |
Tue, 20 May 2008 05:21  |
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
|
Senior Member |
|
|
i want to write a a procedure that returns me all the processes and jobs that are being run on my database at present and also their time stamp like start date end date/time , current status.
please any oone tell me how can i achieve this.
on forms or at database level.
[Updated on: Tue, 20 May 2008 05:21] Report message to a moderator |
|
|
|
| Re: job scheduling [message #321460 is a reply to message #321447] |
Tue, 20 May 2008 05:53  |
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
|
Member |
|
|
| Quote: | on forms or at database level
|
on forms means what?
You will get all active/inactive sessions from v$session.
If application is running, then if it is not accessing Database, it will show session as Inactive till the database is accessed once again and so on.
Regards,
MSMallya
[Updated on: Tue, 20 May 2008 05:59] Report message to a moderator |
|
|
|
|
|
| Re: job scheduling [message #321467 is a reply to message #321463] |
Tue, 20 May 2008 06:17 |
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
|
Senior Member |
|
|
i want to create an interface from which i can view all the processes that are run by my clients and also the processes which started and ended during the day ,
and the timestamps of all the processes ( start time and end time) .
thanx again in advance,
|
|
|
|
|
|
|
|
|
|
| Re: job scheduling [message #322405 is a reply to message #322397] |
Fri, 23 May 2008 06:44 |
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
|
Senior Member |
|
|
Sir ,
I feel Sorry to Tell you ,
I did not understand what u mean by
Oracle version (4 decimals)?
Regards
Michel
I know its my Lack of Knowledge , but i hope u explain it.
Thanks.
|
|
|
|
|
|
|
|
| Re: job scheduling [message #322414 is a reply to message #322411] |
Fri, 23 May 2008 07:46 |
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
|
Senior Member |
|
|
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
