Which tables are in buffer cache.?

[Bunyamin K.Karadeniz]

 Hi all 
gurus,
    
    I want to learn the way to ook 
at 
Which tables are in buffer 
cache./Analyzed?
Is there a system view showing these 
tables??
 
Thanks to All.
 
Bunyamin K.Karadeniz    Database 
Group / Information Systems Department     HAVELSAN Ankara 
/TURKEY    Tel : +903122873565 / 1681    
Mobile Tel : +90 535 3357729
 
 

Re: Fwd: please help

[Glen Mitchell]

>From what I have read there are three problems that Bill has described. 
As this seems urgent and it is still daytime the Pacific timezone, I can
offer some limited advice.  In order of importance they would be ...
1. Recovery of the database.
2. Slow shutdown.
3. SQL statements hanging.
1. I strongly recommend the TAR (or iTAR) approach - if you flag
it as a production issue you should get a priority response.  No Oracle
error messages were provided so it makes it hard to give advice. 
Oracle Support should be able to talk you through the recovery process
with minimal risk of making the situation worse.
2. There can be many reasons for a slow shutdown.  The main things
to look for would be long-running transactions that need to be rolled-back
during a shutdown.  This can be quantified by looking at the active
transactions in v$rollstat.  Once again there is not much info. to
go on here.
3. Again, there can be many causes for SQL statements hanging and
with not much info. to go on I would look at locking and the execution
plan.  First check to see if there are any locks in the database using
dba_locks or v$locked_object.  An SQL statement will sit and wait
for the lock to be released by default.  Dba_locks and v$locked_object
will help identify offending sessions and the locks that they hold which
are blocking other SQL statements.  The other thing you could look
at is the execution plan for a long-running (hung) statement.  The
statement may be executing the hard-way ie. not using an index etc ... 
The easiest way to verify the execution plan is to use the autotrace facility
in SQL*Plus (the plan_table needs to exist).  The actual SQL statement
can be obtained either from the user or from v$sqlarea/v$sqltext for a
specific session.
I know this info. is brief and a bit vague but the best I can offer
with the lack of specific info.
Glen
 
Jonathan Gennick wrote:
Fellow list members, I received the following email
from a
reader a few minutes ago. If you skip down to where he talks
about backup, you'll see that he's in trouble with a
database that won't recover. I've already suggested that he
open a TAR, and that he supply more specifics as to error
messages and the like, but maybe someone on this list can
draw some conclusions from what he's told me so far. If
you're good at recovery, have a look at what he says. I'll
post his email address later if he says its ok, and I'll
pass on any advice/suggestions I receive in the meantime.
--
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED]
* 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com
* http://MetalDrums.org
Tuesday, May 01, 2001, 10:27:51 PM, X wrote:
BC> Hi Jonathan,
BC> I always read and like your articles in the Oracle
BC> Magazine.
BC> Could you please give me a moment of your time ..
BC> I have some couple of pressing problems and questions
BC> if you don't mind as i am under fire at work ..
BC> I have trouble with some of the Oracle databases that
BC> i manage on Sun Solaris platform, sometimes i have my
BC> shutdowns hanging and this takes a very long time to
BC> complete. Also, hanging problems with some of the sql
BC> statements. Could you lend a hand about any possible
BC> clues as to what i should do or where i should look
BC> for answers.
BC> My last question is about hotback.
BC> I ran a hot backup yesterday and tried recovering
BC> today. I was faced with an Oracle error saying system
BC> tablespace needs more recovery and that open resetlogs
BC> will get an error after automatically applying the
BC> redo logs.
BC> My backup strategy went this way,
BC> i created a backup shell script and
BC> i put all tablespaces in hotbackup mode at the same
BC> time with this syntax..
BC> select 'alter tablespace' || tablespace_name ||'begin
BC> backup;'
BC> from dba_tablespaces
BC> where status <> 'INVALID';
BC> I copied my datafiles to backup using the syntax below
BC> ...
BC> !cp /u02/oradata/prod/system01.dbf    /backup/prod
BC> !cp 
BC> !cp 
BC> !cp 
BC> !cp 
BC> then ended backup the same way as i began backup
BC> with the ||'end backup;'
BC> I backed up my controlfile
BC> and everything went well. Today, I restored my
BC> datafiles from backup and i was greeted with the
BC> problem i just expalined to you.
BC> I am the only dba DBA at this location
BC> and i need some advise on what to do as this is a
BC> serious issue with my supervisor.
BC> Thanks,
BC> Bill
BC> __
BC> Do You Yahoo!?
BC> Yahoo! Auctions - buy the things you want at great prices
BC> http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- (858) 538-5051 
FAX: (858) 538-5051
San Diego, California    --
Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EM

DB link for nonoracle databases

[Deepender Kr Gupta]

Hi All !!

I have a DBA question. Can we make a DB link for nonoracle databases ! The
answer is
'YES' , I know. But How.

The documentation says you will have to use Oracle
hetrogeneous services. There is no explaination any
further.


I want my Oracle database to gather data from a SQL
server . Both are on NT.

Thanks in Advance.

Deepender

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

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

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

Fwd: please help

[Jonathan Gennick]

Fellow list members, I received the following email from a
reader a few minutes ago. If you skip down to where he talks
about backup, you'll see that he's in trouble with a
database that won't recover. I've already suggested that he
open a TAR, and that he supply more specifics as to error
messages and the like, but maybe someone on this list can
draw some conclusions from what he's told me so far. If
you're good at recovery, have a look at what he says. I'll
post his email address later if he says its ok, and I'll
pass on any advice/suggestions I receive in the meantime.

-- 
Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Tuesday, May 01, 2001, 10:27:51 PM, X wrote:
BC> Hi Jonathan,

BC> I always read and like your articles in the Oracle
BC> Magazine. 

BC> Could you please give me a moment of your time ..
BC> I have some couple of pressing problems and questions
BC> if you don't mind as i am under fire at work ..

BC> I have trouble with some of the Oracle databases that
BC> i manage on Sun Solaris platform, sometimes i have my
BC> shutdowns hanging and this takes a very long time to
BC> complete. Also, hanging problems with some of the sql
BC> statements. Could you lend a hand about any possible
BC> clues as to what i should do or where i should look
BC> for answers.

BC> My last question is about hotback.

BC> I ran a hot backup yesterday and tried recovering 
BC> today. I was faced with an Oracle error saying system
BC> tablespace needs more recovery and that open resetlogs
BC> will get an error after automatically applying the
BC> redo logs.

BC> My backup strategy went this way,

BC> i created a backup shell script and 
BC> i put all tablespaces in hotbackup mode at the same
BC> time with this syntax..

BC> select 'alter tablespace' || tablespace_name ||'begin
BC> backup;'
BC> from dba_tablespaces
BC> where status <> 'INVALID';

BC> I copied my datafiles to backup using the syntax below
BC> ...

BC> !cp /u02/oradata/prod/system01.dbf/backup/prod
BC> !cp 
BC> !cp 
BC> !cp 
BC> !cp 

BC> then ended backup the same way as i began backup
BC> with the ||'end backup;'

BC> I backed up my controlfile

BC> and everything went well. Today, I restored my
BC> datafiles from backup and i was greeted with the
BC> problem i just expalined to you.

BC> I am the only dba DBA at this location
BC> and i need some advise on what to do as this is a
BC> serious issue with my supervisor.

BC> Thanks,

BC> Bill 







BC> __
BC> Do You Yahoo!?
BC> Yahoo! Auctions - buy the things you want at great prices
BC> http://auctions.yahoo.com/


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 command question

[David A. Barbour]

It's commands like awk, grep, xargs and troff that give UNIX a bad
name.  I read somewhere (more years ago than I'd care to recall) that
you should always beware of an operating system with commands that
sounded like bad bodily functions.

Jared Still wrote:
> 
> Haven't seen this one mentioned yet:
> 
> find . -type d -print | xargs ls -ld
> 
> Jared
> 
> On Tuesday 01 May 2001 19:55, David A. Barbour wrote:
> > ls -Ra | grep /
> >
> > That's ls -Ra 'pipe' grep /
> >
> > You know, the spell checker has fits with the stuff on this list.
> >
> > Regards,
> >
> > David a. Barbour
> > Oracle DBA, OCP
> >
> > Roy Ferguson wrote:
> > > what I would like to see is all directories...not files starting with a
> > > particular letter but all directories...
> > >
> > > ls -d   - doesn't work
> > > ls -ld p*  - doesn't work either
> > >
> > > >Roy,
> > > >
> > > >You could do say ls -ld p* to list the directories starting with p.
> > > >
> > > >Rgds,
> > > >
> > > >raja
> > > >--
> > > >
> > > >On Tue, 01 May 2001 13:35:46
> > > >
> > > > Roy Ferguson wrote:
> > > >>what is the ls command to view only a list of directories?
> > > >>
> > > >>ls -la lists both files and directories...I want to view only a list of
> > > >>directories...
> > > >>
> > > >>environment is sun sparc solaris 2.6
> > > >>
> > > >>thanks in advance
> > > >>
> > > >>roy
> > > >>
> > > >>--
> > > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >>--
> > > >>Author: Roy Ferguson
> > > >>  INET: [EMAIL PROTECTED]
> > > >>
> > > >>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > >>San Diego, California-- Public Internet access / Mailing Lists
> > > >>
> > > >>To REMOVE yourself from this mailing list, send an E-Mail message
> > > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > >>the message BODY, include a line containing: UNSUB ORACLE-L
> > > >>(or the name of mailing list you want to be removed from).  You may
> > > >>also send the HELP command for other information (like subscribing).
> > > >
> > > >Get 250 color business cards for FREE!
> > > >http://businesscards.lycos.com/vp/fastpath/
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: Viraj Luthra
> > > >  INET: [EMAIL PROTECTED]
> > > >
> > > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > >San Diego, California-- Public Internet access / Mailing Lists
> > > >
> > > >To REMOVE yourself from this mailing list, send an E-Mail message
> > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > >the message BODY, include a line containing: UNSUB ORACLE-L
> > > >(or the name of mailing list you want to be removed from).  You may
> > > >also send the HELP command for other information (like subscribing).
> > >
> > > Roy E. Ferguson II
> > > Intel Sacramento
> > > 916-854-1123
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Roy Ferguson
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: [EMAIL PROTECTED]

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

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

RE: unix command question

[Mohan, Karthik (GEP)]

Title: RE: unix command question





You can also try the following 


ll |grep ^d 



Regards,
Karthik M




-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: unix command question




Haven't seen this one mentioned yet:


find . -type d -print | xargs ls -ld


Jared



On Tuesday 01 May 2001 19:55, David A. Barbour wrote:
> ls -Ra | grep /
>
> That's ls -Ra 'pipe' grep /
>
> You know, the spell checker has fits with the stuff on this list.
>
> Regards,
>
> David a. Barbour
> Oracle DBA, OCP
>
> Roy Ferguson wrote:
> > what I would like to see is all directories...not files starting with a
> > particular letter but all directories...
> >
> > ls -d   - doesn't work
> > ls -ld p*  - doesn't work either
> >
> > >Roy,
> > >
> > >You could do say ls -ld p* to list the directories starting with p.
> > >
> > >Rgds,
> > >
> > >raja
> > >--
> > >
> > >On Tue, 01 May 2001 13:35:46
> > >
> > > Roy Ferguson wrote:
> > >>what is the ls command to view only a list of directories?
> > >>
> > >>ls -la lists both files and directories...I want to view only a list of
> > >>directories...
> > >>
> > >>environment is sun sparc solaris 2.6
> > >>
> > >>thanks in advance
> > >>
> > >>roy
> > >>
> > >>--
> > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >>--
> > >>Author: Roy Ferguson
> > >>  INET: [EMAIL PROTECTED]
> > >>
> > >>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> > >>San Diego, California    -- Public Internet access / Mailing Lists
> > >>
> > >>To REMOVE yourself from this mailing list, send an E-Mail message
> > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >>the message BODY, include a line containing: UNSUB ORACLE-L
> > >>(or the name of mailing list you want to be removed from).  You may
> > >>also send the HELP command for other information (like subscribing).
> > >
> > >Get 250 color business cards for FREE!
> > >http://businesscards.lycos.com/vp/fastpath/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Viraj Luthra
> > >  INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California    -- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from).  You may
> > >also send the HELP command for other information (like subscribing).
> >
> > Roy E. Ferguson II
> > Intel Sacramento
> > 916-854-1123
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Roy Ferguson
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California    -- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Jared Still
  INET: [EMAIL PROTECTED]


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

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

Re: unix command question

[Jared Still]

Haven't seen this one mentioned yet:

find . -type d -print | xargs ls -ld

Jared


On Tuesday 01 May 2001 19:55, David A. Barbour wrote:
> ls -Ra | grep /
>
> That's ls -Ra 'pipe' grep /
>
> You know, the spell checker has fits with the stuff on this list.
>
> Regards,
>
> David a. Barbour
> Oracle DBA, OCP
>
> Roy Ferguson wrote:
> > what I would like to see is all directories...not files starting with a
> > particular letter but all directories...
> >
> > ls -d   - doesn't work
> > ls -ld p*  - doesn't work either
> >
> > >Roy,
> > >
> > >You could do say ls -ld p* to list the directories starting with p.
> > >
> > >Rgds,
> > >
> > >raja
> > >--
> > >
> > >On Tue, 01 May 2001 13:35:46
> > >
> > > Roy Ferguson wrote:
> > >>what is the ls command to view only a list of directories?
> > >>
> > >>ls -la lists both files and directories...I want to view only a list of
> > >>directories...
> > >>
> > >>environment is sun sparc solaris 2.6
> > >>
> > >>thanks in advance
> > >>
> > >>roy
> > >>
> > >>--
> > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >>--
> > >>Author: Roy Ferguson
> > >>  INET: [EMAIL PROTECTED]
> > >>
> > >>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >>San Diego, California-- Public Internet access / Mailing Lists
> > >>
> > >>To REMOVE yourself from this mailing list, send an E-Mail message
> > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >>the message BODY, include a line containing: UNSUB ORACLE-L
> > >>(or the name of mailing list you want to be removed from).  You may
> > >>also send the HELP command for other information (like subscribing).
> > >
> > >Get 250 color business cards for FREE!
> > >http://businesscards.lycos.com/vp/fastpath/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Viraj Luthra
> > >  INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from).  You may
> > >also send the HELP command for other information (like subscribing).
> >
> > Roy E. Ferguson II
> > Intel Sacramento
> > 916-854-1123
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Roy Ferguson
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: unix command question

[David A. Barbour]

ls -Ra | grep /

That's ls -Ra 'pipe' grep /

You know, the spell checker has fits with the stuff on this list.

Regards,

David a. Barbour
Oracle DBA, OCP

Roy Ferguson wrote:
> 
> what I would like to see is all directories...not files starting with a
> particular letter but all directories...
> 
> ls -d   - doesn't work
> ls -ld p*  - doesn't work either
> 
> >
> >Roy,
> >
> >You could do say ls -ld p* to list the directories starting with p.
> >
> >Rgds,
> >
> >raja
> >--
> >
> >On Tue, 01 May 2001 13:35:46
> > Roy Ferguson wrote:
> >>what is the ls command to view only a list of directories?
> >>
> >>ls -la lists both files and directories...I want to view only a list of
> >>directories...
> >>
> >>environment is sun sparc solaris 2.6
> >>
> >>thanks in advance
> >>
> >>roy
> >>
> >>--
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >>--
> >>Author: Roy Ferguson
> >>  INET: [EMAIL PROTECTED]
> >>
> >>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >>San Diego, California-- Public Internet access / Mailing Lists
> >>
> >>To REMOVE yourself from this mailing list, send an E-Mail message
> >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >>the message BODY, include a line containing: UNSUB ORACLE-L
> >>(or the name of mailing list you want to be removed from).  You may
> >>also send the HELP command for other information (like subscribing).
> >>
> >
> >
> >Get 250 color business cards for FREE!
> >http://businesscards.lycos.com/vp/fastpath/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Viraj Luthra
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> 
> Roy E. Ferguson II
> Intel Sacramento
> 916-854-1123
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Roy Ferguson
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: David A. Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows vs. UNIX (you are so ready for B*LLSH*T marketing, *!NOT!*)

[Jared Still]

I chuckle every time I see that ad.

Does IBM think they can lease Int'l phone line
capacity, have it all setup and working in 90 days?

It takes that long just to get DSL.

Jared


On Tuesday 01 May 2001 12:56, Eric D. Pierce wrote:
> Well, if I remember details correctly, the subtext of one of the ads
> is actually quite revealing.
>
> A young CEO/CIO announces, at a company party on the deck of a large
> luxury yacht, that the company is doing well, actually made a profit
> (what a concept!), and had attracted $20 million in additional
> investments.
>
> Someone asks how a whole bunch of their multinational IT
> infrastucture is going to be completely integrated in the 90 days
> required by the investors, and (after the blank stares from the
> un-tech-savy company faithful) the answer (at the conclusion of the
> ad) is something along the lines of "you are *s* ready for
> IBM".
>
> The unstated subtext is that presumably it will cost most/all of the
> $20 million of investment to get the IBM solution?
>
> regards,
> ep
>
> On 1 May 2001, at 6:36, Lord David wrote:
>
> Date sent:Tue, 01 May 2001 06:36:04 -0800
> To:   Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
>
> > Now IBM et al aren't going to spend huge amounts on these ads if they
> > didn't think it was worthwhile.  So, what gets me is the implication that
> > company directors will buy IBM, not because they have hard evidence that
> > they are faster/better/cheaper for their business, but because they get a
> > warm safe feeling from ads like these.  Doesn't fill me with much
> > confidence.
>
> ...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: RESOURCE role

[Jared Still]

On Monday 30 April 2001 20:55, Jacques Kilchoer wrote:
> Does anyone know how UNLIMITED TABLESPACE
> gets granted to the user along with the role RESOURCE ?

I've made a half-hearted search for it in the past.  I'm inclined
to think that it's hardwired into the kernel, though I have no
proof for that.

If it is in the kernel, the developers may be afraid to touch, as that
may require a lot of testing.

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

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

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

Re: No listner and tns packet error

[Jared Still]

It would help if you posted the exact error message.

>From what you describe, you have a network problem
that is not related to Oracle.  You need to talk to your
network admin.

Jared


On Tuesday 01 May 2001 09:30, Brijesh Lal wrote:
> Hi
>  I am facing one funny oracle failure. If i try to
> connect the client machine to linux oracle8i server I
> receive the error no listner. However when I see at
> linux server the listner is altready running.Again
> after sometime when I try to connect to oracle server
> I get same error for some time and then I get TNS
> packet failure error. After sometime I get connected
> to oracle server and then get disconenct after few
> minutes and again I get the same error no listner. I
> am totally puzzled with this problem can anyone help
> me in solving me this problem
>
> Looking forward for response from u all
>
> Brijesh
>
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/

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

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

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

Re: No listner and tns packet error

[Jared Still]

It would help if you posted the exact error message.

>From what you describe, you have a network problem
that is not related to Oracle.  You need to talk to your
network admin.

Jared


On Tuesday 01 May 2001 09:30, Brijesh Lal wrote:
> Hi
>  I am facing one funny oracle failure. If i try to
> connect the client machine to linux oracle8i server I
> receive the error no listner. However when I see at
> linux server the listner is altready running.Again
> after sometime when I try to connect to oracle server
> I get same error for some time and then I get TNS
> packet failure error. After sometime I get connected
> to oracle server and then get disconenct after few
> minutes and again I get the same error no listner. I
> am totally puzzled with this problem can anyone help
> me in solving me this problem
>
> Looking forward for response from u all
>
> Brijesh
>
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- marketing (was Windows vs. UNIX)

[Eric D. Pierce]

more surrealism:

"Joan Miro (1893-1983), The Farm (la granja/ la masia)"

http://www.mcs.csuhayward.edu/~malek/Miro.html
-
http://www.mala.bc.ca/~lanes/english/hemngway/miro.htm
-
http://www.mala.bc.ca/~lanes/english/hemngway/miro/farm.htm

note the small child ("caganer", literally translated as "shitter") 
squatting in the middle of the picture just above and left of the 
base of the tree trunk.

The picture was purchased by Hemingway in Paris. Miro supposedly
started it in catalunya, and finished after he moved to france. 
illustrates the combined catalan obsessions of organic rural themes 
and orderliness, and is considered an excellent example of "enyorada" 
(sp?) (extreme homesickness growing from a profound sense of loss
about the familiarities of the beloved motherland.)

The Miro museum in Barcelona is excellent, it is also in a fantastic 
location, on a small wooded mountain overlooking the "barri gotic", 
old city.

enjoy,
ep

On 1 May 2001, at 15:20, Mohan, Ross scribbled with alacrity and cogency:

Date sent:  Tue, 01 May 2001 15:20:28 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Truly, my joy knows no bounds. 

...

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

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

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

RE: unix command question

[Shaw, Donnie]

How about 

ls -ld */


-Original Message-
Sent: Tuesday, May 01, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


what I would like to see is all directories...not files starting with a 
particular letter but all directories...

ls -d   - doesn't work
ls -ld p*  - doesn't work either


>
>Roy,
>
>You could do say ls -ld p* to list the directories starting with p.
>
>Rgds,
>
>raja 
>--
>
>On Tue, 01 May 2001 13:35:46  
> Roy Ferguson wrote:
>>what is the ls command to view only a list of directories?
>>
>>ls -la lists both files and directories...I want to view only a list of 
>>directories...
>>
>>environment is sun sparc solaris 2.6
>>
>>thanks in advance
>>
>>roy
>>
>>-- 
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>-- 
>>Author: Roy Ferguson
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from).  You may
>>also send the HELP command for other information (like subscribing).
>>
>
>
>Get 250 color business cards for FREE!
>http://businesscards.lycos.com/vp/fastpath/
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Viraj Luthra
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




Roy E. Ferguson II
Intel Sacramento
916-854-1123

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw, Donnie
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT -- marketing (was Windows vs. UNIX)

[Mohan, Ross]

Truly, my joy knows no bounds. 

|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 6:55 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: OT -- marketing (was Windows vs. UNIX)
|| 
|| 
|| dude,
|| you forgot about "the additional application of vacuum, via 
|| puckered lips, to glistening posterior orbs". :)
|| ep
|| 
|| ps, in catalan "rauxa" (sp?) (wildness/abandon) is contrasted with 
|| "seny" (rational sensibility/orderliness). see the intro, or maybe 
|| beginning chapter of Robert Hughes book _Barcelona_.
|| 
|| 
|| On 1 May 2001, at 13:10, Mohan, Ross scribbled with alacrity 
|| and cogency:
|| 
|| > "Cross-optimized dung filters 
|| 
|| ...
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Eric D. Pierce
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: differences between physical datafile and v$datafile

[David A. Barbour]

File Header



David Jones wrote:
> 
> Dear Guru:
> 
> When I query the physical file size
> 
> oracle:>ls -l users01.dbf
> -rw-r-   1 oracle   dba  104865792 Apr 10 13:56 users01.dbf
> 
> compare with the size I get from the v$datafile
> SQL> select name, sum(bytes) from v$datafile where name like '%users%' group
> by name;
> 
> NAMESUM(BYTES)
> --- --
> /u02/oradata/GDB1/users01.dbf104857600
> 
> Why there're 8K difference ?
> 
> Thanks
> 
> --dj
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Jones
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: David A. Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 command question

[Behar, Rivaldi]

Title: RE: unix command question





ls -l | grep ^d  


Rivaldi


-Original Message-
From: Roy Ferguson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject: unix command question



what is the ls command to view only a list of directories?


ls -la lists both files and directories...I want to view only a list of 
directories...


environment is sun sparc solaris 2.6


thanks in advance


roy


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT -- marketing (was Windows vs. UNIX)

[Eric D. Pierce]

dude,
you forgot about "the additional application of vacuum, via 
puckered lips, to glistening posterior orbs". :)
ep

ps, in catalan "rauxa" (sp?) (wildness/abandon) is contrasted with 
"seny" (rational sensibility/orderliness). see the intro, or maybe 
beginning chapter of Robert Hughes book _Barcelona_.


On 1 May 2001, at 13:10, Mohan, Ross scribbled with alacrity and cogency:

> "Cross-optimized dung filters 

...


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

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

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

Re: unix command question

[Roy Ferguson]

what I would like to see is all directories...not files starting with a 
particular letter but all directories...

ls -d   - doesn't work
ls -ld p*  - doesn't work either


>
>Roy,
>
>You could do say ls -ld p* to list the directories starting with p.
>
>Rgds,
>
>raja 
>--
>
>On Tue, 01 May 2001 13:35:46  
> Roy Ferguson wrote:
>>what is the ls command to view only a list of directories?
>>
>>ls -la lists both files and directories...I want to view only a list of 
>>directories...
>>
>>environment is sun sparc solaris 2.6
>>
>>thanks in advance
>>
>>roy
>>
>>-- 
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>-- 
>>Author: Roy Ferguson
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from).  You may
>>also send the HELP command for other information (like subscribing).
>>
>
>
>Get 250 color business cards for FREE!
>http://businesscards.lycos.com/vp/fastpath/
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Viraj Luthra
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




Roy E. Ferguson II
Intel Sacramento
916-854-1123

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 command question

[tom panzarella]

ls -la | grep -e '^d'

the above works on Linux.

--t.

Roy Ferguson wrote:

> what is the ls command to view only a list of directories?
> 
> ls -la lists both files and directories...I want to view only a list of 
> directories...
> 
> environment is sun sparc solaris 2.6
> 
> thanks in advance
> 
> roy


-- 
C-x C-c

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 command question

[Viraj Luthra]

Roy,

You could do say ls -ld p* to list the directories starting with p.

Rgds,

raja 
--

On Tue, 01 May 2001 13:35:46  
 Roy Ferguson wrote:
>what is the ls command to view only a list of directories?
>
>ls -la lists both files and directories...I want to view only a list of 
>directories...
>
>environment is sun sparc solaris 2.6
>
>thanks in advance
>
>roy
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Roy Ferguson
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT -- marketing (was Windows vs. UNIX)

[Mohan, Ross]

Title: RE: OT -- marketing (was Windows vs. UNIX)



God, how I love 
this list. 

  -Original Message-From: Kirsh, Gary 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 01, 2001 6:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- marketing (was Windows vs. UNIX)
  Ross,
   
  Here's your prose after I ran it through the 
  Oraclizer:
   
  "Robust cross-optimized, scalable dung filters seamlessly harmonize 
  online B2B and B2C interactions, requiring deep instinct-based best-of-breed 
  CRM, BPE, SOL, and DOA products with a cutting edge, ass-centric, 
  butt-licking, customer driven coherence."
   
  This 
  now scores a jargon 6.  A little more practice, and you too can get a job 
  at Oracle!
   
  Gary
   
  Gary 
  Kirsh
  Next 
  Extent, Inc.
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 01, 2001 5:11 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
OT -- marketing (was Windows vs. UNIX)
Cute website, but sadly, it deemed my submission (below) to 
be level 1 - the best possible prose. 
Uh huh. 
"Cross-optimized dung filters harmonize online interactions 
requiring deep instinct-based CRM, BPE, SOL, and DOA products with a 
ass-centric, butt-licking coherence."
|| -Original Message- || 
From: Kirsh, Gary [mailto:[EMAIL PROTECTED]] 
|| Sent: Tuesday, May 01, 2001 4:20 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: OT -- marketing (was Windows vs. UNIX) 
|| || || 
Eric, || || Judging from 
their recent press releases, I'd say it does || NOT 
apply to their || marketing information.  Check 
for yourself, trying running || some of their 
|| finest marketing prose through the Jargonator at 
|| http://www.jargonfreeweb.com.  
I just tried the press release titled || "Mykrolis 
Takes Oracle Straight to the Bottom Line", and it || 
scored a 6 - || "Put it in the bottom of your bird 
cage and start over", the || highest (or 
|| lowest, depending on how you look at it) jargon 
score. || || To be fair, 
I've found Larry to be pretty good in this || 
regard, but as you || start moving down from the top 
of the Oracle management || pyramid, the 
jargon || really starts to snowball, to the point 
where I've seen (and || worked for) || some low-level managers who speak completely in meaningless, 
|| buzzword-laden || techno 
babble.  My theory is that the quantity of technical || jargon used is || inversely proportional 
to the speakers actual understanding of the || 
technology. || || 
Gary || || Gary Kirsh 
|| Next Extent, Inc || 
|| -Original Message- || Sent: Tuesday, May 01, 2001 3:40 PM || To: 
Multiple recipients of list ORACLE-L || 
|| || Does that apply to 
Oracle's complex, frequently nearly inpenetrable || 
ever changing jargon related to product line/descriptions and 
|| marketing/pricing information, or "just" the 
technology?   :) || || As far as the general topic of marketing effectiveness and/or 
|| failure, there used to be some sort of marketing 
industry award that || was given out to giant 
corporations that spent vast sums on || marketing 
|| consultants and ad campaigns that are huge flops. 
It is not unusual || at all. Of course it is 
essentially a virtual reality industry, so || you 
can imagine the difficulty of trying to q/a that stuff.  
|| || My guess is that one 
of the justifications for big IT corps to spend || 
vast sums on mass "public image" ads is to intimidate competition by 
|| creating the appearance of "normalcy" (about the 
corporation || doing th || 
advertising) in public opinion.  || 
|| In other words, when I see a TV ad for PacBell 
"data operations" || I know that it is probably even 
more of a huge pile of cr*p than the || average 
corporate ad, and somehow suspect it is related to || Worldcom's || ads, and some attempt to 
create a "perception" that PacBell is able || (is is 
soon going to be able) to effectively compete with || Worldcom in || data services. 
|| || etc. || || regards, || 
ep || || || On 1 May 2001, at 9:37, Kirsh, Gary wrote: || || Date 
sent:   Tue, 01 May 
2001 09:37:06 -0800 || 
To: 
 Multiple recipients of list ORACLE-L 
|| <[EMAIL PROTECTED]> || 
|| > To hear Larry's take on IBM and their new 
ads, go to || oracle.com and click || on || > this news story: 
|| > || > "Oracle declares 
war on complexity. Watch the webcast of || Larry 
Ellison's || > interview with Salomon Smith 
Barney and press conference." || || ... || || 
|| -- || Please see the 
official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce 
||   INET: [EMAIL PROTECTED] || || Fat City Network 
Services    -- (858

RE: OT -- marketing (was Windows vs. UNIX)

[Kirsh, Gary]

Title: RE: OT -- marketing (was Windows vs. UNIX)



Ross,
 
Here's 
your prose after I ran it through the Oraclizer:
 
"Robust cross-optimized, scalable dung filters seamlessly harmonize 
online B2B and B2C interactions, requiring deep instinct-based best-of-breed 
CRM, BPE, SOL, and DOA products with a cutting edge, ass-centric, butt-licking, 
customer driven coherence."
 
This 
now scores a jargon 6.  A little more practice, and you too can get a job 
at Oracle!
 
Gary
 
Gary 
Kirsh
Next 
Extent, Inc.

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 01, 2001 5:11 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- marketing (was Windows vs. UNIX)
  Cute website, but sadly, it deemed my submission (below) to be 
  level 1 - the best possible prose. 
  Uh huh. 
  "Cross-optimized dung filters harmonize online interactions 
  requiring deep instinct-based CRM, BPE, SOL, and DOA products with a 
  ass-centric, butt-licking coherence."
  || -Original Message- || From: 
  Kirsh, Gary [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 4:20 PM || To: 
  Multiple recipients of list ORACLE-L || Subject: RE: 
  OT -- marketing (was Windows vs. UNIX) || 
  || || Eric, || || Judging from their recent press releases, 
  I'd say it does || NOT apply to their || marketing information.  Check for yourself, trying running 
  || some of their || finest 
  marketing prose through the Jargonator at || http://www.jargonfreeweb.com.  I 
  just tried the press release titled || "Mykrolis Takes 
  Oracle Straight to the Bottom Line", and it || scored 
  a 6 - || "Put it in the bottom of your bird cage and 
  start over", the || highest (or || lowest, depending on how you look at it) jargon score. 
  || || To be fair, I've found Larry to 
  be pretty good in this || regard, but as you 
  || start moving down from the top of the Oracle management 
  || pyramid, the jargon || 
  really starts to snowball, to the point where I've seen (and || worked for) || some low-level managers who 
  speak completely in meaningless, || 
  buzzword-laden || techno babble.  My theory is 
  that the quantity of technical || jargon used 
  is || inversely proportional to the speakers actual 
  understanding of the || technology. || || Gary || 
  || Gary Kirsh || Next Extent, 
  Inc || || -Original 
  Message- || Sent: Tuesday, May 01, 2001 3:40 
  PM || To: Multiple recipients of list ORACLE-L 
  || || || Does 
  that apply to Oracle's complex, frequently nearly inpenetrable 
  || ever changing jargon related to product 
  line/descriptions and || marketing/pricing 
  information, or "just" the technology?   :) || || As far as the general topic of marketing 
  effectiveness and/or || failure, there used to be some 
  sort of marketing industry award that || was given out 
  to giant corporations that spent vast sums on || 
  marketing || consultants and ad campaigns that are 
  huge flops. It is not unusual || at all. Of course it 
  is essentially a virtual reality industry, so || you 
  can imagine the difficulty of trying to q/a that stuff.  || || My guess is that one of the 
  justifications for big IT corps to spend || vast sums 
  on mass "public image" ads is to intimidate competition by || creating the appearance of "normalcy" (about the corporation 
  || doing th || advertising) in 
  public opinion.  || || In 
  other words, when I see a TV ad for PacBell "data operations" || I know that it is probably even more of a huge pile of cr*p than the 
  || average corporate ad, and somehow suspect it is 
  related to || Worldcom's || 
  ads, and some attempt to create a "perception" that PacBell is able 
  || (is is soon going to be able) to effectively 
  compete with || Worldcom in || 
  data services. || || 
  etc. || || regards, 
  || ep || || 
  || On 1 May 2001, at 9:37, Kirsh, Gary wrote: 
  || || Date 
  sent:   Tue, 01 May 2001 
  09:37:06 -0800 || 
  To: 
   Multiple recipients of list ORACLE-L || <[EMAIL PROTECTED]> || 
  || > To hear Larry's take on IBM and their new ads, 
  go to || oracle.com and click || on || > this news story: || > || > "Oracle declares war on 
  complexity. Watch the webcast of || Larry 
  Ellison's || > interview with Salomon Smith Barney 
  and press conference." || || 
  ... || || || -- || Please see the official ORACLE-L FAQ: 
  http://www.orafaq.com 
  || -- || Author: Eric D. 
  Pierce ||   INET: [EMAIL PROTECTED] 
  || || Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051 
  || San Diego, 
  California    -- Public Internet access 
  / || Mailing Lists || 
   
  || To REMOVE yourself from this mailing list, send an E-Mail 
  message || to: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in || the message BODY, 
  include a line containing: UNSUB ORACLE-L || (or the 
  name of mailing list you wa

RE: differences between physical datafile and v$datafile

[Mohan, Ross]

Title: RE: differences between physical datafile and v$datafile





Because your db_block_size is 4K?


|| -Original Message-
|| From: David Jones [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 5:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: differences between physical datafile and v$datafile
|| 
|| 
|| Dear Guru:
|| 
|| When I query the physical file size
|| 
|| oracle:>ls -l users01.dbf
|| -rw-r-   1 oracle   dba  104865792 Apr 10 13:56 users01.dbf
|| 
|| compare with the size I get from the v$datafile
|| SQL> select name, sum(bytes) from v$datafile where name like 
|| '%users%' group 
|| by name;
|| 
|| NAME    SUM(BYTES)
|| --- --
|| /u02/oradata/GDB1/users01.dbf    104857600
|| 
|| Why there're 8K difference ?
|| 
|| Thanks
|| 
|| --dj
|| _
|| Get your FREE download of MSN Explorer at http://explorer.msn.com
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: David Jones
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California    -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 

unix command question

[Roy Ferguson]

what is the ls command to view only a list of directories?

ls -la lists both files and directories...I want to view only a list of 
directories...

environment is sun sparc solaris 2.6

thanks in advance

roy

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: differences between physical datafile and v$datafile

[Paul Baumgartel]

Every Oracle tablespace uses one Oracle block of overhead for
tablespace/datafile administrative information.

-Original Message-
Sent: Tuesday, May 01, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


Dear Guru:

When I query the physical file size

oracle:>ls -l users01.dbf
-rw-r-   1 oracle   dba  104865792 Apr 10 13:56 users01.dbf

compare with the size I get from the v$datafile
SQL> select name, sum(bytes) from v$datafile where name like '%users%' group

by name;

NAMESUM(BYTES)
--- --
/u02/oradata/GDB1/users01.dbf104857600

Why there're 8K difference ?

Thanks

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 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).

Constraint dependencies

[Yttri, Lisa]

Title: Constraint dependencies





Hi -


When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors?  I would like to be able to identify the order that the constraints should be dropped (or added) so that I can write a script to be automated ( for example, to refresh test data from production).

If anyone has any good ideas on how to do this, I'd really be interested in hearing from you.


Thanks -
Lisa

Re: Help - temp tablespace growing constantly

[Mohammad Rafiq]

You can claim back without rebouncing database by putting it offline and 
online at off-peak time...
Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 01 May 2001 06:36:05 -0800

If all of these segments are temporary then you can reclaim them when you
bounce the database.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 5:01 PM


 > The temp tablespace started at 1G and grew to 29G before croaking,
 > we have the same software running on older oracle versions without
incuring
 > the temp creep.
 >
 > -Original Message-
 > Sent: Monday, April 30, 2001 2:46 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > If you have the autoextend off, you might run out of space in your temp
 > tablespace. If you have autoextend on, your temp file will keep growing.
If
 > you have a reasonably sized tablespace, you might want to look at the
 > queries or index creations. How big is your entire database and how large
is
 > your temp tablespace. For example, we have a database of 35.3 gig and a
temp
 > tablespace of 1.5 gig and almost never run out of space. And when we do,
it
 > is almost always a bad select that is returning too much data.
 >
 > >>> [EMAIL PROTECTED] 04/30/01 01:10PM >>>
 > No but, when I turned it off it kept running out of space.
 >
 > -Original Message-
 > Sent: Friday, April 27, 2001 4:33 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > Does the temp tablespace has it's autoextend turned off?
 >
 > >>> [EMAIL PROTECTED] 04/27/01 04:55PM >>>
 > Under this situation try to offline temp tablespace and online it
 > immediately.
 >
 > Regards
 > Rafiq
 >
 >
 > Reply-To: [EMAIL PROTECTED]
 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
 > Date: Thu, 26 Apr 2001 13:05:26 -0800
 >
 > I've got a 8.05(2.6 patch on NT) db that the temp tablespace is 
constantly
 > growing. It's initially set to 1G , then grows up to around 25G before I
 > drop and recreate it. Called oracle support and they gave me a patch that
 > hasn't helped.
 > Anybody have some hints as to what to look for?
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Shaw, John B
 >INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of mailing list you want to be removed from).  You may
 > also send the HELP command for other information (like subscribing).
 >
 > _
 > Get your FREE download of MSN Explorer at http://explorer.msn.com
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Mohammad Rafiq
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of mailing list you want to be removed from).  You may
 > also send the HELP command for other information (like subscribing).
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: William Beilstein
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (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: Shaw, John B
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of m

Migration question

[Fred Smith]

Does anyone out there know what the best method would be to migrate from 
Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition?

It appears from the docs that the only way to migrate from Enterprise to 
Standard is to do an entire rebuild of the database.  (Export, de-install, 
re-install, Build all tablespaces, etc. and Import).  Is this correct?

OS:  Windows NT 4.0
DB:  Oracle 8.1.6  Enterprise (going to Standard)

Thank you.
-Fred Smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

Re: NOLOGGING creates txns in redo/archive logs

[Connor McDonald]

Only "nologging supported" operations will not result
in logging eg create index, direct load insert and
other such operations...

hth
connor

--- [EMAIL PROTECTED] wrote: >  
>  
> I have been testing logminer and noticed that when I
> alter a table to 
> NOLOGGING, txns are still recorded in the
> redo/archive logs. I thought 
> NOLOGGING was NOT supposed to do this. 
>  
> Anyone know if this is expected behavior?
>  
> At a recent 8i new features class, I explicitly
> asked the instructor this 
> question and he stated that nologging will not cause
> any records to be
> written 
> to the redo/archive logs.
> 
>  
>  
> TIA.
>  
> John Fedock
> iXL, Inc.
> 
>   [EMAIL PROTECTED] 
> http://www.ixl.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).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- marketing (was Windows vs. UNIX)

[Eric D. Pierce]

I know, I was just being droll/sarcastic.

Corporate-speak at Oracle is alive and well.

I could tell you about some bizarre fellini-esque and karka-esque 
conversations I've had with Oracle "account reps". You will be 
assimilated, resistance is futile (the Borg).  

In political/social theory terms, it is a perverse outcome of 
meritocracy, where the customer is an "unworthy" (the hierarchical 
psychosocial equivalent, in consumerist society, of a medieval slave 
or "serf") whose existence is defined by an ethos of greed and 
competition. Not exactly the most noble, elevated expression of the 
human spirit.  

But, like Churchill said, democratic capitalism is a horrible, 
brutual way of going about doing things, but it is better than any 
other known alternative.

regards,
ep


On 1 May 2001, at 12:20, Kirsh, Gary wrote:

Date sent:  Tue, 01 May 2001 12:20:26 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> Eric,
> 
> Judging from their recent press releases, I'd say it does NOT apply to their
> marketing information.  Check for yourself, trying running some of their
> finest marketing prose through the Jargonator at
> http://www.jargonfreeweb.com.  I just tried the press release titled
> "Mykrolis Takes Oracle Straight to the Bottom Line", and it scored a 6 -
> "Put it in the bottom of your bird cage and start over", the highest (or
> lowest, depending on how you look at it) jargon score.
> 
> To be fair, I've found Larry to be pretty good in this regard, but as you
> start moving down from the top of the Oracle management pyramid, the jargon
> really starts to snowball, to the point where I've seen (and worked for)
> some low-level managers who speak completely in meaningless, buzzword-laden
> techno babble.  My theory is that the quantity of technical jargon used is
> inversely proportional to the speakers actual understanding of the
> technology.
> 
> Gary
> 
> Gary Kirsh
> Next Extent, Inc
> 
> -Original Message-
> Sent: Tuesday, May 01, 2001 3:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Does that apply to Oracle's complex, frequently nearly inpenetrable 
> ever changing jargon related to product line/descriptions and 
> marketing/pricing information, or "just" the technology?   :)
> 
> As far as the general topic of marketing effectiveness and/or 
> failure, there used to be some sort of marketing industry award that 
> was given out to giant corporations that spent vast sums on marketing 
> consultants and ad campaigns that are huge flops. It is not unusual 
> at all. Of course it is essentially a virtual reality industry, so 
> you can imagine the difficulty of trying to q/a that stuff.  
> 
> My guess is that one of the justifications for big IT corps to spend 
> vast sums on mass "public image" ads is to intimidate competition by 
> creating the appearance of "normalcy" (about the corporation doing th 
> advertising) in public opinion.  
> 
> In other words, when I see a TV ad for PacBell "data operations"
> I know that it is probably even more of a huge pile of cr*p than the 
> average corporate ad, and somehow suspect it is related to Worldcom's 
> ads, and some attempt to create a "perception" that PacBell is able 
> (is is soon going to be able) to effectively compete with Worldcom in 
> data services.
> 
> etc.
> 
> regards,
> ep
> 
> 
> On 1 May 2001, at 9:37, Kirsh, Gary wrote:
> 
> Date sent:Tue, 01 May 2001 09:37:06 -0800
> To:   Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 
> > To hear Larry's take on IBM and their new ads, go to oracle.com and click
> on
> > this news story:
> > 
> > "Oracle declares war on complexity. Watch the webcast of Larry Ellison's
> > interview with Salomon Smith Barney and press conference."
> 
> ...
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kirsh, Gary
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourse

Re: SQL question

[Diana_Duncan]

But of course -- just use a negative one as the position to the instr
function.



>From the SQL manual:

INSTR searches string for substring.
 position is an integer indicating the character of string where Oracle
 begins the search. If position is negative, Oracle counts and searches
 backward from the end of string.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
P: 919.466.7337
F: 919.466.7427
E: [EMAIL PROTECTED]


   
  
Glenn Travis   
  
   
@wcom.com> cc: 
  
Sent by:   Fax to: 
  
[EMAIL PROTECTED]Subject: SQL question   
  
m  
  
   
  
   
  
05/01/2001 
  
04:36 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




How would you take the same string "/dir1/dir2/test/file.out", and return
"file.out".  Assume you do not know where the last '/' is or how many there
are.  What I need is a reverse instr function.  Find the last occurrance of
'/', not the first.

Can it be done in sqlplus???





-- 
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: OT -- marketing (was Windows vs. UNIX)

[Mohan, Ross]

Title: RE: OT -- marketing (was Windows vs. UNIX)





Cute website, but sadly, it deemed my submission (below) to be level 1 - the best possible prose. 


Uh huh. 



"Cross-optimized dung filters harmonize online interactions requiring deep instinct-based CRM, BPE, SOL, and DOA products with a ass-centric, butt-licking coherence."

|| -Original Message-
|| From: Kirsh, Gary [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 4:20 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: OT -- marketing (was Windows vs. UNIX)
|| 
|| 
|| Eric,
|| 
|| Judging from their recent press releases, I'd say it does 
|| NOT apply to their
|| marketing information.  Check for yourself, trying running 
|| some of their
|| finest marketing prose through the Jargonator at
|| http://www.jargonfreeweb.com.  I just tried the press release titled
|| "Mykrolis Takes Oracle Straight to the Bottom Line", and it 
|| scored a 6 -
|| "Put it in the bottom of your bird cage and start over", the 
|| highest (or
|| lowest, depending on how you look at it) jargon score.
|| 
|| To be fair, I've found Larry to be pretty good in this 
|| regard, but as you
|| start moving down from the top of the Oracle management 
|| pyramid, the jargon
|| really starts to snowball, to the point where I've seen (and 
|| worked for)
|| some low-level managers who speak completely in meaningless, 
|| buzzword-laden
|| techno babble.  My theory is that the quantity of technical 
|| jargon used is
|| inversely proportional to the speakers actual understanding of the
|| technology.
|| 
|| Gary
|| 
|| Gary Kirsh
|| Next Extent, Inc
|| 
|| -Original Message-
|| Sent: Tuesday, May 01, 2001 3:40 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Does that apply to Oracle's complex, frequently nearly inpenetrable 
|| ever changing jargon related to product line/descriptions and 
|| marketing/pricing information, or "just" the technology?   :)
|| 
|| As far as the general topic of marketing effectiveness and/or 
|| failure, there used to be some sort of marketing industry award that 
|| was given out to giant corporations that spent vast sums on 
|| marketing 
|| consultants and ad campaigns that are huge flops. It is not unusual 
|| at all. Of course it is essentially a virtual reality industry, so 
|| you can imagine the difficulty of trying to q/a that stuff.  
|| 
|| My guess is that one of the justifications for big IT corps to spend 
|| vast sums on mass "public image" ads is to intimidate competition by 
|| creating the appearance of "normalcy" (about the corporation 
|| doing th 
|| advertising) in public opinion.  
|| 
|| In other words, when I see a TV ad for PacBell "data operations"
|| I know that it is probably even more of a huge pile of cr*p than the 
|| average corporate ad, and somehow suspect it is related to 
|| Worldcom's 
|| ads, and some attempt to create a "perception" that PacBell is able 
|| (is is soon going to be able) to effectively compete with 
|| Worldcom in 
|| data services.
|| 
|| etc.
|| 
|| regards,
|| ep
|| 
|| 
|| On 1 May 2001, at 9:37, Kirsh, Gary wrote:
|| 
|| Date sent:   Tue, 01 May 2001 09:37:06 -0800
|| To:  Multiple recipients of list ORACLE-L
|| <[EMAIL PROTECTED]>
|| 
|| > To hear Larry's take on IBM and their new ads, go to 
|| oracle.com and click
|| on
|| > this news story:
|| > 
|| > "Oracle declares war on complexity. Watch the webcast of 
|| Larry Ellison's
|| > interview with Salomon Smith Barney and press conference."
|| 
|| ...
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Eric D. Pierce
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California    -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Kirsh, Gary
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California    -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Actual size of database

[Mohammad Rafiq]

Just to see dbsize in short
Use this


set pagesize 0 linesize 255 heading off feedback off
SELECT 'The database size is '|| ( (df.sum + rd.sum) / ( 1024
* 1024) )
 || 'Mbg excluding INI, password  and control files'
FROM
(SELECT SUM(bytes) sum FROM sys.dba_data_files) df,
(SELECT SUM(bytes * members) sum FROM v$log) rd;
set pagesize 24 heading on feedback on
/

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 01 May 2001 10:56:17 -0800

Below is the most complete tablespace script I have found.  I think you will
like it.

set pagesize 80 linesize 100 feedback off
column tablespace_name heading Tablespace format a19
column object_count heading 'Objects|(#)' format 90
column mb heading Mb format 9990
column sum(frags) heading 'Frags|(#)' format 
column avail heading 'Max|(Mb)' format .99
column free heading 'Free|(%)' format 999.9
column bytesize heading 'Size|(Mb)' format 999
column byteused heading 'Used|(Mb)' format 990
column bytefree heading 'Free|(Mb)' format 999
column init_ext heading 'Initial|(K)' format 99
column next_ext heading 'Next|(K)' format 99
break on report
compute sum of object_count bytesize byteused bytefree on report

select tablespace_name,
sum(obj_cnt) object_count,
sum(ini_ext) init_ext,
sum(nex_ext) next_ext,
sum(byte)/1048576 bytesize,
(sum(byte)/1048576)- (sum(fbyte)/1048576) byteused,
sum(fbyte)/1048576 bytefree,
sum(frags),
sum(largest)/1048576 avail,
(sum(fbyte)/sum(byte))*100 free
from
(select tablespace_name,
0 obj_cnt,
0 ini_ext,
0 nex_ext,
0 byte,
sum(bytes) fbyte,
count(*) frags,
max(bytes) largest
from dba_free_space
group by tablespace_name
union
select tablespace_name,
0, 0, 0, sum(bytes), 0, 0, 0
from dba_data_files
group by tablespace_name
union
select tablespace_name, 0,
initial_extent/1024 ini_ext,
next_extent/1024 nex_ext,
0,0,0,0
from dba_tablespaces
union
select tablespace_name,
count(*) obj_cnt,
0, 0, 0, 0, 0, 0
from dba_segments
group by tablespace_name)
group by tablespace_name
order by free desc;
set pagesize 24 feedback on verify on

-Original Message-
Sent: Tuesday, May 01, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


Here is one that I use.  I do not count the TEMP tablespace and the RBS
tablespace because these vary in size.

SELECT sum(bytes) DB_SIZE from dba_segments
where tablespace_name not in ('RBS','TMP')

You can do more math if you do not want the answer in bytes.

Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 2:11 PM


 > Hi All,
 >
 > Oracle 8.0.5 NT 4
 > Does anyone have a script they would share that can calculate the ACTUAL
 > size of a database(space_used) not what has been allocated?
 >
 > Thanks
 > Rick
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Cale, Rick T (Richard)
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of mailing list you want to be removed from).  You may
 > also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

-- 
Please see the official

differences between physical datafile and v$datafile

[David Jones]

Dear Guru:

When I query the physical file size

oracle:>ls -l users01.dbf
-rw-r-   1 oracle   dba  104865792 Apr 10 13:56 users01.dbf

compare with the size I get from the v$datafile
SQL> select name, sum(bytes) from v$datafile where name like '%users%' group 
by name;

NAMESUM(BYTES)
--- --
/u02/oradata/GDB1/users01.dbf104857600

Why there're 8K difference ?

Thanks

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

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

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

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

RE: SQL question

[Jamadagni, Rajendra]

SELECT SUBSTR( '/dir1/dir2/test/file.out'
  ,INSTR('/dir1/dir2/test/file.out','/', -1)+1)
FROM dual

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

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

*

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

*

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

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

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

Re: OCP Discount code

[Mohammad Rafiq]

It should be 'S36' . To verify visit htt://education.oracle.com

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 27 Apr 2001 09:36:20 -0800

Hi,

Please let me know the OTN discount code used for taking OCP.

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

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

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

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

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

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

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

Re: SQL question

