|
||||
|
Hello, Thanks to my colleague (Naga) for this information, We have got a question from another friend on how to find the export dump file whether its belongs to export (exp) or datapump export(expdp). The question is “I am planning to import the dump to a new database but I am confused by seeing the […] We often need to find which process ID is causing high I/O or having I/O waits. Unfortunately there is no real time specific tool that is available apart from iotop which is by default not available in all environments (as in my case). How we can determine which process is generating more I/O (or in […] 1. What are Oracle enqueues? Oracle enqueues are locks at database level that coordinate parallel access to Oracle resources such as objects or data records. For example, enqueues are responsible for several transactions not being able to change the same data record at the same time.Enqueue requests are divided into queues whose requests are then […] Hi, In 10g, you can use data dictionary view v$sql_bind_capture or AWR view dba_hist_sqlbind (historical version of v$sql_bind_capture) to find bind variables’ values. However it has some significant limitations: Captured periodically (_cursor_bind_capture_interval=900 seconds by default), not at real time. Captured under maximum size(_cursor_bind_capture_area_size=400) Only bind variables in WHERE clause are captured (e.g bind variables passed […] A long running job and you have identified that statistics of a table is causing sub optimal plan and you have gathered the statistics and asked teams to rerun the job. But still picking old plan or the statistics which should not, the reasons are and how to invalidate the cursor in library cache (SQL […] Consider this scenario (as explained by My colleague for his requirement, Thanks Rambo) Source database: Tablespace T1 created with locally managed tablespace with auto segment space management. Destination Database: Tablespace T1 created with locally managed tablespace with uniform extent allocation. Read carefully the underline parts, Now If I import this tablespace T1 into the Destination […] Somtimes you might be into a situation, that you have created an sql profile and unfortunately that has not been picked up? Well as per my reads and understanding and limited knowledge, these may be the causes. 1) Signature mismatch – SQL statements as converted to signature (with possible extra space truncation, replace literals etc) […] Many thanks to Shiva & Swathi for sharing their real time experience and appreciating their wish to share this to in my blog. Further, the following is very nice work from Swathi with screenshots and well written to understand the situation and how to resolve the same!!! Read on!!! Sharing one situation of my […] The following sections are key to analyze in the AWR report and identify for RAC global characteristics or load profile. Number of Instances Instance global cache load profile Global cache efficiency percentages GCS-GES workload characteristics Messaging statistics Service Statistics Service Wait class statistics Top segments related to CR and current blocks Number of Instances:- […] Starting 11gr2, ASM now classifies reads/writes into two – COLD and HOT. As you guessed, HOT read/writes are those coming from the blocks which are classified as HOT – meaning placed in the outer sectors. COLD is the default – meaning data placed in inner sectors. Data blocks of most often accessed segments are […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!