These commands are permanent. All deleted data will be lost. Ensure that you complete a full data backup before proceeding with these commands. |
It is strongly recommended that you use the stored procedure that accomplishes the same outcome as the statements below with less effort. It is available by contacting Support at [email protected].
The following commands will delete all performance data prior to a specified date:
select min(id) from performance_sample where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE'; |
delete from performance_aggregate where sample_id < ID; commit; delete from performance_cpu where sample_id < ID; commit; delete from performance_disk where sample_id < ID; commit; delete from performance_disk_total where sample_id < ID; commit; delete from performance_esx3_workload where sample_id < ID; commit; delete from performance_fscap where sample_id < ID; commit; delete from performance_lpar_workload where sample_id < ID; commit; delete from performance_network where sample_id < ID; commit; delete from performance_nrm where sample_id < ID; commit; delete from performance_psinfo where sample_id < ID; commit; delete from performance_vxvol where sample_id < ID; commit; delete from performance_who where sample_id < ID; commit; |
select min(id) from performance_sample where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE'; |
delete from vmware_perf_aggregate where sample_id < ID; commit; delete from vmware_perf_cluster where sample_id < ID; commit; delete from vmware_perf_datastore_usage where sample_id < ID; commit; delete from vmware_perf_datastore_vm_usage where sample_id < ID; commit; delete from vmware_perf_disk_rate where sample_id < ID; commit; delete from vmware_perf_entitlement where sample_id < ID; commit; delete from vmware_perf_host_cpu where sample_id < ID; commit; delete from vmware_perf_host_disk_io where sample_id < ID; commit; delete from vmware_perf_host_disk_io_adv where sample_id < ID; commit; delete from vmware_perf_host_network where sample_id < ID; commit; delete from vmware_perf_host_power_state where sample_id < ID; commit; delete from vmware_perf_mem where sample_id < ID; commit; delete from vmware_perf_mem_advanced where sample_id < ID; commit; delete from vmware_perf_network_rate where sample_id < ID; commit; delete from vmware_perf_vm_cpu where sample_id < ID; commit; delete from vmware_perf_vm_disk_io where sample_id < ID; commit; delete from vmware_perf_vm_network where sample_id < ID; commit; delete from vmware_perf_vm_power_state where sample_id < ID; commit; delete from vmware_perf_vm_storage_usage where sample_id < ID; commit; delete from vmware_perf_vm_vcpu where sample_id < ID; commit; delete from vmware_perf_watts where sample_id < ID; commit; |