Re: AQ query from dequeuw procedure not using index -URGENT
Title: RE: AQ query from dequeuw procedure not using index -URGENT When a hint is in your code it will automatically use the cost based optimizer, even if you have the database or session is set to RULE. Therefore you will need stats collected. If you still have problems then look over this paper http://www.evdbt.com/SearchIntelligenceCBO.doc. It will explain some ways to help improve the explain plan selection for the cost optimizer. Casey - Original Message - From: orafaq To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 4:44 PM Subject: Re: AQ query from dequeuw procedure not using index -URGENT This database is running RULE so analyzing wont help. Outlines is a good idea. Any known issues with outlines in 8173? Thanks Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 12:39 PM Subject: RE: AQ query from dequeuw procedure not using index -URGENT Outlines is the way to go as John suggested ... also ensure that all tables related to the queues are analyzed ... regularly. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AQ query from dequeuw procedure not using index -URGENT Shaleen, Have you considered using Outlines? John Kanagaraj
Re: AQ query from dequeuw procedure not using index -URGENT
Title: RE: AQ query from dequeuw procedure not using index -URGENT When a hint is in your code it will automatically use the cost based optimizer, even if you have the database or session is set to RULE. Therefore you will need stats collected. If you still have problems then look over this paper http://www.evdbt.com/SearchIntelligenceCBO.doc. It will explain some ways to help improve the explain plan selection for the cost optimizer. Casey - Original Message - From: orafaq To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 4:44 PM Subject: Re: AQ query from dequeuw procedure not using index -URGENT This database is running RULE so analyzing wont help. Outlines is a good idea. Any known issues with outlines in 8173? Thanks Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 12:39 PM Subject: RE: AQ query from dequeuw procedure not using index -URGENT Outlines is the way to go as John suggested ... also ensure that all tables related to the queues are analyzed ... regularly. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AQ query from dequeuw procedure not using index -URGENT Shaleen, Have you considered using Outlines? John Kanagaraj
Re: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],
I looked on Metalink and found several hits. Most of them point to Note:147731.1. I states you can get this error when using the 8i JDBC driver to connect to a 9i database. Just in case you didn't know, ora-600 is just a catch all error that you can get for many, many reasons. You when searching Metalink you must include the arguments. Metalink also has a tool for looking up ora-600 errors. You can find it under DOC ID 153788.1. Casey - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 9:33 AM Hi , we are getting the error ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] when trying to retrieve a result set from Java EJB. Searched metalink giving arguments for ORA-00600 but couldn't get any solution. I am being told that Weblogic 6.1 with oracle 9i is giving some problems. Any info on this ? Setup is mentioned Below: Oracle database 9.0.1.1.0 on sunsolaris Weblogic Applications Server 6.1 on Sunsolaris (different Unix box). JDBC driver thin - Classes12.jar In fact , If an Insert from the Application is working fine. But when we try a query it is displaying the above mentioned error. >From udump trace file of oracle below is the error message : /usr/gsci/OraHome1/admin/GMODC/udump/gmodc_ora_1182.trc Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production With the Partitioning option JServer Release 9.0.1.1.0 - Production ORACLE_HOME = /usr/gsci/OraHome1 System name: SunOS Node name: lotus Release: 5.8 Version: Generic Machine: sun4u Redo thread mounted by this instance: 1 Oracle process number: 19 Unix process pid: 1182, image: oracle@lotus (TNS V1-V3) *** SESSION ID:(19.2868) 2002-12-11 10:41:43.563 *** 2002-12-11 10:41:43.563 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] Current SQL statement for this session: SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' - Call Stack Trace - Is there any solution for this problem? TIA Satish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey A. Jordan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Development and Test Database Licensing?
How does Oracle handle the licensing of the Dev and Test servers. Does an OTN license need to be purchased for this or does the purchase of the production server license allow for the Test and Dev servers. thanks, caj From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Friday, November 08, 2002 1:25 PM Subject: RE: FW: developer 2000 THANKS Do u happen to know where can i get that? Regards Paulo -Original Message-From: Viktor [mailto:[EMAIL PROTECTED]]Sent: sexta-feira, 8 de Novembro de 2002 18:09To: Multiple recipients of list ORACLE-LSubject: Re: FW: developer 2000 I think you may need to get an upgraded installer version 3.3.1.1.0c. This is the one compatible with Y2K. Then, run the installer and select typical, and that should be it. Regards, Viktor Paulo Gomes <[EMAIL PROTECTED]> wrote: > -Original Message-> From: Paulo Gomes > Sent: sexta-feira, 8 de Novembro de 2002 17:33> To: '[EMAIL PROTECTED]'> Subject: developer 2000> > > > -Original Message-> From: Paulo Gomes > Sent: sexta-feira, 8 de Novembro de 2002 17:31> To: '[EMAIL PROTECTED]'> Subject: > > hi people> now is my turn to ask for help.> Just got some old forms that are still in developer 2000 version. Can't> upgrade the client and have a win 2000 machine. Developer 2000 doesn't> install in win 2000.> Does anyone knows any trick to install Developer 2000 in win 2000?> I DON'T WANT TO INSTALL A NEW NT MACHINE JUST FIX SOME LITTLE PROBLEM.> > Thanks in advance> Regards> Paulo-- Please see the official ORACLE-! ! L FAQ: http://www.orafaq.com-- Author: Paulo GomesINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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). Do you Yahoo!?U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD
Re: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
2 partition_view_enabledFALSE plsql_v2_compatibilityFALSE pre_page_sga FALSE processes 75 query_rewrite_enabled FALSE query_rewrite_integrity enforced rdbms_server_dn read_only_open_delayedFALSE recovery_parallelism 0 remote_dependencies_mode TIMESTAMP remote_login_passwordfile NONE remote_os_authent FALSE remote_os_roles FALSE replication_dependency_tracking TRUE resource_limitFALSE resource_manager_plan rollback_segments r01, r02, r03, r04 row_locking ALWAYS serializable FALSE serial_reuse DISABLE service_names sqcedi session_cached_cursors0 session_max_open_files10 sessions 87 shadow_core_dump partial shared_memory_address 0 shared_pool_reserved_size 160 shared_pool_size 3200 sort_area_retained_size 80 sort_area_size80 sort_multiblock_read_count2 sql_trace FALSE sql_version NATIVE sql92_securityFALSE standby_archive_dest ?/dbs/arch star_transformation_enabled FALSE tape_asynch_ioTRUE text_enable FALSE thread0 timed_os_statistics 0 timed_statistics FALSE tracefile_identifier transaction_auditing TRUE transactions 95 transactions_per_rollback_segment 5 use_indirect_data_buffers FALSE user_dump_dest/sscedre/data/sqcedi/admin/log utl_file_dir /var/spool/applmgr/sqcedi/common/log -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert 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: Casey A. Jordan 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).
Upgrade on Windows Question?
I am upgrading from 8.1.6 EE to a supported release on Windows 2000. My initial thought is to upgrade to 8.1.7.3. My questions is has anyone had any problems with 8.1.7.3 on Windows, and what would you suggest as the most stable release for Windows. I am not looking for new features but most reliable. Thanks, CAJ
Large record count in fet$ for TEMP tablespace
When trying to select * from DBA_FREE_SPACE_COALESCED the query hangs. It also hangs when trying to calculate free space from the DBA_FREE_SPACE view. I looked in the sys.fet$ table and found that the TEMP tablespace has 21423 entries and I believe this is my problem. Now for my questions. 1. Is coalescing the best solution for this problem? 1. Can I coalesce the tablespace without changing it to a permanent tablespace? 2. Is there a faster way to drop the exents then the alter tablespace coalesce command? I ran it for about 10 minutes and canceled it. 3. Is this normal and do I need to coalesce the TEMP tablespace on a regular basis to avoid this happening again? Thanks,CAJ