I remember readign that article and I thought the results that the
contention was very minor? Steve, are you monitoring?
It seemed like one of those things that its so minor its not really
something to worry about?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
That would require effort and planning on their part.
Ron
-Original Message-
Sent: Friday, January 09, 2004 11:05 AM
To: Multiple recipients of list ORACLE-L
Ron - You may want to ask yourself what you're getting into. My
preference is that the developers be creating scripts to make
I'm not sure if I'd mentioned this before:
We do use an external procedure to run external OS commands, but the procedure that is
mapped to the C program is a private procedure in a package. The public interface to
this procedure uses the PRODUCT_PROFILE (aka PRODUCT_USER_PROFILE) table to
On 01/09/2004 12:29:35 PM, Smith, Ron L. wrote:
That would require effort and planning on their part.
Ron
Ron, are your developers little, bearded men that live in the
swamps of Elbonia? Planning and effort are contrary to the
elbonian customs, but Elbonians are cheap labor.
--
Mladen
Ron - You have my sympathy.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 09, 2004 11:30 AM
To: Multiple recipients of list ORACLE-L
That would require effort and planning on their part.
Ron
-Original Message-
Sent: Friday,
--- [EMAIL PROTECTED] wrote:
Guys,
Any good doc. on securing data on database on
internal network behind firewall with an application
server accessing it in the DMZ. I am thinking
Advanced security but would appreciate something on
this subject. I have stored some documents on
security
That's a wrinkle I had not thought about. Here, being a PeopleSoft shop, they like to
run SQR's and sure enough they want to run the same sqr's from web pages, forms
applications, etc. Well I took the stand that the external procedure could only
be passed data. No you can't pass an sqr
Title: RE: Oracle Warehouse Builder Tutorial
Mark,
Take a look at OTN (http://otn.oracle.com/products/warehouse/index.html). There is a little information there. Unfortunately, there isn't much documentation on OWB. The online help docs with the product were all I found last year
Running Oracle 9i and Solaris 2.9.
It appears to me that the solution can be hardware based or Oracle based then. Which
brings up questions about cost versus administration versus reliability. Hmmm.
-Original Message-
Paul Drake
Sent: Friday, January 09, 2004 12:49 PM
To: Multiple
Yong:
I have not followed the thread completely. So I may be missing
something obvious ;)
BEGIN-NON TECHNICAL
Many applications (for example Oracle Applications) use public synonyms
heavily and running with better (or acceptable) performance. We should
not really worry about the milli second
Good luck finding any relevant documentation outside of TFM.
I looked for a while before I decided to go back and read what oracle
provided. The docs are decent. ...once you get the hang of owb it's fairly
intuitive.
The thing is laden with bugs though. 9.2 is vastly better IMHO that
Thomas:
I think you are right on monitoring the db writer performance. You
should look the write complete waits/ free buffer waits to understand
the db writer contention. I am not sure what prompted your Sr.DBA to
think on increasing the IO slaves or db writers.
KG
--- Thomas Jeff [EMAIL
Is all SQL*Net traffic between the app server and the database server?
In other words, is all traffic secure where packets cannot be sniffed?
Or do you need to encrypt the SQL query result set data going from the
server to an unknown client? I believe that's what Oracle Advanced
Security gives
just to weigh in on the side of use of public synonyms.
If you intend to use roles to simplify privilege management, you are
almost forced to use public synonyms, as you cannot create a private
synonym owned by a role. Your other alternative is to hard-code the
schema owner name in every object
The other option is a user logon trigger that does execute immediate
'alter session set current_schema=appowner';
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what
Hi Rachel
My understanding of the negative aspects of public synonyms is that they
kick in as the number of distinct Oracle Users you have increases. My
*experience* is much the same as yours - namely I almost couldn't care,
however this is predicated on applications tracking users and not using
Nice.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jonathan Lewis
Sent: 09 January 2004 14:04
To: Multiple recipients of list ORACLE-L
Subject: Re: Should we stop analyzing?
Note in-line.
Regards
Jonathan Lewis
http
Smith, Ron L. wrote:
When doing a partial data refresh, using export/import, is there any way
to synchronize Sequences between the two databases?
Thanks!
Ron
Ron,
We use a perl script that connects to procduction and select the current
sequence value then updates the dev sequences to that value.
AS OF NOW, I have not come across a book which talks about RAC at a
detailed level (at least to the level we expect). There are couple of
books in the market, but they cover very little on RAC (Concepts and
Internals)
But, the Oracle Documentation (At least for the RAC part) is very good
and it
Joe,
Last year at the midaltantic Oracle users group seminars there was a
presentation by Mike Ault what was very informative on RAC with a
budget. I believe that he has some decent information available. You
might check www.rampant-books.com for his works.
Ron
[EMAIL PROTECTED] 01/09/2004
Hi Chris
Richard,
I agree there are a number of reasons for reorganising
tables. LMTs remove the
need to reorganise a tablespace but not to reorganise a
table. Two further real- ilfe examples of table reorgs:
1) The purge programs have at last been written and run
deleting data 2
One interpretation of increased red latch contention
and log buffer space waits is that more work is being
done more quickly - so the log writer can't keep up.
This could mean:
a)the log writer has slowed down
b)the database writer(s) have speeded up, so there
is
How would you handle the case where there are many sets of privileges,
depending on which user you log in as?
The trigger would give everyone the right to do anything the owner
could to a table. There are times when I want create a read-only
account in addition to an app user.
we do allow
I've read a couple of the books available on RAC:
- Oracle9i RAC by Madhu Tumma and Mike Ault is decent, I'd give it a 2.5
out of 5. Good multi-platform coverage and decent coverage of the internals.
The book suffers from poor layout/editing. The graphics look like they're
photocopied and the
:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Books on rac
Joe,
Last year at the midaltantic Oracle users group seminars there was a
presentation by Mike Ault what was very informative on RAC with a
budget. I believe that he has
Joe,
In random order, here's some hints:
Make sure you visit Werner's site, http://www.puschitz.com He has all sorts
of non-RAC ideas on how to install Oracle on all sorts of RH flavors.
Beware that RH AS 2.1 is bloody old. You may have problems with it
recognizing your newer hardware. Since
My reading of that is that they chose RH over *Unix* rather than Windows for
the DB Server.
Detailing the problems encountered while using Windows Server 2003 on the
communication and transaction server side, Sharma said, We have been facing
this perennial problem of business logic malfunction,
that method is limiting. Lets say you publish data from various sources
using transportable tablespaces... Its much easier to manage this
publication by putting each transported tablespace in its own user.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
beware the rampant press books. Most of them seem to be total garbage. All
in large print with little detail. I didnt think much of the Ault Internals
book from Rampant... its basically stuff you can copy and paste from
metalink.
Dont know about his RAC book. However, all the other non-Ault books
Partly because of the complexity of the technology and uniqueness of each environment,
no book in the field will be 100 per cent of what anyone of us needs; however, the
following is on my database team's bookshelves:
Oracle 9i RAC
By Mike Ault
Published August 2003 by Rampant Tech Press
ISBN:
Um, roles, privileges, etc are administered however you'd like.
The only suggestion I'm making is that rather than having public
synonyms for all objects in your app_owner schema, each user which needs
default access to the objects in the app_owner schema, gets access to
that schema via the
Well, any solution will require consideration of the application design
and implementation. I'm just offering a possible suggestion. ;-)
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to
Title: RE: RAC setup on linux
joe-
There was a nice document on a *cookbook* to do this by Oracle. I'm not sure if I can get my hands on it as we were working to plan out a Linux install in November. That project fell out of priority.. I'll poke around, but not sure if I would hold high hopes
Title: RE: Books on rac
wait... mine wasn't THAT bad... isn't out yet... but isn't that bad.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@--
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11
-Original Message-
From
I've agreed to
(and also sounds like a good idea) but also wants to
turn on archiving. My thinking is why turn on
archiving if I can restore my DB from last night's
BCV's and then bring it up to date by re-loading any
data that was loaded after the BCV split.
Our system is not 24x7 so we can
Well, recovery might be just a wee bit faster then re-loading few gigs of data
using SQL. Also, developers on that DW might lose any work that they haven't done
the night before. This is a production database, which means that it absolutely
must be in archive log mode. One of the big reasons
I had I love you and The Latest Security Patch from Microsoft emails
stored in my crap folder on my home Linux box but I've recently cleaned it.
It might be a good idea to make people on this list feel loved and secure.
On 01/09/2004 04:24:29 PM, Joe Testa wrote:
In case any of you are
Hello April,
I thought you were writing for CRC Press, not Rampant. Did
you switch publishers?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle
thinking is why turn on
archiving if I can restore my DB from last night's
BCV's and then bring it up to date by re-loading any
data that was loaded after the BCV split.
Our system is not 24x7 so we can shutdown before the
BCV split. Also, it's not directly accessed by users
for ad-hoc queries
make much sense.
He's proposed using EMC BCV's which I've agreed to
(and also sounds like a good idea) but also wants to
turn on archiving. My thinking is why turn on
archiving if I can restore my DB from last night's
BCV's and then bring it up to date by re-loading any
data that was loaded after
Title: RE: Books on rac
"all the other
non-Ault books from
Rampant are total trash."
That's a pretty strong statement, Ryan! Mine is a
non-Ault Rampant book; does it count, too? Before you trash the book and commit
the statement, can I interest you in at least taking a look at
last night's
BCV's and then bring it up to date by re-loading any
data that was loaded after the BCV split.
Our system is not 24x7 so we can shutdown before the
BCV split. Also, it's not directly accessed by
users
for ad-hoc queries. Automated processes access the
database and build
Jonathan,
WILLING IMMEDIATE
IMMEDIATE IMMEDIATE
NAME GETSMISSES TO WAIT %GETS
MISSES REQUEST %SLEEPS
=== === =
What I love is the discount of 43% off at
Bookpool.com.
That text is only 30% off there.
Amazon lost my business way back when the 1-click
patent waste matter went down.
Pd
--- Mladen Gogala [EMAIL PROTECTED] wrote:
I had I love you and The Latest Security Patch
from Microsoft emails
stored
Yes but...
The developers use Cognos tools for all their
development. Nobody writes any PL/SQL, triggers etc.
So again, all that the developers might lose is data
that they loaded which can be easily recovered by
re-running the ETL process.
What I'm trying to say is that the environment from
;
-Oorspronkelijk bericht-
Van: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given
nts toturn on archiving. My
thinking is why turn onarchiving if I can restore my DB from last
night'sBCV's and then bring it up to date by re-loading anydata that was
loaded after the BCV split.Our system is not 24x7 so we can shutdown
before theBCV split. Also, it's not directly accessed by us
Title: RE: Re[2]: Books on rac
Hi Jonathan
Don asked me if I would be interested in writing the Programmers Interview book... the Apps book was just done, so I took him up on the offer.
I am writing for CRC... in fact I have one in process now for them.
April
-Original Message
Title: RE: Books on rac
OK, that statement wasn't fair. I have not looked
at Arup's book. I have no interest in HIPAA. So I shouldn't speak on it. These
are the Rampant books I have skimmed through that I do not like. However, I have
skimmed through several. All the one's I have looked
[EMAIL PROTECTED]
cc:
Subject:Re: Books on rac
beware the rampant press books. Most of them seem to be total garbage. All
in large print with little detail. I didnt think much of the Ault Internals
book from Rampant... its basically stuff you can copy and paste from
metalink.
Dont
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Books on rac
OK, that statement wasn't fair. I have not looked at Arup's book. I have no interest in HIPAA. So I shouldn't speak on it. These are the Rampant books I have skimmed through that I do not like
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RAC setup on linux
Joe,
In random order, here's some hints:
Make sure you visit Werner's site, http://www.puschitz.com He has all sorts
of non-RAC ideas on how to install Oracle on all sorts of RH flavors
see http://www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html
Smith, Ron L. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/09/2004 11:49 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Any way
Did you try reducing _log_io_size to less than
one-third log_buffers size to make LGWR more active
and less busy .. We have had some success with it..
Thanks,
Ravi.
--- Thomas Jeff [EMAIL PROTECTED] wrote:
Jonathan,
just
restore the entire BCV set and re-start the load. Not
an expert on EMC's BCV technology but my sysadmin says
it can be done and yes, I'll test before I sign off on
it.
True, I'd be nice to have archive logging aswell. But
is it a necassity or have we all been programmed into
believing
and restart the load, right?
In the same scenario in my environment I'd just
restore the entire BCV set and re-start the load. Not
an expert on EMC's BCV technology but my sysadmin says
it can be done and yes, I'll test before I sign off on
it.
True, I'd be nice to have archive logging aswell
Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will
come.
On 2004.01.09 19:44, quriyat wrote:
Thanks
___
No banners. No pop-ups. No kidding.
Introducing My Way - http://www.myway.com
--
Please see the
Niall,
I think you're right... and as my databases, even those with multiple
applications in them, rarely have more than 20 named users, that's
likely the reason I see no degradation, even on custom apps.
Nice to know it's not just me :)
Rachel
--- Niall Litchfield [EMAIL PROTECTED] wrote:
Hi
that dbf during a
load, how would you recover the db? Restore the dbf,
apply the logs and restart the load, right?
In the same scenario in my environment I'd just
restore the entire BCV set and re-start the load. Not
an expert on EMC's BCV technology but my sysadmin says
it can
oops. my bad. I really should double-check in the docs before I
pronounce things :)
you are, of course, right. it merely removes the necessity to preface
an object reference with the owner.
--- Bobak, Mark [EMAIL PROTECTED] wrote:
Um, roles, privileges, etc are administered however you'd like.
Hi,
This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that.
***
Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to SORT_AREA_SIZE to a temporary
Hi Ryan,
Not for RMAN. I meant a license for Veritas or
Legato.
See Mladen's reply re: BCV (basically EMC takes a
snapshot of the mount points onto corresponding mount
points i.e. a 1-to-1 mapping for each mount point onto
a BCV mount point)
Hope that clears up the confusion.
mohammed
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Backups in a DW Environment
I never heard about the required license from veritas and legato. Can
someone else confirm that this is necessary? They actually charge you more
money to do use another
Subject: Re: Backups in a DW
Environment
The license is for the
software that interfaces Veritas NetBackup to RMAN. RMAN has an API and NBU has an API. The
intersection of the 2 will set you
back about $1500 US IIRC.Jared
"Ryan" [EMAIL
if I can restore my DB from last night's
BCV's and then bring it up to date by re-loading any
data that was loaded after the BCV split.
The rebuild-then-reload method seems to make sense on paper, but it is the
cause of extreme difficultly in actual practice. If you have not yet
already
of hot backup mode. Robert
Freeman's
book is definitely the best source for anything RMAN around.
On 2004.01.09 20:29, mkb wrote:
Hi Ryan,
Not for RMAN. I meant a license for Veritas or
Legato.
See Mladen's reply re: BCV (basically EMC takes a
snapshot of the mount points onto
Hi All,
Someone has alerted me to this thread, and asked for a comment.
On a quick scan, and it seems to me that you've mostly got it right.
The problem is that when an SQL statement that refers to its base
objects via public synonyms is shared by multiple distinct Oracle users,
then name
Mladen,
Is the ALTER SYSTEM SUSPEND really necessary.
We've just implemented SnapClone mechanims for three Oracle DBs on
Hitachi and EMC SANs, We've been told that only ALTER TABLESPACE ... BEGIN
BACKUP
is necessary.
What we do is
1. Issue an ALTER TABLESPACE ... BEGIN BACKUP for all the
I should have expressed myself more clearly. Suspend is not necessary, it's only fast.
Basically,
with suspend, you don't put tablespaces into backup mode. You suspend, resync, split
and start aonther instance as if it crashed. As no I/O is going to disk, datafiles
aren't
fuzzy, so no recovery
Yes.
On 2004.01.08 01:14, Denham Eva wrote:
Mladen
Thank You for this suggestion, works in that the CBO now see it this way
SELECT STATEMENT Optimizer Mode=CHOOSE
TABLE ACCESS BY INDEX ROWID TABLENAME
INDEX FULL SCAN TABLENAME_NDX
Can these parameters be set
On that I really, really have to disagree with you.
Jonathan's book is not something to read When you're really, really
bored. You should read it when you're wide awake and eager to learn. Short
of a database that's in pieces on the floor I can't think of anything that
should have higher
Thank You!
-Original Message-
Sent: Thursday, January 08, 2004 9:04 AM
To: Multiple recipients of list ORACLE-L
Yes.
On 2004.01.08 01:14, Denham Eva wrote:
Mladen
Thank You for this suggestion, works in that the CBO now see it this
way
SELECT STATEMENT Optimizer Mode=CHOOSE
Hear, hear!
Wolfgang,
Without wanting to appear really dense here. But, how about putting some
titles and surnames to that list of yours?
As much as I would love to buy books, with our exchange rate and import
taxes, it becomes very expensive!
But I do have a To Get list that I like to update.
*User
Response Times!*
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Vidya
KalyanaramanSent: 08 January 2004 08:40To: Multiple
recipients of list ORACLE-LSubject: Database Health
ReviewHiI am supposed to be doing a database
health
recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 1:14 AM
When we consider that re-analyzing stats can cause huge changes to data
access patterns I'm continuously amazed at the number of shops that
re-analyze on a schedule and have the Monday Morning syndrome
There's a failure in the statistics at this point.
As far as I can tell, there are at least four different
reasons why the stats can report a
parse count (total)
without recording a
parse count (hard)
and it would be nice if we could see them as four
different statistics.
Code that
Cary,
You recall correctly, just checked the website and it's distributed under the
GPL with no costs mentioned. There are also a number of other interesting
utilities for download also under the GPL.
Cheers,
Chris Dunscombe
Quoting Cary Millsap [EMAIL PROTECTED]:
WinCVS has worked well
it just shattered
BTW: Hippo Birdie!
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
soul, you'll see that I'm a real sweetheart. Humble and modest, too. Mirror, mirror
on the wall,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno
- Original Message -
The issue here is that very few people understand how the CBO
works, or what the statistics do, or how to use them properly.
And a seriously *big* component of that problem is that Oracle keeps
changing/patching/modifying the CBO and how it reacts to
certain
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
On that I really, really have to disagree with you.
Mladen was probably joking anyway :)
Tanel.
Jonathan's book is not something to read When you're really, really
bored. You should read it when you're wide awake and eager to learn.
Short
of a database that's in pieces on the floor I
site index was not null, thus causing every row to be
indexed and RBO didn't use the index.
Tanel.
- Original Message -
From:
Bellow,
Bambi
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 12:14
AM
Subject: RE: Problem with understanding
Op
Create a log file of the export and scan that logfile for any errors reported by the
export process.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD:
Tim,
while we are 'cool'ing off ... you forgot ... Denver is a 'cool' place ...does it pay
'cool' salaries?
Kewl
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
Let's hope he's not on long service leave :)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 8:44 PM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
-Original Message-
[irrelevant stuff deleted]
P.S. I can work powerpoint too.
Close your Powerpoint.exe and S L O W L Y back away from the keyboard and nobody gets
hurt ...
Raj
Rajendra dot Jamadagni at
that also uses v$session_longops ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
dba_tables
Where blkdiff 100;
To determine reorganization need.
Hi Jolene
You already received a number of replies why there are issues with using a
general formula as above. IF a table is commonly accessed via a FTS AND, IF
sufficient deletes without subsequent re-inserts (permanent table shrinkage
Give that guy (Mladen) a break ... soon he is going to be 43 in geek language he is
over the hill (i.e. 42) ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
1. Assume boson is right and recheck your answer.
I disagree.
Based on the questions and answers I've seen here, I would recommend that
one assumes Boson is *wrong*, scratch one's head in mild confusion, utter a
few expletives under one's breath and move on.
Cheers ;)
Richard
--
Please see
get my point ;)
Cheers
Richard
- Original Message -
From:
Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 6:34
AM
Subject: RE: table reorganizations
Jolene,
Tables should never *need* to be reorganized
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 1:59 AM
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge
Sorry, they are so engrained in my toolset that it didn't even occur to me
that they could be unlnown.
My apologies also to Mladen. I didn't mean to admonish him, I just found
the term boring in connection with Jonathan Lewis, or his book, inappropriate.
Jonathan Lewis: Practical Oracle 8i,
Hi Prem
Comments in line.
Hi Richard ,
Many a thanx for both of your replies .
All my worry is : do such questions appear in the real exams also ?
Although there are certainly some dodgy questions and correspondingly suz
answers, I think you'll find the majority of the OCP exam will have
questions about stats changes are:
1- How can I list the changes to execution plans after re-analysis, A
Priori?
2 - How do I justify the risk (and server expense) of re-analyzing?
Some alternatives might be:
1 - Enhance the dbms_stats auto option (monitoring) to make it more
intelligent
Conversely, the CBO is a lot smarter with
this scenario that people realise. How many
people knew that Oracle can resolve a query
of the type:
where colX is null
using a b-tree index ?
Try this --
drop table t1;
create table t1 (n1 number, n2 number not null, n3 number);
create index i1
We'll thats exactly what I'm doing right now, studying Oracle University
instructor guides to temporarily start thinking like OU myself again -
I'll
be instructing an OCP Review course next week, meant for people who want
to
pass OCP. And in order to not distract the students, I won't even
I had one like that:
I created a database under our 7.1.6, because We need an Oracle database for
development. When? Yesterday!
I gave them usernames and passwords and made sure that TNSNAMES was configured.
In monitoring a few weeks later, I noticed no activity, so I asked them, That
database
Title: Message
Is
there any possibility that the results you are seeing in a result of varying
workloads coincidentally intersecting with your changes to redo? Otherwise
it seems that the total redo for a given workload should be invariant with the
log file size.
Allan
-Original
Hi Jonathan,
What release did this NULL_CHECK start with?
I used to see:
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=1 Bytes=6)
1 0 TABLE ACCESS (FULL) OF 'T1' (Cost=1 Card=1 Bytes=6)
As I recall, I used-to need an
1001 - 1100 of 67344 matches
Mail list logo