Timeout while obtaining an oracle connection lock
..apologies this should have read v8.1.6 if that makes any difference. This problem is occurring within our production domain so *any* assistance would be greatly appreciated. Many thanks GH Grant G Holyoake 11/09/2002 17:56 To: [EMAIL PROTECTED] cc: Subject: Timeout while obtaining an oracle connection lock Is this part of a business decision process?: v8.1.7 solaris 2.6 E10k domain/SAN Coldfusion application receives the following Error Msg: Error Occurred While Processing RequestOracle Error Code =0Timeout while obtaining an oracle connection lock[ select statement]. CF uses native drivers to connect to oracle instance. Nothing in logs or trace files. Tried using 'cookies' default client storage setting in lieu of 'database' however still no luck. We recently moved our instances to SAN however we don't appear to have any other latency issues/problems TIA Grant Holyoake Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments.
Timeout while obtaining an oracle connection lock
v8.1.7 solaris 2.6 E10k domain/SAN Coldfusion application receives the following Error Msg: Error Occurred While Processing RequestOracle Error Code =0Timeout while obtaining an oracle connection lock[ select statement]. CF uses native drivers to connect to oracle instance. Nothing in logs or trace files. Tried using 'cookies' default client storage setting in lieu of 'database' however still no luck. We recently moved our instances to SAN however we don't appear to have any other latency issues/problems TIA Grant Holyoake Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments.
Locally vs Dictionary-Managed Tablespaces - was archive query - revisited
Now that I have ascertained how the allocation and deallocation of extents in Oracle affects logging, (thanks Mohammad and Jay!) I would like to know the pro's and cons people have experienced when changing tablespaces to locally-managed rather than dictionary-managed (apart from the hassle of having to rebuild them!). Recovery of object data is not critical for the tablespaces I intend on modifying. My objective is to minimise logging and have more efficient use of space utilization - avoiding the need to coalesce tablespaces on a regular basis seems like an attractive option. I'm interested in finding out how efficient Oracle is in automatically determining extent sizes, performance benefits of having no rollback information generated and any other information (good or bad) users may have experienced on this topic. Platform is 8i on Solaris 2.6 Regards Grant -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: archive query - revisited
Mohammad and Jaymany thanks for the responses. Upon running your script Mohammad, I noticed that archive files were being written to the archive directory during a large insert operation and stopped being written once the insert had completed. The insert command uses APPEND, the associated table is indexed but created with nologging. It is however partitioned. I'm still confused as to why logging continues to occur.could it be that the extents allocated during the insert operation are logged? The same procedure creates a number of worktables to assist with join queries (not temp tables rather permanent tables) which are subsequently dropped after the query has completed (no indexes - hash joins only). There are no deletes or updates. Any more clues?? Here's a copy of the table structure: (See attached file: table.txt) Here's a copy of the insert statement summarized from the procedure: (See attached file: insert.txt) Many thanks Grant table.txt insert.txt
archive query
Hi, Can anyone explain how I can determine which objects and/or processes are causing logging/archiving to occur? I have a (large) database whereby all tables required to be populated with data on regular batch runs have been created with nologging. The tablespaces they reside on were also created with nologging. There are no constraints (eg triggers) on these tables that could possibly be invoking logging yet my archive destination directory is filling up on a regular basis with unknown archived data!! I have a script to remove redundant archive files but the point is why is it filling up and with what?? There are only a few tables with logging activated but these are relatively small with minimal inserts/updates. The following entries are taken from the parameter file (don't know whether this may help) db_block_buffers = 7 db_block_size= 16384 db_block_lru_latches = 4 compatible = 8.1.0 log_archive_start= TRUE log_archive_dest_1 = location=archive_directory log_archive_format = arch_%t_%s.arc log_buffer = 163840 log_checkpoint_interval = 1000 log_checkpoint_timeout = 1800 db_file_multiblock_read_count= 16 I am considering shutting down the database and changing the status of the database to noarchivelog mode, perform the data loads and then shutdown and reset to archivelog mode. I'm aware of the recovery implications. We're using 8i on Solaris 2.6...and yes I'm fairly new to Oracle ;-) TIA Grant -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
instance resource allocation
Group, being fairly new to Oracle (and this list) I have what I consider (and others may dare to differ) a valid question(running with 8i on Solaris 2.6) How do you manage the division of resources between 2 instances located on the same host? We have two oracle 8i instances (and a number of other applications) running on the same server. One in particular is drastically hogging the bulk of the server resources thus impeding the performance of the other instance and related applications As far as memory conflicts go, we're running an ad hoc query system on one instance, which means it can get resource hungry and can only be tuned/designed to an extent. The issue is that the resources it can grab should be limited, so they don't eat into a minimum resource allocation that the other instance should get. I am not aware of a way to use the DBMS_RESOURCE_MANAGER across two instances. Is there anything we can do here? I'm not sure how we specify how the two instances relate in terms of resourcesperhaps something in the init.ora file? Our Oracle environment resides on an exclusive E10K domain with 4 dedicated (400mhz) processors, 4GB RAM. TIA Grant -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).