Oracle

ORA-1652: unable to extend temp segment by 128 in tablespace

by

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

Users

by

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

ROWID Pseudocolumn

by

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 New Features in Oracle Database 19c

by

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

19c New Features

by

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

Index and Stats Gather Scripts

by

Check for index owned by sys when table owned by SCOTT –View problem indexes, verify table_owner is SCOTT (if INDEX_OWNER and TABLE_OWNER are sys, then you have 2 tables with 2 owners, but same table name, see steps below) INDEX_OWNER INDEX_NAME TABLE_NAME TABLE_OWNER –get the columns for the index and its tablespace INDEX_NAME COLUMN_NAME TABLESPACE_NAME … Read more

User Session Scripts

by

LOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID & SERIAL# ID OF SPECIFIC INACTIVE AND ACTIVE SESSION CHECK AND KILL ALL SYS USER RUNNING WITH LIBRARY CACHE MUTEX WAIT EVENTS TO ESTABLISH NEW CONNECTION ERROR: MAX PROCESS EXCEED CHECK COUNT OF SPECIFIC USER USER ACTIVE FOR MORE THAT 45 … Read more