Home » SQL & PL/SQL » SQL & PL/SQL » ANALYZE TABLE STATEMENT (19C, WINDOW)
ANALYZE TABLE STATEMENT [message #677963] Sat, 26 October 2019 01:43 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Multiple Out Parameters Function in Select Statement - Oracle
Next Topic: Update null value columns based upon previous non null columns
Goto Forum:
  


Current Time: Thu Mar 28 06:54:32 CDT 2024