Administración de...
Follow
Find
17.9K views | +0 today
 
Scooped by Juan Luis Serradilla
onto Administración de una Base de Datos Oracle
Scoop.it!

Why does my full table scan take 10x longer today ?!

Why does my full table scan take 10x longer today ?! | Administración de una Base de Datos Oracle | Scoop.it
Every so often a DSS query that usually takes 10 minutes ends up taking over an hour.  (or one that takes an hour never seems to finish) Why would this happen? When investigating the DSS query, per...
Juan Luis Serradilla's insight:

Interesante script que pemite saber en qué tablespaces provoca E/S cada sentencia SQL, y así poder detectar si se están leyendo datos del UNDO (que es mucho más costoso). Esto puede explicar malos tiempos de respuesta puntuales.

more...
No comment yet.
Administración de una Base de Datos Oracle
Divulgación gratuita de contenidos en castellano sobre Administración de Oracle
Your new post is loading...
Your new post is loading...
Scooped by Juan Luis Serradilla
Scoop.it!

How to get a SQL Testcase in a single step

How to get a SQL Testcase in a single step | Administración de una Base de Datos Oracle | Scoop.it
Regardless of the reason why you are playing with a specific SQL (tune the SQL, avoid an ORA error, work around a wrong result, etc) it's always helpful to be able to reproduce the same behavior in...
Juan Luis Serradilla's insight:

