Metalink doc 52576.1 ?

[Prem Khanna J]

Hi List,

I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink.
Can someone mail me if u have a copy of the same ?

TIA.
Jp.


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

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

RE: Difference in Performance in two schemas in the same BD

[Wolfgang Breitling]

Those setting partially cancel each other out: the 
db_file_multiblock_read_count value of 32 causes the optimizer to assign a 
lower cost to full table scans and subsequently to hash joins. The setting 
of optimizer_index_cost_adj to 30 causes the optimizer to assign a lower 
cost to index accesses and to NL joins.

Given the setting of optimizer_index_cost_adj I would guess that your 
FK_CF02CON_TSA index has a high clustering factor. As I said in my previous 
post, try deleting the statistics for that index and see what happens.

How come that statement uses some bind variables, but then one literal? If 
it were all bind variables you could lock in the good plan with a stored 
outline - for example by deleteing the statistics on both tables, which 
will cause the RBO to parse the sql

At 05:49 PM 9/10/2003 -0800, you wrote:
Tks Wolfang

I have read the paper.

db_file_multiblock_read_countinteger 32
hash_area_size   integer 4194304
sort_area_retained_size  integer 1048576
sort_area_size   integer 2097152
hash_multiblock_io_count integer 0
optimizer_index_caching  integer 90
optimizer_index_cost_adj integer 30
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: how can I see which database I am logged into without

[GovindanK]

How about SELECT ORA_DATABASE_NAME FROM DUAL;

HTH
GovindanK

> select sys_context('USERENV','DB_NAME') from ;
>
> At 10:49 AM 9/10/2003 -0800, you wrote:
>>hi.
>>
>>I think there was a dbms package to get some of
>>the environment variables for a session, but I can't
>>remember anyhting specific. If someone know what I'm
>>talking about and has any details, please Email me or
>>post here
>>
>>thanks
>>
>>Gene
>
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> http://www.centrexcc.com
>
>
>

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

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

RE: Difference in Performance in two schemas in the same BD

[Ramon E. Estevez]

Tks Wolfang

I have read the paper.

db_file_multiblock_read_countinteger 32
hash_area_size   integer 4194304
sort_area_retained_size  integer 1048576
sort_area_size   integer 2097152
hash_multiblock_io_count integer 0
optimizer_index_caching  integer 90
optimizer_index_cost_adj integer 30

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Wolfgang Breitling
Sent: Wednesday, September 10, 2003 9:10 PM
To: Multiple recipients of list ORACLE-L


There could be many reasons why the CBO does not use an index and a NL
join 
like the RBO. The predicate columns could have skewed data distribution
in 
which case gathering histograms on those columns might help, even though

you're using bind variables. The index(es) could have a rather high 
clustering factor, turning the CBO off. In this case you could try
deleting 
the statistics on the index. The default clustering factor of 800 for an

index without statistics is likely to make the index much more
attractive. 
Also, what is your setting for db_file_multiblock_read_count? A high
value 
there can pull the CBO towards full table scans and hash joins.
Likewise, a 
high value for sort_area_size or hash_area_size and 
hash_multiblock_io_count will cause the CBO to favour hash joins.
Finally, you can experiment with optimizer_index_cost_adj and 
optimizer_index_caching. Read Tim Gorman's paper 'The Search for 
Intelligent Life in the Cost-Based Optimizer" (www.evdbt.com).


At 03:34 PM 9/10/2003 -0800, you wrote:

>Hi list,
>
>I had two schemas in the same BD with the same data
>  FBDI WITH STATISTICS
>  FBDIN NO STATISTICS
>
>The one without statistics run in less than 4 minutes
>The one with statistics run in like 30 minutes
>
>Any Help would be very, very appreciated as always.
>
>I already bought the book from Gaja and Kirti, by recommendation of 
>Madlen
>and Stephane, but hasn't arrived to my country yet, Dominican Republic,

>and need to improve this process ASAP.
>
>Applied the EVENT TRACE 10046 and this is the result of the schema with
>stats (FBDI).
>
>***
>*
>
>
>SELECT B.MATHOPERATOR,B.MAPACCOUNTLOCAL,A.PRINTORDER,B.SEQUENCE
>FROM
>  TEQUIVACCOUNT A,TEQUIVACCOUNTDETAIL B  WHERE A.REPORTCODE =
B.REPORTCODE
>   AND A.CODE = B.CODE  AND A.REPORTCODE = 'BDI01' ORDER BY
A.PRINTORDER,
>   B.SEQUENCE
>
>call count   cpuelapsed   disk  querycurrent 
>  rows
>--- --   -- -- --
>--  --
>Parse1  0.04   0.09  9187  0 
> 0
>Execute  1  0.00   0.00  0  0  0 
> 0
>Fetch 5658  0.57   0.70154152  8 
>  5657
>--- --   -- -- -- 
>--  --
>total 5660  0.61   0.79163339  8 
>  5657
>
>Misses in library cache during parse: 1
>Optimizer goal: CHOOSE
>Parsing user id: 20  (FBDI)
>
>Rows Row Source Operation
>---  ---
>5657  SORT ORDER BY
>5657   HASH JOIN
>  46TABLE ACCESS FULL TEQUIVACCOUNT
>5657TABLE ACCESS FULL TEQUIVACCOUNTDETAIL
>
>Rows Execution Plan
>---  ---
>   0  SELECT STATEMENT   GOAL: CHOOSE
>5657   SORT (ORDER BY)
>5657HASH JOIN
>  46 TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'TEQUIVACCOUNT'
>5657 TABLE ACCESS   GOAL: ANALYZED (FULL) OF
> 'TEQUIVACCOUNTDETAIL'
>
>***
>*
>
>
>SELECT MAX(A.ACM_FECACUM),NVL(A.ACM_ACUMDBANT,0) -
NVL(A.ACM_ACUMCRANT,0)  +
>   NVL(A.ACM_ACUMDB,0)  - NVL(A.ACM_ACUMCR,0)
>FROM
>  TCON_ACUM A,(SELECT
ACM_OFICINA,ACM_MONEDA,NVL(MAX(TRUNC(ACM_FECACUM)),
>   TO_DATE('2001/01/01','/MM/DD')) MAXFECACUM   FROM TCON_ACUM
WHERE
>   ACM_CODIGO = :b1  AND ACM_SUCURSAL = :b2  GROUP BY
> ACM_OFICINA,ACM_MONEDA )
>   T  WHERE A.ACM_CODIGO = :b1  AND A.ACM_SUCURSAL = :b2  AND
T.ACM_OFICINA =
>   A.ACM_OFICINA  AND T.ACM_MONEDA = A.ACM_MONEDA  AND
TRUNC(A.ACM_FECACUM) =
>   T.MAXFECACUM  GROUP BY
NVL(A.ACM_ACUMDBANT,0),NVL(A.ACM_ACUMCRANT,0),
>   NVL(A.ACM_ACUMDB,0),NVL(A.ACM_ACUMCR,0)
>
>call count   cpuelapsed   disk  querycurrent 
>  rows
>--- --   -- -- --
>--  --
>Parse1  0.01   0.03  1  3  0 
> 0
>Execute  16971  7.95   9.13  0  0  0 
> 0
>Fetch16971  2.18   2.58113  62981  0 
>  5770
>--- --   -- -- -- 
>--  --
>total33943 

RE: question about migrating to 9i

[M Rafiq]

Faan,

Thanks. After auto creation of script I changed it according to our own 
requirement and it is a really nice features. The other databases we added 
afterword we used the same scripts adter some changes.

No need to keep our own scripts all the time.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 10 Sep 2003 16:34:42 -0800
Dennis and Rafiq,

When you use the dbca you are prompted for this option at the end i.e. 
create
scripts or create the DB.  I HIGHLY recommend you go with the 'create 
script'
option as this allows you to QA the Oracle "Intelligence" before kicking it 
off.
It also serves as a good tutorial on what is involved in creating a Oracle 
DB
without studying the interesting Oracle docs...;-)

-f

-Original Message-
Sent: Wednesday, September 10, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L
Dennis,

There is an option to just create a script for you based on your critaria
and then you can modify it according to your requirement before creating the
database. I think I used this almost 1 year back so don't remember exactly
at what stage it ask for this option...
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 09 Sep 2003 17:49:27 -0800
Ryan
dbca is indeed available with Solaris. I used it today in fact. What
I've
learned about it is:
   - It runs in X-Windows. I don't have much expertise with X-Windows, but
it
seems to run fine from the Solaris console.
   - Unable to create a block size greater than 8k, at least what I've
found.
I believe the reason is that dbca doesn't "create" the data files, but has
precreated files it just copies into place. That's my theory anyway.
   - All data files are created with autoextend on. But you can change that
later.
   - The database is created with spfile which I don't like but it is easy
enough to CREATE PFILE FROM SPFILE.
   - I am usually a skeptic of GUI tools, but I am really impressed with
this
tool.
One alternative you could suggest to your production people is for them to
use dbca on a test system to create a database close to the one you want.
Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great
script (two versions in one, actually) that you can review, edit, etc. This
is an easy way to implement the 9i features you list without studying the
manual for the syntax  for each feature.
   Good luck, we production DBAs can be a touchy lot.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 09, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
they are doing it by hand i believe. no dbca. its a solaris system. dont
think there is a dbca for solaris? Im not a production dba, so i dont know
for certain,.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 6:14 PM
 > Ryan
 > If you (or whoever) is using dbca, I believe all this is configured
 > automatically. But watch the block size. That is the only thing you 
can't
 > change later.
 >
 >
 >
 > Dennis Williams
 > DBA, 80%OCP, 100% DBA
 > Lifetouch, Inc.
 > [EMAIL PROTECTED]
 >
 > -Original Message-
 > Sent: Tuesday, September 09, 2003 4:59 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > Im not going to physically do the migration, but I want to make sure
certain
 > features are set up. Let me know if Im missing any of the 
basics(anything
 > that is a pain to add on my own later).
 >
 > Locally Managed tablespaces are the default right?
 > Automatic Segment Allocation
 > Undo Tablespace
 > SPFILE
 >
 > any other goodies Im forgetting? Just basic settings. rest I can do
myself.
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.net
 > --
 > Author: DENNIS WILLIAMS
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 > San Diego, California-- Mailing list and web hosting services
 > -
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of mailing list you want to be removed from).  You may
 > also send the HELP command for other information (like subscribing).

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

Re: Difference in Performance in two schemas in the same BD

[Wolfgang Breitling]

There could be many reasons why the CBO does not use an index and a NL join 
like the RBO. The predicate columns could have skewed data distribution in 
which case gathering histograms on those columns might help, even though 
you're using bind variables. The index(es) could have a rather high 
clustering factor, turning the CBO off. In this case you could try deleting 
the statistics on the index. The default clustering factor of 800 for an 
index without statistics is likely to make the index much more attractive. 
Also, what is your setting for db_file_multiblock_read_count? A high value 
there can pull the CBO towards full table scans and hash joins. Likewise, a 
high value for sort_area_size or hash_area_size and 
hash_multiblock_io_count will cause the CBO to favour hash joins.
Finally, you can experiment with optimizer_index_cost_adj and 
optimizer_index_caching. Read Tim Gorman's paper 'The Search for 
Intelligent Life in the Cost-Based Optimizer" (www.evdbt.com).

At 03:34 PM 9/10/2003 -0800, you wrote:

Hi list,

I had two schemas in the same BD with the same data
 FBDI WITH STATISTICS
 FBDIN NO STATISTICS
The one without statistics run in less than 4 minutes
The one with statistics run in like 30 minutes
Any Help would be very, very appreciated as always.

I already bought the book from Gaja and Kirti, by recommendation of Madlen 
and Stephane, but hasn't arrived to my country yet, Dominican Republic, 
and need to improve this process ASAP.

Applied the EVENT TRACE 10046 and this is the result of the schema with 
stats (FBDI).

 

SELECT B.MATHOPERATOR,B.MAPACCOUNTLOCAL,A.PRINTORDER,B.SEQUENCE
FROM
 TEQUIVACCOUNT A,TEQUIVACCOUNTDETAIL B  WHERE A.REPORTCODE = B.REPORTCODE
  AND A.CODE = B.CODE  AND A.REPORTCODE = 'BDI01' ORDER BY A.PRINTORDER,
  B.SEQUENCE
call count   cpuelapsed   disk  querycurrent 
 rows
--- --   -- -- -- 
--  --
Parse1  0.04   0.09  9187  0 
0
Execute  1  0.00   0.00  0  0  0 
0
Fetch 5658  0.57   0.70154152  8 
 5657
--- --   -- -- -- 
--  --
total 5660  0.61   0.79163339  8 
 5657

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20  (FBDI)
Rows Row Source Operation
---  ---
   5657  SORT ORDER BY
   5657   HASH JOIN
 46TABLE ACCESS FULL TEQUIVACCOUNT
   5657TABLE ACCESS FULL TEQUIVACCOUNTDETAIL
Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: CHOOSE
   5657   SORT (ORDER BY)
   5657HASH JOIN
 46 TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'TEQUIVACCOUNT'
   5657 TABLE ACCESS   GOAL: ANALYZED (FULL) OF
'TEQUIVACCOUNTDETAIL'
 

SELECT MAX(A.ACM_FECACUM),NVL(A.ACM_ACUMDBANT,0) - NVL(A.ACM_ACUMCRANT,0)  +
  NVL(A.ACM_ACUMDB,0)  - NVL(A.ACM_ACUMCR,0)
FROM
 TCON_ACUM A,(SELECT ACM_OFICINA,ACM_MONEDA,NVL(MAX(TRUNC(ACM_FECACUM)),
  TO_DATE('2001/01/01','/MM/DD')) MAXFECACUM   FROM TCON_ACUM  WHERE
  ACM_CODIGO = :b1  AND ACM_SUCURSAL = :b2  GROUP BY 
ACM_OFICINA,ACM_MONEDA )
  T  WHERE A.ACM_CODIGO = :b1  AND A.ACM_SUCURSAL = :b2  AND T.ACM_OFICINA =
  A.ACM_OFICINA  AND T.ACM_MONEDA = A.ACM_MONEDA  AND TRUNC(A.ACM_FECACUM) =
  T.MAXFECACUM  GROUP BY NVL(A.ACM_ACUMDBANT,0),NVL(A.ACM_ACUMCRANT,0),
  NVL(A.ACM_ACUMDB,0),NVL(A.ACM_ACUMCR,0)

call count   cpuelapsed   disk  querycurrent 
 rows
--- --   -- -- -- 
--  --
Parse1  0.01   0.03  1  3  0 
0
Execute  16971  7.95   9.13  0  0  0 
0
Fetch16971  2.18   2.58113  62981  0 
 5770
--- --   -- -- -- 
--  --
total33943 10.14  11.74114  62984  0 
 5770

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20  (FBDI)   (recursive depth: 1)
Rows Row Source Operation
---  ---
   5849  SORT GROUP BY
   5849   NESTED LOOPS
  22820VIEW
  22820 SORT GROUP BY
   8688  TABLE ACCESS BY INDEX ROWID TCON_ACUM
  25659   INDEX RANGE SCAN (object id 4345)
   5849TABLE ACCESS BY INDEX ROWID TCON_ACUM
  14537 INDEX RANGE SCAN (object id 4345)
Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: CHOOSE
   5849   SORT (GROUP BY)
   5849NESTED LOOPS
  22820  

RE: question about migrating to 9i

[Faan DeSwardt]

Dennis and Rafiq,

When you use the dbca you are prompted for this option at the end i.e. create
scripts or create the DB.  I HIGHLY recommend you go with the 'create script'
option as this allows you to QA the Oracle "Intelligence" before kicking it off.
It also serves as a good tutorial on what is involved in creating a Oracle DB
without studying the interesting Oracle docs...;-)

-f

-Original Message-
Sent: Wednesday, September 10, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L


Dennis,


There is an option to just create a script for you based on your critaria 
and then you can modify it according to your requirement before creating the 
database. I think I used this almost 1 year back so don't remember exactly 
at what stage it ask for this option...

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 09 Sep 2003 17:49:27 -0800

Ryan
dbca is indeed available with Solaris. I used it today in fact. What 
I've
learned about it is:
   - It runs in X-Windows. I don't have much expertise with X-Windows, but 
it
seems to run fine from the Solaris console.
   - Unable to create a block size greater than 8k, at least what I've 
found.
I believe the reason is that dbca doesn't "create" the data files, but has
precreated files it just copies into place. That's my theory anyway.
   - All data files are created with autoextend on. But you can change that
later.
   - The database is created with spfile which I don't like but it is easy
enough to CREATE PFILE FROM SPFILE.
   - I am usually a skeptic of GUI tools, but I am really impressed with 
this
tool.
One alternative you could suggest to your production people is for them to
use dbca on a test system to create a database close to the one you want.
Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great
script (two versions in one, actually) that you can review, edit, etc. This
is an easy way to implement the 9i features you list without studying the
manual for the syntax  for each feature.
   Good luck, we production DBAs can be a touchy lot.

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


-Original Message-
Sent: Tuesday, September 09, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L


they are doing it by hand i believe. no dbca. its a solaris system. dont
think there is a dbca for solaris? Im not a production dba, so i dont know
for certain,.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 6:14 PM


 > Ryan
 > If you (or whoever) is using dbca, I believe all this is configured
 > automatically. But watch the block size. That is the only thing you can't
 > change later.
 >
 >
 >
 > Dennis Williams
 > DBA, 80%OCP, 100% DBA
 > Lifetouch, Inc.
 > [EMAIL PROTECTED]
 >
 > -Original Message-
 > Sent: Tuesday, September 09, 2003 4:59 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > Im not going to physically do the migration, but I want to make sure
certain
 > features are set up. Let me know if Im missing any of the basics(anything
 > that is a pain to add on my own later).
 >
 > Locally Managed tablespaces are the default right?
 > Automatic Segment Allocation
 > Undo Tablespace
 > SPFILE
 >
 > any other goodies Im forgetting? Just basic settings. rest I can do
myself.
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.net
 > --
 > Author: DENNIS WILLIAMS
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 > San Diego, California-- Mailing list and web hosting services
 > -
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of mailing list you want to be removed from).  You may
 > also send the HELP command for other information (like subscribing).

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

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

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

Re: 9.2.0.4 anyone

[Jared . Still]

Yeah, been out for some time now actually.







[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 09/10/2003 04:25 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: 9.2.0.4 anyone



What?   9.2.0.4 is out now?

RWB


Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



                                                                                                                 
                    [EMAIL PROTECTED]                                                                               
                    com                  To:     [EMAIL PROTECTED]                                            
                    Sent by:             cc:                                                                     
                    [EMAIL PROTECTED]       Subject:     9.2.0.4 anyone                                             
                    ity.com                                                                                      
                                                                                                                 
                                                                                                                 
                    09/10/2003                                                                                   
                    05:24 PM                                                                                     
                    Please respond                                                                               
                    to ORACLE-L                                                                                  
                                                                                                                 
                                                                                                                 




Anyone have any negative experiences with 9.2.0.4 yet?

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

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



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

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

Re: Missing a datafile

[Jared . Still]

Nice solution!







"Tanel Poder" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/10/2003 10:19 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Missing a datafile


Hi!

Yes, if you know where your file is.
Use "alter database create datafile as" syntax as seen below:

SQL> alter database backup controlfile to trace;

Database altered.

SQL> alter tablespace users add datafile
'C:\Oracle\Oradata\ORCL\USERS02.DBF' size 1m autoextend off;

Tablespace altered.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  160505408 bytes
Fixed Size                   454208 bytes
Variable Size             109051904 bytes
Database Buffers           50331648 bytes
Redo Buffers                 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
  2  --  SET STANDBY TO MAXIMIZE PERFORMANCE
  3      MAXLOGFILES 32
  4      MAXLOGMEMBERS 3
  5      MAXDATAFILES 100
  6      MAXINSTANCES 1
  7      MAXLOGHISTORY 226
  8  LOGFILE
  9    GROUP 1 'C:\ORACLE\ORADATA\ORCL\REDO01.RDO'  SIZE 20M,
 10    GROUP 2 'C:\ORACLE\ORADATA\ORCL\REDO02.RDO'  SIZE 20M,
 11    GROUP 3 'C:\ORACLE\ORADATA\ORCL\REDO03.RDO'  SIZE 20M,
 12    GROUP 4 'C:\ORACLE\ORADATA\ORCL\REDO04.RDO'  SIZE 20M
 13  -- STANDBY LOGFILE
 14  DATAFILE
 15    'C:\ORACLE\ORADATA\ORCL\SYSTEM_01.DBF',
 16    'C:\ORACLE\ORADATA\ORCL\UNDOTBS1_01.DBF',
 17    'C:\ORACLE\ORADATA\ORCL\CWMLITE_01.DBF',
 18    'C:\ORACLE\ORADATA\ORCL\DRSYS_01.DBF',
 19    'C:\ORACLE\ORADATA\ORCL\EXAMPLE_01.DBF',
 20    'C:\ORACLE\ORADATA\ORCL\INDX_01.DBF',
 21    'C:\ORACLE\ORADATA\ORCL\ODM_01.DBF',
 22    'C:\ORACLE\ORADATA\ORCL\TOOLS_01.DBF',
 23    'C:\ORACLE\ORADATA\ORCL\USERS_01.DBF',
 24    'C:\ORACLE\ORADATA\ORCL\XDB_01.DBF'
 25  CHARACTER SET UTF8
 26  ;

Control file created.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM_01.DBF'


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to controlfile by media recovery
ORA-01110: data file 11: 'C:\ORACLE\ORADATA\ORCL\USERS02.DBF'


SQL> select name from v$datafile;

NAME

-
C:\ORACLE\ORADATA\ORCL\SYSTEM_01.DBF
C:\ORACLE\ORADATA\ORCL\UNDOTBS1_01.DBF
C:\ORACLE\ORADATA\ORCL\CWMLITE_01.DBF
C:\ORACLE\ORADATA\ORCL\DRSYS_01.DBF
C:\ORACLE\ORADATA\ORCL\EXAMPLE_01.DBF
C:\ORACLE\ORADATA\ORCL\INDX_01.DBF
C:\ORACLE\ORADATA\ORCL\ODM_01.DBF
C:\ORACLE\ORADATA\ORCL\TOOLS_01.DBF
C:\ORACLE\ORADATA\ORCL\USERS_01.DBF
C:\ORACLE\ORADATA\ORCL\XDB_01.DBF
C:\ORACLE\ORA92\DATABASE\UNNAMED00011

11 rows selected.

SQL> alter database create datafile 'C:\ORACLE\ORA92\DATABASE\UNNAMED00011'
as 'C:\ORACLE\ORADATA\ORCL\USERS02.DBF';

Database altered.

SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL>

:)

