initjvm.sql

Hi friends, I have problem during execution of initjvm.sql The step's which i have followed. 1)Increased system tablespace 200 mb 2)increased the shared pool size 50mb 3)increased the java pool size to 50mb 4)ran rmjvm.sql 5)initjvm.sql While runnig initjvm.sql the script hangs while i

How to read trace file

Title: How to read trace file Hi! A developer handed me a trace file that he has taken from a session. How do I read the output? It looks totally different from the ones that I know (formatted by tkprof). The Performace Tuning Book from Oracle Press doesn't have anything about

RE: How to read trace file

Title: How to read trace file That needs to be tkprof'd unless I am much mistaken. -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: 12 November 2001 08:25To: Multiple recipients of list ORACLE-LSubject: How to read trace file Hi! A developer

bad BIND variable

IWANT TO CREATE a dynamic trigger where inside; :new.column_name occurs and column_name changes in a loop . DECLARE cursor c1 is select column_name from arsiv.logged_columns where table_name = 'K_IMID_KURUM' ;kolon c1%rowtype; BEGINFOR kolon IN c1 LOOPye := :new.||kolon.column_name;

Re: How to read trace file

did you run it through tkprof? --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! A developer handed me a trace file that he has taken from a session. How do I read the output? It looks totally different from the ones that I know (formatted by tkprof). The Performace Tuning Book from

ORA - 12560: TNS: protocol adapter error

Title: How to read trace file Hi, I have installed your Oracle 8i EE trial software. When i am trying to connect through SQLPLUS with username: SCOTT andpassword: TIGER i am getting the following error :- "ORA - 12560: TNS: protocol adapter error".Could you tell why i am getting this

OT_salary

Hi i'd like to know what average salarys are in european countries for a medium skilled DBA. my first contribution is 40 USD vr. gr. g.g. kor rdw ict the netherlands -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Re: why shrink rollback segs?

If rb's are small, then there is a good chance that just when they are about to aged out of the buffer cache, hey presto! another session needs them again - so you end up with a nice scenario where they spend their life in the cache and cause virtually no IO. As they get larger and larger, the

RE: OT_salary

In the UK, it is around £30-35K. It used to be around £40K but the salaries have dropped after the IT bubble burst. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext.

RE: Scripting and NT

Hi, could somebody help me out with a very short utl_file example for Windows NT? I would like write error data into a simple text file, but I get exceptions. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED]

utl_file example

Hi, Sorry for the previous post with a wrong subject in it. Could somebody help me out with a very short utl_file example for Windows NT? I would like write error data into a simple text file, but I get exceptions. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ:

Slow connection time

Hi LIST, I have a performace problem with the a Database. The time to connect takes upto 40 seconds and more. Oracle 7.3.2.3 HP-UX 10.20 5 Databases on the Server, each has one listner running. One database has about 250 Session, the other only 10-15 I have TNSPING running (on the same

Sqlloaderquetsion

Hallo you DBA's, How can I write in a sqlloader script, the ctl file if I want this to happen: If there is a ? in the file to be laded then I would like to have the number '98' in that field and if there is a ! in the file to be loaded, then I woul dlike to have the number '97' in that

Re: ASCII Char function

Hi Muthu Try this PL/SQL , HTH FUNCTION get_asscii (in_val IN VARCHAR2 ) RETURN VARCHAR2 IS lv_valVARCHAR2(2); BEGIN SELECT CHR(in_val) INTO lv_val FROM DUAL ; RETURN(lv_val); EXCEPTION WHEN OTHERS THEN RETURN (NULL); END;

RE: OT_salary

Of course its a per annum salary. We DBAs would have been millionaires by now if that kind of a salary were paid monthly.and people would have flocked to the UK instead of the US :)). But then again, it is quite a comfy salary in the UK since the cost of living is low. Samir Sarkar Oracle

Sockets and Pl/SQL

Hello All I want to write a trigger for my oracle DB that can write to a socket when a new record is inserted in to a table, Could anyone please help me how can I call socket methods in PL/SQL My OS is Linux. Thanks E. __ Do You Yahoo!? Find

RE: utl_file example

