from:"Deshpande, Kirti"

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Deshpande, Kirti

In 9i Release 2 :
  
 exec dbms_stats.flush_database_monitoring_info 

Nothing of the sort in earlier releases... 

- Kirti 

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


Oh joy!  The ABORT argument again!  ;)

Is there a way to flush table monitoring counts before the ABORT, either in
8i or 9i?


Rich

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Deshpande, Kirti

Precisely.
I am trying to propose the abort option, but I am not the majority around this place I 
call work.. :)
 
On a more than dozen times in the last few months, I had to kill oracle processes to 
get the database to shutdown (with immediate), so the scheduled reboot of the machine 
will continue... And on a number of occasions, the Sunday reboot actually took the 
server down (and brought it up) on Monday mornings when users complained that they 
could not get to databases that were shutdown properly with 'shutdown immediate'.  

- Kirti 

-Original Message-
Sent: Thursday, April 03, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L


the problem is, if immediate hangs and you have automated the
process... nothing happens. it doesn't time out so you sit. and sit and
sit. and hope that whatever is keeping the database active will
eventually end.

In version 7 (7.3.2) I found that while using a third party monitoring
package that had a job in the job queue that ran frequently enough (and
you WANT monitoring software to monitor things!) that we could never
use a shutdown immediate


--- Pardee, Roy E [EMAIL PROTECTED] wrote:
 I am certainly not suggesting that recovery can't handle a crash--I'm
 just
 trying to make sure that I understand what shutdown abort does.  Some
 posts
 have implied that it's no big deal, which is counter-intuitive to me.
  To
 me, crashing a program on purpose seems like a drastic measure.  No
 doubt
 desperate times can call for desperate measures, but I would have
 guessed
 that optimally, you'd try immediate first  then abort if immediate
 takes
 too long.  But I'm just learning this stuff...
 
 Cheers,
 
 -Roy
 
 Roy Pardee
 Programmer/Analyst
 SWFPAC Lockheed Martin IT
 Extension 8487
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti

I was told that the tool creates, and uses, SPFILE after the upgrade... 

- Kirti


-Original Message-
Sent: Wednesday, April 02, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L


I used it recently on a W2K box, worked fine, no problems, no
hassles... took a while to do the upgrade so don't panic if it seems to
be taking a long time


--- Vladimir Barac [EMAIL PROTECTED] wrote:
 Hi
 
 I'm about to upgrade 8.1.7 db to 9.2 db.
 
 Platform is AIX.
 
 Database Upgrade Assistant is going to be used. Does anyone have
 any bad experience with this oracle tool? Or the whole process is
 straight forward?
 
 Thanks,
 Vladimir Barac


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti

Igor,
 It depends. 
 If you are not aware of what the tool does, you will get caught by surprise (like my 
co-worker;) May be there is an option to not create the SPFILE.. I didn't use the tool 
when I upgraded a few my databases to 9i. 
 But, AFIAC, I am staying away from SPFILE, as long as possible, for my own 
reasons.. 

- Kirti 

-Original Message-
Sent: Wednesday, April 02, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Kirti,

Is it a bad thing?

Igor   


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:28 AM


 I was told that the tool creates, and uses, SPFILE after the upgrade... 
 
 - Kirti
 
 
 -Original Message-
 Sent: Wednesday, April 02, 2003 7:09 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I used it recently on a W2K box, worked fine, no problems, no
 hassles... took a while to do the upgrade so don't panic if it seems to
 be taking a long time
 
 
 --- Vladimir Barac [EMAIL PROTECTED] wrote:
  Hi
  
  I'm about to upgrade 8.1.7 db to 9.2 db.
  
  Platform is AIX.
  
  Database Upgrade Assistant is going to be used. Does anyone have
  any bad experience with this oracle tool? Or the whole process is
  straight forward?
  
  Thanks,
  Vladimir Barac
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 Mail

2003-04-01 Thread Deshpande, Kirti

Thanks for the information, Ron. 
I will check it out in due course of time. I was more interested in knowing if anyone 
has done this migration. As Dick mentioned, we are interested in finding out if there 
is any $$ savings, and how much, and at what cost (of deployment etc etc)..

These days Oracle is running some interesting Radio Ads related to Oracle Mail and 
Collaborative Suites, and it appears some of the Damagers types have heard it (and 
probably liked it too) 

- Kirti 

-Original Message-
Sent: Tuesday, April 01, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L


Dick,
 check out this link
http://www.oracle.com/jsp/events/EventsDetail.jsp?p_eventId=9595src=1544227src=1544227Act=183

it is the link top the OTN events about just what you are talking
about.
If your lucky you can get the slide show that did the comparisons
between Oracle and MS per user per year.
Ron

 [EMAIL PROTECTED] 04/01/03 04:08PM 
Kirti,

Can I add to your request?

I'd appreciate knowing of anyone who migrated to collaborative
suite instead of Exchange and if there was a $$ difference how much it
was and which way.  Also if you did make the move from Exchange to
Collaborative did you save any money in the process?


Dick Goulet

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


Hello All,

 Anyone migrated to Oracle Mail from MS Exchange Server?  Care to share
the experience?  

 I was asked about it. I have no idea how it works. I am trying to
gather as much info as possible from Oracle.com, Google  etc.. 

 Thanks.

- Kirti 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: sysresv doesn't work on AIX

2003-03-27 Thread Deshpande, Kirti

Interesting... 
It works for me on AIX 

oracle rs015 [DBMP]: oslevel
4.3.3.0

oracle rs015 [DBMP]: sysresv -l DBMP DBCP

IPC Resources for ORACLE_SID DBMP :
Shared Memory:
ID  KEY
262150  0x566bfa00
Oracle Instance alive for sid DBMP

IPC Resources for ORACLE_SID DBCP :
Shared Memory:
ID  KEY
7   0xa086ab38
Oracle Instance alive for sid DBCP


But if I tried a non-existent SID name:

oracle rs015 [DBMP]: sysresv -l junk

IPC Resources for ORACLE_SID junk :
Shared Memory
ID  KEY
No shared memory segments used
Oracle Instance not alive for sid junk

HTH,

- Kirti 


-Original Message-
Sent: Thursday, March 27, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L


I was logged in as oracle, owner of the shared segments.

Peter Schauss

-Original Message-
Sent: Wednesday, March 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L


Login as the owner of the shared mem segments and run it.

It just worked for me on RH 7.2 with 8.1.7

Jared






Schauss, Peter [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 03/26/2003 12:33 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:sysresv doesn't work on AIX


Poking around metalink I found a reference to a utility called
sysresv (note 123322.1).  According to the document it 
displays the id and key for each for the shared memory segments
which the Oracle instances have created.

I tried it on an AIX 4.3 system running three Oracle instances and it
does not work.

Example:

# sysresv -l vdev delmia ngcdev

IPC Resources for ORACLE_SID vdev :
Shared Memory
ID  KEY
No shared memory segments used
Oracle Instance not alive for sid vdev

IPC Resources for ORACLE_SID delmia :
Shared Memory
ID  KEY
No shared memory segments used
Oracle Instance not alive for sid delmia

IPC Resources for ORACLE_SID ngcdev :
Shared Memory
ID  KEY
No shared memory segments used
Oracle Instance not alive for sid ngcdev

If I do Aipcs -m | grep oracle

I get:

m   1179648 0xf50105e0 --rw-r-   oracle oinstall
m   1179649 0xfa5fbc28 --rw-r-   oracle oinstall
m 2 0x02da4bbc --rw-r-   oracle oinstall

Anyone else have similar experiences?

Thanks,
Peter Schauss
Northrop Grumman Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: sysresv doesn't work on AIX

2003-03-27 Thread Deshpande, Kirti

No, it should not matter.

Are you signed on as 'oracle' ? 
I see the prompt is: # (typically for root). 


- Kirti 

-Original Message-
Sent: Thursday, March 27, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


My ORACLE_SIDs are lower case.  Does that make a difference.

bvdesi02 # oslevel
4.3.2.0
bvdesi02 # sysresv -l vdev

IPC Resources for ORACLE_SID vdev :
Shared Memory
ID  KEY
No shared memory segments used
Oracle Instance not alive for sid vdev

Peter Schauss

-Original Message-
Sent: Thursday, March 27, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L


Interesting... 
It works for me on AIX 

oracle rs015 [DBMP]: oslevel
4.3.3.0

oracle rs015 [DBMP]: sysresv -l DBMP DBCP

IPC Resources for ORACLE_SID DBMP :
Shared Memory:
ID  KEY
262150  0x566bfa00
Oracle Instance alive for sid DBMP

IPC Resources for ORACLE_SID DBCP :
Shared Memory:
ID  KEY
7   0xa086ab38
Oracle Instance alive for sid DBCP


But if I tried a non-existent SID name:

oracle rs015 [DBMP]: sysresv -l junk

IPC Resources for ORACLE_SID junk :
Shared Memory
ID  KEY
No shared memory segments used
Oracle Instance not alive for sid junk

HTH,

- Kirti 


-Original Message-
Sent: Thursday, March 27, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L


I was logged in as oracle, owner of the shared segments.

Peter Schauss

-Original Message-
Sent: Wednesday, March 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L


Login as the owner of the shared mem segments and run it.

It just worked for me on RH 7.2 with 8.1.7

Jared





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

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

RE: Upgrade to AIX 5.2

2003-03-27 Thread Deshpande, Kirti

Joan,
 From what I have found Oracle 9.2 64-bit can be run in a 32-bit mode on AIX 5L. 
 So, one can have 5L running Oracle 8.1.7.4 and 9.2.0 in 32-bit modes. However, the 
H/W running AIX must be 64-bit. 
 Please see note # 169426.1. 

 Let us know what Oracle support has to say. 

 Cheers!

- Kirti 

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


Kirti,

I did some home work toward our near future upgrading from aix 4.3.3 to
5.1 and 817.4-32 bit to 9i2-64 bit. (8 servers)  Note:206569.1 and
Note:223521.1 on which said
  -When running oracle8i 32-bit on aix 5l, the machine must be booted
with the 
  32-bit kernel. this restriction doesn't apply to oracle 9.2 64-bit. Is
that 
  mean 9i-64 bit can coexist with 8.1.7 32-bit with the 32-bit kernet on
aiz 5L? I opened a tar with oracle support, want to clear that out. I
thought 817 and 9i can not coexisted on aix 5L.

Thanks,

joan

Deshpande, Kirti wrote:
 
 Tracy,
  We are still debating this issue with our preferred App Vendor...
 
  Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue.
 
  Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, 
 as *none* of the new features of 9i would be used by the Vendor. Sad but true. There 
 will be more testing time allocated to 9i/AIX 5L update, as several other software 
 pieces would be tested for the first time with that combination. We will need to 
 install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same 
 ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet.
 
  If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L,  this would have been a 
 bit simpler...
 
 Regards,
 
 - Kirti
 
 -Original Message-
 Sent: Thursday, February 27, 2003 1:36 PM
 To: Multiple recipients of list ORACLE-L
 
 John/Kirti,
 We are in the same boat with you.  However, we were looking to first upgrade to
 AIX 5L first and leave our existing 8.1.7 32-bit databases (booting the server
 in 32 bit mode).  In a subsequent phase we would upgrade 8.1.7 32-bit to 9.2
 64-bit.  The downside to this is that it will affect all databases on the
 server.  We would need to test the complexity/timing/risk to determine if this
 is the appropriate choice.  Kirti, with the option that you are leaning
 towards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L
 (there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3
 to 9.2/5L.  Do you know what effort is involved in that transition?  Is it
 complex/time consuming or just pointing to a new oracle_home? Thanks
 
02/27/2003 05:43 AM PST
 
 Please respond to [EMAIL PROTECTED]
 
 Sent by:[EMAIL PROTECTED]
 
 To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:
 
 It appears that way. We are also pondering on this upgrade as well.
 
 But if one takes this route, that is, running 5L in 32-bit mode, one can not
 install 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX
 5L. It is not planned to be available, either.
 
 So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OS
 to AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 later
 this year)..
 
 - Kirti
 
 -Original Message-
 Sent: Thursday, February 27, 2003 7:09 AM
 To: Multiple recipients of list ORACLE-L
 
 So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode???
 
 John
 
 -Original Message-
 Sent: 27 February 2003 12:24
 To: Multiple recipients of list ORACLE-L
 
 Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7
 (8i) On IBM AIX -Based Systems
 
 
 
 
 Operating System: IBM AIX -Based Systems Version 5.2 (5L)
 Oracle Server - Enterprise Edition Version 8.1.7 (8i)
 N/A Version N/A
 Status: Certified
 
 Product Version Note:
 
 Terminal Oracle8i release
 To obtain Patch Sets from MetaLink, click the Patches button to the left.
 Certification Note:
 
 Existing patch sets:
  8.1.7.1.0  (without JDBC),
  8.1.7.1.0b (includes JAVAVM, Context and JDBC),
  8.1.7.2.0
  8.1.7.3.0
  8.1.7.4.0
 
 Oracle 8i 32-bit on AIX 5L (5.1  5.2)
 Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bit
 mode. This mode is not supported, as Oracle 8i uses at least one 32-bit
 kernel extension. AIX-based systems must be booted with kernels in 32-bit
 mode.
 
 Warning about missing crash during installation of Oracle 8i.
 The error message crash: not found may appear during execution of
 rootpre.sh on AIX 5L. This warning may be ignored. Alternatively, the
 warning can be avoided by creating the following script and renaming it to
 /usr/sbin/crash:
 #!/bin/ksh
 read input
 if [ X$input = Xle ]; then
  echo lke | /usr/sbin/kdb | \
  /usr/bin/awk '/^ *[0-9]+/ {printf(LoadList entry at 0x%s\n

RE: events number and meaning

2003-03-26 Thread Deshpande, Kirti




1. Assuming Wait Events: 

 Please check the 
Database Server Reference Guide for the respective release. Also check www.oraperf.com, there a list of wait events 
by Oracle Versions. Free membership is required. 

2. Using triggers at database 
level. 
 for 
example:
 create or replace trigger 
trig_mystoredproc
 after startup on database. 

 declare 
  

 begin 
 
-- your code, calls to other procs... etc 
 end;
/

HTH,

- Kirti 

  -Original Message-From: Paulo Gomes 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 26, 2003 6:09 
  AMTo: Multiple recipients of list ORACLE-LSubject: FW: 
  events number and meaning
  
  -Original Message-From: Paulo Gomes Sent: 
  quarta-feira, 26 de Março de 2003 11:17To:Subject: 
  events number and meaning
  
  Hi guys.
  
  Where can i find a list of 
  Oracle Db (8i, 9i and 9iR2) events and menning?
  
  and by the way how can i fire 
  a Stored procedure if a event (ex.: Shutdown or Startup) is 
  ocurring?
  
  Thanks
  
  PG

RE: find on unix

2003-03-25 Thread Deshpande, Kirti




Ignore 
that.. 
It 
will find newer files, not older files..
I 
misread the question. Sorry..

- 
Kirti 

  -Original Message-From: Deshpande, Kirti 
  Sent: Tuesday, March 25, 2003 1:39 PMTo: 
  '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: 
  RE: find on unix
  Create a 'flag' filewiththe 'particular'date as its 
  last modified date:
  
   touch -t 200303201330.40 oldfile 
  
  
  The 
  timestamp is of the format:MMDDHHMM.SS 
  
  Then 
  use find command to find files newer (later) than oldfile. 

  
   find . -newer oldfile -print 
  
  HTH,
  
  - 
  Kirti
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 10:39 
AMTo: Multiple recipients of list ORACLE-LSubject: 
find on unix
How to use "find" command on unix to find files 
older then (created ) a particular date .
Any idea

-ak

RE: find on unix

2003-03-25 Thread Deshpande, Kirti




Changing 'find' to following would work:

find . ! -newer oldfile -print 

- 
Kirti 


  -Original Message-From: Deshpande, Kirti 
  Sent: Tuesday, March 25, 2003 1:50 PMTo: 
  '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: 
  RE: find on unix
  Ignore that.. 
  It 
  will find newer files, not older files..
  I 
  misread the question. Sorry..
  
  - 
  Kirti 
  
-Original Message-From: Deshpande, Kirti 
Sent: Tuesday, March 25, 2003 1:39 PMTo: 
'[EMAIL PROTECTED]'Cc: 
'[EMAIL PROTECTED]'Subject: RE: find on 
unix
Create a 'flag' filewiththe 'particular'date as its 
last modified date:

 touch -t 200303201330.40 oldfile 


The timestamp is of the format:MMDDHHMM.SS 


Then use find command to find files newer (later) than oldfile. 


 find . -newer oldfile -print 

HTH,

- 
Kirti

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 
  10:39 AMTo: Multiple recipients of list 
  ORACLE-LSubject: find on unix
  How to use "find" command on unix to find 
  files older then (created ) a particular date .
  Any idea
  
  -ak

RE: find on unix

2003-03-25 Thread Deshpande, Kirti




Create 
a 'flag' filewiththe 'particular'date as its last modified 
date:

 touch -t 200303201330.40 oldfile 


The 
timestamp is of the format:MMDDHHMM.SS 

Then 
use find command to find files newer (later) than oldfile. 

 find . -newer oldfile -print 

HTH,

- 
Kirti

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 10:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: find 
  on unix
  How to use "find" command on unix to find files 
  older then (created ) a particular date .
  Any idea
  
  -ak

RE: Script to check for errors

2003-03-21 Thread Deshpande, Kirti

Check Tim Gorman's web site, http://www.evdbt.com/tools.htm. He has a script 
(chk_oerr.sh) to monitor alert.log for new ORA- errors and e-mail. 
You can see how it is done and come up with your own version for your own 
requirements. 

- Kirti


-Original Message-
Sent: Friday, March 21, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


Anyone have a simple script to scan an alert
log for errors and email a report if found?

Customer wants something to run often, but only
email when an error is found. I've got something
that does a bit of that and runs twice a day, but
always sends out.

Thanks.

Maks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 - ORA-03001 Error While creating BLOB in 9.0.1 ?!

2003-03-19 Thread Deshpande, Kirti

There was an issue in 9.0.1.0 with BLOB and ASSM feature. It was rectified in 9.0.1.2. 

Are you sure the Oracle version is *exactly* the same? And that the machine B, is not 
missing any Oracle patches applied to machine A? 

- Kirti 

-Original Message-
Sent: Wednesday, March 19, 2003 5:24 AM
To: Multiple recipients of list ORACLE-L


Guys,

CREATE TABLE NAO.MSG ( 
MEMNO NUMBER(10, 0), 
PROFNO NUMBER(10, 0), 
NAME VARCHAR2(20), 
AGE VARCHAR2(10), 
SEX NUMBER(1, 0), 
JANLNO NUMBER(5, 0), 
SUBJECT VARCHAR2(50), 
CONTENT VARCHAR2(500), 
DELFLAG NUMBER(1, 0) DEFAULT 0, 
POSTDATE DATE DEFAULT SYSDATE, 
EXPDATE DATE, 
POSTNO NUMBER(10, 0), 
REFCNT NUMBER(5, 0) DEFAULT 0, 
PREF VARCHAR2(10), 
AREA NUMBER(2, 0), 
SBSTCNT NUMBER(5, 0) DEFAULT 0, 
SENDFLG NUMBER(1, 0) DEFAULT 0, 
REPLYCNT NUMBER(5, 0) DEFAULT 0, 
CHKFLG NUMBER(1, 0) DEFAULT 0, 
ENTPC VARCHAR2(10), 
STOPFLG NUMBER(5, 0) DEFAULT 0, 
PARENT NUMBER(10, 0), 
PIC BLOB, 
PICUPFLG NUMBER(1, 0) DEFAULT 0
) TABLESPACE CANDY03

When i create this table on machine A,i get the error below:
ORA-03001: unimplemented feature

if i remove the BLOB column from the SQL , it works fine on machine A.

whereas,
this works on another machine B with the same o/s and oracle set up.

i wonder why ?

Can you let me know the reason ?




_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Nealy
  INET: [EMAIL PROTECTED]

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Rownum

2003-03-19 Thread Deshpande, Kirti

No. It is not similar to a rowid.
It is just a pseudo sequential number assigned to the rows in the result set (after 
the result set is prepared) from the query. 

- Kirti

-Original Message-
Sent: Wednesday, March 19, 2003 3:44 AM
To: Multiple recipients of list ORACLE-L


Hello list,

 I wanted to know the concept of Rownum.. Is it similar to Row Id ?

Thanks and Regards,
Santosh 



 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Force to use a tablespace

2003-03-19 Thread Deshpande, Kirti

The 'create table foobar (foo number) tablespace special_tablespace;' syntax would do 
it.

Check the SQL Reference Guide for more info. 

- Kirti

-Original Message-
Sent: Wednesday, March 19, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone who knows how to force a table to use  a special tablespace?

Thanks in advance.

Roland


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

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Data Capture program

2003-03-19 Thread Deshpande, Kirti

Can you tell us a bit more about this requirement?
Does this data need to be loaded into the database? 
Or captured from (as in extracted) from the database? 

- Kirti

-Original Message-
Sent: Wednesday, March 19, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L



Hello list,

 I am in a project where the client wants a data capture program without any 
validation in any fields..
the back-end is Oracle 8.1.7. what is the best way to give the user the data capture 
program ?

please provide me any solution as soon as possible.

Thanks and regards,

Santosh





 

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

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

RE: SQL*LOADER question

2003-03-19 Thread Deshpande, Kirti

Sure, you can do it. 
Just use Oracle Net8 connect string to connect to the remote database when specifying 
userid for sqlldr. 

- Kirti 


-Original Message-
Sent: Wednesday, March 19, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L


Hi All,





  I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a
  remote site (WAN connection) and another on my desk running the Oracle
  client software(no database). Can I, and if so how, use sqlldr on my  
  desktop PC to load data into the remote database. The data file to be 
  loaded and the control file are on my desktop. I do not want to use   
  netmeeting or PC anywhere type programs which I know I can use.   
 Thanks 
 Rick   



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: log buffer space

2003-03-14 Thread Deshpande, Kirti

What's the size of your log buffer, and the redo log file? 
Do you see any errors/messages in alert.log file that are related to 'checkpoints' or 
'log switching'? 

- Kirti 

-Original Message-
Sent: Friday, March 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L


Do you guys think , adding more log file can help ? I think it should not ,
cuz any way logwriter is going to write in one datafile at a time , correct
?

-ak


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 4:32 AM


 Arup:

 NO FLAMES
 The second condition is not quite true. It is 2/3 full in the current
 versions.
 /NO FLAMES

 It is very easy to test with the event 10046^8.

 KG


 --- Arup Nanda [EMAIL PROTECTED] wrote:
  AK,
 
  If the log buffer is at least 4MB, then increasing it will not help,
  rather it may hurt. The log buffer is flushed when any of the the
  follwoing occur
  (i) 1 MB is filled up
  (2) 1/3rd is filled up
  (3) every 3 seconds
  (4) when a checkpoint occurs
  (5) when a commit occurs.
 
  Therefore, see if any of these could be the problem. It's easy to
  check #s 4 and 3.
 
  As Kirti suggested, the problem could be due to the redo logs being
  on a busy disk, or even a slow one.
 
  HTH.
 
  Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
 
 
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
  moving those (or other busy data files on the same disk) to other
  not-so-busy disks.
 
- Kirti



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: utl_file_dir and 9i

2003-03-14 Thread Deshpande, Kirti

Precisely 

But wouldn't it be nice if Oracle made '*', in the utl_file_dir specification, an 
unacceptable parameter value? 

- Kirti


-Original Message-
Sent: Friday, March 14, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


True, but any DBA who puts utl_file_dir=* into their parameter file
should be hung, drawn and quartered anyway!  Just imagine what the
effect is - you've now given people rights to open system01.dbf, write
to it and close it.  Hmm, could that cause any problems?  :)

Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not.  It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Landrum
Sent: Friday, March 14, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L


Good points, also consider the security issues that exist because of
'util_file_dir=*'. With that, any user that can run a procedure and
write (or overwrite) files in locations that should be accessible only
by oracle.


 [EMAIL PROTECTED] 03/14/03 07:08AM 
John,

In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY'
rather than UTL_FILE_DIR ... firstly because a directory can be created
dynamically, so to adda new sub-directory you don't have to bounce the
instance.

Plus instead of '*', you can dynamically create directory ... read/write
and drop the directory if you wish.

I'd recommend you make use of this feature John, because UTL_FILE_DIR
might just go away  because of its limitations.

Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!


-Original Message-
Sent: Friday, March 14, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


In 8i we set utl_file_dir = * because otherwise we have to specify
lots of individual directories. It was not possible to just specify a
top level directory.

Has this changed in 9i?   Is it possible to specify a top level
directory
and then utl_file  can write to subdirectories?

John


-- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: segment from block#

2003-03-14 Thread Deshpande, Kirti

You will need FILE_ID as well.
Here is what I use:

-- find_segment.sql 
-- Finds segment name based on file_id and block_id 
set Lines 132
col Owner for a10
col Segment_name for a30
col Segment_type for a20
col Tablespace_name for a30
select Owner,
   Segment_Name,
   Segment_Type,
   Tablespace_Name
from
DBA_EXTENTS
where
File_Id = File_Id_In
and Block_Id_in between
Block_Id and Block_Id + Blocks - 1;


- Kirti 


-Original Message-
Sent: Friday, March 14, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


Is this a good query to find segment where this block ( 259186 )  belongs ?
select  segment_name 
from dba_extents
where block_id= 259186 and 259186 = block_id+blocks


-ak

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Sun=/var/messages HP-UX=???

2003-03-14 Thread Deshpande, Kirti

What version of HP-UX?
Here is what I get on HP-UX 11.0: 

df2hp105 [IWHA]: ll /var/adm/me*
/var/adm/me* not found

- Kirti 

-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) 
machine is also using /var/adm/messages, maybe I changed this, I don't remember.
/var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris.

 -Original Message-
 From: Nelson, Allan [mailto:[EMAIL PROTECTED]
 Sent: Thursday, March 13, 2003 9:20 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Sun=/var/messages HP-UX=???
 
 
 /var/adm/syslog/syslog.log is the hp-ux equivelant.
 
 -Original Message-
 Sent: Thursday, March 13, 2003 12:59 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS
 log files worth monitoring?
 
 Thanks,
 Ethan
-- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Sun=/var/messages HP-UX=???

2003-03-14 Thread Deshpande, Kirti

dmesg... now, that, I know. 
It needs root privs to use. And unless it is run via some automated setup (cron, as 
you mentioned) to create a public accessible report, we are stuck with syslog.log. At 
least, on most systems, it is public readable... 

Thanks..

- Kirti 

-Original Message-
Sent: Friday, March 14, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


hpux 11.0 
man dmesg shows the standard setup using /var/adm/messages.

  dmesg looks in a system buffer for recently printed diagnostic
  messages and prints them on the standard output.  The messages are
  those printed by the system when unusual events occur (such as when
  system tables overflow or the system crashes).  If the - argument is
  specified, dmesg computes (incrementally) the new messages since the
  last time it was run and places these on the standard output.  This is
  typically used with cron (see cron(1)) to produce the error log
  /var/adm/messages by running the command:

   /usr/sbin/dmesg -  /var/adm/messages

  every 10 minutes.

  The arguments core and system allow substitution for the defaults
  /dev/kmem and /stand/vmunix respectively, where core should be a file
  containing the image of the kernel virtual memory saved by the
  savecore(1M) command and system should be the corresponding kernel.
  If the system is booted with a kernel other than /stand/vmunix say
  /stand/vmunix_new, dmesg must be passed this name, the command must
  be,

   /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new

 WARNINGS
  The system error message buffer is of small, finite size.  dmesg is
  run only every few minutes, so there is no guarantee that all error
  messages will be logged.

 AUTHOR
  dmesg was developed by the University of California, Berkeley.

 FILES
  /var/adm/messageserror log (conventional location)
  /var/adm/msgbuf  memory scratch file for - option
  /dev/kmemspecial file containing the image of kernel
   virtual memory
  /stand/vmunixthe kernel, system name list

 -Original Message-
 From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]
 Sent: Friday, March 14, 2003 3:41 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Sun=/var/messages HP-UX=???
 
 
 What version of HP-UX?
 Here is what I get on HP-UX 11.0: 
 
 df2hp105 [IWHA]: ll /var/adm/me*
 /var/adm/me* not found
 
 - Kirti 
 
 -Original Message-
 Sent: Friday, March 14, 2003 10:44 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Actually /var/adm/messages on hpux is the message file, which 
 my solaris 8(2.8) machine is also using /var/adm/messages, 
 maybe I changed this, I don't remember.
 /var/adm/syslog/ is the default syslog directory equivalent 
 to /var/log/ on solaris.
 
  -Original Message-
  From: Nelson, Allan [mailto:[EMAIL PROTECTED]
  Sent: Thursday, March 13, 2003 9:20 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Sun=/var/messages HP-UX=???
  
  
  /var/adm/syslog/syslog.log is the hp-ux equivelant.
  
  -Original Message-
  Sent: Thursday, March 13, 2003 12:59 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I monitor /var/messages on my Sun boxes, does HP-UX have 
 anytype of OS
  log files worth monitoring?
  
  Thanks,
  Ethan
 -- 




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

A SQL Question

2003-03-13 Thread Deshpande, Kirti

Hi SQL Developers, 

I have a table as follows:

Col1   Col2

AB
CD
EF
GH
BA
EF
CD
HG

With a PK on (Col1, Col2). 

How do I write a SQL script to get following result? 

Col1Col2

AB
BA
CD
DC
EF
FE
G   H
H   G

Thanks for your help.

- Kirti 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Sun=/var/messages HP-UX=???

2003-03-13 Thread Deshpande, Kirti

Ethan,
 
  Check /var/adm/syslog/syslog.log 

- Kirti 

-Original Message-
Sent: Thursday, March 13, 2003 12:59 AM
To: Multiple recipients of list ORACLE-L


I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log
files worth monitoring?

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: POLL: Database to DBA ratio

2003-03-13 Thread Deshpande, Kirti

Title: RE: POLL: Database to DBA ratio



In our 
environment, each DBA supports a certain number of databasesthat are 
his/her 'primary' databases (all the way from Test/Dev/Accept/Production). The 
same person is 'secondary' or 'tertiary' for others.We follow a 
standardizedsetup (somewhat modified OFA) for *all* of these databases, 
with standardized, but different, passwords for sys/system/production schema 
accounts that can be easily 'figured out' by DBA team members.Those 
arechanged routinely!All DBAs are on call all of the time. 
Every 2 hours the automated pagingmechanism/Operations is made 'aware' of 
who's available via our own DBA Web App, that keeps track of who's in and who's 
out as well as the 'primary','secondary','tertiary' matrix by 
databasenames.
This 
is working great for over 5years now 

- 
Kirti 

  -Original Message-From: Chuck Hamilton 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 6:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  POLL: Database to DBA ratio
  With such a large # of databases to support, how 
  do you divide up the work? Does everyone administer all of the databases, or 
  are databases assigned to a DBA? How do you handle on-call?
  
- Original Message - 
From: 
Adams, 
Matthew (GECP, MABG, 088130) 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, March 12, 2003 2:40 
PM
Subject: RE: POLL: Database to DBA 
ratio

350 Oracle Databases spread across US and Europe. 
14 full time, 4 part time. 75% of 
applications are designed and built in-house. 
-Original Message- From: 
Deshpande, Kirti [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 12, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio 
We have over 400 databases, 90%+ are Oracle under 
various versions, platforms. 
Today have 19 DBAs. Two weeks from now there will be 17. 

Rightsizing to continue in the 2nd Quarter 
- Kirti 
-Original Message- Sent: 
Wednesday, March 12, 2003 12:09 PM To: Multiple 
recipients of list ORACLE-L 
We have 7 DBAs. 105 production databases (97 24x7), 
ranging from 2 GB OLTP to 800 GB data 
warehouses. 395 devl/alpha/beta databases ranging in size 
from very small (1 GB) to production-sized. About 1/3 
of the production databases have at least 1 (usually 
more) development effort going on at any given 
time. 
Most of our time (lives?) is spent just keeping things up 
and running. The on-call guy averages between 
50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - 
as we have time.

RE: A SQL Question

2003-03-13 Thread Deshpande, Kirti

I messed up typing the data for the table. It has no dups.
The second  occurrence of C, D and E, F should actually be D, C and F, E.
Sorry about that...

Need more hot tea to wake me up !! 

- Kirti 

  -Original Message-
 From: Deshpande, Kirti  
 Sent: Thursday, March 13, 2003 7:25 AM
 To:   oracle list (E-mail)
 Subject:  A SQL Question
 
 Hi SQL Developers, 
 
 I have a table as follows:
 
 Col1   Col2
 
 AB
 CD
 EF
 GH
 BA
 EF
 CD
 HG
 
 With a PK on (Col1, Col2). 
 
 How do I write a SQL script to get following result? 
 
 Col1Col2
 
 AB
 BA
 CD
 DC
 EF
 FE
 G   H
 H   G
 
 Thanks for your help.
 
 - Kirti 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: A SQL Question

2003-03-13 Thread Deshpande, Kirti

Igor (and all):

Yes, our SPAM Cops and their filters are very strict with the wording in the e-mail 
footers. 

Unfortunately, FatCity.com uses the footer that gets caught by these filters. 

When replying to me directly, using list message, you need to remove the old footers 
from the e-mail. 

Sorry about this little problem. 


I will post my Corrected SQL Question again... 

Thanks.

- Kirti 

-Original Message-
Sent: Thursday, March 13, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


Kirti,

I tried to reply to your direct e-mail, but your mail-server is very strict
and considered my message to be Unsolicited Bulk Email.
What I was trying to say is:

Oracle-l list behaves very strangely (sometimes), I'm still waiting to see
corrected
version of your question.
And actually I suspected, that the question isn't that simple -:)


Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 8:23 AM


 Hi SQL Developers,

 I have a table as follows:

 Col1   Col2
 
 AB
 CD
 EF
 GH
 BA
 EF
 CD
 HG

 With a PK on (Col1, Col2).

 How do I write a SQL script to get following result?

 Col1Col2
 
 AB
 BA
 CD
 DC
 EF
 FE
 G   H
 H   G

 Thanks for your help.

 - Kirti

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

Okay, let me do this right this time,... (Now that I have my hot tea going;)

Here is the test data: 

SQL select c1,c2 from cp;

C1  C2
--- ---
AUS DAL
AUS HOU
DAL AUS
DAL HOU
DAL LIT
DAL XYZ
HOU AUS
HOU DAL
HOU LIT
HOU XYZ
LIT DAL

C1  C2
--- ---
LIT HOU
XYZ DAL
XYZ HOU

14 rows selected.

SQL 

Here is what is required:

C1  C2
--- ---
AUS DAL
DAL AUS
AUS HOU
HOU AUS
DAL HOU
HOU DAL
DAL LIT
LIT DAL
DAL XYZ
XYZ DAL
HOU LIT
LIT HOU
HOU XYZ
XYZ HOU


I think I am clear now... 
Sorry about the wrong test data earlier... 


Thanks,

- Kirti 





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

Okay, let me do this right this time,... (Now that I have my hot tea going;)

Here is the test data: 

SQL select c1,c2 from cp;

C1  C2
--- ---
AUS DAL
AUS HOU
DAL AUS
DAL HOU
DAL LIT
DAL XYZ
HOU AUS
HOU DAL
HOU LIT
HOU XYZ
LIT DAL

C1  C2
--- ---
LIT HOU
XYZ DAL
XYZ HOU

14 rows selected.

SQL 

Here is what is required:

C1  C2
--- ---
AUS DAL
DAL AUS
AUS HOU
HOU AUS
DAL HOU
HOU DAL
DAL LIT
LIT DAL
DAL XYZ
XYZ DAL
HOU LIT
LIT HOU
HOU XYZ
XYZ HOU


I think I am clear now... 
Sorry about the wrong test data earlier... 


Thanks,

- Kirti 





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

I think those solutions should be acceptable. 
Not sure if they are displaying any more information from the table. I was just given 
the test table to get the SQL script working

Thanks a lot.


- Kirti



-Original Message-
Sent: Thursday, March 13, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L


I think its easier if you do it cross-tab

AUS DAL DAL AUS

Is that acceptable? 
Or just select

AUS DAL

If it also has a DAL AUS

Are either of those metods acceptable? If so, pick one and Ill show you how to do it. 
 
 From: Deshpande, Kirti [EMAIL PROTECTED]
 Date: 2003/03/13 Thu AM 11:19:15 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Corrected  SQL Question...
 
 Okay, let me do this right this time,... (Now that I have my hot tea going;)
 
 Here is the test data: 
 
 SQL select c1,c2 from cp;
 
 C1  C2
 --- ---
 AUS DAL
 AUS HOU
 DAL AUS
 DAL HOU
 DAL LIT
 DAL XYZ
 HOU AUS
 HOU DAL
 HOU LIT
 HOU XYZ
 LIT DAL
 
 C1  C2
 --- ---
 LIT HOU
 XYZ DAL
 XYZ HOU
 
 14 rows selected.
 
 SQL 
 
 Here is what is required:
 
 C1  C2
 --- ---
 AUS DAL
 DAL AUS
 AUS HOU
 HOU AUS
 DAL HOU
 HOU DAL
 DAL LIT
 LIT DAL
 DAL XYZ
 XYZ DAL
 HOU LIT
 LIT HOU
 HOU XYZ
 XYZ HOU
 
 
 I think I am clear now... 
 Sorry about the wrong test data earlier... 
 
 
 Thanks,
 
 - Kirti 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

Tom,
They wanted to 'pair up' the contents from c1 and c2. 
Those are supposed to be 3 char Airport codes. DAL-AUS followed by AUS-DAL (or 
vice-versa). 
That's all I was told.

Thanks.

- Kirti 


-Original Message-
Sent: Thursday, March 13, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L


Kirti,

Can you explain the required result order?  It looks random to me - or like
one of the tests we were forced to take in High School.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, March 13, 2003 9:31 AM
To: Multiple recipients of list ORACLE-L


Okay, let me do this right this time,... (Now that I have my hot tea going;)

Here is the test data: 

SQL select c1,c2 from cp;

C1  C2
--- ---
AUS DAL
AUS HOU
DAL AUS
DAL HOU
DAL LIT
DAL XYZ
HOU AUS
HOU DAL
HOU LIT
HOU XYZ
LIT DAL

C1  C2
--- ---
LIT HOU
XYZ DAL
XYZ HOU

14 rows selected.

SQL 

Here is what is required:

C1  C2
--- ---
AUS DAL
DAL AUS
AUS HOU
HOU AUS
DAL HOU
HOU DAL
DAL LIT
LIT DAL
DAL XYZ
XYZ DAL
HOU LIT
LIT HOU
HOU XYZ
XYZ HOU


I think I am clear now... 
Sorry about the wrong test data earlier... 


Thanks,

- Kirti 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

Title: RE: Corrected SQL Question...



Jacques,
Thanks a bunch. 

Elegance was not one of the requirements ;) 

Cheers!

- 
Kirti 


  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 
  12:53 PMTo: '[EMAIL PROTECTED]'Cc: Deshpande, 
  KirtiSubject: RE: Corrected SQL Question...
  (see answer below) 
   -Original Message-  
  From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] 
Here is the test data: 
SQL select c1,c2 
  from cp;   C1 
  C2  --- ---  AUS 
  DAL  AUS HOU  DAL 
  AUS  DAL HOU  DAL 
  LIT  DAL XYZ  HOU 
  AUS  HOU DAL  HOU 
  LIT  HOU XYZ  LIT 
  DAL   C1 
  C2  --- ---  LIT 
  HOU  XYZ DAL  XYZ 
  HOU   14 rows 
  selected.   SQL 
Here is what is 
  required:   C1 
  C2  --- ---  AUS 
  DAL  DAL AUS  AUS 
  HOU  HOU AUS  DAL 
  HOU  HOU DAL  DAL 
  LIT  LIT DAL  DAL 
  XYZ  XYZ DAL  HOU 
  LIT  LIT HOU  HOU 
  XYZ  XYZ HOU 
  This is not very elegant, but it works: SQL select * from cp ; C1 C2 
  --- --- AUS DAL AUS HOU DAL AUS DAL 
  HOU DAL LIT DAL XYZ 
  HOU AUS HOU DAL HOU LIT HOU XYZ LIT 
  DAL LIT HOU XYZ DAL 
  XYZ HOU 14 ligne(s) 
  sélectionnée(s). 
  SQL -- desired result SQL 
  select  2 least (a.c1, 
  a.c2) || greatest (a.c1, a.c2) as sort_field, a.c1, a.c2  3 from cp a  
  4 where not exists  
  5 (select * from cp b  
  6 where b.c2 = a.c1 and b.c1 = a.c2 and 
  a.c1  b.c1)  7 union  8 select  
  9 least (c.c1, c.c2) || greatest (c.c1, c.c2) as sort_field, 
  d.c1, d.c2 10 from 
  11 cp c, cp d 
  12 where 13 c.c1 = d.c2 and c.c2 = d.c1 and 
  c.c1  d.c1 14 order by 1, 2 ; 
  
  SORT_F C1 C2 -- --- 
  --- AUSDAL AUS DAL AUSDAL DAL 
  AUS AUSHOU AUS HOU AUSHOU HOU 
  AUS DALHOU DAL HOU DALHOU HOU 
  DAL DALLIT DAL LIT DALLIT LIT 
  DAL DALXYZ DAL XYZ DALXYZ XYZ 
  DAL HOULIT HOU LIT HOULIT LIT 
  HOU HOUXYZ HOU XYZ HOUXYZ XYZ 
  HOU 14 ligne(s) sélectionnée(s). 
  create table cp (c1 varchar2 (3), c2 
  varchar2 (3)) ; insert into cp values ('AUS', 'DAL') 
  ; insert into cp values ('AUS', 'HOU') ; 
  insert into cp values ('DAL', 'AUS') ; insert into cp values ('DAL', 'HOU') ; insert 
  into cp values ('DAL', 'LIT') ; insert into cp values 
  ('DAL', 'XYZ') ; insert into cp values ('HOU', 'AUS') 
  ; insert into cp values ('HOU', 'DAL') ; 
  insert into cp values ('HOU', 'LIT') ; insert into cp values ('HOU', 'XYZ') ; insert 
  into cp values ('LIT', 'DAL') ; insert into cp values 
  ('LIT', 'HOU') ; insert into cp values ('XYZ', 'DAL') 
  ; insert into cp values ('XYZ', 'HOU') ; 
  commit ; select * from cp ; 
  -- desired result select 
   least (a.c1, a.c2) || greatest (a.c1, a.c2) as 
  sort_field, a.c1, a.c2 from cp a 
  where not exists  
  (select * from cp b  where 
  b.c2 = a.c1 and b.c1 = a.c2 and a.c1  b.c1) union select  
  least (c.c1, c.c2) || greatest (c.c1, c.c2) as sort_field, d.c1, d.c2 
   from  cp c, 
  cp d  where  c.c1 = d.c2 and c.c2 = d.c1 and c.c1  
  d.c1 order by 1, 2 ;

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

All they wanted was to pair up those city codes. 
DAL -- AUS followed by AUS -- DAL, 
AUS -- HOU followed by HOU -- AUS 
etc... 
and on separate lines. 
So, cross-tab did not have the right format. 

I sent them Jacques Kilchoer's solution (he also sent me a simplified one, without the 
UNION), and it was acceptable.  
Problem solved, as there are no more questions :)  

- Kirti

-Original Message-
Sent: Thursday, March 13, 2003 1:46 PM
To: Multiple recipients of list ORACLE-L



Questions I would have for those who wrote the requirements:
Of possible combinations of the form ABC XYZ XYZ ABC, which do they want?

As can be seen from the answers sent to the list, there is more than one set
of responses that give this pattern.  If they only want half of the
possible patterns, which half is the correct half?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Create rollback segment under ORACLE 9ir2 failed????

2003-03-13 Thread Deshpande, Kirti

And what Pete said does work.
Here is a report from my testing of undo mode switching (AUM - MUM). Rollback 
tablespace was already created. 

SQL create rollback segment rbs01 tablespace rollback;
create rollback segment rbs01 tablespace rollback
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK'

SQL create rollback segment junk tablespace system;

Rollback segment created.

SQL create rollback segment rbs01 tablespace rollback;
create rollback segment rbs01 tablespace rollback
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK'

SQL alter rollback segment junk online;

Rollback segment altered.

SQL create rollback segment rbs01 tablespace rollback;

Rollback segment created.

SQL alter rollback segment rbs01 online;

Rollback segment altered.

SQL alter rollback segment junk offline;

Rollback segment altered.

SQL drop rollback segment junk;

Rollback segment dropped.


HTH,

- Kirti 

-Original Message-
Sent: Thursday, March 13, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L


Mike

The only way this would have worked under 8i is if you had already
created a dummy rollback segment in the SYSTEM tablespace.   Something
like this should work (before or after the CREATE TABLESPACE
rollback_space)

SQL connect / as sysdba;
SQL CREATE ROLLBACK SEGMENT dummy;

Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not.  It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Thursday, March 13, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L


I am create database on ORACLE 9iR2 and fail on create
rollback segment.

SQL create tablespace rollback_space datafile
  2   '/u4/oradata/TRAN/rbs01TRAN.dbf'  
size   800M  
  3  default storage (
  4  initial  256k
  5  next 256k
  6  pctincrease0
  7  minextents 8
  8  MAXEXTENTS   4096
  9   );

Tablespace created.

SQL
SQL REM * Create rollback segments.
SQL REM *
SQL create rollback segment rollback_1 tablespace
rollback_space
  2   storage (initial 256K next 256k minextents
20 optimal 5M);
create rollback segment rollback_1 tablespace
rollback_space
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for
non-system tablespace
'ROLLBACK_SPACE'


SQL create rollback segment rollback_2 tablespace
rollback_space
  2   storage (initial 256K next 256k minextents
20 optimal 5M);
create rollback segment rollback_2 tablespace
rollback_space
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for
non-system tablespace
'ROLLBACK_SPACE'


Those script used to work under ORACLE 8i.

Does anyone know why?

Thanks.


_

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti

Unfortunately, it is. 

- Kirti 

-Original Message-
Sent: Thursday, March 13, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L



Is this cheating?

  1* select a.c1||' '||a.c2||CHR(10)||b.c1||' '||b.c2 RESULTS from crap a,
crap b where a.c2 = b.c1 and b.c2 = a.c1
SQL /

RESULTS
---
DAL AUS
AUS DAL

HOU AUS
AUS HOU

AUS DAL
DAL AUS

HOU DAL
DAL HOU

LIT DAL
DAL LIT

XYZ DAL
DAL XYZ

AUS HOU
HOU AUS

DAL HOU
HOU DAL

LIT HOU
HOU LIT

XYZ HOU
HOU XYZ

DAL LIT
LIT DAL

HOU LIT
LIT HOU

DAL XYZ
XYZ DAL

HOU XYZ
XYZ HOU


14 rows selected.

 -Original Message-
 From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]
 Sent: Thursday, March 13, 2003 2:24 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Corrected SQL Question...
 
 
 All they wanted was to pair up those city codes. 
 DAL -- AUS followed by AUS -- DAL, 
 AUS -- HOU followed by HOU -- AUS 
 etc... 
 and on separate lines. 
 So, cross-tab did not have the right format. 
 
 I sent them Jacques Kilchoer's solution (he also sent me a 
 simplified one, without the UNION), and it was acceptable.  
 Problem solved, as there are no more questions :)  
 
 - Kirti
 
 -Original Message-
 Sent: Thursday, March 13, 2003 1:46 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Questions I would have for those who wrote the requirements:
 Of possible combinations of the form ABC XYZ XYZ ABC, which 
 do they want?
 
 As can be seen from the answers sent to the list, there is 
 more than one set
 of responses that give this pattern.  If they only want half of the
 possible patterns, which half is the correct half?
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Deshpande, Kirti
   INET: [EMAIL PROTECTED]



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: log buffer space

2003-03-13 Thread Deshpande, Kirti




Increasing log_buffer size is an option, if it is really small. 

I 
would also check if the redo logs are on a busy disk. If so, try moving those 
(or other busy data fileson the same disk) to othernot-so-busy 
disks.

- 
Kirti

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 4:49 
PMTo: Multiple recipients of list ORACLE-LSubject: log 
buffer space

  I am finding tons of "log buffer space" 
  waits in 10046 output . Does it necessarily means I should look for resizing 
  log_buffer ? What else can be done or looked at to reduce these waits 
  .
  
  Thanks,
  ak

TXNCOUNT in V$UNDOSTAT (9i R2) [ Was -- RE: monitor

2003-03-13 Thread Deshpande, Kirti

Title: RE: monitor transactions over time

Today,
Oracle Support updated my TAR, stating that there won't be a patch released to
fix this bug (#2506774) in 9i R2.

Suggested workaround is to derive TXNCOUNT by
subtracting the numbersfrom theprevious sample
period.
And when you write one, watch out for those -ve numbers
for TXNCOUNT.. :-))

Somebody is watching this list..
seriously ;)
Rajendra, youneed toput your script
on e-bay ;)

Regards,

-
Kirti

-Original Message-From: Deshpande, Kirti
Sent: Friday, March 07, 2003 9:14 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: monitor transactions over
time
From
what IknowOracle Development folks have identified the code
changes to correct thisproblem. Just do not when Oracle would issue the
patch. Since the bug was logged against 9i R2, patch would be provided.

This
bug was originally logged in Aug 2002. There was no follow up.

The
other issue with v$undostat view is that it does not work in Manual Undo
Mode.Forget using it while in Manual Undo Management mode to monitor
your undo usageto size undo tablespace accordingly. Forget what the
documents, white papers say. Some of them are 'syntactically' correct in
saying, "This view is available in Automatic and Manual Undo Management mode."
Yes, that is true. The view isavailable in MUM mode.But, it
returns one useless row in 9i R1 and nothing in 9i R2. I was told by Oracle
Development thatit did not work in 9i R1, in MUM mode,so they
simply changed it to return nothing in 9i Rel 2.

Hmmm... wonder if I followed this principle for some of the bugs in our
Applications. ;)

I will talk about this, and a few other things, in my Quick Tips
Sessions, on AUM and FBQ,at the IOUG Conf next month.

-
Kirti

-Original Message- From:
Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: monitor transactions over time
List,
Does anybody know a way to monitor the number of
transactions occurring over time, say 5 minute or 10
minute intervals? I am looking at v$undostat and it appears to have a problem accumulating transactions under txncount
when it should report over a 10 minute interval (
metalink doc# 260990.995, query v$undostat)

BEGIN_TIM END_TIME UNDOBLKS
TXNCOUNT
-

the undo blocks appear correct, but transactions are
accumulating. Does anybody know how to use
v$transaction or another view to do this? This is 9iRel2 on Unix and the application is geared toward transaction
processing.
thanks,

David Ehresmann

RE: why SAN ? why not external storage ?

2003-03-13 Thread Deshpande, Kirti

Disks are cheap until one asks for them ;)  

- Kirti 

-Original Message-
Sent: Thursday, March 13, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L


There are many things I don't get in this life. One of them is the 
statements about disk storage being an admin nightmare and way too 
expensive. Aren't disks very cheap these days?!

Mogens

[EMAIL PROTECTED] wrote:

Rahul,

This is personal opinion, but it looks to me like your concerned about the
database your creating for the client and may not have the total or corporate
wide view your client has.  We're heading down the SAN road not because of any
specific database requirements but because disk storage has become an
administrative nightmare as well as way too expensive.

Dick Goulet

Reply Separator
Author: Arun Annamalai [EMAIL PROTECTED]
Date:   3/13/2003 12:24 PM

Usaually SAN and NAS is used for several good reasons...the two main are...
1) High availability - When you have your database files on SAN/NAS then you can
bring ur database on another server when the primary goes down. Obviously you
have to use a cluster or Big IP (F5) on the front.
2) reduce redundancy -A unix userid with home directory attached to a paticular
NFS drive on NAS/SAN, will  able to see all his files when he logs into other
servers.

so far I heard Net App is low cost including with Raid 5.

-Arun.
Sr oracle dba
  - Original Message - 
  From: Rahul 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, March 12, 2003 9:38 PM
  Subject: Re: why SAN ? why not external storage ?


  my reasons to recommend an external storage was..
  1) the database size is 36GB, and according to many documents i have read, SAN
is not cost effevtive unless populated 
  by a large numbers of drives !!, now for the client the cost is not the
factor.. given the situation.. wouldnt a SAN be an overkill ? 

  2) NO DBA or SYS ADMIN skills to manage the SAN !! 

- Original Message - 
From: Tim Gorman 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, March 12, 2003 8:33 PM
Subject: Re: why SAN ? why not external storage ?


Can you share some of the reasons related to your decision in choosing a
direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a much
smarter choice than DAS.
  - Original Message - 
  From: Rahul 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, March 12, 2003 1:33 AM
  Subject: why SAN ? why not external storage ?


  list, one of our clietns are going to by SAN, the current oracle databases
take around 
  36GB of storage i dnt understand there reason to go for SAN, i
sugguested to buy an external storage 
  box instead. How can i justify my desicion ? (cost of not the factor) 

  TIA
  rahul



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was -- RE: monitor

2003-03-13 Thread Deshpande, Kirti

Title: RE: monitor transactions over time

Make
that bug #2506744.
Sorry..

-
Kirti

-Original Message-From: Deshpande, Kirti
Sent: Thursday, March 13, 2003 7:20 PMTo:
'[EMAIL PROTECTED]'Subject: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was
-- RE: monitor transactions over time ]
Today, Oracle Support updated my TAR, stating that
there won't be a patch released to fix this bug (#2506774) in 9i R2.

Suggested workaround is to derive TXNCOUNT by
subtracting the numbersfrom theprevious sample
period.
And when you write one, watch out for those -ve
numbers for TXNCOUNT.. :-))

Somebody is watching this list..
seriously ;)
Rajendra, youneed toput your script
on e-bay ;)

Regards,

-
Kirti

-Original Message-From: Deshpande, Kirti
Sent: Friday, March 07, 2003 9:14 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: monitor transactions over
time
From what IknowOracle Development folks have identified
the code changes to correct thisproblem. Just do not when Oracle would
issue the patch. Since the bug was logged against 9i R2, patch would be
provided.

This bug was originally logged in Aug 2002. There was no follow up.

The other issue with v$undostat view is that it does not work in
Manual Undo Mode.Forget using it while in Manual Undo Management mode
to monitor your undo usageto size undo tablespace accordingly. Forget
what the documents, white papers say. Some of them are 'syntactically'
correct in saying, "This view is available in Automatic and Manual Undo
Management mode." Yes, that is true. The view isavailable in MUM
mode.But, it returns one useless row in 9i R1 and nothing in 9i R2. I
was told by Oracle Development thatit did not work in 9i R1, in MUM
mode,so they simply changed it to return nothing in 9i Rel 2.

Hmmm... wonder if I followed this principle for some of the bugs in
our Applications. ;)

I will talk about this, and a few other things, in my Quick
Tips Sessions, on AUM and FBQ,at the IOUG Conf next month.

-
Kirti

-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Friday, March 07,
2003 4:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: monitor transactions over
time
I wrote a script to fix the problem in 9202, but don't
tell Oracle ... we want them to fix the bug. as soon as they know there is
a workaround, the priority on the bug will go down. Log a iTar and request
a patch ... the bug# is 2506744
Raj -
Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art
!!
-Original Message- From:
Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: monitor transactions over time
List,
Does anybody know a way to monitor the number of
transactions occurring over time, say 5 minute or
10 minute intervals? I am looking at v$undostat and it appears to have a problem accumulating transactions under
txncount when it should report over a 10 minute
interval ( metalink doc# 260990.995, query v$undostat)
BEGIN_TIM END_TIME UNDOBLKS
TXNCOUNT
-

David Ehresmann

RE: Re: OCP

2003-03-12 Thread Deshpande, Kirti

 You only need to get 50% of the questions right on the upgrade tests.

Why not set the goal to it get 100% right?  ;) 

- Kirti 



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


I didnt realize that you might be able to do the 8i one without handing $2k to oracle 
for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions right on 
the upgrade tests. 

 
 From: Darrell Landrum [EMAIL PROTECTED]
 Date: 2003/03/12 Wed AM 07:48:43 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: OCP
 
 Jay,
 
 One thing to consider is that just starting the 9i track and if you've not taken any 
 OCP exams prior to September of 2002, there is a requirement to attend one 9i 
 training class in addition to the exams.  However (you'll probably need to call 
 Oracle to get a solid answer to this), if you can still take the 8i track with no 
 classroom training and then take the 9i upgrade exam (if they allow this with no 
 classroom training), this would be your least expensive route since the classes are 
 quite expensive.  The down side is a total of six exams instead of just four.
 If your company is willing to send you to one of the 9i classes, I would take 
 advantage of that and just go for the 9i track.
 
 Good luck!
 Darrell
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: DEFAULT ROLE ALL

2003-03-12 Thread Deshpande, Kirti




That 
sets all roles assigned to the username as it's default and are in effect at the 
same time whenever username logs in.

- 
Kirti 


  -Original Message-From: Edouard Dormidontov 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 7:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  DEFAULT ROLE ALL
  Hi World!
  
  What this mean:
   ALTER USERusername DEFAULT ROLE ALL;
  
  Thanks
  Ed Dorma

RE: POLL: Database to DBA ratio

2003-03-12 Thread Deshpande, Kirti

We have over 400 databases,  90%+ are Oracle under various versions, platforms. 

Today have 19 DBAs. Two weeks from now there will be 17. 

Rightsizing to continue in the 2nd Quarter 

- Kirti 

-Original Message-
Sent: Wednesday, March 12, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L



We have 7 DBAs.  105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses.  395 devl/alpha/beta databases ranging in size
from very small (1 GB) to production-sized.  About 1/3 of the production
databases have at least 1 (usually more) development effort going on at any
given time.

Most of our time (lives?) is spent just keeping things up and running.  The
on-call guy averages between 50 to 100 pages per week (record is in the
230-range).  Tuning and testing new stuff is fairly uncommon - as we have
time.


   
   
  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: monitor transactions over time

2003-03-07 Thread Deshpande, Kirti

Title: RE: monitor transactions over time

From
what IknowOracle Development folks have identified the code changes
to correct thisproblem. Just do not when Oracle would issue the patch.
Since the bug was logged against 9i R2, patch would be provided.

This
bug was originally logged in Aug 2002. There was no follow up.

The
other issue with v$undostat view is that it does not work in Manual Undo
Mode.Forget using it while in Manual Undo Management mode to monitor your
undo usageto size undo tablespace accordingly. Forget what the documents,
white papers say. Some of them are 'syntactically' correct in saying, "This view
is available in Automatic and Manual Undo Management mode." Yes, that is true.
The view isavailable in MUM mode.But, it returns one useless row in
9i R1 and nothing in 9i R2. I was told by Oracle Development thatit did
not work in 9i R1, in MUM mode,so they simply changed it to return nothing
in 9i Rel 2.

Hmmm... wonder if I followed this principle for some of the bugs in our
Applications. ;)

I will talk about this, and a few other things, in my Quick Tips
Sessions, on AUM and FBQ,at the IOUG Conf next month.

-
Kirti

-Original Message- From:
Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: monitor transactions over time
List,
Does anybody know a way to monitor the number of transactions
occurring over time, say 5 minute or 10 minute
intervals? I am looking at v$undostat and it
appears to have a problem accumulating transactions under txncount when
it should report over a 10 minute interval ( metalink doc#
260990.995, query v$undostat)
BEGIN_TIM END_TIME UNDOBLKS
TXNCOUNT
-

-
-- --
05-MAR-03
05-MAR-03
38
161519
05-MAR-03
05-MAR-03
24
161468
05-MAR-03
05-MAR-03
1
161227
05-MAR-03
05-MAR-03
4 161075
05-MAR-03
05-MAR-03
71 160881
05-MAR-03 05-MAR-03
6932 160748
05-MAR-03
05-MAR-03
8 160073
05-MAR-03 05-MAR-03
14545 159887
05-MAR-03 05-MAR-03
19588 159010
05-MAR-03 05-MAR-03
2333 157084
05-MAR-03 05-MAR-03
6972 152649
the undo blocks appear correct, but transactions are
accumulating. Does anybody know how to use
v$transaction or another view to do this? This is 9iRel2 on Unix and the application is geared toward transaction
processing.
thanks,

David Ehresmann

RE: Oracle Magazine excels itself

2003-03-04 Thread Deshpande, Kirti

 that segment
  header
  block contention can be addressed without
  multiple Freelist 
  groups, for example, by increasing the
  pctfree/pctused gap 
  or by partitioning the segment.
  
  end of reply
  
  
  My comments
  
  Surely the point of a 'readers comments' section is
  to get feedback from the readers, add value to the
  article by including readers' experiences or extra
  observations, allow expression of readers' attitudes
  and feelings (without an aggressive editorial
  response),
  and, if an actual error does get noted, allow a
  correction
  to be published.
  
  
  So why publish this erroneous correction ?  It did
  not
  add value to the article, it didn't even expose the
  need
  for clarification of a point. It merely elicited a
  repetition
  of some material that had already been stated in the
  article (which originally said: ... If this is the
  case, increase
  the freelist groups or increase the pctused to
  pctfree gap...) 
  plus the claim that the author had to be right
  because the 
  comment was taken from Metalink.
  
  
  It would, quite arguably, have been valid to reply
  with
  something like:  Your comments do, indeed reflect
  a well-known, and often documented, misconception
  about freelist groups.  However, the behaviour
  changed in
  Oracle 7.X.X, and single-instance Oracle will take
  advantage of multiple free list groups. Be careful,
  however, that you set FREELISTS and FREELIST
  GROUPS to relatively co-prime numbers, or you
  will lose some of the benefits etc.
  
  
  So what has the dialogue achieved:
  
  a) It hasn't improved the knowledge of the
  readers.
  
  b) It has told readers that they had better not
  write in if they think that there is an error in 
  one of the articles unless they want to run 
  the risk of looking stupid in public.
  
  c) It has given Rich Niemiec the chance to
  say I'm right, you're wrong - yah, boo, sucks.
  
  
  I'm not impressed..
  
  
  
  Regards
  
  Jonathan Lewis
  http://www.jlcomp.demon.co.uk
  
  Coming soon one-day tutorials:
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 Magazine excels itself

2003-03-03 Thread Deshpande, Kirti

 )
 
 UK___March 19th
 UK___April 8th
 UK___April 22nd
 
 USA_(FL)_May 2nd
 
 
 Next Seminar dates:
 (see http://www.jlcomp.demon.co.uk/seminar.html )
 
 USA_(CA, TX)_August
 
 
 The Co-operative Oracle Users' FAQ
 http://www.jlcomp.demon.co.uk/faq/ind_faq.html
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Jonathan Lewis
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

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

__



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: multiple oracle homes

2003-03-02 Thread Deshpande, Kirti

Alex,
 Thanks for that idea :) 

- Kirti 

-Original Message-
Sent: Sunday, March 02, 2003 8:04 PM
To: Multiple recipients of list ORACLE-L


Kirti,

The next enhancement would be to execute script (from .profile) which will
generate all aliases based on oratab.
I use something like
alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT'
and /usr/local/bin/oracle_setup.ksh will source oraenv and do some
additional customization.

Alex.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 7:14 PM


Better yet, have one single generic .profile with aliases defined for each
instance running on the server.

Want to change env for another instance? Just type it's name. It is that
simple.

We do this on all our servers, some with 20+ instances running under 7.3.4,
8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w.

The .profile file sources the alias' file as .local.aliases. This file has
entries as below:

#Add Database name here using the following format
alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK=NO;. oraenv;'
alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK=NO;. oraenv;'
alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK=NO;. oraenv; cd
/u01/home/oracle/admin/VP1D;'
alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK=NO;. oraenv;'
alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK=NO;. oraenv;'
alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK=NO;. oraenv;'
alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK=NO;. oraenv;'
alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK=NO;. oraenv;'
alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK=NO;. oraenv;'

PRMT -- IWVT are the instances running on the server.



And finally, do change the UNIX prompt to include current ORACLE_SID, among
other things !!


HTH,

- Kirti

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

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



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

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

RE: Upgrade to AIX 5.2

2003-02-28 Thread Deshpande, Kirti




Our Current Environment: 64-bit AIX 
4.3.3 running 32-bit 8.1.7.4 and 64-bit 9i. 

Here is what we are thinking of testing... 
(a very high level task list, there will be App testing in all these steps). 


First, upgrade databases to 64-bit 9i 

Second, upgrade AIX to 5L, install 
64-bit 9i for 5L
Third, upgrade databases to 9i for 
5L.

We will not use export/import in this 
process. 

We may start this project in Q3 of this 
year. I will have more info then. 

I anyone gets this upgrade/migrate done 
before then, I would appreciate your comments and advise. 

Thanks,

- Kirti 

  -Original Message-From: Gene Sais 
  [mailto:[EMAIL PROTECTED]Sent: Friday, February 28, 2003 
  8:04 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Upgrade to AIX 5.2
  So it appears that Oracle 8.1.7 databases and 9.2 databases can not 
  co-exist on the same server, i.e. AIX 4.3.3 32 bit. If this is the case, 
  then all databases on the server must be upgraded at the same time?
  
  Current Env: AIX 4.3.3 32 bit Oracle 8.1.7
  Proposed Env: AIX 5.2 64 bit Oracle 9.2
  
  Plan to get there:
  - Boot AIX 4.3.3 server to 64 bit
  - Install Oracle 9.2 64 bit  Patch for AIX 4.3.3
  - Change env scripts to point to Oracle 9.2
  - Migrate/upgrade all databases from 8.1.7 to 9.2
  - Upgrade AIX to 5.2
  - Install Oracle 9.2 64 bit binaries
  
  Then there is the alternate plan:
  - Free up a server
  - Upgrade AIX 4.3.3 to 5.2 64 bit on this new server
  - Install Oracle 9.2 64 bit
  - Export 8.1.7 database and import to new 9.2 database
  - Continue this process on a per database basis, no rush to do all 
  databases on server
  
  Any thoughts, experiences, opinions are appreciated. Thanks,
  Gene
   [EMAIL PROTECTED] 02/27/03 03:19PM 
  Tracy,We are still debating this issue with our preferred 
  App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 
  9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 
  should not take considerable amount of time, as *none* of the new features of 
  9i would be used by the Vendor. Sad but true. There will be more testing time 
  allocated to 9i/AIX 5L update, as several other software pieces would be 
  tested for the first time with that combination. We will need to install 9i 
  for AIX 5L after the OS upgrade. We may choose to install it in the same 
  ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, 
  yet. If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L, 
  this would have been a bit simpler... Regards,- Kirti 
  -Original Message-Sent: Thursday, February 27, 2003 
  1:36 PMTo: Multiple recipients of list 
  ORACLE-LJohn/Kirti,We are in the same boat with you. 
  However, we were looking to first upgrade toAIX 5L first and leave our 
  existing 8.1.7 32-bit databases (booting the serverin 32 bit mode). 
  In a subsequent phase we would upgrade 8.1.7 32-bit to 9.264-bit. 
  The downside to this is that it will affect all databases on 
  theserver. We would need to test the complexity/timing/risk to 
  determine if thisis the appropriate choice. Kirti, with the option 
  that you are leaningtowards, as I see it, you need to upgrade to 5L and 
  then install 9.2 for 5L(there is also a 9.2 for 4.3.3) and then migrate 
  the databases from 9.2/4.3.3to 9.2/5L. Do you know what effort is 
  involved in that transition? Is itcomplex/time consuming or just 
  pointing to a new oracle_home? 
  Thanks 02/27/2003 
  05:43 AM PSTPlease respond to [EMAIL PROTECTED]Sent 
  by: [EMAIL PROTECTED]To: 
  "Multiple recipients of list ORACLE-L" 
  [EMAIL PROTECTED]cc:It appears that way. We are 
  also pondering on this upgrade as well.But if one takes this route, 
  that is, running 5L in 32-bit mode, one can notinstall 9i on the same 
  server. And Oracle has not certified 8.1.7 64-bit on AIX5L. It is not 
  planned to be available, either.So, we are leaning towards upgrading 
  to 9i first on AIX 4.3.3. Next upgrade OSto AIX 5L 5.1 and then 5.2 (some 
  of the apps will become available on 5.2 laterthis year)..- 
  Kirti-Original Message-Sent: Thursday, February 27, 2003 
  7:09 AMTo: Multiple recipients of list ORACLE-LSo 8.1.7 is 
  supported on AIX 5L provided AIX is booted in 32 bit 
  mode???John-Original Message-Sent: 27 
  February 2003 12:24To: Multiple recipients of list 
  ORACLE-LCertify - Additional Info Oracle Server - Enterprise 
  Edition Version 8.1.7(8i) On IBM AIX -Based 
  SystemsOperating 
  System: IBM AIX -Based Systems Version 5.2 (5L)Oracle Server - Enterprise 
  Edition Version 8.1.7 (8i)N/A Version N/AStatus: 
  CertifiedProduct Version Note:Terminal Oracle8i 
  releaseTo obtain Patch Sets from MetaLink, click the "Patches" button to 
  the left.Certification Note:Existing patch 
  sets: 8.1.7.1.0 (without 
  JDBC), 8.1.7.1.0b (includes JAVAVM, Context and 
  JDBC), 8.1.7.2.0 
  8.1.7.3.0

RE: multiple oracle homes

2003-02-28 Thread Deshpande, Kirti

Better yet, have one single generic .profile with aliases defined for each instance 
running on the server.

Want to change env for another instance? Just type it's name. It is that simple. 

We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 
8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w.

The .profile file sources the alias' file as .local.aliases. This file has entries as 
below:

#Add Database name here using the following format
alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK=NO;. oraenv;'
alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK=NO;. oraenv;'
alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK=NO;. oraenv; cd 
/u01/home/oracle/admin/VP1D;'
alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK=NO;. oraenv;'
alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK=NO;. oraenv;'
alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK=NO;. oraenv;'
alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK=NO;. oraenv;'
alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK=NO;. oraenv;'
alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK=NO;. oraenv;'

PRMT -- IWVT are the instances running on the server. 

 

And finally, do change the UNIX prompt to include current ORACLE_SID, among other 
things !! 


HTH,

- Kirti 

 
-Original Message-
Sent: Friday, February 28, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L


Using something other than oracle makes it more complicated - I think.  Have a 
different .profile - can name it something that makes sense.  
-Original Message- 
Sent: Friday, February 07, 2003 10:54 AM 
To: Multiple recipients of list ORACLE-L 


Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had 
a bad experience :-) 
Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Friday, February 07, 2003 8:24 AM 
To: Multiple recipients of list ORACLE-L 


On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: 
 
 Where is it well documented how to install multiple server versions, 
 8i and 9i, on the same unix server? 
-- 
Thanks for you replies.  I've never tried this before and it seems like 
there are two different approaches on the surface: 
1. use two different userids, ora817 and ora920, to do the install.  This 
seems stupid, since it replicates the product directory structure and 
oraInventory stuff under different ownership.  This might be safer since 
it is like running one version in that everything is seperate, but 
maybe there are operational issues to not using the oracle userid. 
Seems like there may be a gotcha waiting in the wings.  Like maybe you 
can't run the same listener for both, or worse.  
2. use the same oracle userid for both installs and change the environment 
vars as needed.  Seems like you could damage the first install if you 
made a mistake.  Also, it seems like in a stressful failure situation 
you don't want to have to think about who's on first?  I don't know, 
third base. 
Are both paths valid? 
=== 
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ray Stell 
  INET: [EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Checkpoints

2003-02-27 Thread Deshpande, Kirti




Zabair,
Increasing the l_c_i would help.

I see you have l_c_t set to 0, 
sowhy not set l_c_i to 0 as 
well? So that the checkpoint will only occur at log switches. 


- Kirti 


  -Original Message-From: Zabair Ahmed 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, February 27, 2003 3:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Checkpoints
  
  The following parameters are set in the 
  init.ora:-
  NAME 
  VALUE-- 
  ---log_checkpoint_interval 
  25600log_checkpoint_timeout 
  0log_checkpoints_to_alert 
  TRUE
  This means that a checkpoint will happen 
  every 12Mb of redo being filled, os block size is 512. The size of the 
  redo logs are 50Mb, as a solution,I recommend setting the 
  log_checkpoint_interval to at least 50Mb to reduce the occurrences of these 
  checkpoints. 
  What am noticing in the alert log is that a 
  checkpoint is happening every minute at peak times, this is clearly putting 
  considerable overhead on the lgwr.
  Oracle 8.0.6.3.0 on Solaris 5.8
  Anyone got any thoughts on the above or 
  experienced checkpoints going mad on 8.0.6.
  TIA
  
  
  
  
  
  With Yahoo! Mail you can get a bigger mailbox -- choose a 
  size that fits your needs

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti

It appears that way. We are also pondering on this upgrade as well.

But if one takes this route, that is, running 5L in 32-bit mode, one can not install 
9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX 5L. It is not 
planned to be available, either.  

So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OS to AIX 
5L 5.1 and then 5.2 (some of the apps will become available on 5.2 later this year).. 

- Kirti 

-Original Message-
Sent: Thursday, February 27, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L


So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode???

John




-Original Message-
Sent: 27 February 2003 12:24
To: Multiple recipients of list ORACLE-L



Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7
(8i) On IBM AIX -Based Systems




Operating System: IBM AIX -Based Systems Version 5.2 (5L) 
Oracle Server - Enterprise Edition Version 8.1.7 (8i) 
N/A Version N/A 
Status: Certified 

Product Version Note:


Terminal Oracle8i release 
To obtain Patch Sets from MetaLink, click the Patches button to the left. 
Certification Note:


Existing patch sets:
 8.1.7.1.0  (without JDBC),
 8.1.7.1.0b (includes JAVAVM, Context and JDBC),
 8.1.7.2.0
 8.1.7.3.0
 8.1.7.4.0


Oracle 8i 32-bit on AIX 5L (5.1  5.2) 
Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bit
mode. This mode is not supported, as Oracle 8i uses at least one 32-bit
kernel extension. AIX-based systems must be booted with kernels in 32-bit
mode.

Warning about missing crash during installation of Oracle 8i.
The error message crash: not found may appear during execution of
rootpre.sh on AIX 5L. This warning may be ignored. Alternatively, the
warning can be avoided by creating the following script and renaming it to
/usr/sbin/crash: 
#!/bin/ksh
read input
if [ X$input = Xle ]; then
 echo lke | /usr/sbin/kdb | \
 /usr/bin/awk '/^ *[0-9]+/ {printf(LoadList entry at 0x%s\n  Name:
%s\n\n,$2,$6)}
fi

April Wells
Oracle DBA 
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein



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

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

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti

Tracy,
 We are still debating this issue with our preferred App Vendor... 

 Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. 

 Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, 
as *none* of the new features of 9i would be used by the Vendor. Sad but true. There 
will be more testing time allocated to 9i/AIX 5L update, as several other software 
pieces would be tested for the first time with that combination. We will need to 
install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same 
ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet. 

 If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L,  this would have been a bit 
simpler... 

Regards,

- Kirti 


-Original Message-
Sent: Thursday, February 27, 2003 1:36 PM
To: Multiple recipients of list ORACLE-L



John/Kirti,
We are in the same boat with you.  However, we were looking to first upgrade to
AIX 5L first and leave our existing 8.1.7 32-bit databases (booting the server
in 32 bit mode).  In a subsequent phase we would upgrade 8.1.7 32-bit to 9.2
64-bit.  The downside to this is that it will affect all databases on the
server.  We would need to test the complexity/timing/risk to determine if this
is the appropriate choice.  Kirti, with the option that you are leaning
towards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L
(there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3
to 9.2/5L.  Do you know what effort is involved in that transition?  Is it
complex/time consuming or just pointing to a new oracle_home? Thanks





   02/27/2003 05:43 AM PST

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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


It appears that way. We are also pondering on this upgrade as well.

But if one takes this route, that is, running 5L in 32-bit mode, one can not
install 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX
5L. It is not planned to be available, either.

So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OS
to AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 later
this year)..

- Kirti

-Original Message-
Sent: Thursday, February 27, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L


So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode???

John




-Original Message-
Sent: 27 February 2003 12:24
To: Multiple recipients of list ORACLE-L



Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7
(8i) On IBM AIX -Based Systems




Operating System: IBM AIX -Based Systems Version 5.2 (5L)
Oracle Server - Enterprise Edition Version 8.1.7 (8i)
N/A Version N/A
Status: Certified

Product Version Note:


Terminal Oracle8i release
To obtain Patch Sets from MetaLink, click the Patches button to the left.
Certification Note:


Existing patch sets:
 8.1.7.1.0  (without JDBC),
 8.1.7.1.0b (includes JAVAVM, Context and JDBC),
 8.1.7.2.0
 8.1.7.3.0
 8.1.7.4.0


Oracle 8i 32-bit on AIX 5L (5.1  5.2)
Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bit
mode. This mode is not supported, as Oracle 8i uses at least one 32-bit
kernel extension. AIX-based systems must be booted with kernels in 32-bit
mode.

Warning about missing crash during installation of Oracle 8i.
The error message crash: not found may appear during execution of
rootpre.sh on AIX 5L. This warning may be ignored. Alternatively, the
warning can be avoided by creating the following script and renaming it to
/usr/sbin/crash:
#!/bin/ksh
read input
if [ X$input = Xle ]; then
 echo lke | /usr/sbin/kdb | \
 /usr/bin/awk '/^ *[0-9]+/ {printf(LoadList entry at 0x%s\n  Name:
%s\n\n,$2,$6)}
fi

April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein







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

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



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

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

RE: History

2003-02-26 Thread Deshpande, Kirti

Their presentation slides are dated Nov 1998. One of slides refers to the paper as 
'accompanying paper'. It could be 1998 OOW Conf. 

- Kirti

-Original Message-
Sent: Wednesday, February 26, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L


Seems like 1999 around OOW.

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

On Wed, 26 Feb 2003, Jonathan Lewis wrote:

 
 Does anyone happen to remember when
 Juan Loaiza and Bhaskar Himatsingka first
 published their paper called:
 
 How to stop defragmenting and start living:
 the definitive word on fragmentation.
 
 Thanks
 
 
 Jonathan Lewis
 http://www.jlcomp.demon.co.uk
 
 Coming soon one-day tutorials:
 Cost Based Optimisation
 Trouble-shooting and Tuning
 Indexing Strategies
 (see http://www.jlcomp.demon.co.uk/tutorial.html )
 
 UK___March 19th
 USA_(FL)_May 2nd
 
 
 Next Seminar dates: 
 (see http://www.jlcomp.demon.co.uk/seminar.html )
 
 USA_(CA, TX)_August
 
 
 The Co-operative Oracle Users' FAQ
 http://www.jlcomp.demon.co.uk/faq/ind_faq.html
 
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Partitioning

2003-02-26 Thread Deshpande, Kirti

Yes you can. Check the storage option of the partition clause. 

Something like: 
 
create table (sales_yr varchar2(4),)
partition by range (sales_yr)
 (partition p1 values less than ('1996')
  tablespace blah_p1
  storage (initial 100M next 100M pctincrease 0),
  
  partition p2 values less than ('2000') 
  tablespace blah_p2
  storage (initial 200M next 200M pctincrease 0),
  .
  )
/

BTW.. does you company sell 'DBA-IN-A_BOX' ??? 

HTH,


- Kirti

-Original Message-
Sent: Wednesday, February 26, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L



If you have a table partitioned, can you specify the storage size of each
partition in that tables

I looked at dba_tab_partitions and dba_segments views.
Although the show me storage information, I am unable to create a table
where I can specify the storage size for each partition.

Am I doing something wrong  Or you cannot specify a storage size for
partitions.

Please help..


Thanks

Conrad...

-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: corrupted block

2003-02-24 Thread Deshpande, Kirti

Suzy,
 Just more questions: 
 Are your sure that this corruption has made it to the disk? It could be memory 
related. 
 Can you export the table to /dev/null to double check the corruption? 
 What do you get when reading that particular block using dba_extents? 

- Kirti 
 
 


-Original Message-
Sent: Monday, February 24, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L



I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). 
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.  

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).  

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?  

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name:SunOS
Node name:  kanadb-co1
Release:5.6
Version:Generic_105181-17
Machine:sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP

*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
-- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: corrupted block

2003-02-24 Thread Deshpande, Kirti

Suzy,
 I think it is memory related. May be un-caught memory leak or similar.. Did you get 
any ORA-600 errors? 
 The trace file reports 'Entire contents of block is zero - block never written'. 
DBWR, at some point would have crashed the database if it attempted writing to the 
corrupted block. Not sure if and when that may have happened, but I would guess that 
this block does not contain any rows. 

 Can you read the entire table via one of its indexes? If it is successful, you can 
safely pull data off to another table. 

- Kirti 

-Original Message-
Sent: Monday, February 24, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L



Thanks Kirti.  Interesting, dba_extents doesn't return rows for
block_id=57856.  However, export to /dev/null does report the
corruption.  Does this indicate disk or memory corruption?

Deshpande, Kirti wrote:
 
 Suzy,
  Just more questions:
  Are your sure that this corruption has made it to the disk? It could be memory 
 related.
  Can you export the table to /dev/null to double check the corruption?
  What do you get when reading that particular block using dba_extents?
 
 - Kirti
 
 
 
 -Original Message-
 Sent: Monday, February 24, 2003 10:09 AM
 To: Multiple recipients of list ORACLE-L
 
 I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade).
 Last night I analyzed the tables and a corrupted block was found.  I
 know which table and datafile it is, and it's the only table in the
 affected tablespace.
 
 The database is in archivelog mode so I can recover the datafile, but I
 am not certain when the block corruption occurred.  There were no
 proactive measures in place to quickly report a corrupted block.  So I
 assume it may have been there a long time, and was just found through
 analyze (tables hadn't been analyzed since Dec-2000).
 
 So my question is, if all backups contain the corrupted block, how would
 I copy all non-corrupted blocks from this table into a new table?
 
 Here is the trace file:
 
 ORACLE data block corrupted (file # 24, block # 57856)
 
 Dump file
 /dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
 Oracle7 Server Release 7.3.4.3.0 - Production
 With the distributed, replication, parallel query and Spatial Data
 options
 PL/SQL Release 2.3.4.3.0 - Production
 ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
 System name:SunOS
 Node name:  kanadb-co1
 Release:5.6
 Version:Generic_105181-17
 Machine:sun4u
 Instance name: kana03aP
 Redo thread mounted by this instance: 1
 Oracle process number: 10
 Unix process pid: 13163, image: oraclekana03aP
 
 *** 2003.02.24.02.49.42.000
 *** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
 ***
 Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
 buffer read
 on disk type:0. ver:0. dba: 0x inc:0x seq:0x
 incseq:0x
 Entire contents of block is zero - block never written
 Reread of block=6000e200 file=24. blocknum=57856. found same corupted
 data
 --
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Deshpande, Kirti
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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

RE: general recovery scenarios

2003-02-22 Thread Deshpande, Kirti

Since you want to learn, how about getting Rama Velpuri's Oracle Backup and Recovery 
Guide. I find it to be the *best* book on this subject. It also has a number recovery 
scenarios for you to practice and learn.

- Kirti
(Just finished recovering a database from a loss of 7 data files. Thanks to our brave 
 bold SAs, who were installing Veritas VM and moving files around to newer 
disk..)  


-Original Message-
Sent: Saturday, February 22, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Sorry folks .. i asked a wrong question. thanks for ur answers but those
crashing dbs recovery was totally heavy for me. i shud i have asked, what r
the different types of crashes and how to recover from them ? i mean, only
the general recovery scenarious. since i m learning, i just want to
understand the most frequent ones and learn recovering.

say like, Rich Jesse mentioned, recovering a truncate'd table from the
backup. something similiar, on those lines.

albiet, thanks for the earlier answers !

-sam


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 9i hanging when linking during install !!!

2003-02-21 Thread Deshpande, Kirti

Review and increase kernel parameters maxtsiz, maxdsiz, maxssiz (maxtsiz_64bit, 
maxdsiz_64bit, maxssiz_64bit). It is possible that maxssiz (process stack space) is 
too low, and hence 'Out of Memory'.  
Refer to HP-UX Oracle Installation Guide for some guidelines to select proper values 
for these parameters. Kernel rebuilding and rebooting of the server will be needed :( 

- Kirti 


-Original Message-
Sent: Friday, February 21, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L


Hi All

We are having this major problem when we  are trying to install Oracle
9i software on HP-Unix 11. It just hangs when it's linking, please
help as we need to upgrade our production databases to 9i.

Check here :

Installing oracle 920. On linking getting the ff error :
Error in invoking ioracle of makefile
/$ORACLE_HOME/rdbms/lib/ins_rdbms.mk.

I have checked on
metalink and seen a suggestion of increasing swap space.My swap space
is currently 6Gb. Pls assist.


$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle

 - Linking Oracle
rm -f /opt/oracle/920/rdbms/lib/oracle
 cc   -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o
/opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/
-L/opt/oracle/92
0/lib/  `if /usr/bin/getconf KERNEL_BITS | grep 64  /dev/null ; \
then echo -Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata
1M ; \
else echo  ; fi` -Wl,-PF,linkorderfile
-Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit
+ESlit +
Olibcalls /opt/oracle/920/rdbms/lib/opimai.o
/opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o
 /opt/or
acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o
/opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o
/opt/oracle/920/r
dbms/lib/config.o  -lserver9 -lodm9  -lskgxp9 -lskgxn9 -lclient9
-lvsn9 -lwtcserver9  -lcommon9 -lgeneric9 /opt/oracle/920/
rdbms/lib/defopt.o  -lknlopt `if ar tv
/opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o  /dev/null
21 ; then echo
-loraolap9 ; fi`  -lslax9 -lpls9  -lplp9   -ljox9  -lwwg9  `cat
/opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9
 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9  -lcore9  -lxml9 -lunls9
-ltrace9  `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a
| grep kxmnsd.o  /dev/null 21 ; then echo   ; else echo
-lordsdo9; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9  -lsnls
9   `cat /opt/oracle/920/lib/sysliblist`  -lm   `if ar t
/opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o  /dev/null 21
; then echo /opt/clic/lib/pa20_64/libclic_csi.a;fi`
/opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres
Out of Memory.
*** Error exit code 12

Stop.

Total VM : 735.2mb   Sys Mem  : 354.9mb   User Mem:  1.99gb   Phys
Mem:  6.00gb
Active VM: 301.1mb   Buf Cache:  3.00gb   Free Mem: 674.4mb

ld: (Warning) Can't open the fdp output file linkorderfile

Pid 27501 received a SIGSEGV for stack growth failure.
Possible causes: insufficient memory or swap space,
or stack size exceeded maxssiz.
cc: error 1405: /usr/ccs/bin/ld terminated abnormally with signal
11.
*** Error exit code 11

Stop.
_

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: ORA-02046

2003-02-21 Thread Deshpande, Kirti

If on UNIX, running the oerr utility can be helpful to quickly find a bit more 
information about ORA errors: (I do not know, what's available on Windows). 

df2hp105 [oracle] = oerr ora 2046
02046, 0, distributed transaction already begun
// *Cause: internal error or error in external transaction manager.
// A server session received a begin_tran RPC before finishing
// with a previous distributed tran.

Check if there are any trace files generated to find any clues, else, open an iTAR 
(??). 

- Kirti 

-Original Message-
Sent: Friday, February 21, 2003 5:19 AM
To: Multiple recipients of list ORACLE-L


I'm getting the following error  while trying to select from table using dblink:
ORA-02046 distributed transaction already begun 


Thanks
Manoj

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

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 unauthenticated remote system compromise (

2003-02-21 Thread Deshpande, Kirti

Joan,
 You may want to log in an iTAR to find out if this patch can be applied to 8.1.7.2. 
The note said it was for 8.1.7.4 and I have been applying it to only 8.1.7.4 software 
on our servers. Other lower versions of 8.1.7.x are not patched, as we are upgrading 
those databases to 8.1.7.4.

HTH,

Regards,

- Kirti 


-Original Message-
Sent: Friday, February 21, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


Hi Kirti,

We are on v8.1.7.2 32-bit on IBM 4.3.3. I am not sure should we have to
apply the 8.1.7.4 patch? Sometimes just read the note is very confusing,
so just apply this patch to upgrade to 8.1.7.4?

Joan

Deshpande, Kirti wrote:
 
 Hello All,
 If anyone successfully applied this patch (for Alert #51) to 8.1.7.4 32-bit on HP-UX 
11.0, please let me know. It seems that the patch is not able to find a couple of 
required lib files. Nothing found on the Metalink of any help... (I will log an iTAR 
soon).
 
 No problem on AIX, though.
 
 Thanks.
 
 - Kirti
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: AIX question

2003-02-21 Thread Deshpande, Kirti

Try this:
 lsdev -C -c adapter (to get controller info)
 lsdev -C -c disk (to see what devices are on what controllers) First col is the 
hdisk, 3rd col is the controller number, last col is controller name. 
 No need to be root to get this info ;) 

- Kirti 

-Original Message-
Sent: Friday, February 21, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L


Lisa,
 
A combination of 'lsdev  -C', 'lsvg' (many options), 'lspv' (many options)
and 'lslv' should be sufficient enough. I have been off AIX for about three
years now, so don't remember the details. 
 
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-
Sent: Friday, February 21, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L



AIX 4.3.3 
Can anyone tell me if there's a command to determine what volumes/disks are
on each controller? 

I'm way out of my element here but the SA for this system is scarce. 

Thanks for any suggestions, and have a great weekend everyone 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: AIX question

2003-02-21 Thread Deshpande, Kirti

Lisa,
Thanks. 

I will be in Orlando for IOUG Conference... 

Till then your 'virtual equivalent' will be consumed sparingly :) 

Regards,

- Kirti  

-Original Message-
Sent: Friday, February 21, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L


WOO HOO!  Thank you thank you!

Kirti, next time you are in Florida I will buy you a beer or lunch, or both.  
Fantastic, this is exactly what I needed!  For now, please accept the virtual 
equivalent :)

Muchas Gracias !  Have a peaceful and restful weekend.  

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117  
Fax:954-935-3639
Cell:954-683-4459


-Original Message-
Sent: Friday, February 21, 2003 3:23 PM
To: [EMAIL PROTECTED]
Cc: Koivu, Lisa


Try this:
 lsdev -C -c adapter (to get controller info)
 lsdev -C -c disk (to see what devices are on what controllers) First col is the 
hdisk, 3rd col is the controller number, last col is controller name. 
 No need to be root to get this info ;) 

- Kirti 

-Original Message-
Sent: Friday, February 21, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L


Lisa,
 
A combination of 'lsdev  -C', 'lsvg' (many options), 'lspv' (many options)
and 'lslv' should be sufficient enough. I have been off AIX for about three
years now, so don't remember the details. 
 
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-
Sent: Friday, February 21, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L



AIX 4.3.3 
Can anyone tell me if there's a command to determine what volumes/disks are
on each controller? 

I'm way out of my element here but the SA for this system is scarce. 

Thanks for any suggestions, and have a great weekend everyone 


The sender believes that this E-Mail and any attachments were free of any virus, 
worm, Trojan horse, and/or malicious code when sent. This message and its attachments 
could have been infected during transmission.  By reading the message and opening any 
attachments, the recipient accepts full responsibility for taking proactive and 
remedial action about viruses and other defects. The sender's business entity is not 
liable for any loss or damage arising in any way from this message or its attachments.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: AIX question

2003-02-21 Thread Deshpande, Kirti

Title: AIX question



Kevin,
Thanks for sharing those scripts. :) 

Those are *good* !!I am 
keeping those. 

- 
Kirti 

  -Original Message-From: Kevin Lange 
  [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 1:25 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  AIX question
  Lisa;
   Here is a set of 3 scripts that I used to map 
  our disks on an IBM S70a with a large SSA Disk set that used the AIX Logical 
  Disk Manager. You might be able to glean all the commands from the 
  scripts  or just use them yourself if they work on your system. The 
  get_info.sh script calls the procedure that the included sql script 
  creates. A sample output is in the info.dat file.
  
  Any 
  questions, contact me off list .
  
  Kevin
  
  
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 
11:20 AMTo: Multiple recipients of list 
ORACLE-LSubject: AIX question
AIX 4.3.3 Can 
anyone tell me if there's a command to determine what volumes/disks are on 
each controller? 
I'm way out of my element here but the SA for 
this system is scarce. 
Thanks for any suggestions, and have a great 
weekend everyone 
Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 
Coconut Creek Parkway Ft. Lauderdale, 
FL, USA 33063 Office: 
954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459

RE: Automatic Segment Space Management

2003-02-20 Thread Deshpande, Kirti

Gopal,
 Thanks for the info.
 As I said earlier, I have not played a lot with ASSM.

- Kirti


-Original Message-
Sent: Thursday, February 20, 2003 5:10 AM
To: Multiple recipients of list ORACLE-L


Kirti:

I have not complely following this thread. But I am sure it is worth
mentioning even if someone already mentioned also. In ASSM there would
be two highwatermarks called low high water mark and high high water
mark.

The high high water mark is the actual high water mark (like in the
Freelist Managed Segments) and the low high water mark is the new one
which is introduced in ASSM. i.e till low HWM all blocks are completely
used and from LHWM to HWHM there could be some blocks unused. During
sequential scan it has to read till HHWM (i.e it should scan empty
block also).

But I think by scanning the L2 bitmaps the process can find the unused
blocks and skip that during sequential scanning, though I have not
tested it thoroughly.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA (Now in Austria)





--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 In a very limited tests that I performed with ASSM (quite some time
 ago), I found that it tends to use a bit more space than non-ASSM.
 Something to keep in mind when FTS is used to access tables. 
 Not sure if this changed in 9.2.0.2.x. 
 
 - Kirti 
 

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: converting NT batch files to Unix shell

2003-02-20 Thread Deshpande, Kirti

. re-write those in Perl. Test the Perl version on NT. It will work on UNIX as 
well :) 
Am I right, Jared? 

- Kirti 
(Perl Newbie)

-Original Message-
Sent: Wednesday, February 19, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L


The best thing to do is document the logic in the script,
throw it away, and rewrite it in the shell of your choice.

Unless of course you can find some automated utility
to convert batch files to shell.

Jared





kommareddy sreenivasa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 02/19/2003 01:43 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:converting NT batch files to Unix shell


Hi DBAs,

OS: Solaris 2.8
DB: 8i

Is there any tricks/techniques ( or documentation) to
convert NT batch file to Unix shell script.

( seems to be the question silly.)

But I really need it for our new project.

This is to migrate the data (flatfiles) to oracle from
AS400.

We have received some batch files written in NT (along
with the data (flat) files, and if we can convert the
batch files  to unix shell script the process would
become easy for migration.

Thanks in advance,
Srinivas


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 Names Server 8.1.7 on HP 11

2003-02-20 Thread Deshpande, Kirti




We run 
4 Names servers on 4 different host machines, each having its own repository 
database on that host. 
These 
are defined in various preference order in SQLNET.ora file on various clients. 
Repository databases are monitored by other mechanisms. 

- 
Kirti 

  -Original Message-From: Zabair Ahmed 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 11:19 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle Names Server 8.1.7 on HP 11
  We've currently got Names Server running on 4 host boxes. If one Names 
  server is down, the client is configured to automatically attempt to connect 
  to the next one in the list. We had a problem recently were, if we issued a 
  tnsping from any of the clients we got the following message.
  TNS-03505 - Failed to resolve name
  This implies that our client PC is unable to resolve the name and hence was 
  not able to connect to the database. Usually this implies that something is 
  wrong with all our Oracle Names servers. 
  Inorder to resolve this problem, I had to kill the Names Server on each of 
  the 4 boxes and restart it.
  The Names servers had somehow lost connection to the Oracle Names 
  repository database, although the servers appear to be attached to the 
  database.
  I reckon we canreduce the chances of this problem occuring again, by 
  adding a second Oracle Names database repository in our database cluster. This 
  means, that if the NAMES servers lose connection to one repository, they can 
  fall back on the second database without any loss of service.
  What have other people done with their Names Server and respository and do 
  they see any draw backs with the above.
  Sorry for the long email.
  TIA
  
  
  
  With Yahoo! Mail you can get a bigger mailbox -- choose a 
  size that fits your needs

RE: GRRRRR OWS

2003-02-20 Thread Deshpande, Kirti

Title: RE: GR OWS



FWIW

We have ASSP, SCRP,SCRU... 

:) 


- 
Kirti 
-Original Message-From: 
Loughmiller, Greg [mailto:[EMAIL PROTECTED]]Sent: 
Thursday, February 20, 2003 1:16 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: GR OWS

  LMAO.. Now you need a database named WHUP and A$$ 
  
  -Original Message- From: 
  Stephen Lee [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, February 19, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: GR OWS 
  A good website for appropriate telephone technique can be 
  found at 
  www.roydmercer.com 
  Roy D. Mercer is such an inspiration that we even have test 
  databases named ROY and MERCER. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  -- Author: Stephen Lee 
   INET: [EMAIL PROTECTED]

RE: direct path read waits

2003-02-20 Thread Deshpande, Kirti

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 unauthenticated remote system compromise (

2003-02-20 Thread Deshpande, Kirti

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: storage clause

2003-02-20 Thread Deshpande, Kirti

I suggest reviewing Oracle Concepts Guide as well. It has a lot of good basic 
information. 

- Kirti 

-Original Message-
Sent: Thursday, February 20, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L


Dennis,

sorry for being not clear. in fact, i dont even know the proper approach to
take if i have to resize the table. ok, so 1st input required is how many
rows will the table have ? 2nd is the growth pattern ?

now is there a certain approach to it ? say like, if the table is having
100,000 rows and then depending on the growth pattern, the table can be
sized using a certain set of rules ?

to be brief, what r the rules/steps that u all follow during defining a
table ? what points r considered  how do those play in sizing the table ?

sorry if i m asking very basic :(

Thanks !

ps : in the meanwhile, i m reading abt LMT !!!


-Original Message-
WILLIAMS
Sent: Thursday, February 20, 2003 3:46 PM
To: Multiple recipients of list ORACLE-L


Mad Cap
   First of all, you didn't say how many rows you were storing in it.
Second, what is the growth pattern - static, steady growth, fill and empty?
   Study up on Locally Managed Tablespaces with Uniform Extents (LMT). Then
pretty much the only decision is whether to use 128k, 4m, or 128m extent
size.

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


-Original Message-
Sent: Thursday, February 20, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus ...

can somebody help in sizing the table/index using the storage clause ? what
r the key values to check and how to calculate the table size  the related
storage parameters ? how does it change from an OLTP appln to a
Datawarehouse ?

lets say for the table emp :
Name Null?Type
  
EMPNONOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB   VARCHAR2(9)
MGR   NUMBER(4)
HIREDATE  DATE
SAL   NUMBER(7,2)
COMM  NUMBER(7,2)
DEPTNONUMBER(2)

TIA !


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

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

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

Resolved -- RE: Oracle unauthenticated remote system

2003-02-20 Thread Deshpande, Kirti

/

Telephone +44 208 401 0070
Fax +44 208 401 0076

[EMAIL PROTECTED]





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Automatic Segment Space Management

2003-02-19 Thread Deshpande, Kirti

In a very limited tests that I performed with ASSM (quite some time ago), I found that 
it tends to use a bit more space than non-ASSM. Something to keep in mind when FTS is 
used to access tables. 
Not sure if this changed in 9.2.0.2.x. 

- Kirti 

-Original Message-
Sent: Wednesday, February 19, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


Jay,

I have been using ASSM for last five months in our Datawarehouse
environment. Haven't had a chance to play with the OLTP side, yet.

Inserts are way faster as compared to system managed extent allocation. I
read Don's article on DBAZINE. However, I would like to add one caveat here:
ASSM does not *eliminate* buffer busy waits as the article claims; it
*reduces* them. BBW occur due to concurrent access to a buffer by more than
one session. This will be the case regardless of number of freelists. While
ASSM eliminates the freelist contention - thereby reducing BBW in inserts -
it does not reduce the likelihood that more than one sessions will try to
get the same block to the buffer cache simulataneously.

Table drops appear a little slower in ASSM; but that could be wrong - I
never timed dropping a table in the system managed mode.

HTH.

Arup Nanda


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 9:33 AM


 I'm continuing to introduce myself to 9i.  I've been reading about
Automatic Segment Space Management, and I just wondered if anybody had any
positive/negative experiences with it.  I got some good info at:

 http://www.dbazine.com/burleson11.html


 Thank you,


 Jay Hostetter
 Oracle DBA
 D.  E. Communications
 Ephrata, PA  USA





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: 8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Deshpande, Kirti

Ron,
This is not a problem due to the absence of sgadef file. This file was obsolete with 
8i. 
Your problem seems to be Oracle environment /or Sql*Net related. 
Please check tnsnames.ora, sqlnet.ora, service names etc. on the client. Can you 
connect to any other instance from this client? 

FWIW: 
The sgadef file had following text in 8.0.x versions:
  
This file is now obsolete.  It will be removed in a future release.
To determine whether an instance is up, you should check for the
existence of the PMON process associated with the instance.


HTH,

- Kirti

-Original Message-
Sent: Tuesday, February 18, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L


I have an 8.1.7 Oracle instance on a server that does not create an SGADEF
file when it is started up.  There are no errors in the log or trace files.
As a result of this file not being created, I cannot connect to the database
from a remote client.  I get an error that says the instance is not running.
I can connect to the instance from SVRMGRL on while logged onto the server.
Any ideas why the file would not get created?

Thanks!
Ron Smith


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: DBMS_JOB

2003-02-18 Thread Deshpande, Kirti

Mark, 
 You may want to check http://asktom.oracle.com. 
 I think there are a few examples that you will find come close to what you are 
looking for.

 - Kirti

-Original Message-
Sent: Tuesday, February 18, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes,
unless the time of day is between X and Y (for example 00:00am  03:00am)?

All help appreciated! Pointers to RTFM more than welcome! ;)

Mark

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

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

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Teradata banned from IOUG???

2003-02-18 Thread Deshpande, Kirti




Thanks 
you, Dan.

Very 
nicely put. 

- 
Kirti 

  -Original Message-From: Daniel W. Fink 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:31 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Teradata banned from IOUG???IOUG is a volunteer 
  organization. If you don't like something about it, you can change it from the 
  inside by becoming involved. Remember, the Board Of Directors election is 
  currently open and it is a way to voice your opinion. Also, send feedback 
  about things you don't like, offer solutions and offer to assist in making the 
  change (the most important!). Don't like the articles in SELECT? Offer to 
  write one or be an editor. Don't like the content on the website? Become a tip 
  miner.IOUG-A Live is also volunteer run. Speakers are volunteers, many 
  of the workers are volunteers. As a speaker, the amount of time (and expenses 
  I pay for myself as do many others) spent on the papers and presentation is 
  high. I think it is worth it, as long as I can help 1 person be a better 
  technician. I try to make the paper and presentation as accurate and helpful 
  as I can. In the past, I have had no support (financial or otherwise) from my 
  employers in attending/speaking at conferences, but I consider it worth my 
  time. If you don't like the lineup of speakers, submit for next 
  year.For those who are attendees, it is important to show support to 
  the speakers you respect and the topics that interest you. How many of you 
  fill out the session evaluations? Do you rate the presentations on 
  entertainment value or meaningful content? Do you encourage other people to 
  attend the 'good' presentations? Do you fill out the conference 
  evaluation?Our local user group has seen Oracle's involvement decrease 
  drastically over the past few years. Recently, thanks to an excellent Oracle 
  contact, who is a long time contributor to our organization, we are meeting 
  together to find ways to help each other. Of course, the sales folks want to 
  know "How many new $$$ can we get by pitching new products at meetings?" 
  (strictly forbidden at our meetings if it parades as a technical session). We 
  are finding creative ways to get the groups together, such as having Oracle 
  host a SIG meeting in exchange for a brief sales pitch at the beginning, 
  establishing a specific Vendor track at our annual Traning Days. Attendees 
  know that the intent of the pitch/presentation and they also know that the 
  technical sessions will be technical and not marketing.IOUG can 
  survive without Oracle, TUSC or myself. The question is whether or not that is 
  for the best. Oracle and TUSC employees can provide some great sessions and 
  information. They can also provide fluff and bad information. If we provide 
  constructive feedback, the organization will either change or begin losing 
  membership and disappear.Dan FinkPeter Barnett wrote:
  It seems to me that IOUG has become a wholly owned
subsidiary of TUSC.  TUSC in turn has an incestuous
relationship with Oracle.  All very cozy.

No real complaint about the arrangements.  Someone has
to step up to the plate if IOUG is going to continue
to be a viable organization and in this economic
climate few can afford to do it.

Should IOUG be able to survive without Oracle? 
Probably.  Will it be able to survive without Oracle? 
I doubt it.

RE: Help Oracle 9i db creation scripts

2003-02-17 Thread Deshpande, Kirti

Here is one that I used for my test database:

create database KED9
  maxinstances 1
  maxloghistory 200
  maxlogfiles 4
  maxlogmembers 4
  maxdatafiles 100
  character set us7ascii
  controlfile reuse
datafile '/u801/oradata/KED9/system_01.dbf' size 300M reuse
default temporary tablespace temp 
tempfile '/u802/oradata/KED9/temp_01.dbf' size 100M reuse
extent management local uniform size 1M
undo tablespace undo_tbs 
datafile '/u803/oradata/KED9/undo_tbs_01.dbf' size 300M reuse
logfile group 1 ('/u804/oradata/KED9/redo_g1m1.log') size 100M reuse,
group 2 ('/u805/oradata/KED9/redo_g2m1.log') size 100M reuse,
group 3 ('/u806/oradata/KED9/redo_g3m1.log') size 100M reuse
;

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

create tablespace users
datafile '/u801/oradata/KED9/users_01.dbf' size 100M reuse
extent management local uniform size 1M;

create tablespace data
datafile '/u802/oradata/KED9/data_01.dbf' size 200M reuse
extent management local uniform size 1M;

create tablespace indx
datafile '/u803/oradata/KED9/indx_01.dbf' size 200M reuse
extent management local uniform size 1M;


- Kirti

-Original Message-
Sent: Monday, February 17, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L


Oracle 9i R2 
Solaris 8 
LIST, 
I always create my databases from scripts, and I have Oracle 8i create database 
scripts.  I've been trying to get Oracle 9i DBCA working for several days, and all I 
get is the initializing screen. I've checked metalink, google, and orafaq for 
resolutions, but I'm running out of time.
Does someone have a script for Oracle 9i database creation I can use as a base for my 
new 9i database with the new features included?
TIA 
M.Godlewski 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: ORA-00106

2003-02-17 Thread Deshpande, Kirti

Use a dedicated connection to stop/start a database. 
Connection via MTS (Shared Server) does not allow such tasks.

- Kirti 

-Original Message-
Sent: Monday, February 17, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I try to shutdown my database via Oracle Instance Manager but I get
ORA-10106 error.
Could someone on the list help me how to solve it.

Rgrds,

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

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

Hotsos Symposium in Dallas

2003-02-12 Thread Deshpande, Kirti

The Hotsos Symposium in Dallas, that concluded this afternoon, was one of best 
educational, informative and entertaining conferences I ever attended in my Oracle 
career. If you dealt with Oracle system performance, as a DBA and/or Developer, Dallas 
was the place to be for the past 3 days. The conference was full of excellent 
presentations by World's leading Oracle Scientists. All of them were very responsive, 
interested in helping you out, and eager to listen to what one has to say, and that 
made this Conference very different and very special. 

Other than learning about Oracle system performance, it was also interesting to learn 
that JL can play trombone very well, and Mogens can ride the bull  ;)  
The party at the Austin Ranch was wonderful and entertaining. 

I am looking forward to the next year's Hotsos conference in Las Vegas  :) 

Very well done, Cary and all Hotsos staff !!  

Cheers!

- Kirti 




 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Teradata banned from IOUG???

2003-02-12 Thread Deshpande, Kirti

I think Jared meant : Pointy Haired Boss  (from Dilbert)

- Kirti 


-Original Message-
Sent: Wednesday, February 12, 2003 9:04 PM
To: Multiple recipients of list ORACLE-L




PHB's?  I looked it up and all I could find that fit was Psycho Hose
Beast. Is that correct?

http://www.acronymfinder.com/af-query.asp?Acronym=PHB



   
 
  Jared.Still@radis
 
  ys.com   To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: Teradata baned from 
IOUG???
   
 
   
 
  02/12/03 05:03 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




I can't imagine why they would want to replace Oracle with Teradata.

It's expensive.  It runs only on NCR or Windoze.

The architecture is nothing special.

I imagine the PHB's had their fingers in those moves.

Been there, got the T-shirt, now it's a dust rag.

Jared



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-07 Thread Deshpande, Kirti

Here is a link to IBM site showing a matrix for AIX 4.x support. Fix the link if it 
wraps around.
We had a meeting yesterday to begin upgrading Servers to AIX 5.1 first, for a short 
duration,  and then to 5.2. 

http://www2.ibmlink.ibm.com/cgi-bin/master?xh=YUKoCSGfrgPYSK2USenGnN9332request=salesmanualparms=H%5F5765%2DC34xhi=salesmanual%5Exfr=N

- Kirti

-Original Message-
Sent: Thursday, February 06, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


OMG are you KIDDING

Do you know when??  I just found out (as you may remember from my Just Shoot Me 
post) that IBM's version of desupport is don't even ask us.  

Thank you so much Ruth for pointing this out.  

Have a great day.
Lisa
-Original Message-
Sent: Thursday, February 06, 2003 2:23 PM
To: Multiple recipients of list ORACLE-L


By the way, Lisa.  AIX 4.3.3 is being desupported.  We are testing 9i on AIX5.2 as I 
write this.  I could not get the powers that be to move away from 8.0.x and now we are 
jumping right to 9i.  I did install 8.1.7 and use OEM2.2, but that won't support a 9i 
database.  I will install the new OEM tomorrow or Monday.

Ruth
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Thursday, February 06, 2003 1:51 PM


Lisa,

Try oslevel -r at the command promt.  It should tell you.

-Scott

At 09:49 AM 2/6/03 -0800, you wrote:

Hi Ethan, 
 
Thanks so much for your reply.  I'll have to check which patch level we are on. 
 
Have a great day!
Lisa 
-Original Message- 
Sent: Thursday, February 06, 2003 11:05 AM 
To: Multiple recipients of list ORACLE-L 


No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit. 
Lisa, 
Be aware that there are some issues with ML9 as I am finding out with swap.  We are 
planning on going to ML10 which should fix the problem as well as using vmtune command 
to change the system to use less OS Cache for files, I forgot the exact syntax.  
Happily the problem on these boxes is rare and no one complains so I am not rushing to 
make the changes but if you are running app servers on the same host you could see 
this a lot possibly.  Search the AIX group on google for vmtune oracle and also 
check out the new Database Tuning book at IBM Redbooks, it was released in the past 
couple of weeks so it should be easy to find.  It talks about all the vmtune settings. 
 Also we are seeing issues with some of the psoft processes (Solaris app server) using 
up all the memory on the box when one of the jobs is run (not sure which one), appears 
to be a memory leak of some sort, we are working on it (just a note, the peoplesoft 
environment is not the AIX environment I spoke about). 
- Ethan 
-Original Message- 
Sent: Thursday, February 06, 2003 8:24 AM 
To: Multiple recipients of list ORACLE-L 


Good morning everyone - 
Quick poll for those of you on 8.1.7 and AIX 4.3.3:  
Do you have TIMED_STATISTICS = true?  Have you encountered any problems with it? 
The databases I inherited have this set false all over the place, hence my tuning 
efforts are really limited.  However I don't want to change it without checking around 
first. 
And a tuning question: 


This environment (peoplesoft) is very very low on memory.  When the app servers and 
databases are up there's less than 50MB of memory free.  Adding hardware is not a 
choice here. 
The databases have 100MB set for the SGA.  It really looks like not much thought went 
into some of the parm settings.  
What I've read about tuning says that you must have a goal in mind.  Well, afaik 
nothing is broken, nothing is suffering - then again, no one really paid much 
attention to Oracle.  It was up, fine, move on.  Am I on the wrong path if my goal for 
tuning is to figure out if I can reduce the size of the SGA and redo logs without 
adversely affecting performance? 
Any comments are appreciated.  Thanks everyone 
Lisa Koivu 
Oracle Dingbat Administrator 
Fairfield Resorts, Inc. 
5259 Coconut Creek Parkway 
Ft. Lauderdale, FL, USA  33063 
Office: 954-935-4117  
Fax:954-935-3639 
Cell:954-683-4459 



**
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.net
-- 
Author: Deshpande, Kirti
  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 Migration Workbench for Sybase

2003-02-06 Thread Deshpande, Kirti

Thanks for your response.

This morning I was informed that there is a Sybase Open Client CD that I can use (if 
they could find it :) We do have a few Sybase products, so we have support, licenses 
etc 

We will be exploring both known avenues to get the data into Oracle database. Sybase 
bcp and OMWB. I wanted to test the OMWB path while developers figure out bcp, disk 
space for flat files, SQL*Loader control files etc... 

- Kirti

-Original Message-
Sent: Wednesday, February 05, 2003 9:59 PM
To: Multiple recipients of list ORACLE-L


Hello Listers,
 Anyone used this tool? What was your experience like? 
 I am planning on using it to move about 20GB of data from a Sybase 11.x database to 
Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') 
is the alternate solution. I would like see if we could use OMWB for this. The doc 
says I need Sybase Adaptive Server ODBC driver Release 3.11.00.01.   Searched Sybase 
web site for this driver, but failed to locate it. 
 Any ideas about its source?  

 Thanks.

- Kirti 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: First version with multiple archiver processes?

2003-02-06 Thread Deshpande, Kirti

No problem, Jeremiah. 
I never could open Peter's e-mails due to some error stating 'Your Digital ID name can 
not be found by the underlying security system'. 

I saw what he posted in your message.

I was not aware of this Oracle7 'feature'... Sounds like an un-documented trick :) 

Thanks,

- Kirti 

-Original Message-
Sent: Thursday, February 06, 2003 3:39 AM
To: Multiple recipients of list ORACLE-L


Sorry Kirti, that was meant for Peter.

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

On Thu, 6 Feb 2003, Jeremiah Wilton wrote:

 Kirti
 
 In v.7 the archiver is called ARCH.  If 'archive log start to xxx'
 starts another, what is it called?
 
 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton
 
 On Wed, 5 Feb 2003, Peter Gram wrote:
 
  Kirti
  
   From version 7.x you can manually start multiple archive processes by 
  using the archieve log start to destnation and the added
  processes wil die when there is no more redofiles to archive, but for 
  permanent having multiple processes the answer is 8.1.3 :-)
  
  Deshpande, Kirti wrote:
  
  I can think of 8.1.3.
  
  - Kirti
  
  -Original Message-
  Sent: Wednesday, February 05, 2003 6:04 PM
  To: Multiple recipients of list ORACLE-L
  
  
  What was the first version of Oracle with the ability to start
  multiple archiver processes?
  
  --
  Jeremiah Wilton
  http://www.speakeasy.net/~jwilton
  
  
  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-06 Thread Deshpande, Kirti

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question



