RE: count(*) vs count(0)

[Farnsworth, Dave]

Thanks 
for burying that dead horse Kirti!!
 
;o)
 
 
dave

  -Original Message-From: Kirtikumar Deshpande 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  10:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: count(*) vs count(0)
  Vivek, 
  Your same question on LazyDBA list has been answered correctly. 
  
  :) 
   
  - Kirti VIVEK_SHARMA 
  <[EMAIL PROTECTED]> wrote:
  Is 
there a performance equality between COUNT(*) & COUNT(0) ?Is it same 
, indpendent of the Oracle Version ?Forgive the repeat raising , as 
this issue seems to have come before .Thanks-- 
  
  
  
  Do you Yahoo!?Free online 
  calendar with sync to Outlook(TM).

Re: count(*) vs count(0)

[Kirtikumar Deshpande]

Vivek, 
Your same question on LazyDBA list has been answered correctly. 
:) 
 
- Kirti VIVEK_SHARMA <[EMAIL PROTECTED]> wrote:
Is there a performance equality between COUNT(*) & COUNT(0) ?Is it same , indpendent of the Oracle Version ?Forgive the repeat raising , as this issue seems to have come before .Thanks-- 
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

Re: count(*) vs count(0)

[Wolfgang Breitling]

It may be at your end, I have no difficulty getting to asktom. Here is a 
link to one of the threads about count(*) vs other count() techniques:

http://asktom.oracle.com/pls/ask/f?p=4950:8:26428220175898::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4567980767113,

At 06:45 AM 6/6/2003 -0800, you wrote:
Having tested both forms... it looks like to be the
same...
asktom has a detailed thread about this...

sorry, because I'm not posting the url link, but in
this moment the site is experiencing 'technical
difficulties'
:-)
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: count(*) vs count(0)

[Jose Luis Delgado]

Having tested both forms... it looks like to be the
same...

asktom has a detailed thread about this...

sorry, because I'm not posting the url link, but in
this moment the site is experiencing 'technical
difficulties'

:-)

HTH
JL

--- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote:
> 
> Is there a performance equality between COUNT(*) &
> COUNT(0) ?
> Is it same , indpendent of the Oracle Version ?
> 
> Forgive the repeat raising , as this issue seems to
> have come before .
> 
> Thanks
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: VIVEK_SHARMA
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Ramon E. Estevez]

Title: Message



Tks 
Herman, will make that change.

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent: 
  Thursday, February 13, 2003 10:15 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Count(*) last 30 
  secondsLet's see ...Your DB_CACHE_SIZE is 
  16MB ==  2048 blocksThe table is approx 14,677 blocksThe 
  record-size is something like 800bytesEach multiblock read call will read 
  32-blocksYour DB_CACHE will be filled in less than 64 read-calls and 
  will have less than 1/7th of the table.Your server will certainly be 
  very busy doing physical reads for aFull-Table-Scan of this table 
  alone.Now, the only thing I can suggest is to increase your 
  DB_CACHE_SIZE significantly.16MB is too low for any activity in 
  Oracle.HemantAt 09:54 AM 12-02-03 -0800, you wrote:
  Hermant and Chitale, DB_FILE_MULTIBLOCK_READ_COUNT=32DB_CACHE_SIZE   big integer 
16777216DB_BLOCK_BUFFERS = 
0 Tablespace is 
LMT with a uniform size of 128 MB, DB not in archive mode is for a DW 
system. The time 
for the first run and the re-run last the 
same.  To my understanding the table has only one extent.  This query 
runs in about 7 seconds.  In my production DB runs inmediately that is 
in NT also but 8.1.7.  SELECT TABLESPACE_NAME, EXTENT_ID, BYTES/1048576, 
BLOCKSFROM DBA_EXTENTSWHERESEGMENT_NAME = 
'DM_VENTAS' TABLESPACE_NAME  EXTENT_ID BYTES/1048576 
BLOCKS-- -- - 
--DTMVENTAS   
0   
128  16384  TKS 

  -Original Message- 
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K 
  Chitale 
  Sent: Wednesday, February 12, 2003 8:59 AM 
  To: Multiple recipients of list ORACLE-L 
      Subject: RE: Count(*) last 30 seconds
  That's approx 100 records per blocks. 
  What is the value of DB_FILE_MULTIBLOCK_READ_COUNT ? 
  Also, what is the elapsed time for the query if you re-run the query 
  immediately ? 
  [the first run fetched everything in physical reads, the second run 
  should still 
  find some or most blocks in the SGA, unless the DB_CACHE_SIZE or 
  DB_BLOCK_BUFFERS 
  is very small]. 
  Hemant 
  At 05:18 AM 12-02-03 -0800, you wrote:
  
Hermant, Sergey 
 
The table has 13 columns, the PK is formed for the first 11. 
 
There is no deletion nor update, just inserts in the table.  I 
had truncated the tables sometimes testing the procedure that load the 
rows. 
 
This is the result with an auto trace. 
 
  COUNT(*) 
-- 
   1466196 
 
Execution Plan 
-- 
   0  SELECT STATEMENT 
Optimizer=CHOOSE (Cost=896 Card=1) 
   1    0   SORT (AGGREGATE) 
   2    1 TABLE 
ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196) 
 
 
 
 
 
Statistics 
-- 
  0  
recursive calls 
  0  db 
block gets 
  14677  consistent gets 
  14644  physical reads 
  0  redo 
size 
    386  bytes sent via 
SQL*Net to client 
    503  bytes received 
via SQL*Net from client 
  2  
SQL*Net roundtrips to/from client 
  0  sorts 
(memory) 
  0  sorts 
(disk) 
  1  rows 
processed 
 
  
-Original Message- 
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K 
Chitale 
Sent: Tuesday, February 11, 2003 10:24 PM 
To: Multiple recipients of list ORACLE-L 
Subject: Re: Count(*) last 30 seconds
You are doing Full-Table-Scans.
1.  What's the average row length ?  How many columns does 
the table have ? 
2.  How many "consistent gets" does the count(*) cause ? [ie, 
how many blocks does it actually have to read ?] 
3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE 
large enough to hold most of the 
blocks ?  What is the query-run-time if you re-run the query 
immediately again ?
Hemant 
At 08:19 AM 11-02-03 -0800, you wrote: 

  Hi list, 
  I issue a select count(*) from mytable and last 30 seconds. 
  
  The table has 1,466,196 records and were loaded with a batch 
  process, so they are in a countinous space. 
  I consider that time exagerated. 
  The TBS is LMT 

RE: Count(*) last 30 seconds

[Hemant K Chitale]

Let's see ...
Your DB_CACHE_SIZE is 16MB ==  2048 blocks
The table is approx 14,677 blocks
The record-size is something like 800bytes
Each multiblock read call will read 32-blocks
Your DB_CACHE will be filled in less than 64 read-calls and will have

less than 1/7th of the table.
Your server will certainly be very busy doing physical reads for a
Full-Table-Scan of this table alone.
Now, the only thing I can suggest is to increase your DB_CACHE_SIZE
significantly.
16MB is too low for any activity in Oracle.
Hemant
At 09:54 AM 12-02-03 -0800, you wrote:
Hermant
and Chitale,
 
DB_FILE_MULTIBLOCK_READ_COUNT=32
DB_CACHE_SIZE   big
integer 16777216
DB_BLOCK_BUFFERS =
0
 
Tablespace is LMT with a
uniform size of 128 MB, DB not in archive mode is for a DW
system.
 
The time for the first run and
the re-run last the same.
 
 
To my understanding the table
has only one extent.  This query runs in about 7 seconds.  In
my production DB runs inmediately that is in NT also but
8.1.7.
 
 
SELECT TABLESPACE_NAME,
EXTENT_ID, BYTES/1048576, BLOCKS
FROM DBA_EXTENTS
WHERE
SEGMENT_NAME = 'DM_VENTAS'
 
TABLESPACE_NAME 
EXTENT_ID BYTES/1048576 BLOCKS
-- -- - --
DTMVENTAS  
0  
128  16384
 
 
TKS

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Hemant K Chitale
Sent: Wednesday, February 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Count(*) last 30 seconds

That's approx 100 records per blocks.
What is the value of DB_FILE_MULTIBLOCK_READ_COUNT ?
Also, what is the elapsed time for the query if you re-run the query
immediately ?
[the first run fetched everything in physical reads, the second run
should still
find some or most blocks in the SGA, unless the DB_CACHE_SIZE or
DB_BLOCK_BUFFERS
is very small].
Hemant
At 05:18 AM 12-02-03 -0800, you
wrote:
Hermant, Sergey
 
The table has 13 columns, the PK is formed for the first 11.
 
There is no deletion nor update, just inserts in the table.  I
had truncated the tables sometimes testing the procedure that load the
rows.
 
This is the result with an auto trace.
 
  COUNT(*)
--
   1466196
 
Execution Plan
--
   0  SELECT STATEMENT
Optimizer=CHOOSE (Cost=896 Card=1)
   1    0   SORT (AGGREGATE)
   2    1 TABLE
ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196)
 
 
 
 
 
Statistics
--
  0 
recursive calls
  0  db
block gets
  14677  consistent gets
  14644  physical reads
  0  redo
size
    386  bytes sent via
SQL*Net to client
    503  bytes received
via SQL*Net from client
  2 
SQL*Net roundtrips to/from client
  0  sorts
(memory)
  0  sorts
(disk)
  1  rows
processed
 
  
-Original Message- 
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Hemant K Chitale 
Sent: Tuesday, February 11, 2003 10:24 PM 
To: Multiple recipients of list ORACLE-L 
Subject: Re: Count(*) last 30 seconds

You are doing Full-Table-Scans.

1.  What's the average row length ?  How many columns does
the table have ? 
2.  How many "consistent gets" does the count(*) cause
? [ie, how many blocks does it actually have to read ?] 
3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE
large enough to hold most of the 
blocks ?  What is the query-run-time if you re-run the query
immediately again ?

Hemant 
At 08:19 AM 11-02-03 -0800, you wrote:

Hi list, 
I issue a select count(*) from mytable and last 30 seconds.

The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space. 
I consider that time exagerated. 
The TBS is LMT with a Uniform size of 128 MB. 
The block size is 8MB, version 9.2.0.1.0 in Windows 2000. 
Where should I start looking ??? 
TIA 
Ramon E. Estevez 
[EMAIL PROTECTED] 
809-565-3121 
 
Hemant K Chitale 
My web site page is :  http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 
Hemant K Chitale
My web site page is :  http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fa

RE: Count(*) last 30 seconds

[Ramon E. Estevez]

Title: Message



Hermant and Chitale,
 
DB_FILE_MULTIBLOCK_READ_COUNT=32
DB_CACHE_SIZE   big integer 16777216
DB_BLOCK_BUFFERS = 0
 
Tablespace is LMT with a uniform size of 128 MB, DB not in archive mode 
is for a DW system.
 
The 
time for the first run and the re-run last the same.
 
 
To my 
understanding the table has only one extent.  This query runs in about 7 
seconds.  In my production DB runs inmediately that is in NT also but 
8.1.7.
 
 
SELECT TABLESPACE_NAME, EXTENT_ID, BYTES/1048576, BLOCKSFROM 
DBA_EXTENTSWHERESEGMENT_NAME = 'DM_VENTAS'
 
TABLESPACE_NAME  EXTENT_ID 
BYTES/1048576 BLOCKS-- -- 
- 
--DTMVENTAS   
0   
128  16384
 
 
TKS

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent: 
  Wednesday, February 12, 2003 8:59 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Count(*) last 30 
  secondsThat's approx 100 records per blocks.What 
  is the value of DB_FILE_MULTIBLOCK_READ_COUNT ?Also, what is the elapsed 
  time for the query if you re-run the query immediately ?[the first run 
  fetched everything in physical reads, the second run should stillfind some 
  or most blocks in the SGA, unless the DB_CACHE_SIZE or DB_BLOCK_BUFFERSis 
  very small].HemantAt 05:18 AM 12-02-03 -0800, you wrote:
  Hermant, Sergey The table has 13 columns, the PK is formed for the first 
11. There is no 
deletion nor update, just inserts in the table.  I had truncated the 
tables sometimes testing the procedure that load the 
rows. This is the 
result with an auto trace.   COUNT(*)--   
1466196 Execution 
Plan--   
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=896 
Card=1)   1    0   SORT 
(AGGREGATE)   2    1 
TABLE ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 
Card=1466196) Statistics--  
0  recursive 
calls  0  db 
block gets  14677  consistent 
gets  14644  physical 
reads  0  redo 
size    386  bytes sent via 
SQL*Net to client    503  
bytes received via SQL*Net from 
client  2  
SQL*Net roundtrips to/from 
client  0  
sorts (memory)  
0  sorts 
(disk)  1  
rows processed   

  -Original Message- 
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K 
  Chitale 
  Sent: Tuesday, February 11, 2003 10:24 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: Re: Count(*) last 30 seconds
  You are doing Full-Table-Scans.
  1.  What's the average row length ?  How many columns does 
  the table have ? 
  2.  How many "consistent gets" does the count(*) cause ? [ie, how 
  many blocks does it actually have to read ?] 
  3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE 
  large enough to hold most of the 
  blocks ?  What is the query-run-time if you re-run the query 
  immediately again ?
  Hemant 
  At 08:19 AM 11-02-03 -0800, you wrote:
  
Hi list, 
 
I issue a select count(*) from mytable and last 30 seconds. 
 
The table has 1,466,196 records and were loaded with a batch 
process, so they are in a countinous space. 
 
I consider that time exagerated. 
 
The TBS is LMT with a Uniform size of 128 MB. 
 
The block size is 8MB, version 9.2.0.1.0 in Windows 2000. 
 
Where should I start looking ??? 
 
TIA 
 
Ramon E. Estevez 
[EMAIL PROTECTED] 
809-565-3121 
 
  Hemant K Chitale 
  My web site page is :  http://hkchital.tripod.com
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network 
  Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- 
  Mailing list and web hosting services 
  - To 
  REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
  message BODY, include a line containing: UNSUB ORACLE-L (or the name of 
  mailing list you want to be removed from). You may also send the HELP 
  command for other information (like subscribing). 
  
  
  Hemant K ChitaleMy web site page is :  http://hkchital.tripod.com-- Please see the 
  official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: 
  [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
  http://www.fatcity.com San Diego, Cali

RE: Count(*) last 30 seconds

[Turner, Adrian A SITI-ITPSIE]

Title: Message




Ramon,
 
Our Win2k boxes get between 1000-2000 gets a 
second off a SAN. 

 
Are you using 
compressed folders to store your datafiles?
 
Whats 
Multi_block_read_count set to? 
Set MBRC to 32 (32x8K=256K). Make 
your extent sizes are divisable by 
256K to reduce 
gets
 
Regards
Adrian

  -Original Message-From: Broodbakker, Mario 
  [mailto:[EMAIL PROTECTED]]Sent: 12 February 2003 
  14:09To: Multiple recipients of list ORACLE-LSubject: 
  RE: Count(*) last 30 seconds
  That's not so bad: 14644 physical reads in 30 seconds..that's about 500 
  I/O sec. Depending on your disk layout that's pretty optimal, I 
  think.
   
  Mario
  
-Original Message-From: Ramon E. Estevez 
[mailto:[EMAIL PROTECTED]]Sent: woensdag 12 februari 
2003 14:19To: Multiple recipients of list 
ORACLE-LSubject: RE: Count(*) last 30 
seconds
Hermant, Sergey
 
The table has 13 columns, the PK is formed for the first 
11.
 
There is no deletion nor update, just inserts in the table.  I 
had truncated the tables sometimes testing the procedure that load the 
rows.
 
This is the result with an auto trace.
 
  COUNT(*)--   
1466196
 
Execution 
Plan--   
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=896 
Card=1)   1    0   SORT 
(AGGREGATE)   2    1 
TABLE ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196)
 
 
 
 
 
Statistics--  
0  recursive 
calls  0  db 
block gets  14677  consistent 
gets  14644  physical 
reads  0  redo 
size    386  bytes sent via 
SQL*Net to client    503  
bytes received via SQL*Net from 
client  2  
SQL*Net roundtrips to/from 
client  0  
sorts (memory)  
0  sorts 
(disk)  1  
rows processed
 
 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K 
  ChitaleSent: Tuesday, February 11, 2003 10:24 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: Count(*) last 
  30 secondsYou are doing 
  Full-Table-Scans.1.  What's the average row length ?  
  How many columns does the table have ?2.  How many "consistent 
  gets" does the count(*) cause ? [ie, how many blocks does it actually have 
  to read ?]3.  Are all these Physical Reads ?  Is the 
  DB_CACHE_SIZE large enough to hold most of theblocks ?  What is 
  the query-run-time if you re-run the query immediately again 
  ?HemantAt 08:19 AM 11-02-03 -0800, you wrote:
  Hi 
list, I issue a select 
count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with 
a batch process, so they are in a countinous 
space. I consider that 
time exagerated. The TBS 
is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 
2000. Where should I start 
looking ??? TIA Ramon E. 
Estevez[EMAIL PROTECTED]809-565-3121 
  Hemant K ChitaleMy web site page is :  http://hkchital.tripod.com-- Please see the 
  official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 
  INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
  http://www.fatcity.com San Diego, California -- Mailing list and web 
  hosting services 
  - To 
  REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
  message BODY, include a line containing: UNSUB ORACLE-L (or the name of 
  mailing list you want to be removed from). You may also send the HELP 
  command for other information (like subscribing). 
  

RE: Count(*) last 30 seconds

[Broodbakker, Mario]

Title: Message



That's 
not so bad: 14644 physical reads in 30 seconds..that's about 500 I/O sec. 
Depending on your disk layout that's pretty optimal, I 
think.
 
Mario

  -Original Message-From: Ramon E. Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: woensdag 12 februari 
  2003 14:19To: Multiple recipients of list 
  ORACLE-LSubject: RE: Count(*) last 30 seconds
  Hermant, Sergey
   
  The 
  table has 13 columns, the PK is formed for the first 11.
   
  There is no deletion nor update, just inserts in the table.  I had 
  truncated the tables sometimes testing the procedure that load the 
  rows.
   
  This is the result with an auto trace.
   
    COUNT(*)--   
  1466196
   
  Execution 
  Plan--   
  0  SELECT STATEMENT Optimizer=CHOOSE (Cost=896 
  Card=1)   1    0   SORT 
  (AGGREGATE)   2    1 
  TABLE ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196)
   
   
   
   
   
  Statistics--  
  0  recursive 
  calls  0  db 
  block gets  14677  consistent 
  gets  14644  physical 
  reads  0  redo 
  size    386  bytes sent via 
  SQL*Net to client    503  
  bytes received via SQL*Net from 
  client  2  
  SQL*Net roundtrips to/from 
  client  0  sorts 
  (memory)  0  
  sorts (disk)  1  
  rows processed
   
   
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K 
ChitaleSent: Tuesday, February 11, 2003 10:24 PMTo: 
Multiple recipients of list ORACLE-LSubject: Re: Count(*) last 30 
secondsYou are doing 
Full-Table-Scans.1.  What's the average row length ?  How 
many columns does the table have ?2.  How many "consistent gets" 
does the count(*) cause ? [ie, how many blocks does it actually have to read 
?]3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE 
large enough to hold most of theblocks ?  What is the 
query-run-time if you re-run the query immediately again 
?HemantAt 08:19 AM 11-02-03 -0800, you wrote:
Hi 
  list, I issue a select 
  count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with a 
  batch process, so they are in a countinous 
  space. I consider that time 
  exagerated. The TBS is LMT 
  with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 
  2000. Where should I start 
  looking ??? TIA Ramon E. 
  Estevez[EMAIL PROTECTED]809-565-3121 
Hemant K ChitaleMy web site page is :  http://hkchital.tripod.com-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 
INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
http://www.fatcity.com San Diego, California -- Mailing list and web hosting 
services 
- To 
REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from). You may also send the HELP command for other 
information (like subscribing). 

RE: Count(*) last 30 seconds

[Hemant K Chitale]

That's approx 100 records per blocks.
What is the value of DB_FILE_MULTIBLOCK_READ_COUNT ?
Also, what is the elapsed time for the query if you re-run the query
immediately ?
[the first run fetched everything in physical reads, the second run
should still
find some or most blocks in the SGA, unless the DB_CACHE_SIZE or
DB_BLOCK_BUFFERS
is very small].
Hemant
At 05:18 AM 12-02-03 -0800, you wrote:
Hermant,
Sergey
 
The table has 13 columns, the
PK is formed for the first 11.
 
There is no deletion nor
update, just inserts in the table.  I had truncated the tables
sometimes testing the procedure that load the rows.
 
This is the result with an
auto trace.
 
  COUNT(*)
--
   1466196
 

Execution Plan
--
   0  SELECT STATEMENT
Optimizer=CHOOSE (Cost=896 Card=1)
   1    0   SORT (AGGREGATE)
   2    1 TABLE ACCESS
(FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196)
 
 
 
 
 
Statistics
--
  0  recursive
calls
  0  db block
gets
  14677  consistent gets
  14644  physical reads
  0  redo
size
    386  bytes sent via
SQL*Net to client
    503  bytes received via
SQL*Net from client
  2  SQL*Net
roundtrips to/from client
  0  sorts
(memory)
  0  sorts
(disk)
  1  rows
processed
 
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Hemant K Chitale
Sent: Tuesday, February 11, 2003 10:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Count(*) last 30 seconds

You are doing Full-Table-Scans.

1.  What's the average row length ?  How many columns does
the table have ?
2.  How many "consistent gets" does the count(*) cause
? [ie, how many blocks does it actually have to read ?]
3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE
large enough to hold most of the
blocks ?  What is the query-run-time if you re-run the query
immediately again ?

Hemant
At 08:19 AM 11-02-03 -0800, you
wrote:
Hi list,
 
I issue a select count(*) from mytable and last 30 seconds.
 
The table has 1,466,196 records and were loaded with a batch process,
so they are in a countinous space.
 
I consider that time exagerated.
 
The TBS is LMT with a Uniform size of 128 MB.
 
The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
 
Where should I start looking ???
 
TIA
 
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
 
Hemant K Chitale
My web site page is : 
http://hkchital.tripod.com

-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Ramon E. Estevez]

Title: Message



Hermant, Sergey
 
The 
table has 13 columns, the PK is formed for the first 11.
 
There 
is no deletion nor update, just inserts in the table.  I had truncated the 
tables sometimes testing the procedure that load the rows.
 
This 
is the result with an auto trace.
 
  COUNT(*)--   1466196
 
Execution 
Plan--   
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=896 
Card=1)   1    0   SORT 
(AGGREGATE)   2    1 TABLE 
ACCESS (FULL) OF 'DM_VENTAS' (Cost=896 Card=1466196)
 
 
 
 
 
Statistics--  
0  recursive 
calls  0  db block 
gets  14677  consistent 
gets  14644  physical 
reads  0  redo 
size    386  bytes sent via 
SQL*Net to client    503  bytes 
received via SQL*Net from 
client  2  SQL*Net 
roundtrips to/from 
client  0  sorts 
(memory)  0  sorts 
(disk)  1  rows 
processed
 
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent: 
  Tuesday, February 11, 2003 10:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Count(*) last 30 
  secondsYou are doing 
  Full-Table-Scans.1.  What's the average row length ?  How 
  many columns does the table have ?2.  How many "consistent gets" does 
  the count(*) cause ? [ie, how many blocks does it actually have to read 
  ?]3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE large 
  enough to hold most of theblocks ?  What is the query-run-time if you 
  re-run the query immediately again ?HemantAt 08:19 AM 11-02-03 
  -0800, you wrote:
  Hi 
list, I issue a select 
count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with a 
batch process, so they are in a countinous space. I consider that time 
exagerated. The TBS is LMT 
with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 
2000. Where should I start 
looking ??? TIA Ramon E. 
Estevez[EMAIL PROTECTED]809-565-3121 
  Hemant K ChitaleMy web site page is :  http://hkchital.tripod.com-- Please see the 
  official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: 
  [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
  http://www.fatcity.com San Diego, California -- Mailing list and web hosting 
  services - 
  To REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
  you want to be removed from). You may also send the HELP command for other 
  information (like subscribing). 

Re: Count(*) last 30 seconds

[Hemant K Chitale]

You are doing Full-Table-Scans.
1.  What's the average row length ?  How many columns does the
table have ?
2.  How many "consistent gets" does the count(*) cause ?
[ie, how many blocks does it actually have to read ?]
3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE large
enough to hold most of the
blocks ?  What is the query-run-time if you re-run the query
immediately again ?
Hemant
At 08:19 AM 11-02-03 -0800, you wrote:
Hi
list,
 
I issue a select count(*) from mytable and
last 30 seconds.
 
The table has 1,466,196 records and were
loaded with a batch process, so they are in a countinous
space.
 
I consider that time exagerated.
 
The TBS is LMT with a Uniform size of 128
MB.
 
The block size is 8MB, version 9.2.0.1.0 in
Windows 2000.
 
Where should I start looking ???
 
TIA
 
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
 

Hemant K Chitale
My web site page is : 
http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Ramon E. Estevez]

Title: Message




Tks 
to all of you for your help.
 
The 
table has a PK that is formed by 11 fields of 13 that the table has.  This 
table is for a DW system.
 
This 
the only one in the table.
 
I 
analyze the table again, had done it before using 
dbms_stats.gather_schema_stats, and the time went down to 7 
seconds.
 
And 
there is no difference between count(*) and count(1), the same results with both 
of them.
 
tks 
to all
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Koivu, LisaSent: 
  Tuesday, February 11, 2003 11:40 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Count(*) last 30 seconds
  well, have you traced the statement yet?  That's 
  where to start, with autotrace.
   
  My 
  count(*) which executes a FTS (in a load to mitigate any ORA-1555 error) 
  takes 15 minutes to count 50 million rows.
   
  
  Lisa 
  Koivu Tired, Tired, 
  Tired. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. 
  Lauderdale, FL, USA  33063 Office: 
  954-935-4117  Fax:    
  954-935-3639 Cell:    
  954-683-4459 
  
-Original Message-From: Ramon E. Estevez 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11, 
2003 11:19 AMTo: Multiple recipients of list 
ORACLE-LSubject: Count(*) last 30 seconds
Hi 
list,
 
I issue a 
select count(*) from mytable and last 30 seconds.
 
The table has 
1,466,196 records and were loaded with a batch process, so they are in 
a countinous space.
 
I consider 
that time exagerated.
 
The TBS is LMT 
with a Uniform size of 128 MB.
 
The block size 
is 8MB, version 9.2.0.1.0 in Windows 2000.
 
Where should I 
start looking ???
 
TIA
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
809-565-3121
 

RE: Count(*) last 30 seconds

[Richard Ji]

It used to be different, but Oracle has long optimized count(*)
so it all does the same thing now.  What version of the doc did
you read this from?

Richard

-Original Message-
Sent: Tuesday, February 11, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


Because Oracle documentation says that count(1) has better performance than 
count(*).
I do not know why is it so. WIll it make clear some guru on this list?

JP

On Tuesday 11 February 2003 18:59, you wrote:
> Why use count(1) instead of count(*)?  They all does the same thing.
> So does count(primary key).
>
> Richard Ji
>
> -Original Message-
> Sent: Tuesday, February 11, 2003 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>   1. create unique index or primary key   AND update statistics of the
> table
>   2. use count(1) instead of count(*)
>
> JP
>
> On Tuesday 11 February 2003 17:19, you wrote:
> > Hi list,
> >
> > I issue a select count(*) from mytable and last 30 seconds.
> >
> > The table has 1,466,196 records and were loaded with a batch process, so
> > they are in a countinous space.
> >
> > I consider that time exagerated.
> >
> > The TBS is LMT with a Uniform size of 128 MB.
> >
> > The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
> >
> > Where should I start looking ???
> >
> > TIA
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[JayMiller]

Does it take the same amount of time if you run the count(*) a second time
(i.e., might it reading the entire table from disk the first time)?

Jay Miller

-Original Message-
Sent: Tuesday, February 11, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count(*) last 30 seconds

[Jan Pruner]

Because Oracle documentation says that count(1) has better performance than 
count(*).
I do not know why is it so. WIll it make clear some guru on this list?

JP

On Tuesday 11 February 2003 18:59, you wrote:
> Why use count(1) instead of count(*)?  They all does the same thing.
> So does count(primary key).
>
> Richard Ji
>
> -Original Message-
> Sent: Tuesday, February 11, 2003 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>   1. create unique index or primary key   AND update statistics of the
> table
>   2. use count(1) instead of count(*)
>
> JP
>
> On Tuesday 11 February 2003 17:19, you wrote:
> > Hi list,
> >
> > I issue a select count(*) from mytable and last 30 seconds.
> >
> > The table has 1,466,196 records and were loaded with a batch process, so
> > they are in a countinous space.
> >
> > I consider that time exagerated.
> >
> > The TBS is LMT with a Uniform size of 128 MB.
> >
> > The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
> >
> > Where should I start looking ???
> >
> > TIA
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Toepke, Kevin M]

With Oracle 6 and sometimes in Oracle 7 one count was faster than the other.


With Oracle 8.0+ you'll see that count(1) == count(*) == count(unique
column) == count(not null column) 

Don't believe me? Try it. 

-Original Message-
Sent: Tuesday, February 11, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L


Interestingly enough, I haven't seen an official statement on count(*) being
slower than count(). 

Sunil Nookala
DBA
Dell Corp.



-Original Message-
Sent: Tuesday, February 11, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Rachel Carmichael]

If I remember correctly, there was a discussion here a while ago (like
a few years) on which was faster and I believe (caffeine levels are
low, so memory could be faulty) that it was determined that it made no
difference which you used.

This was pre 9i so things could have changed.


--- [EMAIL PROTECTED] wrote:
> Interestingly enough, I haven't seen an official statement on
> count(*) being
> slower than count(). 
> 
> Sunil Nookala
> DBA
> Dell Corp.
> 
> 
> 
> -Original Message-
> Sent: Tuesday, February 11, 2003 11:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
>   1. create unique index or primary key   AND update statistics of the
> table
>   2. use count(1) instead of count(*)
> 
> JP
> 
> On Tuesday 11 February 2003 17:19, you wrote:
> > Hi list,
> >
> > I issue a select count(*) from mytable and last 30 seconds.
> >
> > The table has 1,466,196 records and were loaded with a batch
> process, so
> > they are in a countinous space.
> >
> > I consider that time exagerated.
> >
> > The TBS is LMT with a Uniform size of 128 MB.
> >
> > The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
> >
> > Where should I start looking ???
> >
> > TIA
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121
> 
> -- 
>  Pruner Jan
>[EMAIL PROTECTED]
>  http://jan.pruner.cz/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jan Pruner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Sutton, Reed]

Unfortunately I don't have the reference in front of my right now, but I
believe the optimizer has a built in way to understand a count(*) and it is
just as fast or faster than count(column_name).

-Original Message-
Sent: Tuesday, February 11, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L


Interestingly enough, I haven't seen an official statement on count(*) being
slower than count(). 

Sunil Nookala
DBA
Dell Corp.



-Original Message-
Sent: Tuesday, February 11, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sutton, Reed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Richard Ji]

Why use count(1) instead of count(*)?  They all does the same thing.
So does count(primary key).

Richard Ji

-Original Message-
Sent: Tuesday, February 11, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Sunil_Nookala]

Interestingly enough, I haven't seen an official statement on count(*) being
slower than count(). 

Sunil Nookala
DBA
Dell Corp.



-Original Message-
Sent: Tuesday, February 11, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count(*) last 30 seconds

[Jan Pruner]

Hi,
1. create unique index or primary key   AND update statistics of the table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count(*) last 30 seconds

[Koivu, Lisa]

Title: Message



well, 
have you traced the statement yet?  That's where to start, with 
autotrace.
 
My 
count(*) which executes a FTS (in a load to mitigate any ORA-1555 error) 
takes 15 minutes to count 50 million rows.
 

Lisa 
Koivu Tired, Tired, Tired. 
Fairfield Resorts, Inc. 5259 
Coconut Creek Parkway Ft. Lauderdale, FL, USA  
33063 Office: 954-935-4117  Fax:    954-935-3639 Cell:    954-683-4459 


  -Original Message-From: Ramon E. Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11, 
  2003 11:19 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Count(*) last 30 seconds
  Hi 
  list,
   
  I issue a select 
  count(*) from mytable and last 30 seconds.
   
  The table has 
  1,466,196 records and were loaded with a batch process, so they are in a 
  countinous space.
   
  I consider that 
  time exagerated.
   
  The TBS is LMT 
  with a Uniform size of 128 MB.
   
  The block size 
  is 8MB, version 9.2.0.1.0 in Windows 2000.
   
  Where should I 
  start looking ???
   
  TIA
   
  Ramon E. 
  Estevez
  [EMAIL PROTECTED]
  809-565-3121
   

RE: Count(*) last 30 seconds

[DENNIS WILLIAMS]

Ramon - Start by adding an index? :-)
 
Do you have any indexes on this table? My first guess is that it is doing a
full table scan. This does seem to be a bit long for a full table scan. Do
you expect to do a lot of full table scans on this table? If so, then you
may want to look at how to tune the full table scan. Otherwise add an index.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, February 11, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


Hi list,
 
I issue a select count(*) from mytable and last 30 seconds.
 
The table has 1,466,196 records and were loaded with a batch process, so
they are in a countinous space.
 
I consider that time exagerated.
 
The TBS is LMT with a Uniform size of 128 MB.
 
The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
 
Where should I start looking ???
 
TIA
 
Ramon E. Estevez
[EMAIL PROTECTED]  
809-565-3121
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Naveen Nahata]

Title: RE: count(*)



I 
think this kind of huge volume of insertions can only take place if the 
application is doing a batch processing, so the issue of contention should not 
come.
 
if it 
is something like recording to page-hits or web-hits, then obviously the table 
will slow down the things a lot.
 
i 
don't have experience of huge DBs but 3 million rows an hour means 72 million 
rows in a day, which means 2.1 billion rows a month! this means it is recording 
some kind of transactions mostly web hits on a very popular web-site. what logic 
will force someone like to do a count(*) on such a 
table?
 
my gut 
feeling is that count(*) must be unnecessary, and simply because it is available 
easily in Informix(according to the poster), the application has somehow found a 
reason to use it
 
regards
naveen

  -Original Message-From: Craig Munday 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 23, 2002 
  5:29 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: count(*) 
  Hi 
  Depending on how the transactions are defined I do not think 
  that you will be able to achieve the throughput as the single row will be a 
  point of serialisation.
  Cheers, Craig. 
  -Original Message- From: 
  Naveen Nahata [mailto:[EMAIL PROTECTED]] 
  Sent: Saturday, 21 September 2002 12:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: count(*) 
  What about having a separate table with a single column and a 
  single row to store only the count, and increment and 
  decrement it using a row trigger on Insert and 
  deletes? 
  that way select count(*) will be very fast, the only ovehead 
  will of the trigger, which i think should be offset by 
  the performance gained by the select. 
  Regards naveen 
  -Original Message- Sent: 
  Friday, September 20, 2002 6:24 PM To: Multiple 
  recipients of list ORACLE-L 
  Rishi, 
  Do records get deleted from this table?  If not, you 
  could simply add an additional column that gets 
  populated by a sequence, add an index on that column, 
  and select max() from that column.  Even better, simply query 
  'select sequence_name,last_number from user_sequences' to get 
  the last value used.  You may need to check 
  whether sequence caching makes a difference with this 
  query. 
  Otherwise, Dennis gave some good advice. 
  Hope this helps. 
  Tom Mercadante Oracle Certified 
  Professional 
  -Original Message- Sent: 
  Thursday, September 19, 2002 5:04 PM To: Multiple 
  recipients of list ORACLE-L 
  Sent: Thursday, September 19, 2002 2:48 PM To: '[EMAIL PROTECTED]' 
  Rishi - I've encountered this as well. I think the problem is 
  the fact that you are pounding millions of rows into 
  the table. When you ask for a count, Oracle won't give 
  you an approximate answer, but insists on giving you a precise answer as of the moment you hit return. You are right, your 
  query can actually slow performance. No, to my 
  knowledge Oracle doesn't maintain a record of the 
  number of rows in the table, my guess being that could become a performance bottleneck.    My 
  recommendation would be to ask very precisely what is to be achieved 
  with the count. As you noticed, the count will lag reality by 
  quite awhile. Perhaps the application could maintain 
  the count. I have quite a few batch programs that will 
  display a running counter. If only an approximate count is needed, there may be an alternate method, like looking at how 
  many segments are used and calculating. Just some 
  thoughts. 
  Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
  
  -Original Message- [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, September 19, 2002 1:28 PM To: Multiple recipients of list ORACLE-L 
  Hi Gurus, 
  In one of our insert intensive application we are inserting 
  around 3-4 million rows / hour. Also this app needs to 
  do a count(*) of the tables every 10 minutes for 
  verifying some application based logic. This is really killing us and it takes a lot of time. 
  Can you please guide me to a direction ( built in functions or 
  something similar). 
  Actually this app is being ported from Informix. Informix can 
  somehow keep a trak of the count(*) of a  table 
  in its header somewhere. 
  And yes I have tries count(1) , count(indexed_column) 
  etc. 
  Thanks In Advance. 
  R.h -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:   INET: 
  [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list

RE: count(*)

[Craig Munday]

Title: RE: count(*)  





Hi


Depending on how the transactions are defined I do not think that you will be able to achieve the throughput as the single row will be a point of serialisation.

Cheers,
Craig.



-Original Message-
From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 21 September 2002 12:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: count(*) 



What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?


that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.


Regards
naveen


-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L



Rishi,


Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.


Otherwise, Dennis gave some good advice.


Hope this helps.


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L




Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'



Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L



Hi Gurus,


In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 


Can you please guide me to a direction ( built in functions or something
similar). 


Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.


And yes I have tries count(1) , count(indexed_column) etc.



Thanks In Advance.


R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send

RE: count(*)

[Craig Munday]

Title: RE: count(*)



Hi,
 
I've 
read so many suggestions for making this count(*) quicker but we are all 
assuming that it is needed and has a purpose in the first place - which may or 
may not be the case.  Obviously the quickest way to do the count(*) is to 
NOT do it in the first place.
 
I'd 
still like to know the purpose of the count(*) and what verification it is 
performing?  And also, why are there so many rows being inserted into the 
table.
 
Cheers,Craig.
 

  -Original Message-From: Craig Munday 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, 20 September 2002 
  10:53 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: count(*)
  Hi, 
  I am not sure if I have a solution for you, but I have a 
  number of questions: 
  1) just for my interest, what type of application would need 
  to insert 3-4 million records per hour? 
  2) Why does the application need to do the select 
  count(*)?  What verification is being performed? 
  3) Perhaps the design of the application could change so the 
  number of records is reduced? 
  Cheers, Craig.   
  