Title: RE: utl_file example Hi, Verify UTL_FILE_DIR init.ora parameter is defined properly. In FOPEN function specify, filepath and filename as separate. [EMAIL PROTECTED] ; 1 DECLARE 2 fid UTL_FILE.FILE_TYPE; 3 BEGIN 4 fid := UTL_FILE.FOPEN('c:\','test.log','w'); 5

RE: initjvm.sql

Does your alert log have any errors? When perfoming this, I had to increase the java_pool to a larger number and make sure that the OS limits allowed the amount of resource I was allocating in the sga (e.g. unlimited across the board on ulimits in Unix). I have also found that following

Re: Slow connection time

Download a free version of traceroute for HP-UX ( I think it doesn't come with the software ) and issue a traceroute to the site. Either the name or the ip. Or both. Have you issued a ping ?. --- Zinsmeister, Klaus {PTBF~Basel} [EMAIL PROTECTED] wrote: Hi LIST, I have a performace problem

RE: initjvm.sql

rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following. If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be

Antwort: ORA - 12560: TNS: protocol adapter error

Hi did you set ORACLE_SID in your environment or registry? Ivo S.Jyotinaray

9i install on Win2K

Hi ladies gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to install 9i on to. PC is as follows: P4 1.3 gig 256Mb RAM (Only a test box) 40 gig HD Win2K SP2

RE: Sqlloaderquetsion

I also could use this scripting. I am doing a somewhat complex DB conversion and this would be very helpful. Thanks much, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -Original Message- Sent: Monday, November 12, 2001 5:25 AM To:

RE: utl_file example

Title: RE: utl_file example Nirmal, do I have to set some OS acces rights? I get the following exception: ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.UTL_FILE", line 98ORA-06512: at "SYS.UTL_FILE", line 157ORA-06512: at line 4 If I handle the exception it turns

RE: OT_salary

Ah, the popular US misconception that the UK stops at London. :-)) The economy of the UK is extremely diverse and whereas the price of a meal or a pint varies little between London and Newcastle Quayside for example, the difference in the cost of property can be vast. The house I live in up in

executing unix commands from PL/SQL

is there anyway to do this other than external procedures or DBMS_PIPE? Like using java? Anyone got a very simple java example?(for someone unfamiliar with java in stored procedures) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL

Which OEM Agent version should I use?

I have installed version 2.2 of OEM which came on the 8.1.7 CD in the 9i boxed CD set. I am preparing to install the Oracle agents. I have 8.0.4, 8.1.5, 8.1.7.2, and 9.0.1 databases on Sun Solaris 2.6 that I'd like to monitor. Should I install the same agent version for all of them? If

RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O

IMHO, I believe it is because the recuriter's are trying to get the very best in potential candidates. Somewhat like that expression...If you aim high, but only get.., whatever that expression is. -Original Message- Sent: Saturday, November 10, 2001 12:15 PM To: Multiple recipients of

RE: executing unix commands from PL/SQL

John, Try the following link: http://asktom.oracle.com/pls/ask/f?p=4950:8:253629::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:952229840241,%7Bjava%7D Note: The url will probably wrap and you may need to copy the entire string. Also, if Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781

Oracle DBA with Peoplesoft Needed in Houston- Must Travel..

International Professional Services firm is looking for a Solid Oracle DBA with strong PeopleSoft Financials experience to be based in Houston, Texas. Extensive travel is required for this position. * Candidates outside the Greater Houston area MUST be willing to pay their own relocation

Re: Sockets and Pl/SQL

Maybe check out the UTL_TCP built in package hth connor --- ehsan sinavalda [EMAIL PROTECTED] wrote: Hello All I want to write a trigger for my oracle DB that can write to a socket when a new record is inserted in to a table, Could anyone please help me how can I call socket methods

Insert into ... as select ...

Hello everybody, I have a problem to find the correct syntax for the following operation: The first table: SQL describe grandeur_mesure; Name Null?Type - ID_GRANDEUR

Oh no

Apparently another plane has crashed in New York, a 767 has gone down in Queens according to news reports over here. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of

RE: OT_salary

Well, if u r in London, u wont feel the difference. I am in Nottingham in the Midlands and I can assure u that the cost of living here is low compared to the US. So is true for most of the other UK cities like Manchester, Sheffield, Glasgow etc... Secondly, since the public transport system is

Re: executing unix commands from PL/SQL

Note:109095.1 on Metalink explains how to use Java John Dunn wrote: is there anyway to do this other than external procedures or DBMS_PIPE? Like using java? Anyone got a very simple java example?(for someone unfamiliar with java in stored procedures) John -- Please see the official

