date:20010910


Rarely would you need to compress an index.


Compression of an index is perfect for a case as follows:

Table 1

Col1Col2   Col3
--
45100   1
25  124 34423
04  124 24643252
06  100 23423052
01  100 3242422
08  123 4252525
02  123 324234

If there was an index on Col2, Col3, compress 1 would help a lot in
efficiency.

One thing about compressiong, although it keeps your physical io / logical
io down, it increases your cpu usage slightly.
More importantly, you slightly increase the chance of locking blocks as more
rows are stored in the index.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L



Ian,

I'll look at compressing the index.   Does that only work on unique indexes
or can you
do it on non-unique multi-column indexes as well?

Thanks,

Cherie


 

MacGregor,

Ian A.  To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]  
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full index
scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om

 

 

09/07/01 03:26

PM

Please respond

to ORACLE-L

 

 





The advantage of the fast full index scan is that it should read fewer
blocks than the full table scan.  Index compression may help reduce the
number of blocks read even further.   A unique index mist be at least two
columns wide to benefit from compression.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, September 07, 2001 5:20 AM
To: Multiple recipients of list ORACLE-L



Ian,

The last one I looked at it was cached, I guess.   I could purposely cache
the
table (and index) if it was small, though.

I'm confused though.   Isn't the whole benefit of the fast, full index scan
that you
don't have to go against the table, thereby avoiding those physical reads?

Or, in the case where the index isn't cached, is the benefit that you don't
have to read all of the columns in the table that aren't part of the index?

Thanks for your reply,

Cherie



MacGregor,

Ian A.  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full
index scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om



09/07/01 01:05

AM

Please respond

to ORACLE-L







There is no rule that says an index will be cache.  Yes physical reads are
being done. If the unique index is composed of more than one column look
into compressing it.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Thursday, September 06, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



I am confused by the output from tkprof below.   An fast full index
scan is being performed.   However, from the statistics, it looks as
thought 649 physical disk reads are being performed.  Is that actually
the case?   Are physical disk reads being done?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network





Select SD.KS_OBJECTID as CONCEPTID
From kbowner.KS_SHORTDESCRIPTION SD
Where SD.KS_DESCRIPTIONTYPE = 'CPTNAME' And
UPPER(SD.KS_DESCRIPTIONTEXT) = ''

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.03   0.03  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch1  0.30   0.30649649  4
0
--- --   -- -- -- --
--
total3  0.33   0.33649649  4
0

Rows Row Source Operation
---  ---
  0  INDEX FAST FULL SCAN (object id 5286)


Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: CHOOSE
  0   INDEX   GOAL: ANALYZED

RE: export user definitions

2001-09-10 Thread Rajesh Dayal


Thanks a lot for correcting me,I just remembered the basic idea
and missed the real stuff ( SHOW=Y AND LOG=filename)
Too Busy with some bugsNpatches of 8.1.7 ;-))

Rajesh

-Original Message-
Sent: Monday, September 10, 2001 4:10 PM
To: [EMAIL PROTECTED]; Rajesh Dayal


Rajesh,
 I am afraid indexfile option will not show such information. 
 If using exported dump file is opted for such information, then it has
to
be extracted using either 'strings' command (UNIX) or by importing using
the
show=y log=logfile option. The logfile will then have to be edited to
fish
out the required information, which may need quite a bit of editing to
get a
working SQL. I like the 'strings' better for such tasks. 

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, September 10, 2001 7:10 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: export user definitions
 
 Do a full export ( without data, rows=n ) and import with indexfile
 option. You can see all the information including users.
 
 HTH,
 Rajesh 
 
 
 -Original Message-
 Sent: Monday, September 10, 2001 1:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 hi everyone
 
 can anybody help me with a script that recreates
 user definitions and the granted roles ?
 
 thanks
  
 g.g. kor
 rdw ict groningen
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  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: v_$session HELP...


The background processes.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone tell me who are those users that identified by null value in
username column


SQL SELECT username from v_$session where osuser='dba';

USERNAME
---






SYS
SYS

8 rows selected.


Thank you

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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: Christopher Spence
  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: v_$session HELP...

2001-09-10 Thread Koivu, Lisa

Title: RE: v_$session HELP...





The background processes. I exclude these sessions when viewing activity in the database with my sessions script.


Lisa Koivu
Oracle Databug Administrator
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From: Sinardy [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L
Subject: v_$session HELP...


Hi all,


Can someone tell me who are those users that identified by null value in
username column



SQL SELECT username from v_$session where osuser='dba';


USERNAME
---







SYS
SYS


8 rows selected.



Thank you


Sinardy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
 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: DYNAMIC SQL - Please mod request to trap error when insert fa

2001-09-10 Thread Jamadagni, Rajendra


George ...

After insert you need a commit somewhere ... preferable after the
dbms_sql.execute only then number of rows actually written to the database
will increase.

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 !

*2

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.

*2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: v_$session HELP...

2001-09-10 Thread Ruth Gramolini


They are the Oracle background process, pmon,smon,reco, etc.  Look at the
username and program and you can see who they are.

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 8:55 AM


 Hi all,

 Can someone tell me who are those users that identified by null value in
 username column


 SQL SELECT username from v_$session where osuser='dba';

 USERNAME
 ---






 SYS
 SYS

 8 rows selected.


 Thank you

 Sinardy

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sinardy
   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: Ruth Gramolini
  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).

query for top customer

2001-09-10 Thread Oracle DBA


how to write a query to find top 3 customer
based on their sales .
eg.
TABLE A
customer   sales
A100  100
A101   200
A102   105
A103109
A104108

RESULTS should be..
A101   200
A103109
A104108

Thanks in advance
Brajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Choose different variables


On Monday 10 September 2001 01:05, [EMAIL PROTECTED] wrote:
 Hallo,

 Can anyone tell me how I  can send different variables into a procedure,
 depending on which action should take place? Please give me an example.
 Roland

Roland,

Can you provide more information?

This is rather sparse and will will result in many useless postings.

What are you really trying to do?

Please reply to the list.

Thanks,

Jared

-- 
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: export user definitions

2001-09-10 Thread Rachel Carmichael


nope, not using the indexfile definition you won't. That way all you'll see 
are table and index create statements.

if you do a full import, using show=y and log=logname you will get a  file 
that contains ALL statements that would recreate your database. They aren't 
particularly readable as oracle breaks lines in the middle of words, but 
it's a start.

or you could just write SQL statements to generate SQL... using the 
dba_users, dba_ts_quotas, dba_roles, dba_tab_privs and dba_sys_privs
views.

From: Rajesh Dayal [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: export user definitions
Date: Mon, 10 Sep 2001 04:10:18 -0800

Do a full export ( without data, rows=n ) and import with indexfile
option. You can see all the information including users.

HTH,
Rajesh


-Original Message-
Sent: Monday, September 10, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


hi everyone

can anybody help me with a script that recreates
user definitions and the granted roles ?

thanks

g.g. kor
rdw ict groningen


--
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: Rajesh Dayal
   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
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: v_$session HELP...

2001-09-10 Thread Robertson Lee - lerobe


select program as well and all will be revealed

Regards

Lee



-Original Message-
Sent: 10 September 2001 13:56
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone tell me who are those users that identified by null value in
username column


SQL SELECT username from v_$session where osuser='dba';

USERNAME
---






SYS
SYS

8 rows selected.


Thank you

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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: db engines VS flat files


Highly depends.  

If your reading the data sequentially, then flat files will be faster,
unless you have many multiple users.

If your sorting, or doing complex things with the data, then Oracle will
most likely be faster.

Oracle will also allow security and integrity of the data.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Sunday, September 09, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


I would like to know your opinion about the developments under for 
example perl for handling large amounts of datas (sets of flats files 
larger than 50 gigs) vs the option of using oracle for exmaple for doing 
the same task, wich would be more eficinet? why? cheers

The information contained in this communication is confidential, is intended
only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient, you
are hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please re-send this communication to the sender and
delete the original message or any copy of it from your computer system.
Please do not re-send by any reazon in any way or form any of the 
informatino here contained. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: agc
  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: Christopher Spence
  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: v_$session HELP...

Title: Message

I have
a decent script on my site www.vampired.net which is a glorified
WHO.It takes this in account, and does some formatting as well to make
it all pretty.
Also, sniped and killed sessions
are shown seperately in the second results.
I believe it is under user/objects

"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."
Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73 Princeton Street North, Chelmsford 01863

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001
9:45 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: v_$session HELP...
The background processes. I exclude
these sessions when viewing activity in the database with my sessions
script.
Lisa Koivu Oracle Databug
Administrator Fairfield Resorts, Inc.
954-935-4117

-Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Monday,
September 10, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: v_$session HELP...
Hi all,
Can someone tell me who are those users that
identified by null value in username
column
SQL SELECT username from v_$session where
osuser='dba';
USERNAME ---
SYS SYS

8 rows selected.
Thank you
Sinardy
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
Sinardy 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: dbms_jobs


Less keystrokes, yes, but the long version is less likely
to generate questions like 'What do those numbers mean?' :)

There in the books :)

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Sunday, September 09, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L



Less keystrokes, yes, but the long version is less likely
to generate questions like 'What do those numbers mean?' :)

Other jobs running on the database is not really a factor in the timing of
my test, as there are no other jobs in the database, and I am the only user
of the entire box.

Jared

On Friday 07 September 2001 10:21, MacGregor, Ian A. wrote:
 I find it easier, takes less keystrokes, I am the world's worst 
 typist, to SCHEDULE A JOB TO RUN AT 9:45 pm  and run every five 
 minutes thereafter

  exec dbms_job.submit(:jobno,'procedure;', trunc(sysdate) + 
 21.75/24,
 'trunc(sysdate,''MI'') + 5/1440')

 Also bear in mind the job_queue_interval parameter and the number of 
 job queue procceses running. There's no guarantee the job will start 
 precisely when it is scheduled.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]

 -Original Message-
 Sent: Thursday, September 06, 2001 11:00 PM
 To: Multiple recipients of list ORACLE-L



 Any thoughts on how this was scheduled this way?

 Schedule a job that takes 10 minutes, set the interval
 to run 5 minutes after the first job starts.

 Here's the job:

 create or replace procedure dummy
 is
 begin
-- sleep for 10 minutes
-- envy the computer
-- waiting for interruption
dbms_lock.sleep(10*60);
 end;
 /

 Here's the submission:

 declare
jobno integer;
 begin
dbms_job.submit(
   job = jobno
   , what = 'dummy;'
   -- provide resolution to the second
   --midnighthour ofminute ofunits
 per day -- of current dayday to run  hr to run( 1
 second ) , next_date = trunc(sysdate) + ((21 * (60*60) + ( 60*45)) * 
 (
 1/(60*60*24))) , interval = 'trunc(sysdate) + ((21 * (60*60) + ( 60*50))
*
 ( 1/(60*60*24)))' );
commit;
 end;
 /

 Here's before it ran:
FAIL
 SCHEMA_USE PRIV_USER  LOG_USER  JOB LAST_DATE   LAST_SEC
 NEXT_DATE   NEXT_SEC TOTAL_TIME B INTERVAL  URES WHAT
 -- -- -- -- --- 
 ---  -- -  
 
 JKSTILLJKSTILLJKSTILL22 
 09/06/2001 21:45:00 21:45:00244 N trunc(sysdate) + ((2   dummy;

   1 * (60*60) + ( 60*5

   0)) * ( 1/(60*60*24)

   ))


 Here's after it ran:

FAIL
 SCHEMA_USE PRIV_USER  LOG_USER  JOB LAST_DATE   LAST_SEC
 NEXT_DATE   NEXT_SEC TOTAL_TIME B INTERVAL  URES WHAT
 -- -- -- -- --- 
 ---  -- -  
 
 JKSTILLJKSTILLJKSTILL22 09/06/2001 21:45:14 21:45:14
 09/06/2001 21:57:28 21:57:28614 N trunc(sysdate) + ((21 dummy;

   1 * (60*60) + ( 60*5

   0)) * ( 1/(60*60*24)

   ))

 Notice the next run time is 00:02:28 after completion of the first 
 job.

 Jared

 On Thursday 06 September 2001 00:50, [EMAIL PROTECTED] wrote:
  Hi
 
 
  As far as I know the job will be rescheduled after the job 
  completes. So in your examples the job will start one hour after the 
  two hour job finishes.
 
 
  Jack
 
 
 
 
  David Turner [EMAIL PROTECTED]@fatcity.com on 06-09-2001 05:35:32
 
  Please respond to [EMAIL PROTECTED]
 
  Sent by:  [EMAIL PROTECTED]
 
 
  To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
 
  I was wondering if you schedule a job to run every hour and say the 
  job takes 2 hours to run. Will the next run of the job queue up or 
  will it run in parallel with the current job? I'll be testing this 
  but if anyone knows I would appreciate it?
 
  Also if the second job waits for the first job to finish how can you 
  see how many jobs have queued up?
 
  Thanks, Dave
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: David Turner
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

Re: db engines VS flat files



In addition to Greg's comments I would like to add
that anyone suggesting flat files for 50 gig of data
is probably not at all familiar with database technology.

Perl is an excellent language for manipulating data, but
it is not a database engine.  50 gigs of data is totally
unmanagable as flat files.  

Personally, were someone to suggest that to me I would have
to bite my tongue to contain the laughter.  

At the very least, something like MySQL should be used.

For a look at what is available in the way or database
interfaces for Perl, have a look at:

http://search.cpan.org/Catalog/Database_Interfaces/

Jared


On Sunday 09 September 2001 12:40, agc wrote:
 I would like to know your opinion about the developments under for
 example perl for handling large amounts of datas (sets of flats files
 larger than 50 gigs) vs the option of using oracle for exmaple for doing
 the same task, wich would be more eficinet? why? cheers

 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 Please do not re-send by any reazon in any way or form any of the
 informatino here contained.
-- 
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: v_$session HELP...

2001-09-10 Thread Rachel Carmichael

the background processes that run oracle -- pmon, smon, dbwr etc

From: Sinardy [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: v_$session HELP...
Date: Mon, 10 Sep 2001 04:55:34 -0800

Hi all,

Can someone tell me who are those users that identified by null value in
username column

SQL SELECT username from v_$session where osuser='dba';

USERNAME
---

SYS
SYS

8 rows selected.

Thank you

Sinardy

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
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: v_$session HELP...



Those are background processes.  This should clear it
up for you.

Jared


select
   b.name,
   s.sid,
   s.serial#,
   s.status,
   s.machine,
   s.osuser,
   substr(s.program,1,20) client_program,
   s.process client_process,
   substr(p.program,1,20) server_program,
   to_char(p.spid) spid,
   to_char(logon_time, 'mm/dd/yy hh24:mi:ss') logon_time,
   -- idle time
   -- days added to hours
   --( trunc(LAST_CALL_ET/86400) * 24 ) || ':'  ||
   -- days separately
   substr('0'||trunc(LAST_CALL_ET/86400),-2,2)  || ':'  ||
   -- hours
   substr('0'||trunc(mod(LAST_CALL_ET,86400)/3600),-2,2) || ':' ||
   -- minutes
   substr('0'||trunc(mod(mod(LAST_CALL_ET,86400),3600)/60),-2,2) || ':' ||
   --seconds
   substr('0'||mod(mod(mod(LAST_CALL_ET,86400),3600),60),-2,2)  idle_time
from v$session s, v$process p, v$bgprocess b
   -- use outer join to show sniped sessions in
   -- v$session that don't have an OS process
   where p.addr = s.paddr
   and s.paddr = b.paddr
order by b.name, sid;


On Monday 10 September 2001 05:55, Sinardy wrote:
 Hi all,

 Can someone tell me who are those users that identified by null value in
 username column


 SQL SELECT username from v_$session where osuser='dba';

 USERNAME
 ---






 SYS
 SYS

 8 rows selected.


 Thank you

 Sinardy
-- 
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: current procedure that is executing



If these are in house modifiable procedures, you could
use DBMS_APPLICATION_INFO to cause the package/procedure name to
appear in v$session.

Here are details:

http://www.oradoc.com/ora817/appdev.817/a76936/dbms_app.htm#999107

Jared


On Sunday 09 September 2001 19:15, Suhen Pather wrote:
 List,

 Is there any way to tell what procedure rather than sql_text that is
 currently executing?
 We are trying to develop a knowledge base were we require this information.

 I tried to check v$sqlarea, v$sqltext but could not find the relevant
 information in the shared pool.

 Any help or pointer will be greatly appreciated.

 TIA
 Suhen


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).