[William Beilstein]

my_string := substr(in_string,instr(in_string,'/',-1)+1);


>>> [EMAIL PROTECTED] 05/01/01 04:36PM >>>
How would you take the same string "/dir1/dir2/test/file.out", and return
"file.out".  Assume you do not know where the last '/' is or how many there
are.  What I need is a reverse instr function.  Find the last occurrance of
'/', not the first.

Can it be done in sqlplus???

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: William Beilstein
  INET: [EMAIL PROTECTED]

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

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

RE: SQL question

[Glenn Travis]

Doh!  Forgot about the extra parameters to instr (like the negative value
for where to start searching!).  Thanks anyway and sorry about the wasted
bandwith.  For those interested, here's the answer;

select '/dir1/dir2/test/file.out' filenm,
substr('/dir1/dir2/test/file.out',
instr('/dir1/dir2/test/file.out','/',-1),length('/dir1/dir2/test/file.out'))
shortnm
from dual;

FILENM   SHORTNM
 
/dir1/dir2/test/file.out file.out


> -Original Message-
> From: Glenn Travis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 3:33 PM
> To: Oracle MailList LazyDBA
> Subject: SQL question
>
>
> How would you take the same string "/dir1/dir2/test/file.out",
> and return "file.out".  Assume you do not know where the last '/'
> is or how many there are.  What I need is a reverse instr
> function.  Find the last occurrance of '/', not the first.
>
> Can it be done in sqlplus???
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OS bloack size and ORACLE BLOCK SIZE

[Karthik Ramachandran]

The default block size is 8K with a fragment size of 1K i.e. files with size below 8K 
are allocated using 1K blocks increments and files larger than 8K are done in 8K 
increments except for the last block which may be a fragment.



>>> [EMAIL PROTECTED] 05/01/01 02:50PM >>>
Hi Everyone i'm trying to determine what my os block size is
My DB's have an 8k block size and i thought for best performance my os block
size should be the same.

So i run the command "df -g"
   8192 file system block size1024 fragment size
is the result

and i run the command "fstyp -v /dev/dbvg/dblv"
f_bsize: 1024
f_frsize: 1024
is the result

so what is my os block size, aren't these commands returning my filesystem
block size, or is that the same thing.
If i'm completly wrong how do i find out my OS block and should my
filesystem block be the same as that?
i'm on HPUX 10.20

Thanks David Hill

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Karthik Ramachandran
  INET: [EMAIL PROTECTED]

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

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

SQL question

[Glenn Travis]

How would you take the same string "/dir1/dir2/test/file.out", and return
"file.out".  Assume you do not know where the last '/' is or how many there
are.  What I need is a reverse instr function.  Find the last occurrance of
'/', not the first.

Can it be done in sqlplus???

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

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

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

Uniquely Weird - duplicate rows

[Koivu, Lisa]

Hello all, 

 
8.1.6.2 on HP/UX 
11.0
 
Has anyone seen 
something like this before?  I can't rebuild the primary key - the error is 
duplicate rows found. So I check the data (first listing) and see duplicate rows 
via fts.  When I give it a hint to use the primary key it shows 
nothing.  When I dump the rowid's, there are no dups.  
Weirdness.  I think I'll have to drop the index and create it from 
scratch.
 
SQL> select 
partner_id, category_id, relationship_type, count('x')  2   
from qode$partner_category_sold  3   group by partner_id, 
category_id, relationship_type  4   having count('x') > 
1;
 
PARTNER_ID 
CATEGORY_ID RE COUNT('X')-- --- -- 
--    
736844    2921 
VE  2    
736844    2922 
VE  2    
736844    3158 
VE  2    
736844    3160 
VE  2    
736844    3161 
VE  2    
736844    3162 
VE  2    
736844    3163 
VE  2    
736844    3164 
VE  2    
736844    3166 
VE  2    
736844    3233 
VE  2    
736844    3235 
VE  2    
736844    3249 
VE  2    
736844    3253 
VE  2    
736844    3255 
VE  2    
736844    3258 
VE  2    
736844    3262 
VE  2    
736844    3264 
VE  2    
736844    3273 
VE  2    
736844    3283 
VE  2    
736844    3297 
VE  2    
736844    3303 
VE  2
 
21 rows 
selected.
 
Execution 
Plan--   
0  SELECT STATEMENT 
Optimizer=CHOOSE   1    0   
FILTER   2    1 SORT (GROUP 
BY)   3    2   
TABLE ACCESS (FULL) OF 'PARTNER_CATEGORY_SOLD'
 
 
 
  1  
select /*+ index (pcs xpkpartner_category_sold) */  2  partner_id, 
category_id, relationship_type, count('x')  3   from 
qode$partner_category_sold pcs  4   group by partner_id, 
category_id, relationship_type  5*  having count('x') > 
1SQL> /
 
no rows 
selected
 
Execution 
Plan--   
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=26 
Card=144492 Bytes  
=4334760)
 
   
1    0   FILTER   2    
1 SORT (GROUP BY NOSORT) (Cost=26 Card=144492 
Bytes=433476  
0)
 
   
3    2   INDEX (FULL SCAN) OF 
'XPKPARTNER_CATEGORY_SOLD' 
(UNIQU  E) (Cost=26 
Card=144492 Bytes=4334760)
 
 
 
 
 


  
  

  
  
  Lisa 
  Rutland KoivuOracle Database 
  Administrator
  Certified 
  Self-Important Database Deity
  Slayer of Unix 
  Administrators
  Wanton 
  Kickboxing Goddess
  [EMAIL PROTECTED]4850 
  N.State Road 7, G104
  Ft. 
  Lauderdale, FL  33319Phone: 954-484-3191 x 
  138Fax: 954-484-2933www.neom.comwww.paperclick.comwww.qode.com
  
  

  

   
  
  
  

  

   
   
 
 

RE: No listner and tns packet error

[Behar, Rivaldi]

Title: RE: No listner and tns packet error





If ping is Ok and listener is running, try using IP address 
in your tnsnames.ora instead of machine name.


Rivaldi


-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: No listner and tns packet error



Did you include this database in your listener.ora file? 


Just a thot,
Ruth
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 12:30 PM



> Hi
>  I am facing one funny oracle failure. If i try to
> connect the client machine to linux oracle8i server I
> receive the error no listner. However when I see at
> linux server the listner is altready running.Again
> after sometime when I try to connect to oracle server
> I get same error for some time and then I get TNS
> packet failure error. After sometime I get connected
> to oracle server and then get disconenct after few
> minutes and again I get the same error no listner. I
> am totally puzzled with this problem can anyone help
> me in solving me this problem
> 
> Looking forward for response from u all
> 
> Brijesh
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Brijesh Lal
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: OT -- marketing (was Windows vs. UNIX)

[Kirsh, Gary]

Eric,

Judging from their recent press releases, I'd say it does NOT apply to their
marketing information.  Check for yourself, trying running some of their
finest marketing prose through the Jargonator at
http://www.jargonfreeweb.com.  I just tried the press release titled
"Mykrolis Takes Oracle Straight to the Bottom Line", and it scored a 6 -
"Put it in the bottom of your bird cage and start over", the highest (or
lowest, depending on how you look at it) jargon score.

To be fair, I've found Larry to be pretty good in this regard, but as you
start moving down from the top of the Oracle management pyramid, the jargon
really starts to snowball, to the point where I've seen (and worked for)
some low-level managers who speak completely in meaningless, buzzword-laden
techno babble.  My theory is that the quantity of technical jargon used is
inversely proportional to the speakers actual understanding of the
technology.

Gary

Gary Kirsh
Next Extent, Inc

-Original Message-
Sent: Tuesday, May 01, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


Does that apply to Oracle's complex, frequently nearly inpenetrable 
ever changing jargon related to product line/descriptions and 
marketing/pricing information, or "just" the technology?   :)

As far as the general topic of marketing effectiveness and/or 
failure, there used to be some sort of marketing industry award that 
was given out to giant corporations that spent vast sums on marketing 
consultants and ad campaigns that are huge flops. It is not unusual 
at all. Of course it is essentially a virtual reality industry, so 
you can imagine the difficulty of trying to q/a that stuff.  

My guess is that one of the justifications for big IT corps to spend 
vast sums on mass "public image" ads is to intimidate competition by 
creating the appearance of "normalcy" (about the corporation doing th 
advertising) in public opinion.  

In other words, when I see a TV ad for PacBell "data operations"
I know that it is probably even more of a huge pile of cr*p than the 
average corporate ad, and somehow suspect it is related to Worldcom's 
ads, and some attempt to create a "perception" that PacBell is able 
(is is soon going to be able) to effectively compete with Worldcom in 
data services.

etc.

regards,
ep


On 1 May 2001, at 9:37, Kirsh, Gary wrote:

Date sent:  Tue, 01 May 2001 09:37:06 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>

> To hear Larry's take on IBM and their new ads, go to oracle.com and click
on
> this news story:
> 
> "Oracle declares war on complexity. Watch the webcast of Larry Ellison's
> interview with Salomon Smith Barney and press conference."

...


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: No listner and tns packet error

[Ruth Gramolini]

Did you include this database in your listener.ora file? 

Just a thot,
Ruth
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 12:30 PM


> Hi
>  I am facing one funny oracle failure. If i try to
> connect the client machine to linux oracle8i server I
> receive the error no listner. However when I see at
> linux server the listner is altready running.Again
> after sometime when I try to connect to oracle server
> I get same error for some time and then I get TNS
> packet failure error. After sometime I get connected
> to oracle server and then get disconenct after few
> minutes and again I get the same error no listner. I
> am totally puzzled with this problem can anyone help
> me in solving me this problem
> 
> Looking forward for response from u all
> 
> Brijesh
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Brijesh Lal
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Windows vs. UNIX (you are so ready for B*LLSH*T marketing, *!NOT!*)

[Eric D. Pierce]

Well, if I remember details correctly, the subtext of one of the ads 
is actually quite revealing.  

A young CEO/CIO announces, at a company party on the deck of a large 
luxury yacht, that the company is doing well, actually made a profit 
(what a concept!), and had attracted $20 million in additional 
investments.  

Someone asks how a whole bunch of their multinational IT 
infrastucture is going to be completely integrated in the 90 days 
required by the investors, and (after the blank stares from the 
un-tech-savy company faithful) the answer (at the conclusion of the 
ad) is something along the lines of "you are *s* ready for 
IBM".  

The unstated subtext is that presumably it will cost most/all of the 
$20 million of investment to get the IBM solution?

regards,
ep

On 1 May 2001, at 6:36, Lord David wrote:

Date sent:  Tue, 01 May 2001 06:36:04 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Now IBM et al aren't going to spend huge amounts on these ads if they didn't
> think it was worthwhile.  So, what gets me is the implication that company
> directors will buy IBM, not because they have hard evidence that they are
> faster/better/cheaper for their business, but because they get a warm safe
> feeling from ads like these.  Doesn't fill me with much confidence.

...

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

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

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

RE: OT -- marketing (was Windows vs. UNIX)

[Eric D. Pierce]

Does that apply to Oracle's complex, frequently nearly inpenetrable 
ever changing jargon related to product line/descriptions and 
marketing/pricing information, or "just" the technology?   :)

As far as the general topic of marketing effectiveness and/or 
failure, there used to be some sort of marketing industry award that 
was given out to giant corporations that spent vast sums on marketing 
consultants and ad campaigns that are huge flops. It is not unusual 
at all. Of course it is essentially a virtual reality industry, so 
you can imagine the difficulty of trying to q/a that stuff.  

My guess is that one of the justifications for big IT corps to spend 
vast sums on mass "public image" ads is to intimidate competition by 
creating the appearance of "normalcy" (about the corporation doing th 
advertising) in public opinion.  

In other words, when I see a TV ad for PacBell "data operations"
I know that it is probably even more of a huge pile of cr*p than the 
average corporate ad, and somehow suspect it is related to Worldcom's 
ads, and some attempt to create a "perception" that PacBell is able 
(is is soon going to be able) to effectively compete with Worldcom in 
data services.

etc.

regards,
ep


On 1 May 2001, at 9:37, Kirsh, Gary wrote:

Date sent:  Tue, 01 May 2001 09:37:06 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> To hear Larry's take on IBM and their new ads, go to oracle.com and click on
> this news story:
> 
> "Oracle declares war on complexity. Watch the webcast of Larry Ellison's
> interview with Salomon Smith Barney and press conference."

...


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

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

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

RE: Actual size of database

[Smith, Ron L.]

Below is the most complete tablespace script I have found.  I think you will
like it.

set pagesize 80 linesize 100 feedback off
column tablespace_name heading Tablespace format a19
column object_count heading 'Objects|(#)' format 90
column mb heading Mb format 9990
column sum(frags) heading 'Frags|(#)' format 
column avail heading 'Max|(Mb)' format .99
column free heading 'Free|(%)' format 999.9
column bytesize heading 'Size|(Mb)' format 999
column byteused heading 'Used|(Mb)' format 990
column bytefree heading 'Free|(Mb)' format 999
column init_ext heading 'Initial|(K)' format 99
column next_ext heading 'Next|(K)' format 99
break on report
compute sum of object_count bytesize byteused bytefree on report

select tablespace_name,
sum(obj_cnt) object_count,
sum(ini_ext) init_ext,
sum(nex_ext) next_ext,
sum(byte)/1048576 bytesize,
(sum(byte)/1048576)- (sum(fbyte)/1048576) byteused,
sum(fbyte)/1048576 bytefree,
sum(frags),
sum(largest)/1048576 avail,
(sum(fbyte)/sum(byte))*100 free
from
(select tablespace_name,
0 obj_cnt,
0 ini_ext,
0 nex_ext,
0 byte,
sum(bytes) fbyte,
count(*) frags,
max(bytes) largest
from dba_free_space
group by tablespace_name
union
select tablespace_name,
0, 0, 0, sum(bytes), 0, 0, 0
from dba_data_files
group by tablespace_name
union
select tablespace_name, 0,
initial_extent/1024 ini_ext,
next_extent/1024 nex_ext,
0,0,0,0
from dba_tablespaces
union
select tablespace_name,
count(*) obj_cnt,
0, 0, 0, 0, 0, 0
from dba_segments
group by tablespace_name)
group by tablespace_name
order by free desc;
set pagesize 24 feedback on verify on

-Original Message-
Sent: Tuesday, May 01, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


Here is one that I use.  I do not count the TEMP tablespace and the RBS
tablespace because these vary in size.

SELECT sum(bytes) DB_SIZE from dba_segments
where tablespace_name not in ('RBS','TMP')

You can do more math if you do not want the answer in bytes.

Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 2:11 PM


> Hi All,
>
> Oracle 8.0.5 NT 4
> Does anyone have a script they would share that can calculate the ACTUAL
> size of a database(space_used) not what has been allocated?
>
> Thanks
> Rick
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

OS bloack size and ORACLE BLOCK SIZE

[hp]

Hi Everyone i'm trying to determine what my os block size is
My DB's have an 8k block size and i thought for best performance my os block
size should be the same.

So i run the command "df -g"
   8192 file system block size1024 fragment size
is the result

and i run the command "fstyp -v /dev/dbvg/dblv"
f_bsize: 1024
f_frsize: 1024
is the result

so what is my os block size, aren't these commands returning my filesystem
block size, or is that the same thing.
If i'm completly wrong how do i find out my OS block and should my
filesystem block be the same as that?
i'm on HPUX 10.20

Thanks David Hill

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Actual size of database

[Ruth Gramolini]

Here is one that I use.  I do not count the TEMP tablespace and the RBS
tablespace because these vary in size.

SELECT sum(bytes) DB_SIZE from dba_segments
where tablespace_name not in ('RBS','TMP')

You can do more math if you do not want the answer in bytes.

Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 2:11 PM


> Hi All,
>
> Oracle 8.0.5 NT 4
> Does anyone have a script they would share that can calculate the ACTUAL
> size of a database(space_used) not what has been allocated?
>
> Thanks
> Rick
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
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: OT -- marketing (was Windows vs. UNIX)

[Diana_Duncan]

Actually, Lee, you should enlighten us.  The last time I was in the U.K.
for any length of time (1998) the McD's there had far more non-beef and
even vegetarian options, which are only now catching on here.  So what can
we expect in the next few years from the enlightened McD's of Europe?

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
P: 919.466.7337
F: 919.466.7427
E: [EMAIL PROTECTED]


-- 
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: Actual size of database

[Tim Sawmiller]

set echo off
set pagesize 60
@my_tabs
spool sp_used
rem Calculate Percent of Space Used in Each Table Space
rem
column tablespace_name format a20
column tablespace heading TSPACE_NAME
column megs_alloc format 999,999.99
column megs_free format 999,999.99
column pct_used format 999.99
column megs_used format 999,999.99
column free_extents format 999,999
column free_extents heading FREE_EXT
break on report
compute sum of megs_alloc on report
compute sum of megs_free on report
compute sum of megs_used on report
ttitle 'Space Used'
select a.tablespace_name, (a.bytes/1048576) megs_alloc,
(b.bytes/1048576) megs_free, 
((a.bytes - b.bytes)/1048576) megs_used,
(100 - ((b.bytes/a.bytes) * 100)) pct_used,
b.free_extents
from tjs_allocated_space a, tjs_free_space b
where a.tablespace_name = b.tablespace_name (+)
order by a.tablespace_name;
spool off
set pagesize 20
set feedback off
drop table tjs_dba_extents;
drop table tjs_free_space;
drop table tjs_allocated_space ;
set feedback on
ttitle off

>>> [EMAIL PROTECTED] 05/01/01 02:11PM >>>
Hi All,

