Offloading Reporting Load to a Standby Database

We want to offload reporting load from our primary database by running Blitz Reports on our standby database. How is this target database specified?

5 replies

Support Enginatics September 22, 2024
You use the profile option ‘Blitz Report Target Database’. This allows specifying a standby database for report execution.
Customer September 24, 2024
What is the format required for the target database value?
Support Enginatics September 25, 2024
You must specify a TNS descriptor defined in `$TNS_ADMIN/tnsnames.ora` on the application server.
Customer September 26, 2024
What are the prerequisites in the database for running reports on a standby database?
Support Enginatics September 27, 2024
Prerequisites include using Oracle database 19c or higher, Active Data Guard licensing, and configuring DML Redirection.