RE: count(*)

[Jamadagni, Rajendra]

Title: RE: count(*)





Hmmm ... everyone is throwing their ideas around ... so here is mine ...


Hopefully on this large table you have a PK.


1. First time when you do the count(*) (I hope it will be > 10 minutes), do it as follows ...


select count(*), max(pk_column)
from my ludicrously_large_table
/


Somehow, remember the max(pk_column) value.


Next time onwards do ...
select count(*), max(pk_column)
from my ludicrously_large_table
where pk_column > previously_saved_max_pk_column_value
/


Then add this count(*) plus last count(*) to get the total number.


How is that ??


Raj
__
Rajendra Jamadagni      MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!




*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: count(*)

[Viral Desai]

I think maintaining counts in other table (Naveen's approach) is more of an 
application issue. To avoid multiple processes waiting for a lock to update 
records in seperate table, you could have each process its dedicated row in 
a seperate table with the current count in it. A slight modified version of 
Naveen's approach to the problem is described below.

I'm interested in knowing any pitfalls with the following approach, Please 
don't hesitate to take a shot at this.

Thanks,
Viral

Lets say, P1, P2, P3, P4 ... Pn processes would insert large number of rows 
in large_table.

   -- Create a table called rcd_cnter or something like that.
create table rcd_cnter
  (
prcss_name varchar2(30) primary key,
recd_count number
   );
   -- Each Pi would drop and create its own seq. at the
  beginining of the process.

   -- At the beginning the Pi, it would
  use dbms_application_info.set_module to set
  the process name i.e. Pi,  to identify itself.
  This will be later available in v$session.module column to
  the trigger on the large_table.

   -- Create an after insert trigger on the large_table. The trigger
  would query v$seesion.module to identify the module/seq number
  to query, and then use that number and v$session.module to insert
  or update record in rcd_cntr;

   -- At any given time the number of records in the table would be
  arrived by following sql

  select sum(nvl(recd_cnter,0)) from rcd_cntr;



>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: count(*)  Date: Fri, 20 Sep 2002 08:33:37 -0800
>
>Naveen - This approach would probably work fine as long as only a single
>process was running. If multiple processes were inserting rows (likely at
>the scale of millions of rows/hour), this new table would probably be the
>bottleneck. Each process must acquire a lock on this row of this table, so
>the other processes must wait unnecessarily. Been there, done that. Very
>difficult to do what the user asks without degrading performance, which is
>probably why Oracle scales higher that Informix. Okay, cheap shot but worth
>mentioning again.
>
> 
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>-Original Message-
>Sent: Friday, September 20, 2002 9:04 AM
>To: Multiple recipients of list ORACLE-L
>
>
>What about having a separate table with a single column and a single row to
>store only the count, and increment and decrement it using a row trigger on
>Insert and deletes?
>
>that way select count(*) will be very fast, the only ovehead will of the
>trigger, which i think should be offset by the performance gained by the
>select.
>
>Regards
>naveen
>
>-Original Message-
>Sent: Friday, September 20, 2002 6:24 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Rishi,
>
>Do records get deleted from this table?  If not, you could simply add an
>additional column that gets populated by a sequence, add an index on that
>column, and select max() from that column.  Even better, simply query
>'select sequence_name,last_number from user_sequences' to get the last 
>value
>used.  You may need to check whether sequence caching makes a difference
>with this query.
>
>Otherwise, Dennis gave some good advice.
>
>Hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Thursday, September 19, 2002 5:04 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Sent: Thursday, September 19, 2002 2:48 PM
>To: '[EMAIL PROTECTED]'
>
>
>Rishi - I've encountered this as well. I think the problem is the fact that
>you are pounding millions of rows into the table. When you ask for a count,
>Oracle won't give you an approximate answer, but insists on giving you a
>precise answer as of the moment you hit return. You are right, your query
>can actually slow performance. No, to my knowledge Oracle doesn't maintain 
>a
>record of the number of rows in the table, my guess being that could become
>a performance bottleneck.
>My recommendation would be to ask very precisely what is to be achieved
>with the count. As you noticed, the count will lag reality by quite awhile.
>Perhaps the application could maintain the count. I have quite a few batch
>programs that will display a running counter. If only an approximate count
>is needed, there may be an alternate method, like looking at how many
>segments are used and calculating. Just some thoughts.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>-Original Message-

Re: count(*)

[Jan Pruner]

Do you really need it?
In case of huge DELETE statement you can always recreate sequence with START 
WITH .

JP

On Friday 20 September 2002 19:04, you wrote:
> but sequences cannot be decremented by PREVVAL too, what about DELETIONS?!
>
> -Original Message-
> Sent: Friday, September 20, 2002 8:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
> this is what Oracle invented SEQUENCES for!  :)
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Friday, September 20, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
> What about having a separate table with a single column and a single row to
> store only the count, and increment and decrement it using a row trigger on
> Insert and deletes?
>
> that way select count(*) will be very fast, the only ovehead will of the
> trigger, which i think should be offset by the performance gained by the
> select.
>
> Regards
> naveen
>
> -Original Message-
> Sent: Friday, September 20, 2002 6:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Rishi,
>
> Do records get deleted from this table?  If not, you could simply add an
> additional column that gets populated by a sequence, add an index on that
> column, and select max() from that column.  Even better, simply query
> 'select sequence_name,last_number from user_sequences' to get the last
> value used.  You may need to check whether sequence caching makes a
> difference with this query.
>
> Otherwise, Dennis gave some good advice.
>
> Hope this helps.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Thursday, September 19, 2002 5:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Sent: Thursday, September 19, 2002 2:48 PM
> To: '[EMAIL PROTECTED]'
>
>
> Rishi - I've encountered this as well. I think the problem is the fact that
> you are pounding millions of rows into the table. When you ask for a count,
> Oracle won't give you an approximate answer, but insists on giving you a
> precise answer as of the moment you hit return. You are right, your query
> can actually slow performance. No, to my knowledge Oracle doesn't maintain
> a record of the number of rows in the table, my guess being that could
> become a performance bottleneck.
>My recommendation would be to ask very precisely what is to be achieved
> with the count. As you noticed, the count will lag reality by quite awhile.
> Perhaps the application could maintain the count. I have quite a few batch
> programs that will display a running counter. If only an approximate count
> is needed, there may be an alternate method, like looking at how many
> segments are used and calculating. Just some thoughts.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
>
>
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 1:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus,
>
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is really
> killing us and it takes a lot of time.
>
> Can you please guide me to a direction ( built in functions or something
> similar).
>
> Actually this app is being ported from Informix. Informix can somehow keep
> a trak of the count(*) of a  table in its header somewhere.
>
> And yes I have tries count(1) , count(indexed_column) etc.
>
>
> Thanks In Advance.
>
> R.h

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Mercadante, Thomas F]

Naveen,

Please read all the posts.  That is the first question I asked.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 20, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


but sequences cannot be decremented by PREVVAL too, what about DELETIONS?!

-Original Message-
Sent: Friday, September 20, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L


this is what Oracle invented SEQUENCES for!  :)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 20, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?

that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.

Regards
naveen

-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L


Rishi,

Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.

Otherwise, Dennis gave some good advice.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L



Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing 

RE: count(*)

[DENNIS WILLIAMS]

Naveen - This approach would probably work fine as long as only a single
process was running. If multiple processes were inserting rows (likely at
the scale of millions of rows/hour), this new table would probably be the
bottleneck. Each process must acquire a lock on this row of this table, so
the other processes must wait unnecessarily. Been there, done that. Very
difficult to do what the user asks without degrading performance, which is
probably why Oracle scales higher that Informix. Okay, cheap shot but worth
mentioning again.

 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
Sent: Friday, September 20, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L


What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?

that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.

Regards
naveen

-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L


Rishi,

Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.

Otherwise, Dennis gave some good advice.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L



Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

RE: count(*)

[Naveen Nahata]

but sequences cannot be decremented by PREVVAL too, what about DELETIONS?!

-Original Message-
Sent: Friday, September 20, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L


this is what Oracle invented SEQUENCES for!  :)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 20, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?

that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.

Regards
naveen

-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L


Rishi,

Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.

Otherwise, Dennis gave some good advice.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L



Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
t

RE: count(*)

[Paula_Stankus]

Title: RE: count(*)  





That is the best advice yet.  Duh for the rest of us.


-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: count(*) 



this is what Oracle invented SEQUENCES for!  :)


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Friday, September 20, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?


that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.


Regards
naveen


-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L



Rishi,


Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.


Otherwise, Dennis gave some good advice.


Hope this helps.


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L




Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'



Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L



Hi Gurus,


In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 


Can you please guide me to a direction ( built in functions or something
similar). 


Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.


And yes I have tries count(1) , count(indexed_column) etc.



Thanks In Advance.


R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
---

RE: count(*)

[Gogala, Mladen]

There is a difference between 10 and 120 minutes, especially on Friday.

> -Original Message-
> From: Anjo Kolk [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 20, 2002 3:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: count(*)
> 
> 
> If you can live with 10 minutes, why not 60 minutes or 120 minutes ?
> Examine why this app feels so insecure that it needs to know 
> the number of 
> rows every 10 minutes.
> 
> 
> On Thursday 19 September 2002 20:28, you wrote:
> > Hi Gurus,
> >
> > In one of our insert intensive application we are inserting 
> around 3-4
> > million rows / hour. Also this app needs to do a count(*) 
> of the tables
> > every 10 minutes for verifying some application based 
> logic. This is really
> > killing us and it takes a lot of time.
> >
> > Can you please guide me to a direction ( built in functions 
> or something
> > similar).
> >
> > Actually this app is being ported from Informix. Informix 
> can somehow keep
> > a trak of the count(*) of a  table in its header somewhere.
> >
> > And yes I have tries count(1) , count(indexed_column) etc.
> >
> >
> > Thanks In Advance.
> >
> > R.h
> 
> -- 
> 
> Anjo Kolk
> http://www.oraperf.com
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Anjo Kolk
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Mercadante, Thomas F]

this is what Oracle invented SEQUENCES for!  :)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 20, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?

that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.

Regards
naveen

-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L


Rishi,

Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.

Otherwise, Dennis gave some good advice.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L



Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subsc

Re: count(*)

[Alexandre Gorbatchev]

Tom,

The sequences are transaction independant, so the trick with 'select
sequence_name,last_number from user_sequences' will only work if there are
no rollbacks after insert as well as no use of cache in sequence as you
mentioned.
Moreover, what if records get deleted? I guess this may be solved using
another trigger on delete selecting another sequence. Than count(*) may be
determined as a difference between two sequences. Again there should be no
rollbacks.

Rishi, I would also join the point of redesigning of the logic without use
of count(*).

Regards,
Alexandre

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 2:53 PM


> Rishi,
>
> Do records get deleted from this table?  If not, you could simply add an
> additional column that gets populated by a sequence, add an index on that
> column, and select max() from that column.  Even better, simply query
> 'select sequence_name,last_number from user_sequences' to get the last
value
> used.  You may need to check whether sequence caching makes a difference
> with this query.
>
> Otherwise, Dennis gave some good advice.
>
> Hope this helps.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Thursday, September 19, 2002 5:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Sent: Thursday, September 19, 2002 2:48 PM
> To: '[EMAIL PROTECTED]'
>
>
> Rishi - I've encountered this as well. I think the problem is the fact
that
> you are pounding millions of rows into the table. When you ask for a
count,
> Oracle won't give you an approximate answer, but insists on giving you a
> precise answer as of the moment you hit return. You are right, your query
> can actually slow performance. No, to my knowledge Oracle doesn't maintain
a
> record of the number of rows in the table, my guess being that could
become
> a performance bottleneck.
>My recommendation would be to ask very precisely what is to be achieved
> with the count. As you noticed, the count will lag reality by quite
awhile.
> Perhaps the application could maintain the count. I have quite a few batch
> programs that will display a running counter. If only an approximate count
> is needed, there may be an alternate method, like looking at how many
> segments are used and calculating. Just some thoughts.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
>
>
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 1:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus,
>
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is
really
> killing us and it takes a lot of time.
>
> Can you please guide me to a direction ( built in functions or something
> similar).
>
> Actually this app is being ported from Informix. Informix can somehow keep
a
> trak of the count(*) of a  table in its header somewhere.
>
> And yes I have tries count(1) , count(indexed_column) etc.
>
>
> Thanks In Advance.
>
> R.h
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTE

RE: count(*)

[Naveen Nahata]

What about having a separate table with a single column and a single row to
store only the count, and increment and decrement it using a row trigger on
Insert and deletes?

that way select count(*) will be very fast, the only ovehead will of the
trigger, which i think should be offset by the performance gained by the
select.

Regards
naveen

-Original Message-
Sent: Friday, September 20, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L


Rishi,

Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.

Otherwise, Dennis gave some good advice.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L



Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif

RE: count(*)

[Mercadante, Thomas F]

Rishi,

Do records get deleted from this table?  If not, you could simply add an
additional column that gets populated by a sequence, add an index on that
column, and select max() from that column.  Even better, simply query
'select sequence_name,last_number from user_sequences' to get the last value
used.  You may need to check whether sequence caching makes a difference
with this query.

Otherwise, Dennis gave some good advice.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, September 19, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L



Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: count(*)

[Anjo Kolk]

If you can live with 10 minutes, why not 60 minutes or 120 minutes ?
Examine why this app feels so insecure that it needs to know the number of 
rows every 10 minutes.


On Thursday 19 September 2002 20:28, you wrote:
> Hi Gurus,
>
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is really
> killing us and it takes a lot of time.
>
> Can you please guide me to a direction ( built in functions or something
> similar).
>
> Actually this app is being ported from Informix. Informix can somehow keep
> a trak of the count(*) of a  table in its header somewhere.
>
> And yes I have tries count(1) , count(indexed_column) etc.
>
>
> Thanks In Advance.
>
> R.h

-- 

Anjo Kolk
http://www.oraperf.com


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: count(*)

[Mladen Gogala]

If the table has a primary key, you can also combine the parallel hint with 
index_ffs on that primary key which is by far the fastest way of doing count(*).

On 2002.09.19 16:18 "Suri, Deepak" wrote:
> I have in the past used parallel hints to speed up a count(*) kind of full
> table scan query.
> 
> thanx
> deepak
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 2:28 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gurus,
> 
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is really
> killing us and it takes a lot of time. 
> 
> Can you please guide me to a direction ( built in functions or something
> similar). 
> 
> Actually this app is being ported from Informix. Informix can somehow keep a
> trak of the count(*) of a  table in its header somewhere.
> 
> And yes I have tries count(1) , count(indexed_column) etc.
> 
> 
> Thanks In Advance.
> 
> R.h
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Suri, Deepak
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Craig Munday]

Title: RE: count(*)





Hi,


I am not sure if I have a solution for you, but I have a number of questions:


1) just for my interest, what type of application would need to insert 3-4 million records per hour?


2) Why does the application need to do the select count(*)?  What verification is being performed?


3) Perhaps the design of the application could change so the number of records is reduced?


Cheers,
Craig.
  


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 20 September 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: count(*)




Paula et al:


It could work if the analyze is done after the load using DBMS_STATS. Then
the num_rows would be accurate.  With the monitoring turned on , analyzing
would be done on the
table if more than a certain percentage had changed.  It is not an elegant
solution.  A more pratical one , if you're using SQL Loader, is to use a
counter variable. If not using SQL Loader, then a synthetic key backed with
a trigger and sequence, could suffice.  It could give you the accurate
count after a load by checking the NEXTVAL.sequence_name or
CURRENTVAL.sequence_name.  The method could be put in a procedure to
improve efficiency.


Just a thought.


RWB

RE: count(*)

[Reginald . W . Bailey]

Paula et al:

It could work if the analyze is done after the load using DBMS_STATS. Then
the num_rows would be accurate.  With the monitoring turned on , analyzing
would be done on the
table if more than a certain percentage had changed.  It is not an elegant
solution.  A more pratical one , if you're using SQL Loader, is to use a
counter variable. If not using SQL Loader, then a synthetic key backed with
a trigger and sequence, could suffice.  It could give you the accurate
count after a load by checking the NEXTVAL.sequence_name or
CURRENTVAL.sequence_name.  The method could be put in a procedure to
improve efficiency.

Just a thought.

RWB




[EMAIL PROTECTED]@fatcity.com on 09/19/2002 05:38:24 PM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:




That won't work if he is constantly loading data as analyze is going to
take longer then just the count(*).  What about writing in the load process
or a trigger itself a variable with a running total could use dbms_output
to write it out to a file.  Starting with existing rowcount this would be
the fastest as you would really not have any additional I/O - just a
counter.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L


Try this:

select table_name, num_rows from dba_tables where table_name
= [table_name];

[table_name] = the name of the table or a variable.
This works if you are updating your statistics and you may also want
monitoring turned on for the table.
It is easier to get the information from the data dictionary sometimes,
than actually doing a count of rows. This is Oracle8i or above, right?

RWB




[EMAIL PROTECTED]@fatcity.com on 09/19/2002 01:28:27 PM

Please respond to [EMAIL PROTECTED]


Sent by:  [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:

Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time.

Can you please guide me to a direction ( built in functions or something
similar).

Actually this app is being ported from Informix. Informix can somehow keep
a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.

Thanks In Advance.

R.h
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: count(*)

[JApplewhite]

If you can modify the application code, how about incrementing a sequence
for each row inserted?  Not to hamper performance with a "Select
MySequence.NextVal From Dual" you could select from - I vaguely remember
this from a thread a few weeks ago - x$dual (or something like that - I
can't remember how to set this up, maybe you could check the archives).

Then you could simply query User_Sequences.Last_Number every 10 minutes to
see how many rows you've inserted.

If you can't modify the application code, how about an After Insert Row
trigger on the table that would increment the sequence?

It might work for you.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715
[EMAIL PROTECTED]



   
   
Rishi.Jain@verizonwi   
   
reless.com To: Multiple recipients of list 
ORACLE-L   
Sent by:<[EMAIL PROTECTED]> 
   
[EMAIL PROTECTED]   cc: 
   
   Subject: count(*)   
   
   
   
09/19/2002 01:28 PM
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time.

Can you please guide me to a direction ( built in functions or something
similar).

Actually this app is being ported from Informix. Informix can somehow keep
a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.

Thanks In Advance.

R.h



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Paula_Stankus]

Title: RE: count(*)





That won't work if he is constantly loading data as analyze is going to take longer then just the count(*).  What about writing in the load process or a trigger itself a variable with a running total could use dbms_output to write it out to a file.  Starting with existing rowcount this would be the fastest as you would really not have any additional I/O - just a counter.  

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: count(*)




Try this:


select table_name, num_rows from dba_tables where table_name
= [table_name];


[table_name] = the name of the table or a variable.
This works if you are updating your statistics and you may also want
monitoring turned on for the table.
It is easier to get the information from the data dictionary sometimes,
than actually doing a count of rows. This is Oracle8i or above, right?


RWB






[EMAIL PROTECTED]@fatcity.com on 09/19/2002 01:28:27 PM


Please respond to [EMAIL PROTECTED]




Sent by:  [EMAIL PROTECTED]



To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Hi Gurus,


In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time.


Can you please guide me to a direction ( built in functions or something
similar).


Actually this app is being ported from Informix. Informix can somehow keep
a
trak of the count(*) of a  table in its header somewhere.


And yes I have tries count(1) , count(indexed_column) etc.



Thanks In Advance.


R.h
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Mark J. Bobak]

That's certainly a possibility, but it still won't scale.  Regardless of
whether PQ is used, Oracle will need to do x consistent gets.  As the
tables grow larger, x will increase.  Regardless of whether PQ is used,
that number of buffer gets that are required will not change, and the
total load on the system will not change (except to increase as the
tables grow larger).  PQ may reduce elapsed time, but will do nothing
for the total resources consumed.

-Mark
On Thu, 2002-09-19 at 16:18, Suri, Deepak wrote:
> I have in the past used parallel hints to speed up a count(*) kind of full
> table scan query.
> 
> thanx
> deepak
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 2:28 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gurus,
> 
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is really
> killing us and it takes a lot of time. 
> 
> Can you please guide me to a direction ( built in functions or something
> similar). 
> 
> Actually this app is being ported from Informix. Informix can somehow keep a
> trak of the count(*) of a  table in its header somewhere.
> 
> And yes I have tries count(1) , count(indexed_column) etc.
> 
> 
> Thanks In Advance.
> 
> R.h
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
"It is not enough to have a good mind.  The main thing is to use it
well."
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: count(*)

[Reginald . W . Bailey]

Try this:

select table_name, num_rows from dba_tables where table_name
= [table_name];

[table_name] = the name of the table or a variable.
This works if you are updating your statistics and you may also want
monitoring turned on for the table.
It is easier to get the information from the data dictionary sometimes,
than actually doing a count of rows. This is Oracle8i or above, right?

RWB





[EMAIL PROTECTED]@fatcity.com on 09/19/2002 01:28:27 PM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time.

Can you please guide me to a direction ( built in functions or something
similar).

Actually this app is being ported from Informix. Informix can somehow keep
a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: count(*)

[Mark J. Bobak]

Hi Rishi,

Oracle does not keep track of the total number of rows anywhere.  When
you need to do this, you need to issue a 'select count(*)...'.  Note
that unless ou are on a very old version of Oracle count(*), count(1),
and count(pk_column) will do the same thing.  

This is a design issue.  You need to re-design your applicaiton to not
require that count(*) every 10 minutes.  You're right, it's killing
you.  And, as the tables continue to increase in size, this will NOT
scale.  You'll reach a point where the amount of time required to
execute a count(*) exceeds the amount of time between calls to
count(*).  When that happens, it's all over.  And, actually, even well
before that happens, the frequency of the count(*) operation will
severely limit your scalability.  

Sorry I can't offer any better solutions.

Hope that helps,

-Mark
On Thu, 2002-09-19 at 14:28, [EMAIL PROTECTED] wrote:
> Hi Gurus,
> 
> In one of our insert intensive application we are inserting around 3-4
> million rows / hour. Also this app needs to do a count(*) of the tables
> every 10 minutes for verifying some application based logic. This is really
> killing us and it takes a lot of time. 
> 
> Can you please guide me to a direction ( built in functions or something
> similar). 
> 
> Actually this app is being ported from Informix. Informix can somehow keep a
> trak of the count(*) of a  table in its header somewhere.
> 
> And yes I have tries count(1) , count(indexed_column) etc.
> 
> 
> Thanks In Advance.
> 
> R.h
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
"It is not enough to have a good mind.  The main thing is to use it
well."
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[DENNIS WILLIAMS]

Sent: Thursday, September 19, 2002 2:48 PM
To: '[EMAIL PROTECTED]'


Rishi - I've encountered this as well. I think the problem is the fact that
you are pounding millions of rows into the table. When you ask for a count,
Oracle won't give you an approximate answer, but insists on giving you a
precise answer as of the moment you hit return. You are right, your query
can actually slow performance. No, to my knowledge Oracle doesn't maintain a
record of the number of rows in the table, my guess being that could become
a performance bottleneck.
   My recommendation would be to ask very precisely what is to be achieved
with the count. As you noticed, the count will lag reality by quite awhile.
Perhaps the application could maintain the count. I have quite a few batch
programs that will display a running counter. If only an approximate count
is needed, there may be an alternate method, like looking at how many
segments are used and calculating. Just some thoughts.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count(*)

[Suri, Deepak]

I have in the past used parallel hints to speed up a count(*) kind of full
table scan query.

thanx
deepak

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

In one of our insert intensive application we are inserting around 3-4
million rows / hour. Also this app needs to do a count(*) of the tables
every 10 minutes for verifying some application based logic. This is really
killing us and it takes a lot of time. 

Can you please guide me to a direction ( built in functions or something
similar). 

Actually this app is being ported from Informix. Informix can somehow keep a
trak of the count(*) of a  table in its header somewhere.

And yes I have tries count(1) , count(indexed_column) etc.


Thanks In Advance.

R.h
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suri, Deepak
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Jared Still]

Nah, just too busy too deal with it right now.  :0

Jared

