 | | | Oracle List | | Not sure specifically what your kernel version might be but you 're probably
2.6.9 something. According to Metalink Note 259487.1 "If using kernel
2.4.9-e.16 or later then the hangcheck-timer moduleHi
We are setting up couple of boxes on Linux with different hardware specs
and trying to prepare a document that can be used as general guidelines
for future installations.
In SQL Server instal
Hi Sandra
> > 3) Why would anyone write a statement like this? What would be the
point?
there was a thread on this very SQL statement a while back. Might be
useful maybe not buit here 's the URL > Oracle tracks the CPU usage of its own sessions and presents it in
> gv$sesstat. It may not be accurate but the inaccurate data of one session
> is somewhat accurately relative to that of others. Hi Gurus
Want to have expert comments on Server Hardware and OS Planning.
If you are asked to recommend a server (Hardware/OS) configuration for a
Oracle database server. Then what factors you willRunning a truss on the sqlplus process might provide some further insight
what it 's being waited on. Just remember to trace accross forks (using -f ).
Stefan
On 7/3/07 Graham Ross <grahamaross@(protected)HP Unix is simple - use a top command.
Solaris is not as friendly - but you can use prstat.
When I use task manager in Windows XP I can only see CPU being consumed
by the Oracle.exe process. You mentioned the restore is set to occur to a point in time "some time
after the backupsare completed. " Evidently some of the redo needed to
bring the db to the point in time you 've specified isn 'tOkay it 's a little hokey but why don 't you just create a procedure/package
to check the number of records in the table. If it gets over something like
40 000 do something like "create table as selHi
This problem pertains to Oracle 10.2.0.3 Solaris 2.9 running on an E15K
domain. Many of our 10.2.0.3 databases see frequent errors while trying
to write to audit...
Thu Jun 14 10 36 39 2007
> I think a lot of people are just scared of the word "abort " no matter
how you explain it.
> Perhaps they 'd be less resistant if it was changed to something less
frightening like
> "shutdown noroJoe
I see you are still hoping the guesswork will work. )
You didn 't even provide text of the statement/view definition
execution plans how you test it (in GUI tool fetching first few
rows?). ItI would be interested in this.
I have consultants who put changes in and don 't compile afterwards... I would have something solid to go back to them with and say... see?
They are a prettyMark
> So how can I determine if "the instance was created with an 11.5.1 Rapid
> Install "?? I 'm not an Oracle Apps guy at all?.but I currently *am* the only
> DBA in the office! Is there some waAs Jared says the Richmond Shee book is great. I 've used it many times to help
solve real performance issues and help gain a better understanding of Oracle
performance I 'd highly recommend it.
Chris
We are running Oracle Version 8.1.7.4 on Solaris 2.9
We have a package that keeps going invalid. It uses oracle mail with utl_smtp. We also have been having mail server problems.
1-CouldListers
With a great deal of help from several colleagues at The Pythian Group I
have prepared an open letter to Larry Ellison suggesting that with the
upcoming release of Oracle 11 he should cCan you elaborate on this? I would be surprised to see any significant
performance degradation. Is that those intermittent delays of few
hundred ms you mentioned?
On 7/2/07 Andreas Piesk <a.piesk@(protected) <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " >
<html >
<head >
<meta content "text/html charset UTF-8 " http-equiv "Content-Type " >
<title > </title >
</head >
<body bgcolor "#ffffff " tex <repost >I meant actually to change the subject line to avoid
side-tracking Joe 's thread but hit send too fast so here it is
again... </repost >
Dear list
It was very interesting to track the developmHi
List
We have created a ASM diskgroup with normal redudancy (MAINGP) with two
failure groups (DATA1 DATA2).
We are bit confused with two different answers from two different people
about writing beHi Peter
Looks like query you have is from Siebel Analytics. If you are using DAC to refresh data from Siebel to Siebel Analytics it tends to drop and recreate indexes in order to speedup data load
This looks like a typical use of the 5% selectivity
for a predicate involving an inequality with an
unknown or in a join. See for example the
filter subquery selectivity at
http //jonathanlI post here too regularly and get too much spam to even attempt to make such a correlation... -)
--
Mark J. Bobak
Senior Database Administrator System & Product Technologies
ProQuest
789 E. EisenhI 'm too busy to even read your whole situation in depth (in the middle
of a restore) but in general high cpu use is usually a sign of a lot
of buffer gets which is usually a sign of indexes and nesCan you change this in the "notification schedule ' in the preferences
page as the user who created the job?
Ron Reidy
Lead DBA
-----Original Message-----
From oracle-l-bounce@(protected)
[mailtoI have a query which intermittently returns the following error
@(protected)
siebel.W_ENTLMNT_D T7967
*
ERROR at line 153
ORA-01410 Depends on your partnership level but you may have up to 6 free exams and 25% discounts for other exams. You get 25% discout for Oracle University courses. You also have free access to lots of onlin
LSC is right .
1. SYS is not to be used for Exports. Note#277237.1 explains why
one should not
connect as SYS when running an Export. Essentially since SYS does
not follow the
transaction lev |
|
|
