2 min read
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time...
2 min read
2 min read
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to...
2 min read
This content is password protected. To view it please enter your password below: Password:
2 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:
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...
