01-21-2011
Something to read:
http://h21007.www2.hp.com/portal/dow...rfCookBook.pdf
What hardware? What discs? Any SANs? Any NFS?
What version of Oracle?
The Oracle DBA should be able to give you detailed statistics for activity of the Oracle database engine and detailed statistics for activity of the Oracle session concerned.
It may just be reading millions of records without using an index ... or something like that. Look very closely for Oracle sorts - these are a notorious bottleneck with default Oracle SGA settings because they use disc if they have not been given enough memory.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello,
I have a mail server (sendmail) with SUNOS 5.5.1. Just recently it began to respond very slowly.
I used vmstat to check the performance data. Only interupt, system call and CPU context swiching are relatively high. Other statistics are normal, especially CPU utilization are very... (5 Replies)
Discussion started by: caoai
5 Replies
2. UNIX for Advanced & Expert Users
hi,
What is the difference between UBC cache and Metadata cache ? where can i find UBC cache Hits and Metadata cache Hits in hp-ux?
Advanced thanx for the help. (2 Replies)
Discussion started by: sushaga
2 Replies
3. Solaris
Hi All,
There is a virtual user "ecoouk" which logs on to the server and runs some scripts. I want to know how much server performance can I gain if I put off all the scripts run by this user.
Please tell me how to analyse how much resources a specific user is using.
Regards,
Abhishek (3 Replies)
Discussion started by: max29583
3 Replies
4. UNIX for Dummies Questions & Answers
I have a Teradata Machine, using MP-RAS Unix, with a 1000 Intel Ethernet card and a Cisco switch.
If I configure the ethernet card and the switch to auto, so they negotiate to 1000, or configure the ethernet card and switch manually to 1000Full or 100Full, the velocity is very very low.
Only... (2 Replies)
Discussion started by: cuatrodos
2 Replies
5. Emergency UNIX and Linux Support
This is a weird problem I've been butting my head against for days now...
I have two OpenVPN servers set up with identical configurations except for the keys. One of them is hosted in a datacenter with a large backbone, the other is hosted on my home server's limited residential internet. One... (9 Replies)
Discussion started by: Corona688
9 Replies
6. Linux
Hi all
I saw in Microsoft web site www.SysInternals.com a tool called CoreInfo from able to print out on screen the size of the Data and Instruction caches of your processor, the Locigal to Physical Processor mapping, the number of the CPU sockets. etc..
Do you know if in Linux is available a... (2 Replies)
Discussion started by: manustone
2 Replies
7. Linux
Hi All,
could any one point out any open source test-suites for "File cache" testing and as well as performance test suites for the same. Currently my system is up with Linux/ext4.
Regards
Manish (0 Replies)
Discussion started by: hmanish
0 Replies
8. Solaris
I have DNS Server running in solaris 10 .
There is website called exaple.com ,whcih was hosted in this dns server with IP 1.2.3.4 ,now we deleted the DNS entry of that website from our DNS Server (db.exmaple.com is deleted from named.conf ) and it is hosted with some other name server with IP... (1 Reply)
Discussion started by: sandeep.tk
1 Replies
9. OS X (Apple)
So I worked out a script for Mac OSX from an existing script. This script checks the versionnumber of a plugin and a package. If the plugin version is different from the package it has to update the plugin. The script works fine but the final check fails.
Here is my script:
#compare version... (6 Replies)
Discussion started by: mattiasvdm
6 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::oracle
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)
NAME
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
BuildDSN
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>
Read details in documentation for DBD::Oracle module.
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
InsertFromSelect
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
KnowsBLOBs
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
for inserts.
BLOBParams FIELD_NAME FIELD_TYPE
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
DistinctQuery STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
BinarySafeBLOBs
Return undef, as Oracle doesn't support binary-safe CLOBS
DatabaseVersion
Returns value of ORA_OCI constant, see "Constants" in DBI.
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
perl(1), DBIx::SearchBuilder
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)