I'm a newbie Oracle guy and I have a few questions...apologies if this is in the wrong forum
- 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. Also, how would I alter these things via SQL?
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).