What exactly do you want to audit? If you mean DB size Audit, then SELECT audit_license_size(); Will trigger an immediate audit of the database size and select GET_COMPLIANCE_STATUS(); Will display w… (View Post)

Here is another example: WITH mytimes AS (SELECT now() - interval '1 day' AS qstart, now() AS qend)SELECT user_name, CASE WHEN qr.request ilike '%swap_partitions_between_tables%' … (View Post)

You cannot alter type of a column when it is referenced in the segmentation expression of that table projection. The following will work. CREATE TABLE my_test(f1 number(10), f2 int);CREATE TABLECREAT… (View Post)

The spill can happen on both environments, however the time it takes until it will finish the first plan of the query on a system with more memory might be longer. It is advised to add a SPILL hint t… (View Post)

If your new cluster nodes have more memory, in case where V pick very large fact on inner, and force spill did not happen, the first try can take much longer because there is more memory until it wil… (View Post)