Oracle 9i on windows Advance Server is not starting Automatically

[Praveen Sahni]

We have a small problem.

Oracle has been installed on Windows Advanced Server.
Other software on the system include Microsoft Cluster Server.
Oracle software has been installed on the local drive (E:) using silent
installation.
Database has been installed on Shared Disk (RAID) (D:) using scripts.
I have created SID, password (using ORADIM and ORAPWD utility) and SPFILE.

My problem is, whenever I restart the system Oracle is not connecting until
I restart the Oracle service in Windows Service window.

connect System/manager gives the following error
ORA-01034 ORACLE not available
ORA-27101 SHARED MEMORY REALM DOES NOT EXISTS.

Database on cluster is not start automatically. Only service shows started
but DB is not mounted.On restarting from services panel it mounts and Opens.

Please let me know if any of us has faced this problem.

Please let me know if we need some more information.

Thanks in advance 
Praveen





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

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

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

RE: Does Oracle 9iAS only run on Apache?

[hemantchitale]

Well. you could look at Note 134284.1 on MetaLink.
I've never tried iAS with anything other than Oracle's Apache distribution
so I can't say if this document suffices.
[You could also look at Note 132466.1  on the Oracle Plug-In for IIS to
run Oracle PLSQL applications through IIS. Again, I've not done it].


Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


[EMAIL PROTECTED] 02/03/2002 03:08 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

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

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: RE: Does Oracle 9iAS only run on Apache? 

   

   

   







What does "Hear, hear." mean? Do you have a constructive(note the 1st 3
letters CON)  reply to the original question?
The employer uses IIS and does not want to support other servers. If Oracle
9iAS is not supported then this is the end of the question and end of
thread.

Rick




"Boivin, Patrice

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

mpo.gc.ca>   Subject: RE: Does Oracle
9iAS only run on Apache?
Sent by:

[EMAIL PROTECTED]



03/01/2002 01:18

PM

Please respond to

ORACLE-L







Hear, hear.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Friday, March 01, 2002 12:30 PM
To:Multiple recipients of list ORACLE-L

Rick,

Why do you ask?  At a former employer, we were being pressured to use a
different
webserver for entirely different reasons.  We eventually concluded that
the ones asking
the question were technically impaired and began ignoring them.

While I believe that you can do this, Oracle won't support your iAS
installation if you do.

It's a fair amount of work to iAS setup and running the way you want
without trying  to give it
a heart transplant in the process.  Doing so will likely also require
regular infusions
anti-rejection drugs ( your time ).

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/01/02 07:03 AM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Does Oracle 9iAS only run on Apache?


Hi All,

Will Oracle 9iAS run on other servers other than Apache? If so which ones
and are they supported by Oracle?
Does anyone have any experience running on other servers? success/failure
stories.

Thanks
Rick


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

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

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



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

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

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

RE: Old Chestnut: Tablespace Fragmentation

[hemantchitale]

Darren,

To check if extents are contiguous query DBA_EXTENTS.


select file_id, block_id, blocks, block_id+blocks-1 from dba_Extents
where segment_name = '&which_table'
and owner='&which_schema'
order by extent_id


Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"Browett, Darren" <[EMAIL PROTECTED]>  02/03/2002 12:48 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

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

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: RE: Old Chestnut:  Tablespace Fragmentation  

   

   

   






Is there anyway to check that the extents are contiguous ?

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: February 28, 2002 2:48 AM
To: Multiple recipients of list ORACLE-L




If you have only 1 Table in that Tablespace and only 1 File on that disk,
even if you had multiple extents, you might expect them to be contiguous.
Then, the only issue would be that the extent size should be a proper
multiple
of db_block_size*db_file_multiblock_read_count (or max_io_size).

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Bill Buchan <[EMAIL PROTECTED]> 27/02/2002 08:43 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L


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

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)

 Subject: Old Chestnut:  Tablespace Fragmentation














I know this one has been done to death:  use uniform extents to avoid
fragmentation; multiple extents don't hurt (within limits).

But what if:

Data Warehouse, one big table on a single disk, full table (batch) scan, no

concurrent transactions on the database (so no contention for the disk), no

fragmentation at the file system level, initially empty buffer cache
(startup), read-only operation so DBWR isn't doing anything on this
disk.  Basically I want to read one data file from end to end.  Surely it
would make sense to have the disk read moving smoothly from one end of the
disk to the other rather than bouncing about all over the place as it may
do with multiple extents "randomly" allocated.

Any thoughts?

Thanks
- Bill.

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

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

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





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

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

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

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

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





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

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

Re: Names server

[Henrik Ekenberg <[EMAIL PROTECTED]>]

Hi,

Works fine for us on Solaris 8 Oracle 8.1.7
20 Dbs in the Nameserver.

Regards
Henrik E.

-- 




On Mon, 4 Mar 2002, Yahoo wrote:

-!-Hi ALL:
-!-Is any one using names server out there?  How the it works?  Any
-!-infor are wellcome.
-!-

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

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

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

Re: Linux for Big(ish) Databases

[Henrik Ekenberg <[EMAIL PROTECTED]>]

Hi,

Why using Linux on Sparc ? Solaris is free up to 8 cpus.
Or is the Oracle price different ?

Regards
HEnrik
-- 

E-mail :[EMAIL PROTECTED]  Fax +46 (0)8 410 78 501
Sweden


On Mon, 4 Mar 2002, Steven Lembark wrote:

-!-
-!-
-!-> We've got a new database to put together.  OLTP, 100-200 users, ~250Gb
-!-> data.  We haven't decided on a platform for this yet.  Is Intel/Linux
-!-> worth considering for this size of thing?
-!-
-!-No reason why not. Might also want to consider linux
-!-on a Sparc or Alpha.
-!-
-!-
-!-
-!---
-!-Steven Lembark   2930 W. Palmer
-!-Workhorse Computing   Chicago, IL 60647
-!-+1 800 762 1582
-!-

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

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

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

Re: Clash of the DBs in eWeek

[Henrik Ekenberg <[EMAIL PROTECTED]>]

Hi,

I have also an other question.
Do you you why they did not test postgressql ?

Regards
Henrik

-- 
---


E-mail :[EMAIL PROTECTED]



On Thu, 28 Feb 2002, Jesse, Rich wrote:

-!-Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled
-!-"Database Clash"?
-!-
-!-The pretty graphs say that their tests showed that Oracle and MySQL rocked
-!-the other DBs they tested (including MS SQueaL Server).  So I investigated.
-!-I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
-!-Download our configuration and tuning scripts".
-!-
-!-According to the Oracle setup docs in there, they're NOT using MTS and
-!-processes in init.ora is 150.  So then how did they test for 1000
-!-"concurrent Web clients"?
-!-
-!-Anyone have a thought?
-!-
-!-
-!-Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-!-

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

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

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

RE: # of datafiles per tablespace

[Rajesh . Rao]

And yeah!!! Restore. Imagine the loss on one datafile of 700 Mb, and one of
50Mb.

Raj




   
 
Rajesh Rao 
 
 To: [EMAIL PROTECTED]  
 
March 05, 2002   cc:   
 
12:45 AM Subject: RE: # of datafiles per 
tablespace(Document link: Rajesh Rao)  
   
 
   
 



If it were a data or an index tablespace, laying out a tablespace across
multiple datafiles could help in striping data or partitioning. And as
Kirti said, could be to balance the I/O across multiple disks.

Raj




   
   
"Deshpande, Kirti" 
   

rizon.com> cc: 
   
Sent by:   Subject: RE: # of datafiles per 
tablespace 
[EMAIL PROTECTED]   
   
   
   
   
   
March 04, 2002 
   
10:33 PM   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Other than I/O load balancing.. I can't see any other reason.

But again, why those tiny 50MB files?
Are these on the same disk? I hope not..

If there is no I/O bottleneck issues,  I would build just one 700MB file.
And then monitor how it works out..

- Kirti

-Original Message-
Sent: Monday, March 04, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L


OK, I know we had the debate already but lets have another go at it.

Say you got a tablespace, lets call it RBS and its for rollbacks.
Now, for what reason would you create a 500M file and 4 50M files
for this puppy as opposed to just one file.  I just cannot see the
reasoning
for this at all.  None.  Natta.  Zilch.

So educate me please if someone out there knows a legit reason they
would do this.

Lets assume for the sake of argument that disk size and mount point
size is not a limitation.  Space available to me on any one mount point
is unlimited.

___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

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

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

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

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

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

RE: # of datafiles per tablespace

[Rajesh . Rao]

If it were a data or an index tablespace, laying out a tablespace across
multiple datafiles could help in striping data or partitioning. And as
Kirti said, could be to balance the I/O across multiple disks.

Raj




   
   
"Deshpande, Kirti" 
   

rizon.com> cc: 
   
Sent by:   Subject: RE: # of datafiles per 
tablespace 
[EMAIL PROTECTED]   
   
   
   
   
   
March 04, 2002 
   
10:33 PM   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Other than I/O load balancing.. I can't see any other reason.

But again, why those tiny 50MB files?
Are these on the same disk? I hope not..

If there is no I/O bottleneck issues,  I would build just one 700MB file.
And then monitor how it works out..

- Kirti

-Original Message-
Sent: Monday, March 04, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L


OK, I know we had the debate already but lets have another go at it.

Say you got a tablespace, lets call it RBS and its for rollbacks.
Now, for what reason would you create a 500M file and 4 50M files
for this puppy as opposed to just one file.  I just cannot see the
reasoning
for this at all.  None.  Natta.  Zilch.

So educate me please if someone out there knows a legit reason they
would do this.

Lets assume for the sake of argument that disk size and mount point
size is not a limitation.  Space available to me on any one mount point
is unlimited.

___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

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

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

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

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

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




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

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

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

RE: Read Consistency & ITL's

[K Gopalakrishnan]

Rajesh,

Other than the Transaction ID,UBA and Commit SCN (or csc.. Cleanout System
Change)
there is something called 'lock byte' in the ITL entry. THis gives the
details
about the locked (!!) rows. I have dumped few blocks and have an half
written note
with me which explains the lock byte and csc behaviors. I will write to you
offline
after completing the note  once I get some free time.

In a nutshell 'lock byte' and 'csc' is the key here along with the UBA to
get the
read consistent view for the multi update (!) block transactions.

