ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. ADRCI enables you to: View diagnostic data within the Automatic Diagnostic Repository…

with PGA_GB as (SELECT VALUE/(1024*1024*1024) PGA_GBFROM V$PARAMETER WHERE NAME = 'pga_aggregate_target'),subpools as (SELECT COALESCE(SUM(VALUE/(1)), NULL) subpoolsFROM V$PARAMETER WHERE NAME = '_kghdsidx_count'),SGA_GB as (select (trunc(sum(value)/1024/1024/1024,2)) SGA_GBfrom v$sga),SHARED_POOL_GB as (SELECT VALUE/(1024*1024*1024) SHARED_POOL_GBFROM…

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…

Create user CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE_NAME> TEMPORARY TABLESPACE ; Drop user drop user <USERNAME> cascade; Alter user alter user <USERNAME> identified by (account un\lock); Backup…

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…

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.…

Check for index owned by sys when table owned by SCOTT select count (*) from dba_indexes where TABLE_NAME in (select object_name from dba_objects where OBJECT_TYPE in ('TABLE') and owner =…