ORA-32001: How to identify if the database was started with spfile or pfile? There are couple of ways of finding if the database was started with spfile or pfile. First we can check the value of parameter spfile, if it returns blank then database was started by pfile. Similar to using SHOW PARAMETER, you can … Read more
For each row in the database, the ROWID pseudocolumn returns the address of the row. Every table in an Oracle database has a pseudocolumn named ROWID. Oracle Database rowid values contain information necessary to locate a row: • The data object number of the object • The data block in the data file in which … Read more
SQL Macros You can create SQL macros (SQM) to factor out common SQL expressions and statements into reusable, parameterized constructs that can be used in other SQL statements. Starting with Oracle Database release 19c, version 19.7, SQL table macros are supported. SQL table macros are expressions, typically used in a FROM clause, to act as … Read more
In this article, we’ll discuss 5 new features and functionality of Oracle Database 19c that will have you not just ready, but excited for your next Oracle database upgrade. 1. Automatic indexing One of 19c’s biggest selling points is the ability to perform automatic indexing. Database indexes are used to improve the speed of querying … Read more