Performance Tuning

Comment

Comment by Pierre Reynes on March 22, 2013 at 3:35pm

Find performance tuning recommendations and best practices in the Oracle Optimized Solutions. Go to http://www.oracle.com/oos  and select the application.

Comment by Sunny Therron on January 16, 2013 at 9:44am

Exciting EBS SCM ( Demand to Build) Consultant Contractual requirement at California,for details please visit http://t.co/JqcI9ZrK

Comment by Muhammad Abdul Halim on January 31, 2012 at 5:15am

how to show a string as a ROW in oracle database query?

Comment by http://linux-oracle-dba.blogspot on December 10, 2009 at 2:58am

Find the help for DBAS on(RAC , RMAN , DR , PT)
Latest series of post: oracle Clusterware and RAC installation.

http://linux-oracle-dba.blogspot.com/

Best blog for mid-level Oracle DBAs and Aspirants \0/
Please give us suggestion to make it better!!

Thanks
Have a nice day !!!

Comment by Ignacio Ruiz on July 16, 2009 at 12:06am

Hi Prasanna, your question definitely needs more inputs, and even with that you may get a rough estimation.
1) Is this an OLTP or Datawarehouse DB?
2) How many users will be using *concurrently* your database?
3) How many data (average) every user access at a given time?
4) Do you have all SQLs that will run on this database?
(you'll need that to know data usage habits)
5) most accessed data structures (tables and indexes)
6) "On use" Data window, I'll elaborate on this: you may have 15TB but only use 500Gb frequently, 2Tb rarely and 12.5Tb never... your "on use" data window is 2.5Tb or i.e. data corresponding to 1 calendar year.
OR
You may start small, implement some capacity measurement stats gather and elaborate projections to forecast 2 or 3 years infrastructure growth, specifically RAM and CPU.
What everybody uses? none of them, just throw more hardware everytime you get the roof on mem/cpu usage...nice!!!

Comment by Prasanna Sahu on July 15, 2009 at 2:56am

Now I m using …oracle 10g Database .Now the database is going to use for 50 users . everyday the uploading data into the database is 10gb ..now I have 3 tb space I planning to go for 15 tb . so what kind of h/w can I choose in terms of ram and processor and another relative things...

pls reply as soon as posible

Comment by Razib Ahamed Khan on February 1, 2009 at 12:57am

http://www.dbahome.blogspot.com

Comment by Ghayas on December 21, 2008 at 1:48am

Any one know how to add Band varable in quarry??

Comment by daryanto eko on November 20, 2008 at 6:51pm

Hai all i'm newbee here..i'd like to ask how to view performance metric in 10g, thanks