Re: Bitmap vs btree - how to tell? how to test?
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bitmap vs btree - how to tell? how to test?
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bitmap vs btree - how to tell? how to test?
I am on leave from May 27 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script for identifying objects having freelists contention
Does anyone have the scripts (or URL) for identifying objects having freelists contention? Thanks. Anand Prakash
How to find current mode of standby database
Which dynamic performance view can provide me information whether a standby database (mounted) is in a) managed recovery mode or b) manual recovery mode or c) just mounted. Thanks. Anand Prakash
Message at the start of svrmgrl
I have just done installation of 8.1.7.0 on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. When I start svrmgrl I see a line "inst emulated pid=175364...". --$ svrmgrlinst emulated pid=175364 svrmgrl va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028 Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.2.0 - ProductionWith the Partitioning optionJServer Release 8.1.7.2.0 - Production SVRMGR ^DServer Manager complete. Any ideas? Anand Prakash
RE: Message at the start of svrmgrl
Mike I found a note on metalink (124568.1) which explains the reason. Oracle 8.1.7.x products are not supported on chip prior to EV56. Thanks. Anand Prakash [EMAIL PROTECTED] 12/03/01 12:40PM Anand, I installed the same(? 8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this result. However, I do remember this kind of result with a earlier upgrade to 8.0.x in the distant past. I believe it is a verbose linking option with no negative impact. Is svrmgrl the only executable responding like this. If so, try relinking. Mike Hand Polaroid Corp. -Original Message- I have just done installation of 8.1.7.0 on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. When I start svrmgrl I see a line "inst emulated pid=175364...". --$ svrmgrlinst emulated pid=175364 svrmgrl va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028 Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
RE: How long are statistics good for
John My initial tests indicated that not all tables which had any DMLs were getting into the'stale category'. I checked the ratioA/B where: A is the sum of inserts+deletes+updates from user_tab_modifications B is num_rows from user_tables (or user_tab_partitions). I observed that if this ratio exceeded 10%, package dbms_stats analyzed theobjects with 'GATHER STALE' option. (But I get error for the partitioned tables with this option). Anand [EMAIL PROTECTED] 10/23/01 05:20PM Anand,Just curious : Is there some test or other observation that you can sharewith the list about dbms_stats using 10% as a boundary for staleness?John KanagarajWhich version of Oracle are you using. In 8i you can set 'monitoring on' forthe tables and use dbms_stats to analyze stale. (Though, I am getting errorwhile using dbms_stats for the partitioned tables. So I have made a homemade version to analyze stale). As per my calculations, package dbms_statsconsiders statistics stale if all DMLs affect more than 10% of number ofrows.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: John Kanagaraj INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: How long are statistics good for
Which version of Oracle are you using. In 8i you can set 'monitoring on' for the tables and use dbms_stats to analyze stale. (Though, I am getting error while using dbms_stats for the partitioned tables. So I have made a home made version to analyze stale). As per my calculations, package dbms_stats considers statistics stale ifall DMLsaffect more than 10% of number of rows. Anand Prakash [EMAIL PROTECTED] 10/23/01 11:00AM We have a data-warehouse that is a combination of Snapshots and table-buildsbased on the snapshots.The table builds run at 4:30 am, scripts are setup to start the snapshots at7:00am and end at 9:00pm. At 6:30 am a script performs an analyze on ALL (except sys andsystem) tables inthe database.If the snapshots have been running all day, should I run an analyze before Ido the table builds?as opposed to after ?At what point do the statistics on a table become no good ? when a new rowis added ?ThanksDarren--Darren Browett P.Eng This messagewas transmittedSystems Analyst - Information Systems using 100%recycled electrons City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Browett, Darren INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: DBMS_STATS
What kind of problem? [EMAIL PROTECTED] 07/11/01 12:30AM I don't know from Steve. However I can tell from my experience that the options GATHER STALE and GATHER EMPTY have problems. Regards. --- Anand Prakash [EMAIL PROTECTED] wrote: Steve You mentioned about dbms_stats having some teething problem on version 8.1.6. Can you provide some more details? I was planning to implement on version 8.1.6.2 on Compaq Tru64 unix 5.1. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_STATS
Steve You mentioned about dbms_stats having some teething problem on version 8.1.6. Can you provide some more details? I was planning to implement on version 8.1.6.2 on Compaq Tru64 unix 5.1. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Does ALTER TABLE .... MONITORING cause any significant
Does ALTER TABLE MONITORING cause any significant overhead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
