Re: who compiled this proc

[Peter Gram]

Bp

There is no way to find the ceator or the ip-addres of a procedure when it
is created if the the creator is different from the owner 
 :-( 

Big Planet wrote:

  
  
  How to find which database user and ip-address
 compiled this stored proc ?
   
  -Bp
  
  
  -- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk


  
  
  

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

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

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

Re: Long running SQL Problem?

[Greg Moore]

Why not code up a couple of SQL's and try it out?

I just tried a couple of examples that match your code, and the NOT IN
version was slightly faster, so I'm not frowning upon it.  ;-)

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 9:13 PM


> Hi Gurus,
>
> My senior DBA always tell us that the "not in" command sucks and we are
all
> encourage to use the select count(*). SQL A is greatly frowned upon and
SQL
> B will be the best.
>
> SQL A :
> SELECT col1,col2
>   FROM Table_1
>  WHERE (col1,col2) NOT IN (SELECT col3,col4
>  FROM Table_2
> WHERE col3 = col1
>   AND col4 = col2);
> SQL B :
> SELECT col1,col2
>   FROM Table_1 A
>  WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE b.col3=a.col1 AND
> b.col4=a.col2));
>
> Qn : Is it true ? Could someone shed some light ? Please advise. Thanks.
>
> Regds,
> Catherine
>
> -Original Message-
> Sent: Wednesday, March 27, 2002 8:19 PM
> To: CHAN Chor Ling Catherine (CSC)
>
>
>
> Hello Catherine
>
> Thanks first of all for your suggestions.
> The indexes were already in exitance before your email, so I did not even
> try that.
> But your query and that of Marco van Rooy ran exactly the same number of
> seconds.
> They are both basicly the same.
> Marco's looked like this...
>
> SELECT col1,col2
>   FROM Table_1
>  WHERE (col1,col2) NOT IN (SELECT col3,col4
>  FROM Table_2
> WHERE col3 = col1
>   AND col4 = col2);
>
> Because both yours and Marcos brought the data back in so short a time
> *16sec*, I have not yet experimented with any of the others.
>
> Thanks again
> Rgds
> Denham
>
> -Original Message-
>  ]
> Sent: Wednesday, March 27, 2002 2:00 PM
> To: '[EMAIL PROTECTED]'
>
>
> Hi Denham,
>
> I would like to know which solution is the fastest.
>
> Regds,
> Catherine
>
> -Original Message-
> Sent: Wednesday, March 27, 2002 7:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi List
>
> Thank you to everyone who took the time to answer, I never realised that
> there could be so many solutions :)
>
> Rgds
> Denham
>
> -Original Message-
> Sent: Wednesday, March 27, 2002 10:53 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hello List
>
> Is there anyone who can give me a solution to this problem.
> It is a sql that runs forever and I eventually have to kill it, both
tables
> are large 50 + rows.
> Is there perhaps a quicker more effecient way of doing this.
>
>
> SELECT col1,col2
> FROM Table_1
> WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2);
>
>
> TIA
> Denham Eva
> Oracle DBA
>
>   _
>
> This e-mail message has been scanned for Viruses and Content and cleared
by
> MailMarshal - For more information please visit
> < http://www.marshalsoftware.com  >
> www.marshalsoftware.com
>   _
>
>
>   _
>
> This e-mail message has been scanned for Viruses and Content and cleared
by
> MailMarshal - For more information please visit
> < http://www.marshalsoftware.com  >
> www.marshalsoftware.com
>   _
>
>   _
>
> This e-mail message has been scanned for Viruses and Content and cleared
by
> MailMarshal - For more information please visit
>  www.marshalsoftware.com
>   _
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: sysdba

[DBarbour]

What is your operating system, database level, and what command are you
issuing?  Is this the first time this has occurred?

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


   
 
paPIpapupapePO 
 
   
nec.co.jp>cc:  
 
Sent by:  Subject: sysdba  
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
04/02/2002 
 
11:18 PM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




i cant connect as sysdba.
ORA-01031 - insuffecient privileges.

can anybody help me?

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

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

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




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

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

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

Re: sysdba

[Bunyamin K. Karadeniz]

I had taken the same error sometime ago and droped and recreated password
file .that is a solution 1 . Try logging as internal and change the password
of sys . then try again .



Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.

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


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

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

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

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

sysdba

[paPIpapupapePO]

i cant connect as sysdba.
ORA-01031 - insuffecient privileges.

can anybody help me?

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

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

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

RE: Long running SQL Problem?

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,
 
My senior DBA always tell us that the "not in" command sucks and we are all
encourage to use the select count(*). SQL A is greatly frowned upon and SQL
B will be the best.
 
SQL A :
SELECT col1,col2 
  FROM Table_1 
 WHERE (col1,col2) NOT IN (SELECT col3,col4 
 FROM Table_2 
WHERE col3 = col1 
  AND col4 = col2); 
SQL B :
SELECT col1,col2 
  FROM Table_1 A
 WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE b.col3=a.col1 AND
b.col4=a.col2));
 
Qn : Is it true ? Could someone shed some light ? Please advise. Thanks.
 
Regds,
Catherine

-Original Message-
Sent: Wednesday, March 27, 2002 8:19 PM
To: CHAN Chor Ling Catherine (CSC)



Hello Catherine 

Thanks first of all for your suggestions. 
The indexes were already in exitance before your email, so I did not even
try that. 
But your query and that of Marco van Rooy ran exactly the same number of
seconds. 
They are both basicly the same. 
Marco's looked like this... 

SELECT col1,col2 
  FROM Table_1 
 WHERE (col1,col2) NOT IN (SELECT col3,col4 
 FROM Table_2 
WHERE col3 = col1 
  AND col4 = col2); 

Because both yours and Marcos brought the data back in so short a time
*16sec*, I have not yet experimented with any of the others.

Thanks again 
Rgds 
Denham 

-Original Message- 
 ] 
Sent: Wednesday, March 27, 2002 2:00 PM 
To: '[EMAIL PROTECTED]' 


Hi Denham, 
  
I would like to know which solution is the fastest. 
  
Regds, 
Catherine 

-Original Message- 
Sent: Wednesday, March 27, 2002 7:44 PM 
To: Multiple recipients of list ORACLE-L 


Hi List 
  
Thank you to everyone who took the time to answer, I never realised that 
there could be so many solutions :) 
  
Rgds 
Denham 

-Original Message- 
Sent: Wednesday, March 27, 2002 10:53 AM 
To: Multiple recipients of list ORACLE-L 



Hello List 

Is there anyone who can give me a solution to this problem. 
It is a sql that runs forever and I eventually have to kill it, both tables 
are large 50 + rows. 
Is there perhaps a quicker more effecient way of doing this. 


SELECT col1,col2 
FROM Table_1 
WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2); 


TIA 
Denham Eva 
Oracle DBA 

  _  

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


  _  

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

  _  

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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

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

RE: EMC question

[Khedr, Waleed]

 So it's great that EMC is offering striping on the hardware level that
should be good idea for implementing striped raw device.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/2/02 6:28 PM

Hi Waleed & list,

The issue I raised about "queuing" was within the
context of sequential writes to the various "stripe
units" within a striped volume. If you have a 4-way
stripe and there are 4 dirty disk blocks (1 on each
stripe unit) that needs to be written to each of the 4
disks, the LVM-mid-layer should be able to get them
down to their respective disks, independent of one
another, not one after the other. If the dirty disk
blocks are not written independent of one another,
there will be no advantage of "striping" for writes.
And "pure striping" should cater to I/O scalability
for both reads and writes.

Regards,

Gaja



--- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> HI Gaja & list,
> 
> I am trying to find the truth here! I was told by
> the storage group that EMC
> has striping now and this what I'm researching.
> 
> Gaja, what you described as a problem during WRITES
> to striped EMC is a
> typical procedure in any striped volumes.
> 
> There is a mid layer that has to map logical I/O
> addresses to physical disk
> addresses.
> 
> If you are using Veritas LVM then all reads/writes
> requests will be queued
> to the LVM and will do exactly as you mentioned.
> 
> There is a queue  but the difference is big. You
> have a queue with many
> servers serving the queue requests simultaneously.
> 
> Please check powerlink.emc.com
> 
> 
> Regards,
> 
> Waleed
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 12:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Waleed & list,
> 
> To define the terms we have on hand:-
> A contiguous meta volume requires the hyper volumes
> to
> be sequential. A non-contiguous does not require the
> hyper volumes to be sequential.
> 
> I want to reiterate again that the concept of "pure
> striping" at the hardware level, is still not there
> in
> EMC, even though you have documentation that claims
> that you do. Let me explain.
> 
> When you look at "pure striping", there are 2
> aspects
> to it :-
> 
> 1) The read aspect
> 2) The write aspect
> 
> Take an example of a 4-way striped volume. The read
> aspect provides us the capability for all 4 drives
> to
> independently spin and service I/O from each of the
> drives. This the EMC device does, after the data has
> been placed on all hypers that support a meta
> volume.
> 
> The write aspect needs to offer the same
> functionality. So, if you are writing to 4 distinct
> blocks (each on 1 disk), then each drive should be
> able to write 1 block in an independent fashion.
> 
> That is where, the EMC hardware striping is not
> complete. This is because, the 4 blocks that need to
> be written to the "meta volume" with 4 hypers
> (regardless of whether it is contiguous or not),
> will
> happen in "sequential" fashion. Meaning, to write 4
> blocks into the "striped volume", the first block
> will
> be written to the first hyper, followed by the
> second
> block to the second hyper and so on. As you can see
> the blocks that need to be written are queued up, so
> that they are written in a sequential fashion on the
> underlying hypers. This can and will cause severe
> write-intensive I/O bottlenecks.
> 
> Why is this implemented this way? No specific
> reasons,
> except, "that is how it is right now". It has been
> rumored that microcode 5x68 or 5x69, will do that.
> Remains to be seen.
> 
> So all the EMC "striping" does right now is to
> alleviate the problem of read-intensive operations
> not
> hammering a single drive, provided the data is
> spread
> across all the underlying hypers. I am not very
> familiar with the Engenuity product offering, hence
> cannot comment on that, but from what I have heard,
> it
> is a software-based volume management product.
> 
> 
> Best regards,
> 
> Gaja
> 
> --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> >  
> > It looks like it's available now.
> > 
> > This is from: ResourcePak for Windows Version 3.2
> > Product Guide 
> > 
> > "Symmetrix Microcode level 5x65 includes support
> for
> > concatenated
> > (contiguous) and striped metavolumes.
> > Noncontiguous metavolumes (including striped)
> > require EMC Enginuity(tm)
> > (5x66 microcode) or higher."
> > 
> > Regards,
> > 
> > Waleed
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L
> > Sent: 4/1/02 5:38 PM
> > 
> > Waleed & list,
> > 
> > I researched this issue recently and found out
> that
> > the meta volume was "concatenating a bunch of
> hyper
> > volume". As you know, concatenation is NOT
> striping.
> > The hyper volumes get filled with data one after
> > another, eventually giving you the "simulation of
> a
> > striped volume", when all hypers are filled with
> > data.
> > 
> > I don't know about the "single-host vs.
> multi-host"
> > addressibility issue. There a

RE: DBMS_STATS

[ayyappan . subramaniyan]

ya 
u have to run the DBMSstat.sql which is in
oracle_home/rdbms/admin/dbmsstat.sql


after that u have to gather the statistics.

Rgds
Ayyapps






This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.
Visit us @
www.ssiworldwide.com

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

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

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

RE: Stand By Database !!

[Rahul]

you need to create the datafile in ur standby and then apply the logs...

see the alter database create datafile AS command... 

