tnslistener brute force trigger?

2002-11-14 Thread Dana . Mueller
all,

i have been attempting to find a solution to set a trigger / alarm mechanism
on the listener for brute-force attempts.  we're trying to get something
useful logged so we can forward it to an ISD system or what not.

ideas?  i have done a bit of research and found nothing useful so far.

am i missing something?

thanks in advance.

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

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



Re: Autostarting databases

2002-11-14 Thread Yechiel Adar
Hi Bob

I took a look at the database service one of our servers.

service properties:
startup program: d:\oracle\ora816\bin\oracle.exe abcd (the sid of the
database).
startup mode = automatic.
logon as local system account.
allow service to interact with desktop.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 9:52 PM


Check what SP is installed on the server.
This is a common problem with Y2K SP1.
Upgrade to SP2.

This is windows 2k server service pack 3

Have a look at the strtsid.cmd script which is used for
starting the instance/DB inside %ORACLE_HOME%\DATABASE.

That must be a personal custom script.
 Ive searched all my nt and win2k servers and only have a TRCFMT.cmd
 which looks like a file to format  trace files


 Let's try the simple solution first.  How about using the
 Services utility in Control Panel to check the service for
 startup =AUTO.

Yes its on auto

 Then specify the parameters that are to be
 used for startup, like pfile=xx.

Your talking about the properties window of the service?
 Where it says You can specify the parameters that apply when you start
the service from here

If so that will start the database but the setting pfile=x does not
retain. So, it seems like you can only pass that parameter,  the
pfile=xxx once

 Specify the userid
 that is supposed to start the database, preferably not the
 Administrator userid, but Oracle or a derivative of it.

So your asying I need a win2k account for the database user? Ive never
heard of that nor have seen parameters in any other configurations.

 This method has been known to work.

 RWB

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

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

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

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



error code 3113

2002-11-14 Thread Satyendra K Khare
3113 end-of-file on communication channel

This is a very common error and encounter many times, but generally down
the databae and up again solve the problem, but this time i m not able
to handle it by doing that...
What is the remady and..
 WHAT ARE THE CAUSE FOR THIS ERROR ?? Why it happened..??

Thanks and regard..
Satyendra ..

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

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



Monitoring Database by Unix

2002-11-14 Thread Eriovaldo Andrietta

Friends :

Do you have scripts ready for :

1.) to see usage memory by database on unix ?
2.) to see usage memory by schema inside database?
3.) to see usage I/O by session inside database ?
4.) to find out how long a session is not being used, and treats it as a non
used or lost session , that is using memory unnecessary
5) to see the load of the machine
6.) explanation about itens showed in the top comand ? what can i look at
this comand ?
 what is the main item that dba needs to see ?

In general , i would like to monitor the machine with database server .

Regards

Eriovaldo



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

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



RE: Move ALL Data from 1 Database into Another

2002-11-14 Thread VIVEK_SHARMA

Would there be any Performance Overhead in the Newly ATTACHED Oracle 8i Database 
after moving it to production ?

NOTE - Database Size 100 GB with 800 Concurrent Users Currently 

Are there any Other Pre-requisites / TO DOs to Allow Detaching of Application 
Tablespaces
from the Previously Migrated Oracle 8i Database to the NEWLY Created 8i Database ?

Sorry for the Ignorance
 

-Original Message-
Sent: Thursday, November 14, 2002 12:54 PM
To: VIVEK_SHARMA


Vivek,
This transportable TBS option come with 8i onwards, and once you have 
migrated to 8i you can detach application tbs and attached these to new 8i 
database.

Thanks  Regards,
Vipin Jain

-Original Message-
From:   VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 14, 2002 12:41 PM
To: LazyDBA.com Discussion
Subject:RE: Move ALL Data from 1 Database into Another

Forgive the previous incomplete post.

Hi Ankur

QS. After Migrating the Oracle 7 Database to 8i , Using Transportable 
Tablespaces
Can one Simply use DETACH the Application Tablespaces (OTHER Than SYSTEM)  
Attach them
to the Newly Created 8i Database ?

Thanks Indeed

Hi Jeremiah

Some of the Data Dictionary Objects are Corrupted in the Live Production 
Oracle 7 Database
 Even after Migration to Oracle 8.1.7.4 the Corruption Still persists .

Nevertheless I missed Some of your Points .

MY QUESTIONS(QS.) TO SOME OF YOUR POINTS ARE IN CAPITALS BELOW :-

Thanks indeed

-Original Message-
Sent: Thursday, November 14, 2002 5:14 AM
To: Multiple recipients of list ORACLE-L


I don't like any of the suggestions so far, because they take more
time than necessary.  DB links do ONE ROUND TRIP for every row
fetched!  That is not efficient.  Export is a nightmare of potential
failures. I think you can devise the best solution by just copying the
database files.

Try this idea on for size:

0. Make sure both versions of Oracle are installed on the host.

1. Make a hot backup or RMAN copy of the database, and start it under
a different SID.

QS. CHANGING SID WOULD WARRANT A RESETLOGS . IS THAT CORRECT ?


2. Upgrade the copy to 8.1.7, but keep COMPATIBLE at 7.3.4.

3. Roll the copy forward to the current time using the logs generated
by the old 7.3.4 instance, which is still in use.

QS. IS IT POSSIBLE TO APPLY REDO LOGS GENERATED FROM A DIFFERENT SID TO A 
NEW SID ?

4. Shut down the old instance, apply the last log to the new one, and
restart the new one with COMPATIBLE = 8.1.7.

5. Replace the listener with an 8.1.7 listener pointing at the new
instance.

This method gives you near zero downtime between kicking the users off
the old database and letting them into the new one.

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


Oracle documentation is here: 
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these 
terms:http://www.lazydba.com/legal.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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



Re: Move ALL Data from 1 Database into Another

2002-11-14 Thread Dale
Hi Jeremiah

 I don't like any of the suggestions so far, because they take more
 time than necessary.  DB links do ONE ROUND TRIP for every row
 fetched!  That is not efficient.  Export is a nightmare of potential
 failures. I think you can devise the best solution by just copying the
 database files.

Are you sure about the one round trip thing. I may be mistaken but I must
admit that has not been my experience. Are you thinking of occasions when
you use a remote table (accessible via a DBLink) in a local join? In such
cases the optimizer might set up the plan to get the remote rows
individually rather than doing unproductive remote full or range scans. One
would anticipate that a query like INSERT into localtable (select * from
remotetable@link) would pull things over in a stream. OCI certainly streams
query results like that - I'm not saying that DBLinks are based on OCI -
just that there is precedent for this in at least one Oracle networking
layer.

Kind regards
Dale

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

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



Re: How-To or Good Practices on Code Releases

2002-11-14 Thread Yechiel Adar
You do not have to reinvent the wheel.
If you want to check the scripts just do the following:
1) Get the DBATool from DataBee www.databee.com
2) Do export no data from the target system.
3) Read the export into the DBATool
4) Create DDL for the schema
5) Run the DDL and create the schema in test db.
6) Run your script against the empty schema.

All syntax error and logical error will show up.
It will not check for data dependent error, like adding unique constrain to
a column with data that have multiple occurrences of the same value but it
will save you a lot of time and development.

Yechiel Adar (who does not have any hidden/unhidden connections to DataBee)
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 9:23 PM


 one of the things I'm experimenting with right now, based on a request
from
 clients, is a pre-run analysis script to report on likely errors that the
 actual script would generate.  this gives me a chance to trap the silly
 errors and continue (e.g., modify column to NOT NULL that is already NOT
 NULL, drop a column that's not there, etc.) and provide feedback to the
 client on the more serious errors that will need their attention - e.g.,
 changing a column datatype or reducing a column_size, where the existing
 data won't work; creating a FK, where there are missing parent records;
 etc.)  This analysis script tests for the existance of new columns or data
 that are to be added, checks max(lengths) of fields that need to be
 shortened, etc.  The client can then execute the analysis script, evaluate
 the output, and decide on a course of action.

 As others have said, though, this REALLY SHOULD first be run in a UAT,
 staging, or other test env first - if for no other reason than a sanity
and
 syntax check.

 My objective with this is to PREVENT the need to roll back the script,
save
 for unexpected errors (whereby something significant changed between the
 time the analysis script was run and the actual delta) and *critical*
errors
 (crash, out of disk space, etc.) . . . in which case I would revert back
to
 the backup they should have taken just before the script was executed

 HTH

 bill

 -Original Message-
 Sent: Wednesday, November 13, 2002 1:20 PM
 To: Multiple recipients of list ORACLE-L



 As an example, something that yours truly was involved with, and still
have
 the scars to show for it.  A migration from a lower version of Oracle, to
a
 higher version, on a completely new server.  The scripts ran fine, and the
 implementation plan worked fine. However, the application started
reporting
 intermittent connection problems. This was a web application, and it took
 the developers a day to realize that the one of the components in the
 application was not fully certified with Oracle 8i. Also, there were
memory
 leak issues with that version of Oracle 8i. Whereby we needed to fall back
 to the old server, with the new data. The rollback strategy in the
 implementation plan was a one liner, to fall back to the old server. This
 was good for an immediate fallback after the implementation. Had to go the
 export import way, which had some additional outage for hours.

 So, the next time this was implemented, we had a quick rollback strategy
to
 rollback after n number of days. If memory serves me right, I think we had
 a standby database created on the old server with the new release, and a
 downgrade plan. This was tested and approved by the developers and the QA
 team, though I never had to use it. Since then, I tend to be paranoid
about
 any changes to production databases. You live and learn.

 Regards
 Raj






 DENNIS WILLIAMS

 DWILLIAMS@LIFETo: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED]
 TOUCH.COM cc:

 Sent by:   Subject: RE: How-To or Good
 Practices on Code Releases
 [EMAIL PROTECTED]

 m





 November 13,

 2002 12:15 PM

 Please respond

 to ORACLE-L









 Raj - Can you provide more details? Is this an automated script, or just a
 line on the form that says that you have some idea of how to rollback the
 change in case anything goes wrong?

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


 -Original Message-
 Sent: Wednesday, November 13, 2002 10:54 AM
 To: Multiple recipients of list ORACLE-L



 And have a similarly tested and signed off rollback strategy in place. An
 immediate rollback, as well as a rollback strategy after n number of days.

 Raj





   One attachment (0k)


 Reginald W.

 Bailey/JPMCHATo: Multiple recipients of
 list
 ORACLE-L [EMAIL PROTECTED]
 SE@CHASE cc:

 Sent by:

Re: tnslistener brute force trigger?

2002-11-14 Thread Stephane Faroult
[EMAIL PROTECTED] wrote:
 
 all,
 
 i have been attempting to find a solution to set a trigger / alarm mechanism
 on the listener for brute-force attempts.  we're trying to get something
 useful logged so we can forward it to an ISD system or what not.
 
 ideas?  i have done a bit of research and found nothing useful so far.
 
 am i missing something?
 
 thanks in advance.
 
 dana mueller
 guardent, inc.
 [EMAIL PROTECTED]
 --

I don't understand what you mean by 'brute force attempts'. But have you
thought about checking the listener log file and, if this is not enough,
putting it at some moderate kind of trace level and checking the .trc ?
-- 
Regards,

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

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



RE: Oracle 10i features

2002-11-14 Thread Hately, Mike (NESL-IT)
9iAS R2 is a terrible install. A complicated process further confused by
poor instructions.

Mike

-Original Message-
Sent: Wednesday, November 13, 2002 7:33 PM
To: Multiple recipients of list ORACLE-L


No, installing 9iAS is a 250 mph breeze. One definition of a tornado is
a very strong breeze.
-Original Message-
Sent: Wednesday, November 13, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L


Only if they make installing 9iAs a breeze ... I have heard stories that
9iAS installation is not a picnic ... 
Raj 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

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



RE: Solaris vs Windows 2000

2002-11-14 Thread Mark Leith
This blind hate and resentment towards Windows products it getting a little
tiresome, have you guys even TRIED using Win2K?

How about some constructive criticism?

Don't get me wrong - I sit on the fence, and will defend both Unix AND
Windows when I feel it's warranted. Win2K WILL be able to do the job that
Jared wants it to do (we've seen and worked with the largest SAP database on
NT in Europe)..

And, Lyndon, I think we've got the message now :)

Mark (Running XP Pro, Win2K Pro, and RH 8 at home) Leith

-Original Message-
[EMAIL PROTECTED]
Sent: 14 November 2002 05:34
To: Multiple recipients of list ORACLE-L



Everything good comes at a price. And never trust any system, where to shut
down, you got to click on start ;-)

Regards
Raj





Steve Perry
sperry@sprynTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
et.com  cc:
Sent by: Subject: Re: Solaris vs Windows
2000
root@fatcity.
com


November 13,
2002 09:08 PM
Please
respond to
ORACLE-L






Thanks, but that wouldn't convince him. He'd say it wasn't MS's fault. It
was our for not securing it :(
When you want to believe something, you don't let facts get in the way :)

Steve

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 11:54 AM


 Steve,

 Get your Boss to read the following. Jared - one more arrow in your
quiver!

  --6 November 2002  Bermudan Bank Site Defaced
 Hackers may have exploited a Microsoft operating system vulnerability
 to deface two Bermudan websites, including that of the Bank of
 Butterfield.  Bank officials say no customer data was compromised.
 The site hosts are recommending that their clients who work with data
 that needs to be protected switch to their Unix based hosting platform.

http://www.bermudasun.bm/cgi-local/edpull.pl?cat=01Newsord=03ed=2002-11-06

 [Editor's Note Schultz]: The recommendation in this news item should
 add a considerable amount of fuel to the whose operating system is
 most secure debate.]

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

 What would you see if you were allowed to look back at your life at the
end
 of your journey in this earth?

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


  -Original Message-
  From: Steve Perry [mailto:sperry;sprynet.com]
  Sent: Wednesday, November 13, 2002 7:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: Solaris vs Windows 2000
 
 
  Jared,
 
  Here's my recollection of a losing battle. I hope this helps.
 
  I used to work on Unix (AIX and Solaris) and can only think
  about the good
  ol' days...
  Now, I work on Comcrap Servers (i mean HP) running Microslop
  NT and 2000.
  We have tons of them :)
  I asked my boss why they are using Windows instead of Unix.
  I gave him all the arguments about scalability, secure... and
  not having to
  do the weekly reboots and he listened patiently.
  He finally said How much will a Sun server cost?. I said
  I'd have to check
  on it, but he said We are running a 500 gig SAP system on a
  $5K compaq with
  6 other compaq app servers that cost less than that. He asked
  what the Unix
  would cost. I started to answer that the hardware isn't the
  only cost and we
  have an EMC disk array behind it, but he stopped me and said
  it doesn't
  matter. He walks into the CIO's office and asks for a $70K
  dollar Solaris
  box and he gets booted out of the office. He can nickle and
  dime him for $5K
  servers...
  I pointed out that we had to spend a million dollars on a EMC
  Symmetrix with
  Clarion and he said exactly. We spend the big money on the
  I/O subsystem
  for a bunch of servers and we can buy all the cheap up front
  hardware we
  want. Next, he pointed out that we'd have to hire a Unix
  admin and that
  would cost money. Everybody knows how to administer Windows
  he says. I
  said pressing control-alt-del isn't administration. He also
  said that with
  EMC behind the scenes we don't have to worry about
  distributing the I/O. EMC
  will take care of it for us. I said that look at all the
  wasted time because
  we have to come in weekends (at least once a month) and
  install Win patches
  that take our systems down. That doesn't cost us anything
  because you're
  not paid hourly and that only impacts a few people my boss
  says. What
  about all the time wasted finding tools/scripts so we can do
  the same type
  of monitoring/troubleshooting that you can on Unix, I ask.
  You only need
  that once in a while and we can reboot the system if can't
  determine the
  problem he laughs. His last argument was that all the
  developers want the
  MS platform so 

Configuring disks on a Windows 2000 server?

2002-11-14 Thread Paul Vincent
Hi all,

A 3rd-party software vendor is coming in to install their application on a
new Windows 2000 server. This application uses Oracle, so they'll also be
installing Oracle 8.1.7 as part of their setup session. However, they've
sent our server/hardware guys the following, specifying how they want the
disks configuring on the server:

- - - - -
As to the RAID recommendations the issue is that Oracle do not support
installations where the redo logs are on any sort of a stripped partition.
My recommendation would be to create a mirror pair out of two of the disks.
This can be partitioned for the system and the redo logs. The remainder of
the disks can be RAID 5. Note that the RAID 5 array is where the actual
database and archive logs are stored. In theory If you lose both disks on
the mirror you would still have enough information on the RAID 5 partition
to save the database.
- - - - -

Now, disk configuration's one of my weakest spots, but I have the following
two questions about their instructions:

1. Is their point about Oracle not supporting redo logs on striped
partitions true, or are they talking rubbish? All our UNIX servers with
Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it
different for Windows servers? I must say I'd never heard of this
restriction before, but I'm willing to be enlightened! Anybody?

2. They're recommending RAID 5 for a transaction-heavy application server,
here. Surely that's wrong? I thought I understood that RAID 5 was great for
file servers but lousy for servers running transactio-heavy business
applications. What's the view of you guys on this?

Please give me your views, I know we have some very experienced people on
this list!

Best regards,

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

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



Re: Configuring disks on a Windows 2000 server?

2002-11-14 Thread Yechiel Adar
Hello Paul

ALL our oracle servers are windows NT/2000 with raid 5 arrays for all the
files.

1) The point that Oracle does not support online redo logs on stripped
partition seems wrong to me.
2) There was a discussion on the list a while ago about the write speed
times between raid 5 and raid 0+1.

Anyway, since raid 5 are usually implemented with a big controller cache
(backed up by a battery) your database writes to the cache and you get
reasonable response time. We have a heavy online application with about 50
users that runs OK on windows NT with 2 processor and 5 disks raid 5 array.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 12:03 PM


 Hi all,

 A 3rd-party software vendor is coming in to install their application on a
 new Windows 2000 server. This application uses Oracle, so they'll also be
 installing Oracle 8.1.7 as part of their setup session. However, they've
 sent our server/hardware guys the following, specifying how they want the
 disks configuring on the server:

 - - - - -
 As to the RAID recommendations the issue is that Oracle do not support
 installations where the redo logs are on any sort of a stripped partition.
 My recommendation would be to create a mirror pair out of two of the
disks.
 This can be partitioned for the system and the redo logs. The remainder of
 the disks can be RAID 5. Note that the RAID 5 array is where the actual
 database and archive logs are stored. In theory If you lose both disks on
 the mirror you would still have enough information on the RAID 5 partition
 to save the database.
 - - - - -

 Now, disk configuration's one of my weakest spots, but I have the
following
 two questions about their instructions:

 1. Is their point about Oracle not supporting redo logs on striped
 partitions true, or are they talking rubbish? All our UNIX servers with
 Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is
it
 different for Windows servers? I must say I'd never heard of this
 restriction before, but I'm willing to be enlightened! Anybody?

 2. They're recommending RAID 5 for a transaction-heavy application server,
 here. Surely that's wrong? I thought I understood that RAID 5 was great
for
 file servers but lousy for servers running transactio-heavy business
 applications. What's the view of you guys on this?

 Please give me your views, I know we have some very experienced people on
 this list!

 Best regards,

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

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

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

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



Re: RE: How-To or Good Practices on Code Releases

2002-11-14 Thread chao_ping
Rajesh.Rao,
I have the same experience. Developers directly connected to 
production database and added a column with default table on a huge table. The whole 
table is locked for 1 hour and other transaction failed.
Add a column with non default value and then later add default value 
for it can be done in 1 second.
Developers do not Know how oracle do it and just go on. New 
application going online without volume testing, getting online and as a production 
dba,i search for the bad sql and trace it out and send it back to developer!
That is why many project fail, the app is designed and developed 
without the attendence of a guy who really knows oracle.





Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)

=== 2002-11-13 12:06:00 ,you wrote£º===

I also have been burnt by an simple alter table add column default string
script. A pretty simple script. The developers tested it, the QA team too
approved it. Was expected to run in a matter of minutes. The problem was
the data in production was 100 times over. Missed out on volume testing.
Took 2 cuppas and 3 smokes before it was done.

Raj





Magaliff, Bill
Bill.Magaliff@lenTo: Multiple recipients of list 
ORACLE-L ORACLE-L@fatcitS

= = = = = = = = = = = = = = = = = = = =




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

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



Re: Move ALL Data from 1 Database into Another

2002-11-14 Thread Jeremiah Wilton
On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote:

 Are you sure about the one round trip thing.

Turns out you are right about not doing a single round-trip per row.
My information was either outdated or apocryphal:

SQL select value from v$sesstat ss, v$statname sn where sid = 31 and
ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips
to/from dblink';

 VALUE
--
 0

SQL insert into foobar (select * from foobar@baz);

1660073 rows created.

SQL select value from v$sesstat ss, v$statname sn where sid = 31 and
ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips
to/from dblink';

 VALUE
--
  1925

(Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production)

However, using DB links can never be as efficient as a parallel
datafile copy followed by a near-zero downtime switchover.

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


 Hi Jeremiah
 
 Are you sure about the one round trip thing. I may be mistaken but I must
 admit that has not been my experience. Are you thinking of occasions when
 you use a remote table (accessible via a DBLink) in a local join? In such
 cases the optimizer might set up the plan to get the remote rows
 individually rather than doing unproductive remote full or range scans. One
 would anticipate that a query like INSERT into localtable (select * from
 remotetable@link) would pull things over in a stream. OCI certainly streams
 query results like that - I'm not saying that DBLinks are based on OCI -
 just that there is precedent for this in at least one Oracle networking
 layer.

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

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



Installing 8.1.7 on a machine with an existing 9.0.1 installation

2002-11-14 Thread Stefan Jahnke
Hi everybody

I'm about to throw my laptop out of the window (I'm on Win2k). I have an
existing 9.0.1 installation (server and developer tools like designer and
jedevelop). That works. Now I need to install an additional 8.1.7. If I run
the installer from 8.1.7, it tells me that the component oracle.swd.jre
1.1.8.10.0 is missing while checking the dependencies (after you decide the
installation type, before the list of available products/options is
displayed). Checking the components in the stage directory, it shows that it
is really missing.
Next try was to install 8.1.7 using the 9.0.1 installer. Installation works,
but hangs at the end ... great. Next try was to take the oracle.swd.jre
1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7
stage and to create the property files. No success.
Any ideas, or do I have to remove everything, then install 8.1.7 first,
folowed by 9.0.1 and the developer tools. That would be very diappointing.

Regards,
Stefan



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

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



listener.log parsing utility

2002-11-14 Thread Boivin, Patrice J
Is there such a utility on the 'net somewhere?

I would like to parse the log automatically, and get summaries of connection
attempts, rejected connections, errors (if any), who connects, for how long.

I have auditing set up in our db and can get some of that info, but I would
like to monitor the contents of listener.log as well.

Just curious.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]




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

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



Re: Installing 8.1.7 on a machine with an existing 9.0.1 installation

2002-11-14 Thread antonio . belloni

Hi,

There´s a bug about your problem reported on Metalink.  According to the
bug report , you cannot install any 8i product on NT/W2K after 9i been
already installed. To solve the problem you can use Universal Installer
2.0.1 , found at the Oracle 9.0.1 bundle.

If you have access to Metalink check notes 172096.1 , 183939.1 and bug
report 2019978.

HIH,
Antonio Belloni



   

  Stefan Jahnke

  Stefan.Jahnke@boTo:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  v.decc: 

  Sent by: Subject:  Installing 8.1.7 on a machine 
with an existing 9.0.1 installation 
  [EMAIL PROTECTED] 

   

   

  14/11/2002 08:13 

  Please respond to

  ORACLE-L 

   

   





Hi everybody

I'm about to throw my laptop out of the window (I'm on Win2k). I have an
existing 9.0.1 installation (server and developer tools like designer and
jedevelop). That works. Now I need to install an additional 8.1.7. If I run
the installer from 8.1.7, it tells me that the component oracle.swd.jre
1.1.8.10.0 is missing while checking the dependencies (after you decide the
installation type, before the list of available products/options is
displayed). Checking the components in the stage directory, it shows that
it
is really missing.
Next try was to install 8.1.7 using the 9.0.1 installer. Installation
works,
but hangs at the end ... great. Next try was to take the oracle.swd.jre
1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7
stage and to create the property files. No success.
Any ideas, or do I have to remove everything, then install 8.1.7 first,
folowed by 9.0.1 and the developer tools. That would be very diappointing.

Regards,
Stefan




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

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





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

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



RE: Installing 8.1.7 on a machine with an existing 9.0.1 installa

2002-11-14 Thread Jack van Zanen
Hi,

I copied the entire CD to disk (so that I can always install additional
features as needed) and installed using the 9.0.1 installer w/o problems on
W2K

off the top of my head:

If you have a Pentium 4 there are issues to resolve with the java
environment and one of them was to
copy the entire cd to disk rename symcjit.dll to symcjit.old and start using
the installation from the install win32 directory. I renamed the files and
used the 9i installer instead and that worked also

Jack


-Original Message-
Sent: donderdag 14 november 2002 12:14
To: Multiple recipients of list ORACLE-L
installation


Hi everybody

I'm about to throw my laptop out of the window (I'm on Win2k). I have an
existing 9.0.1 installation (server and developer tools like designer and
jedevelop). That works. Now I need to install an additional 8.1.7. If I run
the installer from 8.1.7, it tells me that the component oracle.swd.jre
1.1.8.10.0 is missing while checking the dependencies (after you decide the
installation type, before the list of available products/options is
displayed). Checking the components in the stage directory, it shows that it
is really missing.
Next try was to install 8.1.7 using the 9.0.1 installer. Installation works,
but hangs at the end ... great. Next try was to take the oracle.swd.jre
1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7
stage and to create the property files. No success.
Any ideas, or do I have to remove everything, then install 8.1.7 first,
folowed by 9.0.1 and the developer tools. That would be very diappointing.

Regards,
Stefan



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

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

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



Re: Applicatiuon FAILlOVER Callback

2002-11-14 Thread dnaren


Hi here i am reposting the problem


Can someone pls help us with the following problem?

Any help would be appreciated.

Regards
-Naren.


 Requirement:

  When ever there is a connecion lost with database server the client
  applicaion should know this so that it can re-esablish the connecion..

  For this we are using Application Failover callback. I am succeded in
  registering the callback application.
  But even the connection lost the applicaion is not being called.
  Any configuration is needed at database side?..or any other
  reason




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

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



Re: Autostarting databases

2002-11-14 Thread Igor Neyman
strtSID.cmd is long gone, probably since version 8.1X

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 12:13 AM


Read Metalink Note: 62006.1

strtSID.cmd is created when you create a service using ORADIMxx, atleast
on
NT and DB version till 8.0.x, not sure about Win2K and Oracle Server 8.1.x
and later

Regards
Naveen

-Original Message-
Sent: Thursday, November 14, 2002 1:23 AM
To: Multiple recipients of list ORACLE-L


Check what SP is installed on the server.
This is a common problem with Y2K SP1.
Upgrade to SP2.

This is windows 2k server service pack 3

Have a look at the strtsid.cmd script which is used for
starting the instance/DB inside %ORACLE_HOME%\DATABASE.

That must be a personal custom script.
 Ive searched all my nt and win2k servers and only have a TRCFMT.cmd
 which looks like a file to format  trace files


 Let's try the simple solution first.  How about using the
 Services utility in Control Panel to check the service for
 startup =AUTO.

Yes its on auto

 Then specify the parameters that are to be
 used for startup, like pfile=xx.

Your talking about the properties window of the service?
 Where it says You can specify the parameters that apply when you start
the service from here

If so that will start the database but the setting pfile=x does not
retain. So, it seems like you can only pass that parameter,  the
pfile=xxx once

 Specify the userid
 that is supposed to start the database, preferably not the
 Administrator userid, but Oracle or a derivative of it.

So your asying I need a win2k account for the database user? Ive never
heard of that nor have seen parameters in any other configurations.

 This method has been known to work.

 RWB

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

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

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

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

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



Re: Dbf Files, Mount Points and Oracle 7

2002-11-14 Thread McGill, Wayne L
Just wanted to write a follow up to my question that I
posted a couple of weeks ago.  I would like to thank all
that replied. The feedback you gave was great.  I finally
got a chance during the holiday Monday to implement these
changes in my production database and it was fairly
straight-forward and everything seems to be working fine.
There were not even too many surprises that were different
from the newer test database.  As far as Air Force people
pulling Navy people's anchors, I would hope not since this
database is being used more and more for non-Navy projects.
Anyway, thanks again for all the great responses.

Wayne
[EMAIL PROTECTED]

PS.  I might even be able to add weather modification
to my resume since during this change, we got 1/4-inch of
rain.  That is the first measurable rain we have had in this
neck of the Mojave Desert since March of 2001.  Funny,
nobody mentioned this side effect of changing the database ...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: McGill, Wayne L
  INET: [EMAIL PROTECTED]

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



RE: listener.log parsing utility

2002-11-14 Thread John . Hallas
Patrice,
I wrote the enclosed awk script to check the listener log and count the
number of connections from each target.
I am sure it could be adapted to suit your needs
The first few line of output looks like
Service :Host   :User   :tcp:ip address :No of Connections
===
service1 :C   :\Oracle\Ora901\b:xxx:dedicated24
service2 :xxx   :SMITHL1 :tcp:xx.xx.xxx.xxx47


/u00/oracle/john 227$ cat a.sh
Script starts here
echo Service :Host   :User   :tcp:ip address
echo ===
grep CONNECT listener.log |\
 awk -F= '{print $3 :1: $6 :2: $7 :3: $9 :4: $10 :5: $11}'  |\
 sed 's/).*:1:/:/' | \
 sed 's/).*:2:/:/' | \
 sed 's/).*:3:/:/' | \
 sed 's/).*:4:/:/' | \
 sed 's/).*:5:/:/' | \
 sed 's/).*$//' | \
 awk -F: '{printf(%-8.8s:%-16.16s:%-16.16s:%-3.3s:%-10.15s\n, \
  $1,$2,$3,$4,$5)}'  | sort   /tmp/j.lis

grep -v PROGRAM /tmp/j.lis  /tmp/j1.lis
cat /tmp/j1.lis | awk '{if (data[$0]++ == 0)lines[++count] = $0}\
END{for (i = 1; i = count; i++)print lines[i],\tdata[lines[i]]}'\
|sort -n +4

rm /tmp/j.lis
rm /tmp/j1.lis
script ends here


HTH

John
-Original Message-
Sent: 14 November 2002 13:09
To: Multiple recipients of list ORACLE-L


Is there such a utility on the 'net somewhere?

I would like to parse the log automatically, and get summaries of connection
attempts, rejected connections, errors (if any), who connects, for how long.

I have auditing set up in our db and can get some of that info, but I would
like to monitor the contents of listener.log as well.

Just curious.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]




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

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

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



RE: OT ksh day of week yesterday

2002-11-14 Thread Barbara Baker
Ross:
Actually, this solves the problem nicely. I can always find an oracle database up around here somewhere :)
A couple of folks suggested this approach and I was going to work on it yesterday when chaos broke out. But you were kind enough to give me the code!
It's very much appreciated.
Thanks!
Barb
Ross Collado [EMAIL PROTECTED] wrote:
I used to have this requirement too. I never got to solve it by just usingksh scripting so ended up getting Oracle to derive the value for me. I guessthis doesn't solve your problem if you don't have an Oracle db running.#!/bin/kshYESTERDAY=`sqlplus -s / -EOFset head off feed off pages 0select to_char(sysdate-1,'fmDy') from dual;exitEOF`TODAY=`date +\%a`echo "TODAY is $TODAY YESTERDAY is $YESTERDAY"Hth,Ross-Original Message-Sent: Thursday, 14 November 2002 5:25To: Multiple recipients of list ORACLE-LWill someone take pity on this poor VMS'er lost in a unix world??I'm trying to create a script (ksh) that reads a log file created yesterday.The log files are created with `date +%a` appended to the end of the logfile name. Last night a log file was created called arc_index!
!
log.Tue It'seasy enough to get today TDAY="`date +%a`"grep -i "ora" /orasrv/ops/maint/logs/arc_indexlog.$TDAYgrep -i "ora" /orasrv/ops/maint/logs/adv_indexlog.$TDAYbut how do I get yesterday in the same format? (i.e., Tue instead of Wed)I man'd date, but it was no help.Thanks for any help.Barb_ Do you Yahoo!?U2 on LAUNCH - Exclusive medley  videos from Greatest Hits CD-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ross ColladoINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spell!
!
ing 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).Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site

usage of new_time() function

2002-11-14 Thread Steven Haas
Hey folks,

Oracle 8.1.7, Solaris

I have a possible requirement that all record
timestamps must use GMT.  Has anyone found an
easy way to determine the sysdate timezone to use
in the new_time() function.

Thanks much...

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

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



Re: e: when is an error msg not an error msg ?

2002-11-14 Thread Hemant K Chitale

This could happen when the ORACLE_HOME is not set correctly.
You may have the ORACLE_HOME in the .profile but your application
might be running from a script which unsets the ORACLE_HOME or
sets it incorrectly.
Hemanat
At 02:14 PM 13-11-02 -0800, you wrote:

Hello,

I've looked over hill and over dale at many web-sites (MetaLink, google,
asktom, etc.), to no avail, so could someone on the list bail me out on this
question - what causes the following error message:

ORACLE ERROR=Error while trying to retrieve text
for error ORA-03114

Now, I know what causes the 03114; I need to know why I am getting the
'error while trying to retrieve... I get this error on my test and
production servers, but not the development server. All have the same # of
files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing
somewhere that I know not of ? Any help would be greatly appreciated.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]

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

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


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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



RE: Installing 8.1.7 on a machine with an existing 9.0.1 installa

2002-11-14 Thread Stephen Lee

Could you please say which window and when?

 -Original Message-
 I'm about to throw my laptop out of the window
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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



Auto restart of Database

2002-11-14 Thread OraCop
How can I setup my server/database sothat after reboot
of my Solaris server, database and listener start
automatically?

Thanks.


__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraCop
  INET: [EMAIL PROTECTED]

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



Re: Configuring disks on a Windows 2000 server?

2002-11-14 Thread Thomas Day

Oracle's recommendation (for what it's worth) is SAME (Stripe All, Mirror
Everything).  They're blowing smoke about the redo logs.  I've never heard
anyone, anywhere say that (of course, I'm willing to learn from my errors).
RAID 5 is usually recommended against but our recent discussion here (if I
followed it correctly) indicated that the write penalty for RAID 5 may go
the way of the single extent myth.

RAID 5 is cheaper, in terms of number of disks.



   

Paul Vincent   

Paul.VincentTo: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
@uce.ac.uk  cc:   

Sent by: rootSubject: Configuring disks on a Windows 
2000 server?  
   

   

11/14/2002 

05:03 AM   

Please 

respond to 

ORACLE-L   

   

   





Hi all,

A 3rd-party software vendor is coming in to install their application on a
new Windows 2000 server. This application uses Oracle, so they'll also be
installing Oracle 8.1.7 as part of their setup session. However, they've
sent our server/hardware guys the following, specifying how they want the
disks configuring on the server:

- - - - -
As to the RAID recommendations the issue is that Oracle do not support
installations where the redo logs are on any sort of a stripped partition.
My recommendation would be to create a mirror pair out of two of the disks.
This can be partitioned for the system and the redo logs. The remainder of
the disks can be RAID 5. Note that the RAID 5 array is where the actual
database and archive logs are stored. In theory If you lose both disks on
the mirror you would still have enough information on the RAID 5 partition
to save the database.
- - - - -

Now, disk configuration's one of my weakest spots, but I have the following
two questions about their instructions:

1. Is their point about Oracle not supporting redo logs on striped
partitions true, or are they talking rubbish? All our UNIX servers with
Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it
different for Windows servers? I must say I'd never heard of this
restriction before, but I'm willing to be enlightened! Anybody?

2. They're recommending RAID 5 for a transaction-heavy application server,
here. Surely that's wrong? I thought I understood that RAID 5 was great for
file servers but lousy for servers running transactio-heavy business
applications. What's the view of you guys on this?

Please give me your views, I know we have some very experienced people on
this list!

Best regards,

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

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




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

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

RE: Configuring disks on a Windows 2000 server?

2002-11-14 Thread Tony Johnson
I think I would be looking for a new vendor. We run applications that 
run quite well in a Raid5 environment under W2K Server and/or Advanced 
Server and have run with other configurations also. Oracle doesnt know
or care what is underneath as long as the O/S recognizes it and it can
read and write to it. 

-Original Message-
Sent: Thursday, November 14, 2002 3:03 AM
To: Multiple recipients of list ORACLE-L


Hi all,

A 3rd-party software vendor is coming in to install their application on a
new Windows 2000 server. This application uses Oracle, so they'll also be
installing Oracle 8.1.7 as part of their setup session. However, they've
sent our server/hardware guys the following, specifying how they want the
disks configuring on the server:

- - - - -
As to the RAID recommendations the issue is that Oracle do not support
installations where the redo logs are on any sort of a stripped partition.
My recommendation would be to create a mirror pair out of two of the disks.
This can be partitioned for the system and the redo logs. The remainder of
the disks can be RAID 5. Note that the RAID 5 array is where the actual
database and archive logs are stored. In theory If you lose both disks on
the mirror you would still have enough information on the RAID 5 partition
to save the database.
- - - - -

Now, disk configuration's one of my weakest spots, but I have the following
two questions about their instructions:

1. Is their point about Oracle not supporting redo logs on striped
partitions true, or are they talking rubbish? All our UNIX servers with
Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it
different for Windows servers? I must say I'd never heard of this
restriction before, but I'm willing to be enlightened! Anybody?

2. They're recommending RAID 5 for a transaction-heavy application server,
here. Surely that's wrong? I thought I understood that RAID 5 was great for
file servers but lousy for servers running transactio-heavy business
applications. What's the view of you guys on this?

Please give me your views, I know we have some very experienced people on
this list!

Best regards,

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

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

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



RE: Oracle 10i features

2002-11-14 Thread Charlie_Mengler

In addition to 9iAS R2 being a terrible install,
it is riddled with bugs and a total beast to get operational!

I'll give folks another example.
If/when you HOST out from a 9i Form
your Unix process environment is populated with about 18 environmental
variables.
The problem is that NONE of the following are defined; HOME, LOGNAME, PATH!
So the poor process doesn't know who he is, which way is home and has
limited
ability to even find any executable; which make scripting a REAL challenge.



   
  
  Hately, Mike
  
  (NESL-IT)   To:   Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED] 
  Mike.Hately@npowernocc: 
  
  rthern.com  Subject:  RE: Oracle 10i features   
  
  Sent by: 
  
  [EMAIL PROTECTED] 
  
   
  
   
  
  11/14/2002 01:24 AM  
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




9iAS R2 is a terrible install. A complicated process further confused by
poor instructions.

Mike

-Original Message-
Sent: Wednesday, November 13, 2002 7:33 PM
To: Multiple recipients of list ORACLE-L


No, installing 9iAS is a 250 mph breeze. One definition of a tornado is
a very strong breeze.
-Original Message-
Sent: Wednesday, November 13, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L


Only if they make installing 9iAs a breeze ... I have heard stories that
9iAS installation is not a picnic ...
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

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





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

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



AW: Installing 8.1.7 on a machine with an existing 9.0.1 installa

2002-11-14 Thread Stefan Jahnke
Hi

Thanks. I actually tried installing 8.1.7 using the installer as it comes
with 9.0.1 (was already installed, since 9.0.1 is installed on the machine).
It seemed to work, I selected the software to be installed, the install
started, went up to 100% and then nothing happened. It just didn't finish
the installation correctly (I did not choose to create a db or anything).
I'm not on a Pentium 4 and I already copied the whole cd to disk.

Is there anything else you took into consideration ?

Regards,
Stefan


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

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



Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved

2002-11-14 Thread Boris Dali
Ray, right on target!

After looking for disk errors in dmesg output,
/var/log/messages to no avail, I finally uninstalled
the whole 9.2 OH last night,
re-downloaded/re-burned/re-... and this time
installation of both 9.2.0.1 and a patch went with no
glitches. 

Apparently Disk2 was corrupted/missing files/??? on
downloading/burning/unpacking, but what surprised me
the most is that I didn't get any errors at
gunzip/cpio stage, which I always thought of as a good
indication that software on CDs is valid. This
assumption cost me week and a half of hopeless tries
to make it work...

On the bright side, some .o, .so etc. files I see in
OUI during installation look painfully familiar...

Thanks a lot for you help.

 --- Ray Stell [EMAIL PROTECTED] wrote:  On Tue,
Nov 12, 2002 at 01:50:52PM -0800

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boris Dali
  INET: [EMAIL PROTECTED]

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



Re: Solaris vs Windows 2000

2002-11-14 Thread Lyndon Tiu
W2K is fine, really. I use it at work and it's convenient since it comes with 
the computer you just bought. It runs Oracle fine as well since I've been 
using it for a while now.

The issue here is the server side cost. W2K is expensive at $1,500 Cdn a pop 
for 5 licenses only. We need 500 per server at three servers on average per 
installation site, so imagine the cost of that.

That's where Linux comes in. AND contrary to what people still think, Linux 
is ready for prime-time.

--
Lyndon Tiu

On Thursday 14 November 2002 01:30 am, Mark Leith wrote:
 This blind hate and resentment towards Windows products it getting a little
 tiresome, have you guys even TRIED using Win2K?

 How about some constructive criticism?

 Don't get me wrong - I sit on the fence, and will defend both Unix AND
 Windows when I feel it's warranted. Win2K WILL be able to do the job that
 Jared wants it to do (we've seen and worked with the largest SAP database
 on NT in Europe)..

 And, Lyndon, I think we've got the message now :)

 Mark (Running XP Pro, Win2K Pro, and RH 8 at home) Leith

 -Original Message-
 [EMAIL PROTECTED]
 Sent: 14 November 2002 05:34
 To: Multiple recipients of list ORACLE-L



 Everything good comes at a price. And never trust any system, where to shut
 down, you got to click on start ;-)

 Regards
 Raj





 Steve Perry
 sperry@sprynTo: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED]
 et.com  cc:
 Sent by: Subject: Re: Solaris vs
 Windows 2000
 root@fatcity.
 com


 November 13,
 2002 09:08 PM
 Please
 respond to
 ORACLE-L






 Thanks, but that wouldn't convince him. He'd say it wasn't MS's fault. It
 was our for not securing it :(
 When you want to believe something, you don't let facts get in the way :)

 Steve

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, November 13, 2002 11:54 AM

  Steve,
 
  Get your Boss to read the following. Jared - one more arrow in your

 quiver!

   --6 November 2002  Bermudan Bank Site Defaced
  Hackers may have exploited a Microsoft operating system vulnerability
  to deface two Bermudan websites, including that of the Bank of
  Butterfield.  Bank officials say no customer data was compromised.
  The site hosts are recommending that their clients who work with data
  that needs to be protected switch to their Unix based hosting platform.

 http://www.bermudasun.bm/cgi-local/edpull.pl?cat=01Newsord=03ed=2002-11-0
6

  [Editor's Note Schultz]: The recommendation in this news item should
  add a considerable amount of fuel to the whose operating system is
  most secure debate.]
 
  John Kanagaraj
  Oracle Applications DBA
  DBSoft Inc
  (W): 408-970-7002
 
  What would you see if you were allowed to look back at your life at the

 end

  of your journey in this earth?
 
  ** The opinions and statements above are entirely my own and not those of

 my

  employer or clients **
 
   -Original Message-
   From: Steve Perry [mailto:sperry;sprynet.com]
   Sent: Wednesday, November 13, 2002 7:09 AM
   To: Multiple recipients of list ORACLE-L
   Subject: Re: Solaris vs Windows 2000
  
  
   Jared,
  
   Here's my recollection of a losing battle. I hope this helps.
  
   I used to work on Unix (AIX and Solaris) and can only think
   about the good
   ol' days...
   Now, I work on Comcrap Servers (i mean HP) running Microslop
   NT and 2000.
   We have tons of them :)
   I asked my boss why they are using Windows instead of Unix.
   I gave him all the arguments about scalability, secure... and
   not having to
   do the weekly reboots and he listened patiently.
   He finally said How much will a Sun server cost?. I said
   I'd have to check
   on it, but he said We are running a 500 gig SAP system on a
   $5K compaq with
   6 other compaq app servers that cost less than that. He asked
   what the Unix
   would cost. I started to answer that the hardware isn't the
   only cost and we
   have an EMC disk array behind it, but he stopped me and said
   it doesn't
   matter. He walks into the CIO's office and asks for a $70K
   dollar Solaris
   box and he gets booted out of the office. He can nickle and
   dime him for $5K
   servers...
   I pointed out that we had to spend a million dollars on a EMC
   Symmetrix with
   Clarion and he said exactly. We spend the big money on the
   I/O subsystem
   for a bunch of servers and we can buy all the cheap up front
   hardware we
   want. Next, he pointed out that we'd have to hire a Unix
   admin and that
   would cost money. Everybody knows how to administer Windows
   he says. I
   said pressing control-alt-del isn't administration. He also
   said that with
   EMC behind the scenes we don't have to 

Re: usage of new_time() function

2002-11-14 Thread Stephane Faroult
Steven Haas wrote:
 
 Hey folks,
 
 Oracle 8.1.7, Solaris
 
 I have a possible requirement that all record
 timestamps must use GMT.  Has anyone found an
 easy way to determine the sysdate timezone to use
 in the new_time() function.
 
 Thanks much...
 
 Steve

Steve,

   I have very recently played a little bit with such things, and it
seems to me pretty messy, especially when you happen to live in time
zones whence you need not even think about sending your resume to
OraStaff (seems better in 9.x).
   I have a few days ago discovered the command :
   ALTER DATABASE SET TIME_ZONE = 'blahblah';
where 'blahblah' can be specified either as a code (which doesn't really
solve your problem) or as '+00:00' or '-00:00' to specify your offset
to/from GMT, which I find easier to guess.
Once your database knows where it stands, you can use function
dbtimezone (which for a reason I have been too lazy to find out I had to
specify as sys.standard.dbtimezone in a procedure) to get it. Then, you
can compute the GMT date as follows :

declare
   my_timezone  varchar2(30);
   pos  number;
   timeoffset   number;
begin
  select sys.standard.dbtimezone
  into my_timezone
  from dual;
  pos := instr(my_timezone, ':');
  if (pos = 0)
  then
--
--   Timezone was specified as an abbreviation
--
dbms_session.set_nls('NLS_DATE_FORMAT', 'DD-MON- HH24:MI:SS');
timeoffset :=  SYSDATE - NEW_TIME(SYSDATE, my_timezone, 'GMT');
  else
--
--   Timezone was specified as a time offset
--
timeoffset := to_number(substr(my_timezone, 2,
   pos-2))/24
  + to_number(substr(my_timezone,
 pos+1,2))/1440;
if (substr(my_timezone, 1, 1) = '-')
then
  timeoffset := -1 * timeoffset;
end if;
  end if;
end;

Create a packaged function GMTDATE, compute timeoffset as above in the
initialization section of the package, and then simply make GMTDATE
return SYSDATE + timeoffset and it should do.

HTH,

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

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



NetBackup

2002-11-14 Thread O'Neill, Sean
Howdy Folks,

Would appreciate feedback on experiences, positive :) or negative :(, folk
have had using Veritas NetBackup product for DB recovery, especially in DR
scenarios.  There is an Oracle agent but so far all it appears to me to be
is a glorious scheduler of your own RMAN scripted jobs!.  Feedback on
features I may have missed with agent would also be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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



Re: Solaris vs Windows 2000

2002-11-14 Thread Lyndon Tiu
Fwd: linux does well in morgan stanley survey

--  Forwarded Message  --

Date: Thu, 14 Nov 2002 02:42:57 -0800

Hi all,

A recent Morgan Stanley reports an excellent outlook for linux in
IT. Not one CIO was prepared to reduce their usage of linux.

http://h30046.www3.hp.com/news_article.php?topiccode=20021001_itereport0043

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

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



RE: error code 3113

2002-11-14 Thread DENNIS WILLIAMS
Satyendra - There are some good notes on Metalink. I just did a search and
found:
ORA-03113 AND ORA-03114 ON DESKTOP PLATFORMS 
 Type: Note Doc ID: 1003596.6 
 Score: 100% Modified Date: 09-OCT-2002 
 Status: PUBLISHED Platform: MS Windows Product: Oracle Net Services 
2. DIAGNOSING ORA-3113 ERRORS 
 Type: Note Doc ID: 1020463.6 
 Score: 100% Modified Date: 05-OCT-2002 
 Status: PUBLISHED Platform: Generic issue Product: Oracle  
3. OERR: ORA 3113 end-of-file on communication channel 
 Type: Note Doc ID: 19790.1 
 Score: 100% Modified Date: 10-SEP-2002 
 Status: PUBLISHED Platform: Generic issue Product: Oracle Server -
Enterprise Edition 
4.  ORA-03113 on Unix - What Information to Collect 
 Type: Note Doc ID: 17613.1 
 Score: 100% Modified Date: 26-MAR-2000 
 Status: PUBLISHED Platform: Generic issue Product: Oracle Server -
Enterprise Edition 

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


-Original Message-
Sent: Thursday, November 14, 2002 1:59 AM
To: Multiple recipients of list ORACLE-L


3113 end-of-file on communication channel

This is a very common error and encounter many times, but generally down
the databae and up again solve the problem, but this time i m not able
to handle it by doing that...
What is the remady and..
 WHAT ARE THE CAUSE FOR THIS ERROR ?? Why it happened..??

Thanks and regard..
Satyendra ..

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

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

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



RE: listener.log parsing utility

2002-11-14 Thread DENNIS WILLIAMS
Patrice - In case you don't get a reply, it sounds to me like an easy
project for Perl.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, November 14, 2002 7:09 AM
To: Multiple recipients of list ORACLE-L


Is there such a utility on the 'net somewhere?

I would like to parse the log automatically, and get summaries of connection
attempts, rejected connections, errors (if any), who connects, for how long.

I have auditing set up in our db and can get some of that info, but I would
like to monitor the contents of listener.log as well.

Just curious.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]




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

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

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



Re: Auto restart of Database

2002-11-14 Thread Scott Stefick
Assuming you are running Oracle 9i RDBMS(If not, After you click on the 
Database tab, choose the release you are running)

Go to docs.oracle.com, click on the tab in the upper right corner that says 
Database, click on OK on the pop up disclaimer box,  Under the 9i heading 
click on Sun SPARC Solaris and then click on the release that you are 
running.  Then click on the link to the Installation Guide.  Expand the 
Post-Installation section and click on Configuration Tasks to Perform as 
the Root User.  Then go four bullet points down to Automating Database 
Startup and Shutdown for HP, Linux and Solaris... and click on 
that.  There you have the complete instructions on how to implement 
Database Startup and Shutdown.

If you want, you could just add a line in the given script to start the 
listener as well.

-Scott Stefick

At 07:28 AM 11/14/02 -0800, you wrote:
How can I setup my server/database sothat after reboot
of my Solaris server, database and listener start
automatically?

Thanks.


__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraCop
  INET: [EMAIL PROTECTED]

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



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 INET: [EMAIL PROTECTED]

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



Re: Auto restart of Database

2002-11-14 Thread OraCop

Set last argument for appropriate SID in oratab = Y
to restart DB at boot time.

--- OraCop [EMAIL PROTECTED] wrote:
 How can I setup my server/database sothat after
 reboot
 of my Solaris server, database and listener start
 automatically?
 
 Thanks.
 
 
 __
 Do you Yahoo!?
 Yahoo! Web Hosting - Let the expert host your site
 http://webhosting.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: OraCop
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraCop
  INET: [EMAIL PROTECTED]

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



RE: Check Point Interval Question

2002-11-14 Thread Hamid Alavi
Thanks alot jared,

I just want to know if I change my redo log size to 1 K, do I have to
change checkpoint_interval to 2 or still 1 doesn't affect.

Thanks alot

-Original Message-
Sent: Wednesday, November 13, 2002 8:28 PM
To: Multiple recipients of list ORACLE-L



Hamid,

Is there perhaps a reason given for that setting?

The setting determines how often a checkpoint will be performed
based on the number of redo log blocks.  

From the FM:

LOG_CHECKPOINT_INTERVAL specifies the frequency of checkpoints in terms of 
the number of redo log file blocks that can exist between an incremental 
checkpoint and the last block written to the redo log. This number refers to

physical operating system blocks, not database blocks.  

On Solaris, that's 512 bytes per block.

see: 
http://www.ixora.com.au/notes/log_block_size.htm


With a value of 1, the setting had no effect on your log file of 4m,
since
a 4 meg file consists of 8192 512 byte blocks.

Similarly, a setting of 999 will not cause any extra checkpoints to be
written between log switches.  A 20 meg log file has 40960 512 byte blocks.

Setting LOG_CHECKPOINT_INTERVAL = 0 would have the same effect
in both cases.

Jared


