Stripe Width Setting

1) Gaja Wrote :- Systems that are Hybrid in nature and need to Support large data intensive Transfers , it is Recommended to Set this to at Least 1 MB (or even 4MB in some Cases) Qs Would there be any NEGATIVE Effect on OLTP operations in particular if the Stripe Width is OVER-Sized ? NOTE

Data Centers

Hi Friends : I work at the company that is looking for a Data Center. The needs is to put a product that run in internet, (E-procurement). If you know some internet address , please send to me. Nowadays the product is developed in Java/Oracle/Linux and i think that others options will be also

TOAD S/w

Any Docs , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: DIRECT PATH READ wait events

Based on the size and scatter of the direct path reads (which means I am making a couple of drastic assumptions) I think your path looks like an optimum 2-hash path, but the direct reads suggest that the hash_area_size is either too small to hold the hash table needed for table PRDPLVEE, or the

RE: System tables for generating the object privileges

Check sys.dba_objects , where Field OWNER = 'SYS' or 'SYSTEM' -Original Message- Sent: Wednesday, May 22, 2002 7:33 AM To: Multiple recipients of list ORACLE-L Hello All, I am trying to generate a script to grant privileges on the DB objects by extracting them from system tables. I

Changing Internal password

Dear Gurus... Pleasecan u suggest detail procedure of how to change the internal password ..os : Windows NT i tried to do with ORADIM utility..but i could not do it successfullylooking forward for the answer as soon as possible... Regards Chinna    Yahoo! Autos - everything you wanted

Re: ITL Deadlock Example?

It gets more complicated under Oracle 9 because initrans has a minimum value of 2 on tables; but under oracle 8, the following should work: create table t1 initrans 1 maxtrans 1 insert a few dozen rows into t1 so that there are rows in at least two blocks, and commit. session 1 update a

Re: Oracle 9i and Tables Owned by SYS

mcdonac@cust9 select * from v$version; BANNER Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production PL/SQL Release 9.0.1.3.0 - Production CORE9.0.1.2.0 Production TNS for Solaris: Version 9.0.1.3.0 - Production

Performance issue , OCI related ? - urgent , please

Dear gurus ! We are facing a severe performance problems here that i have no idea of how to address. There is a C++ program , which uses OCI , that does the following. It initiates a long running SQL select statement, and then fetches the result set from the DB in buffers of 5000 records. Now ,

Re: Changing Internal password

Hi Try ORAPWD file=file name password=password Jack Chinna Reddy Kunta

ORA-01595

ORA-01595 error freeing extent (string) of rollback segment (string)) I got this error when I tryed to shrink the rollback segment system, What can I do to solve this problem, optiman does'nt solve it. thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard,

Oracle and Delphi

Hi list, I am developing an application wherein Delphi is the Front-end and Oracle the Back-end. I wanted to know what all are needed to get connected to Oracle Database , i.e - settings,configuration etc.. Thanks and regards, Santosh

Re: calling a stored procedure from a sitescope monitor

Chris You wrote I just want to call it and get the one value it returns. I think that procedure does not return values, functions does. If you want to get value from a procedure you have to pass a parameter that the procedure will return the value in. Yechiel Adar Mehish - Original Message

Re: Changing Internal password

hi chinna.. use this -- alter user sys identified by urnewpasswd; was that not rocket science :) .. kidding .. late night humor Deepak --- Chinna Reddy Kunta [EMAIL PROTECTED] wrote: Dear Gurus... Please can u suggest detail procedure of how to change the internal password ..os :

Re: Oracle web application

Hi Aida, I've build a oracle monitor/admin website using PHP and Apache and Oracle repository.It's easy to implement/learn the basics. I had to find out about OCI and PHP because there was not much examples on that on the internet (obvious reason PHP=Free APACHE=Free Oracle= well uhh NOT

RE: Performance issue , OCI related ? - urgent , please

Dear gurus ! We are facing a severe performance problems here that i have no idea of how to address. There is a C++ program , which uses OCI , that does the following. It initiates a long running SQL select statement, and then fetches the result set from the DB in buffers of 5000 records. Now ,

Re: Performance issue , OCI related ? - urgent , please

Can you switch on SQL trace whilst this is running, or peek into v$sql. It sounds to me as if your code is fetching an array by re-opening the cursor, fetching and discarding all the rows up to the required point, and then returning the required rows. To answer your direct question - when

Re: Performance issue , OCI related ? - urgent , please

Do you keep the each batch of 5000 rows ? If yes, are you running out of memory ? Anjo. Andrey Bronfin wrote: Dear gurus ! We are facing a severe performance problems here that i have no idea of how to address. There is a C++ program , which uses OCI , that does the following. It

test

Title: test Testing .

RE: Data Warehouse experts, a simple question for you

Has anyone got that jokey review of a new wonder storage/retrieval format .book ? Simon Fox Room 308, CRH 0161 601 8723 -Original Message- Sent: 22 May 2002 03:58 To: Multiple recipients of list ORACLE-L Mladen, That IS what I do with the documentation CD. But Jack and I were

RE: test

Can I have a copy of three or so test result sets that you have compiled? ;P Thanks! Mark -Original Message- Sent: 22 May 2002 12:43 To: Multiple recipients of list ORACLE-L Testing . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: How to drop a datafile from a tablespace quickly

you wrote: there to claim his 42 virgins in Paradise? This is a common mistake. Read the following to know the truth: Humor . . . bin Laden's fate? After getting nailed by a Daisy Cutter, Osama made his way to the Pearly Gates. There, he is greeted by George Washington. How dare you attack

RE: Oracle on (Ssshhh NT)

From: Robertson Lee - lerobe [EMAIL PROTECTED] Date: Tue, 21 May 2002 15:42:19 +0100 Subject: RE: Oracle on (Ssshhh NT) Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even 8i, don't ask !!!) As you're stuck with Oracle 8 I'd recommend the following book which I believe

RE: test

very... -Original Message- Sent: 22 May 2002 12:43 To: Multiple recipients of list ORACLE-L Testing . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: I/O EVENTS

Cary, Thanks for this meaty example and especially for the analysis afterwards. Real-life examples like this are so much more revealing and insightful than any amount of theoretical discussion. We could learn so much if once a month someone would post the statistics and output from their

RE: oratab file

Stephane: Yes I have seen this type of operation. I helped manage a global services database environment for Oracle Financials where the databases needed to be started/stopped/etc. in that country's specific time zone. All startup files, log files, etc. had to recognize their zone. We

Import help

Hi DBAs, I have an export file from 8.0.5 that I want to import into 8.1.6 both on NT. The import says imported terminated successfully without warnings but I know nothing got imported. The preceding messages say the following Export file created by EXPORT:V08.00.05 import done in WE8ISO8859PI

Re: Statistical sampling and representative stats collection

Jack, What version are you on? Are you able to utilize the gather_stale option. That way you would not only be optimizing the amount you are estimating but the interval between analyzing. Of course, that option of DBMS_STATS is not available on older versions. Cherie Machler Oracle DBA

Re: ok one for you windows/oracle people out there

Nope. Sorry. I've never seen this message and we've moved on to Win2K. Joe Testa jtesta

9iR2 Install Problem

Hello! I am having a little difficulty with the 9iR2 install on a SUN Sparc (Solaris 8) box. The installer completes normally, but when I try to run anything java (e.g. dbca) I get the following message Could not locate Java runtime It looks to me that Oracle's provided jre did not get

Re: Oracle and Delphi

There are several ways to connect to the Oracle from Delphi. You can use ODBC and BDE, but i suppose you to usesome kind of component collections. For example Direct Oracle Access components can connect to the Oracle without BDE and ODBC. One obvious advantage is the speed. It uses tnsnames

Re: Statistical sampling and representative stats collection

Jack, Isn't the problem with this concept that it doesn't take into consideration how skewed the data is? Statistically significance would be relevant to perfectly distributed data but wouldn't you need a higher percentage of data for significance in more highly skewed data? Just something

RE: I/O EVENTS

Hi Cary, I also have a same problem but could not solve it yet I have two m/cs and with identical DB layout etc and running the same pro*C code under same data volume.The top waits are as follows. 1.oracle-8.0.5 ( 2 processor/RAM 512 MB) Total run time 45 mins Event

Re: 8.1.7.4

I thought that .3 was the final patch. I guess they found more stuff that needed fixing. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:58 PM Has anyone patched up to 8.1.7.4 yet??? Anything we should be aware

Re:oratab file

Babu, There already is a parameter in oratab to indicate whether or not you start/stop a database. Anything else in that vein would be highly custom for the site. I Know I use one to tell dbstart dbshut if there is a listener and/or name server that should be handled as part of the

RE: Oracle web application

Hi, Excuse my very bad english:-) can you be more explicit, is what you seek to better understand the utilization of function OCI, because if it is that I can you to send examples on what I have made, that will be able surely to help you. Therefore reply me rapidly:-) LYNDA HAOUHACH

