Expert Blogs

Blogs

jp_vijaykumar
Follow /21 Oct 2017 at 9:18pm / Oracle Blog

TABLESPACE CAPACITY PLANNING REPORT

TABLESPACE CAPACITY PLANNING REPORT Written JP Vijaykumar Oracle DBA Date Sept 14th 2017 I need to run capacity planning report in my project. Requirements: 01) Predict db growth for 3 months, 6 months and one year. 02) Display message, if the available...
15 0 /
Juan Carlos Olamendy
Follow /19 Oct 2017 at 11:41pm / MySQL

Data Flushing Mechanisms in InnoDB

By: Juan Carlos Olamendy Turruellas Introduction Durability is the D in the ACI D properties of transactions in the context of RDBMS . Durability is the guarantee that data has been physically recorded to permanent storage (such as a hard disk)...
13 0 /
Dan Hotka
Follow /19 Oct 2017 at 10:45pm / Oracle Blog

SQL Tuning SubQueries Using Toad

(Please visit the site to view this video)
99 0 /
Clarisa Maman Orfali

Conociendo los tres métodos de conexión a la bas de datos: TNS, directo y LDAP - Parte II

(Please visit the site to view this video)
82 0 /
Clarisa Maman Orfali

Conociendo los tres métodos de conexión a la bas de datos: TNS, directo y LDAP - Parte I

(Please visit the site to view this video)
121 0 /
Tim Fritz
Follow /19 Oct 2017 at 7:05pm / Toad for Oracle Blog

Minimize Risk by Simplifying and Automating Oracle Code Testing

As I work with database management and application development pros at all types and sizes of organizations, I’ve been looking for trends in database code testing – unit testing of PL/SQL functions and procedures, for example. It interests...
97 0 /
skant.gupta
Follow /19 Oct 2017 at 3:59pm / Oracle Blog

Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles s end us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s...
80 0 /
Syed Jaffar Hussain
Follow /19 Oct 2017 at 10:27am / Oracle Blog

How to expand Exadata Database Storage capacity on demand

Exadata Storage expansion Most of us knew the capabilities that Exadata Database Machine delivers. Its known fact that Exadata comes in different fixed rack size capacity: 1/8 rack (2 db nodes, 3 cells), quarter rack (2 db nodes, 3 cells), half rack ...
70 0 /
skant.gupta
Follow /18 Oct 2017 at 12:40am / Oracle Blog

How to Change Schema Passwords Securely in Oracle

Introduction To maximize the security features offered by Oracle Database in any business environment, it is imperative that the database itself be well protected. If you do not use encryption in SQL Net everything that goes from the client to the...
144 0 /
Porus Homi Havewala
Follow /17 Oct 2017 at 8:24pm / Postgres - Blog

PostgreSQL Database for Enterprises – Part I

In today’s brave new world, data and information of all sorts are rapidly proliferating. Many companies who have used traditional databases such as the Oracle database or Microsoft SQL Server for their data requirements since the 1990s have now...
258 0 /
Porus Homi Havewala
Follow /17 Oct 2017 at 7:16pm / Oracle Blog

Oracle Hybrid Database Cloud Using Enterprise Manager – Part V

In this article series, we are looking at the steps for setting up the Oracle Hybrid Cloud via the latest version – Enterprise Manager Cloud Control 13c – that has been installed on premises. The main intention is to install an Enterprise...
209 0 /
Porus Homi Havewala
Follow /17 Oct 2017 at 6:45pm / Oracle Blog

Database as a Service using Enterprise Manager – Part V

Introduction In our article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database as a Service (DBaaS) cloud – including the setup of such a cloud. In the previous parts , we started...
297 0 /
Syed Jaffar Hussain
Follow /17 Oct 2017 at 2:46pm / Oracle Blog

K21 Technologies - Upcoming Oracle trainings

Atual's K21 technologies offering some quality of Oracle training. Below are the upcoming Oracle training: https://k21technologies.samcart.com/referral/appsdba/062687 https://k21technologies.samcart.com/r…/appsdbawebinar/062687 https://k21technologies...
78 0 /
Syed Jaffar Hussain
Follow /17 Oct 2017 at 1:58pm / Oracle Blog

Whats new in Exadata X7

