Hi Biswa I am also facing the same issue, can please tell me what solution you find out. My situation is, I am selecting data from different tables and collecting in a ref cursor, which sort into tables types variables, which means fetches using BULK COLLECT INTO statement, here my performance is very bad. It is taking nearly 3 mins to dump. refcursor performace is bad then simple select statement. Neetha