OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » oracle reports (10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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,

Report message to a moderator

Re: oracle reports [message #398008 is a reply to message #398006]

Tue, 14 April 2009 17:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What could be the most effective way to do so?
Data Guard

Report message to a moderator

Re: oracle reports [message #398010 is a reply to message #398006]

Tue, 14 April 2009 17:06

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: oracle reports [message #398260 is a reply to message #398010]

Wed, 15 April 2009 15:32

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

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!

Report message to a moderator

Re: oracle reports [message #398277 is a reply to message #398006]

Wed, 15 April 2009 22:06

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

Report message to a moderator

Re: oracle reports [message #398278 is a reply to message #398275]

Wed, 15 April 2009 22:07

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: oracle reports [message #398279 is a reply to message #398006]

Wed, 15 April 2009 22:14

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

Report message to a moderator

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,

Report message to a moderator

Re: oracle reports [message #398540 is a reply to message #398538]

Thu, 16 April 2009 10:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Good idea for what?

Report message to a moderator

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,

Report message to a moderator

Re: oracle reports [message #398561 is a reply to message #398560]

Thu, 16 April 2009 13:36

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:35:52 CDT 2024