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??

Hi, is it possible to audit (unified auditing) access to tables only once per session? I don't need to catch all selects from audited tables in a session, I just want to to know if a table was at querried at least once. Currently it generates huge amount of audit data, from which...