(I have an article in my site which gives an overview about the
transactions, locking
and ITL entry. Have a look there if you have not seen that already!
http://www.geocities.com/kgkrish/transactions.html)

Coming to second  part of your question,

Fixed_tables (views or objects) will not have any information in the
dictionary
and their definitions are coming from the rdbms kernel. So they will not
have a valid
object# or the associating details with them. So that might be the reason
for your
2030 errors (I THink!!)






Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L


Hello Gurus,

As I understand it. In order to provide a read consistent view of the data
while reading a data block, Oracle looks at the SCN in the block header,
and compares it to the snapshot of the SCN taken when the read commenced.
If the Snapshot SCN is less than the SCN in the block header, the query is
directed to read from the rollback segments.

For any transaction that modifies a block, the ITL among other things, also
stores the commit SCN and the address to the transaction table in the
rollback segment. Assume that the block has just one ITL. This ITL can be
reused once the transaction is completed. Assume it is. That is, two
transactions have performed updates on the block since our read commenced.
If so is the case, how does Oracle know which rollback segment to look at?
I am assuming it still looks at the ITL, rolls it back, sees that it needs
to rollback further, looks at the ITL in the rolled back block, and
rollsback further, and so on, until it can reconstruct the data block at an
SCN lower than the snapshot SCN. Is that right?

My second question is, what happens if the data block has two ITL's, both
marked with SCN's greater than when the read commenced. Which ITL does
Oracle look at to get the address of the rollback segment? Is it the one
with the least SCN??

And also, my previous question, remains unanswered so far? Why does Oracle
not allow one to grant select privileges on the fixed tables to any other
user?

Thanks
Raj

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

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

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


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

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

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

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

RE: Oracle 9i upgrade exam.

[Abdul Aleem]

Try this site
http://www.oracle-base.com/Articles/9i/Articles9i.asp


 -Original Message-
Sent:   Tuesday, March 05, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle 9i upgrade exam.

Dear all,
I want to prepare my self for oracle 9i upgrade exam . Much appreciated If
anyone can tell me any sites or books  for the preparation of this exam,

Regards 
Chuan 




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

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

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

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

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

Re: Names server

[Nikunj Gupta]

Hi All,



Following is my observation on UNIX Server.  Except for this CLIENT
Connections and individual connections from around the world and servers
work without any problems.

Just to add.. With Names Server life and management is easy...

-

This test was performed with ORACLE NAMES CONFIGURED on the SAME SYSTEM...
and using the SAME ORACLE HOME / VERSION.(8.1.7)

I had 5 background processes to run more or less concurrently using a simple
SQL Script.. such as select sysdate from dual;

These scripts were executed almost 20 times.. and here is approximated
result..

Here are the success rates for each of the 5 processes that try to connect:

First spawned process: 60% success rate.
Second process: 20%
Third process: 25%
Fourth process: 45%
Fifth process: 55%
Overall success rate: 41%

Never did all the 5 processes were successful.


NOW...

If I added a sleep 1 command in shell script before each of the 5 scripts..
success rate was 100%.

Similarly,

Instead of USING ORACLE NAMES.. I changed SQLNET to use TNSNAMES.. and
performed similar test WITHOUT SLEEP 1.. (i.e. performed the original test
which failed with ORACLE NAMES)...

RESULT FOR TNSNAMES : 100 % Success.

NOTE : Only change was TNSNAMES used instead of ONAMES.

Any suggestions / parameters that need to be verified ?



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 07:23 PM


> We use Oracle Names big time.
> Our approach is to keep using it until it *really* does not come on the
> Install CD.
> It will be a mistake to get rid of something that has now stabilized very
> well.
> - Kirti
>
> -Original Message-
> Sent: Monday, March 04, 2002 4:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Completely removing names from Oracle would be a mistake IMO.
>
> Reason:  Name is fairly easy to implement,  LDAP is anything but.
>
> Jared
>
>
>
>
>
> "Freeman, Robert " <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 03/04/02 01:38 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:RE: Names server
>
>
> Names server is depreciated in 9i, but still there.
> They were going to remove it, but I think there was a bit of a backlash,
> so
> they have delayed
> the removal.
> OID (LDAP) is the replacement.
>
> We use names server here, have found it to be pretty stable and reduced
> tnsnames.ora
> administration nicely.
>
> RF
>
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Monday, March 04, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Names server will be obsolete in 9i, I think.
>
> -Original Message-
> Sent: Monday, March 04, 2002 11:33 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi ALL:
> Is any one using names server out there?  How the it works?  Any infor
> are wellcome.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> t

RE: # of datafiles per tablespace

[rabbit]

In a UNIX system it is better to have more small size datafiles than a few
or one large datafile: The reason is that UNIX aquires an exclusive file
write lock and therefore if you use multiple files you will avoid a
situation where multiple simultaneous writes to data files become
serialized and consequently reduce I/O performance: For example instead of
one 2GB Data file , split it into 8 250mb:
By the way I am addressing OLTP type systems with this e-mail


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

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

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

Oracle 9i upgrade exam.

[Chuan Zhang]

Dear all,
I want to prepare my self for oracle 9i upgrade exam . Much appreciated If anyone can 
tell me any sites or books  for the preparation of this exam,

Regards 
Chuan 




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

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

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

RE: # of datafiles per tablespace

[Deshpande, Kirti]

Other than I/O load balancing.. I can't see any other reason. 

But again, why those tiny 50MB files? 
Are these on the same disk? I hope not.. 

If there is no I/O bottleneck issues,  I would build just one 700MB file.
And then monitor how it works out.. 

- Kirti 

-Original Message-
Sent: Monday, March 04, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L


OK, I know we had the debate already but lets have another go at it.

Say you got a tablespace, lets call it RBS and its for rollbacks.
Now, for what reason would you create a 500M file and 4 50M files
for this puppy as opposed to just one file.  I just cannot see the reasoning
for this at all.  None.  Natta.  Zilch.

So educate me please if someone out there knows a legit reason they
would do this.

Lets assume for the sake of argument that disk size and mount point
size is not a limitation.  Space available to me on any one mount point
is unlimited.

___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

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

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

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

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

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

RE: # of datafiles per tablespace

[Kimberly Smith]

That being said is there anything wrong with having one 4G data
file for a tablespace.  I personally cannot think of any.  There
were the days when 2G was the limit but that sure isn't the case
anymore.  

The only thing I can think of is for backups.  However, I am always
going to backup on at least the tablespace level so if I have
one file or multiple files I still need to get them all.  I don't
know if RMAN has some special feature that turns out it makes sense
to backup just one data file of a tablespace that has multiple
data files but I sure can't think of any good reason.

I just randomly picked RBS but I am seeing the same case on
data tablespaces as well.

-Original Message-
Carmichael
Sent: Monday, March 04, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L


no reason. I can see creating multiple files under those conditions
only because you want to keep files to a specific size.

Now, I did once find that the rollback datafiles were a bottleneck on a
system I had. So we built TWO rollback tablespaces, with datafiles on
different mount points etc and the rollback segments divided between
the two tablespaces.

cleared up that bottleneck like a dream


other than that though.. why?


--- Kimberly Smith <[EMAIL PROTECTED]> wrote:
> OK, I know we had the debate already but lets have another go at it.
> 
> Say you got a tablespace, lets call it RBS and its for rollbacks.
> Now, for what reason would you create a 500M file and 4 50M files
> for this puppy as opposed to just one file.  I just cannot see the
> reasoning
> for this at all.  None.  Natta.  Zilch.
> 
> So educate me please if someone out there knows a legit reason they
> would do this.
> 
> Lets assume for the sake of argument that disk size and mount point
> size is not a limitation.  Space available to me on any one mount
> point
> is unlimited.
> 
> ___
> Kimberly Smith
> Portland, OR
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Names server

[Deshpande, Kirti]

We use Oracle Names big time. 
Our approach is to keep using it until it *really* does not come on the
Install CD. 
It will be a mistake to get rid of something that has now stabilized very
well. 
- Kirti

-Original Message-
Sent: Monday, March 04, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L


Completely removing names from Oracle would be a mistake IMO.

Reason:  Name is fairly easy to implement,  LDAP is anything but.

Jared





"Freeman, Robert " <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 01:38 PM
Please respond to ORACLE-L

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


Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, 
so
they have delayed
the removal.
OID (LDAP) is the replacement.
 
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely.
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Names server will be obsolete in 9i, I think.

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


Hi ALL:
Is any one using names server out there?  How the it works?  Any infor
are wellcome.

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

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

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



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

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

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

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

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

Re: # of datafiles per tablespace

[Rachel Carmichael]

no reason. I can see creating multiple files under those conditions
only because you want to keep files to a specific size.

Now, I did once find that the rollback datafiles were a bottleneck on a
system I had. So we built TWO rollback tablespaces, with datafiles on
different mount points etc and the rollback segments divided between
the two tablespaces.

cleared up that bottleneck like a dream


other than that though.. why?


--- Kimberly Smith <[EMAIL PROTECTED]> wrote:
> OK, I know we had the debate already but lets have another go at it.
> 
> Say you got a tablespace, lets call it RBS and its for rollbacks.
> Now, for what reason would you create a 500M file and 4 50M files
> for this puppy as opposed to just one file.  I just cannot see the
> reasoning
> for this at all.  None.  Natta.  Zilch.
> 
> So educate me please if someone out there knows a legit reason they
> would do this.
> 
> Lets assume for the sake of argument that disk size and mount point
> size is not a limitation.  Space available to me on any one mount
> point
> is unlimited.
> 
> ___
> Kimberly Smith
> Portland, OR
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: EXTENTS?

[Rachel Carmichael]

sigh...

someone shoot me. I am spending WAY too much time being unemployed
these days. 

extents are made up of blocks. 

now I'll shut up before I embarrass myself anymore :)

Rachel


--- [EMAIL PROTECTED] wrote:
> > and I was off as well, if your extent size is less than the
> blocksize
> > then you can have more than one extent in a block (divide the block
> > size by the extent size and round DOWN)
> 
> Huh?
> 
> Jared
> 
> 
> 
> 
> 
> Rachel Carmichael <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 03/04/02 12:13 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: EXTENTS?
> 
> 
> nick, you're thinking segments not extents.
> 
> and I was off as well, if your extent size is less than the blocksize
> then you can have more than one extent in a block (divide the block
> size by the extent size and round DOWN)
> 
> in general though, extents are not usually sized as small as the
> database block size
> 
> 
> --- Nick Wagner <[EMAIL PROTECTED]> wrote:
> > I'm going to say 1. I don't think you can have multiple tables in
> the
> > same
> > DB block. 
> > 
> > -Original Message-
> > Sent: Monday, March 04, 2002 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi
> > If DB block size is 8k then how many extents in one db block?
> > Thanks
> > -Seema
> > 
> > 
> > 
> > _
> > Join the world's largest e-mail service with MSN Hotmail. 
> > http://www.hotmail.com
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > 
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Sports - sign up for Fantasy Baseball
> http://sports.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Secret maximum for INITRANS?

[K Gopalakrishnan]

Robert,

I guess you are looking in 'itc' in block dumps which shows the ITL Count.

And yes.. There is an upper bound for number of ITLs based on the block
size.
The transaction slots (and other headers) can not use the more than 50% of
the
space available  for data in the data block. Each ITL will take 24 bytes of
space
in variable header part of the data block.

In 2K block (2048) 50 % is 1024 Bytes. In this we can not use the first 48
bytes
(fixed headers in cache layer and TX data layers uses them. So the space
available
for ITLs will be 976 bytes.

So you can get round (976/24) ~41 ITL slots for 2K block size.  If you set
INITRANS
more than 41 they are simply ignored and only 41 ITLS are created in that
block.



Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Eskridge
Sent: Monday, March 04, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L


I'm still messing with my enqueue waits on an insert. I'm now able to
recreate it on a test database by throwing enough simultaneous inserts
at my table. I was going to make sure which of the tables/indexes was
actually causing the waits by individually raising the INITRANS above
what they would naturally expand to, and see how the waiting sessions
responded.

I was hitting it with 50 simultaneous inserts and usually had 10
sessions go into an enqueue wait until the 40 sessions committed or
rolled back.  So I was going though the indexes and then tables
raising the INITRANS to 50 to see which one(s) made a difference.
None of them made a difference.

So I dumped blocks that had been populated only during this exercise.
Invariably, there were 0x29 Itl slots.  Is there something out there
that would limit the Itl entries to 41 even when MAXTRANS=255?  Is
there some secret bound based on block size?  Ours is 2k (which I
figure is part of the problem).

Other vital stats:  8.0.5 on Solaris 2.7.


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

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

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


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

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

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

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

RE: EXTENTS?

[Rachel Carmichael]

> you create the db (although I heard that different tablespaces can
> have
> different Db Block sizes in 9i - correct anybody?)

yep I've even tested it :)


--- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote:
> Seema,
> 
> You got it backwards.
> 
> If Db Block Size is 8k, and you create a table with it's initial
> extent of
> 32k, the you have 4 db blocks making up the extent.
> 
> An Extent is composed of one or more Db Blocks.  A Db Block is
> defined when
> you create the db (although I heard that different tablespaces can
> have
> different Db Block sizes in 9i - correct anybody?)
> 
> Hope this helps.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 1:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: SSL and non-SSL requests on same Apache server in 9iAS?

[hemantchitale]

Read section 2.2 of Note  123718.1.


Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"Ben Poels" <[EMAIL PROTECTED]> 05/03/2002 06:03 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

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

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: SSL and non-SSL requests on same Apache server in 9iAS?  

   

   

   






Hi,

I want to host SSL and non-SSL requests on one physical server
running one 9iAS.

After installing 9iAS the httpd.conf file specifies by default
that it is listening on port . Later on in httpd.conf it
has an SSL directive that says it's listening on port 80 and 443.
Does this mean that this one Apache server can service non-SSL
requests on  and SSL requests on 443 at the same time?

There is a document on Metalink(135231.1) that describes how to run two
Apache servers in one 9iAS home. Again what is not clear to me
is whether or not one could be handling SSL and the other non-SSL.

Anyone have any recommendations on how to do this? I may also be asked
to host 40-bit and 128-bit encryption on the same web site. Again any
recommendations?

Thanks.

==
 Ben Poels - Senior Technical Analyst - Queen's University at Kingston
 Phone: 613.533.2449  Fax: 613.533.2168  Email: [EMAIL PROTECTED]
==

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

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

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




[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]

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

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

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

OT: X server on Win NT

[Jan Pruner]

http://www.linuxnetmag.com/en/issue5/m5xserver1.html

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

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

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

# of datafiles per tablespace

[Kimberly Smith]

OK, I know we had the debate already but lets have another go at it.

Say you got a tablespace, lets call it RBS and its for rollbacks.
Now, for what reason would you create a 500M file and 4 50M files
for this puppy as opposed to just one file.  I just cannot see the reasoning
for this at all.  None.  Natta.  Zilch.

So educate me please if someone out there knows a legit reason they
would do this.

Lets assume for the sake of argument that disk size and mount point
size is not a limitation.  Space available to me on any one mount point
is unlimited.

___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

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

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

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

RE: Sun Cluster and VCS failover

[hemantchitale]

I would think 12 to 15 minutes still too high.  Damagement would generally
specify
a max of 5 minutes.

Have you found out why it takes 12 to 15 minutes ?  Do the File Systems
take so long or
does the Instance Recovery take so long ?  Do you have to put a "sleep" in
the startup
scripts  [when I setup a failover cluster for Oracle Apps with Oracle Web
Application Server 3.0.2,
I put in a sleep of 30seconds for the Web server -- WAS302 has to have the
physical host-name
hardcoded in the wrb.app file so I maintained two copies of the file and
the startup
script would copy in the correct one, depending on the hostname, as wrb.app
but
sometimes it wouldn't startup immediately ; I had to put a sleep after the
file copy].

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"Baker, Barbara" <[EMAIL PROTECTED]> 05/03/2002 05:58 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

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

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: RE: Sun Cluster and VCS failover 

   

   

   






Nick:
On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5)
it takes us around 12 to 15 minutes.

HTH.
Barb


> --
> From: Nick Wagner[SMTP:[EMAIL PROTECTED]]
> Reply To:  [EMAIL PROTECTED]
> Sent: Monday, March 04, 2002 2:23 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:   Sun Cluster and VCS failover
>
> Situation:  Sun Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
> 2 node Sun E6500s w/ 8 CPUs
>
> If the primary node fails, how long does it take before a user is able to
> connect to the secondary node, and continue their activity?   I'm sure
> reality, and marketing times are different... I'm really interested in
> reality times, but at this point either would be nice.
>
> Thanks!!
>
> Nick
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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





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

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

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

Forms6i (6.0.8 ?) on Motif Mode

[hemantchitale]

We have a number of Forms 4.5 environments (against 7.3.4/8.1.6/8.1.7)
where the clients are Unix workstations. Therefore, the Forms they are are
Motif-mode.

We are looking at upgrading to 6i.  Has anyone upgraded to 6i Motif
(ie convert, develop and run in Motif) ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd

[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]

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

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

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

RE: Sun Cluster and VCS failover

[Nick Wagner]

Title: RE: Sun Cluster and VCS failover 





Thanks!!  Anyone else want to contribute their numbers?


-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sun Cluster and VCS failover 



Nick:
On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5)
it takes us around 12 to 15 minutes.


