04-03-2009
How do I monitor packets by OS id on a UNIX box?
We think we may have an IO problem.
We have 2 identical Oracle servers with the exact same objects in each database. In one database, the first time a query is executed and the data is moved to SGA from disk the query takes about 40 seconds. However, in the other data base, when the query is executed and the data is moved to SGA from disk the query takes about 6 minutes.
If we execute the query the second time on each, the results are the same.
We are pretty sure that there is an I/O bottleneck on the 6 minute machine.
What command could I use on the UNIX box that will show me the OS process id and the packet transfer rate in order to check our theory?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
If I want to access unix box via VPN tunnel,from windows box.
What sould I configure on the windows client PC, and what should I enable on the Unix Server box ?
I am using Solaris V10 intel platform, and I am using windows XP, and 2003 for client (0 Replies)
Discussion started by: zillah
0 Replies
2. UNIX for Advanced & Expert Users
Hi all,
I am generating a file on the Unix machine , now i want to FTP the same file to the NT machine.
how can i do that and the application currently upon which i am working is a JAVA based application.
I need your help.
regards
Ruchir (2 Replies)
Discussion started by: Ruchir
2 Replies
3. UNIX for Dummies Questions & Answers
I am able to run the UNIX commands in a Windows box from a UNIX box through "SSH" functionality. But whenever the SSH connection is established between UNIX and Windows, password for windows box is being asked.
Is there a way to avoid asking password whenever the SSH connection is made? Can I... (1 Reply)
Discussion started by: D.kalpana
1 Replies
4. Shell Programming and Scripting
Hi All,
I need a little help .I want to transfer a file from unix box to a windows box,but the problem i'm facing is that in windows box FTP is not enabled and currently it is nearly impssible to change setting on windows box,i can not use the ftp method ,in my shell script to transfer the file.... (2 Replies)
Discussion started by: Preet
2 Replies
5. UNIX for Dummies Questions & Answers
scp file="myfile.txt" todir="user@somehost:(M:drive:/somepath/)"/
Not sure I need it to go to a specific drive on the windows box (1 Reply)
Discussion started by: xgringo
1 Replies
6. Shell Programming and Scripting
Hi
our unix admin has copied all files from one unix box to new unix box. We just need to confirm that all the file systems are copied properly. How to validate. (9 Replies)
Discussion started by: sravanreddym
9 Replies
7. Shell Programming and Scripting
Hello all !
I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies
8. Shell Programming and Scripting
Hi,
the following shell script is not working on linux box
sugeestions appreciated.
FILE1=/tmp/check1.txt
FILE2=/tmp/check2.txt
df -k | awk '{if (NR != 1)
print $5 $6}' > ${FILE1}
awk -F"%" '{if ($1 > 90) print "Warning: Filesystem " $2 " over 90% threshold (" $1 "%)"}' ${FILE1} >... (7 Replies)
Discussion started by: prakash.gr
7 Replies
9. UNIX for Dummies Questions & Answers
Hi all,
I am new to Linux kernel.
we have a c file that counts the no. of sends and received packets in each interface, and indicate the user about the error/drop ration of incoming and outgoing packets.
in our Linux box , the incoming packets are dropped at random interval.
we have our... (1 Reply)
Discussion started by: kannandv
1 Replies
10. UNIX for Dummies Questions & Answers
Hi Folks,
I am using winscp to graphiclly move the files from one unix box to another unix box , let say one unix box crediantials is (These are dummy crediantials)
xxx -->username
yyy -->password
and another unix box name is
RRR -->username
TTT -->password
NOW i need to... (4 Replies)
Discussion started by: punpun66
4 Replies
LEARN ABOUT REDHAT
explain
EXPLAIN(7) SQL Commands EXPLAIN(7)
NAME
EXPLAIN - show the execution plan of a statement
SYNOPSIS
EXPLAIN [ ANALYZE ] [ VERBOSE ] query
INPUTS
ANALYZE
Flag to carry out the query and show actual run times.
VERBOSE
Flag to show detailed query plan dump.
query Any query.
OUTPUTS
Query plan
Explicit query plan from the PostgreSQL planner.
Note: Prior to PostgreSQL 7.3, the query plan was emitted in the form of a NOTICE message. Now it appears as a query result (format-
ted like a table with a single text column).
DESCRIPTION
This command displays the execution plan that the PostgreSQL planner generates for the supplied query. The execution plan shows how the ta-
ble(s) referenced by the query will be scanned---by plain sequential scan, index scan, etc.---and if multiple tables are referenced, what
join algorithms will be used to bring together the required tuples from each input table.
The most critical part of the display is the estimated query execution cost, which is the planner's guess at how long it will take to run
the query (measured in units of disk page fetches). Actually two numbers are shown: the start-up time before the first tuple can be
returned, and the total time to return all the tuples. For most queries the total time is what matters, but in contexts such as an EXISTS
sub-query the planner will choose the smallest start-up time instead of the smallest total time (since the executor will stop after getting
one tuple, anyway). Also, if you limit the number of tuples to return with a LIMIT clause, the planner makes an appropriate interpolation
between the endpoint costs to estimate which plan is really the cheapest.
The ANALYZE option causes the query to be actually executed, not only planned. The total elapsed time expended within each plan node (in
milliseconds) and total number of rows it actually returned are added to the display. This is useful for seeing whether the planner's esti-
mates are close to reality.
Caution: Keep in mind that the query is actually executed when ANALYZE is used. Although EXPLAIN will discard any output that a
SELECT would return, other side-effects of the query will happen as usual. If you wish to use EXPLAIN ANALYZE on an INSERT, UPDATE,
or DELETE query without letting the query affect your data, use this approach:
BEGIN;
EXPLAIN ANALYZE ...;
ROLLBACK;
The VERBOSE option emits the full internal representation of the plan tree, rather than just a summary. Usually this option is only useful
for debugging PostgreSQL. The VERBOSE dump is either pretty-printed or not, depending on the setting of the EXPLAIN_PRETTY_PRINT configura-
tion parameter.
NOTES
There is only sparse documentation on the optimizer's use of cost information in PostgreSQL. Refer to the User's Guide and Programmer's
Guide for more information.
USAGE
To show a query plan for a simple query on a table with a single int4 column and 10000 rows:
EXPLAIN SELECT * FROM foo;
QUERY PLAN
---------------------------------------------------------
Seq Scan on foo (cost=0.00..155.00 rows=10000 width=4)
(1 row)
If there is an index and we use a query with an indexable WHERE condition, EXPLAIN will show a different plan:
EXPLAIN SELECT * FROM foo WHERE i = 4;
QUERY PLAN
--------------------------------------------------------------
Index Scan using fi on foo (cost=0.00..5.98 rows=1 width=4)
Index Cond: (i = 4)
(2 rows)
And here is an example of a query plan for a query using an aggregate function:
EXPLAIN SELECT sum(i) FROM foo WHERE i < 10;
QUERY PLAN
---------------------------------------------------------------------
Aggregate (cost=23.93..23.93 rows=1 width=4)
-> Index Scan using fi on foo (cost=0.00..23.92 rows=6 width=4)
Index Cond: (i < 10)
(3 rows)
Note that the specific numbers shown, and even the selected query strategy, may vary between PostgreSQL releases due to planner improve-
ments.
COMPATIBILITY
SQL92
There is no EXPLAIN statement defined in SQL92.
SQL - Language Statements 2002-11-22 EXPLAIN(7)