date:20020426



Waleed,

I will run a script and check for missing indexes.

Thanks,

Cherie


   

"Khedr,

Waleed"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: RE: No Rows Deadlock and 
PCTFREE, INITRANS on 8.1.7.2
Sent by:   

[EMAIL PROTECTED] 

om 

   

   

04/25/02 07:03 

PM 

Please respond 

to ORACLE-L

   

   





It does not look like an  inittrans problem on the table.
I remember reading that Oracle will try to avoid contention on itl if it's
doing insert by adding new blocks to the free lists. The only conflict that
could happen on itl (inittrans) during inserts is for indexes.

Could you have a primary key constraint that has some SYS_<..> index
associated with it and was forgotten to be dropped?

Regards,

Waleed

-Original Message-
Sent: Thursday, April 25, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L



Waleed,

There used to be a single process that loaded the data.   It ran too long
and the application owners split the job out into two process.   One
started at one end and loaded data in ascending order and the other started
at the other end and loaded in descending order.

Both jobs run at the same time in the same database.  They've run like this
for a couple of years in the current 8.0.4 database without any obvious
locking errors.

Cherie Machler




"Khedr,

Waleed"  To: Multiple recipients of
list
ORACLE-L <[EMAIL PROTECTED]>
 Subject: RE: No Rows Deadlock
and PCTFREE, INITRANS on 8.1.7.2
Sent by:

[EMAIL PROTECTED]

om





04/25/02 01:33

PM

Please respond

to ORACLE-L









Can you please give more details on: While testing our nightly load job
that
runs in two simultaneous
streams (ascending and descending).

What do you mean by descending and ascending (simultaneous)?

Thanks

Waleed

-Original Message-
Sent: Thursday, April 25, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L



We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.

While testing our nightly load job that runs in two simultaneous
streams (ascending and descending), we have been getting deadlock
errors.   The trace file shows the the rows waited on are no rows.

In response to a TAR I opened with Oracle, Oracle responded that
the application needs to be rewritten so that there is only a single
stream.   However our developers aren't inclined to do so because
our nightly window isn't long enough for a single job and because
this application worked fine as is on 8.0.4.

Our developers have discovered an old article (perhaps from 7.3.4 times)
by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
www.dbdomain.com/120197.htm
that indicates this deadlock error with no rows is an indication of an
"insidious table".

The article states that the the INITRANS and PCTFREE parameters
may be set too low for the table in use.

Has anyone encountered this deadlock with norows indicated error
before?  If yes, how did you resolve it?

In our current 8.0.4 datawarehouse database, this partitioned table
has PCTFREE of 10 and INI_TRANS of 1.   The block size is
8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
As I said, we are preparing to upgrade this to 8.1.7.

What would be an appropriate setting for PCTFREE and INI_TRANS
for this large warehouse parti

RE: Enterprise Manager (EM) Questions

2002-04-26 Thread Abdul Aleem

Title: RE: Enterprise Manager (EM) Questions









Thanx to all,

 

The problem was solved, I downloaded EM Error Messages manual and
checked on it. The detailed mentioned the service, when I checked it was set to
manual startup. After starting it everything was fine again.

 

Thank you for your help.

 

Best Regards,

 

Aleem

 

 

 

-Original
Message-
From: Clinton Naude
[mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 11:39
AM
To: 'Abdul Aleem'
Subject: RE: Enterprise Manager
(EM) Questions

 

Hi Aleem.

 

Here is a copy of the
user groups.

There needs to be one
called ORADBA.

 

This gives you all the
correct permissions. It isntalls when you install Oracle.

 

Let me know.

 

Clint

-Original Message-
From: Abdul Aleem
[mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 6:11
AM
To: Clinton Naude
Subject: RE: Enterprise Manager
(EM) Questions

Hi!

 

I am using WIN2K, it has a group called power users,
I couldn't find any policy to submit batches. Any way creating sysman as power
user didn't work.

 

Do you want me to check on anything else?

 

Best Regards,

 

Aleem

 

-Original
Message-
From: Clinton Naude
[mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:23
PM
To: 'Abdul Aleem'
Subject: RE: Enterprise Manager
(EM) Questions

 

100%,
you need to create this user in NT, and give him super user rights.

Also
give him the policy to submit batch jobs on NT.

-Original Message-
From: Abdul Aleem
[mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 6:18
AM
To: Clinton Naude
Subject: RE: Enterprise Manager
(EM) Questions

Clint,

 

I am sorry for not being able to check on it on time
because of some domestic occupations. I couldn't find NT user by sysman.

 

Best Regards,

 

Aleem

 

 

-Original
Message-
From: Clinton Naude [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002
4:55 PM
To: 'Abdul Aleem'
Subject: RE: Enterprise Manager
(EM) Questions

 

Have you
installed the management server part on a server, and then the client part on
your machine?

 

You need
to have a user called sysman on your NT server (not oracle database) with
Oracle rights.

You
should be able to reset the user via the NT user administration gui.

 

Good
luck.

 

Clint

 

-Original Message-
From: Abdul Aleem
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002
2:04 PM
To: Clinton Naude
Subject: RE: Enterprise Manager
(EM) Questions

Thanks Clintonn,

 

How do I separate hostname, instance name and the
port number? Spaces, slash does not work.

 

Your mentioning sysman and oem_temp made me recall a
note that I had written about it. According to the note, I logged on with this
user and password and then it asked to change the password, and I changed it to
sysman for simplicity. Still this does not work. Is there a way of resetting
password?

 

Unless I am able to log on to the management server,
EM does not allow import.

 

Thanx.

 

Aleem

 

-Original
Message-
From: Clinton Naude
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:27
PM
To: '[EMAIL PROTECTED]'
Subject: RE: Enterprise Manager
(EM) Questions

 

 

* While installing EM 9i, it asked to
creating a separate database for its 
repository to which I said "Yes". Now the problem is
that the database tools

like SQL*Plus and SQL Workseet defaults to EM Repository database
and not 
the original one. How do I specify the database name for database
tools to 
connect to. 
Please note that (The developer/2000 applications/tools however
connect to 
the right database perhaps because the connect string was created
to the 
database before installing EM). 

Give it a host name, then the instance
name then the port number. 

 

* When I start EM with Login to Management
Server, it does not seem to 
recognize the username/password. The stand alone does start and
shows both 
the databases. The error it reports is VTK-1000 

Try sysman with oem_temp as password. 

* Does EM allow importing 8i export file
to 9i, if it doesn't is there any 
other GUI for that? 

Yes it does. 

Cheers 

Clint 

 

TIA! 

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

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

Re: Good SQL/PLSQL Reference Book ?

2002-04-26 Thread Igor Neyman


JoJo,

Good reference book on PL/SQL would be S.Feurstein's (and others) "Oracle
PL/SQL Language Pocket Reference" from O'Reilly.
As for "pure" SQL - not sure...

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 12:13 AM


> Hi folks,
>
> I'd like a recommendation for a good SQL/PLSQL *reference* book (not a
"how
> to" but a good reference).  Please don't tell me to go to Oracle's site (I
> did that already) -- I want a book!  :D
>
> Thanks in advance!,
> JoJo
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: JoJo Al-Zawawi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Ms Access user forum

2002-04-26 Thread Roland . Skoldblom


Hallo,

any one  whom knows how where to find a good MsAccess  user forum where I can ask 
questions?

Thanks in advance

Roland

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

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

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

URGENT : contact phone of Oracle Support

2002-04-26 Thread Mandal, Ashoke


Could any of you send me the 1-800 no. and also the other phone no. for contacting 
Oracle support.

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

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

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

Re:Good SQL/PLSQL Reference Book ?

2002-04-26 Thread dgoulet


I have two that I really like:

1) Oracle Built-in Packages from O'Reilly
2) Oracle PL/SQL tips & Techniques from Osborne

Dick Goulet

Reply Separator
Author: JoJo Al-Zawawi <[EMAIL PROTECTED]>
Date:   4/25/2002 8:13 PM

Hi folks,

I'd like a recommendation for a good SQL/PLSQL *reference* book (not a "how
to" but a good reference).  Please don't tell me to go to Oracle's site (I
did that already) -- I want a book!  :D

Thanks in advance!,
JoJo
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  INET: [EMAIL PROTECTED]

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

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

> That its not as easy as just using embedded sql.  

That kind of duhveloper should quit immediately and
get a job in sales or damagement, since they aren't
interested in doing anything properly.

That kind likes to see the glitter on the screen and 
cares little about what goes on behind the scenes.

Jared

On Thursday 25 April 2002 14:08, Seefelt, Beth wrote:
> Greg,
>
> That its not as easy as just using embedded sql.  I don't agree, it
> takes just a little bit more thought and a couple extra lines of code
> per call, but I lost that battle...
>
>
> -Original Message-
> Sent: Thursday, April 25, 2002 4:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Beth,
>
> What reasons do your programmers give for not wanting to use bind
> variables?
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, April 25, 2002 8:43 AM
>
>
>
> Wow, I think that's a brilliant idea.  It would be a huge benefit to me,
> where all of our code is VB, and the developers refuse to use bind
> variables.  My sql area is .5 GB and is 95% garbage.
-- 
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: How come I don't get postings

2002-04-26 Thread Scott . Shafer


Please send jpgs.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 25, 2002 8:03 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How come I don't get postings
> 
> I can not see you on the list!
> 
>   -Original Message-
>   From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
>   Sent: Thursday, April 25, 2002 8:43 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: How come I don't get postings
>   
>   
> 
>   Guys, 
> 
>   Please someone tell me if you can see me on this list.  I just
> subscribed and got the welcome message but no messages from this list.
> 
>   Thanks, 
>   Paula 
> 
-- 
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: Metalink CD Request

You must fill out an iTar to request product media.

Jared

On Thursday 25 April 2002 21:43, Sinardy Xing wrote:
> Hi all,
>
> Do you have any idea how many times we can request CD from Metalink
> because I requested once and now the option is gone...
>
>
> Thanks
>
> Sinardy
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: UNIX Courses

2002-04-26 Thread Simon Waibale


Inline
-Original Message-
Sent: Friday, April 26, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L


Simon - Can you provide more details about your background / desires?
1. Are you pretty new to computers in general, or a grizzled veteran with
years on non-Unix systems?

Simon:
1 year experience with RedHat

2. Is your experience mostly Windows and you were just promoted to being the
DBA  on a Unix system?

Simon:
Not quite but my boss wants some formal training, not the play i've had with
my Linux box at home.

3. Have you worked with Unix for awhile, are comfortable with the command
interface, and looking to move beyond the user tutorials?

Simon:
Much Linux, Little Unix

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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

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

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

Re:URGENT : contact phone of Oracle Support

2002-04-26 Thread dgoulet


1-800-223-1711
1-415-506-1500

Reply Separator
Author: "Mandal; Ashoke" <[EMAIL PROTECTED]>
Date:   4/26/2002 6:03 AM

Could any of you send me the 1-800 no. and also the other phone no. for
contacting Oracle support.

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

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

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

Insight on oracle enterprise manager

2002-04-26 Thread Bob Metelsky


Hi all

New to the list... beeen lurking for about a week. Ive recently
been  interested in using OEM Ive installed it on my server with one
database, the questions is,how can I acccess the other dbs that dont
have "intellegent agents" I cant seem to add the dbs manually

thanks
bob


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

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

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

RE: Curious question about flushing the Pool

2002-04-26 Thread Seefelt, Beth

Oh, you have no idea.  I could show you code that would make your hair
stand on end.  The manager of that department believes in working in a
complete vacuum, and there is so much custom and undocumented code here,
the management above him is terrified of ticking him off.  It used to
frustrate me, but after a few years now, its just kind of comical to sit
back and watch the whole situation.

-Original Message-
Sent: Friday, April 26, 2002 9:18 AM
To: [EMAIL PROTECTED]; Seefelt, Beth

> That its not as easy as just using embedded sql.  

That kind of duhveloper should quit immediately and
get a job in sales or damagement, since they aren't
interested in doing anything properly.

That kind likes to see the glitter on the screen and 
cares little about what goes on behind the scenes.

Jared

On Thursday 25 April 2002 14:08, Seefelt, Beth wrote:
> Greg,
>
> That its not as easy as just using embedded sql.  I don't agree, it
> takes just a little bit more thought and a couple extra lines of code
> per call, but I lost that battle...
>
>
> -Original Message-
> Sent: Thursday, April 25, 2002 4:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Beth,
>
> What reasons do your programmers give for not wanting to use bind
> variables?
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, April 25, 2002 8:43 AM
>
>
>
> Wow, I think that's a brilliant idea.  It would be a huge benefit to
me,
> where all of our code is VB, and the developers refuse to use bind
> variables.  My sql area is .5 GB and is 95% garbage.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

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

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

AW: Ms Access user forum

2002-04-26 Thread Stefan Jahnke


Hi Ronald,

peach.ease.lsoft.com hosts a bunch of mailing lists.
I think they had a pretty good high traffic Access list, too.

Regards,
Stefan

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 26. April 2002 16:13
An: Multiple recipients of list ORACLE-L
Betreff: Ms Access user forum


Hallo,

any one  whom knows how where to find a good MsAccess  user forum where I
can ask questions?

Thanks in advance

Roland

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

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

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


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

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

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

Re: Problem with Database Link

2002-04-26 Thread Bob Metelsky



Can you connect to the remote database using sqlplus username/password@LINKNAME
on the server where you are creating the db link?
  If you can try creating the db link with the full connect string
in the using parameter
  Example
  Create database link LINKNAME
  connect to username identified by password
  using' (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST
= 10.54.100.231)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME= LINKNAME)))'
in other words insert the DESCRIPTION portion of the tnsnames file in
the using...
bob
Rakesh Banerjee wrote:
Hi Friends,
I am facing a problem in operating with database link.
One of the machine has Personal Oracle 8i installed. In the same machine
the client of Oracle Enterprise 8i is also installed, whose server is installed
on the Database server machine.
Now in the client machine, TNSNAMES.ORA files of both the enterprise
client and that of personal is having the same entry of host string, i.e.
the host name version is same for both the versions.
A Database link is created from the personal oracle for the oracle enterprise.
Now when the select statement is fired from Personal Oracle 8i fetching
data from Oracle enterprise using the database link, it is giving TNS ERROR
specifying OPERATION TIME OUT.
Can anybody help in solving the problem? Thanks in advance.
Rakesh
amtrix Infosystems Ltd.
 
 
 
 
 

Do You Yahoo!?
Yahoo!
Games - play chess, backgammon, pool and more

AS/400

2002-04-26 Thread KENNETH JANUSZ




Does the Oracle DB run on the AS/400 platform?  I don't 
think it does and would appreciate it if someone could confirm this or 
not.
 
Thanks,
Ken Janusz, CPIM

RE: Ms Access user forum

2002-04-26 Thread Whittle Jerome Contr NCI

Title: RE: Ms Access user forum






Roland,


Access-L at:

http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-L&H=PEACH.EASE.LSOFT.COM


Many of the most common questions are answered at the Access-L FAQ.

http://rogersaccesslibrary.com/Access-LFAQ.htm


You can also search the archives at:

http://peach.ease.lsoft.com/archives/access-l.html


Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]


Hallo,


any one  whom knows how where to find a good MsAccess  user forum where I can ask questions?


Thanks in advance


Roland

Re: Serious import problem (help!)



 
Error:  ORA 3125 
Text:   client-server protocol violation
---
Cause:  The application received a bad escape sequence from the server which 
may indicate a problem with the client application user code.
Action: Contact your customer support representative.


Since the client application code is Oracle's, you may need
to open a TAR for this.

ORA-1461:

Could be bug #1304674

INTERMITTANT ORA-1461 ON OCISTMTEXECUTE() WHEN REBINDING ONLY LONG RAW COLUMN 


*** 05/18/00 08:35 am ***
=
PROBLEM:
  When running OCI binds with LONG RAW datatypes, if the LONG RAW column
is not the last one in the list, rebinding only the one column causes
ORA-1461 errors intermittantly on OCIStmtExecute().
.
  This appears to be a regression from 8.1.5, and 8.0.
.
=
DIAGNOSTIC ANALYSIS:
  Tested on 8.0.5/6, 8.1.5/6, made code changes to test various methods
