| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Maxextents unlimited on LMT ?
Jonathan Lewis wrote:
>
> Whoops !
>
> I can't believe I fell into that trap.
>
> The number of times I've explained how
> initial, next, and minextents get used (abused ?)
> when you have LMTs.
>
> >
> >And 10 updates to tsq$ shouldn't
> >have taken that long anyway.
> >
>
> Yes, I'll believe that 990MB/32K = 31,680
> inserts might take that long.
>
> Do you want to ask Pete how big his
> log buffer and redo log file were, and
> how many times he checkpointed in the
> period ?
>
> On the other hand, is it possibly that one
> of you has a version of Oracle which updates
> tsq$ on every extent release, and the other
> has a version that updates only when the
> segment is released. It might be worth
> checking your v$sql after the test for the
> number of executions of updates to tsq$.
> (It might also be worth checking the value
> in tsq$, or the user-friendly view, to see
> if your quota has actually been given back).
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminars
> UK July / Sept
> Australia July / August
> Malaysia September
> USA (MI) November
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Jonathan Lewis wrote in message
> <1026249931.1873.0.nnrp-10.9e984b29_at_news.demon.co.uk>...
> >
> >Here's an oddity -
> >
> >How come the create reported time
> >correctly, but the drop fell back into
> >the mod(60) bug on the seconds ?
> >
> >And 10 updates to tsq$ shouldn't
> >have taken that long anyway.
> >
> >
> >--
> >Jonathan Lewis
> >http://www.jlcomp.demon.co.uk
> >
> >Next Seminars
> > UK July / Sept
> > Australia July / August
> > Malaysia September
> > USA (MI) November
> >http://www.jlcomp.demon.co.uk/seminar.html
> >
> >Connor McDonald wrote in message <3D2B34C3.1E50_at_yahoo.com>...
> >>
> >>Table created.
> >>
> >>Elapsed: 00:02:04.57
> >>SQL> drop table x.p;
> >>
> >>Table dropped.
> >>
> >>Elapsed: 00:01:92.14
> >
> >
> >
(To be honest I can't remember if this is the trace from the same test) but tkprof gave back:
select file#
from
file$ where ts#=:1
call count cpu elapsed disk query current rows
Parse 3953 6.90 7.27 0 0 0 0 Execute 3954 0.82 0.82 0 0 0 0 Fetch 7908 0.92 0.88 0 7913 0 3954
total 15815 8.64 8.97 0 7913 0 3954
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
update tsq$ set
blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8
where
ts#=:1 and user#=:2
call count cpu elapsed disk query current rows
Parse 3949 6.32 6.56 0 0 0 0 Execute 3948 4.63 4.86 0 15792 3948 3948 Fetch 0 0.00 0.00 0 0 0 0
total 7897 10.95 11.42 0 15792 3948 3948
Then again - lets face it - quotas are just DBA's being mean anyway :-)
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Wed Jul 10 2002 - 14:39:12 CDT
 |
 |