Re: Oh no

It's an American Airlines A-300 Airbus, leaving JFK, bound for Santo Domingo, Dominican Republic. Robertson Lee - lerobe wrote: Apparently another plane has crashed in New York, a 767 has gone down in Queens according to news reports over here. -- Please see the official ORACLE-L FAQ:

Re: why shrink rollback segs?

Generally I try monitor v$filestat to see what proportion of IO is due to rollback...The ideal is of course nil, but to do so pretty much means giving everyone a couple of dozen 1555's every day :-) So you end up with the balancing act of trying to make them as small as possible without

RE: utl_file example

Just in case Do You have added correctly entries in utl_file_dir? If I remeber correctly there was a difference between Unix and NT. On one You need to put slash on the end, on another not. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

New flash

Just seen that another American Airlines plane has gone down in NY!! No evidence of Terrorist involvement as yet.. It was an Airbus that went down.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services--

Re: OT_salary

Hi, hmm, I've never been to the UK but always thought that the cost of living in the UK is higher comparing to the USA. It seems I was wrong. Not sure you consider Russia as a part of Europe... Just for your information The average salary for a med. DBA in Moscow is about 12K per year. Hey, any

RE: Data Warehouse Raid-5 Shark Environment

I've not worked with an IBM P660 but do have worked in datawarehouse environments with raid5. Raid5 will slow down your loads. The impact may be not too bad if you're in noarchivelog, using direct path inserts with nologging and loading on a monthly basis. -Original Message- Behalf Of

RE: OT_salary

I have been to the UK a lot... as far south as Sandwich and Dover and up the east coast to Woodbridge, Beccles etc... also been to Scotland as far north as Ulapool. I have also lived in the US for the last 6 or 7 years in various places upstate NY, Michigan, Rhode Island and Connecticut. I

RE: Slow connection time

Klaus, How about an tcpdump ??. I would investigate in those peak times because maybe an isolate traceroute or ping doesn't say anything. Regards. --- Zinsmeister, Klaus {PTBF~Basel} [EMAIL PROTECTED] wrote: Hi Christian, ping and traceroute are OK (1 hops) and it is not a DNS problem.

RE: Oh no

It was an Airbus A300 and apparently suffered engine failure. -Original Message-From: Robertson Lee - lerobe Sent: 12 November 2001 14:41To: ORACLE LIST (E-mail)Subject: Oh no Apparently another plane has crashed in New York, a 767 has gone down in Queens according to

RE: OT_salary

Title: RE: OT_salary I live in UK (Leeds) and frankly I would disagree with everything you have said (no offense intended!!). DBA salary differs depending on skill and location. I would have thought that mid-level DBA for non London/Scotland area is as you say £30-35K/annum. From contractor

RE: 9i install on Win2K

Thanks Charlie! Unfortunatley I don't have access to MegaW@*k, so can't check for anything like this. Do you know if the case is simply: You CANNOT install 9i on a P4 - at all.. say no more.. full stop..? Is the a way around or not? Cheers for your help Mark -Original Message- Sent:

RE: OT_salary

Public transportation system being good in UK? Hey, that's great news! When did the London Subway (a.k.a tube) start operating through the night instead of only until midnight? When did they increase the frequency of those night buses from Trafalgar Square? -Original Message- Sent:

RE: OT_salary

I do know there is more to the UK than London (and have visited more of it!) I merely meant that the last time I visited I was in London. And prices there were high --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: Ah, the popular US misconception that the UK stops at London. :-)) The

RE: Slow connection time

Did you turn off the oracle trace on the server? Sometimes, but just sometimes, the only way is to set EPC_DISABLED environment variable to TRUE in the oracle environment before you start up the database. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 8:25

RE: pfs_mount/umount

you have to pfs_umount it. Also, you have to ensure that you are not in that directory. -Original Message- Sent: Sunday, November 11, 2001 8:50 PM To: Multiple recipients of list ORACLE-L Hi, This is more of a Unix question. I am installing v8.1.7 on a HP-UX 11.0 machine. To mount

Re: Another Oracle DBA gets The Bullet in the UK - Seeking an Oracle

oh it's the whole company, not just me. I just got caught in the fallout --- Yosi Greenfield [EMAIL PROTECTED] wrote: Oh no - not you Rachel! Oy vey! Is nothing sacred? You'd think that all of us talented, intelligent, technologically savvy people with time on our hands could come up with

