Re: How to apply patch to Solaris for Intel

Dave, zip files can be handled on many platforms these days and I'd hope that Intel Solaris can process them if they're zipping system patches. Try which unzip to try to locate the executable or look for a man entry. I can unzip files on Sparc Solaris and AIX so I suspect you won't have a

RE: Oracle error after recovery

Ron, Check that the instance lock file LK isn't still present in your $OACLE_HOME/dbs directory. It's there to stop a database being mounted twice and in the case of a database crash there's a good chance that it's been left lying about. Cheers, Mike Hately Oracle DBA PS 1st email to the

RE: deletion of data from a large table

Hi folks, Rick Cale was correct in saying that a truncate would release the storage by default. The only other option is to drop and recreate the table. Oracle will only release allocated storage when it is specifically asked to. The overhead on having a process monitoring which space it can

Re: Solaris 8 Question

Sam, you may find that you need to issue archive log stop and archive log start to force the database to start archiving again. Once it's failed to archive a log it seems to lose heart and give up until you nudge it. Ironically the ARCHIVER will keep writing to the alert log to say that it's

Re: get yesterdays date

I'll save you the trouble John; it was Sunday June 22nd. Sossy, couldn't resist. Alternatively you can select SYSDATE -1 from DUAL. Cheers, Mike Hately |+--- || John Dunn| || john.dunn@se| || fas.co.uk |

Re: How to download website

WebReaper isn't bad. NetVampire is OK too. Some site will detect this kind of activity and will kill your connection. Regards, Mike Hately |+--- || prasad | || maganti | || prasadm_g@ya| ||

RE: Urgent Select statement SOS

The only way you can do this is to store SYSDATE into a column in the table when you insert the row and to use that column value to order the rows when you SELECT from the table. Yoiu can generate the date from an ON INSERT trigger. Cheers, Mike Hately Oracle DBA -Original Message-

RE: 9i RAC's

Early publicity for RACs specifically said that it was an OPS upgrade and made great play of cache fusion which was already available in 8.1.7. I agree with the previous point that OPS was often thrown at applications that were badly suited and so customers perceived it as a poor technology.

RE: Linux Download and ADSL

UK telecomms is in a hell of state. For most of us the best option is a fast connection at work and a CD writer. Cheers, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: How to execute Unix Command/program within a pl/sql block.

Hi, you can't do this from PL/SQL but you can do it from Java and it's fairly easy too. I'm not able to check the name of the class tht does it but armed with the phrase java os command and either the Metalink or Ask Tom web site you should be able to track it down. Regards, Mike

RE: OFA (Optimal Flexible Architecture) in practice

