date:20030129

I have a high procedure (many INSERT's and UPDATE´s).
This procedure generate insert's in UNDO TableSpace for rollback.
I want to know if exists any way for don´t generate insert´s in UNDO
Tablespace.

Oracle 9i / NT

Thanks.
-- 
Breno A. K. Magnago   mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares


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

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

RE: strange behaviour of sequence

2003-01-29 Thread Stephane Faroult

Guys,

one of my developers is using sequence to
auto-increment the value 
of a column while inserting.

he has created a sequence like this.

SQL  create sequence testseq start with 1;

and then uses a INSERT statement as below in a JSP.


insert into testtab values
('BREAD'||testseq.nextval);

after some inserts .when he does SELECT from
TESTTAB...he 
finds
the values as :

BREAD1
BREAD2
BREAD3
BREAD4
BREAD21
BREAD22

it should increment by 1.but it is not so ?

any hint/clue 

Regards,
Jp.


A gap lower than 20 points to unused cached values (default cache = 20). Can be a 
database rebounce, or (possibly, I have not checked) some ALTER SYSTEM FLUSH 
SHARED_POOL. Of course, rollbacks also introduce gaps, whatever the number of cached 
values.

Regards,

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

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

RE: undo tablespace

2003-01-29 Thread Hately, Mike (NESL-IT)

Breno,
There's no way to do this because it's the central pillar of Oracle's read
consistency mechanism.
It's possible to minimise or suppress redo but undo is out of your control.

regards,
Mike Hately

-Original Message-
Sent: 29 January 2003 11:39
To: Multiple recipients of list ORACLE-L


I have a high procedure (many INSERT's and UPDATE´s).
This procedure generate insert's in UNDO TableSpace for rollback.
I want to know if exists any way for don´t generate insert´s in UNDO
Tablespace.

Oracle 9i / NT

Thanks.
-- 
Breno A. K. Magnago   mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares


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

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



**
 
The information contained in this e-mail is confidential and 
intended only for the use of the addressee. If the reader of 
this message is not the addressee, you are hereby notified 
that you have received this e-mail in error and you must not 
copy, disseminate, distribute, use or take any action as a 
result of the information contained in it.

If you have received this e-mail in error, please notify
[EMAIL PROTECTED] (UK 01384 275454) and delete it 
immediately from your system.

**


**
 
The information contained in this e-mail is confidential and 
intended only for the use of the addressee. If the reader of 
this message is not the addressee, you are hereby notified 
that you have received this e-mail in error and you must not 
copy, disseminate, distribute, use or take any action as a 
result of the information contained in it.

If you have received this e-mail in error, please notify 
[EMAIL PROTECTED] (UK 01384 275454) and delete it 
immediately from your system.

Neither Npower nor any of the other companies in the 
Innogy group from whom this e-mail originates accept any 
responsibility for losses or damage as a result of any viruses 
and it is your responsibility to check attachments (if any) for 
viruses.
Npower Limited
Registered office: Windmill Hill Business Park, Whitehill 
Way, Swindon SN5 6PB. Registered in England and Wales: 
number 3653277
This e-mail may be sent on behalf of a member of the Innogy 
group of companies.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

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

Return the first row only

2003-01-29 Thread Krishnaswamy, Ranganath

Hi List,

I have the below query which returns 13 records.  In this I want to display
only the 1st row.  Is it possible to do this through rownum or any other
function or pseudo column?  If so, please let me know the same.  Any help in
this regard is very much appreciated.

select 'shipment' table_name,ce.display_name,st.timestamp, sequence 
from shipment_timestamp st, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and st.event_id = xm.event_id
union
select 'container' table_name,ce.display_name,sct.timestamp, sequence  
from shipment_container_timestamp sct, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and sct.event_id = xm.event_id
union
select 'order' table_name,ce.display_name,ot.timestamp, sequence  
from order_timestamp ot, shipment_order so,customer_event ce, xm_field xm 
where so.shipment_id = 10402344721477 
and so.order_id = 2
and ot.shipment_order_id = so.shipment_order_id  
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and ot.event_id = xm.event_id order by sequence desc 

Thanks and Regards,

Ranganath
WARNING: The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee.  Access to this message
by anyone else is unauthorised.  If you are not the intended recipient, any
disclosure, copying, or distribution of the message, or any action or
omission taken by you in reliance on it, is prohibited and may be unlawful.
Please immediately contact the sender if you have received this message in
error. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishnaswamy, Ranganath
  INET: [EMAIL PROTECTED]

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

RE: Take Care of your DBAs

2003-01-29 Thread Boivin, Patrice J

Title: "Take Care of your DBAs"



Here's 
that "development DBA" alias again.

sigh.

Pat.

  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 
  29, 2003 7:54 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: "Take Care of your DBAs"
  Thanks for this article. I will forward to 
  damagement.
  
  Dave
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 28, 2003 
3:24 PMTo: Multiple recipients of list 
ORACLE-LSubject: "Take Care of your DBAs"
http://careerlink.devx.com/articles/hc0199/hc0199.asp 

Interesting article I stumbled 
across. Best quote: "Stay Out of your DBA's 
Face"! WELL PUT! 
Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 
Coconut Creek Parkway Ft. Lauderdale, 
FL, USA 33063

Best backup software for daily backups...

2003-01-29 Thread Peter R


Hi Friends,

We are going to upgrade our database(Oracle9i) with Unix server(AIX5.2), I 
would like to know best backup software for new production server with 
250-350Gb database size. Ours is 24X7 shop, so we are going to take daily 
hotbackups. Any ideas and experiance from gurus!!!

Thanks
peter.




_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

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

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

Re: strange behaviour of sequence

2003-01-29 Thread Daniel Wisser

hi j.p.!

try with

SQL  create sequence testseq start with 1 NOCACHE ORDER;

regards
daniel


oraora oraora wrote:
 
 Guys,
 
 one of my developers is using sequence to auto-increment the value
 of a column while inserting.
 
 he has created a sequence like this.
 
 SQL  create sequence testseq start with 1;
 
 and then uses a INSERT statement as below in a JSP.
 
 insert into testtab values ('BREAD'||testseq.nextval);
 
 after some inserts .when he does SELECT from TESTTAB...he
 finds
 the values as :
 
 BREAD1
 BREAD2
 BREAD3
 BREAD4
 BREAD21
 BREAD22
 
 it should increment by 1.but it is not so ?
 
 any hint/clue 
 
 Regards,
 Jp.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

RE: Peoplesoft Oracle

2003-01-29 Thread Dawtrey, Lindsay L

Title: Peoplesoft & Oracle



HI 
Lisa 
Don't 
worry too much about fixing up the database it will only benefit the 
application.
You 
can spread the tablespaces around, I have also found that the default install 
scripts shove all the indexes into one tablespace, you can go ahead and add more 
and spread the indexes across disks if you are getting contention on 
them.
You 
can also change the tablespaces to LMTs no problem and you can us autoextend as 
you see fit, it won't affect PeopleSoft (unless you switch it off and the 
datafiles fill up of course).
You 
can alsochange SYSADM's default/sort tablespace.
Redo 
logs can be multiplexed and moved to seperate disks.
In 
short you can employ most of the good Oracle DBA standardswithout hurting 
Peoplesoft, it is quite flexible, some issues to be aware of are when changing 
default storage parameters for tables and indexes such as tablespace and initial 
and next extents etc, these changes also need to be made within Peoplesoft, the 
app will function just fine if you don't, but the next time a change (ddl) is 
made to that table from within PeopleSoft, it will revert back to the old 
settings when the table is re-created. Peoplesoft alters tables structures such 
ascolumn changes, adds etc by creating and populating a 'temporary' table, 
dropping the original and then renaming the temporary one.I 
alwayscheck the generated alter script before running it anyway just to be 
sure that all is OK.
As far 
as the users accounts are concerned,they are there for two tier 
connections via sqlnet and apply to PeopleSoft versions prior to version 8, 
theapp connects via the userid, gets some info from ps.psdbowner, 
psoprdefn and pslock, it then disconnects and re-connects as the schema 
ownerusually SYSADM if default install values were 
used.
Ifthe user connects via an application server, the userid in Oracle 
is not used as the appserver is already connected and does it's own password 
checking etc BUT the user still needs to exist in Oraclein the event of a 
password change being done, PeopleSoft issues an'alter user' 
toOracle which will choke if the user does not exist.
From 
PeopleSoft 8 all users excetp developers connect via a webserver/app server and 
the Oracle accounts are no longer needed, with the exception of developers, they 
still connect via a generic user, usually called 'people' which then re-connects 
as sysadm.
If the 
app was upgraded from 7 to 8 the users will not automatically have been deleted, 
also true is that when a user is removed from PeopleSoft prior to V8 the Oracle 
user is also not dropped, some cleaning up needs to be done 
here.
I have 
worked with PeopleSoft and Oracle for 8 years now, if you have any other 
problems feel free to contact my direct on [EMAIL PROTECTED]

Hope 
this helps.
Lindsay


  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 28, 2003 
  11:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Peoplesoft  Oracle
  Hello everyone, 
  My apologies for bombarding the list with more 
  questions than answers as of late. This one is pretty desparate. 
  
  For those of you who support Peoplesoft databases - 
  Are there any websites that you frequent to check for quirks, weird anomalies, 
  etc. related to your specific Peoplesoft/Oracle combination? 
  I've just inherited this environment. It's 
  Oracle 8.1.7 on AIX. I don't know the version of AIX and I don't know 
  the version(s) of the Peoplesoft modules being used. However I am seeing 
  some very weird things - not the least of which is every tablespace is 
  dictionary managed, all are on autoextend, there are 600 open database 
  accounts but it looks like the app only connects as SYSADM, all users have 
  SYSTEM for default/temp ts, the entire freaking database is on one disk, all 
  redologs (one in each group) are on one disk, etc., etc., etc. The list 
  goes on. I'm afraid to turn this environment upside down and fix it 
  because management is only interested in keeping the system alive, not 
  improving it. The previous DBA is elusive at best, probably because I 
  yelled at him last year after catching him creating objects on the fly in my 
  databases :)
  I'll do the obvious things like add redologs and 
  check backup and recovery, etc. User error is extraordinarily high in 
  this environment. Everything else I am afraid to touch without doing my 
  homework first. Any websites, suggestions, comments, etc. would be 
  greatly appreciated. 
  The only good thing to come of all this is I'M 
  BAACK in Unix again !!! Woo Hoo!!! 
  Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA 33063 


__
Disclaimer and 
confidentiality note  
 
Everything in this e-mail and any attachments 
relating to the official business of Standard Bank Group Limited is proprietary 
to the

RE: Windows 2000 Cluster on oracle

2003-01-29 Thread Rajesh Dayal

Yes you can go for Active-Active cluster configuration of RAC or else Active-Passive 
configuration of Oracle Fail Safe on Windows Cluster. Both of these are available on 
Windows 2000 cluster.
Let me know, if you want more info.

HTH,
Rajesh

-Original Message-
Sent: Tuesday, January 28, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L

Hi
I wanted to migrate my database from SUN solaris to WINDOWS 2000
platform.Curetly I am having sun cluster as failover with shared disk.
I wanted to setup similar kind of setup with windows 2000.
Is any failover option available in Windows2000?
Let me know if anyone does such kind of setup earlier ?
Thx
-Seema





_
The new MSN 8: smart spam protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail

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

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

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

migration from Sybase to Oracle

2003-01-29 Thread Vijaya Chander V.S

Hi Everyone,

We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models 
defer a lot. 
Is there any tool available for this kind of migration. Can we do this migration with 
out any  tool. 
If yes please let me know like how should we go about this migration.
If there are any websites/ checklist on effort estimation till implementation please 
share with me.
Thanks in advance.

Regards,
Vijay
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vijaya Chander V.S
  INET: [EMAIL PROTECTED]

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

Re: Re: more consistent gets, but more quickly?

2003-01-29 Thread Jonathan Lewis


When Oracle 'expects' to visit a buffer more than
once in a single call, it will hold the cache buffers
chains latch long enough to create a pin (in this
case a memory structure that associates the
session with the buffer) and link it into the linked
list of current users (x$bh.usprev, usnxt) of the
buffer.  On subsequent accesses to the block,
Oracle need not grab the latch and search the
bucket, instead it can jump to the block by
way of the pin which will definitely be there as
a pinned block may not be flushed from the buffer.

Visits which take this short-cut are recorded under
the 'buffer is pinned count' statistic.  So it is a
logical I/O, but using a shorter, often cheaper,
access path.

Typically it will be index leaf blocks that
show most pinning, as they tend to be
revisited during range scans.

In your case, I assumed that the rebuilt table
would result in there being more usable row entries
per leaf block than there had been, so more jumps
back and forth from index to table each time a leaf
was pinned - hence more pins, fewer gets.




Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 29 January 2003 06:42


Jonathan Lewis,
Can you interpret more about this statistics?How does this affect the
sql running time? And how did you think about this statistics that is
seldom used?
The following is the test result:

--sql1:
   00:00:01.58 00:00:01.59
NAME VALUE   VALUE
--- --   -
CPU used by this session   160 161
CPU used when call started 160 161
buffer is not pinned count   41612   41604
buffer is pinned count 1685183 1685183
consistent gets  43911   43907
no work - consistent read gets   43893   43889
session logical reads43914   43910


Elapsed:
--sql2: 00:00:01.69 00:00:01.71
NAME  VALUE   VALUE
 --  --
CPU used by this session170 171
CPU used when call started  170 171
buffer is not pinned count19889   19889
buffer is pinned count  1706898 1706898
consistent gets   22192   22192
no work - consistent read gets22174   22174
session logical reads 22195   22195



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

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

RE: Return the first row only

2003-01-29 Thread Foelz.Frank

Select * from 
(
select 'shipment' table_name,ce.display_name,st.timestamp, sequence 
from shipment_timestamp st, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
nd st.event_id = xm.event_id
union
select 'container' table_name,ce.display_name,sct.timestamp, sequence  
from shipment_container_timestamp sct, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and sct.event_id = xm.event_id
nion
select 'order' table_name,ce.display_name,ot.timestamp, sequence  
from order_timestamp ot, shipment_order so,customer_event ce, 
xm_field xm 
where so.shipment_id = 10402344721477 
and so.order_id = 2
and ot.shipment_order_id = so.shipment_order_id  
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and ot.event_id = xm.event_id order by sequence desc 
) 
where rownum  2