Re: OT_salary

Edward Shevtsov wrote: Hi, hmm, I've never been to the UK but always thought that the cost of living in the UK is higher comparing to the USA. It seems I was wrong. Not sure you consider Russia as a part of Europe... Just for your information The average salary for a med. DBA in Moscow is

RE: 9i install on Win2K

Mark, You can install on a P4, but you may have to do the workaround on metastink. Let me know if you don't have access to metastink cuz I can send you this work around. Dave (miss the OT list, hope to be back in a couple of weeks) -Original Message- Sent: Monday, November 12, 2001

RE: OT_salary

I was only playing with you - I give you more credit than that Rachel (I did put a smiley after my comment) Lee -Original Message- Sent: 12 November 2001 16:15 To: Multiple recipients of list ORACLE-L I do know there is more to the UK than London (and have visited more of it!) I

RE: OT_salary

I'm with our non UK colleagues here. The public transport in the UK is a pile of s**t. There how about that for being straight to the point. -Original Message- Sent: 12 November 2001 15:55 To: Multiple recipients of list ORACLE-L Public transportation system being good in UK? Hey,

RE: Sockets and Pl/SQL

Title: RE: Sockets and Pl/SQL Tom Kyte's book Expert One On One Oracle has a very informative chapter on using UTL_TCP. Well worth the $ for this chapter alone. We had a developer waste the company's time trying to create the same functionality using external procedures. HTH Tony Aponte

Re: how to find files that are generated on a particular date

ls -al |grep 'Nov 10' David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Tatireddy, Shrinivas

RE: initjvm.sql

Are you sure its hanging. Documents have said it can take up to an hour and its that statement that tends to take the longest. I have seen quite the variation in time depending on the system I am on. -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent:

RE: Which OEM Agent version should I use?

Use the 9i agent. Always use the highest they provide you as they tend to get a lot of bugs out per release. I have the 9i agents running against my 8i databases with no issues. I install them in their own home. -Original Message- Sent: Monday, November 12, 2001 6:00 AM To: Multiple

Logging on to SQLPLUS

I would like to know how I go about logging on as: SQLPLUS /nolog? Is this at the initial logon or after I have logged on at the command line? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ:

RE: 9i install on Win2K

Not sure if it's the same fix for 9i as 8i, but patch 1507768 seems to work for 8.1.7 - I'm running it as I type. If you've not got metalink, I'm not sure how Oracle expects you to use their fine product on just about any NT machine produced in the last year or so. The note doesn't mention 9i,

Re: Oracle the best

Hi, It is not running in MTS mode. Our DBA tried to configure the database for MTS mode. But he could not do it. Can anyone tell the steps to follow to configure Oracle for MTS? Regards, Prasad BAV. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: 9i install on Win2K

Dave, I don't have access (I'm only a sales critter, we don't get such niceties :P), so if you could get a copy of this I would REALLY appreciate it! Cheers Mark (miss your OT posts too! Don't be long! :) -Original Message- Dave Sent: 12 November 2001 16:21 To: Multiple recipients of

Re: New flash

Guys, would you please keep news flashes off the list? I've received such news flashes on a variety of mailing lists and I'm tired of it. Life isn't going to change if I wait to hear about it until tonight when I get home. Mark Leith wrote: Just seen that another American Airlines plane

RE: how to find files that are generated on a particular date

This will only work for the working directory - to _find_ files (regardless of loc), use the find command - for help - man find M -Original Message- [EMAIL PROTECTED] Sent: Monday, November 12, 2001 11:50 AM To: Multiple recipients of list ORACLE-L ls -al |grep 'Nov 10' David A.

Re: OT_salary

The average pay in the Denver area is $83K. I believe an average house is $250K or so. But I've seen Jr DBA jobs as low as $45K and senior jobs as high as $110K. Now to find one is another matter! Randy Kirkpatrick (303) 772-7467 - Original Message - To: Multiple recipients of

RE: OT_salary

I concur! Get your own car! lol -Original Message- Lee - lerobe Sent: 12 November 2001 16:31 To: Multiple recipients of list ORACLE-L I'm with our non UK colleagues here. The public transport in the UK is a pile of s**t. There how about that for being straight to the point.

Re: OT_salary

