On Friday 15 June 2001 15:47, Don Granaman wrote:
Can anyone stop this spam? This isn't the first time for OraStaff!
Sorry, we don't consider it spam here. These ads are posted for
new position, and only reposted weekly if not filled. Many of
us consider this a service, especially the way
On Friday 15 June 2001 06:00, Rachel Carmichael wrote:
There was a manager in that same shop who measured her programmers
abilities by the number of lines of code they wrote in a day. She also said
to me once I don't like to waste time on design
Rachel,
Remember the Dilbert where the PHB
Sorry to tell you this Long, but the reason you are
having this problem is that you compiled Perl by setting
LD_LIBRARY_PATH=/usr/local/lib.
This shouldn't be done. It should be compiled *without* setting
LD_LIBRARY_PATH, other than for Oracle software. I saw that you
did this in a previous
Hi All,
I had some situation of Redo Allocation and copy latch
contention as stated in following output.
SQL SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS,
IMMEDIATE_MISSES
FROM V$LATCH WHERE NAME LIKE '%redo%'
/
NAME GETS MISSES IMMEDIATE_GETS
I will be on annual leave until Tuesday 26th June.
For matters that cannot wait until then, please email Ray Feighery at
[EMAIL PROTECTED]
or phone +61 2 8437 6311
Thanks and regards
Jeffrey Lim
Infrastructure Consultant
RecruitASP Pty Ltd
PO Box 300, St Leonards
New South Wales 1590
Hi
I'm looking for docs that explain tuning of SQL statements. But, no stories
about latches, buffers, TKPROF, blocks, V$ views... Just simple (or
advanced?) tips on:
- ordering of tables in FROM part of select (where goes the largest table,
and where to put the smallest table), and why is it
There are reorgs to fix fragmentations, and reorg to
reclaim dirty space. LMT's fix the former but not
necessarily the latter.
I do believe tho' that the days of unloading the
entire database and reloading it (with the exception
of changing the blocksize) should be a thing of the
past
hth
Oracle Financials 11i asks for 14000 semaphores:
When I do the calculation as per the Oracle Guide I come to about 1000.
Anybody know why the disparate nature of these numbers. Can semaphores be
set to such high levels.
I can RTFM, but wonder what lists comments are before
Sam
--
Please
Amar,
That's the whole point Jared was trying to make: your
locking issue is because you *don't* have indexes on
your foreign keys.
You might want to review the following notes:
11828.1 FOREIGN KEYS, INDEXES AND PARENT TABLE
LOCKING
33453.1 (V7) REFERENTIAL INTEGRITY AND LOCKING
38373.1
Connor,
Reorgs to change the blocksize are reduced even
further in 9i since multiple blocksizes are allowed in
the same database, although you still can't change the
default blocksize without rebuilding.
The new free list allocation mechanism looks pretty
slick too.
Definitely lots of new
On Fri, 15 Jun 2001,Raymond Lee Meng Hong scribbled on the wall in glitter...:
-what is EBCDIC format
-
-I have a customer from IBM DB2 mainframe going to pass data to my oracle
-system for matching of record ,what they told me is the tape is in EBCDIC
-format ? I don't have any experience on
connect internal has been removed from 9i you will have to login as
sys/password as sysdba thro sqlplus even the svrmgrl has been removed.
this I think oracle has been saying from 8i version itself that they will
be removing connect as internal in the future version
From: [EMAIL PROTECTED]
A. Bardeen wrote:
Reorgs to change the blocksize are reduced even
further in 9i since multiple blocksizes are allowed in
the same database, although you still can't change the
default blocksize without rebuilding.
At last. 'blocksize' has been an attribute in SYS.TS$ since the early
days of
Take a look at my website, I recently wrote a 32 page document on tuning
sql. I would be very interested in getting feedback from what you think of
it.
www.vampired.net under articles.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R.
No, that IS MegaBytes
Generic PRICE FOR ONLINE ORDERS ONLY - 512MB 168 Pin PC100 MUST MENTION
PRICE WATCH - SDRAM - HIGH DENSITY; CAS2 ;NeutronUSA# 442185 - Volume
DISCOUNT AVAILABLE $ 56 $12.85 2nd Air 6/15/2001 6:52:56 PM CT
NeutronUSA.com
800-813-4218
814-237-0902 PA -
The 150MHz went up a
First of all, if you don't see cumulated waits for the 'latch free' event in
either v$system_event or v$session_event (for a specific session/job) there
is absolutely no need to do anything about these ratios. It's about the only
two latches mentioned in the reference books and it's about the
But each different block size requires its own buffer cache. If you haven't
configured the seperate buffer cache, you cannot add tablespaces with a
different block size to the database.
Stephane Faroult wrote:
A. Bardeen wrote:
Reorgs to change the blocksize are reduced even
further in 9i
Rajesh:
I'm a bit confused here. You say that you are going to tune your redo
allocation latch contention, but, based on the output presented, you don't
have any redo allocation latch contention. The threshold to determine
contention is misses/gets = .01 or
I've recently completed my last exam to achieve OCP status and I'm looking
for a jr DBA position in the Twin City area. I'm currently employed as a
database developer. My problem is I have no hands on DBA experience. Any
suggestions? Thanks in advance for any leads or suggestions!
Jim
Mogens,
You are right.
nothing is a performance problem unless there is a time contention.
In general, it's very hard to see time spent in each latch. itrprof SQL Analyzer
with waitgroup=(name,P1,P2) can report time spent in each latch. So, you can see
time spent in A latch, time spent in B
My theory is this.
A loosely used ratio for performance reviews.
(Number of Bugs Resolved x Number of Projects x Number of lines of code -
(Bugs introduced in your code x 500))
But use this with a grain of salt as many things are involved in programming
and lines of codes, bugs, and number
Setting it too high may cause additional content switching.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Saturday, June 16, 2001 4:26 AM
To: Multiple recipients of list
Basically IBM's version of ASCII
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 10:40 PM
To: Multiple recipients of list ORACLE-L
b
what is EBCDIC
1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What
are
the golden rules. I have seen some authers not mentioning this.
Yes, it is okay to set it higher than this. It won't degrade the
performance, but don't expect any considerable gain in the performance
either.
Elias,
I don't know much about JDBC, but I suspect that like
ODBC it sits on top of the Net8 layer. By default,
Personal Oracle on Win95/98 doesn't automatically
start the listener the way the TNSlistener service
does on NT/Win2K, so try manually starting the
listener from the command prompt:
Or with Cary Millsap's hprof/Sparky stuff (hotsos.com). I'm deligthed that guys like
you and Cary are writing tools/products that harvest the enormous amount of useful
stuff available in 10046 level 8/12 trace files.
You know what would be really cool? The same stuff is available via x$trace.
Steve,
You might also want to test setting
optimizer_max_permutations 8.
By design, the CBO considers multiple starting tables
and restricts permutations during OR expansion when
optimizer_max_permutations 8. This can have a
significant impact on queries that join a large number
of
Hierarchical, network and relational. That's what it was.
My true age is - as per 4th of May this year - is 40. Big party, band playing,
etc. About 130 guests. My wish list for all the guests I had invited was very
short. Among the very few items were black socks, the latest book by John le
Hi again,
Thanks for your tip Anita, but unfortunately I still
get the same error message. So I guess I am still
taking suggestions.
Elias S. Mouchantaf
Tel. (+961) 3 740319
[EMAIL PROTECTED]
www.moshnet.com
Quoting A. Bardeen [EMAIL PROTECTED]:
Elias,
I don't know much about JDBC, but I
Hey John,
If you had come to IOUG-A 2001! conference and attended Cary's
presentation, you would have been part of a special group (all the attendees
in the room, that is) that yelled out Happy Birthday, Mogens over a
cellular phone call to Mogens.
Now, who can top that idea (Cary's, I
On June 16, 2001 04:35 am, Jared Still wrote:
Many of
us consider this a service, especially the way that jobs are
at the moment.
Amazing the difference a year can make, eh?
Cheers,
GC
(obviously a canuck)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gregory
--- Hillman, Alex [EMAIL PROTECTED]
wrote:
Sort allocate memory in chunks of 8K,
Is that the general rule or does it depend on any
parameter?
should worry only in case
when there are too many users who are doing large
sorts simultaniously. Also
I think memory is freed when records
silent about when the memory is returned to the OS. Is
it when user session ends or at instance restart?.
When the session ends.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hi All,
Before I explain what I did, here is the system
configuration details :
Hardware :
CPU : Intel Pentium III 500 Mhz
RAM : 256MB
HDD : 15GB
Software :
OS : Solaris 8 for Intel
Oracle : Oracle 8.1.7 Rel 3
I first changed the /etc/system file by adding these
entries as it is
Hi Pankaj,
With 256 MB RAM, you may not be able to set
set shmsys:shminfo_shmmax=4294967295
Try setting it to lower values 1-2 GB, It should
resolve the issue. Of course it shdn't have any impact on
Oracle's functioning ( If you have just 256 MB, you can't
allocate 4 GB to
Hi Rajesh,
Thanks for the info. I was not aware what shmmax value
was, though, I knew it is related to memory.
I had even left the /etc/system file unchanged during
my 2nd installation attempt (I had copied system to
system.org) and tried. But it fails there too.
Thanks,
gopi
--- Rajesh
36 matches
Mail list logo