Protected: Linux Shell Script To Monitor GoldenGate Lag
There is no excerpt because this is a protected post.
Read more2022
Relocating enabl database for oracle 19c
Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as…
Read moreOratop Utility
Oratop is a text based user interface tool similar to top command for monitoring basic…
Read moreStandby : Unnamed file issue
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…
Read moreProtected: CRS-41053: Checking Oracle Grid Infrastructure for file permission issues CRS-4000
There is no excerpt because this is a protected post.
Read moreProtected: Improve Performance of Data Pump Import In Oracle 19c
There is no excerpt because this is a protected post.
Read moreProtected: CRS-2974: unable to act on resource !!
There is no excerpt because this is a protected post.
Read moreProtected: Create Trigger to Detect Client/App related error.
There is no excerpt because this is a protected post.
Read moreProtected: 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 more