hmm, I've never been to the UK but always thought that the cost of living in the UK is higher comparing to the USA. It seems I was wrong. Not sure you consider Russia as a part of Europe... Just for your information The average salary for a med. DBA in Moscow is about 12K per year. Hey,

Poor dc_histogram_defs hit rate

I have a database w/ a library cache hit rate at ~99%, disk cache hit rate ~98%, but the dictionary cache hit rate is 82%. The biggest problem looks like dc_histogram_defs: NameCount UsageModifications Flushes Requests Misses Hit Ratio dc_histogram_defs 11,488

RE: Oracle the best

Prasad, See Jared's reply to your mail. Check V$session as Jared suggested. If you have questions after checking, then e-mail the problem. Rao -Original Message- Sent: Saturday, November 10, 2001 1:20 AM To: Multiple recipients of list ORACLE-L Hi Rao, No, it is not running in MTS

Re: Logging on to SQLPLUS

$ sqlplus /nolog connect / as sysdba startup || shutdown etc previous was brought to you by 9i the new way to shutdown/startup a database since svrmgrl is gone. joe --- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out:

RE: Another Oracle DBA gets The Bullet in the UK - Seeking an Oracle

Is Red Brick the same as Oxbridge? I thought it was the universities founded in the 50s and 60s, i.e. not one of those useless former Polytechnics, but not one of the elite (Oxbridge/Russell Group). I've seen a few job ads where it says Oxbridge degree and the job is HTML coder. Still, if the

RE: New flash

My appologies, I actually meant to send this message to the OT list. My mistake.. Mark (1st OT message to the list in AGES and he gets shot down :P) Leith -Original Message- Asher Sent: 12 November 2001 17:10 To: Multiple recipients of list ORACLE-L Guys, would you please keep news

RE: 9i install on Win2K

Mark, This is from a post on metastink. Let me know if this helps. If it doesn't I can do some more searching for you. I did a search using the error message you are getting. Dave RDBMS Version: 9iLite Operating System and Version: Windows 2000 Error Number (if applicable): Product (i.e.

RE: Another Oracle DBA gets The Bullet in the UK - Seeking an Oracle

Yes, it means Oxbridge and I agree with your observations re. the strategy. It's just so silly and short-termist. -Original Message- Sent: 12 November 2001 17:27 To: Multiple recipients of list ORACLE-L Oracle Is Red Brick the same as Oxbridge? I thought it was the universities

RE: Which OEM Agent version should I use?

Kimberly, Thanks for your reply. Cherie Kimberly Smith

Re[2]: Oracle the best

Sure, Add something like the following to your init.ora file. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 mts_service=03 mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=tcp)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=03))

RE: New flash

Don't let it happen again. ;-) -Original Message- Sent: Monday, November 12, 2001 12:46 PM To: Multiple recipients of list ORACLE-L My appologies, I actually meant to send this message to the OT list. My mistake.. Mark (1st OT message to the list in AGES and he gets shot down :P)

Deadlocks ORA-60

Occasionally we get ORA-60 in our alert log and it generates a trace file. Does anyone have a good method of interpreting the trace file and finding the root cause? RDBMS 8.1.6.2 thanks begin:vcard n:Vecchiet;Tony tel;fax:408.377.3153 tel;work:408.879.4771 x-mozilla-html:FALSE org:Xilinx, Inc

RE: New flash

Oh I won't - Don't want to let the list gods get angry! I may have to sacrifice Toto to them : Dorothy -Original Message- Sent: 12 November 2001 17:59 To: Multiple recipients of list ORACLE-L Don't let it happen again. ;-) -Original Message- Sent: Monday, November 12, 2001

Re: RE: Logging on to SQLPLUS

no password required, although you need a password file and have been granted sysdba role. check out the concept of password files and get one setup for your database. joe --- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out:

RE: Oh no

Yes, you are right, the news has been devastating here. Ramon E. Estevez [EMAIL PROTECTED] Santo Domingo Dominican Republic 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Dennis M. Heisler Enviado el: Monday, 12 November, 2001 10:10 AM

Re: executing unix commands from PL/SQL

Larry's link to asktom is where I got started however I made the mistake of telling the developers about this before I realized the implications and major security hole. This grants tissd privs to execute ksh scripts from within /gw/prodn/tissd/code/ksh/ begin dbms_java.grant_permission

RE: OT_salary

