Sponsored Content
Operating Systems AIX ORACLE Database running slow on AIX ( nmon / topas ) Post 302444168 by filosophizer on Wednesday 11th of August 2010 05:26:53 AM
Old 08-11-2010
Upgrade memory or Processor

This is an old machine running AIX 5.2 on P4

running an ORACLE Query and then running the command

sar 1 20

gives the idle time between 1 - 20

otherwise the idle time is 99

The memory is 4GB

How to know if it is processor issue or upgrading memory from 4GB to 16GB will speed up the ORACLE Queries.

As far as I know all the processing takes place in the memory.
 

8 More Discussions You Might Find Interesting

1. AIX

Memory usage statistic? (topas, nmon)

hi, how can i diplay: - the ammount RAM used /free - ammount of ram used from a pid or prozess we have the problem, that malloc is returing a NULL pointer errno = 12 ( not enough space). but i think there is still ram free. nmon : shows all memory used ? Memory Use Physical Virtual... (7 Replies)
Discussion started by: Lazzar
7 Replies

2. Filesystems, Disks and Memory

skgpspawn failed running oracle db 9.2.0.5.0 on aix 5.3

Hi, I am running an oracle db 9.2.0.5.0 on ibm p5 550 aix 5.3 with 10g ram, 10G swap space 3 database instances each SGA about 500Meg. I am getting the following error in my alert log file from time to time: skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3 ... (0 Replies)
Discussion started by: hawkerpacific
0 Replies

3. AIX

nmon vs topas

good morning what is the better solution to examen a P570 ? because i use topas and nmon, and the results are totally different !!! with nmon, i have 80% free cpu, and with nmon, i have 90% of used cpu !!!!!! i take a shot with an intervall of 10s during 10 mn. thank you (0 Replies)
Discussion started by: pascalbout
0 Replies

4. AIX

Top command in AIX 4.2 (no topas, no nmon, no top)?

Is there a 'top' command equivalent in AIX 4.2 ? I already checked and I do not see the following ones anywhere: top nmon topas (1 Reply)
Discussion started by: Browser_ice
1 Replies

5. Solaris

what is the command to see which database ie..oracle in running on solaris 10

what is the command to see which database ie..oracle in running on solaris 10 (2 Replies)
Discussion started by: tv.praveenkumar
2 Replies

6. Shell Programming and Scripting

Running script automatically when threshold limit met in one of the field in oracle database

Hi Guys, Need you help in one point! I am working on one shell script which takes following steps : 1. Taking one query result from oracle database 2. Exporting that result to Xls file 3. Mailing that file to my own mail ID Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies

7. AIX

Need to check long running processes on the database server and the os is AIX

Hello, Please help me with a script with which I can check long running processes on the database server and the os is AIX. Best regards, Vishal (5 Replies)
Discussion started by: Vishal_dba
5 Replies

8. AIX

AIX server running very slow

Hello, All the commands on AIX are running very slow. Below is few stats but I didn't find any issue in cpu or memory reosurces vmstat System configuration: lcpu=4 mem=6144MB ent=1.00 kthr memory page faults cpu ----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
condor_stats(1) 					      General Commands Manual						   condor_stats(1)

Name
       condor_stats Display - historical information about the Condor pool

Synopsis
       condor_stats [-f filename] [-orgformat] [-pool centralmanagerhostname[:portnumber]] [time-range] query-type

Description
       condor_stats  displays  historic  information  about a Condor pool. Based on the type of information requested, a query is sent to the con-
       dor_collectordaemon, and the information received is displayed using the standard output. If the -foption is used, the information will	be
       written to a file instead of to standard output. The -pooloption can be used to get information from other pools, instead of from the local
       (default) pool. The condor_stats tool is used to query resource information (single or by platform), submitter and  user  information,  and
       checkpoint  server  information. If a time range is not specified, the default query provides information for the previous 24 hours. Other-
       wise, information can be retrieved for other time ranges such as the last specified number of hours, last week, last month, or a  specified
       date range.

       The information is displayed in columns separated by tabs. The first column always represents the time, as a percentage of the range of the
       query. Thus the first entry will have a value close to 0.0, while the last will be close to 100.0. If the  -orgformatoption  is	used,  the
       time is displayed as number of seconds since the Unix epoch. The information in the remainder of the columns depends on the query type.

       Note that logging of pool history must be enabled in the condor_collectordaemon, otherwise no information will be available.

       One query type is required. If multiple queries are specified, only the last one takes effect.

