OraFAQ Forum: Performance Tuning » Oracle Schema slowing performance

Home » RDBMS Server » Performance Tuning » Oracle Schema slowing performance

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

Oracle Schema slowing performance [message #118367]

Wed, 04 May 2005 13:41

ravin
Messages: 3
Registered: May 2005
Location: uk

Junior Member

Hi,
I want to know, whether defining a Schema and using it slows down the performance of Select SQL?

Report message to a moderator

Re: Oracle Schema slowing performance [message #118375 is a reply to message #118367]

Wed, 04 May 2005 15:17

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Can you elaborate a bit more on your question? What do you mean?

Report message to a moderator

Re: Oracle Schema slowing performance [message #118420 is a reply to message #118367]

Thu, 05 May 2005 02:07

ravin
Messages: 3
Registered: May 2005
Location: uk

Junior Member

using the schema is slowing down the performance.....

Report message to a moderator

Re: Oracle Schema slowing performance [message #118434 is a reply to message #118367]

Thu, 05 May 2005 04:05

Frank
Messages: 7901
Registered: March 2000

Senior Member

Do you mean to ask whether there is a difference in performance between these two statements ?

select ename
from   emp
where  empno = :1

or

select ename
from   scott.emp
where  empno = :1

If that is your question, then the answer is no. There is no performance loss in using schema prefixes.

hth

Report message to a moderator

Re: Oracle Schema slowing performance [message #118439 is a reply to message #118434]

Thu, 05 May 2005 04:40

ravin
Messages: 3
Registered: May 2005
Location: uk

Junior Member

hi,
I have requested our DBA team to create a Synonym , so that we do not have to prefix schema name. DBA team has come back to me, saying creating Synonym would slow down the perfromance.
I am not able to digest this comment from our DBA eam. hence I wanted to check whether there is performance issue with schema name or not?
ravi

Report message to a moderator

Re: Oracle Schema slowing performance [message #118462 is a reply to message #118367]

Thu, 05 May 2005 07:31

tycoonajayverma
Messages: 17
Registered: May 2005
Location: b'lore

Junior Member

hi

this not making any sence ya u check out again what the people saying and reply back.

Thanks.

Report message to a moderator

Re: Oracle Schema slowing performance [message #118463 is a reply to message #118367]

Thu, 05 May 2005 07:32

tycoonajayverma
Messages: 17
Registered: May 2005
Location: b'lore

Junior Member

hi all,

If this is the case those people saying this same one what u thing..?????????

Thanks

Report message to a moderator

Re: Oracle Schema slowing performance [message #118867 is a reply to message #118367]

Mon, 09 May 2005 08:06

Satheesh Babu.S
Messages: 35
Registered: July 2004

Member

Yes there is a overhead when using synonyms. If you can use with schema_name.object_name, then please use it. This approach is better than private synonym and very much better than public synonym.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

Report message to a moderator

Re: Oracle Schema slowing performance [message #118872 is a reply to message #118439]

Mon, 09 May 2005 08:35

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

Senior Member
Account Moderator

http://www.ixora.com.au/newsletter/2001_05.htm

Report message to a moderator

Re: Oracle Schema slowing performance [message #118916 is a reply to message #118367]

Mon, 09 May 2005 12:23

Frank
Messages: 7901
Registered: March 2000

Senior Member

Ah, but this is the other way around then your initial question. I understood that question as does using explicit schema-names slow down performance...

Sorry for the misleading answer then.

Report message to a moderator

Previous Topic:	Query takes long time -need help to improve Performance
Next Topic:	Cursor Performance Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 29 20:16:08 CDT 2025