Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Maxextents unlimited on LMT ?

Re: Maxextents unlimited on LMT ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 10 Jul 2002 20:39:12 +0100
Message-ID: <3D2C8D60.6FAE@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US