Reg:Schedules....... [message #9835] |
Sun, 07 December 2003 22:43 |
SRSB Babu
Messages: 8 Registered: January 2003
|
Junior Member |
|
|
Hi All,
How to know what are the schedules details running in the database using SQL in SqlPlus.
Awaiting your valuble response.
Thanks in advance.
Regards,
Babu.
|
|
|
Re: Reg:Schedules....... [message #9836 is a reply to message #9835] |
Mon, 08 December 2003 00:59 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
If you are talking about schemas: these are somewhat similar to users, i.e. each user has a schema so via DBA_USERS you can list the users. If you want details, go to DBA_OBJECTS. Let's say you want to see what users actually have tables, and how many tables there are in their schemas:SQL> select owner
2 , count(*) cnt
3 From DBA_OBJECTS
4 Where object_type = 'TABLE'
5 Group By owner
6 Having count(*) > 0
7 /
OWNER CNT
------------------------------ ----------
USER1 110
SOME_USER 14
MYSELF 1
APP_USER 386
REFRAC 2
APP_USER2 3
OTTO 2
SYS 202
SYSTEM 15
9 rows selected.
SQL> ed
Wrote file afiedt.buf
1 select owner
2 , count(*) cnt
3 From DBA_TABLES
4 Group By owner
SQL> /
OWNER CNT
------------------------------ ----------
USER1 110
SOME_USER 14
MYSELF 1
APP_USER 386
REFRAC 2
APP_USER2 3
OTTO 2
SYS 202
SYSTEM 15
9 rows selected.
SQL> As you see, there are also the system views DBA_TABLES, DBA_VIEWS, ....all depends on what you are looking for.
Hth,
MHE
|
|
|
Re: Reg:Schedules....... [message #9837 is a reply to message #9836] |
Mon, 08 December 2003 01:12 |
SRSB Babu
Messages: 8 Registered: January 2003
|
Junior Member |
|
|
Thanks for prompt reply Maheer..
But i need the information something different.
In my system, some procedures are running in schedule. I want to know, what are the procedures running in the schedule, and what are timings to execute those and other details using SQL Query in SqlPlus.
I need the only Schedule information only.
Could you please provide that.
Awaiting the response.
Thanks in advance...
Regards,
Babu.
|
|
|
|
|