Oracle 8.0.5 NT 4
Does anyone have a script they would share that can calculate the ACTUAL
size of a database(space_used) not what has been allocated?

Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

Actual size of database

[Cale, Rick T (Richard)]

Hi All,

Oracle 8.0.5 NT 4
Does anyone have a script they would share that can calculate the ACTUAL
size of a database(space_used) not what has been allocated?

Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

RE: Recommendation for a *good* Psoft listserv

[Henry Poras]

John,
We are currently going through an HR upgrade to PS8. I guess that also would
make me interested in any good lists.

Henry

-Original Message-
Sent: Tuesday, May 01, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L


After a brief absence from the list due to a job switch and move from DC to
Atlanta, I'm back...  I missed the daily discussions/arguments/insight that
I have come to know and love. Thanks again to all of you who contribute
your knowledge.

I'm supporting a Peoplesoft Financials 7.5 implementation and 8.0 Upgrade,
and would love to get on a good Peoplesoft mailing list -preferably one
from a more technical standpoint.   I looked the Web over a bit and found a
few lists, but would like to find one that others have found useful.

Any and all recommendations are welcome and appreciated.


John Dailey
ING - Atlanta
Corporate Systems DBA


-- 
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: Henry Poras
  INET: [EMAIL PROTECTED]

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

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

Re:redo size and log_checkpoint_interval

[dgoulet]

Mitchell,

A check point must occur at the interval, timeout, and log switch.  Now in
my mind the least of these is the log switch which is controlled by the log file
size.  Other than the checkpoint and it's associated overhead, the only thing
else that happens during a log switch is the archiver making a copy of the log
to the archive_dest.

Where does all of this lead, well the size of the log file in many ways
affects the granularity of the recovery that can later be accomplished if and
when a disk drive fails.  I always assume that the worst thing possible will
happen, namely I'll loose an online redo log (and the active one to boot), when
that drive quits.  Now if you've for a 100MB log file then there is 40MB or 30
minutes of transactions that are lost.  On the other hand if you've got a 10MB
log with 3 minutes of transactions, then you can get a whole lot closer to right
now when you recover.

Which way you go is dependent on how close to failure time do you need to
get for your customenr (users) to be happy.  In my case the least amount of lost
transactions resluts in the least amount of product that has to be
tossed/retested resulting in the least $.

Which way you decide to go is very much an individual choice.  OH, BTW you
could mirror your log files to prevent the catastrophe, but in my case that
increases the disk $.

Dick Goulet

Reply Separator
Author: "Mitchell" <[EMAIL PROTECTED]>
Date:   4/30/2001 1:10 PM

Dear DBA

I have 130 gb database running on 7/24 basis. redo logfile size is 40mb and
oracle create about most to 400 archivive log. that mean log switch happend
at 3-4 min at peak time.

As oracle suggest, it is better log switch between 30min. (Why, if so that
need more recovery time?)
If  I will increase the size to 100mb and make time around 30 min. How about
Log_checkpooint_interval. My currently setting is 2097152 (20mb).
log_checkpoint_timeout = 0

As my understand, the interval based on volume. If setting is 100mb, mean 5
check point will occured at 20mb interval. I am right?

Any suggest?

Mitchell



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:OT RE: For those out there who also Hate MS

[dgoulet]

Ross,

It came from InformationWeek.  I get a daily news message from them.

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   5/1/2001 9:05 AM

did "David Ewalt" forward the entire
message to you, or wherever you got this from?

Sounds worth paying attention to, if there is
any backup. 

thx



|| -Original Message-
|| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 12:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: FYI: For those out there who also Hate MS
|| 
|| 
|| ** Microsoft Trolls For Informants
|| 
|| Microsoft is coming under fire for a new program that promises 
|| prizes to computer-system builders who report customers ordering 
|| PCs without a pre-installed operating system.
|| 
|| Microsoft unveiled the program in an E-mail apparently sent last 
|| week to system builders on the West Coast. The E-mail explains 
|| that the program is meant to insure compliance with 
|| software-licensing agreements. "Many organizations that are 
|| sending out bids believe that because they have enrolled in a 
|| Microsoft volume-license program... that operating systems for 
|| newly-acquired PCs are automatically enrolled," it reads. "There 
|| is no volume-licensing program at Microsoft that covers operating 
|| systems for new PCs."
|| 
|| As such, Microsoft asks that the builders turn over suspect bids 
|| to them. If the bids are found to be due to a site-license 
|| violation, informants will earn one point for each PC specified 
|| on the bid. The points can then be redeemed for prizes--five 
|| Microsoft game titles for 250 points; a Fossil "Big Tic" watch 
|| for 500; and a "Fast Cook & Grill Combo and Travel Chair" for 
|| 1,000.
|| 
|| Critics of Microsoft fear that the program will be used to track 
|| down or intimidate users of operating systems like Linux, who 
|| might order the machines "naked" in order to install the software 
|| themselves. "I think an argument exists that gathering 
|| information to [potentially] request an audit on businesses that 
|| choose not to buy Windows creates a chilling effect," wrote one 
|| poster on open-source advocacy site Slashdot.org.
|| 
|| "I think it's pretty sleazy," says Andrew Grygus, owner of 
|| Automation Access, a systems integrator for small businesses. 
|| Grygus, who received the E-mail last Wednesday, says "Microsoft 
|| doesn't seem to have a lot of respect for people. He adds that 
|| Microsoft is being "heavy handed" in its efforts to enforce 
|| licenses, but he doesn't think the company is actually hunting 
|| Linux users. "I'm sure they'll be happy to get those names, 
|| though." Grygus says he won't participate in the program. "I have 
|| no inclination to turn in my customers."
|| 
|| Representatives of Microsoft were unavailable for comment. 
|| - David M. Ewalt
|| -- 
|| 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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT -- marketing (was Windows vs. UNIX)

[Kirsh, Gary]

To hear Larry's take on IBM and their new ads, go to oracle.com and click on
this news story:

"Oracle declares war on complexity. Watch the webcast of Larry Ellison's
interview with Salomon Smith Barney and press conference."

Gary Kirsh
Next Extent, Inc

-Original Message-
Sent: Tuesday, May 01, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L


I'll check the McDonald's near my house, I'll get back to you on that one
tomorrow.

They have four on display, McRib being one, I'll see what the other ones are
- probably chicken varieties.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 01, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT -- marketing (was Windows vs. UNIX)

Could you enlighten us over here in the UK as to what other
"non-beef"
burgers they have introduced (apart from the McRib which has been
around
intermittently for years now) since the , and I quote "beef crises
in the
UK?"

Regards

Lee



 

 



-Original Message-
Sent: 01 May 2001 15:51
To: Multiple recipients of list ORACLE-L


Another example, to illustrate.  Those of you who have kids may
identify
with this one.

Twenty or thirty years ago you could have asked a 5 year old to play
the
word-association game too:

"McDonald's" - "Ronald McDonald", "Hamburgler", whatever.

Now it's more likely to be:

"McDonald's" - "toy"

They draw many more children that way than when children thought of
them of
just as a fun place to go.

Hey, if they had toys for database administrators, I would want to
go to
McDonald's too!

: )

P.S. Did you notice they have introduced the McRib, and other
"non-beef"
burgers since the beef crises in the UK?  They are now playing ads
about
this here in Canada, now.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Boivin, Patrice J 
Sent:   Tuesday, May 01, 2001 10:41 AM
To: '[EMAIL PROTECTED]'
Subject:RE: Windows vs. UNIX
Importance: Low

IBM is marketing themselves as a services company now.  

They are trying to change the way you perceive them, if you
want you
can play the word association game:  

"sky" - blue.
"cat" - claws.
"dog" - fur.
"HP" - laserjet printers.
"bank" - no money left.
"car" - gas prices.
"oracle" - databases.
"grocery store" - line ups
"Microsoft" - upgrades.
"shopping malls" - it's too warm
"IBM" - services company.   (if you thought "hardware",
that's
wrong, according to the ad.)

So - you have a crisis?  Call IBM, they will find what you
need,
package it as a solution for your problems, and voilà!

: )

Storage Solutions is like that too, in a way - many
companies now
"outsource" components that they used to manufacture themselves.

The "hole" they are trying to plug is people's perception of
their
company.  They are trying to "position" themselves differently.
Position
themselves differently in your mind...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
 
Sent:   Tuesday, May 01, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering
what in
the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads
lately
on British TV
where it shows a board meeting of some sort where
they are
having a crisis
(who's in charge of web servers, whos in charge of
desktop
support, blah
blah endless blah)- then everything focuses on an
individual
(usually a
director) with the comment: "That's when you realise
you
need IBM!"

Any insight from those all knowing "Oracles" out
there?

Mark

-O

OT RE: For those out there who also Hate MS

[Mohan, Ross]

did "David Ewalt" forward the entire
message to you, or wherever you got this from?

Sounds worth paying attention to, if there is
any backup. 

thx



|| -Original Message-
|| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 12:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: FYI: For those out there who also Hate MS
|| 
|| 
|| ** Microsoft Trolls For Informants
|| 
|| Microsoft is coming under fire for a new program that promises 
|| prizes to computer-system builders who report customers ordering 
|| PCs without a pre-installed operating system.
|| 
|| Microsoft unveiled the program in an E-mail apparently sent last 
|| week to system builders on the West Coast. The E-mail explains 
|| that the program is meant to insure compliance with 
|| software-licensing agreements. "Many organizations that are 
|| sending out bids believe that because they have enrolled in a 
|| Microsoft volume-license program... that operating systems for 
|| newly-acquired PCs are automatically enrolled," it reads. "There 
|| is no volume-licensing program at Microsoft that covers operating 
|| systems for new PCs."
|| 
|| As such, Microsoft asks that the builders turn over suspect bids 
|| to them. If the bids are found to be due to a site-license 
|| violation, informants will earn one point for each PC specified 
|| on the bid. The points can then be redeemed for prizes--five 
|| Microsoft game titles for 250 points; a Fossil "Big Tic" watch 
|| for 500; and a "Fast Cook & Grill Combo and Travel Chair" for 
|| 1,000.
|| 
|| Critics of Microsoft fear that the program will be used to track 
|| down or intimidate users of operating systems like Linux, who 
|| might order the machines "naked" in order to install the software 
|| themselves. "I think an argument exists that gathering 
|| information to [potentially] request an audit on businesses that 
|| choose not to buy Windows creates a chilling effect," wrote one 
|| poster on open-source advocacy site Slashdot.org.
|| 
|| "I think it's pretty sleazy," says Andrew Grygus, owner of 
|| Automation Access, a systems integrator for small businesses. 
|| Grygus, who received the E-mail last Wednesday, says "Microsoft 
|| doesn't seem to have a lot of respect for people. He adds that 
|| Microsoft is being "heavy handed" in its efforts to enforce 
|| licenses, but he doesn't think the company is actually hunting 
|| Linux users. "I'm sure they'll be happy to get those names, 
|| though." Grygus says he won't participate in the program. "I have 
|| no inclination to turn in my customers."
|| 
|| Representatives of Microsoft were unavailable for comment. 
|| - David M. Ewalt
|| -- 
|| 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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows vs. UNIX

[Mohan, Ross]

Title: RE: Windows vs. UNIX





Amen,brother. 


See, for starters, the seminal work "The Hidden Persuaders" by Vance Packard. 


and/or


"Four Reasons for Turning Off your TV"


    


|| -Original Message-
|| From: Dennis Taylor [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 11:42 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Windows vs. UNIX
|| 
|| 
|| At 03:55 AM 5/1/01 -0800, you wrote:
|| >If you are taking social psychology as well, maybe you can 
|| write a paper to
|| >explain why marketing tactics actually work, I never 
|| understood that one.
|| >
|| 
|| You are making the mistake of assuming that we are primarily thinking
|| beings. In fact, our intelligence is just a thin veneer on 
|| top of a whole
|| lotta animal. Advertising plays to our emotions, our 
|| insecurities, our
|| greed, etc. It bypasses your intelligence entirely, and it's 
|| generally
|| effective unless you consciously realize  you're being handled.
|| 
|| There are all kinds of sales and marketing tactics, such as 
|| barrier sales
|| and consistency leading that are simply empirically known to work.
|| 
|| 
|| Dennis Taylor
|| 
|| The only reason I'm not paranoid is to keep those
|| plotting against me off-guard.
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Dennis Taylor
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California    -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 

Java procedure indexes

[John Dunn]

When running load_java I find that the following indexes are created in the
users default tablespace(see below).

I want to create them in my INDEXES table space.

How can I do this for these indexes?

John



SQL> select index_name,index_type, table_name from user_indexes where
tablespace
_name='DATA'


INDEX_NAME INDEX_TYPE   TABLE_NAME
--
SYS_C00766 NORMAL  CREATE$JAVA$LOB$TABLE

SYS_C00767 NORMAL  JAVA$CLASS$MD5$TABLE

SYS_IL020329C2$$   LOBCREATE$JAVA$LOB$TABLE



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Rollbacks

[Danisment Gazi Unal (Unal Bilisim)]

Hi,

I don't talk about  especially XACTS. You may encounter negative value
when:

- if bstat/estat are not run in correct order
- bug

I know several bugs about that. But I don't remember bug number.


VIVEK_SHARMA wrote:

> report.txt :-
>
> What Does the NEGATIVE ( -1 ) Value for field XACTS (below) mean ?
>
> SVRMGR> Rem Waits_for_trans_tbl high implies you should add rollback
> segments.
> SVRMGR> select * from stats$roll;
> UNDO_SEGMENTTRANS_TBL_GETS  TRANS_TBL_WAITS
> UNDO_BYTES_WRITTEN  SEGMENT_SIZE_BYTES  XACTS   SHRINKS
> WRAPS
> --- --- ---
> --- --- ---
> --- ---
>   0 137   0
> 0  237568   0   0
> 0
>   2 880   0
> 46494610641408   0   0
> 1
>   3 913   1
> 79478010641408  -1   0
> 2
>
>
> NOTE - Banking Product with Database having 400 Concurrent Staff users
>
> Rollback Segments = 100 in number
> INITIAL_EXTENT = 512 K , NEXT_EXTENT = 512K ,  MINEXTENTS=20 ,
> OPTIMAL=10M
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Use itrprof SQL Analyzer.

It formats SQL_TRACE/Event10046 traces and gives tuning advises.

It's web based, no download, no configuration.
Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT -- marketing (was Windows vs. UNIX)

[Boivin, Patrice J]

I'll check the McDonald's near my house, I'll get back to you on that one
tomorrow.

They have four on display, McRib being one, I'll see what the other ones are
- probably chicken varieties.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 01, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT -- marketing (was Windows vs. UNIX)

Could you enlighten us over here in the UK as to what other
"non-beef"
burgers they have introduced (apart from the McRib which has been
around
intermittently for years now) since the , and I quote "beef crises
in the
UK?"

Regards

Lee



 

 



-Original Message-
Sent: 01 May 2001 15:51
To: Multiple recipients of list ORACLE-L


Another example, to illustrate.  Those of you who have kids may
identify
with this one.

Twenty or thirty years ago you could have asked a 5 year old to play
the
word-association game too:

"McDonald's" - "Ronald McDonald", "Hamburgler", whatever.

Now it's more likely to be:

"McDonald's" - "toy"

They draw many more children that way than when children thought of
them of
just as a fun place to go.

Hey, if they had toys for database administrators, I would want to
go to
McDonald's too!

: )

P.S. Did you notice they have introduced the McRib, and other
"non-beef"
burgers since the beef crises in the UK?  They are now playing ads
about
this here in Canada, now.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Boivin, Patrice J 
Sent:   Tuesday, May 01, 2001 10:41 AM
To: '[EMAIL PROTECTED]'
Subject:RE: Windows vs. UNIX
Importance: Low

IBM is marketing themselves as a services company now.  

They are trying to change the way you perceive them, if you
want you
can play the word association game:  

"sky" - blue.
"cat" - claws.
"dog" - fur.
"HP" - laserjet printers.
"bank" - no money left.
"car" - gas prices.
"oracle" - databases.
"grocery store" - line ups
"Microsoft" - upgrades.
"shopping malls" - it's too warm
"IBM" - services company.   (if you thought "hardware",
that's
wrong, according to the ad.)

So - you have a crisis?  Call IBM, they will find what you
need,
package it as a solution for your problems, and voilà!

: )

Storage Solutions is like that too, in a way - many
companies now
"outsource" components that they used to manufacture themselves.

The "hole" they are trying to plug is people's perception of
their
company.  They are trying to "position" themselves differently.
Position
themselves differently in your mind...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
 
Sent:   Tuesday, May 01, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering
what in
the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads
lately
on British TV
where it shows a board meeting of some sort where
they are
having a crisis
(who's in charge of web servers, whos in charge of
desktop
support, blah
blah endless blah)- then everything focuses on an
individual
(usually a
director) with the comment: "That's when you realise
you
need IBM!"

Any insight from those all knowing "Oracles" out
there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe
you can
write a paper to
explain why marketing tactics actually work, I never

No listner and tns packet error

[Brijesh Lal]

Hi
 I am facing one funny oracle failure. If i try to
connect the client machine to linux oracle8i server I
receive the error no listner. However when I see at
linux server the listner is altready running.Again
after sometime when I try to connect to oracle server
I get same error for some time and then I get TNS
packet failure error. After sometime I get connected
to oracle server and then get disconenct after few
minutes and again I get the same error no listner. I
am totally puzzled with this problem can anyone help
me in solving me this problem

Looking forward for response from u all

Brijesh

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brijesh Lal
  INET: [EMAIL PROTECTED]

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

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

FYI: For those out there who also Hate MS

[dgoulet]

** Microsoft Trolls For Informants

