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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 19:44:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.