Home » RDBMS Server » Performance Tuning » How SELECT affects remote database from which data is selected
How SELECT affects remote database from which data is selected [message #366296] Fri, 12 December 2008 12:42 Go to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
Hi,
A am having a discussion.
My opponent thinks that
statements like SELECT*FROM schema_name.table_name@remote_database_link
affects performance on remote database.
I disagree, but I could not find supporting materials.
Please help, it is important!
Re: How SELECT affects remote database from which data is selected [message #366300 is a reply to message #366296] Fri, 12 December 2008 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please help, it is important!

Why? It is just a discussion.

Of course, doing something is more expensive than doing nothing.

Regards
Michel
Re: How SELECT affects remote database from which data is selected [message #366320 is a reply to message #366300] Fri, 12 December 2008 15:49 Go to previous messageGo to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
It is not just a discussion. It is a business decission issue.
Re: How SELECT affects remote database from which data is selected [message #366322 is a reply to message #366320] Fri, 12 December 2008 16:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>affects performance on remote database.
How much exactly? In what measure?
Restating Michel's words in another form ,
nothing is free.
In certain cases, even just a select statement may create redo (not directly. undo creates redo). Search this forum. There are numerous examples for this/delayed block cleanout.
Succinctly put (and shamelessly plagiarizing Michel),
doing something is expensive than doing nothing.

[Updated on: Fri, 12 December 2008 16:36]

Report message to a moderator

Re: How SELECT affects remote database from which data is selected [message #366325 is a reply to message #366322] Fri, 12 December 2008 16:56 Go to previous messageGo to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
Mahesh,

I select data from database/schema X from database/schema Y. To my understanding, no redo/undo or any other do can be generated on database Y.

Re: How SELECT affects remote database from which data is selected [message #366328 is a reply to message #366325] Fri, 12 December 2008 17:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>no redo/undo or any other do can be generated on database Y.

Did you care to search the forum?
When you issue a select(no matter from where), Oracle will generate a read consistent image of data from undo records and present it to you. This undo will generate redo.
Re: How SELECT affects remote database from which data is selected [message #366329 is a reply to message #366325] Fri, 12 December 2008 17:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/163593/42800/?srch=delayed+block+cleanout#msg_163593
Re: How SELECT affects remote database from which data is selected [message #366365 is a reply to message #366325] Sat, 13 December 2008 01:31 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you just want a short answer, yes it will affect performances on remote database.

Regards
Michel
Previous Topic: data pull from a table
Next Topic: Redo Log Tuning
Goto Forum:
  


Current Time: Sat Dec 03 01:12:32 CST 2016

Total time taken to generate the page: 0.06972 seconds