Time Range Options
       -lastday

	  Get information for the last day.

       -lastweek

	  Get information for the last week.

       -lastmonth

	  Get information for the last month.

       -lasthours n

	  Get information for the n last hours.

       -from m d y

	  Get  information  for  the  time  since the beginning of the specified date. A start date prior to the Unix epoch causes condor_stats to
	  print its usage information and quit.

       -to m d y

	  Get information for the time up to the beginning of the specified date, instead of up to now. A finish date in the  future  causes  con-
	  dor_stats to print its usage information and quit.

Query Type Arguments
       The query types that do not list all of a category require further specification as given by an argument.

       -resourcequery hostname

	  A  single resource query provides information about a single machine. The information also includes the keyboard idle time (in seconds),
	  the load average, and the machine state.

       -resourcelist

	  A query of a single list of resources to provide a list of all the machines for which the condor_collectordaemon has	historic  informa-
	  tion within the query's time range.

       -resgroupquery arch/opsys | ``Total''

	  A  query  of	a specified group to provide information about a group of machines based on their platform (operating system and architec-
	  ture). The architecture is defined by the machine ClassAd  Arch , and the operating system is defined by the machine	ClassAd   OpSys  .
	  The string ``Total'' ask for information about all platforms.

	  The  columns	displayed  are the number of machines that are unclaimed, matched, claimed, preempting, owner, shutdown, delete, backfill,
	  and drained state.

       -resgrouplist

	  Queries for a list of all the group names for which the condor_collectorhas historic information within the query's time range.

       -userquery email_address/submit_machine

	  Query for a specific submitter on a specific machine. The information displayed includes the number of running jobs and  the	number	of
	  idle jobs. An example argument appears as

	  -userquery jondoe@sample.com/onemachine.sample.com

       -userlist

	  Queries for the list of all submitters for which the condor_collectordaemon has historic information within the query's time range.

       -usergroupquery email_address | ``Total''

	  Query for all jobs submitted by the specific user, regardless of the machine they were submitted from, or all jobs. The information dis-
	  played includes the number of running jobs and the number of idle jobs.

       -usergrouplist

	  Queries for the list of all users for which the condor_collectorhas historic information within the query's time range.

       -ckptquery hostname

	  Query about a checkpoint server given its host name. The information displayed includes the number  of  Mbytes  received,  Mbytes  sent,
	  average receive bandwidth (in Kbytes/sec), and average send bandwidth (in Kbytes/sec).

       -ckptlist

	  Query for the entire list of checkpoint servers for which the condor_collectorhas historic information in the query's time range.

Options
       -f filename

	  Write the information to a file instead of the standard output.

       -pool centralmanagerhostname[:portnumber]

	  Contact the specified central manager instead of the local one.

       -orgformat

	  Display  the	information  in an alternate format for timing, which presents timestamps since the Unix epoch. This argument only affects
	  the display of resoursequery, resgroupquery, userquery, usergroupquery, and ckptquery.

Exit Status
       condor_statswill exit with a status value of 0 (zero) upon success, and it will exit with the value 1 (one) upon failure.

Author
       Condor Team, University of Wisconsin-Madison

Copyright
       Copyright (C) 1990-2012 Condor Team, Computer Sciences Department, University of  Wisconsin-Madison,  Madison,  WI.  All  Rights  Reserved.
       Licensed under the Apache License, Version 2.0.

       See the Condor Version 7.8.2 Manualor http://www.condorproject.org/licensefor additional notices. condor-admin@cs.wisc.edu

								  September 2012						   condor_stats(1)
All times are GMT -4. The time now is 03:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy