And has DBA privs and well-known default passwd, which I alter to a random
string (not using OEM here...)
"Holman, Rodney" wrote:
>
> Ron,
> That's the good old Oracle Intelligent Agent for Enterprise Manager. It
>
> is the ID that talks to the OEM console for events reporting.
>
> Rodd Holm
Title: RE: Shared Memory Problem
Another thing to consider is if you are using Multi-threaded Servers for
your connections. If you are and have not set a Large Pool size,
then memory is consumed in the Shared Pool for a subset of the session
memory.
If you
are using MTS with Siebel, ha
Rajesh,
touser's temporary tablespace is temp, do have
any other idea's as to why system tablespace is
suddenly running out of space?
Thanks
abdul latif
--- Rajesh Dayal <[EMAIL PROTECTED]> wrote:
> Check whether the user TOUSER has a default setting
> of
> SYSTEM tablespace for "TEMPORARY TABL
The Oracle listener has a major security hole. The following is taken from some
patch notes.
# The patch allows a database administrator to restrict run-time
# administration of the Oracl
For long term solution,increase your shared pool size and also introduce
some shared_pool_reserved size...
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 11 May 2001 14:29:18 -0800
Try to flush shared pool.
Rivaldi
-Original Message---
This is a user generated error - typically 2 to
20999 are when people use to raise their own errors
using the raise_application_error built in.
hth
connor
--- Pat Hildebrand <[EMAIL PROTECTED]> wrote: > Has
anyone any idea what this means?
>
> It is coming up when trying to use a procedure
Also there is possibly some merit in hash partitioning
the index rather than reversing it to avoid the
"leading edge" index problems that reverse keys are
targetted to resolve...
COnnor
--- Jared Still <[EMAIL PROTECTED]> wrote: >
> I haven't either.
>
> The only make sense in a high activit
Hello,
I think, there are 3 factors in performance tuning:
- Time
- Amount
- Speed
Most imporatnt factor in performance tuning is the time. Of course others are
important, too. But, others are indirect indicator. For example:
- 1 block 1000 ms
- 1000 block 1 ms
As we see above, second one tak
Thank you,
Yes, you are rihght. it was broad question. I meant all block structures.
and I mean, not only data in block structures, but also data offsets in
block structures.
[EMAIL PROTECTED] wrote:
> Unal, What part of the block sturcture? Segment Header,
> Datablock Header? There are things
I haven't either.
The only make sense in a high activity OLTP database, and my OLTP
experience is with 50 users and less. I dont' think most DBA's are on
high activity OLTP systems anyway, so you don't hear too much
about this kind of stuff.
Jared
On Friday 11 May 2001 23:57, Vikas Kawatr
Check whether the user TOUSER has a default setting of
SYSTEM tablespace for "TEMPORARY TABLESPACE".
You can perform this check by following query:
Select temporary_tablespace from dba_users where username = 'TOUSER';
If the result points to SYSTEM tablespace, then alter the user as
follows:
Whichever user you using to import has
a temporary tablespace and default tablespace
set to SYSTEM?
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> I'm doing an fromuser touse
Thanks Jared ! What I read makes a lot of sense- But what suprises me is -
that I haven't come across anyone really using Reverse key indexes for
Synthetic (surrogate Primary keys).
Have you ?
vikas
-Original Message-
Sent: Friday, May 11, 2001 11:42 PM
To: [EMAIL PROTECTED]; Vikas Kaw
13 matches
Mail list logo