HTH.
Barb



> --
> From:     Nick Wagner[SMTP:[EMAIL PROTECTED]]
> Reply To:     [EMAIL PROTECTED]
> Sent:     Monday, March 04, 2002 2:23 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Sun Cluster and VCS failover 
> 
> Situation:  Sun Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
> 2 node Sun E6500s w/ 8 CPUs
>  
> If the primary node fails, how long does it take before a user is able to
> connect to the secondary node, and continue their activity?   I'm sure
> reality, and marketing times are different... I'm really interested in
> reality times, but at this point either would be nice.  
>  
> Thanks!! 
>  
> Nick 
>  
>  
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]


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

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

Read Consistency & ITL's

[Rajesh . Rao]

Hello Gurus,

As I understand it. In order to provide a read consistent view of the data
while reading a data block, Oracle looks at the SCN in the block header,
and compares it to the snapshot of the SCN taken when the read commenced.
If the Snapshot SCN is less than the SCN in the block header, the query is
directed to read from the rollback segments.

For any transaction that modifies a block, the ITL among other things, also
stores the commit SCN and the address to the transaction table in the
rollback segment. Assume that the block has just one ITL. This ITL can be
reused once the transaction is completed. Assume it is. That is, two
transactions have performed updates on the block since our read commenced.
If so is the case, how does Oracle know which rollback segment to look at?
I am assuming it still looks at the ITL, rolls it back, sees that it needs
to rollback further, looks at the ITL in the rolled back block, and
rollsback further, and so on, until it can reconstruct the data block at an
SCN lower than the snapshot SCN. Is that right?

My second question is, what happens if the data block has two ITL's, both
marked with SCN's greater than when the read commenced. Which ITL does
Oracle look at to get the address of the rollback segment? Is it the one
with the least SCN??

And also, my previous question, remains unanswered so far? Why does Oracle
not allow one to grant select privileges on the fixed tables to any other
user?

Thanks
Raj

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

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

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

Hash Anti Join Requirements

[Larry Elkins]

Listers,

Some conditions have to be met before a HASH ANTI JOIN can be used (either
by hint or by setting always_anti_join=hash). The ones I have come across
are (1) the column in the NOT IN query must be NOT NULL (or constraining
criteria specified that says NOT NULL for the column, and that's probably
what you want anyway), and, (2) there cannot be more than one table in the
NOT IN sub-query (and we have workarounds for that as well -- flip into an
in-line view, use no_merge and use_hash if necessary, and use the outer-join
and key is null anti-join trick).

Here's what the docs say about the conditions:

"The optimizer uses a nested loops algorithm for NOT IN subqueries by
default, unless the initialization parameter ALWAYS_ANTI_JOIN is set to
MERGE or HASH and various required conditions are met that allow the
transformation of the NOT IN subquery into a sort-merge or hash
anti-join..."

Note the "and various required conditions are met that allow the
transformation...". I've never found a source that specified those
conditions. I came up with the two conditions above based on experience but
even then I don't know they are set in stone.

I ask because I am working with some folks who are frightened by anti-joins.
And in their case, a lot of queries would benefit, and have been
demonstrated, from the use HASH-AJ's. I would just like to be able to give
them something more concrete about when a HASH-AJ is possible other than the
two things I listed above (which may or may not be true) and the generic
comment in the Oracle docs.

Regards,

Larry G. Elkins
The Elkins Organization Inc.
[EMAIL PROTECTED]
214.954.1781

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

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

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

Secret maximum for INITRANS?

[Robert Eskridge]

I'm still messing with my enqueue waits on an insert. I'm now able to
recreate it on a test database by throwing enough simultaneous inserts
at my table. I was going to make sure which of the tables/indexes was
actually causing the waits by individually raising the INITRANS above
what they would naturally expand to, and see how the waiting sessions
responded.

I was hitting it with 50 simultaneous inserts and usually had 10
sessions go into an enqueue wait until the 40 sessions committed or
rolled back.  So I was going though the indexes and then tables
raising the INITRANS to 50 to see which one(s) made a difference.
None of them made a difference.

So I dumped blocks that had been populated only during this exercise.
Invariably, there were 0x29 Itl slots.  Is there something out there
that would limit the Itl entries to 41 even when MAXTRANS=255?  Is
there some secret bound based on block size?  Ours is 2k (which I
figure is part of the problem).

Other vital stats:  8.0.5 on Solaris 2.7.


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

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

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

RE: Names server

[Kevin Lange]

I agree with you Jared.   On the last job we had TNSNAMES files out to
everyones work station . got to be a pain.   Installed Names, created
the right files . bingo, all worked .   Very easy.

-Original Message-
Sent: Monday, March 04, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L


Completely removing names from Oracle would be a mistake IMO.

Reason:  Name is fairly easy to implement,  LDAP is anything but.

Jared





"Freeman, Robert " <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 01:38 PM
Please respond to ORACLE-L

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


Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, 
so
they have delayed
the removal.
OID (LDAP) is the replacement.
 
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely.
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Names server will be obsolete in 9i, I think.

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


Hi ALL:
Is any one using names server out there?  How the it works?  Any infor
are wellcome.

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

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

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



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

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

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

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

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

RE: Names server

[Jared . Still]

Completely removing names from Oracle would be a mistake IMO.

Reason:  Name is fairly easy to implement,  LDAP is anything but.

Jared





"Freeman, Robert " <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 01:38 PM
Please respond to ORACLE-L

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


Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, 
so
they have delayed
the removal.
OID (LDAP) is the replacement.
 
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely.
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Names server will be obsolete in 9i, I think.

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


Hi ALL:
Is any one using names server out there?  How the it works?  Any infor
are wellcome.

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

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

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



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

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

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

RE: EXTENTS?

[Jared . Still]

> and I was off as well, if your extent size is less than the blocksize
> then you can have more than one extent in a block (divide the block
> size by the extent size and round DOWN)

Huh?

Jared





Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 12:13 PM
Please respond to ORACLE-L

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


nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> I'm going to say 1. I don't think you can have multiple tables in the
> same
> DB block. 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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



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

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

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

SSL and non-SSL requests on same Apache server in 9iAS?

[Ben Poels]

Hi,

I want to host SSL and non-SSL requests on one physical server
running one 9iAS.

After installing 9iAS the httpd.conf file specifies by default
that it is listening on port . Later on in httpd.conf it 
has an SSL directive that says it's listening on port 80 and 443.
Does this mean that this one Apache server can service non-SSL
requests on  and SSL requests on 443 at the same time?

There is a document on Metalink(135231.1) that describes how to run two
Apache servers in one 9iAS home. Again what is not clear to me
is whether or not one could be handling SSL and the other non-SSL.

Anyone have any recommendations on how to do this? I may also be asked
to host 40-bit and 128-bit encryption on the same web site. Again any
recommendations?

