2 min read
This content is password protected. To view it please enter your password below: Password:
asrblogger
2 min read
1 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
This content is password protected. To view it please enter your password below: Password:
4 min read
Blocking sessions are a problem for the DBA which occur when a session issues an insert, update or delete command...
4 min read
AWR-ADDM-REPORTDownload Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on a database for multiple...
1 min read
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:...
2 min read
Cron is named after Greek word “Chronos” that is used for time. It is a system process that will automatically...
3 min read
File Permissions The "umask" command can be used to read or set default file permissions for the current user. The...
6 min read
File and Directory The "pwd" command displays the current directory: # pwd /u01/app/oracle/product/19.0.0/dbhome_1 The "ls" command lists all files and directories in the specified...
2 min read
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. ADRCI enables...
1 min read
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 =...
This content is password protected. To view it please enter your password below: Password:
4 min read
Overview: The ORA-01652 error concerns a failure in allocating the extent for the temp segment in the tablespace. The temp...
1 min read
Create user CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE_NAME> TEMPORARY TABLESPACE ; Drop user drop user <USERNAME> cascade;...
2 min read
ORA-32001: How to identify if the database was started with spfile or pfile? There are couple of ways of finding...
2 min read
For each row in the database, the ROWID pseudocolumn returns the address of the row. Every table in an Oracle...
3 min read
SQL Macros You can create SQL macros (SQM) to factor out common SQL expressions and statements into reusable, parameterized constructs...
3 min read
In this article, we’ll discuss 5 new features and functionality of Oracle Database 19c that will have you not just...
3 min read
Check for index owned by sys when table owned by SCOTT select count (*) from dba_indexes where TABLE_NAME in (select...
3 min read
LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS:...
1 min read
Daily Archivelog Generation and size: with daily_summary as ( select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKSBLOCK_SIZE)/1048576) MB,count() Archives_Generated from v$archived_log where dest_id=1...
1 min read
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export...
2 min read
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some...
This content is password protected. To view it please enter your password below: Password:
