I am new in Oracle performance tuning. can anyone tell me what the mean of "Oracle statistics gathering" in simple words/way. i has read it from Oracle site http://docs.oracle.com/cd/A87860_01/doc/server.817/a76992/stats.htm.
But i am not understand it properly. It Any role in oracle performance tuning? Does it make good performance of Oracle DB???
You're reading ancient documentation. Forget version 8, just forget aboutit.
Read and search the current documentation (11gR2):
You can check this in some Easy way :ORACLE-BASE - Oracle Cost-Based Optimizer (CBO) And Statistics (DBMS_STATS)
>> It Any role in oracle performance tuning? Does it make good performance of Oracle DB??? :Yes
I have a couple of spastics as well in my team, they can type really fast, but the database isn't performing....
You'll need to carefully read and understand the documentation.
This isn't something one can explain to you in 2 sentences, it is pretty complicated stuff.
Actually, I think the most recent release (12.1c) has it documented better, especially the Oracle® Database SQL Tuning Guide
12c Release 1 (12.1) which you can find here: Contents