hi, can anybody tell me how to do a oracle cache for a particular no. of rows from a table. or any paper/pdf where i can find a step by step procedure to do so. thanks in advance. ruppa
Well if you run the query itself, then the records will be put into the Data Cache. For all records the ALTER TABLE tablename CACHE will put the table into cache Mark