Re: I/O EVENTS

So just looking at v$system_event is dangerous. Looking v$system_event and v$sysstat is much better but still not perfect. The third way is ... (mail me ;-)) Anjo, Jared has an even hand on the tiller. Go ahead an post an informative example of how the v$ views don't allow you to

Re: 9i r2

just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr [EMAIL PROTECTED] 05/20/02 22:17 PM Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with

Re: 9i r2

just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr [EMAIL PROTECTED] 05/20/02 22:17 PM Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with

RE: How to find current ORACLE_HOME programmatically

Hi you should be able to find it under: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Harold -Original Message- Sent: Tuesday, May 21, 2002 01:08 To: Multiple recipients of list ORACLE-L Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that

Re: TEST

you've been ignored, forever RAJESH DAYAL wrote: TESTING .. PLS IGNORE . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

patching 8.1.7

Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official

How to enable Java

Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist

ORA-2085

Hi all. I have recently had to enable global_names in order to set up a replicated environment. The application uses a database link to reconnect to the database under a differant user id (I inheirited this, I had nothing to do with the design!). Appearantly, global_names has a prblem with

Oracle on (Ssshhh NT)

All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear wehave a(nother !!)major client here who requires an Oracle/NT solution and

Re: How to enable Java

You can installed java with scripts. Check metalink note 156477.1 Use more space (10-20M more )than specified on the note for java_pool_size and shared_pool --- Joe LaCascio [EMAIL PROTECTED] a écrit : Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the

RE: 9i r2

I believe those check boxes are required by US export laws. Granted, it won't stop someone from those countries from downloading the software, but then I believe Oracle is not liable. And yes...seemingly pointless... -Original Message- Sent: Tuesday, May 21, 2002 1:23 AM To: Multiple

RE: What makes Export slow ?

Using a large buffer size allows more data to be written via export (a C Program) from the database to a file. The buffer specifies the size of each write to the database. Direct=Y was added in Oracle7 and allows export to bypass the SQL communication layer and write data from the database to

RE: patching 8.1.7

I have patched up to 8.1.7.3 (on Tru64) but there quite a few noises coming from this list to say that this release is buggy and therefore I should have stopped at 8.1.7.2. HTH Lee -Original Message- Sent: 21 May 2002 13:48 To: Multiple recipients of list ORACLE-L Good morning all,

RE: How to enable Java

Joe, Log on to your server, and change your directory to : ORACLE_HOME/JAVAVM/INSTALL Start up Sqlplus, connecting as SYS and run the INITJVM.SQL file. Be sure hat Java_Pool_Size = 52428800 is in your init.ora file. This takes about 20 minutes to complete. This will install the Java

Re: 9i r2

Hi, Were you able to untar and use the cpio command to extract the binaries successfully for Linux without any problems? Because, I was able to sucessfully download all the three files, but I was getting an error Unexpected end of file when using hte cpio command. Regards CP Markus Reger

Outstanding bugs in 8.1.7.2

I've been hunting around OTN and can't remember where to find this. I'd like to see a list of all outstanding bugs that are present in version 8.1.7.2 of EE. Is there one convenient place to find these or am I going to have to compile a list from multiple other versions. Thanks, Cherie

PLS-00553

Can anyone tell me what this PL/SQL error actually means? The manual says An unrecognised name appears in the character set specification John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: 9i r2

nothing stops anyone from lying... but it's CYA on Oracle's part, they ASKED --- [EMAIL PROTECTED] wrote: On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Yeah, I

Re: Export problem

[EMAIL PROTECTED] wrote: Hi! Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it should work. EXP-8: ORACLE error 942 encountered ORA-00942: Tabelle oder View nicht vorhanden EXP-00024: Export views not installed, please notify your DBA EXP-0: Export

RE: 9i r2

Pointless until someone sues Oracle for allowing those products to be freely downloaded to a restricted country. It's free software and you're being asked to click in 4 check boxes. It's a tough life. Mike -Original Message- Sent: 21 May 2002 15:03 To: Multiple recipients of list

Re: How to enable Java

Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run.

Re: patching 8.1.7

I just talked to OWS and they suggested to read the patch notes and if I need any of the fixes and if not, just install and don't patch until I have to. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 9:38 AM I have

RE: How to enable Java

Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account

RE: Oracle on (Ssshhh NT)

Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even 8i, don't ask !!!) Regards Lee -Original Message- Sent: 21 May 2002 15:23 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Oracle Press has two... Oracle9i for Windows(R) Handbook by Velpuri (should be good) and

Re: 9i r2

Have you had these bags under your control since you packed them? Has anyone unknown to you asked you to carry anything on this flight? ...same situation... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:03 AM I believe

Re: ORA-2085

