I'm pretty new to Oracle but I want to process a large amount of data in stored procedure. I'm already using connection pooling and the application is multi-threaded so I'm wondering if I should use temporary tables. Should I go that route? If so, would there be a way to create the tables in a way that different table instances are created for every call to the stored procedure (just so the multiple SPs are not mixed up)? Thank you.