i thought full scan does 1 block at a time and fast full scan does your
multiblock_read_count?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/10/23 Thu PM 11:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: index full scan over an index fast full scan in
that question is diagrammed and answered in tom kytes new book. :) im waiting to get
asked it.
there is a new ault book out on interview questions. I dont think they are very tough.
I think situational questions are better. Have a development DB set up with things for
the applicant to do.
I
Im familiar with top n queries. Im trying to tune an update and try to do it in one
update statement instead of a query. Im basically trying to update only the top N
fields.
Here is the cursor(I have rewritten it as an analytic function, but I really want it
as a single update. any
its in the first book expert one on one. he talks about it on his webpage. its also in
the concepts document. its just a diagram of oracle and the background processes.
he says its the weeding out question he asks. maybe 1 in 10 get it right.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date:
not sure i like the 'read outside the oracle manuals'. I find that alot of people read
alot of really bad books and then dont read the stuff on OTN.
oracle has very good docs. I do have a beef over lack of syntax examples...
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/10/24 Fri
do any of you ask dbas pl/sql questions? I think its important for DBAs to be good
developers as well. especially if they are part of a development team. I dont think
the skill sets should be seperate. they overlap.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/10/24 Fri AM
you worked for oracle for 10 years and you have to guess? how secret do they keep
these internals documents on the algorithms?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/10/24 Fri PM 01:19:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: index full scan
if i want to improve my math skills how much undergraduate math would you recommend?
From: Paul Drake [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 02:29:24 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Your new book
Ryan,
I do not recall seeing a single
howard posted on dejanews that he is contracting to oracle. so i doubt he got fired.
he probably just quit. We all know alot of people who 'used to work for oracle'.
biggest downside is the lydian third site is gone. Had all the copies of his essays on
it. apparently oracle theratened to sue
im trying to submit a job that runs every 5 minuts. Only way I can get the submit to
work is as follows...
variable jobno number;
variable instno number;
begin
select instance_number into :instno from v$instance;
dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'),
i took a discrete math class last summer at a state university. Id recommend for all
technical people. I hadnt had math in 10 years and found it extremely difficult(half
the class failed). the problem solving skills you get out of doing are incredible. No
you dont learn new oracle commands but
id prefer to handle this in the database.
From: Gene Sais [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 10:29:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: stupid dbms_job question
It's called cron :). Or you could run a shell script that executes then
what initialization parameters? job_queue_processes is fine.
From: Gints Plivna [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 11:49:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: stupid dbms_job question
Just a shot in the dark
Have you set
there was alot more on howards site. oracle made him take it down and the person who
put up taht site didnt copy everything.
he has a new site. www.dizwell.com
not much yet, but its worth bookmarking.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/10/23 Thu PM 12:09:34 EDT
To:
I have an index on the two columns used in this query. Why would the optimizer choose
an index full scan over an index fast full scan?
My question isnt why an index is used, but the type of index scan?
select *
from (select col1, col2,
dense_rank()
over (partition by
i cant attach the 10053 trace. it has proprietary info. There isnt much in analytic
explain plan either.
does anyone know in general why a full scan would be faster than a fast full scan?
From: [EMAIL PROTECTED]
Date: 2003/10/23 Thu PM 03:09:26 EDT
To: Multiple recipients of list ORACLE-L
The unix and C forums are pretty inactive. Hope its ok to ask this here.
Anyone know how to do this?
--
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
all oracle employees? Are any of you involved in the 9i PL/SQL test? I just took it
today and passed it. I didnt study at all.
Id like to state that it is an incredibly stupid test. Ive been told the PErformance
tuning one is bad also...
Some gripes:
1. Only package that I was asked about
ive been told 'data modelling for mere mortals' is a good place to start.
From: bhabani s pradhan [EMAIL PROTECTED]
Date: 2003/10/21 Tue AM 08:54:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Data Modelling
Hi All
I have not done data modelling as a major
im assuming this is an old 'trick' from RBO days. Alot of these are still floating
around. Wasnt there one when you wanted to force a full table scan you would go
where num_field = 1 + 0;
the + 0 forced the full table scan? I was on a project earlier this year and one guy
told people to use
We set our staging tables to 1 percent free and 99 percent used. We do this to keep
the datafile as small as possible. This is because we have to tranport it to other
servers when we publish. There by cutting down on the time it takes to copy the file
and send it across the pipe. We have cut
there is a queuing theory article on hotsos. you have to be a member to read it...
does it have more detail than what is in your book?
unfortunately i havent had a chance to read it yet. Ill get to it. Everyone I know who
has read it, really liked it.
From: Cary Millsap [EMAIL PROTECTED]
This is for non-transactional data load instances. The guys here sware that by using
smaller temporary tables(not global temp tables) they can increase the speed of the
data loads.
Not worried about latch contention because its just for bulk loads. I know this bad in
transactional instances.
we drop and recreate the temp tables every night. We also use PCTFREE PCTUSED at 99
and 1 to pack in the blocks and we use very small extent sizes. then we analyze with
an estimate size of 20 percent which is quite fast.
All of them are used for full table scans and do not have indexes. Ive
We have some servers with 6-8 instances. These are typically staging instances and
maybe 1 low transaction production instance.
We keep multiple instances on one server strictly for cost. Licensing additional
servers would be prohibitively expensive so we bought higher end servers and stacked
the big question is how useful will it be in 10g. Will anyone want to use it? I think
I saw a post somewhere that says wait until oracle version 12 before anyone uses it.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/10/20 Mon AM 10:44:25 EDT
To: Multiple recipients of list
generally speaking there are two groups of people using the RBO.
1. The DBAs who have been around for 15 years and doesnt read release notes and doesnt
feel the need to read release notes or documentation because he knows everything. He
may have tried the CBO in 1995 and had 1-2 bad
what is the bug?
From: Bellow, Bambi [EMAIL PROTECTED]
Date: 2003/10/20 Mon PM 02:04:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: CBO, RBO and will v5 ever really go away?
Unfortunately, our applications fall into the second category. And due to
is that the correct number? its not on metalink.
From: Bellow, Bambi [EMAIL PROTECTED]
Date: 2003/10/20 Mon PM 02:54:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: CBO, RBO and will v5 ever really go away?
Didn't I mention that? Bug 2954921... simple
I saw a presentation on this. How difficult is this thing to install, configure, and
administer? How good is it in practice? Its pretty cheap as far as Oracle products go.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
best 9i new features doc i have seen is written by howard rogers. do a google search
for howard Rogers lydian third. there will be a link on the site for 'books'.
very well written. lots of good stuff on that site.
From: Gary W. Parker [EMAIL PROTECTED]
Date: 2003/10/17 Fri PM 02:42:07 EDT
I was at the Wash DC Oracle conference yesterday and the key note address was about
the future direction of Oracle. It was pretty positive about Grid technology and blade
servers. Anyone out there have any opinions?
It seems like this technology is probably several years away from being used
oracle would have to take long out of the data dictionary if it doesnt. long is still
in the utlexplan.sql script.
From: Nancy Hu [EMAIL PROTECTED]
Date: 2003/10/16 Thu AM 10:44:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: LONG data type in 10g
Does any one
im not 100% certain. I believe has to do with using 'of the shelf parts' to slap
together your own servers instead of paying for expensive ones. You set them up as a
'grid' like structure, so if one CPU fails you can failover to others.
I think thats what it is...
From:
or wait for one of the beta testers to put it up on Ebay.
From: Pete Sharman [EMAIL PROTECTED]
Date: 2003/10/16 Thu PM 01:49:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Where can I download 10g ?
Sure, I've got an accurate rumour. Of course, I'd have
yeah dont commit every 1000 records and do it in one shot. this is going to be much
slower.
why do you want to do it this way? Ive done 100m inserts with just an insert select
and one commit.
From: Maryann Atkinson [EMAIL PROTECTED]
Date: 2003/10/16 Thu AM 11:54:33 EDT
To: Multiple
my company just got invited to on next month in Wash DC. Anyone know if these
will have meet or will they just be fluff? I dont want to waste my time going
to a sales pitch.
they had one last week that was just marketing. One of our guys went to it.
--
Please see the official ORACLE-L FAQ:
pl/sql developer is not bad. however, its the same debugging stuff as toad. most
debugging interfaces are generic. step into, step over, break points, etc...
From: Rama, Shreekantha (K.) [EMAIL PROTECTED]
Date: 2003/10/13 Mon PM 01:19:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
What experiences have you had? If not what kind of requirements documents do you use?
Im particularly interested in people who have worked on projects with relational back
ends and object oriented front ends. It seems very difficult to get these two models
to work together cohesively.
--
do they mean the ora -03113 end of file communication error(number may be off)? Alot
of stuff causes that error.
that is a very vague response on their part.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/08 Wed PM 11:34:24 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Oracle documentation discusses multiplexing control files, data files, redo log files
across multiple volumes in a RAID array. How do you handle this if your using shared
storage? Where you just have one or a few logical volumes.
has anyone developed a backup plan for this?
--
Please see
does monitoring have any real overhead in a high transaction system?
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/10/09 Thu AM 08:59:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: how to keep statistics up to date for CBO
Bob,
I do the
Im on 8.1.7. Is it possible to do something like this? Im getting errors:
create or replace procedure myproc is
TYPE myRecord is RECORD (
field_1 number,
field_2 number);
TYPE storageArray IS TABLE OF myRecord
INDEX BY BINARY_INTEGER;
myStorageArray storageArray;
i
2 of the projects Ive been on I have not had any contact with clients. I wasnt even
allowed to speak to them. It all had to go through product managers, or the prime
contractor.
Its nice when your able to speak to your customer, but sometimes your not allowed to.
Ive been attacked by the
go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046
traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/10/08 Wed AM 09:14:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
those sessions are typical all marketing and buzz word type training. you wont get the
goods until the product and the documentation comes out. i dont see the rush. it wont
be out until atleast 2nd quarter next year. Most shops arent even using 9i yet...
From: Ron Rogers [EMAIL PROTECTED]
the goal of government maintenance projects is not to get anything done. its to keep
the contract going and keep the revenues coming in. people dont want to work
themselves out of a job.
I think its one of the reasons people over do the CMM stuff. They can look good with
their processes, get
sounds like bad error handling on BEA's part. i hate when vendors 'translate' database
messages to something else.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/08 Wed AM 10:59:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: BROKEN_PIPE during
i dont think they are totally removing the RBO from 10g. Ive seen conflicting reports.
I think tom kyte hinted that it is gone, then I read somewhere else that its still
going to be there.
RBO is necessary if you use layered complex views. CBO often times doesnt hold up. Its
a pretty bad
didnt they change it to CBO in 9.0.2? Or is that only in 10g?
From: Boivin, Patrice J [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 02:59:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
We had issues here with first_rows and all_rows when set
how many projects actually have SLAs? Ive been on 5 projects and none of them have had
them. Its always been.
Customer: 'It's Slow'
Me: What is?
Customer: The application. Make it fast.
Me: Define fast.
Customer: As fast as possible. Do it now.
From: Wolfgang Breitling [EMAIL PROTECTED]
did he mention any benchmarked performance improvements from gathering statistics on
the system tablespacE?
From: Grabowy, Chris [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 03:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
At the recent
thanks guys. Im only familiar with the oracle database, so I dont know if I can
believe what I read when dealing with other databases.
so I wanted to check. while we are on the topic of other databases. What kind of wait
interface's do other databases provide? How robust are they?
From:
i think one of the reasons utllock.sql is slow is because it joins data dictionary
views instead of just hitting the underlying tables.
does anyone have a modified utlock.sql that hits the underlying tables? dba_blockers
is instanely slow sometimes.
From: Jamadagni, Rajendra [EMAIL
did it have an accompanying ORA- message or some such? If not than its either a
Weblogic error, a weblogic translation of an oracle error, or your developers trapped
the oracle error and translated it to something else(I hate when they do that).
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date:
more terrific work from Don Burleson. I believe he is the editor on the series.
is it jsut more or is most of the stuff from this guy redundant material you can get
for free from the docs? I hear his Unix for DBAs and Wait Statistic books are pretty
good(though have some inaccuracies).
most
I personally feel that its managements call to make these kinds of decisions. If they
are bad decisions its both their fault and their problem. If this forces you to work
an incredible amount of hours, quit and go somewhere else. Hard to say that in a slow
economy though.
To be fair, I feel
How much you open your mouth depends on who you work for. You can open your mouth to
the unemployment line. Alot of managers feel that you are undermining their authority
if you correct them in meetings. I had one manager tell me that I was doing just that
simply by answering co-workers
experience is far more important than the OCP and degrees. In a tight market there are
multiple people with experience and degrees.
To be fair, experience is more important than skill. Employers often assume that
someoen with alot of experience has alot of skill. We have all worked with people
Im reading an academic book on databases and it states that Physical I/O is often the
primary bottleneck in tuning. Its not the case in Oracle. Is this statement correct
with sybase, sql server, or DB2? or maybe mysql?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
my email states that in oracle this isnt true. HOWEVER, what about other databases?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/10/02 Thu PM 12:34:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Physical I/O and databases other than oracle
On Thu,
i guess my question wasnt clear. What Im getting at is do other databases have wait
interfaces? Is there architecture such that Physical I/Os are a serious concern. Far
more than other bottlenecks. Or is this book just garbage...
From: Daniel Fink [EMAIL PROTECTED]
Date: 2003/10/02 Thu PM
the defrag paper was written back in 1998 I believe. Uniform extents were a good
solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m
extent size even though I have tables that can fit into 128k extents, but feel that
the overall time savings by using 1 extent size
I didnt write this code and am not particularly familiar with this part of Oracle. We
are attempting to migrate some CLOB data. To do this we batch load it into DOM
objects, then user XMLPARSER to parse it, then do an insert.
We are finding that it sucks up so many resources that you cant even
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/09/30 Tue PM 02:09:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Separate Indexes and Data
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30,
there is nothing in the alert log,udump, or cdump on this. Im going to have them run
the package with a 10046 trace next. would a different trace be more appropriate?
From: [EMAIL PROTECTED]
Date: 2003/09/30 Tue PM 02:24:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
--
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 and web hosting services
Im taking a database theory class(no I dont need help with my homework). There is an
interesting query in the book that I have never seen posed before. The solution would
be hideously slow if there was even a moderate amount of data in the tables. How would
you write it?
Given 3 tables: and
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/09/29 Mon AM 09:59:39 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: interesting sql question
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
a user may request the same boat more than once. not sure that work.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/09/29 Mon AM 10:34:53 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: interesting sql question
Here is an attempt ...
select p.*
you could do this, but i would have concerns over the indexing strategy.
select name
from person,
(select distinct sid, count(*) bid_count
from bids
group by sid
HAVING count(*) = (SELECT COUNT(BOAT_ID FROM BOATS)) bids
where person.sid = bids.sid;
Now yours bids table is an intersect
no there are examples in the book using where 'not exists'. the query was horrible.
Ill post it later if you want to see how bad it is.
no its not homework. Id get the answer wrong if i did it this way, since Id have to
follow the model in the book. Which is terrible.
From: Mercadante,
i thought i read that auto-segment management only handles pctused. you have to handle
pctfree yourself?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/29 Mon PM 12:09:46 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on
i think there are examplse in the datawarehouse doc on otn.
there is an oracle datawarehouse book that has come recommended(havent read it). tim
gorman wrote that one right? Id bet its in there too.
you use dimensions with star schema's right?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
i think there are memory structurse that oracle isnt telling us about. wouldnt
surprise me if the x$ tables are stored in some place that is not documented.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/29 Mon PM 02:24:46 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
so basically your saying you use dimensions hand in hand with materialized views.
do they have other uses?
From: Stephane Paquette [EMAIL PROTECTED]
Date: 2003/09/29 Mon PM 02:39:43 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Using dimensions
Using
Im in the middle of Kytes new tuning book. He states that google uses a query similiar
to this to return web pages in their search function:
select /*+ FIRST_ROWS */ b.*
from ( select a.*, a.rownum
from (your query here) a
where rownum pick max number of rows you want in a batch )
hmmm. must have read it wrong in the book. any idea how to get the 'estimated number
of record returned?
From: Hemant K Chitale [EMAIL PROTECTED]
Date: 2003/09/26 Fri AM 10:44:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Google's architecture -- was Re: paging
yeah but alot of employers like to see the certifications. so for most of us who are
not at the point in our career as some of the senior guys here, we have to do it. Ive
noticed that you can get more done if your certified too. Adds credibility to what you
say. Especially with management.
i had one yesterday when i killed a process. Also, what parameter tells oracle where
to dump?
why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a
'shutdown abort'
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
must have been google like behavior. i dont focus on every word.
From: Hemant K Chitale [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 12:39:53 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Google's architecture -- was Re: paging and google.com
I'm confused.
memory only dumped to the udump. it didnt dump to the bdump. how is it decided where
it will be dumped?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 12:09:39 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: what causes a memory dump?
ok so what causes the memory to dump? Im stumped?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 02:39:41 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: what causes a memory dump?
Depending on the type of process which is dumping. If it's a
i had to delete the dump file in order to log into sysdba. it took up the whole hard
drive.
any examples of what causes a memory dump? what is the point to a memory dump?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 03:19:48 EDT
To: Multiple recipients of list ORACLE-L
what is warp 9? what is the point of dumping memory? I didnt set this up.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 03:29:43 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: what causes a memory dump?
There is special mechanism that
Looks to be pretty new. I think it came from the Apps team. Its not even in Kytes new
book.
you can get it off of metalink. It gives you alot more info than tkprof when teamed
with a 10046 trace.
any articles on this yet? There is some data in it, I cant quite follow?
--
Please see the
we tried signalling a non-registered alert in test. The session 'hung'. Someone killed
the session and its in kill status. Nothing else is occurring in the session that was
killed. we killed our processes.
any idea why? there is nothing to rollback? Im stumped.
--
Please see the official
Oracle did a memory dump to udump which grew to 3.4 GBs. Any idea why? I thought
memory dumps went to the cdump directory.
Shutdown immediate didnt work. It just hung. So we did a shutdown abort. Everything is
fine. Im just concerned. All the procedure did was the following:
pseudocode
How does oracle handle bit errors creeping into datafiles which could flip a '1' value
in a field to a '2'. I noticed checksum parameter. is that what its used for?
if that isnt enabled what does oracle do?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
is it possible to have a primary key that is enforced with a bitmap index?
if so what is the syntax?
--
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
what was the initial printing?
congrats Cary. Hope I can get a copy soon.
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/09/22 Mon AM 09:09:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Cary's book -- Out of stock !
It's up to the publisher as to
dba union could be considered a trust. doctors tried doing it and because they are
'independent businesses' its not a union its a trust. they did it to fight high
mal-practice suits.
From: Orr, Steve [EMAIL PROTECTED]
Date: 2003/09/22 Mon PM 12:34:40 EDT
To: Multiple recipients of list
I read some posts on here with shared storage such as SAN and Network Appliances its
no longer necessary to multiplex datafiles on different disks, since the storage array
handles that for you.
How do you ensure that control files and redo log files are kept safely apart so that
no one disk
We run multiple instances on the same server. My understanding is max_parallel_servers
should be set to 4 x CPU. We have 4 CPUs which means 16.
however, does this take into account multiple instances on the same server?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
i know there are no magic formulas, but im hoping for something better than trial and
error. i would assume that parallel query helps most when:
1. are doing work off of multiple mount points.
2. Have alot more LIOs to perform than PIOs(such as sorts).
am i close on this?
From: M Rafiq
I have been doing some alter sessions to improve performance of gigabyte sized 'minus'
operations. How do I tell if this is helping other than completion time?
I believe that if LIOs to PIOs ratio improves with the SAME query then sort_area_size
has helped right?(notice Im not trying to improve
you dont need to hawk your book... of course ill buy it. yeah. i think im screwed. I
dont have mount points to multi-plex my redo logs. :(
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/09/17 Wed AM 11:09:50 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: wait
i have a table with 27 million records that is about 1.2 GB in size. I have a 'staging
table' with 18 million records. 16 million records have a 'delete' flag. I have
indexed the column in staging with a delete flag. both tables have indexed primary
keys. Is the following my fastest option or
i explain planned it and it was much worse than not exists.
my understanding is hash_aj is faster when the table in the sub-query returns results
that are significantly less than the one in the outer table.
ill try it, but i think exists is faster. we dont want to do an index scan here and my
i tested the minus in the explain plan and the estimate was very large. dont i need a
large sort_area_size for that?
bitmap index on all columns right? not just one?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 12:59:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
1 - 100 of 328 matches
Mail list logo