> --
> From: Prasad Dash, Saroj (CAP,
> GCF)[SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 9:00 AM
> To:   LazyDBA.com Discussion
> Subject:  Stand By Database !!
> 
> Suhen ,
> 
> After adding a datafile in Primary database .In the day end I am planning
> to
> apply the archive logs into stand by database.
> Did I require to refresh the controlfile .
> 
> Hello all,
> 
> My standby database is in manual mode.
> 
> I came to know that if you will apply the archive logs then  you will hit
> the errors below.
> ORA-283, ORA-1670, ORA-1157, ORA-1110 
> 
> STANDBY DATABASE> svrmgrl
> STANDBY DATABASE> connect internal
> STANDBY DATABASE> recover standby database Press Enter Key 
> 
> then i will hit those errors
> ORA-283, ORA-1670, ORA-1157, ORA-1110
> 
> My standby database is in manual mode.Everyday I transfer the archive logs
> manually and recove the dataase manually.
> 
> 
> So please tell me what will be the detail procedure of adding a datafile
> in
> stand by databse.
> 
> I know about this command.
> 
> Svrmgrl> connect internal 
> svrmgrl> simple i will put the below command.
> 
>  ALTER DATABASE CREATE DATAFILE '/db/orcale/docimage.dbf' 
>  AS '/db/orcale/docimage.dbf';
> 
> svrmgrl> then recover standby database 
> 
> HIt the Enter Key the appply the logs.
> 
> 
> 
> 
> Please tell me the detail procedure.
> 
> Regards,
> Saroj.
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to [EMAIL PROTECTED]
> To subscribe:   send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

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

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

Re: Literal SQL and sys.dual

[Mohammed Shakir]

You are right. There are at least twelve modules that I have identified
so far. Some are easy and others are like speghatti. Learning the code,
fixing and testing will require couple of months. I have to leave this
project with in a month and I have SQL code that needs optimization. I
have a huge buffer gets problem. So I am running against the time. So
without messing up the logic and spend time learning fixing and testing
the code, this one seems like a better option for me at this point.  I
am trying the project to do it right and do it where code needs the
proper change even when I am gone.

Thanks for yours and every one elses response. Your advices are
supporting the ideas I have in the back of my mind to do it right.

--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Mohammed Shakir wrote:
> > 
> > I am working on a database optimization project. My Shared pool is
> > filled with SQL like
> > 
> > select 0 from dual;
> > select 1/1 from dual;
> > select 1 - 1/(2 + 2) from dual;
> > 
> > I tried to use the bind variables to minimize the literal SQL.
> However
> > I need a different SQL script for each case.
> > 
> > select :b1 from dual;
> > select :b1/:b2 from dual;
> > select :b1 - :b2/(:b3 + :b4) from dual;
> > 
> > first one will handle all cases for b1 from 0 to any number which
> is
> > good. And second sql will handle all the cases for any number for
> b1
> > and b2. So I do reduce the literal SQL. However, I need to know
> ahead
> > of time what type of data I am calculating and then use the
> appropriate
> > SQL.
> > 
> > I think the easy solution would be to use arithmetic. That is to
> pass
> > the string like ( 1 + 1 / (2 -2) ) to some function that can return
> me
> > the result of this sting. So I would not be using SQL script, to
> > minimize SQL execution, sys.dual contention or literal SQL filling
> > shared pool and causing both library cache and shared pool. Not to
> > mention saving in CPU processing by not parsing SQL scripts.
> > 
> > Anybody, aware of such function in PL/SQL? Is there any other way
> to do
> > calculations other than 'select 1 + 1 from dual' ?
> > 
> > I would really appreciate if you could let me know.
> > 
> > Thanks
> > 
> > Mohammed Shakir
> > 
> > =
> > Mohammed Shakir
> > CompuSoft, Inc.
> > 11 Heather Way
> > East Brunswick, NJ 08816-2825
> > (732) 672-0464 (Cell)
> > (732) 257-6001 (Home)
> > 
> 
> Mohammed,
> 
>   Don't you think, before starting with a PL/SQL function of death,
> that
> it *might* be easier to check the code and see where these
> statements,
> which are unlikely to be functional requirements, are used? Rewriting
> the PL/SQL code around them is probably the most efficient way to get
> rid of them.
> 
> -- 
> Regards,
> 
> Stephane Faroult
> Oriole Software
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stephane Faroult
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


=
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

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

Exe Loading too slow on DB Server

[VIVEK_SHARMA]

Are there any Best Practices of Tuning Solaris 8 for HIGH-End heavily Loaded Machines ?

A Brief Description of the Issue & Actions Below :-

Machine E6500
RAM 20 GB
CPUs = 20
SWAP = 26 GB
 
After Migration from Oracle 7.3.4 to 8.1.7.2  on Solaris 2.8 

sqlplus becomes SLOW as the Number of Unix Users Connecting to the Database Increases 
to about 400 whereafter even after all users are logged out the response continues to 
be Slow even after the machine is Booted  i.e. ON Issuing the Command $ sqlplus it 
took about 5 minutes for the following Message to appear : -   
 
" SQL*Plus: Release 8.1.7. 0.0 - Production on Tue Mar 19 09:56:05 2002
 
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
 
Enter user-name: "
 
NOTE - This Slowness is Observed BOTH When Issuing "sqlplus" Command DIRECTLY on the 
DB Server & Also from the APP Server Via SQL*Net
 
NOTE - In Oracle 7 NO such Slowness was Observed when the Total of 1200 Connect to the 
Database
 
- Executed truss sqlplus with the Following Output :-
$ truss sqlplus
execve("/arch/oracle/bin/sqlplus", 0xFFBEFBBC, 0xFFBEFBC4)  argc = 1
mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 
0xFF3A
resolvepath("/usr/lib/ld.so.1", "/usr/lib/ld.so.1", 1023) = 16
stat("/arch/oracle/bin/sqlplus", 0xFFBEF8F8)= 0
open("/var/ld/ld.config", O_RDONLY) Err#2 ENOENT
open("/arch/oracle/lib/libclntsh.so.8.0", O_RDONLY) = 3
fstat(3, 0xFFBEF28C)= 0
mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39
mmap(0x, 6717440, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFEC0
mmap(0xFF224000, 209704, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 
6373376) = 
 
0xFF224000
mmap(0xFF258000, 58832, PROT_READ|PROT_WRITE|PROT_EXEC, 
MAP_PRIVATE|MAP_FIXED|MAP_ANON, -1, 0) = 
 
0xFF258000
munmap(0xFF216000, 57344)   = 0
memcntl(0xFEC0, 672560, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)  <-  WAIT HAPPENING AT THIS POINT  
 
ACTIONS 
ON RE-Creating file libclntsh.so.8.0 using getclntsh on the APP Server Response 
Message 
" SQL*Plus: Release 8.1.7.2. " became FAST ONLY for a FEW Minutes whereafter it 
again Became Slow
 
Copied libclntsh.so.8.0  to /usr/lib Dir Both on APP & DB Servers & Set 
LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib whereafter the response to sqlplus became 
for Establishment of upto 500 Process Connections Directly on the DB Server . 

On Adding the Following Parameters to the /etc/system the Slowdown of "sqlplus" 
Connect to the Database Started Occuring after 850 Process Connections Instead of 500 
(Previously) When Executing Directly on the Database Server machine .

set tcp:tcp_conn_hash_size=262144

set rlim_fd_max=8092
set rlim_fd_cur=8092
set autoup=900
set tune_t_fsflushr=1
set bufhwm=8000

INCREASED the Semaphores to the Following Values :-

- /etc/system File on the DB & APP Servers :-

set shmsys:share_page_table=1
set maxuprc=2
set maxusers=1500

set shmsys:shminfo_shmseg=200
set shmsys:shminfo_shmmin=2
set shmsys:shminfo_shmmni=5000
set shmsys:shminfo_shmmax=25769803776
forceload: sys/shmsys
forceload: sys/shmsys
set semsys:seminfo_semmsl=1000
set semsys:seminfo_semaem=16384
set semsys:seminfo_semmap=70
set semsys:seminfo_semmni=6
set semsys:seminfo_semmns=10
set semsys:seminfo_semmnu=1
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767


Because of Increase of SEMAPHORES ( semmns to 100,000 from 20,000 ) the Slowdown of 
"sqlplus" to Establish a Connect to Database started Occuring after 1050 Process 
Connections Instead of 850 (Previously) .

We are yet to try the Settings of Reducing swapfs_minfree , noatime Option with mount 
, inode cache Hit ratio as advised Below

-Original Message-
Sent: Wednesday, March 27, 2002 12:11 AM
To: VIVEK_SHARMA
Servers

   You may need more swap.  I've had the best luck with multiple 1-Gbyte
   swap partitions on different devices.

V> After Migration from Oracle 7.3.4 to 8.1.7.2 on Solaris 2.8 sqlplus
V> becomes SLOW as the Number of Unix Users Connecting to the Database
V> Increases to about 400 whereafter even after all users are logged out
V> the response continues to be Slow even after the machine is Booted

   Some suggestions are below.  You may be spending too much time scanning
   memory for dirty pages.

If you have an application that's an incredible swap hog, or the system is
really slowing down, try adding the lines below to /etc/system and
rebooting.  I run with these settings and they've never caused me trouble.

*
* Swap
*   System keeps 1/8th of all memory for swap, which is too much for
*   a 4GB system.  Reduce that to 32 Mbytes (4096 8K pages).
set swapfs_minfree=4096
*
* Memory management
*
*   To decrease the amount of memory fsflush scans during any scan
*   interval, we must modify the kernel variable autoup.  The default
*   is 30.  For firewalls with 128MB of RAM or more, increase this
*   value.  

Re: Literal SQL and sys.dual

[Mohammed Shakir]

The programmer does not know what he has to calculate ahead of time.
The formulas are stored in the table. He takes the data out from the
table with the formula creates the string of data and operator. Then
adds:

create string:

sql_string := '1 ';
sql_string := sql_string || '+ ';
sql_string := sql_string || '1';

sql_string := 'select ' || sql_string || ' from dual;'

 result := execute immediate
   sql_string;


--- Igor Neyman <[EMAIL PROTECTED]> wrote:
> Why don't you do:
> 
> variable1 := 1+ 1;
> 
> instead of "select (1+1) into variable1 from dual"?
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>   
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 02, 2002 2:03 PM
> 
> 
> > I am working on a database optimization project. My Shared pool is
> > filled with SQL like
> > 
> > select 0 from dual;
> > select 1/1 from dual;
> > select 1 - 1/(2 + 2) from dual;
> > 
> > 
> > I tried to use the bind variables to minimize the literal SQL.
> However
> > I need a different SQL script for each case.
> > 
> > select :b1 from dual;
> > select :b1/:b2 from dual;
> > select :b1 - :b2/(:b3 + :b4) from dual;
> > 
> > first one will handle all cases for b1 from 0 to any number which
> is
> > good. And second sql will handle all the cases for any number for
> b1
> > and b2. So I do reduce the literal SQL. However, I need to know
> ahead
> > of time what type of data I am calculating and then use the
> appropriate
> > SQL.
> > 
> > I think the easy solution would be to use arithmetic. That is to
> pass
> > the string like ( 1 + 1 / (2 -2) ) to some function that can return
> me
> > the result of this sting. So I would not be using SQL script, to
> > minimize SQL execution, sys.dual contention or literal SQL filling
> > shared pool and causing both library cache and shared pool. Not to
> > mention saving in CPU processing by not parsing SQL scripts.
> > 
> > Anybody, aware of such function in PL/SQL? Is there any other way
> to do
> > calculations other than 'select 1 + 1 from dual' ?
> > 
> > I would really appreciate if you could let me know.
> > 
> > Thanks
> > 
> > Mohammed Shakir
> > 
> > =
> > Mohammed Shakir
> > CompuSoft, Inc.
> > 11 Heather Way
> > East Brunswick, NJ 08816-2825
> > (732) 672-0464 (Cell)
> > (732) 257-6001 (Home)
> > 
> > __
> > Do You Yahoo!?
> > Yahoo! Tax Center - online filing with TurboTax
> > http://http://taxes.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Mohammed Shakir
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

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

Re: One sql statement

[Ferry Situmorang]

thankyou for help.


Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 1:28 PM


> Select sum(decode(balance, 'D', amount, 0)) Db_Amt, sum(decode(balance,
'C',
> amount, 0)) Cr_Amt from ...
> HTH!
> Aleem
>
>  -Original Message-
> Sent: Tuesday, April 02, 2002 10:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: One sql statement
>
> Suppose I have table structure like this:
> amount Numeric(10)
> balance VARCHAR(1)
>
> the balance column can only have one of  'D' or 'C'
>
> I want to sum the amount of Debet and Credit on ONE SQL statement.
> How my SQL statement should be?
>
>
> Ferry Situmorang:
> Using Oracle 8.1.7 Designer 6i R4
> PT Perkebunan Nusantara XIII (Persero)
> Pontianak-Indonesia
> http://www.ptpn13.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ferry Situmorang
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Abdul Aleem
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

RE: Literal SQL and sys.dual

[Mohammed Shakir]

As usual I have inherited the code. The code is not in front of me.
Here is the psuedo code.


sql_string := '1 + 1'

sql_string := 'select ' || sql_string || ' from dual;'

Above string is passed as a parameter to a function that executes
a native dynamic sql:

 begin
   execute immediate sql_string;
 end;


Oracle executes the above query in two steps. First step is the native
dynamic sql and second part itself, and passes SQL to Oracle as:

 select 1 + 1 from dual;

And the result is 2. As complete text statement is processed.

Now comes 1 + 2 and the SQL is parsed again and that is non-shared SQL.

The problem is how in this example Oracle sees 1 + 1 as numbers. If I
use bind variable to pass 1 + 1, they are taken as text.

I agree that Programmer did not have to use sys.dual. He has a table
that indicates which record is a value and which record is a token

If token is a + he can add the value. If a token is - (minus) he can
subtract the value when he is getting the data from the table. He did
not have to create the string and pass it to dynamic sql or sys.dual to
process it. 

The programmer did not realize that he is executing this and other
statements over a million times and he will be filling up shared pool
with 11K unique (sys.dual) statements. There are 14000 statements (not
sys.dual) use literal sql filling up the shared pool. I think they are
easier to fix as they are part of either value or where clause.

I am not sure if your approach will work as I am doing the same.

Here is my test program which I believe should look similar to yours. I
have a simpler version but it is not with me right now. The results of
the programs are 0 and 1 + 1. whereas I should be getting 0 and 2. The
problem is 1 + 1 is used as string rather than numbers.

declare
l_varchar2  varchar2(50);
l_varchar_in  varchar2(50);
begin
begin
l_varchar_in := '0';
execute immediate
'begin
select :l_varchar_str into :l_varchar2
from dual;
 end;'
using l_varchar_in, OUT l_varchar2;

dbms_output.put_line(l_varchar2);
 end; 


begin
l_varchar_in := '1 + 1';  -- I will be getting them as string
execute immediate
'begin
select :l_varchar_str into :l_varchar2
from dual;
 end;'
using l_varchar_in, OUT l_varchar2;
dbms_output.put_line(l_varchar2);
 end; 
  
end;







--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> One way to calculate "select (1+1) from dual;" is "myvar := 1+1;".
> Trust me,
> it is more efficient. Most arithmetic functions can be used in
> pl/sql,
> without having to use dual.
> 
> Question for you, why do you think you need to go to database, when
> you are
> NOT accessing anything from the database?
> 
> Raj
> __
> Rajendra JamadagniMIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of
> ESPN Inc.
> 
> QOTD: Any clod can have facts, but having an opinion is an art!
> >
***1
> 
> This e-mail message is confidential, intended only for the named
> 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 ESPN at (860) 766-2000 and
> delete this e-mail message from your computer, Thank you.
> 
>
***1
> 


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

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

RE: RE: License standby database?

[Rachel Carmichael]

That's new policy. Last time I talked to Oracle about it (a while ago,
I admit) it was "if you aren't using it and the server is not
accessible, then you don't need a license"


--- "Post, Ethan" <[EMAIL PROTECTED]> wrote:
> Not sure this is correct Rachel.  I sat in a conference call today
> with some
> folks and an Oracle rep and it was stated that any type of HA
> software being
> used would require additional licenses for the all possible servers
> in the
> failover cluster.  So even if Oracle is not running on server B until
> A
> fails I would need a license for B.  Of course the whole reason for
> the call
> was to discuss Oracles "evolving" licensing model.  Can anyone else
> confirm
> or deny?
> 
> - Ethan
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 12:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> yep... but it's because the database is being used, even if you don't
> use it for read-only the fact that the executables are running
> and
> the database is mounted is why you need the license.
> 
> Now, if you have a copy of all the files, and the executables on
> another machine, but DON'T run anything, THEN you don't need another
> license
> 
> 
> --- [EMAIL PROTECTED] wrote:
> > Jon,
> > 
> > Wrong.  You must license the second server identically to the
> > original.  The
> > reason is that a standby database can be used as a read only copy
> of
> > the
> > original.
> > 
> > Dick Goulet
> > 
> > Reply Separator
> > Author: Jon Baker <[EMAIL PROTECTED]>
> > Date:   4/2/2002 8:03 AM
> > 
> > I believe as long as it is only stand-by, no additional licensing
> > required.
> > Only one system is "functional" at a time.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Dynamic create and execute procedure

[Jack C. Applewhite]

Cool!  A PL/SQL procedure that responds to your every wish!  I want one of
those too!

Seriously Gilbert, be a bit more specific about your "desirements".

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068

"Bernard, Gilbert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
30/03/2002 12:54 AM

I need to create a generic dynamic procedure to create and execute any
procedure I wish.
===

--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]




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

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

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

DBMS_STATS

[Scott Bunnett]

Hi,

I am new to using oracle and was wondering if anyone could help me out
in using the DBMS_STAT's package. Firstly, does the package need to be
installed as I am trying to run some of the subprograms but get errors
like:

execute DBMS_STATS.GATHER_TABLE_STATS( ownname=>'SCOTT',
tabname=>'user_backup', cascade=>TRUE);
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname=>'SCOTT',
tabname=>'user_backup', cascade=>TRUE); END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYSTEM.DBMS_STATS" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


Secondly, if I don't specifiy a 'stattab', the statistics are stored in
the dictionary. Where and what is this.
Sorry for the low level question, but I need to start somewhere..

Thanks
Scott

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

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

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

Re: Unix at command ???

[Brian_P_MacLean]

Try Control-D when you are done inputting your commands

Brian P. MacLean
Oracle DBA, OCP8i



   

Janet Linsy

   
hoo.com> cc:   

Sent by: Subject: Unix at command ???  

[EMAIL PROTECTED] 

om 

   

   

04/02/02 03:14 

PM 

Please respond 

to ORACLE-L

   

   





Hi all,

I'd like to run a file (r2) at 15:10 Apr 2.  Below was
what I did and I could not get out of at normally.

/export/home/oracle/test$ at 15:10 Apr 2
at> r2
at> EOF
at> 
at> 
at> EOT
at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2

I tried EOF according to the on-line doc, and also
tried EOT, but none works.  Finally I used Control Z
to get out of at.  I was out, but the script file
didn't run.

So what's the correct syntax to run the command at a
specific date, time?  Thank you!

Janet

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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




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

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

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

RE: EMC question

[Gaja Krishna Vaidyanatha]

Hi Waleed & list,

The issue I raised about "queuing" was within the
context of sequential writes to the various "stripe
units" within a striped volume. If you have a 4-way
stripe and there are 4 dirty disk blocks (1 on each
stripe unit) that needs to be written to each of the 4
disks, the LVM-mid-layer should be able to get them
down to their respective disks, independent of one
another, not one after the other. If the dirty disk
blocks are not written independent of one another,
there will be no advantage of "striping" for writes.
And "pure striping" should cater to I/O scalability
for both reads and writes.

Regards,

Gaja



--- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> HI Gaja & list,
> 
> I am trying to find the truth here! I was told by
> the storage group that EMC
> has striping now and this what I'm researching.
> 
> Gaja, what you described as a problem during WRITES
> to striped EMC is a
> typical procedure in any striped volumes.
> 
> There is a mid layer that has to map logical I/O
> addresses to physical disk
> addresses.
> 
> If you are using Veritas LVM then all reads/writes
> requests will be queued
> to the LVM and will do exactly as you mentioned.
> 
> There is a queue  but the difference is big. You
> have a queue with many
> servers serving the queue requests simultaneously.
> 
> Please check powerlink.emc.com
> 
> 
> Regards,
> 
> Waleed
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 12:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Waleed & list,
> 
> To define the terms we have on hand:-
> A contiguous meta volume requires the hyper volumes
> to
> be sequential. A non-contiguous does not require the
> hyper volumes to be sequential.
> 
> I want to reiterate again that the concept of "pure
> striping" at the hardware level, is still not there
> in
> EMC, even though you have documentation that claims
> that you do. Let me explain.
> 
> When you look at "pure striping", there are 2
> aspects
> to it :-
> 
> 1) The read aspect
> 2) The write aspect
> 
> Take an example of a 4-way striped volume. The read
> aspect provides us the capability for all 4 drives
> to
> independently spin and service I/O from each of the
> drives. This the EMC device does, after the data has
> been placed on all hypers that support a meta
> volume.
> 
> The write aspect needs to offer the same
> functionality. So, if you are writing to 4 distinct
> blocks (each on 1 disk), then each drive should be
> able to write 1 block in an independent fashion.
> 
> That is where, the EMC hardware striping is not
> complete. This is because, the 4 blocks that need to
> be written to the "meta volume" with 4 hypers
> (regardless of whether it is contiguous or not),
> will
> happen in "sequential" fashion. Meaning, to write 4
> blocks into the "striped volume", the first block
> will
> be written to the first hyper, followed by the
> second
> block to the second hyper and so on. As you can see
> the blocks that need to be written are queued up, so
> that they are written in a sequential fashion on the
> underlying hypers. This can and will cause severe
> write-intensive I/O bottlenecks.
> 
> Why is this implemented this way? No specific
> reasons,
> except, "that is how it is right now". It has been
> rumored that microcode 5x68 or 5x69, will do that.
> Remains to be seen.
> 
> So all the EMC "striping" does right now is to
> alleviate the problem of read-intensive operations
> not
> hammering a single drive, provided the data is
> spread
> across all the underlying hypers. I am not very
> familiar with the Engenuity product offering, hence
> cannot comment on that, but from what I have heard,
> it
> is a software-based volume management product.
> 
> 
> Best regards,
> 
> Gaja
> 
> --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> >  
> > It looks like it's available now.
> > 
> > This is from: ResourcePak for Windows Version 3.2
> > Product Guide 
> > 
> > "Symmetrix Microcode level 5x65 includes support
> for
> > concatenated
> > (contiguous) and striped metavolumes.
> > Noncontiguous metavolumes (including striped)
> > require EMC Enginuity(tm)
> > (5x66 microcode) or higher."
> > 
> > Regards,
> > 
> > Waleed
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L
> > Sent: 4/1/02 5:38 PM
> > 
> > Waleed & list,
> > 
> > I researched this issue recently and found out
> that
> > the meta volume was "concatenating a bunch of
> hyper
> > volume". As you know, concatenation is NOT
> striping.
> > The hyper volumes get filled with data one after
> > another, eventually giving you the "simulation of
> a
> > striped volume", when all hypers are filled with
> > data.
> > 
> > I don't know about the "single-host vs.
> multi-host"
> > addressibility issue. There are plans for
> supporting
> > "true striped volumes" in microcode level 68 or
> 69.
> > From some "reliable sources" that does not look
> like
> > it will happen any time soon. So until then, you
> > should consider crea

Re: Dynamic create and execute procedure

[Peter . McLarty]

What !!!


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=







"Bernard, Gilbert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
30/03/2002 12:54 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Fax to: 
Subject:Dynamic create and execute procedure


I need to create a generic dynamic procedure to create and execute any
procedure I wish.


 ===




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

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

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

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

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

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





-- 
This transmission is for the intended addressee only and is confidential information.  
If you have received this transmission in error, please delete it and notify the 
sender.  The contents of this e-mail are the opinion of the writer only and are not 
endorsed by the Mincom Group of companies unless expressly stated otherwise.

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

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

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

RE: Ticket tracking system

[Deshpande, Kirti]

So.. which one is the Winner ??  ;-))  

What's the volume of these tickets?
Have you considered partitioning the table for deleted tickets? 

- Kirti 

-Original Message-
Sent: Tuesday, April 02, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L


Thank you all very much for different advices.  I will give it a try.

Regards,
David

-Original Message-
Sent: Tuesday, April 02, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L


Don't delete the row(s) you'll need later.  Perhaps add a column called
ticket_status char(1), that gets a default value of 'O' (open).  When you
close the ticket change the value to 'C' (closed).  To reopen change it back
to 'O'.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 11:38 AM


> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database.  My question is how do I use SQL command to
> let people re-open a close ticket for updates?  When someone close a
ticket,
> delete command is executed and data is gone.  Please advise.
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

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

RE: Database shut itself down

[Peter . McLarty]

Hi Lisa

Just check that the files owner is who you think it should be and check 
the permissions.
A great thing NT Admins are god for is changing permissions in a directory 
at teh top of a tree and propagating it down with teh include 
subdirectories checkbox.


the OS error Access denied says either you don't have permissions on the 
file or another process is holding a file lock on it. A reboot  of teh 
server  should clear that if you cant resolve it by other means

Oh and you are right Oracle holds exclusive locks on the files at the OS 
level and as such if you try and move or delete them it won't happen


Cheers


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=







"Koivu, Lisa" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/2002 07:38 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Fax to: 
Subject:RE: Database shut itself down


I thought you couldn't delete a database file in Windows when the database
is up?  I have tried and tried to no avail. 

Maybe this is a nice 'feature' but it doesn't leave much room for testing
b&r

Lisa Koivu
Oracle Database Brick House - 36-54-36
Fairfield Resorts, Inc.
954-935-4117


> -Original Message-
> From:  John Hallas [SMTP:[EMAIL PROTECTED]]
> Sent:  Tuesday, April 02, 2002 3:53 PM
> To:Multiple recipients of list ORACLE-L
> Subject:   Re:  Database shut itself down 
> 
> Sorry to be the bearer of bad news
> That normally happens when someone has deleted the file by mistake.
> 
> Other suggestions could be that it was being archived or locked by some
> other process which inhibited Oracle from updating the file.
> 
> Has the database restarted OK.
> 
> HTH
> 
> John
> 
> -Original Message-
> Dave
> Sent: 02 April 2002 20:03
> To: Multiple recipients of list ORACLE-L
> 
> I have a 8.1.7 database running on NT 4.0 that had a problem this 
morning
> and shut itself down.  In the Alert.log I have the following error.
> 
> Tue Apr 02 10:47:40 2002
> KCF: write/open error block=0x21de online=1
>  file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write 
to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 287
> 
> 
> This is a new for me.  Any ideas what I am dealing with?
> 
> Thanks,
> 
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Hallas
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want 

Re: Unix at command ???

[Alex]

try control-C   or  a  period  or  a control-D

On Tue, 2 Apr 2002, Janet Linsy wrote:

> Hi all,
> 
> I'd like to run a file (r2) at 15:10 Apr 2.  Below was
> what I did and I could not get out of at normally.  
> 
> /export/home/oracle/test$ at 15:10 Apr 2
> at> r2
> at> EOF
> at> 
> at> 
> at> EOT
> at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2
> 
> I tried EOF according to the on-line doc, and also
> tried EOT, but none works.  Finally I used Control Z
> to get out of at.  I was out, but the script file
> didn't run.
> 
> So what's the correct syntax to run the command at a
> specific date, time?  Thank you!
> 
> Janet
> 
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Janet Linsy
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

RE: Unix at command ???

[Scott . Shafer]

Try either:

man at
 
OR 

at -f r2 -t200204021510.00

Where date is in the form:  MMDDhhmm.ss  (at least on HPUX).  This is in
the man pages (man at).

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Janet Linsy [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 4:15 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Unix at command ???
> 
> Hi all,
> 
> I'd like to run a file (r2) at 15:10 Apr 2.  Below was
> what I did and I could not get out of at normally.  
> 
> /export/home/oracle/test$ at 15:10 Apr 2
> at> r2
> at> EOF
> at> 
> at> 
> at> EOT
> at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2
> 
> I tried EOF according to the on-line doc, and also
> tried EOT, but none works.  Finally I used Control Z
> to get out of at.  I was out, but the script file
> didn't run.
> 
> So what's the correct syntax to run the command at a
> specific date, time?  Thank you!
> 
> Janet
> 
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Janet Linsy
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

Re: Unix at command ???

[Gene Sais]

i have never used at.  try cron.

>>> [EMAIL PROTECTED] 04/02/02 05:14PM >>>
Hi all,

I'd like to run a file (r2) at 15:10 Apr 2.  Below was
what I did and I could not get out of at normally.  

/export/home/oracle/test$ at 15:10 Apr 2
at> r2
at> EOF
at> 
at> 
at> EOT
at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2

I tried EOF according to the on-line doc, and also
tried EOT, but none works.  Finally I used Control Z
to get out of at.  I was out, but the script file
didn't run.

So what's the correct syntax to run the command at a
specific date, time?  Thank you!

Janet

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

RE: Cold NT backups

[Guidry, Chris]

Use XCOPY.

--
Chris J. Guidry  P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


> -Original Message-
> From: Rusnak, George A. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 06:58 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Cold NT backups
> 
> Group,
> We are doing a cold backup to a remote server. I am using OCOPY that fails
> intermittently with the following message:
> OCOPY - Insufficient disk space on target drive
> There is more than sufficient space on the drive to hold the file. I filed
> a
> TAR and was told that the error message is generic in nature and they
> could
> not tell me exactly what is failing. Can anyone PLEASE give me some
> suggestions. The file is always SYSTEM01.DBF. All the rest of the files
> copy
> across without a problem.
> TIA
> Al Rusnak
> 804-734-8453
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rusnak, George A.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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

Re: sqlplus connect too slow under load both from DB & APP Servers

[Suzy Vordos]

For some parameters, setting them to excessive values can cause
performance problems .  Consider how semaphores & shared memory
parameters should be calculated per Sun:

* shmmax = max size per shared memory segment
* shmmin = min size per shared memory segment
* shmmni = max num shared memory identifiers
* shmseg = max num shared memory segments per process
* semmns = max num semaphores system wide (=semmni*semmsl)
* semmni = max num semaphore sets system wide (=semmnu)
* semmsl = max num semaphores per semaphore set (=semopm)
* semmnu = max num sempahore undo structures (=semmni)
* semmap = max entries per semaphore map (=semmni*semmsl)
* semopm = max operations per semop call (=semmsl)
* semume = max undo entries per process
* semvmx = max value of a semaphore (cannot be > 32767)

Based on that, you might arrive at these values:

forceload: sys/shmsys
forceload: sys/semsys

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmns=4000
set semsys:seminfo_semmni=40
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmnu=40
set semsys:seminfo_semmap=4000
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767

VIVEK_SHARMA wrote:
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 9:15 AM
> To: 'Karl Vogel'; '[EMAIL PROTECTED]'
> Servers
> 
> Hi
> 
> Because of Increase of SEMAPHORES ( semmns to 100,000 from 20,000 ) the Slowdown of 
>"sqlplus" Connect to Database started Occuring after 1050 Process Connections Instead 
>of 850 (Previously) .
> 
> We are yet to try the Settings of Reducing swapfs_minfree , noatime Option with 
>mount , inode cache Hit ratio as advised by you Below . I will Revert to you .
> 
> Thanks Indeed
> 
> Vivek
> 
> -Original Message-
> Sent: Thursday, March 28, 2002 1:26 PM
> To: 'Karl Vogel'
> Servers
> 
> On Adding the Following Parameters to the /etc/system the Slowdown of "sqlplus" 
>Connect to the Database Started Occuring after 850 Process Connections Instead of 500 
>(Previously)
> 
> set tcp:tcp_conn_hash_size=262144
> 
> set rlim_fd_max=8092
> set rlim_fd_cur=8092
> set autoup=900
> set tune_t_fsflushr=1
> set bufhwm=8000
> 
> We Are Considering INCREASING the Semaphores to the Following Values :-
> 
> - /etc/system File on the DB & APP Servers :-
> 
> set shmsys:share_page_table=1
> set maxuprc=2
> set maxusers=1500
> 
> set shmsys:shminfo_shmseg=200
> set shmsys:shminfo_shmmin=2
> set shmsys:shminfo_shmmni=5000
> set shmsys:shminfo_shmmax=25769803776
> forceload: sys/shmsys
> forceload: sys/shmsys
> set semsys:seminfo_semmsl=1000
> set semsys:seminfo_semaem=16384
> set semsys:seminfo_semmap=70
> set semsys:seminfo_semmni=6
> set semsys:seminfo_semmns=10
> set semsys:seminfo_semmnu=1
> set semsys:seminfo_semume=100
> set semsys:seminfo_semvmx=32767
> 
> Thanks indeed for the Very Valuable Suggestions
> 
> Regards
> 
> Vivek
> 
> -Original Message-
> Sent: Wednesday, March 27, 2002 12:11 AM
> To: VIVEK_SHARMA
> Servers
> 
> >> On Tue, 26 Mar 2002 17:06:21 +0530,
> >> "VIVEK_SHARMA" <[EMAIL PROTECTED]> said:
> 
> V> Machine Model = E6500
> V> No. of CPUs = 20
> V> RAM = 40 GB
> V> SWAP = 4 GB
> 
>You may need more swap.  I've had the best luck with multiple 1-Gbyte
>swap partitions on different devices.
> 
> V> After Migration from Oracle 7.3.4 to 8.1.7.2 on Solaris 2.8 sqlplus
> V> becomes SLOW as the Number of Unix Users Connecting to the Database
> V> Increases to about 400 whereafter even after all users are logged out
> V> the response continues to be Slow even after the machine is Booted
> 
>Some suggestions are below.  You may be spending too much time scanning
>memory for dirty pages.
> 
> --
> Karl Vogel   ASC/YCOA, Wright-Patterson AFB, OH 45433
> [EMAIL PROTECTED]   http://www.dnaco.net/~vogelke
> 
> I am not the reincarnation of Sammy Davis Jr.
> --written on blackboard by Bart Simpson
> 
> -
> http://docs.sun.com/ab2/coll.709.2/SOLTUNEPARAMREF/
> 
>   Overview of Solaris System Tuning
> Tuning a Solaris System
> Tuning the Solaris Kernel
> Special Structures
> Viewing System Configuration Information
> kstats
>   Solaris Kernel Tunables
>   NFS Tunable Parameters
> 
> -
> If you have an application that's an incredible swap hog, or the system is
> really slowing down, try adding the lines below to /etc/system and
> rebooting.  I run with these settings and they've never caused me trouble.
> 
> *
> * Swap
> *   System keeps 1/8th of all memory for swap, which is too much for
> *   a 4GB system.  Reduce that to 32 Mbytes (4096 8K pages).
> set swapfs_minfree=4096
> *
> * Memory management
> *
> *   http://www.carumba.com/talk/random/tuning-sol

RE: EMC question

[Khedr, Waleed]

Take a look at this pdf file and search for 'microcode 5265' : 
 
http://powerlink.emc.com/MediumFreq/21108_Symmetrix_3832_Installation_Manual
.pdf?_requestid=260

Regards,

Waleed


 Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company

-Original Message-
Sent: Tuesday, April 02, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L


Waleed & list,

To define the terms we have on hand:-
A contiguous meta volume requires the hyper volumes to
be sequential. A non-contiguous does not require the
hyper volumes to be sequential.

I want to reiterate again that the concept of "pure
striping" at the hardware level, is still not there in
EMC, even though you have documentation that claims
that you do. Let me explain.

When you look at "pure striping", there are 2 aspects
to it :-

1) The read aspect
2) The write aspect

Take an example of a 4-way striped volume. The read
aspect provides us the capability for all 4 drives to
independently spin and service I/O from each of the
drives. This the EMC device does, after the data has
been placed on all hypers that support a meta volume.

The write aspect needs to offer the same
functionality. So, if you are writing to 4 distinct
blocks (each on 1 disk), then each drive should be
able to write 1 block in an independent fashion.

That is where, the EMC hardware striping is not
complete. This is because, the 4 blocks that need to
be written to the "meta volume" with 4 hypers
(regardless of whether it is contiguous or not), will
happen in "sequential" fashion. Meaning, to write 4
blocks into the "striped volume", the first block will
be written to the first hyper, followed by the second
block to the second hyper and so on. As you can see
the blocks that need to be written are queued up, so
that they are written in a sequential fashion on the
underlying hypers. This can and will cause severe
write-intensive I/O bottlenecks.

Why is this implemented this way? No specific reasons,
except, "that is how it is right now". It has been
rumored that microcode 5x68 or 5x69, will do that.
Remains to be seen.

So all the EMC "striping" does right now is to
alleviate the problem of read-intensive operations not
hammering a single drive, provided the data is spread
across all the underlying hypers. I am not very
familiar with the Engenuity product offering, hence
cannot comment on that, but from what I have heard, it
is a software-based volume management product.


Best regards,

Gaja

--- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
>  
> It looks like it's available now.
> 
> This is from: ResourcePak for Windows Version 3.2
> Product Guide 
> 
> "Symmetrix Microcode level 5x65 includes support for
> concatenated
> (contiguous) and striped metavolumes.
> Noncontiguous metavolumes (including striped)
> require EMC Enginuity(tm)
> (5x66 microcode) or higher."
> 
> Regards,
> 
> Waleed
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 4/1/02 5:38 PM
> 
> Waleed & list,
> 
> I researched this issue recently and found out that
> the meta volume was "concatenating a bunch of hyper
> volume". As you know, concatenation is NOT striping.
> The hyper volumes get filled with data one after
> another, eventually giving you the "simulation of a
> striped volume", when all hypers are filled with
> data.
> 
> I don't know about the "single-host vs. multi-host"
> addressibility issue. There are plans for supporting
> "true striped volumes" in microcode level 68 or 69.
> From some "reliable sources" that does not look like
> it will happen any time soon. So until then, you
> should consider created mirrored hyper volumes
> within
> EMC (RAID 1) and then create a striped volume using
> Veritas Volume Manager, giving you a RAID 1+0
> configuration, which is ideal.
> 
> Best regards,
> 
> Gaja
> 
> --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> > Four years ago the only hardware striping
> available
> > on EMC I was aware of
> > was RAID-S.
> > Recently researching striping ideas on EMC and was
> > told that we can achieve
> > raid0+1 hardware striping on EMC.
> > 
> > I was told that EMC has some layer called
> > meta-volume that is made of many
> > other hyper-volumes.
> > 
> > Told also that meta-volumes could be raid-0
> > (striped) and it's not a
> > single-host addressable volume.
> > 
> > Does anybody know anything about this? Can we
> really
> > get a hardware striped
> > volume using EMC? 
> > 
> > Any limitations there?
> > 
> > Thanks.
> > 
> > 
> > Waleed
> > 
> > 
> >  Any views or opinions presented in this email are
> > solely those of the
> > author and do not necessarily represent those of
> the
> > company
> > 
> > -- 



=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
http://www.osborne.com/database_erp/0072131454/0072131454.shtml

__
Do Y

Re:RE: RE: License standby database?

[dgoulet]

Dennis,

You've hit on the three constants of life, death, taxes, and Oracle's bill.
Actually I think the last causes the first.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   4/2/2002 12:33 PM

Thanks to Rachel, Dick, Jon, and everyone for clarifying this issue. 
The answer falls into a disturbing pattern I'm seeing in Oracle licensing --
lots of confusion, conflicting opinions, and in the end a large invoice from
Oracle.

I participated in a META Group teleconference this morning. A number of
press reporters participated also, so you will probably be seeing press
releases over the next few days. META offered pretty good proof that Oracle
is interpreting the named licensing to be that if your data warehouse is
being loaded with data from another system that has 200 users, then your
data warehouse needs that many named user licenses. 

-Original Message-
Sent: Tuesday, April 02, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L


yep... but it's because the database is being used, even if you don't
use it for read-only the fact that the executables are running and
the database is mounted is why you need the license.

Now, if you have a copy of all the files, and the executables on
another machine, but DON'T run anything, THEN you don't need another
license


--- [EMAIL PROTECTED] wrote:
> Jon,
> 
> Wrong.  You must license the second server identically to the
> original.  The
> reason is that a standby database can be used as a read only copy of
> the
> original.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Jon Baker <[EMAIL PROTECTED]>
> Date:   4/2/2002 8:03 AM
> 
> I believe as long as it is only stand-by, no additional licensing
> required.
> Only one system is "functional" at a time.
> 
> 
> Jon
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Can someone tell me - if you have a standby database, must you carry
> a full
> Oracle license on it? Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> 
> 
> RE: License standby database?
> 
> 
> 
> I believe as long as it is only stand-by, no
> additional
> licensing required.  Only one system is "functional"
> at a
> time.
> 
> 
> 
> Jon
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: DENNIS WILLIAMS [
HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: License standby database?
> 
> 
> 
> Can someone tell me - if you have a standby database,
> must you
> carry a full
> Oracle license on it? Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:  HREF="http://www.orafaq.com";
> TARGET="_blank">http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> 
> Fat City Network Services    -- (858)
> 538-5051  FAX: (858) 538-5051
> San Diego,
> California   
> -- Public Internet access / Mailing Lists
> 
SIZE=2><
/FON
> T>
> To REMOVE yourself from this mailing list, send an
> E-Mail
> message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like
> subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

who compiled this proc

[Big Planet]

How to find which database user and ip-address 
compiled this stored proc ?
 
-Bp

Unix at command ???

[Janet Linsy]

Hi all,

I'd like to run a file (r2) at 15:10 Apr 2.  Below was
what I did and I could not get out of at normally.  

/export/home/oracle/test$ at 15:10 Apr 2
at> r2
at> EOF
at> 
at> 
at> EOT
at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2

I tried EOF according to the on-line doc, and also
tried EOT, but none works.  Finally I used Control Z
to get out of at.  I was out, but the script file
didn't run.

So what's the correct syntax to run the command at a
specific date, time?  Thank you!

Janet

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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

RE: Ticket tracking system

[Post, Ethan]

I better refrain from kidding in the future... :)

Solution 5 was...

5. Get an infinite number of monkeys to type on an infinite number of
keyboards opening an infinite number of tickets, eventually the correct
ticket will be opened up.  Don't place your redo logs on RAID 5 devices,
this could cause a bottleneck during this period.

- E

-Original Message-
Sent: Tuesday, April 02, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L


Solution 4 is not dumb.  We use it frequently - it allows retrieval of
tickets "marked as closed" as well as providing a bit of history for the
ticket.  If you use this technique, David, you must keep in mind that sooner
or later you must actually "delete" the old closed tickets.  We generally
set up a purge schedule that removes any closed items after they reach a
certain age limit.  We also have an archive schedule that places a copy of
any changed item on CD-ROM on a daily interval.  This allows us to retrieve
any ticket, if necessary - though it requires operator intervention to
reload the ticket.

- Ron

> -Original Message-
> From: Post, Ethan [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 4:08 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Ticket tracking system
> 
> Manager to David...
> 
> "David, this is your manager speaking.  Larry says he opened 10 tickets
> last
> month to get the Brady report fixed.  Is that true?"
> 
> ok enough of that let's ponder some possible solutions...
> 
> 1. Have everyone print out a copy of their ticket and then submit it back
> to
> you to re-enter if they want to re-open it.
> 2. Use log miner to log your archive logs.  Find the SQL to recreate the
> ticket then run it again against the database.
> 3. This one is really just a better idea for #1...have everyone do a print
> screen of each ticket then create a database that allows people to upload
> the picture of the ticket.  Save those and you can refer to them if you
> need
> to re-create a ticket.
> 4. This last solution is really dumb but also might work...instead of
> deleting the record perhaps you could just add a status column to the
> table
> and then mark it as closed.  Then you could re-open it using an update
> statement.  
> 
> - Ethan
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database.  My question is how do I use SQL command to
> let people re-open a close ticket for updates?  When someone close a
> ticket,
> delete command is executed and data is gone.  Please advise.
> 
> Thanks,
> David
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Morton, Ronald D
  INET: [EMAIL PROTECTED]

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

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

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

8.0.5 --> 8.1.7 apps upgrade

[Fedock, John (KAM.RHQ)]

Looking into how to do this.

The 8.0.5 database is on NT.  The 8.1.7 is on Windows2000.

I thought I could:
- shut down database on 8.0.5 (on NT)
- copy datafiles to windows 2000 server.
- start 8.1.7 service on windows2000 server
- run cat08005.sql scripts on windows2000 server
- finish other tasks
This way I could move the database and upgrade in 1 step.  Oracle is saying
I cannot do it this way.  They are stating I must  Migrate the Database from
805 to 817 on a Supported Platform and THEN move the database from one
machine to another. To do this, I will then have to install 8.1.7 on my
current production server (NT), do the upgrade and then move the database to
the new windows2000 server.   
Is there a better way?

Thanks in advance.

John Fedock
"K" Line America, Inc.
[EMAIL PROTECTED]
www.kline.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fedock, John (KAM.RHQ)
  INET: [EMAIL PROTECTED]

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

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

RE: Ticket tracking system

[Morton, Ronald D]

Solution 4 is not dumb.  We use it frequently - it allows retrieval of
tickets "marked as closed" as well as providing a bit of history for the
ticket.  If you use this technique, David, you must keep in mind that sooner
or later you must actually "delete" the old closed tickets.  We generally
set up a purge schedule that removes any closed items after they reach a
certain age limit.  We also have an archive schedule that places a copy of
any changed item on CD-ROM on a daily interval.  This allows us to retrieve
any ticket, if necessary - though it requires operator intervention to
reload the ticket.

- Ron

> -Original Message-
> From: Post, Ethan [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 4:08 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Ticket tracking system
> 
> Manager to David...
> 
> "David, this is your manager speaking.  Larry says he opened 10 tickets
> last
> month to get the Brady report fixed.  Is that true?"
> 
> ok enough of that let's ponder some possible solutions...
> 
> 1. Have everyone print out a copy of their ticket and then submit it back
> to
> you to re-enter if they want to re-open it.
> 2. Use log miner to log your archive logs.  Find the SQL to recreate the
> ticket then run it again against the database.
> 3. This one is really just a better idea for #1...have everyone do a print
> screen of each ticket then create a database that allows people to upload
> the picture of the ticket.  Save those and you can refer to them if you
> need
> to re-create a ticket.
> 4. This last solution is really dumb but also might work...instead of
> deleting the record perhaps you could just add a status column to the
> table
> and then mark it as closed.  Then you could re-open it using an update
> statement.  
> 
> - Ethan
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database.  My question is how do I use SQL command to
> let people re-open a close ticket for updates?  When someone close a
> ticket,
> delete command is executed and data is gone.  Please advise.
> 
> Thanks,
> David
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Morton, Ronald D
  INET: [EMAIL PROTECTED]

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

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

RE: Ticket tracking system

[Nguyen, David M]

Thank you all very much for different advices.  I will give it a try.

Regards,
David

-Original Message-
Sent: Tuesday, April 02, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L


Don't delete the row(s) you'll need later.  Perhaps add a column called
ticket_status char(1), that gets a default value of 'O' (open).  When you
close the ticket change the value to 'C' (closed).  To reopen change it back
to 'O'.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 11:38 AM


> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database.  My question is how do I use SQL command to
> let people re-open a close ticket for updates?  When someone close a
ticket,
> delete command is executed and data is gone.  Please advise.
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: Database shut itself down

[Koivu, Lisa]

I thought you couldn't delete a database file in Windows when the database
is up?  I have tried and tried to no avail.  

Maybe this is a nice 'feature' but it doesn't leave much room for testing
b&r

Lisa Koivu
Oracle Database Brick House - 36-54-36
Fairfield Resorts, Inc.
954-935-4117


> -Original Message-
> From: John Hallas [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 3:53 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re:  Database shut itself down 
> 
> Sorry to be the bearer of bad news
> That normally happens when someone has deleted the file by mistake.
> 
> Other suggestions could be that it was being archived or locked by some
> other process which inhibited Oracle from updating the file.
> 
> Has the database restarted OK.
> 
> HTH
> 
> John
> 
> -Original Message-
> Dave
> Sent: 02 April 2002 20:03
> To: Multiple recipients of list ORACLE-L
> 
> I have a 8.1.7 database running on NT 4.0 that had a problem this morning
> and shut itself down.  In the Alert.log I have the following error.
> 
> Tue Apr 02 10:47:40 2002
> KCF: write/open error block=0x21de online=1
>  file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 287
> 
> 
> This is a new for me.  Any ideas what I am dealing with?
> 
> Thanks,
> 
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Hallas
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

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

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

RE: Ticket tracking system

[Post, Ethan]

Manager to David...

"David, this is your manager speaking.  Larry says he opened 10 tickets last
month to get the Brady report fixed.  Is that true?"

ok enough of that let's ponder some possible solutions...

1. Have everyone print out a copy of their ticket and then submit it back to
you to re-enter if they want to re-open it.
2. Use log miner to log your archive logs.  Find the SQL to recreate the
ticket then run it again against the database.
3. This one is really just a better idea for #1...have everyone do a print
screen of each ticket then create a database that allows people to upload
the picture of the ticket.  Save those and you can refer to them if you need
to re-create a ticket.
4. This last solution is really dumb but also might work...instead of
deleting the record perhaps you could just add a status column to the table
and then mark it as closed.  Then you could re-open it using an update
statement.  

- Ethan

-Original Message-
Sent: Tuesday, April 02, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L


I develope a ticket database for people to open, close, re-open ticket to
update using oracle database.  My question is how do I use SQL command to
let people re-open a close ticket for updates?  When someone close a ticket,
delete command is executed and data is gone.  Please advise.

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

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

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

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

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

Re: Literal SQL and sys.dual

[Igor Neyman]

Why don't you do:

variable1 := 1+ 1;

instead of "select (1+1) into variable1 from dual"?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 2:03 PM


> I am working on a database optimization project. My Shared pool is
> filled with SQL like
> 
> select 0 from dual;
> select 1/1 from dual;
> select 1 - 1/(2 + 2) from dual;
> 
> 
> I tried to use the bind variables to minimize the literal SQL. However
> I need a different SQL script for each case.
> 
> select :b1 from dual;
> select :b1/:b2 from dual;
> select :b1 - :b2/(:b3 + :b4) from dual;
> 
> first one will handle all cases for b1 from 0 to any number which is
> good. And second sql will handle all the cases for any number for b1
> and b2. So I do reduce the literal SQL. However, I need to know ahead
> of time what type of data I am calculating and then use the appropriate
> SQL.
> 
> I think the easy solution would be to use arithmetic. That is to pass
> the string like ( 1 + 1 / (2 -2) ) to some function that can return me
> the result of this sting. So I would not be using SQL script, to
> minimize SQL execution, sys.dual contention or literal SQL filling
> shared pool and causing both library cache and shared pool. Not to
> mention saving in CPU processing by not parsing SQL scripts.
> 
> Anybody, aware of such function in PL/SQL? Is there any other way to do
> calculations other than 'select 1 + 1 from dual' ?
> 
> I would really appreciate if you could let me know.
> 
> Thanks
> 
> Mohammed Shakir
> 
> =
> Mohammed Shakir
> CompuSoft, Inc.
> 11 Heather Way
> East Brunswick, NJ 08816-2825
> (732) 672-0464 (Cell)
> (732) 257-6001 (Home)
> 
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://http://taxes.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohammed Shakir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

sqlplus connect too slow under load both from DB & APP Servers

[VIVEK_SHARMA]

-Original Message-
Sent: Tuesday, April 02, 2002 9:15 AM
To: 'Karl Vogel'; '[EMAIL PROTECTED]'
Servers


Hi

Because of Increase of SEMAPHORES ( semmns to 100,000 from 20,000 ) the Slowdown of 
"sqlplus" Connect to Database started Occuring after 1050 Process Connections Instead 
of 850 (Previously) .

We are yet to try the Settings of Reducing swapfs_minfree , noatime Option with mount 
, inode cache Hit ratio as advised by you Below . I will Revert to you .

Thanks Indeed

Vivek


-Original Message-
Sent: Thursday, March 28, 2002 1:26 PM
To: 'Karl Vogel'
Servers



On Adding the Following Parameters to the /etc/system the Slowdown of "sqlplus" 
Connect to the Database Started Occuring after 850 Process Connections Instead of 500 
(Previously)

set tcp:tcp_conn_hash_size=262144

set rlim_fd_max=8092
set rlim_fd_cur=8092
set autoup=900
set tune_t_fsflushr=1
set bufhwm=8000

We Are Considering INCREASING the Semaphores to the Following Values :-

- /etc/system File on the DB & APP Servers :-

set shmsys:share_page_table=1
set maxuprc=2
set maxusers=1500

set shmsys:shminfo_shmseg=200
set shmsys:shminfo_shmmin=2
set shmsys:shminfo_shmmni=5000
set shmsys:shminfo_shmmax=25769803776
forceload: sys/shmsys
forceload: sys/shmsys
set semsys:seminfo_semmsl=1000
set semsys:seminfo_semaem=16384
set semsys:seminfo_semmap=70
set semsys:seminfo_semmni=6
set semsys:seminfo_semmns=10
set semsys:seminfo_semmnu=1
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767


Thanks indeed for the Very Valuable Suggestions 

Regards

Vivek



-Original Message-
Sent: Wednesday, March 27, 2002 12:11 AM
To: VIVEK_SHARMA
Servers


>> On Tue, 26 Mar 2002 17:06:21 +0530, 
>> "VIVEK_SHARMA" <[EMAIL PROTECTED]> said:

V> Machine Model = E6500
V> No. of CPUs = 20
V> RAM = 40 GB
V> SWAP = 4 GB

   You may need more swap.  I've had the best luck with multiple 1-Gbyte
   swap partitions on different devices.

V> After Migration from Oracle 7.3.4 to 8.1.7.2 on Solaris 2.8 sqlplus
V> becomes SLOW as the Number of Unix Users Connecting to the Database
V> Increases to about 400 whereafter even after all users are logged out
V> the response continues to be Slow even after the machine is Booted

   Some suggestions are below.  You may be spending too much time scanning
   memory for dirty pages.

-- 
Karl Vogel   ASC/YCOA, Wright-Patterson AFB, OH 45433
[EMAIL PROTECTED]   http://www.dnaco.net/~vogelke

I am not the reincarnation of Sammy Davis Jr.
--written on blackboard by Bart Simpson

-
http://docs.sun.com/ab2/coll.709.2/SOLTUNEPARAMREF/

  Overview of Solaris System Tuning 
Tuning a Solaris System 
Tuning the Solaris Kernel 
Special Structures 
Viewing System Configuration Information 
kstats 
  Solaris Kernel Tunables 
  NFS Tunable Parameters 

-
If you have an application that's an incredible swap hog, or the system is
really slowing down, try adding the lines below to /etc/system and
rebooting.  I run with these settings and they've never caused me trouble.

*
* Swap
*   System keeps 1/8th of all memory for swap, which is too much for
*   a 4GB system.  Reduce that to 32 Mbytes (4096 8K pages).
set swapfs_minfree=4096
*
* Memory management
*
*   http://www.carumba.com/talk/random/tuning-solaris-checkpoint.txt
*   Tuning Solaris for FireWall-1
*   Rob Thomas [EMAIL PROTECTED]
*   14 Aug 2000
*
*   On firewalls, it is not at all uncommon to have quite a bit of
*   physical memory.  However, as the amount of physical memory is
*   increased, the amount of time the kernel spends managing that
*   memory also increases.  During periods of high load, this may
*   decrease throughput.
*
*   To decrease the amount of memory fsflush scans during any scan
*   interval, we must modify the kernel variable autoup.  The default
*   is 30.  For firewalls with 128MB of RAM or more, increase this
*   value.  The end result is less time spent managing buffers,
*   and more time spent servicing packets.
set autoup = 120

-

Run "mount" to see how your filesystems are set up.  You can mount
filesystems with "noatime" turned on, meaning don't bother updating the
access time whenever a file is opened.  We use this under Solaris-8,
and it makes a *huge* difference if you're doing something to a large
number of small or medium sized files.

Check the size of your inode caches, which keep track of
previously-accessed files.  Run the DNLC script below as root to see your
hit-rate percentage.  If it's under 90-95%, you need to up the cache size.
The easiest way to do that is setting maxusers in /etc/system to something
like 2048.

---
#!/bin/sh

RE: Literal SQL and sys.dual

[Jamadagni, Rajendra]

One way to calculate "select (1+1) from dual;" is "myvar := 1+1;". Trust me,
it is more efficient. Most arithmetic functions can be used in pl/sql,
without having to use dual.

Question for you, why do you think you need to go to database, when you are
NOT accessing anything from the database?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


***1

This e-mail message is confidential, intended only for the named 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 ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

RE: Seeking opinions

[Freeman, Robert]

It's been a while since I've been an admin guy but let me try...

Every file, directory, etc... on a file system is represented by an inode on
the file system. Think of an inode (in a simple term) as another file or a
pointer
if you will. It contains information on that structure (rights, who owns it,
the time stamp for the file, and so on...) The data block addresses that
are assigned to the file are contained in the inode. The OS then uses the
inode to locate the file or directory  and to store information on the file
or directory.

It is possible for that inode to become corrupted (e.g. system
crash) and I've seen 2 cases of it in the 15 years I've been doing this
(both on SCO Unix). 
File systems that journal seem to be safer, and I've never seen it happen on
such a file system
but that doesn't mean it can't happen!. I've read cases of OS bugs on
earlier AIX
versions that could cause Inode corruption in specific cases, but I've never
experienced
the problem in AIX or SUN. Corruption of an inode can lead to loss of
directories or data files,
and therefore I like to limit the size of directories based on a number of
factors, such
as MTTR one directory, the SLA that I have with the customer and so on. 

So, by keeping my redo, control files and datafiles in separate dirs under
/u0x, I reduce the likelihood of inode corruption a bit, but it is still
there
in the form of /u0x or the other directories falling below it.

HTH 

RF


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Tuesday, April 02, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


Robert,

Tell me a little more about potential for inode corruption and how this
helps?  Never heard of that one before.  I stick it all in
/x/oradata/$ORACLE_SID and distinguish my files by .dbf, .ctl, .arc and
.rdo.  Also are yall mostly Oracle or are you running anything else?

- Ethan

-Original Message-
Sent: Tuesday, April 02, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L


This is hogwash. OFA perfectly helps to separate the datafiles from
different 
database instances. We run well over 300+ Oracle databases here and the ONLY
extension we have to OFA is that I add a /data /control and /redo directory
to the file systems for just a little extra protection from possible inode
corruption.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

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

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

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

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

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

Re: Ticket tracking system

[Igor Neyman]

Don't "delete".
Just mark it as "closed".

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 2:38 PM


> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database.  My question is how do I use SQL command to
> let people re-open a close ticket for updates?  When someone close a
ticket,
> delete command is executed and data is gone.  Please advise.
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Ticket tracking system

[Greg Moore]

Don't delete the row(s) you'll need later.  Perhaps add a column called
ticket_status char(1), that gets a default value of 'O' (open).  When you
close the ticket change the value to 'C' (closed).  To reopen change it back
to 'O'.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 11:38 AM


> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database.  My question is how do I use SQL command to
> let people re-open a close ticket for updates?  When someone close a
ticket,
> delete command is executed and data is gone.  Please advise.
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Data Warehouse Tools

[lembark]

-- [EMAIL PROTECTED] on 04/02/02 12:03:27 -0800

> Hi All -
> This is for DBAs who have participated in a DW project: what kind of tools
> did you use for design, ETL, Query etc. I know Oracle has a data warehouse
> builder but it doesn't seem to be widely used. What is the most popular
> tools out there for DW construction and what is the trend?

Most of the ETL I design is done with Ab Initio, less often
Informatica. Ab Initio is the best tool going for scaleable
parallel processing and distribution across multiple nodes;
Informatica has some advantages with lower throughput and 
messier metadata; its licensing is also simpler.

I tend to use Red Brick for data warehousing. Main reasons
are offline loading of data, star and target indexes and 
much simpler data management -- mainly due to lack of rollback
processing and ability to add phyisical storage without 
effecting data access. 

Now that Oracle at least has partitioning it gets more usable
for warehousing but still needs too much care and feeding,
and doesn't support offline loads. For clickstream processing
Oracle with partitioning is a nice combination.

In either case, DBI seems to be the most portable way to talk
to various databases, especially for combining data from multiple
sources (e.g., feeding selection criteria back from a Red Brick
warehouse to an Oracle OLTP system).

enjoi.


--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

Re: Literal SQL and sys.dual

[Stephane Faroult]

Mohammed Shakir wrote:
> 
> I am working on a database optimization project. My Shared pool is
> filled with SQL like
> 
> select 0 from dual;
> select 1/1 from dual;
> select 1 - 1/(2 + 2) from dual;
> 
> I tried to use the bind variables to minimize the literal SQL. However
> I need a different SQL script for each case.
> 
> select :b1 from dual;
> select :b1/:b2 from dual;
> select :b1 - :b2/(:b3 + :b4) from dual;
> 
> first one will handle all cases for b1 from 0 to any number which is
> good. And second sql will handle all the cases for any number for b1
> and b2. So I do reduce the literal SQL. However, I need to know ahead
> of time what type of data I am calculating and then use the appropriate
> SQL.
> 
> I think the easy solution would be to use arithmetic. That is to pass
> the string like ( 1 + 1 / (2 -2) ) to some function that can return me
> the result of this sting. So I would not be using SQL script, to
> minimize SQL execution, sys.dual contention or literal SQL filling
> shared pool and causing both library cache and shared pool. Not to
> mention saving in CPU processing by not parsing SQL scripts.
> 
> Anybody, aware of such function in PL/SQL? Is there any other way to do
> calculations other than 'select 1 + 1 from dual' ?
> 
> I would really appreciate if you could let me know.
> 
> Thanks
> 
> Mohammed Shakir
> 
> =
> Mohammed Shakir
> CompuSoft, Inc.
> 11 Heather Way
> East Brunswick, NJ 08816-2825
> (732) 672-0464 (Cell)
> (732) 257-6001 (Home)
> 

Mohammed,

  Don't you think, before starting with a PL/SQL function of death, that
it *might* be easier to check the code and see where these statements,
which are unlikely to be functional requirements, are used? Rewriting
the PL/SQL code around them is probably the most efficient way to get
rid of them.

-- 
Regards,

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

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

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

Re: Database shut itself down

[John Hallas]

Sorry to be the bearer of bad news
That normally happens when someone has deleted the file by mistake.

Other suggestions could be that it was being archived or locked by some
other process which inhibited Oracle from updating the file.

Has the database restarted OK.

HTH

John

-Original Message-
Dave
Sent: 02 April 2002 20:03
To: Multiple recipients of list ORACLE-L

I have a 8.1.7 database running on NT 4.0 that had a problem this morning
and shut itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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

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

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

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

Re: Ticket tracking system

[Peter Gram]

David

Don't use delete use a update to mark the row deleted. This has the 
advantaged that it is possible to track what happened to a ticket (call 
it journal or history)

Nguyen, David M wrote:

>I develope a ticket database for people to open, close, re-open ticket to
>update using oracle database.  My question is how do I use SQL command to
>let people re-open a close ticket for updates?  When someone close a ticket,
>delete command is executed and data is gone.  Please advise.
>
>Thanks,
>David
>

-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk




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

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

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

Re: Database shut itself down

[tday6]

Check and see if your J disk is full.  On your Win2k desktop, find the "My
Computer" icon.  Right click and choose "explore".  Find the J drive and
right click; choose "properties".  If the disk is full, that's your
problem.

On the other hand, a J drive could be a network mounted drive.  If it is,
there may be a timing issue.  Oracle does not normally support network
mounted drives.




   

"Farnsworth,   

Dave"To: Multiple recipients of list ORACLE-L  



@Ashleyfurnitcc:   

ure.com> Subject: Database shut itself down

Sent by: root  

   

   

04/02/2002 

02:03 PM   

Please 

respond to 

ORACLE-L   

   

   





I have a 8.1.7 database running on NT 4.0 that had a problem this morning
and shut itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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



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

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

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

RE: Ticket tracking system

[Jamadagni, Rajendra]

Instead of deleting, set a flag which indicated the ticket is open or
closed.

I believe you or someone else asked the same question a few weeks ago and
received a similar answer (as above).

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-
Sent: Tuesday, April 02, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L


I develope a ticket database for people to open, close, re-open ticket to
update using oracle database.  My question is how do I use SQL command to
let people re-open a close ticket for updates?  When someone close a ticket,
delete command is executed and data is gone.  Please advise.

Thanks,
David


***1

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 ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

RE: Ticket tracking system

[Jesse, Rich]

Perhaps put a trigger on the ticket table that will insert a row into
another table, which can then be queried from your app?

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


> -Original Message-
> From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Ticket tracking system
> 
> 
> I develope a ticket database for people to open, close, 
> re-open ticket to
> update using oracle database.  My question is how do I use 
> SQL command to
> let people re-open a close ticket for updates?  When someone 
> close a ticket,
> delete command is executed and data is gone.  Please advise.
> 
> Thanks,
> David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Database shut itself down

[Gogala, Mladen]

You are dealing with a problem. From here (Trumbull, CT) it looks
that your problem is lack of permission to write to the database files
or the files that reside on a remote drive (mounted through the network),
which is a big no-no that you should be aware of.

> -Original Message-
> From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 2:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Database shut itself down 
> 
> 
> I have a 8.1.7 database running on NT 4.0 that had a problem 
> this morning and shut itself down.  In the Alert.log I 
> have the following error.
> 
> Tue Apr 02 10:47:40 2002
> KCF: write/open error block=0x21de online=1
>  file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile() failure, unable 
> to write to file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 287
> 
> 
> This is a new for me.  Any ideas what I am dealing with?
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

RE: RE: License standby database?

[Post, Ethan]

Not sure this is correct Rachel.  I sat in a conference call today with some
folks and an Oracle rep and it was stated that any type of HA software being
used would require additional licenses for the all possible servers in the
failover cluster.  So even if Oracle is not running on server B until A
fails I would need a license for B.  Of course the whole reason for the call
was to discuss Oracles "evolving" licensing model.  Can anyone else confirm
or deny?

- Ethan

-Original Message-
Sent: Tuesday, April 02, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L


yep... but it's because the database is being used, even if you don't
use it for read-only the fact that the executables are running and
the database is mounted is why you need the license.

Now, if you have a copy of all the files, and the executables on
another machine, but DON'T run anything, THEN you don't need another
license


--- [EMAIL PROTECTED] wrote:
> Jon,
> 
> Wrong.  You must license the second server identically to the
> original.  The
> reason is that a standby database can be used as a read only copy of
> the
> original.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Jon Baker <[EMAIL PROTECTED]>
> Date:   4/2/2002 8:03 AM
> 
> I believe as long as it is only stand-by, no additional licensing
> required.
> Only one system is "functional" at a time.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

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

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

RE: EMC question

[Khedr, Waleed]

HI Gaja & list,

I am trying to find the truth here! I was told by the storage group that EMC
has striping now and this what I'm researching.

Gaja, what you described as a problem during WRITES to striped EMC is a
typical procedure in any striped volumes.

There is a mid layer that has to map logical I/O addresses to physical disk
addresses.

If you are using Veritas LVM then all reads/writes requests will be queued
to the LVM and will do exactly as you mentioned.

There is a queue  but the difference is big. You have a queue with many
servers serving the queue requests simultaneously.

Please check powerlink.emc.com


Regards,

Waleed

-Original Message-
Sent: Tuesday, April 02, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L


Waleed & list,

To define the terms we have on hand:-
A contiguous meta volume requires the hyper volumes to
be sequential. A non-contiguous does not require the
hyper volumes to be sequential.

I want to reiterate again that the concept of "pure
striping" at the hardware level, is still not there in
EMC, even though you have documentation that claims
that you do. Let me explain.

When you look at "pure striping", there are 2 aspects
to it :-

1) The read aspect
2) The write aspect

Take an example of a 4-way striped volume. The read
aspect provides us the capability for all 4 drives to
independently spin and service I/O from each of the
drives. This the EMC device does, after the data has
been placed on all hypers that support a meta volume.

The write aspect needs to offer the same
functionality. So, if you are writing to 4 distinct
blocks (each on 1 disk), then each drive should be
able to write 1 block in an independent fashion.

That is where, the EMC hardware striping is not
complete. This is because, the 4 blocks that need to
be written to the "meta volume" with 4 hypers
(regardless of whether it is contiguous or not), will
happen in "sequential" fashion. Meaning, to write 4
blocks into the "striped volume", the first block will
be written to the first hyper, followed by the second
block to the second hyper and so on. As you can see
the blocks that need to be written are queued up, so
that they are written in a sequential fashion on the
underlying hypers. This can and will cause severe
write-intensive I/O bottlenecks.

Why is this implemented this way? No specific reasons,
except, "that is how it is right now". It has been
rumored that microcode 5x68 or 5x69, will do that.
Remains to be seen.

So all the EMC "striping" does right now is to
alleviate the problem of read-intensive operations not
hammering a single drive, provided the data is spread
across all the underlying hypers. I am not very
familiar with the Engenuity product offering, hence
cannot comment on that, but from what I have heard, it
is a software-based volume management product.


Best regards,

Gaja

--- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
>  
> It looks like it's available now.
> 
> This is from: ResourcePak for Windows Version 3.2
> Product Guide 
> 
> "Symmetrix Microcode level 5x65 includes support for
> concatenated
> (contiguous) and striped metavolumes.
> Noncontiguous metavolumes (including striped)
> require EMC Enginuity(tm)
> (5x66 microcode) or higher."
> 
> Regards,
> 
> Waleed
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 4/1/02 5:38 PM
> 
> Waleed & list,
> 
> I researched this issue recently and found out that
> the meta volume was "concatenating a bunch of hyper
> volume". As you know, concatenation is NOT striping.
> The hyper volumes get filled with data one after
> another, eventually giving you the "simulation of a
> striped volume", when all hypers are filled with
> data.
> 
> I don't know about the "single-host vs. multi-host"
> addressibility issue. There are plans for supporting
> "true striped volumes" in microcode level 68 or 69.
> From some "reliable sources" that does not look like
> it will happen any time soon. So until then, you
> should consider created mirrored hyper volumes
> within
> EMC (RAID 1) and then create a striped volume using
> Veritas Volume Manager, giving you a RAID 1+0
> configuration, which is ideal.
> 
> Best regards,
> 
> Gaja
> 
> --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> > Four years ago the only hardware striping
> available
> > on EMC I was aware of
> > was RAID-S.
> > Recently researching striping ideas on EMC and was
> > told that we can achieve
> > raid0+1 hardware striping on EMC.
> > 
> > I was told that EMC has some layer called
> > meta-volume that is made of many
> > other hyper-volumes.
> > 
> > Told also that meta-volumes could be raid-0
> > (striped) and it's not a
> > single-host addressable volume.
> > 
> > Does anybody know anything about this? Can we
> really
> > get a hardware striped
> > volume using EMC? 
> > 
> > Any limitations there?
> > 
> > Thanks.
> > 
> > 
> > Waleed
> > 
> > 
> >  Any views or opinions presented in this email are
> > solely those of the
> > author

Re: Database shut itself down

[Stephen Andert]

Dave,
 
Maybe I'm way off base here, but it looks like there is some 
problem at the OS level.  Is that file still there and 
writable?
 
Stephen
>>> [EMAIL PROTECTED] 04/02/02 12:03PM 
>>>I have a 8.1.7 database running on NT 4.0 that had a problem 
this morning and shut itself down.  In the Alert.log I have the 
following error.Tue Apr 02 10:47:40 2002KCF: write/open error 
block=0x21de online=1 file=10 
J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF 
error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to 
fileO/S-Error: (OS 5) Access is denied.'DBW0: terminating instance due 
to error 1242Instance terminated by DBW0, pid = 287This is a new 
for me.  Any ideas what I am dealing 
with?Thanks,Dave--Please see the official ORACLE-L FAQ: 
http://www.orafaq.com--Author: 
Farnsworth, Dave  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
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: Database shut itself down

[Ray Stell]

On Tue, Apr 02, 2002 at 11:03:21AM -0800, Farnsworth, Dave wrote:
> I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut 
>itself down.  In the Alert.log I have the following error.
> 
> Tue Apr 02 10:47:40 2002
> KCF: write/open error block=0x21de online=1
>  file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
>  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file


Dr. Steve Adams says: 

This is a reasonably well known problem on NT. Generally the error is
seen when a routine NT file system backup takes a byte-range lock on
one of the Oracle datafiles in that file system in order to back it up.
There are many solutions, such as configuring the backup software to
skip open files, or at least not to lock them; or you can use ocopy to
copy the datafiles and back those up instead; or you can shutdown the
instance; and so on.



> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 287
> 
> 
> This is a new for me.  Any ideas what I am dealing with?
> 
> Thanks,
> 
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

Re: Ticket tracking system

[Gene Sais]

use the undelete command :)


>>> [EMAIL PROTECTED] 04/02/02 02:38PM >>>
I develope a ticket database for people to open, close, re-open ticket to
update using oracle database.  My question is how do I use SQL command to
let people re-open a close ticket for updates?  When someone close a ticket,
delete command is executed and data is gone.  Please advise.

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

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

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

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

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

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

RE: RE: License standby database?

[DENNIS WILLIAMS]

Thanks to Rachel, Dick, Jon, and everyone for clarifying this issue. 
The answer falls into a disturbing pattern I'm seeing in Oracle licensing --
lots of confusion, conflicting opinions, and in the end a large invoice from
Oracle.

I participated in a META Group teleconference this morning. A number of
press reporters participated also, so you will probably be seeing press
releases over the next few days. META offered pretty good proof that Oracle
is interpreting the named licensing to be that if your data warehouse is
being loaded with data from another system that has 200 users, then your
data warehouse needs that many named user licenses. 

-Original Message-
Sent: Tuesday, April 02, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L


yep... but it's because the database is being used, even if you don't
use it for read-only the fact that the executables are running and
the database is mounted is why you need the license.

Now, if you have a copy of all the files, and the executables on
another machine, but DON'T run anything, THEN you don't need another
license


--- [EMAIL PROTECTED] wrote:
> Jon,
> 
> Wrong.  You must license the second server identically to the
> original.  The
> reason is that a standby database can be used as a read only copy of
> the
> original.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Jon Baker <[EMAIL PROTECTED]>
> Date:   4/2/2002 8:03 AM
> 
> I believe as long as it is only stand-by, no additional licensing
> required.
> Only one system is "functional" at a time.
> 
> 
> Jon
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Can someone tell me - if you have a standby database, must you carry
> a full
> Oracle license on it? Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> 
> 
> RE: License standby database?
> 
> 
> 
> I believe as long as it is only stand-by, no
> additional
> licensing required.  Only one system is "functional"
> at a
> time.
> 
> 
> 
> Jon
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: DENNIS WILLIAMS [
HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: License standby database?
> 
> 
> 
> Can someone tell me - if you have a standby database,
> must you
> carry a full
> Oracle license on it? Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:  HREF="http://www.orafaq.com";
> TARGET="_blank">http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> 
> Fat City Network Services    -- (858)
> 538-5051  FAX: (858) 538-5051
> San Diego,
> California   
> -- Public Internet access / Mailing Lists
> 
SIZE=2><
/FON
> T>
> To REMOVE yourself from this mailing list, send an
> E-Mail
> message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like
> subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City 

Re: Database shut itself down - FIXED

[Igor Neyman]

Did the original problem happened after you started the database?
If that's the case, is it possible, that the file in question was opened by
some other application at the time you were starting the database?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 2:48 PM


I had to do a

STARTUP MOUNT
RECOVER DATABASE

That fixed it and I'm back up and running.

Thanks,

Dave

-Original Message-
Sent: Tuesday, April 02, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


I have a 8.1.7 database running on NT 4.0 that had a problem this morning
and shut itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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

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

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

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

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

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

Re: Database shut itself down

[Peter Gram]

Dave

Oracle had a problem with written to the file 
J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF this was happened because
Oracle did not have proper permission in NT to write to the file. There 
are many reasons that could give this problem

1) the file was in shear
2) the acl was changed
3) oracle was started as a another user


Farnsworth, Dave wrote:

>I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut 
>itself down.  In the Alert.log I have the following error.
>
>Tue Apr 02 10:47:40 2002
>KCF: write/open error block=0x21de online=1
> file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
> error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
>O/S-Error: (OS 5) Access is denied.'
>DBW0: terminating instance due to error 1242
>Instance terminated by DBW0, pid = 287
>
>
>This is a new for me.  Any ideas what I am dealing with?
>
>Thanks,
>
>Dave
>

-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk




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

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

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

RE: Database shut itself down

[Farnsworth, Dave]

It's all fixed.  And of 
course the network guys deny everything.
 
Dave

  -Original Message-From: Stephen Andert 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 
  2:13 PMTo: Farnsworth, Dave; 
  [EMAIL PROTECTED]Subject: Re: Database shut itself 
  down
  Dave,
   
  Maybe I'm way off base here, but it looks like there is some 
  problem at the OS level.  Is that file still there and 
  writable?
   
  Stephen
  >>> [EMAIL PROTECTED] 04/02/02 12:03PM 
  >>>I have a 8.1.7 database running on NT 4.0 that had a problem 
  this morning and shut itself down.  In the Alert.log I have 
  the following error.Tue Apr 02 10:47:40 2002KCF: write/open error 
  block=0x21de online=1 file=10 
  J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF 
  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to 
  fileO/S-Error: (OS 5) Access is denied.'DBW0: terminating instance due 
  to error 1242Instance terminated by DBW0, pid = 287This is a 
  new for me.  Any ideas what I am dealing 
  with?Thanks,Dave--Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com--Author: 
  Farnsworth, Dave  INET: [EMAIL PROTECTED]Fat 
  City Network Services    -- (858) 538-5051  FAX: (858) 
  538-5051San Diego, California    -- 
  Public Internet access / Mailing 
  ListsTo 
  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: Database shut itself down

[Bond Mike A Contr OC-ALC/TILC]

Perhaps another program tied up the file - virus scan, backup software.

My Oracle on NT is easier killed that way - so I scream at the SA.  Mine
usually restarts and recovers fine afterward though.

Mike


-Original Message-
Sent: Tuesday, April 02, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


I have a 8.1.7 database running on NT 4.0 that had a problem this morning
and shut itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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

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

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

RE: Database shut itself down

[Kevin Lange]

 Permissions set wrong on the file ???
 Database started up by the wrong id ??


-Original Message-
Sent: Tuesday, April 02, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


I have a 8.1.7 database running on NT 4.0 that had a problem this morning
and shut itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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

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

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

Data Warehouse Tools

[dmeng]

Hi All -
This is for DBAs who have participated in a DW project: what kind of tools
did you use for design, ETL, Query etc. I know Oracle has a data warehouse
builder but it doesn't seem to be widely used. What is the most popular
tools out there for DW construction and what is the trend?

TIA

Dennis


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

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

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

Ticket tracking system

[Nguyen, David M]

I develope a ticket database for people to open, close, re-open ticket to
update using oracle database.  My question is how do I use SQL command to
let people re-open a close ticket for updates?  When someone close a ticket,
delete command is executed and data is gone.  Please advise.

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

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

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

Literal SQL and sys.dual

[Mohammed Shakir]

I am working on a database optimization project. My Shared pool is
filled with SQL like

select 0 from dual;
select 1/1 from dual;
select 1 - 1/(2 + 2) from dual;


I tried to use the bind variables to minimize the literal SQL. However
I need a different SQL script for each case.

select :b1 from dual;
select :b1/:b2 from dual;
select :b1 - :b2/(:b3 + :b4) from dual;

first one will handle all cases for b1 from 0 to any number which is
good. And second sql will handle all the cases for any number for b1
and b2. So I do reduce the literal SQL. However, I need to know ahead
of time what type of data I am calculating and then use the appropriate
SQL.

I think the easy solution would be to use arithmetic. That is to pass
the string like ( 1 + 1 / (2 -2) ) to some function that can return me
the result of this sting. So I would not be using SQL script, to
minimize SQL execution, sys.dual contention or literal SQL filling
shared pool and causing both library cache and shared pool. Not to
mention saving in CPU processing by not parsing SQL scripts.

Anybody, aware of such function in PL/SQL? Is there any other way to do
calculations other than 'select 1 + 1 from dual' ?

I would really appreciate if you could let me know.

Thanks

Mohammed Shakir

=
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

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

RE: Seeking opinions

[Mandal, Ashoke]

Could any of you please summarize all the points once the discussion is over.

Thanks,
Ashoke

-Original Message-
Sent: Tuesday, April 02, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L


I agree.

I think that some people don't understand OFA's intentions.  First of
all, it _is_ a standard, meant to provide great flexibility.

The reason mount points are to be named in a generic fashion is to
allow any type of file to reside on them.  Any number of file types can
happily coexist under their own appropriately named subdirectories.

Under OFA, database files can be easily identified by "ls
/u???/oradata/$ORACLE_SID"; the file name ought to include the name of
the tablespace to which the file belongs.

Richard's point about a file that gets misnamed is well-taken.  The
only identification of datafiles that matters is the data dictionary. 
Rely on anything else and you're asking for trouble.

Thanks to all for their comments.


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> It sounds to me that whoever architected this approach really didn't
> understand
> the idea of "metadata" and the flexibility that OFA provides in terms
> of
> tuning
> (I'm not limited to specific disks because I have "customer data")
> and
> performance.
> 
> My 2 cents...
> 


=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Database shut itself down - FIXED

[Farnsworth, Dave]

I had to do a 

STARTUP MOUNT
RECOVER DATABASE

That fixed it and I'm back up and running.

Thanks,

Dave

-Original Message-
Sent: Tuesday, April 02, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut 
itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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

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

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

RE: Database shut itself down

[Jamadagni, Rajendra]

O/S-Error: (OS 5) Access is denied.'

This is the most important error message, talk to NT admins to see if anyone
changes any privileges ... my guess, someone did.

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-
Sent: Tuesday, April 02, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L


I have a 8.1.7 database running on NT 4.0 that had a problem this morning
and shut itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,
Dave


***1

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 ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

Re: Seeking opinions

[Stephane Faroult]

Paul Baumgartel wrote:
> 
> Hi everyone.
> 
> I'm currently working at a client where the OFA standard has been (as
> they put it) "taken to the next level".  I disagree with their
> approach, and I'd be interested to see what list members think.
> 
> The client believes that any DBA (there are about 16 on staff) should
> be able to locate data files in any database without querying the data.
>  To this end, mount points are named both /unnn (e.g., /u001) and /annn
> (e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
> go only on the /unnn mount points, and in particular, datafiles for
> certain tablespaces must go on certain mount points--for instance
> rollback tablespace files always go on /u004.
> 
> "User" datafiles are allowed on /a001 and /a002, tables and indexes,
> respectively.
> 
> To my mind, this standard changes the Optimal Flexible Architecture to
> the Sub-optimal Inflexible Architecture, and all just to avoid a data
> dictionary query.  What do you think?
> 

Paul,

  Your story reminds me of a shell script I have seen which was the
pride of its author and was 'fully configurable'. There was a
configuration file containing assignments to about 200 variables,
including those which could have been derived from others, and the great
majority of which was used only once.
There is a fine line between extreme logic and insanity, and wanting to
regulate anything down to the most minute detail is a sure recipe for
pushing people to trespass the rules. My guess is that some day space
will be lacking under /a001 or /a002, or that, because of a failing
batch, the rollback/undo tablespace will be massively increased, past
the then current capacity of /u004. This will probably end up with soft
links, and that's when one will discover that the 'find' statements in
the script lack '-follow'. The road to hell ...

-- 
Regards,

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

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

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

Lietral

[Mohammed Shakir]

 
 

=
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

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

Database shut itself down

[Farnsworth, Dave]

I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut 
itself down.  In the Alert.log I have the following error.

Tue Apr 02 10:47:40 2002
KCF: write/open error block=0x21de online=1
 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
 error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 287


This is a new for me.  Any ideas what I am dealing with?

Thanks,

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

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

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

Re:RE: License standby database?

[Rachel Carmichael]

yep... but it's because the database is being used, even if you don't
use it for read-only the fact that the executables are running and
the database is mounted is why you need the license.

Now, if you have a copy of all the files, and the executables on
another machine, but DON'T run anything, THEN you don't need another
license


--- [EMAIL PROTECTED] wrote:
> Jon,
> 
> Wrong.  You must license the second server identically to the
> original.  The
> reason is that a standby database can be used as a read only copy of
> the
> original.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Jon Baker <[EMAIL PROTECTED]>
> Date:   4/2/2002 8:03 AM
> 
> I believe as long as it is only stand-by, no additional licensing
> required.
> Only one system is "functional" at a time.
> 
> 
> Jon
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Tuesday, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Can someone tell me - if you have a standby database, must you carry
> a full
> Oracle license on it? Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> 
> 
> RE: License standby database?
> 
> 
> 
> I believe as long as it is only stand-by, no
> additional
> licensing required.  Only one system is "functional"
> at a
> time.
> 
> 
> 
> Jon
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: DENNIS WILLIAMS [
HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: License standby database?
> 
> 
> 
> Can someone tell me - if you have a standby database,
> must you
> carry a full
> Oracle license on it? Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:  HREF="http://www.orafaq.com";
> TARGET="_blank">http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> 
> Fat City Network Services    -- (858)
> 538-5051  FAX: (858) 538-5051
> San Diego,
> California   
> -- Public Internet access / Mailing Lists
> 
SIZE=2> T>
> To REMOVE yourself from this mailing list, send an
> E-Mail
> message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like
> subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Seeking opinions

[Jesse, Rich]

To me, there is a potential problem with having the software, administrative
files (init.ora, etc), and database files all under one tree.  Has no one
else needed to do an "rm -r" in an admin or datafile directory to delete an
old database?  While there is a certain level of trust that must be given to
SAs and DBAs, I try to prevent human error -- especially when that human is
me!

If our datafiles all reside under the "/oracle" directory (under several
mountpoints) while the software and admin directories are under another, it
becomes that much more difficult to accidentally mangle files
unintentionally.

And all this aside, Oracle doesn't support OFA in any way on OpenVMS.
Trying to implement it there is an excersize in futility.  And cause for
excessive beer consumption.

:)

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


> -Original Message-
> From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 11:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Seeking opinions 
> 
> 
> I agree.
> 
> I think that some people don't understand OFA's intentions.  First of
> all, it _is_ a standard, meant to provide great flexibility.
> 
> The reason mount points are to be named in a generic fashion is to
> allow any type of file to reside on them.  Any number of file 
> types can
> happily coexist under their own appropriately named subdirectories.
> 
> Under OFA, database files can be easily identified by "ls
> /u???/oradata/$ORACLE_SID"; the file name ought to include the name of
> the tablespace to which the file belongs.
> 
> Richard's point about a file that gets misnamed is well-taken.  The
> only identification of datafiles that matters is the data dictionary. 
> Rely on anything else and you're asking for trouble.
> 
> Thanks to all for their comments.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Seeking opinions

[Post, Ethan]

Robert,

Tell me a little more about potential for inode corruption and how this
helps?  Never heard of that one before.  I stick it all in
/x/oradata/$ORACLE_SID and distinguish my files by .dbf, .ctl, .arc and
.rdo.  Also are yall mostly Oracle or are you running anything else?

- Ethan

-Original Message-
Sent: Tuesday, April 02, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L


This is hogwash. OFA perfectly helps to separate the datafiles from
different 
database instances. We run well over 300+ Oracle databases here and the ONLY
extension we have to OFA is that I add a /data /control and /redo directory
to the file systems for just a little extra protection from possible inode
corruption.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

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

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

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

Re: One sql statement

[Big Planet]

select sum(decode(balamce,'D',amount,-1*amount)
from  table ;


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 9:58 PM


> Suppose I have table structure like this:
> amount Numeric(10)
> balance VARCHAR(1)
> 
> the balance column can only have one of  'D' or 'C'
> 
> I want to sum the amount of Debet and Credit on ONE SQL statement.
> How my SQL statement should be?
> 
> 
> Ferry Situmorang:
> Using Oracle 8.1.7 Designer 6i R4
> PT Perkebunan Nusantara XIII (Persero)
> Pontianak-Indonesia
> http://www.ptpn13.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ferry Situmorang
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Big Planet
  INET: [EMAIL PROTECTED]

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

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

TEST PLEASE DELETE

[Bartolo, David]

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

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

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

RE: EMC question

[Gaja Krishna Vaidyanatha]

Waleed & list,

To define the terms we have on hand:-
A contiguous meta volume requires the hyper volumes to
be sequential. A non-contiguous does not require the
hyper volumes to be sequential.

I want to reiterate again that the concept of "pure
striping" at the hardware level, is still not there in
EMC, even though you have documentation that claims
that you do. Let me explain.

When you look at "pure striping", there are 2 aspects
to it :-

1) The read aspect
2) The write aspect

Take an example of a 4-way striped volume. The read
aspect provides us the capability for all 4 drives to
independently spin and service I/O from each of the
drives. This the EMC device does, after the data has
been placed on all hypers that support a meta volume.

The write aspect needs to offer the same
functionality. So, if you are writing to 4 distinct
blocks (each on 1 disk), then each drive should be
able to write 1 block in an independent fashion.

That is where, the EMC hardware striping is not
complete. This is because, the 4 blocks that need to
be written to the "meta volume" with 4 hypers
(regardless of whether it is contiguous or not), will
happen in "sequential" fashion. Meaning, to write 4
blocks into the "striped volume", the first block will
be written to the first hyper, followed by the second
block to the second hyper and so on. As you can see
the blocks that need to be written are queued up, so
that they are written in a sequential fashion on the
underlying hypers. This can and will cause severe
write-intensive I/O bottlenecks.

Why is this implemented this way? No specific reasons,
except, "that is how it is right now". It has been
rumored that microcode 5x68 or 5x69, will do that.
Remains to be seen.

So all the EMC "striping" does right now is to
alleviate the problem of read-intensive operations not
hammering a single drive, provided the data is spread
across all the underlying hypers. I am not very
familiar with the Engenuity product offering, hence
cannot comment on that, but from what I have heard, it
is a software-based volume management product.


Best regards,

Gaja

--- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
>  
> It looks like it's available now.
> 
> This is from: ResourcePak for Windows Version 3.2
> Product Guide 
> 
> "Symmetrix Microcode level 5x65 includes support for
> concatenated
> (contiguous) and striped metavolumes.
> Noncontiguous metavolumes (including striped)
> require EMC Enginuity(tm)
> (5x66 microcode) or higher."
> 
> Regards,
> 
> Waleed
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 4/1/02 5:38 PM
> 
> Waleed & list,
> 
> I researched this issue recently and found out that
> the meta volume was "concatenating a bunch of hyper
> volume". As you know, concatenation is NOT striping.
> The hyper volumes get filled with data one after
> another, eventually giving you the "simulation of a
> striped volume", when all hypers are filled with
> data.
> 
> I don't know about the "single-host vs. multi-host"
> addressibility issue. There are plans for supporting
> "true striped volumes" in microcode level 68 or 69.
> From some "reliable sources" that does not look like
> it will happen any time soon. So until then, you
> should consider created mirrored hyper volumes
> within
> EMC (RAID 1) and then create a striped volume using
> Veritas Volume Manager, giving you a RAID 1+0
> configuration, which is ideal.
> 
> Best regards,
> 
> Gaja
> 
> --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:
> > Four years ago the only hardware striping
> available
> > on EMC I was aware of
> > was RAID-S.
> > Recently researching striping ideas on EMC and was
> > told that we can achieve
> > raid0+1 hardware striping on EMC.
> > 
> > I was told that EMC has some layer called
> > meta-volume that is made of many
> > other hyper-volumes.
> > 
> > Told also that meta-volumes could be raid-0
> > (striped) and it's not a
> > single-host addressable volume.
> > 
> > Does anybody know anything about this? Can we
> really
> > get a hardware striped
> > volume using EMC? 
> > 
> > Any limitations there?
> > 
> > Thanks.
> > 
> > 
> > Waleed
> > 
> > 
> >  Any views or opinions presented in this email are
> > solely those of the
> > author and do not necessarily represent those of
> the
> > company
> > 
> > -- 



=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
http://www.osborne.com/database_erp/0072131454/0072131454.shtml

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

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

RE: Seeking opinions

[Paul Baumgartel]

I agree.

I think that some people don't understand OFA's intentions.  First of
all, it _is_ a standard, meant to provide great flexibility.

The reason mount points are to be named in a generic fashion is to
allow any type of file to reside on them.  Any number of file types can
happily coexist under their own appropriately named subdirectories.

Under OFA, database files can be easily identified by "ls
/u???/oradata/$ORACLE_SID"; the file name ought to include the name of
the tablespace to which the file belongs.

Richard's point about a file that gets misnamed is well-taken.  The
only identification of datafiles that matters is the data dictionary. 
Rely on anything else and you're asking for trouble.

Thanks to all for their comments.


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> It sounds to me that whoever architected this approach really didn't
> understand
> the idea of "metadata" and the flexibility that OFA provides in terms
> of
> tuning
> (I'm not limited to specific disks because I have "customer data")
> and
> performance.
> 
> My 2 cents...
> 


=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

RE: Seeking opinions

[Freeman, Robert]

My apologies, I was reading the post *REALLY* fast (on my way to my daily
deluge of
meetings) and mis-read what you said completely. Upon re-reading, I agree
100% with what you
said about standards.

Again, removing foot from mouth. 

RF


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Tuesday, April 02, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L


Robert,

What part of what I said is "hogwash".

The part about the DBA's wanting similiar structures across all machine
types, or the part about having standards?

Huh?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, April 02, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L


This is hogwash. OFA perfectly helps to separate the datafiles from
different 
database instances. We run well over 300+ Oracle databases here and the ONLY
extension we have to OFA is that I add a /data /control and /redo directory
to the file systems for just a little extra protection from possible inode
corruption.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Tuesday, April 02, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L


Paul,

I live under similiar standards.  They make sense here becuase, when one
looks at the big picture, they need these types of standards to help the
DBA's (there are three of them) to cope with the many many Oracle instances
across multiple platforms (NT, Sun Unix, Dec Unix).

I look at it this way - at least it's a standard - better than no standards
at all.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and

Re: Designer's Table API: Threat or Menace?

[Paul Baumgartel]

Roy, we are using the TAPI on my current project, and haven't seen any
significant disadvantages (I'm the DBA, so I would know).  Performance
is fine.  I don't think the number of triggers should be an issue as
long as your SYSTEM tablespace is correctly sized.  To me, the
advantages of generated code far outweigh the possibility that the code
isn't the most compact.  

Paul Baumgartel


--- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote:
> Greetings all,
> 
> Is anyone out there using Oracle Designer's Table API?  We're trying
> to
> decide whether to use it as opposed to writing our own packages &
> triggers
> (for things like populating sequence-generated PKs, upcasing
> VARCHARs,
> enforcing domains, etc.).
> 
> From my (admittedly selfish) perspective, any working line of code
> that I
> don't have to write/support is a good line of code, but it does look
> like a
> *lot* of code to do not so very much.  Our DBA is concerned that it's
> creating unnecessary triggers, will suck down resources unecessarily,
> server
> will grind to a halt, etc.
> 
> My concern is that we'll find out that the TAPI procs are bulky &
> complicated for a reason--we'll decide to chuck them & then wind up
> reinventing them (and maybe not as well as the folks at Oracle).  Has
> anybody out there been over this ground & care to make a
> reccomendation?
> 
> Thanks!
> 
> -Roy
> 
> P.S. In case it's important, we're using Designer 6.0 to create
> OAS-deployed
> Oracle Forms & Reports to run against a 9i db.
> 
> Roy Pardee
> Programmer/Analyst
> SWFPAC Lockheed Martin IT
> Extension 8487
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Pardee, Roy E
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

Re: Do programmers tune SQL?

[Suzy Vordos]

Well, I sent this to the list yesterday but it never showed up, trying
again.

Learn the basics of executing SQL from Java:

Statement - basic SQL statement
Prepared Statement - precompiled SQL statement (bind variables)
Callable Statement - calling database procedures/functions

Get the O'Reilly book "Java Enterprise in a Nutshell".  That book was a
lifesaver for me when working with Java developers, as it helped me
understand and communicate in terms they understood. 

Suzy 

DENNIS WILLIAMS wrote:
> 
> Oh, I guess I'm a little slow on Monday. I've enjoyed the discussion so far.
> Very close to my situation.
> 
> Given my situation - i.e., we haven't had many SQL statement problems, but
> expecting to receive more with Java, I'm wondering how I can get ahead of
> the game. I have worked on a set of SQL statement recommendations, simple
> stuff like make sure screen queries use and index. I am considering creating
> a checklist form for SQL statements for the developers to use. Like include
> the listing from EXPLAIN PLAN. Does anyone have any thoughts on this
> approach? I'm not sure if the developers/management would go for it, but I
> thought it would be worth asking as a starting point. Everybody is new to
> Java and a little nervous, so they are probably more open to suggestions.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Monday, April 01, 2002 9:13 AM
> To: Multiple recipients of list ORACLE-L
> 
> and your question is?
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > All,
> >   We are in transition here at my site. Our primary development tool
> > over the past few years has been a client-server tool named Uniface
> > from
> > Compuware, which does an excellent job of protecting developers from
> > themselves. However, we are switching to Java, and moving more
> > developers
> > from the mainframe to an Oracle-Java system that is being developed.
> > For a
> > Java IDE, it looks like a tool named TogetherSoft. I am concerned
> > that I
> > will need to take a more active role with the developers.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Friday, March 29, 2002 8:03 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Greg,
> >
> > You *do* see DBA's doing the bulk of the SQL tuning work in many
> > shops. But
> > it's not necessarily because the developers, or at least some them,
> > can't,
> > or, that many of them don't care (and *many* of them never do give it
> > a
> > thought). I've seen places where the developers begged for the
> > ability to
> > turn on tracing in development, or to have a plan_table and/or the
> > use of
> > autotrace, and were denied. And other cases where the development,
> > testing,
> > and QA environments were so different from production that there was
> > nearly
> > no point.
> >
> > Anyway, just by virtue of their titles, I don't know that a DBA is
> > any
> > better at SQL tuning than a developer or vice versa (and I'm not
> > pointing
> > that comment at you, Greg, but just in general that I don't think the
> > title
> > of DBA or developer makes a difference). It really depends on their
> > backgrounds and skill levels. I've seen, for the most obvious
> > example, many
> > DBA's and developers freak when they see a full table scan, never
> > taking
> > into consideration if that was the appropriate approach. Instead,
> > they just
> > lived by some rule that "full table scans are bad". You see lots of
> > things
> > like that.
> >
> > Anyway, as someone who started off as both a DBA and developer, and
> > drifts
> > back and forth between the two and still serving in both roles, I can
> > see
> > both sides. I know DBA's who rant about the developers not giving a
> > flip
> > about performance when they write their code, and in many cases it is
> > true,
> > the issue of performance was never considered. But I also know many
> > developers who *do* care and are hindered from doing so. By the same
> > token,
> > I know a lot of DBA's who are very good at SQL tuning, and tuning and
> > general, and many more who aren't.
> >
> > So, what we can we do? We can work with the developers (and DBA's)
> > and
> > mentor them. We can teach the tricks and efficient styles (whether
> > SQL
> > itself or application design in general). And it really helps if we
> > can
> > provide an environment that mimics production (dollars and budgets
> > make that
> > hard to do in many cases).
> >
> > Sorry for the length, but it touches on something I'm dealing with
> > right
> > now. I'm helping some developers who are getting hammered about why
> > their
> > code performs so poorly in production. Heck, it ran great in all the
> > other
> > environments, there's not much more that they could have done. And
> > yes, I
> > now sit in on the code reviews making suggestions when something
> > could be
> > done better, and testing t

RE: Seeking opinions

[Ji, Richard]

Tom,

I am not oppositting the idea of standard.  I implement OFA and other stuff,
and everywhere
I go the first I do is establish standards.  The problem is even with
standard
in place one should not assume everything will be in place as is should be.
Which is the problem I see as Paul described.  People are relying on
standard
more than data dictionary.

And like you said when a file is in the wrong place it will stand out like
a sore thumb.  But the bigger question is what will the other 15 DBAs do
about it?  If they trust the standard so much they will think it shouldn't
be there and without querying data dictionary to confirm it some one might
go ahead and delete it.  And yes the chance are very small but I don't like
to risk it.

Richard

-Original Message-
Sent: Tuesday, April 02, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


Richard,

In a busy shop, I would think  that there is a *less* chance of a DBA making
a mistake if all databases across all platforms conformed to the same
directory standard.

Can you imagine how long it would take to diagnose and fix a problem if
every database was set up to a different standard?

Mistakes can happen, but at least with standards, if a file is in the wrong
place, it would stand out like a sore thumb.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, April 02, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L


Hi Paul,

How's going?

What if someone on the dba group make a mistake (typo or whatever)
and put the data file in the wrong place?  And other DBAs didn't
notice it and work on something.  I don't like the idea people
assume things will be in the right place because the rule says so.
I'd rather trust data dictionary than somethng that has 16 DBA's hands
on it.

Do they also write they scripts assuming everything is where it
should be?

Richard Ji

-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line c

RE: Seeking opinions

[Mercadante, Thomas F]

Robert,

What part of what I said is "hogwash".

The part about the DBA's wanting similiar structures across all machine
types, or the part about having standards?

Huh?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, April 02, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L


This is hogwash. OFA perfectly helps to separate the datafiles from
different 
database instances. We run well over 300+ Oracle databases here and the ONLY
extension we have to OFA is that I add a /data /control and /redo directory
to the file systems for just a little extra protection from possible inode
corruption.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Tuesday, April 02, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L


Paul,

I live under similiar standards.  They make sense here becuase, when one
looks at the big picture, they need these types of standards to help the
DBA's (there are three of them) to cope with the many many Oracle instances
across multiple platforms (NT, Sun Unix, Dec Unix).

I look at it this way - at least it's a standard - better than no standards
at all.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

To REMOVE yourself f

Re:RE: License standby database?

[dgoulet]

Jon,

Wrong.  You must license the second server identically to the original.  The
reason is that a standby database can be used as a read only copy of the
original.

Dick Goulet

Reply Separator
Author: Jon Baker <[EMAIL PROTECTED]>
Date:   4/2/2002 8:03 AM

I believe as long as it is only stand-by, no additional licensing required.
Only one system is "functional" at a time.


Jon
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, April 02, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L


Can someone tell me - if you have a standby database, must you carry a full
Oracle license on it? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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

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

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






RE: License standby database?



I believe as long as it is only stand-by, no additional
licensing required.  Only one system is "functional" at a
time.



Jon
[EMAIL PROTECTED]


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject: License standby database?



Can someone tell me - if you have a standby database, must you
carry a full
Oracle license on it? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com"; TARGET="_blank">http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


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

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




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

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

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

RE: License standby database?

[Jon Baker]

Title: RE: License standby database?





I believe as long as it is only stand-by, no additional licensing required.  Only one system is "functional" at a time.



Jon
[EMAIL PROTECTED]


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject: License standby database?



Can someone tell me - if you have a standby database, must you carry a full
Oracle license on it? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


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

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

RE: Congratulations, Ari! + FYI: 9i usage survey

[Deshpande, Kirti]

Congratulations to Ari and all the other Board Members!

My vote does count ;) 

- Kirti 

-Original Message-
Sent: Monday, April 01, 2002 3:34 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Came across this on the IOUG page:

Results of the IOUG Board of Directors Election. The Winners are...  
13-MAR-02 
Michael Abbey - 48.5% of voters
Kimberly Floss - 45.6% of voters
Karen Langley - 41.5% of voters
Ari Kaplan - 40.3% of voters 

Congratulations to the winners. Michael Abbey, popular speaker, author, and
Oracle guru returns to the board. Kimberly Floss and Karen Langley were
re-elected by the membership and will continue their efforts on behalf the
of the Oracle user community. Ari Kaplan joins the IOUG Board of Directors
for the first time. The community looks forward to his insights and
contributions.

JK: Congratulations, Ari! You owe us one.

Results of 9i Migration Survey Completed by OTN and IOUG Members  
11-MAR-00 

- 20% of respondents have installed Oracle9i. This number has climbed from
10% in July to 28% in November to 43% in January 2002 
- 77% of respondents plan to use Oracle9i for production applications within
the next 12 months 
- 41% plan to move all application to 9i, while 37% plan to move some
applications, and 22% plan to deploy only new applications on Oracle9i 
- 74% of respondents rate Oracle9i as very innovative 
- 52% of respondents plan to migrate non-Oracle databases to 9i 


John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

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


> -Original Message-
> From: Joseph S Testa [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 1:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Installing Oracle 9.0.1 on Red Hat Linux 7.2
> 
> 
> first time you get the error,
> 
> open a new window go to $ORACLE_HOME/bin
> look for genclntsh
> vi the file, looking for -z defs, remove that part, the -z defs
> ./genclntsh
> 
> then hit retry, all should be good.
> 
> joe
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> > If you have successfully installed Oracle 9.0.1 on Red Hat 
> 7.2, please
> > let me know what steps you had to take to make it work.
> > 
> > I've installed the compatibility libs and glibc stub patch 
> for Oracle 8i, 
> > and
> > have successfully installed 8.1.7.
> > 
> > The 9i install consistently fails on the ins_plsql.mk  makefile.
> > 
> > I'll check on MetaLink some more.
> > 
> > And yes, I know 7.2 is not yet certified, but it appears 
> from the forums
> > on MetaLink that others have done this.
> > 
> > Thanks,
> > 
> > Jared
> > 
> 
> 
> -- 
> Joseph S Testa
> Data Management Consulting
> http://www.dmc-it.com
> 614-791-9000
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joseph S Testa
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: archive log curr v. switch logfile

[Koivu, Lisa]

Gene's afraid of R-Man!
Gene's afraid of R-Man!

Gene you will not believe how simple RMAN is once you start using it...

Lisa Koivu
Oracle Database TANK
Fairfield Resorts, Inc.
954-935-4117


> -Original Message-
> From: Gene Sais [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:28 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: archive log curr v. switch logfile
> 
> I use Alter system archive log current.  If your archiver process is
> caught up, you will get this error message when issuing Alter system
> archive log all:
> 
> SQL> alter system archive log all;
> alter system archive log all
> *
> ERROR at line 1:
> ORA-00271: there are no logs that need archiving
> 
> Just don't like error messages in the logs :).  Lisa's method seems the
> safest, but never had an archiver not keeping up and if I did, that would
> be an issue to be resolved quickly.
> 
> Here's my hot backup model with help from list members and
> Velpuri/Adkoli's Backup/Recovery Book:
> #   1) Alter system archive log current ;
> #   2) Check backup status.
> #   3) Generate datafile listing.
> #   4) Alter tablespace  begin backup ;
> #   5) Some other process,script,legato,etc. will copy database files
> #  to disk or to tape.
> #   6) Alter tablespace  end backup ;
> #   7) Backup controlfile.
> #   8) Alter system archive log current ;
> #
> Archives are backed up separately 2 x day to tape.
> 
> Gene
> 
> PS.  Confident w/ hot backups, next to conquer RMAN cautiously.
> 
> >>> [EMAIL PROTECTED] 03/29/02 12:13PM >>>
> Actually I use alter system archive log all.  I saw that if the database
> was
> behind with archiving, this would ensure that all logs were written to the
> arc destination.  archive log current only did the most recent.  
> 
> Am I wrong?  Please correct me if I am .
> 
> Lisa Koivu
> Oracle Database Baby Oven
> Fairfield Resorts, Inc.
> 954-935-4117
> 
> 
> > -Original Message-
> > From:   Post, Ethan [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Friday, March 29, 2002 11:48 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: archive log curr v. switch logfile
> > 
> > I believe alter system archive log current will wait until archiver has
> > successfully archived the file, thus this is the one you would want to
> use
> > in any backup scripts.  
> > 
> > - Ethan
> > 
> > -Original Message-
> > Sent: Friday, March 29, 2002 10:24 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > 
> > Can anyone tell me the difference between
> > alter system archive log current
> > and
> > alter system switch logfile
> > 
> > (Seems they both perform checkpoint and both switch a log file).
> > Is one preferred over the other for purposes of switching log files
> prior
> > to
> > applying to a standby database?
> > 
> > Thanks for any insights.
> > 
> > Barb
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > -- 
> > Author: Baker, Barbara
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > -- 
> > Author: Post, Ethan
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Koivu, Lisa
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other inf

RE: Seeking opinions

[Freeman, Robert]

This is hogwash. OFA perfectly helps to separate the datafiles from
different 
database instances. We run well over 300+ Oracle databases here and the ONLY
extension we have to OFA is that I add a /data /control and /redo directory
to the file systems for just a little extra protection from possible inode
corruption.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Tuesday, April 02, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L


Paul,

I live under similiar standards.  They make sense here becuase, when one
looks at the big picture, they need these types of standards to help the
DBA's (there are three of them) to cope with the many many Oracle instances
across multiple platforms (NT, Sun Unix, Dec Unix).

I look at it this way - at least it's a standard - better than no standards
at all.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Seeking opinions

[Freeman, Robert]

It sounds to me that whoever architected this approach really didn't
understand
the idea of "metadata" and the flexibility that OFA provides in terms of
tuning
(I'm not limited to specific disks because I have "customer data") and
performance.

My 2 cents...

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Tuesday, April 02, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L


Hi Paul,

How's going?

What if someone on the dba group make a mistake (typo or whatever)
and put the data file in the wrong place?  And other DBAs didn't
notice it and work on something.  I don't like the idea people
assume things will be in the right place because the rule says so.
I'd rather trust data dictionary than somethng that has 16 DBA's hands
on it.

Do they also write they scripts assuming everything is where it
should be?

Richard Ji

-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Seeking opinions

[Mercadante, Thomas F]

Richard,

In a busy shop, I would think  that there is a *less* chance of a DBA making
a mistake if all databases across all platforms conformed to the same
directory standard.

Can you imagine how long it would take to diagnose and fix a problem if
every database was set up to a different standard?

Mistakes can happen, but at least with standards, if a file is in the wrong
place, it would stand out like a sore thumb.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, April 02, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L


Hi Paul,

How's going?

What if someone on the dba group make a mistake (typo or whatever)
and put the data file in the wrong place?  And other DBAs didn't
notice it and work on something.  I don't like the idea people
assume things will be in the right place because the rule says so.
I'd rather trust data dictionary than somethng that has 16 DBA's hands
on it.

Do they also write they scripts assuming everything is where it
should be?

Richard Ji

-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Oracle , SQL*Server Concurrent SELECT

[Farnsworth, Dave]

Title: RE: Oracle , SQL*Server Concurrent SELECT



Metalink has some papers and docs on this.  Also 
there is a book called "Oracle Distributed Systems" by Charles Dye.  Also, 
when in doubt you can always RTFM.  ;o)
 
Dave

  -Original Message-From: VIVEK_SHARMA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:03 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle , SQL*Server Concurrent SELECT 
   
  Any 
  Links , Docs on the Same ?
   
  
-Original Message-From: Shripad Bharati 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:48 
AMTo: VIVEK_SHARMASubject: RE: Oracle , SQL*Server 
Concurrent SELECT 
U can use Oracle's Heterogeneous Services . 
-Original Message- From: 
VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] 
Sent: 02 April 2002 08:07 To: 
LazyDBA.com Discussion Subject: Oracle , SQL*Server 
Concurrent SELECT 
2 Databases Exist - 1 in Oracle , 2nd SQL Server 
AIM To Possibly Run the Following SELECT Query in Some 
Manner  
SELECT ,  
FROM  ,  

Is the Above possible ? If so How ? 
Thanks 
 Oracle documentation is 
here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage 
To unsubscribe: send a blank email to 
[EMAIL PROTECTED] To 
subscribe:   send a blank email to 
[EMAIL PROTECTED] Visit the list 
archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By 
using this list you agree to these terms:http://www.lazydba.com/legal.html 

Re: Designer's Table API: Threat or Menace?

[Connor McDonald]

Worked on a "100% generated" application on very
similar versions you state.  Although I used the term
100% in quotes, I was very impressed with the
developers - who got about 95% of the gui (screens,
reports) done purely through Designer.

Table API's were used primarily for the journalling
feature.  Worked fine - the only real pain being that
any references to CG_REF_CODES in the validation code
were done with literals - so heaps of parsing with
sql's that could for all intensive purposes be common.
 You'll your shared pool littered with

select ..
from  cg_ref_codes
where domain = some_literal_in_quotes
and ...

I raised an enhancement with Oracle, but as at 6i.2
(the last time I looked at Designer) it was still the
same.

hth
connor

 --- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote: >
Greetings all,
> 
> Is anyone out there using Oracle Designer's Table
> API?  We're trying to
> decide whether to use it as opposed to writing our
> own packages & triggers
> (for things like populating sequence-generated PKs,
> upcasing VARCHARs,
> enforcing domains, etc.).
> 
> From my (admittedly selfish) perspective, any
> working line of code that I
> don't have to write/support is a good line of code,
> but it does look like a
> *lot* of code to do not so very much.  Our DBA is
> concerned that it's
> creating unnecessary triggers, will suck down
> resources unecessarily, server
> will grind to a halt, etc.
> 
> My concern is that we'll find out that the TAPI
> procs are bulky &
> complicated for a reason--we'll decide to chuck them
> & then wind up
> reinventing them (and maybe not as well as the folks
> at Oracle).  Has
> anybody out there been over this ground & care to
> make a reccomendation?
> 
> Thanks!
> 
> -Roy
> 
> P.S. In case it's important, we're using Designer
> 6.0 to create OAS-deployed
> Oracle Forms & Reports to run against a 9i db.
> 
> Roy Pardee
> Programmer/Analyst
> SWFPAC Lockheed Martin IT
> Extension 8487
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Pardee, Roy E
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

License standby database?

[DENNIS WILLIAMS]

Can someone tell me - if you have a standby database, must you carry a full
Oracle license on it? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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

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

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

RE: Seeking opinions

[Jesse, Rich]

Great point.  I had recently created a DB file and forgot to put the ".dbf"
extension on it.  If someone didn't query the DD of the DB first, they might
have thought it was a junk/temp file (they would have to ignore the file's
timestamp) and deleted it.

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


> -Original Message-
> From: Ji, Richard [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 9:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Seeking opinions 
> 
> 
> Hi Paul,
> 
> How's going?
> 
> What if someone on the dba group make a mistake (typo or whatever)
> and put the data file in the wrong place?  And other DBAs didn't
> notice it and work on something.  I don't like the idea people
> assume things will be in the right place because the rule says so.
> I'd rather trust data dictionary than somethng that has 16 DBA's hands
> on it.
> 
> Do they also write they scripts assuming everything is where it
> should be?
> 
> Richard Ji
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: Move index to another tablespace

[Ruth Gramolini]

You can do that in 8.0.6 too.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 9:43 AM


>
>
> > -Original Message-
> > From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 02, 2002 12:13 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Move index to another tablespace
> >
> >
> > Hi Ayyappan,
> >
> > Correct me if I am wrong. I think in 8.1.6, you can use the
> > alter index
> > command to move an index to a different tablespace
> > eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE
> > new_tablespace_name;
>
>
> That is available since 7.3. Moving tables is available as of 8i. There
are
> few
> missing links now. I'd like to see "RENAME USER" command added to the lot.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: archive log curr v. switch logfile

[Gene Sais]

I use Alter system archive log current.  If your archiver process is caught up, you 
will get this error message when issuing Alter system archive log all:

SQL> alter system archive log all;
alter system archive log all
*
ERROR at line 1:
ORA-00271: there are no logs that need archiving

Just don't like error messages in the logs :).  Lisa's method seems the safest, but 
never had an archiver not keeping up and if I did, that would be an issue to be 
resolved quickly.

Here's my hot backup model with help from list members and Velpuri/Adkoli's 
Backup/Recovery Book:
#   1) Alter system archive log current ;
#   2) Check backup status.
#   3) Generate datafile listing.
#   4) Alter tablespace  begin backup ;
#   5) Some other process,script,legato,etc. will copy database files
#  to disk or to tape.
#   6) Alter tablespace  end backup ;
#   7) Backup controlfile.
#   8) Alter system archive log current ;
#
Archives are backed up separately 2 x day to tape.

Gene

PS.  Confident w/ hot backups, next to conquer RMAN cautiously.

>>> [EMAIL PROTECTED] 03/29/02 12:13PM >>>
Actually I use alter system archive log all.  I saw that if the database was
behind with archiving, this would ensure that all logs were written to the
arc destination.  archive log current only did the most recent.  

Am I wrong?  Please correct me if I am .

Lisa Koivu
Oracle Database Baby Oven
Fairfield Resorts, Inc.
954-935-4117


> -Original Message-
> From: Post, Ethan [SMTP:[EMAIL PROTECTED]] 
> Sent: Friday, March 29, 2002 11:48 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: archive log curr v. switch logfile
> 
> I believe alter system archive log current will wait until archiver has
> successfully archived the file, thus this is the one you would want to use
> in any backup scripts.  
> 
> - Ethan
> 
> -Original Message-
> Sent: Friday, March 29, 2002 10:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> Can anyone tell me the difference between
>   alter system archive log current
> and
>   alter system switch logfile
> 
> (Seems they both perform checkpoint and both switch a log file).
> Is one preferred over the other for purposes of switching log files prior
> to
> applying to a standby database?
> 
> Thanks for any insights.
> 
> Barb
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Baker, Barbara
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED] 

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

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

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

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

Re: Cold NT backups

[Igor Neyman]

For cold backup you could just use standard NT "copy" command.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]

The degree of normality in a database
is inversely proportional to that of its DBA.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 02, 2002 8:58 AM


> Group,
> We are doing a cold backup to a remote server. I am using OCOPY that fails
> intermittently with the following message:
> OCOPY - Insufficient disk space on target drive
> There is more than sufficient space on the drive to hold the file. I filed
a
> TAR and was told that the error message is generic in nature and they
could
> not tell me exactly what is failing. Can anyone PLEASE give me some
> suggestions. The file is always SYSTEM01.DBF. All the rest of the files
copy
> across without a problem.
> TIA
> Al Rusnak
> 804-734-8453
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rusnak, George A.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: Seeking opinions

[Ji, Richard]

Hi Paul,

How's going?

What if someone on the dba group make a mistake (typo or whatever)
and put the data file in the wrong place?  And other DBAs didn't
notice it and work on something.  I don't like the idea people
assume things will be in the right place because the rule says so.
I'd rather trust data dictionary than somethng that has 16 DBA's hands
on it.

Do they also write they scripts assuming everything is where it
should be?

Richard Ji

-Original Message-
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L


Hi everyone.  

I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level".  I disagree with their
approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
 To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001).  "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.

To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query.  What do you think?

Thanks,



=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Move index to another tablespace

[Gogala, Mladen]

> -Original Message-
> From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 12:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Move index to another tablespace
> 
> 
> Hi Ayyappan,
> 
> Correct me if I am wrong. I think in 8.1.6, you can use the 
> alter index
> command to move an index to a different tablespace 
> eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE 
> new_tablespace_name;


That is available since 7.3. Moving tables is available as of 8i. There are
few
missing links now. I'd like to see "RENAME USER" command added to the lot.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

Re: Installing Oracle 9.0.1 on Red Hat Linux 7.2

[Gene Sais]

Jared - Check this link, there is a workaround.

http://www.puschitz.com/InstallingOracle9i.html 

Gene

>>> [EMAIL PROTECTED] 04/01/02 02:53PM >>>
If you have successfully installed Oracle 9.0.1 on Red Hat 7.2, please
let me know what steps you had to take to make it work.

I've installed the compatibility libs and glibc stub patch for Oracle 8i, 
and
have successfully installed 8.1.7.

The 9i install consistently fails on the ins_plsql.mk  makefile.

I'll check on MetaLink some more.

And yes, I know 7.2 is not yet certified, but it appears from the forums
on MetaLink that others have done this.

Thanks,

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

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

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

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

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

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