Home » RDBMS Server » Server Administration » how to delete index stats
how to delete index stats [message #299365] Mon, 11 February 2008 13:21 Go to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
hi

I need to know how to delete the index stats.

I need to drop the index and delete the index stats too.

Please help.

Thanks
Anu
Re: how to delete index stats [message #299366 is a reply to message #299365] Mon, 11 February 2008 13:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you drop an index, its stats are also dropped.
You can also use DBMS_STATS.DELETE_INDEX_STATS procedure.

Regards
Michel

[Updated on: Mon, 11 February 2008 13:23]

Report message to a moderator

Re: how to delete index stats [message #299370 is a reply to message #299366] Mon, 11 February 2008 13:45 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

you can also try
analyze index <indexname> delete statistics;
Re: how to delete index stats [message #299371 is a reply to message #299370] Mon, 11 February 2008 13:47 Go to previous messageGo to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
whn i execute this pacakage DBMS_STATS.DELETE_INDEX_STATS ( XE1_TMP_RPT_GROUP)

I am receiving the following error.

Begin
DBMS_STATS.DELETE_INDEX_STATS ( XE1_TMP_RPT_GROUP)
Error at line 1
ORA-06550: line 2, column 51:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

:= . ( % ;


Please help
Re: how to delete index stats [message #299372 is a reply to message #299370] Mon, 11 February 2008 13:48 Go to previous messageGo to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
i have dropped the index. so it didnt work...

i want to drop the index and delete statistics too.
Re: how to delete index stats [message #299374 is a reply to message #299372] Mon, 11 February 2008 13:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If you drop an index, its stats are also dropped.

Regards
Michel
Re: how to delete index stats [message #299375 is a reply to message #299371] Mon, 11 February 2008 13:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
whn i execute this pacakage DBMS_STATS.DELETE_INDEX_STATS ( XE1_TMP_RPT_GROUP)

Copy and paste what you do, don't describe it.

Also read the documentation about the procedure, what is the meaning and type of the first parameter? Is there any other mandatory parameter?

Regards
Michel
Re: how to delete index stats [message #299376 is a reply to message #299374] Mon, 11 February 2008 13:57 Go to previous messageGo to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
but when i dropped the index i could see the stats info.
Re: how to delete index stats [message #299377 is a reply to message #299376] Mon, 11 February 2008 14:30 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How?

Regards
Michel
Previous Topic: ORA-27121: unable to determine size of shared memory segment
Next Topic: Fragmentation in database
Goto Forum:
  


Current Time: Wed Dec 07 14:37:05 CST 2016

Total time taken to generate the page: 0.21597 seconds