19 lines
483 B
Plaintext
Executable File
19 lines
483 B
Plaintext
Executable File
SET LINE 180
|
|
SET PAGES 50
|
|
|
|
COL OWNER FOR A20
|
|
COL OBJECT_NAME FOR A20
|
|
|
|
define OWNER=AINSREQ1
|
|
define OBJECT_NAME=INS_MKT_SUMMARY_J
|
|
|
|
SELECT
|
|
OBJ.OWNER,OBJ.OBJECT_NAME,ANALYZETIME,HS.ROWCNT,HS.BLKCNT,HS.SAMPLESIZE
|
|
FROM
|
|
DBA_OBJECTS OBJ, WRI$_OPTSTAT_TAB_HISTORY HS
|
|
WHERE
|
|
OBJ.OWNER='&OWNER' AND OBJ.OBJECT_NAME='&OBJECT_NAME' AND OBJ.OBJECT_ID=HS.OBJ#
|
|
ORDER BY
|
|
ANALYZETIME ASC;
|
|
|
|
select num_rows from dba_tables where owner='&OWNER' AND table_name='&OBJECT_NAME'; |