Tanel.

Re: OMWB, MySQL plugin

[Joe Testa]

its alot easier going to oracle than going to mysql, this of mysql as 
oracle v6. :)

joe

Mladen Gogala wrote:

Did anyone do migration using OMWB?  Any comments or tips? I don't 
know anything about mysql
and I need to migrate some MySQL databases to oracle. Any last minute 
advice?
 
--
Mladen Gogala
Oracle DBA
 
** 
*Note:*
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any 
mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy 
any hard copies of it and notify the sender.  You must not, directly 
or indirectly, use, disclose, distribute, print, or copy any part of 
this message if you are not the intended recipient. *Wang Trading 
LLC *and any of its subsidiaries each reserve the right to monitor all 
e-mail communications through its networks.  Any views expressed in 
this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to 
be the views of any such entity.
 
 


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

Difference in Performance in two schemas in the same BD

[Ramon E. Estevez]

Title: Difference in Performance in two schemas in the same BD






Hi list,


I had two schemas in the same BD with the same data

 FBDI WITH STATISTICS 

 FBDIN NO STATISTICS 


The one without statistics run in less than 4 minutes

The one with statistics run in like 30 minutes 


Any Help would be very, very appreciated as always.


I already bought the book from Gaja and Kirti, by recommendation of Madlen and Stephane, but hasn't arrived to my country yet, Dominican Republic, and need to improve this process ASAP.

Applied the EVENT TRACE 10046 and this is the result of the schema with stats (FBDI).





SELECT B.MATHOPERATOR,B.MAPACCOUNTLOCAL,A.PRINTORDER,B.SEQUENCE   

FROM

 TEQUIVACCOUNT A,TEQUIVACCOUNTDETAIL B  WHERE A.REPORTCODE = B.REPORTCODE  

  AND A.CODE = B.CODE  AND A.REPORTCODE = 'BDI01' ORDER BY A.PRINTORDER,

  B.SEQUENCE



call count   cpu    elapsed   disk  query    current    rows

--- --   -- -- -- --  --

Parse    1  0.04   0.09  9    187  0   0

Execute  1  0.00   0.00  0  0  0   0

Fetch 5658  0.57   0.70    154    152  8    5657

--- --   -- -- -- --  --

total 5660  0.61   0.79    163    339  8    5657


Misses in library cache during parse: 1

Optimizer goal: CHOOSE

Parsing user id: 20  (FBDI)


Rows Row Source Operation

---  ---

   5657  SORT ORDER BY 

   5657   HASH JOIN 

 46    TABLE ACCESS FULL TEQUIVACCOUNT 

   5657    TABLE ACCESS FULL TEQUIVACCOUNTDETAIL 



Rows Execution Plan

---  ---

  0  SELECT STATEMENT   GOAL: CHOOSE

   5657   SORT (ORDER BY)

   5657    HASH JOIN

 46 TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'TEQUIVACCOUNT'

   5657 TABLE ACCESS   GOAL: ANALYZED (FULL) OF 

    'TEQUIVACCOUNTDETAIL'





SELECT MAX(A.ACM_FECACUM),NVL(A.ACM_ACUMDBANT,0) - NVL(A.ACM_ACUMCRANT,0)  + 

  NVL(A.ACM_ACUMDB,0)  - NVL(A.ACM_ACUMCR,0)    

FROM

 TCON_ACUM A,(SELECT ACM_OFICINA,ACM_MONEDA,NVL(MAX(TRUNC(ACM_FECACUM)),

  TO_DATE('2001/01/01','/MM/DD')) MAXFECACUM   FROM TCON_ACUM  WHERE 

  ACM_CODIGO = :b1  AND ACM_SUCURSAL = :b2  GROUP BY ACM_OFICINA,ACM_MONEDA ) 

  T  WHERE A.ACM_CODIGO = :b1  AND A.ACM_SUCURSAL = :b2  AND T.ACM_OFICINA = 

  A.ACM_OFICINA  AND T.ACM_MONEDA = A.ACM_MONEDA  AND TRUNC(A.ACM_FECACUM) = 

  T.MAXFECACUM  GROUP BY NVL(A.ACM_ACUMDBANT,0),NVL(A.ACM_ACUMCRANT,0),

  NVL(A.ACM_ACUMDB,0),NVL(A.ACM_ACUMCR,0)



call count   cpu    elapsed   disk  query    current    rows

--- --   -- -- -- --  --

Parse    1  0.01   0.03  1  3  0   0

Execute  16971  7.95   9.13  0  0  0   0

Fetch    16971  2.18   2.58    113  62981  0    5770

--- --   -- -- -- --  --

total    33943 10.14  11.74    114  62984  0    5770


Misses in library cache during parse: 1

Optimizer goal: CHOOSE

Parsing user id: 20  (FBDI)   (recursive depth: 1)


Rows Row Source Operation

---  ---

   5849  SORT GROUP BY 

   5849   NESTED LOOPS 

  22820    VIEW 

  22820 SORT GROUP BY 

   8688  TABLE ACCESS BY INDEX ROWID TCON_ACUM 

  25659   INDEX RANGE SCAN (object id 4345)

   5849    TABLE ACCESS BY INDEX ROWID TCON_ACUM 

  14537 INDEX RANGE SCAN (object id 4345)



Rows Execution Plan

---  ---

  0  SELECT STATEMENT   GOAL: CHOOSE

   5849   SORT (GROUP BY)

   5849    NESTED LOOPS

  22820 VIEW

  22820  SORT (GROUP BY)

   8688   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 

  'TCON_ACUM'

  25659    INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CP01CON_ACM' 

   (UNIQUE)

   5849 TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 

    'TCON_ACUM'

  14537  INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CP01CON_ACM' 

 (UNIQUE)





SELECT SUM(DECODE(T.TSA_TIPO,'D',NVL(T.TSA_VALOR,0))),SUM(DECODE(T.TSA_TIPO,

  'C',NVL(T.TSA_VALOR,0)))   

FROM

 TCON_TRANSA T,TCON_DESTRAN D  WHERE T.TSA_SUCURSAL = :b1  AND T.TSA_CUENTA = 

  :b2  AND D.DST_NUMTRAN = T.TSA_NUMTRAN  AND D.DST_SUCURSAL = T.TSA_SUCURSAL 

   AND D.DST_FECHA BETWE

Re: 9.2.0.4 anyone

[Reginald . W . Bailey]

What?   9.2.0.4 is out now?

RWB


Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
[EMAIL PROTECTED]  
 
com  To: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: 9.2.0.4 anyone
 
ity.com
  
   
  
   
  
09/10/2003 
  
05:24 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Anyone have any negative experiences with 9.2.0.4 yet?

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

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



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

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

Re: 9.2.0.4 anyone

[Tanel Poder]

Now that you speak about TOAD I remember that I get ORA-01460: unimplemented
or unreasonable conversion requested in Toads schema browser. But I'm not
using it much anyway, thus don't care...

Tanel.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 1:54 AM


> I can get TOAD to hang almost consistently, but that may be the RAC part
of
> 9.2.0.4 or my 9.2.0.1 client.  I also (still) have a fervent dislike of
the
> DBCA's mangling of given parameters -- even when it doesn't go off into
> la-la land (it hangs at "Initializing..." about 50% of the time).  Other
> than that, I haven't seen any bugs in the DB itself -- yet.  I've only
been
> testing data-wise this week.
>
> Rich
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
>
>
> > -Original Message-
> > From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, September 10, 2003 5:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 9.2.0.4 anyone
> >
> >
> > Anyone have any negative experiences with 9.2.0.4 yet?
> >
> > Robert
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

RE: 9.2.0.4 anyone

[Jesse, Rich]

I can get TOAD to hang almost consistently, but that may be the RAC part of
9.2.0.4 or my 9.2.0.1 client.  I also (still) have a fervent dislike of the
DBCA's mangling of given parameters -- even when it doesn't go off into
la-la land (it hangs at "Initializing..." about 50% of the time).  Other
than that, I haven't seen any bugs in the DB itself -- yet.  I've only been
testing data-wise this week.

Rich

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


> -Original Message-
> From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 5:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 9.2.0.4 anyone
> 
> 
> Anyone have any negative experiences with 9.2.0.4 yet?
> 
> Robert
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: Optimizing Oracle Performance

[Tanel Poder]

Title: Optimizing Oracle Performance



You can check the first chapter from 
here:
 
http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf
 
I read the chapter, I definitely want to read the 
others. Gonna get the book :)
 
Tanel.
 

  - Original Message - 
  From: 
  Pena, Carol A 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, September 11, 2003 12:59 
  AM
  Subject: Optimizing Oracle 
  Performance
  
  Cary, 
  Is your new O'Reilly book Optimizing Oracle 
  Performance out yet?  Do you have an estimated date? 
  a T d H v A a N n 
  K 
  c S e, 
  Carol A. Pena Men's Wearhouse voice:    713-592-7695 pager:  877-604-1952 

Re[4]: DB2 has a foot in the door

[Robert Eskridge]

"Hey, how come my butterfly ballot has a staple in it's navel!?!??"



M> Nope, that's what voting machines are invented for. 
M> They work almost perfectly in almost every state.

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

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

Re: index suppression and processing

[Stephane Faroult]

"Ehresmann, David" wrote:

> DELETE FROM TABLE_MESSAGES
> WHERE   field1 = lrec_icclaims_dtl (i).seq_id AND
>field2 = lrec_icclaims_dtl (i).seq_id AND
>type = 'E';
> 
> 
> The above code deletes processing messages from a table that may contain
> upwards of
> 1,000,000 rows or more. We have a situation where we are inserting 100,000
> rows per day into this table.  When the above code executes within a package
> the whole process basically slows to a stop.  With the code commented out
> the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
> NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
> fields when the code is executed and causing the process to slow down
> dramatically.  Without doing an explicit conversion with to_char (), because
> I believe this will suppress the indexes on field1 and field2, what can be
> done to make this efficient as possible?  Field1 is in 2 indexes and field2
> is in 1 index and type is not included in any indexes.  Does Oracle suppress
> the use of indexes when doing an implicit conversion? Can we force index use
> with this statement:
> 
> delete /*+ INDEX() */   from
> table_messages.
> 
> This is the first time we have seen this problem with this table.
> 
> thanks,
> 
> David Ehresmann
> 


David,

  Oracle does indeed suppress the use of indexes, or at least uses them
differently (must be careful with new versions - a full index scan might
not be affected by conversion) for the very simple reason that indexes
are trees, and that you descend a tree by doing comparisons. As you may
have noticed if you have ever numbered files and listed them, as it
happens '10' is smaller than '2' - lexicographic and numerical order are
different (no better with dates). Descending a tree built on comparisons
giving different results is impossible. A bit like searching a book by
title in a bookstore where shelves are ordered by author name.

 You should indeed do an explicit conversion of seq_id - no it won't
prevent the use of the indexes on field1 and field2, quite the contrary.
The problem you may have is with to_char() appending a space or
converting differently. I suggest you force you NLS numeric parameters
somewhere, to be sure you get nothing fanciful, and that you specify the
conversion mask. A ltrim(to_char()) may be handy to get rid of unwanted
left spaces.
 Since you seem to be keen on speed, perhaps you should also reconsider
the loop in which you are executing your delete. Have you thought about
doing a 

DELETE FROM TABLE_MESSAGES
WHERE field1 in (select ltrim(to_char())
 from ...
  where contions of death)
  AND field2 = field1
  AND type = 'E';

Don't tell me that you want intemediate commits. Size your undo
properly, and don't be shy. Likely to be much faster.

-- 
Regards,

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

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

Re: index suppression and processing

[Stephane Faroult]

"Ehresmann, David" wrote:

> DELETE FROM TABLE_MESSAGES
> WHERE   field1 = lrec_icclaims_dtl (i).seq_id AND
>field2 = lrec_icclaims_dtl (i).seq_id AND
>type = 'E';
> 
> 
> The above code deletes processing messages from a table that may contain
> upwards of
> 1,000,000 rows or more. We have a situation where we are inserting 100,000
> rows per day into this table.  When the above code executes within a package
> the whole process basically slows to a stop.  With the code commented out
> the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
> NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
> fields when the code is executed and causing the process to slow down
> dramatically.  Without doing an explicit conversion with to_char (), because
> I believe this will suppress the indexes on field1 and field2, what can be
> done to make this efficient as possible?  Field1 is in 2 indexes and field2
> is in 1 index and type is not included in any indexes.  Does Oracle suppress
> the use of indexes when doing an implicit conversion? Can we force index use
> with this statement:
> 
> delete /*+ INDEX() */   from
> table_messages.
> 
> This is the first time we have seen this problem with this table.
> 
> thanks,
> 
> David Ehresmann
> 


David,

  Oracle does indeed suppress the use of indexes, or at least uses them
differently (must be careful with new versions - a full index scan might
not be affected by conversion) for the very simple reason that indexes
are trees, and that you descend a tree by doing comparisons. As you may
have noticed if you have ever numbered files and listed them, as it
happens '10' is smaller than '2' - lexicographic and numerical order are
different (no better with dates). Descending a tree built on comparisons
giving different results is impossible. A bit like searching a book by
title in a bookstore where shelves are ordered by author name.

 You should indeed do an explicit conversion of seq_id - no it won't
prevent the use of the indexes on field1 and field2, quite the contrary.
The problem you may have is with to_char() appending a space or
converting differently. I suggest you force you NLS numeric parameters
somewhere, to be sure you get nothing fanciful, and that you specify the
conversion mask. A ltrim(to_char()) may be handy to get rid of unwanted
left spaces.
 Since you seem to be keen on speed, perhaps you should also reconsider
the loop in which you are executing your delete. Have you thought about
doing a 

DELETE FROM TABLE_MESSAGES
WHERE field1 in (select ltrim(to_char())
 from ...
  where contions of death)
  AND field2 = field1
  AND type = 'E';

Don't tell me that you want intemediate commits. Size your undo
properly, and don't be shy. Likely to be much faster.

-- 
Regards,

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

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

RE: RE: RE: DB2 has a foot in the door

[Mladen Gogala]

Nope, that's what voting machines are invented for. 
They work almost perfectly in almost every state.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Nuno Pinto do Souto
> Sent: Wednesday, September 10, 2003 6:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: RE: DB2 has a foot in the door
> 
> 
> > Boivin, Patrice J <[EMAIL PROTECTED]> wrote:
> > 
> > Something like that at the bottom of this article:
> > 
> > http://www.computerworld.com/news/2003/story/0,11280,84773,00.html
> > 
> 
> "Counting processors is very hard. It's very hard to count users"
> 
> I thought that's what count(*) was invented for?
> 
> Larry can truly be the Prime Minister of the Bleeding Obvious 
> when he wants...
> 
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Nuno Pinto do Souto
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

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

OMWB, MySQL plugin

[Mladen Gogala]

Title: Message



Did anyone do 
migration using OMWB?  Any comments or tips? I don't know anything about 
mysql
and I need to 
migrate some MySQL databases to oracle. Any last minute 
advice?
 
--Mladen GogalaOracle DBA 
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

Re: RE: RE: DB2 has a foot in the door

[Nuno Pinto do Souto]

> Boivin, Patrice J <[EMAIL PROTECTED]> wrote:
> 
> Something like that at the bottom of this article:
> 
> http://www.computerworld.com/news/2003/story/0,11280,84773,00.html
> 

"Counting processors is very hard. It's very hard to count users"

I thought that's what count(*) was invented for?

Larry can truly be the Prime Minister of the Bleeding Obvious
when he wants...

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

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

Re: index suppression and processing

[Wolfgang Breitling]

In my understanding of the English language, in this context "believe" is 
in the same category as "assume", meaning "I don't really know". That is 
not good enough to base optimization actions on. You would just be shooting 
in the dark and hope that by sheer luck you hit the target. Better to find 
out where Oracle spends the time when executing the query by turning on 
sql_trace, or polling v$session_wait while it is executing and then go 
after the cause.

At 12:59 PM 9/10/2003 -0800, you wrote:

DELETE FROM TABLE_MESSAGES
WHERE   field1 = lrec_icclaims_dtl (i).seq_id AND
field2 = lrec_icclaims_dtl (i).seq_id AND
type = 'E';
The above code deletes processing messages from a table that may contain
upwards of
1,000,000 rows or more. We have a situation where we are inserting 100,000
rows per day into this table.  When the above code executes within a package
the whole process basically slows to a stop.  With the code commented out
the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
fields when the code is executed and causing the process to slow down
dramatically.  Without doing an explicit conversion with to_char (), because
I believe this will suppress the indexes on field1 and field2, what can be
done to make this efficient as possible?  Field1 is in 2 indexes and field2
is in 1 index and type is not included in any indexes.  Does Oracle suppress
the use of indexes when doing an implicit conversion? Can we force index use
with this statement:
delete /*+ INDEX() */   from
table_messages.
This is the first time we have seen this problem with this table.

thanks,

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

9.2.0.4 anyone

[Freeman Robert - IL]

Anyone have any negative experiences with 9.2.0.4 yet?

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

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

Re: Oracle 11i

[M Rafiq]

Tanel,

A nice tip. Atleast can be set on test system for first run of upgrade.

Regards
Rafiq


Date: Wed, 10 Sep 2003 08:29:23 -0800

RE: Oracle 11iHeh-heh, imagine you're migrating from 10.7, where you have 
additional few tens of thousands AutoUpgrade scripts as well...

Btw, I have sometimes used the unsupported _wait_for_sync=false parameter to 
speed up commits when doing upgrades or extensive patching. You've probably 
looked into some of those 7 scripts and seen a lot of DDL (altering 
tables, adding comments etc..). And every DDL requires at least one commit, 
some even more. Thus if you see lots of log file sync waits for your 
AutoPatch sessions you could reduce database patching downtime noticeably 
using this parameter (the same goes for object recompilation). But as soon 
your instance crashes you should restore from backup, so this is the 
downside..
Actually, I'm not recommending anyone to use this parameter, just want to 
say, sometimes I have reduced Apps patching and upgrade downtime several to 
many hours using this ;)

Tanel.

  From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]

  Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying 
the
  unified driver to bring all of the products bang up to date.
  Just when you think you're on the home straight. A driver file with 
920,000
  lines that starts 71,000 scripts.

  It's enough to start me drinking!

  Mike

_

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

Optimizing Oracle Performance

[Pena, Carol A]

Title: Optimizing Oracle Performance






Cary, 


Is your new O'Reilly book Optimizing Oracle Performance out yet?  Do you have an estimated date? 



a T d H v A a N n K c S e,


Carol A. Pena

Men's Wearhouse

voice:    713-592-7695

pager:  877-604-1952

Re: index suppression and processing

[Reginald . W . Bailey]

Have you considered using  a function based index?

RWB


Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
David.Ehresman 
  
[EMAIL PROTECTED] To: [EMAIL PROTECTED]

Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: index suppression and 
processing   
ity.com
  
   
  
   
  
09/10/2003 
  
03:59 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  





DELETE FROM TABLE_MESSAGES
WHERE field1 = lrec_icclaims_dtl (i).seq_id AND
  field2 = lrec_icclaims_dtl (i).seq_id AND
  type = 'E';


The above code deletes processing messages from a table that may contain
upwards of
1,000,000 rows or more. We have a situation where we are inserting 100,000
rows per day into this table.  When the above code executes within a
package
the whole process basically slows to a stop.  With the code commented out
the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
fields when the code is executed and causing the process to slow down
dramatically.  Without doing an explicit conversion with to_char (),
because
I believe this will suppress the indexes on field1 and field2, what can be
done to make this efficient as possible?  Field1 is in 2 indexes and field2
is in 1 index and type is not included in any indexes.  Does Oracle
suppress
the use of indexes when doing an implicit conversion? Can we force index
use
with this statement:

delete /*+ INDEX() */   from
table_messages.

This is the first time we have seen this problem with this table.


thanks,

David Ehresmann

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

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



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

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

RE: making me crazy

[Jared . Still]

First off, if you don't actually have any requirements for the extproc stuff,
just remove it from the listener.ora file.

Second, if you do need it, it looks like the name of PROGRAM in listener.ora
may be wrong, or it just wasn't installed.  

Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 09/10/2003 01:24 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: making me crazy


Okay guys, 
I copied the listener.ora from one ORACLE_HOME to the other ORACLE_HOME - everything in the listener.ora is the same and still get the error "TNS-01201" 
TNS-01201: Listener cannot find executable /opt/oracle/product/9ias/v2/bin/extpr 
oc for SID PLSExtProc 
Even though both listeners have the ORACLE_HOME the same and hardcoded to: 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = /opt/oracle/product/9ias/902) 
      (PROGRAM = extproc) 
    ) 
    (SID_DESC = 
      (GLOBAL_DBNAME = iasdb.fully qualified host name) 
      (ORACLE_HOME = /opt/oracle/product/9ias/902) 
      (SID_NAME = iasdb) 
    ) 
  ) 

My question is : "With ORACLE_HOME hardcoded to /opt/oracle/product/9ias/902, why the heck is it complaining about not finding executable under /opt/oracle/product/9ias/v2/bin/extpr?"  According to NOTE:  1004700.6 setting the ORACLE_HOME path in the listener as above should handle this issue. 

-Original Message- 
Sent: Wednesday, September 10, 2003 12:20 PM 
To: Multiple recipients of list ORACLE-L 

The curious among us would like to know what kind of situation 
prevents you from correcting the listener.ora in the ORACLE_HOME 
that is running the listener. 

On Wed, 2003-09-10 at 07:44, [EMAIL PROTECTED] wrote: 
> Dealing with 2 Oracle Homes - one if which I need to run the listener from 
> and one in which I need to use the tnsnames.ora definitions from and no I 
> can't just copy the tnsnames.ora to the 1st Oracle Home.  Even when I set 
> the oracle home from which to run lsnrctl it tries to use the listener.ora 
> from the TNS_ADMIN home.  How can I make sure to explicitly start the 
> correct listener.ora? 
> 
> Thanks, 
> Paula 

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

RE: question about migrating to 9i

[M Rafiq]

Dennis,

There is an option to just create a script for you based on your critaria 
and then you can modify it according to your requirement before creating the 
database. I think I used this almost 1 year back so don't remember exactly 
at what stage it ask for this option...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 09 Sep 2003 17:49:27 -0800
Ryan
   dbca is indeed available with Solaris. I used it today in fact. What 
I've
learned about it is:
  - It runs in X-Windows. I don't have much expertise with X-Windows, but 
it
seems to run fine from the Solaris console.
  - Unable to create a block size greater than 8k, at least what I've 
found.
I believe the reason is that dbca doesn't "create" the data files, but has
precreated files it just copies into place. That's my theory anyway.
  - All data files are created with autoextend on. But you can change that
later.
  - The database is created with spfile which I don't like but it is easy
enough to CREATE PFILE FROM SPFILE.
  - I am usually a skeptic of GUI tools, but I am really impressed with 
this
tool.
One alternative you could suggest to your production people is for them to
use dbca on a test system to create a database close to the one you want.
Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great
script (two versions in one, actually) that you can review, edit, etc. This
is an easy way to implement the 9i features you list without studying the
manual for the syntax  for each feature.
  Good luck, we production DBAs can be a touchy lot.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 09, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
they are doing it by hand i believe. no dbca. its a solaris system. dont
think there is a dbca for solaris? Im not a production dba, so i dont know
for certain,.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 6:14 PM
> Ryan
> If you (or whoever) is using dbca, I believe all this is configured
> automatically. But watch the block size. That is the only thing you can't
> change later.
>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Tuesday, September 09, 2003 4:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Im not going to physically do the migration, but I want to make sure
certain
> features are set up. Let me know if Im missing any of the basics(anything
> that is a pain to add on my own later).
>
> Locally Managed tablespaces are the default right?
> Automatic Segment Allocation
> Undo Tablespace
> SPFILE
>
> any other goodies Im forgetting? Just basic settings. rest I can do
myself.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ryan
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
Send and receive larger attachments with Hotmail Extra Storage.   
http://join.msn.com/?PA

Re: index suppression and processing

[Ryan]

what types are your fields? you can solve this problem by doing a function
based index.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 4:59 PM


>
> DELETE FROM TABLE_MESSAGES
> WHERE field1 = lrec_icclaims_dtl (i).seq_id AND
> field2 = lrec_icclaims_dtl (i).seq_id AND
> type = 'E';
>
>
> The above code deletes processing messages from a table that may contain
> upwards of
> 1,000,000 rows or more. We have a situation where we are inserting 100,000
> rows per day into this table.  When the above code executes within a
package
> the whole process basically slows to a stop.  With the code commented out
> the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
> NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
> fields when the code is executed and causing the process to slow down
> dramatically.  Without doing an explicit conversion with to_char (),
because
> I believe this will suppress the indexes on field1 and field2, what can be
> done to make this efficient as possible?  Field1 is in 2 indexes and
field2
> is in 1 index and type is not included in any indexes.  Does Oracle
suppress
> the use of indexes when doing an implicit conversion? Can we force index
use
> with this statement:
>
> delete /*+ INDEX() */   from
> table_messages.
>
> This is the first time we have seen this problem with this table.
>
>
> thanks,
>
> David Ehresmann
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ehresmann, David
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

Oracle 9iAS form displays gray box

[Rick_Cale]

 Hi 







  NT 2000   
  Oracle 9.0.2.0.1  
  Oracle 9ias 9.0.2.0.1 

  Installed infrastructure and tested ok
  Installed middle tier and tested ok   

  When I was testing the forms services from demo tab to test running the   
  demo form 
  it shows form services installed successfully. When I hit ok it is trying 
  to load another   
  form but all I get is a gray box. 

  I also tried this on my local machine where I have 9i dev installed to
  test with another form and I get a gray box.  
  Jinitiator and OC4J listener are running on local to test 9i development  
  install   
  Any one have any suggestions. 



 Thanks 







Rick

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

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

RE: index suppression and processing

[Guang Mei]

Try

DELETE FROM TABLE_MESSAGES
WHERE   field1 = to_char(lrec_icclaims_dtl (i).seq_id)  AND
field2 = to_char(lrec_icclaims_dtl (i).seq_id)  AND
type = 'E';

and use explain plan to see if index is used.

HTH.

Guang

-Original Message-
Ehresmann, David
Sent: Wednesday, September 10, 2003 4:59 PM
To: Multiple recipients of list ORACLE-L



DELETE FROM TABLE_MESSAGES
WHERE   field1 = lrec_icclaims_dtl (i).seq_id AND
field2 = lrec_icclaims_dtl (i).seq_id AND
type = 'E';


The above code deletes processing messages from a table that may contain
upwards of
1,000,000 rows or more. We have a situation where we are inserting 100,000
rows per day into this table.  When the above code executes within a package
the whole process basically slows to a stop.  With the code commented out
the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
fields when the code is executed and causing the process to slow down
dramatically.  Without doing an explicit conversion with to_char (), because
I believe this will suppress the indexes on field1 and field2, what can be
done to make this efficient as possible?  Field1 is in 2 indexes and field2
is in 1 index and type is not included in any indexes.  Does Oracle suppress
the use of indexes when doing an implicit conversion? Can we force index use
with this statement:

delete /*+ INDEX() */   from
table_messages.

This is the first time we have seen this problem with this table.


thanks,

David Ehresmann

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

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

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

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

Re: Weird behavior with VARCHAR fields

[Tanel Poder]

Yep, and it's still there in 9.2.0.4
Of course you don't see it when you're non-sys user.
I once tried to create a view on top of this varchar 4096 column as user
sys, but Oracle had sorted it out in resulting view..

Tanel.
kzrtpdtx B)

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 10:39 PM


> Speaking of 'weird' character behaviour, how about
> this one:
>
> SQL> desc 
>  Name  Null?Type
>  -  --
>  ...
>  PREDICATE  VARCHAR2(4096)
>  ...
>
> Hmmm...that seems about 96 too many to me...
>
> Enjoy...
>
> Connor
>
>  --- Tanel Poder <[EMAIL PROTECTED]> wrote: >
> Hi!
> >
> > One more interesting issue with CHAR datatype is,
> > that it is not *always*
> > padded with spaces as sometimes understood. When the
> > CHAR field is NULL,
> > then no spaces are saved into row. But as soon as
> > you update even one single
> > char into it, the full CHAR length is used for this
> > field in a row.
> >
> > Tanel.
> >
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 10, 2003 5:49 PM
> >
> >
> > > Fermin,
> > >
> > > You are running into the well documented behavior
> > of the CHAR datatype.
> > Use
> > > VARCHAR2 instead if you wish to avoid those
> > pitfalls.
> > >
> > > Hope this helps...
> > >
> > > -Tim
> > >
> > > on 9/10/03 3:29 AM, Fermin Bernaus at
> > [EMAIL PROTECTED] wrote:
> > >
> > > >
> > > > Thank you all of you who answered to my first
> > question.
> > > >
> > > > No, the problem has nothing to do with
> > permissions. The record existed
> > in the
> > > > table, but here it is what I discovered. Can
> > anyone explain please? It
> > may be
> > > > the normal Oracle behavior, but I believe it was
> > not working like this
> > under
> > > > 7.3.4 (now we have 8.0.3). I can not confirm
> > though.
> > > >
> > > > TTDSLS805501 table definition is as follows:
> > > >
> > > > NameNull?Type
> > > > T$ORNONOT NULLNUMBER
> > > > T$USERNOT NULLCHAR(10)
> > > >
> > > > If I do an INSERT like the following:
> > > >
> > > > INSERT INTO TTDSLS805501 VALUES (151124 ,
> > 'exped9')
> > > >
> > > > The value 'exped9' for the field T$USER is 6
> > characters long, while the
> > > > definition has got 10. After the insertion, I
> > find that the field for
> > the new
> > > > record is 10 chars long, the last 4 characters
> > being filled with blanks.
> > > >
> > > > But here comes the weird behavior. If I
> > construct the 2 following SELECT
> > on
> > > > this table from SQLPlus, both work OK and return
> > the expected row:
> > > >
> > > > SELECT t$orno FROM TTDSLS805501 WHERE t$user =
> > 'exped9';-> 1
> > row
> > > returned
> > > > SELECT t$orno FROM TTDSLS805501 WHERE t$user =
> > 'exped9';-> 1
> > row
> > > > returned
> > > >
> > > > But within a stored procedure and using a local
> > variable the following
> > will
> > > > work OK:
> > > >
> > > > SELECT t$orno INTO eskaria FROM TTDSLS805501
> > WHERE t$user = my_var;
> > > >
> > > > where my_var is of type VARCHAR2 and has got the
> > value 'exped9'
> > > >
> > > > Whilst the following will come up with the
> > ORA-01403 error:
> > > >
> > > > SELECT t$orno INTO eskaria FROM TTDSLS805501
> > WHERE t$user = my_var;
> > > >
> > > > where my_var is of type VARCHAR2 and has got the
> > value 'exped9'
> > > >
> > > > Is this normal behavior? why does not the
> > "SELECT t$orno FROM
> > TTDSLS805501
> > > > WHERE t$user = 'exped9';" statement return 0
> > rows in the first place?
> > > >
> > > > Fermin.
> > > >
> > > >
> > > > -Mensaje original-
> > > > De: Tim Gorman [mailto:[EMAIL PROTECTED]
> > > > Enviado el: miércoles, 10 de septiembre de 2003
> > 10:44
> > > > Para: Multiple recipients of list ORACLE-L
> > > > Asunto: Re: ORA-01403 error, help!!!
> > > >
> > > >
> > > > Unless the stored procedure was created with
> > invoker's rights, then it
> > is
> > > > probably executing using the permissions and
> > schema of the account that
> > owns
> > > > it.  Who is the owner of the stored procedure?
> > Is it different from who
> > you
> > > > are logged into SQL*Plus as?
> > > >
> > > > The explanation might be that, through some
> > reason like synonyms
> > pointing in
> > > > different directions from the different
> > accounts, the name TTDSLS805501
> > > > might be resolving to different tables
> > altogether...
> > > >
> > > >
> > > >
> > > > on 9/9/03 10:09 AM, Fermin Bernaus at
> > [EMAIL PROTECTED] wrote:
> > > >
> > > >>
> > > >> If logged in SQL Plus the following SQL returns
> > just one row:
> > > >>
> > > >> SELECT t$orno FROM ttdsls805501 WHERE t$user =
> > 'exped9' GROUP BY
> > t$orno;
> > > >>
> > > >> If I do use the same SELECT statement inside a
> > stored procedure and
> > have the
> > > >> returning value stored in a local varia

index suppression and processing

[Ehresmann, David]

DELETE FROM TABLE_MESSAGES
WHERE   field1 = lrec_icclaims_dtl (i).seq_id AND
field2 = lrec_icclaims_dtl (i).seq_id AND
type = 'E';


The above code deletes processing messages from a table that may contain
upwards of 
1,000,000 rows or more. We have a situation where we are inserting 100,000
rows per day into this table.  When the above code executes within a package
the whole process basically slows to a stop.  With the code commented out
the process runs. Field1 and Field2 are VARCHAR2(30).  seq_id is a
NUMBER(9).  We believe that Oracle is doing an implicit conversion of the
fields when the code is executed and causing the process to slow down
dramatically.  Without doing an explicit conversion with to_char (), because
I believe this will suppress the indexes on field1 and field2, what can be
done to make this efficient as possible?  Field1 is in 2 indexes and field2
is in 1 index and type is not included in any indexes.  Does Oracle suppress
the use of indexes when doing an implicit conversion? Can we force index use
with this statement:
 
delete /*+ INDEX() */   from
table_messages.
 
This is the first time we have seen this problem with this table.


thanks,

David Ehresmann

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

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

Re: Problem with mutating trigger

[Gary Jackson]

Apparently there was a foreign key enabled between order_master & 
order_master_sts_log. Disabling this allowed the trigger to fire 
successfully.
Out of curiosity, why does the foreign key prevent the trigger from 
successfully firing?
Thanks for your help!
-Fred



From: raju pa <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Problem with mutating trigger
Date: Wed, 10 Sep 2003 12:24:26 -0800
Did you check if there are any triggers on  table order_master_sts_log? Are 
there any foreign keys that might lead back to 'select lookup' the initial 
table order_master

Good luck.

Gary Jackson <[EMAIL PROTECTED]> wrote:
Hello,
I have a moderate size 8.0.4 database that has been running perfectly for
years. I took an export of the structure only of this database and imported
it onto another server also running 8.0.4. I then inserted only a few rows
into key tables. This is now serving as a testing database for my
developers.
However a problem is showing up:
When inserting into a table, I get a mutating trigger error that does not
occur on the moderate size database. What could be causing this trigger
error on the small database when it works perfectly on the large database?
(I verified that all code of the trigger, all constraints, and all table
structures involved are identical).
It seems to be a fairly simple trigger:

CREATE OR REPLACE TRIGGER "BOSS".order_master_tau
AFTER UPDATE OF ord_mas_sts_cd ON order_master
FOR EACH ROW
BEGIN
IF
:old.ord_mas_sts_cd <> :new.ord_mas_sts_cd
THEN
INSERT INTO order_master_sts_log
( ord_id, ord_sub_id, ord_sts_cd, ord_sts_dt, ord_sts_nt )
VALUES
( :old.ord_id,:old.ord_sub_id, :old.ord_mas_sts_cd,
:old.ord_mas_sts_dt,
:old.ord_mas_sts_nt );
END IF;
END;
Any input greatly appreciated,
-Fred Smith
_
Try MSN Messenger 6.0 with integrated webcam functionality!
http://www.msnmessenger-download.com/tracking/reach_webcam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Jackson
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
_
Try MSN Messenger 6.0 with integrated webcam functionality! 
http://www.msnmessenger-download.com/tracking/reach_webcam

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

Re: imp with dd pipe

[M Rafiq]

Why don't you send it to tape directly by defining file=/dev/dev_name 
instead of using pipe and dd to tape and likewise importing from there. I 
have been doing in the past for changing blocksize of database.

Regards
Rafiq

RE: making me crazy

[Paula_Stankus]

Title: RE: making me crazy





Think I found solution:


Not only do you have to use fully qualified path in the sid_list - but also in the program statement of the listener.ora

geez.  What complicates it is under the same error:  TNS-01201 - there are multiple notes, problems solutions.


Sorry guys.


-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: making me crazy



The curious among us would like to know what kind of situation
prevents you from correcting the listener.ora in the ORACLE_HOME
that is running the listener.



On Wed, 2003-09-10 at 07:44, [EMAIL PROTECTED] wrote:
> Dealing with 2 Oracle Homes - one if which I need to run the listener from
> and one in which I need to use the tnsnames.ora definitions from and no I
> can't just copy the tnsnames.ora to the 1st Oracle Home.  Even when I set
> the oracle home from which to run lsnrctl it tries to use the listener.ora
> from the TNS_ADMIN home.  How can I make sure to explicitly start the
> correct listener.ora?
> 
> Thanks,
> Paula



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


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

RE: making me crazy

[Paula_Stankus]

Title: RE: making me crazy





Okay guys,


I copied the listener.ora from one ORACLE_HOME to the other ORACLE_HOME - everything in the listener.ora is the same and still get the error "TNS-01201" 

TNS-01201: Listener cannot find executable /opt/oracle/product/9ias/v2/bin/extpr
oc for SID PLSExtProc


Even though both listeners have the ORACLE_HOME the same and hardcoded to:


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/9ias/902)
  (PROGRAM = extproc)
    )
    (SID_DESC =
  (GLOBAL_DBNAME = iasdb.fully qualified host name)
  (ORACLE_HOME = /opt/oracle/product/9ias/902)
  (SID_NAME = iasdb)
    )
  )



My question is : "With ORACLE_HOME hardcoded to /opt/oracle/product/9ias/902, why the heck is it complaining about not finding executable under /opt/oracle/product/9ias/v2/bin/extpr?"  According to NOTE:  1004700.6 setting the ORACLE_HOME path in the listener as above should handle this issue. 


-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: making me crazy



The curious among us would like to know what kind of situation
prevents you from correcting the listener.ora in the ORACLE_HOME
that is running the listener.



On Wed, 2003-09-10 at 07:44, [EMAIL PROTECTED] wrote:
> Dealing with 2 Oracle Homes - one if which I need to run the listener from
> and one in which I need to use the tnsnames.ora definitions from and no I
> can't just copy the tnsnames.ora to the 1st Oracle Home.  Even when I set
> the oracle home from which to run lsnrctl it tries to use the listener.ora
> from the TNS_ADMIN home.  How can I make sure to explicitly start the
> correct listener.ora?
> 
> Thanks,
> Paula



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


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

Re: Problem with mutating trigger

[raju pa]

