Discuss in the Community

Blogs

Deiby Gomez
Follow /26 Oct 2014 at 2:46am / Oracle

Una introducción a OPatch - Aplicar un PSU

Note: This article was written in Spanish, if you are reading this one in English it's possible that you will find typos because of the automatic translation. En este articulo les enseñaré lo básico del uso de la herramienta...
15 0 /
Deiby Gomez
Follow /25 Oct 2014 at 11:47pm / Oracle

SERVER=NONE in V$SESSION using Shared Server

When you are dealing with Shared Server there are some things that you have to know in order to understand what is going on in your database. Last night I was talking with a friend who asked me "Hey why my shared server configuration is not working...
15 0 /
Iggy Fernandez
Follow /25 Oct 2014 at 11:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 23: Answers to the Final Exam! (Part I)

Previous installment: The story so far (Part 11–22) First installment: DON’T PANIC Here are the answers to the first problem based on the following query and execution plan in Part 21 of this series: SELECT ch.channel_class...
82 0 /
Norm [TeamT]
Follow /25 Oct 2014 at 3:34pm / Oracle

Beware of the Silent Database Killer!

There is, out there in Oracle Land, a silent database killer. You never know when it will strike and it affects all databases right up to and including 12c. When it strikes, it does so silently, there is no evidence of its passing, until it is far too...
31 0 /
Sten Vesterli
Follow /25 Oct 2014 at 1:34pm / Oracle

Preparing for Life After Forms

Many customers I advise are running Oracle Forms and are wondering what the future of these applications is. There are generally three options: Stay with Oracle Forms (keeping up to date with the latest release to stay supported) Migrate to...
26 0 /
Porus Homi Havewala
Follow /25 Oct 2014 at 10:56am / Oracle

Managing Oracle Database 12c with Enterprise Manager – Part X - Database as a Service

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at the Database Resource Manager and how it can be used to control resources at the PDB level in Database 12c...
31 0 /
zaheer.appsdba
Follow /24 Oct 2014 at 9:28pm / Oracle

using start CD 12.2.0.48 with R12.2 Stage

In this article i will demonstrate how to use latest start CD with and existing Oracle E-Business suite R12.2 stage. Oracle released two versions of start CD since the announcement of Oracle EBS R12.2. The base release of start CD is 12.2.0.46 then later...
31 0 /
karen.r.morton
Follow /24 Oct 2014 at 6:54pm / Oracle

What's it look like when you mess up?

This was the Top Activity page from Enterprise Manager today after I inadvertently did something in production that I thought I was doing in test. Yikes! As you can see, activity spiked for almost an hour. So, what did I do? I wanted to try a different...
44 0 /
rickdelgado
Follow /24 Oct 2014 at 6:10pm / NoSQL

The New Security Challenges Introduced by Virtualization and Cloud Computing