don't expect it to be fast ;-)

 Frank   


Von: Krishnaswamy, Ranganath
[mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 29. Januar 2003 13:29
An: Multiple recipients of list ORACLE-L
Betreff: Return the first row only

Hi List,

I have the below query which returns 13 records.  In this I 
want to display
only the 1st row.  Is it possible to do this through rownum or 
any other
function or pseudo column?  If so, please let me know the 
same.  Any help in
this regard is very much appreciated.

select 'shipment' table_name,ce.display_name,st.timestamp, sequence 
from shipment_timestamp st, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 

.

from shipment_container_timestamp sct, customer_event ce, xm_field xm 
and ot.shipment_order_id = so.shipment_order_id  
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and ot.event_id = xm.event_id order by sequence desc 

Thanks and Regards,

Ranganath

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

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

Re: Best backup software for daily backups...

2003-01-29 Thread Ruth Gramolini




We are doing the same upgrade, and we will continue to use 
rman for all backups. 
Ruth

  - Original Message - 
  From: 
  Peter R 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 29, 2003 7:39 
  AM
  Subject: Best backup software for daily 
  backups...
  Hi Friends,We are going to upgrade our 
  database(Oracle9i) with Unix server(AIX5.2), I would like to know best 
  backup software for new production server with 250-350Gb database size. 
  Ours is 24X7 shop, so we are going to take daily hotbackups. Any ideas and 
  experiance from 
  gurus!!!Thankspeter._Add 
  photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail-- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Peter 
  R INET: [EMAIL PROTECTED]Fat City 
  Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and inthe message BODY, include a line containing: 
  UNSUB ORACLE-L(or the name of mailing list you want to be removed 
  from). You mayalso send the HELP command for other information (like 
  subscribing).

RE: Return the first row only - Solved

2003-01-29 Thread Krishnaswamy, Ranganath

Hi List,

I found the answer to my query myself and here goes the solution:

select x.* from (select 'shipment' table_name,ce.display_name,st.timestamp,
sequence 
from shipment_timestamp st, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and st.event_id = xm.event_id
union
select 'container' table_name,ce.display_name,sct.timestamp, sequence  
from shipment_container_timestamp sct, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and sct.event_id = xm.event_id
union
select 'order' table_name,ce.display_name,ot.timestamp, sequence  
from order_timestamp ot, shipment_order so,customer_event ce, xm_field xm 
where so.shipment_id = 10402344721477 
and so.order_id = 2
and ot.shipment_order_id = so.shipment_order_id  
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and ot.event_id = xm.event_id 
) x where x.sequence = ( select max(sequence) from 
(select 'shipment' table_name,ce.display_name,st.timestamp, sequence 
from shipment_timestamp st, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and st.event_id = xm.event_id
union
select 'container' table_name,ce.display_name,sct.timestamp, sequence  
from shipment_container_timestamp sct, customer_event ce, xm_field xm 
where shipment_id = 10402344721477 
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and sct.event_id = xm.event_id
union
select 'order' table_name,ce.display_name,ot.timestamp, sequence  
from order_timestamp ot, shipment_order so,customer_event ce, xm_field xm 
where so.shipment_id = 10402344721477 
and so.order_id = 2
and ot.shipment_order_id = so.shipment_order_id  
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
and ot.event_id = xm.event_id))

My apologies for posting such a long query to the forum.

Thanks and Regards,

Ranganath


 -Original Message-
 From: Krishnaswamy, Ranganath 
 Sent: Wednesday, January 29, 2003 5:59 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Return the first row only
 
 Hi List,
 
 I have the below query which returns 13 records.  In this I want to
 display
 only the 1st row.  Is it possible to do this through rownum or any other
 function or pseudo column?  If so, please let me know the same.  Any help
 in
 this regard is very much appreciated.
 
 select 'shipment' table_name,ce.display_name,st.timestamp, sequence 
 from shipment_timestamp st, customer_event ce, xm_field xm 
 where shipment_id = 10402344721477 
 and ce.CUSTOMER_MOT_ID = 1040130035205
 and xm.field_id = ce.field_id
 and st.event_id = xm.event_id
 union
 select 'container' table_name,ce.display_name,sct.timestamp, sequence  
 from shipment_container_timestamp sct, customer_event ce, xm_field xm 
 where shipment_id = 10402344721477 
 and ce.CUSTOMER_MOT_ID = 1040130035205
 and xm.field_id = ce.field_id
 and sct.event_id = xm.event_id
 union
 select 'order' table_name,ce.display_name,ot.timestamp, sequence  
 from order_timestamp ot, shipment_order so,customer_event ce, xm_field xm 
 where so.shipment_id = 10402344721477 
 and so.order_id = 2
 and ot.shipment_order_id = so.shipment_order_id  
 and ce.CUSTOMER_MOT_ID = 1040130035205
 and xm.field_id = ce.field_id
 and ot.event_id = xm.event_id order by sequence desc 
 
 Thanks and Regards,
 
 Ranganath
 WARNING: The information in this message is confidential and may be
 legally
 privileged. It is intended solely for the addressee.  Access to this
 message
 by anyone else is unauthorised.  If you are not the intended recipient,
 any
 disclosure, copying, or distribution of the message, or any action or
 omission taken by you in reliance on it, is prohibited and may be
 unlawful.
 Please immediately contact the sender if you have received this message in
 error. Thank you.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Krishnaswamy, Ranganath
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
WARNING: The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee.  Access to this message
by anyone else is unauthorised.  If you are not the intended recipient, any
disclosure, copying, or distribution of the message, or any action or
omission taken by you in

RE: tuning forms/reports application

Title: RE: tuning forms/reports application





Connor,


Forms is dumb ... I mean it doesn't think it is important to use dbms_application info, you have to do it manually. The statistics parameter ... gosh .. never got it to work right against 7x, 8x and 9x ... 

For my developers, I tell them use use,


* FRD (Forms Runtime Diagnostics) if they want to know which built-in is blowing up the form ...
 FRD also has different options and you can also use trace diagnostics with forms.
* PL/SQL Profiler (to see where they spend lot of time writing redundant code)
* dbms_support.start_trace for SQL performance problems.


So, there are different techniques for different problems.


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!



-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 6:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: tuning forms/reports application



there is a stats=yes (or similar) parameter which
creates a trace file for a form execution which can
then be used to check sql performance (the most common
cause of 'slow' forms).


i haven't checked, but forms by default might pop some
things into module/action columns which you could see
in v$session and v$sql. if forms is not doing it by
default, then its a very good practice to start doing
this yourself (see: dbms_application_info)


hth
connor



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

Re: Follow-up: It's NOT possible to set role in db's logon

2003-01-29 Thread Louis BROUILLETTE

Hi Roy,

I don't know if you solved your problem yet but I have a similar situation 
here.  I have an Oracle account used by PHP programs (third party programs) 
to access some tables.  I don't want anyone to log in to the database with 
this account unless the connection comes from apache and from our web 
server machine.  So what I did is that I created a logon trigger on that 
schema and if the conditions are not met, then I raise an application error 
and the connection dies.

As you know, these informations (program, machine, etc...) can be found in 
v$session and the SID of the current session can be found with select sid 
from v$mystat where rownum = 1.

HTH.

Louis

At 15:13 2003-01-27 -0800, you wrote:
In case anyone cares--it looks like it is *not* possible to set a role in an
after logon trigger.  Had I only looked at metalink:

AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=106140.1

Bummer, that.

Thanks again to all who responded.

Cheers,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Monday, January 13, 2003 7:42 AM
To: 'ORACLE-L'


Greetings all,

I'm trying to support a COTS application that is back-end agnostic  makes
only minimal use of security on the db.  In particular, it requires that
users be granted a default role that has *very* heavy permissions--enough to
do some major mischief should they ever figure out how to use odbc or
sql*plus.

My collegues  I have devised a kludgy method for getting around this
problem, involving a shill startup program that turns the default-ness of
the role on  off in conjunction with users opening  closing the client
program.  This works, but is a pain to maintain.

I've recently discovered the v$session.program field  am now wondering
whether it would be possible to use the new-fangled logon system trigger to
set the role only for cases where v$session.program = the COTS client.

Can anybody comment as to whether this is a viable approach on an 8.1.6
database  if not, on a 9i db?

In particular, there are two things I don't know--first, how to select just
the one row in v$session that corresponds to the current connection.  If a
user was to start up the COTS client  then connect to the same db via
sql*plus, I would want the role set *only* for the COTS client session.  My
best thought so far here is to use the most recently started connection
based on v$session.logon_time.

Second, whether the SET ROLE statement is legal in a logon trigger.

All help will be most welcome.

Thanks!

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

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


Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: [EMAIL PROTECTED]

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

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

Re[2]: undo tablespace

Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?

When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of
REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

-- 
Breno A. K. Magnagomailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI Breno,
HMNI There's no way to do this because it's the central pillar of Oracle's read
HMNI consistency mechanism.
HMNI It's possible to minimise or suppress redo but undo is out of your control.

HMNI regards,
HMNI Mike Hately

HMNI -Original Message-
HMNI Sent: 29 January 2003 11:39
HMNI To: Multiple recipients of list ORACLE-L


HMNI I have a high procedure (many INSERT's and UPDATE´s).
HMNI This procedure generate insert's in UNDO TableSpace for rollback.
HMNI I want to know if exists any way for don´t generate insert´s in UNDO
HMNI Tablespace.

HMNI Oracle 9i / NT

HMNI Thanks.


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

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

RE: Perl

Title: RE: Perl





Okay ... a question from a colleague ...


How do you get python to work with Oracle ... for perl there DBD: and DBI: anything similar in Python? My knowledge of Perl is as good as my knowledge of Python ... /dev/null

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!



-Original Message-
From: Glenn Stauffer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 5:17 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Perl



I tinkered with Perl, but could never really get used to the syntax. 
I basically gave up (still maintain familiarity since Perl is very
common) and started using Python. I've grown to enjoy coding in Python
and use it now for all of the system maintenance and monitoring scripts
I write as well as for my web programming work.


I'm not qualified to compare the two languages, but I will say that
Perl's Oracle support is better developed and the CPAN archives are a
very useful thing. In my opinion, Python is a better designed language
and it is perfectly viable for production-level applications in an
Oracle environment.



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

Re[2]: Peoplesoft Oracle

2003-01-29 Thread dgoulet

David  Lisa,

1st point is that were still on PeopleTools 7.53 so this may be somewhat
dated.  Anyway, go to Peopletools, utilities, use Peopletools options.  Uncheck
the Grant Access option  low  behold, PeopleTools will not try to create a
user via the grant connect to  syntax that is so out dated as to be atrocious.
 The down side is that you now have to create the user manually, but we did put
together a trigger/dbms_job system that does it automatically as we wanted.  Now
why in tarnation would one want to do that, Well as it turns out if you use that
syntax, as Lisa noted, everyone is assigned SYSTEM as their default and temp
tablespace.  Well that's not so bad since their there only for a very brief
period of time before changing over to SYSADMIN or whatever else you happen to
use.  The problem is that PeopleSoft in their VAST wisdom coded the first 2
select statements with a group by in them, just incase there was a duplication
of data in ps.psdbowner and/or psoprdefn.  Now I do not want to bad mouth them
because that was not a bad idea.  The bad point is that you end up with temp
segments in system and a fragmented system tablespace.  YUCK!!  OH for 9i and a
system wide default temp tablespace!!  

OH, also one item of extreme note.  DON'T setup password aging for your users. 
PeopleTools doesn't appreciate it at all.

BTW: I would not say that PeopleSoft does not know databases, they just minored
in them instead.  The real problem is that they code to the least common
denominator in the dbms market, namely SqlServer.  So be prepared for lots of
fun, and do watch Customer Connection.  They every once in a while come out with
a note or patch that is Oracle specific and really does help.  One would think
that there'd be more of them since something like 75% of PeopleSoft's installs
are on Oracle. Of course their development is on Sql Server.  Go figure!!

Dick Goulet

Reply Separator
Author: david davis [EMAIL PROTECTED]
Date:   1/28/2003 8:13 PM

There is a resolution 19368 on customer connection which discusses which 
rights the SYSADM account requires and which ones can be revoked. Though it 
was somewhat better formatted when I retrieved it in 1999. It was last 
modified in 2002.

I am curious how you turn off the create user? I didn't think you could do 
that, only control the grants that take place.

A little gotcha I ran into a couple of years ago when I revoked access was 
that had errors in app designer. The DLL referenced DBA_TABLES (oops) I 
think that was in V7.0.

David Davis



From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Peoplesoft  Oracle
Date: Tue, 28 Jan 2003 14:39:21 -0800

Lisa,
   Sounds like a default install of PeopleSoft. Step 1 that you can do is
re-assign everyone to use a real temp tablespace. Step 2 is break up that 
db
onto seperate spindles. Step 3 is to turn off autoextend exept for those
tablespaces that are nearing say 90% full, then set autoextend to something
sensible. As far as the user accounts are concerned that's normal. I for 
one
would revoke DBA from sysadmin  grant alter any user instead. 
Afterwards, I'd
get into PeopleTools  turn off the creat user function.  I could write 
more,
but this should keep you VERY busy.

Dick Goulet

Koivu; Lisa [EMAIL PROTECTED] wrote on 1/28/03 1:08 pm:

Hello everyone,

My apologies for bombarding the list with more questions than answers as of
late.  This one is pretty desparate.

For those of you who support Peoplesoft databases - Are there any websites 
that
you frequent to check for quirks, weird anomalies, etc. related to your 
specific
Peoplesoft/Oracle combination?

I've just inherited this environment.  It's Oracle 8.1.7 on AIX.  I don't 
know
the version of AIX and I don't know the version(s) of the Peoplesoft 
modules
being used.  However I am seeing some very weird things - not the least of 
which
is every tablespace is dictionary managed, all are on autoextend, there are 
600
open database accounts but it looks like the app only connects as SYSADM, 
all
users have SYSTEM for default/temp ts, the entire freaking database is on 
one
disk, all redologs (one in each group) are on one disk, etc., etc., etc.  
The
list goes on.  I'm afraid to turn this environment upside down and fix it
because management is only interested in keeping the system alive, not 
improving
it.  The previous DBA is elusive at best, probably because I yelled at him 
last
year after catching him creating objects on the fly in my databases :)

I'll do the obvious things like add redologs and check backup and recovery, 
etc.
  User error is extraordinarily high in this environment.  Everything else 
I am
afraid to touch without doing my homework first.  Any websites, 
suggestions,
comments, etc. would be greatly appreciated.

The only good thing to come of all this is I'M BAACK in Unix 
again
!!! Woo

toad question

2003-01-29 Thread Jeffrey Beckstrom




What privileges are needed for a "toad" user to view another users 
packages.

Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

RE: Peoplesoft Oracle

Title: RE: Peoplesoft  Oracle





David, David, David.


THANK YOU, THANK YOU, THANK YOU for your detailed response. Wish I could buy you a beer... a virtual beer will have to do :)

