The best practice is to schedule via cron the use of DROP_PARTITIONS function to drop old partitions as you do. There might be a gap between the time you drop partitions for this to be reflected in D… (View Post)

Q - Is there a way when one node is down to get the other nodes function optimally? A - Yes, open a support case and investigate the root cause for your performance issue. There are several things su… (View Post)

Q - Will their be data loss if the buddy node also goes down? A - Committed data will not lost. While node 18 is down, if also the buddy node will go down the database is considered unsafe and automa… (View Post)

I've tried something similar to Marco idea for user Mike and it works: \a\t\o | vsqlSELECT distinct 'REVOKE ALL ON ALL TABLES IN SCHEMA ' || object_schema || ' FROM ' || gran… (View Post)

with num_rows as ( select sc.schema_name, p.anchor_table_name as table_name, sum(sc.total_row_count - sc.deleted_row_count) as rows from v_monitor.storage_containers sc join v_catalog.projections p o… (View Post)