view counter
Home

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.

TAF is not working on Rac One Node in case of node failure ? Well it depends

Martin Bach did a good study of Rac One Node capability and especially of what happens with session failover during a database relocation or during a node failure into this blog post.
He showed us that:

May 16, 2013 8:38am

Sql script that compares two db,s and updates db and insert date of update

Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done? Can anyone help mee whit this?
May 16, 2013 7:46am

Outputting your data using inbuilt SQL Dev formatting

Oracle has build a number of formatting options into SQL Developer to allow you to output your data in some standard formats. This removes the need to use other tools or to write extra code or performs various follow up steps.All you need to do is to add a comment and use the Scrip buttonSELECT /*csv*/ * FROM scott.emp; SELECT /*xml*/ * FROM scott.emp; SELECT /*html*/ * FROM scott.emp; SELECT /*delimited*/ * FROM scott.emp; SELECT /*insert*/ * FROM SCOTT.EMP;

May 16, 2013 5:55am

Temp Usage

Hi,

I am new to Database activities.Please advise how to check the temp usage and find the query causing that temp in oracle 9i

May 16, 2013 4:26am

SCNs and Timestamps

The function ORA_ROWSCN returns an SCN from a row (or more commonly the block, unless ROWDEPENDENCIES has been used).

select distinct ora_rowscn from PLAN_TABLE;
But unless you're a database, that SCN doesn't mean much. You can put things in some sort of order, but not much more.
Much better is

May 16, 2013 4:05am

Big data can improve customer experience, reduce churn

As companies have come to realize that attracting and retaining customers depend on providing a personalized experience, more firms are looking to mine big data for enhanced analytic insight. By leveraging support from dba services, enterprises have the opportunity to understand consumers on a deeper level, develop more targeted strategies and thus, secure stronger and more loyal relationships.

May 16, 2013 2:15am

Getting Real About Big Data: Build Versus Buy. A whitepaper by ESG

"Getting Real About Big Data: Build Versus Buy", by Evan Quinn, Senior Principal Analyst - ESG - Enterprise Strategy Group - February 2013

A great white paper to prove the efficiency of Oracle Big Data vs a do it by yourself Hadoop Cluster - almost 40% savings in costs and time: download here

May 16, 2013 1:02am

Big data success depends on IT alignment, expertise

Big data has become an increasingly critical focus for enterprises in every sector, but decision-makers are still struggling to make sense of these vast volumes of information. In order to extract value from these sources, enterprises need to seek reputable database experts to aid in capturing and analyzing both structured and unstructured data.

May 15, 2013 11:33am
view counter