Have a great day
Lisa


-Original Message-
From: david davis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Peoplesoft  Oracle



Lisa,


What you have described is a PeopleSoft database with bad habits. The usage 
of dictionary managed tablespaces is normal but will probably change over 
time. While the PeopleSoft installation guide and delivered scripts create 
using the older method, you can certainly using the locally managed 
approach.


There is a document red paper on PeopleSoft customer connection titled 
PeopleSoft 8 Batch Performance on Oracle Database that is probably worth 
downloading. Path to the documents is products|peopletools|peopletools 
resource library.


Alas, documentation from the vendor is weak. Or as I have discovered 
postively brilliant in comparison to other vendors who say nothing 
configure Oracle the same as SQL Server {doh}.


Can't really comment on the autoextend. Use it myself to delay going through 
change mgmt process. :-) PeopleSoft does deliver a script to autoextend but 
it is not the default. So that was a deliberate choice of the DBA.


It is normal for all application users to connect via the schema owner. The 
users Oracle account is used during the logon process for cross 
authentication with application security and the database. This changes to 
certain degree in PeopleTools 8 family.


I believe at some point in PeopleSoft 8, you will have the possibilty of 
losing the individuals Oracle userid and connection is via the app server 
(tuxedo) and connection id.


The user when accessing PeopleSoft is only connected to Oracle using their 
userid for an extremely brief time so it is really what is set for the 
SYSADM account that is key. I have as standard practice set the the default 
tablespace and temp tablespace after userids are created. Just being tidy 
besides shows up on my monitoring reports.


The entire database on one disk. That isn't the vendor's fault. They state 
before installing the database to modify the scripts to specify the 
filesystem locations. One disk or a hundred, that is the DBA's 
responsibility.


You can certainly move tablespaces, redo logs around as needed. On the other 
hand there are things you should be careful with (eg.).


Don't just change the password for SYSADM except via the PeopleSoft security 
administration (unless you wanted to be hunted down by users).


Also applies to user accounts.


Moving tables to other tablespaces should first be done via the application 
designer tool first which updates the meta-data (peopletools tables).


Objects that maintain PeopleTools meta-data should be first created in App 
Designer and then built using the generated SQL script.


I would suggest reading the Administration guide which covers things such as 
the DDL Model, security administration etc. Also, the installation guide has 
some stuff for tuning (snicker).


A couple of reports available for the application DDDAUDIT  SYSAUDIT.


Our environment is very stable.


PeopleSoft HRMS 7.51, PeopleTools 7.58
HP/UX 10.20, Oracle 7.3.4


{Hoping to upgrade to 9i and HP/UX 11i this year}


All batch processing is via Control-M scheduler and not the vendor delivered 
program launcher aka process scheduler. All access via external processes 
connect using their own userid (O/S authenticated for batch) with explicit 
grants. Nobody (clients/developers/support staff) has direct access to 
SYSADM except for the DBA's.


Our reporting environment is a hybrid of 3.22, 7.0, 7.51 custom structures 
based on PeopleTools 7.58. The environment is populated via SQL Server DTS 
(el cheapo ETL)and database links. We have previously used Oracle 
Replication (lots of problems on Oracle 7 (maybe it was the 600 snapshots)) 
but now use custom triggers etc.


If you can dream of it, you can do it. Its just the administration can be a 
bit of work until you understand it and have things setup in a fashion that 
makes sense for you.


References:


David Kurtz posted a document PeopleSoft for the Oracle DBA on customer 
connection. Check out his site www.go-faster.co.uk. He may have a more 
current document (mine is 1999, but then I am used to out of date software).


sites:


www.slerp.com
peoplesoft.ittoolbox.com


I have looked at them but don't generally rely on them. I do believe there 
is a Peoplesoft list that might be worth joining.


Ensure you have access to customer connection. You might as well be tortured 
like the rest of us trying to find things.


David Davis, DBA
Manulife Financial
[EMAIL PROTECTED]


From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Peoplesoft  Oracle
Date: Tue, 28 Jan 2003

RE: Perl

2003-01-29 Thread Hately, Mike (NESL-IT)

Hi,
the issue of database access from python is addressed here :
http://www.python.org/topics/database/
http://www.python.org/topics/database/ 
 
with specific modules (incliuding Oracle) listed here :
http://www.python.org/topics/database/modules.html
http://www.python.org/topics/database/modules.html 
 
I've only used ODBC from python unfortunately so I'm not well placed to
offer a recommendation.
 
Regards,
Mike Hately
 
 

-Original Message-
Sent: 29 January 2003 14:04
To: Multiple recipients of list ORACLE-L



Okay ... a question from a colleague ... 

How do you get python to work with Oracle ... for perl there DBD: and DBI:
anything similar in Python?  My knowledge of Perl is as good as my knowledge
of Python ... /dev/null

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! 


-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Tuesday, January 28, 2003 5:17 PM 
To: Multiple recipients of list ORACLE-L 


I tinkered with Perl, but could never really get used to the syntax.  
I basically gave up (still maintain familiarity since Perl is very 
common) and started using Python.  I've grown to enjoy coding in Python 
and use it now for all of the system maintenance and monitoring scripts 
I write as well as for my web programming work. 

I'm not qualified to compare the two languages, but I will say that 
Perl's Oracle support is better developed and the CPAN archives are a 
very useful thing.  In my opinion, Python is a better designed language 
and it is perfectly viable for production-level applications in an 
Oracle environment. 



**

The information contained in this e-mail is confidential and 
intended only for the use of the addressee. If the reader of 
this message is not the addressee, you are hereby notified 
that you have received this e-mail in error and you must not 
copy, disseminate, distribute, use or take any action as a 
result of the information contained in it.

If you have received this e-mail in error, please notify
[EMAIL PROTECTED] (UK 01384 275454) and delete it 
immediately from your system.

**




**
 
The information contained in this e-mail is confidential and 
intended only for the use of the addressee. If the reader of 
this message is not the addressee, you are hereby notified 
that you have received this e-mail in error and you must not 
copy, disseminate, distribute, use or take any action as a 
result of the information contained in it.

If you have received this e-mail in error, please notify 
[EMAIL PROTECTED] (UK 01384 275454) and delete it 
immediately from your system.

Neither Npower nor any of the other companies in the 
Innogy group from whom this e-mail originates accept any 
responsibility for losses or damage as a result of any viruses 
and it is your responsibility to check attachments (if any) for 
viruses.
Npower Limited
Registered office: Windmill Hill Business Park, Whitehill 
Way, Swindon SN5 6PB. Registered in England and Wales: 
number 3653277
This e-mail may be sent on behalf of a member of the Innogy 
group of companies.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

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

RE: Global Stats

Title: RE: Global Stats





Hi Jared, 


Actually I think monitoring won't work in my case. Data loads fire throughout the day and the docs say that in 8i, analyze can fire based upon table monitoring sometime within 3 hours after data changes. I would rather include a manual fire of analyze in my data load and avoid any locking issues or contention for resources. 

In addition, if temp space is blown during auto-analyze (fired based upon monitoring), would I know about it? 


Just my thoughts. Am I wrong?


Lisa


-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 3:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Global Stats




You may want to read up on table monitoring.


Jared


On Tuesday 28 January 2003 11:10, Koivu, Lisa wrote:
 Hi everyone,

 Back to the lovely world of Oracle :) I've been reading up on statistics.
 Out of the 8.1.7 doco:
 /*
 Partitioned schema objects may contain multiple sets of statistics. They
 can have statistics which refer to the entire schema object as a whole
 (global statistics), they can have statistics which refer to an individual
 partition, and they can have statistics which refer to an individual
 subpartition of a composite partitioned object.

 Unless the query predicate narrows the query to a single partition, the
 optimizer uses the global statistics. Because most queries are not likely
 to be this restrictive, it is most important to have accurate global
 statistics. Intuitively, it may seem that generating global statistics from
 partition-level statistics should be straightforward; however, this is only
 true for some of the statistics. For example, it is very difficult to
 figure out the number of distinct values for a column from the number of
 distinct values found in each partition because of the possible overlap in
 values. Therefore, actually gathering global statistics with the DBMS_STATS
 package is highly recommended, rather than calculating them with the
 ANALYZE statement

 */
 The table I need to generate stats for is currently 32GB and grows by ~2GB
 per week. Even the smallest estimate with calculating global stats will
 take a long long time and I may not be able to spring for all the required
 temp space.

 How does the list feel about global stats? Does anyone agree with the
 documentation that they most important? I'm thinking my partitioned
 statistics are the most important.

 Any input is appreciated. Thanks

 Lisa Koivu
 Oracle Database Administrator
 Fairfield Resorts, Inc.
 5259 Coconut Creek Parkway
 Ft. Lauderdale, FL, USA 33063



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.net
-- 
Author: Jared Still
 INET: [EMAIL PROTECTED]


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

Re: problem install oracle 9.2.0 on redhat 7.3

2003-01-29 Thread Markus Reger

hi\
just in case you are still looking for a solution: 
the entry for the INSO_LINK seem sto be alright. If the retry doesn't succeed, then 
try to link the file manually
cd $ORACLE_HOME/ctx/lib/
/usr/bin/make -f ins_ctx.mk install

if this doesn't work then check the error log. I never had any problem with the retry 
button, except once. This was when I invoked the link explicitly in the way mentioned 
above.


Besides that: I *NEVER* used any additional patch issued either by RedHat nor by 
ORACLE. That means, I took the installed OS as it is.(for O9i rel1 or rel 2, 
differently for O8i)



good luck.



Apologies for any typos overlooked

kr mr
 [EMAIL PROTECTED] 01/29/03 06:44 AM 
hi all,
I need your help, when i install oracle 9.2.0 on redhat 7.3 i got a error
message like :
Error in invoking target install of makefile
/opt/oracle/product/9.2.0/ctx/lib/ins_ctx.mk
but i was fix use the tutorial from
:http://www.puschitz.com/OracleOnLinux.shtml
but is not help my problem.
when i edit $ORACLE_HOME/ctx/lib/env_ctx.mk in INSO_LINK=INSO_LINK
= -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca
$(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut
$(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX)
$(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS) the word is
bold is added manually after that i return to message box and i click retry
but has no effect.

how can i fix the problem???

Thank You

Regards,

Pomin





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

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


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

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

RE: Peoplesoft Oracle

Title: RE: Peoplesoft  Oracle





John, Henry, Lindsay, David, 


Thanks for your responses. At least I don't feel like I'm completely out in the cold here. 


John: My boy is huge, teething, not sleeping much, standing and taking his first steps, had his first bloody nose already. Sleep? What is THAT :)

-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Peoplesoft  Oracle



Lisa,

Afraid I can't help with PSoft (all the best, you have already seen some of
the best of the worst :), but the following link may help you when getting
used to AIX.

http://bhami.com/rosetta.html http://bhami.com/rosetta.html 

So how's Jr. doing? (PS: I think Dick Goulet has experience with PS)
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002


I don't know what the future holds for me, but I do know who holds my
future!


** The opinions and statements above are entirely my own and not those of my
employer or clients **



-Original Message-
Sent: Tuesday, January 28, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L




Hello everyone, 


My apologies for bombarding the list with more questions than answers as of
late. This one is pretty desparate. 


For those of you who support Peoplesoft databases - Are there any websites
that you frequent to check for quirks, weird anomalies, etc. related to your
specific Peoplesoft/Oracle combination? 


I've just inherited this environment. It's Oracle 8.1.7 on AIX. I don't
know the version of AIX and I don't know the version(s) of the Peoplesoft
modules being used. However I am seeing some very weird things - not the
least of which is every tablespace is dictionary managed, all are on
autoextend, there are 600 open database accounts but it looks like the app
only connects as SYSADM, all users have SYSTEM for default/temp ts, the
entire freaking database is on one disk, all redologs (one in each group)
are on one disk, etc., etc., etc. The list goes on. I'm afraid to turn
this environment upside down and fix it because management is only
interested in keeping the system alive, not improving it. The previous DBA
is elusive at best, probably because I yelled at him last year after
catching him creating objects on the fly in my databases :)


I'll do the obvious things like add redologs and check backup and recovery,
etc. User error is extraordinarily high in this environment. Everything
else I am afraid to touch without doing my homework first. Any websites,
suggestions, comments, etc. would be greatly appreciated. 


The only good thing to come of all this is I'M BAACK in Unix
again !!! Woo Hoo!!! 


Lisa Koivu 
Oracle Database Administrator 
Fairfield Resorts, Inc. 
5259 Coconut Creek Parkway 
Ft. Lauderdale, FL, USA 33063 



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


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

Re: Re[2]: Peoplesoft Oracle

2003-01-29 Thread david davis

Dick,

The grant users option has been around since release 2 (was on installation 
table back then). I had not tested turning it off. Our practice is create 
the userid then change the default tablespaces then notify clients of new 
userid. It works for us, because the DBA's happen to be the security 
administrators.

If you are creating the Oracle side of the user account, how are you doing 
password synchronisation?

PeopleSoft 8 has password aging done within the application, but to use pure 
database password aging prior to PeopleSoft 8 you can use Braintree's 
SQLSecure product. The peopleSoft software has DLL/database integration with 
the product if you have it installed. It also does cross database password 
synchronisation.

I thought the lowest common denominator was DB2 guess its been lowered. The 
do Windows development on SQLServer, but Unix is done on UDB. I wonder if 
PeopleSoft will move away from SQLServer as a source development platform 
now the Microsoft is trying to get into the CRM business. Direct 
competition.

David Davis

From: [EMAIL PROTECTED]
To: david davis [EMAIL PROTECTED],   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
Subject: Re[2]: Peoplesoft  Oracle
Date: Wed, 29 Jan 2003 09:44:23 -0500

David  Lisa,

