Thank you for taking my question. We're getting ready for 23ai and see that there is a new RESET_STATE option we can use if we're using PL/SQL behind a web server connected to Oracle using a connection pool and serving up stateless services. (https://docs.oracle.com/en/database/o...

Hi Tom, sorry for asking this dumb question. This is about how blocks are placed in the buffer cache, Say a 50 GB table is accessed using Full table scan with buffer cache size 20 GB, Does Oracle bring all the blocks of the 50 GB to the buffer cache and produce the required resul...

Tom, I have a doubt about adding columns with default values to a table. Recently, I have stumble upon an Arup Nanda article on it where he states the following "When a user selects the column for an existing record, Oracle gets the fact about the default value from the data dict...

In my CI workflow I must often remove a complete schema with a very large number of objects in it. Simply using "drop user <user> cascade" works but takes a long time of up to 5 minutes. Starting by first removing constraints and tables before using "drop user <user> cascade" imp...

There is an requirement to get the DDL for Oracle fusion custom tables is it possible to achieve??