Title: dba_waiters.lock_type = "Disk Space Transaction" - significance?
Analyzing a table (analyze...estimate/compute
statistics)will put a lock on the library cache object preventing any ddl
changes, but any dml should be okay.
Analyzing to validate the structure of a
table(analyze
Alex ,
to answer your question ,
yes any index creation will force reparsing of the
SQL.
At least it did on my 8.1.6 on HP ;)
-RS
--- Hillman, Alex [EMAIL PROTECTED]
wrote:
!! Please do not post Off Topic to this List !!
You mean it invalidates SQL which has references to
the newly analyzed
Hi,
I wonder if I can get a copy of your utility.
Regards,
Mario Alberto Ramos
[EMAIL PROTECTED] 13/09/01 18:45
!! Please do not post Off Topic to this List !!
Here is what it does so far:
first off you HAVE TO GET a versio of strings that is NOT brain dead,
meaning it has to be able to
Larry's answer is totally correct -
The SQL reads:
select /*+ use_nl(t2) *./
etc
from t1,t2
where t1.id = t2.id
etc
But manages to hash from T1 to T2.
(I had to play around a little bit to
make the tables and rows the right
size for this to happen).
Looking
You don't quote a version of Oracle - which makes
a difference to the ROWS column on the execution
path.
However, I think you are seeing the extra I/O because
Oracle is driving off the main table, then executing the
subquery for each row returned - thus executing your
5 logical I/O many times.
One tip Patrice is to download from a non-US server, as you will usually
find less traffic on a non-local server due to the time zones..
Mark
-Original Message-
Patrice J
Sent: Friday, September 14, 2001 19:45
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to
I am wondering how my fellow DBA's fit into their IS organization. My
situation is this. I was hired just a little over a year ago as a DBA but
my official title is network programmer. Except for some job scripting I
have not done any coding. I am the only DBA for 5 Oracle databases and 4
SQL
The 8.1.6 and above Enterprise Edition
comes with the Parallel Server Option
(along with the advanced replication etc..
in the same 'page'!)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi
I am sorry if someone has replied this
But can someone PLEASE tell me
if IBM supports OPS
across their SP frames.
or only support OPS WITHIN SINGLE SP frame?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL
Farnsworth, Dave wrote:
I am wondering how my fellow DBA's fit into their IS organization. My
situation is this. I was hired just a little over a year ago as a DBA but
my official title is network programmer. Except for some job scripting I
have not done any coding. I am the only DBA
Title: Message
Big:
Try
increasing the buffer_size parameter on the import to 1 mb.
Jon Walthour
-Original Message-From: Big Planet
[mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001
9:40 PMTo: Multiple recipients of list ORACLE-LSubject:
ORA-04030 error
Hi
Hi Larry, Jonathan
thanks for your answers. I haven't heard about sides swapped effect before your
postings. Larry, I
had a thought about exact the same path (I mean the links you posted :-) to go into
details.
Jonathan has already posted the info I was going to check That's enough for my
In our organization, the DBA position is within network services, because
the DBA is also the Unix Administrator. I find it works well, because
I have access to the actual systems running the databases. If I was
with the other group (applications) I would have to ask somebody in
networks to log
Hi List,
I'm going to change my job and I'll have to inherite one DB which doesn't seem to be
very good
designated. I haven't known much about the application yet and I can't post many
details to you but
I would appreciate your general advices.
Despite of the optimizer_mode set to RULE at
Dave,
In our organization we have the DBA's/UNIX SA's under IS Operations. We are
primarily responsible for production support, but are also assigned to
project teams for development. As for reporting we report to the Dir. of IS
Ops who is at same level as Dir of App. Dev. Both of them report
Funny... I came in today to get out of my house. But I guess that's what 2 kids
under 3 will do to you... : )
Rodd Holman wrote:
Dave,
In our organization we have the DBA's/UNIX SA's under IS Operations. We are
primarily responsible for production support, but are also assigned to
project
in our place , i'm under the data center. i'm not sure that's the right
place but since we have access to the production databases, and since
there's only 2 of us for both production and development, it's better
than being under the development organization.
--
--
Bill Shrek Thater
Right now I am kind in
limbo with no real authority
Just getting a job title won't do much.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
We have something slightly different, small organization as well.
CTO has three groups reporting to him: programming, network and operations
operations has 2 groups, sysadmins and dbas
I could, if I wanted, have root access. I don't want it. I don't know enough
to be a sysadmin, but I DO
At my last job, my supervisor reported to the Manager of IT as did the manager of
AppDev. Where I am now, there are so many levels of damanagement (ok some of them are
managers not DAmanagers) that all I know is that the AppDevs, SAs and DBAs all report
to a different VP. So when a group
With 8.1.7, you won't need to schedule a reboot of the server after 248
days of oracle being up... [can't remember the exact amount of days, but
if you are on solaris, be prepared to reboot the machine, as oracle will
not shut-down.]
Doc ID: Note:118228.1
248 Days
Type: ALERT
At 03:40 AM
Hi lists
the flwng
DECLARE
V_sal emp.sal%type;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno=p_empno;
IF v_sal2000 then
UPDATE emp
SET sal=sal*1.2
WHERE empno=p_empno;
END IF;
END;
When I run the above, the first time the is asking the empno. But the
next time I run it is taking the same
22 matches
Mail list logo