OraFAQ Forum: SQL & PL/SQL » ANALYZE TABLE STATEMENT

Home » SQL & PL/SQL » SQL & PL/SQL » ANALYZE TABLE STATEMENT (19C, WINDOW)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ANALYZE TABLE STATEMENT [message #677963]

Sat, 26 October 2019 01:43

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

HI EXPERTS.
i want to analyze table and want to know the number of Block in a table using Analyze table statement,
i use this query in sql plus:

ANALYZE TABLE Lineitem COMPUTE STATISTICS FOR TABLE;
Table analyzed.

as it display message that table analyzed but it did not display any thing, how can i display the number of block using analyze table statements,

thanks and regards.

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677965 is a reply to message #677963]

Sat, 26 October 2019 01:51

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

You should never use ANALYZE TABLE...COMPUTE STATISTICS, not since (if I remember correctly) release 8i. It will destroy the histograms generated by dbms_stats.

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677967 is a reply to message #677963]

Sat, 26 October 2019 02:00

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why no feedback and thank in your previous topics?

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677968 is a reply to message #677967]

Sat, 26 October 2019 02:05

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

THANKS FOR MESSAGE, PLEASE GUIDE ME THAT HOW CAN I COMPUTER THE STATISTICS FOR CALCULATING THE NUMBER OF BLOCK?

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677969 is a reply to message #677968]

Sat, 26 October 2019 02:53

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why shouting?

[Updated on: Sat, 26 October 2019 02:57]

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677971 is a reply to message #677969]

Sat, 26 October 2019 03:01

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

apologize and after this will care for this..

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677972 is a reply to message #677971]

Sat, 26 October 2019 03:24

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

I've already told you: in the twenty first century, you gather statistics with DBMS_STATS.

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677973 is a reply to message #677972]

Sat, 26 October 2019 03:26

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

thanks sir, i try this

EXEC dbms_stats.gather_table_stats('TPCHR', 'LINEITEM1998');

it execute procedure successfully but nor result display ..

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677975 is a reply to message #677973]

Sat, 26 October 2019 03:30

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

You have to show some initiative, you know. Have you looked at the procedures in dbms_stats? How about GET_TABLE_STATS ?

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677976 is a reply to message #677975]

Sat, 26 October 2019 03:34

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

i studied about this procedure it display that to know the number of block GET_TABLE_STATS will help to calculate statistics.

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677979 is a reply to message #677976]

Sat, 26 October 2019 09:04

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Those procedures are for calculating statics and storing them in the proper system tables. Nothing says anything about those procedures displaying the stats they calculate. (If they did, it would be a very large, very dense report). The stats are stored in system tables that are revealed by views such as DBA_TABLES, DBA_EXTENTS, DBA_SEGMENTS, etc.

I leave it as an exercise for the student to research those views in the Oracle Database Reference for his or her release of Oracle. The 12c version of that document is here.

Report message to a moderator

Re: ANALYZE TABLE STATEMENT [message #677981 is a reply to message #677979]

Sat, 26 October 2019 11:34

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

thanks every body.i will study the concept, if any question then will ask.

Report message to a moderator

Previous Topic:	Multiple Out Parameters Function in Select Statement - Oracle
Next Topic:	Update null value columns based upon previous non null columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 26 01:09:51 CDT 2025