Most of them are from IT world,
emmm... we are at right path.
-Original Message-
Sent: 02 March 2002 07:08
To: Multiple recipients of list ORACLE-L
Go uncle Larry!!
Make me feel all warm and fuzzy inside.
On Friday 01 March 2002 14:39, you wrote:
The ranking of the world's 100
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
Hello Dennis
You missed the point.
If we could make the transition, sometimes lead it,
from punch cards to internet we can do ANYTHING.
I was leading the transition from cards to diskettes, to online work
and to the use of database in my previous employment.
In my current employment, after 15
Hi Hemant,
Thanks for your help. I've checked the metalink for Installation Guide. I
found a copy Oracle8I Release Notes Release 3 (8.1.7) for Sun SPARC solaris
Part Number A86565-01. Our OS has the following SUNWarc, SUNWbtool, SUNWhea,
SUNWlibm, SUNWlibms, SUNWsprot, SUNWtoo packages but the
Title: Message
I have installed Oracle 8i + Repository for
Designer
and it works on one Computer.
I wish to install Oracle 9iASusing Database
cache, 9i Portal
and iFS, also e-Mail Server on the same
computer.
So I will use one computer.
Question:
1. Can I do that on one computer? And
- Original Message -
Does anyone know the release dates for Oracle versions starting from
8.0.5,
8.0.6 to 9i.
they are different for depending on OS and Oracle edition (SE/EE)
u can check Metalink for the Product Availability Reports (from Product
Lifecycle) for the
Don't forget that Oracle has redesigned the whole
area of hash buckets and hash latches.
In 8.1, the number of buckets is roughly 2 x db_block_buffers,
but each latch covers multiple buckets (don't forget that
a latch is about 160 bytes, so a noticeable amount of
memory overhead)
Because each
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
Rachel... somehow the phrase old fogey does not spring to mind...
-Original Message-
Sent: Sunday, March 03, 2002 9:58 PM
To: Multiple recipients of list ORACLE-L
Dennis,
at least you have management yammering at you... try being an old
fogey and LOOKING for a job.
Scary
Rachel
Hi All,
I used to learn that due to performance reasons (disk head going back and
forth) indexes need to be seperated from tables (different
disks/controllers).
Later I have heard other people say that this is not an issue because the
disk head does not stop and wait for you on a production
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
I am not sure about this... just a guess
They may have included catrep.sql as a part of something
mandatory like catproc or catalog
So, one does not need to run that separatly...
Did you read the documentation? Do they say that if DB has to
be created manually then run catrep.sql
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
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
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:
Basically separating data and indexes is a special
case of separating disparate IO operations to achieve
sensible load balancing across your IO subsystem.
Its a little obsolete - basically being a throwback to
the days when Oracle did nested loops and not much
else. Nowadays, with operations
Thank you Rahul ,
Do you acceptvisa or bank check ?
:)
Bunyamin
- Original Message -
From:
Rahul
Dandekar
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 04, 2002 2:43
PM
Subject: Re: replication question
Depends on your need.
You can have
That is another listserv hosted by suny (State University of New York). It
is not very active but it is not a hoax.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 4:18 PM
Nope, and since the list is supported out of
In DBA Studio, when I try to refine a query on a table to bring back only certain
records I am getting this error message;
VTOS-4845:Cannot retrieve data from table
It only happens on this table. I see no errors or trace files generated. I can run the
query in SQLPlus just fine. Is this a
Hi
How much space occupied by LOB column of any tables?
Thx
-Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
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]
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
He was first for a month or two, then Billy overtook him again.
Friday Oracle announced they would not meet their next earnings target,
their shares went into freefall, but at the end of the day about 3.5% lost
in share value.
So Larry lost worth again.
Regards,
Patrice Boivin
Systems Analyst
[EMAIL PROTECTED] wrote:
I had a teacher in college who could program the machine by flipping
the switches on the front.
that's how you IPLed the 360 and 1440 series.
We had paper tape, a step up from the plugs :)
IBM 403 Accounting Machine. lots and lots of room for plugs, and lots
of
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
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
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
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
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
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
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
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
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
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
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
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
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. sigh
GL!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
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
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
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,
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
Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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
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
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]
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
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
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
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
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
-- 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. sigh
Remember: They're Oracle, you're
I just stumbled upon the Automatic PGA Memory Management section of
the 9i docs. Ive never heard of
this before. Does anyone know how
long its been around? Anyone
using it found any bugs, concerns, etc.?
Granted, this is intended for *dedicated* server mode, it seems
like a good option
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
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
Hi ALL:
Is any one using
names server out there? How the it works? Any infor are
wellcome.
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:
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 happeningat different times for different
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 worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see
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.
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:
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
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
4K
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
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
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
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
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
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
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
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]
Names
server will beobsolete 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?
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
[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]
I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.
Raj
Rachel
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
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
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
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
select * from sonusrpt where UPPER(subject) like '%GENERAL%';
Rick
Nguyen,
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 (
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
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
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
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:
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
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
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
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)
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:
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
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
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
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
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
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
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,
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
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
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
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.
1 - 100 of 120 matches
Mail list logo