What is a local write wait?

Was creating an index with a degree of 4, and in unrecoverable manner? There were few waits for an event called local write wait. Can anyone shed more light on this wait? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

RE: re Rebuilding Indexes in Oracle Apps -- an update

Richard et al, {for those who've been following the thread on Rebuilding Indexes ...} I've just been reading the AskTom thread on rebuilding indexes at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:6601312252730 and picked on the important line Coalesce... reclaim the

Re:How to drop a datafile ?

Perhaps your guess is right Dennis. Dennis For odd features like this marketing probably gets a list from support. /Dennis But Dennis,what is so odd in having this feature ? i think,only ORACLE CORP. knows. Thanx Regards, Jp. 1-11-2003 02:49:30, DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Prem

RE: Finding overlapping time periods - suggestions please

Here's a simple programmatic method (careful, I haven't tested it). declare v_activity_count number := 0; begin for rec in ( select start_time event_time, 'start' event_type from some_table union select end_time event_time, 'end' event_type from some_table order by 1 )

Re: 9i on RHAS3

Read operation from evenone-ROW table will benefit from index - if you index all necessary columns. A full table scan reads segment header and the datablock. Index scan requires only one read of leaf block in case of one-block index. Also, you may get other benefits, if you have unique

Re: Client Search Info Needed

Tracy, IMHO the simplest and most efficient solution is : 1) to define a name_cleanup() function which does something like replace(translate(replace(upper(arg), 'MC', 'MAC'), '- ', '##'), '#', '') (this is of course a very simple example) 2) to maintain by trigger an indexed

Re: Finding overlapping time periods - suggestions please

[EMAIL PROTECTED] wrote: I was wondering if anyone had the need to find overlapping time periods and how to identify them efficiently. Here is the scenario: Elapsed minutes refer to the actual clock time either spent on a given task. Thus an activity that started

RE: Outsourcing's dirty secret

Hi All DBA's all here hmm...well if i were the CFO i would have been lookin for the fast=true parameter if i were bald i would have been looking for a pill or a cream that would give me hairs overnight..the time of instant nirvana has come :-)..software bpo call centeres they are all same..today

Re: memory usage by dbw very high

Just for clarification, do you actually see swapping when starting a new process or you just guess linux would swap because you don't see "free" memory in top output? Tanel. - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L

Re: What is a local write wait?

Rajesh: Typically DBWR has to free up some buffers when you want to read something from the disk. During this process there are chances that you will be waiting for your local buffer (i.e blocks dirtied/invalidated by your session) to be written to disk. During this time the waits are shown as

Re: Finding overlapping time periods - suggestions please

Stephane, my solution was suggested because the client was a telco which was offering each client billing period of their own choosing (weekly, bi-weekly, monthly) starting whenever the client wanted. Finding which calls fall in the certain period was a major hassle. Of course, the solution

Re: memory usage by dbw very high

The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to

RE: What is a local write wait?

I found this on the Metalink: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=183745.995 Waleed -Original Message- Sent: Saturday, November 01, 2003 2:24 AM To: Multiple recipients of list ORACLE-L Was creating an index with a degree of 4,

Re: Finding overlapping time periods - suggestions please

Mladen, If you suggest a convoluted solution like this takes water when you have several million rows I fully agree :-). Funny enough, because it really looks like a purely relational problem, and yet it requires bending backwards. My feeling (and it definitely would deserve time to prove) is

RE: Finding overlapping time periods - suggestions please

Title: Finding overlapping time periods - suggestions please Easy, this should do it: Create a time dimensions--drop table test_date_dim;create table test_date_dim (time_dt