Lisa,
We have several databases on AIX 4.3.3/8.1.7.x. All of them have 
TIMED_STATISTICSset to TRUE. 
Not problems havebeenencountered. 

And about that tuning question: May bethose are all dedicated 
connections, if so check what's set for SORT_AREA_SIZE at the instance level, 
may be there are other non-Oracle processes (application daemons etc.) that are 
memory bound. And if no one is complaining, and all tasks are completed in an 
acceptable time frame, you can just collect 'baseline' data for future 
reference, when the 'database' is at fault ;) 

HTH,

- 
Kirti 
-Original Message-From: 
Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, 
February 06, 2003 8:24 AMTo: Multiple recipients of list 
ORACLE-LSubject: AIX 4.3.3 / 8.1.7  Timed Statistics  
Tuning Question

  Good morning everyone - 
  Quick poll for those of you on 8.1.7 and AIX 
  4.3.3: 
  Do you have TIMED_STATISTICS = true? Have you 
  encountered any problems with it? 
  The databases I inherited have this set false all 
  over the place, hence my tuning efforts are really limited. However I 
  don't want to change it without checking around first. 
  And a tuning question: 
  This environment (peoplesoft) is very very low on 
  memory. When the app servers and databases are up there's less than 50MB 
  of memory free. Adding hardware is not a choice here. 
  The databases have 100MB set for the SGA. It 
  really looks like not much thought went into some of the parm settings. 
  
  What I've read about tuning says that you must have 
  a goal in mind. Well, afaik nothing is "broken", nothing is suffering - 
  then again, no one really paid much attention to Oracle. It was up, 
  fine, move on. Am I on the wrong path if my goal for tuning is to figure 
  out if I can reduce the size of the SGA and redo logs without adversely 
  affecting performance? 
  Any comments are appreciated. Thanks everyone 
  
  Lisa Koivu Oracle Dingbat Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA 33063 Office: 954-935-4117 
  Fax: 954-935-3639 
  Cell: 954-683-4459

RE: Oracle Migration Workbench for Sybase

2003-02-06 Thread Deshpande, Kirti

Reed,
 Thanks. 
 I do not know what we may have. They (Sybase DBAs) are still looking for the CD for 
me. 
 May be this newer release of the driver might work with OMWB... 
 
- Kirti

-Original Message-
Sent: Thursday, February 06, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L


Kirti,

I am no Sybase expert, but I am staring at a Sybase to SQL Server migration,
and I installed the Sybase client tools on my machine and it gave me Sybase
Adaptive Server ODBC driver Release 3.50.00.10.  Unfortunately I can't tell
you if my version is newer or yours is (50 is bigger than 11.. ;-)

Hope this helps at least a little bit.

-Original Message-
Sent: Wednesday, February 05, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L


Hello Listers,
 Anyone used this tool? What was your experience like? 
 I am planning on using it to move about 20GB of data from a Sybase 11.x
database to Oracle 8i (Rel 3). This is a one time activity. Flat file route
(using Sybase 'bcp') is the alternate solution. I would like see if we could
use OMWB for this. The doc says I need Sybase Adaptive Server ODBC driver
Release 3.11.00.01.   Searched Sybase web site for this driver, but failed
to locate it. 
 Any ideas about its source?  

 Thanks.

- Kirti 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Windows 2000 Cluster on oracle

2003-02-06 Thread Deshpande, Kirti

I had to apply the SP1 for Oracle to run.
I built the PC from all off-the-shelf inexpensive parts ;) 

I will now let my Win NT4.0 Server die on its own... 
- Kirti

-Original Message-
Sent: Thursday, February 06, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L


upto you if you're sure that your Windows is OK.

But, You have to carefull with the service pack in Windows 2K. I suggest if
your O/S (Win2K) running well ,please don't apply the service if not
necessary.

BTW, What kind of server that you used and spec of the server ?

Thank's
Bernardus Deddy Hoeydiono.

-Original Message-
Kirti
Sent: Thursday, February 06, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L


My recent PC runs Win 2000 Server edition. I have two 9i Rel 2 databases
running on it with no problems thus far.
In the past several weeks (since I got it), it has not booted by itself. But
my NT 4.0 Server (3 years old now), did that twice, in the middle of the
night, when no one was watching ;)

- Kirti

-Original Message-
Sent: Wednesday, February 05, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


As much as I hate defending Windoze, Win2k is in fact rather stable,
at least Win2k server is.  I have one system on Win2k that I reboot,
oh, every 6 months or so.

Death to NT though.

Jared






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Hanging query puzzle

2003-02-06 Thread Deshpande, Kirti

Henry, 
 I got aiostat from IBM Support when I bugged them about how to monitor AIO. Not sure 
if aiostat is readily available as a download from their Web site or in/for the newer 
versions of AIX. 
 It works similar to vmstat and iostat, showing number of pending AIO requests at the 
time of sampling. Following is an example from one of our Servers, showing 10 samples 
at 1 sec interval. Ideally, the count should be 0 at all times. If it stays high 
(relative term) consistently then one needs to increase the number of configured AIO 
servers, or check the I/O subsystem for other problems... 
 By default, aiostat must be run as 'root'.

HTH,

- Kirti

ibmRS50 [VS9XBP]# aiostat 1 10
AIO requestcount: 1
AIO requestcount: 0
AIO requestcount: 0
AIO requestcount: 1
AIO requestcount: 0
AIO requestcount: 2
AIO requestcount: 0
AIO requestcount: 3
AIO requestcount: 0
AIO requestcount: 0

-Original Message-
Sent: Thursday, February 06, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L


Kirti,
I've been searching on the IBM site for aiostat without much luck. What kind
of information does it give you? (if I'm going to convince my SA to call IBM
about this I'll need a very good argument. I'm still working on getting the
rights to use sar).

Henry


-Original Message-
Kirti
Sent: Wednesday, February 05, 2003 8:29 PM
To: Multiple recipients of list ORACLE-L


Jeff,

If you see the SEQ# field in the v$session_wait view not incrementing, then
something else, other than Oracle, is causing a hang up...

On AIX, if you have AIO enabled, try running 'aiostat'. It will show if
there are any pending AIO requests. The difficult part would be to relate
those pending calls to your session. It is quite likely that a particular
AIO server may show waits on I/O, if this hang up is IO related. You can try
'pstat' to find out AIO server processes and associated 'pid' to dig deeper.

If you do not have 'aiostat', ring up IBM Support. It is a nice utility to
have, and it is free.


For those on AIX 5L, can you please check if 'aiostat' is available as a
standard distribution? I was told by IBM Support that 'aiostat' was going to
be available with AIX 5L.

- Kirti

-Original Message-
Sent: Wednesday, February 05, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L



It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.

You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU.  Perhaps truss (or the AIX
equivalent) might show your process
spinning on whatever call equates to
'has the async read completed yet'.


You could try doing three processstate
dumps with 5 second intervals to see if
the processstate shows any changes
which might give you a hint - but again
I'd GUESS that you'll find nothing happening.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: 7.3.4 upgrade

2003-02-05 Thread Deshpande, Kirti

Hmm... there was nothing in that attachment... :(

When I did this, I followed the Migration Utility Guide. Those steps always worked... 
:) 

- Kirti 

-Original Message-
Sent: Wednesday, February 05, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L


Wow, never thought I'd see a request like this. :)
Nothing wrong to ask though, who knows, someone here might
have the time and resource to do it.

Let me know the kind soul who will do this.  I have a list
of my own test to give out.

:)

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I've prepared a small list of steps to follow for
an upgrade of 7.3.4 database to 9.2

However unfortunately I do not have access to a 7.3.4 database

Can one of you who has access to 7.3.4 database, try these steps
out and give me your 'honest' feedback?

Thanks a lot

Cyril


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Hanging query puzzle

2003-02-05 Thread Deshpande, Kirti

Jeff,

If you see the SEQ# field in the v$session_wait view not incrementing, then something 
else, other than Oracle, is causing a hang up... 

On AIX, if you have AIO enabled, try running 'aiostat'. It will show if there are any 
pending AIO requests. The difficult part would be to relate those pending calls to 
your session. It is quite likely that a particular AIO server may show waits on I/O, 
if this hang up is IO related. You can try 'pstat' to find out AIO server processes 
and associated 'pid' to dig deeper.  

If you do not have 'aiostat', ring up IBM Support. It is a nice utility to have, and 
it is free. 


For those on AIX 5L, can you please check if 'aiostat' is available as a standard 
distribution? I was told by IBM Support that 'aiostat' was going to be available with 
AIX 5L.  

- Kirti  

-Original Message-
Sent: Wednesday, February 05, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L



It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.

You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU.  Perhaps truss (or the AIX
equivalent) might show your process
spinning on whatever call equates to
'has the async read completed yet'.


You could try doing three processstate
dumps with 5 second intervals to see if
the processstate shows any changes
which might give you a hint - but again
I'd GUESS that you'll find nothing happening.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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


-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 05 February 2003 21:05