Rewrote sections of code to narrow down problem to the rebind.  The
application always fails on 3rd insert.
.
=   
WORKAROUND:
  ensure that the LONG RAW column is last
  do not issue a rebind
  issue a rebind for all of the bind variables
...

Jared


On Thursday 25 April 2002 12:32, Conrad, Ben wrote:
> Folks,
>
> I've been exporting data from the production db's every night for over a
> year.  We use these exports to import into the test db's that we have setup
> in the office.  Well, starting yesterday I am no longer able to import
> successfully into any of our 8.1.6 instances.
>
> The exp/imp are being done with the same version (Export file created by
> EXPORT:V08.01.06 via conventional path, Import: Release 8.1.6.0.0 -
> Production on Thu Apr 25 14:19:59 2000) and we have not upgraded Oracle
> (production or test) ever since it's been installed.  Our exp files are
> around 5GB (on NTFS filesystem) when exported, I then gzip (switching to
> bzip2 soon) the files and ftp them off for unzipping and importing into
> another 8.1.6 w2k server.  The thing that dazzles me is that nothing has
> changed except that we moved into a new office (new IP address space) this
> week.  Were using WINS to resolve machine names (eg oradb2) and that's
> working fine (always has).
>
> 75% of the tables in Schema A load up fine, the other 25% in Schema A are
> random but seem to be breaking on the largest tables.
>
> These are the import errors I get on multiple instances and different DB
> machines, very strange.
>
> imp.exe system/%pass%@%dbname% FILE=%dmpfile% BUFFER=2000 COMMIT=Y
> LOG=import.log IGNORE=Y FROMUSER=%owners% TOUSER=%owners%
>
> . . importing table "CUSTOMER"
> IMP-00058: ORACLE error 3125 encountered
> ORA-03125: client-server protocol violation
> IMP-00018: partial import of previous table completed: 3718 rows imported
>
>
> . . importing table  "ACCOUNT"
> IMP-00058: ORACLE error 1461 encountered
> ORA-01461: can bind a LONG value only for insert into a LONG column
> IMP-00018: partial import of previous table completed: 212793 rows imported
>
>
> . . importing table"AGING_LDC_TMP"
> IMP-00058: ORACLE error 3106 encountered
> ORA-03106: fatal two-task communication protocol error
> IMP-00018: partial import of previous table completed: 264180 rows imported
>
>
> . . importing table"BATCH_LOG"
> IMP-00058: ORACLE error 1461 encountered
> ORA-01461: can bind a LONG value only for insert into a LONG column
> IMP-00018: partial import of previous table completed: 723328 rows imported
>
>
> Any help would be appreciated!
>
> Ben.
>
>
>
>  This e-mail communication and any attachments are confidential and
> intended only for the use of the designated recipients named above.  If you
> are not the intended recipient, you are hereby notified that you have
> received this communication in error and that any review, disclosure,
> dissemination, or distribution of it or its contents is prohibited.  If you
> have received this communication in error, please notify USPowerSolutions
> Corporation immediately by telephone at (617)547-3800 or via e-mail at
> [EMAIL PROTECTED] and destroy all copies of this communication and
> any attachments.


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

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

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

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

RE: Metalink CD Request


What are you wanting, Oracle software? That would be technet, not metalink.
(unless you are doing a shipping tar based on your CSI... I'm not sure if
you can file those as iTAR's or not...)

RF

-Original Message-
Sent: Friday, April 26, 2002 12:43 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Do you have any idea how many times we can request CD from Metalink
because I requested once and now the option is gone...


Thanks

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

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

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

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

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

Re: Curious question about flushing the Pool



Oh, but I *do* have an idea.

I've worked with a few of those people in the past.

Jared

On Friday 26 April 2002 06:30, Seefelt, Beth wrote:
> Oh, you have no idea.  I could show you code that would make your hair
> stand on end.  The manager of that department believes in working in a
> complete vacuum, and there is so much custom and undocumented code here,
> the management above him is terrified of ticking him off.  It used to
> frustrate me, but after a few years now, its just kind of comical to sit
> back and watch the whole situation.
>
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 9:18 AM
> To: [EMAIL PROTECTED]; Seefelt, Beth
> Subject: Re: Curious question about flushing the Pool
>
> > That its not as easy as just using embedded sql.
>
> That kind of duhveloper should quit immediately and
> get a job in sales or damagement, since they aren't
> interested in doing anything properly.
>
> That kind likes to see the glitter on the screen and
> cares little about what goes on behind the scenes.
>
> Jared
>
> On Thursday 25 April 2002 14:08, Seefelt, Beth wrote:
> > Greg,
> >
> > That its not as easy as just using embedded sql.  I don't agree, it
> > takes just a little bit more thought and a couple extra lines of code
> > per call, but I lost that battle...
> >
> >
> > -Original Message-
> > Sent: Thursday, April 25, 2002 4:40 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Beth,
> >
> > What reasons do your programmers give for not wanting to use bind
> > variables?
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, April 25, 2002 8:43 AM
> >
> >
> >
> > Wow, I think that's a brilliant idea.  It would be a huge benefit to
>
> me,
>
> > where all of our code is VB, and the developers refuse to use bind
> > variables.  My sql area is .5 GB and is 95% garbage.
-- 
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 Courses

2002-04-26 Thread Simon Waibale


Thanx all ye who responded, I know waht to tell my boss!!
Cheers

-Original Message-
Sent: Thursday, April 25, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L


Hi all,
What Unix courses/modules would you recommend for a budding Oracle DBA
Thanx,
---
CSW
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Ms Access user forum

2002-04-26 Thread Pardee, Roy E


ACCESS-L is a good one.  Here are particulars:

--
The ACCESS-L list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/access-l.html .
 COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=ACCESS-L



Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, April 26, 2002 7:13 AM
To: Multiple recipients of list ORACLE-L


Hallo,

any one  whom knows how where to find a good MsAccess  user forum where I
can ask questions?

Thanks in advance

Roland

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

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

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

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

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

RE: URGENT : contact phone of Oracle Support

2002-04-26 Thread Farnsworth, Dave


1-800-223-1711 for the US

Dave

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


Could any of you send me the 1-800 no. and also the other phone no. for contacting 
Oracle support.

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

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

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

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

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

RE: AS/400

2002-04-26 Thread Karniotis, Stephen










Ken:

 

  At
one time Oracle did have a port for the AS 400, but I don’t think they support
it any longer.  I believe all they
support is the Oracle Gateway to the AS 400.  Check metalink under Certified product configurations and
see.

 

Thank
You

 

Stephen
P. Karniotis

Product Architect

Compuware Corporation

Direct:   (248)
865-4350

Mobile:  (248)
408-2918

Email:  [EMAIL PROTECTED]

Web:    www.compuware.com

 

-Original
Message-
From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 10:34
AM
To: Multiple recipients of list
ORACLE-L
Subject: AS/400

 

Does the
Oracle DB run on the AS/400 platform?  I don't think it does and would
appreciate it if someone could confirm this or not.

 

Thanks,

Ken Janusz,
CPIM










The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

RE: UNIX Courses

2002-04-26 Thread Gene Sais


Linux=free flavor of unix.  Having worked w/ almost every flavor, linux is more like 
unix than say aix :)

>>> [EMAIL PROTECTED] 04/26/02 10:38AM >>>
Inline
-Original Message-
Sent: Friday, April 26, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L


Simon - Can you provide more details about your background / desires?
1. Are you pretty new to computers in general, or a grizzled veteran with
years on non-Unix systems?

Simon:
1 year experience with RedHat

2. Is your experience mostly Windows and you were just promoted to being the
DBA  on a Unix system?

Simon:
Not quite but my boss wants some formal training, not the play i've had with
my Linux box at home.

3. Have you worked with Unix for awhile, are comfortable with the command
interface, and looking to move beyond the user tutorials?

Simon:
Much Linux, Little Unix

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

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

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

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

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

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

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

index status misleading?

2002-04-26 Thread Gurelei


Hi all:

Last night I have moved couple of tables from one TS
to another. Then I thought I'd check whether I need to
rebuild any indices. I ran the following query:

select distinct status from dba_objects
where owner = 'MYOWNER'

Oracle returned I row with value VALID. From that I
concluded that there were no indices to be rebuilt.
This morning however it turns out that there indeed
were indices in UNUSABLE state. What I don't
understand is why didn't I see UNUSABLE in the output
of my query. Can anyone explain please?

thanks

Gene

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

RE: Ms Access user forum

2002-04-26 Thread Farnsworth, Dave


www.M$access\for\those\that\DONT\RTFM.com

Dave

-Original Message-
Sent: Friday, April 26, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L


Hallo,

any one  whom knows how where to find a good MsAccess  user forum where I can ask 
questions?

Thanks in advance

Roland

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

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

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

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

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

GOT IT : URGENT : contact phone of Oracle Support

2002-04-26 Thread Mandal, Ashoke




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


Could any of you send me the 1-800 no. and also the other phone no. for contacting 
Oracle support.

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

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

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

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

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

RE: Ms Access user forum

2002-04-26 Thread Thomas, Kevin


.!

-Original Message-
Sent: 26 April 2002 15:13
To: Multiple recipients of list ORACLE-L


Hallo,

any one  whom knows how where to find a good MsAccess  user forum where I
can ask questions?

Thanks in advance

Roland

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

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

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

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

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

RE: Intermedia Indexing

2002-04-26 Thread Jack C. Applewhite


Hemant,

The 8.1.6 docs (no change to this in the 8.1.7 addendum) say that only PDF
1.0, 1.1, and 1.2 formats are supported by the interMedia Text filters.

We index plain text and HTML documents (about 3 million per month) and have
had zero errors for the last two years.  We're currently on 8.1.7.3.0 under
Win2k.

Jack

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


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, April 26, 2002 1:18 AM
To: Multiple recipients of list ORACLE-L


Hi,
We have an Oracle iFS installation and have enabled Intermedia.

Some documents fail indexing with "Status 1" or "Status 2" errors.
The documents are PDF (pdf 1.3), Excel, World and HTM documents.

I do have a TAR open with Support.  Just would like to know from
the field  how successful is Intermedia in indexing documents ?
Are there any "gotchas" ?

Oracle8i 8.1.7.3 on Solaris for iFS9.0.1

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd



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

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

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

Re: Ms Access user forum

2002-04-26 Thread Bob Metelsky


http://peach.ease.lsoft.com/archives/access-l.html

excellent list

bob


> any one  whom knows how where to find a good MsAccess  user forum where I can ask 
>questions?
>
> Thanks in advance

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

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

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

OT: How come I don't get postings


Simon, if you don't know Scott, he's a huge joker and a source of many
laughs...

He was kidding!

But seriously there is a whole slew of pics of OT list members on Yahoo.
There's even one of me pre-pregnancy.  (I can barely remember what that was
like.)

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

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 11:28 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How come I don't get postings
> 
> 
> 
> .jpgs ?!*&!
> 
> 
> Luckily for those of us of a sensitive disposition, I think jpgs (and
> other
> picture formats) would be filtered out by the list software, so we are
> safe from
> the threat of being suddenly confronted by images of our less-photogenic
> colleagues.  The best we could manage would be ascii representations, I'm
> sure
> someone could convert photo-to ascii if needed.-)
> 
> Seriously though, I seem to remember a set of helpfull commands available
> from
> the other list address (not the posting address, the list-control one you
> get
> sent in your welcome message) - You could be stuck in 'Digest' mode, which
> would
> mean you have to wait a week for the whole list to arrive at once.  Sorry
> that
> this is a RTFM, but it's been so long since I turned off digest mode I
> can't
> remember exactly how I did it...
> 
> Simon Anderson
> 
> 
> 
> 
> Please respond to [EMAIL PROTECTED]
> 
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:(bcc: Simon Anderson/SSplc)
> 
> 
> 
> 
> Please send jpgs.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, April 25, 2002 8:03 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How come I don't get postings
> >
> > I can not see you on the list!
> >
> >-Original Message-
> >From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, April 25, 2002 8:43 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: How come I don't get postings
> >
> >
> >
> >Guys,
> >
> >Please someone tell me if you can see me on this list.  I just
> > subscribed and got the welcome message but no messages from this list.
> >
> >Thanks,
> >Paula
> >
> 
> 
> 
> 
> -- 
> 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: Koivu, Lisa
  INET: [EMAIL PROTECTED]

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

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

Re:AS/400

2002-04-26 Thread dgoulet


Ken,

The last I have from MegaStink is

IBM AIX 32 & 64 bit, NUMA-Q, and OS/390(MVS).

Dick Goulet

Reply Separator
Author: "KENNETH JANUSZ" <[EMAIL PROTECTED]>
Date:   4/26/2002 6:33 AM

Does the Oracle DB run on the AS/400 platform?  I don't think it does and would
appreciate it if someone could confirm this or not.

Thanks,
Ken Janusz, CPIM








Does the Oracle DB run on the AS/400 platform?  I don't 
think it does and would appreciate it if someone could confirm this or 
not.
 
Thanks,
Ken Janusz, CPIM

-- 
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: Oracle Names - Loading tnsnames.ora automatically on Windoze


The answer to this is to use the Names Checkpoint Cache.

Thanks to Stephen for his paper and presentation material.

SqlNet has never been my strong suit, and this particular
feature is not really explained in the manuals.

Jared

PS.  I reinstalled Oracle on my desktop recently, and discovered
that the cache feature does not work properly in 8.1.7.0.  It does
work in 8.1.7.2






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/25/2002 06:43 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle Names - Loading tnsnames.ora automatically on 
Windoze


Thanks Stephen.

I think the answer is to use the Names Checkpoint Cache.

Before looking at your paper, I had never understood it's use.

I'll try it tomorrow and let you know how it goes.

Thanks again,

Jared





"Karniotis, Stephen" <[EMAIL PROTECTED]>
04/25/2002 01:34 PM

 
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject:RE: Oracle Names - Loading tnsnames.ora 
automatically on Windoze


Jared:

   Not sure what the real problem is.  When names starts, it can start 
with
either an administrative database or use external (dynamic) loading of the
tns file.  What problems are you having?

   Here is a white paper I wrote for configuring this.  See if this helps.

 <>  <> 

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct:  (248) 865-4350
Mobile:  (248) 408-2918
Email:   [EMAIL PROTECTED]
Web: www.compuware.com

 -Original Message-
Sent:Thursday, April 25, 2002 4:28 PM
To:  Multiple recipients of list ORACLE-L
on Windoze

Hey list!

Once again I find myself doing far more work than should be necessary
to do something on Windoze that is simple on Unix.

Here's what I need to do:  When the Oracle Names service is started
after a reboot, I want it to load tnsnames.ora automatically.

This sounds simple enough, but apparently it is not.  The executable
that runs the names service is NAMES.EXE.  This does not seem
to have any documented command line parameters.  I tried hacking
the registry to add a command file as can be done with NAMESCTL.EXE,
but NAMES.EXE just ignores it.

I *did* create a solution to this, but I really don't like to do it this 
way.

Using Perl ( what else? ) with the Win32::Daemon module, I created
a load_tnsnames.pl Perl service.  This works, but it really seems like
overkill for something that should be so simple.  It also means I have 
to productionize and document it. 

That's more work than the Perl was.

Anyone ever succeeded at doing this?

And yes, I know Oracle Names is at the terminal release in 9i, and I
don't care.  ;)

Jared

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

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

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or 
disclose
it to anyone else. If you received it in error please notify us 
immediately
and then destroy it. 




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

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

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



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

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

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

Re: URGENT : contact phone of Oracle Support

2002-04-26 Thread Peter Barnett


The number I have is 1-800-223-1711.


--- "Mandal, Ashoke" <[EMAIL PROTECTED]>
wrote:
> Could any of you send me the 1-800 no. and also the
> other phone no. for contacting Oracle support.
> 
> Thanks,
> Ashoke
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mandal, Ashoke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

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

RE: index status misleading?


Do you understand why the indexes were invalidated in the first place?  you
will always have to rebuild your indexes when you move tables, period.
There is no way around it.

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



> -Original Message-
> From: Gurelei [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 11:28 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  index status misleading?
> 
> Hi all:
> 
> Last night I have moved couple of tables from one TS
> to another. Then I thought I'd check whether I need to
> rebuild any indices. I ran the following query:
> 
> select distinct status from dba_objects
> where owner = 'MYOWNER'
> 
> Oracle returned I row with value VALID. From that I
> concluded that there were no indices to be rebuilt.
> This morning however it turns out that there indeed
> were indices in UNUSABLE state. What I don't
> understand is why didn't I see UNUSABLE in the output
> of my query. Can anyone explain please?
> 
> thanks
> 
> Gene
> 
> __
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

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

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

RE: Ms Access user forum

2002-04-26 Thread Pardee, Roy E


Is this just an expression of bewilderment, or is it unix-ese for 'you can
ask right here in this forum' (and you feel strongly about that)? 

8^)

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, April 26, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L


.!

-Original Message-
Sent: 26 April 2002 15:13
To: Multiple recipients of list ORACLE-L


Hallo,

any one  whom knows how where to find a good MsAccess  user forum where I
can ask questions?

Thanks in advance

Roland

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

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

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

RE: How come I don't get postings

2002-04-26 Thread Simon . Anderson




.jpgs ?!*&!


Luckily for those of us of a sensitive disposition, I think jpgs (and other
picture formats) would be filtered out by the list software, so we are safe from
the threat of being suddenly confronted by images of our less-photogenic
colleagues.  The best we could manage would be ascii representations, I'm sure
someone could convert photo-to ascii if needed.-)

Seriously though, I seem to remember a set of helpfull commands available from
the other list address (not the posting address, the list-control one you get
sent in your welcome message) - You could be stuck in 'Digest' mode, which would
mean you have to wait a week for the whole list to arrive at once.  Sorry that
this is a RTFM, but it's been so long since I turned off digest mode I can't
remember exactly how I did it...

Simon Anderson




Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Simon Anderson/SSplc)




Please send jpgs.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
> Sent:   Thursday, April 25, 2002 8:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How come I don't get postings
>
> I can not see you on the list!
>
>-Original Message-
>From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, April 25, 2002 8:43 PM
>To: Multiple recipients of list ORACLE-L
>Subject: How come I don't get postings
>
>
>
>Guys,
>
>Please someone tell me if you can see me on this list.  I just
> subscribed and got the welcome message but no messages from this list.
>
>Thanks,
>Paula
>




-- 
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: AS/400

2002-04-26 Thread Mark Leith


No it does not..

Mark

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

-Original Message-
Sent: 26 April 2002 15:34
To: Multiple recipients of list ORACLE-L


Does the Oracle DB run on the AS/400 platform?  I don't think it does and
would appreciate it if someone could confirm this or not.

Thanks,
Ken Janusz, CPIM

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

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

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

Re: URGENT : contact phone of Oracle Support

2002-04-26 Thread Ora NT DBA

http://www.oracle.com
Under  Services (on left side)
.. Select Support

Under  Services Information (on right side)
.. Select Contact Support Services

You will then get the appropriate numbers you seek.

John

[EMAIL PROTECTED] wrote:

>Could any of you send me the 1-800 no. and also the other phone no. for contacting 
>Oracle support.
>
>Thanks,
>Ashoke
>

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

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

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

Re: sqlldr

2002-04-26 Thread Stephen Andert




Ravi,
 
To the best of my knowledge, there is no limitation on the 
number of records that can be loaded at a time other than the size of your 
rollback segments. I have loaded 10's of millions of rows in a single sqlldr job 
by setting some parameters.  There are defaults that 
work, but don't perform very well.  To determine appropriate settings, you 
may want to read an article I wrote for O'Reilly & Associates (located 
at http://oracle.oreilly.com/news/oraclesqlload_0401.html) which 
gives the step-by-step directions on setting 2 of the key parameters 
(BINDSIZE and ROWS).  It's a pretty easy thing to do, but without knowing 
you data, the only advice I could give is that DIRECT is the best quick tuning 
fix if you can.
 
If you are going to be doing any serious data loading with SQL*Loader, 
Jonathan's book Oracle 
SQL*Loader: The Definitive Guide would be a good investment.
 
HTH
Stephen>>> [EMAIL PROTECTED] 04/25/02 10:13PM 
>>>i belive there is a limitation on the number of records that can 
be loadedfrom sqlldr at a time based on the bind array and rows default 
parameter.if i have a data file with more than 5000records(don't know the 
exactnumber) that needs to be imported using sqlldrwhat is the value i 
need to set for the "rows" and/or "bind array" for me toload the records to 
the table at one attempt.thanksravi-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
Ravindra B  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: 9i new features, the saga continues?


Just to be clear to anyone who might have misunderstood my comments, I was
joking... never thought you were stealing anything!

:-))

Good seeing you at IOUG-A

-Original Message-
Sent: Friday, April 26, 2002 12:28 AM
To: Multiple recipients of list ORACLE-L


Robert, i've started reading it but what i do is write it up, verify it 
works as i say it does, then read your book to make sure i didnt lie(or 
at least we're both lying) :)

joe


Freeman, Robert wrote:

>Actually I think of it as Joe is generating interest
>If you like what Joe says, the you will find MORE detail
>in my book!! :-)
>
>Or maybe he's *GASP* USING MY BOOK
>
>he he he I seem to recall that he does have a copy
>Keep on going Joe, I'm all for this stuff. 
>
>RF
>
>-Original Message-
>Sent: Thursday, April 25, 2002 10:33 AM
>To: Multiple recipients of list ORACLE-L
>
>
>So those features aren't new any more; they're 6 months old. =)
>
>Paging Robert Freeman; Joe is cutting into the sales of your book here!!
>
>Grins to all on this sunny afternoon,
>
>Mike Hately
>
>
>
>
>-Original Message-
>Sent: Thursday, April 25, 2002 9:14 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Ok life has slowed down some and i've got some free time to potentially
>pickup the 9i new features saga i did about 6 months ago.
>
>Anyone still interested?
>
>The next on the list was 9i data guard.
>
>joe
>
>
> 
>___
_
> 
>
>This email and any attached to it are confidential and intended only for
the
>individual or 
>entity to which it is addressed.  If you are not the intended recipient,
>please let us know 
>by telephoning or emailing the sender.  You should also delete the email
and
>any attachment 
>from your systems and should not copy the email or any attachment or
>disclose their content 
>to any other person or entity.  The views expressed here are not
necessarily
>those of 
>Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you.

>Churchill Insurance Group plc.  Company Registration Number - 2280426.
>England. 
>Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
>1DP. 
>
>


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

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

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

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

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

RE: How come I don't get postings

2002-04-26 Thread Scott . Shafer


You ain't popped out that litter yet?  Get to walking, girl!

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 10:58 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT: How come I don't get postings
> 
> Simon, if you don't know Scott, he's a huge joker and a source of many
> laughs...
> 
> He was kidding!
> 
> But seriously there is a whole slew of pics of OT list members on Yahoo.
> There's even one of me pre-pregnancy.  (I can barely remember what that
> was
> like.)
> 
> Lisa Koivu
> Oracle Database Baby Oven
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA  33063
> 
> > -Original Message-
> > From:   [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, April 26, 2002 11:28 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: How come I don't get postings
> > 
> > 
> > 
> > .jpgs ?!*&!
> > 
> > 
> > Luckily for those of us of a sensitive disposition, I think jpgs (and
> > other
> > picture formats) would be filtered out by the list software, so we are
> > safe from
> > the threat of being suddenly confronted by images of our less-photogenic
> > colleagues.  The best we could manage would be ascii representations,
> I'm
> > sure
> > someone could convert photo-to ascii if needed.-)
> > 
> > Seriously though, I seem to remember a set of helpfull commands
> available
> > from
> > the other list address (not the posting address, the list-control one
> you
> > get
> > sent in your welcome message) - You could be stuck in 'Digest' mode,
> which
> > would
> > mean you have to wait a week for the whole list to arrive at once.
> Sorry
> > that
> > this is a RTFM, but it's been so long since I turned off digest mode I
> > can't
> > remember exactly how I did it...
> > 
> > Simon Anderson
> > 
> > 
> > 
> > 
> > Please respond to [EMAIL PROTECTED]
> > 
> > To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > cc:(bcc: Simon Anderson/SSplc)
> > 
> > 
> > 
> > 
> > Please send jpgs.
> > 
> > Scott Shafer
> > San Antonio, TX
> > 210-581-6217
> > 
> > 
> > > -Original Message-
> > > From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
> > > Sent:   Thursday, April 25, 2002 8:03 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: How come I don't get postings
> > >
> > > I can not see you on the list!
> > >
> > >-Original Message-
> > >From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]
> > >Sent: Thursday, April 25, 2002 8:43 PM
> > >To: Multiple recipients of list ORACLE-L
> > >Subject: How come I don't get postings
> > >
> > >
> > >
> > >Guys,
> > >
> > >Please someone tell me if you can see me on this list.  I just
> > > subscribed and got the welcome message but no messages from this list.
> > >
> > >Thanks,
> > >Paula
> > >
> > 
> > 
> > 
> > 
> > -- 
> > 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: Koivu, Lisa
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: 9i new features, the saga continues?


Oh, I knew he did... meant that to be a funny ha ha

RF

-Original Message-
Sent: Thursday, April 25, 2002 10:09 PM
To: Multiple recipients of list ORACLE-L


um, he started this project BEFORE he won your book

generating interest is much more likely :)

--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> Actually I think of it as Joe is generating interest
> If you like what Joe says, the you will find MORE detail
> in my book!! :-)
> 
> Or maybe he's *GASP* USING MY BOOK
> 
> he he he I seem to recall that he does have a copy
> Keep on going Joe, I'm all for this stuff. 
> 
> RF
> 
> -Original Message-
> Sent: Thursday, April 25, 2002 10:33 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> So those features aren't new any more; they're 6 months old. =)
> 
> Paging Robert Freeman; Joe is cutting into the sales of your book
> here!!
> 
> Grins to all on this sunny afternoon,
> 
> Mike Hately
> 
> 
> 
> 
> -Original Message-
> Sent: Thursday, April 25, 2002 9:14 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Ok life has slowed down some and i've got some free time to
> potentially
> pickup the 9i new features saga i did about 6 months ago.
> 
> Anyone still interested?
> 
> The next on the list was 9i data guard.
> 
> joe
> 
> 
>  
>

>  
> 
> This email and any attached to it are confidential and intended only
> for the
> individual or 
> entity to which it is addressed.  If you are not the intended
> recipient,
> please let us know 
> by telephoning or emailing the sender.  You should also delete the
> email and
> any attachment 
> from your systems and should not copy the email or any attachment or
> disclose their content 
> to any other person or entity.  The views expressed here are not
> necessarily
> those of 
> Churchill Insurance Group plc or its affiliates or subsidiaries.
> Thank you. 
> Churchill Insurance Group plc.  Company Registration Number -
> 2280426.
> England. 
> Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent
> BR1
> 1DP. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hately Mike
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Freeman, Robert 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: How come I don't get postings

2002-04-26 Thread Mark Leith


And boy - don't we know how Lisa got in to that "Baby oven" position! ;P





-Original Message-
Sent: 26 April 2002 16:58
To: Multiple recipients of list ORACLE-L


Simon, if you don't know Scott, he's a huge joker and a source of many
laughs...

He was kidding!

But seriously there is a whole slew of pics of OT list members on Yahoo.
There's even one of me pre-pregnancy.  (I can barely remember what that was
like.)

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

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 11:28 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How come I don't get postings
>
>
>
> .jpgs ?!*&!
>
>
> Luckily for those of us of a sensitive disposition, I think jpgs (and
> other
> picture formats) would be filtered out by the list software, so we are
> safe from
> the threat of being suddenly confronted by images of our less-photogenic
> colleagues.  The best we could manage would be ascii representations, I'm
> sure
> someone could convert photo-to ascii if needed.-)
>
> Seriously though, I seem to remember a set of helpfull commands available
> from
> the other list address (not the posting address, the list-control one you
> get
> sent in your welcome message) - You could be stuck in 'Digest' mode, which
> would
> mean you have to wait a week for the whole list to arrive at once.  Sorry
> that
> this is a RTFM, but it's been so long since I turned off digest mode I
> can't
> remember exactly how I did it...
>
> Simon Anderson
>
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:(bcc: Simon Anderson/SSplc)
>
>
>
>
> Please send jpgs.
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
>
> > -Original Message-
> > From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, April 25, 2002 8:03 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How come I don't get postings
> >
> > I can not see you on the list!
> >
> >-Original Message-
> >From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, April 25, 2002 8:43 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: How come I don't get postings
> >
> >
> >
> >Guys,
> >
> >Please someone tell me if you can see me on this list.  I just
> > subscribed and got the welcome message but no messages from this list.
> >
> >Thanks,
> >Paula
> >
>
>
>
>
> --
> 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: Koivu, Lisa
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: What block size are you using for your new 9i data warehouse?

2002-04-26 Thread Gaja Krishna Vaidyanatha

All,

Something to keep in mind regardless of whether you
are using 9i or not. This issue becomes more relevant
in 9i with "multiple block sizes" for different
tablespaces. 

You always want to ensure that your DB_BLOCK_SIZE =
File System Block Size. This is to avoid wasted I/O
and also the case where the "read ahead algorithm" is
triggered accidentally, when 1 Database Block results
in multiple file system blocks being read from disk.

If your application performs range scans, there is a
high possibility that multiple "single database block"
read requests to a set of contiguous blocks, may
result in the "read ahead algorithm" performing 128K
or 256K pre-fetches, even though your application may
have not required all 128K or 256K. 

This problem is rampant on ufs file systems where the
default block size is 512 bytes, and with a 8K
DB_BLOCK_SIZE, it takes 16 file system blocks to store
1 DB block on disk. However, even if you have advanced
file systems and have a 1-is-to-2 ratio of DB block
is-to FS blocks, you are still in danger of
overloading your I/O sub-system, "under the right
conditions".

If you are using a volume manager product such as
Veritas, and if your version of the volume manager
supports "dynamic file system block sizing" based on
size of the file system or the files themselves,
please pay close attention to that detail and make
sure that the file system block size does not exceed
the database block size (based on the size of the file
system).

Best regards,

Gaja

--- Johnson Poovathummoottil <[EMAIL PROTECTED]>
wrote:
> We too have a data warehouse close to 500GB in size.
> We upgraded the OS solaris 2.8 and our block size is
> 16K. All our data and index tablespaces datafiles
> are
> spread across 20 files systems whose disks are on
> EMC
> storage. We too user veritas volume manager. File
> systems use four 9 GB disks whaich are raid S and
> software stripe uinit size of 256 KB.
> 
> reasons 
>  16K  block size as we have many full table scan ans
> sequential reads.
>  256 KB stripe unit size because we have set the
> db_file_multi_block_read_count to 64(1MB)
> 
> we are moving to a sun fire 15K machine soon and
> then
> the we will go to 9i 64 bit.
> 
> --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> wrote:
> > Cherie:
> > 
> > If you are using Oracle 9i, you can use mutliple
> > block sizes! You still
> > create your database with a default block size,
> but
> > each tablespace (except
> > system) can have a block size different from the
> > default.
> > 
> > Valid blocksizes are limited by OS, but they range
> > from 2K to 32k. 
> > 
> > Check out the 9i docs for CREATE TABLESPACE for
> more
> > info.
> > 
> > Caver
> > 
> > -Original Message-
> > Sent: Thursday, April 25, 2002 11:24 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > We are building a new version 9.0.1 data warehouse
> > on Sun Solaris 2.6
> > migrating to Solaris 2.8.  We will be using
> striped
> > disk that is striped
> > using Veritas Volume Manager on EMC disk.
> > 
> > The datawarehouse will be about 200 Gig.   It will
> > be written to throughout
> > the day.
> > 
> > To this point, almost all of our databases have
> been
> > created with an 8k
> > block size.   i'm not sure if that blocksize is
> > optimal anymore.   With 9i,
> > what block sizes are people using in the field
> > nowadays for data
> > warehouses?
> > 
> > Also, if you use striped disk, what stripe size
> are
> > you using and why?
> > 
> > Thanks for weighing in on this topic.
> > 
> > Cherie Machler
> > Oracle DBA
> > Gelco Information Network
> > 
> > -- 
> > 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: Toepke, Kevin M
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

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

RE: Begin backup fails sporadically

2002-04-26 Thread Kip . Bryant


Hi,

I'm leaning towards parallel execution, now.  I just haven't proven it yet.  I
now think it is merely a procedural problem with operations.  I just haven't
figured out what that "procedural problem" is...yet.

Thanks,
Kip Bryant

|Hi,

|You're problem might be that your backup software is doing things
|in parallel. We use Omniback here and it happened here also.

|Hth,

|Jeroen

|-Oorspronkelijk bericht-
|Van: Peter Gram [mailto:[EMAIL PROTECTED]]
|Verzonden: vrijdag 26 april 2002 10:03
|Aan: Multiple recipients of list ORACLE-L
|Onderwerp: Re: Begin backup fails sporadically


|Hi Kip

|When you next time have this problem check the v$backup table to verify
|that the file is not in backup mode, if this is tha case you
|proberly have to log a iTAR with support.

|[EMAIL PROTECTED] wrote:

|>Version is 8.0.6.3.0
|>
|>I have several databases using the exact same set of generic backup
|scripts.
|>The script that puts all tablespaces into backup mode is generated
|>automatically and done correctly.  Same is true for the script which takes
|all
|>the tablespaces out of backup mode.  The problem I am facing is that when
|this
|>script is invoked, one (and only one) of these databases occasionally has
|>problems.  Some tablespaces are successfully put into backup mode and some
|say
|>
|>ORA-01146: cannot start online backup - file 15 is already in backup
|>ORA-01110: data file 15: '< datafile name >'
|>
|>The only things that would make sense to me is if two of these scripts were
|>running in parallel or if the prior day had some weird problem.  Neither of
|>these seem to be the case.  The only thing that seems to straighten things
|out
|>is to runs these scripts manually.
|>
|>Ideas?
|>
|>Regards,
|>Kip Bryant
|>

|--

|/regards

|Peter Gram

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

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




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

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

|Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be 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: Good SQL/PLSQL Reference Book ?

2002-04-26 Thread JoJo Al-Zawawi


Thanks everyone for your replies!

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

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

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

RE: What block size are you using for your new 9i data

2002-04-26 Thread Bill Buchan

Sorry, I'm a bit non-clued up on this "read ahead algorithm".  Could I be a 
pain and ask for more details?  Does the OS return one OS block if exactly 
one is requested, but if 2 are requested it thinks "aha! sequential scan" 
and goes and gets 4 or 8 or something?

The follow on is, does this mean you should use a (minimal) 2k block size 
on UFS, 512 bytes blocks, or is this read-ahead overhead a smaller 
performance hit than that of using a database block size which is too small 
for the application?

Thanks
- Bill.

At 08:48 26/04/02 -0800, you wrote:
>All,
>
>You always want to ensure that your DB_BLOCK_SIZE =
>File System Block Size. This is to avoid wasted I/O
>and also the case where the "read ahead algorithm" is
>triggered accidentally, when 1 Database Block results
>in multiple file system blocks being read from disk.
>
>If your application performs range scans, there is a
>high possibility that multiple "single database block"
>read requests to a set of contiguous blocks, may
>result in the "read ahead algorithm" performing 128K
>or 256K pre-fetches, even though your application may
>have not required all 128K or 256K.
>
>This problem is rampant on ufs file systems where the
>default block size is 512 bytes, and with a 8K
>DB_BLOCK_SIZE, it takes 16 file system blocks to store
>1 DB block on disk. However, even if you have advanced
>file systems and have a 1-is-to-2 ratio of DB block
>is-to FS blocks, you are still in danger of
>overloading your I/O sub-system, "under the right
>conditions".

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

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

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

Re:Good SQL/PLSQL Reference Book ?

2002-04-26 Thread Rachel Carmichael


there's also a PL/SQL 101 from Osborne/Oracle Press (no, I didn't write
it or have anything to do with the publication of it)


--- [EMAIL PROTECTED] wrote:
> I have two that I really like:
> 
> 1) Oracle Built-in Packages from O'Reilly
> 2) Oracle PL/SQL tips & Techniques from Osborne
> 
> Dick Goulet
> 
> Reply Separator
> Author: JoJo Al-Zawawi <[EMAIL PROTECTED]>
> Date:   4/25/2002 8:13 PM
> 
> Hi folks,
> 
> I'd like a recommendation for a good SQL/PLSQL *reference* book (not
> a "how
> to" but a good reference).  Please don't tell me to go to Oracle's
> site (I
> did that already) -- I want a book!  :D
> 
> Thanks in advance!,
> JoJo
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: JoJo Al-Zawawi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Unix - Writing stderr to a file and stdout

2002-04-26 Thread Mohammed . Ahsanuddin


Hi,

Is it possible to write stderr to stdout and to another file
simultaneously..?

Thanks in advance.

Mohammed Ahsanuddin
Oracle 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: CPU Pegged at 100%

2002-04-26 Thread Charlie Mengler


>From SVRMGRL
SVRMGR> @/u01/app/oracle/product/8.1.7/rdbms/admin/utlbstat.sql

-- let it collect data for 12 - 15 minutes

SVRMGR> @/u01/app/oracle/product/8.1.7/rdbms/admin/utlestat.sql

Upload the resultant report.txt file to www.oraperf.com

Review the results to identify where the bottleneck really is.

HTH & YMMV!

> Raghu Banaji wrote:
> 
> Hi,
> 
> I have a customer who runs an ERP application written using
> ORACLE. Almost all code is written using PL/SQL packages. There are about
> 80-100 users
> at any given point of time(6 AM - 11 PM). Oracle version is 8.1.7.1.1 Standard
> Edition.
> All the four CPU's on their server is pegged at 100% for most of the time.
> This is resulting
> in end users complaning about slow performance and slower log-ons to the
> application.
> This issue has been occuring consistently for over 2-3 weeks now. Archive
> logging is enabled
> and the database is normally shutdown once a week for cold backup.
> 
> The Admin guys have been monitoring the server using Performance monitor and
> find that Oracle.exe is the process consuming 99% of the resource. Memory
> usage is
> constant and there is plenty of it free. Hard disk drives show no activity. A
> normal
> assumption would be that disk drives would be going crazy with all
> the CPU activity going on, but that does not seem to be the case.
> 
> Oracle software and one PRODuction database exist on this server.
> 
> Their Server configuration consists of:
> Windows 2000 OS (Advanced Server), with 4 Pentium III Xeon processors (each
> 700 Mhz),
> 4 Gb RAM and 2 disk drives on seperate disk controllers. Hard drives are of
> 15,000 RPM's.
> 
> MY APPROACH SO FAR:
> 
> Step 1:
> I started looking into this issue since last week and the first area I
> concentrated
> was on finding SQL statements that were taking too many hits or taking too
> long to complete.
> I was able to tune almost 10 of the top SQL statements last week. In most of
> the previous performance
> issues I have been involved with this has resulted in huge performance gains
> and life went on.
> In this situation, tuning these top 10 SQL's did result in small gains, but
> did not make
> any difference to the CPU contention. They still continued to be pegged at
> 100% most of the times.
> 
> Step 2:
> The next step I took was to find out if there were hard parsing going on. As
> mentioned in a number
> of articles here, this would cause the CPU to work extra harder.
> My check resulted in only 2 SQL statement that were hard parsed.
> Based on the fact that there are a number of very big jobs, user queries
> and other activities that go on a daily basis, should I really worry about it
> ?
> 
> Step 3:
> Next step was to increase the number of rollback segments from 5 to 35.
> Previously, there
> were 5 big rollback segments. Now, there are 35 medium sized rollback segments
> spread over
> 2 rollback tablespaces. This step was taken yesterday and so far there has
> been no improvement
> as far as CPU pegging goes. It is still pegged at 100%
> 
> Step 4:
> Certain articles in Metalink suggested that one of the reasons
> that would make the CPU spin continously would be SMON working overtime
> to clean up a large number of temporary extents, or to coalesce a large number
> of free extents.
> This can manifest itself by SMON appearing to spin, consuming a high
> percentage of CPU for
> long periods. I really dont know how to test this statement. PCT_INCREASE is
> set to 0 for
> all the tablespaces except SYSTEM and one ROLLBACK tablespace.
> I will re-set PCT_INCREASE to 0 for the second ROLLBACK tablespace also. Apart
> from this I
> really dont know what else I can look for. My temporary tablespace is around 3
> GB.
> Is there a SQL statement that I can run and find out if there is a problem
> with SMON?
> 
> Step 5:
> The final step was to run Statspack on this instance for about 25 minutes.
> I have copied extracts from some of the data that would be of interest.
> 
> Hard parses and the Top 5 waits seem to be the issue atleast in this report.
> Could some one share some of your experience in the area of tuning these wait
> events
> and what you would recomend me to do next. My CPU is still pegged at 100%.
> 
> STATSPACK report for
> 
> DB Name DB IdInstance Inst Num Release OPS Host
>  ---   --- --- 
> PROD  3888465932 prod1 8.1.7.1.1   NO  ERP1
> 
> Snap Id Snap Time  Sessions
> --- -- 
>  Begin Snap: 31 26-Apr-02 09:21:38  169
>End Snap: 41 26-Apr-02 09:46:03  169
> Elapsed:  24.42 (mins)
> 
> Cache Sizes
> ~~~
>db_block_buffers: 131072  log_buffer: 163840
>   db_block_size:   8192shared_pool_size:  314572800
> 
> Load Profile
> Per Second   P

Re: Unix - Writing stderr to a file and stdout


But of course

find . -print | xargs grep "hoser" 

This will generate errors on directories

Make the errors disappear:

 find . -print | xargs grep "hoser"  2>/dev/null

Now send the standard output to a file.  Make sure the
file is outside the directory structure you are searching.

 find . -print | xargs grep "hoser"  2>/dev/null 1>/tmp/hoser.txt

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/26/2002 11:30 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Unix - Writing stderr to a file and stdout


Hi,

Is it possible to write stderr to stdout and to another file
simultaneously..?

Thanks in advance.

Mohammed Ahsanuddin
Oracle 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: 
  INET: [EMAIL PROTECTED]

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

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

RE: How come I don't get postings

2002-04-26 Thread Gene Sais


oh oh, lisa has a fan club :-)

gene


>>> [EMAIL PROTECTED] 04/26/02 12:58PM >>>
And boy - don't we know how Lisa got in to that "Baby oven" position! ;P





-Original Message-
Sent: 26 April 2002 16:58
To: Multiple recipients of list ORACLE-L


Simon, if you don't know Scott, he's a huge joker and a source of many
laughs...

He was kidding!

But seriously there is a whole slew of pics of OT list members on Yahoo.
There's even one of me pre-pregnancy.  (I can barely remember what that was
like.)

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

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
> Sent: Friday, April 26, 2002 11:28 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How come I don't get postings
>
>
>
> .jpgs ?!*&!
>
>
> Luckily for those of us of a sensitive disposition, I think jpgs (and
> other
> picture formats) would be filtered out by the list software, so we are
> safe from
> the threat of being suddenly confronted by images of our less-photogenic
> colleagues.  The best we could manage would be ascii representations, I'm
> sure
> someone could convert photo-to ascii if needed.-)
>
> Seriously though, I seem to remember a set of helpfull commands available
> from
> the other list address (not the posting address, the list-control one you
> get
> sent in your welcome message) - You could be stuck in 'Digest' mode, which
> would
> mean you have to wait a week for the whole list to arrive at once.  Sorry
> that
> this is a RTFM, but it's been so long since I turned off digest mode I
> can't
> remember exactly how I did it...
>
> Simon Anderson
>
>
>
>
> Please respond to [EMAIL PROTECTED] 
>
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:(bcc: Simon Anderson/SSplc)
>
>
>
>
> Please send jpgs.
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
>
> > -Original Message-
> > From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Thursday, April 25, 2002 8:03 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How come I don't get postings
> >
> > I can not see you on the list!
> >
> >-Original Message-
> >From: [EMAIL PROTECTED] 
> > [mailto:[EMAIL PROTECTED]] 
> >Sent: Thursday, April 25, 2002 8:43 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: How come I don't get postings
> >
> >
> >
> >Guys,
> >
> >Please someone tell me if you can see me on this list.  I just
> > subscribed and got the welcome message but no messages from this list.
> >
> >Thanks,
> >Paula
> >
>
>
>
>
> --
> 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: Koivu, Lisa
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

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

To REMOVE yourself from this mai

RE: Unix - Writing stderr to a file and stdout

2002-04-26 Thread Mohammed . Ahsanuddin


Hi,

I think I did not explain my request properly..let me try again.

Is it possible to write stderr to stdout and to another file
simultaneously..?

For Ex:

ls -l > outfile 2>&1 will get me command output and diagnostics info in the
same file which is outfile.

However, I am trying to get the diagnostics info into outfile as well as
into another file (say errfile). Would that be possible? I was not able to
do it with tee either..

Thanks

Mohammed Ahsanuddin
Oracle DBA
Verizon Wireless
Work : 845 365 7203
Pager : 800 366 2337 pin : 16040



-Original Message-
Sent: Friday, April 26, 2002 1:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


But of course

find . -print | xargs grep "hoser" 

This will generate errors on directories

Make the errors disappear:

 find . -print | xargs grep "hoser"  2>/dev/null

Now send the standard output to a file.  Make sure the
file is outside the directory structure you are searching.

 find . -print | xargs grep "hoser"  2>/dev/null 1>/tmp/hoser.txt

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/26/2002 11:30 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Unix - Writing stderr to a file and stdout


Hi,

Is it possible to write stderr to stdout and to another file
simultaneously..?

Thanks in advance.

Mohammed Ahsanuddin
Oracle 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: 
  INET: [EMAIL PROTECTED]

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

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

2002-04-26 Thread Gardiner, Steve


ORACLE ODBC BRAIN DUMP from [EMAIL PROTECTED]

The following are random notes for getting ODBC access to Oracle databases.
These notes are for Win2000 and MS/Access and MS/Excel. They should not be
much different for Win95.

INSTALL ORACLE CLIENT
I used cd #a840505-01. This has ODBC Driver 8.1.6.0.0. You can get a later
one from Metalink. I have 8.1.66.
The biggest problem is if you have multiple oracle products installed (with
different oracle releases) on one PC. Some Oracle product can share Oracle
Homes on the PC registry, some can't. See Metalink notes. 70215.1, 66464.1,
65995.1. Oracle PC client software that is before release 8.0.4 (uses
orainst installer) usually can't share PC registration entries and must be
installed in one Oracle Home. Oracle PC client software that is after
release 8.0.4 (Oracle Universal Installer java based) is pretty good about
multiple Oracle products. Using Oracle Universal installer choose Custom
Install, Net8 client, Oracle Protocol Support, Sqlplus, Oracle ODBC Driver.
I like to put this in it's own Oracle Home 

WINDOWS REGISTRATION ENTRIES
If there are multiple Oracle Homes, how does the Windows app (Access or
Excel, sqlplus, etc) know which to use? For Software after 8.0.4, it looks
for the file oracle.key in it path. It's in the Oracle Home /bin directory.
This file points to the correct windows registration entries. By changing
the path, you change which windows registration entries. If you install pre
8.0.4 software, install them first.
Internet Explorer 5.5 must be installed prior - I don't know why!

TNSNAMES.ORA
After I install the Oracle client, I like to add a registration entry
'TNS_ADMIN' that points to the lan directory that has our TNSNAMES.ORA file
(like P:\APPS\ORAWIN95\NETWORK\ADMIN)

WINDOWS ODBC SETUP
Adding ODBC DSNs are a little different for win2000 versus win95
Win2000
start, settings, control panel, administrative tools, data sources (odbc)
Win95
start, settings, control panel, odbc data sources (32 bit)

SETTING UP THE ODBC CONNECTION
The Data Source Name must match a entry in the ODBC application (MS/Access
or EXCEL)
TNS Service name must match an entry in a TNSNAMES.ORA file.
Use the highest level Oracle ODBC driver listed. I think the Microsoft
supplied ODBC driver is based on Oracle 6, so we never use it.

