Home Discussions Questions & Answers Offloading Reporting Load to a Standby Database

Offloading Reporting Load to a Standby Database

Avatar photoCustomer September 21, 2024 at 6:31 pm

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

Viewing 4 reply threads
  • Author
    Replies
    • Support September 22, 2024 at 9:34 pm  

      You use the profile option ‘Blitz Report Target Database’. This allows specifying a standby database for report execution.

    • Avatar photoCustomer September 24, 2024 at 2:56 am  

      What is the format required for the target database value?

    • Support September 25, 2024 at 12:48 am  

      You must specify a TNS descriptor defined in `$TNS_ADMIN/tnsnames.ora` on the application server.

    • Avatar photoCustomer September 26, 2024 at 11:00 am  

      What are the prerequisites in the database for running reports on a standby database?

    • Support September 27, 2024 at 11:16 am  

      Prerequisites include using Oracle database 19c or higher, Active Data Guard licensing, and configuring DML Redirection.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: