Re: Bug with automatic undo management?

d 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 subsc

Re: Book (was) oaktable people

-- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services

Re: sql trace - forward attribution

an 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 >

Re: SAMPLE BLOCK

from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Califor

Re: Index usage

indexed column. > > I have already tried index(ta ind1) , RULE hints. > > The table and the index are analyzed. > > What cud be the reason for that? > > Regards, > B S Pradhan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET

Re: Wow, Man, Flashbacks!

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.net -- Author: Daniel

Re: Wow, Man, Flashbacks!

e official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Melanie Caffrey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > --

Re: Redo log corruption

on either host. Unfortunately, I can't cut loose my scripts at this point, due to intellectual property issues with my employer. Pd "Daniel W. FInk" <[EMAIL PROTECTED]> wrote: Shibu, What version of Oracle? There is a 7.x bug where mismatches in asynch i/o read/write corrupted the

Re: Redo log corruption

ohibited. Please > note that e-mails are susceptible to change and MindTree shall not be liable for any > improper, untimely or incomplete transmission. > > > Name: winmail.dat > winmail.dat

Re: ORA-01555 with Automatic Undo Management mode

cannot be reused, no matter what (active undo is NEVER overwritten). -- Daniel W. Fink http://www.optimaldba.com Darrell Landrum wrote: That all being said, the fact that there is free space in the tablespace implies that the 1555 is not due to an extent being

Re: Partitions of table read only

Food for thought... How does Oracle know that an existing transaction (which may be more than the current statement) will not alter data in the RO Tablespace until the transaction is completed (rollback/commit)? -- Daniel W. Fink http://www.optimaldba.com Rachel Carmichael wrote: The admin

Re: World premier performance of the BAARF party logo

://www.orafaq.net -- Author: Daniel W. Fink 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

Re: Query on Dual

can find out more on his website at www.hotsos.com. -- Daniel W. Fink http://www.optimaldba.com Jayaram Keshava Murthy (Cognizant) wrote: Hi all, Can anyone tell me the performance issues related to the excessive usage of the DUAL table in pl/sql procedures

Re: How to put a TOP 1 in a select

OOPS! Mea Culpa! I improperly used rownum in the query. The previous reply from Mark is correct. However, the info on my website is correct. Daniel W. Fink http://www.optimaldba.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL

Re: How to put a TOP 1 in a select

ation that discusses the Top-N type queries at www.optimaldba.com/library.html. -- Daniel W. Fink http://www.optimaldba.com Teresita Castro wrote: Hi!! I was working with SQL Server 2000, and now the company decided to change to Oracle. So I don't know much about Oracle, I

Re: International User Community

attachment. -- Daniel W. Fink http://www.optimaldba.com

Re: A new form of ORA-1555

ected members of this list disagree with me. We each have our reasons for our positions and we are both right. -- Daniel W. Fink http://www.optimaldba.com Gogala, Mladen wrote: Well, I've read a lot of that on this list (this is not the first time FBQ is being discussed

Re: A new form of ORA-1555

Mladen,     That is a common misconception, one that Oracle wholeheartedly supports. Flashback Query (FBQ) depends upon the smon_scn_time table, which is popluated in 9i, regardless of the undo_management setting. This table is populated regardless of the UNDO_RETENTION parameter. This paramete

Re: A new form of ORA-1555

exist and consume space (at least 2 extents/128k) in the undo tablespace until it is dropped and a new one created? I THINK that the answer is that once created an undo segment will exist until the tablespace is dropped as there is no 'drop undo segment' command with aum. -- Daniel W.

Re: HP OpenView

monitoring interface ungainly and difficult to use. If an alert was presented, we had to go to another product or login to the db to examine it in depth or fix it. I would have preferred to use Enterprise Manager since I could do almost everything I needed to do in one window. -- Daniel W. Fink http

Re: Deadlock - Missing Trace File

ng up words in strings, so I always doublecheck the file path and name. Could the device that includes the udump directory be full? -- Daniel W. Fink http://www.optimaldba.com Gogala, Mladen wrote: Actually, I've had a TAR like that. You must set "60" event at the system level to ge

Re: inline views

5 262 30 7654 3 6 26 3 -- Daniel W. Fink http://www.optimaldba.com VIVEK_SHARMA wrote: Where are they advantageous to use & where not ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Autho

Re: Deadlock - Missing Trace File

Any chance there is a scheduled process that goes out and cleans up files in the *dump directories? -- Daniel W. Fink http://www.optimaldba.com Odland, Brad wrote: Encountered a deadlock during nightly processing. A ORA-60 was written to the alert log but the refereced trace file was nowhere to

Re: inline views

I have used an inline view to reduce network traffic when retrieiving data from a remote db. Instead of using a nested loop and making multiple trips, it made 1 trip and brought over all of the data. The query time was reduced from 30 minutes to 5 minutes. -- Daniel W. Fink http

Re: Snapshot too old during stress test... how to avoid

://www.orafaq.net -- Author: Daniel W. Fink 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

Re: Snapshot too old during stress test... how to avoid

The rbs does not shrink to optimal when the transaction commits. The 2nd transaction to 'find' that the rbs has extended beyond optimal will cause the rbs to shrink. -- Daniel W. Fink http://www.optimaldba.com Thomas Day wrote: With optimal, the rollback segment shrinks back to i

Re: Snapshot too old during stress test... how to avoid

end 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). -- Daniel W. Fink http://www.optimaldba.com

Re: Oracle's use of Indexes

, user_indexes.clustering_factor, user_tab_columns.density for each column in the index). -- Daniel W. Fink http://www.optimaldba.com Craig Healey wrote: OK, I'm confused. Maybe it's Monday morning and my brain's not working. We have a production schema and a test schema on the sa

Re: next week

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Daniel W. Fink http://www.optimaldba.com

Re: x$bh.dbablk values (repost)

Wolfgang, Thank you for pointing this out. The ol' Uncertainty Principle (or Schrodinger's Cat). Of course, I may have my principles wrong (no comments on that one!). -- Daniel W. Fink http://www.optimaldba.com Wolfgang Breitling wrote: You are running into the classical pr

x$bh.dbablk values (repost)

8993 8 9000 The questions are Why are the segment headers being returned by my first query? Is there something wrong with the sql statement? Am I not reading the dbablk value properly? Is there a process that is reading these segment headers? -- Daniel W. Fink http://www.optimaldba

Re: SQL Query Help

SELECT ID,MAX(LastModDate) FROM Tab where id = 1 group by ID; -- Daniel W. Fink http://www.optimaldba.com Basavaraja, Ravindra wrote: I had tried this as per Oracle Metalink Note.When I add the group by ID it will display both the records like 2 1/20/2003 2:56:18 AM 1 4/23/2003 10

Re: Space Remaining in Current Extent

ded in the calculation. One of the problems with this approach is if the high water mark is set artificially high or the table has had a high amount of delete activity. -- Daniel W. Fink http://www.optimaldba.com Kevin Lange wrote: Hey guys; Does anyone know where I can look to find the space remai

Immediate v. Abort

accept the challenge? I'll put up a bottle of good Scotch (no Black Adder Raw Cask) or one of my pictures (ask Rachel) to the person who changes my mind or reinforces my current view. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27

Re: why ?????????

being read, checking the predicate and rejecting the row. Okay, gurus, please correct me if I am wrong (by the way, I'm being totally serious...) -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem So

Re: dbshut script - shutdown or shutdown immediate

n the times when the immediate takes longer than expected. I don't think this issue is one of black and white/right and wrong, but rather varying shades of gray. Okay, Connor...your turn! -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April

Re: dbshut script - shutdown or shutdown immediate

, you cannot perform a complete recovery. You can recover up to the last log that can be read. If the active log cannot be read, the previous log is the end point of your recovery. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am

Re: dbshut script - shutdown or shutdown immediate

only protects from hardware failure. It will not protect you from accidental deletion of the log (been there, had to fix it!). -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thu

Re: Oracle view riddle I am being asked , help me out here.

Run autotrace or sql_trace and determine if the execution plans are different. If they are the same, increase the sql_trace level and find out what the wait events are. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm

Where's my trace file?

2628 Now, go out to 'user_dump_dest' and you can find the file with '2628' in the name and there is your trace file. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solvin

Re: dropped sequence - backup/recovery question

perhaps another unique value). -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Jacques Kilchoer wrote: d

Re: Test - Delete me

delete from oracle-l where subscriber = 'Gene Sais'; commit; select count(*) from oracle-l where subscriber = 'Gene Sais';   COUNT(*) ------          0 -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, Apri

Rownum

re SQL Scripting Sorcery. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals -- Please see the official ORACLE-L FAQ

Re: insert stmt disk reads

ds to occur. IIRC, you can see the file and block output in the raw trace output from sql_trace. Track these back to the file/block values in dba_extents and it will tell you which objects you are reading. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL S

Re: insert stmt disk reads

Partial List Foreign Key Validation Primary Key Validation Reading blocks on the freelist for insert Before Insert/After Insert Triggers -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with

Re: Sizing Indexes - URGENT

are not accurate. This makes a fine-grained sizing approach ultimately innacurate.     Use locally managed tablespaces and create estimated sizes. Add in enough space for variances and keep an eye on them. When in doubt, err on the side of overallocation. -- Daniel W. Fink http://www.optimaldba.com

Re: Comparing strings whilst ignoring some characters

that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Re: rollback segment

ack segment and have queries fail with Snapshot Too Old. My recommendation is to offline the segment during a time of low activity and then drop it. v$transaction provides limited undo info, but enough to determine which sessions/users are using the specific rollback segment.     --

Re: Create rollback segment under ORACLE 9ir2 failed????

system. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Pete Sharman wrote: Mike The only way this would have worked under

Re: Create rollback segment under ORACLE 9ir2 failed????

7;ROLLBACK_SPACE' Those script used to work under ORACLE 8i. Does anyone know why? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Daniel W. Fink http://www.optimaldba.com IOUG-A L

Re: Tablespaces - datafiles

not really documented. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals -- Please see the official ORACLE-L

Re: Rollback Segments on 8.1.7.4

you upgraded, did you change any of the settings, like OPTIMAL, for the rollback segments? Were they dropped and recreated or upgraded inline? -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with

Re: LMT monitoring

tes and I did not find a new extent size. The first 3 sizes are documented by Oracle, the last one I found by testing and have verified from other research, though the author/website escapes me at the current time. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orla

Re: Date difference function

, Santosh   -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

Re: Oracle Magazine excels itself

utside of the UK though. Mark -Original Message- -- Daniel W. Fink http://www.optimaldba.com RMOUG Training Days March 5 & 6, 2003 Denver, CO IOUG-A Live! April 27 - May 1, 2003 Orlando, FL

Re: DBV

. set pages 0 feedback off termout off lines 200 spool $ORAMON_HOME/bin/dbverify.ksh select 'dbv file='||f.name||' blocksize='||p.value||' logfile=dbverify.out' from v$datafile f, v$parameter p where p.name = 'db_block_size'; spool off -- Daniel

Re: Number of joins in the query

ately contact the sender if you have received this message in error. Thank you. -- Daniel W. Fink http://www.optimaldba.com RMOUG Training Days March 5 & 6, 2003 Denver, CO IOUG-A Live! April 27 - May 1, 2003 Orlando, FL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Autho

Re: Checkpoints

checkpoints going mad on 8.0.6. TIA     With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs -- Daniel W. Fink http://www.optimaldba.com RMOUG Training Days March 5 & 6, 2003 Denver, CO IOUG-A Live! April 27 - May 1, 2003 Orlando, FL

Re: DBV

935.5929 (pager) [EMAIL PROTECTED] "Daniel W. Fink" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L

Re: DBV

wrote: Hi, Can I use the program DBV on a production datafile (read and write), without take offline the tablespace ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: corrupted block

An export is a great method for catching corruptions in tables. However, it does not read indexes, so it misses those corruptions. Analyze and dbv will. Yechiel Adar wrote: We had a session with an expert on Monday and he recommended export to \dev\nul to detect errors in the database. Yec

Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

This reminds me of the paper I wrote for American Goverment in high school. I don't recall the author, but the gist was that Free Speech must not be impeded, because in the end, the Truth will prevail. Very well said. Thank you Cary. Cary Millsap wrote: The only thing wrong with President W

Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

Connor corollary to Wilson theory... "The truth will out...especially when demonstrated with free beer!" Freeman Robert - IL wrote: And to the credit of Woodrow Wilson - "The wisest thing to do with a fool is to encourage him to hire a hall and

Re: UPDATE...REPLACE...'...apostrophe...

Use the CHR function. CHR(39) will display/insert an apostrophe. Daniel W. Fink Gorden-Ozgul, Patricia E wrote: RE: SQL struggle I'm running Oracle on Solaris 2.6.   I successfully inserted data from a composite file by replacing apostr

Re: select count(case ...) slow in PL/SQL, any better way?

CASE appeared (with little fanfare) in 8.1.6. However, until Oracle9, it was not available in PL/SQL, when they integrated the PL/SQL engine into the kernel. Darrell Landrum wrote: I thought case in PL/SQL was not available until 9i. I'll have to look that up. [

Re: corrupted block

00 inc:0x seq:0x incseq:0x Entire contents of block is zero - block never written Reread of block=6000e200 file=24. blocknum=57856. found same corupted data -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED

Re: Oh Where Oh Where Is My Redo Coming From

letes? * ?? The goal is to identify the objects, then identify the jobs that work on those objects and see if I can reduce redo. I suspect a lot of this redo is being generated because of some poor design issues. Thanks! - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- A

Re: How do you calcuate the temp space needed for view?

Is the temporary space needed = (table 1 row-length * table 1 total number of rows ) * (table 2 row-length * table 2 total number of rows ) ? Any advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECT

Re: Teradata baned from IOUG???

I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego). I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, un

Re: Teradata banned from IOUG???

IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice your opinion. Also, send feedback about things you don't like, offer solutions and

OT: Call for Presentations RMOUG Training Days 2003

orafaq.com -- Author: Daniel W. Fink 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 th

Re: Clone Database

z" <[EMAIL PROTECTED]> wrote: > I have to refresh a development database every day > with the production DB. > The size of the DB is 70GB and import last like 7 > hours. Does anyone in the > list has the steps to clone a database, not using > import. > > TIA &g

Re: DB Version upgrade with CreateDB/Import "Risky"???

tional space is required to hold an export file. All in all, there are valid reasons to use both methods. Export/Create/Import offers a chance to 'repair' structural issues. In place migration may require less time. Daniel W. Fink James Damiano wrote: >Hello fellow Oracle DBAs, &

RE: FILE IDENTIFY wait event

pure UNIX... - Original Message - From: Daniel W. Fink To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 10:41 AM Subject: FILE IDENTIFY wait event Oracle8.1.7 on Solaris8   I am trying to create a table

FILE IDENTIFY wait event

Oracle8.1.7 on Solaris8   I am trying to create a tablespace on a raw device and the SQL*Plus session that performs the tablespace creation is waiting on a 'file identify'. A quick search on metalink and other docs did not indicate the root cause of the wait event. I have used the raw dev

RE: Slow select distinct

P command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Maili

RE: PATCH?

FAQ: http://www.orafaq.com -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOV

RE: Curious question about flushing the Pool

-- 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 wa

RE: SQL question

lso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pub