Protected: Create Trigger to Detect Client/App related error.
There is no excerpt because this is a protected post.
Read moreOracle
Protected: Result cache in Oracle 11g
There is no excerpt because this is a protected post.
Read moreBlocking sessions in Oracle
Blocking sessions are a problem for the DBA which occur when a session issues an…
Read moreOracle AWR (Automatic Workload Repository)
Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on…
Read moresec_case_sensitive_logon Parameter in oracle
The SEC_CASE_SENSITIVE_LOGON parameter is deprecated. It is retained for backward compatibility only. SEC_CASE_SENSITIVE_LOGON enables or…
Read moreLinux Operating System 2.
File Permissions The “umask” command can be used to read or set default file permissions…
Read moreLinux Operating System 1.
File and Directory The “pwd” command displays the current directory: The "ls" command lists all…
Read moreAutomatic Diagnostic Repository (ADR)
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in…
Read moreDetails of PGA, SGA, db_cache, shared_pool and db/sp%, subpools
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)…
Read moreProtected: Purge Archivelog Script
There is no excerpt because this is a protected post.
Read moreORA-1652: unable to extend temp segment by 128 in tablespace
Overview: The ORA-01652 error concerns a failure in allocating the extent for the temp segment…
Read moreUsers
Create user Drop user Alter user Backup user Failed logins See failed logins (keep in…
Read moreORA-32001: write to spfile requested but no SPFILE specified at startup !!!!
ORA-32001: How to identify if the database was started with spfile or pfile? There are…
Read moreROWID Pseudocolumn
For each row in the database, the ROWID pseudocolumn returns the address of the row.…
Read moreSQL New Features in Oracle Database 19c
SQL Macros You can create SQL macros (SQM) to factor out common SQL expressions and…
Read more19c New Features
In this article, we’ll discuss 5 new features and functionality of Oracle Database 19c that…
Read moreIndex and Stats Gather Scripts
Check for index owned by sys when table owned by SCOTT –View problem indexes, verify…
Read moreUser Session Scripts
LOCK A USER: UNLOCK A USER: CHECK STATUS OF USERS: CHECK AND GET SID &…
Read moreDaily Archive Generation Script
Daily Archivelog Generation and size: ARCHIVELOG GENERATION ON DAILY BASIS COUNT
Read moreGolden Gate Error while loading shared libraries.
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such…
Read moreORA-15032: not all alterations performed in Oracle ASM !!
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM.…
Read moreProtected: Important parameters for 19c DB Upgrade
There is no excerpt because this is a protected post.
Read more18c New Features
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance…
Read moreDatabase in restricted mode.
Restrict Mode in which Oracle database allow making connection with special rights such as DBA,…
Read more