On Thursday 04 July 2002 06:18, Farnsworth, Dave wrote:
> Or Jared is busy signing copies of his Perl book.  ;o)
>
> Dave
>
> -Original Message-
> Sent: Wednesday, July 03, 2002 4:22 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I guess, Jared allows this thread to continue only because it's pre-holiday
> :-)
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
>
> - Original Message -
> To: Multiple   recipients of list ORACLE-L
> Sent: Wednesday, July 03, 2002 4:49 PM
>
>
> Something like Schrodinger's Cat!
>
> Jerry Whittle
>
> ACIFICS DBA
>
> NCI Information Systems Inc.
>
> [EMAIL PROTECTED]
>
> 618-622-4145
>
>   -Original Message-
>
>   From:   Fink, Dan [SMTP:[EMAIL PROTECTED]]
>
>   We are all missing the point. Without opening the file, it must be
> observed from the outside. As such, from this observation point, it
> contains no rows. Thus, the method is irrelevant as the answer will always
> be 'NONE'.
>
>   -Original Message-
>
>
>   If the room is dark, you may need to step on tails and count the
> YRss you hear. Of course, duplicates could still be a
> problem.
>
>   Jerry Whittle
> ACIFICS DBA
> NCI Information Systems Inc.
> [EMAIL PROTECTED]
> 618-622-4145
>
>   -Original Message-
>
>   gee, for simplicity's sake, I usually just count tails :)
>
>   --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > Count the eyes and divide by 2...
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> >
> > > Roland,
> > >
> > > How about counting black cats in the dark room without turning on
> >
> > the light?
> >
> > > Igor Neyman, OCP DBA
> > > [EMAIL PROTECTED]
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > >
> > > > Anyone whom has a good example on how to check "how many rows
> >
> > (without opening the file) does a text file consists of?
> >
> > > > What is the command?
> > > >
> > > > Thanks in advance
> > > >
> > > > Roland


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Farnsworth, Dave]

I think, therefore I am, I think?

Daves version of Rene Descartes

-Original Message-
Sent: Wednesday, July 03, 2002 4:40 PM
To: Multiple recipients of list ORACLE-L


Dan, I think you're forgetting the Hiesenberg Uncertainty Principle.
According to that, we can know the contents of the file or its location but
not both at the same time. Therefore, if we know where the file is, we can't
be certain that the answer is "none".

-Original Message-
From:   Fink, Dan [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 03, 2002 2:26 PM
To: Multiple recipients of list ORACLE-L
    Subject:RE: Count rows in textfile

We are all missing the point. Without opening the file, it must be
observed from the outside. As such, from this observation point, it contains
no rows. Thus, the method is irrelevant as the answer will always be 'NONE'.

-Original Message-
From: Whittle Jerome Contr NCI
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Count rows in textfile



If the room is dark, you may need to step on tails and count
the YRss you hear. Of course, duplicates could still be
a problem.

Jerry Whittle 
ACIFICS DBA 
NCI Information Systems Inc. 
[EMAIL PROTECTED] 
618-622-4145 

-Original Message- 
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]] 

gee, for simplicity's sake, I usually just count tails :) 

--- Tim Gorman <[EMAIL PROTECTED]> wrote: 
> Count the eyes and divide by 2... 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> 
> > Roland, 
> > 
> > How about counting black cats in the dark room without
turning on 
> the light? 
> > 
> > Igor Neyman, OCP DBA 
> > [EMAIL PROTECTED] 
> > 
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> > 
> > > Anyone whom has a good example on how to check "how
many rows 
> (without opening the file) does a text file consists of? 
> > > What is the command? 
> > > 
> > > Thanks in advance 
> > > 
> > > Roland 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stahlke, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Farnsworth, Dave]

Title: RE: Count rows in textfile



Or 
Jared is busy signing copies of his Perl book.  ;o)
 
Dave

  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 03, 2002 4:22 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Count rows in textfile
  I guess, Jared allows this thread to continue only because 
  it's pre-holiday :-)
   
  Igor Neyman, OCP DBA[EMAIL PROTECTED]  
  
  
- Original Message - 
From: 
Whittle Jerome Contr NCI 
To: Multiple 
recipients of list ORACLE-L 
Sent: Wednesday, July 03, 2002 4:49 
PM
Subject: RE: Count rows in 
textfile

Something like 
Schrodinger's Cat!
Jerry Whittle
ACIFICS DBA
NCI Information Systems 
Inc.
[EMAIL PROTECTED]
618-622-4145

  -Original 
  Message-
  From:   Fink, Dan 
  [SMTP:[EMAIL PROTECTED]]
  We are 
  all missing the point. Without opening the file, it must be observed from 
  the outside. As such, from this observation point, it contains no rows. 
  Thus, the method is irrelevant as the answer will always be 
  'NONE'.
  
-Original 
Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]
If the 
room is dark, you may need to step on tails and count the 
YRss you hear. Of course, duplicates could still be 
a problem.
Jerry WhittleACIFICS DBANCI Information Systems 
Inc.[EMAIL PROTECTED]618-622-4145 
-Original 
Message-From:   
Rachel Carmichael 
[SMTP:[EMAIL PROTECTED]] 
gee, for 
simplicity's sake, I usually just count tails :) 

--- Tim Gorman 
<[EMAIL PROTECTED]> wrote:> Count the eyes and divide by 2...>> - Original Message -> To: "Multiple 
recipients of list ORACLE-L" <[EMAIL PROTECTED]>>> > Roland,> >> > How about 
counting black cats in the dark room without turning on> the 
light?> 
>> > 
Igor Neyman, OCP DBA> > [EMAIL PROTECTED]> >> > - Original 
Message -> > To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>> >> > > Anyone whom has a good example on how 
to check "how many rows> (without opening the file) does a text file 
consists of?> > > What is the command?> > >> > > Thanks in 
advance> 
> >> 
> > Roland 
  

Re: Count rows in textfile

[Alexandre Gorbatchev]

That's called estimation.

> add 10% for the ones that are asleep...
>
> -Original Message-
> Sent: Wednesday, July 03, 2002 12:33 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Count the eyes and divide by 2...
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 9:18 AM
>
>
> > Roland,
> >
> > How about counting black cats in the dark room without turning on the
> light?
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 4:43 AM
> >
> >
> > > Anyone whom has a good example on how to check "how many rows (without
> > opening the file) does a text file consists of?
> > > What is the command?
> > >
> > >
> > > Thanks in advance
> > >
> > >
> > > Roland
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>






>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Bunyamin Karadeniz]

You can do it easily with AWK

awk -f myawk1 /dir1/masters.txt

source of myawk1 is :
BEGIN { } END {print "there are ",NR," lines"  }

Bunyamin

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 9:03 PM


My wife recently bought a book called "Unix for Dummies".  I'm sure it
documents the command you need if you are using any flavor of Unix.  For
Micromonopoly operating systems, either get a Unix shell emulator such as
cygwin or find a Microsoft Press book and see what it says.

Of course, any command that counts rows in a text file will need to open the
file -- there is no alternative.
Kevin Kennedy
First Point Energy Corporation

-Original Message-
Sent: Wednesday, July 03, 2002 1:43 AM
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?


Thanks in advance


Roland




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin Karadeniz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Nils Höglund]

> Can we find how much roe is in a fish without opening it?

x-ray


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Rachel Carmichael]

even "tailless" cats like the manx have a tail - it's just a stubby
tail 


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> Ah, but what if some of the cats are the tailless kind (Manx?)
> 
> -Original Message-
> Sent: Wednesday, July 03, 2002 11:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> gee, for simplicity's sake, I usually just count tails :)
> 
> 
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > Count the eyes and divide by 2...
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 9:18 AM
> > 
> > 
> > > Roland,
> > >
> > > How about counting black cats in the dark room without turning on
> > the
> > light?
> > >
> > > Igor Neyman, OCP DBA
> > > [EMAIL PROTECTED]
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, July 03, 2002 4:43 AM
> > >
> > >
> > > > Anyone whom has a good example on how to check "how many rows
> > (without
> > > opening the file) does a text file consists of?
> > > > What is the command?
> > > >
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > > Roland
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author:
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> > 538-5051
> > > > San Diego, California-- Public Internet access /
> Mailing
> > Lists
> > > >
> >
> 
> > > > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and
> > in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You
> > may
> > > > also send the HELP command for other information (like
> > subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Igor Neyman
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You
> may
> > > also send the HELP command for other information (like
> > subscribing).
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Tim Gorman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fink, Dan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Jeremy Bainbridge-Smith]

Title: RE: Count rows in textfile





If you're using Unix, try:


cat filename | wc -l


Cheers
Jeremy


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 3 July 2002 8:43 PM
To: Multiple recipients of list ORACLE-L
Subject: Count rows in textfile



Anyone whom has a good example on how to check "how many rows (without opening the file) does a text file consists of?
What is the command?



Thanks in advance



Roland





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Henry Poras]

I think it has to do with Access.???

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 5:07 PM


What is zipper?

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


Roland,

Just go ahead and open the file.  You know you want to.  We both know that
it would be soo satisfying to just take a peek inside, right?  That way
you can count lines.  I'm sure you can handle up to ~20 or so with your
zipper up, right?  No one needs to know...

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 03, 2002 3:43 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Count rows in textfile
> 
> Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> What is the command?
> 
> 
> Thanks in advance
> 
> 
> Roland
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Jesse, Rich]

Or, more specifically, some number >= the filesize, since the filesize isn't
stored as part of the file (file header and/or directory, depending on the
filesystem).

Given that and Economic Law of Purchasing an Infinite Amount of Storage,
every file that exists will have:

filesize >= Rows < infinity

And, according to the Guinness Principle, we can only know that beer is good
if it is drunk.  Much like I plan to be shortly after a trip to the liquor
depot.


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Johan Hermansson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 03, 2002 3:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Count rows in textfile
> 
> 
> On Wed, Jul 03, 2002 at 12:26:13PM -0800, Fink, Dan wrote:
> 
> > We are all missing the point. Without opening the file, it 
> must be observed
> > from the outside. As such, from this observation point, it 
> contains no rows.
> > Thus, the method is irrelevant as the answer will always be 'NONE'.
> 
> Why is it it has to contain no rows? Why can't it equally 
> contain infinite amount of rows, or a random amount?
> 
> 
> -- 
> Johan Hermansson   +46-(0)709-919763
> Naqua KB<[EMAIL PROTECTED]>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Orr, Steve]

Sort of topical... 
I guess you've heard about how the Heisenberg Uncertainty Principle is being
used for "hacker proof" security. Data is being transfered via light and if
it's been looked at over a certain threshold number of times then it's
rejected. Check it out at...
http://techupdate.zdnet.com/techupdate/stories/main/0,14179,2861716,00.html



-Original Message-
Sent: Wednesday, July 03, 2002 3:40 PM
To: Multiple recipients of list ORACLE-L


Dan, I think you're forgetting the Hiesenberg Uncertainty Principle.
According to that, we can know the contents of the file or its location but
not both at the same time. Therefore, if we know where the file is, we can't
be certain that the answer is "none".

-Original Message-
From:   Fink, Dan [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 03, 2002 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Count rows in textfile

We are all missing the point. Without opening the file, it must be
observed from the outside. As such, from this observation point, it contains
no rows. Thus, the method is irrelevant as the answer will always be 'NONE'.

-Original Message-
From: Whittle Jerome Contr NCI
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Count rows in textfile



If the room is dark, you may need to step on tails and count
the YRss you hear. Of course, duplicates could still be
a problem.

Jerry Whittle 
ACIFICS DBA 
NCI Information Systems Inc. 
[EMAIL PROTECTED] 
618-622-4145 

-Original Message- 
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]] 

gee, for simplicity's sake, I usually just count tails :) 

--- Tim Gorman <[EMAIL PROTECTED]> wrote: 
> Count the eyes and divide by 2... 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> 
> > Roland, 
> > 
> > How about counting black cats in the dark room without
turning on 
> the light? 
> > 
> > Igor Neyman, OCP DBA 
> > [EMAIL PROTECTED] 
> > 
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> > 
> > > Anyone whom has a good example on how to check "how
many rows 
> (without opening the file) does a text file consists of? 
> > > What is the command? 
> > > 
> > > Thanks in advance 
> > > 
> > > Roland 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stahlke, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Ji, Richard]

Title: RE: Count rows in textfile



He is 
probably on holiday already. :)

  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 03, 2002 5:22 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Count rows in textfile
  I guess, Jared allows this thread to continue only because 
  it's pre-holiday :-)
   
  Igor Neyman, OCP DBA[EMAIL PROTECTED]  
  
  
- Original Message - 
From: 
Whittle Jerome Contr NCI 

To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, July 03, 2002 4:49 
PM
Subject: RE: Count rows in 
textfile

Something like 
Schrodinger's Cat!
Jerry Whittle
ACIFICS DBA
NCI Information Systems 
Inc.
[EMAIL PROTECTED]
618-622-4145

  -Original 
  Message-
  From:   Fink, Dan 
  [SMTP:[EMAIL PROTECTED]]
  We are 
  all missing the point. Without opening the file, it must be observed from 
  the outside. As such, from this observation point, it contains no rows. 
  Thus, the method is irrelevant as the answer will always be 
  'NONE'.
  
-Original 
Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]
If the 
room is dark, you may need to step on tails and count the 
YRss you hear. Of course, duplicates could still be 
a problem.
Jerry WhittleACIFICS DBANCI Information Systems 
Inc.[EMAIL PROTECTED]618-622-4145 
-Original 
Message-From:   
Rachel Carmichael 
[SMTP:[EMAIL PROTECTED]] 
gee, for 
simplicity's sake, I usually just count tails :) 