Licensing??

2001-09-10 Thread Walter K


Hi,

Can someone explain how the named-user licensing
works? Also, has concurrent usage licensing gone away?

We have a need for an additional database to use for
mapping/geo-coding purposes. The primary application
will periodically perform a query against this new
database to look up some mapping info. Essentially,
the application will always maintain a handful of
sessions to the mapping database. It may perform the
lookup as often as 10 times an hour. The new database
will essentially be read-only.

The docs say NOT to allow the sharing of usernames for
multiple concurrent users. Although the application
may be hosting several users, no more than a handful
would ever need to get data from the mapping database
thus the idea of going cheap by buying say 5-10 named
user licenses.

It seems that for a few $K that I could accomplish
what I want with the database using named-user
licensing rather than dropping $14K for a single-CPU
license (2yr). We may also want to go with a dual-cpu
box which would mean another $14k!

Am I treading a thin line here? I hope this makes
sense.

As always, your feedback is appreciated!

-w


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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: query for top customer

2001-09-10 Thread Carle, William T (Bill), NLCIO


Hi,

Try this query:

select customer,sales
from tablea x
where 3  (select count(*) from tablea y where y.sales  x.sales)
order by x.sales desc;


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Monday, September 10, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L
Subject:query for top customer

how to write a query to find top 3 customer
based on their sales .
eg.
TABLE A
customer   sales
A100  100
A101   200
A102   105
A103109
A104108

RESULTS should be..
A101   200
A103109
A104108

Thanks in advance
Brajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Carle, William T (Bill), NLCIO
  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: query for top customer

2001-09-10 Thread Cale, Rick T (Richard)


SELECT customer,sales
FROM  (SELECT customer,sales
   FROM table_a
   ORDER BY sales DESC)
WHERE rownum  4;

Must be running at least 8i for this to work

Rick

-Original Message-
Sent: Monday, September 10, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


how to write a query to find top 3 customer
based on their sales .
eg.
TABLE A
customer   sales
A100  100
A101   200
A102   105
A103109
A104108

RESULTS should be..
A101   200
A103109
A104108

Thanks in advance
Brajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Cale, Rick T (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: v_$session HELP...

2001-09-10 Thread Igor Neyman


Background processes identified by null value in username column.


Igor   

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 8:55 AM


 Hi all,
 
 Can someone tell me who are those users that identified by null value in
 username column
 
 
 SQL SELECT username from v_$session where osuser='dba';
 
 USERNAME
 ---
 
 
 
 
 
 
 SYS
 SYS
 
 8 rows selected.
 
 
 Thank you
 
 Sinardy
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Sinardy
   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: export user definitions


On Monday 10 September 2001 02:45, [EMAIL PROTECTED] wrote:
 hi everyone

 can anybody help me with a script that recreates
 user definitions and the granted roles ?

 thanks

 g.g. kor
 rdw ict groningen

Someone asked this just a couple of weeks ago. That 
script will recreate a user.

Take a look through the archives at www.fatcity.com for this.

Recreating the roles is a simple exercise I'll leave to you.

Jared

-- 
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: Passing a parameter containing a space to sqlplus

2001-09-10 Thread Barry Deevey


I have just found a reference to the below question within Metalink - You
need to quote the string as follows: 'WORD1 WORD2'

Apologies for my premature posting.

Best Regards,

Barry.



Hi gurus,

I'm trying to pass a parameter from unix into a sqlplus script.  The
parameter contains a space, i.e. JOB SERVER  I have tried passing it with
both single and double quotations, but the sql script only accepts the first
word in the string.  It works fine if the parameter does not contain a
space.

Can anybody tell me what I'm not doing wrong??

TIA - Your replies are much appreciated.

Best Regards,

Barry
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Barry Deevey
  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: v_$session HELP...

2001-09-10 Thread Walthour, Jon (GEAE, Compaq)


The sessions where username is null are generally the Oracle background
processes. You can confirm this by also checking the TYPE column for
'BACKGROUND'.

Jon Walthour


-Original Message-
Sent: Monday, September 10, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone tell me who are those users that identified by null value in
username column


SQL SELECT username from v_$session where osuser='dba';

USERNAME
---






SYS
SYS

8 rows selected.


Thank you

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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: Walthour, Jon (GEAE, Compaq)
  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: dbms_jobs


On Monday 10 September 2001 06:35, Christopher Spence wrote:
 Less keystrokes, yes, but the long version is less likely
 to generate questions like 'What do those numbers mean?' :)

 There in the books :)

Geez Chris, of course they're in the books.  That doesn't
stop people from asking.   :)

After a few years of this you learn how to head off many
of the inevitable RTFM questions.

Jared


 Do not criticize someone until you walked a mile in their shoes, that way
 when you criticize them, you are a mile a way and have their shoes.

 Christopher R. Spence
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275

 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863




 -Original Message-
 Sent: Sunday, September 09, 2001 3:40 PM
 To: Multiple recipients of list ORACLE-L



 Less keystrokes, yes, but the long version is less likely
 to generate questions like 'What do those numbers mean?' :)

 Other jobs running on the database is not really a factor in the timing of
 my test, as there are no other jobs in the database, and I am the only user
 of the entire box.

 Jared

 On Friday 07 September 2001 10:21, MacGregor, Ian A. wrote:
  I find it easier, takes less keystrokes, I am the world's worst
  typist, to SCHEDULE A JOB TO RUN AT 9:45 pm  and run every five
  minutes thereafter
 
   exec dbms_job.submit(:jobno,'procedure;', trunc(sysdate) +
  21.75/24,
  'trunc(sysdate,''MI'') + 5/1440')
 
  Also bear in mind the job_queue_interval parameter and the number of
  job queue procceses running. There's no guarantee the job will start
  precisely when it is scheduled.
 
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
 
  -Original Message-
  Sent: Thursday, September 06, 2001 11:00 PM
  To: Multiple recipients of list ORACLE-L
 
 
 
  Any thoughts on how this was scheduled this way?
 
  Schedule a job that takes 10 minutes, set the interval
  to run 5 minutes after the first job starts.
 
  Here's the job:
 
  create or replace procedure dummy
  is
  begin
 -- sleep for 10 minutes
 -- envy the computer
 -- waiting for interruption
 dbms_lock.sleep(10*60);
  end;
  /
 
  Here's the submission:
 
  declare
 jobno integer;
  begin
 dbms_job.submit(
job = jobno
, what = 'dummy;'
-- provide resolution to the second
--midnighthour ofminute ofunits
  per day -- of current dayday to run  hr to run( 1
  second ) , next_date = trunc(sysdate) + ((21 * (60*60) + ( 60*45)) *
  (
  1/(60*60*24))) , interval = 'trunc(sysdate) + ((21 * (60*60) + ( 60*50))

 *

  ( 1/(60*60*24)))' );
 commit;
  end;
  /
 
  Here's before it ran:
 FAIL
  SCHEMA_USE PRIV_USER  LOG_USER  JOB LAST_DATE   LAST_SEC
  NEXT_DATE   NEXT_SEC TOTAL_TIME B INTERVAL  URES WHAT
  -- -- -- -- --- 
  ---  -- -  
  
  JKSTILLJKSTILLJKSTILL22
  09/06/2001 21:45:00 21:45:00244 N trunc(sysdate) + ((2   dummy;
 
1 * (60*60) + ( 60*5
 
0)) * ( 1/(60*60*24)
 
))
 
 
  Here's after it ran:
 
 FAIL
  SCHEMA_USE PRIV_USER  LOG_USER  JOB LAST_DATE   LAST_SEC
  NEXT_DATE   NEXT_SEC TOTAL_TIME B INTERVAL  URES WHAT
  -- -- -- -- --- 
  ---  -- -  
  
  JKSTILLJKSTILLJKSTILL22 09/06/2001 21:45:14 21:45:14
  09/06/2001 21:57:28 21:57:28614 N trunc(sysdate) + ((21
  dummy;
 
1 * (60*60) + ( 60*5
 
0)) * ( 1/(60*60*24)
 
))
 
  Notice the next run time is 00:02:28 after completion of the first
  job.
 
  Jared
 
  On Thursday 06 September 2001 00:50, [EMAIL PROTECTED] wrote:
   Hi
  
  
   As far as I know the job will be rescheduled after the job
   completes. So in your examples the job will start one hour after the
   two hour job finishes.
  
  
   Jack
  
  
  
  
   David Turner [EMAIL PROTECTED]@fatcity.com on 06-09-2001 05:35:32
  
   Please respond to [EMAIL PROTECTED]
  
   Sent by:  [EMAIL PROTECTED]
  
  
   To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
  
   I was wondering if you schedule a job to run every hour and say the
   job takes 2 hours to run. Will the next run of the job queue up or
   will it run in parallel with the current job? I'll be testing this
   but if anyone knows I would appreciate it?
  
   Also if the second job waits for the first job to finish how can you
   see how many jobs have queued up?
  
   Thanks, Dave
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: David Turner
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051

RE: query for top customer

2001-09-10 Thread Thomas, Kevin


Try this...

DECLARE
  CURSOR c_sales IS
  SELECT *
FROM sales
   ORDER BY sales desc;
  r_sales c_sales%rowtype;
  l_count NUMBER := 0;
BEGIN
  OPEN c_sales;
  DBMS_OUTPUT.PUT_LINE( 'Customer' || ' ' || 'Sales' );
  WHILE l_count  3 LOOP
FETCH c_sales INTO r_sales;
DBMS_OUTPUT.PUT_LINE( r_sales.customer || ' ' || r_sales.sales );
l_count := l_count + 1;
  END LOOP;
  CLOSE c_sales;
END;
/

I did it as a pl/sql block because you can't be fancy (well not in 7.3.4)
and use ROWNUM with an ORDER BY. I was going to
suggest just doing:

SELECT *
  FROM sales
 WHERE rownum  4
 ORDER BY sales DESC;

But alas, this doesn't work...try the above, it's nasty but quick...

HTH,

Kev.


__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 10 September 2001 14:30
To: Multiple recipients of list ORACLE-L


how to write a query to find top 3 customer
based on their sales .
eg.
TABLE A
customer   sales
A100  100
A101   200
A102   105
A103109
A104108

RESULTS should be..
A101   200
A103109
A104108

Thanks in advance
Brajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Thomas, Kevin
  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: How do you audit a DBA?

2001-09-10 Thread Miller, Jay


So you've had a mass DBA exodus too?
We're currently at 50% (3/6) of the Oracle DBA staffing levels we had a year
ago and have finally gotten permission to add one more person.  Hmm, if
anyone is looking for a job in Jersey City near the PATH train with lots of
bureaucracy and paperwork but occasional interesting stuff feel free to send
my your resume.  We need a DB2 DBA too.

Oh, and my great-grandboss knows my name but his office is only about 15'
from my cubicle so I don't know if that counts.

Jay Miller

-Original Message-
Sent: Friday, September 07, 2001 4:47 PM
To: Multiple recipients of list ORACLE-L


Yes, and she is the VP.  (hesitating)  That's probably because every other
DBA has left, so all of the sudden I am becoming popular around here.

-Original Message-
Sent: Friday, September 07, 2001 4:32 PM
To: Multiple recipients of list ORACLE-L


President of the company?  Of the U.S.A.?

You would only see him once every ten years... if that.

Does the manager three levels above you know you by name?

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Acting Head
Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
From:   Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, September 07, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: How do you audit a DBA?

I think the president should be the only one in charge, he just
tells the
dba what to do, i.e., alter the freelists on this table, add some
extents
here, put some fluff there.

Do not criticize someone until you walked a mile in their shoes,
that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Friday, September 07, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L





The point is, you only need one, single trusted person to hold the
administrator account (someone from your audit firm, for example)
and almost
everything can be done by sub-administrators who only have the
precise
permissions they need and no more. In theory, anyway :0)

There's that single point of failure again!  so... the auditor is
more 
trusted than the DBA?

Who audits the auditor?



From: Guy Hammond [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: How do you audit a DBA?
Date: Fri, 07 Sep 2001 01:45:06 -0800

There is an administrator account, but individual users can
configure 
access control lists on their files (right-click, properties,
security) 
that would prevent the administrator from reading them. The only
way 
that an administrator could then read them would be to take
ownership 
first. Unlike Unix, ownership of a file is taken rather than given,
so 
even if an Administrator read a confidential file, the OS would not
let 
then erase traces of having done so. If you wanted to steal a file,
you 
could obviously back it up to tape (if you have the Backup Operator
role) restore it to another system, take ownership there and read
it 
(unless it was encrypted of course) but there's only so much an OS
can 
do about physical security.

The point is, you only need one, single trusted person to hold the 
administrator account (someone from your audit firm, for example)
and 
almost everything can be done by sub-administrators who only have
the 
precise permissions they need and no more. In theory, anyway :0)

g



-Original Message-
Sent: Thursday, September 06, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L


but doesn't there have to be ONE account/role in NT that can assign
all 
the others? how else could you set up a role or continue to set
them 
up?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
   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

Re: Do fast full index scans do physical disk reads?


On Monday 10 September 2001 05:50, [EMAIL PROTECTED] wrote:
 Ian,

 I'll look at compressing the index.   Does that only work on unique indexes
 or can you
 do it on non-unique multi-column indexes as well?


You can compress unique and non-unique indexes.  You may get better 
compression from non-unique indexes, but this is really dependent on
your data in any case.

I've shrunk 180 meg indexes down to 60 meg with it.

Don't expect your indexes to be faster though.  The benefit of
compression is chiefly that Oracle will be able to cache more
index blocks when compressed, greatly speeding queries when so.

If your index is read from disk though, you won't see much of
a difference in many cases.

Jared


 Thanks,

 Cherie



 MacGregor,
 Ian A.  To: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]   cc:
 ford.EDUSubject: RE: Do fast full
 index scans do physical disk reads? Sent by:
 [EMAIL PROTECTED]
 om


 09/07/01 03:26
 PM
 Please respond
 to ORACLE-L






 The advantage of the fast full index scan is that it should read fewer
 blocks than the full table scan.  Index compression may help reduce the
 number of blocks read even further.   A unique index mist be at least two
 columns wide to benefit from compression.


 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]

 -Original Message-
 Sent: Friday, September 07, 2001 5:20 AM
 To: Multiple recipients of list ORACLE-L



 Ian,

 The last one I looked at it was cached, I guess.   I could purposely cache
 the
 table (and index) if it was small, though.

 I'm confused though.   Isn't the whole benefit of the fast, full index scan
 that you
 don't have to go against the table, thereby avoiding those physical reads?

 Or, in the case where the index isn't cached, is the benefit that you don't
 have
 to read all of the columns in the table that aren't part of the index?

 Thanks for your reply,

 Cherie



 MacGregor,

 Ian A.  To: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED]
 [EMAIL PROTECTED]   cc:

 ford.EDUSubject: RE: Do fast full
 index scans do physical disk reads?
 Sent by:

 [EMAIL PROTECTED]

 om



 09/07/01 01:05

 AM

 Please respond

 to ORACLE-L







 There is no rule that says an index will be cache.  Yes physical reads are
 being done.
 If the unique index is composed of more than one column look into
 compressing it.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]



 -Original Message-
 Sent: Thursday, September 06, 2001 1:51 PM
 To: Multiple recipients of list ORACLE-L



 I am confused by the output from tkprof below.   An fast full index
 scan is being performed.   However, from the statistics, it looks as
 thought 649 physical disk reads are being performed.  Is that actually
 the case?   Are physical disk reads being done?

 Thanks,

 Cherie Machler
 Oracle DBA
 Gelco Information Network
 ***
