Cary,
Thank you.
Could you elaborate on the issue of excessive database calls, which show up
as excessive network traffic?
I can picture a PL/SQL loop, which executes an SQL statement over and over
again. This would produce many database calls, and it might be possible to
remove the loop
Greg,
That's one case. PL/SQL is a really poor language in which to write an
application. The language tricks you into believing that writing a
scalable application can be accomplished in just a few lines of 4GL
code, but it's really not true. To write scalable PL/SQL, you need to
use DBMS_SQL.
Babette Turner-Underwood wrote:
Does anyone on this listserv using Oracle on a mainframe?
I was asked today if I can use Oracle's extproc feature on the mainframe to
submit JCL. I said that I doubted it because the OS structure is so much
different than UNIX or NT, but I would look into
Does their has way that can download (or purchase CD) all the ORACLE
Openworld documents?
Thanks.
_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
--
Please see the
There is an (older) paper on www.jlcomp.demon.co.uk,
and some very good info on www.ixora.com.au
hth
connor
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
Any Good Docs , Links , sources ?
Need to present a paper to the Managers
Thanks
--
Please see the official ORACLE-L FAQ:
In some cases, NOT IN is better than NOT EXISTS. In
other cases, the opposite is true.
Moral: It never pays to discount an option out of hand
- eg, NOT IN often works very very nicely for
uncorrelated subqueries
hth
connor
--- Post, Ethan [EMAIL PROTECTED] wrote: Hold
the press. NOT IN
On index-obsessed apps, you'll often see massive
amount of LIO to a target of a nested loop. ie, scan
mega table and then index probe the inner table for
every row of the mega table...
Generally you'll see smoke coming out of the index
root/branch blocks on the target table :-)
hth
connor
---
With the advent of bulk bind and bulk collection
facilities in PL/SQL, you can get very close to the
correct SQL mechanisms...its just that not many
people tend to do it, and you end up with a gazillion
'one-row-at-a-time' applications out there.
Cheers
Connor
--- Cary Millsap [EMAIL PROTECTED]
How about switching to incremental (from full) backups? Even if all you
do are level-0 backups?
My understanding of the difference between a full and a level-0 backup
(besides the obvious impact on any subsequent level-n incremental backups)
is that level-0 backups only back up database blocks
Tim, i'd be glad to hear someone else verify your statement as my
understanding is the the only difference between full and level 0 is
that full cannot be used as part of an incremental strategy, other than
that they both back up the ever used blocks.
Anyone else care to jump in on this one?
Joe Tim,
It is accurate to state the both full and level 0 have the same impact
on the database, and both backup all used blocks. It is also accurate
that a full backup cannot be used as a piece of an incremental strategy.
Although there may be rare instances (no pun intended :-) ) when you
Babette,
This is one of those from this old turd to that old fart messages. I've
been around Oracle since 1985 I love it too. But it sounds like the director
has a serious problem with new technology. Doing anything in COBOL today? Even
PeopleSoft is busy re-writing their code in C++.
Sthepen :
I am very thankfull for you help ...
But it is not all...
Imagine you working at environment that doesn't know the
database, and need to solve problems.
So, the CPU is a item that you helped me to find out the user
that is using it a lot,
and in general, what more can i do, thinks
In the for what it is worth department:
In addition to Dick's comments (with which I agree)
Be careful how you approach this situation. If you wish to succeed, it
may be key to let the powers that be know that you are not proposing
bleeding edge solutions, and that looking down the road towards
Cary M., Connor M., Thanks very much.
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Cobol! Again!:(
-Original Message-
Sent: Friday, November 15, 2002 5:24 PM
To: Multiple recipients of list ORACLE-L
I just found out today that we have a major development initiative that is
starting and they are planning on using Pro*Cobol to develop the
application. (my head is still
Hi All !
I am new to Application Tuning
i have the following queries:
0) where how to start?? the key areas in application tuning.
1) the tips techniques..
2)useful tools scripts
3) othere resources [docs, websites etc]
Best Regards
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your
17 matches
Mail list logo