Recommendation for SQL Tuning Book

Question for those who have gone before... Is there a consensus on the best book to use to teach myself SQL tuning under the cost-based optimiser, particularly the use of hints. I have lots of experience under the rule-based optimiser, so I need hard-core info on use of hints and other features,

RE: Re: BCHR Tuning

I personally find the turn the argument is taking rather dispiriting. I have, like everybody who has been working with Oracle for some time, used BCHR in the past (and queried X$KCBRBH and its twin, X$KCBCBH). To be honest, I even have had some quite interesting results - which I would get by ot

Trace file size...

Hi gurus My SQL_TRACE is on for instance. What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE. wether it is truncated? or it will start writing into another file? Is there a way to recognize, which trace file belongs to which session? Please help me this is urget requirement? thanks

Re: Trace file size...

On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you

RE: Recommendation for SQL Tuning Book

Guy Harrison's "Oracle SQL High Performance Tuning" - really good one You can get it for under 20$ at: http://www.bookpool.com/.x/aii6z8nb34/sm/0130123811 -Original Message- Sent: ? 13 ? 2003 11:39 To: Multiple recipients of list ORACLE-L Question for those who have gone before...

Minimum required init.ora parameters

List,   I'm interested to know the minimum required parameters to startup the database.   Pls anybody list out that?   Nirmal.,

RE: Trace file size...

my main question is about the file size... Thank you very much... -Original Message- Sent: Monday, January 13, 2003 4:49 PM To: Multiple recipients of list ORACLE-L On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we

Different Backups - A Comparartive analysis

Need to Do a Comparative analysis of General Characteristics of HOT , COLD , exp , RMAN backups What additional Headings can be Explored ? Some Feadings below :- 1) Database Status during backup - UP / Down 2) Time of Backup 3) Restoration effort & time 4) Reovery facility 5) Dependency on

RE: Some of you may find this useful

Trade you users, Rachel... we still have one that thinks that silly 1000 column limit is something that I made up to make her life difficult. April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent:

RE: Minimum required init.ora parameters

Nirmal - I believe there are four: db_name control_file db_block_size compatibility This is from John Hibbard, a great Oracle Education instructor. But why not try for yourself? Save off your init.ora, then create a new init.ora with just the above parameters. If Oracle comes up,

RE: Different Backups - A Comparartive analysis

Vivek - I believe you are off to a good start. I'm assuming you are considering the database to be in archivelogmode in all the scenarios. Also, keep in mind that export is not a valid sole backup method for a production database. There are many situations that having an export alone will not en

RE: Big Brother is Here

2 + 2 = 4 Todd -Original Message- [EMAIL PROTECTED] Sent: Friday, January 10, 2003 12:46 PM To: Multiple recipients of list ORACLE-L OK, this is a little off topic, but if MicroSlop gets this to work, how long before OEM will have a link into the same technology?? I always thought that

Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Sorry, I forgot this additional infromation... Oracle created invalid objects when we ran rebuild. The odd thing was that the trace file showed an invalid object but the all_objects table showed a valid object. -Original Message- Sent: Monday, January 13, 2003 9:39 AM To: [EMAIL PROTE

Oracle 7.3.4 Real-Time Re-indexing

Team, I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode. While the users were on the system, we Re-Indexed our tables. Situation: The users complained, that they were unable to process their orders. Although, the log file showed that the re-indexing was successful, the users

RE: Minimum required init.ora parameters

"compatibility" or "compatible" is not a mandatory init.ora parameter. I would think that only the first three are required. Hemant At 06:08 AM 13-01-03 -0800, you wrote: Nirmal - I believe there are four: db_name control_file db_block_size compatibility This is from John Hibba

Re: Different Backups - A Comparartive analysis

To add to your list: 13) Is an additional volume of redo generated, resulting solely from being in backup mode? 14) Is backup capable of any other purpose, such as checking for corruption in database blocks and/or archivelog files? 15) Additional hidden costs of integrating with tape subsystem (i.

Internet file system

Title: Internet file system as per usual, technet website is confusing as heck.  I am trying to locate the latest release on IFS.  I am on the products website and see the following on the IFS webpage: Content Management Software Development Kit (CMSDK) Version 9.0.3   (Note: this rele

compatible in 9iRel2

List, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Solaris 8 database. If you bounce the instance the sql>show parameter compatible=9.0.0 stays the same, it does not change. If you shutdown and reboot the server you get an: ora-01033: Initialization or shutdown in pro

Re: Recommendation for SQL Tuning Book

Check out this white paper by Tim Gorman: http://www.evdbt.com/SearchIntelligenceCBO.doc. There is (somewhere, don't remember URL) also a white paper by Mark Gurry, the author of the book you bought. BTW, I think the book is very good. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Me

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Conrad - What command did you use to re-index? Drop index / create index? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Sorry, I forgot this additional infromation... O

8.1.6: possible to set role in db's logon trigger?

Greetings all, I'm trying to support a COTS application that is back-end agnostic & makes only minimal use of security on the db. In particular, it requires that users be granted a default role that has *very* heavy permissions--enough to do some major mischief should they ever figure out how to

RE: Minimum required init.ora parameters

Hemant - I was just going from my hastily written class notes. Sorry about misspelling the parameter. However, just tried it and 8.1.6 won't start without the COMPATIBLE parameter set in init.ora. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Mon

bitmapped indexes

RE: compatible in 9iRel2

David - What are you trying to accomplish? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L List, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Sola

RE: Minimum required init.ora parameters

The only one parameter.. control_files. Rest are optional. Best Regards, K Gopalakrishnan -Original Message- WILLIAMS Sent: Monday, January 13, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Hemant - I was just going from my hastily written class notes. Sorry about misspellin

Re: Daramtically improve BCHR with a single statement

Hello All I saw that piece of code a few times and still think that even if you can bump up the BCHR it has it's place. How can you tell that you need more space in the buffer pool? Bad BCHR is an indication that you need to check this. It is also an indication that you do a lot of FTS or missing

Re: BCHR Tuning

Hello Anjo I just had a tuning session with Dov Hit, from ACS in Israel. He used some of the scripts that you showed him 2 years ago when you did some work for Amdocs. Anyway, after doing some search on the waits, he checked the BCHR and found out that this database has only 40%. That led us on fu

Re: Minimum required init.ora parameters

It seems like I remember misspelling 'control_file' once and discorvering that even it has a default. Of course with Oracle, it could depend on the version, O/S, patch level, phase of the moon, etc. Keith - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

ALTER ...REBUILD.. Thanks COnrad.. -Original Message- WILLIAMS Sent: Monday, January 13, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Conrad - What command did you use to re-index? Drop index / create index? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED]

Dead shared server msgs in alert log + core dumps

Has anyone ever seen a similar message to the following showing up in the alert log and creating dump/trace files: Mon Jan 13 09:45:22 2003 found dead shared server 'S000', pid = (9, 13) Mon Jan 13 10:13:46 2003 Errors in file /u01/app/oracle/admin/ndi/bdump/ndi_s000_3556.trc: ORA-07445: exception

newbie question - still: please help

hi! a DBA inteds to speed up a script that is looping and sending hundred thousands of sequential update statements like: UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; he suggests copying the table to a file, change it and then load it into the DB again. i am strongly convinced that this is

RE: 8.1.6: possible to set role in db's logon trigger?

Title: RE: 8.1.6: possible to set role in db's logon trigger? Hi Roy, Note 122230.1 will answer your first question about session id's. Lisa Koivu Oracle Dogbone Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 -Original Message---

Re: dw tool question

>We have a new datawarehouse project. I didn't involve in this project at >beginning. Right now, I was assigned to the group for picking a front >end reporting tool. So far I know the manager prefer brio, cognos and >business intelligent product. > >Does anyone familiar with those tools? Can you gi

Re: 8.1.6: possible to set role in db's logon trigger?

To solve your first problem, correctly identifying the current session from v$session, in your login trigger include: client_info_str := 'SOME_LITTERAL_' || LTRIM(dbms_random.value,'.'); DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str); Then you can: SELECT program, user

RE: Minimum required init.ora parameters

Well, I just tried it on 8.1.8, and here is what I receive: SVRMGR> !cat inittest816.ora control_files = ("/oracle8/oradata/test816/control01.ctl", "/oracle8/oradata/te) SVRMGR> startup ORACLE instance started. Total System Global Area142688680 bytes Fixed Size

RE: newbie question - still: please help

Daniel - Can you explain the two alternatives in a little more detail, especially the difference between the two. What types of systems are involved (Unix, Windows)? Thanks. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 1

RE: newbie question - still: please help

>hi! > >a DBA inteds to speed up a script that is looping >and >sending hundred thousands of sequential update >statements like: > >UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; > >he suggests copying the table to a file, change it >and then >load it into the DB again. i am strongly convinced >

RE: 8.1.6: possible to set role in db's logon trigger?

Title: RE: 8.1.6: possible to set role in db's logon trigger? Roy, this is in 9202 ... check the custom code for hash joins ... it has been working fine for us for > 2 months ... CREATE OR REPLACE TRIGGER "SYSTEM".DBT_USERS_LOGON AFTER LOGON ON DATABASE -- DECLARE CURSOR cur_sess IS SELECT

RE: compatible in 9iRel2

David - Try COMPATIBLE=8.1.0 See the following link (you may have to patch it back together) http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96530/migcompa.htm#1 009871 Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 200

RE: compatible in 9iRel2

I am trying to apply a "fix" for some developers here. They used this fix in 8 and 8i by changing the compatible parameter and running their sql script. I just want to be able to tell them that they need to fix their application now that we are using 9iRel2. I tried this morning and got the ORA-

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Conrad - I haven't used 7.3.4 in quite some time, so my knowledge is a little rusty. If you search METALINK, you will find quite a few issues with this command on various Oracle versions. I believe that the basic principle is the same - Oracle builds a new index in the background, syncs up any tabl

removing duplicate entries from a table

Hi List Is there a tool for removing duplicate entries from a table - except that the key field is not the same. I ran some data imports more than once and was hoping someone could point me in the direction of a way to undo my mistake. Any help will be most appreciated Thanks Mark Warner __

RE: Daramtically improve BCHR with a single statement

"How can you tell that you need more space in the buffer pool?" ...You can notice when this is true by observing summarized extended SQL trace (event 10046) data. If the LIO count for a session is small, but the PIO count is large, then you have the problem. So, sure... Checking a session's BCHR

RE: dw tool question

Title: RE: dw tool question This is something I am currently dealing with. We have two products here:  Business Objects and BRIO.  It depends on what kind of end-user you expect to support.  The main difference I see between these two is that Business Objects can easily hide the metadata de

Re: BCHR Tuning

I too think the BCHR has its place, as a problem indicator. It can tell me theres something wrong with my database. Say, I have this database performing well, the users are happy, the BHR is mostly at 90%, and now it suddenly shoots down to 70%, or it suddenly increases to 98. Somethings amiss. It

RE: Recommendation for SQL Tuning Book

The Pocket Reference has been helpful to many people. The book appears to be at least a handy summary of some relevant aspects of Oracle's documentation. However, various colleagues have convinced me that there are many statements in the book that you can disprove using careful tests. Cary Mills

Re: removing duplicate entries from a table

Hi, following metalink documents may help you. Note:65080.1 Using SQL To Delete Duplicate Rows In A Table PR:1015631.6 HOW TO SELECT DUPLICATE ROWS WITHOUT USING ROWID PR:1004425.6 HOW TO FIND OR DELETE DUPLICATE ROWS IN TABLE Murat

RE: compatible in 9iRel2

I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either - never really needed it so I haven't bothered with metalink/tar. >>> [EMAIL PROTECTED] 01/13/03 11:16AM >>>I am trying to apply a "fix" for som

Re: bitmapped indexes

Andrey, Perhaps you could tell us what paper, and where to obtain it. >From the context, it sounds like a reference to physical modifications rather than DML. Jared On Monday 13 January 2003 07:54, Andrey Bronfin wrote: > Dear gurus ! > A ( maybe ) stupid question : I always thought that bitma

Re: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Though I'm not sure, I *believe* that in 7.3 indexes must be taken offline during a rebuild. That being the case, your users queries would not have executed properly. i.e. FTS would take place for queries that normally used indexed access. Jared On Monday 13 January 2003 08:14, Conrad Meertin

Re: Different Backups - A Comparartive analysis

On Monday 13 January 2003 06:03, Tim Gorman wrote: > Another question: should SQL BackTrack be included for consideration? What does SQL BackTrack to that RMAN doesn't do? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat

Re: DB Triggers vs Stored Procedures

In a nutshell, it is better to put your code in a stored procedure outside of the trigger. Why? Modular code is easier to reuse. You can't reuse code blocks that are in a trigger. There are other reasons, but this is the biggy IMO. As Ferenc recommended, get the Feurstein book. Jared On Su

Re: Oracle 7.3.4 Real-Time Re-indexing

Have you used parallel clause while rebuilding? What version of 7.3.4 ? Check alert_SID.log for any possible index corruption If any , then you have to check for table and all indexes on that. Find index/es with multiple keys , save their defination through export , drop those indexes and cr

Re: Daramtically improve BCHR with a single statement

So, if I coerce the developers into writing better code that does less logical IO, and the BCHR goes down, I should then investigate and fix the problem? ;) Jared On Monday 13 January 2003 08:09, Yechiel Adar wrote: > Hello All > > I saw that piece of code a few times and still think that even

Re: compatible in 9iRel2

You need to create the database with compatible set to 8.1.7.0. You can't create a database at one version and then lower the compatible level without downgrading or recreating. Jared On Monday 13 January 2003 09:16, Ehresmann, David wrote: > I am trying to apply a "fix" for some developers he

Re: newbie question - still: please help

Daniel, Your gut reaction is right on-target. It is always a struggle to keep certain folks from killing the entire village while trying to cure a single case of the sniffles. What's worse is that such folks are usually quite bright and talented. After, very few mediocre folks can either cure t

Re: newbie question - still: please help

Even with this little bit of information, it's obvious your DBA is on the right track. Any script that loops and executes 'hundred thousands of sequential update statements' is total nonsense. This will bring most any database to it's knees in a hurry. Oh yes, I've had developers pull this one

RE: 8.1.6: possible to set role in db's logon trigger?

Woah--free code! A thousand thanks--this looks really close to what I'd like to do. If I can wrestle some extra privs on our test db I'll report back as to whether I was able to get this going on 8.1.6. Thanks also to Lisa & Thomas for responding. Cheers, -Roy Roy Pardee Programmer/Analyst SW

RE: Daramtically improve BCHR with a single statement

:) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Still Sent: Monday, January 13, 2003 11:45 AM To: Multiple recipients of list ORACLE-L

RE: compatible in 9iRel2

Title: RE: compatible in 9iRel2 Curious minds want to know what bugs you are trying to fix ?? Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't re

RE: compatible in 9iRel2

Were you using any of the new tablespace features or using dictionary managed tablespaces? David Ehresmann -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Monday, January 13, 2003 11:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: compatible in 9i

RE: compatible in 9iRel2

We are running 9.2.0.1., do you think that could be the reason.   the .1=component specifiec Release Number?  Was your 9i  9.2.0.0.0? David Ehresmann. -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Monday, January 13, 2003 11:41 AMTo: Multiple recipients of

How to identify full table scans?

List, We use the following script to identify recent full table scans or full index scans. This result set will be used to identify the potential queries that could benefit by creating any new indexes or modify the existing index structure as needed. Our intention is to run this query against

USER_TABLESPACES has more rows than DBA_TABLESPACES

Has anyone else seen this or can you explain it?   I have 7 tablespaces in USER_TABLESPACES that don't exist in DBA_TABLESPACES. These have been dropped, but somehow did not disappear from USER_TABLESPACES. They have a status of INVALID.   The database is version 8.0.5 (Yeah, I know, we'll b

RE: compatible in 9iRel2

system is data dictionary - the rest lmt's with uniform extents>>> [EMAIL PROTECTED] 01/13/03 12:35PM >>> Were you using any of the new tablespace features or using dictionary managed tablespaces? David Ehresmann -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: M

RE: How to identify full table scans?

Title: RE: How to identify full table scans? Govind, Just curious why you are attacking the full table scans.  I implemented something like this in the past utilizing Steve Adams' script expensive_sql.sql.  It was very telling and very very useful. Lisa Koivu Oracle Database Administrator

RE: compatible in 9iRel2

I was curious about this parameter I have an application that is certified on 8.1.7 only Could I create a 9i database set compatible to 8.1.7 and essentially call it an 8.1.7 database?   -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Monday, January

Re: USER_TABLESPACES has more rows than DBA_TABLESPACES

> Keith Moore wrote: > > Has anyone else seen this or can you explain it? > > I have 7 tablespaces in USER_TABLESPACES that don't exist in > DBA_TABLESPACES. These have been dropped, but somehow did not > disappear from USER_TABLESPACES. They have a status of INVALID. > > The database is version

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Dennis, Here/ in this senario ' 'ANALYZE INDEX VALIDATE STRUCTURE' will not help or reveal anything except to anlyze table with cascade structure which will reveal any index corruption relating to that table. There was a bug in 7.3.4.3 where index rebuilding with parallel clause was resulting i

Re[2]: newbie question - still: please help

Daniel, After some of the younger folks in the audience have had a say, Let's let the "old fart" have one. While on the one hand I can see what your DBA is croaking on, I can also see where you are too. Your approach is easy to code, but can wreck hell on the database especially if each

ioug.org web site

Title: ioug.org web site Is anybody else having trouble with the www.ioug.org web site.  I can get to the home page, but cannot log in, or register for IOUG-A Live. Is it just me? Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to ki

Question On High Parse to execute ratio

Hello: I have a third party application which seems to have alot of unbound SQL statements, several of which do not seem to be very effective queries. Unfortunatelly the code is locked. My Parse to execute ratio is around 72% and I was wondering if anyone has any ideas on how I can decrease t

index rebuilding performance vs sort_area_size

Hi: Today I did some small testing on our db (Oracle 8173 on Solaris 2.8) to test index rebuild (with nologging) performance vs sort_area_size. I used "alter session set sort_area_size = " to set the sort_area_size value. Nothing else was changed. The temp tablespace is 8G. There is no other a

RE: Conversion from CLOB to RAW

I wasn't. I actually am still trying to look at the varchar2. The downside is the huge amount of data they want to keep in a compressed format hence the RAW or BLOB format. Regards, Bill Burke "The Kinder and Gentler DBA" IOUG University Master Class Faculty 2001-2002 "iDBA Management, High Per

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Thanks Rafiq. As I said, my 7.3.4 knowledge is too old by now (but man, was that a great version). Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 1:22 PM To: Multiple recipients of list ORACLE-L Dennis, Here/ in this s

RE: compatible in 9iRel2

David - No. This just ensures you don't use any "9i" only features. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 1:22 PM To: Multiple recipients of list ORACLE-L I was curious about this parameter I have an appli

Re: Question On High Parse to execute ratio

Success with using CURSOR_SHARING depends on your Oracle version. In earlier versions it's buggy. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 3:00 PM > Hello: > > I have a thi

Re: ioug.org web site

I don't know if it's just you, but I'm ok. I just logged in and went to the Live 2003 page without any problem. Check with your network folks. Stephen >>> [EMAIL PROTECTED] 01/13/03 12:49PM >>> Is anybody else having trouble with the www.ioug.org web site. I can get to the home page, but ca

RE: Question On High Parse to execute ratio

Jay - Here are the possibilities: 1. The vendor is stupid. Or doesn't understand Oracle. 2. The product was incorrectly installed. Some products are sophisticated enough to have a configurable interface, which may be misconfigured or need tuning over time. 3. You are missing a key piece o

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

Yes, it is as of today...We are still having 7.3.4.5 for our Oracle Financials 10.7 Application. This may be the last year for this version... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 13 Jan 2003 12:38:39 -0800 Tha

Re: Different Backups - A Comparartive analysis

Don't know really. Just thought that it should probably be included, then I was hoping to find out... :-) - Original Message - To: <[EMAIL PROTECTED]>; "Tim Gorman" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 10:49 AM > On Monday 13 January 2003 06:03, Tim Gorman wrote: > > Anot

Re: removing duplicate entries from a table

Mark, About how many rows are we talking about? Just curious... Log Miner might be a viable option. It comes with 8i but if the database in question is v8.0.x then you can still read them from an 8i database. From Log Miner you can extract the UNDO_SQL for the rows you want to delete. If you

RE: index rebuilding performance vs sort_area_size

We have not seen any performance gains after setting the sort_area_size in excess of 50Mb. We have set this as a standard in our re-indexing scripts to set this to 50Mb maximum. HTH. -Original Message- Sent: Monday, January 13, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Hi:

Re: ioug.org web site

Hi Matt, I registered last week without a problem, except they insisted on a credit card number even tho I owed $0. Looking forward to seeing you again! Ruth Gramolini - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 2:49 PM

Re: Question On High Parse to execute ratio

My colleagues call it CURSER_SHARING :))) "Igor Neyman"

RE: Conversion from CLOB to RAW

Bill - Will you need to search for information that will be compressed? If yes, then performance could be really, really bad. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 2:07 PM To: Multiple recipients of list ORACLE-L

RE: How to identify full table scans?

Title: RE: How to identify full table scans? This helps to identify the queries that could be tuned for LIO and/or PIO from a SQL Tuning perspective.  We can give this list to the development or application teams so that they could independently work off this list (hopefully!). -Origi

RE: Different Backups - A Comparartive analysis

Is SQL BackTrack a product like RMAN (from Oracle Corp. or 3rd party )? -Original Message- Sent: Tuesday, January 14, 2003 2:09 AM To: Multiple recipients of list ORACLE-L Don't know really. Just thought that it should probably be included, then I was hoping to find out... :-)

rdist Examples

rdist is a good way to keep files (sql, tools, tnsnames) synchronized between servers, in my case I need to replicate /db01/foo/* to /u01/foo/* Going from /db01/foo to /db01/foo on a different server is easy but I can not find any examples of going to another directory structure. The docs are n

Re: Different Backups - A Comparartive analysis

I *think* that RMAN does everything SQL Backtrack does. Can't be positive, as I haven't used it for awhile. RMAN seems to have everything I recall SQL BT having, and then some. Jared On Monday 13 January 2003 12:38, Tim Gorman wrote: > Don't know really. Just thought that it should probably

RE: Minimum required init.ora parameters

Curious, for which platform is 8.1.8 available? And *why*? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > Sent: Mond

Was 8.1.6 certified on Solaris 8?

We're upgrading from Solaris 2.6 to Solaris 8 and 8.1.6 to 8.1.7 on one of our boxes. I want to know if it's possible to do the OS upgrade first and then the database upgrade (e.g., I'd be running 8.1.6 on Solaris 8 for a day or so). The Oracle certification matrix only says that 8.1.6 is desuppo

RE: ioug.org web site

I spoke with Matt and he is able to register / log in. As it usually happens, he got it working right after he sent the email. Take care, -Ari Kaplan -Original Message- Andert Sent: Monday, January 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L I don't know if it's just you,

Re: index rebuilding performance vs sort_area_size

The increase in performance of course comes from sorting in memory and avoiding disk writes. Try running this bit of SQL before and after your tests, and record the numbers: select stat.sid, name.name name, stat.value from v$sesstat stat, v$statname name, v$session sess where stat.si

2 basic Qs. on export

1) Large Export Dumps , if Directly Exported to TAPE Devices , Can Import be safely Done therefrom ? FILE= OR is it advisable to compress / Split the Export Dump Files onto Storage Box & thereafter backup the Same onto Tape ? 2) With Oracle 8i & 9i Does export backup fired at a certain Ti

RE: Question On High Parse to execute ratio

Jay, Take a look into using stored outlines. If the problem is with the vendor's code not using bind variables, I don't know that this will help, but you may find some instances where it might be useful. I heard recently that a book should be written with just one chapter on bind variables.C

RE: Question On High Parse to execute ratio

In fact, in 8.1.7.2, it can cause *incorrect* results in certain queries without reporting an error! 8.1.7.4 is supposed to be a little more stable (applying that minipack to production as this is typed), and 9iR2 is reported to be even better. For us, it was CS=F or die (dead server, die trying

perl timeout

Does anyone have some perl code that will return an error if it take longer than a certain number of seconds to connect to or return the results from a database? I'd like to have some of my queries connect to an alternate database if there is a problem connecting or returning results within 10 seco

RE: #of blocks in extent

And of course to calculate you'll need to know your block size and your extent size. -Original Message- Sent: Saturday, January 11, 2003 10:34 AM To: Multiple recipients of list ORACLE-L UNIFORM SIZE clause of Tablespace, if it is LMT. --- Igor Neyman <[EMAIL PROTECTED]> wrote: > INITIA

RE: Question On High Parse to execute ratio

CURSOR_SHARING won't reduce the "parse count (total)" count; only eliminating parse calls from your application can do that. Using CURSOR_SHARING will reduce the "parse count (hard)" count (and maybe some shared pool latch contention), but at the expense of more user-mode CPU consumed during each p

  1   2   >