Click on the "Follow" button below and you'll get the latest news from Anjaniappsdba via email, mobile or you can read them on your personal news page on this site.
You can unsubscribe anytime you want easily.
You can also choose the topics or keywords that you're interested in, so you receive only what you want.
Anjaniappsdba title: ANJANI APPS DBA
Is this your feed? Claim it!
Hi All,
I am sharing in details step by step oracle 19c Golden Gate installation on VM ,
pre-requisites :: in my lab i have already install oracle 19C database software on both target and source side.
configuring the listeners on both the nodes
unlocked the all locked accounts on both the nodes.
Hi All,
In this post i will show how to Troubleshoot Long running SQL In Oracle 19C Database Step by step Lab, with explanation.
Most of the times we will receive complains from application team,saying that , as till yesterday query execution was right and all of suddenly they started observing lag in execution or and some cases n...
Dear All,
In this post i am sharing few useful SQL's and How to find the top 10 sql's and Find How much PGA usage in Oracle 19C DB.
1) To find corrupt Object/Segments using file_id and block_id
select segment_name,block_id,file_id from dba_extents where FILE_ID=&1 and &2 between block_...
Hi All,
In this post i am going share about Oracle Deep Data Security .
You will learn how to shift from fragmented, application-based controls to a centralized, declarative model that evaluates identity and context at runtime.
The brief offers practical guidance for enforcing least-privilege access, protecting AI-driven workflows such as re...
Dear All,
In this post i am sharing Oracle 19C DB How to export the dumpfile using LOGTIME parameter step by step lab .
This parameter LOGTIME give us the timestamp for each and every export operation during expdp., therefore its easy to check the diagnise/elapsed time taken for execution.
default LOGTIME=NONE, If you want to use this ...