Re[2]: sysmaster extents

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable I have a couple of questions on this then=2E =20 I've got nothing set for DD_HASHSIZE or DD_HASHMAX=2E onstat -g dic=20 reports 357 dictionary entries, but surely the maximum size is 310? =20 Also, only 14 of these entries are system catalog tables, but surely=20 if these tables remained in cache, this number would be higher? =20 Am I simply missing something obvious here? =20 Davin =20 7=2E23=2EUC6 on AIX 4=2E2 ______________________________ Reply Separator ____________________________= _____ Subject: Re: sysmaster extents Author: PC {kagel@bloomberg=2Ecom} at INTERNET Date: 13/05/1998 07:40 Paul wrote: >=20 > I am running Online 7=2E23=2EUC4 on HPUX 10=2E20=2E > Is it important for the DBA to be concerned about the number of extents i= n=20 > the system catalog? > I have plenty of room in root to accomodate the growth=2E =20 No 1) There is nothing you can do about it anyway and 2) The system catalogs remain resident in the Data Dictionary Cache=20 anyway so accessing the catalog pages from disk is rare=2E If you have=20 more than ~300 ACTIVE tables in all database in the instance you can=20 increase the size of the Data Dictionary Cache with the DD_HASHSIZE and=20 DD_HASHMAX config file parameters=2E The former must be a prime number=20 and defaults to 31 the latter defaults to 10 the product of these is=20 the size of the cache=2E =20 =20 Art S=2E Kagel =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--