Re: Oracle gurus? NEED HELP!

From: David Ballester - Kern Pharma (dballester_at_kernpharma.com)
Date: 09/30/05

  • Next message: Roger Deschner: "Forbid attachments on AIX-L list?" 
    Date:         Fri, 30 Sep 2005 09:57:11 +0200
To: aix-l@Princeton.EDU

    El jue, 29-09-2005 a las 07:33 -0400, Dave Zarnoch escribió:
    > Folks,
    >
    > Any Oracle gurus out there?
    >
    > What should "tunables" be set for Oracle 9i?
    > Should there be any additional tunable paramaters set?
    >
    > System info:
    >
    > System Model: IBM,7026-6H1
    > Processor Type: PowerPC_RS64-III
    > Number Of Processors: 4
    > Processor Clock Speed: 451 MHz
    > CPU Type: 64-bit
    > Kernel Type: 64-bit
    > LPAR Info: -1 NULL
    > Memory Size: 4096 MB
    > Good Memory Size: 4096 MB
    > Firmware Version: IBM,M2P020910
    > Total Paging Space: 2048MB
    > OS level 5.2.3
    >
    > Thanks!
    >
    > Dave Zarnoch
    > Nationwide Provident
    > zarnocd@nationwideprovident.com
    > W 302-452-4197
    > C 302-462-8703

    May be better first talk about what is going wrong, what type of
    database you have ( ¿datawarehouse?, ¿intensive online transactions? ),
    type of hard disks ( ¿SSA?, ¿SAN environment?, ¿SCSI local?).

    But take this in mind:

    All is 'tunable', Operative System, disk access, network, memory... but
    the best optimization for the highest database health is a good coded
    application. And it's really difficult to obtain a good coder this
    days... :(

    Regards

  • Next message: Roger Deschner: "Forbid attachments on AIX-L list?"