Starting 11gR1 Oracle introduced Testcase Builder (TCB) as part of the Oracle Database Fault Diagnosability Infrastructure (ADRCI, DBMS_HM and DBMS_SQLDIAG just to keep it simple). Basically it’s a set of APIs (http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sqldiag.htm#ARPLS68321) to generate a testcase starting from either a SQL ID or a SQL text. The easiest way to extract a TC is to use "dbms_sqldiag.EXPORT_SQL_TESTCASE" passing a SQL_ID.

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, September 2, 7:56 AM

Desde Oracle 11g R1, la forma más sencilla de generar un Caso de Test (Test Case) de una sentencia SQL es usar el procedure "dbms_sqldiag.EXPORT_SQL_TESTCASE", pasándole el SQL_ID (http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sqldiag.htm#ARPLS68321)

Scooped by Juan Luis Serradilla
Scoop.it!

Relational to JSON in Oracle Database

Relational to JSON in Oracle Database | Administración de una Base de Datos Oracle | Scoop.it
Juan Luis Serradilla's insight:

This article shows several options, from lower level PL/SQL based solutions to higher level solutions that do more than just generate and parse JSON:

-    Lower Level
     -   PL/JSON: https://jsao.io/2015/07/relational-to-json-with-pljson/
     -   APEX_JSON: https://jsao.io/2015/07/relational-to-json-with-apex_json/

-    Higher Level

     -   ORDS: https://jsao.io/2015/07/relational-to-json-with-ords/

     -   Node.js driver for Oracle Database: https://jsao.io/2015/07/relational-to-json-with-node-js/

 

more...
No comment yet.
Scooped by Juan Luis Serradilla
Scoop.it!

Indexes and NOT Equal (or NOT In)

Indexes and NOT Equal (or NOT In) | Administración de una Base de Datos Oracle | Scoop.it
The Cost Based Optimizer (CBO) is a rather complex piece of code that has to deal with countless different possible scenarios when trying to determine what the most optimal execution plan might be....
Juan Luis Serradilla's insight:

When the CBO ignores indexes, it ignores indexes in all cases. Even if 99.99% of rows match the value in the NOT EQUAL (or NOT IN) condition and there’s only a handful of remaining rows to actually be retrieved, the code path in the CBO is still followed and indexes are ignored regardless. The reason possibly being such queries could be re-written to avoid the use of the NOT EQUAL (or NOT IN) condition and so its use is still suggesting a large selectivity.

 

more...
No comment yet.
Scooped by Juan Luis Serradilla
Scoop.it!

Oracle Critical Patch Update - July 2015

None
Juan Luis Serradilla's insight:

De las 10 nuevas vulnerabilidades corregidas en Oracle Database Server, una de ellas se puede explotar fácilmente de forma remota sin autenticación, afectando al componente "RDBMS Security" en la versión 12.1.0.2, con una puntuación CVSS de 5 (https://nvd.nist.gov/cvss.cfm?calculator&version=2). Hay otra vulnerabilidad similar (explotable sin autenticación por red), pero solo afecta a Application Express (versiones anteriores a la 4.2.1) y la complejidad es media, con puntuación 4.3.

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, July 21, 5:07 AM

De las 193 vulnerabilidades corregidas, 10 afectan a la base de datos (Oracle Database Server), y una de ellas se puede explotar fácilmente de forma remota sin autenticación, afectando al componente "RDBMS Security" en la versión 12.1.0.2, con una puntuación CVSS de 5 (https://nvd.nist.gov/cvss.cfm?calculator&version=2).

Scooped by Juan Luis Serradilla
Scoop.it!

Dimensional Modeling in Oracle SQL Developer Data Modeler

Dimensional Modeling in Oracle SQL Developer Data Modeler | Administración de una Base de Datos Oracle | Scoop.it
A free powerpoint presentation on dimensional modeling in Oracle SQL Developer Data Modeler and a sample dimensional model for you to play with
Juan Luis Serradilla's insight:

Many thanks to Jeff Smith for the presentation that you can see on SlideShare: http://www.slideshare.net/hillbillyToad/dimensional-modeling-in-oracle-sql-developer

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, July 9, 8:00 AM

¿Estás trabajando en un proyecto de BI (Business Intelligence) y quieres modelar los datos (dimensiones, medidas, etc)? Puedes hacerlo con Oracle DataModeler

Scooped by Juan Luis Serradilla
Scoop.it!

Webcast "Why Upgrade to Oracle 12c"

Webcast "Why Upgrade to Oracle 12c" | Administración de una Base de Datos Oracle | Scoop.it
Blogs.Oracle.Com - Upgrade your Database - NOW!
Juan Luis Serradilla's insight:

My outline:

- 11.2 with extended support from Jan 2015 to 2018.

- Don't wait for release 2 (12.2) because may be you are missing new fixs por your bugs.

- preupgrd.sql script for testing upgrade requirements.

- catctl.pl  for parallel upgrade can save 40% upgrade time with large databases.

- DBUA (DB upgrade assitant), for easy upgrade, can run preupgrd.sql and catctl.pl.

-You also can upgrade with full transportable export, copying your datafiles. More complex than DBUA, but may be faster.

- More info: MOS note 1462240.1 (https://support.oracle.com/epmos/faces/DocumentDisplay?id=1462240.1),  and "Oracle Upgrade BLOG" (https://blogs.oracle.com/upgrade/).

- Vídeo: https://medianetwork.oracle.com/video/player/4301086284001
- Oracle Doc: https://docs.oracle.com/database/121/UPGRD/toc.htm

- Oracle White Paper: http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf,

- Oracle Base sample: https://oracle-base.com/articles/12c/upgrading-to-12c

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, June 19, 5:15 AM

Cuestiones clave:

- Oracle 11.2 está en soporte extendido desde Enero 2015 (hasa 2018).

- No esperes a la "release 2" (12.2) pq con soporte extendido no tienes fix para determinados bugs q están resueltos en 12.1.

- script preupgrd.sql para comprobar si se cumplen los requisitos necesarios para hacer el upgrade.

- script catctl.pl permite ejecutar upgrade en paralelo, con lo q para una BD grande se puede reducir la duración de la actualización hasta un 40%.

- asistente gráfico DBUA (DB upgrade assitant), permite ejecutar los 2 scripts anteriores preupgrd.sql and catctl.pl.

- puedes actualizar haciendo "full transportable export", simplemente copiando tus datafiles. Más complejo q DBUA, pero puede ser mucho más rápido.

- Mas info: MOS note 1462240.1 (https://support.oracle.com/epmos/faces/DocumentDisplay?id=1462240.1),  y "Oracle Upgrade BLOG" (https://blogs.oracle.com/upgrade/).

- Vídeo: https://medianetwork.oracle.com/video/player/4301086284001

- Artículo Oracle en español: http://www.oracle.com/technetwork/es/articles/database-performance/upgrade-database-12c-parte-1-2089684-esa.html

- Oracle Doc: https://docs.oracle.com/database/121/UPGRD/toc.htm

- Oracle White Paper: http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf,

- Ejemplo en Oracle Base: https://oracle-base.com/articles/12c/upgrading-to-12c

 

Scooped by Juan Luis Serradilla
Scoop.it!

@sfonplsql Ideas for transforming your PL/SQL code

I presented a four hour workshop for GLOC15 (https://www.neooug.org/gloc/) in May 2015. I started with some very high level thoughts on what makes an
Juan Luis Serradilla's insight:

Thanks to Steven Feuerstein for shaing his deep knowledge and best practices with PL/SQL programming.

 

Ideas for transforming your PL/SQL code.

- PL/SQL Fundamentals

- First Questios and Key Building Blocks

- Write Maintainable Code

- Write Optimized Code

Puedes descargar el PDF de la presentación directamente desde:

https://community.oracle.com/servlet/JiveServlet/download/915011-2-163991/Make%20No%20Small%20Plans%20PDF.pdf

 

El código al que se hace referencia en la presentación puede encontrase en siguiente enlace:

http://www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, May 25, 5:26 AM

Aprende buenas prácticas de programación PL/SQL de la mano del maestro Steven Feuerstein

 

Scooped by Juan Luis Serradilla
Scoop.it!

Oracle SQL Developer 4.1 Tips & Tricks

Updated for version 4.1! This presentation shows features and preferences that will turbo-charge your database development experience in Oracle SQL Developer.

Juan Luis Serradilla's insight:

- SQL History (Ctrl+Up or Down).

- SQL Logging (View -> Log).

- Format Query Results directly to CSV, XML, JSON, etc (select /*json*/ ... from ...).

- Copying grids with column headers (Shift+Ctrl+c).

- Drag&Drop objects to editor.

- Drag&Drop objects to model.

- Viewing PL/SQL execution output (RefCursors)

- And more ...

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, May 12, 4:18 AM

- Histórico SQL (Ctrl+Arriba o Abajo).

- Log SQL (Ver -> Log).

- Formatear resultado de una consulta directamente como CSV, XML, JSON, etc (select /*json*/ ... from ...).

- Copiar el contenido de una tabla incluido el encabezado (Shift+Ctrl+c).

- Y más ...

Scooped by Juan Luis Serradilla
Scoop.it!

Do you want to learn all about Oracle PL/SQL?

Do you want to learn all about Oracle PL/SQL? | Administración de una Base de Datos Oracle | Scoop.it
Juan Luis Serradilla's insight:

Do you want to learn PL/SQL? Then just visit Oracle PL/SQL site and you will find everything you need (videos and docs from Steven Feuerstein's team): http://www.oracle.com/technetwork/database/application-development/plsql/overview/index.html

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, May 8, 6:07 AM

Si quieres aprender PL/SQL tan solo tienes q visitar la página oficial de Oracle PL/SQL

Scooped by Juan Luis Serradilla
Scoop.it!

Complex Wait Chain Signature Analysis with ash_wait_chains.sql

Here's a treat for the hard-core Oracle performance geeks out there - I'm releasing a cool, but still experimental script for ASH (or poor-man's ASH)-based wait
Juan Luis Serradilla's insight:

Thanks to Tanel Poder for sharing his Advanced Oracle Troubleshooting Guide, where he explains how V$WAIT_CHAINS view introduced in Oracle 11g is capable of showing chains of waiting sessions, but it is designed to diagnose relatively long-lasting hangs, not performance problems and short (but non-trivial) contention. So he thinks we need something different for performance analysis, and he has developed ash_wait_chains.sql script (http://blog.tanelpoder.com/files/scripts/ash/ash_wait_chains.sql)

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, April 29, 7:14 AM

La vista V$WAIT_CHAINS  (http://docs.oracle.com/cd/E18283_01/server.112/e17110/dynviews_3122.htm) nos permite listar los bloqueos de larga duración, pero ¿y si tenemos bloqueos de corta duración q no se registran en dicha vista? En tal caso nos toca echar mano de ASH, y además, el siguiente script de @tanelpoder nos puede dar información adicional muy interesante: http://blog.tanelpoder.com/files/scripts/ash/ash_wait_chains.sql

Scooped by Juan Luis Serradilla
Scoop.it!

Optimizing DBA working environment with SQLdeveloper

unshared
Juan Luis Serradilla's insight:

Thanks to Nikolay Savvinov for sharing some of the tricks he uses to optimize his DBA working experience with Oracle SQLdeveloper.

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, March 10, 6:23 AM

Algunos consejos para sacarle mayor partido a SQLdeveloper como herramienta para el DBA.

Scooped by Juan Luis Serradilla
Scoop.it!

Executing Dynamic PL/SQL Blocks

Juan Luis Serradilla's insight:

You're probably familiar with executing dynamic SQL statements. You can also dynamically construct, compile and execute PL/SQL blocks of code.

 

PDF slides: http://tutorials.plsqlchannel.com/public/Presentations/DYN5/DYN5.pdf

more...
No comment yet.
Scooped by Juan Luis Serradilla
Scoop.it!

ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql

ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql | Administración de una Base de Datos Oracle | Scoop.it
Since Oracle 9.2 the shared pool can be "partitioned" into multiple parts. This was probably done for relieving shared pool latch contention for crappy
Juan Luis Serradilla's insight:

Thanks to Tanel Poder for this interesting article and this useful script sgastatx.sql

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, February 26, 3:36 AM

Este artículo cuenta los detalles de como se organiza la Shared Pool en subpools, e incluye un script (http://blog.tanelpoder.com/files/scripts/sgastatx.sql) muy útil para consultar el estado de estos subpools. Tb habla del parámetro oculto "_kghdsidx_count" q define el nº de subpool, e incluye un while paper de Oracle http://www.oracle.com/technetwork/database/focus-areas/manageability/ps-s003-274003-106-1-fin-v2-128827.pdf() sobre los detalles de la gestión interna de la Shared Pool. Todo ello, enfocado hacia la resolución de problemas que provocan el conocido error ORA-04031.

Scooped by Juan Luis Serradilla
Scoop.it!

Comparing Execution Plans and Access vs. Filter Predicates

Comparing Execution Plans and Access vs. Filter Predicates | Administración de una Base de Datos Oracle | Scoop.it
Blogs.Oracle.Com - All Things SQL
Juan Luis Serradilla's insight:

Two short and interesting videos about "Comparing Execution Plans" and "Access vs Filter Predicates", with Oracle SQL Developer.

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, July 24, 7:42 AM

Aprende a comparar 2 planes de ejecución (y todos los datos de Autotrace) con Oracle SQL Developer; así como la diferencia que hay entre predicados de acceso (access predicates) y de filtrado (filter predicates).

Scooped by Juan Luis Serradilla
Scoop.it!

UNPIVOT saves the day

ORACLE-BASE - PIVOT and UNPIVOT Operators in Oracle Database 11g Release 1
Juan Luis Serradilla's insight:

Tim Hall shows us how the UNPIVOT operator converts column-based data into separate rows.

more...
No comment yet.
Scooped by Juan Luis Serradilla
Scoop.it!

Oracle OpenWorld Latin America 2015 - Presentaciones en PDF

Oracle OpenWorld Latin America 2015 - Presentaciones en PDF | Administración de una Base de Datos Oracle | Scoop.it
Oracle OpenWorld Latin America 2015 Content Catalog
Juan Luis Serradilla's insight:

Las presentaciones en PDF sobre Oracle Database que me han parecido más interesantes son:

 

1.- Best Practices to avoid ORA-01555: https://www.oracle.com/us/assets/lad-2015-usr17001-gomez-en-2604923.pdf

2.- Oracle Database Compression Best Practices: https://www.oracle.com/us/assets/lad-2015-ses16380-pedregal-2604876.pdf

 

En el ámbito de Sistemas también he encontrado interesantes:

 

3.- Enterprise Manager Snap Clone: https://www.oracle.com/us/assets/lad-2015-ses16172-wolf-2604860.pdf

4.- Best Practice Configuration Management with Puppet: https://www.oracle.com/us/assets/lad-2015-ses16404-viscaino-en-2604906.pdf

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, July 17, 7:59 AM

Presentaciones en PDF que nos han parecido más interesantes son:

 

1.- Best Practices to avoid ORA-01555: https://www.oracle.com/us/assets/lad-2015-usr17001-gomez-en-2604923.pdf

2.- Oracle Database Compression Best Practices: https://www.oracle.com/us/assets/lad-2015-ses16380-pedregal-2604876.pdf

3.- Enterprise Manager Snap Clone: https://www.oracle.com/us/assets/lad-2015-ses16172-wolf-2604860.pdf

4.- Best Practice Configuration Management with Puppet: https://www.oracle.com/us/assets/lad-2015-ses16404-viscaino-en-2604906.pdf

 

Scooped by Juan Luis Serradilla
Scoop.it!

Series of articles about the Oracle cost-based optimizer (CBO)

Series of articles about the Oracle cost-based optimizer (CBO) | Administración de una Base de Datos Oracle | Scoop.it
Update 9th July 2015:  part 4 now published.   I'm writing a series of articles about the cost-based optimizer for AllthingsOracle. My intention in this series is to present the optimizer with...
Juan Luis Serradilla's insight:

Many thanks to Jonathan Lewis for this series on Oracle’s Cost Based Optimizer, that it is aimed at the less experienced DBAs and developers to help them understand what the optimizer is trying to achieve, how it arrives at an execution plan, why it makes mistakes and, perhaps most importantly, how to recognize the source of those mistakes and so address the resulting problems in an appropriate fashion.

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, July 9, 7:57 AM

¿Quieres saber cómo funciona el CBO (Optimizador Basado en Costes) de Oracle?

Scooped by Juan Luis Serradilla
Scoop.it!

Oracle 12c Database In-Memory

Oracle 12c Database In-Memory | Administración de una Base de Datos Oracle | Scoop.it
Juan Luis Serradilla's insight:

 

Oracle Database In-Memory provides a unique dual-format architecture that enables tables to be simultaneously represented in memory using traditional row format and a new in-memory column format. The Oracle SQL Optimizer automatically routes analytic queries to the column format and OLTP queries to the row format, transparently delivering best-of-both-worlds performance. Oracle Database 12c automatically maintains full transactional consistency between the row and the column formats, just as it maintains consistency between tables and indexes today. The new column format is a pure in-memory format and is not persistent on disk, so there are no additional storage costs or storage synchronization issues.

 

New "In-Memory Column Store" SGA pool: https://docs.oracle.com/database/121/CNCPT/memory.htm#CNCPT89659

 

Using the "In-Memory Column Store": https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN14257

more...
Scooped by Juan Luis Serradilla
Scoop.it!

Hive tables with Data Modeler

Hive tables with Data Modeler | Administración de una Base de Datos Oracle | Scoop.it

Since version 4.0.2 Data Modeler has supported Hive tables, now in 4.0.3 also SQL Developer does that.

Juan Luis Serradilla's insight:

It means that at least you can:

– design Hive tables

– reverse engineer Hive tables

– create SQL queries on both Oracle tables and Hive tables

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, May 12, 4:11 AM

Since version 4.0.2 Data Modeler and since version 4.0.3 SQL Developer has been supporting Oracle Big Data SQL and Hive. This support allows you to connect to Hive and reverse engineer Hive tables. To be able to create a connection to Hive you must first download the JDBC drivers and connectors. Data Modeler supports both Hortonworks and Coludera implementations, SQL Developer only supports Cloudera. You can download the Cloudera JDBC Drivers from http://www.cloudera.com/content/cloudera/en/downloads.html.

 

Scooped by Juan Luis Serradilla
Scoop.it!

Latch free waits, Dynamic Statistics, and the Result Cache

Latch free waits, Dynamic Statistics, and the Result Cache | Administración de una Base de Datos Oracle | Scoop.it
Recently migrated Peoplesoft Campus Solutions database from 11.2.0.3 Solaris non-RAC non-ASM to 12.1.0.2 Linux ASM RAC (yes really, all at once). This is a mixed workload database, OLTP and Peoples...
Juan Luis Serradilla's insight:

Do you want to see a DBA in action? Just have a look to this really interesting post: https://dban00b.wordpress.com/2015/04/21/311/

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, May 8, 6:11 AM

Un DBA nos cuenta como ha resuelto un problema bastante complejo, después de migrar Oracle 11g sobre Solaris, a Oracle 12c en RAC sobre Linux. Muy interesante si quieres ver a un DBA en acción.

Scooped by Juan Luis Serradilla
Scoop.it!

The How, Why and What of Autotrace with SQLdeveloper

Blogs.Oracle.Com - All Things SQL
Juan Luis Serradilla's insight:

Autotrace helps us figure out where our SQL query are going wrong and what we need to do to optimize it. If you're not familiar with this tool, keep reading for a short video series showing you how to use it in SQL Developer, why you should do so instead of relying on explain plan and what to look for in the output.

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, May 8, 6:09 AM

Videotutoriales para aprender a usar Autotrace desde SQLdeveloper

Scooped by Juan Luis Serradilla
Scoop.it!

Mejorar el rendimiento PL/SQL en bucles LOOP con sentencias DML - Performance Anti-Patterns: Non-query DML inside loops

Lots of code follows patterns. Some of the patterns are good ones, some them are bad - and these we call "anti-patterns." In this video, Steven identifies a ...
Juan Luis Serradilla's insight:

Steven Feuerstein, expoerto en PL/SQL, nos muestra como detectar lo que él considera una mala práctica (Anti-Pattern) de programación en PL/SQL, en cuanto al rendimiento se refiere, como es la inclusión de sentencias DML en bucles (LOOP), algo muy habitual, de modo que él propone refactorizarlo mediante un proceso que diferencie claramente las 3 fases del procesamiento de datos:

 

1.- Extraer las filas sobre las que vamos a trabajar con BULK COLLECT y guardarlas en una colección.

 

2.- Procesar los datos en la colección, con los cambios que queremos llevar a la BD.

 

3.- Hacer las actualizaciones en BD desde los datos de la colección q ya tenemos ya preparada.

 

De este modo, al separar el acceso a BD del procesamiento sobre los datos, se mejora considerablemente el rendimiento del proceso, pues hay q tener en cuenta q  las sentencias DML dentro de un LOOP hacen q Oracle tenga q cambiar de contexto en cada ciclo del blucle, cambiando del motor PL/SQL al motor SQL de BD.

 

https://www.youtube.com/watch?v=lb4xu8qVuII

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, March 17, 8:28 AM

Cómo mejorar el rendimiento de tus bucles PL/SQL, separando la extracción de datos del procesamiento, y sobre todo de las actualizaciones en BD.

 

https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw

 

Scooped by Juan Luis Serradilla
Scoop.it!

Big Data: Hadoop and Oracle technologies explained

Big Data: Hadoop and Oracle technologies explained | Administración de una Base de Datos Oracle | Scoop.it
It turned out the be the first real talk that puts "Big Data" in the perspective it needs to be consumable and realistic.
Juan Luis Serradilla's insight:

Do you really know what Hadoop is? Do you know Oracle technologies related with Hadoop? Then I think you should read this post and the following slides about Mark Rittman talk in Oracle Usergroup Holland:

http://www.slideshare.net/rittmanmead/ogh-2015-hadoop-oracle-bda-and

 

If you want to work with Big Data for testing, please download the Big data light VM from OTN: http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html

 

more...
Sección de Metodologías de la Universidad de Murcia's curator insight, March 10, 6:25 AM

Lee esto si quieres saber qué es Hadoop y qué está haciendo Oracle en este sentido (Oracle Big Data).

Scooped by Juan Luis Serradilla
Scoop.it!

Database Development Web Series

Database Development Web Series | Administración de una Base de Datos Oracle | Scoop.it
Juan Luis Serradilla's insight:

Oracle Database Development Web Series is a weeky 1 hour information session. During the session, Oracle Experts will introduce topics ranging from SQL, PL/SQL, JAVA, Node, .NET and how to improve productivity by utilizing Development Tools like SQL Developer, Application Express and much more. Join us every Wednesday at Noon EST. Some sessions wil be recorded.

more...
No comment yet.