cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

Database partitioning : .sql script execution time

am00478975
Inactive

Hi Team,

Could you please let me know how long the oracle DB partition script takes to run , incase we have data and moving from large to X-Large .

Also plet me know what the below statement in the script does:

dbms_stats.gather_table_stats(sys_context('USERENV', 'CURRENT_SCHEMA'), 'percentiles_high', 'poverflow', cascade => TRUE);

end;


/

Regards,

Anusha

4 REPLIES 4

Babar_Qayyum
DynaMight Leader
DynaMight Leader

Hello Anshan,

Check the below link for maximum understanding of moving from Large to xLarge environment.

https://answers.dynatrace.com/questions/166696/vie...

Regards,

Babar

peter_karlhuber
Dynatrace Pro
Dynatrace Pro

HI Anusha,

our experience is that explicitly gathering stats with the daily partitioning job increases charting speed, that's why we put the gather_table_stats call in there.

The partitioning script itself runs very quickly, the migrating of existing data can be done in parallel to the already connected dynatrace server to minimize the time we're offline.

Best regards,

Peter

rodrigo_biaggio
Participant

Hi, when I execute the script with "select dynatrace_partitioning_daily_job", I have an error:
"No function matches the given name and argument types. You might need to add explicit type casts".
I have a postgre.
Can anyone help?

Hi Rodrigo,

please verify that he script was executed with the correct user and has created these functions:

high_retention_time
buffer_time
f_dbdate2javalong
create_partition
drop_partition
init_partitions
slide_window
dynatrace_partitioning_daily_job
migrate_data

You should also have two tables called

measurement_high_old_data
percentiles_high_old_data

Thanks, best regards,

Peter