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.

Deploy a SQL Server database to Azure


 
Deploying a SQL Server database to a Windows Azure virtual machine is a feature introduced with SQL Server 2014.

DBA_FEATURE_USAGE_STATISTICS

Oracle introduced this view in version 10.

What is Dephix ? (video presentation)

According to a recent IDC study, on average Delphix

  • pays for itself in 4.3 months
  • 461% ROI over 5 years
  • 96.8% reduction in database storage
  • $50 Million predicted annual benefit for organizations over 75,000 employees

Delphix is used by over 100 of the Fortune 500.
What is Delphix? Why is Delphix important? What problems does Delphix solve in the industry?
Here is a slide deck I put together for KSCOPE :

keeping my fingers crossed just submitted abstract for RMOUG 2015 Training Days ...

The Rocky Mountain Oracle Users Group has been big and organized for a very long time.  I have never been out there ( my bad ) but am hoping to change that situation in 2015.

Abstracts are being accepted for Training Days 2015 ... my first one is in there now thinking about a second submission but my Hotsos 2014 presentation needs some more work/fixing.  Ok lets be honest I need to shrink it considerably and tighten the focus of that one.

Information on RMOUG 2015 can be found here: RMOUG Training Days 2015

Sequences as Primary Keys in Oracle RAC environment - best way to generate PKs

Environment: Oracle 11G, Web Portal Application development, Java, DataGuard available if needed

What is the best/recommended/proven way to generate integer surrogate keys for App development with Oracle as back-end in multi node RAC environment. There may be relatively frequent node switch-over.

Q. IS CACHED, non-ordered sequence is best preferred way in above environment?

Factors:
security
performance,
data maintenance and quality,
Data ETL/Refreshing between environments,
failover

ORA-27476: "SYS.MY_FANCY_JOB_CLASS" does not exist

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

Ever exported a whole schema containing DBMS_SCHEDULER jobs with non-default job classes?
Chances are that you hit the following error message when you attempt to import the dump later on.
 
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-27476: "SYS.MY_FANCY_JOB_CLASS"

Longreads’ Best of WordPress, Vol. 3

We’re back with another edition of Longreads’ Best of WordPress: below are 10 outstanding stories from across WordPress, published over the past month.

You can find Vol. 1 and 2 here — and you can follow Longreads on WordPress.com for all of our daily reading recommendations.

Glorious mysteries of Oracle's web site

God or Larry knows why Oracle feels the compelling need of changing some of its page links over time.

Oracle Application Express' main page URL is now:

http://www.oracle.com/technetwork/developer-tools/apex/index.html

It was:

http://www.oracle.com/technology/products/database/application_express/index.html

May be I am a bit slow in picking up these changes, I don't really know if this

12c RMAN New Feature – Cross Platform Data Transport Using Incremental Backups

In Oracle 12c we can now transport data across platforms using full as well as incremental backup sets.

The use of RMAN Incremental backups can significantly reduce overall application downtime during cross-platform data migration and will be useful in any 11g to 12c future upgrades.

In this example we look at migrating data from an Oracle 11g R2 database on Windows platform to an Oracle 12c container database hosted on a Linux platform using incremental backup sets.

Watch Oracle DB Session Activity With The Real-Time Session Sampler

Watch Oracle DB Session Activity With My Real-Time Session Sampler

Watching session activity is a great way to diagnose and learn about Oracle Database tuning. There are many approaches to this. I wanted something simple, useful, modifiable, no Oracle licensing

view counter