Thanx buddies,
U both have given me good ideas. Can u explain the utilities or options to measure the performance except explain plan (if there is any). I wanted to know maximumm methods to play with tunning of Queries .....
I really appreciate your help.
Thanx.
Hi all,
I'm running an application on Oracle 8i Server. Memory is well tunned, but at some areas of the application, it seems to be very slow. I'm doubtful about some procedures, but to make it sure, whats the best way to measure the performance of some procedures (in a application) and what...
Hi, First, what version of Oracle u r using, if its 8i, then u can do it very easily by writing a java class and upload it in Oracle database (Using LOADJAVA utility). I've done the same thing in one of my project. If u get any other way, please post it also. Take care.
Hi all,
I was attempting one of the trial OCP tests. I found following question in it, please read it.
QUESTION
The ITEM table contains these columns:
COST NUMBER(7,2)
RETAIL NUMBER(7,2)
The RETAIL and COST columns must have a value that is greater than zero...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.