view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

ASH visualized in R, ggplot2, Gephi, Jit, HighCharts, Excel ,SVG

There is more and more happening in the world of visualization and visualizing Oracle performance specifically with v$active_session_history.
Of these visualizations,  the one pushing the envelope the most is Marcin Przepiorowski. Marcin is responsible for writing S-ASH , ie Simulated ASH versions 2.1,2.2 and 2.3. See

Solid Conference San Francisco 2014: Complete Video Compilation

Solid Conference focused on the intersection of software and hardware. It's great community with Software and Hardware.

Create Windows Service for Oracle RAC

It’s my first time on RAC system for Windows and I’m happy to learn something new to share.

I created a new service for database (restoredb) only to find out the ORACLE_HOME is for the service is “c:\oracle\product\10.2.0\asm_1″

Any ideas as to what was wrong?

How SQL Server Browser Service Works

Some of you may wonder the role SQL browser service plays in the SQL Server instance. In this blog post, I’ll provide an overview of the how SQL Server browser plays crucial role in connectivity and understand the internals of it by capturing the network monitor output during the connectivity with different scenario.

Oracle Database 12.1.0.2.0 – Turning OFF the In-Memory Database option

So how to turn it the option off/disabled…As a privileged database user: > Just don’t set the INMEMORY_SIZE parameter to a non zero value…(the default...
class="readmore"> class="more-btn" href="http://www.liberidu.com/blog/2014/07/29/oracle-database-12-1-0-2-0-turning-off-the-in-memory-database-option/">Read More

SQL Saturday in Paris on 12 -13 September

As you certainly know SQL Saturday events are very popular in SQL Server world community. This is the second time the event takes place in Paris (France), but this time, we have a new format with pre-conferences on Wednesday and classic sessions on Saturday. During pre-conferences, we will talk about a particular subject fo

12c and export/import from a lower version

There is a serious problem with export/import utilities between versions.
The first command, executed on Oracle 11.2.0.4, Linux x86_64 was:

[oracle@oradb tmp]$ expdp system directory=tmp dumpfile=oe.dmp schemas=oe
logfile=oe.log
Directory tmp was created as /tmp
Result was the following:
Export: Release 11.2.0.4.0 – Production on Mon Jul 28 22:57:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
reserved.
Password:

Impugn My Character Over Technical Points–But You Should Probably Be Correct When You Do So. Oracle 12c In-Memory Feature Snare? You Be The Judge ‘Cause Here’s The Proof.

Executive Summary

This blog post offers proof that you will trigger In-Memory Column Store feature usage with the default INMEMORY_* parameter settings.

auto-generate SQLAlchemy models

PyOhio gave my lightning talk on ddlgenerator a warm reception, and Brandon Lorenz got me thinking, and PyOhio sprints filled my with py-drenaline, and now ddlgenerator can inspect your data and spit out SQLAlchemy model definitions for you:

view counter