oracle reports [message #398006] |
Tue, 14 April 2009 16:00 |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
Currently there are many reports running using some tables in
our database.Is there any way I can separate out the reporting
from my current production database server.What could be
the most effective way to do so?
Regards,
Varun Punj,
|
|
|
|
|
|
Re: oracle reports [message #398275 is a reply to message #398008] |
Wed, 15 April 2009 21:13 |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
BlackSwan wrote on Wed, 15 April 2009 05:00 | >What could be the most effective way to do so?
Data Guard
|
No, I do not think so, the Data_Guard can not be replaced with Reporting application. Data_Guard is only Data_Guard, do not force it to be multiplexed systems. Stream or event DWH are the database system of reporting.
Am I wrong? May you clarify or correct me, dear Black_Swan(!?)
Thank you!
|
|
|
|
|
|
Re: oracle reports [message #398538 is a reply to message #398279] |
Thu, 16 April 2009 10:35 |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Thanks all,
I have one more basic question:-
I already have streaming enabled in the database.
Is It good idea to setup dataguard alongwith streams
on primary database Instance.
Regards,
Varun Punj,
|
|
|
|
Re: oracle reports [message #398560 is a reply to message #398540] |
Thu, 16 April 2009 13:09 |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Mahesh,
Sorry for confusing.
If both dataguard and streaming are set up are on the database,
Can It impact the performance of database because streaming
uses lot of cpu for the capture process.
Regards,
Varun Punj,
|
|
|
Re: oracle reports [message #398561 is a reply to message #398560] |
Thu, 16 April 2009 13:36 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
DataGuard and Streams offer their services at different level and act independently.
So there might be some overhead with computing and administrative resources. I just do not have an exact number for you.
If you are just looking into separation of reporting services, streams does that for you ( and you already have it enabled).
DataGuard is meant for standby purposes but will perfectly support reporting functionality also.
So there is an overlap here and it is upto you to decide.
Physical Standby and Streams use redolog apply and Logical standby will use SQL apply.
Streams is more meant for heterogeneous platforms (11g DG supports to some extent), ETL/Warehousing purpose.
If you want to use both together, there are much bigger fish to fry.
For instance, start worrying about role transitions.
|
|
|