Hello, I was checking out the records in the QUERY_EVENTS table. Does anyone know if I should be worried about these records? In particular the SMALL_MERGE_REPLACED, MERGE_CONVERTED_TO_UNION and WOS_SPILL records :?: dbadmin=> select distinct event_category, event_type, count(*) from query_events gr...

Howdy, On page 205 of the sql reference guide there is a little blurb about how to convert an epoch back into a timestamp: Here is how you can convert an epoch value back to a timestamp: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second'; However, that conversion doesn't seem ...

Thanks, Jim! Awesome time tests!

Hi, The default size of a sequence cache is 250,000. That seems awful high to me considering if I only insert a few rows per session I'll lose a lot of the sequence values and they'll be huge gaps in my primary key. Does anyone have a recommendation on a cache size? I've tried no cache, but the perf...

Hmm. Ok, thanks, sKwa. I suppose that makes sense.

Hello,

Is there a way to tell how much disk space I am using if increase the HistoryRetentionTime parameter to a 24 hour period using the command SELECT SET_CONFIG_PARAMETER ('HistoryRetentionTime', '86400'); ?

Also, does this storage count against my license allowance?

Thanks, Jim. I kind of figured as much. Thanks for a nice work around