| Facing performance issues in simple insert statement from Oracle 10g [message #643711] |
Fri, 16 October 2015 00:21  |
 |
toitdoctor
Messages: 6
Registered: September 2015
Location: USA
|
Junior Member |
|
|
Hi All,
Oracle Version : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
We are facing performance issues in oracle insert statement. I have analyzed all the things for the table and insert statement.
The details of the scenario is given below
1.The gather stats job is running weekly on the table.
2.We load data in table on daily basis.The load type is truncate and then insert. The total no of rows for insert about 6 million.
3. We have checked the indexes/constraints on the table.
4. The output of ALL_TAB_STATISTICS is :
TABLE_NAME NUM_ROWS STALE_STATS
XYZ 6,756,996 YES
5. The output of ALL_TAB_MODIFICATION is :
TABLE_NAME INSERTS UPDATES DELETES TRUNCATED
XYZ 27,075,776 0 0 YES
now my questions are :
1. Should we need to gather the stats on the table daily basis?
2. We do truncate and then insert daily still we require to gather the stats on the table?
3. Change the gather stats job from weekly to daily can improve the performance ?
may i know any suggestions and thoughts for this kind of problem...
Thanks in advacne...
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
