Home » RDBMS Server » Server Administration » faq
faq [message #238335] Thu, 17 May 2007 07:46 Go to next message
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.
Re: faq [message #238341 is a reply to message #238335] Thu, 17 May 2007 08:18 Go to previous messageGo to next message
joy_division
Messages: 4643
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
Re: faq [message #238641 is a reply to message #238341] Fri, 18 May 2007 15:59 Go to previous messageGo to next message
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.
Re: faq [message #238645 is a reply to message #238641] Fri, 18 May 2007 16:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the source you quote (I already asked you in another thread).
Don't try to appropriate them.

Regards
Michel
Re: faq [message #238650 is a reply to message #238645] Fri, 18 May 2007 16:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Go to

$ORACLE_HOME/rdbms/admin/

more dbmspool.sql
more catdbsyn.sql



Laughing
Re: faq [message #238677 is a reply to message #238650] Fri, 18 May 2007 23:47 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is the correct answer. ./fa/1581/0/
Don't feed just show the way to find the answer. ./fa/1601/0/

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


Current Time: Thu Dec 08 22:31:55 CST 2016

Total time taken to generate the page: 0.30738 seconds