*



 Select SD.KS_OBJECTID as CONCEPTID
 From kbowner.KS_SHORTDESCRIPTION SD
 Where SD.KS_DESCRIPTIONTYPE = 'CPTNAME' And
 UPPER(SD.KS_DESCRIPTIONTEXT) = ''

 call count   cpuelapsed   disk  querycurrent
 rows
 --- --   -- -- -- --
 --
 Parse1  0.03   0.03  0  0  0
 0
 Execute  1  0.00   0.00  0  0  0
 0
 Fetch1  0.30   0.30649649  4
 0
 --- --   -- -- -- --
 --
 total3  0.33   0.33649649  4
 0

 Rows Row Source Operation
 ---  ---
   0  INDEX FAST FULL SCAN (object id 5286)


 Rows Execution Plan
 ---  ---
   0  SELECT STATEMENT   GOAL: CHOOSE
   0   INDEX   GOAL: ANALYZED (FAST FULL SCAN) OF 'SYS_C001069' (UNIQUE)

 --
 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:

Re: db engines VS flat files

2001-09-10 Thread agc


well so start to bite your tonge :-)  because yes there are some very 
large collections of datas stored as flat text files, so do bite it 
and do it very hard because this large amounts of datas may almost 
doble the size every year... and most of them are being searched and 
manipulated with perl scripts. I do not know if has been that way 
because of not knowign search engines, do not think that is the 
case, that I do not know but my 
question remains. ok, for only seraching patterns with in this 
falt files wich would be the difference between having a real search 
engine and just having perl scripts for searching patterns with in 
this flat text files? until now all I can say is that most of 
administrative tasks are quite dificult to do under perl and shell 
scripts, and c progrmas, but for the rest and even knowing that all 
this works under cgis, it works fine well... so do not laught so hard 
may loose your tonge :-)

On Mon, 10 Sep 2001, Jared Still wrote:

 Date: Mon, 10 Sep 2001 06:40:19 -0800
 From: Jared Still [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: db engines VS flat files
 
 
 In addition to Greg's comments I would like to add
 that anyone suggesting flat files for 50 gig of data
 is probably not at all familiar with database technology.
 
 Perl is an excellent language for manipulating data, but
 it is not a database engine.  50 gigs of data is totally
 unmanagable as flat files.  
 
 Personally, were someone to suggest that to me I would have
 to bite my tongue to contain the laughter.  
 
 At the very least, something like MySQL should be used.
 
 For a look at what is available in the way or database
 interfaces for Perl, have a look at:
 
 http://search.cpan.org/Catalog/Database_Interfaces/
 
 Jared
 
 
 On Sunday 09 September 2001 12:40, agc wrote:
  I would like to know your opinion about the developments under for
  example perl for handling large amounts of datas (sets of flats files
  larger than 50 gigs) vs the option of using oracle for exmaple for doing
  the same task, wich would be more eficinet? why? cheers
 
  The information contained in this communication is
  confidential, is intended only for the use of the recipient
  named above, and may be legally privileged. If the reader
  of this message is not the intended recipient, you are
  hereby notified that any dissemination, distribution or
  copying of this communication is strictly prohibited.
  If you have received this communication in error, please
  re-send this communication to the sender and delete the
  original message or any copy of it from your computer
  system.
  Please do not re-send by any reazon in any way or form any of the
  informatino here contained.
 -- 
 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).
 

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
Please do not re-send by any reazon in any way or form any of the 
informatino here contained. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: agc
  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: dbms_jobs


Yeah, just say RTFM :)

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 9:40 AM
To: [EMAIL PROTECTED]; Christopher Spence


On Monday 10 September 2001 06:35, Christopher Spence wrote:
 Less keystrokes, yes, but the long version is less likely
 to generate questions like 'What do those numbers mean?' :)

 There in the books :)

Geez Chris, of course they're in the books.  That doesn't
stop people from asking.   :)

After a few years of this you learn how to head off many
of the inevitable RTFM questions.

Jared


 Do not criticize someone until you walked a mile in their shoes, that 
 way when you criticize them, you are a mile a way and have their 
 shoes.

 Christopher R. Spence
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275

 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863




 -Original Message-
 Sent: Sunday, September 09, 2001 3:40 PM
 To: Multiple recipients of list ORACLE-L



 Less keystrokes, yes, but the long version is less likely
 to generate questions like 'What do those numbers mean?' :)

 Other jobs running on the database is not really a factor in the 
 timing of my test, as there are no other jobs in the database, and I 
 am the only user of the entire box.

 Jared

 On Friday 07 September 2001 10:21, MacGregor, Ian A. wrote:
  I find it easier, takes less keystrokes, I am the world's worst 
  typist, to SCHEDULE A JOB TO RUN AT 9:45 pm  and run every five 
  minutes thereafter
 
   exec dbms_job.submit(:jobno,'procedure;', trunc(sysdate) + 
  21.75/24,
  'trunc(sysdate,''MI'') + 5/1440')
 
  Also bear in mind the job_queue_interval parameter and the number of 
  job queue procceses running. There's no guarantee the job will start 
  precisely when it is scheduled.
 
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
 
  -Original Message-
  Sent: Thursday, September 06, 2001 11:00 PM
  To: Multiple recipients of list ORACLE-L
 
 
 
  Any thoughts on how this was scheduled this way?
 
  Schedule a job that takes 10 minutes, set the interval
  to run 5 minutes after the first job starts.
 
  Here's the job:
 
  create or replace procedure dummy
  is
  begin
 -- sleep for 10 minutes
 -- envy the computer
 -- waiting for interruption
 dbms_lock.sleep(10*60);
  end;
  /
 
  Here's the submission:
 
  declare
 jobno integer;
  begin
 dbms_job.submit(
job = jobno
, what = 'dummy;'
-- provide resolution to the second
--midnighthour ofminute of
units
  per day -- of current dayday to run  hr to run(
1
  second ) , next_date = trunc(sysdate) + ((21 * (60*60) + ( 60*45)) 
  * (
  1/(60*60*24))) , interval = 'trunc(sysdate) + ((21 * (60*60) + ( 
  60*50))

 *

  ( 1/(60*60*24)))' );
 commit;
  end;
  /
 
  Here's before it ran:
 FAIL
  SCHEMA_USE PRIV_USER  LOG_USER  JOB LAST_DATE   LAST_SEC
  NEXT_DATE   NEXT_SEC TOTAL_TIME B INTERVAL  URES WHAT
  -- -- -- -- --- 
  ---  -- -  
  
  JKSTILLJKSTILLJKSTILL22
  09/06/2001 21:45:00 21:45:00244 N trunc(sysdate) + ((2   dummy;
 
1 * (60*60) + ( 60*5
 
0)) * ( 1/(60*60*24)
 
))
 
 
  Here's after it ran:
 
 FAIL
  SCHEMA_USE PRIV_USER  LOG_USER  JOB LAST_DATE   LAST_SEC
  NEXT_DATE   NEXT_SEC TOTAL_TIME B INTERVAL  URES WHAT
  -- -- -- -- --- 
  ---  -- -  
  
  JKSTILLJKSTILLJKSTILL22 09/06/2001 21:45:14 21:45:14
  09/06/2001 21:57:28 21:57:28614 N trunc(sysdate) + ((21
  dummy;
 
1 * (60*60) + ( 60*5
 
0)) * ( 1/(60*60*24)
 
))
 
  Notice the next run time is 00:02:28 after completion of the first 
  job.
 
  Jared
 
  On Thursday 06 September 2001 00:50, [EMAIL PROTECTED] wrote:
   Hi
  
  
   As far as I know the job will be rescheduled after the job 
   completes. So in your examples the job will start one hour after 
   the two hour job finishes.
  
  
   Jack
  
  
  
  
   David Turner [EMAIL PROTECTED]@fatcity.com on 06-09-2001 
   05:35:32
  
   Please respond to [EMAIL PROTECTED]
  
   Sent by:  [EMAIL PROTECTED]
  
  
   To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
  
   I was wondering if you schedule a job to run every hour and say 
   the job takes 2 hours to run. Will the next run of the job queue 
   up or will it run

shutdown immediate hangs

2001-09-10 Thread Farnsworth, Dave


I have Oracle 8.1.7 running on windoze NT 4.0.  Every night I have a script
that kicks off a cold backup.  Part of the script issues the command

SHUTDOWN IMMEDIATE

which normally works just fine before I actually copy my files.  However,
periodically the shutdown immediate command does not work.  It just hangs
until someone complains that they cannot connect to the database or when I
come in early in the morning and notice it hanging.
In my SIDAlrt.log I get the following

SHUTDOWN: waiting for active calls to complete

This also shows up in a trace file file multiple times.  I have to issue a
shutdown abort to stop the database.

In doing some research on metalink I see that otheres also have this
problem.  The responses from Oracle are somewhat vague.  I do see that one
of the responses seems to indicate that if the intelligent agent is running
that it could be the cause for the hanging.  Has anyone else had this
problem and solved it by shutting down the intelligent agent service??  Any
other things that I can do to remedy this.

Thanks,

Dave
-- 
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:Licensing??


Walter,

First question, where are all of the astrological signs?  Their needed to
understand Oracle's pricing schemes in the first place.

Now names users is exactly that.  You have to be able to put an employee
name next to a database connection, as I understand it.  Since it sounds like
you application will be using an application server of some sorts this is a
no-no.

The other licensing scheme is per cpu which allows unlimited connections.

Concurrent licenses have become extinct.  But then there is always the
'ideas' your sales rep is likely to come up with.

Dick Goulet

Reply Separator
Author: Walter K [EMAIL PROTECTED]
Date:   9/10/2001 7:00 AM

Hi,

Can someone explain how the named-user licensing
works? Also, has concurrent usage licensing gone away?

We have a need for an additional database to use for
mapping/geo-coding purposes. The primary application
will periodically perform a query against this new
database to look up some mapping info. Essentially,
the application will always maintain a handful of
sessions to the mapping database. It may perform the
lookup as often as 10 times an hour. The new database
will essentially be read-only.

The docs say NOT to allow the sharing of usernames for
multiple concurrent users. Although the application
may be hosting several users, no more than a handful
would ever need to get data from the mapping database
thus the idea of going cheap by buying say 5-10 named
user licenses.

It seems that for a few $K that I could accomplish
what I want with the database using named-user
licensing rather than dropping $14K for a single-CPU
license (2yr). We may also want to go with a dual-cpu
box which would mean another $14k!

Am I treading a thin line here? I hope this makes
sense.

As always, your feedback is appreciated!

-w


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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: Passing a parameter containing a space to sqlplus

2001-09-10 Thread Chaim . Katz



Barry
Make sure that your substitution variable is in single quotes '1' and then
pass the parameter in single quotes, (or in single quotes surrounded by
double quotes)

hth
chaim





Barry Deevey [EMAIL PROTECTED]@fatcity.com on 09/10/2001 11:15:25
AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



Hi gurus,

I'm trying to pass a parameter from unix into a sqlplus script.  The
parameter contains a space, i.e. JOB SERVER  I have tried passing it with
both single and double quotations, but the sql script only accepts the
first
word in the string.  It works fine if the parameter does not contain a
space.

Can anybody tell me what I'm not doing wrong??

TIA - Your replies are much appreciated.

Best Regards,

Barry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
  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[2]: db engines VS flat files


Allow me to interject something from antiquity as well.

I have the displeasure to work with an old database called TurboImage from HP. 
I would place it somewhere between a flat file and a real database engine.  The
reason being that it stores data in flat files that are accessed via turboimage
intrinstics (read that as functions).  It is kindof like a database engine as it
handles data as tables and has a degree of referential integrity, but the two
biggest problems are locking and someone changing the file layout.  Locking does
not exist as we know it in the Oracle world, it's basically 'he who gets there
first wins', also read consistence and rollback were not design considerations. 
Worst of all is the datafile headers, which if someone changes them without
re-compiling all of the programs involved, well you get the picture production
problems out the wazoo.

Don't do it, PLEASE!

Dick Goulet

Reply Separator
Author: Jared Still [EMAIL PROTECTED]
Date:   9/10/2001 6:40 AM


In addition to Greg's comments I would like to add
that anyone suggesting flat files for 50 gig of data
is probably not at all familiar with database technology.

Perl is an excellent language for manipulating data, but
it is not a database engine.  50 gigs of data is totally
unmanagable as flat files.  

Personally, were someone to suggest that to me I would have
to bite my tongue to contain the laughter.  

At the very least, something like MySQL should be used.

For a look at what is available in the way or database
interfaces for Perl, have a look at:

http://search.cpan.org/Catalog/Database_Interfaces/

Jared


On Sunday 09 September 2001 12:40, agc wrote:
 I would like to know your opinion about the developments under for
 example perl for handling large amounts of datas (sets of flats files
 larger than 50 gigs) vs the option of using oracle for exmaple for doing
 the same task, wich would be more eficinet? why? cheers

 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 Please do not re-send by any reazon in any way or form any of the
 informatino here contained.
-- 
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).
-- 
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).

Passing a parameter containing a space to sqlplus

2001-09-10 Thread Barry Deevey


Hi gurus,

I'm trying to pass a parameter from unix into a sqlplus script.  The
parameter contains a space, i.e. JOB SERVER  I have tried passing it with
both single and double quotations, but the sql script only accepts the first
word in the string.  It works fine if the parameter does not contain a
space.

Can anybody tell me what I'm not doing wrong??

TIA - Your replies are much appreciated.

Best Regards,

Barry
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Barry Deevey
  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).

Script for checking temp usage

2001-09-10 Thread Jenkins, Michael


Does anybody have a script that will tell you which session_ids are using
temp and how much they are using?  We occasionally get runaway sessions that
don't release temp and this would allow us to easily locate the offending
session.

I've already checked OraMag and used google with no significant results.

Thanks in advance.

--Michael
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  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: Logging into Windows 2000 Advanced Server - Solved, Thanks

2001-09-10 Thread DBarbour



Thanks folks,

The SET command was what I needed.  It turns out that the network folks
installed some new software on the server and somehow trashed the Oracle
environment.  Even though I manually set my environmental variables, I
still was unable to connect to the instance.  Oracle support told me this
was an indication on Windows 2000 that my binaries needed to be relinked,
and the only way to accomplish this on 2000 was to reinstall Oracle.  I
did, and it's now working.

Live and learn.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
Walthour, Jon 
   
(GEAE,   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
Compaq) cc:   
   
Jon.walthour@   Subject: RE: Logging into Windows 2000 
Advanced Server 
ae.ge.com 
   
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
09/09/2001 
   
07:20 AM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Thank you for the correction, Mohammad.

Jon Walthour


-Original Message-
Sent: Sunday, September 09, 2001 1:10 AM
To: Multiple recipients of list ORACLE-L


David,
Although Jon has given you almost complete solution but your answer to
login

as sqlplus is

sqlplus / as sysdba
and you will connected as sys...This is also courtsy of Jon who gave this
answer to someone couple of days back...
Regards


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sat, 08 Sep 2001 20:30:17 -0800

The ORA-1113 message suggests that you have a file that needs media
recovery, which makes sense considering the abrupt shutdown. Instead of
opening the database, mount it first through SVRMGRL, the type recover
database. You may be asked for some archive logs if you're in archivelog
mode. Just follow the directions that Oracle provides. You should be able
to
do a full recovery if the file is not permanently damaged. My guess is that
the db may just be out of sync and media recovery will just get things back
in sync. After the media recovery finishes, run alter database open.

To do this, go to a command prompt and type set to see all your
environment variables. To use SVRMGRL, you need to set your ORACLE_SID
variable. To do this, enter set ORACLE_SID=your oracle sid goes here.
The run SVRMGRL, connect internal, and mount the database. Then recover it
and open it. For example:

C:\set oracle_sid=mydb

C:\svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
With the Partitioning option
JServer Release 8.1.7.2.1 - Production

