OraFAQ Forum: SQL & PL/SQL » Reg:Schedules.......

Home » SQL & PL/SQL » SQL & PL/SQL » Reg:Schedules.......

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Re: Reg:Schedules....... [message #9839 is a reply to message #9837]

Mon, 08 December 2003 01:26

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Ok, I think you are talking about jobs here.

In the system views DBA_JOBS and DBA_JOBS_RUNNING you find all the details about the jobs that are scheduled and running.

The column DBA_JOBS.WHAT contains the procedure_name
The columns LAST_DATE and NEXT_DATE,...I guess you can figure that one out yourself. I recommend you take a peek at http://tahiti.oracle.com (here's a deep link). Subscription is required but it's (spam)free.

MHE

Report message to a moderator

Re: Reg:Schedules....... [message #9844 is a reply to message #9839]

Mon, 08 December 2003 03:46

SRSB Babu
Messages: 8
Registered: January 2003

Junior Member

Thanks Maaher..

Exactly this one i required...

Regards,

Babu.

Report message to a moderator

Previous Topic:	Date difference in months
Next Topic:	COLUMN_POSITION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 23:50:06 CDT 2024