On Wednesday 13 November 2002 09:54, Hamid Alavi wrote:
 Dennis,

 Here it is in the oracle performance tuning (Tip's  Techniques) page 
735
 suggested value for LOG_CHECKPOINT_INTERVAL = 999.

 My oracle version is 8.1.7.4 on sun solaris, 2.8, and I have some CPU
 problem, My thought is may be some checkpoint problem so, I have decided
to
 increase the size of my Redo log from 4M to 20M and change the
 log_checkpoint_interval from 1 to 999 but I don't know what's the
 best setting for these numbers.


 -Original Message-
 Sent: Wednesday, November 13, 2002 9:16 AM
 To: Multiple recipients of list ORACLE-L


 Hamid - Which parameter to use depends on your Oracle version. If it is
9i,
 use FAST_START_MTTR_TARGET. In 8i, use LOG_CHECKPOINT_TIMEOUT. Did your
 tuning manual explain why you should set it to 999? That seems a
little
 strange. Basically shorter checkpoint queue lengths will shorten your
 recovery times, but too short a queue length may hamper performance, so it
 is a tradeoff. What are your tradeoff criteria?

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


 -Original Message-
 Sent: Wednesday, November 13, 2002 10:39 AM
 To: Multiple recipients of list ORACLE-L


 Hi List,

 I have a question regarding check_point_interval. In my setting
 log_checkpoint_interval = 1  log_checkpoint_timeout = 1800 , I
findout
 in the tuning manual which I have to change thelog_checkpoint_interval =
 999 but nothing regarding the log_checkpoint_timeout, when I change
the
 interval to 999 do I have to change the checkpoint_timeout too, or
 what's the best setting for these two numbers.
 I got confued, some where in the manual they are talking about to set
 timeout to zero some where else diffrent setting, I realy appreciate if
 some body give me a pratical Idea.

 Thanks for your help.




 Hamid Alavi
 Office 818 737-0526
 Cell818 416-5095






 === Confidentiality Statement ===
 The information contained in this message and any attachments is
 intended only for the use of the individual or entity to which it is
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
 and exempt from disclosure under applicable law.  If you have received
 this message in error, you are prohibited from copying, distributing, or
 using the information.  Please contact the sender immediately by return
 e-mail and delete the original message from your system.
 = End Confidentiality Statement =
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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





=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from 

Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved

2002-11-14 Thread Markus Reger
out of curiosity : did you ever check the filesizes in bytes of yr first corrupt 
downloads with the bytes of the files on the download site? i'm running O9i too, now 
wondering if this test might suffice to tell whether the download was successful or 
not. i didn't experience any probs so far until recently when i changed/patched to 
9.2.0.2.0 - the oem/console dosn't display the XML database. the flaw is, that it 
doesn't have some index ...

created a totally new -userdefined,NOT preconfigured - database and could successfully 
display the XML-stuff.

installation is on a rh 7.2 - was a rh 8.0 - but on rh8.0 the console didn't work - 
unproperly terminated connect string when attempting to connect even to a local 
database. dumped the whole rh 8.0, reinstalled the 7.2.

lfw to a reply 
mr  
 [EMAIL PROTECTED] 11/14/02 17:32 PM 
Ray, right on target!

After looking for disk errors in dmesg output,
/var/log/messages to no avail, I finally uninstalled
the whole 9.2 OH last night,
re-downloaded/re-burned/re-... and this time
installation of both 9.2.0.1 and a patch went with no
glitches. 

Apparently Disk2 was corrupted/missing files/??? on
downloading/burning/unpacking, but what surprised me
the most is that I didn't get any errors at
gunzip/cpio stage, which I always thought of as a good
indication that software on CDs is valid. This
assumption cost me week and a half of hopeless tries
to make it work...

On the bright side, some .o, .so etc. files I see in
OUI during installation look painfully familiar...

Thanks a lot for you help.

 --- Ray Stell [EMAIL PROTECTED] wrote:  On Tue,
Nov 12, 2002 at 01:50:52PM -0800

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boris Dali
  INET: [EMAIL PROTECTED]

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

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

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



Linux?

2002-11-14 Thread Lyndon Tiu

Fwd: linux does well in morgan stanley survey

--  Forwarded Message  --

Date: Thu, 14 Nov 2002 02:42:57 -0800

Hi all,

A recent Morgan Stanley reports an excellent outlook for linux in
IT. Not one CIO was prepared to reduce their usage of linux.

http://h30046.www3.hp.com/news_article.php?topiccode=20021001_itereport0043
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

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



RE: RE: How-To or Good Practices on Code Releases

2002-11-14 Thread Magaliff, Bill
what is the difference in the db between adding a column with a default
value, and adding a column and then later modifying it to set a default
value?

in neither case is the value actually set in the column itself.

thx
-b

-Original Message-
Sent: Thursday, November 14, 2002 6:09 AM
To: Multiple recipients of list ORACLE-L


Rajesh.Rao,
I have the same experience. Developers directly connected to
production database and added a column with default table on a huge table.
The whole table is locked for 1 hour and other transaction failed.
Add a column with non default value and then later add
default value for it can be done in 1 second.
Developers do not Know how oracle do it and just go on. New
application going online without volume testing, getting online and as a
production dba,i search for the bad sql and trace it out and send it back to
developer!
That is why many project fail, the app is designed and
developed without the attendence of a guy who really knows oracle.





Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)

=== 2002-11-13 12:06:00 ,you wrote£º===

I also have been burnt by an simple alter table add column default string
script. A pretty simple script. The developers tested it, the QA team too
approved it. Was expected to run in a matter of minutes. The problem was
the data in production was 100 times over. Missed out on volume testing.
Took 2 cuppas and 3 smokes before it was done.

Raj






Magaliff, Bill

Bill.Magaliff@lenTo: Multiple recipients
of list ORACLE-L ORACLE-L@fatcitS

= = = = = = = = = = = = = = = = = = = =




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

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

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



CONSISTANT GETS

2002-11-14 Thread Hamid Alavi
Dear List,

I am monitoring a database,  I findout there is a transaction which runing
a long time and others are waiting for this transaction, this transaction
have 8,000,000 consistant gets with only 1 Physical I/O.
My question is, what I have to do except the SQL tuning to make this
transaction faster, we have done all the necessary tuning on all the SQL
query's.
Here is a copy of ora.ini:

Oracle 8.1.7.4   on sun solaris 2.8

background_dump_dest = /oracle/admin/cmstst/bdump
compatible = 8.1.7.4
control_files = /cmsdb/cmstst/control02.ctl
control_files = /oralogs1/cmstst/control03.ctl
control_files = /oracle/oradata/cmstst/control01.ctl
core_dump_dest = /oracle/admin/cmstst/cdump
db_block_buffers = 1??? this need to
increase?
db_block_lru_latches = 4
db_block_size = 8192
db_file_multiblock_read_count = 16
db_name = cmstst
hash_area_size = 2048000??? need tuning ???
instance_name = cmstst
java_pool_size = 20971520
large_pool_size = 614400
log_archive_dest_1 = location=/archlogs/cmstst
log_archive_format = arch%s.arc
log_archive_start = TRUE
log_buffer = 262144 ?? this log buffer
is enough??
log_checkpoint_interval = 1 ?? 
log_checkpoint_timeout = 1800
max_enabled_roles = 30
open_cursors = 300
optimizer_index_caching = 90
optimizer_index_cost_adj = 35
os_authent_prefix = 
processes = 100
remote_login_passwordfile = EXCLUSIVE
session_cached_cursors = 100
shared_pool_size = 134217728
sort_area_retained_size = 262144
sort_area_size = 262144
timed_statistics = TRUE


I realy appreciate your help and assistant. I am getting confused, just want
to know changing any of these parameter help the performance to reduce the
number of CONSISTANT GETS or NOT???

Thanks in advance.



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

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



Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved

2002-11-14 Thread Ray Stell

Oracle Corp. finds the checksum concept to be alien.  They actually
posted these words to me in a tar at metalink, We don't support
servers that are installed via download from otn.  I guess network
computing really is dead. ;)
 



On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote:
 Ray, right on target!
 
 After looking for disk errors in dmesg output,
 /var/log/messages to no avail, I finally uninstalled
 the whole 9.2 OH last night,
 re-downloaded/re-burned/re-... and this time
 installation of both 9.2.0.1 and a patch went with no
 glitches. 
 
 Apparently Disk2 was corrupted/missing files/??? on
 downloading/burning/unpacking, but what surprised me
 the most is that I didn't get any errors at
 gunzip/cpio stage, which I always thought of as a good
 indication that software on CDs is valid. This
 assumption cost me week and a half of hopeless tries
 to make it work...
 
 On the bright side, some .o, .so etc. files I see in
 OUI during installation look painfully familiar...
 
 Thanks a lot for you help.
 
  --- Ray Stell [EMAIL PROTECTED] wrote:  On Tue,
 Nov 12, 2002 at 01:50:52PM -0800
 
 __ 
 Post your free ad now! http://personals.yahoo.ca
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Boris Dali
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

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

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



RE: Oracle SAN Experiences?

2002-11-14 Thread Leonard, George
Title: The Sys









Hi there



What are the thoughts about the Xiotech - Magnitude.





George



George
 Leonard

Oracle Database
Administrator

Dimension Data (Pty) Ltd

(Reg. No. 1987/006597/07)

Tel:(+27 11) 575
0573

Fax:(+27 11) 576
0573

E-mail:[EMAIL PROTECTED]

Web:  http://www.didata.co.za



You Have The Obligation
to Inform One Honestly of the risk, And As a Person

You Are Committed to
Educate Yourself to the Total Risk In Any Activity!

Once Informed 
Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure
Themselves as They See Fit!



-Original Message-
From: Babette Turner-Underwood
[mailto:[EMAIL PROTECTED]] 
Sent: 11 November 2002 15:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle  SAN
Experiences?





A client
site that I was supporting a while ago had big problems with their NAS.





While
doing Oracle backups to tape, the application would drop connections. 





In a SAN
environment, there might also be similar problems.











-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of David
Wagoner
Sent: Friday, November 08, 2002
9:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: Oracle  SAN
Experiences?





The Sys. Admin. team wants to consolidate storage (and probably get a
new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600).
The DBA team is doing some research to determine the pros and cons of
doing this, and I'd like to hear any of your experiences (good and bad)
using SAN with Oracle.



My understanding is that all of our database servers would remain
intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and
App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from
Production, Test, Apps., staging, ODS,data warehouse, etc.



Their arguments:

-the SAN is very scalable (500 GB - 40 TB)

-easy to manage disks in one central location

-fancy statistics collection on all SAN disks

-much higher throughput on the fiber SAN connections than with locally
attached disk arrays

-capable of using mixed RAID levels (0, 1, 1+0, 5, etc.)

-can partition sets of disks in the SAN for specific server access

-Snapshot backup capability is very fast in the SAN (much faster than
traditional Oracle backups)



DBA arguments:

-How will this affect database performance?

-What are the drawbacks, if any, with the pre-fetch of data performed
by the SAN (i.e., SAN cache)

-How tunable is the SAN

-Fast, small disks are better for performance and less wasted space
than the typical huge disks in a SAN (it's possible to use smaller disks
in the SAN)

-Prove it!





After reading the "Sane SAN" article and a case study about
Volvo implementing a SAN, I believe it's possible to have a great
Oracle/SAN implementation if it's setup correctly and tuned. Other resources that you can Google are
"Using SVA SnapShot with Oracle", "Performance Benchmark LSI
Logic E4600 (STK D178)", "SAN Storage for Open Systems
Environments", and of course check the OraFaq.



Thanks for sharing,



David Wagoner

Oracle DBA


















Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved

2002-11-14 Thread Boris Dali
 --- Markus Reger [EMAIL PROTECTED] wrote:  out of
curiosity : did you ever check the filesizes
 in bytes of yr first corrupt downloads with the
 bytes of the files on the download site? 

I did. They bear some resemblace, but figures are not
exactly the same. 
I also compared sizes of files I got on disk
(unpacked) after my first and second downloads and
they are different for all 3 files, even though only
Disk2 was... well, not good. Math doesn't seem to rule
here. Go figure

 i'm running O9i too, now wondering if this test
might suffice to
 tell whether the download was successful or not. i
 didn't experience any probs so far until recently
 when i changed/patched to 9.2.0.2.0 - the
 oem/console dosn't display the XML database. the
 flaw is, that it doesn't have some index ...
 
 created a totally new -userdefined,NOT preconfigured
 - database and could successfully display the
 XML-stuff.
 
 installation is on a rh 7.2 - was a rh 8.0 - but on
 rh8.0 the console didn't work - unproperly
 terminated connect string when attempting to connect
 even to a local database. dumped the whole rh 8.0,
 reinstalled the 7.2.
 
 lfw to a reply 
 mr  
  [EMAIL PROTECTED] 11/14/02 17:32 PM 
 Ray, right on target!
 
 After looking for disk errors in dmesg output,
 /var/log/messages to no avail, I finally uninstalled
 the whole 9.2 OH last night,
 re-downloaded/re-burned/re-... and this time
 installation of both 9.2.0.1 and a patch went with
 no
 glitches. 
 
 Apparently Disk2 was corrupted/missing files/??? on
 downloading/burning/unpacking, but what surprised me
 the most is that I didn't get any errors at
 gunzip/cpio stage, which I always thought of as a
 good
 indication that software on CDs is valid. This
 assumption cost me week and a half of hopeless tries
 to make it work...
 
 On the bright side, some .o, .so etc. files I see in
 OUI during installation look painfully familiar...
 
 Thanks a lot for you help.
 
  --- Ray Stell [EMAIL PROTECTED] wrote:  On Tue,
 Nov 12, 2002 at 01:50:52PM -0800
 

__
 
 Post your free ad now! http://personals.yahoo.ca
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Boris Dali
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boris Dali
  INET: [EMAIL PROTECTED]

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



ini file

2002-11-14 Thread Hamid Alavi
Hi Again,

Another question is, if i increase the following parameter is there any
negative effective or not?

1) db_block_buffers = 1change to 2
2) hash_area_size = 2048000 change  to 5120 5 M
3) log_buffer = 262144change to 5242880   5 M

Thanks



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

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



RE: Oracle 9.2.0.1/2 on Mandrake 9 - solved

2002-11-14 Thread Jim . Conboy
I've been told the same thing, but the reasoning was that they couldn't guarantee what 
was put out for download was actually the correct build.  Not sure that's very 
reassuring, either.

Jim

-Original Message-
Sent: Thursday, November 14, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L



Oracle Corp. finds the checksum concept to be alien.  They actually
posted these words to me in a tar at metalink, We don't support
servers that are installed via download from otn.  I guess network
computing really is dead. ;)
 



On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote:
 Ray, right on target!
 
 After looking for disk errors in dmesg output,
 /var/log/messages to no avail, I finally uninstalled
 the whole 9.2 OH last night,
 re-downloaded/re-burned/re-... and this time
 installation of both 9.2.0.1 and a patch went with no
 glitches. 
 
 Apparently Disk2 was corrupted/missing files/??? on
 downloading/burning/unpacking, but what surprised me
 the most is that I didn't get any errors at
 gunzip/cpio stage, which I always thought of as a good
 indication that software on CDs is valid. This
 assumption cost me week and a half of hopeless tries
 to make it work...
 
 On the bright side, some .o, .so etc. files I see in
 OUI during installation look painfully familiar...
 
 Thanks a lot for you help.
 
  --- Ray Stell [EMAIL PROTECTED] wrote:  On Tue,
 Nov 12, 2002 at 01:50:52PM -0800
 
 __ 
 Post your free ad now! http://personals.yahoo.ca
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Boris Dali
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

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

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

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



Re: How-To or Good Practices on Code Releases

2002-11-14 Thread Stephane Faroult
Magaliff, Bill wrote:
 
 what is the difference in the db between adding a column with a default
 value, and adding a column and then later modifying it to set a default
 value?
 
 in neither case is the value actually set in the column itself.
 
 thx
 -b
 

