When you do a SHOW STATS VALUES you can see the history records.
If this is the table's UPI you might not need to collect stats at all, the optimizer already knows that the combination is unique, check Explains if for actual confidence level.
So,Can i assume for a big table like 600GB this much spool and timming to run collect stats is ok
yes there's default percent
here's the artcile on it by carrie which should be helpful.
is there need for stats to be collected daily on these large tables, could it be weekly.? does the data change every day by that much.. the earlier recommendation was if the data changes 10% then we need to collect stats..
also is the table partitioned ?.