I read the little blurb in the 9i new features on it. The example there doesnt seem
very useful. What have people used it for?
any good articles with good examples on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
I have a TAR open on this and Im arguing with the Oracle tech support guy.
Here is what happened. We upgraded an instance to 9i. Switched to automatic undo
management. Set our undo parameters to point to a newly created undo tablespace.
1. took our old rollback tablespace(with rollback
I know you can hint a fast full scan. I have run into cases lately where depending on
circumstances Oracle will use an index, but use a sub-optimal type of index scan with
dramatic differences in performances.
This is on 9.2. Any hints for forcing an 'index range scan'. Anything stronger than
i know about the limit clause. I just want to keep someone else from bringing down an
instance.
I think Ill get a taser and fry the next person who does it. :)
From: zhu chao [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 10:34:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I have a very strict SLA and I posted a question on asktom about the best way to get
the 'estimate' of rows and return it to the user. Im getting 'no data found'. anyone
have ideas? Im on 9.2, tables are analyzed, and Im in a DBA account.
my question is at the bottom.
im concerned about hitting the v$views in production. we have 30,000 users. its either
that or do counts. Its a requirement from the users.
not sure what to do. doesnt tom kyte do this on asktom?
From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/12/30 Tue PM 12:09:33 EST
To: Multiple
anyone have a better way to do this? im going to post what you said wolfgang on asktom
and see what he has to say.
From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/12/30 Tue PM 12:09:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: help with estimate row
i could have swarn i read in multiple places that in a high transaction system hitting
v$views repeatedly kills performance? causes excessive latching?
ill have to test it to see if this is better than a count. Gonna be ugly either way.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date:
that isnt a reliable statistic. doesnt track people forced to take low paying temp
jobs either.
besides, anyone can tell you that the job market is bad, by just putting out a job ad.
when you get 100-150 resumes for 1 job... its a tight labor market.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
One of our guys used a very large bulk collect into with a forall update. It sucked up
all the swap space on our solaris box and noone could connect to it. So we had to
bounce the server.
I was under the impression that pl/sql tables go into the buffer cache and cannot go
large than its size?
the sqlnet is a network issue. talk to your SAs. is the other database on a different
server? work from there.
your big one is your read. could mean your SGA is too small. is anything else running
at this time?
are you sure there is an equivalent amount of work to do? are you sure there isnt
do ref cursors always do a hard parse? or can i get them to always do a soft parse?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
we dont have that level of granularity. everyone developers out of the same DBA
account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 12:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL
3 million records in a forall statement. we are bringing on temps and you know how
that goes... Im hoping I can set a parameter somewhere to keep anyone from bringing
down a server.
such as 'memory for pl/sql table area limit hit' errors out what he is doing.
i guess not :(
From: Khedr,
it filled up the pga and then used 'swap' space on the hard drive. this filled up.
didnt realize this was a feature. yeah, I know i can 'tell' them to do it. I was
hoping to disallow it though.
From: Bobak, Mark [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 01:24:25 EST
To: Multiple recipients
you mean a dbms_job?
execute immediate 'turn trace on'
inside what ever is being called. then check it. or just run it manually.
From: Potluri, Venu (CT Appl Suppt) [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 01:09:29 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
go to metalink and get 'trace analyzer' read the install instructions. It will extract
wait events from your output.
if your in 9i and up wait events are in the tkprof. i think you have to do a 10046
trace to get the wait events? not just a sql_trace.
From: Potluri, Venu (CT Appl Suppt)
can someone send me the query I use to hit v$sql_plan to get my estimated cardinality
for a query?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
i need to return the cardinality estimate to the user as a number. how do i do that?
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 04:29:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: getting estimate of result set from v$sql_plan
[EMAIL
i believe tom kyte recommends putting them in one or a few instances and using VPD to
handle security. He claims it scales better. I believe its in his second book and on
his website.
However, Thomas is right. You really dont want 13 instances together for maintenance
reasons. Some may need
Im sure its a privilege issue.
1. I have 3 tables with two different owners
2. I want to create a materialized join view of these tables in a 3rd user account.
3. I altered the session to enable query rewrite and query_rewrite_integrity=trusted
4. I granted query rewrite enabled to every owner
I figured it out.
I have another problem. I create my materialized view. I now want to write a query
that joins it to a transactional table. I want to use query rewrite. Problem is the
join is not on the primary key of either table.
Is it possible to enable query rewrite without that? I have
I figured it out. I need some help with query re-write. Im not sure its possible.
My materialized view joins 3 tables on the primary key/foreign key. I have a query
that would join that materialized view to a third transactional table, but that join
is not on any primary key or foreign key.
I
my bad on the explanation.
I have 4 tables. 3 are non-transactional. These are joined in a primary key/foreign
key relationship. These are going in the materialized view.
I want to join my 4th table to my materialized view.
1. The application current has code that joins all 4 tables. I dont
are there really that many people who use hit ratio?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/12/23 Tue AM 11:49:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Hit Ratio
Yong,
Connor's script is not a joke, it's a proof by counterexample that the
The softwrae engineers are measuring CPU usage. I usually ignore this and dont care
about that value. I dont have any docs on it. anyone have any docs on this? or am I
wrong?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
the cpu right now is high because they are not-using bind variables. Which is being
fixed. So I was ignoring CPU usage.
Ive read that article. I dont remember any CPU material in there. I just focused on
LIOs and didnt realize I needed to monitor CPU. However, high LIOs will lead to high
CPU
I decided to play around with ASMs and use the statspack tablespace as my trial
balloons(lots of inserts and deletes and I dont care about fragmentation).
anyway I just ran SPCREATE. Wierd thing is that there is no data in any of my
statspack tables, but their segments sizes vary from 1m to
hmmm... odd
there is no setting for pct_used on tables, but different settings for percent free.
Different settings for initial extent to between tables.
anyone have more info on how this 'intelligent' algorithm works? I heard kyte speak
last week and he assured us that the algorithm is good
ignore spcreate.sql actually puts pctfree,pctused, and really bad initial and next
extent settings on the tables. its an antiquated script that hasnt been updated.
my bad.
From: [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 09:09:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL
transportable tablespaces need to be totally self-contained. everything that is being
transported has to be in that tablespace. it doesnt matter if its a different
datafile.
you probably have your partitions in seperate tablespaces? or am i wrong?
From: NGUYEN Philippe (Cetelem) [EMAIL
wait or are you just trying to transport 1 partition?
i think you have to do regular export and import.
From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 10:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Exporting a partition with
i dont think many people are using bchr anymore. I think its been talked down to
death. only place I hear about it is offshore. people still using the old niemic book.
his new took all that stuff out.
or am i wrong?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/12/22 Mon PM 02:14:26 EST
My estimate right now is about a 500GB instance(but could grow). There are several
complexities.
1. high transaction system, but also will have alot of long running queries
2. We deliver data daily and rebuild large parts of the database nightly with loads.
Im not certain I have the window to
I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know
atleast one other person from the list was there. Since Oracle is releasing details
and its going to be released(in theory) in the next 2 weeks, I was wondering if you
guys could talk about it.
1. does ASMs
no ASMs are considerably different. Its supposed to manage everything. You dont give
it a file, you give it entire disks and oracle does everything. Sets up files,
manages, I/O, everything.
you only look at the tablespace level. you dont even install any software on it. If
your on SAN, you
the last two projects I have been on we are using client server with .Net. Tons of
.net people, verify few database people.
oracle is pushing jdeveloper hard. You need skilled java people to use that.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/12/19 Fri AM 09:44:25 EST
To:
I see this alot when people look for data warehouse people. any idea what is meant by
this? Not look for the obvious oxymoronic joke.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services--
SAME is stripe and mirror everything. There is a doc on otn by that name. ASMs will do
that for you, 'in theory'.
kyte is the technical face of oracle. This is why they pay him so much money.
presentation would have been better if people didnt play 'stump the dba'. It seems
like people were
btw, a straight not in without a hash_aj, tends to get hideous bench marks.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/12/18 Thu AM 09:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any known problems using NOT IN ?
Actually, because relational
uhh... thats not exactly true. oracle is a bastardization of set theory.
there are alot of cases where 'not exists' and 'not in'(if doing a hash anti-join' are
much superior to minus.
here are some generalizations.
1. not in with a hash_aj is the best if
-- your sub-query is significantly
your goals should tie into the job market. you might absolutely love Pascal
programming, but I dont recommend studying it.
Right now(and I dont know how it will fluctuate), there is far, far, far more demand
for Software Engineers who specialize in Java or .Net. Far, far, far, more than people
my biggest concern is the model for development has been changed. The model now is do
most development with software engineers and have only a small number of database
people. this means less pure oracle jobs.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/12/18 Thu PM 02:59:26 EST
To:
learn java and object oriented programming. go to sun.com and start reading the java
docs.
go to www.bruceeckel.com and read his java book.
do a search on any job sites. a ton more work for java than oracle. people who can do
both are in demand.
From: Mladen Gogala [EMAIL PROTECTED]
DC area is insanely expensive. you can spend $300,000 for a condo. Traffic is very bad
also and getting worse.
it doesnt get 'affordable' until you get up to frederick or in virginia near manassas
or west of leesburg.
with all the government money and the private sector IT stuff in free
the question for technical people is where the sales are located. are they in the US?
or somewhere else
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/12/16 Tue AM 08:59:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Good news from Oracle
Oracle is
The software engineers here are using an application server with connection pooling to
connect to our oracle instances.
They are doing it with a dedicated connection to Oracle. No MTS.
they compartmentalize stuff here, so Im having trouble figuring out exactly how this
affects the database and
doesnt this force you to commit after every single DML statement?
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/12/15 Mon AM 08:36:09 EST
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: connection pooling from an application server
so if user A has 10 DML statements to do in one transaction. The application server
will be smart enough to to only allow user 'A' to use that connection until a 'commit'
is issued?
how does application level connection pooling compare to MTS?
From: Rachel Carmichael [EMAIL PROTECTED]
I change it with an alter rollback segment, but when i bounce the instance, it goes
back to the default of 1m.
is there a way to make the change permanent?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network
how many people are actually OCMs? and those of you that are, has it helped you in
getting work?
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 07:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Who are certified Oracle Masters?
Hi
how do you move over to the academic database world? it seems like the most
interesting stuff is going on there?
From: MacGregor, Ian A. [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 11:29:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT: More Advances in
i meant automatic segment management has fragmentation issues.
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 06:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little competition
Little competition for you all :)
It's a two part question:
who wrote that?
automatic undo management has fragmentation issues. Niall Litchfield posted a test
case a couple of months ago.
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 06:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little
hopefully i wont sound like a complete idiot, but what is wrong with wanting to be
able to handle your own pctfree and pctused. Ok oracle handles the next and initial
extent sizes...(which causes fragmentation).
I use transportable tablespaces and in order to increase the time it takes to copy
Ive been working on 'large' distributed databases lately and its not as high as alot
of arrogant people make it out to be. Its just different. Im not sure tuning a
database with alot of data and fewer transactions like in a datawarehouse necessarily
'harder' than tuning a higher transaction
yeah typical burleson carelessness then. anyone can make that mistake, but if your
going to publish you should be more careful.
should have known.
From: Tim Gorman [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 08:34:32 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
#1. these instances are still on 8i. We are supposed to go to 9i, but its not my call
#2. its read only for the users. We do batch loads at night and I did not notice any
slow down in the loads. I run statspack regularly. no problem. Just gotta do an alter
table move periodically when we get
put it into a a dbms_output to see what is passed as variables
then wrap it in execute immediate. your doing dynamic pl/sql. i think that will work.
From: anu [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 11:54:35 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re:
oracle literature is really lacking in entry level docs anyway. The concepts document
is way too large to be digestable by someone new to the topic.
What we really need is:
simple SQL book for newbies
simple PL/SQL book for newbies
Architecture book
automatic features
Beginning Oracle
you need to contact oracle sales to make certain. The obligation is on your company
double check.
i doubt what they are saying is true. please post what you find out.
From: Jay Hostetter [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 09:14:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL
DBAs should never 'guess' about performance. If they are guessing you need new DBAs.
They should be running statspacks, sql trace, and looking at timing data.
Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'.
How much are you paying these guys?
From:
Has anyone else notice that these two can be somewhat different? In a high transaction
system, I typiucal try to reduce LIOs when I write queries.
For last 6-8 months, Ive been doing alot of ETL and nightly batch data loads. Ive
found that there are times when I can improve response time by
i was at an oracle group meeting and one of the RAC specialists at oracle was talking.
he said that that kind of thing 'can' be done, but is incredibly expensive. you need
redundancy and fail safes like crazy.
any time you do an upgrade, bad things may happen.
From: Tracy Rahmlow [EMAIL
Im playing with the example in tom kytes book. we have alot of korn shell scripts that
we use as functions.
We 'echo' out values to standard out. is there anyway to catch this echo with a java
stored procedure? I thought about redirecting it to a file and reading it in with
utl_file, but that
what do you mean by sophisticated I/O?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/12/07 Sun PM 11:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: PERL?
You'll get much more comprehensive answers than mine, but a few huge
motives for me are.
We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on
windows. I also have development responsibilities, so I dont have time for a
checklist.
you need to automate tasks. You cant spend your time reading the alert log. you should
poll it and get an email when
expert one on one. check asktom.oracle.com might be on there also.
From: John Dunn [EMAIL PROTECTED]
Date: 2003/12/04 Thu AM 09:44:29 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: java package to run OS command
Which book is that?
-Original
cost is irrelevant. ignore it. it doesnt matter. its internal for oracle. what docs
are you using that say to use cost? none from oracle. they dont exist.
have your Logical I/Os gone up? Has your response time gone up?
I can guess as to why its more 'costly'? By accessing the varray do you do
We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i.
I'm looking at using RMAN for our backup and recovery. We have many instances but
essentially 2 types.
1. Production instances that have both OLAP and OLTP. These must be in archive log
mode.
2. We have
i must have misread the docs. i thought it was either catalog or control file. didnt
know you could do both
thanks.
From: [EMAIL PROTECTED]
Date: 2003/12/04 Thu AM 11:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RMAN questions
I suppose just how
Which wait events are indications that your missing bind variables?
btw, if you want to implement bind variables through a c/c++ middle tier its best to
use 'prepared statements'. correct?
bind arrays can be issued as prepared statements right? This is when you need to do
alot of inserts
never pay retail with oracle licensing. who pays the full $10k? If your buying other
stuff you should be able to knock off alot. Never pay the full amount.
From: David Wagoner [EMAIL PROTECTED]
Date: 2003/12/03 Wed AM 09:24:38 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
this has to do with RAC right? oracle uses shared everything and ibm uses shared
nothing right?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
anyone got the articles about why raid 5 is bad for databases?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
are you using a grid at stanford? how much data do they have at CERN?
From: MacGregor, Ian A. [EMAIL PROTECTED]
Date: 2003/12/03 Wed PM 02:49:32 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
i think this is possible. any docs on how to set this up with suggested methods?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
what if you have a web based architecture? is there a way to have 9iAS decide which
connection to use?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/12/02 Tue AM 07:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: running both shared server and dedicated
what causes memory fragmentation errors? should oracle be able to go to the LRU and
start kicking stuff out of memory if there isnt enough space?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/12/02 Tue PM 12:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re:
i believe column privileges are only for dml. views are supposed to filter out columns
for selects. i could be wrong.
From: Krishna Kakatur [EMAIL PROTECTED]
Date: 2003/12/02 Tue PM 12:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Anyone run into this
im assuming this means you want a software engineer who knows a little oracle right?
you cnat be an expert in both.
Ive seen more and more jobs like this and less and less oracle specialist positions.
Its troubling.
From: Dave Phillips [EMAIL PROTECTED]
Date: 2003/12/01 Mon AM 08:59:25 EST
maybe its running on sql server?
From: Connor McDonald [EMAIL PROTECTED]
Date: 2003/11/28 Fri AM 08:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Semi-OT...dbazine
Anyone noticed www.dbazine.com...
This domain has temporarily been disabled.
To restore
This view seems to be a smaller subset of v$sysstat? When is it useful?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
both store that info
SQL desc v$statname
Name Null?Type
-
STATISTIC# NUMBER
NAME
v$sysstat has the NAME column also?
From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED]
Date: 2003/11/26 Wed AM 08:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: when do you use v$statname?
v$statname is a lookup table for the statistic# that appears in
right, then why do we have v$statname?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/11/26 Wed AM 08:44:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: when do you use v$statname?
but only v$sysstat has the value column ...
Raj
are you looking for the init.ora max_open_cursors(dont think i typed it exactly right).
even if the cursors are cached, they should not be counted as open. they doesnt make
sense from an oracle design standpoint.
From: Lord David [EMAIL PROTECTED]
Date: 2003/11/26 Wed AM 10:34:34 EST
To:
i remember in tom kytes new book there is a 'softer parse' he was referring to using
dbms_sql instead of execute immediate. Im not referring to using dbms_sql when you
have to loop and use the same cursor repeatedly so you eliminate all parsing.
he didnt go into great detail on this just gave
i heard it was just the corporate call centers coming back? not the private call
centers?
dell tech support isnt any good no matter where it is. its just an entry level
position. The guys who get good move up or on to other things. gateway is bad too.
From: Bellow, Bambi [EMAIL PROTECTED]
I see it referred to on metalink alot. I know its seperate from the rdbms.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
the arrogance here is troubling. though there seems to be more incompetent developers
who do not know the database I have worked with my share of incompetent DBAs. Havent
used anything since versoin 5.0 and so on. Dont know anything at all about
development.
If a production DBA knows
i was on a project last year where the lead didnt let us make stored code. she thought
it 'cluttered the database'. what can you do? lots of incompetence out there. worst
when its the boss.
From: April Wells [EMAIL PROTECTED]
Date: 2003/11/21 Fri AM 09:54:33 EST
To: Multiple recipients of
how does dimensional modelling used by datawarehousing fit into relational theory?
From: Daniel Hanks [EMAIL PROTECTED]
Date: 2003/11/19 Wed PM 04:35:03 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make it
I was at an Oracle usergroup meeting last week and a guy at Oracle said the following
happened. Can anyone confirm? Just curious.
1. Orbitz did an upgrade to some software other than Oracle. I think it was firmware.
They did NOT test it first. Did it directly in production.
2. This corrupted a
there are used copies for sale right on there.
From: KENNETH JANUSZ [EMAIL PROTECTED]
Date: 2003/11/20 Thu AM 11:20:15 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any articles/books that take relational theory and make it
Unfortunately according to
the guy who spoke from oracle said that 9.2 is much better than 9.0.1 RAC. anyone use
it?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 12:19:59 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: orbitz fiasco
The only thing high about 9.0.1
which noted O-O author said that about DBs?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 02:59:58 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make it
Paula - It may get worse. A noted
what is TAF?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 02:45:19 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: orbitz fiasco
Yes. We have a 9.2.0.4 test system based on the How to Build a $1000 RAC
whitepaper
I swapped emails with a member of the list and Im having trouble seeing how you can
take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF
essentially means you have a key that you can put a unique constraint on. Well that
makes this much easier to understand.
these are bogus. its just about giving your boss some BS, so he goes away. Been there,
done that.
the only useful stuff to send him would be polling the alert log for 'ORA' errors,
checking for chained rows as a percentage of total rows, and check to see how much
free space is in each
1 - 100 of 158 matches
Mail list logo