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.
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?
Thanks & Regards,
This is going to be a list of my public appearances in 2015.
|Paris Oracle Meetup|
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 :-
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
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
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
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.
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.
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
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.