A recent MOS document discusses, albeit briefly, an issue with AWR reports that’s been going on since 10.2.0, namely that the elapsed time numbers for queries executed in parallel are considerably greater than the actual elapsed clock time. Let’s look at why that is and what can be done about it.
You pick up little funny things in the day to day with Oracle.
Like this one when you try to drop a tablespace with a queue table in it:
drop tablespace MY_TSPACE including contents
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: Inappropriate utilities used to perform DDL on AQ table
You would think that since you’ve asked to drop everything, that well…everything could be dropped, but no :-)
I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when a full export / import would be too slow, and this is meant to be … well…fast.
And fast it is.. until it reaches the following step:
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Adaptive plans are one of the coolest new optimiser features in Oracle 12c. If you haven’t seen or heard about them in detail I recommend the following resources:
After giving my session about SQL Server AlwaysOn and availability groups at the last French event “Les journées SQL Server 2014”, I had several questions concerning the port conflict issues, particularly the differences that exist between FCIs and availability groups (AAGs) on this subject.
So what are Metric Extensions?
As the name implies metric extensions enables us to extend the out-of-the-box monitoring capabilities of Enterprise Manager and customize it according to the requirements of our specific environment.
Very often we may have some monitoring and alerting requirements for which metrics are not available in OEM and we are having to run external scripts outside OEM.
For example we would like to be alerted and notified via OEM in the following circumstances:
is there any query which gives which table had been locked in past i mean some hours ago or 1 day ago?.if so please send me the query. thanks a lot in advance.
Hi, welcome to RDX! While cybersecurity experts may not have a crystal ball to tell them which threats will impact companies the most, it’s still important to prepare for the future.
So, what does the average data breach look like in 2015? More people are expected to use mobile payment solutions and other similar systems this year. As a result, it’s likely that cybercriminals will use any tactics at their disposal to infiltrate this technology and the protocols associated with it.