Give it a try, Bill.

-- 
Regards,

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

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



Re: CONSISTANT GETS

2002-11-14 Thread Connor McDonald
forget about parameters ... look at fixing the SQL
that is causing the problem

hth
connor

 --- Hamid Alavi [EMAIL PROTECTED] wrote: 
Dear List,
 
 I am monitoring a database,  I findout there is a
 transaction which runing
 a long time and others are waiting for this
 transaction, this transaction
 have 8,000,000 consistant gets with only 1 Physical
 I/O.
 My question is, what I have to do except the SQL
 tuning to make this
 transaction faster, we have done all the necessary
 tuning on all the SQL
 query's.
 Here is a copy of ora.ini:
 
 Oracle 8.1.7.4   on sun solaris 2.8
 
 background_dump_dest = /oracle/admin/cmstst/bdump
 compatible = 8.1.7.4
 control_files = /cmsdb/cmstst/control02.ctl
 control_files = /oralogs1/cmstst/control03.ctl
 control_files =
 /oracle/oradata/cmstst/control01.ctl
 core_dump_dest = /oracle/admin/cmstst/cdump
 db_block_buffers = 1  ??? this need to
 increase?
 db_block_lru_latches = 4
 db_block_size = 8192
 db_file_multiblock_read_count = 16
 db_name = cmstst
 hash_area_size = 2048000  ??? need tuning ???
 instance_name = cmstst
 java_pool_size = 20971520
 large_pool_size = 614400
 log_archive_dest_1 = location=/archlogs/cmstst
 log_archive_format = arch%s.arc
 log_archive_start = TRUE
 log_buffer = 262144   ?? this log buffer
 is enough??
 log_checkpoint_interval = 1   ?? 
 log_checkpoint_timeout = 1800
 max_enabled_roles = 30
 open_cursors = 300
 optimizer_index_caching = 90
 optimizer_index_cost_adj = 35
 os_authent_prefix = 
 processes = 100
 remote_login_passwordfile = EXCLUSIVE
 session_cached_cursors = 100
 shared_pool_size = 134217728
 sort_area_retained_size = 262144
 sort_area_size = 262144
 timed_statistics = TRUE
 
 
 I realy appreciate your help and assistant. I am
 getting confused, just want
 to know changing any of these parameter help the
 performance to reduce the
 number of CONSISTANT GETS or NOT???
 
 Thanks in advance.
 
 
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 416-5095
 
 
 
 
 
 
 === Confidentiality Statement
 === 
 The information contained in this message and any
 attachments is 
 intended only for the use of the individual or
 entity to which it is 
 addressed, and may contain information that is
 PRIVILEGED, CONFIDENTIAL 
 and exempt from disclosure under applicable law.  If
 you have received 
 this message in error, you are prohibited from
 copying, distributing, or 
 using the information.  Please contact the sender
 immediately by return 
 e-mail and delete the original message from your
 system. 
 = End Confidentiality Statement
 =  
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Hamid Alavi
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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



RE: ini file

2002-11-14 Thread Cary Millsap
Increasing db_block_buffers will almost certainly make no difference to
the performance of the query you've shown us. 

Manipulation of hash_area_size might change your query's execution plan,
but I can't tell you whether for better or for worse. But it is
important to understand that changing hash_area_size might profoundly
change a lot of other execution plans in your system as well. Some for
better, and--I'm sure--some for worse.

Your log buffer size is very likely an irrelevance with respect to your
query performance.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Alavi
Sent: Thursday, November 14, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L

Hi Again,

Another question is, if i increase the following parameter is there any
negative effective or not?

1) db_block_buffers = 1change to 2
2) hash_area_size = 2048000 change  to 5120 5 M
3) log_buffer = 262144change to 5242880   5 M

Thanks



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement
=== 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or

using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement
=  


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

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

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

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



Join Query Question

2002-11-14 Thread Gary Chambers
All...

I'm not even sure how to ask this question, but given three tables:

pocs

poc_id number primary key
sn varchar2(32)
poc_hrid   varchar2(16)
poctype_id number references poctypes(poctype_id)

poctypes

poctype_id  number primary key
tiernumber(2,0)
description varchar2(64)
pocgroup_id number references pocgroups(pocgroup_id)

pocgroups
-
pocgroup_id number primary key
description varchar2(16)

I'm attempting to construct a single query that will provide the
poc_hrid *AND* the pocgroup description to which that poc belongs.
This is part of a web-based application which allows for many
points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only
members of a particular group to modify certain sections of the record.
Any help will be greatly appreciated!

Gary Chambers

//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--

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

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



RE: CONSISTANT GETS

2002-11-14 Thread Cary Millsap
Hamid,

I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the
calling application (or an aggregation of 800,000 rows), then the
statement we have done all the necessary tuning on all the SQL queries
is not yet true.

If your SQL does actually return about 800,000 rows, then it is time to
begin thinking about the mismatch between business processing
requirements and the logical structure of your data.

The answer to your problem is not in your instance parameters.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Alavi
Sent: Thursday, November 14, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L

Dear List,

I am monitoring a database,  I findout there is a transaction which
runing
a long time and others are waiting for this transaction, this
transaction
have 8,000,000 consistant gets with only 1 Physical I/O.
My question is, what I have to do except the SQL tuning to make this
transaction faster, we have done all the necessary tuning on all the SQL
query's.
Here is a copy of ora.ini:

Oracle 8.1.7.4   on sun solaris 2.8

background_dump_dest = /oracle/admin/cmstst/bdump
compatible = 8.1.7.4
control_files = /cmsdb/cmstst/control02.ctl
control_files = /oralogs1/cmstst/control03.ctl
control_files = /oracle/oradata/cmstst/control01.ctl
core_dump_dest = /oracle/admin/cmstst/cdump
db_block_buffers = 1??? this need to
increase?
db_block_lru_latches = 4
db_block_size = 8192
db_file_multiblock_read_count = 16
db_name = cmstst
hash_area_size = 2048000??? need tuning
???
instance_name = cmstst
java_pool_size = 20971520
large_pool_size = 614400
log_archive_dest_1 = location=/archlogs/cmstst
log_archive_format = arch%s.arc
log_archive_start = TRUE
log_buffer = 262144 ?? this log
buffer
is enough??
log_checkpoint_interval = 1 ?? 
log_checkpoint_timeout = 1800
max_enabled_roles = 30
open_cursors = 300
optimizer_index_caching = 90
optimizer_index_cost_adj = 35
os_authent_prefix = 
processes = 100
remote_login_passwordfile = EXCLUSIVE
session_cached_cursors = 100
shared_pool_size = 134217728
sort_area_retained_size = 262144
sort_area_size = 262144
timed_statistics = TRUE


I realy appreciate your help and assistant. I am getting confused, just
want
to know changing any of these parameter help the performance to reduce
the
number of CONSISTANT GETS or NOT???

Thanks in advance.



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement
=== 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or

using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement
=  


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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ini file

2002-11-14 Thread Shao, Chunning
If you do not have enough memory, you will use swap memory, which will cause a lot of 
I/O, and you will not be able to see it on your database dictionary.

later

-Original Message-
Sent: Thursday, November 14, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Hi Again,

Another question is, if i increase the following parameter is there any
negative effective or not?

1) db_block_buffers = 1change to 2
2) hash_area_size = 2048000 change  to 5120 5 M
3) log_buffer = 262144change to 5242880   5 M

Thanks



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

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

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



RE: Join Query Question

2002-11-14 Thread Carle, William T (Bill), ALCAS
select a.poc_hrid,c.description from pocs a, poctypes b, pocgroups c
where a.poctype_id = b.poctype_id
and b.pocgroup_id = c.pocgroup_id;


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

 -Original Message-
Sent:   Thursday, November 14, 2002 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject:Join Query Question

All...

I'm not even sure how to ask this question, but given three tables:

pocs

poc_id number primary key
sn varchar2(32)
poc_hrid   varchar2(16)
poctype_id number references poctypes(poctype_id)

poctypes

poctype_id  number primary key
tiernumber(2,0)
description varchar2(64)
pocgroup_id number references pocgroups(pocgroup_id)

pocgroups
-
pocgroup_id number primary key
description varchar2(16)

I'm attempting to construct a single query that will provide the
poc_hrid *AND* the pocgroup description to which that poc belongs.
This is part of a web-based application which allows for many
points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only
members of a particular group to modify certain sections of the record.
Any help will be greatly appreciated!

Gary Chambers

//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--

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

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

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



RE: e: when is an error msg not an error msg ?

2002-11-14 Thread Sherman, Paul R.
Hello,

Thanks to all that replied.

Yes, it was an environmental issue. The Pro*C program was being executed
from cron without a wrapper, and cron being 'environmentally dumb' meant
that, despite the environment being properly set for the user, the job was
executed in a void. The developers will wrap the executable and all should
be okay afterwards.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 14, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L



This could happen when the ORACLE_HOME is not set correctly.
You may have the ORACLE_HOME in the .profile but your application
might be running from a script which unsets the ORACLE_HOME or
sets it incorrectly.
Hemanat
At 02:14 PM 13-11-02 -0800, you wrote:
Hello,

I've looked over hill and over dale at many web-sites (MetaLink, google,
asktom, etc.), to no avail, so could someone on the list bail me out on
this
question - what causes the following error message:

 ORACLE ERROR=Error while trying to retrieve text
for error ORA-03114

Now, I know what causes the 03114; I need to know why I am getting the
'error while trying to retrieve... I get this error on my test and
production servers, but not the development server. All have the same # of
files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing
somewhere that I know not of ? Any help would be greatly appreciated.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]

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

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

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

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



Monitoring Unix Question

2002-11-14 Thread ecandrietta

Friends :

How can i do for get what is running inside a PID that is
using a lot of CPU ?

How can I get the query that is running inside the database
according PID of unix ?

I would like to know commands of the unix and the query that
i need to run in the database for find out the problem.

Regards

Eriovaldo



---
UOL, o melhor da Internet
http://www.uol.com.br/

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

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



renaming host

2002-11-14 Thread David Turner
Is there any way to tell what connect string an application is using to connect
to the database? I want to rename a host but I know some developers are going to
forget to change their connect strings and I would like to catch them before we
rename the box.

My plan is to:

o create a new cname for the host

o create a new tnsalias based on the cname

o Have developers reconnect using the new tnsalias

o Monitor for any connections that still use the old connect string, and
  tell developers they still need to change their connect string.

o Monitor again 

o Rename box

o Have all applications connecting using the new name.

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

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



OT: Metalink patch searches rant

2002-11-14 Thread Murray, Margaret
All,
I'm so frustrated that I had to rant to the list - my co-workers don't have
much sympathy.  I haven't been searching Metalink for patches in the last
two weeks, but the new search functionality really sucks.  When trying to
search for Linux patches, I must put in Linux Operating System Family
which promptly makes the ONLY release RedHat Advanced Server 2.0.  Not
right when I want to search certified SuSE SLES7 (or even if I had RedHat,
2.0 is only certified on 9i, not 8i!). Must mean there are only patches for
RedHat 2.0 on 9i? Yeah, right. Urrgh! 
Plus, in the new Beta search, drop downs are a thing of the past - just
about every field must be queried separately (those lovely pop-up windows),
though supposedly the searches can be saved (haven't tried that yet, no
reason to!). I'm sure there are tons of other limiting features to the new
search, but I did get a huge laugh when I queried RDBMS 8.1.7 and got 500
patches returned (there are more but it only returned 500) - if you ever
wanted an idea of how many patches are out there, there's a good indication.
There's only 12 patchset/minipacks, though (lots of patches rolled into one,
I guess).
I did notice the new Beta search doesn't have an easily found feedback
button (it's back on page one), but I did fill out a long gripe to them :)
Enough ranting, back to trying to get around the search engines (both
newly-fixed-old and new-Beta-2.0) to find the patches I need.
Margaret

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

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



change global_name on 9i

2002-11-14 Thread Michael Barger
Oracle 9.2.0 on Solaris 2.8 - I've got global_name =
FALSE and db_domain =  - however I mistakenly issued
the command alter database rename global_name to
instance.world, and now I cannot get rid of it.

I've found the following on Metastink, but am
wondering if there is any other method of getting the
global_name back to instancename (without the .world)

This problem doesn't happen in 9i because a value NULL
for db_domain is allowed, therefore if you set in 9i
db_domain=, then you have a GLOBAL_NAME with only
db_name and you can rename global_name to include
domain and after rename it back without including
domain. 

Updating props$ manually is not a supported
workaround. 

Any help would be appreciated.

TIA,
mb


__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Barger
  INET: [EMAIL PROTECTED]

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



Re: Monitoring Unix Question

2002-11-14 Thread Connor McDonald
In V$PROCESS there is SPID (or something similar)
which is the OS pid.  Then, you can join to V$SESSION
on ADDR / PADDR 

hth
connor

 --- ecandrietta [EMAIL PROTECTED] wrote:  
 Friends :
 
 How can i do for get what is running inside a PID
 that is
 using a lot of CPU ?
 
 How can I get the query that is running inside the
 database
 according PID of unix ?
 
 I would like to know commands of the unix and the
 query that
 i need to run in the database for find out the
 problem.
 
 Regards
 
 Eriovaldo
 
 
 
 ---
 UOL, o melhor da Internet
 http://www.uol.com.br/
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: ecandrietta
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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



RE: e: when is an error msg not an error msg ?

2002-11-14 Thread Richard Ji
You could just tell cron to execute your .profile before executing
the pro*c program, thus you don't necessarily need a wrapper.

-Original Message-
Sent: Thursday, November 14, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Hello,

Thanks to all that replied.

Yes, it was an environmental issue. The Pro*C program was being executed
from cron without a wrapper, and cron being 'environmentally dumb' meant
that, despite the environment being properly set for the user, the job was
executed in a void. The developers will wrap the executable and all should
be okay afterwards.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 14, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L



This could happen when the ORACLE_HOME is not set correctly.
You may have the ORACLE_HOME in the .profile but your application
might be running from a script which unsets the ORACLE_HOME or
sets it incorrectly.
Hemanat
At 02:14 PM 13-11-02 -0800, you wrote:
Hello,

I've looked over hill and over dale at many web-sites (MetaLink, google,
asktom, etc.), to no avail, so could someone on the list bail me out on
this
question - what causes the following error message:

 ORACLE ERROR=Error while trying to retrieve text
