Oracle VM Site Review - Oracle VM Health Check
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.

Paris Oracle Meetup (Jeudi 26 Mars 2015 @ 7pm)

A quick post to say that this week, on Thursday 26th, I will be giving a talk (in English!) on the subject of Flash for DBAs (and architects, designers, developers, managers etc) at the Paris Oracle Meetup:

Low EST_PGA_CACHE_HIT_PERCENTAGE

Hi Friends,

While analysing the AWR report of Oracle 11g, In PGA TARGET Advisory i found low est_pga_cache_hit_percentage at size_factor =1.

If I increase the PGA_AGGREGATE_TARGET size will it improve the performance of the queries that accessing SORT/MERGE/HASH paths.

or

Should i found the queries accessing SORT/MERGE/HASH paths and tune them?

Which will be preferred one. Will that application to Dataware-house also?
please suggest.

Thanks & Regards,
Saranya

Public appearances 2015

This is going to be a list of my public appearances in 2015.

Upcoming Events

Paris Oracle Meetup

Enable/Disable SSH For Root User

Sometimes for any reason you want to enable root ssh using any SSH Client such as putty and only the administrator can login to do this follow the below steps :-

Oracle Performance

Hello

Please I am actually using a new server on Linux Redhat with 32G (64 bits) .
I need some advice to increase performance since my rman takes Now 2 hours
instead of 1 hour before when I was on 16G

See below pfile details

Code:

rwddb.__db_cache_size=1577058304
rwddb.__java_pool_size=33554432
rwddb.__large_pool_size=16777216
rwddb.__shared_pool_size=335544320
rwddb.__streams_pool_size=16777216

Big Data with Hadoop Training

Introduction

We have some exciting news for you. We are starting the Big Data with Hadoop training program and Srini Ramineni will be the faculty for this course. Srini Ramineni is the founder of DBA University and has rich experience in the IT industry in USA managing both relational databases as well as Big Data with Hadoop environments. He also has completed a graduate degree credit

12c Parallel Execution New Features: Concurrent UNION ALL - Part 3

In the final part of this instalment I want to focus on the possible optimisation of remote access that I outlined in the initial part, which is based on the idea of running multiple concurrent remote branches of a UNION ALL to overcome the query coordinator bottleneck of straightforward remote queries that need to transfer larger amounts of data.For that purpose I now simply change my sample query to access the serial table T2 via the DB link defined in the setup of the initial pa

Setting up SQL Developer with Instant Client on MacOSX

Since I started a new job I also wanted to try out MacBook as my new laptop. I've never been a Mac user, but there seems to be a large group of people who think Macs are the best, so I needed to find out the goodness of Macs myself :) A quick tip: Don't upgrade to Yosemite if you laptop is bound to Active Directory.

SQLDeveloper XML Extensions and auto-navigation

It’s official, England are now the second best cricket team in the British Isles !
After all, Scotland were dispatched with ease and as for Wales…they didn’t even make it to the Cricket World Cup.
OK, technically they did because they’re part of England for the purposes of cricket…although you’d be hard pressed to get them to admit it.
Ireland are, of course, some way in front having actually managed to actually win the odd game against Test Playing Nations.

What’s this ‘WHERE 1=1′?

Since some time I have been adding WHERE 1=1 to all my queries.
I get queries like this:

SELECT *
  FROM emp e
 WHERE 1=1
   AND e.ename LIKE 'A%'
   AND e.deptno = 20

Lots of people ask me what’s the use of this WHERE 1=1.

You know I like to type as little as possible but here I am typing a lot of extra characters. And yet, it makes my development life a lot easier.

view counter