ORACLE ISSUES
The odbc user will have the same privileges as a sqlplus user! We have a db
profile that sets all roles to select only. We don't want ODBC users update
the database.
Sometime an ODBC user is prompted for a userid and password. This must match
the oracle database  user name and password. You can test this test this
with sqlplus at a dos command prompt
When the ODBC application does not prompt for a password. An Oracle User
OSP$USERNAME must match the network id on user's PC. The ops$username
database account must have the correct database privileges to view the
tables.
The first time a ODBC user signs into the database, all table name are
displayed to the user. This may take minutes to log in. There is a limit of
4000 table names displayed. Sometimes because of some other error, only one
table is displayed. There is a suggested solution in METALINK Note 124117.1.
This involves creating database special ALL_OBJECTS and ALL_SYNONYMS view
for that user. I would not want to do this for every individual ODBC user
but we could create a generic ODBC oracle database user so we could control
what users see by this technique. I don't like the idea of a ODBC user
seeing the names of every table even though they might not have select
access on it.

PATH ISSUES
The biggest problem is getting the windows path variable correct. I don't
want to set a path in an autoexec.bat file or Win2000 system env variable,
so I execute Access (or whatever) this with a shortcut pointing to a .bat
file:
set path=C:\oracle8iClient\8.1.6\bin;%PATH%
 "C:\Program Files\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" 

You will also need to do this for the ODBC Administrator Setup Panel
set path=C:\oracle8iClient\8.1.6\bin;%PATH%
C:\WINNT\SYSTEM32\ODBCAD32.exe

The Oracle utility 'Oracle Home Selector' sets the path too. See Metalink
Note 66464.1.

Sqlplus and tnsping at a DOS prompt are very good at debugging connection
problems.

Other Notes from Metalink or OTN
Note 11841.1, 1029911.6
ODBC 8.1.6.6.6 Read Me
Using the Oracle ODBC Drivers with Third Party Products by Rick Schultz,
Oracle Corp

Hope this helps
Steve Gardiner
[EMAIL PROTECTED]




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

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

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

RE: Compare (diff) Oracle DB and MS-SQLServer DB - DBArtisan

2002-04-26 Thread Ray Gordon


Spent some long hours on DBArtisan...nice looking tool.

However, it does not allow simultaneous connections for a compare. In fact, 
it does not have the word "compare" in its 
vocabulary/help/contents/find/index...  Well, it "does not compare".

So in conclusion, I think NO TOOL EXISTS that compares Oracle and SQLServer. 
  I now open the floor to sql scripts, just send me anything that will help, 
and which we can modify.  I would like to thank Raj Shakti for sending a 
compare script for comparison between two Oracle users. I will forward this 
to the group.

Ray


>From: "Mark Leith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Compare (diff) Oracle DB and MS-SQLServer DB
>Date: Fri, 19 Apr 2002 01:23:22 -0800
>
>Ray,
>
>Have you looked at Embarcardero's DBArtisan tool? I'm not sure if it will 
>do
>an active compare of the schemas etc. but it certainly works on both Oracle
>and SQLServer concurrently, and is in the "ballpark" that you are looking
>for..
>
>May be worth checking it out:
>
>www.embarcadero.com
>
>HTH
>
>Mark
>
>===
>  Mark Leith | T: +44 (0)1905 330 281
>  Sales & Marketing  | F: +44 (0)870 127 5283
>  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
>===
>http://www.cool-tools.co.uk
>Maximising throughput & performance
>
>-Original Message-
>Sent: 18 April 2002 21:24
>To: Multiple recipients of list ORACLE-L
>
>
>Mostly schema (tables, views, indexes, ...) and if possible data (reference
>tables).
>
>Now, ERWin... I dont think so...not a good idea to use an ER tool.  We 
>would
>end up unnecessarily managing a model within ERWin, and we would have to
>retrofit the model (complete compare) each time before running the compare.
>Such a pain, and I would have to hire another person and keep paying 
>another
>salary just to do this.  I want to reduce my headcount not increase it.
>
>What we need is a very simple utility.  Something like TOAD.  But TOAD only
>works for ORACLE and does not let you set conditions, so it will be useless
>here.
>
>While I am dreaming... lets continue.  We need something like an ADVANCED
>TOAD, i.e. which not only identifies the diffs but shows the deltas 
>exactly,
>and which allows us to set conditions for the compare (eg: ignore
>tablespace, ignore INITIAL, ignore datatype, etc.).
>
>Ray
>
>
> >From: Joe Raube <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Compare (diff) Oracle DB and MS-SQLServer DB
> >Date: Thu, 18 Apr 2002 10:42:37 -0800
> >
> >Diff of what? Data? Schema? Stored procs?
> >
> >Depends on what you need -- ERwin or another ER tool may be able to
> >help find schema diffs...
> >
> >--- Ray Gordon <[EMAIL PROTECTED]> wrote:
> > > One of our teams started programming in SQLServer, but now we are
> > > live in a
> > > production ORACLE environment.  Due to several issues, such as
> > > licensing,skills, etc., the development must stay on SQLServer.
> > >
> > > Is there a tool or whatever to find out the deltas between a
> > > SQLServerDB
> > > and an Oracle DB?  Or any suggestions.
> > >
> > > Ray
> > >
> > >
> > > _
> > > Send and receive Hotmail on your mobile device:
> > > http://mobile.msn.com
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ray Gordon
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
> >
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like
> >subscribing).
> >
> >
> >__
> >Do You Yahoo!?
> >Yahoo! Tax Center - online filing with TurboTax
> >http://taxes.yahoo.com/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Joe Raube
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  Y

Re: How come I don't get postings

2002-04-26 Thread bill thater


[EMAIL PROTECTED] wrote:

> oh oh, lisa has a fan club :-)


with lots of members.;-)



-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

On a clear disk you can seek forever.   -Computerworld button




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

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

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


Try the tee command

ls -l > outfile 2> tee -a &1

Never tried it this way, so time to experiement... :-)

RF

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L


Hi,

I think I did not explain my request properly..let me try again.

Is it possible to write stderr to stdout and to another file
simultaneously..?

For Ex:

ls -l > outfile 2>&1 will get me command output and diagnostics info in the
same file which is outfile.

However, I am trying to get the diagnostics info into outfile as well as
into another file (say errfile). Would that be possible? I was not able to
do it with tee either..

Thanks

Mohammed Ahsanuddin
Oracle DBA
Verizon Wireless
Work : 845 365 7203
Pager : 800 366 2337 pin : 16040



-Original Message-
Sent: Friday, April 26, 2002 1:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


But of course

find . -print | xargs grep "hoser" 

This will generate errors on directories

Make the errors disappear:

 find . -print | xargs grep "hoser"  2>/dev/null

Now send the standard output to a file.  Make sure the
file is outside the directory structure you are searching.

 find . -print | xargs grep "hoser"  2>/dev/null 1>/tmp/hoser.txt

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/26/2002 11:30 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Unix - Writing stderr to a file and stdout


Hi,

Is it possible to write stderr to stdout and to another file
simultaneously..?

Thanks in advance.

Mohammed Ahsanuddin
Oracle 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: 
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: URGENT : contact phone of Oracle Support


Of course, if you don't have a CSI, good luck getting support! :-)

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


1-800-223-1711
1-415-506-1500

Reply Separator
Author: "Mandal; Ashoke" <[EMAIL PROTECTED]>
Date:   4/26/2002 6:03 AM

Could any of you send me the 1-800 no. and also the other phone no. for
contacting Oracle support.

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

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

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

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

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

RE: What block size are you using for your new 9i data warehouse?

Gaja,

Thanks for this enlightening and helpful reply.

Cherie

Gaja Krishna   

Vaidyanatha  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: RE: What block size are you 
using for your new 9i data   
Sent by:  warehouse?   

[EMAIL PROTECTED] 

om 

04/26/02 11:48 

AM 

Please respond 

to ORACLE-L

All,

Something to keep in mind regardless of whether you
are using 9i or not. This issue becomes more relevant
in 9i with "multiple block sizes" for different
tablespaces.

You always want to ensure that your DB_BLOCK_SIZE =
File System Block Size. This is to avoid wasted I/O
and also the case where the "read ahead algorithm" is
triggered accidentally, when 1 Database Block results
in multiple file system blocks being read from disk.

If your application performs range scans, there is a
high possibility that multiple "single database block"
read requests to a set of contiguous blocks, may
result in the "read ahead algorithm" performing 128K
or 256K pre-fetches, even though your application may
have not required all 128K or 256K.

This problem is rampant on ufs file systems where the
default block size is 512 bytes, and with a 8K
DB_BLOCK_SIZE, it takes 16 file system blocks to store
1 DB block on disk. However, even if you have advanced
file systems and have a 1-is-to-2 ratio of DB block
is-to FS blocks, you are still in danger of
overloading your I/O sub-system, "under the right
conditions".

If you are using a volume manager product such as
Veritas, and if your version of the volume manager
supports "dynamic file system block sizing" based on
size of the file system or the files themselves,
please pay close attention to that detail and make
sure that the file system block size does not exceed
the database block size (based on the size of the file
system).

Best regards,

Gaja

--- Johnson Poovathummoottil <[EMAIL PROTECTED]>
wrote:
> We too have a data warehouse close to 500GB in size.
> We upgraded the OS solaris 2.8 and our block size is
> 16K. All our data and index tablespaces datafiles
> are
> spread across 20 files systems whose disks are on
> EMC
> storage. We too user veritas volume manager. File
> systems use four 9 GB disks whaich are raid S and
> software stripe uinit size of 256 KB.
>
> reasons
>  16K  block size as we have many full table scan ans
> sequential reads.
>  256 KB stripe unit size because we have set the
> db_file_multi_block_read_count to 64(1MB)
>
> we are moving to a sun fire 15K machine soon and
> then
> the we will go to 9i 64 bit.
>
> --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> wrote:
> > Cherie:
> >
> > If you are using Oracle 9i, you can use mutliple
> > block sizes! You still
> > create your database with a default block size,
> but
> > each tablespace (except
> > system) can have a block size different from the
> > default.
> >
> > Valid blocksizes are limited by OS, but they range
> > from 2K to 32k.
> >
> > Check out the 9i docs for CREATE TABLESPACE for
> more
> > info.
> >
> > Caver
> >
> > -Original Message-
> > Sent: Thursday, April 25, 2002 11:24 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > We are building a new version 9.0.1 data warehouse
> > on Sun Solaris 2.6
> > migrating to Solaris 2.8.  We will be using
> striped
> > disk that is striped
> > using Veritas Volume Manager on EMC disk.
> >
> > The datawarehouse will be about 200 Gig.   It will
> > be written to throughout
> > the day.
> >
> > To this point, almost all of our databases have
> been
>

Tuning Question and Advice needed ..

2002-04-26 Thread Bunyamin K. Karadeniz




Dear Gurus , I need your help ..
 
I run UTLBSTAT and then after 2 hour run the 
UTLESTAT.sql scripts as internal and  look at the report.txt generated 
...
 
On report.txt , I see that 
 
System wide wait events for background processes: 

System wide wait events for non-background 
processes :
Latch statistics
Statistics on no_wait gets of latches
Sum IO operations over tablespaces
 
and other things also is in the report. 

 
Question 1) 
What I wonder is  
Are these values between the start and end times of 
scripts. 
What I mean is  , for example  Is  the 
wait events for non-background processes list in report are the wait events 
occured between UTLBSTAT script run time T1 and UTLESTAT script run time 
T2   ? or  are they total wait events from the startup 
of   database ?
 
Question 2) 
I see lots of wait events occur .. 
What will I give importance to ? 
will I try to make 0 wait event in report. What are 
the optimums of wait events. ? 
For example I see  
 
"Latch free event" occured for 3015 times , 

"control file sequential read" occured for 182 
times ,
"log file sync" occured for 1756 times 

"direct path read" occured for 11000 
times
"direct path write" occured for 6000 
times
 
Are these values normal ? Will I try to make them 0 
in the tomarrows report ?
 
How can I comment on the report ? Is there a link 
you can tell me to understand the problems and will help me to read and action 
about the problems ? 
 
Thank you...
 
 
 
 
 
 
 
 
 
Bunyamin K. 
Karadeniz   Oracle 
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 
3357729

ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =..txt file

2002-04-26 Thread Eric D. Pierce


I don't know if this guy (Evans, David) is subscribed to this list, 
but if so, please tell your email admin that this stuff sucks.

A text file attachment is not automatically equivalent to a virus 
attachment.

If their system wasn't set up by such dikheads, they would know 
that they can implement packet scanning at the email gateway in a 
non-intrusive manner that is far more effective than this spam 
cr*pola. 

http://www.antivirus.com/products/isvw/

regards,
ep





Return-path: <[EMAIL PROTECTED]>

Received: from acsdefense.com ([208.155.8.98])
by csus.edu with ESMTP id LAA23736
for <[EMAIL PROTECTED]>; Fri, 26 Apr 2002 11:33:14 -0700 (PDT)

Received: from dilbert.acsdefense.com ([192.168.101.7]) by 
gateway.acsdefense.com with ESMTP id <119046>; Fri, 26 Apr 2002 
14:35:41 -0400

Received: by webmail.acsdefense.com with Internet Mail Service 
(5.5.2654.89)   id ; Fri, 26 Apr 2002 14:33:05 -0400

Message-ID: <299610E95611D411AE5500508BA37D830155F48F@ACSPHX03>

To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Date:  Fri, 26 Apr 2002 13:22:04 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2654.89)
Content-Type: text/plain
X-PMFLAGS: 34078848 0 1 Y0F158.CNM

Antigen for Exchange found Text from file 'ORACLNT5.TXT'.txt 
matching
=*.*.txt file filter.
The file is currently Removed.  The message, "oracle/nt-5 (last)", 
was
sent from Eric D. Pierce and was discovered in Evans, David\ORACLE-
L\EP
located at ACS/ACSPHX/ACSPHX03.

--- Forwarded message follows ---
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Date sent:  Fri, 26 Apr 2002 13:22:06 -0400

Antigen for Exchange found Text from file 'N093_NT4.TXT'.txt 
matching
=*.*.txt file filter.
The file is currently Removed.  The message, "N093_NT1.TXT [4 of 
4]", was
sent from Eric D. Pierce and was discovered in Evans, David\ORACLE-
L\EP
located at ACS/ACSPHX/ACSPHX03.
--- End of forwarded message ---
-- 
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: CPU Pegged at 100%

2002-04-26 Thread Whittle Jerome Contr NCI

Title: RE: CPU Pegged at 100%

Raghu,

Do not depend on Performance Monitor alone for your CPU statistics. At least in NT4, it quite often reports 100% usage with nothing going on. Right now on my workstation I have one little Access database open with no activity. Performance Monitor is saying CPU is at 100% and has been for the last 5 minutes.

Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From: Raghu Banaji [SMTP:[EMAIL PROTECTED]]

Hi,

I have a customer who runs an ERP application written using
ORACLE. Almost all code is written using PL/SQL packages. There are about 80-100 users
at any given point of time(6 AM - 11 PM). Oracle version is 8.1.7.1.1 Standard Edition.
All the four CPU's on their server is pegged at 100% for most of the time. This is resulting
in end users complaning about slow performance and slower log-ons to the application.
This issue has been occuring consistently for over 2-3 weeks now. Archive logging is enabled
and the database is normally shutdown once a week for cold backup.

The Admin guys have been monitoring the server using Performance monitor and
find that Oracle.exe is the process consuming 99% of the resource. Memory usage is
constant and there is plenty of it free. Hard disk drives show no activity. A normal
assumption would be that disk drives would be going crazy with all
the CPU activity going on, but that does not seem to be the case.

Oracle software and one PRODuction database exist on this server.

Their Server configuration consists of:
Windows 2000 OS (Advanced Server), with 4 Pentium III Xeon processors (each 700 Mhz),
4 Gb RAM and 2 disk drives on seperate disk controllers. Hard drives are of 15,000 RPM's.

<<< snipped >>>

Thanks,
Raghu

Re: index status misleading?



Gene,

Perhaps the indexes weren't owned by MYOWNER.   Accidentally owned by a
different userid?

Cherie Machler
Oracle DBA
Gelco Information Network


   

Gurelei

   
.com>cc:   

Sent by: Subject: index status misleading? 

[EMAIL PROTECTED] 

om 

   

   

04/26/02 10:28 

AM 

Please respond 

to ORACLE-L

   

   





Hi all:

Last night I have moved couple of tables from one TS
to another. Then I thought I'd check whether I need to
rebuild any indices. I ran the following query:

select distinct status from dba_objects
where owner = 'MYOWNER'

Oracle returned I row with value VALID. From that I
concluded that there were no indices to be rebuilt.
This morning however it turns out that there indeed
were indices in UNUSABLE state. What I don't
understand is why didn't I see UNUSABLE in the output
of my query. Can anyone explain please?

thanks

Gene

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

2002-04-26 Thread DENNIS WILLIAMS


Bunyamin - I went to http://www.google.com   and
searched for "utlbstat" and received 1,050 results. I would recommend that
you try the same and read up on the resources available over the Internet. I
would also recommend the book Oracle Performance Tuning 101 by Gaja Krishna
Vaidyanatha
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, April 26, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L


Dear Gurus , I need your help ..
 
I run UTLBSTAT and then after 2 hour run the UTLESTAT.sql scripts as
internal and  look at the report.txt generated ...
 
On report.txt , I see that 
 
System wide wait events for background processes: 
System wide wait events for non-background processes :
Latch statistics
Statistics on no_wait gets of latches
Sum IO operations over tablespaces
 
and other things also is in the report. 
 
Question 1) 
What I wonder is  
Are these values between the start and end times of scripts. 
What I mean is  , for example  Is the wait events for non-background
processes list in report are the wait events occured between UTLBSTAT script
run time T1 and UTLESTAT script run time T2   ? or  are they total wait
events from the startup of   database ?
 
Question 2) 
I see lots of wait events occur .. 
What will I give importance to ? 
will I try to make 0 wait event in report. What are the optimums of wait
events. ? 
For example I see  
 
"Latch free event" occured for 3015 times , 
"control file sequential read" occured for 182 times ,
"log file sync" occured for 1756 times 
"direct path read" occured for 11000 times
"direct path write" occured for 6000 times
 
Are these values normal ? Will I try to make them 0 in the tomarrows report
?
 
How can I comment on the report ? Is there a link you can tell me to
understand the problems and will help me to read and action about the
problems ? 
 
Thank you...
 
 
 
 
 
 
 
 
 
Bunyamin K. Karadeniz   
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu 
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729


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

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

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

RE: What block size are you using for your new 9i data

2002-04-26 Thread Gaja Krishna Vaidyanatha

Hi Bill & list,

The main function of a "read ahead algorithm" is to
anticipate the nature of I/O requests on a given track
of a disk's platter and see whether it is beneficial
to "pre-fetch" some of the blocks, so that subsequent
requests can be serviced from the either the
controller's or the file system's cache, without
having to "go to disk" multiple times.

The OS (or the sub-system) should normally return only
the same number of blocks as requested. But, if there
are multiple "read requests" from Oracle that are
physically contiguous on disk and they also occur in a
rapid succession, the OS or the I/O sub-system (as the
case may be), "second guesses" the requestor's intent
and assumes that more of the other blocks in the same
track will also be requested, in the near future.

For a real "sequential scan", like in a full-table
scan or an index fast-full scan, this is beneficial.
But in the case of a range scan where only "a few
contiguous blocks" are requested, pre-fetching 128K or
256K worth of data is wasteful use of a system's I/O
resources. This is because, not all the blocks that is
pre-fetched will be consumed.

The issue of an 8K DB_BLOCK_SIZE with say a 512-byte
File System (or OS) Block Size, is that there is a
1-is-to-16 ratio between logical and physical blocks.
So, for example if 4 Oracle blocks are requested, they
translate into 64 FS (or OS) blocks. If these blocks
are contiguous (and chances are good that leaf blocks
in an index can be contiguous ), it becomes an "ideal
condition" for the read-ahead algorithm to engage. So
instead of servicing 32K of data, the sub-system
retrieves 128K or 256K worth of data.

And, even if you have a 1-is-to-2 ratio between
logical and physical blocks (DB_BLOCK_SIZE is 8K and
FS Block Size is 4K), under the "right conditions",
the read-ahead algorithm will engage and pre-fetch in
a wasteful manner. So the bottom line is follows:

Keep DB_BLOCK_SIZE = FS(or OS) Block Size

This way, if Oracle requests for a few blocks in a
track, the OS does not pre-fetch all of the blocks in
the track. As mentioned before, in case of a "real
sequential scan", the pre-fetch comes in goodstead.

Hope that helps,

Gaja

--- Bill Buchan <[EMAIL PROTECTED]> wrote:
> 
> Sorry, I'm a bit non-clued up on this "read ahead
> algorithm".  Could I be a 
> pain and ask for more details?  Does the OS return
> one OS block if exactly 
> one is requested, but if 2 are requested it thinks
> "aha! sequential scan" 
> and goes and gets 4 or 8 or something?
> 
> The follow on is, does this mean you should use a
> (minimal) 2k block size 
> on UFS, 512 bytes blocks, or is this read-ahead
> overhead a smaller 
> performance hit than that of using a database block
> size which is too small 
> for the application?
> 
> Thanks
> - Bill.
> 
> 
> At 08:48 26/04/02 -0800, you wrote:
> >All,
> >
> >You always want to ensure that your DB_BLOCK_SIZE =
> >File System Block Size. This is to avoid wasted I/O
> >and also the case where the "read ahead algorithm"
> is
> >triggered accidentally, when 1 Database Block
> results
> >in multiple file system blocks being read from
> disk.
> >
> >If your application performs range scans, there is
> a
> >high possibility that multiple "single database
> block"
> >read requests to a set of contiguous blocks, may
> >result in the "read ahead algorithm" performing
> 128K
> >or 256K pre-fetches, even though your application
> may
> >have not required all 128K or 256K.
> >
> >This problem is rampant on ufs file systems where
> the
> >default block size is 512 bytes, and with a 8K
> >DB_BLOCK_SIZE, it takes 16 file system blocks to
> store
> >1 DB block on disk. However, even if you have
> advanced
> >file systems and have a 1-is-to-2 ratio of DB block
> >is-to FS blocks, you are still in danger of
> >overloading your I/O sub-system, "under the right
> >conditions".
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Bill Buchan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gaja Kr

RE: index status misleading?

2002-04-26 Thread Khedr, Waleed


Looking at the status column in DBA_OBJECTS will show if the object is valid
or not.

Unusable index is still a valid object.

You should get the status from dba_indexes.

Try this:

create table  tes ( c1 number);
create index  testgg on testcase.tes ( c1);
alter  index  testgg unusable;

select status from dba_objects where object_name = 'TESTGG';
select status from dba_indexes where index_name  = 'TESTGG';

Regards,

Waleed

-Original Message-
Sent: Friday, April 26, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


Hi all:

Last night I have moved couple of tables from one TS
to another. Then I thought I'd check whether I need to
rebuild any indices. I ran the following query:

select distinct status from dba_objects
where owner = 'MYOWNER'

Oracle returned I row with value VALID. From that I
concluded that there were no indices to be rebuilt.
This morning however it turns out that there indeed
were indices in UNUSABLE state. What I don't
understand is why didn't I see UNUSABLE in the output
of my query. Can anyone explain please?

thanks

Gene

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Compare (diff) Oracle DB and MS-SQLServer DB - DBArtisan

2002-04-26 Thread Thomas Day



This is not mine -- I just added the SYNONYMS
The remote link (for the database to compare to) is @IHP (global edit as
needed)
/*
This script compares the object definitions in the current schema
to that of a remote schema.
The remote schema is defined using a database link.
THE SCRIPT COMPARES THE FOLLOWING:
- Existence of tables
- Existence of columns
- Column definitions
- Existence of indexes
- Index definitions (column usage)
- Existence of constraints
- Constraint definitions (table, type and reference)
- Constraint column usage (for unique, primary key and foreign keys)
- Check constraint definitions
- Existence of triggers
- Definition of triggers
- Existence of procedure/packages/functions
- Definition of procedures/packages/functions
(Ie. the script does not do a complete check, it does not for example
check any grants, clusters or storage definitions).
The script drops and creates a few temporary objects prefixed with
the first 3 letter combination (AAA - ZZZ) that does not conflict with any
existing objects.
This script has been tested on Oracle 7.3.
Added synonyms 6-14-01  T. Day
*/
undef prex
undef prefx
undef a
undef thisuser
undef b
undef REMOTESCHEMA
undef REMOTEPASSW
undef connstring
undef c
undef todaysdate
variable prefx varchar2(3)
declare
i number ;
j number ;
k number ;
cnt number;
begin
 for i in ascii('A') .. ascii('Z') loop
  for j in ascii('A') .. ascii('Z') loop
   for k in ascii('A') .. ascii('Z') loop
 select count(*) into cnt from DBA_objects@IHP where object_name like
 chr(i)||chr(j)||chr(k)||'%'
 AND OWNER = upper('&&1');
 if cnt = 0 then
   :prefx := chr(i)||chr(j)||chr(k);
   return;
 end if;
end loop;
   end loop;
  end loop;
end;
/
column a new_val prex
set verify off
set linesize 132
SET PAGESIZE 0
set feedback off
select :prefx a from dual;
column b new_val thisuser
select user b from dual;
column c new_val todaysdate
select to_char(sysdate,'DD-MON- HH24:MI') c from dual;
accept REMOTESCHEMA char prompt 'Enter remote username:'
--accept REMOTEPASSW char prompt 'Enter remote password:' hide
--accept connstring char prompt 'Enter remote connectstring:'

spool c:\project\listings\&&1.dbdiff.lst
PROMPT
PROMPT
PROMPT
~~
PROMPT SCHEMA DEFINITION DIFFERENCES &todaysdate
PROMPT
PROMPT
~~
PROMPT
PROMPT
--create database link EID1 connect to &REMOTESCHEMA identified
--by &REMOTEPASSW using '&CONNSTRING';
PROMPT
PROMPT
PROMPT
~~
PROMPT  TABLES MISSING IN &&1 on IHP production:
PROMPT
~~
column table_name format a38
column column_name format a38
column synonym_name format a38
column owner format a8
column constraint_name format a38
create table &prex.common_tables as
select table_name from DBA_TAbles@EID1 WHERE OWNER = upper('&&1')
intersect
select table_name from DBA_tables@IHP WHERE OWNER = upper('&&1');
select table_name from DBA_TAbles@EID1 WHERE OWNER = upper('&&1')
minus
select table_name from &prex.common_tables;
PROMPT
PROMPT
PROMPT
~~
PROMPT TABLES MISSING IN &&1 on EID production:
PROMPT
~~
select table_name from DBA_TAbles@IHP WHERE OWNER = upper('&&1')
minus
select table_name from &prex.common_tables;
PROMPT
PROMPT
~~
PROMPT  SYNONYMS MISSING IN &&1 on IHP production:
PROMPT
~~
create table &prex.common_synonyms as
select table_name, synonym_name, owner from DBA_synonyms@EID1 WHERE
table_owner = upper('&&1')
intersect
select table_name, synonym_name, owner from DBA_synonyms@IHP WHERE
table_owner = upper('&&1');
select table_name, synonym_name, owner from DBA_synonyms@EID1 WHERE
table_owner = upper('&&1')
minus
select table_name, synonym_name, owner from &prex.common_synonyms;
PROMPT
PROMPT
PROMPT
~~
PROMPT SYNONYMS MISSING IN &&1 on EID production:
PROMPT
~~
select table_name, synonym_name, owner from DBA_synonyms@IHP WHERE
table_owner = upper('&&1')
minus
select table_name, synonym_name, owner from &prex.common_synonyms;
PROMPT
PROMPT
PROMPT
~~
PROMPT COLUMNS MISSING IN &&1 on EID production FOR COMMON TABLES
PROMPT
~~
select table_name,column_name from DBA_tab_columns@EID1
where table_name in
(select table_name from &prex.common_tables) AND OWNER = upper('&&1')
minus
select table_name,column_name from DBA_tab_columns@IHP

RE: What block size are you using for your new 9i data warehouse?


Can anyone tell me how to figure out the file system block size and max i/o
size of a Windows 2000 system?  My sysadmin had no clue.  (Gosh, can't
imagine why, everything's hidden behind that stupid gui)

Thanks in advance for any replies

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

> -Original Message-
> From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 12:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: What block size are you using for your new 9i data
> warehouse?
> 
> All,
> 
> Something to keep in mind regardless of whether you
> are using 9i or not. This issue becomes more relevant
> in 9i with "multiple block sizes" for different
> tablespaces. 
> 
> You always want to ensure that your DB_BLOCK_SIZE =
> File System Block Size. This is to avoid wasted I/O
> and also the case where the "read ahead algorithm" is
> triggered accidentally, when 1 Database Block results
> in multiple file system blocks being read from disk.
> 
> If your application performs range scans, there is a
> high possibility that multiple "single database block"
> read requests to a set of contiguous blocks, may
> result in the "read ahead algorithm" performing 128K
> or 256K pre-fetches, even though your application may
> have not required all 128K or 256K. 
> 
> This problem is rampant on ufs file systems where the
> default block size is 512 bytes, and with a 8K
> DB_BLOCK_SIZE, it takes 16 file system blocks to store
> 1 DB block on disk. However, even if you have advanced
> file systems and have a 1-is-to-2 ratio of DB block
> is-to FS blocks, you are still in danger of
> overloading your I/O sub-system, "under the right
> conditions".
> 
> If you are using a volume manager product such as
> Veritas, and if your version of the volume manager
> supports "dynamic file system block sizing" based on
> size of the file system or the files themselves,
> please pay close attention to that detail and make
> sure that the file system block size does not exceed
> the database block size (based on the size of the file
> system).
> 
> Best regards,
> 
> Gaja
> 
> --- Johnson Poovathummoottil <[EMAIL PROTECTED]>
> wrote:
> > We too have a data warehouse close to 500GB in size.
> > We upgraded the OS solaris 2.8 and our block size is
> > 16K. All our data and index tablespaces datafiles
> > are
> > spread across 20 files systems whose disks are on
> > EMC
> > storage. We too user veritas volume manager. File
> > systems use four 9 GB disks whaich are raid S and
> > software stripe uinit size of 256 KB.
> > 
> > reasons 
> >  16K  block size as we have many full table scan ans
> > sequential reads.
> >  256 KB stripe unit size because we have set the
> > db_file_multi_block_read_count to 64(1MB)
> > 
> > we are moving to a sun fire 15K machine soon and
> > then
> > the we will go to 9i 64 bit.
> > 
> > --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> > wrote:
> > > Cherie:
> > > 
> > > If you are using Oracle 9i, you can use mutliple
> > > block sizes! You still
> > > create your database with a default block size,
> > but
> > > each tablespace (except
> > > system) can have a block size different from the
> > > default.
> > > 
> > > Valid blocksizes are limited by OS, but they range
> > > from 2K to 32k. 
> > > 
> > > Check out the 9i docs for CREATE TABLESPACE for
> > more
> > > info.
> > > 
> > > Caver
> > > 
> > > -Original Message-
> > > Sent: Thursday, April 25, 2002 11:24 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > We are building a new version 9.0.1 data warehouse
> > > on Sun Solaris 2.6
> > > migrating to Solaris 2.8.  We will be using
> > striped
> > > disk that is striped
> > > using Veritas Volume Manager on EMC disk.
> > > 
> > > The datawarehouse will be about 200 Gig.   It will
> > > be written to throughout
> > > the day.
> > > 
> > > To this point, almost all of our databases have
> > been
> > > created with an 8k
> > > block size.   i'm not sure if that blocksize is
> > > optimal anymore.   With 9i,
> > > what block sizes are people using in the field
> > > nowadays for data
> > > warehouses?
> > > 
> > > Also, if you use striped disk, what stripe size
> > are
> > > you using and why?
> > > 
> > > Thanks for weighing in on this topic.
> > > 
> > > Cherie Machler
> > > Oracle DBA
> > > Gelco Information Network
> > > 
> > > -- 
> > > 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
> > > 'ListGu

RE: How come I don't get postings


um, thanks, but NOT ANYMORE!!!  

> -Original Message-
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 12:59 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How come I don't get postings
> 
> And boy - don't we know how Lisa got in to that "Baby oven" position! ;P
> 
> 
> 
> 
> 
> -Original Message-
> Sent: 26 April 2002 16:58
> To: Multiple recipients of list ORACLE-L
> 
> 
> Simon, if you don't know Scott, he's a huge joker and a source of many
> laughs...
> 
> He was kidding!
> 
> But seriously there is a whole slew of pics of OT list members on Yahoo.
> There's even one of me pre-pregnancy.  (I can barely remember what that
> was
> like.)
> 
> Lisa Koivu
> Oracle Database Baby Oven
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA  33063
> 
> > -Original Message-
> > From:   [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, April 26, 2002 11:28 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: How come I don't get postings
> >
> >
> >
> > .jpgs ?!*&!
> >
> >
> > Luckily for those of us of a sensitive disposition, I think jpgs (and
> > other
> > picture formats) would be filtered out by the list software, so we are
> > safe from
> > the threat of being suddenly confronted by images of our less-photogenic
> > colleagues.  The best we could manage would be ascii representations,
> I'm
> > sure
> > someone could convert photo-to ascii if needed.-)
> >
> > Seriously though, I seem to remember a set of helpfull commands
> available
> > from
> > the other list address (not the posting address, the list-control one
> you
> > get
> > sent in your welcome message) - You could be stuck in 'Digest' mode,
> which
> > would
> > mean you have to wait a week for the whole list to arrive at once.
> Sorry
> > that
> > this is a RTFM, but it's been so long since I turned off digest mode I
> > can't
> > remember exactly how I did it...
> >
> > Simon Anderson
> >
> >
> >
> >
> > Please respond to [EMAIL PROTECTED]
> >
> > To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > cc:(bcc: Simon Anderson/SSplc)
> >
> >
> >
> >
> > Please send jpgs.
> >
> > Scott Shafer
> > San Antonio, TX
> > 210-581-6217
> >
> >
> > > -Original Message-
> > > From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
> > > Sent:   Thursday, April 25, 2002 8:03 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: How come I don't get postings
> > >
> > > I can not see you on the list!
> > >
> > >-Original Message-
> > >From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]
> > >Sent: Thursday, April 25, 2002 8:43 PM
> > >To: Multiple recipients of list ORACLE-L
> > >Subject: How come I don't get postings
> > >
> > >
> > >
> > >Guys,
> > >
> > >Please someone tell me if you can see me on this list.  I just
> > > subscribed and got the welcome message but no messages from this list.
> > >
> > >Thanks,
> > >Paula
> > >
> >
> >
> >
> >
> > --
> > 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: Koivu, Lisa
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> 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

