RE: how to stop a killed session bothering me ?

Doing a shutdown abort is hardly dangerous. Granted, it is not as clean as shutdown normal or shutdown abort, but it is not dangerous. All it does is severe the connections. When the instance comes up, it goes through and starts rolling back looking through rbs and redo logs. I look at

RE: Installing Oracle 9i

Have at least that if you are creating the database during your install. Otherwise you will be switching logs real quick. You might change it back after the initial database creation though. -Original Message- From: Eca Eca [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07,

RE: computer history stories - Now: Age discrimination?

With reference to the postings about quick learning and all that, I remembered a story: There was a Talmudist - no job and no money. His wife confronted him. It bothered her that she alone was worrying about their situation and he didn't seem concerned at all. Not true, he says, I just worry

RE: computer history stories - Now: Age discrimination?

[via oracle-l digest] -- From: Rachel Carmichael [EMAIL PROTECTED] Date: Mon, 06 Aug 2001 18:22:47 + Subject: RE: computer history stories - Now: Age discrimination? ... My IQ is not low, yet I CANNOT for the life of me learn physics That is because you

RE: computer history stories - Now: Age discrimination?

[via oracle-l digest] -- From: Henry Poras [EMAIL PROTECTED] Date: Mon, 6 Aug 2001 15:44:26 -0400 Subject: RE: computer history stories - Now: Age discrimination? ... E are you out there? A lot of people seem to think so! ep didn't some famous

RE: Code Red

Thanks! KK -Original Message- Patrice J Sent: Tuesday, August 07, 2001 3:56 PM To: Multiple recipients of list ORACLE-L http://tds.diamondcs.com.au/html/intro.htm http://tds.diamondcs.com.au/html/intro.htm Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)

RE: negative value for buffer cache hit ratio

Nothing is wrong in your database. You don't have the required X_$ views created. Change X_$ to X$ or create X_$ views as select * from X$ views. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA.

RE: free up datafile space problem ???

I just sent this to the other list... Here is a quick script to list the tablespace/datafiles and their higwater marks, as well as generate the resize commands; --begin script col blksz new_value blksz noprint; col tablespace_name for a20 heading Tablespace|Name; col file_name for a50 heading

Re: OT: Over seas online demo

Kevin, Try VNC. It works across multiple platforms and has a web interface. http://www.uk.research.att.com/vnc/index.html On 07 Aug 2001 11:43:20 -0800, Kevin Kostyszyn wrote: Hi all, Was wondering if anyone knows of any software (bedsides pcanywhere or Citrix) that could be used to

sqlloader stops

Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is

Re: Precise

Hi! O'Neill, Sean writes: Is no-one on this list using Precise SQL or Precise Pulse?. Has anyone heard of them or evaluated them?. We are using Precise/SQL for over a year now. I like the ability to find any correlation between a statement, the calling users, the calling sessions, the host

RE: how to stop a killed session bothering me ?

Yes upon startup. When you kill and the session doesn't leave their locks and changes its serial# as a few of its symptons, PMON take charge. --- A. Bardeen [EMAIL PROTECTED] wrote: Jim, No, since 7.3 SMON does the rollback in the background upon startup. If a user session attempts to

Re: negative value for buffer cache hit ratio

It is possible that after 4 months your stats have wrapped around the ( ? 64 bit ?) limit value for your platform. Check the actual values from v$sysstat to see if some of them have gone negative or appear to be 'counting backwards'. Jonathan Lewis Seminars on getting the best out of Oracle

RE: Over seas online demo

VNC is a useful, free, yet insecure option. Another would be Dameware (www.dameware.com). I use Dameware in the office and in my home. The price is reasonable, it is considerably more secure, and will install the remote agent on the server as a service, provided you give it the right login

Re: PARTITION attache to SYNONYM

Which version of Oracle ? I got a 600 error when trying to create a partition when using a public synonym instead of the table_name on 8.1.7.0 Have a look in dba_segments for segment_name = 'your table name' and segment_name = 'your synonym', check especially the OWNER in case something very

RE: Over seas online demo

Yes, NetMeeting can be used for that purpose. Some of the Oracle Education sites use it for classwork exercises. --Michael -Original Message- Sent: Tuesday, August 07, 2001 3:43 PM To: Multiple recipients of list ORACLE-L Hi all, Was wondering if anyone knows of any software

RE: negative value for buffer cache hit ratio

I assume you have 8.1.7, since 8.1.7 they changed things back to how it was done in 7.3.4. This script works for 7.3.4 and 8.1.7/9.0.1 select to_char(100 * misses / (logical - physical + misses), '9990.00') || '%' miss_rate from ( select total_waits misses from sys.v_$system_event

Re: free up datafile space problem ???

Janet, You can only reduce the datafile by the amount of contiguous free space at the end of the datafile. Back up your DB before you try any of this. I never play with tablespace and datafiles without a current backup. Use alter tablespace coalesce, then query dba_free_space, dba_data_files

RE: sqlloader stops

Just a stab here... Check the .bad files to see if you are getting any data rows kicked out due to errors. If so, you might be exceeding the ERRORS parameter by the time you finish the third file. HTH. David Wagoner DBA -Original Message- Sent: Tuesday, August 07, 2001 4:15 PM To:

Re: negative value for buffer cache hit ratio

Welcome Jonathan, I think most of the counter are limited by ub4maxval and that makes the negative hit ratio. Welcome again ! --- Jonathan Lewis [EMAIL PROTECTED] wrote: It is possible that after 4 months your stats have wrapped around the ( ? 64 bit ?) limit value for your

RE: sqlloader stops

My impression is the ERRORS parameter is set for each single load not number of loads. No, there is no bad file. Thanks David. -Original Message- Sent: Tuesday, August 07, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Just a stab here... Check the .bad files to see if you are

How to determine checkpoint rate?

I am trying to locate a stat that is incremented every time a checkpoint occurs. I see a few checkpoint related stats in V$SYSTAT but none seem high enough to match the number of checkpoints that have occurred as a result of log switches, log checkpoint timeouts. Am I mistaken on this? Is

RE: negative value for buffer cache hit ratio

Christopher Thanks. This script ran from 7.3.4 to 8.1.6 with following result... I hope misses less than 1% is not bad...Any comment SQL select to_char(100 * misses / (logical - physical + misses), '9990.00') || 2 '%' miss_rate 3from ( select total_waits misses 4from

RE: Optimizer Mode......how to choose the right one?

what would you do with an application that has 3 GB of data and 6 GB of indexes developers keep telling me that they can't get rid of any index because they use them all. how can I prove wich indexes are never used?? Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera

Re: sqlloader stops

Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server

RE: negative value for buffer cache hit ratio

Hi, My misses is MISS_RATE - 0.68% Is that good or bad, Oracle 8.0.5 Standard Edition, Windows 2000. Is there a 8.1.7 Standard Edition Version ? Ramon Estevez [EMAIL PROTECTED] --- Christopher Thanks. This script ran from 7.3.4 to 8.1.6 with following result... I hope misses

RE: Optimizer Mode......how to choose the right one?

If u can persuade them, create better ones. F.e.: Issue this query to look for better indexes: select u.name || '.' || ot.name TABLE, oi.name INDEX, ic.pos# POS, c.name COLUMN, h.distcnt DIST VAL from sys.user$ u, sys.obj$ ot, sys.obj$ oi,

RE: sqlloader stops

Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 2001 5:37 PM To: Multiple recipients of list ORACLE-L Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I

RE: Over seas online demo

Hey all, Just wanted to say thanks to everyone that replied to my question. I am going to go with a product from Centrinow.com, seems to do the job well and it's free!!! Thanks again. KK -Original Message- Michael Sent: Tuesday, August 07, 2001 4:16 PM To: Multiple recipients of

RE: negative value for buffer cache hit ratio

Hi, Generally speaking.. HIT RATIOS does not give the true picture always. I have seen databases performing extremely good with 50% and bad databases with 99% hit ratio. You should never decide the database performance based on hit ratio and 90% hit ratio does not mean that 90% of the data is

RE: Precise

Title: RE: Precise First a disclaimer (since this is going to sound like a love feast). I do not have any ties to Precise Software Solutions nor do I receive any material gain from your purchasing decision. We've been using it since day one of its release. It has many of the features common

Oracle for Unix Clients, LD_LIBRARY_PATH and Its Impact on Other

This environment variable is usually not set in UNIX. However Oracle executables require a directory list be passed to the runtime linker; thus when setting up the Oracle environment one often has something akin to the following setenv LD_LIBRARY_PATH

Re: free up datafile space problem ???

I think you may find that your 'hwm' comment is a version dependent thing, and a restriction on RMAN which always seems to back up to the tablespace 'hwm'. Certainly from 8.0.5 onwards, I have reduced file sizes before setting tablespaces readonly by fiddling about with: alter table move

RE: Over seas online demo

Kevin, You might also consider recording the demo using Techsmith's Camtasia product www.techsmith.com. I have used it in the past to record tutorials and demos for my web site. I highly recommend it. Perhaps you can check out also see what http://www.groove.net/ and http://www.webex.com have

Testing posting to Oracle-L list...

Hi DBA's, I joined previously, but for some reason my membership was not activated. I've joined again and I'm checking if my membership is registered now. Regards, Denmark W. _ Get your FREE download of MSN Explorer at

RE: How to determine checkpoint rate?

One more idea, set up www.gotomypc.com on a computer and allow the client access from one of their machines. They will be able to see everything you are doing. I use it and it is excellent. It requires no software for the client and you could have it running in as little as 5-10 minutes. -

Upgrade problem

Trying to do an upgrade from 8.0.5 o 8.1.6 on HPUX 11. When I start up the installer, it says Initializing Java Virtual Machine .. Warning: Missing Charsets in String to Font Set Conversion Warning: Cannot convert string dt-interface user-medium-r-normal-s * * * * to type font set Any ideas on

RE: Over seas online demo

Ethan, Yeah I have used that program in the past as well, very cool. This is going to be a live demo, I would consider using Camtasia, but don't those files usually get a little large? KK -Original Message- Sent: Tuesday, August 07, 2001 6:35 PM To: Multiple recipients of list

RE: Optimizer Mode......how to choose the right one?

It's correct, I've only analyzed the schema where the data of the application is stored. Thanks for your comment! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -Mensaje original- De: Miller, Jay [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 07 de

How to locate who dropped a view using log miner?

Hi listers, I know most of you will advice me to turn audit on, but I like the hard way better. I've been able to locate who drops tables based on the dml operations on fixed tables. According to note 93370.1 from Oracle, the hint for locating who dropped a table is to look for a DELETE

RE: Optimizer Mode......how to choose the right one?

try analyzing using the for all indexed columns clause .. --- Miller, Jay [EMAIL PROTECTED] wrote: You probably already thought of this, but I hope you aren't analyzing the SYS schema? This can cause terrible performance problems. Jay Miller -Original Message- Sent:

Re: How to locate who dropped a view using log miner?

you're making things way too hard. logminer is in its infancy at best up thru 8.1.7(its a tad bit better in 9i shameless plug and if all goes well, i'll be doing a talk on it at IOUG 2002 /shameless plug How do you handle when things go south and only internal shows as the operation, you're

RE: How to determine checkpoint rate?

I began indiscriminantly delete OT messages. Too much. Alex Hillman -Original Message- Sent: Tuesday, August 07, 2001 6:57 PM To: Multiple recipients of list ORACLE-L One more idea, set up www.gotomypc.com on a computer and allow the client access from one of their machines. They

RE: Over seas online demo

I provided another reply to the wrong post but also check out www.gotomypc.com, 5 *'s. If you use 256 color, the right sound codec, 1 frame per second, and nothing more than 800*600 you can get very good compression, around 500K per minute. 7 MB for a 30 minute demo with audio ain't bad. Oh, I

RE: ORA-12546 TNS:permission denied

Hi, I am installing a program that requires root to create/alter a database. I know this is not correct but there is no way around this. I actually solved the problem by applying 775 permissions to directories higher up in the order. This seems to have solved the problem. Thanks for your help

Re: computer history stories - Now: Age discrimination?

Speaking of beer. My husband had his IQ tested AFTER he discovered beer and whiskey. A few years later he gave up the stuff and his IQ went up remarkably. Perhaps IQ is just a measure of sobreity ? ;-) - Babette - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Optimizer Question

Suppose I have two tables. SQL describe test NameNull?Type --- NVALUE NOT NULL NUMBER(2) SQL describe test2 NameNull?Type ---

RE: How to locate who dropped a view using log miner?

Title: RE: How to locate who dropped a view using log miner? take a look at the sys.ind$ table for indexes sys.view$ for views sys.source$ for stored procedures HTH Nick Wagner Quest Software www.quest.com -Original Message- From: Mario Alberto Ramos Arellano [mailto:[EMAIL

RE: Optimizer Mode......how to choose the right one?

what may be the differences between using this clause and not using it? Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -Mensaje original- De: deepak thapliyal [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 07 de Agosto de 2001 05:41 p.m. Para:

Private vs. Public Rollback Segments

Can someone explain the benefit of using a private rollback segment? The only advantage I can see is having more control over what rollback segments actually come on line when the instance is started. The drawback is you have to use the rollback_segments parameter in the parameter file which we

RE: How to locate who dropped a view using log miner?

Title: RE: How to locate who dropped a view using log miner? Hi I dont find any records in v$logmnr_contents even if i dropped tables /views. Should i enable any parameter and restart db to get records. srinivas -Original Message-From: Nick Wagner [mailto:[EMAIL

RE: Private vs. Public Rollback Segments

Hi all, I think we can create a big private rollback segment for huge transaction when we need one or two. Sinardy -Original Message- Sent: Wednesday, 8 August 2001 8:45 AM To: Multiple recipients of list ORACLE-L Can someone explain the benefit of using a private rollback segment?

How to locate who dropped a view using log miner?

Hi listers, I know most of you will advice me to turn audit on, but I like the hard way better. I've been able to locate who drops tables based on dml operations on fixed tables. According to note 93370.1 from Oracle, the hint for locating who dropped a table is to look for a DELETE operation

Re: sqlloader stops

How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07,

Unix and Oracle

Hi all, I have a table with 3 columns which are Counter, Officer, TYPE, PRICE, Counter number 4 TYPE is only contain either Sell or Buy Officer number 4 price number 11 I want to spool out report with SQL to be like this example Counter : 0

Re: Unix and Oracle

How in the world did you come up with a subject line of 'Unix and Oracle?' I can't help you get that counter column on top of the buy and sell header line, you may want to put its column to the left of Officer, and maybe BREAK on it to not print duplicate values. And you may have to change some

Re: SUMMARY: BIG PROBLEM

Yep, that was me :) I left Qwest (formerly U S WEST) last year, one day after my 19 year anniversary. No regrets, my new job challenges my skills and keeps me busy (but leaves little time for beer). Geesh, here it is August and I'm finally reading oracle-l from June... John Kanagaraj wrote:

Re: connection times...

Are these JDBC connections? 8i has a bug with MTS that causes dispatchers to hang when using JDBC thin connections. Search Metalink for Bug 1684600. We've experienced this problem with both 8.1.5 8.1.7 on Solaris 2.7. Richard Huntley wrote: Anyone know of some quick checks to perform or

<    1   2