Microsoft is coming under fire for a new program that promises 
prizes to computer-system builders who report customers ordering 
PCs without a pre-installed operating system.

Microsoft unveiled the program in an E-mail apparently sent last 
week to system builders on the West Coast. The E-mail explains 
that the program is meant to insure compliance with 
software-licensing agreements. "Many organizations that are 
sending out bids believe that because they have enrolled in a 
Microsoft volume-license program... that operating systems for 
newly-acquired PCs are automatically enrolled," it reads. "There 
is no volume-licensing program at Microsoft that covers operating 
systems for new PCs."

As such, Microsoft asks that the builders turn over suspect bids 
to them. If the bids are found to be due to a site-license 
violation, informants will earn one point for each PC specified 
on the bid. The points can then be redeemed for prizes--five 
Microsoft game titles for 250 points; a Fossil "Big Tic" watch 
for 500; and a "Fast Cook & Grill Combo and Travel Chair" for 
1,000.

Critics of Microsoft fear that the program will be used to track 
down or intimidate users of operating systems like Linux, who 
might order the machines "naked" in order to install the software 
themselves. "I think an argument exists that gathering 
information to [potentially] request an audit on businesses that 
choose not to buy Windows creates a chilling effect," wrote one 
poster on open-source advocacy site Slashdot.org.

"I think it's pretty sleazy," says Andrew Grygus, owner of 
Automation Access, a systems integrator for small businesses. 
Grygus, who received the E-mail last Wednesday, says "Microsoft 
doesn't seem to have a lot of respect for people. He adds that 
Microsoft is being "heavy handed" in its efforts to enforce 
licenses, but he doesn't think the company is actually hunting 
Linux users. "I'm sure they'll be happy to get those names, 
though." Grygus says he won't participate in the program. "I have 
no inclination to turn in my customers."

Representatives of Microsoft were unavailable for comment. 
- David M. Ewalt
-- 
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).

Recommendation for a *good* Psoft listserv

[John . Dailey]

After a brief absence from the list due to a job switch and move from DC to
Atlanta, I'm back...  I missed the daily discussions/arguments/insight that
I have come to know and love. Thanks again to all of you who contribute
your knowledge.

I'm supporting a Peoplesoft Financials 7.5 implementation and 8.0 Upgrade,
and would love to get on a good Peoplesoft mailing list -preferably one
from a more technical standpoint.   I looked the Web over a bit and found a
few lists, but would like to find one that others have found useful.

Any and all recommendations are welcome and appreciated.


John Dailey
ING - Atlanta
Corporate Systems DBA


-- 
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: OT -- marketing (was Windows vs. UNIX)

[Tim Sawmiller]

"IBM" - "HAL"

>>> [EMAIL PROTECTED] 05/01/01 10:50AM >>>
Another example, to illustrate.  Those of you who have kids may identify
with this one.

Twenty or thirty years ago you could have asked a 5 year old to play the
word-association game too:

"McDonald's" - "Ronald McDonald", "Hamburgler", whatever.

Now it's more likely to be:

"McDonald's" - "toy"

They draw many more children that way than when children thought of them of
just as a fun place to go.

Hey, if they had toys for database administrators, I would want to go to
McDonald's too!

: )

P.S. Did you notice they have introduced the McRib, and other "non-beef"
burgers since the beef crises in the UK?  They are now playing ads about
this here in Canada, now.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Boivin, Patrice J 
Sent:   Tuesday, May 01, 2001 10:41 AM
To: '[EMAIL PROTECTED]' 
Subject:RE: Windows vs. UNIX
Importance: Low

IBM is marketing themselves as a services company now.  

They are trying to change the way you perceive them, if you want you
can play the word association game:  

"sky" - blue.
"cat" - claws.
"dog" - fur.
"HP" - laserjet printers.
"bank" - no money left.
"car" - gas prices.
"oracle" - databases.
"grocery store" - line ups
"Microsoft" - upgrades.
"shopping malls" - it's too warm
"IBM" - services company.   (if you thought "hardware", that's
wrong, according to the ad.)

So - you have a crisis?  Call IBM, they will find what you need,
package it as a solution for your problems, and voilà!

: )

Storage Solutions is like that too, in a way - many companies now
"outsource" components that they used to manufacture themselves.

The "hole" they are trying to plug is people's perception of their
company.  They are trying to "position" themselves differently.  Position
themselves differently in your mind...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]] 
 
Sent:   Tuesday, May 01, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering what in
the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads lately
on British TV
where it shows a board meeting of some sort where they are
having a crisis
(who's in charge of web servers, whos in charge of desktop
support, blah
blah endless blah)- then everything focuses on an individual
(usually a
director) with the comment: "That's when you realise you
need IBM!"

Any insight from those all knowing "Oracles" out there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe you can
write a paper to
explain why marketing tactics actually work, I never
understood that one.

Why is using imagery and imparting moods more effective at
selling than
facts and a track record?

Once you have finished that paper, please send it to me,
because I still
don't understand.

e.g. last night on TV there was a Bridgestone commercial,
talking about
integrity, reliability.  It seems obvious to me that their
sales have
dropped, they did a marketing study and discovered that
ooops!  People don't
trust them anymore.  So they concoct an advertisement to
present themselves
as reliable, to plug a hole so to speak.  This is just an
example, most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system
administrator with nothing
to do because she was using Windows2000 servers, and
therefore had no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., I
am responsible
for the effect of sharing my honest opinions, blah blah
blah)

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Roy Ferguson [

RE: OT -- marketing (was Windows vs. UNIX)

[Robertson Lee - lerobe]

Could you enlighten us over here in the UK as to what other "non-beef"
burgers they have introduced (apart from the McRib which has been around
intermittently for years now) since the , and I quote "beef crises in the
UK?"

Regards

Lee



 

 



-Original Message-
Sent: 01 May 2001 15:51
To: Multiple recipients of list ORACLE-L


Another example, to illustrate.  Those of you who have kids may identify
with this one.

Twenty or thirty years ago you could have asked a 5 year old to play the
word-association game too:

"McDonald's" - "Ronald McDonald", "Hamburgler", whatever.

Now it's more likely to be:

"McDonald's" - "toy"

They draw many more children that way than when children thought of them of
just as a fun place to go.

Hey, if they had toys for database administrators, I would want to go to
McDonald's too!

: )

P.S. Did you notice they have introduced the McRib, and other "non-beef"
burgers since the beef crises in the UK?  They are now playing ads about
this here in Canada, now.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Boivin, Patrice J 
Sent:   Tuesday, May 01, 2001 10:41 AM
To: '[EMAIL PROTECTED]'
Subject:RE: Windows vs. UNIX
Importance: Low

IBM is marketing themselves as a services company now.  

They are trying to change the way you perceive them, if you want you
can play the word association game:  

"sky" - blue.
"cat" - claws.
"dog" - fur.
"HP" - laserjet printers.
"bank" - no money left.
"car" - gas prices.
"oracle" - databases.
"grocery store" - line ups
"Microsoft" - upgrades.
"shopping malls" - it's too warm
"IBM" - services company.   (if you thought "hardware", that's
wrong, according to the ad.)

So - you have a crisis?  Call IBM, they will find what you need,
package it as a solution for your problems, and voilà!

: )

Storage Solutions is like that too, in a way - many companies now
"outsource" components that they used to manufacture themselves.

The "hole" they are trying to plug is people's perception of their
company.  They are trying to "position" themselves differently.  Position
themselves differently in your mind...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
 
Sent:   Tuesday, May 01, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering what in
the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads lately
on British TV
where it shows a board meeting of some sort where they are
having a crisis
(who's in charge of web servers, whos in charge of desktop
support, blah
blah endless blah)- then everything focuses on an individual
(usually a
director) with the comment: "That's when you realise you
need IBM!"

Any insight from those all knowing "Oracles" out there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe you can
write a paper to
explain why marketing tactics actually work, I never
understood that one.

Why is using imagery and imparting moods more effective at
selling than
facts and a track record?

Once you have finished that paper, please send it to me,
because I still
don't understand.

e.g. last night on TV there was a Bridgestone commercial,
talking about
integrity, reliability.  It seems obvious to me that their
sales have
dropped, they did a marketing study and discovered that
ooops!  People don't
trust them anymore.  So they concoct an advertisement to
present themselves
as reliable, to plug a hole so to speak.  This is just an
example, most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system
administrator with nothing
to do because she was using Windows2000 servers, and
therefore had no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., 

Re: Could not Connect to 8.1.6

[Jyoti Randive]

What is the error that you are getting ? Do you get a core dump? Are you using connect string to connect ?
 I have seen situations when connecting from 8.0.5 home doing a core dump(on HP-UX) when connecting to 8.1.5 which was a bug.
JyotiGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jyoti Randive
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Help - temp tablespace growing constantly

[Ruth Gramolini]

If all of these segments are temporary then you can reclaim them when you
bounce the database.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 5:01 PM


> The temp tablespace started at 1G and grew to 29G before croaking,
> we have the same software running on older oracle versions without
incuring
> the temp creep.
>
> -Original Message-
> Sent: Monday, April 30, 2001 2:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If you have the autoextend off, you might run out of space in your temp
> tablespace. If you have autoextend on, your temp file will keep growing.
If
> you have a reasonably sized tablespace, you might want to look at the
> queries or index creations. How big is your entire database and how large
is
> your temp tablespace. For example, we have a database of 35.3 gig and a
temp
> tablespace of 1.5 gig and almost never run out of space. And when we do,
it
> is almost always a bad select that is returning too much data.
>
> >>> [EMAIL PROTECTED] 04/30/01 01:10PM >>>
> No but, when I turned it off it kept running out of space.
>
> -Original Message-
> Sent: Friday, April 27, 2001 4:33 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Does the temp tablespace has it's autoextend turned off?
>
> >>> [EMAIL PROTECTED] 04/27/01 04:55PM >>>
> Under this situation try to offline temp tablespace and online it
> immediately.
>
> Regards
> Rafiq
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Thu, 26 Apr 2001 13:05:26 -0800
>
> I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly
> growing. It's initially set to 1G , then grows up to around 25G before I
> drop and recreate it. Called oracle support and they gave me a patch that
> hasn't helped.
> Anybody have some hints as to what to look for?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shaw, John B
>INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: William Beilstein
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Shaw, John B
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: William Beilstein
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California 

RE: Oracle What savepoints are active for a given session?

[Steve Adams]

Hi Venkata,

There is no V$ view or X$ table that contains this information. The only
solution that occurs to me is to dump the savepoints to the process trace file
with

alter session set events 'immediate trace name savepoints';

and then use UTL_FILE to read and parse the trace file information. Here is an
example of what you might get:

SAVEPOINT FOR CURRENT PROCESS
--
   flag: 0x3
   name: S3
   dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
   status: VALID, next: 3822f60
   name: S2
   dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
   status: VALID, next: 37f63ec
   name: S1
   dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
   status: VALID, next: 0

This process has three savepoints named S1, S2 and S3 respectively.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Tuesday, 1 May 2001 18:20
To: Multiple recipients of list ORACLE-L


HI  PLEASE SEND ME ANSWER
Question Title: Oracle What savepoints are active for a given session?

Detailed Question: Does anybody know IF and HOW can I get a list of
active savepoints for the current session? I need a native way, not
solutions based on additional application-level housekeeping. Some query
on the V$ tables/views would be the kind of answer I'm looking for.
Details: Within one stored proc I'd like to obtain a list (in any form)
of the savepoints issued currently in the current transaction. Example:
Proc A issues savepoint svA; then proc B issues savepoint svB; and then
proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
something like that. Of course, there are no intervening commits or
rollbacks.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: NOLOGGING creates txns in redo/archive logs

[Janet Schmitt 265-3334]

John -

I had this same question not too long ago.   This is what I found in 
the documentation.

Only the following operations can make use of the NOLOGGING option: 

  alter table...move partition 
  alter table...split partition 
  alter index...split partition 
  alter index...rebuild 
  alter index...rebuild partition 
  create table...as select 
  create index 
  direct load with SQL*Loader 
  direct load INSERT 

  Other SQL statements (such as UPDATE, DELETE, conventional path
  INSERT, and various DDL statements not listed above) are unaffected
  by the NOLOGGING attribute of the schema object. 

HTH. 

Janet Schmitt.


>  
>  
> I have been testing logminer and noticed that when I alter a table to 
> NOLOGGING, txns are still recorded in the redo/archive logs. I thought 
> NOLOGGING was NOT supposed to do this. 
>  
> Anyone know if this is expected behavior?
>  
> At a recent 8i new features class, I explicitly asked the instructor this 
> question and he stated that nologging will not cause any records to be
> written 
> to the redo/archive logs.
> 
>  
>  
> TIA.
>  
> John Fedock
> iXL, Inc.
> 
>   [EMAIL PROTECTED] 
> http://www.ixl.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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Schmitt 265-3334
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows vs. UNIX

[Dennis Taylor]

At 03:55 AM 5/1/01 -0800, you wrote:
>If you are taking social psychology as well, maybe you can write a paper to
>explain why marketing tactics actually work, I never understood that one.
>

You are making the mistake of assuming that we are primarily thinking
beings. In fact, our intelligence is just a thin veneer on top of a whole
lotta animal. Advertising plays to our emotions, our insecurities, our
greed, etc. It bypasses your intelligence entirely, and it's generally
effective unless you consciously realize  you're being handled.

There are all kinds of sales and marketing tactics, such as barrier sales
and consistency leading that are simply empirically known to work.


Dennis Taylor

The only reason I'm not paranoid is to keep those
plotting against me off-guard.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows vs. UNIX

[Marianne Brooks]

Title: RE: Windows vs. UNIX





Well, here in the states, IBM stands for Ibuprofen, Beer and Margaritas.


Marianne


-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Windows vs. UNIX



For all those in the UK - I am sat here wondering what in the world the IBM
ads could do in the way of "plugging the hole"?


For US/International: we have had a spate of IBM ads lately on British TV
where it shows a board meeting of some sort where they are having a crisis
(who's in charge of web servers, whos in charge of desktop support, blah
blah endless blah)- then everything focuses on an individual (usually a
director) with the comment: "That's when you realise you need IBM!"


Any insight from those all knowing "Oracles" out there?


Mark

Somewhat OT: Blobs and Ordimage types

[Yttri, Lisa]

Title: Somewhat OT:  Blobs and Ordimage types





Hi -


We have an application group that is interested in storing documents in the database.  Some of these documents are word docs or excel spreadsheets, while others are actual image files.  We have looked into the interMedia ordimage type, which seems to work great for the images, but doesn't work for the documents.

Is there some other way within interMedia to manipulate the documents?


Would they need more than one column - ie. one to store images and another to store documents?


From a DBA perspective - does it make sense to store these in the database?


Thanks for any help you can offer -
Lisa

RE: Windows vs. UNIX

[Boivin, Patrice J]

IBM is marketing themselves as a services company now.  

They are trying to change the way you perceive them, if you want you can
play the word association game:  

"sky" - blue.
"cat" - claws.
"dog" - fur.
"HP" - laserjet printers.
"bank" - no money left.
"car" - gas prices.
"oracle" - databases.
"grocery store" - line ups
"Microsoft" - upgrades.
"shopping malls" - it's too warm
"IBM" - services company.   (if you thought "hardware", that's wrong,
according to the ad.)

So - you have a crisis?  Call IBM, they will find what you need, package it
as a solution for your problems, and voilà!

: )

Storage Solutions is like that too, in a way - many companies now
"outsource" components that they used to manufacture themselves.

The "hole" they are trying to plug is people's perception of their company.
They are trying to "position" themselves differently.  Position themselves
differently in your mind...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 01, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering what in the world
the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads lately on
British TV
where it shows a board meeting of some sort where they are having a
crisis
(who's in charge of web servers, whos in charge of desktop support,
blah
blah endless blah)- then everything focuses on an individual
(usually a
director) with the comment: "That's when you realise you need IBM!"

Any insight from those all knowing "Oracles" out there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe you can write a
paper to
explain why marketing tactics actually work, I never understood that
one.

Why is using imagery and imparting moods more effective at selling
than
facts and a track record?

Once you have finished that paper, please send it to me, because I
still
don't understand.

