Is it possible to tune Pro*C programs. These are written in Unix environment. If there is a way please explain in detail.
http://www.experts-exchange.com/Database/Oracle/Q_10060254.html
Zones:
OracleDate Answered: 06/27/1998 Rating: 7.6 Views: 0
Any suggestions (or ref pages) to shorten the excution time when construcinting a SQL?
Or
Are there major factors to consider (e.g. number of table to be cross-joined) that affect db performance?
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20083577.htm...
Zones:
ASPDate Answered: 03/04/2001 Rating: 7.4 Views: 0
How can I monitor the CPU usage and HD/Memory Activities under AIX Unix environment (like WINNT's Task Maanager)?.
I remember that those informance can be shown under X-windows, but how can I ...
http://www.experts-exchange.com/OS/Unix/Setup/Q_20113230.html
Zones:
Unix SetupDate Answered: 07/01/2004 Rating: 7.0 Views: 0
1) Is indexing the only method to increase performance of select, delete, update and insert queries where ever where & order by clauses are used.
2) How much difference does it make if we do or ...
http://www.experts-exchange.com/Database/DB2/Q_20702914.html
Zones:
DB2Date Answered: 08/13/2003 Rating: 9.6 Views: 0
I run a very busy web server with 4000+ domains of which about 10% of them are very active. The tech specs:
1. RH 7.1 + Apache 1.3
2. Dual 1 GHz PIII
3. 4 GB ECC RAM
4. Dual 74 GB SCSI
Ma...
http://www.experts-exchange.com/OS/Linux/Administration/Q_20960875.html
Zones:
Linux AdminDate Answered: 04/15/2005 Rating: 7.6 Views: 0
Hi ALl Application server experts
My connection pool settings are
Steady size 8
Max size 32
Resize - 0
idle-time-out 0
Max -wait -time -0
Is it a valid connection pool setting
...
http://www.experts-exchange.com/Software/Server_Software/Application_Servers/Q_21028503.ht...
1) We used Quest DB2 SQL Optimizer tool to tune our queries.
2) We have DB2 8.1.4 AIX 5.1 DB2/6000
3) The tool suggested many queries with coalesce on columns on either/single side of some j...
http://www.experts-exchange.com/Database/DB2/Q_21215775.html
Zones:
DB2Date Answered: 12/19/2004 Rating: 9.4 Views: 0
I have a couple of long running queries (~5 minutes) that are used for reports. The queries are pretty badly written, I think with minimal effort I can cut them down significantly.
The Boss-man...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_22683470.html
Hello,
J'ai une base de Données en 9010 hpux PARIC où le process checkpoint est très lent ( 20mn pour termnier l'operation ).
je veux modifier mes valeurs log_checkpoint_interval et fast_star...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23015282.html
We have a 10g database and having problem in keeping temp tablespace free. Any time it gets full it does not release the space back. We restarted the services but it still does not. I already creat...
http://www.experts-exchange.com/Database/Oracle/Q_24047822.html