SVRMGR connect internal
Connected.
SVRMGR startup mount
ORACLE instance started.
Total System Global Area 52193308 bytes
Fixed Size  75804 bytes
Variable Size10342400 bytes
Database Buffers 41697280 bytes
Redo Buffers77824 bytes
Database mounted.
SVRMGRrecover database
Database recovered. (There may be more to this step to do any media
recovery.)
SVRMGR alter database open;
Statement processed.
SVRMGR

... and on you go ...

Hope this helps.

Jon Walthour

-Original Message-
Sent: Saturday, September 08, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L



Hope somebody can help.

Our network personnel rebooted a Windows

Re: query for top customer

2001-09-10 Thread Stuart Graham


SELECT a.customer,
   a.sales
  FROM (SELECT customer,
   sales
   FROM a
ORDER BY sales desc) a
 WHERE rownum4;

would do the trick...

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 2:30 PM


 how to write a query to find top 3 customer
 based on their sales .
 eg.
 TABLE A
 customer   sales
 A100  100
 A101   200
 A102   105
 A103109
 A104108
 
 RESULTS should be..
 A101   200
 A103109
 A104108
 
 Thanks in advance
 Brajesh
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Oracle DBA
   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: Stuart Graham
  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: query for top customer

2001-09-10 Thread Bunyamin K. Karadeniz


works on 8.1.7
SELECT * FROM (Select * from tableA order by sales) where rownum4;

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 4:30 PM


 how to write a query to find top 3 customer
 based on their sales .
 eg.
 TABLE A
 customer   sales
 A100  100
 A101   200
 A102   105
 A103109
 A104108
 
 RESULTS should be..
 A101   200
 A103109
 A104108
 
 Thanks in advance
 Brajesh
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Oracle DBA
   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 K. 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).

Oracle, security the USAF?


Some of you may be interested in this:


--

1251.  AFRL successfully completes Oracle test program

ROME, N.Y. (AFPN) -- Air Force Research Laboratory engineers here
successfully completed participation in a six-month test program for the
next-generation database and internet server being developed by Oracle Corp.

Evaluation of technology focusing on network security was the primary goal
of participation in Oracle's Beta Test Program for Version 9i.

Under the auspices of its Joint Battlespace Infosphere program, the AFRL
information directorate focused its efforts on ensuring the latest major
release of Oracle software adheres to stringent Air Force and Department of
Defense guidelines for security of data generated and stored in
mission-critical command and control information systems.

Security issues remain a high priority as Air Force C2 legacy systems
undergo re-engineering, and a move toward using open commercial
product-based architectures and standards that are based on the internet and
World Wide Web.  DOD has adopted internet-like technology to support command
and control of worldwide military and humanitarian operations.

The directorate has numerous technology programs addressing information
management issues, but the JBI is one of its flagship efforts.

Originally described by the Air Force Scientific Advisory Board in a 1998
report and refined a year later, the JBI is a combat information management
system that provides individual users with the specific information required
for their functional responsibilities during crisis or conflict.

The SAB is a committee that provides independent guidance and insight to Air
Force senior leadership on science and technology for continued air and
space dominance.  One of the panel's main recommendations in its 1999 report
was to focus the AFRL, other Service research labs, and battlelabs on
evaluating and applying commercial technologies for the JBI. 

Participation in Oracle 9i Beta was an implementation of the SAB's guidance
to develop the JBI by evaluating and incorporating suitable commercial
off-the-shelf, or COTS, products.

AFRL leveraged and extended its in-house expertise by applying for 9i Beta
Test Site status in January.  In its proposal, the directorate team
identified security as the project focus area and generated stress tests and
remediation plans.  The directorate was selected in February as one of a
small number of Oracle beta sites located worldwide.  

To augment the existing team, AFRL brought on additional Oracle technical
support from the company's Advanced Products Group in Reston, Va., to aid
during beta testing.

Oracle has a rich history of working closely with Air Force engineers on
leading edge programs such as the JBI, said Eric Amberge, northeast
regional manager for Oracle's Advanced Programs Group.  This Beta test is
an excellent example of real government/industry interaction on the COTS
leading edge.  The AFRL cadre and their beta test findings were both
outstanding.

Participating in the Oracle 9i Beta program gave us a great opportunity to
continue our work with Oracle in the security area and influence future
commercial product releases, said Charles Flynn, lead engineer from the
AFRL information directorate.  Oracle is working to improve secure access
to information and developing products which exhibit a lot of appeal to the
military command and control systems designers. 

This effort allowed AFRL to get in on the ground floor six months before
commercial release and help Oracle refine their security products in order
to help meet JBI technical challenges, said Thomas A. Clark, program manager
of the effort in the directorate's JBI Office.  

We have found a lot of (commercial) products are not really addressing
security issues to the extent that Oracle has in the past, and continues to
do, he said. This effort allowed us to evaluate a next-generation
commercial product and influence its applicability to JBI.
-- 
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: How to organize oracle directories in Unix ?

2001-09-10 Thread Kimberly Smith


As long as your mount points are not sharing disks from
the same volume group you are correct.  However, its 
expensive to write to RAID 5 which is why you will usually
see raid 0+1 instead.

-Original Message-
Sent: Sunday, September 09, 2001 7:55 AM
To: Multiple recipients of list ORACLE-L


Hi Joe,

What's your configuration ? Raid 1 ?
How do U organize the oracle directories ? 

Correct me if I am wrong. I thought though I use Raid 5 but with different
mount points, I will not have contention problems 
For example 
One mount point for data files
Another mount point for index files. 

Please advise. Thanks.

Regds,
New Bee
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 09/09/2001 8:30 PM

if u dont know the underlying striping and someone else built the
filesystes, then the point is moot, you might as well have one logical
disk, since you cant reallt guarantee where something is going to end up
anyways.

with all of the raid5 stuff(that evryone likes so much anymore), we as
DBAs dont have control over where stuff is, so a good backup/recovery
plan is a must, at least in the old days when a physical device was
mapped to a filesystem(pre-logical volume days), we could handle making
sure of duplexing redo logs, etc.

joe
CHAN Chor Ling Catherine (CSC) wrote:
 
 Hi Guru,
 
 How do you organize your oracle directories in Unix ?
 
 I am thinking of using the configurations below. We are using Raid 5
with
 various mount points.
 
 \dg1\oracle = contains Oracle Human Resources software applications
and
 oracle home .eg. sidappl, sidcomn, sidora
 
 \dg2\oracle = contains redo log file and control file eg. sidredo 
sidctrl
 
 \dg3\oracle = contains redo log file and control file eg. sidredo 
sidctrl
 
 \dg4\oracle = contains redo log file and control file eg. sidredo 
sidctrl
 
 \dg5\oracle = system tablespace file and temp tablespace data file
.eg.
 siddata
 \dg6\oracle = data file and rollback segment data file .eg. siddata
 \dg7\oracle = index file eg. sididx
 \dg8\oracle = archive log file .eg. sidarc
 
 Is there any disadvantage if I put the redo log file and control file
in
 different directories but in the same mount point ?
 
 Is there any disadvantage if I put the rollback segment data file
together
 with my data file in the same directory ?
 
 Is there any disadvantage if I put the tablespace data file together
with my
 temp tablespace data file in the same directory ?
 
 TIA
 
 Regds,
 New Bee

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: CHAN Chor Ling Catherine (CSC)
  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: Kimberly Smith
  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: v_$session HELP...


Actually background processed are identified by BACKGROUND in the type
column and happen to have a null in the username.  



Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Background processes identified by null value in username column.


Igor   

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 8:55 AM


 Hi all,
 
 Can someone tell me who are those users that identified by null value 
 in username column
 
 
 SQL SELECT username from v_$session where osuser='dba';
 
 USERNAME
 ---
 
 
 
 
 
 
 SYS
 SYS
 
 8 rows selected.
 
 
 Thank you
 
 Sinardy
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Sinardy
   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: Christopher Spence
  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: manage oracle on SAP system

2001-09-10 Thread Hillman, Alex


Typo.

Alex Hillman

-Original Message-
Sent: Friday, September 07, 2001 6:31 PM
To: Multiple recipients of list ORACLE-L


Alex, 
Are you joking or it's a typo ? 
but I like Iracle (Irate+Oracle ??:) SAP DBA... 

- Kirti 

 -Original Message-
 From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, September 07, 2001 3:53 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: manage oracle on SAP system
 
 Why don't you buy Donald Burleson book about Iracle DBA in SAP
 environment.
 Do't remember exact  title but you can find it by author.
 
 Alex Hillman
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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: Hillman, Alex
  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: Last time an Index was used..

2001-09-10 Thread Miller, Jay


Wow, that's a nice feature.  Any idea what the overhead is for this (not
that we'll be moving to 9i for at least a year)?

Jay Miller

-Original Message-
Sent: Thursday, September 06, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L


Under 9i

MONITORING USAGE | NOMONITORING USAGE 

Use this clause to begin or end the collection of statistics on index
usage. This clause is useful in determining whether an index is being
used. 

Specify MONITORING USAGE to begin statistics collection. Oracle first
clears existing statistics on index and then begins to collect
statistics on index usage.
Statistics collection continues until a subsequent ALTER INDEX ...
NOMONITORING USAGE statement is executed. 

To terminate collection of statistics on index, specify NOMONITORING
USAGE. 

Connor McDonald wrote:
 
 Not really - but you could move it into its own
 tablespace and then monitor reads/write on this tspace
 using v$filestat.
 
 hth
 connor
 
  --- Veronica Levin [EMAIL PROTECTED] wrote: 
 Hi listers,
  Is there a chance I could find somehow the last time
  (date) an index was
  used
  Any help will be appreciated!
 
  Saludos,
  Veronica Levin Enriquez
  Administrador AIX
  Compañía Cervecera de Nicaragua
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Veronica Levin
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).
 
 =
 Connor McDonald
 http://www.oracledba.co.uk (mirrored at
 http://www.oradba.freeserve.co.uk)
 
 Some days you're the pigeon, some days you're the statue
 
 
 Do You Yahoo!?
 Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
 or your free @yahoo.ie address at http://mail.yahoo.ie
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?Connor=20McDonald?=
   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).

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Data-free analysis results in a success-free history.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: Miller, Jay
  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: export user definitions

2001-09-10 Thread Mohammad Rafiq


Kirti,
I found problem with strings on HP-UX. If create table line is long it cuts 
it. In Oracle Financials create tables scripts are very long and while 
converting dmp file to txt file it cuts a lot of stuff. Do you know any work 
around for this problem. I never observed this problem with NCR UNIX.
Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 10 Sep 2001 05:10:24 -0800

Rajesh,
  I am afraid indexfile option will not show such information.
  If using exported dump file is opted for such information, then it has to
be extracted using either 'strings' command (UNIX) or by importing using the
show=y log=logfile option. The logfile will then have to be edited to fish
out the required information, which may need quite a bit of editing to get a
working SQL. I like the 'strings' better for such tasks.

HTH,

Regards,

- Kirti Deshpande
   Verizon Information Services
http://www.superpages.com

  -Original Message-
  From:Rajesh Dayal [SMTP:[EMAIL PROTECTED]]
  Sent:Monday, September 10, 2001 7:10 AM
  To:  Multiple recipients of list ORACLE-L
  Subject: RE: export user definitions
 
  Do a full export ( without data, rows=n ) and import with indexfile
  option. You can see all the information including users.
 
  HTH,
  Rajesh
 
 
  -Original Message-
  Sent: Monday, September 10, 2001 1:45 PM
  To: Multiple recipients of list ORACLE-L
 
 
  hi everyone
 
  can anybody help me with a script that recreates
  user definitions and the granted roles ?
 
  thanks
 
  g.g. kor
  rdw ict groningen
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author:
INET: [EMAIL PROTECTED]
 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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: query for top customer

2001-09-10 Thread Ramon Estevez


SELECT B.CUSTOMER, B.SALES
   FROM (SELECT CUSTOMER, MAX(SALES) FROM SALES) B
WHERE
  ROWNUM  4


Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Oracle DBA
Enviado el: Monday, 10 September, 2001 8:30 AM
Para: Multiple recipients of list ORACLE-L
Asunto: query for top customer


how to write a query to find top 3 customer
based on their sales .
eg.
TABLE A
customer   sales
A100  100
A101   200
A102   105
A103109
A104108

RESULTS should be..
A101   200
A103109
A104108

Thanks in advance
Brajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Ramon Estevez
  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: query for top customer

2001-09-10 Thread Thomas, Kevin


Good grief!

Here's me publishing war-n-peace to solve a problem that takes
4 lines of code...that's the last time I go out both nights at the weekend!!
;)

Please ignore my overly-engineered email when it finally arrives...

-Original Message-
Sent: 10 September 2001 16:10
To: Multiple recipients of list ORACLE-L


Hi,

Try this query:

select customer,sales
from tablea x
where 3  (select count(*) from tablea y where y.sales  x.sales)
order by x.sales desc;


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Monday, September 10, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L
Subject:query for top customer

how to write a query to find top 3 customer
based on their sales .
eg.
TABLE A
customer   sales
A100  100
A101   200
A102   105
A103109
A104108

RESULTS should be..
A101   200
A103109
A104108

Thanks in advance
Brajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Carle, William T (Bill), NLCIO
  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: Thomas, Kevin
  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: db engines VS flat files

2001-09-10 Thread John Lewis


I think it's one of those things that if you have to ask then...

-Original Message-
Sent: Sunday, September 09, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L


I would like to know your opinion about the developments under for 
example perl for handling large amounts of datas (sets of flats files 
larger than 50 gigs) vs the option of using oracle for exmaple for doing 
the same task, wich would be more eficinet? why? cheers

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
Please do not re-send by any reazon in any way or form any of the 
informatino here contained. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: agc
  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: John Lewis
  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: Oracle, security the USAF?


Is this happening or happened?

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


Some of you may be interested in this:



--

1251.  AFRL successfully completes Oracle test program

ROME, N.Y. (AFPN) -- Air Force Research Laboratory engineers here
successfully completed participation in a six-month test program for the
next-generation database and internet server being developed by Oracle Corp.

Evaluation of technology focusing on network security was the primary goal
of participation in Oracle's Beta Test Program for Version 9i.

Under the auspices of its Joint Battlespace Infosphere program, the AFRL
information directorate focused its efforts on ensuring the latest major
release of Oracle software adheres to stringent Air Force and Department of
Defense guidelines for security of data generated and stored in
mission-critical command and control information systems.

Security issues remain a high priority as Air Force C2 legacy systems
undergo re-engineering, and a move toward using open commercial
product-based architectures and standards that are based on the internet and
World Wide Web.  DOD has adopted internet-like technology to support command
and control of worldwide military and humanitarian operations.

The directorate has numerous technology programs addressing information
management issues, but the JBI is one of its flagship efforts.

Originally described by the Air Force Scientific Advisory Board in a 1998
report and refined a year later, the JBI is a combat information management
system that provides individual users with the specific information required
for their functional responsibilities during crisis or conflict.

The SAB is a committee that provides independent guidance and insight to Air
Force senior leadership on science and technology for continued air and
space dominance.  One of the panel's main recommendations in its 1999 report
was to focus the AFRL, other Service research labs, and battlelabs on
evaluating and applying commercial technologies for the JBI. 

Participation in Oracle 9i Beta was an implementation of the SAB's guidance
to develop the JBI by evaluating and incorporating suitable commercial
off-the-shelf, or COTS, products.

AFRL leveraged and extended its in-house expertise by applying for 9i Beta
Test Site status in January.  In its proposal, the directorate team
identified security as the project focus area and generated stress tests and
remediation plans.  The directorate was selected in February as one of a
small number of Oracle beta sites located worldwide.  

To augment the existing team, AFRL brought on additional Oracle technical
support from the company's Advanced Products Group in Reston, Va., to aid
during beta testing.

Oracle has a rich history of working closely with Air Force engineers on
leading edge programs such as the JBI, said Eric Amberge, northeast
regional manager for Oracle's Advanced Programs Group.  This Beta test is
an excellent example of real government/industry interaction on the COTS
leading edge.  The AFRL cadre and their beta test findings were both
outstanding.

