Home » SQL & PL/SQL » SQL & PL/SQL » dbms_stats for specific tables of different schemas (9.2.0.6)
icon5.gif  dbms_stats for specific tables of different schemas [message #277382] Mon, 29 October 2007 19:07 Go to next message
arlin_ilu
Messages: 1
Registered: October 2007
Junior Member
Friends,

Can any one of you help me with the syntax on how to use dbms_stats for specific tables of different schemas. I want to create a job with dbms_job for this purpose.

dbms_stats.gather_table_stats for

schema1 ( tableX, tableY)
schema2 ( tableA, tableB)

Thanks in advance,
Arlin
Re: dbms_stats for specific tables of different schemas [message #277399 is a reply to message #277382] Mon, 29 October 2007 23:14 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#sthref7887
Re: dbms_stats for specific tables of different schemas [message #277458 is a reply to message #277382] Tue, 30 October 2007 04:00 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
All you need to do is to have several calls to DBMS_STATS.GATHER_TABLE_STATS in one pl/sql block, and execute that block using DBMS_JOB
Previous Topic: caseexpression
Next Topic: query
Goto Forum:
  


Current Time: Sun Dec 11 02:08:41 CST 2016

Total time taken to generate the page: 0.23322 seconds