What is the meaning of Spoil Table information in Data Dictionary . Will this affect performance?
Iam getting this while executing as one of the query in the explain plan --steps SPLTBL
"We spoil the parser's dictionary cache for the table" removes all chached metadata about this table, e.g. after a ALTER TABLE or a CREATE INDEX, or after DELETE/UPDATE/INSERT of a larger number of rows.
This will also remove any cached execution plans.
Iam getting SPLTBL(Spoil Table information in Data Dictionary) as one of the step(last step before End transaction) when Iam trying to insert into a table . This means it is trying to flush the metadata before ending the transaction?
This insert runs every 15 minutes since this is NRT( NEar real time) and we also delete the data from the table before inserting.
Once insert is completed we collect stats.
So this is the process
delete from table
insert into table
the above process repeats every 15 min