| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> External Table Log Statistics
Hi Guys,
Will you please tell me what the below
Date Cache Statistics Mean (of External Table) ..??
I was able to load the data from External Table to the table into which I want to load data. No Problem.
I want to find out the no. of rows loaded into the table from external table. The below statistics ENTRIES + HITS gives the No of rows loaded. But I dont understand why this information in 2 different columns.?
If Someone knows the answer, please elp me.
Thanks in advance
Shiv
LOG FILE
LOG file opened at 07/31/02 11:08:49
Field Definitions for table MWLP_EXT
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Rows with all null fields are accepted
Fields in Data Source:
PRODUCT_ID CHAR (255)
Terminated by ","
Trim whitespace same as SQL Loader
WAFEREVENT_ID CHAR (255)
Terminated by ","
Trim whitespace same as SQL Loader
VARIABLE_ID CHAR (255)
Terminated by ","
Trim whitespace same as SQL Loader
EVENTEND CHAR (19)
Date datatype DATE, date mask rrrr-mm-dd HH24:MI:SS
Terminated by ","
Trim whitespace same as SQL Loader
X CHAR (255)
Terminated by ","
Trim whitespace same as SQL Loader
Y CHAR (255)
Terminated by ","
Trim whitespace same as SQL Loader
VAL CHAR (255)
Terminated by ","
Trim whitespace same as SQL Loader
Date Cache Statistics for table MWLP_EXT
Max Size: 1000
Entries : 2
Hits : 59997
Misses : 0
Received on Sun Aug 04 2002 - 02:22:46 CDT
![]() |
![]() |