Oracle Virtualization and Cloud Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Time Is On My Side, Maybe

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.

Inappropriate behaviour

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
SCOTT.QUEUE_TABLE
You would think that since you’ve asked to drop everything, that well…everything could be dropped, but no :-)

Data Pump import makes me crabby

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 and v$sql_plan and related views

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:

SQL Server 2014: FCIs, availability groups, and TCP port conflict issues

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.

EM12c Cloud Control Metric Extensions – Monitor failed DBMS SCHEDULER Jobs

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:

Do The LGWRs Always Sleep For The Full Three Seconds?

Do Oracle Database LGWRs (10g, 11g, 12c) Always Sleep For The Full Three Seconds?

table lock in past

Hi Guys,

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.

Best Regards.

SOUG-Romand: Journée performance le 21 mai

(english below)
Bonne nouvelle pour les francophones: le SOUG-R est de plus en plus actif.
Le 21 mai 2015 une journée performance est organisée sur Lausanne.

The greatest cybersecurity concerns of the new year [VIDEO]

Transcript

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.

view counter