RE: ORA-01595

Gilbert - The oerr utility says the key part is the accompanying message. Can you forward the accompanying messgage? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 4:58 AM To: Multiple recipients of list ORACLE-L ORA-01595 error

RE: TOAD S/w

Try www.quest.com, I believe this is the company's web site. Bryan -Original Message- Sent: Wednesday, May 22, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Any Docs , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET:

Re: System tables for generating the object privileges

I just spent 6 months doing, among other things, just this. DBA_TAB_PRIVS should probably be more accurately called DBA_OBJ_PRIVS as it has all objects' privs in it, now just tables. Here's an example. It produces spooled output that can be run to recreate the existing privs. SELECT 'GRANT

RE: Performance issue , OCI related ? - urgent , please

Thanks a lot Jonathan ! I TKPROFed these statements - nothing outstanding, it looks like the cursor is not getting closed eafter each fetch. Anyway , i would not expect the 100th fetch to take 100s times more time than the first one Also please note that the select contains 'group by' and

RE: ORA-01595

Do not take this as a gospel truth, but as far as I understand, there is no harm done and nothing needs to be done for this error - this is like the dog that catches his tail while he's chasing it yelp!. However, it's a good idea to check any trace file that gets generated, and/or look for any

RE: 9iR2 Install Problem

Check and see if the jre runtime libraries are in your path for the session. Otherwise, it will not dynamically find them. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com

EJB Support in Oracle 9iR2

Hi, Can anyone confirm if EJB support has been removed from Oracle Database Server Release 2 ? If so, can they point me to a metalink etc article. I am sure I read about this somewhere but can't find any reference to it. If this is correct, then Oracle revenue should go up as everyone buys

RE: ok one for you windows/oracle people out there

Correct me if I'm wrong (and I probably am) but isn't this the add a switch to the startup line in the boot.ini fix. From Tuning 101. Windows NT4.0 Enterprise Edition has a feature called 4Gb Ram Tuning (4GT). This feature makes it possible for applications to use up to 3Gb of memory space.

Re[2]: Inline View Query Versus Ordinary Query - Comparison

The biggest problem I've seen with inline view defs is that they most often force a resolution of that view into a temporary table which is then not indexed. Not a problem if the inline view has only a handful of rows, but when that inline view returns several thousand rows you can get into a

parametric Views

Can anyone of u tell me How to create parametric views?? thanx in advance.. Shishir Kumar Mishra

e: shared pool

Rafiq, I ran your query as we have been in the process of tuning our shared pool, and I have a question. When you see many more loads than executions for a given table, is it a safe bet that the application in question is executing queries that have that table in the from clause, but it is not

RE: Statistical sampling and representative stats collection

Jack, Nielsen Ratings (the TV Rating company) monitors about 5000 people (and their TV watching habits) to supply ratings for all the shows on most of the networks for the whole United States. So, as long as you have a working and proven statistical model, and a good sample, it works. How do I

RE: Performance issue , OCI related ? - urgent , please

Stephane , thanks a lot ! actualy , i do not think that this is the case , because it would take relatively much more time to construct the result set (my SQL contains massive 'group by' and 'order by' and therefore the whole result set needs to be constructed before returning even the 1st row),

Re: Oracle and Delphi

I am developing an application wherein Delphi is the Front-end and Oracle the Back-end. I wanted to know what all are needed to get connected to Oracle Database , i.e - settings,configuration etc.. Santosh I have had success with the Direct Oracle Access component set from AllRound

