|
||||
|
I have got a request from the team asking to get the DML statements that ran against a table for a particular period of time For this, I have three options 1) If auditing is enabled, get the statements from the audit trail, but the problem will be no bind variable replacement and also the […] Hello All, This is the first post and test post for this new site, if you are encountering any issues with site please drop me an email with issue, will fix it. For those who enrolled post to email subscription, they should receive this post via email, if not can you please spare sometime […] Hello, Thanks to my colleague, I have just buyed the following from my Friend Naga Satish from his email and sharing here. “Edited Explain plan” —————————————————————————————— | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | —————————————————————————————— | 0 | SELECT STATEMENT | | 3626K| 390M| | 1217K (1)| 04:03:28 […] If you want to understand more about SQL Plan Management, read this post before reading further, https://blogs.oracle.com/optimizer/entry/sql_plan_management_part_1_of_4_creating_sql_plan_baselines Debate- SPA vs. SPM vs. ACS, SPM vs. sql_profiles etc As you see in the figure, Each and every sql baselines has multiple plans associated with it and stored in sql plan management base. Some of the statements […] Hello All, In continuation of my previous post, Quick Question: When is my table last accessed? Does my index is in use? I have another questions when is my table last modified and what are the ways i can view it. Here you go, 1) Enabling audit on segment 1)Enable auditing […] Thanks Iordon Iotzov for showing up here and following this blog. To my blog readers, Iordon has many good works and posts under his blog and he has recently presented at HOTSOS about confidence on cardinalities/statistics. You can read it here. Hotsos Symposium 2013 -Thanks Geek DBA Finding the CRS resource last modified or started will be very clumpsy when you look at crsd.log or any other logs. For that use -v flag in crsctl status resource command where you can find some important details like last server , last changed, last restart, internal status etc. For example:- [grid@node1 ~]$ crsctl status […] Hi, When you need to run something like a check of parameter in all databases in a server and if you have more databases, manually doing will be cumbersome. Here is the script that helps to connect to all databases in a server by reading /etc/oratab (linux) and then change a parameter streams pool to […] When a query is issued against an Oracle Real Application Clusters (Oracle RAC) database with multiple nodes, the parallel processes may be spawned on different nodes. This approach is used to ensure that no one node becomes overloaded and that the processing power of all nodes is utilized as efficiently as possible. However, under certain […] In Theory:- HugePages is a feature integrated into the Linux kernel 2.6. It is a method to have larger page size that is useful for working with very large memory. HugePages is useful for both 32-bit and 64-bit configurations. HugePage sizes vary from 2MB to 256MB, depending on the kernel version and the […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!