Hi, If you can cd to a single directory and list all of your files then it means that all of your files are in a single filesystem probably (unless you've been VERY clever) sharing the same disks. I agree with the suggestion that you can create links to the datafiles from a central directory

RE: can i place online redologs with oracle engine ?

Hi, There's very little I/O done to the ORACLE_HOME unless you've chosen to store and database files under it. As for Unix, it would depend on how your filesystems are alocated. Steer clear of /tmp and you should be OK but don't let anything fill up any 'OS' filesystems such as /, /var etc.

Re: Oracle9i on Suse Linux

Jonathan, I saw almost exactly the same thing with 512MB , 512MB swap, Suse Linux 7.1 also.. Some stuff that springs to mind: Did you dynamically change the SHMMAX setting before the install and if so, did you make the same change once the machine had rebooted? When you're prompted for the JDK

Re: Oracle9i on Suse Linux

Jared, Oracle 9i is certified with Suse 7.1 out of the box. It specifically needs the 2.4.4 kernel and glibc 2.2. There should be no need for any patches. Regards, Mike |+--- || Jared Still | || jkstill@cybc| ||

Re: Schema organization

Stephane, I'm sure they would prefer to operate as the schema owner but to me it's sloppy practice. You're right; create the objects as DWH and grant the necessary permissions to the application users. That way only the schema owner has 'admin' rights (create, drop, alter etc.). If they can't

Re: PFILE location in NT

Hi, sorry but no, there's not. You can see your ifile setting in v$parameter but the init.ora isn't available. Regards, Mike |+-- || Shahid Nasir| || shahidnasir@emi| || rates.com | ||

Re: Two indexes same columns

No, there would be no benefit and it probably wouldn't be allowed anyway unless you reversed the columns in the 2nd index. Regards, Mike Hately. |+--- || Connie | || Milliken | || cemail@sprin| |

RE: 9i Open Day (UK Listers)

Reading or bracknell, may as well be the moon. I've got a living to make. I read the blurb on my invitation and it looked like a barely-scratch-the-surface-sales-job. I've got 9i installed and I can glean the same depth of information from the Oracle web site. Mind you, if I was in the area I

Re: Speed up massive delete

Jack, First of all you could explore these options : Could you truncate the table ? Could you copy out the rows you want to keep (using CTAS NOLOGGING) /drop the table/rename 'kept-rows' table to original name? Are the rows in a partition that you could drop? If none of these are possible

Re: Fragmentation Locally Managed Tablespaces

Rachel, That maximum isn't a hard limit. Oracle themselves impose no limit of this kind. After you use all of the available space in the segment header block, any additional space map entries are overflowed into additional extent maps within the segment. This means that because the used extent

Re: OT: Exploding the Mythns

I think I've missed a bit of this thread so apologies in advance. I always set timed_statistics-true and I don't worry unduly about lots of extents. I'm aware of problems with both approaches (bugs etc.) but as general principles I'm happy with them and they've never caused a problem. What's

Re: Speed up massive delete

Ron, How does creating indexes as UNRECOVERABLE save time when you insert data? As far as I'm aware the only operation it will save time on is the initial creation. Regards, Mike |+--- || Ron Rogers | || RROGERS@galo| ||

Re: Common Oracle RDBMS Misconceptions

Hi, Can't remember who started this thread but the most common misconception I see is : NOLOGGING (UNRECOVERABLE) stops redo log generation. though another favourite of mine is : The Universal Installer is useful and You can use the 8i database assistant to reliably create a database.

Re: OT: Exploding the Mythns

Rachel, Thanks for that. Ive read and enjoyed that paper. I was actually defending your corner as the previous post seemed to be implying that you were in the wrong. Confusion reigned. I've experimented with TIMED_STAISTICS and high numbers of extents and my experience bears out your

Re: Speed up massive delete

Ron, I can see why it would save redo generation on direct load inserts. I can't understand why it would save any time on ordinary inserts, updates, deletes or import. I'm sure that your loads are direct loads and they make use of NOLOGGING/UNRECOVERABLE which is where you'll see the savings.

Re: Virus again

Just got it. 3 posts in a row. It seems to be replying directly to anyone who posts to the list. Cheers, Mike -- 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

Re: Common Oracle RDBMS Misconceptions

Sorry, that attempt at humour has been withdrawn due to quality control issues. Regards, Mike |+--- || novicedba | || novicedba@ho| || tmail.com | || | ||

Re: OT RE: 24 x 7 on NT?

More on the same vein. Sorry if this thread is developing a me too feel. I'm happy to use GUI tools when they save me time. I know what they're doing and how they achieve their results. The availability of GUI tools is however a huge disincentive for new DBAs to find out how the database

RE: NOLOGGING FEATURE

Greg, In 9i our good old Relational Trace File Management has been renamed to Real Trace File Management. Worse than that. The Logical Oracle Listener option is now called Real Oracle Transmission Failover Listener Management Advanced Option. Regards, Mike Hately Oracle DBA Greg Solomon

Re: NOLOGGING

Hi Greg, Delete isn't an operation that supports nologging. So you should see exactly the same performance. Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: License high water mark

Dave, I've never seen the license HWM cause a problem. It's usually informational in order for the DBA or auditors to tell if them have purchased sufficient licenses. Internal limit messages often indicate that a process is trying to exceed a user or system limit (memory/semaphores/file

Re: timed statistics

Greg, No, though in early versions of Oracle 8 there are bugs that can trip you up. At 8.1.6 timed_statistics is stable and low-cost in my experience. I've tried to measure the performance hit but I've never noticed any difference at all. I personally wouldn't run without it. Regards, Mike

RE: 9i On Linux

Hi, The recommendation is definitely 512MB RAM + a swap partition of twice that size. I installed on Suse 7.1 with 512MB RAM and a 600MB swap partition and encountered relatively few problems. RedHat should be OK as it's based on the 2.4 kernel. I can't recommend Suse highly enough though.

Re: Digestive

Agh!! Ice. Chills the taste buds. Impairs the flavour. Sometime a little water if it's a strong malt. Mike -- 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,

Re: Oracle 9i database for Linux available for download on Technet

Coincidentally, when you open Disk3 in Winzip the 'packed' size is almost exactly a tenth of the size reported on the TechNet site. I think someone put an extra 5 on the end of the size on the web page. I haven't tried to use it yet though. It's being burned to CD right now. Regards, Mike

RE: Digestive

Weird. When I saw the word digestive Lagavulin and Laphroiag both sprang to mind. Just shows you. great minds ... They're an acquired taste I admit. Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat

RE: Digestive

Laphroiag is very very nice. I still prefer my Talisker and I have a 30-year old Glenfiddich at home that I'm working my way through VERY slowly. I plan to buy a bottle of something from the year I was born ( '67 ) but the older I get, the more expensive they become. -- Please see the

Re: S.A.M.E. and HP XPs

SAME, It's easy, it's fast, it's convenient and it should guarantee that you get sub-optimal performance. Never terrible but never great either. You get out what you put in. Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

RE: Quer

Hi, Oracle 8 datafile limits: The maximum number of files at Oracle 8 is OS dependant but usually it's 1022 per tablespace and 65533 per database. As with any program, the values of variables are held in control structures and it's up to the developer to arrive at sensible maximum limits for

RE: LOT (Little OT): Interesting Oracle related URL's.

Folks, Just my opinion but : Hosting a document on your site without the author's express or implied permission is bad. Providing a 'deep' link direct to a document within another site is OK if you check with the site owner. It's plain bad manners if you don't OK it first. Linking to the home

Re: OT / LOL/ Serious Question (believe it or not)...

Speilberg eh? Can we call it Saving Private Synonym. Woo hoo hoo hoo hoo hee hee !!! [sounds of general thigh slapping and side-splitting] Cheers, Mike PS Sorry folks, I realise how pathetic that was but it's Friday so give me a break =) PPS Yes John (G), I KNOW! On Thu, 7 Jun 2001,Luis

Re: OFA Question

In performance terms it won't really make a difference but from an admin point of view it's not a great idea. It's way too easy to accidentally move or remove a file during a routine operation and it can can confuse backup and restore operations. If I ever have to do this I create a

Re: PCTUSED??

Hi If the pattern of deleted dta leaves you with many almost empty leaf blocks then you may find that you would benefit from and index COALESCE rather than a REBUILD. On the subject of wasted space in table blocks it's very difficult to generalise. The best way to go may be to analyse the table

RE: OT RE: SUMMARY: Thanks everyone - tru64

I'd like to apply for evil-flying-monkey-thing or failing that, the muchkin who says Follow the yellow brick road! first. I have previous experience of being evil, flying and saying Follow the yellow brick road!. I have studied being a monkey to degree level. I'm ready for my closeup.

RE: Oracle 9i is on technet (NT)

Yeah, I created my Solaris Intel CDs at the weekend but it won't help me with 9i unfortunately 'cos the download's only for Sparc architecture. Maybe I'll need to spend cash. =( Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: How to prevent oracle from committing a transaction?

Hi, If you set autocommit off it will rollback any uncommitted transactions by default when you exit SQL*Plus. regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: How to prevent oracle from committing a transaction?

Wow, you're right. Let this be a warning to you all; this is what happens to your brain when you mess with DB2. Just say no kids. = ) Thanks, Mike Hi Mike, I was also thinking so. But it doesn't do so. Setting autocommit off will implicitly commit all your transactions

Re: Messing with DB2

I'm having my first brush with it and it's a bit of a shift. Seeing as IBM now own Informix I'd expect them to rip off its features and incorporate them into DB2. First impressions are that it's easy to set up a default database but not as tunable as Oracle but having said that I'm at no great

RE: Auto Extend

Hi John, I still haven't learned not to make sweeping statements on mailing lists = ) I expected someone to raise SMON or checkpoint overheads so I added necessarily very deliberately. Agreed, I'd tend to keep the number of files down to a reasonable number but I've run a database with 3,500

RE: Oracle 9i is on technet (NT)

That's definitely what they do. Anyone want to sell me a Sparc box? Not you Spence, the shipping costs would bankrupt me !!! = ) Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Auto Extend

Hi, Neither large files nor small files are evil. As with all things, fit the solution to the problem. Small files can leave you with lots of separate datafiles which isn't necessarily a drag on performance but can be an administrative chore and can cause more wasted space due to that pesky

Re: how determine chaining if using gather_stats

Hi, GATHER_STATS only returns statistics that Oracle considers to be useful to the CBO. That doesn't include information on chained rows unfortunately. Cheers, Mike Hately, Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat