The SGA size is 10 GB and the output of SQL query is 50 GB. Could you please let me know whether this SQL query will succeed or fail.
The query will succeed!
Oracle Database will load the table into the buffer cache. If the cache is full, it will load the data into the PGA instead, overwriting the entire cache for "big" tables.
This is a read on the direct path. If the database needs to handle data from the huge table before returning to the client (for example, for a join), the information will be written to temp (disk).
For more Interview Questions and Answers visit link mention below: