PL/SQL and storage...

[RageMatrix]

Hi all,

I'm a newbie Oracle guy and I have a few questions...

- I'm trying to write some benchmarking software in PL/SQL and want to calculate the time a query takes in milliseconds. Is there some sort of timer function in PL/SQL that would do this? Something like =Millisecs() or suchlike? I need two millisecond calculations and work out the time by subtracting one from the other.

- In which tables are the following things stored and how can I get info on the details of each? Roles, Privileges, PL/SQL created Types, Procedures and Triggers. How would I alter these things?

Thank you for any info on the above....sorry its such a lot of questions, but I'm very new at this....I'm really just a VB programmer, not a database guy (yet).

Cheers,

Jon.

 

[carp]

RM -
I think the closest you can get on the timing is hundredths of a second. You will get this via the dbms_utility.get_time function.

As far as where do you find information on various objects, the answer is "it depends".
For instance, what do you want to know about a role? What its name is, what privileges it has, who has been granted the role? With a little more information (and no - "everything" is NOT a very good answer here) we will be better able to assist you.

Elbert, CO
0941 MDT