e.g. last night on TV there was a Bridgestone commercial, talking
about
integrity, reliability.  It seems obvious to me that their sales
have
dropped, they did a marketing study and discovered that ooops!
People don't
trust them anymore.  So they concoct an advertisement to present
themselves
as reliable, to plug a hole so to speak.  This is just an example,
most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system administrator with
nothing
to do because she was using Windows2000 servers, and therefore had
no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., I am
responsible
for the effect of sharing my honest opinions, blah blah blah)

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Roy Ferguson [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 30, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

this information is actually a proposal that I created for a
college
course I'm
taking...I have a lot of experience with UNIX and very
little with
Windows...that's why I only needed the facts and no
opinions...


>
>Roy,
>
>Forgive me my lack of understanding, but if you don't
>know why one would choose Unix over Windows, why are
>you proposing Unix altogether?
>
>Yosi
>
>> -Original Message-
>> From: Roy Ferguson [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, April 30, 2001 2:46 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Windows vs. UNIX
>>
>>
>> this is not to bring up a heated debate over the two
platforms...
>>
>> I am making a proposal to move the current access 97
>> databases to an oralce
>> platform running solaris  I would like to put in the
>> proposal a brief reason
>> why a UNIX platform will be better than a Windows
platform.
>>
>> the curr

RE: Help - temp tablespace growing constantly

[Miller, Jay]

You probably already checked this, but if you have PCTINCREASE set to
something other than 0 on the tablespace this might be contributing to the
problem.
What are the INITIAL, NEXT and PCTINCREASE settings?


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


The temp tablespace started at 1G and grew to 29G before croaking,
we have the same software running on older oracle versions without incuring
the temp creep.

-Original Message-
Sent: Monday, April 30, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L


If you have the autoextend off, you might run out of space in your temp
tablespace. If you have autoextend on, your temp file will keep growing. If
you have a reasonably sized tablespace, you might want to look at the
queries or index creations. How big is your entire database and how large is
your temp tablespace. For example, we have a database of 35.3 gig and a temp
tablespace of 1.5 gig and almost never run out of space. And when we do, it
is almost always a bad select that is returning too much data.

>>> [EMAIL PROTECTED] 04/30/01 01:10PM >>>
No but, when I turned it off it kept running out of space.

-Original Message-
Sent: Friday, April 27, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L


Does the temp tablespace has it's autoextend turned off?

>>> [EMAIL PROTECTED] 04/27/01 04:55PM >>>
Under this situation try to offline temp tablespace and online it 
immediately.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 26 Apr 2001 13:05:26 -0800

I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly
growing. It's initially set to 1G , then grows up to around 25G before I
drop and recreate it. Called oracle support and they gave me a patch that
hasn't helped.
Anybody have some hints as to what to look for?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Shaw, John B
   INET: [EMAIL PROTECTED] 

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

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

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

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Shaw, John B
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: William Beilstein
  INET: [EMAIL PROTECTED]

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

OT -- marketing (was Windows vs. UNIX)

[Boivin, Patrice J]

Another example, to illustrate.  Those of you who have kids may identify
with this one.

Twenty or thirty years ago you could have asked a 5 year old to play the
word-association game too:

"McDonald's" - "Ronald McDonald", "Hamburgler", whatever.

Now it's more likely to be:

"McDonald's" - "toy"

They draw many more children that way than when children thought of them of
just as a fun place to go.

Hey, if they had toys for database administrators, I would want to go to
McDonald's too!

: )

P.S. Did you notice they have introduced the McRib, and other "non-beef"
burgers since the beef crises in the UK?  They are now playing ads about
this here in Canada, now.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Boivin, Patrice J 
Sent:   Tuesday, May 01, 2001 10:41 AM
To: '[EMAIL PROTECTED]'
Subject:RE: Windows vs. UNIX
Importance: Low

IBM is marketing themselves as a services company now.  

They are trying to change the way you perceive them, if you want you
can play the word association game:  

"sky" - blue.
"cat" - claws.
"dog" - fur.
"HP" - laserjet printers.
"bank" - no money left.
"car" - gas prices.
"oracle" - databases.
"grocery store" - line ups
"Microsoft" - upgrades.
"shopping malls" - it's too warm
"IBM" - services company.   (if you thought "hardware", that's
wrong, according to the ad.)

So - you have a crisis?  Call IBM, they will find what you need,
package it as a solution for your problems, and voilà!

: )

Storage Solutions is like that too, in a way - many companies now
"outsource" components that they used to manufacture themselves.

The "hole" they are trying to plug is people's perception of their
company.  They are trying to "position" themselves differently.  Position
themselves differently in your mind...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
 
Sent:   Tuesday, May 01, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering what in
the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads lately
on British TV
where it shows a board meeting of some sort where they are
having a crisis
(who's in charge of web servers, whos in charge of desktop
support, blah
blah endless blah)- then everything focuses on an individual
(usually a
director) with the comment: "That's when you realise you
need IBM!"

Any insight from those all knowing "Oracles" out there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe you can
write a paper to
explain why marketing tactics actually work, I never
understood that one.

Why is using imagery and imparting moods more effective at
selling than
facts and a track record?

Once you have finished that paper, please send it to me,
because I still
don't understand.

e.g. last night on TV there was a Bridgestone commercial,
talking about
integrity, reliability.  It seems obvious to me that their
sales have
dropped, they did a marketing study and discovered that
ooops!  People don't
trust them anymore.  So they concoct an advertisement to
present themselves
as reliable, to plug a hole so to speak.  This is just an
example, most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system
administrator with nothing
to do because she was using Windows2000 servers, and
therefore had no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., I
am responsible
for the effect of sharing my honest opinions, blah blah
blah)

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Roy Ferguson [SMTP:[EMAIL PROTECTED]]
 
 

RE: not able to dump buffers

[ARUN K C]

Thanks Steve,
It was dumb of me not to see that.
Thanks very much