RE: patching 8.1.7

I just patched two instances on HP-UX 11 (64bit) to 8.1.7.4. We are running Oracle Apps as well. I'll let you know if we hit anything. (we patched to get rid of ORA-00600 errors and subsequent core dumps, on the advice from Oracle). -Original Message- From: Gogala, Mladen

RE: TOAD S/w

http://www.quest.com http://www.toadsoft.com http://www.egroups.com/list/toad Quest is the official site. Toadsoft is the original site of the freeware (which is still available!). The TOAD mailing list is run/monitored by Toadman Jim himself, as well as his wonderfully helpful staff.

Rename Column in 9iR2

Summary: it works! SQL SELECT * FROM v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE9.2.0.1.0 Production TNS for Solaris: Version 9.2.0.1.0 -

RE: Statistical sampling and representative stats collection

Jack, Raj I agree. The main point I feel is that if you follow statistics theory, which a good part of our modern technology relies on, you will test a fixed number of samples, rather than a percentage of the table rows. For a small table, you may have to sample the entire table

RE: Data Warehouse experts, a simple question for you

Try running: select 'IT DOES' from dual where 2 = '02'; I guess that SQLPlus is doing an implicit data conversion. Paula_Stankus

New Oracle 9.x Pre-Install Script from Oracle

Just saw this todayhavent tried it yet. Excerpt from MetaLink: News Notes New Script: Pre-Install script which checks your Unix environment to ensure successful installation of Oracle 9.x version of RDBMS The Data Server Support team is pleased to release a new

Re: Statistical sampling and representative stats collection

Cherie, Had some problems with DBMS_STATS, but we are making our way towards it. Just have to be careful, since it can do quirky things like analyze the dictionary. We are using dba_tab_modifications to monitor our tables. Thanks for the input. Jack --- [EMAIL PROTECTED] wrote: Jack,

RE: ok one for you windows/oracle people out there

I have had these periodically happen but have not yet fixed it. I'm reading the Oracle docs for NT memory management. Hope to have a solution soon. Dave -Original Message- Sent: Tuesday, May 21, 2002 4:24 PM To: Multiple recipients of list ORACLE-L Whenever more users logon to the

RE: ID This Wait stat

Now that's a truly useful site, someone could make that into one of those Pocket DBA books. ;- Thanks Lots... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 7:20 PM To: Multiple recipients of

RE: Statistical sampling and representative stats collection

I remember, in 96/97, I was working on a Oracle 7 database and none of the this sample() was available. My task was to select x people out of z number of people randomly. We hired a temp, who took Dallas/Fort Worth dictionary (I was working in that area) and counted (yes counted) number of people

Oracle Papers.

Hi All, I'd like to set up a technical papers section on the new iteration of the Cool-Tools web site, and was wondering if there were any authors of papers out there (such as Tim Cox's DBA Checklist, and Sean O'Neill's Oracle NT Config Guide) that wouldn't mind me putting a copy of their

RE: Oracle web application

Hi, I only needed basic functionality of the OCI calls and implemented that w/o much problems. The problem was that there are a zillion examples of PHP MySQL but not with OCI on the internet. If you have some good examples I will gladly have a look at them and file them for possible future use

oracle FTPserver

Good morning everyone, Please tell me the address for the Oracle FTP server. Thanks, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: Statistical sampling and representative stats collection

That is a very good question. Anyone else know the answer? My approach to skewness right now is to compare the mean and the median of the entire dataset, since if you have two measures of centrality that are not the same, you have skewness. /jack --- [EMAIL PROTECTED] wrote: Jack, Isn't

[Q] any problem ORACLE 9iR2 and RedHAt 7.3?

Have anyone tried ORACLE 9iR2 with RedHat7.3? Any problem? Thanks. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash

RE: shared pool

Sherman, I found the following SQL from Tim Gorman's site... this will create a file , which can be run to pin the objects, It Pins CURSORS as well as the other objects ( not the tables ). set tab off echo off feedback off timing off trimout on pause off set trimspool on pages 0 lines 500

OSUSER in V$SESSION capture in procedure?