Re: index status misleading?

2002-04-26 Thread Gurelei


Mo, They are all in the same schema. Looks like
dba_index would have provided more accurate results

--- [EMAIL PROTECTED] wrote:
> 
> Gene,
> 
> Perhaps the indexes weren't owned by MYOWNER.  
> Accidentally owned by a
> different userid?
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> 
> 
> 
>  
> Gurelei 
> 
>  
>  Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>   
> .com>cc:
> 
>  
> Sent by: Subject:   
>  index status misleading?   
>  
> [EMAIL PROTECTED]  
> 
>  
> om  
> 
>  
> 
> 
>  
> 
> 
>  
> 04/26/02 10:28  
> 
>  
> AM  
> 
>  
> Please respond  
> 
>  
> to ORACLE-L 
> 
>  
> 
> 
>  
> 
> 
>  
> 
> 
> 
> 
> Hi all:
> 
> Last night I have moved couple of tables from one TS
> to another. Then I thought I'd check whether I need
> to
> rebuild any indices. I ran the following query:
> 
> select distinct status from dba_objects
> where owner = 'MYOWNER'
> 
> Oracle returned I row with value VALID. From that I
> concluded that there were no indices to be rebuilt.
> This morning however it turns out that there indeed
> were indices in UNUSABLE state. What I don't
> understand is why didn't I see UNUSABLE in the
> output
> of my query. Can anyone explain please?
> 
> thanks
> 
> Gene
> 
> __
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

Re: How come I don't get postings

2002-04-26 Thread Bill Gentry

Title: How come I don't get postings



I see you!
 
Bill GentryDBAAllina Health SystemMinneapolis, MN 
55403612-775-1190[EMAIL PROTECTED]

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, April 25, 2002 7:43 
  PM
  Subject: How come I don't get 
  postings
  
  Guys, 
  Please someone tell me if you can see me on this 
  list.  I just subscribed and got the welcome message but no messages from 
  this list.
  Thanks, Paula

RE: What block size are you using for your new 9i data warehouse?

2002-04-26 Thread Todd Carlson


If I remember right the default W2K block size is .5K.
The max IO size depends on the RAID controllers used. 

What, you don't like the GUI? ;-)


Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246

-Original Message-
Lisa
Sent: Friday, April 26, 2002 3:31 PM
To: Multiple recipients of list ORACLE-L
warehouse?

