(Hemant K Chitale) In the previous two posts, I have demonstrated direct path read and db file scattered read being used for Full Table Scans. Since 11g, Oracle uses an internal formula to determine the manner of reading the table segment for a Full Table Scan.

(John Brady) If you don’t already know, then you should almost always be using bind variables in all SQL statements used in any applications you write that run against Oracle. Bind variables are place holders within your SQL statements that get replaced by real data values at run time when the SQL s

(connormcdonald) Yes, I know what you’re thinking.

(Natik Ameen) Oracle has launched the latest version of SQL Developer. Let’s check out some of the top preferences that you should tune into to enhance your experience with it.

(Andrew Reid) If you grant the DBA role to a user, Oracle also grants it the UNLIMITED TABLESPACE system privilege. If you then revoke the DBA role from this user, Oracle also revokes its UNLIMITED TABLESPACE system privilege. This isn’t too much of an issue.

(Benjamin Rosenzweig and Elena Rakhimov) This chapter is a collection of some fundamental elements of using SQL statements in PL/SQL blocks. In the previous chapter, you initialized variables with the “:=” syntax; in this chapter, we will introduce the method of using a SQL select statement to updat

(Hemant K Chitale) (I will be returning to the Tracing series …. but a quick diversion because I had received a request for assistance on auditing DBMS_STATS usage)

(John Hallas) I wanted to add an append hint to some code but realised that there are known restrictions when either triggers or referential integrity are involved.

(Martin Berger) In Oracle database the vie DBA_FEATURE_USAGE_STATISTICS is given to

(connormcdonald) If you are a regular user of LOB’s in the database, take care when you switch from 11g to 12c. Notice the subtle difference: