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 M. Cadot 128050
2 F. Pachot 128000
3 B. Vroman 98450
4 A. Kavsek 81650
5 Z. Hudec 59200
6 A. Deledda 44300
7 P. Wisse 39000
8 T. Boles 38300
9 V. Swamy 28925
10 J. Koyen 22100
About
DBA-Village
Site Statistics
Ever registered41105
Total active users25979
Act. users last 24h218
Act. users last hour3
Hits last week7594
Hits last month28543
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
help using SQL Loader

Hi,

We actually have an external table define with :

<pre>
CREATE TABLE "SIC"."PAIE"
... (0 repl.)
Performance Tuning

Hi Guru,

Please tell me how to start performance tuning practics? and tell me steps for tuning .... (0 repl.)
Check database is up or not -- every 10MS

Hi,

We are looking free tool to ping databases (Oracle & SQL) every 10ms to see they are up or we... (0 repl.)
Leading Table

Dears,
How to find the leading table from Explain plan out put.

Regards,
Nikhita (3 repl.)
DR Rebuild - Data restore issue

Hi Experts,

While doing DR rebuild ( physical standby ), after restoring standby controlfile in D... (3 repl.)
Oracle 10g Production Server Crash PLZ Help

Hi,
Our database server has been crashed. Aix and Oracle database need to install on another Ser... (7 repl.)
MySQL

Hi,

Can anyone recommend good book for MySQL that write for Oracle DBA to learn quick?
(2 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
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...
usually using scripts to monitor it http://www.dba-oracle.com/oracl...
Well, we are using pga parameters on 9i and 10g. usually, I just put a...
Yes, we use pga_aggregate_target parameter since 9i but do not monitor...

More...