Thanks. 

==
 Ben Poels - Senior Technical Analyst - Queen's University at Kingston
 Phone: 613.533.2449  Fax: 613.533.2168  Email: [EMAIL PROTECTED]
==

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

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

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

RE: replication question

[James A]

Thanks 
tons Kevin, that is the information I was looking for.
Great, 
quick response.
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
  Monday, March 04, 2002 2:43 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: replication question
  I 
  have used both.   
   
  Replication, like archive log movement , happens whenever you set it up 
  to happen.   That can be anywhere from every minute to once a day to 
  beyond.  It just depends on your needs.  In the case of my old job, 
  we had replication happening at different times for different 
  tables.   Our key table was replicating IMMEDIATELY upon any 
  changes to the parent table.  This happened via 
  trigger.   Other , not so important tables, would replicate at 
  anywhere from 30 to 60 
  minutes.  We did this using scheduled jobs.
   
  I 
  see two real nice advantages of replicated databases.  One, 
  they are accessible.  i.e. you can run reports, queries, etc on 
  them.  They are nothing more than instances that get updated via a 
  foreign database.  Two, depending on what kind of software you use, 
  you can update the database from an outside source.   We used to 
  have data sent down from our DB2 database into our Oracle database using an 
  oracle product called Replication Services (nothing more than triggers and a 
  specific data structure) and an IBM product called Data Propogator.  
  
   
  Archive log transport for standbys can happen in 
  multiple ways also.  The newer oracle versions support direct archiving 
  from a production database to a standby database.  I have not tried this 
  yet but we are looking into it.   Our current standby databases are 
  brought up to date with a shell script that is scheduled via cron every 20 
  minutes.   
   
  The thing about the standbys, they are all or 
  nothing ... you can not just say I want only tables 1-10 to be updated.  
  They all are.  Also, in the older oracle versions, the standbys could not 
  be accessed via software so you could not use them as any sort of read only 
  database.  This is not the case in a replicated database.   
  But, they are also very easy to rebuild and resetup.  Just copy your 
  production files over, create a standby control file, and bring the databse up 
  in standby mode.  Very easy.
   
  Now... which would I recommend ???   
  Depends on your needs.
   
  If you really need to access that copy of the 
  database for other purposes and you only want certain tables to be updated, 
  then I would consider replication.   If, on the other hand, you do 
  not have to access the data (until such a time as your production gets killed 
  and you need your standby up) and you need a fast way to rebuild the second 
  database, I would suggest the Standby 
  approach.
   
  Kevin 
  
-Original Message-From: James Ambursley 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
replication question
Is 
replication faster than a standby database. As I understand it, the 
standby database will be receive arch logs at preset intervals.  Does 
replication have the same functionality and about how much data is sent to 
the replicated site.
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
  Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: replication question
  The way I see it .  the question comes down to whether or 
  not you need two way replication or just one way.   If both 
  databases can update those tables and you need them synced between the 
  databases then Advanced Replication would be the route.   If all 
  you need are data changes from 1 database to be replicated to another 
  database then simple replication is all you need.
  
-Original Message-From: Rahul Dandekar 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 
6:43 AMTo: Multiple recipients of list 
ORACLE-LSubject: Re: replication 
question
Depends on your need.
You can have read only snapshots, updatable 
snapshots
or multimaster...
Again if you think of multimaster... then 
you would need to make decision
based on your application requirements 
about sync or async
 
I donot have any expereince of snapshot 
replication.
But, if you are planning multimaster 
replication, then better
spend a couple of months studying it and 
testing on test boxes...
 
Make 100% sure that your 
application really needs the replication
and there is no other simpler 
option...
 
Just 2 cents...
 
+Rahul

  -

RE: Automatic PGA Memory Management via PGA_AGGREGATE_TARGET para

[David Wagoner]

I bet if you wowed us with a really good explanation of this new feature
then some readers would be inclined to go check out your book :).



david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Tel. (919) 466-6723
Fax (919) 466-6783
Mobile (919) 225-4962
[EMAIL PROTECTED] 
http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender by phone or email and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Monday, March 04, 2002 2:53 PM
To: Multiple recipients of list ORACLE-L

I cover this topic and many others in my Oracle9i New Features book :-))

RF


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 04, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L



I just stumbled upon the "Automatic PGA Memory Management" section of the 9i
docs.  I've never heard of this before.  Does anyone know how long it's been
around?  Anyone using it found any bugs, concerns, etc.?



Granted, this is intended for *dedicated* server mode, it seems like a good
option for our Test databases and perhaps other databases that have only a
handful of users and don't require MTS.  By setting PGA_AGGREGATE_TARGET=X,
where X can be a value in K, M, or G, Oracle will automatically distribute
this memory allocation to dedicated sessions instead of using
SORT_AREA_SIZE.  Here's an excerpt from the docs:



"Oracle does not recommend using the SORT_AREA_SIZE parameter unless the
instance is configured with the shared server option.  Oracle recommends
that you enable automatic sizing of SQL working areas by setting
PGA_AGGREGATE_TARGET instead.  SORT_AREA_SIZE is retained for backward
compatibility."





Learn something new every day in Oracle land...





david



David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency Parkway, Suite 110

Cary, NC 27511-8582

Tel. (919) 466-6723

Fax (919) 466-6783

Mobile (919) 225-4962

[EMAIL PROTECTED]

  http://www.arsenaldigital.com/




***  NOTICE  ***

This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender by phone or email and delete this e-mail
message from your computer.  Thank you.



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

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

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

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

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

RE: Sun Cluster and VCS failover

[Baker, Barbara]

Nick:
On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5)
it takes us around 12 to 15 minutes.

HTH.
Barb