Hello Listers, I have what I hope is challenging problem. I am trying to create a procedure that execs from a trigger on a table. Simple enough. But I want to capture the OSUSER value from v$session so that the there is a history of changes to the table and by whom. Problem with using USER

RE: ITL Deadlock Example?

Thanks for the replies (K,Jonathan,Anjo). I'm getting deadlocks to occur but they're not producing the deadlock graphs I was expecting to see. I'm looking to reproduce the scenario that will generate the following kind of deadlock graph--where it looks like a self-deadlock:

RE: ID This Wait stat

Pocket book??? I was thinking more like an encyclopedia...the extended edition... -Original Message- Sent: Wednesday, May 22, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Now that's a truly useful site, someone could make that into one of those Pocket DBA books. ;- Thanks

RE: oracle FTPserver

ftp://oracle-ftp.oracle.com/server/patchsets/ HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED]

Re: Oracle web application

Hi Lynda, Thank you for answering to me, I really appreciate it. Let me explain more clear the situation. I am a graduate student at Stephen F. Austin State University in computer science department. I will graduate next summer. As part of my graduation the department has assigned me the

9ir2 and rh 7.3

thats a configuration i hope to have tested this weekend. battling stupid dimensions and query-rewrite or would have done it already. joe

partitioning

Title: Message Hi all, Does anybody know with what version of Oracle partitioning was included at no extra cost? Thanks! - Jerry

Re: Statistical sampling and representative stats collection

Jack You are right keeping in mind your application and variation of data in different tables. I just mentioned 30% as most agreed percentage for estimate. I think Dennis gave you a more pracitcial answer yesterday. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list

RE: OSUSER in V$SESSION capture in procedure?

I, too, have a situation whereby all users access the db via third party app with single credentials - haven't found a way around it, other then application-side logging -bill -Original Message- Sent: Wednesday, May 22, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hello

RE: oracle FTPserver

ftp://oracle-ftp.oracle.com 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: Wednesday, May 22, 2002 12:04 PM To: Multiple

Re: oracle FTPserver

Thanks! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 12:43 PM ftp://oracle-ftp.oracle.com Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248)

patchset 8.1.7.3 or 8.1.7.4

Dear List, What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I download them? I looking on the FTP site and on Metalink but I couldn't tell which was which. Thanks, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET:

Re: ORA-2085

At last something that I have experience in. Just do the following: On the target database issue the following: Alter database rename global_name to donot_trigger; We had the same problem. This solves it. The global name has no other influence. Yechiel Adar Mehish - Original Message -

RE: Oracle 9i and Tables Owned by SYS

There is a difference in how privileges are handled in anonymous PL/SQL blocks vs. stored procedures, packages etc. I should have made it more clear that this was not from an anonymous block, but from a package. Ian -Original Message- Sent: Wednesday, May 22, 2002 2:38 AM To:

RE: How to find current ORACLE_HOME programmatically

Looks like no takers, except one whos great advice was to find it somewhere in the registry. Alex Hillman -Original Message- Hillman Sent: Monday, May 20, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Hi, guys. I need to find current value of ORACLE_HOME on the client from VB

Re: partitioning

Title: Message None It is an option (Means you pay). Yechiel AdarMehish - Original Message - From: Cunningham, Gerald To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 22, 2002 6:38 PM Subject: partitioning Hi all, Does anybody know with

Re: Rename Column in 9iR2

Kevin, Yes but does it work with data in the column?, I do not have 9i set up yet. If it works as you describe with data in the column it will really help with the multi million row tables that they want to rename a column after a release of a new lotto game. thanks, for the test and update.

RE: New Oracle 9.x Pre-Install Script from Oracle

On HP/UX at least, it doesn't work very well unless you've modified every kernel parameter stated in the install docs, even if the default is adequate. Only the modified values get put into /stand/system, which the script greps. Rich Jesse System/Database Administrator

RE: partitioning

Absolutely true! Even worse, it is an option on top of Enterprise Edition, so you can't license Standard Edition and buy the partitioning option. -Original Message- Sent: Wednesday, May 22, 2002 12:06 PM To: Multiple recipients of list ORACLE-L None It is an option (Means you pay).

RE: ORA_ENCRYPT_LOGIN

