Re: Source Code about Java Classes

[Sergio Boix Moriano]

Hi all,

[EMAIL PROTECTED] wrote:

> Sergio,
>
> It doesn't seem to likely that Oracle will
> provide the source for their products.

I supposed it, but I only want the source for the oracle.forms.ui or the
oracle.forms.ui.vbutton. If it's not possible, i would like to have a
complete information about the methods an the posibble values of the
attributes for the  oracle.forms.ui class.

Thanks in advance.

>
>
> Jraed
> On Mon, 26 Mar 2001, Sergio Boix Moriano wrote:
>
> > Hi all,
> >
> > Does anyody knows how to find the source code about Forms java
> > classes (oracle.forms.ui), i've looked for it at OTN, Technet and
> > Metalink, and haven't found no documentation about it.
> >
> > Thanks in advance
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

olap?

[Roland . Skoldblom]

Hallo,

Can anyone tell me:

What is OLAP and how does it work, a short description, thanks.


Roland Sköldblom



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

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

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

RE: Execution Plan Qs. of SQL Script ?

[VIVEK_SHARMA]

Kevin wrote - "It is no surprise that the index you mention cannot be used"

Qs. WHY ? 
( Why is Index IDX_TAX_DED_AT_SOURCE_TABLE on the Table in the Main Query
NOT being used 
in the Absence  of the Index on the Table of the Sub-Query ? )

Or am i missing the Obvious ?


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 3:59 AM
> To:   [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject:  RE: Execution Plan Qs. of SQL Script ?
> 
> 
> > > CASE 1 - Following query Going for FULL table scan of
> > > TAX_DED_AT_SOURCE_TABLE(Synonym=TDS) Table inspite of the presence of
> > the
> > > index IDX_TAX_DED_AT_SOURCE_TABLE defined on Fileds(sol_id, cust_id,
> > > tds_cert_num, tran_date)
> > > 
> > > 
> > > SELECT SOL_ID,CUST_ID FROM TDS
> > > WHERE TDS.SOL_ID IN (  SELECT SOL_ID  FROM SOL  WHERE SOL.BR_CODE =
> > '033'
> > > )
> > > AND TDS.CUST_ID =  '03313'
> > > AND TDS.TRAN_DATE  >= TO_DATE( '01-04-2000 00:00:00' , 'DD-MM-
> > > HH24:MI:SS' )
> > 
>   It is no surprise that the index you mention cannot be used.
> 
>   1) You need to think of the subquery as a seperate query, and
> produce an index that will optimize the subquery.  That is why the index
> on
> SOL.BR_CODE works well.
> 
>   2) Your index is otherwise overspecified in relation to your WHERE
> clause... your query does not include the index column TDS_CERT_NUM and
> any
> following column, so you are unable to use the TRAN_DATE component of the
> index as well.  You could either reverse the order of the 3rd and 4th
> column
> (which may impact some other queries' performance... check on v$sqlarea
> for
> similar queries), or create another index which just has the 3 columns you
> are referencing.
> 
>   Kevin Little
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

help!!! data migration

[Nihar]

hi ppl,

 i want to migrate oracle database from solaris to NT and vise versa..
can anybody tell me the best way to do it. my database sixe is around 25GB.


thanks

   
- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com



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

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

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

Curious /etc/system settings in Solaris

[Louis Avrami]

Hello all,

One of the database servers that I am currently working on is
a Sun 6500, running Solaris 2.7.  It's a fairly large machine,
with 20 gig of memory.  It's being used for development and testing
for multiple applications.

When I began installing our particular versions of Oracle (7.3.4.5
and 8.1.7) on the box, I noticed that there were several tunables
settings in /etc/system that I had not seen on Solaris boxes
previously.  Is anyone familiar with the settings that I have
listed below?  I have placed an < to the right of the tunables
in question.  Could they perhaps be applicable to an HP-UX server?
 So far I've only worked on Sun, AIX and Linux servers.  The
shop where this server is located has been primarily HP-UX in
the past, so I thought that these might be legacy settings.

On Solaris, I've heard that it isn't a good idea to fool around
too much with tunables if it isn't necessary.  Portions of the
kernel are "dynamic", and unneeded settings could limit OS operations.

Some of the typical Oracle settings don't look optimal either,
 for example semmns=15000!!, but that is an issue for another
time.

Any info would be greatly appreciated,

Lou Avrami



* Following paraameters added under change # 144754 for Oracle
install.
set tune_t_gpgslo=250   <-
set tune_t_minarmem=100 <-
set tune_t_minasmem=250 <-
set msgsys:msginfo_msgmap=200   <-
set msgsys:msginfo_msgmni=100   <-
set msgsys:msginfo_msgtql=80<-
set msgsys:msginfo_msgseg=2048  <-
set semsys:seminfo_semmap=100   <-
set semsys:seminfo_semmnu=800   <-
set semsys:seminfo_semume=100   <-
set pln:pln_enable_detach_suspend=1 <-
set soc:soc_enable_detach_suspend=1 <-
set socal:socal_enable_suspend=1<-
set fcaw:force32 = 1<-
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=500
set semsys:seminfo_semmsl=2010
set semsys:seminfo_semmns=15000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
* End change # 144754




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

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

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

RE: ===>CPU, memory script(need help)

[Sinardy Xing]

select   NAME,
 VALUE
from sys.v_$sga;

vmstat (solaris command)



Sinardy



-Original Message-
Sent: Monday, 26 March 2001 8:12 PM
To: [EMAIL PROTECTED]
Importance: High


Hi Gurus,
does anyone has a script that detects in a database where a lot CPU is being
used and memories.(on Solaris)
if so can someone send me this.

Thanks
Regis


Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com


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

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

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

Qualifying columns to improve performance?

[Arn Klammer]

At a course some years ago, we were told that in join statements, we should 
qualify ALL our column names with the appropriate table name, not just those 
that may be ambiguous. The reason was that the parser would not need to spend 
time checking multiple tables to determine the table to which each column 
belongs.
 
Is this still a valid rule?
 
Does this apply to statements in PL/SQL procedures/packages?  Or are 
they different, because they are checked at compile time?  
 
-a

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

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

www.mimesweeper.com
**

RE: IOUG university

[Rachel Carmichael]

I saw Cary present in Copenhagen VERY smart man.. father of OFA :)

Gaja we all know from this list -- and I know very few (if any) people who 
know more about performance tuning than he does

Dave Ensor also -- yes a stand-up comic, but he also is one of the most 
knowledgeable men about oracle that I have met.

ALL these presentations will be wonderful


>From: "Weaver, Walt" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: IOUG university
>Date: Mon, 26 Mar 2001 14:36:00 -0800
>
>Well, I haven't been to any classes taught by Cary Millsap, but I worked
>with Cary in the late '80's. One of the sharpest individuals I've ever
>worked with, very personable, friendly, and down to earth. I would imagine
>his classes/seminars are very useful.
>
>I've been to seminars put on by Gaja and Dave at OpenWorld and, if memory
>serves me right (very debatable), at the IOUG conference. Their
>presentations were very interesting and useful. In addition, Dave Ensor
>could probably be a stand-up comedian. Very entertaining guy.
>
>IMHO, and despite not looking at the course outlines, I'd say you can't go
>wrong with any of'em.
>
>--Walt Weaver
>   Bozeman, Montana, USA
>
>-Original Message-
>Sent: Monday, March 26, 2001 2:52 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I am specifically interested in Gary Miilsap,  Gaja Vaidynata and Dave 
>Ensor
>courses - opinions about level, usefullness, materials etc.
>Alex Hillman
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Weaver, Walt
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

Execute priv to an isolated procedure inside a package

[djordjej]

Hi friends,

One cannot grant execute privilege to a specific procedure/function inside a
package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed.  One idea is to
create a separate stand-alone procedure that will just be a wrapper around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje


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

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

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

RE: OLAP again

[Khedr, Waleed]

It seems that Oracle is planning to desupport the OLAP technology some time
in the future (Oracle Express) and enhance the data warehousing capabilities
and performance in 9i. That's why they are offering a new layer called 9i
OLAP services in 9i.

Regards,

Waleed

-Original Message-
Sent: Monday, March 26, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L



I'm no OLAP expert, but you may want to resarch
ROLAP products, ROLAP being Relation Online Analytical
Processing.

These tools are designed to allow OLAP functionality
from your relational database.

Jared

On Mon, 26 Mar 2001, Witold Iwaniec wrote:

> Hi
>
> Our product uses quite complex data model and we are looking for
> ways to speed up data access, especially large reports in the
> range of 25,000+ records.
> One of the ideas was to look into OLAP, or now Business
> Intelligence, tools. After some reading it seems to me that OLAP is
> completely separate product - it is the Express Server that runs its
> own database, and tools like Express Objects, Express Analyzer
> that use the Oracle 9iAS and Express Server technology. You can
> still connect to your Oracle database or import/export the data for
> analysis, reporting, etc. but you have to set up completely new
> environment.
>
> We hoped that we could use OLAP tools to point to Oracle 8i
> database and use it to provide faster access to our complex data
> model but it does not seems so straightforward. Or maybe I
> missed a tool. Could someone, please, correct me?
>
> Thanks
>
> Witold
> ==
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> [EMAIL PROTECTED]
> http://www.novalistech.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


Jared Still
Certified Oracle DBA and Part Time Perl Evangelist  ;-)
Regence BlueCross BlueShield of Oregon
[EMAIL PROTECTED] - Work - preferred address
[EMAIL PROTECTED] - private


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

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

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

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

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

RE: how to store orace errors in database (UNIX scripting challen

[Mandar Ghosalkar]

Ok guys,

spent my weekend on learning sed.
heres what i hv cooked up, just for fun

a shell script to get all ora errors into a SDF format, which can be
uploaded into a table using sql*loader.

issues faced and asking for answers
* how to insert a new-line. so broke the sed into next line to insert the
new line char.
* typeset was not working with /bin/ksh (maybe not ksh93), so used
/usr/dt/bin/dtksh
* how to install ksh93 on release 5.7 ?
* what are the licensing issues related to installing ksh93
* why dont i hv ksh93? why why why? :)
* its very slw

script starts here >
#/usr/dt/bin/dtksh 
tmpfile=/tmp/err$$ #temporary file
errfile=err.dat #error data file
typeset -Z5 count   #fixed width var
count=1
typeset -L256 errm errcause erraction   #fixed width var
while [ count -ne 20001 ]
do
var=`oerr ora $count`
if [ -n "$var" ]
then
echo $var | sed 's/\/\/ \*Cause: /\
/;s/\/\/ \*Action:/\
/;s/ \/\/ / /g' >$tmpfile   #remove "*Cause" "*Action" "//" and add
newline instead
errm=`sed -n 1p $tmpfile`
errcause=`sed -n 2p $tmpfile`
erraction=`sed -n 3p $tmpfile`
echo "$errm""$errcause""$erraction" >>$errfile
fi  
count=`expr $count + 1`
done
<< > Reply Separator
> > Author: "kaushikdas" <[EMAIL PROTECTED]>
> > Date:   3/21/2001 11:35 PM
> > 
> > 
> > 
> > Hello I am Kaushik Das from india .I am new to your group.
> > I had a query ,i hope some one will reply to this mail.
> > 
> > Just like we can store help of sql commands in HELP table  in
> > oracle database.In a semilar way can we store ORACLE errors 
> > in database
> > 
> > for example to see oracle error  in unix we write   
> oerr ora 
> > 
> > 1)what command should we write in nt to see the complete 
> info of this
> > error.
> > 
> > 2) How to store and retrive complete oracle error messages in oracle
> > database.
> > 
> > 3) is there any sql file which dba should run to create such 
> > table and toad
> > data.
> > 
> > Thanks in advance.
> > 
> > regards
> > 
> > kaushik
> > 
> > 
> > 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  INET: [EMAIL PROTECTED]

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

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

Solaris security ?

[Sinardy Xing]

Hi guys,

(With - Solaris 2.7)

Do you have any solution how to allow "non owner" to perform backup ? with
"tar command"

For example:
myfile.txt rw---

can you solve this puzzled ?
If you think I need to write a unix script would you please teaching me and
showing me the steps ?



Thank you,



Sinardy

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

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

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

Re: OLAP again

[jkstill]

I'm no OLAP expert, but you may want to resarch
ROLAP products, ROLAP being Relation Online Analytical
Processing.

