there arent that many new pl/sql features. 90% of the time your using the generic
stuff. the new stuff is nice, but not always that special. Or maybe its just because I
do it everyday. But how much is new? PL/SQL tables? Bulk binds? Dynamic SQL? That
stuff is all basic. Its minor syntax
I want to store some files. I make a new copy every night. I want to archive it back 4
days. So after 4 days, I want to delete the old copy. How do I do this?
However, if i miss a nightly batch and have less than 4 copies, I do not want to
delete any?
--
Please see the official ORACLE-L
I can see using them in some cases where say I have majority OLTP users and have a few
batch processes that I dont want sucking up resources.
Other than that... Im not sure they are particularly useful?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
the guys who concentrate just on sql tend to be sql server lists with people who
generally dont like oracle.
i know joe celko who wrote those sql books posts on the sql server usenets.
From: Jonathan Gennick [EMAIL PROTECTED]
Date: 2003/11/14 Fri AM 11:39:28 EST
To: Multiple recipients of
Im reading from user_source and writing the text of packages to files. Problem is that
if i use UTL_FILE.PUT_LINE it adds an extra '/n'(end of line character or space) into
the file. since the code itself is stored in the database with an end of line
character.
If I use UTL_FILE.PUT or
Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies.
Is the test the same way? If so do they improve it in 9i?
The book is loaded with all types of hit ratios, discussions about committing
frequently to IMPROVE performance, and other garbage.
anyone know the
im going to take it soon. I was going to just read howard rogers guide then the otn
one.
you think that is enough? I just want to pass it and get my piece of paper. I already
know the 9i stuff that is useful to me.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/11/12 Wed PM 12:19:32
My company started offshoring jobs to India. Ive been told Im safe, but in a corporate
environment, your boss doesnt know much. He didnt even get advance notice about the
layoffs that occurrted today. I believe long term they want to outsource the whole
department overseas. My boss doesnt know.
my 'C' isnt very good, but I would assume CGA is allocated with malloc right? they are
just dynamic allocations.
do you know what type of data structures oracle uses to sort? dynamic arrays or linked
lists?
From: Steve Adams [EMAIL PROTECTED]
Date: 2003/11/11 Tue AM 08:14:26 EST
To:
I cant find any specifics in the docs. I must be missing something. All I see is
'session specific information'?
Does this mean package variables? SQLPLUS bind variables? What does this mean?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET:
I checked v$db_object_cache on several of our instances and found that none of our
objects in the shared pool take up much space.
Does anyone have any objects need to to go to the reserved pool? Like what? All the
shared pool is storing are execution plans, etc... how could that take up enough
Im sure on the DB side this is the same for Java and C/C++ also.
The OO guys pass us an array. When I write my code, I need to define a PL/SQL table
that maps exactly to the array correct?
Our middle tier is having problem doing bulk inserts since its doing one at a time and
I believe it
hmm
earlier in the year i was on a project where I wrote alot of backend PL/SQL that was
called through the middle tier. I have no idea how this works. I just assumed it came
straight through .NET.
any idea how they might have done that? The front end was a .NET architecture. Sorry
for
ignore most of my last question. I didnt see pl/sql 'table' just saw pl/sql
my bad. sorry
From: David Hau [EMAIL PROTECTED]
Date: 2003/11/10 Mon PM 01:44:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: passing an array variable from a .Net middle tier to a
sounds like your not a fan of .net, with the .not reference? why?
From: Kevin Toepke [EMAIL PROTECTED]
Date: 2003/11/10 Mon PM 02:09:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: passing an array variable from a .Net middle tier to a da
Given that
One of the guys here did some research and found that files over 32GB can cause data
dictionary corruption. anyone have problems with this? we are using an automated
transportable tablespace process with alot of logic and between many instances and
servers.
we would prefer not to complicate
I remember seeing this question asked on another forum some time back. I dont like the
solution the guy had and Im wondering how some of you might solve problem. Im giving a
low level generic example.
Lets say you have a parent-child relationship. The parent table is 'TRUCKS' and the
child
i like that. you then have a table that lists 'available trucks' and you have a key
constraint from the cargo_detail to the truck table.
you can also archive when changes happen for history data. I like that one.
From: AK [EMAIL PROTECTED]
Date: 2003/11/06 Thu PM 12:19:26 EST
To: Multiple
most of the oracle docs state that when you partition a table you will get the most
performance benefits by splitting the datafiles for each partition onto seperate
storage devices.
Im on an NAS and all I see are logical mount points. What are your recommendations for
this?
--
Please see
i dont think social security number is actually unique. I heard that there are some
repeats and there are problems with people who are 80 years old drawing money out of
accoutns of people who are 25 due to this problem.
i know its a standard to use SSN as a key, but it might not be accurate.
This comes from $ORACLE_HOME/rdbms/admin/utldtree.sql
I expected to see a dependency here, but did not. Any idea? Im testing because I need
to use these views to write some code.
CREATE OR REPLACE PACKAGE X IS
PROCEDURE Y;
END;
CREATE OR REPLACE PACKAGE BY X IS
PROCEDURE Y IS
BEGIN
im not concerned about the type of join. Im strictly concerned about the join order.
does oracle use histograms and distinctness in determining join order? The odd thing
is that it chose a different join order on these tables earlier and on 'similiar'
joins(ie large number of records and only 4
are histograms only used to determine whether to use an index or join type, not join
order?
From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/11/05 Wed AM 11:49:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: explain plan conundrum
However, since
do people actually use a table as a counter these days? Now Im 'assuming' they are
jsut people who dont know about sequences or are there actually 'professionals' who
know about sequencse and decide not to use them.
id assume those tables were used in oracle 5 days because either sequences
cant you use rownum with a 'merge'?
From: Khedr, Waleed [EMAIL PROTECTED]
Date: 2003/11/05 Wed AM 11:34:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: External Tables question
What about rownum?
Waleed
-Original Message-
Sent: Wednesday,
I go to the 9iAS application server docs page and there are tons of docs. What do i
read first? I flipped through the 'concepts' document and its all over the place.
I dont know what I want to learn, since this isnt for work. I just want to get a feel
for it.
also, I believe i read somewhere
Ive read the stuff on OTN. I read rene nyffenegger's stuff on his page. any other docs
on this out there you can recommend? Id prefer not having to hunt through google.com
for them.
i dont create databases at work. Look for stuff on Windows and Linux so I can play
around at home.
--
Please
I cant sql trace it now. I hae run statspack. this query is running now and I dont
want to run another copy with a trace on until this finishes, since I dont want to
suck up resources. Im at a loss as to where the 20 billion rows comes from in this
explain plan? Everything including the indexes
some more info.
I checked distinct values in those two tables. and there are 366,000 records in one
table and 5,000 records in another however, the column that is joining to only has 4
distinct values. I added a bitmap index to the columns and its using it on the smaller
table.
Im willing
i figured it out. I use the ordered hint. Its actually a 3 table join and I took that
out for simplicity in my question. I drove off a more selective join. Got it to run in
1 minute.
i almost never have to use ordered hint
From: [EMAIL PROTECTED]
Date: 2003/11/04 Tue PM 01:34:26 EST
To:
there is an ora-600 query screen on metalink. it has limited amounts of information.
ora-600 is not documented anywhere else.
you need toopen a TAR immediately. ora-600 is not well documented. if you dont have a
support plan, you may have a problem.
From: David Boyd [EMAIL PROTECTED]
Date:
everything is analyzed. For all indexes, for all indexed columns.
I used analyze. its the same as dbms_stats, just not as robust. I use it when I dont
feel like typing out dbms_stats.
Are there optimizer parameters that help the optimizer determine join order? Ive never
had to use the
I picked up Mark Gurry's SQL pocket reference on Friday and it states that you can
radically improve performance of 'where exists' statements by using semi-joins since
it only returns the sub-query ones.
Now logically you have to return the sub-query repeatedly, this would only come into
play
if thats the case, how is a semi_nl useful? its doing a nested loop also.
There is alot of academic talk on semi-joins on the web, but I cant find an algorithm
anywhere. The basics of it appear to be generic.
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/11/03 Mon PM 12:49:25 EST
To:
ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts
performance.
which is similiar to normalize until its inconvenient.
you could have some real fun and try to explan the boyce-codd normal form from an
academic text book :)
From: [EMAIL PROTECTED]
Date:
the person who made this post has a habit of asking hte exact same question on this
forum and lazydba.
i hope he dosent decide to expand that to 5-6 forums.
From: Yong Huang [EMAIL PROTECTED]
Date: 2003/11/03 Mon PM 02:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
doa google search for lydian third howard rogers site got mirroed. it was down
for a while, but was up last time i checked. go to books. 9i new features doc is
there.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/31 Fri PM 02:34:26 EST
To: Multiple recipients of list ORACLE-L
Total Pages Examined : 1280
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1
Total Pages Empty : 1279
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages marked corrupt:
if you have a tablespace with 10 datafiles. can you drop just one datafile?
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/10/29 Wed AM 08:04:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: How to drop a datafile ?
export the data (make sure you get
disregard my question. i saw it in an earlier post. sorry i have several hundred
emails this morning. i missed it.
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/10/29 Wed AM 08:04:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: How to drop a datafile ?
the only book out there that is any good is High Performance Tuning by Guy Harrison.
Ignore the part where he says that a cursor with an update in the loop can be faster
than using an update with where exists. That is inaccurate.
the rest is solid.
unforunately its not that simple. How you
the original poster sent me an email stating that he doesnt want a book or
documentation, he just wants some sort of short cut template. i replied that if one
exists its garbage. He didnt respond.
A side note, it seems to be in vogue to recommend advanced books like carrie millsap's
and tom
it means you need to be able to handle stupid questions without losing your temper.
the best people to ask on this are the hardware support guys. They get the true
'gems', when it comes to stupid questions. They should provide training to oracle
dba's on the topic.
I was at a conference
i guess i jumped to conclusions, but i took it from the level of his questions. 'basic
template' = looking for shortcut = what people look for when they are new to something
and want to get started quick = not always a bad idea.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/29 Wed
from basic set theory:
union = OR
intersect = AND
select e.id, e.name, d.deptname from emp e, dept d
where e.deptno=d.deptno and e.name='JOSE'
or d.deptno = 50;
From: Linda Wang [EMAIL PROTECTED]
Date: 2003/10/29 Wed PM 12:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL
for a fair contracting rate, I could offer training? since Im apparently a renowned
expert on the subject.
From: John Spencer [EMAIL PROTECTED]
Date: 2003/10/29 Wed PM 01:44:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Perm job opening in MA
Ryan,
jared you have been doing this for what 10-15 years now? take someone with little to
know background in this field and little to no technical experience.
tom kytes book is rough and dense from their perspective. soemtimes people forget how
far removed they are from the true beginner. There is
not sure its about sink or swim. I think its more productive for them to start with
basic stuff and get grounded in that first. Saves time. Saves frustration and they
learn faster.
From: [EMAIL PROTECTED]
Date: 2003/10/29 Wed PM 02:54:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL
check out asktom. its up for today. if you use an 8i tkprof on a 9i trace file, you
get bad cpu results.
are you doing that?
From: Muqthar Ahmed [EMAIL PROTECTED]
Date: 2003/10/28 Tue AM 11:04:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Execution Plan is
yes bchr is only useful at extremes, but its based on interpretation. if you have a
very high BCHR, you probably have alot of very bad sql.
if you have a very low one AND are in a type of application where you should(namely
OLTP) you may want to consider increasing your buffer cache.
mladen
materialized views have the create statements in the database. you just have to
refresh them.
can you refersh a materialized view in parallel? if not than create can be faster...
From: David Boyd [EMAIL PROTECTED]
Date: 2003/10/28 Tue PM 12:04:25 EST
To: Multiple recipients of list
does toad or the oracle instance itself slip in rule hints? We got an ora-600 error
off of a data dictionary read. i think it has to do with explain plan.
ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [],
[]
Current SQL statement for this session:
select /*+
none of the apps have documentation. not forsm, reports, or discoverer and noone is
writing updated books on them since they dont sell enough copees.
i dont understand oracle on this one. atleast they can write one and sell the damn
thing...
From: Tracy Rahmlow [EMAIL PROTECTED]
Date:
does the data dictionary still use rule by support? any idea why toad would bother
slipping it in?
From: John Shaw [EMAIL PROTECTED]
Date: 2003/10/28 Tue PM 02:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ora-600 question
TOAD puts a hint in.
because its not always faster to use an index. try using a hint for the index and see
which runs better.
From: David Wagoner [EMAIL PROTECTED]
Date: 2003/10/27 Mon AM 10:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Query Tuning Help
I'm trying to tune
I need to parallelize some sql operations and Im running them from unix scripts.
I want to spawn off a few in the background from a master script, then have the master
script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I
cant dig up the syntax to do this with korn
anyone use these? Oracle support said db_block_checksum can create major performance
issues.
im trying to track down an ora-600 error and oracle support said we should possibly
try using these.
anyone have any experience with this?
--
Please see the official ORACLE-L FAQ:
if you attemp to wait after the process is complete, will it cause a problem? say the
PID no longer exists when you issue wait?
From: Dunscombe, Chris [EMAIL PROTECTED]
Date: 2003/10/27 Mon AM 11:39:34 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: wait/notify
101 - 158 of 158 matches
Mail list logo