!! Please do not post Off Topic to this List !!
Actually, failover (TAF - for connection, session, and select) works fine
without MTS. I've built six 8i OPS systems in the last year or so using TAF
without MTS. (None had direct Java clients though.)
MTS is not required for the older multiple
!! Please do not post Off Topic to this List !!
Hi Jonathan,
Thx for your input.
If I look at v$filestat I see many columns.
Searching the documents don't give me the explanation for them. Where do I
get this info or maybe you can explain.
AVGIOTM seems to be the column I need (units
!! Please do not post Off Topic to this List !!
The other workload I would say was about the same (Relatively speaking)
Both machines did have idle time on the CPU (I/O intensive job).
What are the dominant wait events - in Oracle? It sounds like its probably I/O,
but you might want to
!! Please do not post Off Topic to this List !!
...or copy command of sqlplus.
Regards.
--- Suhen Pather [EMAIL PROTECTED]
wrote:
!! Please do not post Off Topic to this List !!
You cannot use the alter table move on a table with
LONG columns.
*
ERROR at line 1:
ORA-00997: illegal
!! Please do not post Off Topic to this List !!
Hi
SOrry about this..
But I have actually seen the Net8
(shipped with Oracle 8.1.7 client CD)
using Oracle 8.1.6 Enterprise Edition Database Server,
where the failover works WITHOUT mts.
However, Gopal, can you please clarify
whether
!! Please do not post Off Topic to this List !!
Hi Don,
wait_events that are dominant.
db_file_scattered_reads, db_file_sequential_reads,
db_file_parallel_write,sort_segment_request
are the dominant wait (right under SQL*Net message from client rdbms ipc
message)
So yes I know I have an I/O
!! Please do not post Off Topic to this List !!
Hi
Which oracle patch number is required to upgrade from 8.1.7.0 to 8.1.7.2?
Thanks in advance
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
!! Please do not post Off Topic to this List !!
I've been using LMTs in production systems since 1999 with no problems. I've
been doing uniform extents for (almost) everything (enforced through controlling
the DDL) since 1990 - and wouldn't have it any other way.
My strategy is simple - assign
!! Please do not post Off Topic to this List !!
Does estimate without samples size or percentage not just use 1024 as the
sample size?. If you look at dba_tab_columns the samples size will be in
there. If the table is not too big could you try it with compute statistics
or estimate statistics
!! Please do not post Off Topic to this List !!
I think this is the best description I have seen
so far of the way in which the optimiser has
evolved.
Currently I believe that the optimizer HAS to
obey hints if the hints can be applied to the
paths it has been constrained to check. If
!! Please do not post Off Topic to this List !!
Hi
Patchset : 1882450
Jack
Seema Singh [EMAIL PROTECTED]@fatcity.com on 14-09-2001 11:15:17
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack
Title: CBO - default num_rows in a table
My question of the day is :-
What value does the CBO use as a default number of rows for a table.
Background: -
We all know that if any tables in a query have been analyzed then CBO is used for the query not RBO (couple of caveats I know but let's
!! Please do not post Off Topic to this List !!
Hi,
on AIX platforms, Oracle actually uses it's post wait driver
architecture.
It's a substitute for the operating system's semaphores. The background
is
that due to an exhaustive overhead dealing with OS semaphores (context
switch),
Oracle
Title: CBO - default no of rows
My question of the day is :-
What value does the CBO use as a default number of rows for a table.
Background: -
We all know that if any tables in a query have been analyzed then CBO is used for the query not RBO (couple of caveats I know but let's
!! Please do not post Off Topic to this List !!
Hi Don,
I think I can get your don't believe everything you
hear list to 10no make that 14. This is not
specific to any storage vendor :
8) I/O access patterns on datafiles and redo logfiles
are the same, hence can co-exist without any I/O
Hi,
Please can someone advise me on how to recreate the recovery catalog from
the control file. I have found a command:
resync catalog from backup controlfile;
I am connecting to rman using nocatalog and then issuing the above, but am
getting a syntax errorI have looked on metalink but
!! Please do not post Off Topic to this List !!
Ooooh, correct me if I'm wrong on this one, but doesn't the CBO just use the
stats that are on the table. Hence if you actually delete the stats for the
tables that don't have upto date stat values, you can actually get a
performance increase,
my
!! Please do not post Off Topic to this List !!
Don't laugh, that is what a lot of Windows programming firms aimed for:
Start a small software firm.
Give your employees stock options.
Make a very useful utility.
Become popular.
Your stock value climbs.
Microsoft buys out your company at your
!! Please do not post Off Topic to this List !!
Don,
Just to confirm a point that I think that you are making:
Each tablespace should only have one extent size in it?
Once you get too many extents, you move the object up to the next-size
tablespace?
Thanks,
Cherie
!! Please do not post Off Topic to this List !!
Don,
Thanks for your comprehensive reply. Could you elaborate on how you
enforce uniform extents through controlling the DDL?
What do you mean by that?
Thanks,
Cherie
!! Please do not post Off Topic to this List !!
Hi,
Anyone play red alert 2 ?
do you have cheat codes ?
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
!! Please do not post Off Topic to this List !!
If you have had a catalog in the past and it is backed up somewhere you can
get restore in from backup. If you don't have a backup I would just create
a new recovery catalog. Then backup all of you databases using rman in
order to have current
!! Please do not post Off Topic to this List !!
I am planning setting up a new database with the redo logs on RAID 1 array
(mirror).
The amount of space available on the array is 16Gb and only the redo logs
will be on there.
The application will generate 2Gb of redo per day and will be
!! Please do not post Off Topic to this List !!
If you delete the stats it will use rule based, unless a table being join
does have stats, then the other objects will be estimated (which I believe
is simply based on the number of blocks).
Do not criticize someone until you walked a mile in
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
Rules of tuning
databases.
There is always a bottleneck.
Once you solve the bottle neck, refer to rule number 1.
Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a
!! Please do not post Off Topic to this List !!
Hi
Yes you can untill the day that you have this runaway process that creates
20Gb of redo and than crashes your database 5 minutes before the daily
offline backup should kick in.
But you are only mirroring, why not put your database in
!! Please do not post Off Topic to this List !!
You can only have a max of 8 log groups if I remember correctly.
Yesterday's backup may have failed, and you may have to recover from the day
prior or prior's prior. Keep this in mind as well.
With archive log, you can use 6 month old backup,
!! Please do not post Off Topic to this List !!
Instead, get Jared's dump.sql (Dump Tables to Flat File) from
http://www.cybcon.com/~jkstill/util/. Review it and change it to get what
you need.
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
!! Please do not post Off Topic to this List !!
If the statement is not exactly the same, the new statement will be
reparsed.
If you are executing it under a different user the statement will be
reparsed.
If you drop/create an index, it will invalidate the explain plan if that was
part of the
!! Please do not post Off Topic to this List !!
Making Oracle simpler to work with I don't fear would put dba's out of work.
A dba's role is far more involved than just the daily janitor work.
Planning is also a large part of our job as well.
But let's think about this, look at Windows, a
!! Please do not post Off Topic to this List !!
Having too many datafiles is not good for performance,
updating datafile headers during checkpointing.
I disagree, unless you have an unreasonable amount, there is minor almost
not noticeable difference.
Tests have been done on many databases
!! Please do not post Off Topic to this List !!
I use LMT's a lot.
Advantages
1. Avoids honeycomb fragmentation
2. Simple administration
3. Avoid the need for rebuilding due to fragmented extents
4. Faster when dealing with local extents
5. No need to coalesce (hense eliminate problems
!! Please do not post Off Topic to this List !!
Not at all, it is just a great replacement of utlbstat/estat.
I find it simply an outstanding resource. The ability to take snap shots
every hour, then at any point in time do a report between any two points in
time. They are much more detailed
!! Please do not post Off Topic to this List !!
Generally more smaller data files is better than fewer larger ones.
There is no performance problem with having 10 200Mb data files rather than
1 2gb data file. In fact, using 10 200mb data files will help a little when
it comes to file locking.
!! Please do not post Off Topic to this List !!
Hi
Thanks. That's a very good point. I agree that ARCHIVELOG mode will be
needed.
However, I still have this big disk just for redo logs, so I'm tempted to
fill it anyway. This will be a sort of supplementary backup in case the
archive disk
!! Please do not post Off Topic to this List !!
Tests have been done on many databases with 3500+ data files and shown
the
difference to be insignificant.
Chris,
Can you pl point me to the doc/web site etc. where this is reported.
I am having to deal with such an issue with one of my
!! Please do not post Off Topic to this List !!
I'm curious. With all that's going on in New York, were any
Oracle databases lost? Has anyone had to activate a disaster
recovery plan and bring up their database at a new location?
If so, how did that go? It would be interesting, and
possibly
!! Please do not post Off Topic to this List !!
Chris,
Are these tests results published someplace?
Tests have been done on many databases with 3500+ data files and shown the
difference to be insignificant.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
!! Please do not post Off Topic to this List !!
There is no performance problem with having 10 200Mb data files rather than
1 2gb data file. In fact, using 10 200mb data files will help a little when
it comes to file locking.
and recovery..
-Original Message-
Spence
Sent: Friday,
!! Please do not post Off Topic to this List !!
It is very common for people to see all that free space and want to fill it.
Avoid the desire, fill it with a blank file. Disks are cheap and if you
store things on the outer platters performance will suffer.
Redo logs and other things in oracle
!! Please do not post Off Topic to this List !!
Someone posted a test they did from this list, some reason I believe it was
John, but I can't remember 100%. If the person who did this test on the
list please come forward, I remember this discussion, but I may even do it
on one of my test boxes
!! Please do not post Off Topic to this List !!
Can anyone tell me if they know whether Oracle Spatial
is included with 9i EE? The on-line documentation for
Options is linked to Oracle8 (why I don't know) and
is vague.
Thanks!
-w
__
Terrorist
!! Please do not post Off Topic to this List !!
Chris list,
The last time I checked, an ANALYZE also invalidates
the SQL in the shared pool, to force a parse and
rebuild of the execution plan, on the next execution
of the SQL statement.
Regards,
Gaja
--- Christopher Spence [EMAIL PROTECTED]
!! Please do not post Off Topic to this List !!
Datafile sizing is also dependent on the size of your db. I use 10gb datafile size's
for a 1tb database.
[EMAIL PROTECTED] 09/14/01 09:50AM
!! Please do not post Off Topic to this List !!
Generally more smaller data files is better than fewer
!! Please do not post Off Topic to this List !!
I know a few people (actually on the LazyDBA list) have done tests and each
time they have said the checkpoint time has been insignificantly altered.
I cannot say I have done these tests, and go by the theory of using smaller
data files rather
!! Please do not post Off Topic to this List !!
Please ignore the previous post. It turned out that
one of the indices on the partitioned table was not
partitioned locally. That's what I was missing
--- Gene Gurevich [EMAIL PROTECTED] wrote:
Hi.
I'm getting ora-14098 error when executing
!! Please do not post Off Topic to this List !!
Please ignore the previous post. It turned out that
one of the indices on the partitioned table was not
partitioned locally. That's what I was missing
--- Gene Gurevich [EMAIL PROTECTED] wrote:
Hi.
I'm getting ora-14098 error when executing
!! Please do not post Off Topic to this List !!
I agree - but it would possibly be good etiquette to
wait some weeks before we asked such questions (and
this is not to criticise in any way your post)
Just my 2c worth.
Cheers
Connor
--- Jonathan Gennick [EMAIL PROTECTED] wrote:
!! Please do
!! Please do not post Off Topic to this List !!
What are the rules for using the Decimal datatype? I can't find anything in
my references.
TIA,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken
!! Please do not post Off Topic to this List !!
Christopher R. Spence said:
You can only have a max of 8 log groups if I remember correctly.
Gee, I thought that the DBA controlled the maximum number of redo logs
allowed for a database.
There's this thing called a database create statement:
!! Please do not post Off Topic to this List !!
I missed a step...
you have to register the database using the command
register database; in rman once you are connected...
Anjan
Malik, Fawzia wrote:
Hi,
Please can someone advise me on how to recreate the recovery catalog from
the
!! Please do not post Off Topic to this List !!
We have had 2 querys go wacko on us. Both are cursors in a large
(5000 line) pl/sql package. This interface package runs daily.
The cursor execution below ran in less than 30 seconds on Tues;
ran 2 hrs 15 minutes Wed. (yikes!) We had the same
!! Please do not post Off Topic to this List !!
Umm... see that message at the top of each post?
Please read and heed.
Jared ( stressed out list owner )
On Friday 14 September 2001 06:00, Sinardy wrote:
!! Please do not post Off Topic to this List !!
Hi,
Anyone play red alert 2 ?
do
!! Please do not post Off Topic to this List !!
Can't recall at the moment, but if you take a look
at the tuning manual, it will tell you what the
defaults are.
Jared
On Friday 14 September 2001 03:20, Hallas John wrote:
My question of the day is :-
What value does the CBO use as a
!! Please do not post Off Topic to this List !!
Chris:
If you are executing it under a different user the statement will be
reparsed.
I'm puzzled. I always thought that different users submitting the identical
SQL statement would use the same plan and not need to be reparsed. I
understood
!! Please do not post Off Topic to this List !!
Well, all our servers were fine as of the time our building was evacuated on
Tuesday but I got paged on Wednesday that our 100 Wall St. office had lost
power and was running on generator. Fortunately the only machines I had
there were our standby
!! Please do not post Off Topic to this List !!
Generally IDE shows this problem much more than scsi, but on IDE you can see
as much as 50% performance degrading, I haven't really tested the
difference.
If you put the logs on, then fill the rests of the disks with a empty file
of that size, you
!! Please do not post Off Topic to this List !!
Dear List Members,
I have Production DB in 8.1.6.2.0(64bit) on one box, and RMAN catalog
database
(8.1.6.2.0) on another box. I need to upgrade both the DBs to 8.1.7.1.0. I
have
no problem upgrading the production DB to 8.1.7.0.0 and then
!! Please do not post Off Topic to this List !!
Christopher R. Spence said:
Disks are cheap and if you store things on the outer platters performance
will suffer?
Chris, I'm not sure what you mean here.
The concept of Variable Transfer Rate covers this.
Stealing a quote from: Optimal Storage
!! Please do not post Off Topic to this List !!
It seems that the I/O wait statistics, along with the increased time it takes
for the job to run, is pretty good circumstantial evidence (enough for the
grand jury hearing). That should be sufficient motivation to start the ball
rolling to collect
!! Please do not post Off Topic to this List !!
Our NT Server admins have been told by the Security department that they
need to install virus protection software on the NT / Oracle servers. Does
anyone know of any problems between Oracle and any virus software?
Ron Smith
Database
!! Please do not post Off Topic to this List !!
Hi List,
I am trying to calculate the average database response time for a data
center audit currently underway. Without expensive monitoring tools, is
it possible to determine this from database statistics. So far, I'm using
(Service Time +
!! Please do not post Off Topic to this List !!
Couple of things here..
Do u have a backup u can restore from.. If yes restore...
If never had a catalog..
Create the schema in the database u want to create the catalog and follow these
steps... (pl check the syntax of the commands)
1. connect to
!! Please do not post Off Topic to this List !!
How big a performance issue is the location of the log file on disk? Even
if I create the minimum of 2 archive log groups, how can I be sure the
controller hasn't put these on the outer platters anyway? Since these are
log files then the
!! Please do not post Off Topic to this List !!
I forgot the word default; I know 8 used to be the default. I tend to be
doing many different things when I respond to emails. I guess it would be
much easier if I didn't post at all. Not like I ever ask questions on the
list.
But thanks for
!! Please do not post Off Topic to this List !!
Gaja,
I REALLY like #14 :)
Rachel
From: Gaja Krishna Vaidyanatha [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: I/O Performance/bottlenecks on EMC Symmetrix
Date: Fri, 14
!! Please do not post Off Topic to this List !!
What is 2lakh rows? Never heard of that number metric.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978)
!! Please do not post Off Topic to this List !!
Ehh ... users???
:-)))
On Fri 14. September 2001 18:40, you wrote:
!! Please do not post Off Topic to this List !!
Our NT Server admins have been told by the Security department that they
need to install virus protection software on the NT /
!! Please do not post Off Topic to this List !!
corollary to rule 2
after a certain point, just stop. It ain't worth it anymore.
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: I/O
!! Please do not post Off Topic to this List !!
You mean it invalidates SQL which has references to the newly analyzed
objects, not all SQL in cache - right? Also are you sure that creating index
on table will invalidate SQL which references this table or view based on
this table?
Alex Hillman
Chris,
"Generally more smaller data files is better
than fewer larger ones." Can
you pl let me know if there is any paper or something throwing light on
this.
Thanks
Anjan
Gene Sais wrote:
!! Please do not post Off Topic to this List !!
Datafile sizing is also dependent on the size of your db. I
!! Please do not post Off Topic to this List !!
Hi List,
I am trying to calculate the average database response time for a data
center audit currently underway. Without expensive monitoring tools, is
it possible to determine this from database statistics. So far, I'm using
(Service Time
Title: RE: CBO - default num_rows in a table
Jared,Christopher
The tuning manual states the following
If the optimizer uses the cost-based approach for a SQL statement, and if some tables accessed by the statement have no statistics, then the optimizer uses internal information (such as the
!! Please do not post Off Topic to this List !!
Hi
I am having problem with a query. This query fetches rows from a table which
has 15 million rows.
The problem is, when I execute this query with subquery, the consistent gets
are 4700. Where us without the subquery the consistent gets are
!! Please do not post Off Topic to this List !!
Dear List,
I have Production DB in 8.1.6.2.0(64bit) on one box, and RMAN catalog
database
(8.1.6.2.0) on another box. I need to upgrade both the DBs to 8.1.7.1.0. I
have
no problem upgrading the production DB to 8.1.7.0.0 and the to 8.1.7.1.0
!! Please do not post Off Topic to this List !!
What I would do is use DBMS_STATS to move the production stats to the
staging db and see if the tests lead the same results.
Are ya stats up to date? You using analyze or dbms_stats?
Do you have comparing explain plans, trace files?
I would
!! Please do not post Off Topic to this List !!
Inline answers...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 14, 2001 7:45 AM
!! Please do not post Off Topic to this List !!
Don,
Just to confirm a point that I think
!! Please do not post Off Topic to this List !!
Jonathan,
Don't know -- the NYOUG is trying to check on members, but we've been
looking more towards making sure everyone is alive (so far, I have not heard
that we lost members) and finding ways to help them than towards disaster
recovery
!! Please do not post Off Topic to this List !!
Hi DBA's
First, as a Belizean/American, I'd like to share my sympathy for those
touched by the terrorist attack on the US and anger towards the cowards who
would go to such extremes to achieve their goals.
Life is real. Life is a journey, we
!! Please do not post Off Topic to this List !!
I second that! Market open on Monday might be somewhat revealing...
(setq minor-rant-mode ON)
I worked as a DBA in the financial/brokerage sector for years and was frequently
appalled at what were often loudly touted as high availability and
!! Please do not post Off Topic to this List !!
If the Oracle executing user is different, the execution plan will be
different due to possibility of different objects and security.
Different sessions under the same user can share using bind variables.
Do not criticize someone until you walked
!! Please do not post Off Topic to this List !!
Paul,
Try this:
select ( s.service_seconds + w.wait_seconds) / user_calls service_time
from (
select
(sum(value)/100) / ( 3600 * 24 ) service_seconds
from v$sysstat
where upper(name) like '%CPU%'
and class in (1,64) -- User and
!! Please do not post Off Topic to this List !!
We use rman here. I have used it using the OEM Backup Manager but I find it
more convenient to run it from the OS. I schedule jobs on OEM to run the
server commands and let the agent take care of it.
HTH,
Ruth
- Original Message -
To:
!! Please do not post Off Topic to this List !!
We run a Virus Scanner on our NT Server that houses an Oracle database
with no issues. The only problem I have every seen is where a bug
was in one of the downloads to update the virus information and it messed
up everything from PCs to the
!! Please do not post Off Topic to this List !!
AIX has a unique concept of this.
Given data spread on a disk. The head will spend more time over the
middle tracks as it seeks data that is distributed across the disk.
Thus for faster access, place your tablespace on the middle tracks
of a
!! Please do not post Off Topic to this List !!
Hi Alex,
Yes, I mean invalidate the SQL that is referencing the
object(s) that was analyzed. The creation of the index
has the same effect. Which means after the index is
created, the next execution of the query to that
table, will be re-parsed,
!! Please do not post Off Topic to this List !!
It will slow down your server.
With McAfee, you can exclude the directories that contain oracle datafiles,
that minimizes the impact.
Virus checking software is a good idea, in my opinion.
Regards,
Patrice Boivin
Systems Analyst (Oracle
!! Please do not post Off Topic to this List !!
200, (two hundred thousand:)
English is indeed an great language as it changes in
its nuances as geographic locations change ..its
friday finally!
srinivas for estimating rollback, consider taking
snapshots of v$rollstat.waits (specified in
!! Please do not post Off Topic to this List !!
How are you to create the rollback segments? Is this the same or different from the
other LMT tablespaces. I see where the Temporary Tablespaces are different.
Any other good LMT articles besides the one below? I want to change our database
!! Please do not post Off Topic to this List !!
We're looking at possibly running Oracle on our mainframe, but the
perception exists that a more optimum solution would be DB2. I would
appreciate hearing from anyone that is running Oracle on OS390, and/or
made a decision
!! Please do not post Off Topic to this List !!
Prior to the advent of 8i, uniform extents had to be enforced through making
sure that every extent in a given tablespace was the same size by using
appropriate values in the storage clause in effect at the time of object
creation. The easiest
!! Please do not post Off Topic to this List !!
I think this is what you want to know: you should upgrade your rman
database to the highest version of the databases being backed up with rman.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
!! Please do not post Off Topic to this List !!
Excellent. Thanks for the information; maybe I won't fill my whole disk
with redo now!
- Bill.
At 08:40 14/09/01 -0800, you wrote:
!! Please do not post Off Topic to this List !!
Generally IDE shows this problem much more than scsi, but on
!! Please do not post Off Topic to this List !!
And I have built TB+ sized databases using no datafiles larger than 2 GB. At
this level, larger files are worthy of consideration, but they are certainly not
required - or even critical. It depends...
-Don Granaman
[OraSaurus - Honk if you
!! Please do not post Off Topic to this List !!
With the advent of worms like Code Red, I would recommend it. You don't
need users on the server anymore to get a virus. All you need is an OS
full of holes and the system open to the internet.
Rodd Holman
Original Message
On 9/14/01,
!! Please do not post Off Topic to this List !!
Ruth,
Iam facing the follwing problems/doubts how to upgrade the catalog now.
Please try to help me if you can:
I have Production DB in 8.1.6.2.0(64bit) on one box, and RMAN catalog
database
(8.1.6.2.0) on another box. I need to upgrade both
!! Please do not post Off Topic to this List !!
Fyi,
This is the server that doesn't allow parallel downloading with Download
Accelerator Plus:
ap103aru.us.oracle.com
What's different about that one, I wonder?
Anyway, attempt #1 at downloading patch 11.5.5, 11.5.4. failed three times
so
!! Please do not post Off Topic to this List !!
200,000 @ 50 bytes, I would say just over 40Mb of rollback.
Not sure how you came up with 21akh to 200,000 :)
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their
!! Please do not post Off Topic to this List !!
I think that Chris was referring to the maximum number of redo log group one
COULD create - an Oracle hard limit. I don't know what it is, but I know its
not 8 since I have created OPS databases with 12 redo groups for each instance
and multiple
!! Please do not post Off Topic to this List !!
I have a nightly load job that was being tracked by our developers.
According to their nightly logs (going back months), a query was running
as far back as they can record with a sub-second response time.
Then on a particular date (Aug. 23rd),
1 - 100 of 164 matches
Mail list logo