This is mainly Oracle DBA blog which also cover performance tuning,oracle cloud dbaas,oracle rac dataguard,active dataguard,RMAN and other topics like Linux,AWS,Cassandra and other databases.Please subscribe below to get update on my blog.
A.Enabling SPM manually to stabilize plan for a particular query For this test case I will create a table with skewed data so that for one bind value it will go for one execution plan and for other bind value,it will go for another execution plan.Ideally this should be good… Continue Reading SPM oracle 12c test case
debasis maity
Logical IO vs Physical IO vs Consistent gets I have created 1 GB table T1. Let me check how many blocks are there in the table after I have analyzed it. SQL> select BLOCKS from user_tables where table_name=’T1′; BLOCKS ———- 139153 Autotrace report Let me clean buffer… Continue Reading Logical IO vs Physical IO vs Consistent gets oracle
debasis maity
Sarat 1) What are pre-checks you do before doing point in time recovery? 2) There is no previous level zero backup available, Can we take a Level 1 backup? 3) My database have 500+ datafiles, In that I lost 89 files. How you will identify which files to recover? 4)… Continue Reading Backup and recovery Interview questions
debasis maity
Heman Sahi 1. Your RMAN backup triggered, you deleted snapshot controlfile at backend, what will happen to your running backup ? 2. what happens internally when we issue ‘ RESYNC CATELOG’ for recovery catelog ? 3. You enabled Block change tracking and then immediately performed level 1 backup, will BCT… Continue Reading RMAN interview questions
debasis maity
I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: – The optimizer cost model relies on statistics collected about the objects involved in a query, and the database and host where the query runs. Statistics are critical to the optimizer’s ability to pick the… Continue Reading Oracle 12c gather statistics oracle deep dive
debasis maity
Thanks Akhil Mohan. Debasis Maity: 1.Why controlfile and redolog file multiplexed? Control file : A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the… Continue Reading Redo,Undo,Control file interview questions
debasis maity
debasis maity
Author:-https://www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level
debasis maity
OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to be done in Client Server Create directory where agent will be installed in Client Server In Client,You need to create a directory or mount point as /u01/oemcc Install telnet in… Continue Reading Oracle 13c cloud control agent installation
debasis maity
Answer Credit:- https://www.linkedin.com/in/skantali/ https://www.linkedin.com/in/hemant-shahi-59921762/ How we can execute PLSQL without any privilege to change it What are the default user created when Oracle is installed ? Can you create password less user in Oracle ? If yes how ? How we can see the procedure /package body with out having… Continue Reading Oracle user role and privilege interview questions
debasis maity