Hi Arun, these sessions are very helpful for preparing the interviews. If possible please provide one session regarding Oracle Exadata.
@vidmayur4 жыл бұрын
About the question on finding the username ,instead of trigger do you suggest using the auditing option to capture the username which would be much easier than writing the Trigger ,find action using dba audit trail table .i could be wrong
@dbagenesis4 жыл бұрын
Are you aware of what is the impact of enabling auditing?
@OlivierSimpleLife4 жыл бұрын
@@dbagenesis Are you aware of the impact on performance of such trigger that would perform an addition insert for each and every single insert in this table ? And yes, auditing is the right way to go, it also has overhead, but there's no need to re-invent the wheel ;)
@amitjha94533 жыл бұрын
Gen1 & Gen2 which exadata we have to choose what is the difference
@himanshugarg48464 жыл бұрын
please explain the below error and how to resolve it. ora-01652-unable-to-extend-temp-segment-by-128-in-tablespace-system-how-to-ext
@dbagenesis4 жыл бұрын
Check this article: support.dbagenesis.com/knowledge-base/temp-tablespace-utilization/
@devilsgaming59154 жыл бұрын
Hi sir, When Temp tablespace got full what are the steps we need to take to release the temp space?when we need shrink the temp tablespace can you explain ? Whether inactive sessions will have any impact on temp tablespace ? Kindly explain sir.
@dbagenesis4 жыл бұрын
Check this support article: support.dbagenesis.com/knowledge-base/temp-tablespace-utilization/
@user-qb7cc3cw7l Жыл бұрын
Create one extra temp tablespace ..make it default temp and drop old one...
@riyaxavier23834 жыл бұрын
For loading data into another database from oracle database.....Oracle GoldenGate can be used right...did you just forget to mention it or is it wrong?
@dbagenesis4 жыл бұрын
I missed it, good point.. Thanks buddy!
@ragavp46234 жыл бұрын
Hi Arun What is the difference between Physical DBA task Vs logical DBA task
@dbagenesis4 жыл бұрын
It used to exists in olden days. Today, your question should be "Who is a cloud dba?"
@girija1kp4 жыл бұрын
Why 3 scan ips , you have answered very well in previous videos . Thanks .
@ravi9aug4 жыл бұрын
Golden gate can be used to move database from one to another irrespective of any database.
@SandeepYadav-lt7pr4 жыл бұрын
Sir, Can u plzz create one video for sqlnet.ora file uses?
Sir one video on oracle database design I will be grateful to you sir
@SANDATA7644 жыл бұрын
Thanks to you arun
@himanshugarg48464 жыл бұрын
What is linux keepalived and how it helps the crs in rac?
@dbagenesis4 жыл бұрын
Research
@Kotavinod293 жыл бұрын
I have P51 with 64 GB ram
@mohammadislam31342 жыл бұрын
👍
@ragavp46234 жыл бұрын
Video for ITIL process
@dbagenesis4 жыл бұрын
Maybe sometime in future
@devbah094 жыл бұрын
The only reason of 3 scan ips is in the scenario for future expand-ability. If I later add a third node, the third SCAN VIP is ready for the third node. Or at some point, I will replace the hardware for these two nodes. I typically add the two new servers as the third and fourth nodes of the cluster for a short period of time before I remove the old servers. For that short period of time, its nice to have that third SCAN listener. But not mandatory.
@dbagenesis4 жыл бұрын
What if we have 20 nodes? Will you configure 20 SCAN IPs?