Did you check if there are any triggers on  table order_master_sts_log? Are there any foreign keys that might lead back to 'select lookup' the initial table order_master
Good luck.Gary Jackson <[EMAIL PROTECTED]> wrote:
Hello,I have a moderate size 8.0.4 database that has been running perfectly for years. I took an export of the structure only of this database and imported it onto another server also running 8.0.4. I then inserted only a few rows into key tables. This is now serving as a testing database for my developers.However a problem is showing up:When inserting into a table, I get a mutating trigger error that does not occur on the moderate size database. What could be causing this trigger error on the small database when it works perfectly on the large database? (I verified that all code of the trigger, all constraints, and all table structures involved are identical).It seems to be a fairly simple trigger:CREATE OR REPLACE TRIGGER "BOSS".order_master_tauAFTER UPDATE OF ord_mas_sts_cd ON order_masterFOR EACH
 ROWBEGINIF:old.ord_mas_sts_cd <> :new.ord_mas_sts_cdTHENINSERT INTO order_master_sts_log( ord_id, ord_sub_id, ord_sts_cd, ord_sts_dt, ord_sts_nt )VALUES( :old.ord_id,:old.ord_sub_id, :old.ord_mas_sts_cd, :old.ord_mas_sts_dt,:old.ord_mas_sts_nt );END IF;END;Any input greatly appreciated,-Fred Smith_Try MSN Messenger 6.0 with integrated webcam functionality! http://www.msnmessenger-download.com/tracking/reach_webcam-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Gary JacksonINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto:
 [EMAIL PROTECTED] (note EXACT 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! SiteBuilder - Free, easy-to-use web site design software

RE: Oracle 9i and DB2 8.1 comparison article

[Mladen Gogala]

Title: Message



Let me quote the conclusion of the article:
ConclusionIt is not true that Oracle 9i 
Database is better than DB2 Universal Database v8.1or vice versa. Both products 
can be used to build stable and efficient systemsand the stability and 
effectiveness of your applications and databases depend rather upon the 
experience of the database developers and database administratorthan the 
database's provider.
This is feature by feature comparison, made by using marketing 
materials from both companies as  the main source. The purpose of this 
comparison is quite
unclear to me. It underlines the differences in the approach 
between marketing teams from IBM and Oracle and will not be helpful to magazine 
reading 
damagement in deciding what database to buy. Marketing materials 
are, as expected, grossly inaccurate, so in comparison with SQL Server there is 
statement that maximum row size for SQL Server is 8036 characters, which would 
render it completely useless, while the maximum row size for Oracle9i was set 
to  255000 
which would directly 
contradict to the existence of LONG columns, which as we all 
know, can go to 2GB. Author, nevertheless, puts this information in the 
"comparison".
The conclusion is the same at the bottom of all 3 comparisons 
and that is that it's not true that one database is better then another, which 
is 
obviously not true.  What is more, open source alternatives 
like Postgres and MySQL were left out of  the comparison and they are 
rapidly gaining ground,
especially Postgres, which supports transactions and can use 
perl as it's internal scripting language.
 --Mladen GogalaOracle DBA> -Original 
Message-> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On> Behalf 
Of Boivin, Patrice J> Sent: Wednesday, September 10, 2003 12:05 
PM> To: Multiple recipients of list ORACLE-L> Subject: Oracle 9i 
and DB2 8.1 comparison article>>> http://www.databasejournal.com/features/oracle/article.php/3075071>> Patrice.> --> Please see the official ORACLE-L 
FAQ: http://www.orafaq.net> --> Author: 
Boivin, Patrice J>   INET: 
[EMAIL PROTECTED]>> Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.com> San Diego, 
California    -- Mailing list and web 
hosting services> 
-> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')> and in the 
message BODY, include a line containing: UNSUB> ORACLE-L (or the name of 
mailing list you want to be removed> from).  You may also send the 
HELP command for other> information (like subscribing).> 

 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

Re: Weird behavior with VARCHAR fields

[Connor McDonald]

Speaking of 'weird' character behaviour, how about
this one:

SQL> desc 
 Name  Null?Type
 -  --
 ...
 PREDICATE  VARCHAR2(4096)
 ...

Hmmm...that seems about 96 too many to me...

Enjoy...

Connor

 --- Tanel Poder <[EMAIL PROTECTED]> wrote: >
Hi!
> 
> One more interesting issue with CHAR datatype is,
> that it is not *always*
> padded with spaces as sometimes understood. When the
> CHAR field is NULL,
> then no spaces are saved into row. But as soon as
> you update even one single
> char into it, the full CHAR length is used for this
> field in a row.
> 
> Tanel.
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, September 10, 2003 5:49 PM
> 
> 
> > Fermin,
> >
> > You are running into the well documented behavior
> of the CHAR datatype.
> Use
> > VARCHAR2 instead if you wish to avoid those
> pitfalls.
> >
> > Hope this helps...
> >
> > -Tim
> >
> > on 9/10/03 3:29 AM, Fermin Bernaus at
> [EMAIL PROTECTED] wrote:
> >
> > >
> > > Thank you all of you who answered to my first
> question.
> > >
> > > No, the problem has nothing to do with
> permissions. The record existed
> in the
> > > table, but here it is what I discovered. Can
> anyone explain please? It
> may be
> > > the normal Oracle behavior, but I believe it was
> not working like this
> under
> > > 7.3.4 (now we have 8.0.3). I can not confirm
> though.
> > >
> > > TTDSLS805501 table definition is as follows:
> > >
> > > NameNull?Type
> > > T$ORNONOT NULLNUMBER
> > > T$USERNOT NULLCHAR(10)
> > >
> > > If I do an INSERT like the following:
> > >
> > > INSERT INTO TTDSLS805501 VALUES (151124 ,
> 'exped9')
> > >
> > > The value 'exped9' for the field T$USER is 6
> characters long, while the
> > > definition has got 10. After the insertion, I
> find that the field for
> the new
> > > record is 10 chars long, the last 4 characters
> being filled with blanks.
> > >
> > > But here comes the weird behavior. If I
> construct the 2 following SELECT
> on
> > > this table from SQLPlus, both work OK and return
> the expected row:
> > >
> > > SELECT t$orno FROM TTDSLS805501 WHERE t$user =
> 'exped9';-> 1
> row
> > returned
> > > SELECT t$orno FROM TTDSLS805501 WHERE t$user =
> 'exped9';-> 1
> row
> > > returned
> > >
> > > But within a stored procedure and using a local
> variable the following
> will
> > > work OK:
> > >
> > > SELECT t$orno INTO eskaria FROM TTDSLS805501
> WHERE t$user = my_var;
> > >
> > > where my_var is of type VARCHAR2 and has got the
> value 'exped9'
> > >
> > > Whilst the following will come up with the
> ORA-01403 error:
> > >
> > > SELECT t$orno INTO eskaria FROM TTDSLS805501
> WHERE t$user = my_var;
> > >
> > > where my_var is of type VARCHAR2 and has got the
> value 'exped9'
> > >
> > > Is this normal behavior? why does not the
> "SELECT t$orno FROM
> TTDSLS805501
> > > WHERE t$user = 'exped9';" statement return 0
> rows in the first place?
> > >
> > > Fermin.
> > >
> > >
> > > -Mensaje original-
> > > De: Tim Gorman [mailto:[EMAIL PROTECTED]
> > > Enviado el: miércoles, 10 de septiembre de 2003
> 10:44
> > > Para: Multiple recipients of list ORACLE-L
> > > Asunto: Re: ORA-01403 error, help!!!
> > >
> > >
> > > Unless the stored procedure was created with
> invoker's rights, then it
> is
> > > probably executing using the permissions and
> schema of the account that
> owns
> > > it.  Who is the owner of the stored procedure? 
> Is it different from who
> you
> > > are logged into SQL*Plus as?
> > >
> > > The explanation might be that, through some
> reason like synonyms
> pointing in
> > > different directions from the different
> accounts, the name TTDSLS805501
> > > might be resolving to different tables
> altogether...
> > >
> > >
> > >
> > > on 9/9/03 10:09 AM, Fermin Bernaus at
> [EMAIL PROTECTED] wrote:
> > >
> > >>
> > >> If logged in SQL Plus the following SQL returns
> just one row:
> > >>
> > >> SELECT t$orno FROM ttdsls805501 WHERE t$user =
> 'exped9' GROUP BY
> t$orno;
> > >>
> > >> If I do use the same SELECT statement inside a
> stored procedure and
> have the
> > >> returning value stored in a local variable:
> > >>
> > >> SELECT t$orno INTO eskaria FROM ttdsls805501
> WHERE t$user = 'exped9'
> GROUP BY
> > >> t$orno;
> > >>
> > >> where eskaria has been declared as:
> > >>
> > >> eskaria ttdsls805501.t$orno%TYPE;
> > >>
> > >> I get ORA-01403. I have no clue why I am
> getting this error, can you
> help
> > >> please?
> > >>
> > >> Many thanks!
> > >>
> > >> .
> > >> Fermín Bernaus Berraondo
> > >> Dpto. de Informática
> > >> SAMMIC, S.A.
> > >> [EMAIL PROTECTED]
> > >> http://www.sammic.com
> > >> Telf. +34 - 943 157 331
> > >> Fax +34 - 943 151 276
> > >> .
> >
> > -- 
> > Please see the official ORACLE-L FAQ:
> http

RE: RE: DB2 has a foot in the door

[Stephane Paquette]

I'm interested in the report also.


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 



-Original Message-
Goulet, Dick
Sent: Wednesday, September 10, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Do you have the source of this report???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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


The following may be pertinent to the current discussion of Oracle pricing
models.

Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time

SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that allows businesses to
use as much software as they want, Oracle Corp.'s chairman and chief
executive officer Larry Ellison said Tuesday.

"It becomes very hard to count processors and to count users," Ellison said,
responding to a question on the future of software pricing at the
OracleWorld show. "Where I think we'll go is towards enterprise licensing.
... You pay an annual recurring fee and use as much software as you want,
and I think that's a much more sensible model to use."   In News

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


For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 10:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: DB2 has a foot in the door
>
>
> is SE alot more affordable than EE? CAn you un-bundle Oracle
> software and just buy the pieces you want to use or do you
> always have to buy the whole bundle?
>
> what about 9iAS? do you have to buy the whole bundle or can
> you just get pieces?
> >
> > From: "Hitchman, Peter" <[EMAIL PROTECTED]>
> > Date: 2003/09/10 Wed AM 09:54:35 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: DB2 has a foot in the door
> >
> > Hi,
> > I looked into SE but found that Oracle would not allow it
> to be used
> > on a machine that has 4 or more CPUs or can support that many CPUs,
> > which for this company is a problem because we generally
> run Oracle on
> > Sun servers. Don't know if that has changed now with later Oracle
> > releases.
> >
> > Regards
> >
> > Pete
> >
> > -Original Message-
> > Sent: 10 September 2003 13:21
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > When negotiating site licensing, does Oracle encourage the
> customers
> > to buy EE licences?
> >
> > Or can people negotiate for a mix of EE or SE.
> >
> > Just curious, I don't know how that would work -- not very
> compatible
> > with OracleStore, it seems to me.
> >
> > Patrice.
> >
> > -Original Message-
> > Sent: Wednesday, September 10, 2003 5:59 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > We also has site licensing.
> > It was done 3-4 years ago. Maybe Oracle changed tactics since then.
> >
> > Yechiel Adar
> > Mehish
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from).  You may
> also send
> > the HELP command for other information (like subscribing).
> >
> > __
> >
> > The information contained in this email is confidential and
> > intended only for the use of the individual or entity named
> > above. If the reader of this message is not the intended
> > recipient, you are hereby notified that any dissemination,
> > distribution, or copying of this communication is strictly
> > prohibited. Thomson Scientific will accept no responsibility
> > or liability in respect to this email other than to the addressee.
> > If you have received this communication in error, please
> > notify us immediately via email: [EMAIL PROTECTED]
> > __
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hitchman, Peter
> >   INET: [EMAIL PROTECTED]
> 

RE: how can I see which database I am logged into without v$instance and v$database

[Jacques Kilchoer]

> -Original Message-
> From: Olga Gurevich [mailto:[EMAIL PROTECTED]
> 
> I think there was a dbms package to get some of
> the environment variables for a session, but I can't
> remember anyhting specific. If someone know what I'm
> talking about and has any details, please Email me or
> post here


Oracle9i SQL Reference Release 2 (9.2)
Part Number A96540-01
Functions, 122 of 177: SYS_CONTEXT
...
Table 6-2  Predefined Parameters of Namespace USERENV
...
(parameter, return value, return length (bytes))
DB_DOMAIN
 Domain of the database as specified in the DB_DOMAIN initialization parameter. 256

DB_NAME
 Name of the database as specified in the DB_NAME initialization parameter. 30
...
HOST
 Name of the host machine from which the client has connected. 54

INSTANCE
 The instance identification number of the current instance. 30

e.g.

select
   sys_context ('userenv', 'db_domain') as db_domain,
   sys_context ('userenv', 'db_name') as db_name,
   sys_context ('userenv', 'host') as host,
   sys_context ('userenv', 'instance') as instance
 from dual ;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

Re: how can I see which database I am logged into without v$instance and v$database

[Tanel Poder]

Olga,

There are userenv and sys_context functions. Describe sys.standard package
to get more information. Or if you want to be really advanced, go and read
the documentation ;)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 9:49 PM
and v$database


> hi.
>
> I think there was a dbms package to get some of
> the environment variables for a session, but I can't
> remember anyhting specific. If someone know what I'm
> talking about and has any details, please Email me or
> post here
>
> thanks
>
> Gene
>
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Olga Gurevich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

Re: how can I see which database I am logged into without

[Wolfgang Breitling]

select sys_context('USERENV','DB_NAME') from ;

At 10:49 AM 9/10/2003 -0800, you wrote:
hi.

I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific. If someone know what I'm
talking about and has any details, please Email me or
post here
thanks

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

RE: how can I see which database I am logged into without v$insta

[Gorbounov,Vadim]

Olga, 

Does select * from global_name ; do the trick?


-Original Message-
Sent: Wednesday, September 10, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
v$instance and v$database


hi.

I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific. If someone know what I'm
talking about and has any details, please Email me or
post here

thanks

Gene

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Olga Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: what is a materialized view ?

[Vergara, Michael (TEM)]

Re:

> PS Personally I think that the discontinuation of paper manuals was a
> disaster. I used to take concepts manuals when I went in the bath. A great
> place to learn. No kids, no TV.

Absolutely!  I still have several of my old v6 and v7 manuals
just because of the little schnibbles of information I have
scribbled in the margins.  Much has changed, but not everything.

Just my 2¢ worth...

Mike
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

RE: RE: DB2 has a foot in the door

[Boivin, Patrice J]

Something like that at the bottom of this article:

http://www.computerworld.com/news/2003/story/0,11280,84773,00.html

Patrice.

-Original Message-
Sent: Wednesday, September 10, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Do you have the source of this report???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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


The following may be pertinent to the current discussion of Oracle pricing
models.

Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time

SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that allows businesses to
use as much software as they want, Oracle Corp.'s chairman and chief
executive officer Larry Ellison said Tuesday.

"It becomes very hard to count processors and to count users," Ellison said,
responding to a question on the future of software pricing at the
OracleWorld show. "Where I think we'll go is towards enterprise licensing.
.. You pay an annual recurring fee and use as much software as you want,
and I think that's a much more sensible model to use."   In News

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


For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 10:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: DB2 has a foot in the door
> 
> 
> is SE alot more affordable than EE? CAn you un-bundle Oracle 
> software and just buy the pieces you want to use or do you 
> always have to buy the whole bundle? 
> 
> what about 9iAS? do you have to buy the whole bundle or can 
> you just get pieces? 
> > 
> > From: "Hitchman, Peter" <[EMAIL PROTECTED]>
> > Date: 2003/09/10 Wed AM 09:54:35 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: DB2 has a foot in the door
> > 
> > Hi,
> > I looked into SE but found that Oracle would not allow it 
> to be used 
> > on a machine that has 4 or more CPUs or can support that many CPUs, 
> > which for this company is a problem because we generally 
> run Oracle on 
> > Sun servers. Don't know if that has changed now with later Oracle 
> > releases.
> > 
> > Regards
> > 
> > Pete
> > 
> > -Original Message-
> > Sent: 10 September 2003 13:21
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > When negotiating site licensing, does Oracle encourage the 
> customers 
> > to buy EE licences?
> > 
> > Or can people negotiate for a mix of EE or SE.
> > 
> > Just curious, I don't know how that would work -- not very 
> compatible 
> > with OracleStore, it seems to me.
> > 
> > Patrice.
> > 
> > -Original Message-
> > Sent: Wednesday, September 10, 2003 5:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > We also has site licensing.
> > It was done 3-4 years ago. Maybe Oracle changed tactics since then.
> > 
> > Yechiel Adar
> > Mehish
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> > 
> > __
> > 
> > The information contained in this email is confidential and
> > intended only for the use of the individual or entity named 
> > above. If the reader of this message is not the intended 
> > recipient, you are hereby notified that any dissemination, 
> > distribution, or copying of this communication is strictly 
> > prohibited. Thomson Scientific will accept no responsibility 
> > or liability in respect to this email other than to the addressee. 
> > If you have received this communication in error, please 
> > notify us immediately via email: [EMAIL PROTECTED]
> > __
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Hitchman, Peter
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcit

how can I see which database I am logged into without v$instance and v$database

[Olga Gurevich]

hi.

I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific. If someone know what I'm
talking about and has any details, please Email me or
post here

thanks

Gene

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Olga Gurevich
  INET: [EMAIL PROTECTED]

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

RE: what is a materialized view ?

[April Wells]

Title: RE: what is a materialized view ?





I have our print room print them double sided and glued binding.


It's just so hard to highlight and mark up a PDF


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: what is a materialized view ?



Consider this :
Research is the best way to discover and to remember information.
The acquisition of information increases a DBA's skill.
Skilled DBAs should (?!!) always be in demand.


Therefore, by encouraging people to read manuals you're helping to make me
unemployed.


Just something to consider   =)


Mike Hately


PS Personally I think that the discontinuation of paper manuals was a
disaster. I used to take concepts manuals when I went in the bath. A great
place to learn. No kids, no TV.


-Original Message-
Sent: 10 September 2003 13:54
To: Multiple recipients of list ORACLE-L



I have a problem with unwillingness to invest effort and do some very basic
research from the readily available literature. Oracle has a manual called
"Database Concepts" which is accessible on approximately 87 billion places 
on the internet, for free, of course. Previous incarnations of this list
(and I am
a long time member) were, in my opinion, rendered unusable by a flood of
trivial
questions. I do honestly believe that, in order to fully participate in this
list, 
a person must satisfy certain pre-requisites, knoledge-wise and
experience-wise. 
That is why I'm trying to discourage questions like the one above. My reply
was 
jovial and humorous, but the RTFM was dead serious.


--
Mladen Gogala
Oracle DBA 




> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On 
> Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI
> Sent: Wednesday, September 10, 2003 8:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: what is a materilized view ?
> 
> 
> ROFLMAO ... What a kidder ...
> 
> v/r
> 
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> [EMAIL PROTECTED]
> (813) 827-9974  DSN 651-9974
> 
> 
> 
> > -Original Message-
> > From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 10, 2003 7:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: what is a materilized view ?
> > 
> > 
> > That would be a question for Madonna, not for this list.
> > Read The Fine Manual.
> > 
> > On 2003.09.10 07:04, Veeraraju_Mareddi wrote:
> > > Dear Freinds,
> > > 
> > > what is a materilized view ? what is the use of it and how
> > to create
> > > it.
> > > 
> > > Any docs or notes or white papers will be helpful.
> > > 
> > > TIA,
> > > Rajuveera
> > > 
> > 
> **
> > > 
> > > This email (including any attachments) is intended for the
> > sole use of the
> > > intended recipient/s and may contain material that is
> > CONFIDENTIAL AND
> > > PRIVATE COMPANY INFORMATION. Any review or reliance by
> > others or copying or
> > > distribution or forwarding of any or all of the contents in
> > this message is
> > > STRICTLY PROHIBITED. If you are not the intended recipient,
> > please contact
> > > the sender by email and delete all copies; your cooperation
> > in this regard
> > > is appreciated.
> > > 
> > **
> > 
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Veeraraju_Mareddi
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services    -- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California    -- Mailing list and web 
> > hosting services
> > > 
> > 
> -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the 
> > > name of mailing list you want to be removed from).  You may 
> > also send
> > > the HELP command for other information (like subscribing).
> > >
> > 
> > --
> > Mladen Gogala
> > Oracle DBA
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> > San Diego, California    -- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the mes

RE: Does the 9iR2 Installer delete patch files?

[Jesse, Rich]

Yay!

"Five years ago, everybody *knew* that Oracle was the center of the
universe.  Two years ago, everyone *knew* OiD was the best thing since
sliced bread and fifteen minutes ago, you *knew* that OUI could do no wrong.
Imagine what you'll know tomorrow."

(with apologies to Barry Sonnenfeld)

Rich

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


> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 11:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Does the 9iR2 Installer delete patch files?
> 
> 
> 
> FYI: You run the risk of corrupting your oracle inventory
> files by using that installer.
> 
> Jared
> 
> On Wed, 2003-09-10 at 08:04, Jesse, Rich wrote:
> > Thanks for the suggestion.  And perhaps it explains what 
> I'm seeing.  I
> > tried the 9.2.0.4 installer many times between two 
> installs.  Each time the
> > 2.2.0.18 ("new") installer crashed and there was no help on 
> MetaLink nor
> > Goo5le (Happy 5yrs!).  Out of desperation I tried the 
> 9.2.0.1 installer and
> > it worked.  I don't know why I didn't see this before (too 
> obvious???), but
> > that could sure explain it.  Perhaps I need to verify my 
> installer install
> > on each RAC node.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: RE: DB2 has a foot in the door

[Stephane Paquette]

Here it is :
http://www.infoworld.com/article/03/09/10/HNellisonpricing_1.html


Stephane
-Original Message-
Goulet, Dick
Sent: Wednesday, September 10, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Do you have the source of this report???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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


The following may be pertinent to the current discussion of Oracle pricing
models.

Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time

SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that allows businesses to
use as much software as they want, Oracle Corp.'s chairman and chief
executive officer Larry Ellison said Tuesday.

"It becomes very hard to count processors and to count users," Ellison said,
responding to a question on the future of software pricing at the
OracleWorld show. "Where I think we'll go is towards enterprise licensing.
.. You pay an annual recurring fee and use as much software as you want,
and I think that's a much more sensible model to use."   In News

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


For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 10:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: DB2 has a foot in the door
>
>
> is SE alot more affordable than EE? CAn you un-bundle Oracle
> software and just buy the pieces you want to use or do you
> always have to buy the whole bundle?
>
> what about 9iAS? do you have to buy the whole bundle or can
> you just get pieces?
> >
> > From: "Hitchman, Peter" <[EMAIL PROTECTED]>
> > Date: 2003/09/10 Wed AM 09:54:35 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: DB2 has a foot in the door
> >
> > Hi,
> > I looked into SE but found that Oracle would not allow it
> to be used
> > on a machine that has 4 or more CPUs or can support that many CPUs,
> > which for this company is a problem because we generally
> run Oracle on
> > Sun servers. Don't know if that has changed now with later Oracle
> > releases.
> >
> > Regards
> >
> > Pete
> >
> > -Original Message-
> > Sent: 10 September 2003 13:21
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > When negotiating site licensing, does Oracle encourage the
> customers
> > to buy EE licences?
> >
> > Or can people negotiate for a mix of EE or SE.
> >
> > Just curious, I don't know how that would work -- not very
> compatible
> > with OracleStore, it seems to me.
> >
> > Patrice.
> >
> > -Original Message-
> > Sent: Wednesday, September 10, 2003 5:59 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > We also has site licensing.
> > It was done 3-4 years ago. Maybe Oracle changed tactics since then.
> >
> > Yechiel Adar
> > Mehish
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from).  You may
> also send
> > the HELP command for other information (like subscribing).
> >
> > __
> >
> > The information contained in this email is confidential and
> > intended only for the use of the individual or entity named
> > above. If the reader of this message is not the intended
> > recipient, you are hereby notified that any dissemination,
> > distribution, or copying of this communication is strictly
> > prohibited. Thomson Scientific will accept no responsibility
> > or liability in respect to this email other than to the addressee.
> > If you have received this communication in error, please
> > notify us immediately via email: [EMAIL PROTECTED]
> > __
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hitchman, Peter
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> hosting services

RE: what is a materialized view ?

[Hately, Mike (LogicaCMG)]

Consider this :
Research is the best way to discover and to remember information.
The acquisition of information increases a DBA's skill.
Skilled DBAs should (?!!) always be in demand.

Therefore, by encouraging people to read manuals you're helping to make me
unemployed.

Just something to consider   =)

Mike Hately

PS Personally I think that the discontinuation of paper manuals was a
disaster. I used to take concepts manuals when I went in the bath. A great
place to learn. No kids, no TV.

-Original Message-
Sent: 10 September 2003 13:54
To: Multiple recipients of list ORACLE-L


I have a problem with unwillingness to invest effort and do some very basic
research from the readily available literature. Oracle has a manual called
"Database Concepts" which is accessible on approximately 87 billion places 
on the internet, for free, of course. Previous incarnations of this list
(and I am
a long time member) were, in my opinion, rendered unusable by a flood of
trivial
questions. I do honestly believe that, in order to fully participate in this
list, 
a person must satisfy certain pre-requisites, knoledge-wise and
experience-wise. 
That is why I'm trying to discourage questions like the one above. My reply
was 
jovial and humorous, but the RTFM was dead serious.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI
> Sent: Wednesday, September 10, 2003 8:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: what is a materilized view ?
> 
> 
> ROFLMAO ... What a kidder ...
> 
> v/r
> 
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> [EMAIL PROTECTED]
> (813) 827-9974  DSN 651-9974
> 
> 
> 
> > -Original Message-
> > From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, September 10, 2003 7:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: what is a materilized view ?
> > 
> > 
> > That would be a question for Madonna, not for this list.
> > Read The Fine Manual.
> > 
> > On 2003.09.10 07:04, Veeraraju_Mareddi wrote:
> > > Dear Freinds,
> > > 
> > > what is a materilized view ? what is the use of it and how
> > to create
> > > it.
> > > 
> > > Any docs or notes or white papers will be helpful.
> > > 
> > > TIA,
> > > Rajuveera
> > > 
> > 
> **
> > > 
> > > This email (including any attachments) is intended for the
> > sole use of the
> > > intended recipient/s and may contain material that is
> > CONFIDENTIAL AND
> > > PRIVATE COMPANY INFORMATION. Any review or reliance by
> > others or copying or
> > > distribution or forwarding of any or all of the contents in
> > this message is
> > > STRICTLY PROHIBITED. If you are not the intended recipient,
> > please contact
> > > the sender by email and delete all copies; your cooperation
> > in this regard
> > > is appreciated.
> > > 
> > **
> > 
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Veeraraju_Mareddi
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> > hosting services
> > > 
> > 
> -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the 
> > > name of mailing list you want to be removed from).  You may 
> > also send
> > > the HELP command for other information (like subscribing).
> > >
> > 
> > --
> > Mladen Gogala
> > Oracle DBA
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB 
> > ORACLE-L (or the name of mailing list you want to be removed 
> > from).  You may also send the HELP command for other 
> > information (like subscribing).
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing

RE: what is a materilized view ?

[Igor Neyman]

Having fun, while Jared isn't watching?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Orr, Steve
Sent: Wednesday, September 10, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L

Philosophically speaking, when the scales fall from the eyes of an
idealist and he/she becomes a rationalist, they've adopted a
"materialized view." ;-) But maybe it only exists if you believe it
exists.



-Original Message-
Sent: Wednesday, September 10, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L


Dear Freinds, 

what is a materilized view ? what is the use of it and how to create it.


Any docs or notes or white papers will be helpful.

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

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


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

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

Re: array question ???

[rgaffuri]

otn.oracle.com go to documents. look pl/sql table. its a dynamic array. 

asktom.oracle.com will have examples. 
> 
> From: Andrea Oracle <[EMAIL PROTECTED]>
> Date: 2003/09/10 Wed PM 01:34:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: array question ???
> 
> Hi all,
> 
> How to work with Array in PL/SQL.  I have an input
> string like 12,34,56,.. I need to get the values
> out and assign them to an array, and loop through the
> array to call a function.  Do you have sample code for
> 1) value assignment to array and 2) loop through
> array.  And it's all in pl/sql.
> 
> Thank you.
> 
> Andrea
> 
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Andrea Oracle
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Documents in or outside the database.

[Daniel Fink]

You also need to consider replication issues. If you will have another
site that needs to store the documents, you will need to include that in
the decision. For example, if you store them inside, Oracle can handle
the propogation of the documents to the alternate site. If you store them
outside, a separate mechanism is required.

Rachel Carmichael wrote:

> Compromise? BFILE?
>
> Unless we are actually trying to search the documents themselves, I
> store documents outside the database and store the pathname to the
> document location within the database itself.
>
> --- "M.Godlewski" <[EMAIL PROTECTED]> wrote:
> > Hi listers,
> >
> > We are working on a project that will have documents as attachments.
> > The developers want to store the documents outside the database on
> > the application server.  I want to store the documents inside the
> > database for recovery purposes.  Is there a white paper or document
> > that has performance information for blob/clob storage and retrieval
> > database performance information?
> >
> > TIA
> > M.
> >
> >
> >
> >
> > -
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
>
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

RE: RE: DB2 has a foot in the door

[DENNIS WILLIAMS]

Dick - Sorry, Infoworld, I didn't realize the link would get stripped off.


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

-Original Message-
Sent: Wednesday, September 10, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Do you have the source of this report???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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


The following may be pertinent to the current discussion of Oracle pricing
models.

Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time

SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that allows businesses to
use as much software as they want, Oracle Corp.'s chairman and chief
executive officer Larry Ellison said Tuesday.

"It becomes very hard to count processors and to count users," Ellison said,
responding to a question on the future of software pricing at the
OracleWorld show. "Where I think we'll go is towards enterprise licensing.
.. You pay an annual recurring fee and use as much software as you want,
and I think that's a much more sensible model to use."   In News

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


For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 10:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: DB2 has a foot in the door
> 
> 
> is SE alot more affordable than EE? CAn you un-bundle Oracle 
> software and just buy the pieces you want to use or do you 
> always have to buy the whole bundle? 
> 
> what about 9iAS? do you have to buy the whole bundle or can 
> you just get pieces? 
> > 
> > From: "Hitchman, Peter" <[EMAIL PROTECTED]>
> > Date: 2003/09/10 Wed AM 09:54:35 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: DB2 has a foot in the door
> > 
> > Hi,
> > I looked into SE but found that Oracle would not allow it 
> to be used 
> > on a machine that has 4 or more CPUs or can support that many CPUs, 
> > which for this company is a problem because we generally 
> run Oracle on 
> > Sun servers. Don't know if that has changed now with later Oracle 
> > releases.
> > 
> > Regards
> > 
> > Pete
> > 
> > -Original Message-
> > Sent: 10 September 2003 13:21
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > When negotiating site licensing, does Oracle encourage the 
> customers 
> > to buy EE licences?
> > 
> > Or can people negotiate for a mix of EE or SE.
> > 
> > Just curious, I don't know how that would work -- not very 
> compatible 
> > with OracleStore, it seems to me.
> > 
> > Patrice.
> > 
> > -Original Message-
> > Sent: Wednesday, September 10, 2003 5:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > We also has site licensing.
> > It was done 3-4 years ago. Maybe Oracle changed tactics since then.
> > 
> > Yechiel Adar
> > Mehish
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> > 
> > __
> > 
> > The information contained in this email is confidential and
> > intended only for the use of the individual or entity named 
> > above. If the reader of this message is not the intended 
> > recipient, you are hereby notified that any dissemination, 
> > distribution, or copying of this communication is strictly 
> > prohibited. Thomson Scientific will accept no responsibility 
> > or liability in respect to this email other than to the addressee. 
> > If you have received this communication in error, please 
> > notify us immediately via email: [EMAIL PROTECTED]
> > __
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Hitchman, Peter
> >   INET: [EMAIL PROTEC

Re: Oracle 11i

[Tanel Poder]

Title: RE: Oracle 11i



Heh-heh, imagine you're migrating from 10.7, where 
you have additional few tens of thousands AutoUpgrade scripts as 
well...
 
Btw, I have sometimes used the unsupported 
_wait_for_sync=false parameter to speed up commits when doing upgrades 
or extensive patching. You've probably looked into some of those 7 scripts 
and seen a lot of DDL (altering tables, adding comments etc..). And every DDL 
requires at least one commit, some even more. Thus if you see lots of log file 
sync waits for your AutoPatch sessions you could reduce database patching 
downtime noticeably using this parameter (the same goes for object 
recompilation). But as soon your instance crashes you should restore from 
backup, so this is the downside..
Actually, I'm not recommending anyone to use this 
parameter, just want to say, sometimes I have reduced Apps patching and upgrade 
downtime several to many hours using this ;)
 
Tanel.
 
 
 

  -Original Message- From: 
  Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i 
  Ha! Tell me about it. I'm at the tail end of an upgrade. Just 
  applying the unified driver to bring all of the 
  products bang up to date. Just when you think you're 
  on the home straight. A driver file with 920,000 lines 
  that starts 71,000 scripts. 
  It's enough to start me drinking! 
  Mike 

RE: Missing a datafile

[GL2Z/ INF DBA BENLATRECHE]

 

I don't know which schema is using  the tablepace, but I have a yesterday's
Export file.

Regards

-Message d'origine-
De : Rodrigues, Bryan [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 10 septembre 2003 17:24
À : Multiple recipients of list ORACLE-L
Objet : RE: Missing a datafile


Kamel,

What do you have for backups on the schema(s) that use the tablespace with
the missed datafile?

Bryan Rodrigues
DBA
Elcom, Inc.

-Original Message-
Sent: Wednesday, September 10, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L


Hi List

  Due to a corrupted controlfile,  I create a new controlfile with the
CREATE CONTROLFILE statement. Unfortunately I missed one datafile.  Is there
any solution to for  this case. We are running under 8.1.7 release.

Thank You.

Best Regards
Kamel Benlatreche.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

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

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

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

RE: RE: DB2 has a foot in the door

[Goulet, Dick]

Dennis,

Do you have the source of this report???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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


The following may be pertinent to the current discussion of Oracle pricing
models.

Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time

SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that allows businesses to
use as much software as they want, Oracle Corp.'s chairman and chief
executive officer Larry Ellison said Tuesday.

"It becomes very hard to count processors and to count users," Ellison said,
responding to a question on the future of software pricing at the
OracleWorld show. "Where I think we'll go is towards enterprise licensing.
... You pay an annual recurring fee and use as much software as you want,
and I think that's a much more sensible model to use."   In News

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


For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 10:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: DB2 has a foot in the door
> 
> 
> is SE alot more affordable than EE? CAn you un-bundle Oracle 
> software and just buy the pieces you want to use or do you 
> always have to buy the whole bundle? 
> 
> what about 9iAS? do you have to buy the whole bundle or can 
> you just get pieces? 
> > 
> > From: "Hitchman, Peter" <[EMAIL PROTECTED]>
> > Date: 2003/09/10 Wed AM 09:54:35 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: DB2 has a foot in the door
> > 
> > Hi,
> > I looked into SE but found that Oracle would not allow it 
> to be used 
> > on a machine that has 4 or more CPUs or can support that many CPUs, 
> > which for this company is a problem because we generally 
> run Oracle on 
> > Sun servers. Don't know if that has changed now with later Oracle 
> > releases.
> > 
> > Regards
> > 
> > Pete
> > 
> > -Original Message-
> > Sent: 10 September 2003 13:21
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > When negotiating site licensing, does Oracle encourage the 
> customers 
> > to buy EE licences?
> > 
> > Or can people negotiate for a mix of EE or SE.
> > 
> > Just curious, I don't know how that would work -- not very 
> compatible 
> > with OracleStore, it seems to me.
> > 
> > Patrice.
> > 
> > -Original Message-
> > Sent: Wednesday, September 10, 2003 5:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > We also has site licensing.
> > It was done 3-4 years ago. Maybe Oracle changed tactics since then.
> > 
> > Yechiel Adar
> > Mehish
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> > 
> > __
> > 
> > The information contained in this email is confidential and
> > intended only for the use of the individual or entity named 
> > above. If the reader of this message is not the intended 
> > recipient, you are hereby notified that any dissemination, 
> > distribution, or copying of this communication is strictly 
> > prohibited. Thomson Scientific will accept no responsibility 
> > or liability in respect to this email other than to the addressee. 
> > If you have received this communication in error, please 
> > notify us immediately via email: [EMAIL PROTECTED]
> > __
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Hitchman, Peter
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAI

array question ???

[Andrea Oracle]

Hi all,

How to work with Array in PL/SQL.  I have an input
string like 12,34,56,.. I need to get the values
out and assign them to an array, and loop through the
array to call a function.  Do you have sample code for
1) value assignment to array and 2) loop through
array.  And it's all in pl/sql.

Thank you.

Andrea

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

RE: Missing a datafile

[Rodrigues, Bryan]

Kamel,

What do you have for backups on the schema(s) that use the tablespace with
the missed datafile?

Bryan Rodrigues
DBA
Elcom, Inc.

-Original Message-
Sent: Wednesday, September 10, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L


Hi List

  Due to a corrupted controlfile,  I create a new controlfile with the
CREATE CONTROLFILE statement. Unfortunately I missed one datafile.  Is there
any solution to for  this case. We are running under 8.1.7 release.

Thank You.

Best Regards
Kamel Benlatreche.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

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

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

Re: Missing a datafile

[Tanel Poder]

Hi!

Yes, if you know where your file is.
Use "alter database create datafile as" syntax as seen below:

SQL> alter database backup controlfile to trace;

Database altered.

SQL> alter tablespace users add datafile
'C:\Oracle\Oradata\ORCL\USERS02.DBF' size 1m autoextend off;

Tablespace altered.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  160505408 bytes
Fixed Size   454208 bytes
Variable Size 109051904 bytes
Database Buffers   50331648 bytes
Redo Buffers 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
  2  --  SET STANDBY TO MAXIMIZE PERFORMANCE
  3  MAXLOGFILES 32
  4  MAXLOGMEMBERS 3
  5  MAXDATAFILES 100
  6  MAXINSTANCES 1
  7  MAXLOGHISTORY 226
  8  LOGFILE
  9GROUP 1 'C:\ORACLE\ORADATA\ORCL\REDO01.RDO'  SIZE 20M,
 10GROUP 2 'C:\ORACLE\ORADATA\ORCL\REDO02.RDO'  SIZE 20M,
 11GROUP 3 'C:\ORACLE\ORADATA\ORCL\REDO03.RDO'  SIZE 20M,
 12GROUP 4 'C:\ORACLE\ORADATA\ORCL\REDO04.RDO'  SIZE 20M
 13  -- STANDBY LOGFILE
 14  DATAFILE
 15'C:\ORACLE\ORADATA\ORCL\SYSTEM_01.DBF',
 16'C:\ORACLE\ORADATA\ORCL\UNDOTBS1_01.DBF',
 17'C:\ORACLE\ORADATA\ORCL\CWMLITE_01.DBF',
 18'C:\ORACLE\ORADATA\ORCL\DRSYS_01.DBF',
 19'C:\ORACLE\ORADATA\ORCL\EXAMPLE_01.DBF',
 20'C:\ORACLE\ORADATA\ORCL\INDX_01.DBF',
 21'C:\ORACLE\ORADATA\ORCL\ODM_01.DBF',
 22'C:\ORACLE\ORADATA\ORCL\TOOLS_01.DBF',
 23'C:\ORACLE\ORADATA\ORCL\USERS_01.DBF',
 24'C:\ORACLE\ORADATA\ORCL\XDB_01.DBF'
 25  CHARACTER SET UTF8
 26  ;

Control file created.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM_01.DBF'


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to controlfile by media recovery
ORA-01110: data file 11: 'C:\ORACLE\ORADATA\ORCL\USERS02.DBF'


SQL> select name from v$datafile;

NAME

-
C:\ORACLE\ORADATA\ORCL\SYSTEM_01.DBF
C:\ORACLE\ORADATA\ORCL\UNDOTBS1_01.DBF
C:\ORACLE\ORADATA\ORCL\CWMLITE_01.DBF
C:\ORACLE\ORADATA\ORCL\DRSYS_01.DBF
C:\ORACLE\ORADATA\ORCL\EXAMPLE_01.DBF
C:\ORACLE\ORADATA\ORCL\INDX_01.DBF
C:\ORACLE\ORADATA\ORCL\ODM_01.DBF
C:\ORACLE\ORADATA\ORCL\TOOLS_01.DBF
C:\ORACLE\ORADATA\ORCL\USERS_01.DBF
C:\ORACLE\ORADATA\ORCL\XDB_01.DBF
C:\ORACLE\ORA92\DATABASE\UNNAMED00011

11 rows selected.

SQL> alter database create datafile 'C:\ORACLE\ORA92\DATABASE\UNNAMED00011'
as 'C:\ORACLE\ORADATA\ORCL\USERS02.DBF';

Database altered.

SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL>

:)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 7:54 PM


> Hi List
>
>   Due to a corrupted controlfile,  I create a new controlfile with the
> CREATE CONTROLFILE statement. Unfortunately I missed one datafile.  Is
there
> any solution to for  this case. We are running under 8.1.7 release.
>
> Thank You.
>
> Best Regards
> Kamel Benlatreche.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: GL2Z/ INF  DBA BENLATRECHE
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

Re: Weird behavior with VARCHAR fields (was: ORA-01403 error,

[Tanel Poder]

Hi!

One more interesting issue with CHAR datatype is, that it is not *always*
padded with spaces as sometimes understood. When the CHAR field is NULL,
then no spaces are saved into row. But as soon as you update even one single
char into it, the full CHAR length is used for this field in a row.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 5:49 PM


> Fermin,
>
> You are running into the well documented behavior of the CHAR datatype.
Use
> VARCHAR2 instead if you wish to avoid those pitfalls.
>
> Hope this helps...
>
> -Tim
>
> on 9/10/03 3:29 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote:
>
> >
> > Thank you all of you who answered to my first question.
> >
> > No, the problem has nothing to do with permissions. The record existed
in the
> > table, but here it is what I discovered. Can anyone explain please? It
may be
> > the normal Oracle behavior, but I believe it was not working like this
under
> > 7.3.4 (now we have 8.0.3). I can not confirm though.
> >
> > TTDSLS805501 table definition is as follows:
> >
> > NameNull?Type
> > T$ORNONOT NULLNUMBER
> > T$USERNOT NULLCHAR(10)
> >
> > If I do an INSERT like the following:
> >
> > INSERT INTO TTDSLS805501 VALUES (151124 , 'exped9')
> >
> > The value 'exped9' for the field T$USER is 6 characters long, while the
> > definition has got 10. After the insertion, I find that the field for
the new
> > record is 10 chars long, the last 4 characters being filled with blanks.
> >
> > But here comes the weird behavior. If I construct the 2 following SELECT
on
> > this table from SQLPlus, both work OK and return the expected row:
> >
> > SELECT t$orno FROM TTDSLS805501 WHERE t$user = 'exped9';-> 1
row
> returned
> > SELECT t$orno FROM TTDSLS805501 WHERE t$user = 'exped9';-> 1
row
> > returned
> >
> > But within a stored procedure and using a local variable the following
will
> > work OK:
> >
> > SELECT t$orno INTO eskaria FROM TTDSLS805501 WHERE t$user = my_var;
> >
> > where my_var is of type VARCHAR2 and has got the value 'exped9'
> >
> > Whilst the following will come up with the ORA-01403 error:
> >
> > SELECT t$orno INTO eskaria FROM TTDSLS805501 WHERE t$user = my_var;
> >
> > where my_var is of type VARCHAR2 and has got the value 'exped9'
> >
> > Is this normal behavior? why does not the "SELECT t$orno FROM
TTDSLS805501
> > WHERE t$user = 'exped9';" statement return 0 rows in the first place?
> >
> > Fermin.
> >
> >
> > -Mensaje original-
> > De: Tim Gorman [mailto:[EMAIL PROTECTED]
> > Enviado el: miércoles, 10 de septiembre de 2003 10:44
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Re: ORA-01403 error, help!!!
> >
> >
> > Unless the stored procedure was created with invoker's rights, then it
is
> > probably executing using the permissions and schema of the account that
owns
> > it.  Who is the owner of the stored procedure?  Is it different from who
you
> > are logged into SQL*Plus as?
> >
> > The explanation might be that, through some reason like synonyms
pointing in
> > different directions from the different accounts, the name TTDSLS805501
> > might be resolving to different tables altogether...
> >
> >
> >
> > on 9/9/03 10:09 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote:
> >
> >>
> >> If logged in SQL Plus the following SQL returns just one row:
> >>
> >> SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY
t$orno;
> >>
> >> If I do use the same SELECT statement inside a stored procedure and
have the
> >> returning value stored in a local variable:
> >>
> >> SELECT t$orno INTO eskaria FROM ttdsls805501 WHERE t$user = 'exped9'
GROUP BY
> >> t$orno;
> >>
> >> where eskaria has been declared as:
> >>
> >> eskaria ttdsls805501.t$orno%TYPE;
> >>
> >> I get ORA-01403. I have no clue why I am getting this error, can you
help
> >> please?
> >>
> >> Many thanks!
> >>
> >> .
> >> Fermín Bernaus Berraondo
> >> Dpto. de Informática
> >> SAMMIC, S.A.
> >> [EMAIL PROTECTED]
> >> http://www.sammic.com
> >> Telf. +34 - 943 157 331
> >> Fax +34 - 943 151 276
> >> .
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

Re: Oracle 11i

[Tanel Poder]

Title: RE: Oracle 11i



Don't forget the installation and patch sizes vary 
dramatically between platforms...
 
(11.5.7 standard installation for Linux is 24 disks 
for example (I counted oraAux in)).
 
Tanel.
 

  - Original Message - 
  From: 
  April Wells 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, September 10, 2003 6:59 
  PM
  Subject: RE: Oracle 11i
  
  NO... it is only 1.8 gig zip file... haven't had the courage 
  to unzip it yet... 11.5.8 unzipped to nearly 8 gig. and that doesn't address the pre-req patches to lay down the new 
  tablespaces for the new users created in the upgrade. =) 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas   /\  /   \ / 
  \ \ /   \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: Tim 
  Gorman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 9:49 AM To: 
  Multiple recipients of list ORACLE-L Subject: Re: 
  Oracle 11i 
  Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  
  If you start with 11.5.8 or below, you'd also want to 
  download the 11.5.9 patch anyway, which is a further 
  2.5Gb or so... 
  on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at 
  [EMAIL PROTECTED] wrote: 
  > Tanel, > the 11.5.9 docs ask 
  you to get in touch if you're interested in a DVD > 
  release. It doesn't sound like it's actually available but they must be 
  > gauging interest for future releases. > > Cheers, > 
  Mike > > -Original 
  Message- > Sent: 10 September 2003 02:50 
  > To: Multiple recipients of list ORACLE-L 
  > > >  > > You can't download 11i, you can order 
  it for evaluation from Oracle, it's > about 50 CD 
  (when the heck will they put it on DVD?), > 
  > > Cheers, 
  > Tanel. > > > > 
  ** 
  > ** > E mail 
  Disclaimer > > You agree 
  that you have read and understood this disclaimer and you agree to 
  > be bound by its terms. > 
  > The information contained in this e-mail and any 
  files transmitted with it (if > any) are 
  confidential and intended for the addressee only.  If you have 
  > received this  e-mail in error please notify the 
  originator. > > This 
  e-mail and any attachments have been scanned for certain viruses prior 
  to > sending but CE Electric UK Funding Company nor 
  any of its associated companies > from whom this 
  e-mail originates shall be liable for any losses as a result of 
  > any viruses being passed on. > > No warranty of any kind is given in 
  respect of any information contained in > 
  this   e-mail and you should be aware that that it might be 
  incomplete, out of > date or incorrect. It is 
  therefore essential that you verify all such > 
  information with us before placing any reliance upon it. > > CE Electric UK Funding Company 
  > Lloyds Court > 78 Grey 
  Street > Newcastle upon Tyne > NE1 6AF > Registered in England and 
  Wales: Number 3476201 > > 
  ** 
  > ** 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Tim Gorman   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  


  The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: what is a materilized view ?

[Orr, Steve]

Philosophically speaking, when the scales fall from the eyes of an
idealist and he/she becomes a rationalist, they've adopted a
"materialized view." ;-) But maybe it only exists if you believe it
exists.



-Original Message-
Sent: Wednesday, September 10, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L


Dear Freinds, 

what is a materilized view ? what is the use of it and how to create it.


Any docs or notes or white papers will be helpful.

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

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

Re: Antw: Weird behavior with VARCHAR fields (was: ORA-01403

[Chaim . Katz]

Fermin,
The pl/sql manual has an appendix on char versus varchar2 semantics.
I guess SQL*Plus isn't as restrictive(?) and I gues the behaviour might
have changed since 7.3.
I wonder why baan uses char datatypes
chaim




"Guido Konsolke" <[EMAIL PROTECTED]>
@fatcity.com on 09/10/2003 10:14:24 AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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



Hi Fermin,

given that I understand you correctly:

pl/sql DOES exactly what you want:
it returns 0 rows. That results in a exception
called NO_DATA_FOUND and is assigned
to the ORA-01403 error.

To get a result '0' you have to query
the table using 'Count'.

Greetings,
Guido

>>> [EMAIL PROTECTED] 10.09.2003  12.29 Uhr >>>

  Thank you all of you who answered to my first question.

  No, the problem has nothing to do with permissions. The record
existed in the table, but here it is what I discovered. Can anyone explain
please? It may be the normal Oracle behavior, but I believe it was not
working like this under 7.3.4 (now we have 8.0.3). I can not confirm
though.

  TTDSLS805501 table definition is as follows:

Name  Null? Type
T$ORNO  NOT NULLNUMBER
T$USER  NOT NULLCHAR(10)

  If I do an INSERT like the following:

INSERT INTO TTDSLS805501 VALUES (151124 , 'exped9')

  The value 'exped9' for the field T$USER is 6 characters long, while
the definition has got 10. After the insertion, I find that the field for
the new record is 10 chars long, the last 4 characters being filled with
blanks.

  But here comes the weird behavior. If I construct the 2 following
SELECT on this table from SQLPlus, both work OK and return the expected
row:

SELECT t$orno FROM TTDSLS805501 WHERE t$user = 'exped9';
  -> 1 row returned
SELECT t$orno FROM TTDSLS805501 WHERE t$user = 'exped9';
  -> 1 row returned

  But within a stored procedure and using a local variable the
following will work OK:

SELECT t$orno INTO eskaria FROM TTDSLS805501 WHERE t$user =
my_var;

where my_var is of type VARCHAR2 and has got the value 'exped9
'

  Whilst the following will come up with the ORA-01403 error:

SELECT t$orno INTO eskaria FROM TTDSLS805501 WHERE t$user =
my_var;

where my_var is of type VARCHAR2 and has got the value 'exped9'

  Is this normal behavior? why does not the "SELECT t$orno FROM
TTDSLS805501 WHERE t$user = 'exped9';" statement return 0 rows in the first
place?

Fermin.



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

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




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

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

Problem with mutating trigger

[Gary Jackson]

Hello,
 I have a moderate size 8.0.4 database that has been running perfectly for 
years. I took an export of the structure only of this database and imported 
it onto another server also running 8.0.4.  I then inserted only a few rows 
into key tables. This is now serving as a testing database for my 
developers.
However a problem is showing up:

When inserting into a table, I get a mutating trigger error that does not 
occur on the moderate size database.  What could be causing this trigger 
error on the small database when it works perfectly on the large database? 
(I verified that all code of the trigger, all constraints, and all table 
structures involved are identical).

It seems to be a fairly simple trigger:

CREATE OR REPLACE TRIGGER "BOSS".order_master_tau
AFTER UPDATE OF ord_mas_sts_cd ON order_master
FOR EACH ROW
BEGIN
   IF
   :old.ord_mas_sts_cd <> :new.ord_mas_sts_cd
   THEN
INSERT INTO order_master_sts_log
   ( ord_id, ord_sub_id, ord_sts_cd, ord_sts_dt, ord_sts_nt )
VALUES
( :old.ord_id,:old.ord_sub_id, :old.ord_mas_sts_cd, 
:old.ord_mas_sts_dt,
  :old.ord_mas_sts_nt );
   END IF;
 END;

Any input greatly appreciated,
-Fred Smith
_
Try MSN Messenger 6.0 with integrated webcam functionality! 
http://www.msnmessenger-download.com/tracking/reach_webcam

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

Missing a datafile

[GL2Z/ INF DBA BENLATRECHE]

Hi List

  Due to a corrupted controlfile,  I create a new controlfile with the
CREATE CONTROLFILE statement. Unfortunately I missed one datafile.  Is there
any solution to for  this case. We are running under 8.1.7 release.

Thank You.

Best Regards
Kamel Benlatreche.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

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

RE: Weird behavior with VARCHAR fields (was: ORA-01403 error,

[Wolfgang Breitling]

SQL and PL/SQL are not the same until Oracle 9. There are distinct 
differences between the two in earlier releases.

I don't have an 8.0.3 version of Oracle but the following is the result 
from 8.1.7:

SQL> create table wb (c1 char(8));

Table created.

SQL> insert into wb values('abcd');

1 row created.

SQL> insert into wb values('abcde');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from wb where c1 = 'abcd';

C1

abcd
1 row selected.

SQL> create or replace procedure wbp as
  2v_c1 char(8);
  3l_c1 varchar2(8) := 'abcd';
  4l_c2 varchar2(8) := 'abcd';
  5  begin
  6begin
  7  select c1 into v_c1 from wb where c1 = 'abcd';
  8  dbms_output.put_line('literal: '||v_c1);
  9exception
 10when no_data_found then null;
 11end;
 12begin
 13  select c1 into v_c1 from wb where c1 = l_c1;
 14  dbms_output.put_line('case1: '||v_c1);
 15exception
 16when no_data_found then null;
 17end;
 18begin
 19  select c1 into v_c1 from wb where c1 = l_c2;
 20  dbms_output.put_line('case2: '||v_c1);
 21exception
 22when no_data_found then null;
 23end;
 24* end;
 25  /
Procedure created.

SQL> exec wbp;
literal: abcd
case2: abcd
PL/SQL procedure successfully completed.

The literal worked. So did the the varchar2 string padded to match the 
length of the char column.

Now this is the result if run on 9.2:

SQL> create table wb (c1 char(8));

Table created.

SQL> insert into wb values('abcd');

1 row created.

SQL> insert into wb values('abcde');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from wb where c1 = 'abcd';

C1

abcd
1 row selected.

SQL> create or replace procedure wbp as
  2v_c1 char(8);
  3l_c1 varchar2(8) := 'abcd';
  4l_c2 varchar2(8) := 'abcd';
  5  begin
  6begin
  7  select c1 into v_c1 from wb where c1 = 'abcd';
  8  dbms_output.put_line('literal: '||v_c1);
  9exception
 10when no_data_found then null;
 11end;
 12begin
 13  select c1 into v_c1 from wb where c1 = l_c1;
 14  dbms_output.put_line('case1: '||v_c1);
 15exception
 16when no_data_found then null;
 17end;
 18begin
 19  select c1 into v_c1 from wb where c1 = l_c2;
 20  dbms_output.put_line('case2: '||v_c1);
 21exception
 22when no_data_found then null;
 23end;
 24* end;
 25  /
Procedure created.

SQL> exec wbp;
literal: abcd
case1: abcd
PL/SQL procedure successfully completed.

The literal still works the same, but now the unpadded string finds the 
row, but the padded one doesn't.

Moral: It pays to test when upgrading software.

At 08:14 AM 9/10/2003 -0800, you wrote:

Yet I do not understand why it returns a row in SQLPlus and it 
does not in a stored procedure... The problem is now fixed, but I'd like 
to know the reason it won't work leaving it as it was. It also fails if I 
put a string instead of a variable in the stored procedure.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: imp with pipe and dd cmds

[Jared Still]

Ah, so it was to tape.

How many people still use dd to go to tape?

Jared

On Tue, 2003-09-09 at 19:49, Tanel Poder wrote:
> Are you sure that your exportfile is intact, that it was saved fully and correctly 
> to tape and it is read fully and correctly from tape. And it is passed fully and 
> correctly to the pipe?
> Shouldn't you have used exp with pipe and split for this purpose?
> 
> Tanel.
> 
>   - Original Message - 
>   From: venkat Rama 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Wednesday, September 10, 2003 5:09 AM
>   Subject: imp with pipe and dd cmds
> 
> 
> 
> 
> Hi Friends,
> 
> I exported with full=y my whole database(on AIX5.1,oracle8174), I 
> exported with pipe and dd (bs=65536k)commands, Export went very well. But my 
> problem now Iam importing back with tables=mytable its just sitting 
> there? with out any response. If I query os its showing its running..
> 
> Iam trying to import a particular table I did't see any response. My 
> parfile options are
> userid=u/p
> tables=mytable
> ignore=y
> commit=y
> buffer=400
> indexes=n
> 
> I tried to change block_size for dd command, But some times it worked, 
> some times not. I tried to import one row table giving block_size 32k, 
> its imported!! But for mytable its big with 40Millon rows with avg row 
> size 300bytes. But 0 block_size its gave error(pls remember I exported 
> with bs=65536k) saying "read fail". Could you people suggest any ideas?
> 
> TIA
> 
> Venkat
> 
> 
> 
> 
> 
> 
> --
>   Do you Yahoo!?
>   Yahoo! SiteBuilder - Free, easy-to-use web site design software


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

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

RE: Oracle 11i

[April Wells]

sometimes listener... but sometimes not (when new works 
old doesn't but if new doesn't start... old will)
sometimes apache... but sometimes not (when new works 
old doesn't but if new doesn't start... old will)
sometimes CM... but sometimes not... (when new works 
old doesn't but if new doesn't start... old will)
 
we 
can't do a remote session with ORacle due to EXTEME lag times on our 
firewalls... so they are minimally helpful... 
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   
>\<  
\  
>\<  \ 
Few people really enjoy the simple 
pleasure of flying a kite Adam 
Wells age 11 

  -Original Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003 
  10:22 AMTo: April Wells; [EMAIL PROTECTED]Subject: 
  RE: Oracle 11i
  Has Oracle made any progress on the problem.  We have duty managered 
  the TAR with no solution to date.  Last update is that Oracle wants an 
  ODC session.
   
  We are W2K on two tier.
   
  What services are giving you a problem?
   
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
  781-4204>>> [EMAIL PROTECTED] 9/10/03 11:54:33 AM 
  >>>
  We are having issues with reports server, too... I think it is 
  Autoconfig.
   
  Did YOU notice that you got a whole NEW set of services (are you 
  on Win?) when you went auto config... FEATURE!!  Some of the new ones 
  work sometimes, sometimes only the old ones will.
   
  April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   >\<  \  >\<  
  \ Few people really enjoy the 
  simple pleasure of flying a kite Adam Wells age 11 
  
-Original Message-From: Jeffrey Beckstrom 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003 
9:49 AMTo: April Wells; [EMAIL PROTECTED]Subject: 
RE: Oracle 11i
We went from 11.5.6 to 11.5.9.  As part of upgrade we implemented 
autoconfig.  Initiallly could not print.  Then put on a patch for 
grants and now can print - patch was titled fixes for non-standard 
schemas.  Still can not access report server.  Don't know if due 
to autoconfig or 11.5.9 since did not stop in between.
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland 
Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 
44113(216) 781-4204>>> [EMAIL PROTECTED] 9/10/03 
11:39:25 AM >>>
Anything break badly? 
We are going to be starting in about a month down the 11.5.8 
-> 11.5.9 road. 
April Wells Oracle DBA/Oracle Apps 
DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/ 
  >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 
-Original Message- From: 
Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 10, 2003 10:29 AM 
To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i 
Ha! Tell me about it. I'm at the tail end of an upgrade. 
Just applying the unified driver to bring all of the 
products bang up to date. Just when you think you're 
on the home straight. A driver file with 920,000 lines that starts 71,000 scripts. 
It's enough to start me drinking! 
Mike 
-Original Message- Sent: 10 
September 2003 14:49 To: Multiple recipients of list 
ORACLE-L 
Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 
12Gb.  If you start with 11.5.8 or below, you'd 
also want to download the 11.5.9 patch anyway, which is a further 2.5Gb or so... 
on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at 
[EMAIL PROTECTED] wrote: 
> Tanel, > the 11.5.9 docs ask 
you to get in touch if you're interested in a DVD > release. It doesn't sound like it's actually available but they 
must be > gauging interest for future 
releases. > > 
Cheers, > Mike > 
> -Original Message- > Sent: 10 September 2003 02:50 > To: 
Multiple recipients of list ORACLE-L > 
> >  > > You can't download 11i, you can order it for evaluation from 
Oracle, it's > about 50 CD (when the heck will 
they put it on DVD?), > > > Cheers, > Tanel. > > 
> >  
** > ** 
> E mail Disclaimer > 
> You agree that you have read and understood 
this disclaimer and you agree to > be bound by its terms. > 
> The information contained in this e-mail and 
any files transmitted with it (if > any) are confidential and intended for the addressee only.  
If you have > received this  e-mail in error 
please notify the originator. > > This e-mail and any attachments have been scanned for certain 
viruses prior to > 
sending but CE Electric UK Funding Company nor any of its

RE: Oracle 11i

[Jeffrey Beckstrom]

Has Oracle made any progress on the problem.  We have duty managered 
the TAR with no solution to date.  Last update is that Oracle wants an ODC 
session.
 
We are W2K on two tier.
 
What services are giving you a problem?
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204>>> [EMAIL PROTECTED] 9/10/03 11:54:33 AM 
>>>
We 
are having issues with reports server, too... I think it is 
Autoconfig.
 
Did 
YOU notice that you got a whole NEW set of services (are you on Win?) when you 
went auto config... FEATURE!!  Some of the new ones work sometimes, 
sometimes only the old ones will.
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   
>\<  
\  
>\<  \ 
Few people really enjoy the simple 
pleasure of flying a kite Adam 
Wells age 11 

  -Original Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003 
  9:49 AMTo: April Wells; [EMAIL PROTECTED]Subject: RE: 
  Oracle 11i
  We went from 11.5.6 to 11.5.9.  As part of upgrade we implemented 
  autoconfig.  Initiallly could not print.  Then put on a patch for 
  grants and now can print - patch was titled fixes for non-standard 
  schemas.  Still can not access report server.  Don't know if due to 
  autoconfig or 11.5.9 since did not stop in between.
   
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
  781-4204>>> [EMAIL PROTECTED] 9/10/03 11:39:25 AM 
  >>>
  Anything break badly? 
  We are going to be starting in about a month down the 11.5.8 
  -> 11.5.9 road. 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas   /\  /   \ / 
  \ \ /   \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: 
  Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i 
  Ha! Tell me about it. I'm at the tail end of an upgrade. Just 
  applying the unified driver to bring all of the 
  products bang up to date. Just when you think you're 
  on the home straight. A driver file with 920,000 lines 
  that starts 71,000 scripts. 
  It's enough to start me drinking! 
  Mike 
  -Original Message- Sent: 10 
  September 2003 14:49 To: Multiple recipients of list 
  ORACLE-L 
  Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  
  If you start with 11.5.8 or below, you'd also want to 
  download the 11.5.9 patch anyway, which is a further 
  2.5Gb or so... 
  on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at 
  [EMAIL PROTECTED] wrote: 
  > Tanel, > the 11.5.9 docs ask 
  you to get in touch if you're interested in a DVD > 
  release. It doesn't sound like it's actually available but they must be 
  > gauging interest for future releases. > > Cheers, > 
  Mike > > -Original 
  Message- > Sent: 10 September 2003 02:50 
  > To: Multiple recipients of list ORACLE-L 
  > > >  > > You can't download 11i, you can order 
  it for evaluation from Oracle, it's > about 50 CD 
  (when the heck will they put it on DVD?), > 
  > > Cheers, 
  > Tanel. > > > > 
   
  ** > ** 
  > E mail Disclaimer > 
  > You agree that you have read and understood this 
  disclaimer and you agree to > be bound by its terms. > 
  > The information contained in this e-mail and any 
  files transmitted with it (if > any) are confidential and intended for the addressee only.  
  If you have > received this  e-mail in error 
  please notify the originator. > > This e-mail and any attachments have been scanned for certain 
  viruses prior to > sending 
  but CE Electric UK Funding Company nor any of its associated companies > from whom this e-mail originates 
  shall be liable for any losses as a result of 
  > any viruses being passed on. > > No warranty of any kind is given in 
  respect of any information contained in 
  > this   e-mail and you should be aware that 
  that it might be incomplete, out of > date or incorrect. It is therefore essential that you verify all 
  such > information with us before placing any 
  reliance upon it. > > CE 
  Electric UK Funding Company > Lloyds Court 
  > 78 Grey Street > Newcastle 
  upon Tyne > NE1 6AF > 
  Registered in England and Wales: Number 3476201 > 
  >  
  ** > ** 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Tim Gorman   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services --

Weblogic versus Oracle 9ias

[Paulo Gomes]

Hi list
 
My companie is trying to 
demonstrate the virtuews of 9ias compared with BEA.
 
Can any one help me 
here?
 
Regards
 
PG

RE: Oracle 11i

[April Wells]

Title: RE: Oracle 11i





It actually just doesn't speak well of the sanity of those involved in maintaining the beast.  And this is coming from the Corporate Systems chief beast keeper... 

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 11i



Database Database Administrator.


(Database DBA)


: )


Patrice.


-Original Message-
Sent: Wednesday, September 10, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L



Doesn't this go back to the "Application DBA" vs. "Production DBA"
discussion?  I've talked with folks that employ a "Patch DBA" -- all they do
is manage 11i patches.  Fun!


Rich


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



> -Original Message-
> From: Tim Gorman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 10, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle 11i
> 
> 
> Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  If 
> you start with
> 11.5.8 or below, you'd also want to download the 11.5.9 patch 
> anyway, which
> is a further 2.5Gb or so...
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]


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


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



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: making me crazy

[Jared Still]

The curious among us would like to know what kind of situation
prevents you from correcting the listener.ora in the ORACLE_HOME
that is running the listener.


On Wed, 2003-09-10 at 07:44, [EMAIL PROTECTED] wrote:
> Dealing with 2 Oracle Homes - one if which I need to run the listener from
> and one in which I need to use the tnsnames.ora definitions from and no I
> can't just copy the tnsnames.ora to the 1st Oracle Home.  Even when I set
> the oracle home from which to run lsnrctl it tries to use the listener.ora
> from the TNS_ADMIN home.  How can I make sure to explicitly start the
> correct listener.ora?
> 
> Thanks,
> Paula


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

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

RE: Weird behavior with VARCHAR fields (was: ORA-01403 error,

[Fermin Bernaus]

Yet I do not understand why it returns a row in SQLPlus and it does not in a 
stored procedure... The problem is now fixed, but I'd like to know the reason it won't 
work leaving it as it was. It also fails if I put a string instead of a variable in 
the stored procedure.

Thanks!

Fermin.

-Mensaje original-
De: Tim Gorman [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 10 de septiembre de 2003 16:50
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Weird behavior with VARCHAR fields (was: ORA-01403 error,


Fermin,

You are running into the well documented behavior of the CHAR datatype.  Use
VARCHAR2 instead if you wish to avoid those pitfalls.

Hope this helps...

-Tim

on 9/10/03 3:29 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote:

> 
> Thank you all of you who answered to my first question.
> 
> No, the problem has nothing to do with permissions. The record existed in the
> table, but here it is what I discovered. Can anyone explain please? It may be
> the normal Oracle behavior, but I believe it was not working like this under
> 7.3.4 (now we have 8.0.3). I can not confirm though.
> 
> TTDSLS805501 table definition is as follows:
> 
> NameNull?Type
> T$ORNONOT NULLNUMBER
> T$USERNOT NULLCHAR(10)
> 
> If I do an INSERT like the following:
> 
> INSERT INTO TTDSLS805501 VALUES (151124 , 'exped9')
> 
> The value 'exped9' for the field T$USER is 6 characters long, while the
> definition has got 10. After the insertion, I find that the field for the new
> record is 10 chars long, the last 4 characters being filled with blanks.
> 
> But here comes the weird behavior. If I construct the 2 following SELECT on
> this table from SQLPlus, both work OK and return the expected row:
> 
> SELECT t$orno FROM TTDSLS805501 WHERE t$user = 'exped9';-> 1 row
returned
> SELECT t$orno FROM TTDSLS805501 WHERE t$user = 'exped9';-> 1 row
> returned
> 
> But within a stored procedure and using a local variable the following will
> work OK:
> 
> SELECT t$orno INTO eskaria FROM TTDSLS805501 WHERE t$user = my_var;
> 
> where my_var is of type VARCHAR2 and has got the value 'exped9'
> 
> Whilst the following will come up with the ORA-01403 error:
> 
> SELECT t$orno INTO eskaria FROM TTDSLS805501 WHERE t$user = my_var;
> 
> where my_var is of type VARCHAR2 and has got the value 'exped9'
> 
> Is this normal behavior? why does not the "SELECT t$orno FROM TTDSLS805501
> WHERE t$user = 'exped9';" statement return 0 rows in the first place?
> 
> Fermin.
> 
> 
> -Mensaje original-
> De: Tim Gorman [mailto:[EMAIL PROTECTED]
> Enviado el: miércoles, 10 de septiembre de 2003 10:44
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: ORA-01403 error, help!!!
> 
> 
> Unless the stored procedure was created with invoker's rights, then it is
> probably executing using the permissions and schema of the account that owns
> it.  Who is the owner of the stored procedure?  Is it different from who you
> are logged into SQL*Plus as?
> 
> The explanation might be that, through some reason like synonyms pointing in
> different directions from the different accounts, the name TTDSLS805501
> might be resolving to different tables altogether...
> 
> 
> 
> on 9/9/03 10:09 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote:
> 
>> 
>> If logged in SQL Plus the following SQL returns just one row:
>> 
>> SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno;
>> 
>> If I do use the same SELECT statement inside a stored procedure and have the
>> returning value stored in a local variable:
>> 
>> SELECT t$orno INTO eskaria FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY
>> t$orno;
>> 
>> where eskaria has been declared as:
>> 
>> eskaria ttdsls805501.t$orno%TYPE;
>> 
>> I get ORA-01403. I have no clue why I am getting this error, can you help
>> please?
>> 
>> Many thanks!
>> 
>> .
>> Fermín Bernaus Berraondo
>> Dpto. de Informática
>> SAMMIC, S.A.
>> [EMAIL PROTECTED]
>> http://www.sammic.com
>> Telf. +34 - 943 157 331
>> Fax +34 - 943 151 276
>> .

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.

RE: making me crazy

[Hand, Michael T]

Title: RE: making me crazy



Paula,
Would 
putting both listeners in one listener.ora file help.  You would, of course 
have to change one or both to a non-default name.
 
Mike

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 
  10, 2003 10:45 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: making me crazy
  Dealing with 2 Oracle Homes - one if which I need to run the 
  listener from and one in which I need to use the tnsnames.ora definitions from 
  and no I can't just copy the tnsnames.ora to the 1st Oracle Home.  Even 
  when I set the oracle home from which to run lsnrctl it tries to use the 
  listener.ora from the TNS_ADMIN home.  How can I make sure to explicitly 
  start the correct listener.ora?
  Thanks, Paula 
-- 
This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

RE: HTML Report Question

[Mladen Gogala]

How about using the extension ".HTM"? OE is a vewy, vewy screwy program and
makes
decisions purely on extensions. You could even make it open an executable
extension
which would send all of your friends message like "I love you", which would
replicate
itself when opened. All it takes is a preview of a HTML formatted message
with VBS
as a scripting language. A teenager could write something like that.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Orr, Steve
> Sent: Wednesday, September 10, 2003 11:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: HTML Report Question
> 
> 
> Hmmm... Try making this the first line followed by a blank line:
> 
> "Content-Type: text/html
> 
> "
> 
> 
> Just guessing...
> 
> 
> -Original Message-
> Sent: Tuesday, September 09, 2003 7:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi DBAs!
> 
> I am trying to generate an HTML report, and send it through the 
> mail in HTML format.  Only one problem...Outlook thinks it's 
> text not html, even though the first line of the report is "".
> 
> I'm generating the report with...
>  sqlplus -silent -markup "HTML ON"
> ...and then using mailx to send the output to my client mailbox.
> 
> Any suggestions as to how I can make the mail come in as HTML?
> 
> Thanks,
> Mike
> 
> 
> --- 
> ==
> ==
> ===
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Vergara, Michael (TEM)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing)
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

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

RE: RE: DB2 has a foot in the door

[DENNIS WILLIAMS]

The following may be pertinent to the current discussion of Oracle pricing
models.

Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time

SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that allows businesses to
use as much software as they want, Oracle Corp.'s chairman and chief
executive officer Larry Ellison said Tuesday.

"It becomes very hard to count processors and to count users," Ellison said,
responding to a question on the future of software pricing at the
OracleWorld show. "Where I think we'll go is towards enterprise licensing.
... You pay an annual recurring fee and use as much software as you want,
and I think that's a much more sensible model to use."   In News

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


For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 10:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: DB2 has a foot in the door
> 
> 
> is SE alot more affordable than EE? CAn you un-bundle Oracle 
> software and just buy the pieces you want to use or do you 
> always have to buy the whole bundle? 
> 
> what about 9iAS? do you have to buy the whole bundle or can 
> you just get pieces? 
> > 
> > From: "Hitchman, Peter" <[EMAIL PROTECTED]>
> > Date: 2003/09/10 Wed AM 09:54:35 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: DB2 has a foot in the door
> > 
> > Hi,
> > I looked into SE but found that Oracle would not allow it 
> to be used 
> > on a machine that has 4 or more CPUs or can support that many CPUs, 
> > which for this company is a problem because we generally 
> run Oracle on 
> > Sun servers. Don't know if that has changed now with later Oracle 
> > releases.
> > 
> > Regards
> > 
> > Pete
> > 
> > -Original Message-
> > Sent: 10 September 2003 13:21
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > When negotiating site licensing, does Oracle encourage the 
> customers 
> > to buy EE licences?
> > 
> > Or can people negotiate for a mix of EE or SE.
> > 
> > Just curious, I don't know how that would work -- not very 
> compatible 
> > with OracleStore, it seems to me.
> > 
> > Patrice.
> > 
> > -Original Message-
> > Sent: Wednesday, September 10, 2003 5:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > We also has site licensing.
> > It was done 3-4 years ago. Maybe Oracle changed tactics since then.
> > 
> > Yechiel Adar
> > Mehish
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> > 
> > __
> > 
> > The information contained in this email is confidential and
> > intended only for the use of the individual or entity named 
> > above. If the reader of this message is not the intended 
> > recipient, you are hereby notified that any dissemination, 
> > distribution, or copying of this communication is strictly 
> > prohibited. Thomson Scientific will accept no responsibility 
> > or liability in respect to this email other than to the addressee. 
> > If you have received this communication in error, please 
> > notify us immediately via email: [EMAIL PROTECTED]
> > __
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Hitchman, Peter
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command 

RE: Oracle 11i

[Hately, Mike (LogicaCMG)]

April,
 
Nothing disastrous has happened actually (touch wood!) which was a surprise.
We're going from 11.0.3 so I've seen things that no man should ever have to
see.   =)
 
Mostly small data fixes specific to us. I'll let you know if we get a fix to
this current problem.
Feel free to get in touch if you hit any problems. I'll trawl through my
"issues" folder and forward anything that I think you may hit. 
 
Cheers,
Mike Hately

-Original Message-
Sent: 10 September 2003 15:39
To: Multiple recipients of list ORACLE-L



Anything break badly? 

We are going to be starting in about a month down the 11.5.8 -> 11.5.9 road.


April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 
  /\ 
 /   \ 
/ \ 
\ / 
  \/ 
  >\< 
 \ 
 >\< 
 \ 
Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 



-Original Message- 
 ] 
Sent: Wednesday, September 10, 2003 10:29 AM 
To: Multiple recipients of list ORACLE-L 


Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the 
unified driver to bring all of the products bang up to date. 
Just when you think you're on the home straight. A driver file with 920,000 
lines that starts 71,000 scripts. 

It's enough to start me drinking! 

Mike 




E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  INET: [EMAIL PROTECTED]

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

RE: Does the 9iR2 Installer delete patch files?

[Jared Still]

FYI: You run the risk of corrupting your oracle inventory
files by using that installer.

Jared

On Wed, 2003-09-10 at 08:04, Jesse, Rich wrote:
> Thanks for the suggestion.  And perhaps it explains what I'm seeing.  I
> tried the 9.2.0.4 installer many times between two installs.  Each time the
> 2.2.0.18 ("new") installer crashed and there was no help on MetaLink nor
> Goo5le (Happy 5yrs!).  Out of desperation I tried the 9.2.0.1 installer and
> it worked.  I don't know why I didn't see this before (too obvious???), but
> that could sure explain it.  Perhaps I need to verify my installer install
> on each RAC node.
> 
> Thanks again Mehish!
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> > -Original Message-
> > From: Yechiel Adar [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, September 10, 2003 7:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Does the 9iR2 Installer delete patch files?
> > 
> > 
> > Hello Jesse
> > 
> > I do not know if this apply also to Linux but:
> > I am installing now 9.2.0.4 on windows and I saw that you 
> > need to install
> > the new installer first on all the nodes of the RAC first.
> > Then you can install the patch.
> > 
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 03, 2003 5:54 PM
> > 
> > 
> > > Hey all,
> > >
> > > During the instal of 9iRAC on RH9, the instructions say to 
> > install the
> > > 9.2.0.1 software, then apply the 9.2.0.4 patch separately to the
> > Installer,
> > > OCM, and finally to the RAC software itself.  This is my second time
> > through
> > > and both times there were files in the cpio-exploded patch that had
> > > disappeared somewhere between the patching of the Installer 
> > and the RAC
> > > software.  This time I kept the cpio file of the patch so I 
> > didn't need to
> > > download it again.
> > >
> > > I should probably have taken down some of the names of the 
> > files that came
> > > up as "File not found" errors during the RAC install, but 
> > there were so
> > many
> > > during my first install, I figured I had accidentally "rm"d 
> > a directory.
> > >
> > > Anyone know what's up with the Installer?  "Or is it just 
> > me?" he axes,
> > > praying for the former...
> > >
> > > Rich
> > >
> > > Rich Jesse   System/Database Administrator
> > > [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

RE: Oracle 11i

[Boivin, Patrice J]

Database Database Administrator.

(Database DBA)

: )

Patrice.

-Original Message-
Sent: Wednesday, September 10, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Doesn't this go back to the "Application DBA" vs. "Production DBA"
discussion?  I've talked with folks that employ a "Patch DBA" -- all they do
is manage 11i patches.  Fun!

Rich

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


> -Original Message-
> From: Tim Gorman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle 11i
> 
> 
> Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  If 
> you start with
> 11.5.8 or below, you'd also want to download the 11.5.9 patch 
> anyway, which
> is a further 2.5Gb or so...
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: question about migrating to 9i

[Tanel Poder]

Hi!

Actually you can issue just "create database" with non-OMF configuration in
9i as well. The command creates files like log1orcl.ora, log2orcl.ora,
dbsorcl.ora, und1orcl.ora under $OH/dbs (or $OH/database as I tested on
windows with 9.2.0.4).

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 6:39 PM


> I was told by one Oracle instructor that new features of 9i, including
> Oracle Managed Files, could allow you to create a viable production
database
> by simply typing "CREATE DATABASE" -- once the init.ora (SPFILE?) was
> created and the hardware layed out properly.
>
> Perhaps not something many will use, but it could be one of those good and
> nasty over-simplified marketing tools.
>
> :)
>
> Rich
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
>
>
>
>  -Original Message-
> Sent: Tuesday, September 09, 2003 4:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Im not going to physically do the migration, but I want to make sure
certain
> features are set up. Let me know if Im missing any of the basics(anything
> that is a pain to add on my own later).
>
> Locally Managed tablespaces are the default right?
> Automatic Segment Allocation
> Undo Tablespace
> SPFILE
>
> any other goodies Im forgetting? Just basic settings. rest I can do
myself.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

Oracle 9i and DB2 8.1 comparison article

[Boivin, Patrice J]

http://www.databasejournal.com/features/oracle/article.php/3075071

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

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

RE: Oracle 11i

[Anna Li]

Thanks, Mike.  It still asks me to provide billing info when I tried to 
order the CD Packs.  How did you get it for free?

Nancy


From: "Hately, Mike (LogicaCMG)" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Oracle 11i
Date: Wed, 10 Sep 2003 01:24:24 -0800
Nancy,
look in the Oracle Store. You can buy it for next to nothing.
Click the CD Packs tab, choose the platform you want, select 11i Release 9.
Cheers,
Mike Hately
-Original Message-
Sent: 10 September 2003 02:24
To: Multiple recipients of list ORACLE-L
I would like to evaluate Oracle 11i.  Could any body let me know what are
pros and cons between Oracle 11i and Oracle Collaboration Suite?  Is there
any place where I can download Oracle 11i and related documents for trial?
I can not find them on Oracle web site.
Thanks for any inputs in advance.

Nancy

_


E mail Disclaimer
You agree that you have read and understood this disclaimer and you agree 
to be bound by its terms.

The information contained in this e-mail and any files transmitted with it 
(if any) are confidential and intended for the addressee only.  If you have 
received this  e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior 
to sending but CE Electric UK Funding Company nor any of its associated 
companies from whom this e-mail originates shall be liable for any losses 
as a result of any viruses being passed on.

No warranty of any kind is given in respect of any information contained in 
this   e-mail and you should be aware that that it might be incomplete, out 
of date or incorrect. It is therefore essential that you verify all such 
information with us before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201


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

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

RE: Oracle 11i

[April Wells]

Title: RE: Oracle 11i





NO... it is only 1.8 gig zip file... haven't had the courage to unzip it yet... 11.5.8 unzipped to nearly 8 gig.
and that doesn't address the pre-req patches to lay down the new tablespaces for the new users created in the upgrade.
=)


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Tim Gorman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle 11i



Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  If you start with
11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which
is a further 2.5Gb or so...



on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED]
wrote:


> Tanel,
> the 11.5.9 docs ask you to get in touch if you're interested in a DVD
> release. It doesn't sound like it's actually available but they must be
> gauging interest for future releases.
> 
> Cheers,
> Mike
> 
> -Original Message-
> Sent: 10 September 2003 02:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> You can't download 11i, you can order it for evaluation from Oracle, it's
> about 50 CD (when the heck will they put it on DVD?),
> 
> 
> Cheers,
> Tanel.
> 
> 
> 
> **
> **
> E mail Disclaimer
> 
> You agree that you have read and understood this disclaimer and you agree to
> be bound by its terms.
> 
> The information contained in this e-mail and any files transmitted with it (if
> any) are confidential and intended for the addressee only.  If you have
> received this  e-mail in error please notify the originator.
> 
> This e-mail and any attachments have been scanned for certain viruses prior to
> sending but CE Electric UK Funding Company nor any of its associated companies
> from whom this e-mail originates shall be liable for any losses as a result of
> any viruses being passed on.
> 
> No warranty of any kind is given in respect of any information contained in
> this   e-mail and you should be aware that that it might be incomplete, out of
> date or incorrect. It is therefore essential that you verify all such
> information with us before placing any reliance upon it.
> 
> CE Electric UK Funding Company
> Lloyds Court
> 78 Grey Street
> Newcastle upon Tyne
> NE1 6AF
> Registered in England and Wales: Number 3476201
> 
> **
> **


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


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



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: Oracle 11i

[April Wells]

We 
are having issues with reports server, too... I think it is 
Autoconfig.
 
