10-12-2009
Oracle 9.2.0.1.0 on AIX 5300-07
Seek help from all of the experts here.
Database Oracle 9.2.0.1.0 run on AIX 5300-07.
The system is running so slow that sometime 1 click of changing screen will take more than 5 minutes.
The hardware in this LPAR is 6CPUs, 21GB-RAM, 42GB-Paging and run on p570 server POWER 5+.
And the vmo setting is as below where
minperm = 3%, maxperm=90%, maxclient=90%, lru_file_repage=0 and lru_poll_interval = 10.
With the Oracle init.ora is as below:
*.aq_tm_processes=1
*.background_dump_dest='/app/oracle/admin/PROD/bdump'
*.compatible='9.2.0.1.0'
*.control_file_record_keep_time=7
*.control_files='/data05/control01.ctl','/data10/control02.ctl','/data07/control03.ctl'
*.core_dump_dest='/app/oracle/admin/PROD/cdump'
*.cpu_count=6
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_cache_advice='OFF'
*.db_cache_size=3674210304
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_files=300
*.db_name='PROD'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)'
*.dml_locks=4860
*.enqueue_resources=5124
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='PROD'
*.java_pool_size=15286400
*.job_queue_processes=10
*.large_pool_size=576777216
*.log_buffer=2048000
*.log_checkpoint_interval=10000000
*.log_checkpoint_timeout=0
*.log_checkpoints_to_alert=TRUE
*.max_enabled_roles=120
*.open_cursors=2000
*.db_writer_processes=4
*.pga_aggregate_target=2007986918
*.processes=1500
*.log_archive_dest_2='location=/data11/arch'
*.log_archive_dest_1='location=/data06/arch'
*.log_archive_dest_3='service=hlarep reopen=60 optional arch'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_dest_state_3=DEFER
*.remote_archive_enable=send
*.log_archive_start=TRUE
*.query_rewrite_enabled='TRUE'
*.remote_dependencies_mode='SIGNATURE'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.session_cached_cursors=500
*.sga_max_size=8176279568
*.shared_pool_reserved_size=247815065
*.shared_pool_size=1503013120
*.sort_area_size=4194304
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.transactions=2000
*.undo_management='AUTO'
*.undo_retention=600
*.undo_suppress_errors=TRUE
*.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/app/oracle/admin/PROD/udump'
*.utl_file_dir='/data06/utlfiles'
*.workarea_size_policy='AUTO'
*.optimizer_index_cost_adj=100
*.optimizer_index_caching =70
*.audit_trail=DB
*.disk_asynch_io=TRUE
*.dg_broker_start=true
*.lock_sga=true
May I know what is wrong with all these setting? Is there anything on O/S or Database setting that is wrong which affect the slowness?
As I know from my DBA, the Database only using 8GB of memory and I do not understand why it can't use all 21GB of them.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
what is the reason oracle is giving ora-600 space leak error?
how to rectify this error? (6 Replies)
Discussion started by: varadakumar
6 Replies
2. UNIX for Advanced & Expert Users
Hi @all
Who's able to help me?
I've a running Oracle DB on AIX 4.3.3.
You've also an Oracle Client running for this.
So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things,
but it doesn't work. Thanks a lot!
Regards
Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies
3. AIX
Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run"
and i can't start the installation of ORACLE 9i...
see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies
4. AIX
Hi All,
I need to update some AIX servers from 5.2 to 5.3 OR 6.1 .
The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 .
I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies
5. AIX
Please read my issue!
My old server using:
- AIX system operating (5300-05-CSP-0000)
- WebSphere 6.1.0.21 (Fix Pack 21)
After I've upgraded version AIX
- AIX system operating (5300-09-02-0849)
- WebSphere 6.1.0.21 (Fix Pack 21)
I have 1 issue when I access home page:
"Error... (0 Replies)
Discussion started by: gamonhon
0 Replies
6. AIX
I have two IBM_9110-51A boxes
OS - fresh installs
5764-G03 TL 5300-10-00 disks dated 5/2009
HACMP - fresh installs
HACMP for AIX 5L Base V5.4 5765-F62 dated 7/2006
Bottom line for smit output attempting 2 node cluster config
... (2 Replies)
Discussion started by: DrKillPatient
2 Replies
7. AIX
Hi All,
I have this fix for AIX (5300-06-06-0811) and i need to install it.
How can i do this?
What are the prerequisites for this fix?
Thanks (1 Reply)
Discussion started by: lucaxvu
1 Replies
8. AIX
Hi,
we need to upgrade from aix 5.3 oracle 9 to aix 6.1 oracle 11.
Our base interest is on vmo and disk setup
On aix 5.3 we change lru_file_repage to 0.
We split disk layout ( emc cx4 ) to tree volume groups:
- one for data base files ( one filesystem over two lun/hdiskpower, block size... (5 Replies)
Discussion started by: prebila
5 Replies
9. AIX
I'm having this trouble when smit update_all.
==========================================================
MISSING REQUISITES: The following filesets are required by one or more
of the selected filesets listed above. They are not currently installed
and could not be found on the... (5 Replies)
Discussion started by: liberatti
5 Replies
10. AIX
Hello All,
I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO.
They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache.
To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies
LEARN ABOUT DEBIAN
apache::session::store::oracle
Apache::Session::Store::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Store::Oracle(3pm)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.10.1 2010-10-18 Apache::Session::Store::Oracle(3pm)