Can anyone tell me how to figure out the file system block size and max
i/o
size of a Windows 2000 system?  My sysadmin had no clue.  (Gosh, can't
imagine why, everything's hidden behind that stupid gui)

Thanks in advance for any replies

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

> -Original Message-
> From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 12:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: What block size are you using for your new 9i data
> warehouse?
> 
> All,
> 
> Something to keep in mind regardless of whether you
> are using 9i or not. This issue becomes more relevant
> in 9i with "multiple block sizes" for different
> tablespaces. 
> 
> You always want to ensure that your DB_BLOCK_SIZE =
> File System Block Size. This is to avoid wasted I/O
> and also the case where the "read ahead algorithm" is
> triggered accidentally, when 1 Database Block results
> in multiple file system blocks being read from disk.
> 
> If your application performs range scans, there is a
> high possibility that multiple "single database block"
> read requests to a set of contiguous blocks, may
> result in the "read ahead algorithm" performing 128K
> or 256K pre-fetches, even though your application may
> have not required all 128K or 256K. 
> 
> This problem is rampant on ufs file systems where the
> default block size is 512 bytes, and with a 8K
> DB_BLOCK_SIZE, it takes 16 file system blocks to store
> 1 DB block on disk. However, even if you have advanced
> file systems and have a 1-is-to-2 ratio of DB block
> is-to FS blocks, you are still in danger of
> overloading your I/O sub-system, "under the right
> conditions".
> 
> If you are using a volume manager product such as
> Veritas, and if your version of the volume manager
> supports "dynamic file system block sizing" based on
> size of the file system or the files themselves,
> please pay close attention to that detail and make
> sure that the file system block size does not exceed
> the database block size (based on the size of the file
> system).
> 
> Best regards,
> 
> Gaja
> 
> --- Johnson Poovathummoottil <[EMAIL PROTECTED]>
> wrote:
> > We too have a data warehouse close to 500GB in size.
> > We upgraded the OS solaris 2.8 and our block size is
> > 16K. All our data and index tablespaces datafiles
> > are
> > spread across 20 files systems whose disks are on
> > EMC
> > storage. We too user veritas volume manager. File
> > systems use four 9 GB disks whaich are raid S and
> > software stripe uinit size of 256 KB.
> > 
> > reasons 
> >  16K  block size as we have many full table scan ans
> > sequential reads.
> >  256 KB stripe unit size because we have set the
> > db_file_multi_block_read_count to 64(1MB)
> > 
> > we are moving to a sun fire 15K machine soon and
> > then
> > the we will go to 9i 64 bit.
> > 
> > --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> > wrote:
> > > Cherie:
> > > 
> > > If you are using Oracle 9i, you can use mutliple
> > > block sizes! You still
> > > create your database with a default block size,
> > but
> > > each tablespace (except
> > > system) can have a block size different from the
> > > default.
> > > 
> > > Valid blocksizes are limited by OS, but they range
> > > from 2K to 32k. 
> > > 
> > > Check out the 9i docs for CREATE TABLESPACE for
> > more
> > > info.
> > > 
> > > Caver
> > > 
> > > -Original Message-
> > > Sent: Thursday, April 25, 2002 11:24 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > We are building a new version 9.0.1 data warehouse
> > > on Sun Solaris 2.6
> > > migrating to Solaris 2.8.  We will be using
> > striped
> > > disk that is striped
> > > using Veritas Volume Manager on EMC disk.
> > > 
> > > The datawarehouse will be about 200 Gig.   It will
> > > be written to throughout
> > > the day.
> > > 
> > > To this point, almost all of our databases have
> > been
> > > created with an 8k
> > > block size.   i'm not sure if that blocksize is
> > > optimal anymore.   With 9i,
> > > what block sizes are people using in the field
> > > nowadays for data
> > > warehouses?
> > > 
> > > Also, if you use striped disk, what stripe size
> > are
> > > you using and why?
> > > 
> > > Thanks for weighing in on this topic.
> > > 
> > > Cherie Machler
> > > Oracle DBA
> > > Gelco Information Network
> > > 
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > -- 
> > > Author: 
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- (85

RE: What block size are you using for your new 9i data warehouse?

2002-04-26 Thread Khedr, Waleed


It's NTFS cluster size (chkdsk drive: -->  will tell how many allocation
units you have).

Regards,

Waleed

-Original Message-
Sent: Friday, April 26, 2002 4:31 PM
To: Multiple recipients of list ORACLE-L
warehouse?


Can anyone tell me how to figure out the file system block size and max i/o
size of a Windows 2000 system?  My sysadmin had no clue.  (Gosh, can't
imagine why, everything's hidden behind that stupid gui)

Thanks in advance for any replies

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

> -Original Message-
> From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 12:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: What block size are you using for your new 9i data
> warehouse?
> 
> All,
> 
> Something to keep in mind regardless of whether you
> are using 9i or not. This issue becomes more relevant
> in 9i with "multiple block sizes" for different
> tablespaces. 
> 
> You always want to ensure that your DB_BLOCK_SIZE =
> File System Block Size. This is to avoid wasted I/O
> and also the case where the "read ahead algorithm" is
> triggered accidentally, when 1 Database Block results
> in multiple file system blocks being read from disk.
> 
> If your application performs range scans, there is a
> high possibility that multiple "single database block"
> read requests to a set of contiguous blocks, may
> result in the "read ahead algorithm" performing 128K
> or 256K pre-fetches, even though your application may
> have not required all 128K or 256K. 
> 
> This problem is rampant on ufs file systems where the
> default block size is 512 bytes, and with a 8K
> DB_BLOCK_SIZE, it takes 16 file system blocks to store
> 1 DB block on disk. However, even if you have advanced
> file systems and have a 1-is-to-2 ratio of DB block
> is-to FS blocks, you are still in danger of
> overloading your I/O sub-system, "under the right
> conditions".
> 
> If you are using a volume manager product such as
> Veritas, and if your version of the volume manager
> supports "dynamic file system block sizing" based on
> size of the file system or the files themselves,
> please pay close attention to that detail and make
> sure that the file system block size does not exceed
> the database block size (based on the size of the file
> system).
> 
> Best regards,
> 
> Gaja
> 
> --- Johnson Poovathummoottil <[EMAIL PROTECTED]>
> wrote:
> > We too have a data warehouse close to 500GB in size.
> > We upgraded the OS solaris 2.8 and our block size is
> > 16K. All our data and index tablespaces datafiles
> > are
> > spread across 20 files systems whose disks are on
> > EMC
> > storage. We too user veritas volume manager. File
> > systems use four 9 GB disks whaich are raid S and
> > software stripe uinit size of 256 KB.
> > 
> > reasons 
> >  16K  block size as we have many full table scan ans
> > sequential reads.
> >  256 KB stripe unit size because we have set the
> > db_file_multi_block_read_count to 64(1MB)
> > 
> > we are moving to a sun fire 15K machine soon and
> > then
> > the we will go to 9i 64 bit.
> > 
> > --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> > wrote:
> > > Cherie:
> > > 
> > > If you are using Oracle 9i, you can use mutliple
> > > block sizes! You still
> > > create your database with a default block size,
> > but
> > > each tablespace (except
> > > system) can have a block size different from the
> > > default.
> > > 
> > > Valid blocksizes are limited by OS, but they range
> > > from 2K to 32k. 
> > > 
> > > Check out the 9i docs for CREATE TABLESPACE for
> > more
> > > info.
> > > 
> > > Caver
> > > 
> > > -Original Message-
> > > Sent: Thursday, April 25, 2002 11:24 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > We are building a new version 9.0.1 data warehouse
> > > on Sun Solaris 2.6
> > > migrating to Solaris 2.8.  We will be using
> > striped
> > > disk that is striped
> > > using Veritas Volume Manager on EMC disk.
> > > 
> > > The datawarehouse will be about 200 Gig.   It will
> > > be written to throughout
> > > the day.
> > > 
> > > To this point, almost all of our databases have
> > been
> > > created with an 8k
> > > block size.   i'm not sure if that blocksize is
> > > optimal anymore.   With 9i,
> > > what block sizes are people using in the field
> > > nowadays for data
> > > warehouses?
> > > 
> > > Also, if you use striped disk, what stripe size
> > are
> > > you using and why?
> > > 
> > > Thanks for weighing in on this topic.
> > > 
> > > Cherie Machler
> > > Oracle DBA
> > > Gelco Information Network
> > > 
> > > -- 
> > > 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 Lis

RE: CPU Pegged at 100%

2002-04-26 Thread Gaja Krishna Vaidyanatha


Hi Raghu,

Can you trace a couple of your top sessions by setting
10046 and see which SQL statements are causing the
most resource consumption. This will give us an idea
of the "cause". The "effect" that you are seeing is a
very high level of CPU consumption and waits for the
cache buffers chains latches.

>From the look of it (and we need to confirm this with
the trace data), your SQL statements are probably
performing more logical I/O than what is required. The
report you shared with us, reveals 5,806 Logical I/Os
per second over a 24.42 minutes. With 1482 seconds in
this time period, the amount of logical I/O performed
is 8,604,492 blocks. How many concurrent sessions did
you have then? 

The symptom of cache buffers chains contention may
corroborate that there could be more logical I/O
performed than what is required. You need to
investigate what is causing this and whether or not
this is reasonable?

One of the potential reasons for this could be
"over-indexing" of the tables and/or "forceful use of
indexes for many queries", which may do quite well
with full-table scans. Use the 10046 trace data as
your "starting point" to take you down the right path
for your problem solving process.

Cheers,

Gaja

--- Raghu Banaji <[EMAIL PROTECTED]> wrote:
> All users waiting for latch "cache buffer chains"
>  
>  -Original Message-
> Sent: Friday, April 26, 2002 11:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> From the statspack report it shows that u have lots
> of latchfree waits which
> is event timing out
> can u see in the session_Wait which is the user and
> what latch he is waiting
> on
>  
> 
> -Original Message-
> Sent: Friday, April 26, 2002 2:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi, 
> 
> I have a customer who runs an ERP application
> written using 
> ORACLE. Almost all code is written using PL/SQL
> packages. There are about
> 80-100 users 
> at any given point of time(6 AM - 11 PM). Oracle
> version is 8.1.7.1.1
> Standard Edition. 
> All the four CPU's on their server is pegged at 100%
> for most of the time.
> This is resulting 
> in end users complaning about slow performance and
> slower log-ons to the
> application. 
> This issue has been occuring consistently for over
> 2-3 weeks now. Archive
> logging is enabled 
> and the database is normally shutdown once a week
> for cold backup. 
> 
> The Admin guys have been monitoring the server using
> Performance monitor and
> 
> find that Oracle.exe is the process consuming 99% of
> the resource. Memory
> usage is 
> constant and there is plenty of it free. Hard disk
> drives show no activity.
> A normal 
> assumption would be that disk drives would be going
> crazy with all 
> the CPU activity going on, but that does not seem to
> be the case. 
> 
> Oracle software and one PRODuction database exist on
> this server. 
> 
> Their Server configuration consists of: 
> Windows 2000 OS (Advanced Server), with 4 Pentium
> III Xeon processors (each
> 700 Mhz), 
> 4 Gb RAM and 2 disk drives on seperate disk
> controllers. Hard drives are of
> 15,000 RPM's. 
> 
> 
> MY APPROACH SO FAR: 
> 
> Step 1: 
> I started looking into this issue since last week
> and the first area I
> concentrated 
> was on finding SQL statements that were taking too
> many hits or taking too
> long to complete. 
> I was able to tune almost 10 of the top SQL
> statements last week. In most of
> the previous performance 
> issues I have been involved with this has resulted
> in huge performance gains
> and life went on. 
> In this situation, tuning these top 10 SQL's did
> result in small gains, but
> did not make 
> any difference to the CPU contention. They still
> continued to be pegged at
> 100% most of the times. 
> 
> Step 2: 
> The next step I took was to find out if there were
> hard parsing going on. As
> mentioned in a number 
> of articles here, this would cause the CPU to work
> extra harder. 
> My check resulted in only 2 SQL statement that were
> hard parsed. 
> Based on the fact that there are a number of very
> big jobs, user queries 
> and other activities that go on a daily basis,
> should I really worry about
> it ? 
> 
> 
> Step 3: 
> Next step was to increase the number of rollback
> segments from 5 to 35.
> Previously, there 
> were 5 big rollback segments. Now, there are 35
> medium sized rollback
> segments spread over 
> 2 rollback tablespaces. This step was taken
> yesterday and so far there has
> been no improvement 
> as far as CPU pegging goes. It is still pegged at
> 100% 
> 
> Step 4: 
> Certain articles in Metalink suggested that one of
> the reasons 
> that would make the CPU spin continously would be
> SMON working overtime 
> to clean up a large number of temporary extents, or
> to coalesce a large
> number of free extents. 
> This can manifest itself by SMON appearing to spin,
> consuming a high
> percentage of CPU for 
> long periods. I really dont know how to test this
> statement. PCT_INCREASE

Re: index status misleading?



Is this a partitioned index?   If so, then there is no status shown in
dba_indexes for that index.   You'll have to look for index status in
dba_ind_partitions.

Cherie


   

Gurelei

   
.com>cc:   

Sent by: Subject: Re: index status misleading? 

[EMAIL PROTECTED] 

om 

   

   

04/26/02 03:54 

PM 

Please respond 

to ORACLE-L

   

   





Mo, They are all in the same schema. Looks like
dba_index would have provided more accurate results

--- [EMAIL PROTECTED] wrote:
>
> Gene,
>
> Perhaps the indexes weren't owned by MYOWNER.
> Accidentally owned by a
> different userid?
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
>
>
>
>
> Gurelei
>
>
>  Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> .com>cc:
>
>
> Sent by: Subject:
>  index status misleading?
>
> [EMAIL PROTECTED]
>
>
> om
>
>
>
>
>
>
>
>
> 04/26/02 10:28
>
>
> AM
>
>
> Please respond
>
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
>
>
>
> Hi all:
>
> Last night I have moved couple of tables from one TS
> to another. Then I thought I'd check whether I need
> to
> rebuild any indices. I ran the following query:
>
> select distinct status from dba_objects
> where owner = 'MYOWNER'
>
> Oracle returned I row with value VALID. From that I
> concluded that there were no indices to be rebuilt.
> This morning however it turns out that there indeed
> were indices in UNUSABLE state. What I don't
> understand is why didn't I see UNUSABLE in the
> output
> of my query. Can anyone explain please?
>
> thanks
>
> Gene
>
> __
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gurelei
  INET: [EM

looking at notes in METALINK

2002-04-26 Thread Helen J Mitchell




How do I find a specific note number in METALINK?

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.


BEGIN:VCARD
VERSION:2.1
N:Mitchell;Helen
FN:Helen Mitchell
NICKNAME:Helen
TEL;HOME;VOICE:303.841.9528
TEL;CELL;VOICE:303.907.4204
ADR;HOME:;;15362 Foxglove Ct.;Parker;CO;80134-9589;USA
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:15362 Foxglove Ct.=0D=0AParker, CO 80134-9589=0D=0AUSA
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20020426T205222Z
END:VCARD

Re: What block size are you using for your new 9i data

2002-04-26 Thread Danisment Gazi Unal



Hi Gaja,
Once again I've not tested, but I've some questions about your comments
on "physically contiguous" and "Keep DB_BLOCK_SIZE = FS(or OS) Block Size"
 
"physically contiguous":
We know that disk sectors are read and then transfered to bus. There
will be a delay while transfering read sectors to bus, but before the reading
next sector. Since disk rotates, while transfering current sector to bus,
some or all of the next physically contiguous sector may be missed. If
these sectors were really physically contiguous, OS would wait for the
next rotation of the disk to read entire next physically contiguous sector.
So, OS doesn't put logically contiguous sectors as physically contiguous.
By depending on disk rotation speed and transfer speed to bus, it's scattered
to disk. An optimized disk management system finds next sector immediately
after the current sector is transfered to bus. This may be done by putting
gaps between logically contiguous sectors. These gaps may be used for other
data. Of course, there may be different implementation, but there will
be always a delay to bus and there will be always a miss to next sector(s).
I've not tested but If Oracle sequential data is stored as physically
contiguous, it's a real problem for IO subsystem. I guess it's logically
contiguous.
"Keep DB_BLOCK_SIZE = FS(or OS) Block Size":
As I remember(???), Oracle uses bytes as parameters in IO system calls.
And, let's say we created a db which has DB_BLOCK_SIZE = FS/OS block size.
is it guarantee that each new Oracle block will be written to new OS block
? Every file is identified by a file handle in OS level, and also there
should be a specific value in a register which points to last offset of
the file. I mean, next insert may be appended to current OS block if there
is free space, and new block(s) may be allocated for the remainings. Here
is a sample:
- OS block size = db block size = 2k
- 1K of the last OS block is free and we would like to insert 4K.
1K is appended to last OS block, a new OS block is allocated for the
remaining 2K, another new OS block is allocated for the remaining 1K. In
this sample, 4K is scattered to 3 blocks, not 2 blocks.
I think this will not be a problem for Oracle. Because Oracle uses its
own format. The check between block header and tail will prevent scattered
data from any corruptions in physically different blocks.
 
I've not tested them, I may be wrong. Looking forward to hearing a confirmation
 
regards
 
 
 
 
Gaja Krishna Vaidyanatha wrote:
Hi Bill & list,
The main function of a "read ahead algorithm" is to
anticipate the nature of I/O requests on a given track
of a disk's platter and see whether it is beneficial
to "pre-fetch" some of the blocks, so that subsequent
requests can be serviced from the either the
controller's or the file system's cache, without
having to "go to disk" multiple times.
The OS (or the sub-system) should normally return only
the same number of blocks as requested. But, if there
are multiple "read requests" from Oracle that are
physically contiguous on disk and they also occur in a
rapid succession, the OS or the I/O sub-system (as the
case may be), "second guesses" the requestor's intent
and assumes that more of the other blocks in the same
track will also be requested, in the near future.
For a real "sequential scan", like in a full-table
scan or an index fast-full scan, this is beneficial.
But in the case of a range scan where only "a few
contiguous blocks" are requested, pre-fetching 128K or
256K worth of data is wasteful use of a system's I/O
resources. This is because, not all the blocks that is
pre-fetched will be consumed.
The issue of an 8K DB_BLOCK_SIZE with say a 512-byte
File System (or OS) Block Size, is that there is a
1-is-to-16 ratio between logical and physical blocks.
So, for example if 4 Oracle blocks are requested, they
translate into 64 FS (or OS) blocks. If these blocks
are contiguous (and chances are good that leaf blocks
in an index can be contiguous ), it becomes an "ideal
condition" for the read-ahead algorithm to engage. So
instead of servicing 32K of data, the sub-system
retrieves 128K or 256K worth of data.
And, even if you have a 1-is-to-2 ratio between
logical and physical blocks (DB_BLOCK_SIZE is 8K and
FS Block Size is 4K), under the "right conditions",
the read-ahead algorithm will engage and pre-fetch in
a wasteful manner. So the bottom line is follows:
Keep DB_BLOCK_SIZE = FS(or OS) Block Size
This way, if Oracle requests for a few blocks in a
track, the OS does not pre-fetch all of the blocks in
the track. As mentioned before, in case of a "real
sequential scan", the pre-fetch comes in goodstead.
Hope that helps,
Gaja
--- Bill Buchan <[EMAIL PROTECTED]> wrote:
>
> Sorry, I'm a bit non-clued up on this "read ahead
> algorithm".  Could I be a
> pain and ask for more details?  Does the OS return
> one OS block if exactly
> one is requested, but if 2 are requested it thinks
> "aha! sequential scan"
> and goes and get

Re: index status misleading?

2002-04-26 Thread Gurelei


Cherie,

This is a non-partitined index, so it should be in the
dba_indexes.

--- [EMAIL PROTECTED] wrote:
> 
> Is this a partitioned index?   If so, then there is
> no status shown in
> dba_indexes for that index.   You'll have to look
> for index status in
> dba_ind_partitions.
> 
> Cherie
> 
> 
> 
> 
>  
> Gurelei 
> 
>  
>  Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>   
> .com>cc:
> 
>  
> Sent by: Subject:   
>  Re: index status misleading?   
>  
> [EMAIL PROTECTED]  
> 
>  
> om  
> 
>  
> 
> 
>  
> 
> 
>  
> 04/26/02 03:54  
> 
>  
> PM  
> 
>  
> Please respond  
> 
>  
> to ORACLE-L 
> 
>  
> 
> 
>  
> 
> 
>  
> 
> 
> 
> 
> Mo, They are all in the same schema. Looks like
> dba_index would have provided more accurate results
> 
> --- [EMAIL PROTECTED] wrote:
> >
> > Gene,
> >
> > Perhaps the indexes weren't owned by MYOWNER.
> > Accidentally owned by a
> > different userid?
> >
> > Cherie Machler
> > Oracle DBA
> > Gelco Information Network
> >
> >
> >
> >
> >
> > Gurelei
> >
> >
> >  > Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > .com>cc:
> >
> >
> > Sent by: Subject:
> >  index status misleading?
> >
> > [EMAIL PROTECTED]
> >
> >
> > om
> >
> >
> >
> >
> >
> >
> >
> >
> > 04/26/02 10:28
> >
> >
> > AM
> >
> >
> > Please respond
> >
> >
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi all:
> >
> > Last night I have moved couple of tables from one
> TS
> > to another. Then I thought I'd check whether I
> need
> > to
> > rebuild any indices. I ran the following query:
> >
> > select distinct status from dba_objects
> > where owner = 'MYOWNER'
> >
> > Oracle returned I row with value VALID. From that
> I
> > concluded that there were no indices to be
> rebuilt.
> > This morning however it turns out that there
> indeed
> > were indices in UNUSABLE state. What I don't
> > understand is why didn't I see UNUSABLE in the
> > output
> > of my query. Can anyone explain please?
> >
> > thanks
> >
> > Gene
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Games - play chess, backgammon, pool and
> more
> > http://games.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Gurelei
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

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

RE: Unix - Writing stderr to a file and stdout


Sorry, I misread it.

Just change it around a little:

find . -print | xargs grep "hoser"  2>&1 | tee /tmp/test.txt

try 'man -k output'

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/26/2002 12:04 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Unix - Writing stderr to a file and stdout


Hi,

I think I did not explain my request properly..let me try again.

Is it possible to write stderr to stdout and to another file
simultaneously..?

For Ex:

ls -l > outfile 2>&1 will get me command output and diagnostics info in 
the
same file which is outfile.

However, I am trying to get the diagnostics info into outfile as well as
into another file (say errfile). Would that be possible? I was not able to
do it with tee either..

Thanks

Mohammed Ahsanuddin
Oracle DBA
Verizon Wireless
Work : 845 365 7203
Pager : 800 366 2337 pin : 16040



-Original Message-
Sent: Friday, April 26, 2002 1:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


But of course

find . -print | xargs grep "hoser" 

This will generate errors on directories

Make the errors disappear:

 find . -print | xargs grep "hoser"  2>/dev/null

Now send the standard output to a file.  Make sure the
file is outside the directory structure you are searching.

 find . -print | xargs grep "hoser"  2>/dev/null 1>/tmp/hoser.txt

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/26/2002 11:30 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc: 
Subject:Unix - Writing stderr to a file and stdout


Hi,

Is it possible to write stderr to stdout and to another file
simultaneously..?

Thanks in advance.

Mohammed Ahsanuddin
Oracle 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: 
  INET: [EMAIL PROTECTED]

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

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


Click on 'Advanced Search'

You will see a 'Note ID' radio button.

Jared





"Helen J Mitchell" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/26/2002 02:48 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:looking at notes in METALINK


How do I find a specific note number in METALINK?


-- 
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: What block size are you using for your new 9i data warehouse?


Lisa,

You can use this script from Steve Adams' site to determine the
maximum IO size.

http://www.ixora.com.au/scripts/io_opt.htm#multiblock_read_test

Since it is Windoze though, the sed command will fail.

No problem, just open up the trace file in notepad and look for
the value of the p3 parameter near the end of the file.  This will
be in 512 byte blocks.

Jared






"Koivu, Lisa" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/26/2002 01:30 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: What block size are you using for your new 9i data 
warehouse?


Can anyone tell me how to figure out the file system block size and max 
i/o
size of a Windows 2000 system?  My sysadmin had no clue.  (Gosh, can't
imagine why, everything's hidden behind that stupid gui)

Thanks in advance for any replies

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

> -Original Message-
> From:  Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
> Sent:  Friday, April 26, 2002 12:49 PM
> To:Multiple recipients of list ORACLE-L
> Subject:   RE: What block size are you using for your new 9i 
data
> warehouse?
> 
> All,
> 
> Something to keep in mind regardless of whether you
> are using 9i or not. This issue becomes more relevant
> in 9i with "multiple block sizes" for different
> tablespaces. 
> 
> You always want to ensure that your DB_BLOCK_SIZE =
> File System Block Size. This is to avoid wasted I/O
> and also the case where the "read ahead algorithm" is
> triggered accidentally, when 1 Database Block results
> in multiple file system blocks being read from disk.
> 
> If your application performs range scans, there is a
> high possibility that multiple "single database block"
> read requests to a set of contiguous blocks, may
> result in the "read ahead algorithm" performing 128K
> or 256K pre-fetches, even though your application may
> have not required all 128K or 256K. 
> 
> This problem is rampant on ufs file systems where the
> default block size is 512 bytes, and with a 8K
> DB_BLOCK_SIZE, it takes 16 file system blocks to store
> 1 DB block on disk. However, even if you have advanced
> file systems and have a 1-is-to-2 ratio of DB block
> is-to FS blocks, you are still in danger of
> overloading your I/O sub-system, "under the right
> conditions".
> 
> If you are using a volume manager product such as
> Veritas, and if your version of the volume manager
> supports "dynamic file system block sizing" based on
> size of the file system or the files themselves,
> please pay close attention to that detail and make
> sure that the file system block size does not exceed
> the database block size (based on the size of the file
> system).
> 
> Best regards,
> 
> Gaja
> 
> --- Johnson Poovathummoottil <[EMAIL PROTECTED]>
> wrote:
> > We too have a data warehouse close to 500GB in size.
> > We upgraded the OS solaris 2.8 and our block size is
> > 16K. All our data and index tablespaces datafiles
> > are
> > spread across 20 files systems whose disks are on
> > EMC
> > storage. We too user veritas volume manager. File
> > systems use four 9 GB disks whaich are raid S and
> > software stripe uinit size of 256 KB.
> > 
> > reasons 
> >  16K  block size as we have many full table scan ans
> > sequential reads.
> >  256 KB stripe unit size because we have set the
> > db_file_multi_block_read_count to 64(1MB)
> > 
> > we are moving to a sun fire 15K machine soon and
> > then
> > the we will go to 9i 64 bit.
> > 
> > --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> > wrote:
> > > Cherie:
> > > 
> > > If you are using Oracle 9i, you can use mutliple
> > > block sizes! You still
> > > create your database with a default block size,
> > but
> > > each tablespace (except
> > > system) can have a block size different from the
> > > default.
> > > 
> > > Valid blocksizes are limited by OS, but they range
> > > from 2K to 32k. 
> > > 
> > > Check out the 9i docs for CREATE TABLESPACE for
> > more
> > > info.
> > > 
> > > Caver
> > > 
> > > -Original Message-
> > > Sent: Thursday, April 25, 2002 11:24 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > We are building a new version 9.0.1 data warehouse
> > > on Sun Solaris 2.6
> > > migrating to Solaris 2.8.  We will be using
> > striped
> > > disk that is striped
> > > using Veritas Volume Manager on EMC disk.
> > > 
> > > The datawarehouse will be about 200 Gig.   It will
> > > be written to throughout
> > > the day.
> > > 
> > > To this point, almost all of our databases have
> > been
> > > created with an 8k
> > > block size.   i'm not sure if that blocksize is
> > > optimal anymore.   With 9i,
> > > what block sizes are people using in the field
> > > nowadays for data
> > > warehouses?
> > > 
> > > Also, if you use striped disk, what stripe size

RE: CPU Pegged at 100%