>From: "Steve Adams" Reply-To: [EMAIL PROTECTED] To: Multiple recipients 
>of list ORACLE-L Subject: RE: not able to dump buffers Date: Sat, 28 Apr 
>2001 21:55:30 -0800
>
>Hi Arun,
>
>You have requested a BUFFER dump, rather than a BUFFERS dump. The BUFFER 
>dump is intended to do a level 10 dump of a particular buffer. The level 
>number to specify in the event syntax is the decimal tablespace relative 
>data block address. Of course, there is no buffer with an RDBA of 10. That 
>is why your trace file was empty.
>
>The levels for the BUFFERS dump are as follows.
>
>level 1 dump the buffer headers only level 2 include the cache and 
>transaction headers from each block level 3 include a full dump of each 
>block level 4 dump the working set lists and the buffer headers and the 
>cache header for each block level 5 include the transaction header from 
>each block level 6 include a full dump of each block
>
>Most levels high than 6 are equivalent to 6, except that levels 8 and 9 are 
>the same as 4 and 5 respectively. For level 1 to 3 the information is 
>dumped in buffer header order. For levels higher than 3, the buffers and 
>blocks are dumped in hash chain order.
>
>@ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ 
>http://www.christianity.net.au/
>
>
>-Original Message- Sent: Friday, 27 April 2001 8:07 To: Multiple 
>recipients of list ORACLE-L
>
>
>Hi, I am trying to take a buffer dump thro the following command alter 
>session set events 'immediate trace name buffer level 10'; but all i am 
>getting is a dump file which does not have any information on it can 
>somebody let me know what i am missing here. the below said information is 
>what there in the dump file Dump file 
>g:\806_home\RDBMS80\trace\ORA00241.TRC Thu Apr 26 16:58:24 2001 ORACLE 
>V8.0.6.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS 
>V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.6.0.0 - 
>Production With the Partitioning and Objects options PL/SQL Release 
>8.0.6.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance 
>name: orcl
>
>Redo thread mounted by this instance: 1
>
>Oracle process number: 11
>
>pid: f1
>
>
>*** 2001-04-26 16:58:24.879 *** SESSION ID:(10.1) 2001-04-26 16:58:24.879 
>Dump of buffer cache at level 10 
>_ 
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com --
>Author: ARUN K C INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, 
>California -- Public Internet access / Mailing Lists 
> To 
>REMOVE yourself from this mailing list, send an E-Mail message to: 
>[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
>BODY, include a line containing: UNSUB ORACLE-L (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: Steve Adams INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, 
>California -- Public Internet access / Mailing Lists 
> To 
>REMOVE yourself from this mailing list, send an E-Mail message to: 
>[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
>BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing 
>list you want to be removed from). You may also send the HELP command for 
>other information (like subscribing).
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows vs. UNIX

[Lord David]

Presumably, its the 'nobody ever got sacked for buying IBM' line.

Now IBM et al aren't going to spend huge amounts on these ads if they didn't
think it was worthwhile.  So, what gets me is the implication that company
directors will buy IBM, not because they have hard evidence that they are
faster/better/cheaper for their business, but because they get a warm safe
feeling from ads like these.  Doesn't fill me with much confidence.

David Lord

-Original Message-
Sent: 01 May 2001 15:05
To: Multiple recipients of list ORACLE-L


For all those in the UK - I am sat here wondering what in the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads lately on British TV
where it shows a board meeting of some sort where they are having a crisis
(who's in charge of web servers, whos in charge of desktop support, blah
blah endless blah)- then everything focuses on an individual (usually a
director) with the comment: "That's when you realise you need IBM!"

Any insight from those all knowing "Oracles" out there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe you can write a paper to
explain why marketing tactics actually work, I never understood that one.

Why is using imagery and imparting moods more effective at selling than
facts and a track record?

Once you have finished that paper, please send it to me, because I still
don't understand.

e.g. last night on TV there was a Bridgestone commercial, talking about
integrity, reliability.  It seems obvious to me that their sales have
dropped, they did a marketing study and discovered that ooops!  People don't
trust them anymore.  So they concoct an advertisement to present themselves
as reliable, to plug a hole so to speak.  This is just an example, most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system administrator with nothing
to do because she was using Windows2000 servers, and therefore had no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., I am responsible
for the effect of sharing my honest opinions, blah blah blah)

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Roy Ferguson [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 30, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

this information is actually a proposal that I created for a college
course I'm
taking...I have a lot of experience with UNIX and very little with
Windows...that's why I only needed the facts and no opinions...


>
>Roy,
>
>Forgive me my lack of understanding, but if you don't
>know why one would choose Unix over Windows, why are
>you proposing Unix altogether?
>
>Yosi
>
>> -Original Message-
>> From: Roy Ferguson [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, April 30, 2001 2:46 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Windows vs. UNIX
>>
>>
>> this is not to bring up a heated debate over the two platforms...
>>
>> I am making a proposal to move the current access 97
>> databases to an oralce
>> platform running solaris  I would like to put in the
>> proposal a brief reason
>> why a UNIX platform will be better than a Windows platform.
>>
>> the current environment:
>>
>> MS Access 97 databases running on Compaq server.  Databases
>> are about 20GB in
>> size...
>>
>> proposed solution:
>>
>> Sun E3500
>> T3 Storage Array
>> Solaris 8
>> Oracle 8i
>>
>> Just need a couple FACTS as to why one would choose UNIX over
>> Windows
>>
>> Thanks in advance
>> roy
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Roy Ferguson
>>   INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
>> San Diego, California-- Public Internet access / Mailing
Lists
>>

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

Re: NOLOGGING creates txns in redo/archive logs

[james ellis]

This is normal. When a transaction is set to
nologging, minimal redo is written because of Data
Dictionary changes that are occurring.

James
--- [EMAIL PROTECTED] wrote:
>  
>  
> I have been testing logminer and noticed that when I
> alter a table to 
> NOLOGGING, txns are still recorded in the
> redo/archive logs. I thought 
> NOLOGGING was NOT supposed to do this. 
>  
> Anyone know if this is expected behavior?
>  
> At a recent 8i new features class, I explicitly
> asked the instructor this 
> question and he stated that nologging will not cause
> any records to be
> written 
> to the redo/archive logs.
> 
>  
>  
> TIA.
>  
> John Fedock
> iXL, Inc.
> 
>   [EMAIL PROTECTED] 
> http://www.ixl.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).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: james ellis
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OFA and SAN - Why not group all db files on its own m

[dgoulet]

Mike,

SAN or no SAN, IO can become a problem.  We use the EMC solution as well and
I can tell you that having too few channels into the storage array is worse than
didicated disk systems.  How does this affect your layout, depends on what you
have for load balancing software on the server.  EMC sells a product called
PowerPath.  It's suppose to spread the io load accross all of your channels into
and out of the storage array.  Works pretty good, we've seen a 4 fold increase
in throughput, but we still map things out as in old even with the array.  The
reason is that although the EMC software is very intelligent it can't do much
more than react to the load of the moment.  By speading things out as one use to
do we ended up with fewer hot drives, greater cache throughput and utilization,
and a whole lot of happier end users.

As for breaking up the storage instance by instance, DO IT.  This is
especially true with your development environment.  We had a problem a few
months ago where the SA got the same hyper volume mounted on two systems.  Each
trashed what the other was doing.  It was a whole lot easier to recover that one
instance since it was isolated.  It was also much easier to explain to the SA
what we needed restored and it was easier for them to troubleshoot.

Dick Goulet

Reply Separator
Author: "Lanteigne; Mike" <[EMAIL PROTECTED]>
Date:   5/1/2001 5:05 AM

Hi Lisa, 

Thanks for the response. The SAN is very new here. Our first test server is
supposed to be hooked up to it this week. After that we start to play. I
will look into the tuning software for EMC, however from the meetings I've
been to, it looks like we'll (the DBA group) have little say in the SAN
setup, including "..mapping all the way back into the physical
controller..". Too bad, that sounded like fun.  

The only drawback I see about equating a mount point to a database instance
is that new mount points will have to be created for each new database. No
big deal in the static production environment, however could be a pain in
dev and test (assuming I follow the same strategy in these environments). In
fact, I have no idea how I'd even make a mount point, or allocate storage to
it? (SAN PFM I guess).  

Thanks again

Mike




> Hi Mike, 
> 
> If you are running EMC hardware, there are several utilities you can use
> to determine if EMC's cache is performing up to par.  There are also
> utilities to alleviate any i/o contention that may appear if the EMC cache
> does not take care of i/o problems.  I can't tell you exactly what they
> are though, the sysadmins used them, not me.  I've worked in two places
> where we ran EMC hardware (symmetrix) and was told it should not make a
> difference if you follow the standard or not from an i/o point of view.
> However, I just couldn't get over the thought that "i/o will never be a
> problem".  
> 
> Add to it I've heard contradicting stories from EMC support staff, in MN
> and here in FL.  I think there is still merit to mapping all the way back
> into the physical controllers in the symmetrix, but it's a royal pain in
> the behind.  When the EMC guy talked through it, it was difficult for me
> to follow.  I still have the documentation but I couldn't tell you exactly
> what it meant.  (I am not an SA !!)  It's a lot of work for what little
> performance boost you may see.
> 
> If you are interested in seeing this tuning software (I'm not talking
> about Precise/SQL DBTuner, it's lower level than that) I'd suggest
> contacting your EMC support staff.  
> 
> Sorry I couldn't be more specific, but I can tell you I've set up
> databases both ways (OFA and not) and haven't experienced huge i/o
> problems.
> 
>   
> Lisa Rutland Koivu 
> Oracle Database Administrator 
> Certified Self-Important Database Deity 
> Slayer of Unix Administrators 
> Wanton Kickboxing Goddess 
> 
> 
> 
> Hello List, 
> 
> I'm planning an upgrade of four databases on one server from 7.3.4 to
> 8.1.7 
> on Solaris. We are in the initial stages of implementing a Storage Area 
> Network (SAN) project, initially 10TB on EMC hardware. The database server
> 
> will use the SAN for its storage so I will have no decision on where 
> datafile are actually stored (those involved in a SAN implementation know 
> what I mean). 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lanteigne, Mike
  INET: [EMAIL PROTECTED]

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

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

RE: Windows vs. UNIX

[Mark Leith]

For all those in the UK - I am sat here wondering what in the world the IBM
ads could do in the way of "plugging the hole"?

For US/International: we have had a spate of IBM ads lately on British TV
where it shows a board meeting of some sort where they are having a crisis
(who's in charge of web servers, whos in charge of desktop support, blah
blah endless blah)- then everything focuses on an individual (usually a
director) with the comment: "That's when you realise you need IBM!"

Any insight from those all knowing "Oracles" out there?

Mark

-Original Message-
Patrice J
Sent: Tuesday, May 01, 2001 12:55
To: Multiple recipients of list ORACLE-L


If you are taking social psychology as well, maybe you can write a paper to
explain why marketing tactics actually work, I never understood that one.

Why is using imagery and imparting moods more effective at selling than
facts and a track record?

Once you have finished that paper, please send it to me, because I still
don't understand.

e.g. last night on TV there was a Bridgestone commercial, talking about
integrity, reliability.  It seems obvious to me that their sales have
dropped, they did a marketing study and discovered that ooops!  People don't
trust them anymore.  So they concoct an advertisement to present themselves
as reliable, to plug a hole so to speak.  This is just an example, most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system administrator with nothing
to do because she was using Windows2000 servers, and therefore had no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., I am responsible
for the effect of sharing my honest opinions, blah blah blah)

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Roy Ferguson [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 30, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

this information is actually a proposal that I created for a college
course I'm
taking...I have a lot of experience with UNIX and very little with
Windows...that's why I only needed the facts and no opinions...


>
>Roy,
>
>Forgive me my lack of understanding, but if you don't
>know why one would choose Unix over Windows, why are
>you proposing Unix altogether?
>
>Yosi
>
>> -Original Message-
>> From: Roy Ferguson [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, April 30, 2001 2:46 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Windows vs. UNIX
>>
>>
>> this is not to bring up a heated debate over the two platforms...
>>
>> I am making a proposal to move the current access 97
>> databases to an oralce
>> platform running solaris  I would like to put in the
>> proposal a brief reason
>> why a UNIX platform will be better than a Windows platform.
>>
>> the current environment:
>>
>> MS Access 97 databases running on Compaq server.  Databases
>> are about 20GB in
>> size...
>>
>> proposed solution:
>>
>> Sun E3500
>> T3 Storage Array
>> Solaris 8
>> Oracle 8i
>>
>> Just need a couple FACTS as to why one would choose UNIX over
>> Windows
>>
>> Thanks in advance
>> roy
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Roy Ferguson
>>   INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
>> San Diego, California-- Public Internet access / Mailing
Lists
>>

>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (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: [EMA

Re:Oracle client for the desktop/Win 2000. Need help with wh

[dgoulet]

Charles,

8.0.5 will work on Win2K, I've got it still installed and have no problems. 
BUT, if your DB is 8.1.x then you're loosing some features by not upgrading the
client.  As a for instance, the 8.0.5 SQL*Plus client will not support the
"execute immediate" statememnt in PL/SQL.  The 8.1.6 will.

Dick Goulet

Reply Separator
Author: Charles Yuan <[EMAIL PROTECTED]>
Date:   4/30/2001 9:25 AM

Hi Listeners,

Do you recommend the latest version of the Oracle client for the
desktop?

Our current standard is Oracle 8.0.5.  In preparation for Windows 2000,
we would like to migrate to a new version sometimes this
year.  Is there a version you suggest we look at?

Thanks in advance,

Charles Yuan
Oracle DBA
918 744 4333


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).

test

[Mujeeb Chowdhry]

test

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

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

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

Advice on database development life cycle practices

[Lanteigne, Mike]

Hello all,

Again turning to the wisdom of the list.

I'm looking for information on database developments and application
development practices. You know the DBA vrs developer thing this list loves
so much.  

Any good resources you know about that I can look into? Any good
methodologies you follow?  What do you use the dev database for? That kind
of thing. I'm especially interested in any work practices you follow. Do you
have these work practices documented? Do the developers consider you (DBAs)
an asset to the development cycle?  

Any info appreciated.

Thanks

Mike















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

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

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

RE: OFA and SAN - Why not group all db files on its own mount poi

[Lanteigne, Mike]

Hi Lisa, 

Thanks for the response. The SAN is very new here. Our first test server is
supposed to be hooked up to it this week. After that we start to play. I
will look into the tuning software for EMC, however from the meetings I've
been to, it looks like we'll (the DBA group) have little say in the SAN
setup, including "..mapping all the way back into the physical
controller..". Too bad, that sounded like fun.  

The only drawback I see about equating a mount point to a database instance
is that new mount points will have to be created for each new database. No
big deal in the static production environment, however could be a pain in
dev and test (assuming I follow the same strategy in these environments). In
fact, I have no idea how I'd even make a mount point, or allocate storage to
it? (SAN PFM I guess).  

Thanks again

Mike




> Hi Mike, 
> 
> If you are running EMC hardware, there are several utilities you can use
> to determine if EMC's cache is performing up to par.  There are also
> utilities to alleviate any i/o contention that may appear if the EMC cache
> does not take care of i/o problems.  I can't tell you exactly what they
> are though, the sysadmins used them, not me.  I've worked in two places
> where we ran EMC hardware (symmetrix) and was told it should not make a
> difference if you follow the standard or not from an i/o point of view.
> However, I just couldn't get over the thought that "i/o will never be a
> problem".  
> 
> Add to it I've heard contradicting stories from EMC support staff, in MN
> and here in FL.  I think there is still merit to mapping all the way back
> into the physical controllers in the symmetrix, but it's a royal pain in
> the behind.  When the EMC guy talked through it, it was difficult for me
> to follow.  I still have the documentation but I couldn't tell you exactly
> what it meant.  (I am not an SA !!)  It's a lot of work for what little
> performance boost you may see.
> 
> If you are interested in seeing this tuning software (I'm not talking
> about Precise/SQL DBTuner, it's lower level than that) I'd suggest
> contacting your EMC support staff.  
> 
> Sorry I couldn't be more specific, but I can tell you I've set up
> databases both ways (OFA and not) and haven't experienced huge i/o
> problems.
> 
>   
> Lisa Rutland Koivu 
> Oracle Database Administrator 
> Certified Self-Important Database Deity 
> Slayer of Unix Administrators 
> Wanton Kickboxing Goddess 
> 
> 
> 
> Hello List, 
> 
> I'm planning an upgrade of four databases on one server from 7.3.4 to
> 8.1.7 
> on Solaris. We are in the initial stages of implementing a Storage Area 
> Network (SAN) project, initially 10TB on EMC hardware. The database server
> 
> will use the SAN for its storage so I will have no decision on where 
> datafile are actually stored (those involved in a SAN implementation know 
> what I mean). 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lanteigne, Mike
  INET: [EMAIL PROTECTED]

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

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

RE: OFA and SAN - Why not group all db files on its own mount poi

[Koivu, Lisa]

Title: RE: OFA and SAN - Why not group all db files on its own mount point?





Hi Mike, 


If you are running EMC hardware, there are several utilities you can use to determine if EMC's cache is performing up to par.  There are also utilities to alleviate any i/o contention that may appear if the EMC cache does not take care of i/o problems.  I can't tell you exactly what they are though, the sysadmins used them, not me.  I've worked in two places where we ran EMC hardware (symmetrix) and was told it should not make a difference if you follow the standard or not from an i/o point of view.  However, I just couldn't get over the thought that "i/o will never be a problem".  

Add to it I've heard contradicting stories from EMC support staff, in MN and here in FL.  I think there is still merit to mapping all the way back into the physical controllers in the symmetrix, but it's a royal pain in the behind.  When the EMC guy talked through it, it was difficult for me to follow.  I still have the documentation but I couldn't tell you exactly what it meant.  (I am not an SA !!)  It's a lot of work for what little performance boost you may see.

If you are interested in seeing this tuning software (I'm not talking about Precise/SQL DBTuner, it's lower level than that) I'd suggest contacting your EMC support staff.  

Sorry I couldn't be more specific, but I can tell you I've set up databases both ways (OFA and not) and haven't experienced huge i/o problems.

 
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess


[EMAIL PROTECTED]
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 



 Enter Your PaperClick Code Here!
 
 




-Original Message-
From: Lanteigne, Mike [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Subject: OFA and SAN - Why not group all db files on its own mount
point?



Hello List,


I'm planning an upgrade of four databases on one server from 7.3.4 to 8.1.7
on Solaris. We are in the initial stages of implementing a Storage Area
Network (SAN) project, initially 10TB on EMC hardware. The database server
will use the SAN for its storage so I will have no decision on where
datafile are actually stored (those involved in a SAN implementation know
what I mean). 


So... I'm looking at the OFA docs - where datafiles from different databases
are on different mount points mostly for I/O purposes e.g.:
Non SAN OFA:


md03/
 oradata/
     db_1/
             system01
             data01
             control01
             redoG1M1
             redoG2M1


           db_2/
             system01
             data01
             control01
             redoG1M1
             redoG2M1
md04/
 oradata/
     db_1/
             index01
             temp01
             control02
             redoG1M2
             redoG2M2
           db_2/
             index01
             temp01
             control02
             redoG1M2
             redoG2M2            



In a SAN implementation, it seems to me that since I/O is no longer a
parameter I can control, why not group each database on its own mount point
e.g.:
md03/
 oradata/
     db_1/
             system01
             data01
             index01
             temp01
             control01
             control02
             redoG1M1
             redoG1M2
             redoG2M1
             redoG2M2


md04/
 oradata/
     db_2/
             system01
             data01
             index01
             temp01
             control01
             control02
             redoG1M1
             redoG1M2
             redoG2M1
             redoG2M2


I know it looks scary. Lets say I separate the control files on separate
mount points. In reality the SAN puts the files all over the place, making
copies on multiple volumes, so I think I'm fooling myself by thinking I'm
buying anything by using separate mount points.


Any thoughts? Anyone set 

RE: Re[2]: RESOURCE role

[Boivin, Patrice J]

Probably because too many people use them.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Jared Still [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 01, 2001 1:26 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Re[2]: RESOURCE role


Probably a good idea.

I wonder why Oracle hasn't replaced these 2 roles,
or at least the RESOURCE role?

Jared

On Monday 30 April 2001 19:24, [EMAIL PROTECTED] wrote:
>  I don't know about the rest of you, but whenever I create a new
> instance one of th first things that gets done is to drop the
resource
> role.  I also get rid of Connect too.
>
> Dick Goulet
> -- Reply Separator --
> Subject: Re[2]: RESOURCE role
> Author: Jared Still <[EMAIL PROTECTED]>
> Date: 4/30/01 5:52 PM
>
> On Monday 30 April 2001 15:25, Jacques Kilchoer wrote:
> > The RESOURCE role is created via
$ORACLE_HOME/rdbms/admin/sql.bsq
> > You can look at that file, or you could query
> > DBA_ROLES
> > DBA_ROLE_PRIVS
> > DBA_SYS_PRIVS
> > DBA_TAB_PRIVS
> > DBA_COL_PRIVS
> >
> > Choosing a tablespace for a segment, however, is determined by
the
>
> quotas
>
> > allowed to the user. Check view DBA_TS_QUOTAS.
>
> Jacques,
>
> Granting RESOURCE to a user results in UNLIMITED TABLESPACE
> being granted directly to the user account.
>
> Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Windows vs. UNIX

[Boivin, Patrice J]

If you are taking social psychology as well, maybe you can write a paper to
explain why marketing tactics actually work, I never understood that one.

Why is using imagery and imparting moods more effective at selling than
facts and a track record?

Once you have finished that paper, please send it to me, because I still
don't understand.

e.g. last night on TV there was a Bridgestone commercial, talking about
integrity, reliability.  It seems obvious to me that their sales have
dropped, they did a marketing study and discovered that ooops!  People don't
trust them anymore.  So they concoct an advertisement to present themselves
as reliable, to plug a hole so to speak.  This is just an example, most of
the ads on TV seem to be about plugging holes...

Another example was that MS ad about the system administrator with nothing
to do because she was using Windows2000 servers, and therefore had no
worries about anything ever going wrong...

The list could go on and on.

And these ads actually work!  I just don't get it.

(this is my opinion, not that of my employers, etc. etc., I am responsible
for the effect of sharing my honest opinions, blah blah blah)

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Roy Ferguson [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 30, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Windows vs. UNIX

this information is actually a proposal that I created for a college
course I'm 
taking...I have a lot of experience with UNIX and very little with 
Windows...that's why I only needed the facts and no opinions...


>
>Roy,
>
>Forgive me my lack of understanding, but if you don't
>know why one would choose Unix over Windows, why are
>you proposing Unix altogether?
>
>Yosi
>
>> -Original Message-
>> From: Roy Ferguson [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, April 30, 2001 2:46 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Windows vs. UNIX
>> 
>> 
>> this is not to bring up a heated debate over the two platforms...
>> 
>> I am making a proposal to move the current access 97 
>> databases to an oralce 
>> platform running solaris  I would like to put in the 
>> proposal a brief reason 
>> why a UNIX platform will be better than a Windows platform.
>> 
>> the current environment: 
>> 
>> MS Access 97 databases running on Compaq server.  Databases 
>> are about 20GB in 
>> size...
>> 
>> proposed solution:
>> 
>> Sun E3500
>> T3 Storage Array
>> Solaris 8
>> Oracle 8i
>> 
>> Just need a couple FACTS as to why one would choose UNIX over 
>> Windows
>> 
>> Thanks in advance
>> roy
>> 
>> -- 
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> -- 
>> Author: Roy Ferguson
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
>> San Diego, California-- Public Internet access / Mailing
Lists
>>

>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (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).




Roy E. Ferguson II
Intel Sacramento
916-854-1123

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California--

Rollbacks

[VIVEK_SHARMA]

report.txt :-

What Does the NEGATIVE ( -1 ) Value for field XACTS (below) mean ?


SVRMGR> Rem Waits_for_trans_tbl high implies you should add rollback
segments.
SVRMGR> select * from stats$roll;
UNDO_SEGMENTTRANS_TBL_GETS  TRANS_TBL_WAITS
UNDO_BYTES_WRITTEN  SEGMENT_SIZE_BYTES  XACTS   SHRINKS
WRAPS  
--- --- ---
--- --- ---
--- ---
  0 137   0
0  237568   0   0
0
  2 880   0
46494610641408   0   0
1
  3 913   1
79478010641408  -1   0
2



NOTE - Banking Product with Database having 400 Concurrent Staff users

Rollback Segments = 100 in number
INITIAL_EXTENT = 512 K , NEXT_EXTENT = 512K ,  MINEXTENTS=20 ,
OPTIMAL=10M


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ORA-07445

[Lord David]

We had (and still have) a similar problem - ORA7445's & ORA00600's.  Do you
have any invalid objects (pl/sql procedures/functions/packages or possibly
views)?  If so, recompile them.

After a lot of head-scratching by us and OWS we tied it down to a problem
with 'on-the-fly' recompilation of invalid objects.  When a session uses an
invalid object, it is recompiled on-the-fly and if successful, the session
*should* then continue as normal.  However, in 8.1.6, the object is
compiled, but the session then dies with ORA-03113: end-of-file on
communication channel and the above errors appear in the alert log.  We also
suspect that it can cause pmon to crash occasionally.

Its now a bug (1520530) and is fixed in 8.1.7.99 apparently (not that that
will be of any use to you, as it isn't out yet).

HTH
David Lord

-Original Message-
Sent: 30 April 2001 16:31
To: Multiple recipients of list ORACLE-L



Hello All

This message is appearing in the alert log periodically.. anyone know hat
it means and how I can get rid of it


ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV]
[Address not mapped to object] [8] [] []

Thanks

-- 
Sajid Iqbal
Database Team Leader


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
**
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this email in error please notify 
the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

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

Oracle What savepoints are active for a given session?

[Venkata Apparao N]

HI  PLEASE SEND ME ANSWER
Question Title: Oracle What savepoints are active for a given session?

Detailed Question: Does anybody know IF and HOW can I get a list of
active savepoints for the current session? I need a native way, not
solutions based on additional application-level housekeeping. Some query
on the V$ tables/views would be the kind of answer I'm looking for.
Details: Within one stored proc I'd like to obtain a list (in any form)
of the savepoints issued currently in the current transaction. Example:
Proc A issues savepoint svA; then proc B issues savepoint svB; and then
proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
something like that. Of course, there are no intervening commits or
rollbacks.


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 1:10 PM


> Don't know about the Java code...
> ora- 1008 is normally encountered because of undefined global variable or
> missing grants on the concerned table..
> Please check from your end...
>
> Thanks,
> Amar Kumar Padhi.
>
> -Original Message-
> Sent: Monday, April 30, 2001 2:41 PM
> To: Multiple recipients of list ORACLE-L
>
>
> We are having a table TestSite with the following fields.
>
> Name  Null?Type
> -   
> PK_SITE_ID  NOT NULL NUMBER
> FK_CATEGORY NOT NULL NUMBER
> TITLE CLOB
> URL   NOT NULL
> VARCHAR2(4000)
> DESCRIPTION CLOB
> STATUS NOT NULL NUMBER
> PAGE_HITS NOT NULL
> NUMBER
> EDITOR_CHOICEVARCHAR2(10)
>
> One of our developers has written code for inserting the data into
> this
> table using
> PreparedStatement class in Java. But he is getting "ORA-01008 - Not All
> Variables
> Bound" when using the code.
> Earlier code was with normal Statement class in Java.  It was
> working
> fine without any errors. Could any of you please let me know as to what
the
> problem
> could be?
>
>   The java code is as follows:
>
> import java.io.*;
> import java.sql.*;
>
> import oracle.sql.CLOB;
> import oracle.jdbc.driver.OracleResultSet;
> import oracle.jdbc.driver.OracleCallableStatement;
>
> public class TestPreparedStatement
> {
>
> private static void setSiteData(int pk_site_id, int fk_category,
> String
> title, String url, String description, int siteStatus, int page_hits,
String
> editor_choice)
> {
> ResultSet resultSet   = null;
> file://Statement stmt = null;
> PreparedStatement stmt = null;
> Connection con = null;
>
> oracle.sql.CLOB clobTitle = null;
> oracle.sql.CLOB clobDescription = null;
>
> String strSQL = "",strSelectSQL = "";
> int nTemp1=0;
> int nTemp2=0;
> int k1 = 0;
> int k2 = 0;
>
> try
> {
> con=getConnection();
>   con.setAutoCommit(false);
>
> /*
> stmt = con.createStatement();
>   strSQL = "INSERT INTO SITE VALUES (" +pk_site_id +",
> "+fk_category +",
> empty_clob(), '"+url+"', empty_clob(), "+siteStatus+", "+page_hits+",
> '"+editor_choice+"')";
>   stmt.execute (strSQL);
> strSelectSQL = "SELECT * FROM TESTSITE where
> pk_site_id=" + pk_site_id;
> ResultSet rset = stmt.executeQuery(strSelectSQL);
> */
>
> strSQL = "INSERT INTO TESTSITE VALUES (?, ?,
> empty_clob(),
> ?,empty_clob(), ?, ?, ?)";
> stmt = con.prepareStatement(strSQL);
> stmt.setInt(1,pk_site_id);
> stmt.setInt(2,fk_category);
> stmt.setString(3,url);
> stmt.setInt(4,siteStatus);
> stmt.setInt(5,page_hits);
> stmt.setString(6,editor_choice);
>
> stmt.executeUpdate(strSQL);
>
> strSelectSQL = "SELECT * FROM TESTSITE where
> pk_site_id = ?";
> stmt = con.prepareStatement(strSQL);
> stmt.setInt(1,pk_site_id);
> ResultSet rset = stmt.executeQuery(strSelectSQL);
>
> while(rset.next())
> {
> clobTitle =
> ((OracleResultSet)rset).getCLOB(3);
> clobDescription  =
> ((OracleResultSet)rset).getCLOB(5);
> break;
> }
>
> // if the size of the title and description is
> greater than 60,000
> characters,
> // then copy the contents into a file and update the
> database after
> reading the
> // the contents from the file. Else update the
> database directly from the
> string.
> int nTitle =  title.length();
> int nDescription = description.length();
>
> java.io.Writer titleWriter, descriptionWriter;
>
> if(nTitle > 6)
> {
> File titleFile = new
> File("Site"+pk_site_id+".txt");
> // copy the contents of the of the string
> into the file
> BufferedWriter brWriterTitle = new
> BufferedWriter(new
> FileWriter(titleFile));
> brWriterTitle.write(title,0,nTitle);
> brWriterTitle.flush();
> brWriterTitle.close();
> FileInputStream instreamTitle  = new
> FileInputStream(titleFile);
> titleWriter =
> ((CLOB)clobTitle).getCharacterOutputStream();
> int size = clobTitle.get