Title: SQL Server to Oracle DB That's exactly what I want to stop, passwords being sent in the clear. However, I'm not able to verify it's working so far. I've turned on tracing, as recommended in another reply on this topic, did a login before enabling then after enabling this parameter

Re: Rename Column in 9iR2

wish this had come about 20 years ago, as it would have saved us approx. 2 man years of dev. time (conservative estimate). Considering all 9i enhancements... this feature should weigh in at well over 25% Keith Date: Wed, 22 May 2002 06:38:37 -0800 To: Multiple recipients of list ORACLE-L

Re: parametric Views

Check out the SYS_CONTEXT package. hth connor --- Shishir Kumar Mishra [EMAIL PROTECTED] wrote: Can any one of u tell me How to create parametric views?? thanx in advance.. Shishir Kumar Mishra = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some

How to create Redo Log Members. Oracle8.1.7

Hi, I just wantedto create new online redo log members forexisting groups. Currently I have 3 online redo log groups. Each one contains only one member. Here is information about the online redo log of a database select group#, bytes, members from sys.v$log; GROUP# BYTES MEMBERS--

AW: OSUSER in V$SESSION capture in procedure?

Hi Eva, 1. If there is always the same osuser, why don't you use a default value. 2. Your proc couldn't work, because Select uid from dual; UID Gives you the USER_ID (number) from all_users. Then you compare OSUSER (char) with UID(number)? This should work: CREATE OR REPLACE PROCEDURE

RE: ORA-2085

Yechiel - If this does what I think it does, your value to postings ratio just soared! Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 11:49 AM To: Multiple recipients of list ORACLE-L At last something that I have experience in.

RE: 9iR2 Install Problem

Stephen: I can run Java programs I wrote using the installed jvm. Those from $ORACLE_HOME/bin appear to use the JVM that was installed with 9i. The dbca and downstream scripts appear to re-create the Java environment for you. Caver -Original Message- Sent: Wednesday, May 22, 2002 11:08

Re: oracle FTPserver

Depends on what you want to download... For downloading software, you have to go through http://otn.oracle.com... For downloading patches found on http://metalink.oracle.com, you can login via FTP to upgrades.oracle.com, using your MetaLink username/password to login (useful for downloading

RE: patchset 8.1.7.3 or 8.1.7.4

Ruth, What platform? For Sun Solaris ( which is what you have if memory serves ) 8173 is 2189751 8174 is 2376472 Regards, Mike Hately -Original Message- Sent: 22 May 2002 18:06 To: Multiple recipients of list ORACLE-L Dear List, What is the number of the patch for 8.1.7.3 or 8.1.7.4

dbms_stats issues on 8i

Hello fellow orabrains, Although Oracle has made it clear that DBMS_STATS is the future and that ANALYZE will be desupported, and it seems to work well in 9i, here are some things that I uncovered in my research of it during our initial stats process implementation (we were on 8.1.6 during this

PARALLEL SERVER

Hi I have one application which is running on Oracle 8.1.6.But most of time CPU idea is very low due to capacity peak.I am looking for either Oracle Parallel server or Oracle9i.Oracle Parallel server would distribute the load but question is. Is Oracle Parallel server is stable in rel 8.1.7 or

RE: How to create Redo Log Members. Oracle8.1.7

That should be fine. The name of the file is not important. I've seen log, rdo, dbf, redo and many others. The statement itself should be fine. Your log files seem to be the default size ( 500k ). It may be worth checking how often you're switching log files as you might want to make them larger

Re: oracle FTPserver

On Wed, May 22, 2002 at 09:14:49AM -0800, Tim Gorman wrote: For downloading patches found on http://metalink.oracle.com, you can login via FTP to upgrades.oracle.com, ftp upgrades.oracle.com upgrades.oracle.com: unknown host or invalid literal address

Re: oracle FTPserver

Thanks! I am downloading now...it is going to take awhile. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 1:14 PM Depends on what you want to download... For downloading software, you have to go through

Re: oracle FTPserver

Thanks! RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 12:48 PM ftp://oracle-ftp.oracle.com/server/patchsets/ HTH Mark === Mark Leith | T: +44

  1   2   >