for error ORA-03114

Now, I know what causes the 03114; I need to know why I am getting the
'error while trying to retrieve... I get this error on my test and
production servers, but not the development server. All have the same # of
files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing
somewhere that I know not of ? Any help would be greatly appreciated.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]

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

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

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

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

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



RE: CONSISTANT GETS

2002-11-14 Thread Hamid Alavi
Sorry for asking such a obvious question, but CONSISTANT GETS means calling
rows from Database

Thanks,

-Original Message-
Sent: Thursday, November 14, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L


Hamid,

I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the
calling application (or an aggregation of 800,000 rows), then the
statement we have done all the necessary tuning on all the SQL queries
is not yet true.

If your SQL does actually return about 800,000 rows, then it is time to
begin thinking about the mismatch between business processing
requirements and the logical structure of your data.

The answer to your problem is not in your instance parameters.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Alavi
Sent: Thursday, November 14, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L

Dear List,

I am monitoring a database,  I findout there is a transaction which
runing
a long time and others are waiting for this transaction, this
transaction
have 8,000,000 consistant gets with only 1 Physical I/O.
My question is, what I have to do except the SQL tuning to make this
transaction faster, we have done all the necessary tuning on all the SQL
query's.
Here is a copy of ora.ini:

Oracle 8.1.7.4   on sun solaris 2.8

background_dump_dest = /oracle/admin/cmstst/bdump
compatible = 8.1.7.4
control_files = /cmsdb/cmstst/control02.ctl
control_files = /oralogs1/cmstst/control03.ctl
control_files = /oracle/oradata/cmstst/control01.ctl
core_dump_dest = /oracle/admin/cmstst/cdump
db_block_buffers = 1??? this need to
increase?
db_block_lru_latches = 4
db_block_size = 8192
db_file_multiblock_read_count = 16
db_name = cmstst
hash_area_size = 2048000??? need tuning
???
instance_name = cmstst
java_pool_size = 20971520
large_pool_size = 614400
log_archive_dest_1 = location=/archlogs/cmstst
log_archive_format = arch%s.arc
log_archive_start = TRUE
log_buffer = 262144 ?? this log
buffer
is enough??
log_checkpoint_interval = 1 ?? 
log_checkpoint_timeout = 1800
max_enabled_roles = 30
open_cursors = 300
optimizer_index_caching = 90
optimizer_index_cost_adj = 35
os_authent_prefix = 
processes = 100
remote_login_passwordfile = EXCLUSIVE
session_cached_cursors = 100
shared_pool_size = 134217728
sort_area_retained_size = 262144
sort_area_size = 262144
timed_statistics = TRUE


I realy appreciate your help and assistant. I am getting confused, just
want
to know changing any of these parameter help the performance to reduce
the
number of CONSISTANT GETS or NOT???

Thanks in advance.



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement
=== 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or

using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement
=  


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

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

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

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





=== Confidentiality Statement === 
The information 

RE: dumping microsoft desktop?

2002-11-14 Thread David . Schmoldt

 Both answers a are expected to be No. The lawsuit is
 expected to be dropped. But who knows. They won
 antitrust case after all.
 
 Nick
 

I know it *seems* like they won, but Microsoft actually lost the antitrust
case. :-(

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

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



Re: renaming host

2002-11-14 Thread Stephane Faroult
David Turner wrote:
 
 Is there any way to tell what connect string an application is using to connect
 to the database? I want to rename a host but I know some developers are going to
 forget to change their connect strings and I would like to catch them before we
 rename the box.
 
 My plan is to:
 
 o create a new cname for the host
 
 o create a new tnsalias based on the cname
 
 o Have developers reconnect using the new tnsalias
 
 o Monitor for any connections that still use the old connect string, and
   tell developers they still need to change their connect string.
 
 o Monitor again
 
 o Rename box
 
 o Have all applications connecting using the new name.
 
 Dave
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: David Turner
   INET: [EMAIL PROTECTED]


If you do not change the alias, but keep the same alias pointing to the
new host name, you do not have to worry ...
-- 
Regards,

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

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



Re:RE: CONSISTANT GETS

2002-11-14 Thread dgoulet
Hamid,

This is one of those instances where I'll heartly agree with Cary in ALL
respects.  We run PeopleSoft and have found many a query that seems to spinn
around and around creating a pile of consistent gets and little if any IO.  The
problem that most often exists is that a coorrelated subquery is the last item
in the where clause or the first thing that Oracle does.  Damned nasty.  Check
your code over again and trace it.

Dick Goulet

Reply Separator
Author: Cary Millsap [EMAIL PROTECTED]
Date:   11/14/2002 10:34 AM

Hamid,

I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the
calling application (or an aggregation of 800,000 rows), then the
statement we have done all the necessary tuning on all the SQL queries
is not yet true.

If your SQL does actually return about 800,000 rows, then it is time to
begin thinking about the mismatch between business processing
requirements and the logical structure of your data.

The answer to your problem is not in your instance parameters.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Alavi
Sent: Thursday, November 14, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L

Dear List,

I am monitoring a database,  I findout there is a transaction which
runing
a long time and others are waiting for this transaction, this
transaction
have 8,000,000 consistant gets with only 1 Physical I/O.
My question is, what I have to do except the SQL tuning to make this
transaction faster, we have done all the necessary tuning on all the SQL
query's.
Here is a copy of ora.ini:

Oracle 8.1.7.4   on sun solaris 2.8

background_dump_dest = /oracle/admin/cmstst/bdump
compatible = 8.1.7.4
control_files = /cmsdb/cmstst/control02.ctl
control_files = /oralogs1/cmstst/control03.ctl
control_files = /oracle/oradata/cmstst/control01.ctl
core_dump_dest = /oracle/admin/cmstst/cdump
db_block_buffers = 1??? this need to
increase?
db_block_lru_latches = 4
db_block_size = 8192
db_file_multiblock_read_count = 16
db_name = cmstst
hash_area_size = 2048000??? need tuning
???
instance_name = cmstst
java_pool_size = 20971520
large_pool_size = 614400
log_archive_dest_1 = location=/archlogs/cmstst
log_archive_format = arch%s.arc
log_archive_start = TRUE
log_buffer = 262144 ?? this log
buffer
is enough??
log_checkpoint_interval = 1 ?? 
log_checkpoint_timeout = 1800
max_enabled_roles = 30
open_cursors = 300
optimizer_index_caching = 90
optimizer_index_cost_adj = 35
os_authent_prefix = 
processes = 100
remote_login_passwordfile = EXCLUSIVE
session_cached_cursors = 100
shared_pool_size = 134217728
sort_area_retained_size = 262144
sort_area_size = 262144
timed_statistics = TRUE


I realy appreciate your help and assistant. I am getting confused, just
want
to know changing any of these parameter help the performance to reduce
the
number of CONSISTANT GETS or NOT???

Thanks in advance.



Hamid Alavi
Office 818 737-0526
Cell818 416-5095






=== Confidentiality Statement
=== 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or

using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement
=  


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

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

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

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

Urgent : Shell Script is needed !!!!!

2002-11-14 Thread Reddy, Madhusudana
Title: Blank



Hello All,


I have to do automation of 
manual process of the following things, being not good at the Shell 
scripting , I need your help or at least a sample script would be great
Manual process:
1. get the oldest partition name 
from a partitioned table
2. create a non-partitioned table 
same as the oldest partition name from the partitioned table with the same 
structure
2. exchange the partition with the 
newly created table 
3. then export the new table to a 
Unix directory.

Later I have to drop the oldest partition .( For this we have a 
procedure to take care of )

Regards,
Madhu Reddy
Blank Bkgrd.gif

10046 Level 8 Trace file disappeared

2002-11-14 Thread Miller, Jay
After playing around with this in development for a while I just tried
setting Event 10046, Level 8 trace on a production process that was taking
too long to run.
 
Everything went smoothly, the trace file was being written to, when suddenly
the trace file disappeared.  The last time I checked it was a little over 2
Meg but I had max file size set to 2 Gig.  All the space was freed up
according to df -k.
 
I tried setting the event to level 0 and back to level 8 but there was still
no trace file.  The session was still running.
 
Here's what I ran:
 
exec sys.dbms_system.set_bool_param_in_session(265, 16097,
'timed_statistics', true);
exec sys.dbms_system.set_int_param_in_session(265, 16097,
'max_dump_file_size', 2147483647);
exec sys.dbms_system.set_ev(265,16097,10046, 8, '');
 
I'm on Oracle 8.1.7.2, Solaris 2.6.
 
Does anyone have any ideas as to what might have happened to my file?
 
 
Thanks,
Jay Miller
x48355
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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



WAIT EVENTS?

2002-11-14 Thread Seema Singh
Hi,
I have been noticing db file scattered read and
db file sequential read  with one of instance.
Does increasing parameter DB_FILE_MULTIBLOCK_READ_COUNT would help or not?
regarding db file sequential read what to do? without striping the files 
across the disk?
A sequential read is a single-block read which read  data into contiguous 
memory space.

WIth another instance  I am looking control file parallel write wait 
events.
Does changing the location of control file would help?
Thx
-Seema




_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

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


RE: dumping microsoft desktop?

2002-11-14 Thread Gogala, Mladen
Yes. They are, legally, a monopoly. Government has already
apologized for all the nuisance that has created for Microsoft
and promised to bring rebellious PC dealers to their senses by
using special forces, if necessary.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:David.Schmoldt;gazettecommunications.com]
 Sent: Thursday, November 14, 2002 3:15 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: dumping microsoft desktop?
 
 
 
  Both answers a are expected to be No. The lawsuit is
  expected to be dropped. But who knows. They won
  antitrust case after all.
  
  Nick
  
 
 I know it *seems* like they won, but Microsoft actually lost 
 the antitrust
 case. :-(
 
 Dave
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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



RE: RE: dumping microsoft desktop?

2002-11-14 Thread Gogala, Mladen
Well, once upon a time there was an event called Boston Tea Party
which dealt with too expensive product of low quality delivered by 
a monopoly. I wonder whether we can expect Seattle Windows Party?
Would that be too cruel to the fish in Seattle harbor?

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:dgoulet;vicr.com]
 Sent: Thursday, November 14, 2002 3:44 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re:RE: dumping microsoft desktop?
 
 
 David,
 
 Just like beauty, winning or loosing in a lawsuit is in 
 the eye of the
 beholder.  Actually in MicroSlop's case it was the justice 
 department that
 bailed and more than likely King George who sat on the judge. 
  You got to love
 those political action committees and their BIG donors!!  In 
 politics money
 talks louder than anything else.
 
 Dick Goulet
 
 Reply Separator
 Author: [EMAIL PROTECTED]
 Date:   11/14/2002 12:15 PM
 
 
  Both answers a are expected to be No. The lawsuit is
  expected to be dropped. But who knows. They won
  antitrust case after all.
  
  Nick
  
 
 I know it *seems* like they won, but Microsoft actually lost 
 the antitrust
 case. :-(
 
 Dave
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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



Query to predict failure on second extent of segment

2002-11-14 Thread Jesse, Rich
Hi all,

Until a whole mass of astrological confluences happen, I'm stuck with
dictionary-managed tablespaces on 8.1.7 on HP/UX 11.0.  And we're having
some space/growth issues right now that I want (need!) to be more proactive
with.  So, based on several factors -- most political -- I want to run a
daily report that tells me when a segment will not be able to extend twice.
(We're already running the single extent failure hourly.)

After looking on the net, I found some queries to do this, but all I saw
were severely flawed.  So, I rolled my own.  The only problem I can see with
it for dictionary TSs is when the RANK() has multiple matches for first and
second (e.g. TS MY_BIG_TS has it's largest contiguous free spaces of 40M,
10M, and 10M).  Unfortunately, I'm stumped as to how to prevent this.

Anyone care to comment on this load of SQueaL?  Thx!  :)

Rich

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



SELECT ds.owner, ds.segment_name, ds.segment_type, ds.tablespace_name,
ds.next_extent/1024 Next ext, fs2.max_free/1024 Max Free,
fs2.min_free/1024 2nd Max Free, fs2.free_spaces
FROM dba_segments ds,
(
SELECT tablespace_name, MAX(bytes) max_free, MIN(bytes) min_free,
count(*) free_spaces
FROM
(
SELECT tablespace_name, bytes,
RANK() OVER (PARTITION BY tablespace_name
ORDER BY tablespace_name, bytes DESC)
byte_rank
FROM dba_free_space
)
WHERE byte_rank  3
GROUP BY tablespace_name
) fs2
WHERE ds.segment_type IN ('INDEX','TABLE')
AND fs2.tablespace_name = ds.tablespace_name
AND (
((ds.next_extent  fs2.min_free OR fs2.free_spaces  2)
AND ds.next_extent*2  fs2.max_free)
OR ds.next_extent  fs2.max_free
)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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



Re:RE: dumping microsoft desktop?

2002-11-14 Thread dgoulet
David,

Just like beauty, winning or loosing in a lawsuit is in the eye of the
beholder.  Actually in MicroSlop's case it was the justice department that
bailed and more than likely King George who sat on the judge.  You got to love
those political action committees and their BIG donors!!  In politics money
talks louder than anything else.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   11/14/2002 12:15 PM


 Both answers a are expected to be No. The lawsuit is
 expected to be dropped. But who knows. They won
 antitrust case after all.
 
 Nick
 

I know it *seems* like they won, but Microsoft actually lost the antitrust
case. :-(

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

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

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



RE: Monitoring Unix Question

2002-11-14 Thread Stephen Lee
If you have the top utility installed on the Unix box, this makes an easy
to use interface to identify CPU hogs.  For non-root users to run it, your
sys admin might have to change default permissions on certain files such
as /dev/kmem; or possibly make top SUID root.

If you don't have top, or you can't run it as non-root, you can try using
the following ps command to sort things by %CPU, but I think there might be
differences among OS's on some of the more exotic ps and sort options:

ps -eo pid -o %cpu | sort -rk2 | head -20

After you have identified which PID is the hog, and can see that it is a
dedicated server process, you can run something like the following to match
SID  SERIAL# to the correct OS process ID.  If you must brutally kill the
process, kill the session in the database, then kill the pid in the OS.

set linesize whatever_you_like
set pagesize whatever_you_like

col username format a15
col osuser format a15

select s.username,
   s.osuser,
   s.sid,
   s.serial#,
   s.process USER PRCS,
   p.spid SVR PRCS
  from v$process p,v$session s
  where p.addr = s.paddr
  and s.username  ' '
/


 -Original Message-
 From: ecandrietta [mailto:ecandrietta;uol.com.br]
 Sent: Thursday, November 14, 2002 1:20 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Monitoring Unix Question 
 
 
 
 Friends :
 
 How can i do for get what is running inside a PID that is 
 using a lot of CPU ?
 
 How can I get the query that is running inside the database 
 according PID of unix ?
 
 I would like to know commands of the unix and the query that 
 i need to run in the database for find out the problem.
 
 Regards
 
 Eriovaldo
 
 
  
 ---
 UOL, o melhor da Internet
 http://www.uol.com.br/
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: ecandrietta
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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



Re: Urgent : Shell Script is needed !!!!!

2002-11-14 Thread Stephane Faroult
 Reddy, Madhusudana wrote:
 
 Hello All,
 
 
 I have to do automation of manual process of the following things,
 being not good at the Shell scripting , I need your help or at least a
 sample script would be great
 
 Manual process:
 
 1. get the oldest partition name from a partitioned table
 
 2. create a non-partitioned table same as the oldest partition name
 from the partitioned table with the same structure
 
 2. exchange the partition with the newly created table
 
 3. then export the new table to a Unix directory.
 
 
 
 Later I have to drop the oldest partition .( For this we have a
 procedure to take care of )
 
 
 
 Regards,
 
 Madhu Reddy
 

Hint : do most of it as a SQL script rather than a shell script. 
-- 
Regards,

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

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



NULL storage in CHAR fields

2002-11-14 Thread Jesse, Rich
Hey all,

In 8.1.7, does Oracle reserve (x) bytes for a CHAR(x) field if the field is
NULL?  A dev wants to NON NULL a key field, and I'd like to better be able
to predict the effects on the table of inserting a space (indexes have
already been considered).

TIA!

Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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



low buffer hit ratio

2002-11-14 Thread Gurelei
Hi.

I found a query with a buffer hit ratio about 60%:
SELECT b.Name, a.Racf, c.Manager,  fileds from STATS
table
FROM BT.Stats a, BT.Employees b, BT.Employees c
WHERE a.Stats_Date Between '13-Nov-02' and '13-Nov-02'
and a.Manager = c.Manager and
c.racf = 'RLEWI01' and b.Racf = a.Racf
and ( Product='RTI' OR Product = 'RIM' ...  or Product
= 'WEB')
Group by b.Name, a.Racf, c.Manager Order by b.Name

Here is the plan under oracle 7.3.3 rbo:

1.0 SELECT STATEMENT   (, , )
  2.1 SORT GROUP BY  (, , )
3.1 NESTED LOOPS   (, , )
  4.1 NESTED LOOPS   (, , )
5.1 TABLE ACCESS BY ROWID EMPLOYEES (, , )
  6.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , )
5.2 TABLE ACCESS BY ROWID STATS (, , )
  6.1 INDEX RANGE SCAN STATS_FK2 (, , )
  4.2 TABLE ACCESS BY ROWID EMPLOYEES (, , )
5.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , )

The largest table is STATS - 1.6 mil rows. STATS_FK2
is
an index on MANAGER field. We have only 115 different
managers so the index is not very selective. The
stats_date field is more selective. Does it make sence
for me to force Oracle to use that index in order to
reduce the number of disk reads?

thanks

Gene





__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: combine or not combine into one database?

2002-11-14 Thread Tao_Zuo
I send a e-mail to the address and get no respond so far.  Any other 
solution?  Thanks a lot.  - Tao

-Original Message-
Sent: Tuesday, November 12, 2002 7:19 AM
To: ORACLE-L


Tao - I believe you send any mail to:
 mailto:lawson_sysadmin-subscribe;topica.com 

If that doesn't work, let me know.

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

-Original Message-
Sent: Monday, November 11, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L


Thanks a lot for you info.  Do you know how I can subscribe the Lawson 
email list?  Thanks again.

-Original Message-
Sent: Monday, November 11, 2002 2:59 PM
To: ORACLE-L


Tao - If I understand your situation, you currently have 3 separate
databases, 2 separate Lawson databases and another OEM database?
You can combine your two Lawson databases, but you'll need to
develop a careful project plan. Right now your Lawson HR database 
probably
sends data to your Lawson GL system, so that needs looked at before you 
do
the combination. There is a Lawson email list that can answer that 
question
in more detail.
Is the OEM repository and historical database more of a data
warehouse or OLTP system? Data warehouses tend to have spikey usage and
don't play well with OLTP databases such as your Lawson system. I would 
tend
to keep it separate just based on the limited information you've 
provided.

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


-Original Message-
Sent: Monday, November 11, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I would like to know any advantage and disadvantage to combine the 
following databases into one:

Finance in Lawson
HR in Lawson
OEM repository and historical database

Any comments are very appreciated.



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

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

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

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

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

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

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

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

RE: Urgent : Shell Script is needed !!!!!

2002-11-14 Thread Kevin Lange
Title: Blank



Madhu
 Three years ago we wrote a system 
that would except files from an outside data system, take those files and , in a 
rotating 18 month cycle, load the data into a partitioned view  dropping the 
oldest set of data and adding the next set in its place.

Ifs 
complicated, but if you think you might be interested in looking thru it to make 
your own,I can find the SQL code and UNIX code that went with 
it.

If you would be interested, 
contact me offline at [EMAIL PROTECTED] . I will 
need to take the time to find the code outside of work.

Kevin
-Original Message-From: 
Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: 
Thursday, November 14, 2002 2:50 PMTo: Multiple recipients of list 
ORACLE-LSubject: Urgent : Shell Script is needed 
!

  Hello All,
  
  
  I have to do automation of 
  manual process of the following things, being not good at the Shell 
  scripting , I need your help or at least a sample script would be great
  Manual process:
  1. get the oldest partition name 
  from a partitioned table
  2. create a non-partitioned 
  table same as the oldest partition name from the partitioned table with the 
  same structure
  2. exchange the partition with 
  the newly created table 
  3. then export the new table to 
  a Unix directory.
  
  Later I have to drop the oldest partition .( For this we have a 
  procedure to take care of )
  
  Regards,
  Madhu 
Reddy


RE: e: when is an error msg not an error msg ?

2002-11-14 Thread Jared . Still
That's not always a good idea.  Their may be settings in your .profile 
that
don't play well with cron.

Best to setup an account especially for cron jobs, and include only what 
is
necessary in the .profile.

Jared





Richard Ji [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/14/2002 11:48 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: e: when is an error msg not an error msg ?


You could just tell cron to execute your .profile before executing
the pro*c program, thus you don't necessarily need a wrapper.

-Original Message-
Sent: Thursday, November 14, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Hello,

Thanks to all that replied.

Yes, it was an environmental issue. The Pro*C program was being executed
from cron without a wrapper, and cron being 'environmentally dumb' meant
that, despite the environment being properly set for the user, the job was
executed in a void. The developers will wrap the executable and all 
should
be okay afterwards.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 14, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L



This could happen when the ORACLE_HOME is not set correctly.
You may have the ORACLE_HOME in the .profile but your application
might be running from a script which unsets the ORACLE_HOME or
sets it incorrectly.
Hemanat
At 02:14 PM 13-11-02 -0800, you wrote:
Hello,

I've looked over hill and over dale at many web-sites (MetaLink, google,
asktom, etc.), to no avail, so could someone on the list bail me out on
this
question - what causes the following error message:

 ORACLE ERROR=Error while trying to retrieve 
text
for error ORA-03114

Now, I know what causes the 03114; I need to know why I am getting the
'error while trying to retrieve... I get this error on my test and
production servers, but not the development server. All have the same # 
of
files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file 
missing
somewhere that I know not of ? Any help would be greatly appreciated.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]

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

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

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

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

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

Re: RE: How-To or Good Practices on Code Releases

2002-11-14 Thread Jared . Still
You now have an excellent argument for disabling developer 
access to production databases.

Jared






chao_ping [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/14/2002 03:08 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: RE: How-To or Good Practices on Code Releases


Rajesh.Rao,
 I have the same experience. Developers 
directly connected to production database and added a column with default 
table on a huge table. The whole table is locked for 1 hour and other 
transaction failed.
 Add a column with non default value and 
then later add default value for it can be done in 1 second.
 Developers do not Know how oracle do it 
and just go on. New application going online without volume testing, 
getting online and as a production dba,i search for the bad sql and trace 
it out and send it back to developer!
 That is why many project fail, the app is 
designed and developed without the attendence of a guy who really knows 
oracle.





Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)

=== 2002-11-13 12:06:00 ,you wrote£º===

I also have been burnt by an simple alter table add column default 
string
script. A pretty simple script. The developers tested it, the QA team too
approved it. Was expected to run in a matter of minutes. The problem was
the data in production was 100 times over. Missed out on volume testing.
Took 2 cuppas and 3 smokes before it was done.

Raj




  
Magaliff, Bill   
Bill.Magaliff@lenTo: Multiple recipients 
of list ORACLE-L ORACLE-L@fatcitS

= = = = = = = = = = = = = = = = = = = =
 



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

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



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

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



RE: RE: dumping microsoft desktop?

2002-11-14 Thread David . Schmoldt
We just received a request from our CEO to do research on using Open Office
or Star Office as an alternative to Microsoft Office for our non-power
users.

So maybe there is an ultimate justice that can't be bought out or voted in
(like the anti-trust case).

 -Original Message-
 From: Gogala, Mladen [mailto:MGogala;oxhp.com]
 Sent: Thursday, November 14, 2002 3:39 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: RE: dumping microsoft desktop?
 
 
 Well, once upon a time there was an event called Boston Tea Party
 which dealt with too expensive product of low quality delivered by 
 a monopoly. I wonder whether we can expect Seattle Windows Party?
 Would that be too cruel to the fish in Seattle harbor?
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:dgoulet;vicr.com]
  Sent: Thursday, November 14, 2002 3:44 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re:RE: dumping microsoft desktop?
  
  
  David,
  
  Just like beauty, winning or loosing in a lawsuit is in 
  the eye of the
  beholder.  Actually in MicroSlop's case it was the justice 
  department that
  bailed and more than likely King George who sat on the judge. 
   You got to love
  those political action committees and their BIG donors!!  In 
  politics money
  talks louder than anything else.
  
  Dick Goulet
  
  Reply Separator
  Author: [EMAIL PROTECTED]
  Date:   11/14/2002 12:15 PM
  
  
   Both answers a are expected to be No. The lawsuit is
   expected to be dropped. But who knows. They won
   antitrust case after all.
   
   Nick
   
  
  I know it *seems* like they won, but Microsoft actually lost 
  the antitrust
  case. :-(
  
  Dave
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gogala, Mladen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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



RE: low buffer hit ratio

2002-11-14 Thread DENNIS WILLIAMS
Gurelei - What do you mean by a low buffer hit ratio for a SQL statement?
BHR is measured for the system, not for an individual query. 
   Why have you singled this query out for attention? Are there complaints
about its performance? Does it hit more blocks that other queries on your
system?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, November 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Hi.

I found a query with a buffer hit ratio about 60%:
SELECT b.Name, a.Racf, c.Manager,  fileds from STATS
table
FROM BT.Stats a, BT.Employees b, BT.Employees c
WHERE a.Stats_Date Between '13-Nov-02' and '13-Nov-02'
and a.Manager = c.Manager and
c.racf = 'RLEWI01' and b.Racf = a.Racf
and ( Product='RTI' OR Product = 'RIM' ...  or Product
= 'WEB')
Group by b.Name, a.Racf, c.Manager Order by b.Name

Here is the plan under oracle 7.3.3 rbo:

1.0 SELECT STATEMENT   (, , )
  2.1 SORT GROUP BY  (, , )
3.1 NESTED LOOPS   (, , )
  4.1 NESTED LOOPS   (, , )
5.1 TABLE ACCESS BY ROWID EMPLOYEES (, , )
  6.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , )
5.2 TABLE ACCESS BY ROWID STATS (, , )
  6.1 INDEX RANGE SCAN STATS_FK2 (, , )
  4.2 TABLE ACCESS BY ROWID EMPLOYEES (, , )
5.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , )

The largest table is STATS - 1.6 mil rows. STATS_FK2
is
an index on MANAGER field. We have only 115 different
managers so the index is not very selective. The
stats_date field is more selective. Does it make sence
for me to force Oracle to use that index in order to
reduce the number of disk reads?

thanks

Gene





__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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



Naming Conventions....

2002-11-14 Thread Shibu MB



Hi 
all...

 
What are the naming conventions u guys follow when designing a database 
???.Can anybody send me a general document on this. I am trying to 
make the attribute name unique in my database but i 
dunno what naming convention i have to follow for this 
.. I have tried all kinda combinations but some 
how the names are not coming unique and because of this  
the developers may get confused know ... so please tell me 
what naming convention are followed by u DBA s 



Thanks
Shibu