AWR-ADDM-REPORTDownload Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on a database for multiple purposes including detection and elimination of performance issues. AWR reports…

The SEC_CASE_SENSITIVE_LOGON parameter is deprecated. It is retained for backward compatibility only.  SEC_CASE_SENSITIVE_LOGON enables or disables password case sensitivity in the database. true: Database logon passwords are case sensitive. false: Database logon passwords…

Cron is named after Greek word “Chronos” that is used for time. It is a system process that will automatically perform tasks as per the specific schedule. Cron is a…

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…