gotcha --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: I was only playing with you - I give you more credit than that Rachel (I did put a smiley after my comment) Lee -Original Message- Sent: 12 November 2001 16:15 To: Multiple recipients of list ORACLE-L I do know

SQL*Loader and NLS_DATE_FORMAT

Hi all: Does sqlloader read the NLS_ variables? For example, if I export NLS_DATE_FORMAT to -mm-dd, would sqlloader then accept the input file with all the data fields in that format if I use the variable format records? thanks = __ Do

How to identify processes that cause ORA-4030 errors

How does one identify the processes that will (likely) cause these errors? I am running 9i, 16G RAM, 700M SGA. Due to a bunch of these errors we had a system crash last week. So I want to put in a monitoring process that will identify the process, sql it is executing at that time. Other than

RE: RE: Logging on to SQLPLUS

Joe: Is this file created on the client or the server. I found the information on how to create it - PWDSID.ORA. Could you send me a sample, if you have it, because the documentation doesn't give me one. TIA, Ken -Original Message- Sent: Monday, November 12, 2001 12:21 PM To:

RE: Deadlocks ORA-60

Tony, I don't have them handy, but there are a few good notes on Metalink about Deadlocks, and some of them go into detail on how to read the deadlock graph, which is a good starting point for determining the cause. I also found some helpful info and comments at www.ixora.com.au (Steve Adams).

RE: executing unix commands from PL/SQL

Brian, And this really a problem that people run into with many of the methods for accessing the OS from within PL/SQL. Great care needs to be taken to ensure damage can't be done. Just like with UTL_FILE and someone simply setting the utl_file_dir parameter to * -- a developer could overwrite

OEM and Intelligent Agent Compatibility Error

I am trying to autodiscover a server in the OEM console in an 8.1.7.2 database on Sun Solaris 2.6. The databases on the other host are 8.0.4, 8.1.5, 8.1.7.2, and 9.0.1. I am using an 9.0.1 Intelligent Agent on the remote host where I want to monitor. When I try to autodiscover, I get the

latch wait

I have a puzzling problem: a session is apparently waiting on a cache buffers chains latch forever (well, for 40 minutes and counting, so far); seq# in v$session_wait is static. tries is 0. latch free address

Next extent problem

Hi. I have two tables in my database. They both have the NEXT_EXTENT set to 512K for a long time. Yet all the extents for these tables are either 16 or 24K. I have checked the next extent sessing once and again and it has always shown 512K. The tables are not being truncated. Why would Oracle

Login Scripts

Hey gang; Is there any way to get your login script to run whenever the connection is change instead of just when sqlplus starts up ?? I have a script that displays the instance name when I log in but when I do a connect after sqlplus is already started it does not change. I can manually

Reset SID

How do I go about resetting the SID for another DB? I can only find the command for RMAN which doesn't work at the SQLPLUS command line. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: OEM and Intelligent Agent Compatibility Error

This is from a tar I opened with Oracle: Kimberly, My name is Eddie and I will be assisting you with this tar. Oracle Server versions 8.0.5.x and earlier are officially dessupported, so no compatibility testing was performed on them. I would expect OEM 9i to work in the configuration that you

Re: How to identify processes that cause ORA-4030 errors

Rajendra The best advise for avoiding this would be to have thorough knowledge of your application SQL by performing detailed sql trace analysis and ensuring that statements are shared and use bind variables. The tkprof process is painfull but will help in long run .. its much better than a

Re: Oracle related docs/OCP materials

Boy, this was sure a disappointment. No white papers that I could find. The What's News section is listing the 9i beta test offerwhich expired nearly a month ago. The only thing there was the change to spend money on your 2 products. :( [EMAIL PROTECTED] 11/10/01 08:00AM Hi, We

How to import withoutduplrows

Hi How to eliminate duplicates rows at time of Import? Thanks Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema

RE: How to identify processes that cause ORA-4030 errors

Thanks ... I think I know which one is causing, but can't figure out why? Last time when system crashed, the box was shut down before the trace file was even written. So we didn't have any luck except the messages in alert log file. Well I'll lookup the info on metaslink. thanks again Raj

RE: latch wait

Try v$latch_children -Original Message- Sent: Monday, November 12, 2001 2:30 PM To: Multiple recipients of list ORACLE-L I have a puzzling problem: a session is apparently waiting on a cache buffers chains latch forever (well, for 40 minutes and counting, so far); seq# in

  1   2   >