Gather statistics for a huge oracle table - worry of collapsing the server

Question

I'm trying to improve the execution time of a view of an Oracle database, which takes ages to load, and it involves a table which has 15,352,595 records. I'm considering to gather statistics on it coz I suspect the poor performance is due to stale stats.

However, I'm worried that this will burden the server a lot and I'm not very confident that its harddisks (or whatever hardware components) can withstand heavy workloads without breaking.

Is that a real thing that should be worried?

Answer 1

You can gather statistics with low value of estimate percentage.