05-22-2013
Hi os2mac,
nothing has changed in kernel parameters in /etc/system
Hi jim,
our DBA has logged call with Oracle and also shared the patches we applied last month to get a response from them. Lets wait and see what oracle has to say on this.
After checking logs, DBA could only confirm that there is very high Logical I/O activity. There is no wait I/O on the system and DBA also confirmed physical I/O is negligible from his logs.
Could it be that the high logical I/O is caused by some application defect ? Also we have lot of memory available on the system which is not used by oracle. Shall i ask DBA to increase SGA to include the free memory ? Will it help reduce the logical I/O. Any comments will be appreciated.
8 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
I have 4 solaris 8 servers running mysql 5.0.22. I am considering upgrading to solaris 9 and wanted to know if mysql needs to be recompiled for mysql to run under solaris 9.
Thank you (4 Replies)
Discussion started by: csgonan
4 Replies
2. Solaris
Please give me some idea about the impact of upgrading the SOLARIS OS from 5.6 to 5.8.
We are using object store database of version 5.1. will there be any impact on this.
Please help me in this regard.
Thanks in advance. (1 Reply)
Discussion started by: vamshikrishnab
1 Replies
3. Solaris
Does anyone get the following error message below when trying to download solaris 10 recommended patch?
End-of-central-directory signature not found. Either this file is not
a zipfile, or it constitutes one disk of a multi-part archive. In the
latter case the central directory and... (8 Replies)
Discussion started by: Sarccastik Dude
8 Replies
4. Solaris
Hello guys,
I have a question regarding link aggregation / trunking in Solaris 9
Sun Trunking does not come by default in Solaris 9 unlike Solaris 10 where we can use the "dladm" command to trunk 4 physical NIC interfaces together.
My question is in Solaris 9. Will the configurations of... (1 Reply)
Discussion started by: br1an
1 Replies
5. Solaris
Hello
I recently downloaded and installed the latest patchset for Solaris 10 (update 5) running on SPARC.
Actually I am new to Solaris (I come from Red Hat) and the security department asked me to update the system for security fixes.
I logged in to Oracle support and used the recommended patch... (3 Replies)
Discussion started by: abohmeed
3 Replies
6. Solaris
Dear All,
Has Oracle stopped updating Solaris 10 recommended patch cluster ? From suport.oracle.com i could see the last patch bundle was released on 11th july and there has been no updates after that.
Does anyone know about any official announcement from oracle on this ?
Thanks ... (1 Reply)
Discussion started by: abhi_8029
1 Replies
7. Solaris
Hi Gurus
I am not able to find the patching procedure for solaris 10 ( sol10 u11) to latest patchset with sun cluster having failover zones so that same I should follow.
Take an instance, there are sol1 and sol2 nodes and having two failover zones like sozone1-rg and sozone2-rg and currently... (1 Reply)
Discussion started by: nick101
1 Replies
8. Solaris
Hi Guys,
I'm looking to download the latest patche cluster, we install them on a monthly basis.
I have not seen anything released in the last couple months since January.
Did I miss an announcement?
Are they going to start releasing quarterly?
Or is it just so happening there are no... (2 Replies)
Discussion started by: BG_JrAdmin
2 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::sqlanywhere
DBIx::Class::Storage::DBI::SQLAnywhere(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::SQLAnywhere(3)
NAME
DBIx::Class::Storage::DBI::SQLAnywhere - Driver for SQL Anywhere
DESCRIPTION
This class implements autoincrements for SQL Anywhere and provides DBIx::Class::InflateColumn::DateTime support and support for the
"uniqueidentifier" type (via DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.)
You need the "DBD::SQLAnywhere" driver that comes with the SQL Anywhere distribution, NOT the one on CPAN. It is usually under a path such
as:
/opt/sqlanywhere11/sdk/perl
Recommended connect_info settings:
on_connect_call => 'datetime_setup'
METHODS
connect_call_datetime_setup
Used as:
on_connect_call => 'datetime_setup'
In connect_info to set the date and timestamp formats (as temporary options for the session) for use with
DBIx::Class::InflateColumn::DateTime.
The "TIMESTAMP" data type supports up to 6 digits after the decimal point for second precision. The full precision is used.
The "DATE" data type supposedly stores hours and minutes too, according to the documentation, but I could not get that to work. It seems to
only store the date.
You will need the DateTime::Format::Strptime module for inflation to work.
MAXIMUM CURSORS
A DBIx::Class application can use a lot of cursors, due to the usage of prepare_cached.
The default cursor maximum is 50, which can be a bit too low. This limit can be turned off (or increased) by the DBA by executing:
set option max_statement_count = 0
set option max_cursor_count = 0
Highly recommended.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::SQLAnywhere(3)