Question
What is your pga_aggregate_target (largest of all databases)?
Less than 500Mb
Less than 1Gb
Less than 2Gb
Less than 4Gb
Less than 8Gb
8Gb or larger
No idea or not applicable
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 51 now available
Jun 26, 2009
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 F. Pachot 129400
2 M. Cadot 127250
3 B. Vroman 98450
4 A. Kavsek 81750
5 Z. Hudec 59100
6 A. Deledda 44300
7 P. Wisse 39200
8 T. Boles 38300
9 V. Swamy 28925
10 J. Koyen 22600
About
DBA-Village
Site Statistics
Ever registered41110
Total active users25980
Act. users last 24h140
Act. users last hour8
Hits last week7278
Hits last month28483
Tips, Scripts, Papers, Events, Links, ...
Link:Oracle - Articles d'experts (in French)

Franck Pachot, Mar 07
Tip:Enable trace for asmcmd utility

anand chavan, Mar 07
Link: Convert Oracle Rac to Single Instance

anand chavan, Mar 07
Link:Oracle Real Application Clusters SIG

anand chavan, Feb 28
Link:Oracle Database Administrators Blog

Suvin Prathab, Feb 23
Latest Forum Threads
What kind of environment is there in MNC for Oracle DBA?

Hi guys,
I am new to this forum. I have completed OCP. I am looking forward to work in MNC. Earlie... (0 repl.)
Multiple databases on RAC Configuration Qustions

Hi Guru,

I need some advices from RAC guru.
I'm trying to configure the multiple databases on 2 ... (0 repl.)
get all

hi,

if we pass in parameter we get the result ,
here if the user does not pass any vaule to in p... (6 repl.)
Where to look about procedure progress

I have one procedure that is taking so much of time to get execute,So could anyody guide how can i m... (2 repl.)
Handling ORA-01555: in a procedure

Hi,

I have procedure to analyze all the tables in schema based on frequency column value.

whil... (7 repl.)
Database Link Creation

Hi

Can I create a database link in Oracle 10.2.0 to Oracle 9.2.0. If it is yes then please let m... (3 repl.)
Oracle Baseline(ing) - HOW

Hi all,

Can anyone please advise where to start in terms of creating a baseline for Oracle DBs?
... (1 repl.)
--> Start a new thread ...
Headlines
Sep, 01 Oracle 11g Release 2 now available for download
Jul, 19 New database patching strategy: Patch Set Updates
Jun, 26 PLATO Version 51 available
Apr, 20 Oracle buys Sun
Apr, 19 Public yum server for Oracle Enterprise Linux and Oracle VM
Apr, 19 Oracle Critical Patch Update April 2009 available

More ...
Imho
How do you tune your PGA? new
We use parameter and monitor v$pgastat as well, also every now and the...
Absolutely, I use the pga_aggregate_target parameter (and other target...
Yes, We do use this parameter. So far no issues
Yes , i am working o Oracle9i and 10g , and we use this parameter
We obviously use pga_aggregate_target and I throw and eye on v$pgastat...
We are using memory_target target in our envronment, so far no issues ...
Yes, we monitor its size. We have a "check" when this value goes beyon...

More...