Overview: The ORA-01652 error concerns a failure in allocating the extent for the temp segment in the tablespace. The temp segment refers to a temporary tablespace used internally by the Oracle database for the function of certain operations, such as joins. The primary solution to an ORA-01652 error revolves around increasing the size of the … Read more
Create user Drop user Alter user Backup user Failed logins See failed logins (keep in mind this resets every time a successful login occurs) How to get the last password changed time for a oracle user CTIME Indicates – Creation TimePTIME Indicates – Password Change TimeThis is the query the metric is executing. An incident … Read more
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