Discuss in the Community

Blogs

David Fitzjarrell
Follow /31 Jul 2015 at 8:44pm / Oracle

What’s In A (User) Name?

"So each one of you agrees to disagree with whatever the other one agrees with, but if you both disagree with the same thing, aren't you really in agreement?" - Norton Juster, The Phantom Tollbooth Recently a blog post caught my attention...
17 0 /
Ajith Narayanan
Follow /31 Jul 2015 at 3:46pm / Oracle

Oracle Backup & Recovery Series - 4 (RMAN BKP Configuration)

In my previous posts, all the settings for recoverability was discussed, If you have not read them yet, maybe you can start reading them now. In this blogpost we will start discussing on the backup configurations we should be concentrating on. 1) Multiplexing...
69 0 /
Fernando Garcia
Follow /31 Jul 2015 at 12:57am / Oracle

Acerca de las funciones analíticas.

Dentro del lenguaje SQL de Oracle podemos encontrar varios tipos de funciones. Es probable que coincidas conmigo en que las llamadas "single row" y las "agregadas" son los tipos de funciones mas famosas de todas. Como sus nombres lo...
106 0 /
Brad Wulf
Follow /30 Jul 2015 at 7:15pm / Toad for MySQL

Amazon Aurora is now GA! Get the most out of it by using Toad for MySQL

Amazon Aurora is now GA. If you aren’t familiar, Amazon says it best here: ‘ Amazon Aurora is a fully managed, MySQL-compatible, relational database engine that combines the speed and reliability of high-end commercial databases with the...
222 0 /
o.mustafaoracle
Follow /30 Jul 2015 at 12:09am / Oracle

Presentation will be

There is no much left for 2015 but there is too much work waiting me, presenting in different country means a lot of work and preparation, i am still waiting different events but till now this is confirmed:- SIOUG2015 HROUG2015 OOW15 UKOUG TECH15 So Excited...
102 0 /
o.mustafaoracle
Follow /30 Jul 2015 at 12:06am / Oracle

Database 12.1.0.2 Certified with EBS 12.2

After Waiting too long finally I can upgrade my Oracle EBS Database ,Regarding to Oracle Blog "Database 12.1.0.2 Certified with EBS 12.2". You can Read more about this here Cheers Osama
85 0 /
Dan Hotka
Follow /29 Jul 2015 at 4:57pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 7)

Hi! I have been discussing how I would find and tune problem SQL. Datatype mismatch has always been a problem for the optimizer. Oracle only compares like data types (more importantly, the same data types). So, if you are comparing a number...
136 0 /
Deiby Gomez
Follow /29 Jul 2015 at 3:30pm / Oracle

OTN Tour - Guatemala

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. OTN TOUR 2012 Tuve la oportunidad de participar en el primer OTN Tour que se realizó...
258 0 /
Deiby Gomez
Follow /29 Jul 2015 at 8:26am / Oracle

Oracle 12.1.0.2 y la función APPROX_COUNT_DISTINCT

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. Como parte de las nuevas características con las que cuenta Oracle 12.1.0.2, tenemos...
235 0 /
rickdelgado
Follow /28 Jul 2015 at 10:55pm / NoSQL

9 Elements of the Modern Data Center

Data centers are becoming increasingly important in today’s modern world. They hold and disseminate information to people when they need it. Because these data centers are crucial to how we run our lives and businesses it is important to understand...
382 0 /
David Fitzjarrell
Follow /28 Jul 2015 at 10:36pm / Oracle

It Isn’t The Index