> --
> From: Nick Wagner[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Monday, March 04, 2002 2:23 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Sun Cluster and VCS failover 
> 
> Situation:  Sun Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
> 2 node Sun E6500s w/ 8 CPUs
>  
> If the primary node fails, how long does it take before a user is able to
> connect to the secondary node, and continue their activity?   I'm sure
> reality, and marketing times are different... I'm really interested in
> reality times, but at this point either would be nice.  
>  
> Thanks!! 
>  
> Nick 
>  
>  
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

Re:how are the snapshots refreshed ?

[dgoulet]

Bunyamin,

OK, some of this may be a little off the wall since I'm at home on a day
off.  Can't believe I'm answering the mail on a day off!!  But you got to do
something while waiting for the glue to dry!!

Anyway, there are two init parameters that need to be set,
job_queue_interval and job_queue_processes.  After that bounce your database to
start things.  There after, the parameters you set for 'next' will take over. 
Now if you need to make changes, look in the user_jobs table.  There you will
find the next_date column and a procedure dbms_job.next_date to adjust matters.

Dick Goulet

Reply Separator
Author: "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]>
Date:   3/4/2002 4:58 AM

Dear Gurus,

I have made 10 tables as snapshots . And I want to refresh them for specific
intervals. 
How can I do that ;
I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but could not succeed . 
How is it done ?
Bunyamin








Dear Gurus,
 
I have made 10 tables as snapshots . And I want to 
refresh them for specific intervals. 
How can I do that ;
I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but 
could not succeed . 
How is it done ?
Bunyamin

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

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

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

RE: EXTENTS?

[Jack C. Applewhite]

Yes, this one will get a lot of traffic, I'll bet.

I just looked in the 8.1.7 docs (SQL Reference - Storage Clause) and it says
that the minimum INITIAL is 2 DB blocks for non-bitmapped segments, 3 for
bitmapped segments.  The minimum for NEXT is 1 DB block.

Unlesss it's a new 9i feature, a DB block can belong to one and only one
Extent.

Jack


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


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L



I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.

Raj




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

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

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

RE: ORA-600 [1158] on 8.1.7

[Veronica Levin]

Hi, 
I'm working on Oracle 8.1.7.2 , AIX 4.3.3 and haven't got any problems...
had a lot before the patch, but not ORA-600.
I suggest you apply the patch and monitor the instance.
Hope this helps!

Saludos,
Verónica Levin Enríquez.
Compañía Cervecera de Nicaragua.


-Mensaje original-
De: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Enviado el: Thursday, February 14, 2002 11:54 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: ORA-600 [1158] on 8.1.7


With every parchset they provide list of fixes in readme file. You can check

it before downloading or applying patches...However, it is better to go to 
8.1.7.2 which has lot of fixes...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 14 Feb 2002 08:23:34 -0800

Hi,

We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently
crashes with an
ORA-600 [1158] error. Oracle's "ORA-600 lookup" tool did not have any hits.
There was no specific
resolution from Oracle support for this error - just a general suggestion to
upgrade to the latest
patch  levels.  This is something we are reluctant to do without specific 
patch
information addressing
our problem.

Has anyone seen this error on 8.1.7 before?

Regards,

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

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

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




MOHAMMAD RAFIQ


_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

Defaults for ANALYZE

[Jesse, Rich]

Hi all,

>From my testing in 8.1.6 and 8.1.7, it appears to me that the ANALYZE
defaults to "FOR ALL COLUMNS SIZE 1".  I found this by checking the
DBA_TAB_HISTOGRAMS view before and after an "ANALYZE TABLE bleah COMPUTE
STATISTICS".  I then compared those results to a before/after using
DBMS_STATS first with "METHOD_OPT => NULL", then "METHOD_OPT => 'FOR ALL
COLUMNS SIZE 1'".

So, can anyone tell me where the hell this is documented for the ANALYZE
command?  It's not in "Oracle8i SQL Reference" under ANALYZE, where one
would think it should be, nor does it show up in a search on
http://tahiti.oracle.com.  Same for Metaclink.

I've been pulling my hair out trying to determine why I've been getting
different explain plans between DBMS_STATS and ANALYZE, until I discovered
this.  DBA need beer.  One "Three Floyd's" left in fridge.  M...

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

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

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

RE: Names server

[Freeman, Robert]

Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, so
they have delayed
the removal.
OID (LDAP) is the replacement.
 
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely.
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Names server will be obsolete in 9i, I think.

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


Hi ALL:
Is any one using names server out there?  How the it works?  Any infor
are wellcome.

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

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

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

RE: LIKE and % operator

[Pardee, Roy E]

Are the results any different if you say

select * from sonusrpt where subject like '%GENERAL%';

?

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Monday, March 04, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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

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

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

RE: LIKE and % operator

[Bellows, Bambi]

Looks like you're running into a case-sensitivity issue.  Try 

select * from sonusrpt where upper(subject) like upper('%general%');

HTH.
-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L

I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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

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

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

Re: LIKE and % operator

[Rick_Cale]

select * from sonusrpt where UPPER(subject) like '%GENERAL%';

Rick



   

"Nguyen,   

David M" To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: LIKE  and % operator 

Sent by:   

root@fatcity.  

com

   

   

03/04/2002 

03:33 PM   

Please 

respond to 

ORACLE-L   

   

   





I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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




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

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

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

Re: LIKE and % operator

[Suzy Vordos]

Case needs to be considered, eg., '%General%' or use of upper/lower
functions.

"Nguyen, David M" wrote:
> 
> I am running oracle8i on solaris8.  I have a word ( General ) in my column
> named "subject", I try to run SQL using LIKE and % to grep any data having
> the word ( General ) but it displayed no rows selected.  Does someone have
> any idea why?  Below is my SQL I used.
> 
> SQL> select * from sonusrpt where subject like '%general%';
> 
> no rows selected.
> 
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

Re: LIKE and % operator

[Viktor]

Try changing the query to say:

select * 
from sonusrpt 
where lower(subject) like '%general%'
/


--- "Nguyen, David M" <[EMAIL PROTECTED]> wrote:
> I am running oracle8i on solaris8.  I have a word (
> General ) in my column
> named "subject", I try to run SQL using LIKE and %
> to grep any data having
> the word ( General ) but it displayed no rows
> selected.  Does someone have
> any idea why?  Below is my SQL I used.
> 
> SQL> select * from sonusrpt where subject like
> '%general%';
> 
> no rows selected.
> 
> 
> Thanks,
> David
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

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

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

RE: LIKE and % operator

[Whittle Jerome Contr NCI]

David,

If you have General with an upper case G and are looking for general with a lower case 
g, you won't return any records. It's that old case sensitive thing.

Try this:

select * from sonusrpt where Upper(subject) like '%GENERAL%';

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145

> -Original Message-
> From: Nguyen, David M [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 04, 2002 2:33 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  LIKE  and % operator
> 
> I am running oracle8i on solaris8.  I have a word ( General ) in my column
> named "subject", I try to run SQL using LIKE and % to grep any data having
> the word ( General ) but it displayed no rows selected.  Does someone have
> any idea why?  Below is my SQL I used.
> 
> SQL> select * from sonusrpt where subject like '%general%';
> 
> no rows selected.
> 
> Thanks,
> David
> 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
  INET: [EMAIL PROTECTED]

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

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

Sun Cluster and VCS failover

[Nick Wagner]

Situation:  Sun 
Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
2 node Sun E6500s w/ 
8 CPUs
 
If the primary node 
fails, how long does it take before a user is able to connect to the secondary 
node, and continue their activity?   I'm sure reality, and marketing 
times are different... I'm really interested in reality times, but at this point 
either would be nice.  
 
Thanks!! 

 
Nick 
 
 

RE: EXTENTS?

[Rajesh . Rao]

I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.

Raj




   
 
Rachel 
 
Carmichael   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
   Subject: RE: EXTENTS? 
 
Sent by:   
 
root@fatcity.  
 
com
 
   
 
   
 
March 04,  
 
2002 03:13 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> I'm going to say 1. I don't think you can have multiple tables in the
> same
> DB block.
>
> -Original Message-
> Sent: Monday, March 04, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
>
>
>
> _
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Re: EXTENTS?

[bill thater]

[EMAIL PROTECTED] wrote:

>
>
>in general though, extents are not usually sized as small as the
>database block size
>
should extents be multiples of block size?


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

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

God is real, unless declared integer.






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

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

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

RE: LIKE and % operator

[Shaw John-P55297]

The search is case sensitive, try something like
select * from sonusrpt where upper(subject) like '%GENERAL%';

-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L


I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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

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

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

RE: Names server

[Wong, Bing]

Names 
server will be obsolete in 9i, I think.

  -Original Message-From: Yahoo 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 11:33 
  AMTo: Multiple recipients of list ORACLE-LSubject: Names 
  server
  Hi ALL:
      Is any one using 
  names server out there?  How the it works?  Any infor are 
  wellcome.

RE: LIKE and % operator

[Kevin Lange]

Think Case .

Is the word actually in lower case ???  Is it upper case G and then lower
case eneral ??   

Best way to be sure is

SQL> select * from sonusrpt where upper(subject) like '%GENERAL%';


-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L


I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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

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

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

RE: LIKE and % operator

[Guidry, Chris]

Try,

SQL> select * from sonusrpt where subject like '%GENERAL%';
or
SQL> select * from sonusrpt where lower(subject) like '%general%';


--
Chris J. Guidry  P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


> -Original Message-
> From: Nguyen, David M [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 04, 2002 01:33 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  LIKE  and % operator
> 
> I am running oracle8i on solaris8.  I have a word ( General ) in my column
> named "subject", I try to run SQL using LIKE and % to grep any data having
> the word ( General ) but it displayed no rows selected.  Does someone have
> any idea why?  Below is my SQL I used.
> 
> SQL> select * from sonusrpt where subject like '%general%';
> 
> no rows selected.
> 
> 
> Thanks,
> David
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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

RE: How TO KNOW TABLE SIZE

[Tomita Koga, Alex - (Per)]

Check this note from metalink.


***

Title: Script to compute table size

Disclaimer:
This script is provided for educational purposes only. It is NOT
supported by Oracle Support Services.  The script has been
tested and appears to work as intended.  However, you should always
test any script before relying on it.

PROOFREAD THIS SCRIPT PRIOR TO USING IT!  Due to differences in the
way text editors, email packages and operating systems handle text
formatting (spaces, tabs and carriage returns), this script may not
be in an executable state when you first receive it.  Check over the 
script to ensure that errors of this type are corrected.

Abstract:
It is sometimes necessary to calculate the exact size (exact 
number of bytes) of a table. 

The function 'VSIZE' gives the exact number of bytes allocated
by Oracle for data.
 
For example, if you have a table called 'table1' with n columns  
say, 'col1', 'col2',  , 'coln', execute the following SQL
statement to find the exact size of the table:
  
SELECT SUM(VSIZE(col1)) + SUM(VSIZE(col2)) + ... + 
   SUM(VSIZE(coln)) FROM table1;

In the scott/tiger schema, the following SQL statement can be
executed to find the exact table size of the 'DEPT' table:

SQL> SELECT SUM(VSIZE(deptno)) + SUM(VSIZE(dname)) +
 SUM(VSIZE(loc)) FROM dept;

SUM(VSIZE(DEPTNO))+SUM(VSIZE(DNAME))+SUM(VSIZE(LOC))

 88
Requirements:
None

Version Testing:
This script was tested on Oracle 7.3.3 to 8.1.6 and SQL*Plus 


***


AT&T Latin America
Alex Tomita Koga - ITS
e-mail: [EMAIL PROTECTED]
phone: (51) 1 610- extension 2619
Av. Larco 1301 Torre Parque Mar - Miraflores




-Mensaje original-
De: Seema Singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 04 de Marzo de 2002 02:08 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: How TO KNOW TABLE SIZE


Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

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

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

Re: TABLE SIZE?

[Ora NT DBA]

This would be true if and only if you ignored block header space and ignored
free space in blocks.

What do you want to know

The number of blocks under the high water mark?

The total size of extents allocated to the table segment?

The space allocated within those blocks?

The total number of blocks allocated to the table?

Any one of these could be answered none of them would be the answer you 
arrived at.

John


John

[EMAIL PROTECTED] wrote:

> Hi
> If I have value num_rows and avg_row_len then can I know the size of 
> tables?
> Table size(Bytes)=num_rows*avg_row_len
>
> Thx
> -seema
>
>
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
>


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

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

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

LIKE and % operator

[Nguyen, David M]

I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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

Re: How TO KNOW TABLE SIZE

[Gene Gurevich]

I usually do

select sum(bytes) from dba_Segments
where segment_name = 'TABLENAME';

HTH
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> How can I know how much space a table occupied?
> Can BLOCKS columns in dba_tables helps?
> Or I have to use dba_extents and dba_segments
> tables?
> Thx
> -Seema
> 
> 
> 
>
_
> MSN Photos is the easiest way to share and print
> your photos: 
> http://photos.msn.com/support/worldwide.aspx
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


=


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: EXTENTS?

[Rachel Carmichael]

nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> I'm going to say 1. I don't think you can have multiple tables in the
> same
> DB block.  
> 
> -Original Message-
> Sent: Monday, March 04, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: EXTENTS?

[Mercadante, Thomas F]

Seema,

You got it backwards.

If Db Block Size is 8k, and you create a table with it's initial extent of
32k, the you have 4 db blocks making up the extent.

An Extent is composed of one or more Db Blocks.  A Db Block is defined when
you create the db (although I heard that different tablespaces can have
different Db Block sizes in 9i - correct anybody?)

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

Re: How TO KNOW TABLE SIZE

[Bill Gentry]

This is what I use.  Hope it helps.

spool table_space_usage.log 
set pagesize 0  
set linesize 80   
select   substr (segment_name,1,20)   
  ,bytes / 1024 kbytes 
  ,extents 
  ,blocks  
  from sys.dba_segments  
  where  owner = 'LAWSON'
   and segment_name like 'AR%'  
   and segment_type = 'TABLE'
  order by  segment_name 
/
spool off;   

Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:08 PM


> Hi
> How can I know how much space a table occupied?
> Can BLOCKS columns in dba_tables helps?
> Or I have to use dba_extents and dba_segments tables?
> Thx
> -Seema
> 
> 
> 
> _
> MSN Photos is the easiest way to share and print your photos: 
> http://photos.msn.com/support/worldwide.aspx
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: EXTENTS?

[Rahul Dandekar]

Isn't the minimum extent size something like 5 times the DB_BLOCK_SIZE?

If that's true then maximum .2 extents in DB block.

Or you are looking for this info?

   db_block_size  Max Extents 
   -- --- 
2K121 
4K249 
8K505 
   16K   1017 
   32K   2041


+Rahul

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:28 PM


> Depends on your extent size 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 12:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  INET: [EMAIL PROTECTED]

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

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

Re: replication question

[Rahul Dandekar]

Well, you could open standby DB only for 
read only access (8i) whereas in replication, both or
all (more than 2) databases could be up 
and open to users all the times.
 
Each DML causes substantial overhead as 
each transaction needs to be propogated and applied
at all the master sites (whereas 
in Oracle Parallel Server, there is centralized database accessed 

by multiple instances, there is no need 
for this).
 
So, if you donot need two databases at two 
geographically separate locations, open for users,
then Standby DB or OPS might be 
better option. Again, in OPS, if the hardware cluster fails then
you are in trouble...
 
About speed, if you could tune up sending 
of logs and application of it, then Standby database
would consume substantially lesser 
resources than replication, hence higher throughput...
The primary database in Standby DB just 
needs to send the archivelogs (simple file transfer)
and then log application happens on the 
secondary server...
Whereas, in replication, the database 
would have to propogate and apply each and every
transaction individually
 
+Rahul

  - Original Message - 
  From: 
  James 
  Ambursley 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, March 04, 2002 1:24 
PM
  Subject: RE: replication question
  
  Is 
  replication faster than a standby database. As I understand it, the 
  standby database will be receive arch logs at preset intervals.  Does 
  replication have the same functionality and about how much data is sent to the 
  replicated site.
   
   
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: replication question
The way I see it .  the question comes down to whether or 
not you need two way replication or just one way.   If both 
databases can update those tables and you need them synced between the 
databases then Advanced Replication would be the route.   If all 
you need are data changes from 1 database to be replicated to another 
database then simple replication is all you need.

  -Original Message-From: Rahul Dandekar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 
  6:43 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: replication question
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about 
  sync or async
   
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster 
  replication, then better
  spend a couple of months studying it and 
  testing on test boxes...
   
  Make 100% sure that your 
  application really needs the replication
  and there is no other simpler 
  option...
   
  Just 2 cents...
   
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a 
database all day and I will update the other database . 
I need to replicate 10 tables in a database 
to other database at a specific time. 
 
Do I need Advanced replication  or 
basic replication . ?
How can I understand that replication is 
supported in my both databases. ?
 
Bunyamin 
 
 
 

RE: EXTENTS?

[Godlewski, Melissa]

Title: RE: EXTENTS?





The Server Concepts manual Chapter on Data Blocks, Extents, and Segments would be a helpful Chapter to read.


-Original Message-
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: EXTENTS?



Depends on your extent size    


-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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


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

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


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

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

Re: replication question

[Rahul Dandekar]

Why not just Updateable Snapshots?
 
Updateable Snapshots allow users to query 
and update a local replicated data set 
even when disconnected from the master 
site.

More relevant is the fact that... Updateable Snapshots require fewer 
resources than multimaster replication, while still supporting data 
updates.

  - Original Message - 
  From: 
  Kevin Lange 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, March 04, 2002 10:43 
  AM
  Subject: RE: replication question
  
  The 
  way I see it .  the question comes down to whether or not you need 
  two way replication or just one way.   If both databases can update 
  those tables and you need them synced between the databases then Advanced 
  Replication would be the route.   If all you need are data changes 
  from 1 database to be replicated to another database then simple replication 
  is all you need.
  
-Original Message-From: Rahul Dandekar 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
replication question
Depends on your need.
You can have read only snapshots, updatable 
snapshots
or multimaster...
Again if you think of multimaster... then you 
would need to make decision
based on your application requirements about 
sync or async
 
I donot have any expereince of snapshot 
replication.
But, if you are planning multimaster 
replication, then better
spend a couple of months studying it and 
testing on test boxes...
 
Make 100% sure that your 
application really needs the replication
and there is no other simpler 
option...
 
Just 2 cents...
 
+Rahul

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, March 04, 2002 3:33 
  AM
  Subject: replication question
  
  Dear Gurus,
  The clients will enter records to a database 
  all day and I will update the other database . 
  I need to replicate 10 tables in a database 
  to other database at a specific time. 
   
  Do I need Advanced replication  or basic 
  replication . ?
  How can I understand that replication is 
  supported in my both databases. ?
   
  Bunyamin 
   
   
   

RE: Automatic PGA Memory Management via PGA_AGGREGATE_TARGET para

[Freeman, Robert]

I cover this topic and many others in my Oracle9i New Features book :-))
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L



I just stumbled upon the "Automatic PGA Memory Management" section of the 9i
docs.  I've never heard of this before.  Does anyone know how long it's been
around?  Anyone using it found any bugs, concerns, etc.?

 

Granted, this is intended for *dedicated* server mode, it seems like a good
option for our Test databases and perhaps other databases that have only a
handful of users and don't require MTS.  By setting PGA_AGGREGATE_TARGET=X,
where X can be a value in K, M, or G, Oracle will automatically distribute
this memory allocation to dedicated sessions instead of using
SORT_AREA_SIZE.  Here's an excerpt from the docs:

 

"Oracle does not recommend using the SORT_AREA_SIZE parameter unless the
instance is configured with the shared server option.  Oracle recommends
that you enable automatic sizing of SQL working areas by setting
PGA_AGGREGATE_TARGET instead.  SORT_AREA_SIZE is retained for backward
compatibility."

 

 

Learn something new every day in Oracle land...

 

 

david

 

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency Parkway, Suite 110

Cary, NC 27511-8582

Tel. (919) 466-6723

Fax (919) 466-6783

Mobile (919) 225-4962

[EMAIL PROTECTED] 

  http://www.arsenaldigital.com/

 

 
***  NOTICE  ***

This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender by phone or email and delete this e-mail
message from your computer.  Thank you.

 

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

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

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

TABLE SIZE?

[Seema Singh]

Hi
If I have value num_rows and avg_row_len then can I know the size of tables?
Table size(Bytes)=num_rows*avg_row_len

Thx
-seema


_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

RE: replication question

[Kevin Lange]

I have 
used both.   
 
Replication, like archive log movement , happens whenever you set it up 
to happen.   That can be anywhere from every minute to once a day to 
beyond.  It just depends on your needs.  In the case of my old job, we 
had replication happening at different times for different 
tables.   Our key table was replicating IMMEDIATELY upon any 
changes to the parent table.  This happened via 
trigger.   Other , not so important tables, would replicate at 
anywhere from 30 to 60 
minutes.  We did this using scheduled jobs.
 
I see 
two real nice advantages of replicated databases.  One, they are 
accessible.  i.e. you can run reports, queries, etc on them.  
They are nothing more than instances that get updated via a foreign 
database.  Two, depending on what kind of software you use, you can 
update the database from an outside source.   We used to have data 
sent down from our DB2 database into our Oracle database using an oracle product 
called Replication Services (nothing more than triggers and a specific data 
structure) and an IBM product called Data Propogator.  
 
Archive log transport for standbys can happen in 
multiple ways also.  The newer oracle versions support direct archiving 
from a production database to a standby database.  I have not tried this 
yet but we are looking into it.   Our current standby databases are 
brought up to date with a shell script that is scheduled via cron every 20 
minutes.   
 
The thing about the standbys, they are all or 
nothing ... you can not just say I want only tables 1-10 to be updated.  
They all are.  Also, in the older oracle versions, the standbys could not 
be accessed via software so you could not use them as any sort of read only 
database.  This is not the case in a replicated database.   But, 
they are also very easy to rebuild and resetup.  Just copy your production 
files over, create a standby control file, and bring the databse up in standby 
mode.  Very easy.
 
Now... which would I recommend ???   Depends 
on your needs.
 
If you really need to access that copy of the database 
for other purposes and you only want certain tables to be updated, then I would 
consider replication.   If, on the other hand, you do not have to 
access the data (until such a time as your production gets killed and you need 
your standby up) and you need a fast way to rebuild the second database, I would 
suggest the Standby approach.
 
Kevin 

  -Original Message-From: James Ambursley 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  replication question
  Is 
  replication faster than a standby database. As I understand it, the 
  standby database will be receive arch logs at preset intervals.  Does 
  replication have the same functionality and about how much data is sent to the 
  replicated site.
   
   
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: replication question
The way I see it .  the question comes down to whether or 
not you need two way replication or just one way.   If both 
databases can update those tables and you need them synced between the 
databases then Advanced Replication would be the route.   If all 
you need are data changes from 1 database to be replicated to another 
database then simple replication is all you need.

  -Original Message-From: Rahul Dandekar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 
  6:43 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: replication question
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about 
  sync or async
   
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster 
  replication, then better
  spend a couple of months studying it and 
  testing on test boxes...
   
  Make 100% sure that your 
  application really needs the replication
  and there is no other simpler 
  option...
   
  Just 2 cents...
   
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a 
database all day and I will update the other database . 
I need to replicate 10 tables in a database 
to other database at a specific time. 
 
Do I need Advanced replication  or 
bas

How TO KNOW TABLE SIZE

[Seema Singh]

Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Names server

[Yahoo]

Hi ALL:
    Is any one using 
names server out there?  How the it works?  Any infor are 
wellcome.

Re: EXTENTS?

[Jared . Still]

None.

The lowest level of granularity of storage in Oracle is a block.

block->extent->segment

Time to hit the books, the Concepts manual in this case.

Jared






"Seema Singh" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 10:18 AM
Please respond to ORACLE-L

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


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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



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

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

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

RE: EXTENTS?

[Nick Wagner]

Title: RE: EXTENTS?





I'm going to say 1. I don't think you can have multiple tables in the same DB block.  


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: EXTENTS?



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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


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

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

Automatic PGA Memory Management via PGA_AGGREGATE_TARGET paramete

[David Wagoner]

I just stumbled upon the “Automatic PGA Memory Management” section of
the 9i docs.  I’ve never heard of
this before.  Does anyone know how
long it’s been around?  Anyone
using it found any bugs, concerns, etc.?

 

Granted, this is intended for *dedicated* server mode, it seems
like a good option for our Test databases and perhaps other databases that have
only a handful of users and don’t require MTS.  By setting PGA_AGGREGATE_TARGET=X, where X can be a value in
K, M, or G, Oracle will automatically distribute this memory allocation to
dedicated sessions instead of using SORT_AREA_SIZE.  Here’s an excerpt from the docs:

 

“Oracle does
not recommend using the SORT_AREA_SIZE parameter unless the instance is
configured with the shared server option. 
Oracle recommends that you enable automatic sizing of SQL working areas
by setting PGA_AGGREGATE_TARGET instead.  SORT_AREA_SIZE is retained for backward compatibility.”

 

 

Learn something
new every day in Oracle land…

 

 

david

 

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency
Parkway, Suite 110

Cary, NC
27511-8582

Tel. (919)
466-6723

Fax (919)
466-6783

Mobile (919)
225-4962

[EMAIL PROTECTED]


http://www.arsenaldigital.com/

 

 
***  NOTICE  ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender by phone or email and delete this e-mail message
from your computer.  Thank you.

 

RE: Linux for Big(ish) Databases

[lembark]

-- "Jesse, Rich" <[EMAIL PROTECTED]> on 03/04/02 09:03:28 -0800

> The problem with Linux on Sparc or Alpha is that Oracle doesn't have
> binaries for them.  I've requested Alpha binaries, but haven't had any
> response, despite the "1-2 business days" response.  

Remember: They're Oracle, you're not. Be glad they take
their precious time to not answer your questions!

The main problem with Intel boxes is a narrow I/O bus and
latency issues with the chipsets. The VIA set tends to be
faster so far as I've seen. Combined with good SCSI boards
and LVM striping you can get decent throughput, but it'll
never match something like a V-box or 6500 for full-bore
speed. The "real" alpha motherboards (not "NT compatable"
toys) use wide I/O channels to keep the chip fed.

If you're considering linux look carefully at clusters.
They can be an immense help dealing with large databases.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

Re: EXTENTS?

[Rachel Carmichael]

you have it backwards... extents don't fit into blocks, blocks fit into
extents

and extent size is dependent on tablespace storage parameters and
objectg storage parameters


--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world’s largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Planning Test Backup/Recovery - Tom

[Mercadante, Thomas F]

Eriovaldo,

If you already have a backup script, then you need to test it on the
production machine.  The test db you create does not necessarily have to be
the same size as the production db (init.ora params can be smaller).  But
what you are testing is that your backup scripts run as expected on the
production machine.
  Your init.ora params can be smaller (like a smaller SGA) to prove that it
works ok.

Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L



Tom :

I am thinking something like that ..
I have already did the test at another machine ...
It worked right...

but the instance was diferente ...

So, in your opinion i need to create a instance, in the production machine, 
with the same parameters of production and apply the test there, righ ...

But , how can i to create a instance with the same parameters ?
Should i use the init.ora of the production instance ?

Thanks.
Eriovaldo


>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Planning Test Backup/Recovery
>Date: Mon, 04 Mar 2002 06:18:22 -0800
>
>Eriovaldo,
>
>If I were you, I would create a small test database on the production
>machine, and perform backup/restore of that test database to be sure that
>everything is working before I would try it on a production database.
>
>Once you are convinced that everything works, schedule a down time where 
>you
>can test backup/restore of the production database.
>
>I would also keep the test db on the production box, and as a regular
>monthly schedule, test backup and restore of that database - just to make
>sure that it continues to work.
>
>Hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Monday, March 04, 2002 7:48 AM
>To: Multiple recipients of list ORACLE-L
>
>
>There should not be any problem to test the backup.
>However we are testing the restores to another machine,
>not on the production machine.
>
>Yechiel Adar, Mehish Computer Services
>[EMAIL PROTECTED]
>
> > -Original Message-
> > From:   Eca Eca [SMTP:[EMAIL PROTECTED]]
> > Sent:   Mon, March 04, 2002 1:18 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Planning Test Backup/Recovery
> >
> >
> > Hi all :
> >
> > Does anyone have a planning for test backup and recovery ?
> >
> > I have the scripts and i am doing the backup and now we need to test it
> > in production environment.
> >
> > I have tested it at another environment and got sucess.
> >
> > but at production ... it need to be very very careful ...
> >
> > Any sugestion ?
> >
> > Regards
> >
> > Eriovaldo
> >
> >
> >
> >
> > _
> > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir 
>suas
> > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Eca Eca
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want t

RE: EXTENTS?

[Kevin Lange]

Depends on your extent size    

-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

Re: EXTENTS?

[Igor Neyman]

Depends on the size of the extent.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:18 PM


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

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

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

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

RE: EXTENTS?

[Nelson Flores]

Title: RE: EXTENTS?





it´s the other way around... how many db blocks in an extent.
an extent is a number of contiguous data blocks ...



-Mensaje original-
De: Seema Singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 04 de Marzo de 2002 15:19
Para: Multiple recipients of list ORACLE-L
Asunto: EXTENTS?



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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


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

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

RE: replication question

[James Ambursley]

Is 
replication faster than a standby database. As I understand it, the standby 
database will be receive arch logs at preset intervals.  Does replication 
have the same functionality and about how much data is sent to the replicated 
site.
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
  Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: replication question
  The 
  way I see it .  the question comes down to whether or not you need 
  two way replication or just one way.   If both databases can update 
  those tables and you need them synced between the databases then Advanced 
  Replication would be the route.   If all you need are data changes 
  from 1 database to be replicated to another database then simple replication 
  is all you need.
  
-Original Message-From: Rahul Dandekar 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
replication question
Depends on your need.
You can have read only snapshots, updatable 
snapshots
or multimaster...
Again if you think of multimaster... then you 
would need to make decision
based on your application requirements about 
sync or async
 
I donot have any expereince of snapshot 
replication.
But, if you are planning multimaster 
replication, then better
spend a couple of months studying it and 
testing on test boxes...
 
Make 100% sure that your 
application really needs the replication
and there is no other simpler 
option...
 
Just 2 cents...
 
+Rahul

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Monday, March 04, 2002 3:33 
  AM
  Subject: replication question
  
  Dear Gurus,
  The clients will enter records to a database 
  all day and I will update the other database . 
  I need to replicate 10 tables in a database 
  to other database at a specific time. 
   
  Do I need Advanced replication  or basic 
  replication . ?
  How can I understand that replication is 
  supported in my both databases. ?
   
  Bunyamin 
   
   
   

Re: New iMac as dba workstation

[Jan Pruner]

Yes, thank You.

JP

On Mon 4. March 2002 15:38, you wrote:
> I'm using a Titanium G4 as a workstation, does that count?  ;)
>
> I've had marginal luck using products like SQLGrinder (native OSX app,
> uses JDBC for connectivity).  Ultimately though, I fell back to using
> Tora X-forwarded back to my box (I'm running XDarwin on top of Agua).  I
>
> This is all part of a grand experiment, and I have to say that for me
> it's a marginal success at best.  The cut-and-paste between Aqua and
> XDarwin is poor, which makes Tora only marginally useful for me.  I
> would kill for OCI libs for OSX and a port of Golden.
>
> George
>
> On Monday, March 4, 2002, at 06:23 AM, Jan Pruner wrote:
> > Is anybody using iMac as workstation (db admin,  programming Oracle
> > stuff
> > etc.)?
> > Is there net8 client verison for PowerPC or have I to run sqlplus (or
> > TOra)
> > remote?
> >
> > Thanks
> >
> > JP
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jan Pruner
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> > ---
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jan Pruner
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> // George Schlossnagle
> // Principal Consultant
> // OmniTI, Inchttp://www.omniti.com
> // (c) 301.343.6422   (e) [EMAIL PROTECTED]
> // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

[Q] difference between DEveloper 6i and 6i rel2?

[dist cash]

I just checked ORACLE OTN site and their has ORACLE Developer 6i Release 2
can download.  The CD pack we have is Developer 6i.  Can anyone tell me
what is difference between 6i and 6i rel2?

Thanks

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

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

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

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

EXTENTS?

[Seema Singh]

Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

* Philly, PA - Oracle DBA/ Unix Sys Admin Needed

[OraStaff]

Philadelphia, Pennsylvania company needs an Oracle DBA who also has 
Unix Systems Administration experience (solaris preferred).

This is a staff opportunity... No sub-contractors or third parties please.

* DO NOT send your resume unless you have a stable work history.
  Candidates whose work history includes frequent job changes connot be
considered.
  If you are employed by a consulting company you must have a long term
project history.

NO Sponsorship is available!

*Candidates in the greater Philly area will be given proirity..but
 others will be considered especially if they no not need relocation assistance.

Job Description:  
Duties include providing Oracle and UNIX administration
and consulting services for our internal projects. Additional
responsibilities include: working with the development organization in
producing Oracle and UNIX-related solutions such as disaster recovery;
participating in the development and documentation of operational best
practices for technical solutions; monitoring the production
databases/assist in performance tuning activities; performing data
analysis/modeling for new functionality.

Requirements:
BS degree in Computer Science or related degree, A must.
At least 5 years Oracle DBA experience (must include 8i)) and 2+ years UNIX
administration
experience required (Solaris preferred). Extensive experience in Oracle
Database Administration on both UNIX and NT platforms. Demonstrated
experience in use of Oracle advanced features such as Advanced Replication
and Partitioning. Skilled in Oracle and UNIX performance tuning,
backup/recovery and networking methodologies. Capable of troubleshooting at
the OS, database and application levels. Skilled in UNIX administration
including configuration and tuning methodologies. OpenText and Livelink
experience desired. Oracle Certified Professional (version 8.x or higher)
required. Sun Certified Systems Administrator preferred. Developed
communication, problem-solving and organizational skills essential. Ability
to learn quickly and manage multiple priorities is a must in this fast-paced
environment.