Participating in the Oracle 9i Beta program gave us a great opportunity to
continue our work with Oracle in the security area and influence future
commercial product releases, said Charles Flynn, lead engineer from the
AFRL information directorate.  Oracle is working to improve secure access
to information and developing products which exhibit a lot of appeal to the
military command and control systems designers. 

This effort allowed AFRL to get in on the ground floor six months before
commercial release and help Oracle refine their security products in order
to help meet JBI technical challenges, said Thomas A. Clark, program manager
of the effort in the directorate's JBI Office.  

We have found a lot of (commercial) products are not really addressing
security issues to the extent that Oracle has in the past, and continues to
do, he said. This effort allowed us to evaluate a next-generation
commercial product and influence its applicability to JBI.
-- 
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

RE: db engines VS flat files


Huh?  Doesn't the irs use flat files? :)

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L



In addition to Greg's comments I would like to add
that anyone suggesting flat files for 50 gig of data
is probably not at all familiar with database technology.

Perl is an excellent language for manipulating data, but
it is not a database engine.  50 gigs of data is totally unmanagable as flat
files.  

Personally, were someone to suggest that to me I would have
to bite my tongue to contain the laughter.  

At the very least, something like MySQL should be used.

For a look at what is available in the way or database interfaces for Perl,
have a look at:

http://search.cpan.org/Catalog/Database_Interfaces/

Jared


On Sunday 09 September 2001 12:40, agc wrote:
 I would like to know your opinion about the developments under for 
 example perl for handling large amounts of datas (sets of flats files 
 larger than 50 gigs) vs the option of using oracle for exmaple for 
 doing the same task, wich would be more eficinet? why? cheers

 The information contained in this communication is confidential, is 
 intended only for the use of the recipient named above, and may be 
 legally privileged. If the reader of this message is not the intended 
 recipient, you are hereby notified that any dissemination, 
 distribution or copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 Please do not re-send by any reazon in any way or form any of the
 informatino here contained.
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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).

OT: Anybody heard of...

2001-09-10 Thread Patrick Mullen



Anbody heard of a contract agency in the uk called Cyren?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Patrick Mullen
  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: Script for checking temp usage

2001-09-10 Thread Lucy Lin


try this query:

SELECT s.username, s.serial#, s.sid, u.tablespace, u.contents, u.extents,
u.blocks
 FROM v$session s, v$sort_usage u
 WHERE s.saddr=u.session_addr;


Lucy



On Mon, 10 Sep 2001, Jenkins, Michael wrote:

 Does anybody have a script that will tell you which session_ids are using
 temp and how much they are using?  We occasionally get runaway sessions that
 don't release temp and this would allow us to easily locate the offending
 session.
 
 I've already checked OraMag and used google with no significant results.
 
 Thanks in advance.
 
 --Michael
 

-- 
Lucy Lin Oracle DBA

condenet.com 212-286-3852

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lucy Lin
  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: Script for checking temp usage

2001-09-10 Thread Seley, Linda


Michael -

I've had similar problems (although the pain isn't high enough for me to get
in there and fix them yet).  To do this I've set up a cron job to check
every 15 minutes.  The script I run is:

set lines 100 pages 87

column username format a10
column tablespace format a6 heading 'TBSP'
column segfile# format 999 heading 'FILE#'
column extents format 9 heading 'EXT'
column blocks format 999

spool /tmp/sort1

select s.username,
  su.session_addr,
  su.session_num,
  su.sqladdr,
  su.tablespace,
  su.contents,
  su.segtype,
  su.segfile#,
  sum(su.extents) extents,
  sum(su.blocks) blocks, 
  sum((su.blocks*p.value)/1024/1024) M,
  sa.sql_text
from v$sort_usage su, 
  v$session s, 
  v$sqlarea sa, 
  v$parameter p
where su.session_num = s.serial#
  and s.sql_address=sa.address
  and p.name = 'db_block_size'
  and s.username  'SYS'
group by s.username,
  su.session_addr,
  su.session_num,
  su.sqladdr,
  su.tablespace,
  su.contents,
  su.segtype,
  su.segfile#,
  sa.sql_text
/
select *
from v$sort_segment
/

exit;

My ksh script checks to see if there are rows returned and if so sends me
the information.  

HTH!

Linda

-Original Message-
Sent: Monday, September 10, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L


Does anybody have a script that will tell you which session_ids are using
temp and how much they are using?  We occasionally get runaway sessions that
don't release temp and this would allow us to easily locate the offending
session.

I've already checked OraMag and used google with no significant results.

Thanks in advance.

--Michael
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  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: Seley, Linda
  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: Publishing HTML

2001-09-10 Thread Charlie Mengler


Below is the solution that was implemented  is now in production.

Scott Graves wrote:
 
 To produce a simple page,  at the sqlplus prompt type set markup html on
 then issue your query and spool it to a file.
 


#!/usr/bin/ksh
# Formats a simple webpage for an emergency call list.
#
. ${HOME}/oracle.chiron.HR.env 
sqlplus -silent EOF
username/password
column lastname   format a16
column phone  format a16
column department format a24
set lines 140 pages 60 echo off term off feedback off
set markup HTML on pre on spool on 
spool /opt/netscape/docs/bcm/phonelist.html
  select EMP.FIRSTNAME, EMP.LASTNAME, TTL.JOBLONG title,
DPT.DEPTLONG Department, EP.Phone
  from hr.empheader_master EMP,
   hr.eorg_master ORG,
   hr.jobnumber TTL,
   hr.depart DPT,
   hr.ejobsal_master JOB,
   hr.epersonal_master EP
  where EMP.A_I = 'A'
   and  ORG.DEPARTMENT in ('100','112','117','121','122','138')
   and  ORG.DEPARTMENT = DPT.DEPTCODE
   and  EMP.SSN = JOB.SSN
   and  EMP.SSN = ORG.SSN
   and  JOB.JOBNUMBER = TTL.JOBCODE
   and  EMP.SSN = EP.SSN
   order by 2
/
spool off
exit
EOF
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: query for top customer

2001-09-10 Thread Nirmal Kumar Muthu Kumaran


Hi thomas,

You use correlated sub-query for that, it's quite simple than ur stuff:

select * from emp a where n = (select count(distinct sal) from emp b where
a.sal = b.sal) order by sal desc;

---
[EMAIL PROTECTED] ed
Wrote file afiedt.buf

  1  select * from emp a where n = (select count(distinct sal) from emp b
where a.sal = b.sal)
  2* order by sal desc
[EMAIL PROTECTED] /
Enter value for n: 3
old   1: select * from emp a where n = (select count(distinct sal) from
emp b where a.sal = b.sal)
new   1: select * from emp a where 3 = (select count(distinct sal) from emp
b where a.sal = b.sal)

EMPNO ENAME  JOB MGR HIREDATESAL  COMM
DEPTNO
- -- - - - - -
-
 7839 KING   PRESIDENT   17-NOV-81  5000
10
 7788 SCOTT  ANALYST7566 09-DEC-82  3000
20
 7902 FORD   ANALYST7566 03-DEC-81  3000
20
 7566 JONES  MANAGER7839 02-APR-81  2975
20

4 rows selected.
---

The same thing you can impose in ur case also.

REgards,

Nirmal Kumar.


 -Original Message-
 From: Thomas, Kevin [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, September 10, 2001 6:35 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: query for top customer
 
 Try this...
 
 DECLARE
   CURSOR c_sales IS
   SELECT *
 FROM sales
ORDER BY sales desc;
   r_sales c_sales%rowtype;
   l_count NUMBER := 0;
 BEGIN
   OPEN c_sales;
   DBMS_OUTPUT.PUT_LINE( 'Customer' || ' ' || 'Sales' );
   WHILE l_count  3 LOOP
 FETCH c_sales INTO r_sales;
 DBMS_OUTPUT.PUT_LINE( r_sales.customer || ' ' || r_sales.sales );
 l_count := l_count + 1;
   END LOOP;
   CLOSE c_sales;
 END;
 /
 
 I did it as a pl/sql block because you can't be fancy (well not in 7.3.4)
 and use ROWNUM with an ORDER BY. I was going to
 suggest just doing:
 
 SELECT *
   FROM sales
  WHERE rownum  4
  ORDER BY sales DESC;
 
 But alas, this doesn't work...try the above, it's nasty but quick...
 
 HTH,
 
 Kev.
 
 
 __
 
 Kevin Thomas
 Technical Analyst
 Deregulation Services
 Calanais Ltd.
 (2nd Floor East - Weirs Building)
 Tel: 0141 568 2377
 Fax: 0141 568 2366
 http://www.calanais.com
 
 
 -Original Message-
 Sent: 10 September 2001 14:30
 To: Multiple recipients of list ORACLE-L
 
 
 how to write a query to find top 3 customer
 based on their sales .
 eg.
 TABLE A
 customer   sales
 A100  100
 A101   200
 A102   105
 A103109
 A104108
 
 RESULTS should be..
 A101   200
 A103109
 A104108
 
 Thanks in advance
 Brajesh
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Oracle DBA
   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: Thomas, Kevin
   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: Nirmal Kumar  Muthu Kumaran
  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: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.


You cannot compress single column unique indexes.  The rule is: you can compress up to 
n-1 columns of a unique index where n = the number of columns in the index.  A 
multi-column compressed index should, for maximum effect, have as its leading column 
the one with greatest  number of repeated values.  This is in conflict with the rule 
that states to put the column with the highest cardinality  first.  

Bear in mind compressing an index is not cost free.  The CPU will need to do more work 
to read the index; however the cost of the work will be less than doing a physical I/O.

You can compress all columns of a non-unique index.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  

-Original Message-
Sent: Monday, September 10, 2001 5:50 AM
To: Multiple recipients of list ORACLE-L



Ian,

I'll look at compressing the index.   Does that only work on unique indexes
or can you
do it on non-unique multi-column indexes as well?

Thanks,

Cherie


   
   
MacGregor,
   
Ian A.  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
[EMAIL PROTECTED]   cc:   
   
ford.EDUSubject: RE: Do fast full index scans do 
physical disk reads?
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
09/07/01 03:26 
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




The advantage of the fast full index scan is that it should read fewer
blocks than the full table scan.  Index compression may help reduce the
number of blocks read even further.   A unique index mist be at least two
columns wide to benefit from compression.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, September 07, 2001 5:20 AM
To: Multiple recipients of list ORACLE-L



Ian,

The last one I looked at it was cached, I guess.   I could purposely cache
the
table (and index) if it was small, though.

I'm confused though.   Isn't the whole benefit of the fast, full index scan
that you
don't have to go against the table, thereby avoiding those physical reads?

Or, in the case where the index isn't cached, is the benefit that you don't
have
to read all of the columns in the table that aren't part of the index?

Thanks for your reply,

Cherie



MacGregor,

Ian A.  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full
index scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om



09/07/01 01:05

AM

Please respond

to ORACLE-L







There is no rule that says an index will be cache.  Yes physical reads are
being done.
If the unique index is composed of more than one column look into
compressing it.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Thursday, September 06, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



I am confused by the output from tkprof below.   An fast full index
scan is being performed.   However, from the statistics, it looks as
thought 649 physical disk reads are being performed.  Is that actually
the case?   Are physical disk reads being done?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

RE: ORA-6502: numeric or value error. 8.1.5, NT

2001-09-10 Thread Grabowy, Chris


Ok, let's try this again.  

The limitation that I mentioned below about Excel is not true.  

We finally got the ColdFusion developer to look at this problem, after I
finally convinced everyone that this is not an Oracle or Excel issue.  The
CF developer immediately knew the answer.  Apparently, when you pass field
data between CF and Oracle there is a default limitation of 255 characters.
The CF developer raised this limitation to 1,000 for the field in question
in the .cfm code.  And the application now works correctly.  

Something to keep in mind when dealing with ColdFusion...

Tom, thanks for all the PL/SQL help.  It sure looked like an Oracle error.
Oh well...

Thanks.

Chris
May Oracle be with you...always

-Original Message-
Sent: Wednesday, September 05, 2001 3:13 PM
To: 'Mercadante, Thomas F'; '[EMAIL PROTECTED]'
Cc: Grabowy, Chris


Thanks to Tom M and everyone else that responded.

When the procedures are called from within Oracle with the same data then
there are no errors.  This now appears to be an Excel problem.  Apparently,
Excel has a limitation with inserting 255+ characters into a cell.  So, yes,
the app was retrieving data from Oracle and feeding it into Excel.  But
instead of getting an Excel error we were getting Oracle errors.  

This will be confirmed when the programmer splits the data into small chunks
and feeds them into different cells.

Thanks.

Chris

-Original Message-
Sent: Tuesday, September 04, 2001 3:51 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Chris, 
want to try something?

Create a local variable for the TITLE column (local to this procedure.
Select the data into the local variable, then reassign it to your OUT
variable and see if the same thing happens.

like::


l_study_title_out study.title%TYPE;

begin

select title into l_study_title_out from;


study_title_out := l_study_title_out;


end;

see if you get the same error.
You can use DBMS_OUTPUT to depbug the steps if it helps.

I've seen stuff with selects and out variables that don't make sense
sometimes.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 04, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L


Let's try that once more...

procedure get_study_info (study_id_in IN study.study_id%TYPE,
  study_title_out OUT study.title%TYPE,
  brief_title_out OUT study.brief_title%TYPE,
  study_number_out OUT study.client_study_no%TYPE,
  protocol_number_out OUT
study.sponsor_protocol_no%TYPE,
  sponsor_out OUT company.company_name%TYPE,
  cro_out OUT company.company_name%TYPE,
  therapeutic_agent_out OUT
therapeutic_agent.therapeutic_agent%TYPE,
  clinical_state_out OUT indication.indication%TYPE,
  study_status_out OUT current_status.label%TYPE,
  target_number_of_sites_out OUT
study.target_num_of_sites%TYPE,
  target_number_of_subjects_out OUT
study.target_num_of_subjects%TYPE)
 IS
 BEGIN
select title, brief_title, client_study_no, sponsor_protocol_no, 
 sponsor_company.company_name sponsor_name,
 cro_company.company_name cro_name, ta.therapeutic_agent, 
 i.indication indication,
 cs.label current_study_status, nvl(target_num_of_sites, 0)
target_num_of_sites, 
 nvl(target_num_of_subjects, 0) target_num_of_subjects
into study_title_out, brief_title_out, study_number_out,
protocol_number_out, 
 sponsor_out, cro_out, therapeutic_agent_out, clinical_state_out,
 study_status_out, target_number_of_sites_out,
target_number_of_subjects_out
from study s, company sponsor_company, company cro_company,
therapeutic_agent ta,
 indication i, current_status cs
where s.sponsor=sponsor_company.company_id
and s.cro=cro_company.company_id (+)
and s.therapeutic_agent_id=ta.therapeutic_agent_id
and s.indication_id=i.indication_id
and current_study_status_id=cs.current_status_id
and s.study_id=study_id_in;
 end get_study_info;

Hopefully, that will come out in a better format on the list...

BTW, per Tom's question the calling procedure also TYPE's the study title 
to the STUDY.TITLE table/column.

Chris

-Original Message-
Sent: Tuesday, September 04, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L


Chris,

Need to see the whole procedure ...

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 !

*1

This e-mail message is confidential, intended only for the named

RE: Script for checking temp usage


Have you looked at v$sort_usage?  (8i only)

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Does anybody have a script that will tell you which session_ids are using
temp and how much they are using?  We occasionally get runaway sessions that
don't release temp and this would allow us to easily locate the offending
session.

I've already checked OraMag and used google with no significant results.

Thanks in advance.

--Michael
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  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: Christopher Spence
  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: Last time an Index was used..


Not much at all, you can use monitoring in Oracle 8i.

Since it only writes the changes every few hours, it has very monitor
impact.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L


Wow, that's a nice feature.  Any idea what the overhead is for this (not
that we'll be moving to 9i for at least a year)?

Jay Miller

-Original Message-
Sent: Thursday, September 06, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L


Under 9i

MONITORING USAGE | NOMONITORING USAGE 

Use this clause to begin or end the collection of statistics on index usage.
This clause is useful in determining whether an index is being used. 

Specify MONITORING USAGE to begin statistics collection. Oracle first clears
existing statistics on index and then begins to collect statistics on index
usage. Statistics collection continues until a subsequent ALTER INDEX ...
NOMONITORING USAGE statement is executed. 

To terminate collection of statistics on index, specify NOMONITORING USAGE. 

Connor McDonald wrote:
 
 Not really - but you could move it into its own
 tablespace and then monitor reads/write on this tspace
 using v$filestat.
 
 hth
 connor
 
  --- Veronica Levin [EMAIL PROTECTED] wrote: 
 Hi listers,
  Is there a chance I could find somehow the last time
  (date) an index was
  used
  Any help will be appreciated!
 
  Saludos,
  Veronica Levin Enriquez
  Administrador AIX
  Compañía Cervecera de Nicaragua
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Veronica Levin
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).
 
 =
 Connor McDonald
 http://www.oracledba.co.uk (mirrored at
 http://www.oradba.freeserve.co.uk)
 
 Some days you're the pigeon, some days you're the statue
 
 
 Do You Yahoo!?
 Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your 
 free @yahoo.ie address at http://mail.yahoo.ie
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?Connor=20McDonald?=
   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).

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Data-free analysis results in a success-free history.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: Miller, Jay
  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

