Re: Changing from Informix to Oracle

From: Boscia <rwboscia@worldnet.att.net> > >onstat - >Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days >06:48:25 -- 901120 Kbytes > > >onstat -c >PHYSDBS logs # Location (dbspace) of physical log >PHYSFILE 10000 # Physical log file size (Kbytes) Seems a bit small? >TBLSPACE_STATS 1 Set to 0. ># System Archive Tape Device > >TAPEDEV /home/informix/tape/tapelog # Tape device path >TAPEBLK 16 # Tape block size (Kbytes) >TAPESIZE 10240 # Maximum amount of data to put on Bit small? ># Log Archive Tape Device > >LTAPEDEV /home/informix/tape/ltapelog # Log tape device path >LTAPEBLK 16 # Log tape block size (Kbytes) >LTAPESIZE 10240 # Max amount of data to put on log Bit small? >RESIDENT 1 # Forced residency flag (Yes = 1, No Try -1. ># Shared Memory Parameters > >LOCKS 150000 # Maximum number of locks >BUFFERS 400000 # Maximum number of shared buffers Seems a bit low. Try 768000 >NUMAIOVPS 12 # Number of IO vps >PHYSBUFF 64 # Physical log buffer size (Kbytes) >LOGBUFF 64 # Logical log buffer size (Kbytes) What is the output from onstat -l >CLEANERS 32 # Number of buffer cleaner processes Try 127. >SHMVIRTSIZE 8192 # initial virtual shared memory segment>size >SHMADD 8192 # Size of new shared memory segments What hardware is this? >LRUS 32 # Number of LRU queues Try 127. >LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning Try 2 >LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning Try 1 >RA_PAGES 64 # Number of pages to attempt to read Try 32 >RA_THRESHOLD 60 # Number of pages left before next Try 28 >OPTCOMPIND 2 # To hint the optimizer Try 0 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Hardware is Sun E10K onstat -l Informix Dynamic Server Version 7.31.UC5 -- On-Line (CKPT REQ) -- Up 13 days 15:42:03 -- 901120 Kbytes Blocked:CKPT Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 0 32 4260622 135232 31.51 phybegin physize phypos phyused %used 25b90d 5000 1560 1390 27.80 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 32 566956 46276 33302 12.3 1.4 Subsystem numrecs Log Space used OLDRSAM 566956 34898020 address number flags uniqid begin size used %used a80a2a4 2 U-B---- 682 200035 5000 2716 54.32 a80a2c0 3 U-B---- 683 2013bd 5000 5000 100.00 a80a2dc 4 U-B---- 684 202745 5000 5000 100.00 a80a2f8 5 U-B---- 685 203acd 5000 3779 75.58 a80a314 6 U-B---- 686 204e55 5000 5000 100.00 a80a330 7 U-B---- 687 2061dd 5000 5000 100.00 a80a34c 8 U-B---- 688 207565 5000 2594 51.88 a80a368 9 U-B---- 689 2088ed 5000 5000 100.00 a80a384 10 U-B---- 690 209c75 5000 5000 100.00 a80a3a0 11 U-B---- 691 20affd 5000 1752 35.04 a80a3bc 12 U-B---- 692 20c385 5000 5000 100.00 a80a3d8 13 U-B---- 693 20d70d 5000 5000 100.00 a80a3f4 14 U-B---- 694 20ea95 5000 2978 59.56 a80a410 15 U-B---- 695 20fe1d 5000 5000 100.00 a80a42c 16 U---C-L 696 2111a5 5000 4713 94.26 a80a448 17 U-B---- 622 21252d 5000 5000 100.00 a80a464 18 U-B---- 623 2138b5 5000 5000 100.00 a80a480 19 U-B---- 624 214c3d 5000 5000 100.00 a80a49c 20 U-B---- 625 215fc5 5000 5000 100.00 a80a4b8 21 U-B---- 626 21734d 5000 5000 100.00 a80a4d4 22 U-B---- 627 2186d5 5000 5000 100.00 a80a4f0 23 U-B---- 628 219a5d 5000 5000 100.00 a80a50c 24 U-B---- 629 21ade5 5000 5000 100.00 a80a528 25 U-B---- 630 21c16d 5000 5000 100.00 a80a544 26 U-B---- 631 21d4f5 5000 5000 100.00 a80a560 27 U-B---- 632 21e87d 5000 5000 100.00 a80a57c 28 U-B---- 633 21fc05 5000 5000 100.00 a80a598 29 U-B---- 634 220f8d 5000 5000 100.00 a80a5b4 30 U-B---- 635 222315 5000 5000 100.00 a80a5d0 31 U-B---- 636 22369d 5000 5000 100.00 a80a5ec 32 U-B---- 637 224a25 5000 5000 100.00 a80a608 33 U-B---- 638 225dad 5000 5000 100.00 a80a624 34 U-B---- 639 227135 5000 5000 100.00 a80a640 35 U-B---- 640 2284bd 5000 5000 100.00 a80a65c 36 U-B---- 641 229845 5000 5000 100.00 a80a678 37 U-B---- 642 22abcd 5000 5000 100.00 a80a694 38 U-B---- 643 22bf55 5000 5000 100.00 a80a6b0 39 U-B---- 644 22d2dd 5000 5000 100.00 a80a6cc 40 U-B---- 645 22e665 5000 1686 33.72 a80a6e8 41 U-B---- 646 22f9ed 5000 5000 100.00 a80a704 42 U-B---- 647 230d75 5000 5000 100.00 a80a720 43 U-B---- 648 2320fd 5000 5000 100.00 a80a73c 44 U-B---- 649 233485 5000 5000 100.00 a80a758 45 U-B---- 650 23480d 5000 5000 100.00 a80a774 46 U-B---- 651 235b95 5000 5000 100.00 a80a790 47 U-B---- 652 236f1d 5000 5000 100.00 a80a7ac 48 U-B---- 653 2382a5 5000 5000 100.00 a80a7c8 49 U-B---- 654 23962d 5000 5000 100.00 a80a7e4 50 U-B---- 655 23a9b5 5000 5000 100.00 a80a800 51 U-B---- 656 23bd3d 5000 5000 100.00 a80a81c 52 U-B---- 657 23d0c5 5000 5000 100.00 a80a838 53 U-B---- 658 23e44d 5000 5000 100.00 a80a854 54 U-B---- 659 23f7d5 5000 5000 100.00 a80a870 55 U-B---- 660 240b5d 5000 5000 100.00 a80a88c 56 U-B---- 661 241ee5 5000 5000 100.00 a80a8a8 57 U-B---- 662 24326d 5000 5000 100.00 a80a8c4 58 U-B---- 663 2445f5 5000 5000 100.00 a80a8e0 59 U-B---- 664 24597d 5000 5000 100.00 a80a8fc 60 U-B---- 665 246d05 5000 5000 100.00 a80a918 61 U-B---- 666 24808d 5000 5000 100.00 a80a934 62 U-B---- 667 249415 5000 5000 100.00 a80a950 63 U-B---- 668 24a79d 5000 5000 100.00 a80a96c 64 U-B---- 669 24bb25 5000 5000 100.00 a80a988 65 U-B---- 670 24cead 5000 5000 100.00 a80a9a4 66 U-B---- 671 24e235 5000 5000 100.00 a80a9c0 67 U-B---- 672 24f5bd 5000 5000 100.00 a80a9dc 68 U-B---- 673 250945 5000 1493 29.86 a80a9f8 69 U-B---- 674 251ccd 5000 5000 100.00 a80aa14 70 U-B---- 675 253055 5000 5000 100.00 a80aa30 71 U-B---- 676 2543dd 5000 3256 65.12 a80aa4c 72 U-B---- 677 255765 5000 5000 100.00 a80aa68 73 U-B---- 678 256aed 5000 5000 100.00 a80aabc 76 U-B---- 679 257e75 5000 2511 50.22 a80aad8 77 U-B---- 680 2591fd 5000 5000 100.00 a80aaf4 78 U-B---- 681 25a585 5000 5000 100.00 ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com