Did 
YOU notice that you got a whole NEW set of services (are you on Win?) when you 
went auto config... FEATURE!!  Some of the new ones work sometimes, 
sometimes only the old ones will.
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   
>\<  
\  
>\<  \ 
Few people really enjoy the simple 
pleasure of flying a kite Adam 
Wells age 11 

  -Original Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003 
  9:49 AMTo: April Wells; [EMAIL PROTECTED]Subject: RE: 
  Oracle 11i
  We went from 11.5.6 to 11.5.9.  As part of upgrade we implemented 
  autoconfig.  Initiallly could not print.  Then put on a patch for 
  grants and now can print - patch was titled fixes for non-standard 
  schemas.  Still can not access report server.  Don't know if due to 
  autoconfig or 11.5.9 since did not stop in between.
   
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
  781-4204>>> [EMAIL PROTECTED] 9/10/03 11:39:25 AM 
  >>>
  Anything break badly? 
  We are going to be starting in about a month down the 11.5.8 
  -> 11.5.9 road. 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas   /\  /   \ / 
  \ \ /   \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: 
  Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 11i 
  Ha! Tell me about it. I'm at the tail end of an upgrade. Just 
  applying the unified driver to bring all of the 
  products bang up to date. Just when you think you're 
  on the home straight. A driver file with 920,000 lines 
  that starts 71,000 scripts. 
  It's enough to start me drinking! 
  Mike 
  -Original Message- Sent: 10 
  September 2003 14:49 To: Multiple recipients of list 
  ORACLE-L 
  Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  
  If you start with 11.5.8 or below, you'd also want to 
  download the 11.5.9 patch anyway, which is a further 
  2.5Gb or so... 
  on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at 
  [EMAIL PROTECTED] wrote: 
  > Tanel, > the 11.5.9 docs ask 
  you to get in touch if you're interested in a DVD > 
  release. It doesn't sound like it's actually available but they must be 
  > gauging interest for future releases. > > Cheers, > 
  Mike > > -Original 
  Message- > Sent: 10 September 2003 02:50 
  > To: Multiple recipients of list ORACLE-L 
  > > >  > > You can't download 11i, you can order 
  it for evaluation from Oracle, it's > about 50 CD 
  (when the heck will they put it on DVD?), > 
  > > Cheers, 
  > Tanel. > > > > 
   
  ** > ** 
  > E mail Disclaimer > 
  > You agree that you have read and understood this 
  disclaimer and you agree to > be bound by its terms. > 
  > The information contained in this e-mail and any 
  files transmitted with it (if > any) are confidential and intended for the addressee only.  
  If you have > received this  e-mail in error 
  please notify the originator. > > This e-mail and any attachments have been scanned for certain 
  viruses prior to > sending 
  but CE Electric UK Funding Company nor any of its associated companies > from whom this e-mail originates 
  shall be liable for any losses as a result of 
  > any viruses being passed on. > > No warranty of any kind is given in 
  respect of any information contained in 
  > this   e-mail and you should be aware that 
  that it might be incomplete, out of > date or incorrect. It is therefore essential that you verify all 
  such > information with us before placing any 
  reliance upon it. > > CE 
  Electric UK Funding Company > Lloyds Court 
  > 78 Grey Street > Newcastle 
  upon Tyne > NE1 6AF > 
  Registered in England and Wales: Number 3476201 > 
  >  
  ** > ** 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- Author: Tim Gorman   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  -- Please s

RE: Oracle 11i

[Jeffrey Beckstrom]

We went from 11.5.6 to 11.5.9.  As part of upgrade we implemented 
autoconfig.  Initiallly could not print.  Then put on a patch for 
grants and now can print - patch was titled fixes for non-standard 
schemas.  Still can not access report server.  Don't know if due to 
autoconfig or 11.5.9 since did not stop in between.
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204>>> [EMAIL PROTECTED] 9/10/03 11:39:25 AM 
>>>
Anything break badly? 
We are going to be starting in about a month down the 11.5.8 
-> 11.5.9 road. 
April Wells Oracle DBA/Oracle Apps 
DBA Corporate Systems Amarillo 
Texas   /\  /   \ / 
\ \ /   \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 
-Original Message- From: Hately, 
Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: 
RE: Oracle 11i 
Ha! Tell me about it. I'm at the tail end of an upgrade. Just 
applying the unified driver to bring all of the products 
bang up to date. Just when you think you're on the home 
straight. A driver file with 920,000 lines that starts 
71,000 scripts. 
It's enough to start me drinking! 
Mike 
-Original Message- Sent: 10 
September 2003 14:49 To: Multiple recipients of list 
ORACLE-L 
Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  
If you start with 11.5.8 or below, you'd also want to 
download the 11.5.9 patch anyway, which is a further 
2.5Gb or so... 
on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at 
[EMAIL PROTECTED] wrote: 
> Tanel, > the 11.5.9 docs ask you 
to get in touch if you're interested in a DVD > 
release. It doesn't sound like it's actually available but they must be 
> gauging interest for future releases. > > Cheers, > 
Mike > > -Original 
Message- > Sent: 10 September 2003 02:50 
> To: Multiple recipients of list ORACLE-L > > > 
 > 
> You can't download 11i, you can order it for 
evaluation from Oracle, it's > about 50 CD (when the 
heck will they put it on DVD?), > > > Cheers, > 
Tanel. > > 
> >  
** > ** > E mail Disclaimer > > You agree that you have read and understood this disclaimer and you 
agree to > be bound by its 
terms. > > The information 
contained in this e-mail and any files transmitted with it (if > any) are confidential and intended for 
the addressee only.  If you have > received 
this  e-mail in error please notify the originator. > > This e-mail and any attachments have 
been scanned for certain viruses prior to 
> sending but CE Electric UK Funding Company nor any of its 
associated companies > from 
whom this e-mail originates shall be liable for any losses as a result of > any viruses being passed 
on. > > No warranty of any 
kind is given in respect of any information contained in > this   e-mail and you should be 
aware that that it might be incomplete, out of 
> date or incorrect. It is therefore essential that you 
verify all such > information with us before placing 
any reliance upon it. > > 
CE Electric UK Funding Company > Lloyds Court 
> 78 Grey Street > Newcastle upon 
Tyne > NE1 6AF > 
Registered in England and Wales: Number 3476201 > 
>  
** > ** 
-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net 
-- Author: Tim Gorman   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California    
-- Mailing list and web hosting services - 
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- Author: Hately, Mike 
(LogicaCMG)   INET: [EMAIL PROTECTED] 

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

  
  
The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, 

AW: making me crazy

[Kulev, Milen]

Title: RE: making me crazy



Hi Paula !
You have 2 options :
1) provide symlink to your "listener.ora" 
file.
2) In case you start  the listener process via sth like thata 
"BASH_PROMPT> lsnrctl start " you can "fake" the 
shell
with the command " TNS_ADMIN=/tmp  lsnrctl start" ( no export of 
TNS_ADMIN  varaible ! ). thus the variable 
TNS_ADMIN
will be used ONLY for the invocation of the 
current command (in this case lsnrctl start) . Here is a 
small proof of the concept  ( under RHAS 2.1, Orac 9.2.0):) 

-
11338 access("/tmp/ldap.ora", F_OK) = -1 ENOENT 
(No such file or directory)11338 
access("/oracle/o1/oracle/product/9.2.0/network/admin/ldap.ora", F_OK) = -1 
ENOENT (No such file or directory)11338 access("/tmp/listener.ora", 
F_OK) = 011338 open("/tmp/listener.ora", O_RDONLY) = 311338 fcntl64(0x3, 
0x2, 0x1, 0x2)   = 011338 
brk(0x81c2000)    
= 0x81c200011338 fstat64(3, {st_mode=S_IFREG|0644, st_size=713, ...}) = 
011338 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, 
-1, 0) = 0x40abc00011338 read(3, "# LISTENER.ORA Network Configura"..., 
4096) = 713
.
.
11340 rt_sigaction(SIGRT_2, {SIG_DFL}, NULL, 8) = 011340 
execve("/oracle/o1/oracle/product/9.2.0/bin/tnslsnr", 
["/oracle/o1/oracle/product/9.2.0/"...,"LISTENER", "-inherit"], [/* 36 vars 
*/]) = 011340 uname({sys="Linux", node="as1", ...}) = 
0
-
 
HTH. Milen 

  -Ursprüngliche Nachricht-Von: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 10. 
  September 2003 16:45An: Multiple recipients of list 
  ORACLE-LBetreff: RE: making me crazy
  Dealing with 2 Oracle Homes - one if which I need to run the 
  listener from and one in which I need to use the tnsnames.ora definitions from 
  and no I can't just copy the tnsnames.ora to the 1st Oracle Home.  Even 
  when I set the oracle home from which to run lsnrctl it tries to use the 
  listener.ora from the TNS_ADMIN home.  How can I make sure to explicitly 
  start the correct listener.ora?
  Thanks, Paula 

RE: question about migrating to 9i

[Jesse, Rich]

I was told by one Oracle instructor that new features of 9i, including
Oracle Managed Files, could allow you to create a viable production database
by simply typing "CREATE DATABASE" -- once the init.ora (SPFILE?) was
created and the hardware layed out properly.

Perhaps not something many will use, but it could be one of those good and
nasty over-simplified marketing tools.

:)

Rich

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


 
 -Original Message-
Sent: Tuesday, September 09, 2003 4:59 PM
To: Multiple recipients of list ORACLE-L


Im not going to physically do the migration, but I want to make sure certain
features are set up. Let me know if Im missing any of the basics(anything
that is a pain to add on my own later). 
 
Locally Managed tablespaces are the default right? 
Automatic Segment Allocation
Undo Tablespace
SPFILE
 
any other goodies Im forgetting? Just basic settings. rest I can do myself. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: Oracle 11i

[April Wells]

Title: RE: Oracle 11i





Anything break badly?


We are going to be starting in about a month down the 11.5.8 -> 11.5.9 road.


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 11i



Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the
unified driver to bring all of the products bang up to date. 
Just when you think you're on the home straight. A driver file with 920,000
lines that starts 71,000 scripts. 


It's enough to start me drinking!


Mike


-Original Message-
Sent: 10 September 2003 14:49
To: Multiple recipients of list ORACLE-L



Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  If you start with
11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which
is a further 2.5Gb or so...



on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED]
wrote:


> Tanel,
> the 11.5.9 docs ask you to get in touch if you're interested in a DVD
> release. It doesn't sound like it's actually available but they must be
> gauging interest for future releases.
> 
> Cheers,
> Mike
> 
> -Original Message-
> Sent: 10 September 2003 02:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> You can't download 11i, you can order it for evaluation from Oracle, it's
> about 50 CD (when the heck will they put it on DVD?),
> 
> 
> Cheers,
> Tanel.
> 
> 
> 
>

**
> **
> E mail Disclaimer
> 
> You agree that you have read and understood this disclaimer and you agree
to
> be bound by its terms.
> 
> The information contained in this e-mail and any files transmitted with it
(if
> any) are confidential and intended for the addressee only.  If you have
> received this  e-mail in error please notify the originator.
> 
> This e-mail and any attachments have been scanned for certain viruses
prior to
> sending but CE Electric UK Funding Company nor any of its associated
companies
> from whom this e-mail originates shall be liable for any losses as a
result of
> any viruses being passed on.
> 
> No warranty of any kind is given in respect of any information contained
in
> this   e-mail and you should be aware that that it might be incomplete,
out of
> date or incorrect. It is therefore essential that you verify all such
> information with us before placing any reliance upon it.
> 
> CE Electric UK Funding Company
> Lloyds Court
> 78 Grey Street
> Newcastle upon Tyne
> NE1 6AF
> Registered in England and Wales: Number 3476201
> 
>

**
> **


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


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


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



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept f

RE: Oracle 11i

[Hately, Mike (LogicaCMG)]

Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the
unified driver to bring all of the products bang up to date. 
Just when you think you're on the home straight. A driver file with 920,000
lines that starts 71,000 scripts. 

It's enough to start me drinking!

Mike

-Original Message-
Sent: 10 September 2003 14:49
To: Multiple recipients of list ORACLE-L


Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  If you start with
11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which
is a further 2.5Gb or so...


on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED]
wrote:

> Tanel,
> the 11.5.9 docs ask you to get in touch if you're interested in a DVD
> release. It doesn't sound like it's actually available but they must be
> gauging interest for future releases.
> 
> Cheers,
> Mike
> 
> -Original Message-
> Sent: 10 September 2003 02:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> You can't download 11i, you can order it for evaluation from Oracle, it's
> about 50 CD (when the heck will they put it on DVD?),
> 
> 
> Cheers,
> Tanel.
> 
> 
> 
>

**
> **
> E mail Disclaimer
> 
> You agree that you have read and understood this disclaimer and you agree
to
> be bound by its terms.
> 
> The information contained in this e-mail and any files transmitted with it
(if
> any) are confidential and intended for the addressee only.  If you have
> received this  e-mail in error please notify the originator.
> 
> This e-mail and any attachments have been scanned for certain viruses
prior to
> sending but CE Electric UK Funding Company nor any of its associated
companies
> from whom this e-mail originates shall be liable for any losses as a
result of
> any viruses being passed on.
> 
> No warranty of any kind is given in respect of any information contained
in
> this   e-mail and you should be aware that that it might be incomplete,
out of
> date or incorrect. It is therefore essential that you verify all such
> information with us before placing any reliance upon it.
> 
> CE Electric UK Funding Company
> Lloyds Court
> 78 Grey Street
> Newcastle upon Tyne
> NE1 6AF
> Registered in England and Wales: Number 3476201
> 
>

**
> **

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

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

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

RE: Oracle 11i

[Jesse, Rich]

Doesn't this go back to the "Application DBA" vs. "Production DBA"
discussion?  I've talked with folks that employ a "Patch DBA" -- all they do
is manage 11i patches.  Fun!

Rich

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


> -Original Message-
> From: Tim Gorman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle 11i
> 
> 
> Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb.  If 
> you start with
> 11.5.8 or below, you'd also want to download the 11.5.9 patch 
> anyway, which
> is a further 2.5Gb or so...
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: Oracle, Perl, and our List members

[Mladen Gogala]

Perl? Isn't that Pathologically Eclectic Rubbish Lister? Why would 
anyone want use perl besides the fact that it's very portable, it's fast,
it's practical, it has bindings for ton of software and is very, very well 
documented indeed? The problem with perl is that it's free and management 
doesn't like that geekish freware stuff. They much prefere shelling out
few grands ("10g") to a tool vendor. An explanation why is that so can
be found at http://www.dilbert.com.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Ron Rogers
> Sent: Wednesday, September 10, 2003 10:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle, Perl, and our List members
> 
> 
> List,
>  A nice tidbit into the contents of the book. 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> PERL MEETS ORACLE | Andy Duncan & Jared Still
> 
> Perl is a very powerful tool for Oracle database 
> administrators, but too few DBAs realize how helpful Perl can 
> be in managing, monitoring, and tuning Oracle9i, Oracle8i, 
> and earlier databases. This chapter from the book "Perl for 
> Oracle DBAs" (O'Reilly) introduces the topic, describes 
> PERL's origins and advantages, defines Oracle's PERL 
> architecture, and argues that PERL is a particularly useful 
> language for Oracle DBAs to learn.
> 
> >> CLICK for the full tip...
> http://www.searchOracle.com/tip/1,289483,sid41_gci926018,00.html 
> 
> Ron
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ron Rogers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

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

RE: Does the 9iR2 Installer delete patch files?

[Jesse, Rich]

Thanks for the suggestion.  And perhaps it explains what I'm seeing.  I
tried the 9.2.0.4 installer many times between two installs.  Each time the
2.2.0.18 ("new") installer crashed and there was no help on MetaLink nor
Goo5le (Happy 5yrs!).  Out of desperation I tried the 9.2.0.1 installer and
it worked.  I don't know why I didn't see this before (too obvious???), but
that could sure explain it.  Perhaps I need to verify my installer install
on each RAC node.

Thanks again Mehish!

Rich

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


> -Original Message-
> From: Yechiel Adar [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 7:12 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Does the 9iR2 Installer delete patch files?
> 
> 
> Hello Jesse
> 
> I do not know if this apply also to Linux but:
> I am installing now 9.2.0.4 on windows and I saw that you 
> need to install
> the new installer first on all the nodes of the RAC first.
> Then you can install the patch.
> 
> Yechiel Adar
> Mehish
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 03, 2003 5:54 PM
> 
> 
> > Hey all,
> >
> > During the instal of 9iRAC on RH9, the instructions say to 
> install the
> > 9.2.0.1 software, then apply the 9.2.0.4 patch separately to the
> Installer,
> > OCM, and finally to the RAC software itself.  This is my second time
> through
> > and both times there were files in the cpio-exploded patch that had
> > disappeared somewhere between the patching of the Installer 
> and the RAC
> > software.  This time I kept the cpio file of the patch so I 
> didn't need to
> > download it again.
> >
> > I should probably have taken down some of the names of the 
> files that came
> > up as "File not found" errors during the RAC install, but 
> there were so
> many
> > during my first install, I figured I had accidentally "rm"d 
> a directory.
> >
> > Anyone know what's up with the Installer?  "Or is it just 
> me?" he axes,
> > praying for the former...
> >
> > Rich
> >
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: HTML Report Question

[Orr, Steve]

Hmmm... Try making this the first line followed by a blank line:

"Content-Type: text/html

"


Just guessing...


-Original Message-
Sent: Tuesday, September 09, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L


Hi DBAs!

I am trying to generate an HTML report, and send it through the 
mail in HTML format.  Only one problem...Outlook thinks it's text not
html, even though the first line of the report is "".

I'm generating the report with...
 sqlplus -silent -markup "HTML ON"
...and then using mailx to send the output to my client mailbox.

Any suggestions as to how I can make the mail come in as HTML?

Thanks,
Mike


---

===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

RE: what is a materilized view ?

[Henry Poras]

The opposite of an immaterial view :)

Henry


-Original Message-
Veeraraju_Mareddi
Sent: Wednesday, September 10, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L


Dear Freinds, 

what is a materilized view ? what is the use of it and how to create it. 

Any docs or notes or white papers will be helpful.

TIA,
Rajuveera
** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle 11i

[Tanel Poder]

About half of those disks are needed for standard 11i install, other stuff
is various additional Oracle software which you might want to use (and pay
the licenses for)..

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 4:29 PM


> Someone on this list ordered me a CD Kit of the 10i Applications Suite,
it's
> 52 CDs.
>
> You may be able to order one from the OracleStore.
>
> Two years ago I couldn't do that from the oracle.com site because they
only
> accepted U.S. States and Zip Codes... I called a 1-800 number they had
> suggested for Oracle Canada.  The person who answered didn't seem to know
> what to do, it was the first time she had received a request for 10i CDs.
>
> I contacted them later again, it went nowhere.
>
> Finally, someone on the list ordered me a set, and I refunded him the
> amount.
>
> When I received the kit I realized what a behemoth the suite is, 52 CDs
!!!
>
> Patrice.
>
> -Original Message-
> Sent: Wednesday, September 10, 2003 12:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> The 11i docs, however, are available from docs.oracle.com. Latest version
is
> 11.5.9.
>
> Tanel.
>
> > You can't download 11i, you can order it for evaluation from Oracle,
it's
> > about 50 CD (when the heck will they put it on DVD?), but you have to be
a
> > fairly serious company for getting the eval.
> >
> > Cheers,
> > Tanel.
> >
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 10, 2003 5:24 AM
> >
> >
> > > I would like to evaluate Oracle 11i.  Could any body let me know what
> are
> > > pros and cons between Oracle 11i and Oracle Collaboration Suite?  Is
> there
> > > any place where I can download Oracle 11i and related documents for
> trial?
> > > I can not find them on Oracle web site.
> > >
> > > Thanks for any inputs in advance.
> > >
> > > Nancy
> > >
> > > _
> > > Send and receive larger attachments with Hotmail Extra Storage.
> > > http://join.msn.com/?PAGE=features/es
> > >
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Anna Li
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Tanel Poder
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 

RE: making me crazy

[Jack van Zanen]

Maybe copying isn't an option, but if on NIX how about putting a symbolic
link in or tnsnames in the /etc (checked before $ORACLE_HOME/network)
directory and not set TNS_ADMIN


Jack
-Original Message-
Sent: Wednesday, September 10, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


Dealing with 2 Oracle Homes - one if which I need to run the listener from
and one in which I need to use the tnsnames.ora definitions from and no I
can't just copy the tnsnames.ora to the 1st Oracle Home.  Even when I set
the oracle home from which to run lsnrctl it tries to use the listener.ora
from the TNS_ADMIN home.  How can I make sure to explicitly start the
correct listener.ora?
Thanks, 
Paula 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

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

Oracle, Perl, and our List members

[Ron Rogers]

List,
 A nice tidbit into the contents of the book. 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PERL MEETS ORACLE | Andy Duncan & Jared Still

Perl is a very powerful tool for Oracle database administrators, but
too few DBAs realize how helpful Perl can be in managing, monitoring,
and tuning Oracle9i, Oracle8i, and earlier databases. This chapter
from the book "Perl for Oracle DBAs" (O'Reilly) introduces the topic,
describes PERL's origins and advantages, defines Oracle's PERL
architecture, and argues that PERL is a particularly useful language
for Oracle DBAs to learn.

>> CLICK for the full tip... 
http://www.searchOracle.com/tip/1,289483,sid41_gci926018,00.html 

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

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