U.S. citizenship or permanent residency is also required.

Base Salary is Open and depends on experience.

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

Email: [EMAIL PROTECTED]
Please use job code: One/Philly/DBA/U.Sys Admin/Kevin
Phone: 800-549-8502

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

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

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

RE: Linux for Big(ish) Databases

[Gogala, Mladen]

May be they'll release the source code and distribute it under the GPL
license?

> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 04, 2002 12:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Linux for Big(ish) Databases
> 
> 
> The problem with Linux on Sparc or Alpha is that Oracle doesn't have
> binaries for them.  I've requested Alpha binaries, but haven't had any
> response, despite the "1-2 business days" response.  
> 
> GL!
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 9:53 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> > We've got a new database to put together.  OLTP, 100-200 
> users, ~250Gb
> > data.  We haven't decided on a platform for this yet.  Is 
> Intel/Linux
> > worth considering for this size of thing?
> 
> No reason why not. Might also want to consider linux
> on a Sparc or Alpha.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

RE: Planning Test Backup/Recovery - Tom

[Eca Eca]

Tom :

I am thinking something like that ..
I have already did the test at another machine ...
It worked right...

but the instance was diferente ...

So, in your opinion i need to create a instance, in the production machine, 
with the same parameters of production and apply the test there, righ ...

But , how can i to create a instance with the same parameters ?
Should i use the init.ora of the production instance ?

Thanks.
Eriovaldo


>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Planning Test Backup/Recovery
>Date: Mon, 04 Mar 2002 06:18:22 -0800
>
>Eriovaldo,
>
>If I were you, I would create a small test database on the production
>machine, and perform backup/restore of that test database to be sure that
>everything is working before I would try it on a production database.
>
>Once you are convinced that everything works, schedule a down time where 
>you
>can test backup/restore of the production database.
>
>I would also keep the test db on the production box, and as a regular
>monthly schedule, test backup and restore of that database - just to make
>sure that it continues to work.
>
>Hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Monday, March 04, 2002 7:48 AM
>To: Multiple recipients of list ORACLE-L
>
>
>There should not be any problem to test the backup.
>However we are testing the restores to another machine,
>not on the production machine.
>
>Yechiel Adar, Mehish Computer Services
>[EMAIL PROTECTED]
>
> > -Original Message-
> > From:   Eca Eca [SMTP:[EMAIL PROTECTED]]
> > Sent:   Mon, March 04, 2002 1:18 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Planning Test Backup/Recovery
> >
> >
> > Hi all :
> >
> > Does anyone have a planning for test backup and recovery ?
> >
> > I have the scripts and i am doing the backup and now we need to test it
> > in production environment.
> >
> > I have tested it at another environment and got sucess.
> >
> > but at production ... it need to be very very careful ...
> >
> > Any sugestion ?
> >
> > Regards
> >
> > Eriovaldo
> >
> >
> >
> >
> > _
> > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir 
>suas
> > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Eca Eca
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).




_
Converse com amigos on-line, experimente o MSN Messenger: 
http://messenger.msn.com.br

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

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

To REM

Multimaster Replication Doubt...

[Rahul Dandekar]

1.
It is my understanding that Oracle 7.x has continuous purge
of the propogated deftrans. There is no option of scheduling
periodic purge at specific time. Am I correct?

2.
How to schedule continuous purge of propogated deftrans in
Oracle 8i from command line?

prompt  SCHEDULE PURGE AT MASTER SITE 
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
NEXT_DATE => SYSDATE,
INTERVAL => 'SYSDATE + 1/24',
DELAY_SECONDS => 0,
ROLLBACK_SEGMENT => '');
END;
/

Manual says set DELAY_SECONDS to 500,000 and set INTERVAL to a value less
than
DELAY_SECONDS. I could not understand exactly how this works...

+Rahul

  ___   ______   ___   ___
 /  /\ /  /\  /  /\ /  /\ /  /\
/  /::\   /  /::\/  /://  /://  /:/
   /  /:/\:\ /  /:/:|   /  /://  /://  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
|  |:|::/ \__\::|  \__\::/   \  \:\  /:/   \  \:\
|  |:|\/   |  |:|  /  /:/ \  \:\/:/ \  \:\
|__|:| |__|:| /__/:/   \  \::/   \  \:\
 \__\|  \__\| \__\/ \__\/ \__\/

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

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

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

RE: ftp from unix session to your local harddrive-How?

[Michael Cupp]

Either need to ftp from the network drive, use samba, or run an ftp server on the 
network so you can ftp to it.

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


Hi List,

I just want to extent discussion in this thread instead of opening a new one...

How can we ftp on to a Network drive from unix machine?
We have an issue to automate the ftping of db audit files to a network drive on 
monthly basis.

Any help is appreciated.

Thanks,
Surendra

-Original Message-
Sent: Tuesday, February 26, 2002 2:46 PM
To: Multiple recipients of list ORACLE-L


I am very happy with the product WS-FTP from www.ipswitch.com for transfering files to 
and from unix /windoz. It has a trial period and the registered product is very 
inexpensive. ROR mª¿ªm

>>> [EMAIL PROTECTED] 02/25/02 03:45PM >>>
You'd need to run an FTP server on your local machine - do a search on 
www.download.com 


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

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

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

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

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

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

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

RE: Linux for Big(ish) Databases

[Jesse, Rich]

The problem with Linux on Sparc or Alpha is that Oracle doesn't have
binaries for them.  I've requested Alpha binaries, but haven't had any
response, despite the "1-2 business days" response.  

GL!

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


-Original Message-
Sent: Monday, March 04, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L




> We've got a new database to put together.  OLTP, 100-200 users, ~250Gb
> data.  We haven't decided on a platform for this yet.  Is Intel/Linux
> worth considering for this size of thing?

No reason why not. Might also want to consider linux
on a Sparc or Alpha.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: ftp from unix session to your local harddrive-How?