RE: export user definitions

2001-09-10 Thread Deshpande, Kirti


Mohammed,
 No, I have not found a solution for it. IBM-AIX does that too. I have
several tables with partitions, and the ddl for it is never complete, if I
used strings. So I use it for things that do not have long SQL statements.
For others, I use scripts or 3rd party tools. 

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, September 10, 2001 11:40 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: export user definitions
 
 Kirti,
 I found problem with strings on HP-UX. If create table line is long it
 cuts 
 it. In Oracle Financials create tables scripts are very long and while 
 converting dmp file to txt file it cuts a lot of stuff. Do you know any
 work 
 around for this problem. I never observed this problem with NCR UNIX.
 Regards
 
 MOHAMMAD RAFIQ
 
 
 
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Date: Mon, 10 Sep 2001 05:10:24 -0800
 
 Rajesh,
   I am afraid indexfile option will not show such information.
   If using exported dump file is opted for such information, then it has
 to
 be extracted using either 'strings' command (UNIX) or by importing using
 the
 show=y log=logfile option. The logfile will then have to be edited to
 fish
 out the required information, which may need quite a bit of editing to get
 a
 working SQL. I like the 'strings' better for such tasks.
 
 HTH,
 
 Regards,
 
 - Kirti Deshpande
Verizon Information Services
 http://www.superpages.com
 
   -Original Message-
   From:  Rajesh Dayal [SMTP:[EMAIL PROTECTED]]
   Sent:  Monday, September 10, 2001 7:10 AM
   To:Multiple recipients of list ORACLE-L
   Subject:   RE: export user definitions
  
   Do a full export ( without data, rows=n ) and import with indexfile
   option. You can see all the information including users.
  
   HTH,
   Rajesh
  
  
   -Original Message-
   Sent: Monday, September 10, 2001 1:45 PM
   To: Multiple recipients of list ORACLE-L
  
  
   hi everyone
  
   can anybody help me with a script that recreates
   user definitions and the granted roles ?
  
   thanks
  
   g.g. kor
   rdw ict groningen
  
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author:
 INET: [EMAIL PROTECTED]
  
  
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Deshpande, Kirti
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).
 
 
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohammad Rafiq
   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: Deshpande, Kirti
  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).

[Fwd: Re: patch question]

2001-09-10 Thread Joan Hsieh


Thanks, Joe,

I read the notes. It seems can go either way. I reinstalled the 817 base
again. My next question puzzled me, should I upgrade database first
816- 817, then apply the patch, or apply patch goes first? Maybe it
goes either way. But I'd like to hear some advice first.

Joan

 Original Message 
 Subject: Re: patch question
Date: Thu, 06 Sep 2001 09:47:01 -0800
From: JOE TESTA [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]

 Joan, check out the release notes for aix patches, if i remember
correctly: 8.1.7.0 - 8.1.7.18.1.7.0 - 8.1.7.2 8.1.7.1 - 8.1.7.0 -
8.1.7.2 to go from 8171 to 8172, i think you have to reinstall 8.1.7.0,
run all scripts, then apply patch and run scripts again. joe

 [EMAIL PROTECTED] 09/06/01 01:32PM 
Hi Listers,

I am asking a simple question today. We have 8.1.6 production database
and want to upgrade to 8.1.7.2 on AIX R/6000.

1. I installed 8.1.7 on production already. Can I install 8.1.7.2 patch
direct on top of 8.1.7 or have to go 8.1.7.1 first?

2. Installed patch first, then upgrade database later or upgrade
database from 8.1.6 to 8.1.7 then installed patch later?

Thanks,

Joan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
  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: Joan Hsieh
  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: Do fast full index scans do physical disk reads?


Actually you can create compressed indexes upto the size of the columns.
In other words, the last column in a concentated index can be compressed.
Although most practice does not.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


You cannot compress single column unique indexes.  The rule is: you can
compress up to n-1 columns of a unique index where n = the number of columns
in the index.  A multi-column compressed index should, for maximum effect,
have as its leading column the one with greatest  number of repeated values.
This is in conflict with the rule that states to put the column with the
highest cardinality  first.  

Bear in mind compressing an index is not cost free.  The CPU will need to do
more work to read the index; however the cost of the work will be less than
doing a physical I/O.

You can compress all columns of a non-unique index.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  

-Original Message-
Sent: Monday, September 10, 2001 5:50 AM
To: Multiple recipients of list ORACLE-L



Ian,

I'll look at compressing the index.   Does that only work on unique indexes
or can you
do it on non-unique multi-column indexes as well?

Thanks,

Cherie


 

MacGregor,

Ian A.  To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]  
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full index
scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om

 

 

09/07/01 03:26

PM

Please respond

to ORACLE-L

 

 





The advantage of the fast full index scan is that it should read fewer
blocks than the full table scan.  Index compression may help reduce the
number of blocks read even further.   A unique index mist be at least two
columns wide to benefit from compression.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, September 07, 2001 5:20 AM
To: Multiple recipients of list ORACLE-L



Ian,

The last one I looked at it was cached, I guess.   I could purposely cache
the
table (and index) if it was small, though.

I'm confused though.   Isn't the whole benefit of the fast, full index scan
that you
don't have to go against the table, thereby avoiding those physical reads?

Or, in the case where the index isn't cached, is the benefit that you don't
have to read all of the columns in the table that aren't part of the index?

Thanks for your reply,

Cherie



MacGregor,

Ian A.  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full
index scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om



09/07/01 01:05

AM

Please respond

to ORACLE-L







There is no rule that says an index will be cache.  Yes physical reads are
being done. If the unique index is composed of more than one column look
into compressing it.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Thursday, September 06, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



I am confused by the output from tkprof below.   An fast full index
scan is being performed.   However, from the statistics, it looks as
thought 649 physical disk reads are being performed.  Is that actually
the case?   Are physical disk reads being done?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network





Select SD.KS_OBJECTID as CONCEPTID
From kbowner.KS_SHORTDESCRIPTION SD
Where SD.KS_DESCRIPTIONTYPE = 'CPTNAME' And
UPPER(SD.KS_DESCRIPTIONTEXT) = ''

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.03   0.03  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch1  0.30   0.30649649  4
0
--- --   -- -- -- --
--
total3  0.33   0.33649649  4
0

Rows Row Source Operation

Re:RE: Oracle, security the USAF?


Last time I looked it up 'completes' was past tense, as in history.

Dick Goulet

Reply Separator
Author: Christopher Spence [EMAIL PROTECTED]
Date:   9/10/2001 8:25 AM

Is this happening or happened?

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


Some of you may be interested in this:



--

1251.  AFRL successfully completes Oracle test program

ROME, N.Y. (AFPN) -- Air Force Research Laboratory engineers here
successfully completed participation in a six-month test program for the
next-generation database and internet server being developed by Oracle Corp.

Evaluation of technology focusing on network security was the primary goal
of participation in Oracle's Beta Test Program for Version 9i.

Under the auspices of its Joint Battlespace Infosphere program, the AFRL
information directorate focused its efforts on ensuring the latest major
release of Oracle software adheres to stringent Air Force and Department of
Defense guidelines for security of data generated and stored in
mission-critical command and control information systems.

Security issues remain a high priority as Air Force C2 legacy systems
undergo re-engineering, and a move toward using open commercial
product-based architectures and standards that are based on the internet and
World Wide Web.  DOD has adopted internet-like technology to support command
and control of worldwide military and humanitarian operations.

The directorate has numerous technology programs addressing information
management issues, but the JBI is one of its flagship efforts.

Originally described by the Air Force Scientific Advisory Board in a 1998
report and refined a year later, the JBI is a combat information management
system that provides individual users with the specific information required
for their functional responsibilities during crisis or conflict.

The SAB is a committee that provides independent guidance and insight to Air
Force senior leadership on science and technology for continued air and
space dominance.  One of the panel's main recommendations in its 1999 report
was to focus the AFRL, other Service research labs, and battlelabs on
evaluating and applying commercial technologies for the JBI. 

Participation in Oracle 9i Beta was an implementation of the SAB's guidance
to develop the JBI by evaluating and incorporating suitable commercial
off-the-shelf, or COTS, products.

AFRL leveraged and extended its in-house expertise by applying for 9i Beta
Test Site status in January.  In its proposal, the directorate team
identified security as the project focus area and generated stress tests and
remediation plans.  The directorate was selected in February as one of a
small number of Oracle beta sites located worldwide.  

To augment the existing team, AFRL brought on additional Oracle technical
support from the company's Advanced Products Group in Reston, Va., to aid
during beta testing.

Oracle has a rich history of working closely with Air Force engineers on
leading edge programs such as the JBI, said Eric Amberge, northeast
regional manager for Oracle's Advanced Programs Group.  This Beta test is
an excellent example of real government/industry interaction on the COTS
leading edge.  The AFRL cadre and their beta test findings were both
outstanding.

Participating in the Oracle 9i Beta program gave us a great opportunity to
continue our work with Oracle in the security area and influence future
commercial product releases, said Charles Flynn, lead engineer from the
AFRL information directorate.  Oracle is working to improve secure access
to information and developing products which exhibit a lot of appeal to the
military command and control systems designers. 

This effort allowed AFRL to get in on the ground floor six months before
commercial release and help Oracle refine their security products in order
to help meet JBI technical challenges, said Thomas A. Clark, program manager
of the effort in the directorate's JBI Office.  

We have found a lot of (commercial) products are not really addressing
security issues to the extent that Oracle has in the past, and continues to
do, he said. This effort allowed us to evaluate a next-generation
commercial product and influence its applicability to JBI.
-- 
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

Re: Script for checking temp usage

2001-09-10 Thread Christian Trassens


Since 8.X joining v$sort_usage and v$session. In 7.X
Metalink had an script that I enclose.

When the query is running, you can issue a query over
v$session_wait. Looking for the event 'db file
sequential read' where p1 includes all the files of
the temp tablespace.

Regards.




--- Jenkins, Michael [EMAIL PROTECTED]
wrote:
 Does anybody have a script that will tell you which
 session_ids are using
 temp and how much they are using?  We occasionally
 get runaway sessions that
 don't release temp and this would allow us to easily
 locate the offending
 session.
 
 I've already checked OraMag and used google with no
 significant results.
 
 Thanks in advance.
 
 --Michael
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Jenkins, Michael
   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).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
 findtemp.sql

RE: shutdown immediate hangs

2001-09-10 Thread Khushalani, Vikram


Dave,

Worth Checking - 

Sometimes the OracleSIDAgent service or the OracleSIDDataGatherer
service, if running, will cause the SHUTDOWN IMMEDIATE to hang.  Try
shutting such services down by including a 'net stop OracleSIDAgent..'
etc. in your script, just before you issue the SHUTDOWN IMMEDIATE.

HTH
Vikram Khushalani
Oracle DBA

-Original Message-
Sent: Monday, September 10, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on windoze NT 4.0.  Every night I have a script
that kicks off a cold backup.  Part of the script issues the command

SHUTDOWN IMMEDIATE

which normally works just fine before I actually copy my files.  However,
periodically the shutdown immediate command does not work.  It just hangs
until someone complains that they cannot connect to the database or when I
come in early in the morning and notice it hanging.
In my SIDAlrt.log I get the following

SHUTDOWN: waiting for active calls to complete

This also shows up in a trace file file multiple times.  I have to issue a
shutdown abort to stop the database.

In doing some research on metalink I see that otheres also have this
problem.  The responses from Oracle are somewhat vague.  I do see that one
of the responses seems to indicate that if the intelligent agent is running
that it could be the cause for the hanging.  Has anyone else had this
problem and solved it by shutting down the intelligent agent service??  Any
other things that I can do to remedy this.

Thanks,

Dave
-- 
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: Khushalani, Vikram
  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: ms acces

2001-09-10 Thread schmoldt

Oracle's Migration Workbench will do what you need, if you're on Oracle
Client 8.1.7 or newer.

 -Original Message-
 From: agc [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, September 06, 2001 2:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: ms acces

 is there any tool that imports directly form ms acces to oracle? 
 with out having to export ms acces files to flat text files and then 
 load them in to oracle but some sort  of direct importation? cheers

 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 Please do not re-send by any reazon in any way or form any of the 
 informatino here contained. 

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: agc
   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: export user definitions

2001-09-10 Thread Mohammad Rafiq

Thanks...for update...

MOHAMMAD RAFIQ

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 10 Sep 2001 10:10:19 -0800

Mohammed,
  No, I have not found a solution for it. IBM-AIX does that too. I have
several tables with partitions, and the ddl for it is never complete, if I
used strings. So I use it for things that do not have long SQL statements.
For others, I use scripts or 3rd party tools.

Regards,

- Kirti Deshpande
   Verizon Information Services
http://www.superpages.com

  -Original Message-
  From:Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
  Sent:Monday, September 10, 2001 11:40 AM
  To:  Multiple recipients of list ORACLE-L
  Subject: RE: export user definitions

  Kirti,
  I found problem with strings on HP-UX. If create table line is long it
  cuts
  it. In Oracle Financials create tables scripts are very long and while
  converting dmp file to txt file it cuts a lot of stuff. Do you know any
  work
  around for this problem. I never observed this problem with NCR UNIX.
  Regards

  MOHAMMAD RAFIQ

  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Date: Mon, 10 Sep 2001 05:10:24 -0800

  Rajesh,
I am afraid indexfile option will not show such information.
If using exported dump file is opted for such information, then it has
  to
  be extracted using either 'strings' command (UNIX) or by importing using
  the
  show=y log=logfile option. The logfile will then have to be edited to
  fish
  out the required information, which may need quite a bit of editing to 
get
  a
  working SQL. I like the 'strings' better for such tasks.

  HTH,

  Regards,

  - Kirti Deshpande
 Verizon Information Services
  http://www.superpages.com

-Original Message-
From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 7:10 AM
To:   Multiple recipients of list ORACLE-L
Subject:  RE: export user definitions

Do a full export ( without data, rows=n ) and import with indexfile
option. You can see all the information including users.

HTH,
Rajesh

-Original Message-
Sent: Monday, September 10, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L

hi everyone

can anybody help me with a script that recreates
user definitions and the granted roles ?

thanks

g.g. kor
rdw ict groningen

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

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Deshpande, Kirti
 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).

  _
  Get your FREE download of MSN Explorer at 
http://explorer.msn.com/intl.asp

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Mohammad Rafiq
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: Deshpande, Kirti
   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ:

RE: Cloning Database failed

2001-09-10 Thread Miller, Jay


Unfortunately I'm not using RMAN.  If I can find the space somewhere I'll
test recreating the control file route and create it with just a few
tablespaces.

-Original Message-
Sent: Friday, September 07, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


If you are using rman try doing a switch on the datafile which you moved.
If you need more info write me directly.

Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 11:32 AM


 I went to replace my QC database from production yesterday (we do this
about
 once a month) and discovered that there wasn't enough room in one of the
 filesystems to copy all the hot backup files.  No problem I thought, I