--- Tim Gorman 
<[EMAIL PROTECTED]> wrote:> Count the eyes and divide by 2...>> - Original Message -> To: "Multiple 
recipients of list ORACLE-L" <[EMAIL PROTECTED]>>> > Roland,> >> > How about 
counting black cats in the dark room without turning on> the 
light?> 
>> > 
Igor Neyman, OCP DBA> > [EMAIL PROTECTED]> >> > - Original 
Message -> > To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>> >> > > Anyone whom has a good example on how 
to check "how many rows> (without opening the file) does a text file 
consists of?> > > What is the command?> > >> > > Thanks in 
advance> 
> >> 
> > Roland 
  

RE: Count rows in textfile

[Stahlke, Mark]

Dan, I think you're forgetting the Hiesenberg Uncertainty Principle.
According to that, we can know the contents of the file or its location but
not both at the same time. Therefore, if we know where the file is, we can't
be certain that the answer is "none".

-Original Message-
From:   Fink, Dan [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 03, 2002 2:26 PM
To: Multiple recipients of list ORACLE-L
    Subject:RE: Count rows in textfile

We are all missing the point. Without opening the file, it must be
observed from the outside. As such, from this observation point, it contains
no rows. Thus, the method is irrelevant as the answer will always be 'NONE'.

-Original Message-
From: Whittle Jerome Contr NCI
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Count rows in textfile



If the room is dark, you may need to step on tails and count
the YRss you hear. Of course, duplicates could still be
a problem.

Jerry Whittle 
ACIFICS DBA 
NCI Information Systems Inc. 
[EMAIL PROTECTED] 
618-622-4145 

-Original Message- 
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]] 

gee, for simplicity's sake, I usually just count tails :) 

--- Tim Gorman <[EMAIL PROTECTED]> wrote: 
> Count the eyes and divide by 2... 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> 
> > Roland, 
> > 
> > How about counting black cats in the dark room without
turning on 
> the light? 
> > 
> > Igor Neyman, OCP DBA 
> > [EMAIL PROTECTED] 
> > 
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> > 
> > > Anyone whom has a good example on how to check "how
many rows 
> (without opening the file) does a text file consists of? 
> > > What is the command? 
> > > 
> > > Thanks in advance 
> > > 
> > > Roland 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stahlke, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Igor Neyman]

Title: RE: Count rows in textfile



I guess, Jared allows this thread to continue only because 
it's pre-holiday :-)
 
Igor Neyman, OCP DBA[EMAIL PROTECTED]  


  - Original Message - 
  From: 
  Whittle Jerome Contr NCI 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, July 03, 2002 4:49 
  PM
  Subject: RE: Count rows in textfile
  
  Something like 
  Schrodinger's Cat!
  Jerry Whittle
  ACIFICS DBA
  NCI Information Systems 
  Inc.
  [EMAIL PROTECTED]
  618-622-4145
  
-Original 
Message-
From:   Fink, Dan 
[SMTP:[EMAIL PROTECTED]]
We are all 
missing the point. Without opening the file, it must be observed from the 
outside. As such, from this observation point, it contains no rows. Thus, 
the method is irrelevant as the answer will always be 
'NONE'.

  -Original 
  Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]
  If the 
  room is dark, you may need to step on tails and count the 
  YRss you hear. Of course, duplicates could still be a 
  problem.
  Jerry WhittleACIFICS DBANCI Information Systems 
  Inc.[EMAIL PROTECTED]618-622-4145 
  -Original 
  Message-From:   Rachel Carmichael 
  [SMTP:[EMAIL PROTECTED]] 
  gee, for simplicity's 
  sake, I usually just count tails :) 
  
  --- Tim Gorman 
  <[EMAIL PROTECTED]> wrote:> Count the eyes and divide by 2...>> - Original Message -> To: "Multiple 
  recipients of list ORACLE-L" <[EMAIL PROTECTED]>>> > Roland,> >> > How about counting 
  black cats in the dark room without turning on> the light?> >> > Igor Neyman, OCP 
  DBA> > 
  [EMAIL PROTECTED]> >> > - Original Message -> > To: "Multiple 
  recipients of list ORACLE-L" <[EMAIL PROTECTED]>> >> > > Anyone whom 
  has a good example on how to check "how many rows> (without opening the 
  file) does a text file consists of?> > > What is the 
  command?> 
  > >> 
  > > Thanks in advance> > >> > > Roland 
  

RE: Count rows in textfile

[Farnsworth, Dave]

What is zipper?

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


Roland,

Just go ahead and open the file.  You know you want to.  We both know that
it would be soo satisfying to just take a peek inside, right?  That way
you can count lines.  I'm sure you can handle up to ~20 or so with your
zipper up, right?  No one needs to know...

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 03, 2002 3:43 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Count rows in textfile
> 
> Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> What is the command?
> 
> 
> Thanks in advance
> 
> 
> Roland
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Whittle Jerome Contr NCI]

Title: RE: Count rows in textfile






Something like Schrodinger's Cat!

Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From:   Fink, Dan [SMTP:[EMAIL PROTECTED]]

We are all missing the point. Without opening the file, it must be observed from the outside. As such, from this observation point, it contains no rows. Thus, the method is irrelevant as the answer will always be 'NONE'.

-Original Message-
From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]


If the room is dark, you may need to step on tails and count the YRss you hear. Of course, duplicates could still be a problem.

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145 

-Original Message-
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]] 

gee, for simplicity's sake, I usually just count tails :) 

--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> Count the eyes and divide by 2...
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>
> > Roland,
> >
> > How about counting black cats in the dark room without turning on
> the light?
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> >
> > > Anyone whom has a good example on how to check "how many rows
> (without opening the file) does a text file consists of?
> > > What is the command?
> > >
> > > Thanks in advance
> > >
> > > Roland 

Re: Count rows in textfile

[Johan Hermansson]

On Wed, Jul 03, 2002 at 12:26:13PM -0800, Fink, Dan wrote:

> We are all missing the point. Without opening the file, it must be observed
> from the outside. As such, from this observation point, it contains no rows.
> Thus, the method is irrelevant as the answer will always be 'NONE'.

Why is it it has to contain no rows? Why can't it equally contain infinite amount of 
rows, or a random amount?


-- 
Johan Hermansson   +46-(0)709-919763
Naqua KB<[EMAIL PROTECTED]>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Hermansson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Michael Cupp]

X-ray?

-Original Message-
Sent: Wednesday, July 03, 2002 4:26 PM
To: Multiple recipients of list ORACLE-L


Can we find how much roe is in a fish without opening it?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 1:58 PM


> gee, for simplicity's sake, I usually just count tails :)
> 
> 
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > Count the eyes and divide by 2...
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 9:18 AM
> > 
> > 
> > > Roland,
> > >
> > > How about counting black cats in the dark room without turning on
> > the
> > light?
> > >
> > > Igor Neyman, OCP DBA
> > > [EMAIL PROTECTED]
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, July 03, 2002 4:43 AM
> > >
> > >
> > > > Anyone whom has a good example on how to check "how many rows
> > (without
> > > opening the file) does a text file consists of?
> > > > What is the command?
> > > >
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > > Roland
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author:
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> > 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > > >
> > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail 
> > > > message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> > in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L (or 
> > > > the name of mailing list you want to be removed from).  You
> > may
> > > > also send the HELP command for other information (like
> > subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Igor Neyman
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
> > > in the message BODY, include a line containing: UNSUB ORACLE-L (or 
> > > the name of mailing list you want to be removed from).  You may 
> > > also send the HELP command for other information (like
> > subscribing).
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Tim Gorman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may also 
> > send the HELP command for other information (like subscribing).
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 
removed from).  You may also send the HELP command for other information (like 
subscribing).

Re: Count rows in textfile

[Nils Höglund]

> if you're on unix and have bash use 
> 
> $ wc

Actually wc isn't a part of the bash-shell, but an independent program.


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Henry Poras]

Can we find how much roe is in a fish without opening it?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 1:58 PM


> gee, for simplicity's sake, I usually just count tails :)
> 
> 
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > Count the eyes and divide by 2...
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 9:18 AM
> > 
> > 
> > > Roland,
> > >
> > > How about counting black cats in the dark room without turning on
> > the
> > light?
> > >
> > > Igor Neyman, OCP DBA
> > > [EMAIL PROTECTED]
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, July 03, 2002 4:43 AM
> > >
> > >
> > > > Anyone whom has a good example on how to check "how many rows
> > (without
> > > opening the file) does a text file consists of?
> > > > What is the command?
> > > >
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > > Roland
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author:
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> > 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > > >
> > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> > in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You
> > may
> > > > also send the HELP command for other information (like
> > subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Igor Neyman
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like
> > subscribing).
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Tim Gorman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Fink, Dan]

Title: RE: Count rows in textfile



We are 
all missing the point. Without opening the file, it must be observed from the 
outside. As such, from this observation point, it contains no rows. Thus, the 
method is irrelevant as the answer will always be 'NONE'.

  -Original Message-From: Whittle Jerome Contr NCI 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 03, 2002 
  1:34 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Count rows in textfile
  If the room is dark, 
  you may need to step on tails and count the YRss you hear. 
  Of course, duplicates could still be a problem.
  Jerry Whittle ACIFICS DBA NCI Information Systems Inc. 
  [EMAIL PROTECTED] 618-622-4145 
  
-Original 
Message- From:   Rachel 
Carmichael [SMTP:[EMAIL PROTECTED]] 
gee, for simplicity's sake, I 
usually just count tails :) 
--- Tim Gorman 
<[EMAIL PROTECTED]> wrote: > Count the eyes and divide by 2... 
> > - Original Message 
- > To: 
"Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]> > > > Roland, > > > > How about counting black cats in the dark room without 
turning on > 
the light? > 
> > > 
Igor Neyman, OCP DBA > > [EMAIL PROTECTED] > > > > - Original Message 
- > > 
To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]> > > > > > Anyone whom has a good example on how to 
check "how many rows > (without opening the file) does a text file consists 
of? > > 
> What is the command? > > > > > > Thanks in advance > > > > > > Roland 
  

RE: Count rows in textfile

[Fink, Dan]

Ah, but what if some of the cats are the tailless kind (Manx?)

-Original Message-
Sent: Wednesday, July 03, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L


gee, for simplicity's sake, I usually just count tails :)


--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> Count the eyes and divide by 2...
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 9:18 AM
> 
> 
> > Roland,
> >
> > How about counting black cats in the dark room without turning on
> the
> light?
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 4:43 AM
> >
> >
> > > Anyone whom has a good example on how to check "how many rows
> (without
> > opening the file) does a text file consists of?
> > > What is the command?
> > >
> > >
> > > Thanks in advance
> > >
> > >
> > > Roland
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> Lists
> > >
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You
> may
> > > also send the HELP command for other information (like
> subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Igor Neyman]

in the dark? :-)

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 1:58 PM


> gee, for simplicity's sake, I usually just count tails :)
> 
> 
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > Count the eyes and divide by 2...
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 9:18 AM
> > 
> > 
> > > Roland,
> > >
> > > How about counting black cats in the dark room without turning on
> > the
> > light?
> > >
> > > Igor Neyman, OCP DBA
> > > [EMAIL PROTECTED]
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, July 03, 2002 4:43 AM
> > >
> > >
> > > > Anyone whom has a good example on how to check "how many rows
> > (without
> > > opening the file) does a text file consists of?
> > > > What is the command?
> > > >
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > > Roland
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author:
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> > 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > > >
> > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> > in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You
> > may
> > > > also send the HELP command for other information (like
> > subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Igor Neyman
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like
> > subscribing).
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Tim Gorman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Grabowy, Chris]

Look folks, just setup your claymore mine, fire it, and then you can count
the cat hearts with your Rambo knife...it's easy.

-Original Message-
Sent: Wednesday, July 03, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L


add 10% for the ones that are asleep...

-Original Message-
Sent: Wednesday, July 03, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


Count the eyes and divide by 2...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 9:18 AM


> Roland,
>
> How about counting black cats in the dark room without turning on the
light?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 4:43 AM
>
>
> > Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> > What is the command?
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Whittle Jerome Contr NCI]

Title: RE: Count rows in textfile






If the room is dark, you may need to step on tails and count the YRss you hear. Of course, duplicates could still be a problem.

Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]


gee, for simplicity's sake, I usually just count tails :)


--- Tim Gorman <[EMAIL PROTECTED]> wrote:

> Count the eyes and divide by 2...

> 

> - Original Message -

> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>

> 

> > Roland,

> >

> > How about counting black cats in the dark room without turning on

> the light?

> >

> > Igor Neyman, OCP DBA

> > [EMAIL PROTECTED]

> >

> > - Original Message -

> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>

> >

> > > Anyone whom has a good example on how to check "how many rows

> (without opening the file) does a text file consists of?

> > > What is the command?

> > >

> > > Thanks in advance

> > >

> > > Roland

Re: Count rows in textfile

[Johan Hermansson]