I think that this is one of the few Oracle error messages where the suggested action truly represents the solution. Far more helpful than Contact your Oracle Representative... :-) This might be a long shot, however... SQL create synonym [EMAIL PROTECTED] for sys.dual; Synonym

RE: Oracle on (Ssshhh NT)

Do'h. Just shows how much notice/interest I have in the subject. I have just picked up my copy (apologies Gaja/Kirti) and went straight to the stuff you are talking about. Thanks to all for the help thus far. I will make more use of my existing library set before bothering you good people

Re: Oracle on (Ssshhh NT)

The question of Oracle and NT came up before. I had some papers (not mine) that I'd downloaded to my hard drive so I posted them where people could find them. This doesn't answer your question exactly and I'm not sure how useful the papers were to other people but they have been useful to me.

Restoring archivelogs through RMAN

In running RMAN and restoring a database, the necessary archivelogs are not restored. I found that they have to be restored separately, unless its something we are doing incorrectly. My question is, I have attempted to use the 'restore archivelog like 'PROD_1_2%' but it fails with RMAN-06004:

RE: How to enable Java

I don't have an account with metalink, and I can't get to this article on technet. Anyplace else to get this. Also, I'm trying to do this in 8.1.6. Thanks, Joe On Tue, 21 May 2002, Rodrigues, Bryan wrote: Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for

init.ora params for quick i/0

Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O

RE: ORA-2085

Yes, I inherited this, and I am setting up Multimaster Advanced Replication, setting global_names=false isn't an option. I have suggested moving the donotfiretrigger logic into the trigger, which has some initial support. For the moment, we are changing the code to point to a link with the same

Re: SHARED POOL SIZE

NO, THERE IS NO WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN (sic) THE DATABASE below 9i. Please don't use All-Caps. I remember the first time I used All-Caps on a NewsGroup about 7 or 8 years ago, I was roundly berated. Hemant K Chitale - Original Message - To: Multiple

How to populate many-to-many

I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate

RE: Oracle on (Ssshhh NT)

Oracle Performance Tuning 101 has NT and unix specific info in it. Most publications are geared to NT. I hate to say it but about the best one is in the FM. In the Oracle for NT docs is the Oracle Administrators Guide for NT. Waiting for your next recipe. :o) Dave -Original

RE: Statspack Problem

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, Bruce (CALBBAY) Sent: Monday, May 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack Problem Have you connected via BEQ or Net8 initially? Have you got

RE: How to enable Java

Thanks for the help folks. We are moving along with our IAS install now. It's funny, I've been using the command line with Oracle for so long, I didn't know that dbassist was even there. And once again, the GUI failed where good ole SQL prompt resolved the problem. Thanks, Joe -- Please

Re: Restoring archivelogs through RMAN

Here is the corrent syntax: restore archivelog from logseq until logseq thread 1; You have to specify from logseq ...unt8il logseq even if you only want to restore 1 logfile. An easier way would be: restore logfile all; This will get any archivelogs in the backupset. HTH, Ruth

ORA_ENCRYPT_LOGIN

Title: SQL Server to Oracle DB Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted? Thanks.

RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?

Yup, as I mentioned in the export... statement, it is. Looks like an iTAR... sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL

RE: Korn Shell Sqlplus

According to Oracle Support, in 8.1.6, this can cause processes and locks of the KILLed sessions to hang. And we've seen it. Even after 24 hours, the processes are still listed in V$SESSION, but they have no corresponding entry in V$PROCESS. At this point, the only fix is to bounce the

host from SQL prompt

Title: host from SQL prompt How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if

RE: Outstanding bugs in 8.1.7.2

A good start would be to get the list of fixes in the README of the 8.1.7.3 bundle for your platform, but I don't know of any comprehensive list. If you find one, let me know! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

Re: Oracle on (Ssshhh NT)

Lee, I am in the same boat...although I am going to be allowed to install 8.1.7 and use it for my own stuff. Our hired gums(consultants) won't let us more without permission. Take heart, ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday,

Re: host from SQL prompt

Are they telnetting in to your server and then running SQLPlus at the command prompt or are they running SQLPlus from their client and connecting via SQLNet? If the first, then host will not give them anything that they won't get from the telnet session. If the second, they they'll most likely

UPDATE Results

Title: UPDATE Results Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I

Re: ORA_ENCRYPT_LOGIN

[EMAIL PROTECTED] wrote: Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted? Thanks. seems like you could put a sniffer on it and watch the data flow by. -- -- Bill Shrek Thater ORACLE DBA

RE: How to populate many-to-many

Title: RE: How to populate many-to-many Dennis, M2M's are ugly but a fact of life. I've done what you have suggested. I suggest that you make the combination of server_id and software_id a unique constraint to keep out dupes. In Access drop down lists are called combo boxes. You can base