Still sitting there, while we try to figure out exactly why it's
waiting.


  SID Username EVENT
WAIT_TIME STATE   SECONDS_IN_WAIT
-  --

-- --- ---
1  pmon timer
0 WAITING   79579
5  smon timer
0 WAITING  80
   12  slave wait
0 WAITING 199
   13  slave wait
0 WAITING 199
   14  slave wait
0 WAITING 262
   15  slave wait
0 WAITING 199
   28 NIK  db file scattered read
0 WAITING   20119

-Original Message-
Sent: Wednesday, February 05, 2003 2:58 PM
To: [EMAIL PROTECTED]
Cc: Thomas Jeff




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

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

RE: SQL Tuning Help

2003-02-05 Thread Deshpande, Kirti

Sundeep,
 Have you reviewed Tim Gorman's paper titled: 'The Search For Intelligent Life In The 
Cost-Based Optimizer'? Check it out at http://www.evdbt.com. It may help. 

- Kirti
 

-Original Message-
Sent: Wednesday, February 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.7.4 on HP-UX

I am using collections to pass multiple values from client to the
database to gather values for more than input values. The queries
produce the results but the without the RULE hint the response is
dramatically slower. Following is just one of the examples but I have
many many queries which exhibit the same behavior.  

Since RULE based optimization is headed for the chopping block we are
wondering what is the alternative.

SELECT  eqp.equipment_id, 
eqp.manufacturer_code, 
eqp.model_num, 
eqp.equipment_serial_num, 
DECODE(SIGN(eqp.last_pm_performed_at_hrs -
eqp.current_meter_reading_hrs),1,   
'SMU_ADJUSTED',eqp.last_pm_performed_at_hrs) smu_adjusted, 
eqp.productlink_equipment_code, 
ecps.pm_schedule_name, 
epp.performed_datetime, 
DECODE(epp.comment_text,NULL,1,0) comments_available, 
  emr.reading_date, 
emr.meter_reading_value, 
equipment_event_log.event_status(eqp.equipment_id,2), 
equipments_next_pm_due.pms_due_list(eqp.equipment_id) pms_due_list, 
equipments_next_pm_due.perform_at_hrs_cnt(eqp.equipment_id)
next_pm_hrs 
   FROM equipments eqp, 
equipment_meter_readings emr, 
equipment_pm_performed epp, 
equipment_class_pm_schedules ecps, 
TABLE(CAST(id_table_t(100071,100072,100073,100074)
AS id_table_t)) eqp_list 
  WHERE eqp.epp_id_last_pm_performed = epp.epp_id (+) 
AND eqp.emr_id_current_meter_reading = emr.emr_id (+) 
AND epp.ecps_id = ecps.ecps_id (+) 
AND eqp.equipment_id = eqp_list.column_value
/

Plan:
SELECT STATEMENT Hint=CHOOSE8 K 510  
  HASH JOIN OUTER   8 K 582 K   510  
HASH JOIN OUTER 8 K 510 K   497  
  HASH JOIN OUTER   8 K 390 K   489   
HASH JOIN   8 K 279 K   287   
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS FULL EQUIPMENTS  192 K   6 M 256
TABLE ACCESS FULL   EQUIPMENT_METER_READINGS221 K   2 M 151
 
 
  TABLE ACCESS FULL EQUIPMENT_PM_PERFORMED  96  1 K 
TABLE ACCESS FULL   EQUIPMENT_CLASS_PM_SCHEDULES2 K 22 K4  

Following is the Plan with /*+ RULE */ hint has the expected fast
response and the desired plan:

SELECT STATEMENT Hint=HINT: RULE 
  NESTED LOOPS OUTER 
NESTED LOOPS OUTER
  NESTED LOOPS OUTER 
NESTED LOOPS 
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS BY INDEX ROWID   EQUIPMENTS   
INDEX UNIQUE SCAN   EQP_PK   
TABLE ACCESS BY INDEX ROWID EQUIPMENT_PM_PERFORMED   
  INDEX UNIQUE SCAN EPP_PK   
  TABLE ACCESS BY INDEX ROWID   EQUIPMENT_CLASS_PM_SCHEDULES 
INDEX UNIQUE SCAN   ECPMS_PK 
TABLE ACCESS BY INDEX ROWID EQUIPMENT_METER_READINGS  
  INDEX UNIQUE SCAN EMR_PK

I have tried both versions IN (TABLE(CAST( as a predicate and as a
pseudo-table in FROM (as in the query above) and it made no
difference to the plan. I searched askTOM and heard similar
sentiments about performance being echoed by other users but no
solutions.  

Any tips or insights as to how to avoid the full table scans (all of
which are 10-100M in size) of the large table without the RULE hint.
A more thorough explanation of what is happening and why would be a
bonus.

TIA


=

Sundeep Maini 
Consultant 
Currently on Assignement at Caterpillar Peoria
[EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: First version with multiple archiver processes?

2003-02-05 Thread Deshpande, Kirti

I can think of 8.1.3.

- Kirti

-Original Message-
Sent: Wednesday, February 05, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L


What was the first version of Oracle with the ability to start
multiple archiver processes?

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

Oracle Migration Workbench for Sybase

2003-02-05 Thread Deshpande, Kirti

Hello Listers,
 Anyone used this tool? What was your experience like? 
 I am planning on using it to move about 20GB of data from a Sybase 11.x database to 
Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') 
is the alternate solution. I would like see if we could use OMWB for this. The doc 
says I need Sybase Adaptive Server ODBC driver Release 3.11.00.01.   Searched Sybase 
web site for this driver, but failed to locate it. 
 Any ideas about its source?  

 Thanks.

- Kirti 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Windows 2000 Cluster on oracle

2003-02-05 Thread Deshpande, Kirti

My recent PC runs Win 2000 Server edition. I have two 9i Rel 2 databases running on it 
with no problems thus far.
In the past several weeks (since I got it), it has not booted by itself. But my NT 4.0 
Server (3 years old now), did that twice, in the middle of the night, when no one was 
watching ;) 

- Kirti  

-Original Message-
Sent: Wednesday, February 05, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


As much as I hate defending Windoze, Win2k is in fact rather stable,
at least Win2k server is.  I have one system on Win2k that I reboot,
oh, every 6 months or so.

Death to NT though.

Jared



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: windows application to show sql being executed by a client

2003-02-05 Thread Deshpande, Kirti

Title: windows application to show sql being executed by a client program



Pretty cool...

A future Quest product ??? ;) 

 
Just wondering... :)

- 
Kirti 


  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 
  2003 7:59 PMTo: Multiple recipients of list 
  ORACLE-LSubject: windows application to show sql being executed by 
  a client progra
  Hello list members. A colleague of 
  mine has written a small Windows client utility that allows you to view the 
  SQL statements being issued by another client application. The utility has to 
  be running on the same machine as the other client application.
  I use it myself pretty often instead of turning on tracing a 
  session. 
  His description says: - Displays SQL 
  statements that come from processes in real-time, eliminating the necessity to 
  turn on tracing and look into poorly formatted trace file 
  - Allows monitoring NT services - 
  Displays logon attempts, both successful and unsuccessful (username, password, 
  tns alias, success) - Performs syntax highlighting 
  - Displays values of bind variables for SQL statements 
  - Shows even statements that fail to execute. Displays 
  Oracle error code and message for those statements. - 
  Allows to copy and paste statements from the output to one of your SQL 
  analyzing tools (TOAD, SQL Navigator, or even SQL*Plus) 
  - Monitors applications like Import/Export, SQLoader, Server 
  Manager (svrmgrl.exe), as well as applications written with Oracle Forms or 
  Pro*C 
  - Supports Oracle clients starting with version 7.3 
  - It's FREE! 
  He has told me that I can publicize it on the list. All he 
  asks is some feedback / bug reports. Here's the 
  link: http://www.fastalgo.com/ 
  P.S. You should send the feedback to him and not to me.

RE: Excessive library cache latch contention

2003-01-31 Thread Deshpande, Kirti

Neil,
 
 Does this application use a lot of literal SQL? 
 Do the users tend to use the same Appl processes during the peak times? 
 And do they really complain about poor performance during the peak times? 

 The contention could be due to the excessive parsing.  Since you are noticing this at 
all your sites, it sounds like more of a SQL issue. Sharing of cursors, use of bind 
variables will help. 

 Think of increasing SHARED_POOL_SIZE only when all other avenues to reduce this 
contention have been explored (and rejected). But a large shared_pool_size may worsen 
this situation.
  
 If you have access to Metalink, Note# 1012049.6 (and other notes referenced in there) 
may be of some help. 
 You can also consider use of Statspack, during the peak times (if the version of your 
database supports Statspack). 
 
- Kirti

-Original Message-
Sent: Friday, January 31, 2003 5:09 AM
To: Multiple recipients of list ORACLE-L


We've got about 30 sites all running the same application, and I'm
consistently seeing large numbers of 106 (library cache) latch free waits.
They tend to happen at peak times during the day, and in the worst case I
saw 12 sessions all on a 106 latch free wait event, spread across 3 P1RAW
addresses.

Running Steve Adams latch_sleeps scripts, yields the following:

LATCH TYPE IMPACT SLEEP RATE WAITS HOLDING
LEVEL
- --- -- -
-
library cache 1281502  0.11%   2399666
5
cache buffers chains   273556  0.00% 23049
1
shared pool 73893  0.04% 91633
7
cache buffers lru chain 12236  0.01% 70756
3
session allocation  10639  0.06% 19969
5
row cache objects7835  0.00% 29816
4
cache buffer handles 3646  0.00%  2575
3
transaction allocation   2344  0.01%  4341
8
enqueue hash chains  1831  0.01% 13722
4
redo writing  778  0.01% 17328
5
session idle bit  714  0.00% 0
1

The results above are from an instance which has been up for 5 days

As you can see, library cache latch has a big impact (though I must admit,
I'm not sure what Steve's IMPACT formula actually tells me). When I check
across other sites, I see a similar pattern - large numbers of 106 latch
misses and sleeps.

I guess what I'd like to know is where these latches are happening, which
objects / cursors etc are causing the contention. I've grappled with SQL
against x$kglob, trying to join back to the P1RAW but am not getting very
far.

Any ideas?

TIA.

Neil.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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 101 Performance Tuning comes to the rescue again!

2003-01-31 Thread Deshpande, Kirti




Tom,

Thanks a lot.

I am glad to read that the book is helping you.

I am not so sure about ".. solves all problems", though ;) 


Regards,

- 
Kirti


-Original Message-From: Mercadante, Thomas F 
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52 
AMTo: Multiple recipients of list ORACLE-LSubject: Oracle 
101 Performance Tuning comes to the rescue again!
All,

you 
*MUST* buy this book.

I just 
got called over by the Warehouse people. Their database was hung. We 
could log-on ok, but certain queries would hang.

Ran 
the four "wait-state" queries and saw that two queries were hung on library 
cache. the two queries were an analyze table and a MV refresh - using the 
same table. hung them both out to dry.

killed 
the analyze and the MV started up again.

great 
book. solves all problems. great job Gaja, Kirti and John. you 
guys do the work, and I look like a hero.

thanks 
again.

Tom Mercadante Oracle Certified Professional

RE: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti

Hamid,

Here is one way:

SQL select myseq.currval from dual;

   CURRVAL
--
 4

SQL alter sequence myseq nocache;

Sequence altered.

SQL alter sequence myseq maxvalue 4 cycle;

Sequence altered.

SQL select myseq.nextval from dual;

   NEXTVAL
--
 1

SQL REM --- Other alter sequence commands to change maxvalue, cache, nocycle etc. 
   
Now, you get to do the tricky part of automating it ;) Because, I have not attempted 
to do it, yet. 

HTH,

- Kirti


-Original Message-
Sent: Friday, January 31, 2003 12:21 PM
To: Multiple recipients of list ORACLE-L


Dear List,

How can I reinitiate a sequence Instead or dropping  recreating it, I want
every night my sequence number reinitiate and start from 1 again.
Thanks for your help.


Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-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.net
-- 
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.net
-- 
Author: Deshpande, Kirti
  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: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti

Please post your test... 

- Kirti

-Original Message-
Sent: Friday, January 31, 2003 1:43 PM
To: Multiple recipients of list ORACLE-L


Kirti,

I test it it doesn't work.


-Original Message-
Sent: Friday, January 31, 2003 11:09 AM
To: [EMAIL PROTECTED]
Cc: Hamid Alavi


Hamid,

Here is one way:

SQL select myseq.currval from dual;

   CURRVAL
--
 4

SQL alter sequence myseq nocache;

Sequence altered.

SQL alter sequence myseq maxvalue 4 cycle;

Sequence altered.

SQL select myseq.nextval from dual;

   NEXTVAL
--
 1

SQL REM --- Other alter sequence commands to change maxvalue, cache,
nocycle etc. 
   
Now, you get to do the tricky part of automating it ;) Because, I have not
attempted to do it, yet. 

HTH,

- Kirti


-Original Message-
Sent: Friday, January 31, 2003 12:21 PM
To: Multiple recipients of list ORACLE-L


Dear List,

How can I reinitiate a sequence Instead or dropping  recreating it, I want
every night my sequence number reinitiate and start from 1 again.
Thanks for your help.


Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-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.net
-- 
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).







=== 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.net
-- 
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.net
-- 
Author: Deshpande, Kirti
  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: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti

Did you use 'recycle'? 
Sequence must not use 'cache' when attempting to do this. 

You may also want to check out other options from the Google link posted by Raj.

- Kirti 

-Original Message-
Sent: Friday, January 31, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


Kirti,

I have to set the maxvalue manually, when I do this still nextval not reset.
For example if the maxvalue is 100 and the current value is 500, some
how I have to set alter sequence to reach the maxvalue so the next value
start from 0 again.
This test doesn't do that.


-Original Message-
Sent: Friday, January 31, 2003 12:08 PM
To: Multiple recipients of list ORACLE-L


Please post your test... 

- Kirti

-Original Message-
Sent: Friday, January 31, 2003 1:43 PM
To: Multiple recipients of list ORACLE-L


Kirti,

I test it it doesn't work.


-Original Message-
Sent: Friday, January 31, 2003 11:09 AM
To: [EMAIL PROTECTED]
Cc: Hamid Alavi


Hamid,

Here is one way:

SQL select myseq.currval from dual;

   CURRVAL
--
 4

SQL alter sequence myseq nocache;

Sequence altered.

SQL alter sequence myseq maxvalue 4 cycle;

Sequence altered.

SQL select myseq.nextval from dual;

   NEXTVAL
--
 1

SQL REM --- Other alter sequence commands to change maxvalue, cache,
nocycle etc. 
   
Now, you get to do the tricky part of automating it ;) Because, I have not
attempted to do it, yet. 

HTH,

- Kirti


-Original Message-
Sent: Friday, January 31, 2003 12:21 PM
To: Multiple recipients of list ORACLE-L


Dear List,

How can I reinitiate a sequence Instead or dropping  recreating it, I want
every night my sequence number reinitiate and start from 1 again.
Thanks for your help.


Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-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.net
-- 
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).







=== 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.net
-- 
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.net
-- 
Author: Deshpande, Kirti
  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

RE: Global Stats

2003-01-30 Thread Deshpande, Kirti

Hi Gopal,
 Thanks for the information.

 I was not aware of this. 

 Regards,

- Kirti 


-Original Message-
From:   K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent:   Thu 1/30/2003 1:03 AM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:RE: Global Stats

Hi Kirti:

THe algorithm is slightly differnt in 9i. In 8i SMON queries the
dictionary (dba_tab_modifications) in once in 3 hours to get the stale
stats, and then the stats are flushed to the dictionary from the SGA
and the dictionary is updated . The operation is reverse in 9i. THe
stats are written to dictionary from SGA once in 15 minutes and then
the tables are examined to get the stale stats.

Metalink note 102334.1 has some details..

Best Regards,
K Gopalakrishnan
Bangalore, INDIA


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 Gopal,
 
 I should have waited a bit longer..
 It was about 12 minutes, when I replied...
 
 Okay, I will test it out tomorrow.. 
 It's getting late :(
 
 Now, go eat your lunch.. it's about lunch time for you... :) 
 
 Regards,
 
 - Kirti 
 
 
 -Original Message-
 From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
 Sent: Wed 1/29/2003 10:58 PM
 To:   Multiple recipients of list ORACLE-L
 Cc:   
 Subject:  RE: Global Stats
 
 Kirti:
 
 Sorry for the typo. It is 15 minutes. 
 
 
 --- K Gopalakrishnan [EMAIL PROTECTED] wrote:
  Kirti:
  
  I think the interval is changed to 5 minutes from
  3 hours starting from 9i (rel2?).
  
  
  
  Best Regards,
  K Gopalakrishnan
  
  
  
  

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  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).






winmail.dat

RE: why so many log switches?

2003-01-30 Thread Deshpande, Kirti

Randy,
 This is a long shot... but.. 
 do you run hot backup when the data gets loaded? 

- Kirti 

-Original Message-
Sent: Thursday, January 30, 2003 2:56 PM
To: Multiple recipients of list ORACLE-L


I have 5 indexes on that table, 3 of them are concatenated indexes.

 -Original Message-
Sent:   Thursday, January 30, 2003 3:02 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: why so many log switches?

Those redo could be because of indexes?  How many indexes do you have on
your 40 million row table?

-Original Message-
Sent: Thursday, January 30, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L


I have a table with 40 million rows.  Daily I load about 70,000 records into
it.  Each record is 128 characters wide. The flat file the data comes in is
9 megs.  My redo logs are 20 megs each and I have 3 groups of them.

When I load the data, the alert log shows 29 log switches which generates a
lot of archives logs. Why am I getting so many log switches?  I would think
that if the OS file is 9 megs and the redo logs are 20, I would at most get
1 log switch.

Thanks,
Randy
-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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).

1 2 3 4 5 6 7 8 9 >

1 - 100 of 811 matches

Mail list logo