OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » faq

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

faq [message #238335]

Thu, 17 May 2007 07:46

kishore_dba
Messages: 21
Registered: March 2007
Location: HYDERABAD

Junior Member

hi all,
what is the use of catdbsyn.sql and dbmspool.sql.
Regards,
Kishore.

Report message to a moderator

Re: faq [message #238341 is a reply to message #238335]

Thu, 17 May 2007 08:18

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=mJ0&q=catdbsyn.sql+dbmspool .sql&btnG=Search

Report message to a moderator

Re: faq [message #238641 is a reply to message #238341]

Fri, 18 May 2007 15:59

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Hi

DBMSPOOl.sql
This package provides access to the shared pool. This is the
shared memory area where cursors and PL/SQL objects are stored.

CATDBSYN.sql
Creates private synonyms for DBA-only dictionary views.

Report message to a moderator

Re: faq [message #238645 is a reply to message #238641]

Fri, 18 May 2007 16:08

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post the source you quote (I already asked you in another thread).
Don't try to appropriate them.

Regards
Michel

Report message to a moderator

Re: faq [message #238650 is a reply to message #238645]

Fri, 18 May 2007 16:22

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Go to

$ORACLE_HOME/rdbms/admin/

more dbmspool.sql
more catdbsyn.sql

Laughing

Report message to a moderator

Re: faq [message #238677 is a reply to message #238650]

Fri, 18 May 2007 23:47

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, this is the correct answer. /forum/fa/1581/0/

Don't feed just show the way to find the answer. /forum/fa/1601/0/

Regards
Michel

Report message to a moderator

Previous Topic:	-2049ORA-02049: timeout: distributed transaction waiting for lock
Next Topic:	Undo space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 25 05:52:15 CST 2025