These tools are designed to allow OLAP functionality
from your relational database.

Jared

On Mon, 26 Mar 2001, Witold Iwaniec wrote:

> Hi
>
> Our product uses quite complex data model and we are looking for
> ways to speed up data access, especially large reports in the
> range of 25,000+ records.
> One of the ideas was to look into OLAP, or now Business
> Intelligence, tools. After some reading it seems to me that OLAP is
> completely separate product - it is the Express Server that runs its
> own database, and tools like Express Objects, Express Analyzer
> that use the Oracle 9iAS and Express Server technology. You can
> still connect to your Oracle database or import/export the data for
> analysis, reporting, etc. but you have to set up completely new
> environment.
>
> We hoped that we could use OLAP tools to point to Oracle 8i
> database and use it to provide faster access to our complex data
> model but it does not seems so straightforward. Or maybe I
> missed a tool. Could someone, please, correct me?
>
> Thanks
>
> Witold
> ==
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> [EMAIL PROTECTED]
> http://www.novalistech.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


Jared Still
Certified Oracle DBA and Part Time Perl Evangelist  ;-)
Regence BlueCross BlueShield of Oregon
[EMAIL PROTECTED] - Work - preferred address
[EMAIL PROTECTED] - private


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

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

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

Re: Source Code about Java Classes

[jkstill]

Sergio,

It doesn't seem to likely that Oracle will
provide the source for their products.

Jraed
On Mon, 26 Mar 2001, Sergio Boix Moriano wrote:

> Hi all,
>
> Does anyody knows how to find the source code about Forms java
> classes (oracle.forms.ui), i've looked for it at OTN, Technet and
> Metalink, and haven't found no documentation about it.
>
> Thanks in advance
>
>

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

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

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

RE: Redo Log size used

[Steve Adams]

Hi Glenn,

Yes, your query is fine, and does just what you think.
Please see http://www.ixora.com.au/q+a/0102/06135327.htm for the meaning
of cpodr_bno.
Please see http://www.ixora.com.au/tips/tuning/log_buffer_size.htm for
the relationship between log blocks and the log buffer.

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


-Original Message-
Sent: Tuesday, 27 March 2001 7:27
To: Steve Adams
Cc: Oracledba


As always your script was exactly what I was looking for.  I am assuming
the
column sys.x_$kccle.lesiz is number of blocks which make up the logfile,
and
sys.x_$kcccp.cpodr_bno is number of blocks in the log file currently in
use,
although I can't decipher the column name meaning.  Using your
http://www.ixora.com.au/scripts/redo_log.htm#log_block_size.sql script,
I
was able to see the number of bytes in a redo log block.  Again, I am
assuming it is bytes (why is the redo log block size different from the
log
buffer size (set in the init.ora file)?).  What exactly is the
sys.x_$kccle.lebsz column?

I wrote this query to give me the number of MB currently in use by in
the
redo log file.

select
  le.leseq  log_sequence#,
  le.lesiz * le.lebsz /1024 /1024 logmbtotal,
  cp.cpodr_bno * le.lebsz /1024 /1024 logmbinuse
from
  sys.x_$kcccp  cp,
  sys.x_$kccle  le
where
  le.inst_id = userenv('Instance') and
  cp.inst_id = userenv('Instance') and
  le.leseq = cp.cpodr_seq

Am I making the correct assumptions here?

> -Original Message-
> From: Steve Adams [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 3:26 PM
> To: [EMAIL PROTECTED]
> Cc: Oracledba
> Subject: RE: Redo Log size used
>
>
> Hi Glenn,
>
> Try 'log_file_usage.sql' at
> http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
>
>
> -Original Message-
> From: Glenn Travis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 27 March 2001 5:48
> To: [EMAIL PROTECTED]
> Subject: Redo Log size used
>
>
> What can I query to see how much of the redo log file is currently in
use?
>

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

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

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

RE: IOUG university

[Weaver, Walt]

Well, I haven't been to any classes taught by Cary Millsap, but I worked
with Cary in the late '80's. One of the sharpest individuals I've ever
worked with, very personable, friendly, and down to earth. I would imagine
his classes/seminars are very useful.

I've been to seminars put on by Gaja and Dave at OpenWorld and, if memory
serves me right (very debatable), at the IOUG conference. Their
presentations were very interesting and useful. In addition, Dave Ensor
could probably be a stand-up comedian. Very entertaining guy.

IMHO, and despite not looking at the course outlines, I'd say you can't go
wrong with any of'em.

--Walt Weaver
  Bozeman, Montana, USA 

-Original Message-
Sent: Monday, March 26, 2001 2:52 PM
To: Multiple recipients of list ORACLE-L


I am specifically interested in Gary Miilsap,  Gaja Vaidynata and Dave Ensor
courses - opinions about level, usefullness, materials etc.
Alex Hillman

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

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

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

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

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

RE: Linux, Sqlplus worksheet?

[Gogala, Mladen]

OEM will do just fine. It's available on 8.1.7

-Original Message-
Sent: Monday, March 26, 2001 4:00 PM
To: Multiple recipients of list ORACLE-L



Hi, 

I have a user who works on Linux and wants a SQL interface other than
command line sqlplus.  Since I don't use Linux, I checked my disks for a
SQLPLUS Worksheet or OEM version for Linux to no avail.  

Can anyone recommend a gui/java/etc. SQL processor for Linux, other than
command line sqlplus? 

Any information or referral to documentation is appreciated. 

Thanks,  

Linda 

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

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

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

Re: Single Code Table or Separate Code tables dilemma

[Michael Netrusov]

- Original Message -


> As to the encapsulation: Yes things should be encapsulated, fine. But are
> you saying you do not use any queries in your encapsulating procedures?

I am using cursors ( mostly implicit ).

> Have you ever seen an app that was completely encapsulated?

Yes, I had. Not every app needs ad hoc queries..

> What about the
> developer that gets repeatedly reprimanded for not following corporate
> standards but is married to the CEO's daughter?

If the CEO still keeps him, he is dumb. If the CEO is dumb, the whole company goes to 
hell sooner or later.
What's the point of taking care of the project then? :-)

> You keep referring to code that has to be changed anyway.  Perchance another
> example, we'll use the DOCTOR table from the Ghosalkar/Kilchoer thread:
...
> The users tell us: We need to track specialties as being primarily inpatient
> or outpatient so that extra information can be collected for inpatient
> situations (I know, those of you doing work in health care can shoot all
> kinds of holes in this.)
>
> Then I copy all the entries from the code table. (script that must run at
> the production site - asking for trouble), remove them from the old table
> (even more dangerous).  Update the master table entry program and procedures
> to not allow the archived code any more.  Rip through every scrap of code in
> the system to find any reference to I_DONT_LIKE_MASTER to make sure it does
> not have any need of the archived code type.

I would put this into code_type = 'specialty_type_inpatient'  and code_type = 
'specialty_type_outpatient', not adding the
inpatient_yn column.

> Please bear in mind that
> although you are being a very good programmer and using encapsulation, the
> idiots that got fired last week were not, so we still have to look.

I would say we have to prevent this :-) "Code supervizing" they call it..

> Any
> that are found will have to be changed.  Now I create my new entry form to
> add the field and update the registration code.  Then I sit back and wait
> for 1) one of the client's Access reports to return no data because they did
> not realize the data had been moved,

So Access report does not use the packaged code? Too bad..

> or  2) some of our code to break because
> we overlooked something.
>
> The multiple table way:
> CREATE TABLE SPECIALTIES
> (INPATIENT_YN VARCHAR2(1))
> Now I create my new entry form to add the field and update the registration
> code.  Done.  Where are these other code changes that have to be done?

Changes to the doctor table.

> All the old code (encapsulated or not) still works the way it used to.  If I
> overlook something, it may not have the added functionality, but it will not
> break.
>
> PS:  I think this discussion would best be continued with copious amounts of
> alcohol.  If you are ever in Dallas, look me up.

Agreed ;-) If you'll be in Washington DC, let me know!


> > -Original Message-
> > From: Michael Netrusov [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 23, 2001 4:31 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Single Code Table or Separate Code tables dilemma
> >
> >
> >
> > > > Well, in the case of 100 tables you are still hunting all the
> > > > code looking for pieces which are relevant to that changed table.
> > > > Depends on your code. I prefer to encapsulate mine, so
> > > > reference to a table is enclosed in its own package.
> > >
> > > My point is that I can use grep to search the entire code
> > for "order_status"
> > > and get a short list (maybe 10) of places to look.  It is much more
> > > difficult to search for "code_table", get a list of 1,
> > then filter
> > > through the results for some bastardized variety of
> > "code_type = 'STATUS'"
> > > to get down to those same 10.
> > >
> > > Not everything can be encapsulated in a procedure.  This is
> > a database we
> > > are talking about, so people do still write queries where
> > it is easier to
> > > join the lookup table to the master table directly.  If the
> > code has to be
> > > broken out of the central lookup table, you have to update
> > every query that
> > > joins it in, even if all that query needs is the
> > description.  If it is
> > > already split out, the only code I really have to be
> > concerned with is the
> > > places where the new functionality applies.
> >
> > Queries still can be ( and should be ) encapsulated in
> > packages. If you are taking this to-be-enhanced 'status'
> > entity out of the
> > master lookup table, all you have to do is to develop a new
> > package, change the calling code and prohibit the usage of code_type =
> > 'status' in the master lookup table. This still would be
> > changed if you had a separate package and table for the
> > 'status' entity.
> >
> > > > > If I were starting a product from scratch and there was a
> > > > central code table
> > > > > I would probably code against a set of views in
> > > > anticipation of the above
> > > > > ev

RE: Best Practice ?

[VIVEK_SHARMA]

Thanks again for responding 

What do you mean by "analyzing ... + or - 10 % change" mean ?

Allow me to say that :-

The Same Application on Oracle 7.3.4.5 Works Quite Fine With NO Statistics
on most Tables for a Database of Size About 100 GB (except for Some stray
jobs which work well Only with Statistics Computed on Select Tables )

NOTE - 
1) In Light of the Above For the Same Application , but for Databases on
ORA817 of the Same Size , Would it Still be Advisable to Compute Statistics
?

2) The Same Databases are Going to Explode in Size to a TeraByte in a few
years . Would it Still be Advisable to Compute Statistics ?




> -Original Message-
> From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 2:36 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Best Practice ?
> 
> Hi !
> 
> It all depends on your OPTIMIZER_MODE. I guess you
> will be using CHOOSE and if that is the case I would recommend
> analyzing the tables& indexes (or ANALYZE_SCHEMA) for
> + or - 10 % change.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> - Original Message -
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Sunday, March 25, 2001 5:48 PM
> 
> 
> >
> > For Analyze of Tables on a Oracle 817 Database on Cluster with OPS ?
> >
> > Should the Tables be Analyzed OR Not ?
> >
> > This is a Application with More OLTP than Batch ( Banking Product )
> >
> >
> >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

OPS Setup Steps ?

[VIVEK_SHARMA]

Have a Single Instance Database ( ORA 8.1.7 )Running on a 2-node Cluster (
Digital Unix 5.1)

Any Doc. Listing Steps to Convert it into a 2 instance OPS Database ?


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

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

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

Re: Using HS

[Tzachi Nissim]

It must be a silly environment issue. Are you using a Merant driver on the
Sun to SQL server (I was not aware that there is such a Merant driver), or
are you using SQL*NET to get to the NT where HS is activating Merant?

- If Merant driver is on the Sun, I would check the listener environment.
Probably the ODBCINI environment variable is not set.

- If Merant driver is on NT, the most common case is if you defined a user
DSN instead of a system DSN. The listener starts HS under the system so the
user DSN is not known.

Hope this helps...

Tzachi

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 4:55 PM


> The SUN/Merant => NT link is ok because it is working
> when using Powermart.
> We just want to call a stored proc on MS SQL Server
> which is not allowed with Powermart 4.6 (it is
> supposed to work with Powermart 5) . So the idea is to
> call an Oracle Stored proc which would called a MS SQL
> Server stored proc. We won't buy the Gateway since
> Powermart 5 should do the job in a few months.
>
>
>
> --- Tzachi Nissim <[EMAIL PROTECTED]> a écrit : >
> Looks like you did not setup the DSN name correctly.
> > Merant cannot find the
> > DSN name that HS passed to it. Look at their ODBCINI
> > file to verify that the
> > DSN appears there. I would suggest, however, that
> > you get the enterprise
> > gateway to SQL server. Performance will be better
> > too...
> >
> > I hope you had more fun in your vacation... :)
> >
> > Tzachi
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Thursday, March 22, 2001 7:30 PM
> >
> >
> > > Hi,
> > >
> > > Back from vacation and trying to make HS work
> > between
> > > Oracle 816/Solaris and MS SQl Server 6.5 or Oracle
> > > 817/Solaris MS SQl Server 6.5. The ODBC driver is
> > > Merant 360.
> > >
> > >
> > > On 816 I'm having :
> > > ORA-28500: connection from ORACLE to a non-Oracle
> > > system returned this mess
> > > age:
> > > [Transparent gateway for ODBC]DRV_InitTdp:
> > > [MERANT][ODBC lib] Data source name not found and
> > no
> > > default driver specified (SQL State: IM002; SQL
> > Code:
> > > 0)
> > > ORA-02063: preceding 2 lines from HSODBC
> > >
> > >
> > > On 817 I'm having
> > > ORA-28509: unable to establish a connection to a
> > > non-Oracle system
> > > ORA-02063: preceding line from HSODBC
> > >
> > >
> > > Anybody ?
> > >
> > >
> > >
> > > =
> > > Stéphane Paquette
> > > DBA Oracle, consultant entrepôt de données
> > > Oracle DBA, datawarehouse consultant
> > > [EMAIL PROTECTED]
> > >
> > > __
> > > Do You Yahoo!?
> > > Get email at your own domain with Yahoo! Mail.
> > > http://personal.mail.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Tzachi Nissim
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE

Execution Plan Qs. of SQL Script ?

[VIVEK_SHARMA]

> Oracle ver 7.3.4.5 
> 
> CASE 1 - Following query Going for FULL table scan of
> TAX_DED_AT_SOURCE_TABLE(Synonym=TDS) Table inspite of the presence of the
> index IDX_TAX_DED_AT_SOURCE_TABLE defined on Fileds(sol_id, cust_id,
> tds_cert_num, tran_date)
> 
> 
> SELECT SOL_ID,CUST_ID FROM TDS
> WHERE TDS.SOL_ID IN (  SELECT SOL_ID  FROM SOL  WHERE SOL.BR_CODE =  '033'
> )
> AND TDS.CUST_ID =  '03313'
> AND TDS.TRAN_DATE  >= TO_DATE( '01-04-2000 00:00:00' , 'DD-MM-
> HH24:MI:SS' )
> 
> call count   cpuelapsed   disk  querycurrent
> rows
> --- --   -- -- -- --
> --
> Parse1  0.00   0.00  0  0  0
> 0
> Execute  1  0.00   0.00  0  0  0
> 0
> Fetch1  1.74   1.74   8062   8068  2
> 1
> --- --   -- -- -- --
> --
> total3  1.74   1.74   8062   8068  2
> 1
> 
> Rows Execution Plan
> ---  ---
>   0  SELECT STATEMENT   GOAL: RULE
>   1   NESTED LOOPS
>  368573TABLE ACCESS (FULL) OF 'TAX_DED_AT_SOURCE_TABLE'
>   1TABLE ACCESS (BY ROWID) OF 'SERVICE_OUTLET_TABLE'
>   1 INDEX (UNIQUE SCAN) OF 'IDX_SERVICE_OUTLET_TABLE' (UNIQUE)
> 
> NOTE SOL is the Synonym for SERVICE_OUTLET_TABLE Table which Contains
> Masterdata of about 50 
> rows only
> 
> Qs. 1 Why is Index Scan of TAX_DED_AT_SOURCE_TABLE Table NOT Happening ?
> Qs. 2 Am i correct in inferring from the Above That
> TAX_DED_AT_SOURCE_TABLE is the Driving 
> Table because it Appears First in the Execution Plan when Reading
> Downwards ?
> 
> 
> CASE 2 - After Creation  of Index on SERVICE_OUTLET_TABLE (SOL) table on
> field (br_code field), for the SAME WHERE Clause Statement , INDEX Scan of
> TAX_DED_AT_SOURCE_TABLE(TDS) Table is Done 
> 
> UPDATE TDS  SET TDS.SHORTFALL_AMT = 0
> WHERE
>   TDS.SOL_ID IN (  SELECT SOL_ID  FROM SOL  WHERE SOL.BR_CODE =  :1  ) AND
>   TDS.CUST_ID =  :2  AND TDS.TRAN_DATE  >=  TO_DATE( :3 , 'DD-MM-
> HH24:MI:SS' )
> 
> 
> call count   cpuelapsed   disk  querycurrent
> rows
> --- --   -- -- -- --
> --
> Parse1  0.00   0.00  0  0  0
> 0
> Execute  1  0.00   0.00  0  7  1
> 1
> Fetch0  0.00   0.00  0  0  0
> 0
> --- --   -- -- -- --
> --
> total2  0.00   0.00  0  7  1
> 1
> 
> Rows Execution Plan
> ---  ---
>   0  UPDATE STATEMENT   GOAL: RULE
>   1   NESTED LOOPS
>   1TABLE ACCESS (BY ROWID) OF 'SERVICE_OUTLET_TABLE'
>   2 INDEX (RANGE SCAN) OF 'IDX_SOL_BR_CODE' (NON-UNIQUE)
>   2INDEX (RANGE SCAN) OF 'IDX_TAX_DED_AT_SOURCE_TABLE' (UNIQUE)
> 
> NOTE - Also seemingly SERVICE_OUTLET_TABLE(SOL) Table Now Becomes the
> Driving Table
> 
> Qs. How does Creation of an index on The Table which is Part of the Nested
> Query Cause the Execution plan to Change as Shown ?
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

IOUG university

[Hillman, Alex]

I am specifically interested in Gary Miilsap,  Gaja Vaidynata and Dave Ensor
courses - opinions about level, usefullness, materials etc.
Alex Hillman

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

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

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

RE: Linux, Sqlplus worksheet?

[gregory . t . norris]

I haven't used them myself, but the OraSoft utilities 
(http://www.orasoft.org/) seem fairly impressive.

-Original Message-
Sent: Monday, March 26, 2001 3:00 PM
To: ORACLE-L
Cc: lindah


Hi, 
I have a user who works on Linux and wants a SQL interface other than 
command line sqlplus.  Since I don't use Linux, I checked my disks for 
a SQLPLUS Worksheet or OEM version for Linux to no avail.  
Can anyone recommend a gui/java/etc. SQL processor for Linux, other 
than command line sqlplus? 
Any information or referral to documentation is appreciated. 
Thanks,  
Linda 

Re: Linux, Sqlplus worksheet?

[Rodd Holman]

Let me rephrase OEM is "free" in accordance with the license restrictions in 
the development download.  Orasoft is GPL for the downloadable version.

On Monday 26 March 2001 15:31, you wrote:
> OEM for linux is available in the 8.1.7 download from technet.  Another
> good place to look is http://www.orasoft.org.  Matthew has written a fairly
> good sql worksheet.  They both work off the idea of a sql window and output
> window.  Both give you command history, scrollable output, export of
> input/output to text, both are free.  OEM is in java.  Orasoft is done with
> gtk.  The OEM sheet allows for sqlplus commands Orasoft doesn't.  Orasoft
> is faster (it's not hogging the machine processes with java.)  I use both
> depending on what I need.  Orasoft only works with 8x db's.  OEM will work
> with any Oracle db 7.3.4 or higher (maybe lower too, but  I haven't had
> time to explore that)
>
> HTH
>
> On Monday 26 March 2001 15:00, Linda wrote:
> > Hi,
> >
> > I have a user who works on Linux and wants a SQL interface other than
> > command line sqlplus.  Since I don't use Linux, I checked my disks for a
> > SQLPLUS Worksheet or OEM version for Linux to no avail.
> >
> > Can anyone recommend a gui/java/etc. SQL processor for Linux, other than
> > command line sqlplus?
> >
> > Any information or referral to documentation is appreciated.
> >
> > Thanks,
> >
> > Linda
>
> ---

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation


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

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

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

Re: Redo Log size used

[Mohammad Rafiq]

See your alertSID.log by using

tail -f alertSID.log

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 26 Mar 2001 11:51:11 -0800

What can I query to see how much of the redo log file is currently in use?


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

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

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

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

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

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

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

Re: Linux, Sqlplus worksheet?

[Rodd Holman]

OEM for linux is available in the 8.1.7 download from technet.  Another good 
place to look is http://www.orasoft.org.  Matthew has written a fairly good 
sql worksheet.  They both work off the idea of a sql window and output 
window.  Both give you command history, scrollable output, export of 
input/output to text, both are free.  OEM is in java.  Orasoft is done with 
gtk.  The OEM sheet allows for sqlplus commands Orasoft doesn't.  Orasoft is 
faster (it's not hogging the machine processes with java.)  I use both 
depending on what I need.  Orasoft only works with 8x db's.  OEM will work 
with any Oracle db 7.3.4 or higher (maybe lower too, but  I haven't had time 
to explore that)

HTH

On Monday 26 March 2001 15:00, Linda wrote:
> Hi,
>
> I have a user who works on Linux and wants a SQL interface other than
> command line sqlplus.  Since I don't use Linux, I checked my disks for a
> SQLPLUS Worksheet or OEM version for Linux to no avail.
>
> Can anyone recommend a gui/java/etc. SQL processor for Linux, other than
> command line sqlplus?
>
> Any information or referral to documentation is appreciated.
>
> Thanks,
>
> Linda
---

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

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

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

Insert

[Kevin Kostyszyn]

Hi DBA's,
One of my developers just asked me a question, and honestly I don't know
what he's talking about.  But, it made me think of my own that I do know the
answer to or at least I used to:(   Anyway, when doing an insert into a
table, doesn't it increase performance to delete any indexes, do the insert
then rebuild the index.  Or do you just have to disable the index?  Also,
does this work the same for delete?  Also...is there anyway to guestemate
how long an insert is going to take?

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

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

RE: Redo Log size used

[Steve Adams]

Hi Glenn,

Try 'log_file_usage.sql' at
http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage.

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


-Original Message-
Sent: Tuesday, 27 March 2001 5:51
To: Multiple recipients of list ORACLE-L


What can I query to see how much of the redo log file is currently in
use?


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

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

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

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

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

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

Re: do you use SQLJ ?

[jkstill]

Oracle has repeatedly stated that PL/SQL is not
going away.

One good reason for this is that PL/SQL is highly
optimized for DML in the database.  Java is not,
and will not likely ever be as efficient PL/SQL
for manipulating large amounts of data.  At least
IMO.

OOP has many benefits, but large scale DML is not
one of them, at least not yet.

PL/SQL will be around for awhile yet.

And if you are wondering 'Should I learn Java?', the
answer is 'definitely', as it is capable of many
things that PL/SQL is not.

Jared



On Thu, 22 Mar 2001, Jeff Cox wrote:

> Dear List,
>
> I haven't really seen a question on this list regarding SQLJ, and it makes
> me wonder how many people on this list actually use SQLJ.  A DBA friend of
> mine told me that eventually SQLJ will replace PL/SQL in preference, and I
> wanted to know the truth regarding his statement - so who better to ask than
> the experts of this list?
>
> What have you heard, or better yet, what is your opinion of SQLJ?  Is SQLJ
> the future?  Will PL/SQL die a slow death?  Can you do everything in SQLJ
> that you can do in PL/SQL?
>
>
> Cheers,
>
> Jeff Cox
> IPS-Sendero
> Scottsdale, AZ
>


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

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

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

Linux, Sqlplus worksheet?

[Hagedorn, Linda]

Title: Linux, Sqlplus worksheet? 





Hi, 


I have a user who works on Linux and wants a SQL interface other than command line sqlplus.  Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail.  

Can anyone recommend a gui/java/etc. SQL processor for Linux, other than command line sqlplus? 


Any information or referral to documentation is appreciated. 


Thanks,  


Linda 

RE: Why is there air?

[jkstill]

On Thu, 22 Mar 2001, Maser, Donna  (SEA) wrote:

> Jared,
>   I am still waiting/hoping for an answer...
>   Why IS there air?
> - Donna
>

It's to dilute the output from grain eating
methane dispensers.

Jared


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

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

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

RE: (Fwd 1 of 2) Re: Forms going away?

[Grabowy, Chris]

The presentation at the below link might also provide you with some
additional info.

http://www.seouc.org/Details/13.htm

Chris
"May Oracle be with you...always"

-Original Message-
Sent: Monday, March 26, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L


fyi (1 of 2)

--- Forwarded message follows ---
Date sent:  Mon, 26 Mar 2001 02:35:24 -0800
Send reply to:  O D T U G - D E V 2 K - L @ f a t c i t y . c o m

Sriram,
Cherokee is not yet available and there are no papers on the Oracle or
Technet sites yet, although there will be shortly.
A sneak preview of Cherokee was published in the last ODTUG journal which
provides a good overview to the tool.

Anyway - the one paragraph overview:

"Oracle Project Cherokee is a standards-based, declarative development tool
for building high-performance, scaleable HTML transactional data-aware
components which can be embedded into any JSP or Oracle Portal Page. It
combines powerful transactional processing as well as a very rich
interactive HTML UI with an ultra-lightweight HTML footprint. Applications
run natively in commonly used browsers such as Internet Explorer and
Netscape. "


Regards

Duncan Mills
Oracle Forms Product Management
- Original Message -
To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m
Sent: Saturday, March 24, 2001 12:30 AM


> Friends,
>
> What is Cherokee? is it a forms replacement? Where can I find more on it.
I
> did
> try digging thru the ORACLE website but could not locate any white papers
> etc..
>
> Thanks
>
> Sriram
>
>
>
> > -Original Message-
> > From: On Behalf Of Openshaw, Michael
> > Sent: Friday, March 23, 2001 4:30 PM
> > To: Multiple recipients of list ODTUG-DEV2K-L
> > Subject: RE: Forms going away?
> >
> >
> > Cherokee will substantially improve the issue, but it still will have a
> > problem as far as I'm concerned.  That is the need to load a specific
> > component (about 200K in Cherokee's case, as opposed to
> > Jinitiator) to work
> > with a standard browser.
> >
> > The Web was *supposed* to get us away from controlling client
> > configurations; that's why I like Webserver Generation, where
> > browser-sensitivity is minimized (unless you specifically code for it).
> >
> > > -Original Message-
> > > From: Jim Walski [ j w a l s k i 3 @ c l a s s i c p l a n . c o m ]
> > > Sent: Friday, March 23, 2001 2:32 PM
> > > To: Multiple recipients of list ODTUG-DEV2K-L
> > > Subject: Re: Forms going away?
> > >
> > > That was my thoughts exactly.  I figure they _have_ to support
> > it for who
> > > knows how long, but as far as new functionality, what you see
> > is what you
> > > get.
> > >
> > > I would *love* to see this Project Cherokee perform as
> > described.  Oracle
> > > Forms over the Internet is poor at best.  I just can't get my
> > hopes up, as
> > > Oracle is great at marketing and as for delivering?
> > >
> > > Jim
> > >
> > >
> > >
> > >
> > > -Original Message-
> > > To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m 
> > > Date: Friday, March 23, 2001 12:15 PM
> > >
> > >
> > > >Jim, Forms will be around for a Lng time.  Simply because
> > Oracle will
> > > >not kill it until Oracle Apps moves off of it (and we all know
> > the speed
> > > at
> > > >which Oracle Apps moves forward; calling it glacial would be kind.)
> > > >
> > > >Will forms be continually enhanced?  I would doubt it, past the next
12
> > > >months or so.  The chances of a Forms 8 every seeing the light
> > of day is
> > > >about the same as Egypt winning the Olympic gold medal in hockey.
> > > >
> > > >
> > > >> -Original Message-
> > > >> From: Jim Walski 
> > > >> Sent: Friday, March 23, 2001 12:20 PM
> > > >> To: Multiple recipients of list ODTUG-DEV2K-L
> > > >> Subject: Forms going away?
> > > >>
> > > >> I keep hearing that Forms will continually be enhanced for a
> > long time.
> > > >> However, I sure find it very interesting that Oracle is building a
> > > >> Migration
> > > >> utility to move your Forms .fmb to Cherokee files.
> > > >>
> > > >> Quote from an email received from Susan Duncan
> > > >>
> > > >> "...We have a team of developers who are working on a
> > migration utility
> > > to
> > > >> migrate Developer Forms to Cherokee modules "
> > > >>
> > > >> Sure sounds like all new features will be added in Cherokee.
> >  Of course
> > > >> knowing the speed of Oracle development I won't hold my breath for
an
> > > >> early
> > > >> release of Cherokee.

...



To REMOVE yourself from this mailing list, send an E-Mail message
to: 
L i s t G u r u @ f a t c i t y . c o m  
(note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-DEV2K-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--- End of forwarded message ---

-- 
Ple

Re: NT Server very slow

[Jerry C]

Hi Kevin -

The bug doc mentions a certain processor, so it could be hardware dependant.
I'm not sure if our affected machine had the mentioned processors or not (I
stopped investigating after the patch fixed our problem - I'm lazy that
way!).

Even though the doc says 8.1.5, we had the problem w/ 8.1.6.0 - it was fixed
in 8.1.6.3

Here's an excerpt from the doc for those who are interested.

- Jerry

---

Bug No. 941798
Filed 21-JUL-1999
Updated 28-APR-2000
Product Oracle Server - Enterprise Edition V7
Product Version 8.1.5.0.0
Platform Intel Windows NT Platform Version 4.0
RDBMS Version 8.1.5.0.0
Affects Platforms Port-Specific
Priority Severe Loss of Service
Status Closed, Could Not Reproduce
Base Bug 879133
Fixed in Product Version No Data

Problem statement:

ORACLE.EXE MEMORY LEAK, 100% UTILIZATION WITH INTEL P-3 XEON 450 PROCESSORS

Hdr: 941798 8.1.5.0.0 RDBMS 8.1.5.0.0 PERFORMANCE PRODID-5 PORTID-912
ORA-12500 879133 Abstract: ORACLE.EXE MEMORY LEAK, 100% UTILIZATION WITH
INTEL P-3 XEON 450 PROCESSORS *** 07/21/99 05:49 am *** .

=

PROBLEM: .
1. Clear description of the problem encountered:
Oracle.exe appears to have a memory leak when running on xeon processors. Ct
has several instalations running on plain p-2's ok, though instalation on
intel MB, 2 p-3 xeon processors, 1G mem, fails after 2-3 days running This
is with 0-1 users connecting to db fr this period of time. .

2. Pertinent configuration information (MTS/OPS/distributed/etc)
Ct had originally configured MTS, though disabled thinking this may have
been an issue. Still has same issue. .

3. Indication of the frequency and predictability of the problem
This occurs between 2-3 days after starting instance. After occurance of
error, reboot is solution. This is fairly consistent on ct's installation .

4. Sequence of events leading to the problem nothing special, start oracle
service and ionstance, after 2-3 days gets eeror ora-12500 'can not create
dedicated process' when trying to connect. .

5. Technical impact on the customer. Include persistent after effects. This
is a test machine, ct is planning on rolling out production utilizing xeon
processors for performance gain. They are on a time constraint and are leary
of hardware/software purchases utill this is resolved

=
DIAGNOSTIC ANALYSIS:
NT Performance monitor statistics

system resources;
start, 447,240M used
end, 562,008 M used .

oracle.exe
start 77,352 M used
end 93,200 M used .

racle.exe cpu utilization;
start 0%
end 100% . .

=
WORKAROUND: None .

=
RELATED BUGS: 879133 .

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, March 24, 2001 12:40 PM


> Hey Jerry,
> Is this hardware dependant in any way?   I have several instances of
> 8.1.6.0 and none of them have ever done anything like that. Then again, we
> are not a 24/7 shop and I am running cold backups every night, maybe that
is
> why.
> Kev
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Friday, March 23, 2001 5:30 PM
>
>
> > Hi Kevin,
> >
> > Yes, it will suck down the whole processor. We had a new implementation,
> > with ZERO users, that had the problem.
> >
> > It is a memory leak of some sort. 8163 fixed it.
> >
> >
> > - Jerry
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 23, 2001 3:59 PM
> >
> >
> > > Interesting, i have never heard of this bug.  What do you mean, all of
> the
> > > sudden it will suck down the whole processor?  How many users?
> > >
> > > -Original Message-
> > > Sent: Friday, March 23, 2001 3:37 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > There is a bug with some version of Oracle (I believe it was
8.1.6.0.0,
> > but
> > > don't quote me on that), where even with NO users, oracle.exe would
> > > eventually consume your whole CPU. The CPU utilization ramps up after
a
> db
> > > restart until it gets to 99 or 100.
> > >
> > > Open Task Manager and check the oracle.exe process.
> > >
> > > I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.
> > >
> > >
> > > Good luck!
> > >
> > > - Jerry
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 23, 2001 12:17 PM
> > >
> > >
> > > > Since you mention there are only a few users, I would take a look at
> the
> > > > jobs these users are running.  Maybe one of these users is firing
off
> a
> > > > poorly tuned job that brings the database to a grinding halt.
> > > >
> > > > Is the database the only product on the Server?  Or are there other
> > > > applications ( email server, web server...)
> > > >
> > > > Jim
> > > >
> > > >
> > > >
> > > > -Original Message-
> > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE

RE: Help...Rollback Segmenst Grow?

[Deshpande, Kirti]

There is no way to stop the use of rollback segments when performing delete
operation. Have you considered writing a small PL/SQL procedure to delete
the rows? That way, you could commit the work at some interval to control
the use of rollback segments. You can certainly shrink them manually as
required.
 
- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Scott Hahn [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 8:36 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Help...Rollback Segmenst Grow? 
> 
> Gurus
> 
> 
> 1)
> I am doing some data movement involving a table creation based on
> another table
> create table userid.pm_stage_lg_arch tablespace user_data as select
> *from userid.pm_stage_lg where
> entry_timestamp<= to_date('06-feb-01 11:00:00','DD-MON-YY
> HH24:MI:SS');
> 
> This creates a table with 1,000,000 rows and grows my tablespace by 360
> MB...
> 
> 2)
> I then want to delete the rows from the original table based on the
> same
> date range.
> delete from nuserid.pm_stage_lg where entry_timestamp <=
> to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS');
> 
> The problem is that when I issue this statement which deletes
> 1,000,000 rows my rollback segments understandably grow by 600 MB...
> 1) Can I issue this statement without growing the rollback
> segments? (no recover?)
> 2)  Can I actually shrink the size of the rollback
> segments
> after backing up the database?
> 
> 3) As you see in the statement I am basing my select on the date which I
> need to be exact...Is there a way I could do it as select sysdate-45 from
> dual and have it returned in teh same format as 'DD-MON-YY HH24:MI:SS' ???
> I have been trying this for a while and cant get it..
> 
> Thanks for the help.  This is a DB that is limited in Hard drive space so
> I
> need to conserve..
> 
> Scott Hahn
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Scott Hahn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Redo Log size used

[Glenn Travis]

What can I query to see how much of the redo log file is currently in use?


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

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

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

(Fwd 2 of 2) Re: Forms going away?

[Eric D. Pierce]

--- Forwarded message follows ---
Date sent:  Mon, 26 Mar 2001 02:20:18 -0800
T o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m 
F r o m : d u n c a n . m i l l s @ o r a c l e . c o m 

We are building a migration facility purely because that was one of the
first things the customer base asked for when we initially showed Cherokee.
You bet people would have moaned if we'd not done it.
You'll note the word here is "Migration" not "Upgrade".  Cherokee does not
replace Forms, it will be a just another service under iAS.
There is no doubt that some applications will have portions which will adapt
well to the HTML interface so we offer a way of getting there via the
migration tool.   On the other hand you can do stuff in Forms that the
Cherokee HTML interface just can't do.  We believe that there is room for
both products

I'll take this opportunity to plug the "Migrating your 6i applications to
Project Cherokee" paper in San Diego.

Regards

Duncan Mills
Oracle Forms Product Management
- Original Message -
To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m 
Sent: Friday, March 23, 2001 7:20 PM


> I keep hearing that Forms will continually be enhanced for a long time.
> However, I sure find it very interesting that Oracle is building a
Migration
> utility to move your Forms .fmb to Cherokee files.
>
> Quote from an email received from Susan Duncan
>
> "...We have a team of developers who are working on a migration utility to
> migrate Developer Forms to Cherokee modules "
>
> Sure sounds like all new features will be added in Cherokee.  Of course
> knowing the speed of Oracle development I won't hold my breath for an
early
> release of Cherokee.

...


To REMOVE yourself from this mailing list, send an E-Mail message
to: 
L i s t G u r u @ f a t c i t y . c o m 
(note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-DEV2K-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--- End of forwarded message ---


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

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

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

(Fwd 1 of 2) Re: Forms going away?

[Eric D. Pierce]

fyi (1 of 2)

--- Forwarded message follows ---
Date sent:  Mon, 26 Mar 2001 02:35:24 -0800
Send reply to:  O D T U G - D E V 2 K - L @ f a t c i t y . c o m

Sriram,
Cherokee is not yet available and there are no papers on the Oracle or
Technet sites yet, although there will be shortly.
A sneak preview of Cherokee was published in the last ODTUG journal which
provides a good overview to the tool.

Anyway - the one paragraph overview:

"Oracle Project Cherokee is a standards-based, declarative development tool
for building high-performance, scaleable HTML transactional data-aware
components which can be embedded into any JSP or Oracle Portal Page. It
combines powerful transactional processing as well as a very rich
interactive HTML UI with an ultra-lightweight HTML footprint. Applications
run natively in commonly used browsers such as Internet Explorer and
Netscape. "


Regards

Duncan Mills
Oracle Forms Product Management
- Original Message -
To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m
Sent: Saturday, March 24, 2001 12:30 AM


> Friends,
>
> What is Cherokee? is it a forms replacement? Where can I find more on it.
I
> did
> try digging thru the ORACLE website but could not locate any white papers
> etc..
>
> Thanks
>
> Sriram
>
>
>
> > -Original Message-
> > From: On Behalf Of Openshaw, Michael
> > Sent: Friday, March 23, 2001 4:30 PM
> > To: Multiple recipients of list ODTUG-DEV2K-L
> > Subject: RE: Forms going away?
> >
> >
> > Cherokee will substantially improve the issue, but it still will have a
> > problem as far as I'm concerned.  That is the need to load a specific
> > component (about 200K in Cherokee's case, as opposed to
> > Jinitiator) to work
> > with a standard browser.
> >
> > The Web was *supposed* to get us away from controlling client
> > configurations; that's why I like Webserver Generation, where
> > browser-sensitivity is minimized (unless you specifically code for it).
> >
> > > -Original Message-
> > > From: Jim Walski [ j w a l s k i 3 @ c l a s s i c p l a n . c o m ]
> > > Sent: Friday, March 23, 2001 2:32 PM
> > > To: Multiple recipients of list ODTUG-DEV2K-L
> > > Subject: Re: Forms going away?
> > >
> > > That was my thoughts exactly.  I figure they _have_ to support
> > it for who
> > > knows how long, but as far as new functionality, what you see
> > is what you
> > > get.
> > >
> > > I would *love* to see this Project Cherokee perform as
> > described.  Oracle
> > > Forms over the Internet is poor at best.  I just can't get my
> > hopes up, as
> > > Oracle is great at marketing and as for delivering?
> > >
> > > Jim
> > >
> > >
> > >
> > >
> > > -Original Message-
> > > To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m 
> > > Date: Friday, March 23, 2001 12:15 PM
> > >
> > >
> > > >Jim, Forms will be around for a Lng time.  Simply because
> > Oracle will
> > > >not kill it until Oracle Apps moves off of it (and we all know
> > the speed
> > > at
> > > >which Oracle Apps moves forward; calling it glacial would be kind.)
> > > >
> > > >Will forms be continually enhanced?  I would doubt it, past the next
12
> > > >months or so.  The chances of a Forms 8 every seeing the light
> > of day is
> > > >about the same as Egypt winning the Olympic gold medal in hockey.
> > > >
> > > >
> > > >> -Original Message-
> > > >> From: Jim Walski 
> > > >> Sent: Friday, March 23, 2001 12:20 PM
> > > >> To: Multiple recipients of list ODTUG-DEV2K-L
> > > >> Subject: Forms going away?
> > > >>
> > > >> I keep hearing that Forms will continually be enhanced for a
> > long time.
> > > >> However, I sure find it very interesting that Oracle is building a
> > > >> Migration
> > > >> utility to move your Forms .fmb to Cherokee files.
> > > >>
> > > >> Quote from an email received from Susan Duncan
> > > >>
> > > >> "...We have a team of developers who are working on a
> > migration utility
> > > to
> > > >> migrate Developer Forms to Cherokee modules "
> > > >>
> > > >> Sure sounds like all new features will be added in Cherokee.
> >  Of course
> > > >> knowing the speed of Oracle development I won't hold my breath for
an
> > > >> early
> > > >> release of Cherokee.

...



To REMOVE yourself from this mailing list, send an E-Mail message
to: 
L i s t G u r u @ f a t c i t y . c o m  
(note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-DEV2K-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--- End of forwarded message ---

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

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

RE: NT Server very slow

[Kevin Kostyszyn]

Ahh yes, the Xeon processor!  I wish I had two of those, until now, sheesh.
Thanks for the heads up.
Kev

-Original Message-
Sent: Monday, March 26, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L


Hi Kevin -

The bug doc mentions a certain processor, so it could be hardware dependant.
I'm not sure if our affected machine had the mentioned processors or not (I
stopped investigating after the patch fixed our problem - I'm lazy that
way!).

Even though the doc says 8.1.5, we had the problem w/ 8.1.6.0 - it was fixed
in 8.1.6.3

Here's an excerpt from the doc for those who are interested.

- Jerry

---

Bug No. 941798
Filed 21-JUL-1999
Updated 28-APR-2000
Product Oracle Server - Enterprise Edition V7
Product Version 8.1.5.0.0
Platform Intel Windows NT Platform Version 4.0
RDBMS Version 8.1.5.0.0
Affects Platforms Port-Specific
Priority Severe Loss of Service
Status Closed, Could Not Reproduce
Base Bug 879133
Fixed in Product Version No Data

Problem statement:

ORACLE.EXE MEMORY LEAK, 100% UTILIZATION WITH INTEL P-3 XEON 450 PROCESSORS

Hdr: 941798 8.1.5.0.0 RDBMS 8.1.5.0.0 PERFORMANCE PRODID-5 PORTID-912
ORA-12500 879133 Abstract: ORACLE.EXE MEMORY LEAK, 100% UTILIZATION WITH
INTEL P-3 XEON 450 PROCESSORS *** 07/21/99 05:49 am *** .

=

PROBLEM: .
1. Clear description of the problem encountered:
Oracle.exe appears to have a memory leak when running on xeon processors. Ct
has several instalations running on plain p-2's ok, though instalation on
intel MB, 2 p-3 xeon processors, 1G mem, fails after 2-3 days running This
is with 0-1 users connecting to db fr this period of time. .

2. Pertinent configuration information (MTS/OPS/distributed/etc)
Ct had originally configured MTS, though disabled thinking this may have
been an issue. Still has same issue. .

3. Indication of the frequency and predictability of the problem
This occurs between 2-3 days after starting instance. After occurance of
error, reboot is solution. This is fairly consistent on ct's installation .

4. Sequence of events leading to the problem nothing special, start oracle
service and ionstance, after 2-3 days gets eeror ora-12500 'can not create
dedicated process' when trying to connect. .

5. Technical impact on the customer. Include persistent after effects. This
is a test machine, ct is planning on rolling out production utilizing xeon
processors for performance gain. They are on a time constraint and are leary
of hardware/software purchases utill this is resolved

=
DIAGNOSTIC ANALYSIS:
NT Performance monitor statistics

system resources;
start, 447,240M used
end, 562,008 M used .

oracle.exe
start 77,352 M used
end 93,200 M used .

racle.exe cpu utilization;
start 0%
end 100% . .

=
WORKAROUND: None .

=
RELATED BUGS: 879133 .

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, March 24, 2001 12:40 PM


> Hey Jerry,
> Is this hardware dependant in any way?   I have several instances of
> 8.1.6.0 and none of them have ever done anything like that. Then again, we
> are not a 24/7 shop and I am running cold backups every night, maybe that
is
> why.
> Kev
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Friday, March 23, 2001 5:30 PM
>
>
> > Hi Kevin,
> >
> > Yes, it will suck down the whole processor. We had a new implementation,
> > with ZERO users, that had the problem.
> >
> > It is a memory leak of some sort. 8163 fixed it.
> >
> >
> > - Jerry
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 23, 2001 3:59 PM
> >
> >
> > > Interesting, i have never heard of this bug.  What do you mean, all of
> the
> > > sudden it will suck down the whole processor?  How many users?
> > >
> > > -Original Message-
> > > Sent: Friday, March 23, 2001 3:37 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > There is a bug with some version of Oracle (I believe it was
8.1.6.0.0,
> > but
> > > don't quote me on that), where even with NO users, oracle.exe would
> > > eventually consume your whole CPU. The CPU utilization ramps up after
a
> db
> > > restart until it gets to 99 or 100.
> > >
> > > Open Task Manager and check the oracle.exe process.
> > >
> > > I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.
> > >
> > >
> > > Good luck!
> > >
> > > - Jerry
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 23, 2001 12:17 PM
> > >
> > >
> > > > Since you mention there are only a few users, I would take a look at
> the
> > > > jobs these users are running.  Maybe one of these users is firing
off
> a
> > > > poorly tuned job that brings the database to a grinding halt.
> > > >
> > > > Is the database the only product on the Server?  Or

Re: do you use SQLJ ?

[Jonathan Gennick]

I also am interested in talking to people who use SQLJ.

Best regards,

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

Thursday, March 22, 2001, 8:20:30 PM, you wrote:
JC> Dear List,

JC> I haven't really seen a question on this list regarding SQLJ, and it makes
JC> me wonder how many people on this list actually use SQLJ.  A DBA friend of
JC> mine told me that eventually SQLJ will replace PL/SQL in preference, and I
JC> wanted to know the truth regarding his statement - so who better to ask than
JC> the experts of this list?

JC> What have you heard, or better yet, what is your opinion of SQLJ?  Is SQLJ
JC> the future?  Will PL/SQL die a slow death?  Can you do everything in SQLJ
JC> that you can do in PL/SQL?


JC> Cheers,

JC> Jeff Cox
JC> IPS-Sendero
JC> Scottsdale, AZ


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

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

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

how to compile the object type LIBRARY in oracle 8i

[Seema Singh]

Hi Gurus
How to compile following object type like (LIBRARY and PACKAGE BODY).
Thanks in advance
Mayank


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

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

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

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

[Deshpande, Kirti]

Make sure you have ORACLE_SID & ORACLE_HOME properly set for your Client
connections. Confirm that listener.ora has correct entries for it. If on
UNIX, remember that ORACLE_SID is case sensitive. Please search Metalink for
this error number. There is a note related to this error.

HTH.

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Haskins, Ed [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 10:36 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: ORA-27101: shared memory realm does not exist
> 
> Abiy,
>  
> I'm not positive, but it appears that the server's Shared Memory may not
> be configured.  Is the database started and open?  I'm assuming not...if
> in fact Oracle can't allocate the SGA in Shared Memory.  You may need to
> reconfigure your Shared Memory settings and recompile the UNIX Kernel.
> Check to see if these shared memory settings exist first.
>  
> Ed Haskins]
> Oracle DBA
> Verizon Wireless
> 
>   -Original Message-
>   From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]
>   Sent: Monday, March 26, 2001 10:41 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: ORA-27101: shared memory realm does not exist
>   
>   
>   I have this error when I try to connect to a 8.1.7 database
> instance.  I don't really know what's happening.  To give just an
> information, on the server machine I've 2 database engines (7.3.4 and
> 8.1.7) and on both engines there are 2 or more instances running.  I've
> only one listener.ora file for both engines, with the correct ORACLE_HOMES
>
>   Thank you folks ... 
>   
> --
> --
>   @biy @lemu
>   [EMAIL PROTECTED] 
>   Cril Telecom Software
>   France
>
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Anyone running Broadvision?

[Jerry C]

Hi,

Is anybody running Broadvision w/ Oracle? Does Broadvision have any official
recommendation as far as analyzing the BV schema?


Thanks!

Jerry


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

RE: Migration from 7.3.4 to 8.1.6

[Dan . Hubler]

After engaging Oracle WWS concerning this issue we have learned that there
have been a significant
number of complaints regarding performance when upgrading to 8.1.6.x.

It appears that re-running your ANALYZE is not enough.

Dropping statistics and then running ANALYZE might be required.





-- Forwarded by Dan Hubler/DS/MICORP on 03/26/2001
11:41 AM ---

Dan Hubler
03/23/2001 01:46 PM


To:   "Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> @ MICORPEX
cc:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>


Optimizer mode was CHOOSE in both releases.

Statistics are estimated at 10 percent.

Used command-line migration tool.

Thanks for replying.







"Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> on 03/23/2001 12:37:15
PM

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:


Dan:
  Thanks for your answer.  What is your optimizer method in the 8.1.6 db
vs. what it was in 7.3.4 ? (I think Oracle 8 defaults to Choose)  Do you
have statistics computed or
estimated on the table ?  What method did you use to migrate ? export /
import, migration assistant , or command-line migration tool ?

I would also look at indexes on the table, Maybe the query is using an
index when it should not or vice-versa.

Thanks in advance,
  Mary

-Original Message-
Sent: Friday, March 23, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L




The thing that is killing us is a single query.

This query does a group by.

It also references some user-defined functions in the column-list of the
SELECT statement.

These user-defined functions are actually SELECTS from 2 other small
tables.

It is not behaving the same way it did in version 7.3.4.

The table that the query runs against is pretty big (700,000 rows across 4
gig).
The 2 tables referenced by the user-defined functions are very small (10-20
rows).








"Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> on 03/22/2001 04:18:30
PM

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>


Dan:
  What kinds of problems ?  I am beginning a migration of a hybrid OLTP /
OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6  We are planning to take 6
weeks to "clean up" the
database and fix the chained /migrated rows before we migrate (mainly on
the big tables).  We will spend a month testing on a migrated copy before
migrating production.  Our apps
are custom Powerbuilder apps.  I decided to go to 8.1.5 because our other
databases are 8.1.5, and just live with the fact I cannot import a table
from a multiple-table export.
(that bugs me to no end)  I am most interested in responses to this post.
Maybe some truly compelling reasons to go to 8.1.6 , although I heard about
hanging listener problems
with that version which scared me.

thanks in advance,
Mary Ruiz / Atlanta

-Original Message-
Sent: Thursday, March 22, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L



We just migrated the first of our environments from 7.3.4  to  8.1.6  (
Solaris  2.6   ).

We have run into a couple of problems that only seem to appear when
processing
large tables or large amounts of data.

This is kind of what we expected because we did not have the resources to
do full-blown, production size testing.

Anybody have any information on things that go wrong with this type of
migration?



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

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

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




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

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

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






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

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

To REMOVE yourself from this mailing list, send an E-Ma

UNIX CD on NT

[Khedr, Waleed]

Is there a way to read an UNIX CD correctly on NT?
I want to use my CD drive (on NT) to get the files and permissions read
correctly on UNIX!

Thanks,

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

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

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

Re: DBMS_REPAIR package usage

[Winnie_Liu]

Thanks for your help! I will definitely try that later today! :D

It's really nice to have a full team of people helping me out when I am in
a "confused" phrase.

And I really do hope that there is not any "I know it's off-topic, but I
just couldn't resist .." spam over there.

I use my delete keys a lot more frequent than before (it is only my
opinion. I am not starting any war here..)

:P

Winnie







yong huang <[EMAIL PROTECTED]> on 03/24/2001 05:04:00 AM

To:   [EMAIL PROTECTED]
cc:   [EMAIL PROTECTED]



Hi, Winnie,

How did you find the file# to be 9 (unless you messed with your original
error
message)?

I suggest you post your message to news:comp.databases.oracle.server (or
http://news.interbulletin.com/cgi-bin/ibwrn/post/comp.databases.oracle.server

if your company doesn't have a news server). Hopefully it will attract
attention of Jonathan Lewis, the Oracle 8i expert, and several (former)
Oracle
employees such as Kyle Hailey, Howard Rogers and Anjo Kolk. The good thing
about that newsgroup is nobody is audacious enough to post spam messages
like
"tomorrow I'll post the chocolate recipe here".

Yong Huang
[EMAIL PROTECTED]

--- [EMAIL PROTECTED] wrote:
>
>
> Yong,
>
> Thanks a lot for all the research! :D
>
> The file# that actaully contains this block is 9. My database is not that
> big at all.
>
> I did do some research myself and some Oracle analysts in the World Wide
> Support does suggest that the influxed blocks are very likely to be a
> fractured block. But I reallly have no idea how it got in there... .
>
> Winnie
>
>
>
>
>
> yong huang <[EMAIL PROTECTED]> on 03/23/2001 04:01:21 PM
>
> To:   [EMAIL PROTECTED]
> cc:   [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
>
> Subject:  Re: DBMS_REPAIR package usage
>
>
> Hi, Winnie,
>
> Just a little more research. I wonder how you can have an rdba that big,
> 0x24070020, which is 604438560 in decimal.
>
> SQL> var a number;
> SQL> exec :a := dbms_utility.data_block_address_file(604438560);
>
> PL/SQL procedure successfully completed.
>
> SQL> print
>
> A
> -
>   144
>
> SQL> exec :a := dbms_utility.data_block_address_block(604438560);
>
> PL/SQL procedure successfully completed.
>
> SQL> print
>
> A
> -
>458784
>
> This is done on 8.1.6. It says the block is in file 144, block 458784.
Why
> does
> your error say file=0? Anyway, in case you do have a file numbered 144,
> check
> to see if there's an object there. If it's indeed file 0, the dba should
be
> the
> same as block#, 458784, or 0x70020. DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS
> can
> confirm this. However, that file# 0 may be just an indicator that that
> information is lost, as multiple other 0's look like.
>
> I believe dbv reports an error when it encounters a fractured block,
i.e.,
> the
> first two bytes of tail (0003 in your case) does not match the last two
> bytes
> of rdba (0020). We know how a fractured block is created during hot
backup.
> But
> I don't understand why an offlined datafile (as you said in another
email)
> can
> contain fractured blocks. Maybe Jeremiah Wilton can give a better answer.
>
> Yong Huang
> [EMAIL PROTECTED]
>
> you wrote:
>
> I have a datafile in my production box (a user data tablespace), when I
run
> dbv against it, it showed that 5 blocks are "influxed"
>
> Page 458784 is influx - most likely media corrupt
> ***
> Corrupt block relative dba: 0x24070020 file=0. blocknum=458784.
> Fractured block found during dbv:
> Data in bad block - type:0. format:0. rdba:0x
> last change scn:0x. seq:0x0 flg:0x00
> consistancy value in tail 0x0003c204
> check value in block header: 0x0, check value not calculated
> spare1:0x0, spare2:0x0, spare2:0x0
>
> We can copy this file to tape, dd this file. On the OS disk level, the OS
> does
> n
> ot treat this as corrupted. But it is corrupted on the oracle
> (software) level.
>
> I've checked and can't find any object associate with these 5 corrupted
> blcok.
>
> That means that there is no data inside those blocks.
>
> Since the tablespace is about 12 GB on a highly active system (which only
> got 3
> hours maintance window each month), export/import (then drop the
> tablespace)
> which Oracle support suggested is mostly out of the question.
(Especially,
> it
> is
>  very hard for me to convince the sysadmin that the blocks are
> corrupted
> as they don't see any I/O error associate with this file and the
developers
> don'
> t see any problem with the application either!)
>
> I am currently thinking about upgrading this database to 8.1.6 to make
use
> of
> th
> e DBMS_REPAIR package to make those blocks as "unusable". But I
> am not sure that if the DBMS_REPAIR package can run against the blocks
> which do
> not belong to any objects!! Can someone  give me some
> guidences?
>
> thanks
>
> Winnie
>
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.y

RE: Which is faster??

[Connor McDonald]

Direct patch sqlldr (and insert-append) do allow
indexes - its just that you get slugged a little more
on rollback and redo...

I don't have any metrics to compare - typical usage of
either tends be to the ol'  a) drop ind, b) load, c)
redindex

hth
connor

--- Martin Kendall <[EMAIL PROTECTED]> wrote: >
I know that Direct Path of sqlldr does not allow
> Indexes
> so what is the comparative performance of this
> suggestion if
> the given Table is indexed ?
> 
> Martin
> 
> -Original Message-
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


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

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


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

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

RE: ORA-27101: shared memory realm does not exist

[Kevin Kostyszyn]

If this is NT I have had this error as well.  Mine was an error in the
init.ora parameters, I forgot to comment something out.
Kevin

-Original Message-
Sent: Monday, March 26, 2001 10:58 AM
To: Multiple recipients of list ORACLE-L


What is the OS?

-Original Message-
Sent: Monday, March 26, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L


I have this error when I try to connect to a 8.1.7 database instance.  I
don't really know what's happening.  To give just an information, on the
server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines
there are 2 or more instances running.  I've only one listener.ora file for
both engines, with the correct ORACLE_HOMES

Thank you folks ...


@biy @lemu
[EMAIL PROTECTED] 
Cril Telecom Software
France


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

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

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

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

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

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

[Haskins, Ed]

Abiy,
 
I'm 
not positive, but it appears that the server's Shared Memory may not be 
configured.  Is the database started and open?  I'm assuming not...if 
in fact Oracle can't allocate the SGA in Shared Memory.  You may need to 
reconfigure your Shared Memory settings and recompile the UNIX Kernel.  
Check to see if these shared memory settings exist first.
 
Ed 
Haskins]
Oracle 
DBA
Verizon Wireless

  -Original Message-From: ALEMU Abiy 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 26, 2001 
  10:41 AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-27101: shared memory realm does not exist
  I have this error 
  when I try to connect to a 8.1.7 database instance.  I don't really know 
  what's happening.  To give just an information, on the server machine 
  I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or 
  more instances running.  I've only one listener.ora file for both 
  engines, with the correct ORACLE_HOMES
   
  Thank you folks 
  ... 
  
  @biy @lemu
  [EMAIL PROTECTED]
  Cril Telecom Software
  France
   

RE: Unix question

[Brian MacLean]

this 
is ksh93 syntax (at least on Sun):
 
1453:oracle@e6500b> ksh1453:oracle@e6500b> 
var=tester1453:oracle@e6500b> echo ${var//e/o}ksh: ${var//e/o}: bad 
substitution
1453:oracle@e6500b> 
dtksh1453:oracle@e6500b> var=tester1453:oracle@e6500b> echo 
${var//e/o}tostor1453:oracle@e6500b>

  -Original Message-From: Mandar Ghosalkar 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 8:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Unix question
  check this question from korn faq at 
  http://www.kornshell.com/doc/faq.html
   
  Q24. How do I do global substitutions on 
  the contents of shell variables?A24. Use // instead of / for global 
  substitution, ${var//aa/bb} willexpand to the value of  with each 
  "aa" replace by "bb".
  so i 
  tried
  $ 
  var=tester$ echo $vartester$ echo ${var//e/o}bad 
  substitution$
   
  anyone out there :)
   
  -Mandar
   
  
-Original Message-From: Big Planet 
[mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 7:56 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Unix question
Hi geeks ,
How can I do substr and instr kind of operaion 
in unix shell script . is it possible ? 
like i have one paramter as "hostname" .. I 
want to trim quotes surrounding the hostname .
One more question , is possible to read another 
text file line by line using a shel script and then edit that file 
.
Actually I have this configuration file for my 
system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to 
replace with actual values at the time of installation by asking questions 
to the user.
 
TIA
--Big planet
 
 

Oracle DBAs with AIX experience needed in Florida..

[OraStaff]

Position: Oracle DBAs with AIX experience
Location: Ft Lauderdale, Florida
Industry: Resorts
Salary:   Up to 95K 

Description:

These positions are with a major entity in the resorts industry that needs 
Oracle DBAs who have AIX experience to provide database support. 
These are staff positions...so no third parties or sub-contractors please.

Requirements:
 
*They need someone with at least three years Oracle DBA experience.
*Solid AIX platform experience.
*Strong written and oral communication skills.
**Must be a U.S. citizen or permanent resident.


This position offers:
   * Stability 
   * The opportunity to become a key member of the team.
   * Relocation assistance

Please do not send your resume if you are not in the United States.

For  immediate consideration, please email your resume as an attachment to:

OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
Please use job code: One/DBA/Ft.Lauderdale/Linda W.

Note: This is only one of the many opportunities that we have available
across the U.S. 
for candidates with Oracle skills. So if this one is not a match for you, we
invite you 
to send us your resume- as we quite possibly have the opportunity that you
are seeking.

I pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law



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

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

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

RE: Which is faster??

[Witold Iwaniec]

As far as I remember direct load allows to load data into indexed 
table - it "disables" indexes for the loading time and builds the 
indexes once, after the load completes. Also it prepares binary 
array corresponding to the table layout and writes directly to the 
file. Conventional load basically creates an insert statement for 
each row of data to be loaded and executes it. It also modifies 
indexes after each record has been loaded. It makes big difference 
in time, of course depending on the volume

Witold


On 26 Mar 2001, at 7:31, Martin Kendall wrote:

> I know that Direct Path of sqlldr does not allow Indexes
> so what is the comparative performance of this suggestion if
> the given Table is indexed ?
> 
> Martin
> 
> -Original Message-
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the statue"
> 
> 
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Martin Kendall
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


==
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
[EMAIL PROTECTED] 
http://www.novalistech.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

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

Doc on migrating to Oracle 8.1.6 on Solaris

[Cale, Rick T (Richard)]

Hi,

I checked OTN and they do not have doc on migrating to 8.1.6 for Solaris.
Does anyone know where I can
get this?

All I found on OTN is which has no info on migration

Sun SPARC Solaris 2.x, Release 8.1.5
 HTML   PDF   Installation Guide
 HTML   PDF   Administrator's Reference

Thanks
Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

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

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

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

Source Code about Java Classes

[Sergio Boix Moriano]

Hi all,

Does anyody knows how to find the source code about Forms java
classes (oracle.forms.ui), i've looked for it at OTN, Technet and
Metalink, and haven't found no documentation about it.

Thanks in advance


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

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

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

OLAP again

[Witold Iwaniec]

Hi

Our product uses quite complex data model and we are looking for 
ways to speed up data access, especially large reports in the 
range of 25,000+ records.
One of the ideas was to look into OLAP, or now Business 
Intelligence, tools. After some reading it seems to me that OLAP is 
completely separate product - it is the Express Server that runs its 
own database, and tools like Express Objects, Express Analyzer 
that use the Oracle 9iAS and Express Server technology. You can 
still connect to your Oracle database or import/export the data for 
analysis, reporting, etc. but you have to set up completely new 
environment.

We hoped that we could use OLAP tools to point to Oracle 8i 
database and use it to provide faster access to our complex data 
model but it does not seems so straightforward. Or maybe I 
missed a tool. Could someone, please, correct me?

Thanks

Witold
==
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
[EMAIL PROTECTED] 
http://www.novalistech.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

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

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

[Henry Poras]

What is the OS?

-Original Message-
Sent: Monday, March 26, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L


I have this error when I try to connect to a 8.1.7 database instance.  I
don't really know what's happening.  To give just an information, on the
server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines
there are 2 or more instances running.  I've only one listener.ora file for
both engines, with the correct ORACLE_HOMES
 
Thank you folks ... 


@biy @lemu
[EMAIL PROTECTED]  
Cril Telecom Software
France
 

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

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

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

ORA-27101: shared memory realm does not exist

[ALEMU Abiy]

I have this error 
when I try to connect to a 8.1.7 database instance.  I don't really know 
what's happening.  To give just an information, on the server machine I've 
2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more 
instances running.  I've only one listener.ora file for both engines, with 
the correct ORACLE_HOMES
 
Thank you folks 
... 

@biy @lemu
[EMAIL PROTECTED]
Cril Telecom Software
France
 

RE: Unix question

[Brian MacLean]

The UNIX command "sed", "awk", and "tr" offer a world 
of solutions for altering text.
 
Using Ksh93 you can do substringing.  You can find 
it on Aix, and Sun system in the form of "dtksh".  The syntax 
is:
 
    
#!/usr/dt/bin/dtksh
    ...cut...
    
myvar=${myvarin:startpos:length}
    ...rest...
 
To edit a file on the fly use the old "edit" 
command.  An example follows:
 
    3925:oratst@marge> cat 
/tmp/abc    
bccc    
$HOSTNAME$.$SCHEMA$    
1223    
3925:oratst@marge>
    3925:oratst@marge> edit /tmp/abc 
<<\EOF    > 
1,$s/\$HOSTNAME\$/MYBOX/g    > 
1,$s/\$SCHEMA\$/MYSCHEMA/g    > w    
> q    > EOF    "/tmp/abc" 3 lines, 
110 characters    MYBOX.$SCHEMA$    
MYBOX.MYSCHEMA    "/tmp/abc" 3 lines, 105 
characters    3925:oratst@marge>    
3925:oratst@marge>    3925:oratst@marge> cat 
/tmp/abc    
bccc    
MYBOX.MYSCHEMA    
1223    
3925:oratst@marge>    
3925:oratst@marge>

  -Original Message-From: Big Planet 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 6:56 
  PMTo: Multiple recipients of list ORACLE-LSubject: Unix 
  question
  Hi geeks ,
  How can I do substr and instr kind of operaion in 
  unix shell script . is it possible ? 
  like i have one paramter as "hostname" .. I want 
  to trim quotes surrounding the hostname .
  One more question , is possible to read another 
  text file line by line using a shel script and then edit that file 
  .
  Actually I have this configuration file for my 
  system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace 
  with actual values at the time of installation by asking questions to the 
  user.
   
  TIA
  --Big planet
   
   

RE: Single Code Table or Separate Code tables dilemma

[Norrell, Brian]

As to the encapsulation: Yes things should be encapsulated, fine. But are
you saying you do not use any queries in your encapsulating procedures?
Have you ever seen an app that was completely encapsulated?  What about the
developer that gets repeatedly reprimanded for not following corporate
standards but is married to the CEO's daughter?

You keep referring to code that has to be changed anyway.  Perchance another
example, we'll use the DOCTOR table from the Ghosalkar/Kilchoer thread:

CREATE TABLE I_DONT_LIKE_MASTER 
( CODE_TYPE VARCHAR2(4) NOT NULL,
CODE_VALUE VARCHAR2(3) NOT NULL,
CODE_DESC VARCHAR2(20) ,
PRIMARY KEY (CODE_TYPE, CODE_VALUE) )

SPLTN   SDFLJDSL
SPLTFP  SDFSDKFDS
SPLTOBG SFLSDJFSD
TYPEMD  SDFLSDFSDF
TYPEFP  SDFJDSFJ
TYPEOPH SDLFJDSKF

CREATE TABLE DOCTOR
(.,
SPECIALITY_CODE_TYPEVARCHAR2(4),
SPECIALITY_CODE_VALUE   VARCHAR2(3),
TYPE_CODE_TYPE  VARCHAR2(4),
TYPE_CODE_VALUE VARCHAR2(3),
.,
foreign key  (SPECIALITY_CODE_TYPE,SPECIALITY_CODE_VALUE) references
I_DONT_LIKE_MASTER,
foreign key  (TYPE_CODE_TYPE, TYPE_CODE_VALUE ) references
I_DONT_LIKE_MASTER )

D1  SPLTN   TYPEOPH
D2  SPLT  N TYPEMD

The users tell us: We need to track specialties as being primarily inpatient
or outpatient so that extra information can be collected for inpatient
situations (I know, those of you doing work in health care can shoot all
kinds of holes in this.)

The one table way:
CREATE TABLE SPECIALTIES
(CODE_VALUE VARCHAR2(3) NOT NULL,
CODE_DESC VARCHAR2(20) ,
INPATIENT_YN VARCHAR2(1),
PRIMARY KEY (CODE_VALUE) )

Then I copy all the entries from the code table. (script that must run at
the production site - asking for trouble), remove them from the old table
(even more dangerous).  Update the master table entry program and procedures
to not allow the archived code any more.  Rip through every scrap of code in
the system to find any reference to I_DONT_LIKE_MASTER to make sure it does
not have any need of the archived code type.  Please bear in mind that
although you are being a very good programmer and using encapsulation, the
idiots that got fired last week were not, so we still have to look.  Any
that are found will have to be changed.  Now I create my new entry form to
add the field and update the registration code.  Then I sit back and wait
for 1) one of the client's Access reports to return no data because they did
not realize the data had been moved, or 2) some of our code to break because
we overlooked something.



The multiple table way:
CREATE TABLE SPECIALTIES
(INPATIENT_YN VARCHAR2(1))
Now I create my new entry form to add the field and update the registration
code.  Done.  Where are these other code changes that have to be done?

All the old code (encapsulated or not) still works the way it used to.  If I
overlook something, it may not have the added functionality, but it will not
break.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600
 
PS:  I think this discussion would best be continued with copious amounts of
alcohol.  If you are ever in Dallas, look me up.

> -Original Message-
> From: Michael Netrusov [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Single Code Table or Separate Code tables dilemma
> 
> 
> 
> > > Well, in the case of 100 tables you are still hunting all the
> > > code looking for pieces which are relevant to that changed table.
> > > Depends on your code. I prefer to encapsulate mine, so
> > > reference to a table is enclosed in its own package.
> >
> > My point is that I can use grep to search the entire code 
> for "order_status"
> > and get a short list (maybe 10) of places to look.  It is much more
> > difficult to search for "code_table", get a list of 1, 
> then filter
> > through the results for some bastardized variety of 
> "code_type = 'STATUS'"
> > to get down to those same 10.
> >
> > Not everything can be encapsulated in a procedure.  This is 
> a database we
> > are talking about, so people do still write queries where 
> it is easier to
> > join the lookup table to the master table directly.  If the 
> code has to be
> > broken out of the central lookup table, you have to update 
> every query that
> > joins it in, even if all that query needs is the 
> description.  If it is
> > already split out, the only code I really have to be 
> concerned with is the
> > places where the new functionality applies.
> 
> Queries still can be ( and should be ) encapsulated in 
> packages. If you are taking this to-be-enhanced 'status' 
> entity out of the
> master lookup table, all you have to do is to develop a new 
> package, change the calling code and prohibit the usage of code_type =
> 'status' in the master lookup table. This still would be 
> changed if you had a separate package and table for the 
> 'status' entity.
>

Problem : Oracle connection thru' COM object

[Bathma Sivaraj]

Title: Problem : Oracle connection thru' COM object





I'm facing a problem while connecting Oracle through COM object hosted in MTS. I have tried following providers/drivers for the connection.

 
1. Microsoft OLEDB provider for Oracle
2. Microsoft ODBC driver for Oracle
3. Oracle ODBC driver 
 
In case 1. it gives "Catestrophic Failure" error.
In case 2. and case 3. "Driver not capable" error is fired.
 
If the COM class is compiled with "Not an MTS Component" property things are fine. But if other properties are used while compilation, above mentioned errors are encountered.

 
Please try to solve my problem ASAP.



Thanks and Regards,


Bathmasivaraj A, 
Software Engineer,
Atos Origin India. Ltd.,
Email : mailto:[EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]

RE: Which is faster??

[Martin Kendall]

I know that Direct Path of sqlldr does not allow Indexes
so what is the comparative performance of this suggestion if
the given Table is indexed ?

Martin

-Original Message-
Sent: 23 March 2001 09:05
To: Multiple recipients of list ORACLE-L


If you're on 8.0 or higher, try

insert /*+ APPEND */ 
into table
select * from other_table;

where "table" is defined as nologging.  Then you won't
hit either redo logs or rollback segments..Its the
equivalent of a sqlldr direct load

hth
connor

--- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
the following scripts:
> 
> insert into table
> select * from table2
> ;
> 
> So if use the about bulk statement in my 
> application, and the table2 is big, say 10
> million records, my concern is that it's 
> going to fail because of the possible rollback
> segments failure. So then I have to use PL/SQL
> to create a cursor and commit every 5 records.
> What's the disadvantage of this?Will it be much
> slower
> than a bulk insert?
> 
> Can I do it another way: create a stored procedure
> for this bulk insert, then pin this procedure in
> memory, does it still have RBS problem?
> 
> Anyone has similar experience?
> 
> Thanks in Advance,
> 
> Chris
> 
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: CC Harvest
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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


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

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

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

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

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

RE:

[Armstead, Michael A]

Read the documentation on the 'orapwd' utility.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline


> -Original Message-
> From: Nihar [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 4:41 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  
> 
> hi ppl
> 
>  can any body help in changing internal pwd on solaris system. i couldn't
> find oradim on sun. Is there any similar tools like oradim on solaris..
> 
> thanks
> 
> 
> - NIHAR SANGHVI
> 
> NetMagic Solutions Pvt. Ltd.
> 22,Nirlon Complex,Western Express Highway,
> Goregaon (E), Mumabai 400 063
> 
> Phone: 8723003 extn: 144
> www.netmagicsolutions.com
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nihar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Help...Rollback Segmenst Grow?

[Scott Hahn]

Gurus


1)
I am doing some data movement involving a table creation based on
another table
create table userid.pm_stage_lg_arch tablespace user_data as select
*from userid.pm_stage_lg where
entry_timestamp<= to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS');

This creates a table with 1,000,000 rows and grows my tablespace by 360
MB...

2)
I then want to delete the rows from the original table based on the same
date range.
delete from nuserid.pm_stage_lg where entry_timestamp <=
to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS');

The problem is that when I issue this statement which deletes
1,000,000 rows my rollback segments understandably grow by 600 MB...
1) Can I issue this statement without growing the rollback
segments? (no recover?)
2)  Can I actually shrink the size of the rollback segments
after backing up the database?

3) As you see in the statement I am basing my select on the date which I
need to be exact...Is there a way I could do it as select sysdate-45 from
dual and have it returned in teh same format as 'DD-MON-YY HH24:MI:SS' ???
I have been trying this for a while and cant get it..

Thanks for the help.  This is a DB that is limited in Hard drive space so I
need to conserve..

Scott Hahn


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

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

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

Re: changing internal password

[Chuck Hamilton]

You use the orapwd utility to change the remote internal password on unix. The default file name is $ORACLE_HOME/dbs/orapw$ORACLE_SID. Also, when you log in as internal locally, you don't need a password as long as the id you log in with is part of the dba unix group.
  Nihar <[EMAIL PROTECTED]> wrote: 
hi pplcan any body help in changing internal pwd on solaris system. i couldn'tfind oradim on sun. Is there any similar tools like oradim on solaris..thanks- NIHAR SANGHVINetMagic Solutions Pvt. Ltd.22,Nirlon Complex,Western Express Highway,Goregaon (E), Mumabai 400 063Phone: 8723003 extn: 144www.netmagicsolutions.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: NiharINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY!
!
, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

RE: Connect internal password ?

[William Beilstein]

SVRMGRL will not allow you to connect internal unless the user is a member of the dba 
group.

>>> [EMAIL PROTECTED] 03/26/01 06:25AM >>>
I try to restrict other user from accessing other than sqlplus, by creating
new group for them and inside my
/appl/Oracle8i/bin/bla bla bla   rwxrw-
so i can not mix those with dba group do you have any sugestion?



-Original Message-
Sent: Monday, 26 March 2001 6:57 PM
To: [EMAIL PROTECTED]; 'lzDBA'; [EMAIL PROTECTED] 


Associate that second user to the 'dba' unix group.










- Original Message -
To: 'lzDBA' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 4:06 PM


> Hi guys,
>
> (WITH SOLARIS 7 and ORACLE 8.1.6)
>
> After I create a new user that can access SVRMGRL and with user .profile
> updated, this user cannot connect internal - SVRMGRL ask for password,
> the most strange is that when I create my second user there is no such
> problem (first one is the DBA for oracle installation).
> There is no proble with the .profile because I do "copyt and paste"
>
> I heard that orapwd able to solve this problem, what is the file for ? and
> is that all other users have that kind of file and where Oracle store it ?
>
>
> Thank you for your time,
>
>
> Sinardy
>
>
> 
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to [EMAIL PROTECTED] 
> to subscribe send a blank email to [EMAIL PROTECTED] 
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 
> Tell yer mates about http://www.farAwayJobs.com 


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com 


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

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

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

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

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

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

RE: Unix question

[Chuck Hamilton]

For single character replacement (or removal) use "tr". For string to string replacement use sed.
echo $var | tr "e" "o"
-or-
echo $var | sed "s/e/o/g" # (the '/g' means globally)
  Mandar Ghosalkar <[EMAIL PROTECTED]> wrote: 




check this question from korn faq at 
http://www.kornshell.com/doc/faq.html
 
Q24. How do I do global substitutions on the contents of shell variables?A24. Use // instead of / for global substitution, ${var//aa/bb} willexpand to the value of  with each "aa" replace by "bb".
so i tried
$ var=tester$ echo $vartester$ echo ${var//e/o}bad substitution$
 
anyone out there :)
 
-Mandar
 

-Original Message-From: Big Planet [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 7:56 PMTo: Multiple recipients of list ORACLE-LSubject: Unix question
Hi geeks ,
How can I do substr and instr kind of operaion in unix shell script . is it possible ? 
like i have one paramter as "hostname" .. I want to trim quotes surrounding the hostname .
One more question , is possible to read another text file line by line using a shel script and then edit that file .
Actually I have this configuration file for my system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace with actual values at the time of installation by asking questions to the user.
 
TIA
--Big planet
 
 Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

OEM 2.1 and Netscape / JRE conflict?

[Boivin, Patrice J]

I am having OEM problems again, this time related to the JRE I think -- it
is REALLY slow again.  This is with OEM 2.1 instead of OEM 2.2.

I am not sure yet, but I think I am narrowing things down (?)

I used to have problems with OEM 2.2., jre.exe would be way too slow, to the
point that OEM became unusable.

I re-installed OEM 2.2, and installed OEM 2.1 to go with the 8.1.6
repository.

Everything was fine, I took a snapshot of three schemas on an Oracle 7.3.
database, imported them into an 8.1.6 database, then compared them.  No
problem, except that the Change Manager report's HTML files was over 1 Meg
in size.  IE took forever to load it, so I decided to try loading it with
Netscape to see what would happen.

I was so happy though, the OEM was running properly.

I installed Netscape on my machine.

I could read the HTML file all right, but later I discovered I can no longer
connect to the Oracle Management Server -- it shuts down at the same time as
I get a "Cannot connect to Oracle Management Server" at the login prompt.

Could it be that Netscape's JRE might be interfering with Oracle's?

I used to have Netscape on that machine when OEM 2.2. was on it, now I am
wondering if this is just a coincidence or if Netscape's JRE isn't
interfering with the OEM's somehow.

I de-installed Netscape using Add / Remove Programs, but of course by now
the damage has been done and the OEM java components take forever.  (e.g.
the OUI cannot finish looking at current configuration, it just runs and
runs...)

TIA
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada

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

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

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

RE: Connect internal password ?

[Sinardy Xing]

I try to restrict other user from accessing other than sqlplus, by creating
new group for them and inside my
/appl/Oracle8i/bin/bla bla bla   rwxrw-
so i can not mix those with dba group do you have any sugestion?



-Original Message-
Sent: Monday, 26 March 2001 6:57 PM
To: [EMAIL PROTECTED]; 'lzDBA'; [EMAIL PROTECTED]


Associate that second user to the 'dba' unix group.










- Original Message -
To: 'lzDBA' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 4:06 PM


> Hi guys,
>
> (WITH SOLARIS 7 and ORACLE 8.1.6)
>
> After I create a new user that can access SVRMGRL and with user .profile
> updated, this user cannot connect internal - SVRMGRL ask for password,
> the most strange is that when I create my second user there is no such
> problem (first one is the DBA for oracle installation).
> There is no proble with the .profile because I do "copyt and paste"
>
> I heard that orapwd able to solve this problem, what is the file for ? and
> is that all other users have that kind of file and where Oracle store it ?
>
>
> Thank you for your time,
>
>
> Sinardy
>
>
> 
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to [EMAIL PROTECTED]
> to subscribe send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

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

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

Re: Connect internal password ?

[K Gopalakrishnan]

Associate that second user to the 'dba' unix group.










- Original Message -
To: 'lzDBA' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 4:06 PM


> Hi guys,
>
> (WITH SOLARIS 7 and ORACLE 8.1.6)
>
> After I create a new user that can access SVRMGRL and with user .profile
> updated, this user cannot connect internal - SVRMGRL ask for password,
> the most strange is that when I create my second user there is no such
> problem (first one is the DBA for oracle installation).
> There is no proble with the .profile because I do "copyt and paste"
>
> I heard that orapwd able to solve this problem, what is the file for ? and
> is that all other users have that kind of file and where Oracle store it ?
>
>
> Thank you for your time,
>
>
> Sinardy
>
>
> 
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to [EMAIL PROTECTED]
> to subscribe send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

Connect internal password ?

[Sinardy Xing]

Hi guys,

(WITH SOLARIS 7 and ORACLE 8.1.6)

After I create a new user that can access SVRMGRL and with user .profile
updated, this user cannot connect internal - SVRMGRL ask for password,
the most strange is that when I create my second user there is no such
problem (first one is the DBA for oracle installation).
There is no proble with the .profile because I do "copyt and paste"

I heard that orapwd able to solve this problem, what is the file for ? and
is that all other users have that kind of file and where Oracle store it ?


Thank you for your time,


Sinardy

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

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

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

No Subject

[Nihar]

hi ppl

 can any body help in changing internal pwd on solaris system. i couldn't
find oradim on sun. Is there any similar tools like oradim on solaris..

thanks


- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com






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

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

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

RE: Forms Server - MS IIS

[Kuijten, F. (Frank)]

Tamas,

Yes.
We have that combination running.

IIS 4, IE 4.0, Dev6i patch 3, JInitiator 1.1.8.3


Greetings,
Frank

> -Original Message-
> From: Szecsy Tamas [mailto:[EMAIL PROTECTED]]
> Sent: vrijdag 23 maart 2001 15:41
> To: Multiple recipients of list ORACLE-L
> Subject: Forms Server - MS IIS
> 
> 
> Hi Listers,
> 
> don't stone me for this question :-), but can Forms Server 6i 
> cooperate with
> Microsoft IIS to provide Forms over the Web?
> 
> TIA,
> 
> Tamas Szecsy
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Szecsy Tamas
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kuijten, F. (Frank)
  INET: [EMAIL PROTECTED]

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

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

Re: Best Practice ?

[K Gopalakrishnan]

Hi !

It all depends on your OPTIMIZER_MODE. I guess you
will be using CHOOSE and if that is the case I would recommend
analyzing the tables& indexes (or ANALYZE_SCHEMA) for
+ or - 10 % change.










- Original Message -
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, March 25, 2001 5:48 PM


>
> For Analyze of Tables on a Oracle 817 Database on Cluster with OPS ?
>
> Should the Tables be Analyzed OR Not ?
>
> This is a Application with More OLTP than Batch ( Banking Product )
>
>
>
> 
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to [EMAIL PROTECTED]
> to subscribe send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

RE: changing the datbase server name and IP number

[Mark Leith]

You may also need to indclude sqlnet.ora as well.

-Original Message-
Sent: Friday, March 23, 2001 06:41
To: Multiple recipients of list ORACLE-L


As long as you are keeping the DB_NAME's the same you should be able to get
by with changing the listener.ora and tnsnames.ora files.  You will also
need
to change your global tnsnames or Onames server references to these db's.

On Friday 23 March 2001 11:30, you wrote:
> We are setting up a new database server.  It's HP-UX 11.0.  Oracle 7.3.4
(I
> know, we need to upgrade !) has already been installed and configured on
> it. Databases have been built and are in use for testing.  In a couple of
> weeks, we'll be exporting the production database from our old server and
> importing it to the new machine.  Sometime during this process, we'd like
> to rename the new machine to have the same name as our old production
> server.  At the same time, the IP number will be changed.  The goal is to
> make the new production machine have the same name and IP number as the
old
> production machine.  Since Oracle has already been installed on the new
> server, and it already has test databases on it, what will need to change
> Oracle-wise when the host machine name and IP number change ?
>
> Thanks for any information you can share!
>
> Judy Hazeley
> Millersville University
> Millersville, PA
> [EMAIL PROTECTED] 

--
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views,
policies, or procedures of LodgeNet Entertainment Corporation


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

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

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

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

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

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