Thread: performance

-how to performance tuning in oracle 9i database
-with example
-what is degaster recovery
-what is wait event, what impotance of wait event

Your question is too much theoritical to answer. It is beyond the scope of this discussion to explain al that here.
Please find the details here.

Your question is already replied . Please do not post the same question repeatedly.

which performance tuning do u need?
There are different types of tuning mechanisms.
They are Database tuning,Memory tuning,Application tuning.

what is the diff between oracle9i & 10g

Originally Posted by simsim

what is the diff between oracle9i & 10g

Please find oracle 10g new features here.

Originally Posted by koushlesh.kushwah

-how to performance tuning in oracle 9i database
-with example
-what is degaster recovery
-what is wait event, what impotance of wait event

Hello,

For percormance tunning u have to see the explain plan of the query in sql.

There are different parts through we can modifies the queries performance like

which way the query is written like what it has been used in that if it using subquery then for big recordset we cant use subquery it heat the database.

sorting is a expensive process etc.

we can measure it through explain plan.

in pl/sql there is also diff. tunning we can do in that.