Search

Top 60 Oracle Blogs

Recent comments

April 2016

Oracle Management Cloud – Application Performance Monitoring

A while ago I created a first post about the Oracle Management Cloud ( #OMC

Birmingham City University (BCU) Talk #5

bcuI had a day off work today so I could go over to Birmingham City University (BCU) and do a talk to the students.

Today’s session was more about giving them an idea of where databases fit into the big picture as far as data and data processing is concerned. I obviously come at this as a relational database guy, but the presentation also included NoSQL and Hadoop. I hope nobody is naive enough anymore to think relational databases are the correct solution for every use case, so it’s important to be objective about this stuff, rather than to push your own agenda.

DEFAULT_CACHE_SIZE mentioned in alert.log of an #Oracle database

Today, I got this message in my alert.log file:

Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 709 MBs bigger than current size.

When I look at the datafile sizes and compare them with the buffer cache size, it shows:

 

EM13c Cloning- Part II, Demands from Test Master and Kellyn

On my previous post, I submitted a job to create a test master database in my test environment.  Now my test environment is a sweet offering of containers that simulate a multi-host scenario, but in reality, it’s not.

Why You Should Consider Moving Your Enterprise Applications to the Oracle Cloud

class="l-submain">
class="l-submain-h g-html i-cf">

 

style="font-weight: 400;">If you’ve decided to migrate your Oracle enterprise applications to the public cloud, it’s a good idea to consider Oracle Cloud alongside alternatives such as Amazon Web Services (AWS) and Microsoft Azure.

style="font-weight: 400;">Oracle has made big strides in the cloud lately with platform-as-a-service (PaaS) offerings for its middleware and database software, culminating in the release of its first infrastructure-as-a-service (IaaS) offering in late 2015.

style="font-weight: 400;">Oracle has a clear advantage over the competition when it comes to running its own applications in the cloud: it has full control over product licensing and can optimize its cloud platform for lift-and-shift migrations. This gives you a low-risk strategy for modernizing your IT portfolio.

 

What to expect from Oracle Cloud IaaS

How to Find Information in the OMR, (Enterprise Manager Repository)

I get a lot of questions starting with, “Where do I find…” and end with “in the Oracle Management Repository, (OMR)?”

What Are Your Options For Migrating Enterprise Applications to the Cloud?

class="l-submain">
class="l-submain-h g-html i-cf">

style="font-weight: 400;">Migrating your enterprise applications from on-premises infrastructure to the public cloud is attractive for a number of reasons. It eliminates the costs and complexities of provisioning hardware and managing servers, storage devices, and network infrastructure; it gives you more compute capacity per dollar without upfront capital investment; and you gain opportunities for innovation through easier access to new technologies, such as advanced analytical capabilities.

style="font-weight: 400;">So how do you get there?

Oracle Security And Delphix Paper and Video Available

I did a webinar with Delphix on 30th March 2016 on USA time. This was a very good session with some great questions at the end from the attendees. I did a talk on Oracle Security in general, securing non-production....[Read More]

Posted by Pete On 01/04/16 At 03:43 PM

Set Operations

A recent post on the OTN database forum highlights a couple of important points ideas for optimising SQL. There are: (a) is there a logically equivalent way of stating the SQL and (b) is there a different “natural language” way of posing the problem.

The posting starts with a query, part of an execution plan, and a request to “get rid of the tablescan”. I guessed originally that the query came from an 11g instance, and the OP gave us some code to create the tables and indexes, so I’ve modelled the tables to get the indicated plan (then filled in the original numbers). This is the query, and my cosmetically adjusted version of the plan output that the OP probably got:

NoCOUG changes its name (Happy April Fools Day)‏

The board members of NoCOUG meets in closed session to discuss the continuing decline in memberships and conference attendance.(read more)