just
 copied one of the larger files to a different filesystem, mounted the
 database, and renamed to file to point to the new location.  I then did my
 recovery, but when I tried to do ALTER DATABASE OPEN RESETLOGS I got
 ORA-01113: file 1 needs media recovery

 ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf'

 I tried applying more archive logs, eventually applying over 10 hours
worth.
 Still got the error.  I redid it this morning in case I had copied the
wrong
 file somewhere, but once again...

 I'm now assuming that the problem was caused by my having renamed the
file.
 Can anyone confirm or deny this and give me a suggestion on how to resolve
 the issue?  I'm considering rebuilding the control file without an index
 tablespace to free up space but now I'm afraid that I'll get the same
error.

 It's not a high priority since my SA just called to let me know he was
able
 to find a few extra Meg for the filesystem (I was only short a frustrating
 300K), but I'd still like to know what the problem was and any suggestions
 (in case it happens again in the future).

 Oracle 8.0.4.3, Solaris 2.5.1



 TIA,
 Jay Miller

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Miller, Jay
   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: Ruth Gramolini
  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: Miller, Jay
  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: shutdown immediate hangs

2001-09-10 Thread Walthour, Jon (GEAE, Compaq)


Dave:

The message in the alert log means that there are uncommitted transactions.
During a shutdown immediate uncommitted transactions are rolled back and
Oracle must wait until this rollback is complete before the db can be
actually shut down.

You could do a shutdown abort, but then you would have to have this rollback
done during startup, which may be preferable, but Oracle does not recommend
shutdown aborts unless absolutely necessary and one shouldn't rely on a cold
backup taken on an aborted db. Either way, though, the rollback must occur.

One thing you could do is check v$transaction before you shutdown. The
used_ublk column may give you some idea of how much rollback has to be done.


Jon Walthour

-Original Message-
Sent: Monday, September 10, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on windoze NT 4.0.  Every night I have a script
that kicks off a cold backup.  Part of the script issues the command

SHUTDOWN IMMEDIATE

which normally works just fine before I actually copy my files.  However,
periodically the shutdown immediate command does not work.  It just hangs
until someone complains that they cannot connect to the database or when I
come in early in the morning and notice it hanging. In my SIDAlrt.log I
get the following

SHUTDOWN: waiting for active calls to complete

This also shows up in a trace file file multiple times.  I have to issue a
shutdown abort to stop the database.

In doing some research on metalink I see that otheres also have this
problem.  The responses from Oracle are somewhat vague.  I do see that one
of the responses seems to indicate that if the intelligent agent is running
that it could be the cause for the hanging.  Has anyone else had this
problem and solved it by shutting down the intelligent agent service??  Any
other things that I can do to remedy this.

Thanks,

Dave
-- 
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: Walthour, Jon (GEAE, Compaq)
  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: db engines VS flat files

2001-09-10 Thread Jared . Still



Since we're not in a meeting, I don't have to bite my tongue.

'Context sensitive indexing' comes to mind.

Jared



   
 
agc
 
acad@accefyn.   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
org.co  cc:   
 
Sent by: Subject: Re: db engines VS flat files 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
09/10/01 09:10 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




well so start to bite your tonge :-)  because yes there are some very
large collections of datas stored as flat text files, so do bite it
and do it very hard because this large amounts of datas may almost
doble the size every year... and most of them are being searched and
manipulated with perl scripts. I do not know if has been that way
because of not knowign search engines, do not think that is the
case, that I do not know but my
question remains. ok, for only seraching patterns with in this
falt files wich would be the difference between having a real search
engine and just having perl scripts for searching patterns with in
this flat text files? until now all I can say is that most of
administrative tasks are quite dificult to do under perl and shell
scripts, and c progrmas, but for the rest and even knowing that all
this works under cgis, it works fine well... so do not laught so hard
may loose your tonge :-)

On Mon, 10 Sep 2001, Jared Still wrote:

 Date: Mon, 10 Sep 2001 06:40:19 -0800
 From: Jared Still [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: db engines VS flat files


 In addition to Greg's comments I would like to add
 that anyone suggesting flat files for 50 gig of data
 is probably not at all familiar with database technology.

 Perl is an excellent language for manipulating data, but
 it is not a database engine.  50 gigs of data is totally
 unmanagable as flat files.

 Personally, were someone to suggest that to me I would have
 to bite my tongue to contain the laughter.

 At the very least, something like MySQL should be used.

 For a look at what is available in the way or database
 interfaces for Perl, have a look at:

 http://search.cpan.org/Catalog/Database_Interfaces/

 Jared


 On Sunday 09 September 2001 12:40, agc wrote:
  I would like to know your opinion about the developments under for
  example perl for handling large amounts of datas (sets of flats files
  larger than 50 gigs) vs the option of using oracle for exmaple for
doing
  the same task, wich would be more eficinet? why? cheers
 
  The information contained in this communication is
  confidential, is intended only for the use of the recipient
  named above, and may be legally privileged. If the reader
  of this message is not the intended recipient, you are
  hereby notified that any dissemination, distribution or
  copying of this communication is strictly prohibited.
  If you have received this communication in error, please
  re-send this communication to the sender and delete the
  original message or any copy of it from your computer
  system.
  Please do not re-send by any reazon in any way or form any of the
  informatino here contained.
 --
 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,

Re:RE: shutdown immediate hangs


Jon,

One correction, shutdown immediate waits till all uncommitted transactions
are committed or rolled back.  The client session must do one or the other,
otherwise the shutdown hangs waiting for the end user.  This is a good example
of where setting the idle time in user_profiles is a good thing.  Since after
the specified time idle time period Oracle will rollback the users transaction
and terminate their session whether or not they wanted to.  Works well with end
users who start a transaction and then go home for the weekend without closing
down their database connection.

Dick Goulet

Reply Separator
Author: Walthour; Jon (GEAE; Compaq) [EMAIL PROTECTED]
Date:   9/10/2001 10:55 AM

Dave:

The message in the alert log means that there are uncommitted transactions.
During a shutdown immediate uncommitted transactions are rolled back and
Oracle must wait until this rollback is complete before the db can be
actually shut down.

You could do a shutdown abort, but then you would have to have this rollback
done during startup, which may be preferable, but Oracle does not recommend
shutdown aborts unless absolutely necessary and one shouldn't rely on a cold
backup taken on an aborted db. Either way, though, the rollback must occur.

One thing you could do is check v$transaction before you shutdown. The
used_ublk column may give you some idea of how much rollback has to be done.


Jon Walthour

-Original Message-
Sent: Monday, September 10, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on windoze NT 4.0.  Every night I have a script
that kicks off a cold backup.  Part of the script issues the command

SHUTDOWN IMMEDIATE

which normally works just fine before I actually copy my files.  However,
periodically the shutdown immediate command does not work.  It just hangs
until someone complains that they cannot connect to the database or when I
come in early in the morning and notice it hanging. In my SIDAlrt.log I
get the following

SHUTDOWN: waiting for active calls to complete

This also shows up in a trace file file multiple times.  I have to issue a
shutdown abort to stop the database.

In doing some research on metalink I see that otheres also have this
problem.  The responses from Oracle are somewhat vague.  I do see that one
of the responses seems to indicate that if the intelligent agent is running
that it could be the cause for the hanging.  Has anyone else had this
problem and solved it by shutting down the intelligent agent service??  Any
other things that I can do to remedy this.

Thanks,

Dave
-- 
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: Walthour, Jon (GEAE, Compaq)
  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).

What's wrong with this query

2001-09-10 Thread Anne Yu


Hey list,   Can anyone tell me what's wrong with this query?

many thanks,


select /*+ INDEX(b)*/ distinct d.batch_number
  , d.document_number
  , d.entry_user_id
  , d.document_type_id
  , d.document_processed_date
  , b.batch_media_id, d.return_Method_Id
from submitter_batch b , document d
  , ucc_master_amendment m
where d.batch_number = b.batch_number
   and d.document_number = m.document_number
   and d.imaged = 0
   and b.batch_media_id = 4
   and d.document_status_id = 4




  Submitter_batch - 97853 rows
  Document-   8043272 rows (fk_d_batchnumber index on
batch_number)
  Ucc_master_adment   -0 rows  (pk_uma_dn index on document_number)





Here is the explain plan:

explain planexpected rows   object name
 

select statement   164662478 
   sort (unique) 164662478
   nested loops 164662478
 nested loops 2008079
   table access(full)  46193  submitted
batch
  table access(by idx)  2008079  document
   index(range scan)  2008079
fk_d_batchnumber non-unique
 index(unique scan) 82
pk_uma_dn unique



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  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: shutdown immediate hangs

2001-09-10 Thread Cherie_Machler



Dave,

We've periodically had this problem with various jobs that
were running at the time of the shutdown immediate.   I try
to isolate the cause by killing the various processes I still
see running via ps -ef | grep SID.

Sometimes the problem has been our RMAN backup that
is running, sometimes it's a problem with our piped export
script, and sometimes it is our third party monitoring tool,
Precise.

A simple solution would be to do a shutdown abort, startup
restrict, and a normal shutdown instead of shutdown immediate.

Another solution would be to write a script that checks to see
what processes are still running and kill them all.

Cherie Machler
Oracle DBA
Gelco Information Network


   

Farnsworth, Dave 

DFarnsworth@Ashleyfurn   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]  
iture.comcc:  

Sent by:  Subject: shutdown immediate 
hangs
[EMAIL PROTECTED]   

   

   

09/10/01 11:10 AM  

Please respond to  

ORACLE-L   

   

   





I have Oracle 8.1.7 running on windoze NT 4.0.  Every night I have a script
that kicks off a cold backup.  Part of the script issues the command

SHUTDOWN IMMEDIATE

which normally works just fine before I actually copy my files.  However,
periodically the shutdown immediate command does not work.  It just hangs
until someone complains that they cannot connect to the database or when I
come in early in the morning and notice it hanging.
In my SIDAlrt.log I get the following

SHUTDOWN: waiting for active calls to complete

This also shows up in a trace file file multiple times.  I have to issue a
shutdown abort to stop the database.

In doing some research on metalink I see that otheres also have this
problem.  The responses from Oracle are somewhat vague.  I do see that one
of the responses seems to indicate that if the intelligent agent is running
that it could be the cause for the hanging.  Has anyone else had this
problem and solved it by shutting down the intelligent agent service??  Any
other things that I can do to remedy this.

Thanks,

Dave
--
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: 
  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: RE: Oracle, security the USAF?


I wonder what was the result of their findings.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 1:27 PM
To: Christopher Spence; Multiple recipients of list ORACLE-L


Last time I looked it up 'completes' was past tense, as in history.

Dick Goulet

Reply Separator
Author: Christopher Spence [EMAIL PROTECTED]
Date:   9/10/2001 8:25 AM

Is this happening or happened?

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


Some of you may be interested in this:



--

1251.  AFRL successfully completes Oracle test program

ROME, N.Y. (AFPN) -- Air Force Research Laboratory engineers here
successfully completed participation in a six-month test program for the
next-generation database and internet server being developed by Oracle Corp.

Evaluation of technology focusing on network security was the primary goal
of participation in Oracle's Beta Test Program for Version 9i.

Under the auspices of its Joint Battlespace Infosphere program, the AFRL
information directorate focused its efforts on ensuring the latest major
release of Oracle software adheres to stringent Air Force and Department of
Defense guidelines for security of data generated and stored in
mission-critical command and control information systems.

Security issues remain a high priority as Air Force C2 legacy systems
undergo re-engineering, and a move toward using open commercial
product-based architectures and standards that are based on the internet and
World Wide Web.  DOD has adopted internet-like technology to support command
and control of worldwide military and humanitarian operations.

The directorate has numerous technology programs addressing information
management issues, but the JBI is one of its flagship efforts.

Originally described by the Air Force Scientific Advisory Board in a 1998
report and refined a year later, the JBI is a combat information management
system that provides individual users with the specific information required
for their functional responsibilities during crisis or conflict.

The SAB is a committee that provides independent guidance and insight to Air
Force senior leadership on science and technology for continued air and
space dominance.  One of the panel's main recommendations in its 1999 report
was to focus the AFRL, other Service research labs, and battlelabs on
evaluating and applying commercial technologies for the JBI. 

Participation in Oracle 9i Beta was an implementation of the SAB's guidance
to develop the JBI by evaluating and incorporating suitable commercial
off-the-shelf, or COTS, products.

AFRL leveraged and extended its in-house expertise by applying for 9i Beta
Test Site status in January.  In its proposal, the directorate team
identified security as the project focus area and generated stress tests and
remediation plans.  The directorate was selected in February as one of a
small number of Oracle beta sites located worldwide.  

To augment the existing team, AFRL brought on additional Oracle technical
support from the company's Advanced Products Group in Reston, Va., to aid
during beta testing.

Oracle has a rich history of working closely with Air Force engineers on
leading edge programs such as the JBI, said Eric Amberge, northeast
regional manager for Oracle's Advanced Programs Group.  This Beta test is
an excellent example of real government/industry interaction on the COTS
leading edge.  The AFRL cadre and their beta test findings were both
outstanding.

Participating in the Oracle 9i Beta program gave us a great opportunity to
continue our work with Oracle in the security area and influence future
commercial product releases, said Charles Flynn, lead engineer from the
AFRL information directorate.  Oracle is working to improve secure access
to information and developing products which exhibit a lot of appeal to the
military command and control systems designers. 

This effort allowed AFRL to get in on the ground floor six months before
commercial release and help Oracle refine their security products in order
to help meet JBI technical challenges, said Thomas A. Clark, program manager
of the effort in the directorate's JBI Office.  

We have found a lot of (commercial) products are not really

Re:RE: shutdown immediate hangs

2001-09-10 Thread Jeremiah Wilton


On Mon, 10 Sep 2001, [EMAIL PROTECTED] wrote:

 One correction, shutdown immediate waits till all uncommitted
 transactions are committed or rolled back.  The client session must
 do one or the other, otherwise the shutdown hangs waiting for the
 end user.

No, that's shutdown transactional.

 Reply Separator
 Author: Walthour; Jon (GEAE; Compaq) [EMAIL PROTECTED]

 The message in the alert log means that there are uncommitted
 transactions.

Not necessarily, there are other (unnecessary, time-wasting) actions
that must be performed before a shutdowm immediate completes
successfully.  One of these is cleaning up sort segments.  Any
operation that is part of the immediate shutdown routine can hold up
the shutdown and cause this message to be produced, not just rollback.

 You could do a shutdown abort, but then you would have to have this
 rollback done during startup

Since version 7, rollback takes place after the database is open and
available to users.  This is not a problem.

 Oracle does not recommend shutdown aborts unless absolutely
 necessary

This is misguided advice.  In parts of the Oracle documentation, they
say to avoid aborts, but in the FailSafe documentation, they mention
that abort is the preferable and default shutdown mode for high
availability.  I agree.

  and one shouldn't rely on a cold backup taken on an aborted
 db. Either way, though, the rollback must occur.

Shutdown abort/startup restrict/shutdown immediate should be a
reasonable way to get the desired state of the database for a cold
backup.

 One thing you could do is check v$transaction before you shutdown. The
 used_ublk column may give you some idea of how much rollback has to be done.

Good advice, if the problem is transaction rollback.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

 -Original Message-

 I have Oracle 8.1.7 running on windoze NT 4.0.  Every night I have a script
 that kicks off a cold backup.  Part of the script issues the command

 SHUTDOWN IMMEDIATE

 which normally works just fine before I actually copy my files.  However,
 periodically the shutdown immediate command does not work.  It just hangs
 until someone complains that they cannot connect to the database or when I
 come in early in the morning and notice it hanging. In my SIDAlrt.log I
 get the following

 SHUTDOWN: waiting for active calls to complete

 This also shows up in a trace file file multiple times.  I have to issue a
 shutdown abort to stop the database.

 In doing some research on metalink I see that otheres also have this
 problem.  The responses from Oracle are somewhat vague.  I do see that one
 of the responses seems to indicate that if the intelligent agent is running
 that it could be the cause for the hanging.  Has anyone else had this
 problem and solved it by shutting down the intelligent agent service??  Any
 other things that I can do to remedy this.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: What's wrong with this query

2001-09-10 Thread Koivu, Lisa

Title: RE: What's wrong with this query





Your hint is wrong. You have to tell it what index to use. example /*+ index (table_alias index_name) */
Remember hints, if they are wrong, will just be ignored. 


Your execution plan seems OK. It's returning an awful lot of rows ...


Lisa Koivu
Oracle Doggie Administrator
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From: Anne Yu [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject: What's wrong with this query


Hey list, Can anyone tell me what's wrong with this query?


many thanks,



select /*+ INDEX(b)*/ distinct d.batch_number
 , d.document_number
 , d.entry_user_id
 , d.document_type_id
 , d.document_processed_date
 , b.batch_media_id, d.return_Method_Id
from submitter_batch b , document d
 , ucc_master_amendment m
where d.batch_number = b.batch_number
 and d.document_number = m.document_number
 and d.imaged = 0
 and b.batch_media_id = 4
 and d.document_status_id = 4





 Submitter_batch - 97853 rows
 Document - 8043272 rows (fk_d_batchnumber index on
batch_number)
 Ucc_master_adment - 0 rows (pk_uma_dn index on document_number)






Here is the explain plan:


explain plan expected rows object name 
 


select statement 164662478 
 sort (unique) 164662478
 nested loops 164662478
 nested loops 2008079
 table access(full) 46193 submitted
batch
 table access(by idx) 2008079 document
 index(range scan) 2008079
fk_d_batchnumber non-unique
 index(unique scan) 82
pk_uma_dn unique




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
 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: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.


The restriction is on unique indexes.

  1* select column_name from dba_ind_COLUMNS where INDEX_NAME = 'WOLO_PK'
SQL /

COLUMN_NAME

PERSON_ID
INSTITUTION_CODE

ALTER INDEX CASEPUPPY.WOLO_PK
REBUILD COMPRESS 2 TABLESPACE PEPII_INDEX
/

REBUILD COMPRESS 2 TABLESPACE PEPII_INDEX
*
ERROR at line 2:
ORA-25194: invalid COMPRESS prefix length value

 ALTER INDEX CASEPUPPY.WOLO_PK
 REBUILD COMPRESS 1 TABLESPACE PEPII_INDEX
/

Index altered.

This was done on an 8.1.6.3 database.  As far as what's done in practice, I would 
hazard accepting the Oracle defaults for
prefix length values is the most common.  The documentation states: 

For unique indexes, the valid range of prefix length values is from 1 to the number 
of key columns minus 1. The default prefix length is the number
  of key columns minus 1. 

  For nonunique indexes, the valid range of prefix length 
values is from 1 to the number of key columns. The default prefix length is the number 
of
  key columns.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, September 10, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L


Actually you can create compressed indexes upto the size of the columns.
In other words, the last column in a concentated index can be compressed.
Although most practice does not.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


You cannot compress single column unique indexes.  The rule is: you can
compress up to n-1 columns of a unique index where n = the number of columns
in the index.  A multi-column compressed index should, for maximum effect,
have as its leading column the one with greatest  number of repeated values.
This is in conflict with the rule that states to put the column with the
highest cardinality  first.  

Bear in mind compressing an index is not cost free.  The CPU will need to do
more work to read the index; however the cost of the work will be less than
doing a physical I/O.

You can compress all columns of a non-unique index.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  

-Original Message-
Sent: Monday, September 10, 2001 5:50 AM
To: Multiple recipients of list ORACLE-L



Ian,

I'll look at compressing the index.   Does that only work on unique indexes
or can you
do it on non-unique multi-column indexes as well?

Thanks,

Cherie


 

MacGregor,

Ian A.  To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]  
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full index
scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om

 

 

09/07/01 03:26

PM

Please respond

to ORACLE-L

 

 





The advantage of the fast full index scan is that it should read fewer
blocks than the full table scan.  Index compression may help reduce the
number of blocks read even further.   A unique index mist be at least two
columns wide to benefit from compression.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, September 07, 2001 5:20 AM
To: Multiple recipients of list ORACLE-L



Ian,

The last one I looked at it was cached, I guess.   I could purposely cache
the
table (and index) if it was small, though.

I'm confused though.   Isn't the whole benefit of the fast, full index scan
that you
don't have to go against the table, thereby avoiding those physical reads?

Or, in the case where the index isn't cached, is the benefit that you don't
have to read all of the columns in the table that aren't part of the index?

Thanks for your reply,

Cherie



MacGregor,

Ian A.  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:

ford.EDUSubject: RE: Do fast full
index scans do physical disk reads?
Sent by:

[EMAIL PROTECTED]

om



09/07/01 01:05

AM

Please respond

to

RE: db engines VS flat files


Biting your tongue is no fun, I just say what I think.
Which happens to be a whole lot of nothing.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L



Since we're not in a meeting, I don't have to bite my tongue.

'Context sensitive indexing' comes to mind.

Jared



 

agc

acad@accefyn.   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
org.co  cc:

Sent by: Subject: Re: db engines VS flat
files  
[EMAIL PROTECTED]

om

 

 

09/10/01 09:10

AM

Please respond

to ORACLE-L

 

 





well so start to bite your tonge :-)  because yes there are some very large
collections of datas stored as flat text files, so do bite it and do it very
hard because this large amounts of datas may almost doble the size every
year... and most of them are being searched and manipulated with perl
scripts. I do not know if has been that way because of not knowign search
engines, do not think that is the case, that I do not know but my question
remains. ok, for only seraching patterns with in this falt files wich
would be the difference between having a real search engine and just having
perl scripts for searching patterns with in this flat text files? until now
all I can say is that most of administrative tasks are quite dificult to do
under perl and shell scripts, and c progrmas, but for the rest and even
knowing that all this works under cgis, it works fine well... so do not
laught so hard may loose your tonge :-)

On Mon, 10 Sep 2001, Jared Still wrote:

 Date: Mon, 10 Sep 2001 06:40:19 -0800
 From: Jared Still [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: db engines VS flat files


 In addition to Greg's comments I would like to add
 that anyone suggesting flat files for 50 gig of data
 is probably not at all familiar with database technology.

 Perl is an excellent language for manipulating data, but
 it is not a database engine.  50 gigs of data is totally unmanagable 
 as flat files.

 Personally, were someone to suggest that to me I would have to bite my 
 tongue to contain the laughter.

 At the very least, something like MySQL should be used.

 For a look at what is available in the way or database interfaces for 
 Perl, have a look at:

 http://search.cpan.org/Catalog/Database_Interfaces/

 Jared


 On Sunday 09 September 2001 12:40, agc wrote:
  I would like to know your opinion about the developments under for 
  example perl for handling large amounts of datas (sets of flats 
  files larger than 50 gigs) vs the option of using oracle for exmaple 
  for
doing
  the same task, wich would be more eficinet? why? cheers
 
  The information contained in this communication is confidential, is 
  intended only for the use of the recipient named above, and may be 
  legally privileged. If the reader of this message is not the 
  intended recipient, you are hereby notified that any dissemination, 
  distribution or copying of this communication is strictly 
  prohibited. If you have received this communication in error, please
  re-send this communication to the sender and delete the
  original message or any copy of it from your computer
  system.
  Please do not re-send by any reazon in any way or form any of the
  informatino here contained.
 --
 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).


The information contained in this communication is confidential, is intended
only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient, you
are hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please re-send this communication to the sender and
delete the original message

RE: db engines VS flat files

2001-09-10 Thread agc

jey man take it easy... just a joke.. nothing serious... 

On Mon, 10 Sep 2001, Christopher Spence wrote:

 Date: Mon, 10 Sep 2001 11:40:41 -0800
 From: Christopher Spence [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: db engines VS flat files

 Biting your tongue is no fun, I just say what I think.
 Which happens to be a whole lot of nothing.

 Do not criticize someone until you walked a mile in their shoes, that way
 when you criticize them, you are a mile a way and have their shoes.

 Christopher R. Spence 
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275

 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863

 -Original Message-
 Sent: Monday, September 10, 2001 3:00 PM
 To: Multiple recipients of list ORACLE-L

 Since we're not in a meeting, I don't have to bite my tongue.

 'Context sensitive indexing' comes to mind.

 Jared

 agc

 acad@accefyn.   To: Multiple recipients of list
 ORACLE-L [EMAIL PROTECTED]
 org.co  cc:

 Sent by: Subject: Re: db engines VS flat
 files  
 [EMAIL PROTECTED]

 om

 09/10/01 09:10

 AM

 Please respond

 to ORACLE-L

 well so start to bite your tonge :-)  because yes there are some very large
 collections of datas stored as flat text files, so do bite it and do it very
 hard because this large amounts of datas may almost doble the size every
 year... and most of them are being searched and manipulated with perl
 scripts. I do not know if has been that way because of not knowign search
 engines, do not think that is the case, that I do not know but my question
 remains. ok, for only seraching patterns with in this falt files wich
 would be the difference between having a real search engine and just having
 perl scripts for searching patterns with in this flat text files? until now
 all I can say is that most of administrative tasks are quite dificult to do
 under perl and shell scripts, and c progrmas, but for the rest and even
 knowing that all this works under cgis, it works fine well... so do not
 laught so hard may loose your tonge :-)

 On Mon, 10 Sep 2001, Jared Still wrote:

  Date: Mon, 10 Sep 2001 06:40:19 -0800
  From: Jared Still [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: Re: db engines VS flat files

  In addition to Greg's comments I would like to add
  that anyone suggesting flat files for 50 gig of data
  is probably not at all familiar with database technology.

  Perl is an excellent language for manipulating data, but
  it is not a database engine.  50 gigs of data is totally unmanagable 
  as flat files.

  Personally, were someone to suggest that to me I would have to bite my 
  tongue to contain the laughter.

  At the very least, something like MySQL should be used.

  For a look at what is available in the way or database interfaces for 
  Perl, have a look at:

  http://search.cpan.org/Catalog/Database_Interfaces/

  Jared

  On Sunday 09 September 2001 12:40, agc wrote:
   I would like to know your opinion about the developments under for 
   example perl for handling large amounts of datas (sets of flats 
   files larger than 50 gigs) vs the option of using oracle for exmaple 
   for
 doing
   the same task, wich would be more eficinet? why? cheers

   The information contained in this communication is confidential, is 
   intended only for the use of the recipient named above, and may be 
   legally privileged. If the reader of this message is not the 
   intended recipient, you are hereby notified that any dissemination, 
   distribution or copying of this communication is strictly 
   prohibited. If you have received this communication in error, please
   re-send this communication to the sender and delete the
   original message or any copy of it from your computer
   system.
   Please do not re-send by any reazon in any way or form any of the
   informatino here contained.
  --
  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).

 The information contained

RE: Interesting News..

2001-09-10 Thread Eric D. Pierce


No. 

I'm more interested in what happens to the customer.

[via ORACLE-L Digest -- Volume 2001, Number 251]

 --
 
  From: Walthour, Jon (GEAE, Compaq) [EMAIL PROTECTED]
  Date: Fri, 7 Sep 2001 06:50:52 -0400 
  Subject: RE: Interesting News..
 
 Eric:
 
 While I can appreciate that your opinion of the Compaq Services division
 might be less than positive, would you please, for the sake of those who
 actually work for these companies, be a little less dramatic in your
 expression of that opinion.
 

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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).

Concepts Manual

2001-09-10 Thread Boivin, Patrice J


Am I blind, or did Oracle omit the Concepts Manual from
http://docs.oracle.com?

I am going to do a search in Technet.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Acting Head
Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  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: Hardware requirements when migration oracle from NT to Linux

2001-09-10 Thread Eric D. Pierce


one of these might work: 

 http://www.stanford.edu/dept/news/report/news/gifs%20archive/smserver.jpg
-
or: http://www.compulab.co.il/486core.htm


[via ORACLE-L Digest -- Volume 2001, Number 251]

 
 --
 
  From: Schoen Volker [EMAIL PROTECTED]
  Date: Fri, 7 Sep 2001 10:42:15 +0200 
  Subject: Hardware requirements when migration oracle from NT to Linux

 I want to migrate our developer databases from NT 4.0 (Oracle 8.1.5) to
 Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do I need
 for the linux machine to hit the same performance than on NT machine.

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: db engines VS flat files


I know it was, but I was serious :)

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, September 10, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


jey man take it easy... just a joke.. nothing serious... 

On Mon, 10 Sep 2001, Christopher Spence wrote:

 Date: Mon, 10 Sep 2001 11:40:41 -0800
 From: Christopher Spence [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: db engines VS flat files
 
 Biting your tongue is no fun, I just say what I think.
 Which happens to be a whole lot of nothing.
 
 Do not criticize someone until you walked a mile in their shoes, that 
 way when you criticize them, you are a mile a way and have their 
 shoes.
 
 Christopher R. Spence
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275
 
 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863
  
 
 
 
 -Original Message-
 Sent: Monday, September 10, 2001 3:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Since we're not in a meeting, I don't have to bite my tongue.
 
 'Context sensitive indexing' comes to mind.
 
 Jared
 
 
 
  
 
 agc
 
 acad@accefyn.   To: Multiple recipients of
list
 ORACLE-L [EMAIL PROTECTED]
 org.co  cc:
 
 Sent by: Subject: Re: db engines VS
flat
 files  
 [EMAIL PROTECTED]
 
 om
 
  
 
  
 
 09/10/01 09:10
 
 AM
 
 Please respond
 
 to ORACLE-L
 
  
 
  
 
 
 
 
 
 well so start to bite your tonge :-)  because yes there are some very 
 large collections of datas stored as flat text files, so do bite it 
 and do it very hard because this large amounts of datas may almost 
 doble the size every year... and most of them are being searched and 
 manipulated with perl scripts. I do not know if has been that way 
 because of not knowign search engines, do not think that is the case, 
 that I do not know but my question remains. ok, for only seraching 
 patterns with in this falt files wich would be the difference between 
 having a real search engine and just having perl scripts for searching 
 patterns with in this flat text files? until now all I can say is that 
 most of administrative tasks are quite dificult to do under perl and 
 shell scripts, and c progrmas, but for the rest and even knowing that 
 all this works under cgis, it works fine well... so do not laught so 
 hard may loose your tonge :-)
 
 On Mon, 10 Sep 2001, Jared Still wrote:
 
  Date: Mon, 10 Sep 2001 06:40:19 -0800
  From: Jared Still [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: Re: db engines VS flat files
 
 
  In addition to Greg's comments I would like to add
  that anyone suggesting flat files for 50 gig of data
  is probably not at all familiar with database technology.
 
  Perl is an excellent language for manipulating data, but
  it is not a database engine.  50 gigs of data is totally unmanagable
  as flat files.
 
  Personally, were someone to suggest that to me I would have to bite 
  my
  tongue to contain the laughter.
 
  At the very least, something like MySQL should be used.
 
  For a look at what is available in the way or database interfaces 
  for
  Perl, have a look at:
 
  http://search.cpan.org/Catalog/Database_Interfaces/
 
  Jared
 
 
  On Sunday 09 September 2001 12:40, agc wrote:
   I would like to know your opinion about the developments under for
   example perl for handling large amounts of datas (sets of flats 
   files larger than 50 gigs) vs the option of using oracle for exmaple 
   for
 doing
   the same task, wich would be more eficinet? why? cheers
  
   The information contained in this communication is confidential, 
   is
   intended only for the use of the recipient named above, and may be 
   legally privileged. If the reader of this message is not the 
   intended recipient, you are hereby notified that any dissemination, 
   distribution or copying of this communication is strictly 
   prohibited. If you have received this communication in error, please
   re-send this communication to the sender and delete the
   original message or any copy of it from your computer
   system.
   Please do not re-send by any reazon in any way or form any of the
   informatino here contained.
  --
  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

RE: Do fast full index scans do physical disk reads?