As per my suggestion for bigger(in TB) size database migration data guard is good option & also datagurd is free with enterprise edition bundle license. we can save downtime in migration using dataguard. Please clear if i am wrong.
Hi Arun,In Oracle 12c database in my prod database FRA is not releasing Flashback Logs(after retention window over) ,what would be the issue? Nothing major in alerting ,it's causing issue in alarming alerts via OEM
Can you tell me how cursors work actually in shared sql area...I am confused why and when the same sql Id will be having its child cursors and version counts?? Sometimes when I try to migrate the base line from one environmnt to another it is confusing me which plan do i actually need to migrate because I see two r three plans for the same sql id but with its child cursors having different sql plans.
High version count and child cursors for the same query could point to an application design issue. You may have designed application to use literals instead of bind variables. In your scenario there’s a bit of work to be done at application design level first.
Hi arun, In our dataguard setup, one of database having 1 archivelog gap all the time, will added standby redolog also and started recovery in real time apply but still 1 log gap is there. what the reason behind this..?
Depends, looks like it needs to be investigated. You will have to look into both primary and standby alert logs to identify whats going on. Also check, sometimes when you enable MRP, you can delay the log apply. See if you have something like that when you enable MRP.
Difference between integrated capture and classic capture in golden gate? In integrated capture do we need to create the logminer database in source database or Oracle uses logminer mechanism ?
Classic capture (resides outside DB) directly reads from the redo/archive logs, Integrated Capture is registered within the Oracle db and GG reads using internal Stream/Logminer APIs to read the logs and writes the changes as LCRs.
Hi Renny, we try not to allow viewers to promote other website courses. If you do so, we will be banning you from commenting on any of our videos. Request you to maintain our channel guidelines! Though we will never stop you to share your knowledge and expertise with fellow DBAs. All the best!
You can utilise DBMS_SQLTUNE package for tuning your query or can get the help of OEM. I'd still suggest to go through manual steps ;) 3 tasks had to be done, DBMS_SQLTUNE_*create_tuning_task( DBMS_SQLTUNE_*execute_tuning_task( DBMS_SQLTUNE_*report_tuning_task(
There are many criteria's on which index is not being used (I presume u mean to say index present for the column but still not been used). Gathering statistics on the table or baselining a plan for the query if index was already being used might help. You could try using index within hint to see if the index is being utilised as well, For ex, select /*+ INDEX (TABLE Index_name) */ * from table where column=condition;
Many reasons, so when optimizer is going for full table scan, that means there could be couple of reasons for IGNORING THE INDEX: 1. Index needs to be rebuild 2. Full table scan is less costly compared to Index scan You do not need to enable anything, its just if you want to force Index scan when query is going for full table scan, then you use HINTS. And, vice versa as well.
1.u can collect table&&indexes statistics and Histogram. to be a DBA ,2.u should know which is best execution plan access the table with lowest cost from the cbo 3.When necessary using hint /+ */ to stabilize the execution plan. good luck.