1st point is that were still on PeopleTools 7.53 so this may be 
somewhat
dated.  Anyway, go to Peopletools, utilities, use Peopletools options.  
Uncheck
the Grant Access option  low  behold, PeopleTools will not try to 
create a
user via the grant connect to  syntax that is so out dated as to be 
atrocious.
 The down side is that you now have to create the user manually, but we 
did put
together a trigger/dbms_job system that does it automatically as we wanted. 
 Now
why in tarnation would one want to do that, Well as it turns out if you use 
that
syntax, as Lisa noted, everyone is assigned SYSTEM as their default and 
temp
tablespace.  Well that's not so bad since their there only for a very brief
period of time before changing over to SYSADMIN or whatever else you happen 
to
use.  The problem is that PeopleSoft in their VAST wisdom coded the first 2
select statements with a group by in them, just incase there was a 
duplication
of data in ps.psdbowner and/or psoprdefn.  Now I do not want to bad mouth 
them
because that was not a bad idea.  The bad point is that you end up with 
temp
segments in system and a fragmented system tablespace.  YUCK!!  OH for 9i 
and a
system wide default temp tablespace!!

OH, also one item of extreme note.  DON'T setup password aging for your 
users.
PeopleTools doesn't appreciate it at all.

BTW: I would not say that PeopleSoft does not know databases, they just 
minored
in them instead.  The real problem is that they code to the least common
denominator in the dbms market, namely SqlServer.  So be prepared for lots 
of
fun, and do watch Customer Connection.  They every once in a while come out 
with
a note or patch that is Oracle specific and really does help.  One would 
think
that there'd be more of them since something like 75% of PeopleSoft's 
installs
are on Oracle. Of course their development is on Sql Server.  Go figure!!

Dick Goulet

Reply Separator
Subject:Re: Peoplesoft  Oracle
Author: david davis [EMAIL PROTECTED]
Date:   1/28/2003 8:13 PM

There is a resolution 19368 on customer connection which discusses which
rights the SYSADM account requires and which ones can be revoked. Though it
was somewhat better formatted when I retrieved it in 1999. It was last
modified in 2002.

I am curious how you turn off the create user? I didn't think you could do
that, only control the grants that take place.

A little gotcha I ran into a couple of years ago when I revoked access was
that had errors in app designer. The DLL referenced DBA_TABLES (oops) I
think that was in V7.0.

David Davis



From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Peoplesoft  Oracle
Date: Tue, 28 Jan 2003 14:39:21 -0800

Lisa,
   Sounds like a default install of PeopleSoft. Step 1 that you can do is
re-assign everyone to use a real temp tablespace. Step 2 is break up that
db
onto seperate spindles. Step 3 is to turn off autoextend exept for those
tablespaces that are nearing say 90% full, then set autoextend to 
something
sensible. As far as the user accounts are concerned that's normal. I for
one
would revoke DBA from sysadmin  grant alter any user instead.
Afterwards, I'd
get into PeopleTools  turn off the creat user function.  I could write
more,
but this should keep you VERY busy.

Dick Goulet

Koivu; Lisa [EMAIL PROTECTED] wrote on 1/28/03 1:08 pm:

Hello everyone,

My apologies for bombarding the list with more questions than answers as 
of
late.  This one is pretty desparate.

For those of you who support Peoplesoft databases - Are there any 
websites
that
you frequent to check for quirks, weird anomalies, etc. related

Re: Re[2]: undo tablespace

2003-01-29 Thread Rachel Carmichael

think CAREFULLY about this as it invalidates your recovery procedures.
Nologging means there is nothing in the redo logs to be applied. and
your backup is invalid.

Other than that, I suggest you do some research in the Oracle docs. A
VERY brief check (search on nologging) brought me this information:

Direct-path INSERT is subject to a number of restrictions. If any of
these restrictions is violated, then Oracle executes conventional
INSERT serially without returning any message (unless otherwise noted):

* You can have multiple direct-path INSERT statements in a single
transaction, with or without other DML statements. However, after one
DML statement alters a particular table, partition, or index, no other
DML statement in the transaction can access that table, partition, or
index.
* Queries that access the same table, partition, or index are
allowed before the direct-path INSERT statement, but not after it.
* If any serial or parallel statement attempts to access a table
that has already been modified by a direct-path INSERT in the same
transaction, then Oracle returns an error and rejects the statement.
* The ROW_LOCKING initialization parameter cannot be set to INTENT.
* The target table cannot be index organized or clustered.
* The target table cannot contain object type or LOB columns.
* The target table cannot have any triggers or referential
integrity constraints defined on it.
* The target table cannot be replicated.
* A transaction containing a direct-path INSERT statement cannot be
or become distributed.


--- Breno A. K. Magnago [EMAIL PROTECTED] wrote:
 Mike,
 
 I asked it because I have a problem.
 Any insert data in UNDO tablespace generate insert in REDO Files. Is
 is correct ?
 
 When I execute a high procedure, many inserts in UNDO tablespace
 ocurres, so many inserts in REDO´s are genereate.
 I want to avoid this REDO´s generation.
 My tables and indexes are in NOLOGGING, but I high value of
 REDO are generate (100 MB each 20 minutes). It is desnecessary.
 
 Oracle 9i / NT
 
 -- 
 Breno A. K. Magnago   
 mailto:[EMAIL PROTECTED]
 Mercantil de Alimentos Soares
 
 Wednesday, January 29, 2003, 10:29:15 AM, you wrote:
 
 HMNI Breno,
 HMNI There's no way to do this because it's the central pillar of
 Oracle's read
 HMNI consistency mechanism.
 HMNI It's possible to minimise or suppress redo but undo is out of
 your control.
 
 HMNI regards,
 HMNI Mike Hately
 
 HMNI -Original Message-
 HMNI Sent: 29 January 2003 11:39
 HMNI To: Multiple recipients of list ORACLE-L
 
 
 HMNI I have a high procedure (many INSERT's and UPDATE´s).
 HMNI This procedure generate insert's in UNDO TableSpace for
 rollback.
 HMNI I want to know if exists any way for don´t generate insert´s in
 UNDO
 HMNI Tablespace.
 
 HMNI Oracle 9i / NT
 
 HMNI Thanks.
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Breno A. K. Magnago
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: Re[2]: undo tablespace

2003-01-29 Thread Fink, Dan

Breno,
100mb of redo in 20 minutes is not all that high. I have seen far
worse (as I am sure most on the list have as well). Why do you perceive this
as a problem? Are you seeing poor performance or waits? 
Is the generation of redo (and archived logs) causing the system to
halt due to the archive_dump_dest filling up? If so, the problem is not the
procedure, but rather the lack of proper process to manage your archive
logs.
Even with NOLOGGING, UNDO must be generated for read consistency,
rollback and recovery. You are not inserting data into the undo tablespace.
The undo entries are generated for each operation (insert/update/delete).
However, the undo entry for an insert is very small and thus will consume
very little undo space and redo.

Don't concern yourself with trying to stop the generation of UNDO.
You will end up causing yourself more problems that you will ever try to
solve. It is part of the Oracle kernel and not modifiable (at least in this
release). Focus on performance and decide if 100mb in 20 minutes is really a
problem.

Dan Fink

-Original Message-
Sent: Wednesday, January 29, 2003 7:10 AM
To: Multiple recipients of list ORACLE-L


Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?

When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of
REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

-- 
Breno A. K. Magnago
mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI Breno,
HMNI There's no way to do this because it's the central pillar of Oracle's
read
HMNI consistency mechanism.
HMNI It's possible to minimise or suppress redo but undo is out of your
control.

HMNI regards,
HMNI Mike Hately

HMNI -Original Message-
HMNI Sent: 29 January 2003 11:39
HMNI To: Multiple recipients of list ORACLE-L


HMNI I have a high procedure (many INSERT's and UPDATE´s).
HMNI This procedure generate insert's in UNDO TableSpace for rollback.
HMNI I want to know if exists any way for don´t generate insert´s in UNDO
HMNI Tablespace.

HMNI Oracle 9i / NT

HMNI Thanks.


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

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

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

RE: Perl

2003-01-29 Thread Glenn Stauffer

On Wed, 2003-01-29 at 09:04, Jamadagni, Rajendra wrote:
 Okay ... a question from a colleague ...
 
 How do you get python to work with Oracle ... for perl there DBD: and
 DBI: anything similar in Python?  My knowledge of Perl is as good as
 my knowledge of Python ... /dev/null
 

Python defines a database API specification (currently DB-API 2.0) and
module writers provide various database adapters which implement this
API.

You can find out more about this at:

http://www.python.org/topics/database/

There are currently two Oracle database adapters in common use:

DCOracle2 from the Zope Community: http://www.zope.org/Members/matt/dco2

cx_Oracle from Computronix: http://www.computronix.com/utilities.shtml

Since the DB-API defines the methods that a database adapter implements,
they both provide the same functionality at the basic
connect/query/retrieve results level.  There aren't any differences
between these two adapters that I've noticed in my work.

 -- 
 Glenn Stauffer
 Swarthmore College
 Swarthmore, PA

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

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

RE: Perl

2003-01-29 Thread Orr, Steve

Title: RE: Perl





There are two resources:
http://www.zope.org/Members/matt/dco2
http://www.computronix.com/utilities.shtml


The installs are not as nice as DBI but the products work. We've been using cx_Oracle in production for over a year now and have no complaints. Here's an Oracle connectivity test script:

-
#!/usr/bin/env python
# File: testPyOra.py
# Purpose: Test Python/Oracle connectivity.
# Usage: ./testPyOra.py
# Set the user connect info in myconstants.py
import myconstants as con
import cx_Oracle as db


def doConnect():
 theUser = con.defuser
 thePW = con.defpw
 theConnectString = con.defcs
 conn=db.connect(theUser,thePW,theConnectString)


 if conn != None :
 theText = Successfully connected to Oracle!
 else:
 theText = Unable to connect to the database.


 print theText
 return conn


def doQuery(myConn):
 if myConn != None :
 print Since we have a valid connection I'll do a query to prove it...
 print Here's a list of users on this database...
 SQLtext = Select username from dba_users
 cursor = myConn.cursor()
 cursor.execute(SQLtext)
 resultSet = cursor.fetchall()
 for un in resultSet:
 print %s %un
 else :
 print Since we're not connected I won't even bother doing a query.



def main():
 theConn = doConnect()
 doQuery(theConn)


if __name__=='__main__':main()




Steve


-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Perl



Okay ... a question from a colleague ... 
How do you get python to work with Oracle ... for perl there DBD: and DBI: anything similar in Python? My knowledge of Perl is as good as my knowledge of Python ... /dev/null

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! 



-Original Message- 
From: Glenn Stauffer [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 5:17 PM 
To: Multiple recipients of list ORACLE-L 
Subject: Re: Perl 



I tinkered with Perl, but could never really get used to the syntax. 
I basically gave up (still maintain familiarity since Perl is very 
common) and started using Python. I've grown to enjoy coding in Python 
and use it now for all of the system maintenance and monitoring scripts 
I write as well as for my web programming work. 
I'm not qualified to compare the two languages, but I will say that 
Perl's Oracle support is better developed and the CPAN archives are a 
very useful thing. In my opinion, Python is a better designed language 
and it is perfectly viable for production-level applications in an 
Oracle environment.

[Q] grant select on column level security failed?

2003-01-29 Thread dist cash


I tried to grant select on column level security and failed (on 8.1.7
and 9.2).  I heard some said column level security on work on insert
update and reference.  Is it true?  any other way to pass around?

 SQL grant select (update_date) on pay_update to user1;
grant select (update_date) on pay_update to user1
*
ERROR at line 1:
ORA-00969: missing ON keyword


SQL grant update (update_date) on pay_update to user1;

Grant succeeded.


Thanks.







_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

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

RE: Perl - Was Unix time conversion function

2003-01-29 Thread Jesse, Rich

Because I'm picky.  I ruled out OracleTool because it's web-based.  While it
may be an advantage at times (don't need to install on every machine I use),
it's a whole number of layers I don't want to troubleshoot when in Crisis
Mode.

OraC is pretty cool.  I looked at it when I got O'Reilly's Oracle and Open
Source.  It's nice, but not what I want/need.  All I want is a tool that
will allow the user, Me, to design and maintain system events and their
respective metrics and thresholds and notify the user when those thresholds
have been exceeded.  We already have a few tools that do this, but they all
have their drawbacks.  OEM's drawbacks are that is doesn't notify us half of
the time (and doesn't seem to have a mechanism to log notifications), and
that it's custom interface is TCL (another language I don't want to have to
learn to perform a single task).

I also liked the Jareds_tools module...  :D

Rich


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

p.s.  I could have sworn I sent this out yesterday (Tuesday), but as I'm in
the middle of a three-day PC rebuild (Winders bites!), I guess I'll take MS
Lookout's word for it that I didn't.

-Original Message-
Sent: Tuesday, January 28, 2003 11:36 AM
To: [EMAIL PROTECTED]
Cc: Jesse, Rich
Importance: High


 Also, on scant nights I've even been rolling my own KISS-method Perl/Tk 
OEM
 replacement.  Sorry Jared, but sometimes I like GUIs!  :)

Why?  Look up OraC and OracleTool on google.

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

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

RE: Follow-up: It's NOT possible to set role in db's logon

2003-01-29 Thread Pardee, Roy E

That's a great idea--many thanks.  I bet I could put up a table of permitted
username/client program combinations  just do a SELECT from it  translate
the no_data_found exception into a 'connect via your program verboten!'
message...

Thanks again,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, January 29, 2003 6:04 AM
To: Multiple recipients of list ORACLE-L


Hi Roy,

I don't know if you solved your problem yet but I have a similar situation 
here.  I have an Oracle account used by PHP programs (third party programs) 
to access some tables.  I don't want anyone to log in to the database with 
this account unless the connection comes from apache and from our web 
server machine.  So what I did is that I created a logon trigger on that 
schema and if the conditions are not met, then I raise an application error 
and the connection dies.

As you know, these informations (program, machine, etc...) can be found in 
v$session and the SID of the current session can be found with select sid 
from v$mystat where rownum = 1.

HTH.

Louis

At 15:13 2003-01-27 -0800, you wrote:
In case anyone cares--it looks like it is *not* possible to set a role in
an
after logon trigger.  Had I only looked at metalink:

AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles
Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
b
ase_id=NOTp_id=106140.1

Bummer, that.

Thanks again to all who responded.

Cheers,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Monday, January 13, 2003 7:42 AM
To: 'ORACLE-L'


Greetings all,

I'm trying to support a COTS application that is back-end agnostic  makes
only minimal use of security on the db.  In particular, it requires that
users be granted a default role that has *very* heavy permissions--enough
to
do some major mischief should they ever figure out how to use odbc or
sql*plus.

My collegues  I have devised a kludgy method for getting around this
problem, involving a shill startup program that turns the default-ness of
the role on  off in conjunction with users opening  closing the client
program.  This works, but is a pain to maintain.

I've recently discovered the v$session.program field  am now wondering
whether it would be possible to use the new-fangled logon system trigger to
set the role only for cases where v$session.program = the COTS client.

Can anybody comment as to whether this is a viable approach on an 8.1.6
database  if not, on a 9i db?

In particular, there are two things I don't know--first, how to select just
the one row in v$session that corresponds to the current connection.  If a
user was to start up the COTS client  then connect to the same db via
sql*plus, I would want the role set *only* for the COTS client session.  My
best thought so far here is to use the most recently started connection
based on v$session.logon_time.

Second, whether the SET ROLE statement is legal in a logon trigger.

All help will be most welcome.

Thanks!

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pardee, Roy E
   INET: [EMAIL PROTECTED]

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

Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: [EMAIL PROTECTED]

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

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

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

RE: Perl

2003-01-29 Thread Denham Eva

Title: RE: Perl

Good
question Raj! Hey Steve give us the run down on connecting to Oracle with
Python.
I've
downloaded the Activestate version to try!

Denham

-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29,
2003 4:04 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Perl
Okay ... a question from a colleague ...
How do you get python to work with Oracle ... for perl there
DBD: and DBI: anything similar in Python? My knowledge of Perl is as
good as my knowledge of Python ... /dev/null
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!
-Original Message- From: Glenn
Stauffer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 5:17 PM To: Multiple recipients of list ORACLE-L Subject: Re: Perl
I tinkered with Perl, but could never really get used to the
syntax. I basically gave up (still maintain
familiarity since Perl is very common) and started
using Python. I've grown to enjoy coding in Python and use it now for all of the system maintenance and monitoring
scripts I write as well as for my web programming
work.
I'm not qualified to compare the two languages, but I will say
that Perl's Oracle support is better developed and the
CPAN archives are a very useful thing. In my
opinion, Python is a better designed language and it
is perfectly viable for production-level applications in an Oracle environment.

DISCLAIMER

This message is for the named person's use
only. It may contain confidential, proprietary or legally privileged
information. No confidentiality or privilege is waived or lost by any
mistransmission. If you receive this message in error, please immediately delete
it and all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each reserve
the right to monitor and manage all e-mail communications through its
networks.
Any views expressed in this message are those
of the individual sender, except where the message states otherwise and the
sender is authorized to state them to be views of any such entity.

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal -
For more information please visit
www.marshalsoftware.com

Re: migration from Sybase to Oracle

2003-01-29 Thread Stephen Evans

vijay,

oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects data from sybase to oracle.

however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you could possibly use this product to at leastget your data into oracle then massage it into your new structures.

good luck,

steve

Vijaya Chander V.S [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/29/2003 07:49 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:migration from Sybase to Oracle

Hi Everyone,

We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models defer a lot.
Is there any tool available for this kind of migration. Can we do this migration with out any tool.
If yes please let me know like how should we go about this migration.
If there are any websites/ checklist on effort estimation till implementation please share with me.
Thanks in advance.

Regards,
Vijay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vijaya Chander V.S
INET: [EMAIL PROTECTED]

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

RE: toad question




Same as Oracle privs 
...

If you give execute, 
other user can see only package spec, if you grant 'create any procedure' they 
can see the package body/procedure/function body as 
well.

* to see 
procedure/function/package spec you need on of
 1. execute (if 
grant is made to public)
2. execute 
any procedure
 3. create any 
procedure

* to see package body 
you need "create any procedure"

For more details see 
ALL_SOURCE view definition ...
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!

  -Original Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 9:49 
  AMTo: Multiple recipients of list ORACLE-LSubject: toad 
  question
  What privileges are needed for a "toad" user to view another users 
  packages.
  
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
  781-4204
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Advice needed on PL/SQL code

2003-01-29 Thread Richard Ji

Robert,

Thanks for point that out.  Also, if there is index on the table,
redo will still be generated for index.

Richard

-Original Message-
Sent: Tuesday, January 28, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L


/*+ append */ alone does not prevent redo generation. Only with NOLOGGING in
the SQL
will redo generation be suppressed.

Cheers!

RF

-Original Message-
Sent: Tuesday, January 28, 2003 6:29 PM
To: Multiple recipients of list ORACLE-L


If it's a lot of rows and looks like you are archiving it to
a historical table, you could do:

insert /*+ append */ into target_table select * from source_table;

this will do a direct path insert, so it uses space above HWM.
It doesn't generate redo.

Richard

-Original Message-
Sent: Tuesday, January 28, 2003 6:09 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Please forgive this newbie question; I'm just getting started with PL/SQL.
I want to write a procedure to copy all rows from one table to another one
with an identical structure.  The table has many rows so I'm committing
every thousand records (error handling to be added later).  The table has
50+ columns and (if possible) I'd like to avoid listing them all in the
VALUES clause.  I'm not just being lazy - I hope to deploy this code to
several databases and the source table, while having the same name, may have
differences in the columns.  I want to do something like this:

DECLARE
   count_ NUMBER;
   CURSOR get_archive_records IS
  SELECT * FROM customer_order_table;
BEGIN
   count_ := 0;
   FOR rec_ IN get_archive_records LOOP
  INSERT INTO customer_order_archive
  VALUES (rec_.*); -- OBVIOUSLY, THIS DOES NOT WORK
  count_ := count_ + 1;
  IF MOD(count_,1000) = 0 THEN
 COMMIT;
  END IF;
   END LOOP;
   COMMIT;
END;

Is there a way to accomplish this?  Or is my whole approach all wrong?

Thanks in advance,
Beth

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

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

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

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

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

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

RE: Debate on rc commands Solaris and Oracle

2003-01-29 Thread Paula_Stankus

Title: RE: Debate on rc commands Solaris and Oracle





System Administrator says he doesn't trust that the rc commands will stop if the database doesn't want to shutdown and even if it does would want to shutdown with scripts beforehand so that a DBA could connect and resolve the issue. Other DBA says this is all wrong and rc commands should include shutdown immediate of database. In the past I had setup 2 processes in the system scripts for the sys admin - shutdown immediate - wait  shutdown abort - on a read-only DSS system which of course allows some room for this type of activity. I kind of would want to know if a database was going to be shutdown with an abort esp. in OLTP system and do it myself.



- any ideas

RE: Re[2]: undo tablespace

2003-01-29 Thread Hately, Mike (NESL-IT)

You're correct in saying that your undo blocks are protected by your redo
files. 
What type of operation are you performing on your table? I ask because only
a small subset of commands support the NOLOGGING feature; the remainder will
generate redo as usual. 

If you're not using a syntax that supports NOLOGGING maybe you could adapt
your job to adopt one.
Alternatively you may find that you just need to optimise your redo log
placement in order to handle the load.

Regards,
Mike Hately


-Original Message-
Sent: 29 January 2003 14:10
To: Multiple recipients of list ORACLE-L


Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?

When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of
REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

-- 
Breno A. K. Magnago
mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI Breno,
HMNI There's no way to do this because it's the central pillar of Oracle's
read
HMNI consistency mechanism.
HMNI It's possible to minimise or suppress redo but undo is out of your
control.

HMNI regards,
HMNI Mike Hately

HMNI -Original Message-
HMNI Sent: 29 January 2003 11:39
HMNI To: Multiple recipients of list ORACLE-L


HMNI I have a high procedure (many INSERT's and UPDATE´s).
HMNI This procedure generate insert's in UNDO TableSpace for rollback.
HMNI I want to know if exists any way for don´t generate insert´s in UNDO
HMNI Tablespace.

HMNI Oracle 9i / NT

HMNI Thanks.



**
 
The information contained in this e-mail is confidential and 
intended only for the use of the addressee. If the reader of 
this message is not the addressee, you are hereby notified 
that you have received this e-mail in error and you must not 
copy, disseminate, distribute, use or take any action as a 
result of the information contained in it.

If you have received this e-mail in error, please notify 
[EMAIL PROTECTED] (UK 01384 275454) and delete it 
immediately from your system.

Neither Npower nor any of the other companies in the 
Innogy group from whom this e-mail originates accept any 
responsibility for losses or damage as a result of any viruses 
and it is your responsibility to check attachments (if any) for 
viruses.
Npower Limited
Registered office: Windmill Hill Business Park, Whitehill 
Way, Swindon SN5 6PB. Registered in England and Wales: 
number 3653277
This e-mail may be sent on behalf of a member of the Innogy 
group of companies.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

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

Re: [Q] grant select on column level security failed?

2003-01-29 Thread Igor Neyman

Create a view (including only columns you want user1 to see) and let user1
use this view instead of table.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 10:24 AM



 I tried to grant select on column level security and failed (on 8.1.7
 and 9.2).  I heard some said column level security on work on insert
 update and reference.  Is it true?  any other way to pass around?

   SQL grant select (update_date) on pay_update to user1;
 grant select (update_date) on pay_update to user1
  *
 ERROR at line 1:
 ORA-00969: missing ON keyword


 SQL grant update (update_date) on pay_update to user1;

 Grant succeeded.


 Thanks.







 _
 The new MSN 8: smart spam protection and 2 months FREE*
 http://join.msn.com/?page=features/junkmail

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

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


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

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

RE: Problem on P4 intel servers

2003-01-29 Thread Jesse, Rich

I completely forgot all about this, but the install I just completed went
without a hitch.  I'm running Win2K SP3 (bleah) and installed 9.2.0.1.0
downloaded from OTN last night.

Is it possible that someone (perhaps in SP3) fixed this?

Rich


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

-Original Message-
Sent: Wednesday, January 29, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


symcjit.dll is Symantecs's Just-In-Time Compiler dll, it is basically a
faster option to javai.dll for java app executions.

Another work around, is to copy the files from the install disks to your
hard drive, then search these directories for any occurrence of
symcjit.dll, and replace them with the newer version of the dll, which you
can grab from:

http://www.cool-tools.co.uk/products/downloads/symcjit.dll

You can then either run the install from your HD, or burn the modified
install sets to CDRs, and run the install from those.

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance

-Original Message-
kristanto
Sent: 29 January 2003 08:44
To: Multiple recipients of list ORACLE-L


Naveen,
What is symcjit.dll, what happen if not renaming it ?

Rgrds,

Sony

 -Original Message-
 From: Naveen Nahata [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, January 29, 2003 2:09 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Problem on P4 intel servers

 The problem with Oracle Installation of P4 can be solved by renaming all
 the
 instances of 'symcjit.dll' in the installation software to
 'symcjitOLD.dll'
 or any other name.

 Regards
 Naveen

 -Original Message-
 Sent: Wednesday, January 29, 2003 11:59 AM
 To: Multiple recipients of list ORACLE-L


 Hi Gurus,
 Can anybody explain whats the problem with the Oracle/java installation on
 P4 machines

 Rgds,
 Vishal Vohra
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: toad question

2003-01-29 Thread emre . hancioglu


Only 'Execute' right should be enough.

Regards

M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-2576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]








Jeffrey Beckstrom [EMAIL PROTECTED]
gcrta.org
Sent by: [EMAIL PROTECTED]
29.01.2003 15:48
Please respond to ORACLE-L






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

cc:





Subject:
toad question 


What privileges are needed for a toad user to view another users packages.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

Re: Re[2]: undo tablespace

2003-01-29 Thread Stephen Evans

breno,

i believe the 'no logging' option only applies to data that is direct loaded into your tables

therefore, you may be able to bypass logging if you used sqlldr or 'create table as select'

good luck,

steve

Breno A. K. Magnago [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/29/2003 09:09 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re[2]: undo tablespace

Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?

When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of
REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI Breno,
HMNI There's no way to do this because it's the central pillar of Oracle's read
HMNI consistency mechanism.
HMNI It's possible to minimise or suppress redo but undo is out of your control.

HMNI regards,
HMNI Mike Hately

HMNI -Original Message-
HMNI Sent: 29 January 2003 11:39
HMNI To: Multiple recipients of list ORACLE-L

HMNI I have a high procedure (many INSERT's and UPDATE´s).
HMNI This procedure generate insert's in UNDO TableSpace for rollback.
HMNI I want to know if exists any way for don´t generate insert´s in UNDO
HMNI Tablespace.

HMNI Oracle 9i / NT

HMNI Thanks.

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

RE: Re[2]: undo tablespace

2003-01-29 Thread Cary Millsap

I agree in principal with Dan's thesis, but I'll add something.

Don't do things that generate unnecessary undo and redo, either.

One common example is SQL that updates a column to a value that it
already contains. For example, we see things like setting a flag='y'
without checking that the flag doesn't already have a 'y' value. Things
like this provide zero business value, but they degrade operational
performance and recovery operations, and they consume unnecessary space
in your undo and redo.

There are probably a million others...


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London


-Original Message-
Sent: Wednesday, January 29, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L

Breno,
100mb of redo in 20 minutes is not all that high. I have seen
far
worse (as I am sure most on the list have as well). Why do you perceive
this
as a problem? Are you seeing poor performance or waits? 
Is the generation of redo (and archived logs) causing the system
to
halt due to the archive_dump_dest filling up? If so, the problem is not
the
procedure, but rather the lack of proper process to manage your archive
logs.
Even with NOLOGGING, UNDO must be generated for read
consistency,
rollback and recovery. You are not inserting data into the undo
tablespace.
The undo entries are generated for each operation
(insert/update/delete).
However, the undo entry for an insert is very small and thus will
consume
very little undo space and redo.

Don't concern yourself with trying to stop the generation of
UNDO.
You will end up causing yourself more problems that you will ever try to
solve. It is part of the Oracle kernel and not modifiable (at least in
this
release). Focus on performance and decide if 100mb in 20 minutes is
really a
problem.

Dan Fink

-Original Message-
Sent: Wednesday, January 29, 2003 7:10 AM
To: Multiple recipients of list ORACLE-L


Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?

When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of
REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

-- 
Breno A. K. Magnago
mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI Breno,
HMNI There's no way to do this because it's the central pillar of
Oracle's
read
HMNI consistency mechanism.
HMNI It's possible to minimise or suppress redo but undo is out of your
control.

HMNI regards,
HMNI Mike Hately

HMNI -Original Message-
HMNI Sent: 29 January 2003 11:39
HMNI To: Multiple recipients of list ORACLE-L


HMNI I have a high procedure (many INSERT's and UPDATE´s).
HMNI This procedure generate insert's in UNDO TableSpace for rollback.
HMNI I want to know if exists any way for don´t generate insert´s in
UNDO
HMNI Tablespace.

HMNI Oracle 9i / NT

HMNI Thanks.


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

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

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

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

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

RE: Take Care of your DBAs

2003-01-29 Thread David Wagoner

Title: Take Care of your DBAs










I love
this article. I forwarded it to
damagement too because they havent been showing enough love for the DBAs
lately ;-).







Best regards,



David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency
Parkway, Suite 100

Cary, NC
27511-8582

Office (919)
466-6723

Mobile (919)
412-8462

Pager
[EMAIL PROTECTED]

Fax (919)
466-6783

AIM adswDWagoner

http://www.arsenaldigital.com/






*** NOTICE ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, 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 the sender by phone or email and delete this e-mail message from your
computer. Thank you.



-Original
Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003
4:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: Take Care of your
DBAs



http://careerlink.devx.com/articles/hc0199/hc0199.asp 

Interesting article I
stumbled across. Best quote: Stay Out of your DBA's
Face! WELL PUT! 

Lisa Koivu 
Oracle Database Administrator 
Fairfield Resorts, Inc. 
5259 Coconut Creek Parkway 
Ft. Lauderdale, FL, USA 33063

Re[4]: undo tablespace

Dan,

Is the generation of redo (and archived logs) causing the system to
halt due to the archive_dump_dest filling up? 
YES
I'll work to minimize this situation. Thanks.

-- 
Breno A. K. Magnagomailto:[EMAIL PROTECTED]

Wednesday, January 29, 2003, 1:19:50 PM, you wrote:

FD Breno,
FD 100mb of redo in 20 minutes is not all that high. I have seen far
FD worse (as I am sure most on the list have as well). Why do you perceive this
FD as a problem? Are you seeing poor performance or waits? 
FD Is the generation of redo (and archived logs) causing the system to
FD halt due to the archive_dump_dest filling up? If so, the problem is not the
FD procedure, but rather the lack of proper process to manage your archive
FD logs.
FD Even with NOLOGGING, UNDO must be generated for read consistency,
FD rollback and recovery. You are not inserting data into the undo tablespace.
FD The undo entries are generated for each operation (insert/update/delete).
FD However, the undo entry for an insert is very small and thus will consume
FD very little undo space and redo.

FD Don't concern yourself with trying to stop the generation of UNDO.
FD You will end up causing yourself more problems that you will ever try to
FD solve. It is part of the Oracle kernel and not modifiable (at least in this
FD release). Focus on performance and decide if 100mb in 20 minutes is really a
FD problem.

FD Dan Fink

FD -Original Message-
FD Sent: Wednesday, January 29, 2003 7:10 AM
FD To: Multiple recipients of list ORACLE-L


FD Mike,

FD I asked it because I have a problem.
FD Any insert data in UNDO tablespace generate insert in REDO Files. Is
FD is correct ?

FD When I execute a high procedure, many inserts in UNDO tablespace
FD ocurres, so many inserts in REDO´s are genereate.
FD I want to avoid this REDO´s generation.
FD My tables and indexes are in NOLOGGING, but I high value of
FD REDO are generate (100 MB each 20 minutes). It is desnecessary.

FD Oracle 9i / NT


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

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

Re: Upgrade 8.1.6 - 8.1.7 Patch 4

2003-01-29 Thread Peter Barnett

Upgrade 8.1.6 to 8.1.7 and then apply the patch.  Read
the docs carefully before applying the patch it is an
ugly puppy.  


--- [EMAIL PROTECTED] wrote:
 Im doing an upgrade from 8.1.6. to 8.1.7.4.
 Is there any benfit of doing the upgrade from 8.1.6
 to 8.1.7, using 
 ODMA then patching to 8.1.7.4
 or
 installing 8.1.7, patch it to 8.1.7.4, then ODMA the
 database from 
 8.1.6.
 
 any other comments on this upgrade path are welcomed
 
 thanks
 
 Sam 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

Re: Database Too Slow - Suggestions???

2003-01-29 Thread Rachna Vaidya

What is Buffer Cache Hit Ratio? LC Hit RAtio?
What's the hardware?
Run top or mpstat or sar to get the system stats...

We had seen somewhat somilar bstat estat data...

+Rachna

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 4:23 AM


 Hi Gurus,

 We have an OLTP 8i database on Win 2K RAM 1GB with about 10 million rows,
 Total size 100GB. Have done a bit of tuning here and there (see stats
below).
 What do you read of these stats?


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

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

RE: Problem on P4 intel servers

2003-01-29 Thread Lyndon Tiu

I believe the problem affects only 8i.

9i is ok.

-- 
Lyndon Tiu


Quoting Jesse, Rich [EMAIL PROTECTED]:

 I completely forgot all about this, but the install I just
 completed went
 without a hitch.  I'm running Win2K SP3 (bleah) and installed
 9.2.0.1.0
 downloaded from OTN last night.
 
 Is it possible that someone (perhaps in SP3) fixed this?
 
 Rich
 
 
 Rich Jesse  System/Database
 Administrator
 [EMAIL PROTECTED] Quad/Tech International,
 Sussex, WI
 USA
 
 -Original Message-
 Sent: Wednesday, January 29, 2003 4:44 AM
 To: Multiple recipients of list ORACLE-L
 
 
 symcjit.dll is Symantecs's Just-In-Time Compiler dll, it is
 basically a
 faster option to javai.dll for java app executions.
 
 Another work around, is to copy the files from the install disks to
 your
 hard drive, then search these directories for any occurrence of
 symcjit.dll, and replace them with the newer version of the dll,
 which you
 can grab from:
 
 http://www.cool-tools.co.uk/products/downloads/symcjit.dll
 
 You can then either run the install from your HD, or burn the
 modified
 install sets to CDRs, and run the install from those.
 
 HTH
 
 Mark
 
 ===
  Mark Leith | T: +44 (0)1905 330 281
  Sales  Marketing  | F: +44 (0)870 127 5283
  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
 ===
http://www.cool-tools.co.uk
Maximising throughput  performance
 
 -Original Message-
 kristanto
 Sent: 29 January 2003 08:44
 To: Multiple recipients of list ORACLE-L
 
 
 Naveen,
 What is symcjit.dll, what happen if not renaming it ?
 
 Rgrds,
 
 Sony
 
  -Original Message-
  From:   Naveen Nahata [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, January 29, 2003 2:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Problem on P4 intel servers
 
  The problem with Oracle Installation of P4 can be solved by
 renaming all
  the
  instances of 'symcjit.dll' in the installation software to
  'symcjitOLD.dll'
  or any other name.
 
  Regards
  Naveen
 
  -Original Message-
  Sent: Wednesday, January 29, 2003 11:59 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Hi Gurus,
  Can anybody explain whats the problem with the Oracle/java
 installation on
  P4 machines
 
  Rgds,
  Vishal Vohra
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
 services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You
 may
 also send the HELP command for other information (like
 subscribing).
 
 


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

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

RE: Problem on P4 intel servers

2003-01-29 Thread Donald Bricker

The problem was with lower versions of the database. The newer version
of symcjit.dll are included on the newer media. I am not sure what
version started to include the correct dll version. I am guessing 9i
release 1.



Don Bricker
Database Administrator / System Administrator
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290

 [EMAIL PROTECTED] 01/29/03 10:20AM 
I completely forgot all about this, but the install I just completed
went
without a hitch.  I'm running Win2K SP3 (bleah) and installed
9.2.0.1.0
downloaded from OTN last night.

Is it possible that someone (perhaps in SP3) fixed this?

Rich


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

-Original Message-
Sent: Wednesday, January 29, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


symcjit.dll is Symantecs's Just-In-Time Compiler dll, it is basically
a
faster option to javai.dll for java app executions.

Another work around, is to copy the files from the install disks to
your
hard drive, then search these directories for any occurrence of
symcjit.dll, and replace them with the newer version of the dll,
which you
can grab from:

http://www.cool-tools.co.uk/products/downloads/symcjit.dll 

You can then either run the install from your HD, or burn the modified
install sets to CDRs, and run the install from those.

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED] 
===
   http://www.cool-tools.co.uk 
   Maximising throughput  performance

-Original Message-
kristanto
Sent: 29 January 2003 08:44
To: Multiple recipients of list ORACLE-L


Naveen,
What is symcjit.dll, what happen if not renaming it ?

Rgrds,

Sony

 -Original Message-
 From: Naveen Nahata [SMTP:[EMAIL PROTECTED]] 
 Sent: Wednesday, January 29, 2003 2:09 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Problem on P4 intel servers

 The problem with Oracle Installation of P4 can be solved by renaming
all
 the
 instances of 'symcjit.dll' in the installation software to
 'symcjitOLD.dll'
 or any other name.

 Regards
 Naveen

 -Original Message-
 Sent: Wednesday, January 29, 2003 11:59 AM
 To: Multiple recipients of list ORACLE-L


 Hi Gurus,
 Can anybody explain whats the problem with the Oracle/java
installation on
 P4 machines

 Rgds,
 Vishal Vohra
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED] 

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

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

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

Export Oracle data to Excel

2003-01-29 Thread Jared . Still

Some of you will no doubt be interested in this:

http://www.knownow.com/cworld/dm/excel.html


Jared

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

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

RE: Re[2]: undo tablespace

2003-01-29 Thread Charlie_Mengler


AFAIK, in 8i+ tablespaces can be created with theNOLOGGING clause

LOGGING | NOLOGGING


Specify the default logging attributes of all tables, indexes, and
partitions within the tablespace. LOGGING is the default.


The tablespace-level logging attribute can be overridden by logging
specifications at the table, index, and partition levels.


Only the following operations support the NOLOGGING mode:
  DML: direct-load INSERT (serial or parallel), Direct Loader
  (SQL*Loader)
  DDL: CREATE TABLE ... AS SELECT, CREATE INDEX, ALTER INDEX ...
  REBUILD, ALTER INDEX ... REBUILD PARTITION, ALTER INDEX ... SPLIT
  PARTITION, ALTER TABLE ... SPLIT PARTITION, and ALTER TABLE ... MOVE
  PARTITION


In NOLOGGING mode, data is modified with minimal logging (to mark new
extents INVALID and to record dictionary changes). When applied during
media recovery, the extent invalidation records mark a range of blocks as
logically corrupt, because the redo data is not logged. Therefore, if you
cannot afford to lose the object, you should take a backup after the
NOLOGGING operation.





   
  
  Hately, Mike
  
  (NESL-IT)   To:   Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED] 
  Mike.Hately@npowernocc: 
  
  rthern.com  Subject:  RE: Re[2]: undo 
tablespace  
  Sent by: 
  
  [EMAIL PROTECTED] 
  
   
  
   
  
  01/29/2003 08:04 AM  
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




You're correct in saying that your undo blocks are protected by your redo
files.
What type of operation are you performing on your table? I ask because only
a small subset of commands support the NOLOGGING feature; the remainder
will
generate redo as usual.

If you're not using a syntax that supports NOLOGGING maybe you could adapt
your job to adopt one.
Alternatively you may find that you just need to optimise your redo log
placement in order to handle the load.

Regards,
Mike Hately


-Original Message-
Sent: 29 January 2003 14:10
To: Multiple recipients of list ORACLE-L


Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?

When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of
REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

--
Breno A. K. Magnago
mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI Breno,
HMNI There's no way to do this because it's the central pillar of Oracle's
read
HMNI consistency mechanism.
HMNI It's possible to minimise or suppress redo but undo is out of your
control.

HMNI regards,
HMNI Mike Hately

HMNI -Original Message-
HMNI Sent: 29 January 2003 11:39
HMNI To: Multiple recipients of list ORACLE-L


HMNI I have a high procedure (many INSERT's and UPDATE´s).
HMNI This procedure generate insert's in UNDO TableSpace for rollback.
HMNI I want to know if exists any way for don´t generate insert´s in UNDO
HMNI Tablespace.

HMNI Oracle 9i / NT

HMNI Thanks.



**

The information contained in this e-mail is confidential and
intended only for the use of the addressee. If the reader of
this message is not the addressee, you are hereby notified

RE: Perl

Title: RE: Perl



Thanks a bunch ...

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!

  -Original Message-From: Orr, Steve 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 10:14 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Perl
  There are two resources: http://www.zope.org/Members/matt/dco2 
  http://www.computronix.com/utilities.shtml 
  
  The installs are not as nice as DBI but the products work. 
  We've been using cx_Oracle in production for over a year now and have no 
  complaints. Here's an Oracle connectivity test script:
  - 
  #!/usr/bin/env python # File: 
  testPyOra.py # Purpose: Test Python/Oracle 
  connectivity. # Usage: ./testPyOra.py # Set the user connect info 
  in myconstants.py import myconstants as con 
  import cx_Oracle as db 
  def doConnect():  theUser 
  = con.defuser  thePW = con.defpw 
   theConnectString = con.defcs  conn=db.connect(theUser,thePW,theConnectString) 

   if conn != None :  theText = "Successfully connected to 
  Oracle!"  else:  theText = "Unable to connect to the 
  database." 
   print theText  return conn 
  def doQuery(myConn):  if 
  myConn != None :  print 
  "Since we have a valid connection I'll do a query to prove it..." 
   print "Here's a list of users 
  on this database..."  
  SQLtext = "Select username from dba_users"  cursor = myConn.cursor() 
   cursor.execute(SQLtext) 
   resultSet = 
  cursor.fetchall()  for 
  un in resultSet:  print "%s" %un 
   else :  print "Since we're not connected I won't 
  even bother doing a query." 
  def main():  theConn = 
  doConnect()  doQuery(theConn) 
  if __name__=='__main__':main()  
  Steve 
  -Original Message- From: 
  Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, January 29, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Perl 
  Okay ... a question from a colleague ... How do you get python to work with Oracle ... for perl there DBD: and 
  DBI: anything similar in Python? My knowledge of Perl is as good as my 
  knowledge of Python ... /dev/null
  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! 
  -Original Message- From: Glenn 
  Stauffer [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, January 28, 2003 5:17 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: Re: Perl 
  I tinkered with Perl, but could never really get used to the 
  syntax. I basically gave up (still maintain 
  familiarity since Perl is very common) and started 
  using Python. I've grown to enjoy coding in Python and use it now for all of the system maintenance and monitoring scripts 
  I write as well as for my web programming work. 
  I'm not qualified to compare the two languages, but I 
  will say that Perl's Oracle support is better 
  developed and the CPAN archives are a very useful 
  thing. In my opinion, Python is a better designed language 
  and it is perfectly viable for production-level 
  applications in an Oracle environment. 

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

RE: Re[4]: undo tablespace

2003-01-29 Thread Fink, Dan

Breno,
There is your problem. Don't try to solve it by trying to eliminate
undo. I have run into that situation several times. The key is to set up the
database management processes to handle the situation. 
Things to think about:
1) Increase the size of the device where archive_dump_dest resides
2) NEVER, NEVER, NEVER delete archived redo logs until they are on several
different backup tapes. You lose 1 of this beauties and your recovery is
halted.
3) Put together a script/process to move the logs from one device to
another, then purge them after several days.

Dan Fink


-Original Message-
Sent: Wednesday, January 29, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


Dan,

Is the generation of redo (and archived logs) causing the system to
halt due to the archive_dump_dest filling up? 
YES
I'll work to minimize this situation. Thanks.

-- 
Breno A. K. Magnago
mailto:[EMAIL PROTECTED]

Wednesday, January 29, 2003, 1:19:50 PM, you wrote:

FD Breno,
FD 100mb of redo in 20 minutes is not all that high. I have seen
far
FD worse (as I am sure most on the list have as well). Why do you perceive
this
FD as a problem? Are you seeing poor performance or waits? 
FD Is the generation of redo (and archived logs) causing the system
to
FD halt due to the archive_dump_dest filling up? If so, the problem is not
the
FD procedure, but rather the lack of proper process to manage your archive
FD logs.
FD Even with NOLOGGING, UNDO must be generated for read
consistency,
FD rollback and recovery. You are not inserting data into the undo
tablespace.
FD The undo entries are generated for each operation
(insert/update/delete).
FD However, the undo entry for an insert is very small and thus will
consume
FD very little undo space and redo.

FD Don't concern yourself with trying to stop the generation of
UNDO.
FD You will end up causing yourself more problems that you will ever try to
FD solve. It is part of the Oracle kernel and not modifiable (at least in
this
FD release). Focus on performance and decide if 100mb in 20 minutes is
really a
FD problem.

FD Dan Fink

FD -Original Message-
FD Sent: Wednesday, January 29, 2003 7:10 AM
FD To: Multiple recipients of list ORACLE-L


FD Mike,

FD I asked it because I have a problem.
FD Any insert data in UNDO tablespace generate insert in REDO Files. Is
FD is correct ?

FD When I execute a high procedure, many inserts in UNDO tablespace
FD ocurres, so many inserts in REDO´s are genereate.
FD I want to avoid this REDO´s generation.
FD My tables and indexes are in NOLOGGING, but I high value of
FD REDO are generate (100 MB each 20 minutes). It is desnecessary.

FD Oracle 9i / NT


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

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

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

Re[4]: undo tablespace

Mike,

What type of operation are you performing on your table?

INSERT INTO A.TABLE1(COL1,COL2)
SELECT COL1,COL2
FROM B.TABLE2@DB_LINK;

I think that command support the NOLOGGING.Is is correct ?
The table B.TABLE2 and all indexes are in NOLOGGING Option.

-- 
Breno A. K. Magnagomailto:[EMAIL PROTECTED]

Wednesday, January 29, 2003, 2:04:39 PM, you wrote:

HMNI You're correct in saying that your undo blocks are protected by your redo
HMNI files. 
HMNI What type of operation are you performing on your table? I ask because only
HMNI a small subset of commands support the NOLOGGING feature; the remainder will
HMNI generate redo as usual. 

HMNI If you're not using a syntax that supports NOLOGGING maybe you could adapt
HMNI your job to adopt one.
HMNI Alternatively you may find that you just need to optimise your redo log
HMNI placement in order to handle the load.

HMNI Regards,
HMNI Mike Hately


HMNI -Original Message-
HMNI Sent: 29 January 2003 14:10
HMNI To: Multiple recipients of list ORACLE-L


HMNI Mike,

HMNI I asked it because I have a problem.
HMNI Any insert data in UNDO tablespace generate insert in REDO Files. Is
HMNI is correct ?

HMNI When I execute a high procedure, many inserts in UNDO tablespace
HMNI ocurres, so many inserts in REDO´s are genereate.
HMNI I want to avoid this REDO´s generation.
HMNI My tables and indexes are in NOLOGGING, but I high value of
HMNI REDO are generate (100 MB each 20 minutes). It is desnecessary.

HMNI Oracle 9i / NT


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

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

Need help and documentation on moving database from Unix to W2K

2003-01-29 Thread Baswannappa, Shiva




Hi 
Gurus

I am not a DBA, 
but I have request from client to move their oracle 8.1.6 database from a 
Unix server to W2K. Can somebody lead me to documentation in moving entire DB or 
any other resource that will help me accomplish the task?

Thanks a ton in 
advance

Regards 
Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.

SQL question

2003-01-29 Thread Charu Joshi

Hello Listers,

How to find out the COUNT of DISTINCT values of multiple columns?

For eg.

SQL SELECT DISTINCT ename FROM emp;
-- This works.

SQL SELECT COUNT(DISTINCT ename) FROM emp;
-- So does this.

SQL SELECT DISTINCT ename, job FROM emp;
-- And this too.

SQL SELECT COUNT(DISTINCT ename, job) FROM emp;
-- So why does this fail?

I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be elegant
way of doing it.

I have a feeling I might be missing some fairly basic syntax, but feeling
dumb is better than suspense.

Thanks  regards,
Charu.

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



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

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

Rogue TNSNAMES.ORA files Revisited

2003-01-29 Thread Brian McGraw

A few days (or was that weeks??) ago, someone posted some
problems they were having connecting to a database defined in their tnsnames.ora
file. The problem was resolved when they found out that there was a rogue
tnsnames.ora file residing in the same directory as the binary. The
binary file was resolving a databases address by using the local tnsnames.ora
first.

I recently had a similar issue (a long story, available on http://www.clanmcgraw.com/oracle.html
for those interested) where sqlplus was resolving a database address by using a
tnsnames.ora file stored in /var/opt/oracle (on Solaris 8). I thought
that was because I did not have the TNS_ADMIN environment variable set properly
by the oraenv file.

I did some research on Metalink, and under Note 114085.1,
found the following information that others might find useful:

Windows
NT/2000 running Oracle 9i
First: The directory where the application is
launched. For example, if sqlplus resides in
ORACLE_HOME\bin\sqlplus
but was launched from the c:\temp directory, then
c:\temp
is searched for a tnsnames.ora file.
Second: The value of the TNS_ADMIN environment variable.
Third: ORACLE_HOME\network\admin

Sun
Solaris running Oracle 8i or 9i
First: The oracle user's home directory is searched for a
hidden '.tnsnames.ora'
Second: The value of the TNS_ADMIN
environment variable.
Third: /var/opt/oracle
Fourth: $ORACLE_HOME/network/admin

Some were talking about an April Fools joke with local
tnsnames.ora files. I think youd have a lot more fun with the .tnsnames.ora
file, if youre on Solaris. J

Hope that information is useful to someone out there

Brian

--
| Brian McGraw /* DBA */ Infinity Insurance
|
| mailto:[EMAIL PROTECTED]
|
--

RE: Need help and documentation on moving database from Unix to W




1. Install software on W2K
2. Configure DB appropriately
3. Take a cold backup from your Unix DB
 3.1 Make 4 copies, 1 for actual usage, one stand-by two for 
off site backup
4. Import on W2K database
5. Start Database, add a dollop of Whipped Cream and enjoy 
...

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!

  -Original Message-From: Baswannappa, Shiva 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 12:59 
  PMTo: Multiple recipients of list ORACLE-LSubject: Need 
  help and documentation on moving database from Unix to 
W2K
  Hi 
  Gurus
  
  I am not a DBA, 
  but I have request from client to move their oracle 8.1.6 database from 
  a Unix server to W2K. Can somebody lead me to documentation in moving entire 
  DB or any other resource that will help me accomplish the 
  task?
  
  Thanks a ton in 
  advance
  
  Regards 
  Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
  Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
  If the reader of this e-mail is not an 
  intended recipient, you have received this e-mail in error and any review, 
  dissemination, distribution or copying is strictly prohibited. If you have 
  received this e-mail in error, please notify the sender immediately by return 
  e-mail and permanently delete the copy you received. Thank you.
  
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: Need help and documentation on moving database from Unix to W2K

2003-01-29 Thread Alan Davey

Why do they want to move to W2k?  Was it running too quickly for them under Unix?  ;^)

You can use export/import to move the database.  Hopefully the database isn't very big.
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 1/29/2003 12:59 PM, Baswannappa, Shiva [EMAIL PROTECTED] wrote:

Hi Gurus
 
I am not a DBA, but  I have request from client to move their oracle 
8.1.6 database from a Unix server to W2K. Can somebody lead me to 
documentation in moving entire DB or any other resource that will 
help me accomplish the task?
 
Thanks a ton in advance
 
Regards
Shiva Baswannappa
Senior Developer
Digital Consulting and Software Services
Phone: 281.243.2658
Fax: 281.243.2504
Web: http://www.dcss.com http://www.dcss.com/
If the reader of this e-mail is not an intended recipient, you have 
received this e-mail in error and any review, dissemination, distribution 
or copying is strictly prohibited. If you have received this e-mail 
in error, please notify the sender immediately by return e-mail and 
permanently delete the copy you received. Thank you.
 

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

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

STATSPACK

2003-01-29 Thread Ruth Gramolini

 Hello everyone,

I hope this is a quick question.  Can you run 8.1.7 Statspack on an 8.0.6.3
instance?

Thanks in advance,
Ruth

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

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

9iR2 standby databae archiving location

2003-01-29 Thread Glenn Stauffer

Has anyone run into this problem...

I created a standby database using RMAN and have found that there is an
archiving location defined for this standby database,
log_archive_dest_11 which points to the $ORACLE_HOME/dbs directory.  I
didn't define a logging destination 11 and there isn't one defined in my
primary database.  So, how was it created?

And, how can it be changed or removed?  I've tried alter system set
log_archive_dest_11='LOCATION=/new/path/arch';, but that statement
fails with an ORA-02065, illegal option.  I've also tried to modify this
in a pfile, but Oracle won't let me generate an spfile from a pfile with
the 'log_archive_dest_11' option set - says it is invalid.

I've posted to the metalink forums, but no reponse yet.  If anyone dealt
with this, I'd appreciate your advice on either redefining or removing
this archiving destination.

Thanks, Glenn

-- 
Glenn Stauffer
Swarthmore College
Swarthmore, PA

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

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

Perl scripts for hot backup

2003-01-29 Thread Farnsworth, Dave

Here is a link that I found for a Perl script for hot backups.  Just have seen a bunch 
of chatter about perl on the list lately so just wanted to throw this out in case 
someone finds it useful.

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci857677,00.html

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

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

HP-UX 11i/8.1.7/DB Link Question

2003-01-29 Thread Vergara, Michael (TEM)

Hi Everyone!

I have been tasked with finding out how often connections are made between
databases using DB links.  Does anyone know of a tracking or auditing
tool, or perhaps a audit methodology, that would provide this information?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

Re: off topic: iostat -x in linux

2003-01-29 Thread Craig I. Hagan

   In linux, it seems difficult, I have tried linux iostat and sysstat-iostat, 
non of them seems to work properly with util column in iostat report.  Though no 
activity on the server at all, iostat always report utilization of the partitions 
100%  Why?
 I also searched google and found the same question asked by others, but nobody 
replied. 
 
   Anyone have the same experience? How did you measure the load on the io 
subsystem in your linux server then? IO wait is still 0%, but io capacity usage is 
100%. Confusing...


I usually take the %util as provided by the os and ignore it. Only the disk
itself truly knows how well utilized it is -- you may have other problems
(small requests over fibre, etc which causeyou to talk more protocol than data,
for example). If you can't pull stats from the disk, you can watch its response
time which will tell you when it is truly overutilized (service time tends to
increase as a function of load, with a knee in most systems that is rather
pronounced, raid5 being *far* more noticeable when faced with writes,
especially non-stripe aligned writes).

This appears in iostat as svtcm, which is the number of ms it takes the
relevant disk/partition to respond to the io requests just tracked. You can
also look at mean io size, which requires a teensy bit of math, compute it like
this:

Read: ((rsec)/2)/rrqm)
Write: ((wsec)/2)/wrqm)


Also, realize with with modern disk subsystems, you can often take bursts of
traffic which far exceed the disks capacity to handle it and not see a major
spike due to cache effects, particularly with write-behind caching systems.  
Often such systems will look fabulous for small spikes but will show good
behavior that suddenly falls apart when handed a continous load which exceeds
the array's ability to flush cache to the disks.  This is part of why the
utilization stats (on the os) are fairly meaningless as they are based on
complete guesses rather than true knowledge of the underlying subsystems.


-- craig

  .-... . -.-. .-. . --- . ... ... .- --. .

Craig I. Hagan
   hagan(at)cih.com



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

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

RE: Rogue TNSNAMES.ORA files Revisited

Title: RE: Rogue TNSNAMES.ORA files Revisited





Yup ... learned it the hard way !! At-least AIX is *normal* (fingers crossed).


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!
-Original Message-
From: Brian McGraw [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Rogue TNSNAMES.ORA files Revisited



A few days (or was that weeks??) ago, someone posted some problems they were having connecting to a database defined in their tnsnames.ora file. The problem was resolved when they found out that there was a 'rogue' tnsnames.ora file residing in the same directory as the binary. The binary file was resolving a database's address by using the local tnsnames.ora first.

I recently had a similar issue (a long story, available on http://www.clanmcgraw.com/oracle.html for those interested) where sqlplus was resolving a database address by using a tnsnames.ora file stored in /var/opt/oracle (on Solaris 8). I thought that was because I did not have the TNS_ADMIN environment variable set properly by the oraenv file.

I did some research on Metalink, and under Note 114085.1, found the following information that others might find useful:

Windows NT/2000 running Oracle 9i 
 First: The directory where the application is launched. For example, if sqlplus resides in 
 ORACLE_HOME\bin\sqlplus but was launched from the c:\temp directory, then 
 c:\temp is searched for a tnsnames.ora file. 
 Second: The value of the TNS_ADMIN environment variable. 
 Third: ORACLE_HOME\network\admin 
Sun Solaris running Oracle 8i or 9i 
 First: The oracle user's home directory is searched for a hidden '.tnsnames.ora' 
 Second: The value of the TNS_ADMIN environment variable. 
 Third: /var/opt/oracle 
 Fourth: $ORACLE_HOME/network/admin 
Some were talking about an April Fool's joke with local tnsnames.ora files. I think you'd have a lot more fun with the .tnsnames.ora file, if you're on Solaris. J

Hope that information is useful to someone out there...


Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--



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

RE: Need help and documentation on moving database from Unix to W

2003-01-29 Thread DENNIS WILLIAMS

Shiva
First I would suggest you consider whether this is a good use of your
client's money. This is a somewhat complex task that will be a good learning
experience for you personally, but may cost the client. You should also
consider how you will be able to confirm the quality of your work once you
are done. Will you be able to ensure the client will have a robust Oracle
database they can rely on?
   Overall the steps are: 
Install Oracle on Windows.
Create a database, with the same usernames and tablespaces as the
Unix database.
Perform a full export of the data.
Import the data into the Windows database.
Verify that the import was successful and no data was lost.



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

-Original Message-
Sent: Wednesday, January 29, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus
 
I am not a DBA, but  I have request from client to move their oracle 8.1.6
database from a Unix server to W2K. Can somebody lead me to documentation in
moving entire DB or any other resource that will help me accomplish the
task?
 
Thanks a ton in advance
 
Regards 

Shiva Baswannappa 
Senior Developer 
Digital Consulting and Software Services 
Phone: 281.243.2658 
Fax: 281.243.2504 
Web: http://www.dcss.com http://www.dcss.com/  

If the reader of this e-mail is not an intended recipient, you have received
this e-mail in error and any review, dissemination, distribution or copying
is strictly prohibited. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and permanently delete the
copy you received. Thank you.

 

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

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

RE: Debate on rc commands Solaris and Oracle

2003-01-29 Thread maheswara.rao

Title: RE: Debate on rc commands Solaris and Oracle



Paula,

Shutdown abort is not recommended as the file 
checkpointing is not done during shutdown abort. If you need to perform 
shutdown abort, then, it is preferred to bring up the db with startup restrict 
(so that the users wouldn't connect) and then, cleanly shutdown the db and bring 
it up again.

Tell 
to your sys admins. that shutdown immediate would take some time (about 5 to 10 
minutes) depending on the activity on your db. They would have to wait for 
that much time before calling a DBA during system boots.

Rao

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 
  2003 11:30 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Debate on rc commands Solaris and 
  Oracle
  System Administrator says he doesn't trust that the rc 
  commands will stop if the database doesn't want to shutdown and even if it 
  does would want to shutdown with scripts beforehand so that a DBA could 
  connect and resolve the issue. Other DBA says this is all wrong and rc 
  commands should include shutdown immediate of database. In the past I 
  had setup 2 processes in the system scripts for the sys admin - shutdown 
  immediate - wait  shutdown abort - on a read-only DSS system which of 
  course allows some room for this type of activity. I kind of would want 
  to know if a database was going to be shutdown with an abort esp. in OLTP 
  system and do it myself.
  - any ideas

RE: Base conversion

2003-01-29 Thread James Howerton

Danny  Thilaga,

You might find this useful. ;-)

...JIM...

 [EMAIL PROTECTED] 1/28/03 2:10:28 PM 
Here ya go:

create or replace package radix
is

/*
base code courtesy of Thomas Kyte
*/

function to_base( p_dec in number, p_base in number )
return varchar2;

function to_dec (
p_str in varchar2,
p_from_base in number default 16
) return number;

function to_hex( p_dec in number ) return varchar2;
function to_bin( p_dec in number ) return varchar2;
function to_oct( p_dec in number ) return varchar2;
function to_36( p_dec in number ) return varchar2;
function to_64( p_dec in number ) return varchar2;

pragma restrict_references( to_base, wnds, rnds, wnps, rnps );
pragma restrict_references( to_dec, wnds, rnds, wnps, rnps );
pragma restrict_references( to_hex, wnds, rnds, wnps, rnps );
pragma restrict_references( to_bin, wnds, rnds, wnps, rnps );
pragma restrict_references( to_oct, wnds, rnds, wnps, rnps );
pragma restrict_references( to_36, wnds, rnds, wnps, rnps );
pragma restrict_references( to_64, wnds, rnds, wnps, rnps );

end radix;
/

show errors

create or replace package body radix
is

function to_base( p_dec in number, p_base in number )
return varchar2
is
l_str   varchar2(255) default NULL;
l_num   number  default p_dec;
l_hex   varchar2(64) := 
'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
begin
-- base 64 for Oracle extended rowid format
if p_base = 64 then
l_hex := 
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
end if;
if ( trunc(p_dec)  p_dec OR p_dec   0 ) then
raise INVALID_NUMBER;
end if;
loop
l_str := substr( l_hex, mod(l_num,p_base)+1, 1
) 
|| l_str;
l_num := trunc( l_num/p_base );
exit when ( l_num = 0 );
end loop;
return l_str;
end to_base;

function to_dec (
p_str in varchar2,
p_from_base in number default 16 )
return number
is
l_num   number default 0;
l_hex   varchar2(64) := 
'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
begin
-- base 64 for Oracle extended rowid format
if p_from_base = 64 then
l_hex := 
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
end if;
for i in 1 .. length(p_str) loop
l_num := l_num * p_from_base + 
instr(l_hex,upper(substr(p_str,i,1)))-1;
end loop;
return l_num;
end to_dec;

function to_hex( p_dec in number ) return varchar2
is
begin
return to_base( p_dec, 16 );
end to_hex;

function to_bin( p_dec in number ) return varchar2
is
begin
return to_base( p_dec, 2 );
end to_bin;

function to_oct( p_dec in number ) return varchar2
is
begin
return to_base( p_dec, 8 );
end to_oct;

function to_36( p_dec in number ) return varchar2
is
begin
return to_base( p_dec, 36 );
end to_36;

function to_64( p_dec in number ) return varchar2
is
begin
return to_base( p_dec, 64 );
end to_64;

end radix;
/


show errors


 test 

ol object new_value object
col file new_value file
col block new_value block
col row new_value row

select rowid
, substr(rowid,1,6) OBJECT
, substr(rowid,7,3) FILE
, substr(rowiD,10,6) BLOCK
, substr(rowid,16,3) ROW
, dbms_rowid.rowid_to_restricted(rowid,0 ) RESTRICTED
, dbms_rowid.rowid_to_absolute_fno(rowid,'SYS','DUAL') FNO
, dbms_rowid.rowid_object(rowid) OBJECT_ID
, dbms_rowid.rowid_block_number(rowid) BLOCK_NUM
, dbms_rowid.rowid_row_number(rowid) ROW_NUMBER
from dual
/

select
radix.to_dec('file',64) FNO
, radix.to_dec('object',64) OBJECT_ID
, radix.to_dec('block',64) BLOCK_NUM
, radix.to_dec('row',64)
from dual
/



Jared







Stephen Lee [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 
 01/28/2003 11:25 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: 
Subject:RE: Base conversion


 -Original Message-
 Stephen,
 
 The code I posted earlier is easily adapted to do base 64.
 
 Please share your mods.  :)
-

OK.  I figured out that A is zero (I think).  Now, only 63 more to

RE: STATSPACK

2003-01-29 Thread Farnsworth, Dave

I believe that an 8.1.7 statspack can run on an Oracle8 or higher database.

Dave

-Original Message-
Sent: Wednesday, January 29, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L


 Hello everyone,

I hope this is a quick question.  Can you run 8.1.7 Statspack on an 8.0.6.3
instance?

Thanks in advance,
Ruth

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

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

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

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

RE: Perl

2003-01-29 Thread Stephen Lee

 -Original Message-
 Is it better/faster than a ksh script?
--

Whether you use perl or ksh, the main purpose of the script is to build a
command line and run it for whatever backup method you are using.  After
that, virtually all of the time is used by the backup process which doesn't
care from whence its command line came.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: SQL question

2003-01-29 Thread Fink, Dan

Charu,
The COUNT() function requires a single expression. ename, job is
not a valid expression. ename||job is a valid expression since it will
return a single value.
Another alternative would be
select count(*)
from (select distinct ename, job from emp);

Dan Fink

-Original Message-
Sent: Wednesday, January 29, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L


Hello Listers,

How to find out the COUNT of DISTINCT values of multiple columns?

For eg.

SQL SELECT DISTINCT ename FROM emp;
-- This works.

SQL SELECT COUNT(DISTINCT ename) FROM emp;
-- So does this.

SQL SELECT DISTINCT ename, job FROM emp;
-- And this too.

SQL SELECT COUNT(DISTINCT ename, job) FROM emp;
-- So why does this fail?

I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be elegant
way of doing it.

I have a feeling I might be missing some fairly basic syntax, but feeling
dumb is better than suspense.

Thanks  regards,
Charu.

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



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

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

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

RE: Perl

2003-01-29 Thread Ron Rogers

Perl People,
 Boy that sounds like a blast from the past with the purple people
eater...
There is an interesting Perl hot backup script at
http://www.searchDatabase.com/tip/1,289483,sid13_gci876060,00.html 
Not understanding Perl yet and liking to keep things simple, The code
seems link and complex. Is it better/faster than a ksh script?
Ron

Looking into different options to learn to enhance my value.

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

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

RE: Rogue TNSNAMES.ORA files Revisited

2003-01-29 Thread John Kanagaraj

Brian,

The order in which the TNS connection searches are performed can also easily
be determined by using the 'truss' command on Solaris. I used this to prove
my case to a PHB of a smart-aleck Developer who was side-stepping our move
to an Oracle Name Service in a prior assignment.

I see what you mean - been there done that!

Take care bro!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my
future! 

** The opinions and statements above are entirely my own and not those of my
employer or clients **


-Original Message-
Sent: Wednesday, January 29, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L


A few days (or was that weeks??) ago, someone posted some problems they were
having connecting to a database defined in their tnsnames.ora file.  The
problem was resolved when they found out that there was a 'rogue'
tnsnames.ora file residing in the same directory as the binary.  The binary
file was resolving a database's address by using the local tnsnames.ora
first.
 
I recently had a similar issue (a long story, available on
http://www.clanmcgraw.com/oracle.html for those interested) where sqlplus
was resolving a database address by using a tnsnames.ora file stored in
/var/opt/oracle (on Solaris 8).  I thought that was because I did not have
the TNS_ADMIN environment variable set properly by the oraenv file.
 
I did some research on Metalink, and under Note 114085.1, found the
following information that others might find useful:
Windows NT/2000 running Oracle 9i 
First: The directory where the application is launched.  For example, if
sqlplus resides in 
ORACLE_HOME\bin\sqlplus but was launched from the c:\temp
directory, then 
c:\temp is searched for a tnsnames.ora file. 
Second: The value of the TNS_ADMIN environment variable. 
Third: ORACLE_HOME\network\admin 
Sun Solaris running Oracle 8i or 9i 
First: The oracle user's home directory is searched for a hidden
'.tnsnames.ora' 
Second: The value of the TNS_ADMIN environment variable. 
Third: /var/opt/oracle 
Fourth: $ORACLE_HOME/network/admin 
Some were talking about an April Fool's joke with local tnsnames.ora files.
I think you'd have a lot more fun with the .tnsnames.ora file, if you're on
Solaris.  J
 
Hope that information is useful to someone out there...
 
Brian
--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

10046 Tracing ...

Title: 10046 Tracing ...





Has anyone used ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip yet? I found it today and seems to be a nice utility. Sweet ... and it works even if you are not running Oracle apps.

It is probably a better tkprof interface, but intuitive ... cool tool !!


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



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

RE: SQL question

2003-01-29 Thread Whittle Jerome Contr NCI

Title: RE: SQL question






Joshi,


SELECT count(*) 

FROM (SELECT count(*) 

 FROM flight_legs 

 GROUP BY d_actual_time, event_type);


SELECT count(*) 

FROM (SELECT DISTINCT d_actual_time, event_type

 FROM flight_legs );


The first one took about 37 seconds in returning a count of 357331. The second statement was about 10 seconds quicker.


Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From: Charu Joshi [SMTP:[EMAIL PROTECTED]]


Hello Listers,


How to find out the COUNT of DISTINCT values of multiple columns?


For eg.


SQL SELECT DISTINCT ename FROM emp;

-- This works.


SQL SELECT COUNT(DISTINCT ename) FROM emp;

-- So does this.


SQL SELECT DISTINCT ename, job FROM emp;

-- And this too.


SQL SELECT COUNT(DISTINCT ename, job) FROM emp;

-- So why does this fail?


I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be elegant

way of doing it.


I have a feeling I might be missing some fairly basic syntax, but feeling

dumb is better than suspense.


Thanks  regards,

Charu.

Re: SQL question

2003-01-29 Thread Rachna Vaidya

And, can you have two columns as arguements for COUNT?
I guess its either one column or rows

+Rachna

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 1:19 PM


 Hello Listers,

 How to find out the COUNT of DISTINCT values of multiple columns?

 For eg.

 SQL SELECT DISTINCT ename FROM emp;
 -- This works.

 SQL SELECT COUNT(DISTINCT ename) FROM emp;
 -- So does this.

 SQL SELECT DISTINCT ename, job FROM emp;
 -- And this too.

 SQL SELECT COUNT(DISTINCT ename, job) FROM emp;
 -- So why does this fail?

 I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be
elegant
 way of doing it.

 I have a feeling I might be missing some fairly basic syntax, but feeling
 dumb is better than suspense.

 Thanks  regards,
 Charu.

 *
 Disclaimer

 This message (including any attachments) contains
 confidential information intended for a specific
 individual and purpose, and is protected by law.
 If you are not the intended recipient, you should
 delete this message and are hereby notified that
 any disclosure, copying, or distribution of this
 message, or the taking of any action based on it,
 is strictly prohibited.

 *
 Visit us at http://www.mahindrabt.com



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

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

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

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

RE: SQL question