How to use dbms_utility packages

Hi.. I am trying to use get_time package and any other dbms_utility packages to try out, but resulting in errors..

I am logged in as system or other users that has dba privilege.

exec dbms_utility.get_time
OR
exec get_time

results in error, saying function or package is not declared..

Thx, ST2000

FUNCTION GET_TIME RETURNS NUMBER

SQL> select dbms_utility.get_time from dual;

GET_TIME
----------
4527754

Thanks for your reply pando.. By the way, how would I decode the time.. Is it the time in seconds from 1971 or something..

Secondly, if i want to analyze entire schema, how would I do it? Should I be writing a select statement like using the get_time?

Thanks, ST2000

~

Quote:

---

Originally posted by st2000
Thanks for your reply pando.. By the way, how would I decode the time.. Is it the time in seconds from 1971 or something..

Secondly, if i want to analyze entire schema, how would I do it? Should I be writing a select statement like using the get_time?

Thanks, ST2000

~

---

well I dont know and I dont really care, if I want get time I use sysdate

analyze schema, dbms_stats