RE: host from SQL prompt

Title: host from SQL prompt Disable the command from the product profile by adding a row to table PRODUCT_PROFILE. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:

RE: UPDATE Results

Title: UPDATE Results using sql%rowcount innediately after update statement will give you that value. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: Outstanding bugs in 8.1.7.2

Is there anyway to download the readme file without downloading the whole product set for 8.1.7.3? Thanks, Cherie Jesse, Rich

RE: How to populate many-to-many

I would follow the exact approach that Forms gives you with drop down lists. You would then have the actual table fields filled in with background/hidden fields within the application. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248)

RE: host from SQL prompt

See the following link http://soi3.mmtel.ru/books/oracle8-how-to/chap1_11.html http://soi3.mmtel.ru/books/oracle8-how-to/chap1_11.html which gives some details on using product_user_profile. I'm assuming it'll be the same for higher versions. Iain Nicoll -Original Message- Sent:

PLS-908

Can't see anything on metalink regarding this error over a database link. We have an 8.1.6 database trying to execute a package on a 7.3.2.3 database and it's giving the following error. Any solution other than upgrade? ORA-04052: error occurred when looking up remote object

RE: UPDATE Results

Title: UPDATE Results Thank you. This worked great!! -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: UPDATE Results using sql%rowcount innediately after

complementary Conference passes

we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the

RE: UPDATE Results

Title: UPDATE Results If you are within a C-type program, the SQLCA contains a field that contains the number of rows updated. Look at the Application Developers Guide for more information. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248)

Re: ORA_ENCRYPT_LOGIN

I'm not using it, but you can look at the packets too and from the client by setting these lines in the clients sqlnet.ora: TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = some directory TRACE_FILE_CLIENT = some file The output is pretty huge, so you don't want to do this for more than a

RE: host from SQL prompt

Title: RE: host from SQL prompt I wish I could train them like monkeys, but no, it's an account for tech. support and they're ssh'ing into the production box, and I want to limit their access and give them no way to get to a command prompt, if I can avoid it. Would you believe that they were

RE: complementary Conference passes

Ops. Sorry list. -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith

RE: complementary Conference passes

I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email.

RE: host from SQL prompt --- LOL

The product profile is the way to go. Richard Huntley To: Multiple recipients

RE: Outstanding bugs in 8.1.7.2

I've dumped the Solaris one to: http://www.westbend.net/~legoman/readme_solaris_8173.html HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL

Free ODTUG2002 registrations

Chris, the info. is at: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith Date: Tue, 21 May 2002 10:29:45 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To:

OS patches required by Oracle

Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your

RE: Export problem

But why would you want to? If you export using the 7.3.3 database using the 7.3.3 export utility you should be able to import it into your 8.1.7 database using the 8.1.7 import utility. It's backward compatible. You just can't go the other way (import an 8.1.7 export to 7.3.3). Jay Miller

RE: OS patches required by Oracle

Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent:

Re: init.ora params for quick i/0

Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book,

Re: patching 8.1.7

Most of us on the list would probably recommend that you patch to 8.1.7.2.x, though you probably should check the patch readmes on MetaLink and check for RMAN bugs. Jared Ruth Gramolini [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 AM Please respond to ORACLE-L

Re: Data Warehouse experts, a simple question for you

Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

Re: Korn Shell Sqlplus

Stephane Faroult wrote: Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set

Re: I/O EVENTS

Go ahead an post an informative example of how the v$ views don't allow you to diagnose a specific problem, and how Precise products do. We wanna know, and I don't imagine he'll mind. Indeed I won't mind. Go ahead, tell us. :) Jared Greg Moore [EMAIL PROTECTED] Sent by: [EMAIL

Shared Pool Tuneup

Hi List, I have run some scripts for Tune up shared pool,here is the result of one script which i run : Script: SELECT name,sharable_mem FROM v$db_object_cache WHERE sharable_mem 1 AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR TYPE = 'FUNCTION' OR TYPE = 'PROCEDURE') AND KEPT = 'NO'

Re: Data Warehouse experts, a simple question for you

it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel ---

Monitoring Oracle License

How does one monitor oracle license, is v$license the only option? Is this useful in case of processor based license? Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here

DB Freeze

Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't

Re: Data Warehouse experts, a simple question for you

I second that emotion. the guy that wrote it is a PhD and owns Red Brick or something. totally knows what he is talking about. One of my top five books, best warehousing book by far I have ever read. /jack silvey --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4

Export 7.3.4 / Import 8.1.7

I need a full export of a 7.3.4 database that will be imported into a 8.1.7 database. I know there are several ways to do this. I would like to import as much as I can, (grants, users, etc...) in one pass if I can. Will an import full ignore=y work or will it complain about the different

