I am having an oracle database with 1.5TB size. In that a partical two tables alone is very big in size. Almost 75% of total DB size.
Now my problem is with running statistics. The statistics is not getting completed both at weekday and also at weekend windows. Also I am facing performance issue while the stats gathering is on.
Please can someone suggest your expertise idea on this issue, how the stats job can be taken forward from here?
Version : 220.127.116.11 , Oracle Database, Suse OS