[Tirumala, Surendra]

Hi List,

I just want to extent discussion in this thread instead of opening a new
one...

How can we ftp on to a Network drive from unix machine?
We have an issue to automate the ftping of db audit files to a network drive
on monthly basis.

Any help is appreciated.

Thanks,
Surendra

-Original Message-
Sent: Tuesday, February 26, 2002 2:46 PM
To: Multiple recipients of list ORACLE-L


I am very happy with the product WS-FTP from www.ipswitch.com for
transfering files to and from unix /windoz. It has a trial period and
the registered product is very inexpensive.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 02/25/02 03:45PM >>>
You'd need to run an FTP server on your local machine - do a search on
www.download.com 


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

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

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

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

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

Re: Changing the SID of a database

[Bill Gentry]

Rick, here is how I do it.  Contact me if there are any questions.


Make a copy of 'prod' on LAWDB to 'test' on LAWDB from Cold Backup

Introduction

The 'prod' Oracle instance sometimes need to be replicated, on demand, for
testing and/or training purposes. The replication is done using a 'Cold'
backup copy of the 'prod' instance using either the backup directory
(/dbkup) or the ADSM backup. The procedure is very much the same for
creating either 'test' or 'train'. This section will assume creating a 'test
' database.


Procedure

? Take a cold backup of 'prod'

? Shutdown 'test' instance

The 'test' instance should be shutdown using 'immediate' option.


>ORACLE_SID=test

>export ORACLE_SID

>svrmgrl

SVRMGR> connect / as sysdba;
connected;

SVRMGR> select name from v$database;
NAME
-
TEST
1 row selected.

SVRMGR> oradebug ipc

SVRMGR> shutdown immediate;

SVRMGR> exit;

? Copy the datafiles files from the cold backup

Delete ALL TEST database related files, i.e. *.dbf, *.ctl, *.log

Use the cold backup to copy the .dbf files to the "test" instance
mountpoints


? Re-create control files & redo logs for the "test" instance.
(See example belos)

Use the 'make control file' script

>ORACLE_SID=test

>export ORACLE_SID

>cd $HOME/test/admin

>svrmgrl

SVRMGR> connect / as sysdba

SVRMGR> @mkctrl

SVRMGR> select name from v$database;



Example  of creating control files & redo logs:

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "lawtst5" RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 200
MAXINSTANCES 8
MAXLOGHISTORY 800
LOGFILE
  GROUP 1 '/db/u05/oradata/lawtst5/redo01.log'  SIZE 64M,
  GROUP 2 '/db/u06/oradata/lawtst5/redo02.log'  SIZE 64M,
  GROUP 3 '/db/u07/oradata/lawtst5/redo03.log'  SIZE 64M
DATAFILE
  '/db/u05/oradata/lawtst5/system01.dbf',
.
.
.
. '/db/u04/oradata/lawtst5/index22.dbf',
  '/db/u04/oradata/lawtst5/index23.dbf',
  '/db/u04/oradata/lawtst5/index24.dbf'
;
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE RENAME GLOBAL_NAME TO "LAWTST5.WORLD";


Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 9:23 AM


> I'm going to take the datafiles from a cold backup and use them for a new
> database. However, to do this, I need to change the SID of the new db.
I've read
> that it's possible, but not how to do it. Is this an easy thing to do, or
would
> it be better to extract the tables and create the new db that way?
>
> Thanks for any help.
> Rick
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: help with a SQL self-join

[Pardee, Roy E]

If I understand correctly, it sounds like you need a *recursive* self-join.
Depending on the version of your db (certainly in 8i or later) you may be
able to use the CONNECT BY PRIOR syntax to get what you're after.

Have a look at the SQL reference for 'hierarchical queries'.  Here's a link
to the 9i docs:

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/qu
eries2.htm#2053937

(please watch for line wraps)

for reference.

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, March 01, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L


I need help with a self-join.  I have two tables:  DEPT_TBL and TREENODE.

One table holds dept data.  Depts report to one another at at different 
levels, and are "rolled-up" for different purposes.  This roll-up 
information is stored in the TREENODE table.

Each tree_node in TREENODE has a corresponding PARENT_TREE_NUM, which 
corresponds to it's roll-up level.  DEPT_TBL holds dept ID and dept 
description, but no level information.  TREENODE holds tree_descriptions.

The a.deptid = b.tree_node, so that's a possible join.

Question:  How do I pull a dept ID and it's corresponding roll-up 
node/deptid?

This is what I have so far;

select DISTINCT a.tree_node DEPT, b.tree_node COLL
from treenode a, treenode b
where a.tree_node <> b.tree_node
and a.tree_name = 'DEPT_SECURITY'
and a.tree_node = 'H0086'
and a.parent_node_num = b.parent_node_num;

this pulls a dept and all the depts that roll-up at the same level, but 
not the roll-up level.  For example, Dept 'H0086', and 27 depts that rollup 
at the same level.   I simply want a single row with two columns:  a deptID,

and a rollup ID.

How do I do this?

Any help is really appreciated.

Thanks--
Edward Lock
[EMAIL PROTECTED]








_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

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

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

Re: Changing the SID of a database

[Rachel Carmichael]

it's doable. You will need to do a number of things before you can open
the database, including recreating the controlfile (to change the sid)
and renaming all the datafiles to new locations (so you don't overwrite
the original database)

The easiest way (but not the shortest time) to do this would be to do a
full database export, create the new database, with the SID you want
and all the tablespaces with the new datafiles, import the full export
with DESTROY=N and IGNORE=Y (this is VERY important! or you will
overwrite the original datafiles).

you can also export every user individually and import them into the
new database safest way but most time-consuming and biggest pain in
the butt way to do it


--- [EMAIL PROTECTED] wrote:
> I'm going to take the datafiles from a cold backup and use them for a
> new
> database. However, to do this, I need to change the SID of the new
> db. I've read
> that it's possible, but not how to do it. Is this an easy thing to
> do, or would
> it be better to extract the tables and create the new db that way?
> 
> Thanks for any help.
> Rick
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Changing the SID of a database

[SARKAR, Samir]

Take a backup of the controlfile statement by doing a 

 alter system backup controlfile to trace;

Then use this script to create a new controlfile with the new SID
after u have transferred all the datafiles, redolog files and archive
log files. The first line of the create controlfile script may look 
aomething like :

 CREATE CONTROLFILE REUSE SET DATABASE "" RESETLOGS
ARCHIVELOG

Change the path of the log files and other datafiles in the script if they
happen to
be different than the old database. Remember to run the create controlfile
script in 
nomount mode.

Remember to change the db_name parameter in ur parameter 
file for the new database. 

After creating the controlfile, startup the database using the resetlogs
option :

 alter database open resetlogs;

Hope this helps,

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 04 March 2002 15:23
To: Multiple recipients of list ORACLE-L


I'm going to take the datafiles from a cold backup and use them for a new
database. However, to do this, I need to change the SID of the new db. I've
read
that it's possible, but not how to do it. Is this an easy thing to do, or
would
it be better to extract the tables and create the new db that way?

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

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

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


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

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

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

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

Re: Linux for Big(ish) Databases

[Steven Lembark]

> We've got a new database to put together.  OLTP, 100-200 users, ~250Gb
> data.  We haven't decided on a platform for this yet.  Is Intel/Linux
> worth considering for this size of thing?

No reason why not. Might also want to consider linux
on a Sparc or Alpha.



--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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

Making rule-based optimizer choose correct index

[Frederik Lindberg]

Hi,

I'm trying to do a join that is best done by a fast full scan of one
index and a lookup in another. Using the rule-based optimizer and
Oracle 8.1.6, I can't get the optimizer to do what I want. Is there a
way? Any enlightenment would be greatly appreciated.

[Yes, we are moving to cost-based, but some applications need
straightening out first).

- details ---
TABLE U
-UID number,
-EMAIL varchar2(100),
-CLIENT_ID number

unique index on (UID,EMAIL,CLIENT_ID)

TABLE D
-UID number
... lots of data columns

unique index on UID

Query: select D.UID,U.EMAIL from U,D where U.UID = D.UID (so in
essence, I want the UID->EMAIL translation for all UID that exist in
the D table).

The optimizer does a table access full on D and a range scan on the U
table index. Same query with /*+ INDEX_FFS(D-index) */ results in a
fast full scan of the _U_ index followed by a unique scan of the D
index. Adding nonsense criteria such as "... and D.UID > 0" doesn't
make things better.

The D table is very wide, so a lot of I/O is wasted by doing a full
table scan.

Thanks!


-- Sincerely, Fred
Frederik Lindberg, CTO, CheetahMail


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

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

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

RE: replication question

[Kevin Lange]

The 
way I see it .  the question comes down to whether or not you need two 
way replication or just one way.   If both databases can update those 
tables and you need them synced between the databases then Advanced Replication 
would be the route.   If all you need are data changes from 1 database 
to be replicated to another database then simple replication is all you 
need.

  -Original Message-From: Rahul Dandekar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  replication question
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about sync 
  or async
   
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster replication, 
  then better
  spend a couple of months studying it and testing 
  on test boxes...
   
  Make 100% sure that your application really 
  needs the replication
  and there is no other simpler 
  option...
   
  Just 2 cents...
   
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a database 
all day and I will update the other database . 
I need to replicate 10 tables in a database to 
other database at a specific time. 
 
Do I need Advanced replication  or basic 
replication . ?
How can I understand that replication is 
supported in my both databases. ?
 
Bunyamin 
 
 
 

Changing the SID of a database

[rick]

I'm going to take the datafiles from a cold backup and use them for a new
database. However, to do this, I need to change the SID of the new db. I've read
that it's possible, but not how to do it. Is this an easy thing to do, or would
it be better to extract the tables and create the new db that way?

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

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

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

Re: how are the snapshots refreshed ?

[claudio cutelli]

you should define the interval
in the snapshot's DDL.
 ES. START WITH sysdate  NEXT 
sysdate + (1/24)/30  

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, March 04, 2002 1:58 
PM
  Subject: how are the snapshots refreshed 
  ?
  
  Dear Gurus,
   
  I have made 10 tables as snapshots . And I want 
  to refresh them for specific intervals. 
  How can I do that ;
  I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but 
  could not succeed . 
  How is it done ?
  Bunyamin

RE: Replication - Oracle 9i - problem

[Jesse, Rich]

In 9i, catrep is now called from catproc, so AR is installed automatically.
At least that's what the "New Features Guide" says.  And in the Linux
version, it's true.

HTH!  GL!  :)

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


-Original Message-
Sent: Monday, March 04, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


I think what Vladimir is referring is the DBCA screen
(atleast in 8i) which asks if Replication option is
to be used or not. And if checked, it calls catrep.sql
after "dbcreate - catalog - catproc"

+Rahul

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 7:53 AM


> Replication is not part of database configuration.
> After you build the database and create objects inside
> you use the replication manager to create the replication
> on the objects you want to replicate.
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Vladimir Barac - posao [SMTP:[EMAIL PROTECTED]]
> > Sent: Mon, March 04, 2002 12:08 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Replication - Oracle 9i - problem
> >
> > During install of Oracle9i EE software, I have checked "replication"
> > option.
> >
> > Afterwards, when I run "Database Configuration Assistant" there is no
> > check
> > box related to replication???
> >
> > When I run "Oracle Installer" after the install, it confirms that
> > replication option is present.
> >
> > Platform is 9i on Win2000.
> >
> > Thanks in advance
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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