On Wed, Jul 03, 2002 at 03:43:20AM -0800, Tim Bunce wrote:

> You might find this interesting:
> 
> http://www.ling.helsinki.fi/~reriksso/unix/award.html#cat
> 
> :-)

Ooh, that one is going into my bookmarks. :-)

-- 
Johan Hermansson   +46-(0)709-919763
Naqua KB<[EMAIL PROTECTED]>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Hermansson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Post, Ethan]

I had to find out more...

http://www.ling.helsinki.fi/~reriksso/unix/award.html

Ethan Post
perotdba (AIM), epost1 (Yahoo)



-Original Message-
Sent: Wednesday, July 03, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


John,

If you were to put that on usenet, Randal Schwartz would nail you
with 'another useless use of cat' award.  ;)

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/03/2002 02:53 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:    RE: Count rows in textfile


Try the following which will give the number of line in the file

cat filename | wc -l 

HTH

John


-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Scott . Shafer]

Roland,

Just go ahead and open the file.  You know you want to.  We both know that
it would be soo satisfying to just take a peek inside, right?  That way
you can count lines.  I'm sure you can handle up to ~20 or so with your
zipper up, right?  No one needs to know...

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 03, 2002 3:43 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Count rows in textfile
> 
> Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> What is the command?
> 
> 
> Thanks in advance
> 
> 
> Roland
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[kkennedy]

But, it's obvious that he included the cat so that he could count the eyes!  
Otherwise, I would agree that the cat was not needed.
Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Wednesday, July 03, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L


John,

If you were to put that on usenet, Randal Schwartz would nail you
with 'another useless use of cat' award.  ;)

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/03/2002 02:53 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
        Subject:RE: Count rows in textfile


Try the following which will give the number of line in the file

cat filename | wc -l 

HTH

John


-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Ji, Richard]

You are assuming:

1)  All cats are looking at you.
2)  They all sitting still.
3)  None of them are alseep.

:)

-Original Message-
Sent: Wednesday, July 03, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L



> How about counting black cats in the dark room without turning on the
light?

You'll probobly see the reflextions of the cats eyes, even in the dark.

1) Count the number of eyes you see.
2) Divide that number in two.

Very easy. :)


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ji, Richard
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[kkennedy]

My wife recently bought a book called "Unix for Dummies".  I'm sure it documents the 
command you need if you are using any flavor of Unix.  For Micromonopoly operating 
systems, either get a Unix shell emulator such as cygwin or find a Microsoft Press 
book and see what it says.

Of course, any command that counts rows in a text file will need to open the file -- 
there is no alternative.
Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Wednesday, July 03, 2002 1:43 AM
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without opening the 
file) does a text file consists of?
What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Toepke, Kevin M]

try surfing to shopping.yahoo.com and search for "infra red glasses"
(without the quotes) and you'll see a variety of products. May I recommend
that you instead get night vision goggles (search for "night vision
goggles") Most of the better ons have built-in IR illumination that allows
you to see in _total_ darkness!


-Original Message-
Sent: Wednesday, July 03, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L


No problem.
Just use infra red glasses.

Question:
What are infra red glasses?
Where can I get one.
Can someone give me an example?
:-)))

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 5:18 PM


> Roland,
>
> How about counting black cats in the dark room without turning on the
light?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 4:43 AM
>
>
> > Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> > What is the command?
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[April Wells]

add 10% for the ones that are asleep...

-Original Message-
Sent: Wednesday, July 03, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


Count the eyes and divide by 2...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 9:18 AM


> Roland,
>
> How about counting black cats in the dark room without turning on the
light?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 4:43 AM
>
>
> > Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> > What is the command?
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Michael Cupp]

What if they're one eyed cats?

-Original Message-
Sent: Wednesday, July 03, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


Count the eyes and divide by 2...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 9:18 AM


> Roland,
>
> How about counting black cats in the dark room without turning on the
light?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 4:43 AM
>
>
> > Anyone whom has a good example on how to check "how many rows 
> > (without
> opening the file) does a text file consists of?
> > What is the command?
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may also 
> > send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 
removed from).  You may also send the HELP command for other information (like 
subscribing).


This message originated from the internet.  Its originator may not be who they claim 
to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Cupp
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Yechiel Adar]

No problem.
Just use infra red glasses.

Question:
What are infra red glasses?
Where can I get one.
Can someone give me an example?
:-)))

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 5:18 PM


> Roland,
>
> How about counting black cats in the dark room without turning on the
light?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 4:43 AM
>
>
> > Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> > What is the command?
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Tim Gorman]

Count the eyes and divide by 2...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 9:18 AM


> Roland,
>
> How about counting black cats in the dark room without turning on the
light?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 4:43 AM
>
>
> > Anyone whom has a good example on how to check "how many rows (without
> opening the file) does a text file consists of?
> > What is the command?
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Rachel Carmichael]

gee, for simplicity's sake, I usually just count tails :)


--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> Count the eyes and divide by 2...
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 9:18 AM
> 
> 
> > Roland,
> >
> > How about counting black cats in the dark room without turning on
> the
> light?
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 4:43 AM
> >
> >
> > > Anyone whom has a good example on how to check "how many rows
> (without
> > opening the file) does a text file consists of?
> > > What is the command?
> > >
> > >
> > > Thanks in advance
> > >
> > >
> > > Roland
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> Lists
> > >
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You
> may
> > > also send the HELP command for other information (like
> subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Nils Höglund]

> How about counting black cats in the dark room without turning on the light?

You'll probobly see the reflextions of the cats eyes, even in the dark.

1) Count the number of eyes you see.
2) Divide that number in two.

Very easy. :)


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Jared . Still]

John,

If you were to put that on usenet, Randal Schwartz would nail you
with 'another useless use of cat' award.  ;)

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/03/2002 02:53 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:    RE: Count rows in textfile


Try the following which will give the number of line in the file

cat filename | wc -l 

HTH

John


-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Daniel Wisser]

hi roland!

if you're on unix and have bash use 

$ wc

which has a lot of super options, see --> $ man wc

i think it's the same on ksh too, but am not sure.


if you're on w3, i would either install cygwin, then
use can use bash, too, or write a little perl script


daniel


[EMAIL PROTECTED] wrote:
> 
> Anyone whom has a good example on how to check "how many rows (without opening the 
>file) does a text file consists of?
> What is the command?
> 
> Thanks in advance
> 
> Roland
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Daniel Wisser, Mag. 
Papyrus Quality Assurance 
DB Team 

ISIS Information Systems
Alter Wienerweg 12
A-2344 Ma. Enzersdorf, Austria

Phone: +43-2236-27551-149
Fax: +43-2236-21081
E-mail: [EMAIL PROTECTED]

Hotline: +43-2236-27551-111

Visit the ISIS Website: http://www.isis-papyrus.com

---
This e-mail is only intended for the recipient and not legally 
binding. Unauthorised use, publication, reproduction or 
disclosure of the content of this e-mail is not permitted.
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Michael Cupp]

Try wc txtfilename
It will return # of Chars, # of Words, # of lines

-Original Message-
Sent: Wednesday, July 03, 2002 4:43 AM
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without opening the 
file) does a text file consists of? What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 
removed from).  You may also send the HELP command for other information (like 
subscribing).


This message originated from the internet.  Its originator may not be who they claim 
to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Cupp
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Jerry Hess]

Roland, under Unix you can use the Word Count(wc) command. Type in "wc -l
filename".


-Original Message-
Sent: Wednesday, July 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


Roland,

How about counting black cats in the dark room without turning on the light?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 4:43 AM


> Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
> What is the command?
>
>
> Thanks in advance
>
>
> Roland
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jerry Hess
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Igor Neyman]

Roland,

How about counting black cats in the dark room without turning on the light?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 4:43 AM


> Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
> What is the command?
>
>
> Thanks in advance
>
>
> Roland
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Tim Bunce]

On Wed, Jul 03, 2002 at 01:53:25AM -0800, [EMAIL PROTECTED] wrote:
> Try the following which will give the number of line in the file
> 
> cat filename | wc -l 

You might find this interesting:

http://www.ling.helsinki.fi/~reriksso/unix/award.html#cat

:-)

Tim.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Bunce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[John . Hallas]

Try the following which will give the number of line in the file

cat filename | wc -l 

HTH

John


-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Hately Mike]

Roland 

wc -l   (assuming you're in unix)

Mike Hately

-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L


Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?


Thanks in advance


Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Count rows in textfile

[Nils Höglund]

> Anyone whom has a good example on how to check "how many rows (without opening the 
>file) does a text file consists of?
> What is the command?

I don't know about "without opening the file."

However, you can use the utility 'wc' with the -l flag to count rows in a
file.

The syntax is:  wc -l filename

wc can also count rows from stdin with wc:  wc -l < filename

-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count rows that are being imported

[Mercadante, Thomas F]

srinivas,

Also look at using the COMMIT=Y command line prompt.  This will commit the
imported records every so often which would allow you to perform your select
count(*) command.

Be aware that if your import plan requires a complete rollback if something
bad happens, then using COMMIT=Y is probably not what you want to do, as the
records are truely committed.  In that case, as Bruce said, using the
FEEDBACK command is probably better.

For a quick reference of commands, type IMP HELP=Y at the command line.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 1:30 AM
To: Multiple recipients of list ORACLE-L


Hi,

Look into imp -feedback.

>From the manual (816 Utilities, chapter 2):

FEEDBACK
Default: 0 (zero) 

Specifies that Import should display a progress meter in the form of a dot
for n number of rows imported. For example, if you specify FEEDBACK=10,
Import displays a dot each time 10 rows have been imported. The FEEDBACK
value applies to all tables being imported; it cannot be set on a per-table
basis. 



If your import has already started, you could possibly use logminer to query
the redo / archive logs to count the number of inserted rows - I haven't
tried this though.


HTH,
Bruce Reardon

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 2 October 2001 15:10

Hi lists,

I have a tablespace that is 600 M size, has 4 million rows.

It is taking nearly 2 hrs to finish the import.

In the meantime, I tried selecting howmany rows imported(from another
session), but every time I issue query,the result is zero. 

But after finishing the import I got the total count.

Is there anyway to see how may rows imported in that table(in the middle
or import process, from another session) ?

thnx in adv.

srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count rows that are being imported

[Suhen Pather]

Srinivas,

Do you have any indexes, constraints, triggers on this table
When trying to import.
Cause this can reduce import performance substantially.

Just to let you know, on a DELL 6450 Windoze NT Server, I get can import 2
million records per minute as long as there are no indexes or constraints
present.
Depending on the size of your server and disk speeds you should be able to
achieve good performance as long there are no indexes, constraints.

For large tables it is better to drop the indexes, constraints.
Import the data and then rebuild the indexes and enable constraints.

Make sure there is no contention for disk io between dump file and
datafiles.

Use commit=n ,make sure you have a large rollback segment online eg. BIGR.
Switch smaller rollback segments offline.

I use this useful script from Frank Naude's Orafaq.


  select substr(sql_text,instr(sql_text,'INTO "'),30) table_name,
 rows_processed,
 round((sysdate-to_date(first_load_time,'-mm-dd
hh24:mi:ss'))*24*60,1) minutes,
 trunc(rows_processed/((sysdate-to_date(first_load_time,'-mm-dd
hh24:mi:ss'))*24*60)) rows_per_min
  from   sys.v_$sqlarea
  where  sql_text like 'INSERT %INTO "%'
and  command_type = 2
and  open_versions > 0;


This tells me how far the import is gone.

Regards
Suhen



Hi lists,

I have a tablespace that is 600 M size, has 4 million rows.

It is taking nearly 2 hrs to finish the import.

In the meantime, I tried selecting howmany rows imported(from another
session), but every time I issue query,the result is zero. 

But after finishing the import I got the total count.

Is there anyway to see how may rows imported in that table(in the middle
or import process, from another session) ?

thnx in adv.

srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suhen Pather
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: count rows that are being imported

[Reardon, Bruce (CALBBAY)]

Hi,

Look into imp -feedback.

>From the manual (816 Utilities, chapter 2):

FEEDBACK
Default: 0 (zero) 

Specifies that Import should display a progress meter in the form of a dot
for n number of rows imported. For example, if you specify FEEDBACK=10,
Import displays a dot each time 10 rows have been imported. The FEEDBACK
value applies to all tables being imported; it cannot be set on a per-table
basis. 



If your import has already started, you could possibly use logminer to query
the redo / archive logs to count the number of inserted rows - I haven't
tried this though.


HTH,
Bruce Reardon

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 2 October 2001 15:10

Hi lists,

I have a tablespace that is 600 M size, has 4 million rows.

It is taking nearly 2 hrs to finish the import.

In the meantime, I tried selecting howmany rows imported(from another
session), but every time I issue query,the result is zero. 

But after finishing the import I got the total count.

Is there anyway to see how may rows imported in that table(in the middle
or import process, from another session) ?

thnx in adv.

srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).