Home » RDBMS Server » Server Administration » DBMS (10g)
DBMS [message #339194] Thu, 07 August 2008 01:13 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear all

I want to know more about DBMS packages...

FOr eg ...we can use

EXECUTE DBMS_MVIEW.EXPLAIN_MVIEW ('MV_NAME');

to get a detail explaination of MVIEW in a particular schema

same is for REWRITE in MVIEW

EXECUTE DBMS_MVIEW.EXPLAIN_REWRITE ('MV_NAME');

like wise ....

are there any packages for SQL Tunning and for Indexes...

kindly let me know in detail.......

thank you in advance

CHeers
Re: DBMS [message #339205 is a reply to message #339194] Thu, 07 August 2008 01:29 Go to previous message
saagar
Messages: 79
Registered: December 2007
Member
hey
i search it

here is the link

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/toc.htm

CHeers
Previous Topic: Datafiles without .dbf extension
Next Topic: size
Goto Forum:
  


Current Time: Wed Dec 07 14:39:55 CST 2016

Total time taken to generate the page: 0.10293 seconds