Home » RDBMS Server » Server Administration » oracle reports (10.2.0.2)
oracle reports [message #398006] Tue, 14 April 2009 16:00 Go to next message
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 #398008 is a reply to message #398006] Tue, 14 April 2009 17:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What could be the most effective way to do so?
Data Guard
Re: oracle reports [message #398010 is a reply to message #398006] Tue, 14 April 2009 17:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>the most effective way to do so?
It would also help if you can define "effective" in your terms.
Easiest? Cost? Performance?
Re: oracle reports [message #398260 is a reply to message #398010] Wed, 15 April 2009 15:32 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks Mahesh and Blackswan for the reply
I am asking in terms of cost and easiest.
Regards,
Varun Punj,

[Updated on: Wed, 15 April 2009 15:32]

Report message to a moderator

Re: oracle reports [message #398275 is a reply to message #398008] Wed, 15 April 2009 21:13 Go to previous messageGo to next message
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 #398277 is a reply to message #398006] Wed, 15 April 2009 22:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I do not think so, the Data_Guard can not be replaced with Reporting application.
With Data Guard you have the Primary (Production) instance and you have either a Physical Standby and/or Logical Standby.

The Physical Standby can be opened in READ ONLY mode & then reports could be generated from its data.
However during this reporting interval no redo logs are being applied.

The Logical Standby can by applying redo while reports are being generated from its data.

Answers to such questions can be found at http://tahiti.oracle.com
Re: oracle reports [message #398278 is a reply to message #398275] Wed, 15 April 2009 22:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> the Data_Guard can not be replaced with Reporting application.
Nobody said so.
Dataguard just provides a standby environment which could be used
for reporting purposes.
Infact, It is one of the best method and probably where money spent for good.
You not only have a standby database, you can also use it for reporting and free up some resources in production.
Re: oracle reports [message #398279 is a reply to message #398006] Wed, 15 April 2009 22:14 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, all of you, Mash & BS.
I've just forgot Logical-Standby Embarassed , I often setup Physical Standby..rather than Logical Standby! Embarassed
Re: oracle reports [message #398538 is a reply to message #398279] Thu, 16 April 2009 10:35 Go to previous messageGo to next message
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 #398540 is a reply to message #398538] Thu, 16 April 2009 10:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Good idea for what?
Re: oracle reports [message #398560 is a reply to message #398540] Thu, 16 April 2009 13:09 Go to previous messageGo to next message
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 Go to previous message
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.

Previous Topic: Enabling Option Partitioning
Next Topic: Oracle 8i
Goto Forum:
  


Current Time: Sat Nov 09 17:43:55 CST 2024