The terms virtualization and cloud computing are more than just buzzwords; they represent tools that can be used by business owners to grow their companies and reach out to more customers. By now, the benefits of both technologies (more productivity,...
23 0 /
Craig Mullins
Follow /24 Oct 2014 at 4:55pm / Oracle

A Sample DBA Job Posting

I’ve seen a lot of different job postings for DBAs and database professionals over the years, but I rarely see ones that are well-written and accurately cover the essential job responsibilities and expectations. So with that in mind, I decided to...
72 1 /
Jason Strate
Follow /24 Oct 2014 at 4:00pm / SQL Server

Reblog: October 17 to October 23

Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
28 0 /
WaterOx
Follow /24 Oct 2014 at 2:00pm / SQL Server

Find all triggers in a SQL Server Database

What Are Database Triggers? Do you know what triggers lurk in your database? Triggers can be implemented to enforce business rules or referential data integrity in database applications. There are even triggers that allow data modifications to multiple...
106 0 /
DuncanDavies
Follow /24 Oct 2014 at 12:15pm / Oracle

Oracle recognizes Cedar Consulting for Expertise in Oracle HCM Cloud

We are delighted to announce that Cedar Consulting has achieved OPN Specialized status for Oracle HCM Cloud. To achieve this a number of our consultants had to pass a set of exams on Oracle HCM Cloud and as a business we had to have a certain amount...
28 0 /
Craig Mullins
Follow /23 Oct 2014 at 6:27pm / IBM DB2

DB2 SQL and Application Performance Tools

So far in this series of blog posts on DB2 performance tools, we have looked at system and database performance solutions. But perhaps the most important solution area involves monitoring and tuning application SQL statements. Why do I say that? Well...
136 0 /
Stuart Ainsworth
Follow /23 Oct 2014 at 1:02pm / SQL Server

#SQLPASS – Fluffy Bunnies

I didn’t really have a good name for this post, so I thought I’d just try to pick something as non-offensive as possible.  Everybody likes bunnies, right?  Anyway, the last series of posts that I’ve made regarding the Professional Association...
108 0 /
Natik Ameen
Follow /23 Oct 2014 at 5:37am / Oracle

Configure Oracle Exadata Write Back Flash Cache

In addition to improving read I/Os, Oracle Exadata Write back flash cache also provides the ability to cache write I/Os directly to PCI flash. Exadata storage software version 11.2.3.2.1 is the minimum version required to use write back flash cache. Grid...
66 0 /
Jason Brimhall
Follow /22 Oct 2014 at 10:16pm / SQL Server

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is the link so you can read that article first before proceeding here.  This article is intended as a first of two part follow-up to that article . ...
73 0 /
DuncanDavies
Follow /22 Oct 2014 at 10:01pm / Oracle

What’s coming in Taleo 14B

The release notes are out, and the other night I attended a webinar showing the highlights of the Taleo Enterprise Edition 14B release (provisionally due on November 24th). It was a really worthwhile hour and the presenter – who I believe was Fabrice...
54 0 /
John Weathington
Follow /22 Oct 2014 at 4:04pm / Toad BI Suite

We Don't Support That Here

Introduction I was sitting in my hotel room last night frustrated with the speed of my Internet connection, so I called the front desk to upgrade my bandwidth. Unfortunately my problem was over their head, so they gave me the number to their IT support...
24 0 /
David Fitzjarrell
Follow /22 Oct 2014 at 3:37pm / Oracle

Memory Improvement

Oracle 12c (version 12.1.0.2) offers the option of using in-memory processing to speed things along. Called the In-memory option it’s installed when you install the 12.1.0.2 software. Using it can make a considerable difference in processing speed...
98 0 /
Derik Hammer
Follow /22 Oct 2014 at 3:13pm / SQL Server

Backup testing with PowerShell

This week I released a two part blog series on testing your backup files and reporting on the results in an automated fashion. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your organization...
62 0 /
Kenneth Fisher
Follow /22 Oct 2014 at 12:00pm / SQL Server

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures . In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can...
52 0 /
Richard To
Follow /22 Oct 2014 at 6:58am / SQL Optimizer for Oracle

SQL Rewrite to Twist Cost Estimation

There are mainly three problems that database SQL optimizer cannot find the best way to process your SQL statements. Cost estimation error The cost estimation error is not only caused outdated statistics, but lots of other factors that a SQL's...
30 0 /
Fernando Garcia
Follow /21 Oct 2014 at 11:16pm / Oracle

Curiosidades Oracle; el DISCONNECT que no desconecta.

Para comprender esta curiosidad de la base de datos Oracle necesitamos introducirnos en el mundo de las sesiones y conexiones. ¿Qué es una sesión de base de datos? Una sesión de base de datos se define como una entidad...
140 0 /
Paul Turley
Follow /21 Oct 2014 at 6:01pm / SQL Server

SQL Server Upgrade Preconference at PASS Summit 2014

Please join me and my associates for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology...
13115 0 /