Oracle announced its new Exadata Database Machine X7 during OOW 2017. Lets walk through quickly about the key features of X7. Key features Up to 912 CPU core and 28.5TB memory per rack 2 to 19 DB servers per rack 3 to 18 Storage servers per rack Maximum...
69 0 /
Denny Cherry
Follow /16 Oct 2017 at 6:39pm / SQL Server Blog

PASS Summit 2017 Speaker Idol Judges

I know I’ve been really slacking on getting this year judges list for speaker idol posted. A lot of this is just because of everything else that’s been going on leading up to the PASS summit, specifically my insane travel schedule to SQL Saturday’s...
83 0 /
Pini.Dibask
Follow /13 Oct 2017 at 2:44pm / Oracle Blog

I'm an Oracle ACE - thank you Oracle for this recognition!

Hi everybody, Yesterday I received the following email from the Oracle ACE Program: "I am pleased to inform you that you have been accepted to receive the Oracle ACE award. You have been chosen based on your significant contribution and activity...
105 1 /
Syed Jaffar Hussain
Follow /13 Oct 2017 at 1:51pm / Oracle Blog

Switchover and Switchback simplied in Oracle 12c

Business continuity (Disaster Recovery) has become a very critical factor for every business, especially in the financial sectors. Most of the banks are tending to have their regular DR test to meet the central bank regulation on DR testing capabilities...
112 0 /
Denny Cherry
Follow /12 Oct 2017 at 6:46pm / SQL Server Blog

PASS Summit Speaker Idol Lineup Change Redux

We’ve had another change to the PASS Summit speaker idol line up. Tzahi has had to withdraw du e to work commitments and won’t be able to attend the PASS summit at all this year.  Which is good news for Jeremy Frye as he will be taking the...
81 0 /
skant.gupta
Follow /12 Oct 2017 at 5:53am / Oracle Blog

Oracle 18c: “Oracle 18c and its impact on DBAs”

This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles s end us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta's LinkedIn...
174 0 /
Kevin Dalton

Benchmark Factory 8.0 Released!!!

We are very excited to announce the release of Benchmark Factory 8.0!! In this major release are several enhancements, including the much anticipated update to the BMF REST API so that database performance testing can be automated and easily included...
34 0 /
Pini.Dibask
Follow /10 Oct 2017 at 3:44pm / Oracle Blog

ODC Appreciation Day : Online Move Data File Operation

I've decided to dedicate my ODC Appreciation Day blog post to "Online Move Data File Operation" - a feature which has been introduced in Oracle 12c. As a quick background to this blog post, ODC (Oracle Developer Community) appreciation day...
113 0 /
Pini.Dibask
Follow /10 Oct 2017 at 2:05pm / Oracle Blog

My Oracle OpenWorld 2017 Presentation - Slide Deck is Now Available!

Last week, on October 1st, I've presented a session at Oracle OpenWorld about Database consolidation using Oracle Multitenant option. I was invited to speak on behalf of the IOUG (Independent Oracle User Group) at Oracle OpenWorld for the second year...
391 0 /
Clarisa Maman Orfali
Follow /10 Oct 2017 at 5:37am / Oracle Blog

Instalación de la Base de Datos Oracle 11gR2 en Windows

En este artículo quiero compartir la instalación de la Base de Datos Oracle 11gR2 muy simple en Windows. Descargamos la base de datos Oracle desde OTN, para ello necesitamos tener un usuario y aceptar el acuerdo de licencia. En mi...
103 0 /
Deepak Vohra
Follow /9 Oct 2017 at 11:56pm / Toad Edge - Blog

Using SSH in Toad Edge 1.1 with MySQL Database

Introduction SSH (Secure Shell) is a protocol for secure remote login to a machine. SSH is designed for a client-server model; connecting an SSH Client to an SSH Server. While SSH supports several options for user authentication, the main options are...
160 0 /
Dan Hotka
Follow /9 Oct 2017 at 6:39pm / Oracle Blog

Scary Situations: Management Bullies, Tight Deadlines, and More

Hi, This month pulls from my programming and consulting days: how I solved working with management bullies, and used technology to solve short time frames and to assist in a screen-conversion project where I didn’t have any help. All of these...
274 0 /