Re: Wierd slow "comment"

What's your shared_pool_size looking like? (yeah yeah yeah, and db_block_buffers), and how fragmented is your SYSTEM tablespace?

What you're complaining about sounds like something non-good with all the parameters and physical life of the data dictionary and the SYSTEM tablespace.

Comment on...

never seemed to take much time to execute for me, on any platform, so there's either a big contention problem, lack of memory somewhere, enormous fragmentation of SYSTEM, etc. If someone or someTHING is doing DDL ops, that would definitely be nasty, as DDL needs exclusive locks; but you didn't mention any error messages; what does your alertxxx log say? Any trace files being generated?

All I can think of as the root cause is either other operations contending for locks on your comment-on objects, a badly fragmented system tablespace that of course would affect the data dictionary, SGA memory tuning problems, or, (no insult intended), unrelated processes running that are sucking up CPU cycles or other resources.

What do sar, vmstat, and top say when you're running these scripts? And is the database in RESTRICTED mode and you are certain nothing and nobody but you and your script are accessing the instance?

Apart from that, the well is dry. One of the gurus here will have to give their two cents; I'm just a grunt.

RSH. I trust no other operations are going on at the same time this script is running?

"broom" <broom_at_voicenet.com> wrote in message news:c948eb61.0202271819.179718bf_at_posting.google.com...
> I'm doing a scripted install of Oracle 9.0.1
> on Solaris 8. All my files are Veritas qio.
> 4 CPU Ultra 450. 2GB memory.
>
> I decided to watch, and discovered something amazing.
>
> When I run CreateDBCatalog.sql, there is a huge lag between
> each comment, as in:
>
> SQL> comment on column DBA_INDEXTYPES.INDEXTYPE_NAME is
> 2 'Name of the indextype'
> 3 /
>
> Comment created.
>
> SQL> comment on column DBA_INDEXTYPES.IMPLEMENTATION_SCHEMA is
> 2 'Name of the schema for indextype implementation'
> 3 /
>
> Comment created.
>
> SQL> comment on column DBA_INDEXTYPES.IMPLEMENTATION_NAME is
> 2 'Name of indextype implementation'
> 3 /
>
> I can wait 2 minutes between each of the above statements.
>
> Any ideas?
Received on Wed Feb 27 2002 - 23:48:39 CST