"If you want sense, you'll have to make it yourself." - Norton Juster, The Phantom Tollbooth One of the more confusing statistics in Oracle is, apparently, one called the clustering factor. Associated with an index (as evidenced by...
264 0 /
Lenka Vanek
Follow /28 Jul 2015 at 9:45pm / Toad for Hadoop - Blog

Apache Sqoop Direct Mode – Optimized Data Transfer

Many Hadoop analytic tasks are dependent on data traditionally maintained primarily in a relational database such as Oracle. For instance, an analysis of web logs might need to access the CUSTOMER table in Oracle to obtain the customer’s geographic...
455 0 /
Natik Ameen
Follow /28 Jul 2015 at 4:55pm / Oracle

Database Rankings July 2015

Here is an interesting Database rankings survey on the db-engines site, which measures the general interest in the different databases, based on the criteria below. This provides some insight into the trend in the adoption of these databases. Database...
41 0 /
Jen McCown
Follow /28 Jul 2015 at 3:00pm / SQL Server

Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR

You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday, July 31, and if you register before June 30 you’ll get the Early Bird rate of $99…it’s $125 to attend...
357 0 /
akreul
Follow /28 Jul 2015 at 12:00pm / SQL Server

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route...
397 0 /
Craig Mullins
Follow /28 Jul 2015 at 12:35am / IBM DB2

DB2 Compression: z/OS versus LUW

Data compression for non-mainframe DB2 is quite a bit different than it is for DB2 for z/OS. In mainframe DB2, specifying COMPRESS YES on the CREATE TABLESPACE statement will cause DB2 to implement Ziv-Lempel compression ( http://www.data-compression...
696 0 /
rickdelgado
Follow /27 Jul 2015 at 7:46pm / NoSQL

Fears Over the Cloud are On the Decline

Cloud computing, or “the cloud” as it’s commonly referred to, is “the collection of data and use of related computing services via remote servers accessed through the internet.” Hundreds of cloud companies exist today to...
662 0 /
Brad Wulf
Follow /24 Jul 2015 at 5:21pm / Toad for Hadoop - Blog

Toad for Hadoop and Hortonworks - Like ordering off of the secret menu at In 'n Out Burger.

As a Hadoop user, it’s clear that you are an early adopter of technologies, and not afraid to roll up your sleeves and dig into a technology. In that spirit, we’ve recently heard from quite a few folks that are using Toad for Hadoop to connect...
1425 0 /
Sten Vesterli
Follow /24 Jul 2015 at 1:33pm / Oracle

First APEX 5.0 Patch

The most enthusiastic APEX developers jumped straight at APEX 5.0.0 as soon as it was released. This was a major, major change to APEX and a few kinks were to be expected. Oracle has already released APEX 5.0.1, fixing no less than 185 bugs . Given...
647 0 /
Fernando Garcia
Follow /23 Jul 2015 at 11:57pm / Oracle

Oracle y las arquitecturas de alta disponibilidad

Bajo el nombre “Oracle Maximum Availability Architecture (Oracle MAA)” Oracle define cuatro arquitecturas de alta disponibilidad que se ajustan a las necesidades de empresas e instituciones de distintos tamaños y líneas de negocio...
539 0 /
Porus Homi Havewala
Follow /23 Jul 2015 at 7:52am / Oracle

Enhancements to the Oracle Multitenant option in Oracle Database 12.1.0.2 – Part XIV

In this blog post series, we are looking at noteworthy enhancements to the Oracle Multitenant option of the Oracle Database in 12.1.0.2. In the previous post, we looked at Flashback Data Archive (FDA) which can now be enabled in 12c container databases...
638 0 /
Natik Ameen
Follow /22 Jul 2015 at 9:21pm / Oracle

BIWA Summit 2016 – Call for Speakers Open

BIWA Summit - The Big Data + Analytics User Conference. The call for Presentation Abstracts is now open. Submit yours today. The post BIWA Summit 2016 – Call for Speakers Open appeared first on VitalSoftTech .
22 0 /
Denny Cherry
Follow /22 Jul 2015 at 7:00pm / SQL Server

Updating All Jobs To Check For AG Primary Replica

One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group. This is because you have to manually create the jobs on each...
632 0 /
Dan Hotka
Follow /22 Jul 2015 at 4:55pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 6)

Hi! We have been discussing explain plan cardinality, the rows being returned by each line of the explain plan and the importance of these numbers, the useful and performance-related relationship these numbers have, and how Oracle11 is using actual...
670 0 /
Craig Mullins
Follow /21 Jul 2015 at 8:42pm / IBM DB2

Influencing the DB2 Optimizer: Part 4 - OPTIMIZE FOR n ROWS

In the first installments of this series of posts on ways to influence the DB2 optimizer we looked at standard methods like RUNSTATS and SQL tweaking techniques. Today, we will look at yet a nother method of influencing access path selection: specifying...
517 0 /