Re:RE: OS patches required by Oracle

You be right!! Dick Goulet Reply Separator Author: Karniotis; Stephen [EMAIL PROTECTED] Date: 5/21/2002 11:22 AM Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect

Re: Data Warehouse experts, a simple question for you

I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel

ITL Deadlock Example?

Can someone post an example of how to trigger a deadlock (ORA-0060) due to ITL shortage? This is for informational/fact-finding purposes. I've created a test table with MAXTRANS=1 and can cause the enqueue waits between two sessions contending for the same block but I can't seem to cause a

Re: patching 8.1.7

BTW, looks like 8.1.7.4 has been released for most platforms. Just downloaded HP-UX and linux today. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats.

RE: Outstanding bugs in 8.1.7.2

Cherie, The majority of the documentation is available for download at http://docs.oracle.com click on database and then the version and OS you want. Ron ROR mô¿ôm [EMAIL PROTECTED] 05/21/02 02:39PM I've dumped the Solaris one to: http://www.westbend.net/~legoman/readme_solaris_8173.html

Re: UPDATE Results

Burton, Laura L. wrote: Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement,

RE: Shared Pool Tuneup

Hamid, what happens , if an object is getting executed once in a while but takes huge sharable memory, we may not be getting full use of pinning it in the shared pool, except wasting the memory, So we need to consider the number of executions also. if the number of executions are high for any

Re: Korn Shell Sqlplus

I must agree with Jared on this practice. By following this practice, you never bounce database to just get rid of hanging sessions holding locks as some listers are complaining about that they had to bounce database to get rid of hanging sessions becuase they killed process on database level

Re: host from SQL prompt

Richard Huntley wrote: How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if

ID This Wait stat

You know I could have all the documentation for Oracle printed on my brain, buy all the books ever written about the subject, but the primary wait problem that comes up will never be directly addressed. So, what exactly does 'Slave Wait' mean and what can I do about it? I am using DBWR

RE: Statspack Problem

I ran 'statscre' again and got the same message again. It seemed to prevent SQL*Plus from logging into any account. So, I quit, re-started SQL*Plus and logged in as Perfstat and ran the remaining two scripts, which then completed without incident. I have been able to take a couple snapshots

Re: Data Warehouse experts, a simple question for you

gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it

RE: DB Freeze

Raj: You can dump the SYSTEMSTATE/PROCESSSTATE using ORADEBUG dump and analyze the trace files. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Rajendra Sent: Tuesday, May 21, 2002 1:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database

RE: Export 7.3.4 / Import 8.1.7

Ron, I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3. I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints about different versions. Mark Stahlke DuhBA Denver Newspaper Agency -Original Message- From: Smith, Ron L.

RE: host from SQL prompt

Product profile has worked to stop this and others since version 6. It is very easy to create the table and add a row to disable certain types of commands. Don't you just love nosey users :) -Original Message- Sent: Tuesday, May 21, 2002 12:12 PM To: Multiple recipients of list

RE: How to enable Java

You don't need this article if in 8.1.6. Java installations and upgrades became a lot more complicated as of 8.1.7. Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I don't have an account with metalink, and I can't get to

RE: DB Freeze

One way is to do a system state dump level 10. It is done either as svrmgrl or as sqlplus with sysdba privileges. You would use the command alter sesssion set events 'immediate trace name systemstate level 10'; (if you do not have a large user dump file capacity you can alter your session to

RE: Export 7.3.4 / Import 8.1.7

Thanks! -Original Message- Sent: Tuesday, May 21, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Ron, I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3. I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints about different versions.

Tru64 Unix and Oracle

Hi all, I am new to the Tru64 flavor of Unix and would like to find out if there are kernal parameters that need to be set for Oracle (similar to the shm parameters on SUN)? Also, I would like to know if there are any other differences in terms of an Oracle installation on Tru64. TIA,

Appending date to export file name in NT

Hi Everyone, I can easily append the date to my export file names in unix. Can anyone tell me how to do on NT. An example would be great! I've had very little NT experience. Thanks for any help. Shirley :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Taylor,

RE: DB Freeze

Kevin, No it wasn't a problem with log_archive_dest or on-line redo logs, these locations have more than enough space allocated. As for redo, we weren't generating much, I mean there were only 2 baseball games going on at that time. We have managed 7 concurrent games and the DB doesn't even show

RE: ITL Deadlock Example?

SET PCTFREE=0 and fill the rows in that data block. Then update two DIFFERENT rows in that block from DIFFERENT sessions. You will get the required deadlock !! Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Tuesday, May 21, 2002 1:14 PM To: Multiple

  1   2   >