32bit v. 64bit Oracle

Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to

RE: Histogram Helper

Hi Ian, Good catch, thanks. I've fixed it. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 13 April 2001 10:49 To: 'Steve Adams' I fetched the code off the IXORA website, and I believe it can give erroneo

sql queries issued to the database

How do we find all the queries that are issused against the database.Can we enable any log that will capture this information along with the user information who issued the query. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja I

Re: lock modes

Mark, The parameter ROW_LOCKING defaults to 'ALWAYS', and is considered the normal behavior of Oracle. I've never heard of anyone explicitly setting this parameter. Do you know of some situation where that would be needed? Jared On Thursday 12 April 2001 12:47, Mark Leith wrote: > In answer

Re: Subject: Oracle Reports Server?

Ckeckout the showjobs option. It will display all reports ran by a report server including other details like started and finished time etc. HTH, Manmohan. ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ --

Re: 9iAS -- Boxes on which to run

On 12 Apr 2001, at 16:30, [EMAIL PROTECTED] wrote: Date sent: Thu, 12 Apr 2001 16:30:24 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Currently running a Dev2k 2.1 web enabled application using 7.3.4 on an > HP-UX V2500 16 processor box wi

Re: 9iAS -- Boxes on which to run

Sorry to hear this Larry. At BlueCross we moved the server off of Intel ( Dual 500 MHZ, NT 4.0 ) because it was *so* much easier to support on Solaris. This sounds like a backwards move that probably cost more in the long run due to maintenance and downtime. Jared On Thursday 12 April 2001

Where do I find the patch script on the install CD ?

I just finished installing Oracle8.0.6 on a SUN SPARC ULTRA 5. The install cd is : Oracle8 Enterprise Edition Release 8.0.6.0.1 After the install I query v$version and I notice that I have version 8.0.6.0.0 Where do I find the patch on the CD (or the local Oracle Home Directory) to bring it from

9iAS -- Boxes on which to run

Listers, Currently running a Dev2k 2.1 web enabled application using 7.3.4 on an HP-UX V2500 16 processor box with the Forms servers and OAS 3.x running on 5 HP-UX "D" class machines and the Reports Server running on the V2500. Currently in the process of upgrading to 8.1.7, Developer 6i Release

RE: Database Cache of Oracle9ias

What's the problems you have ? --Kevin -Original Message- Sent: Thursday, April 12, 2001 3:55 PM To: Multiple recipients of list ORACLE-L Hi all, Has anybody installed Oracle Database Cache of Oracle 9iAS sucessfully.. Thanks in advance... Sushant --- TARUN SHARMA <[EMAIL PROTECTE

Database Cache of Oracle9ias

Hi all, Has anybody installed Oracle Database Cache of Oracle 9iAS sucessfully.. Thanks in advance... Sushant --- TARUN SHARMA <[EMAIL PROTECTED]> wrote: > Hi, > Yes u can install oracle 8i DB and 9iAS on the > same machine. > > > On Wed, 11 Apr 2001, Seema Singh wrote: > > > Hi DBAs > >

RE: Sseperate external procedure listeneers for 2 SIDS - Correcti

Once you create two separate listeners for each SID, you can start and stop each listener separately from command line lsnrctl start/stop -Original Message- Sent: Thursday, April 12, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Correcti But for each SID I need an external p

fyi: security issue with OAS 4.0.8.2

*** {01.15.025} Cross - Oracle OAS ndwfn4.so library buffer overflow The ndwfn4.so shared library shipped with Oracle's Application Server version 4.0.8.2 has been found to contain a remotely exploitable buffer overflow in the handling of long URL requests. The ndwfn4.so library is designed to plu

RE: How to get rid off file permanently?

Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile

RE: How to get rid off file permanently?

There is a page about algorithms for shooting yourself in a foot somewhere on the web (it can be found by starting at www.ugu.com) but you don't have to do it in public. Scientifically speaking, if you deleted a database file from the disk, your database is in so called foobar state and about the

Re: RMAN doubts

Is there any difference between these two? I saw the first one in one of the scripts and was wondering about until time 'sysdate-0' 1. run { allocate channel ch1 type 'SBT_TAPE'; backup archivelog until time 'sysdate-0' all; } 2. run { alloc

Re: RMAN doubts

The database 'may' be in NOARCHIVELOG mode 1. Its a 300 GB database and RMAN picks up only the USED blocks to might save time and disk space for disk backup 2. We back up directly to tape. So if done through RMAN, we need not keep inventory of tapes as RMAN/Legato would maintain it internall

WebDB 2.2 on linux 6.2 Oracle 8.1.6

List, Is there any gotchas that I shoould be aware of before I implement WebDB 2.2 on a linux 6.2 server running Oracle 8.1.6? It is a test server and I do not have the capability to backup the server. It is deployed with 128Meg ram and a 10 GIG drive. I only have 1 GIG free on the /data drive

Re:PL/SQL wrappers

John, Are you talking about creating a wrapper around your PL/SQL code or using the wrap utility to "encrypt" the code. I for one would use both methods for stuff I want hidden from the customer, but there aren't any real gotcha's that I know of with this approach. Dick Goulet

RE: Basic logon architecture for multiple apps in a db

Yosi, The user that logs in, is granted create session, and granted a role will use synonyms to access the tables they need. The users in this situation run an application that will use all of the tables in the instance. (70 GIG data approx 350 tables). The users do not need to or have the abil

RE: How to get rid off file permanently?

No, you simply cannot drop a datafile from the tablespace. You will need to drop the whole tablespace and rebuild it. Winnie "udaycb" <[EMAIL PROTECTED]>@fatcity.com on 04/12/2001 11:48:56 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of li

Re: Basic logon architecture for multiple apps in a db

Hi Yosi, You may want to check alter session set current_schema= This gives you the best of both worlds. You can let the users login using their own logins and still access the objects in the application schema without using synonyms. Regards, Denny [EMAIL PROTECTED] wrote: > > Ron, >

RE: lock modes

In answer to the original question: Exclusive: means that the table in question is locked by a user exclusively. This is usually used as shown below by Ep, to stop other users *modifying* the data within the table (they can still select). Row Exclusive: You can specify an init parameter ROW_LOCK

RE: How to get rid off file permanently?

I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain

Re: purged data??

Raghu, What exactly do you mean? Are you deleting rows and want to know how many you deleted? How many someone else deleted? 'Purged' is rather ambigous without some context. Jared PS. Please reply to the list, not just me. On Thursday 12 April 2001 06:45, Raghu Kota wrote: > Hi Friends

Table rows??

Hi Friends I calculated the size of Table and HWM. How can I caluculate each row in bytes and total rows in bytes?/ How can I calculate holes in it due deletetion of sum rows TIA Raghu. _ Get Your Private, Free E-mail

RE: How to get rid off file permanently?

You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '

RE: Sseperate external procedure listeneers for 2 SIDS - Correcti

But for each SID I need an external proedure listener that I can start seperately from the standard listener. John > -Original Message- > From: Terry Ball [SMTP:[EMAIL PROTECTED]] > Sent: 12 April 2001 19:21 > To: Multiple recipients of list ORACLE-L > Subject: Re: Sseperate exter

PL/SQL wrappers

We are considering using wrappers to hide our PL/SQL code from customers. Are there any issues to be aware of?..we need to implement on various Unix platforms. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network S

RE: How to get rid off file permanently?

Hi, Andrea , You HAVE to drop and create tablespace. Regards, Vadim Gorbounov Oracle dba -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter da

RE: How to get rid off file permanently?

try recreating the control file . -Original Message- Oracle Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users0

Re: Sseperate external procedure listeneers for 2 SIDS - Correction

We do that by creating a listener for each SID. So listener would look like: LISTENER_SID1 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1521) ) ) STARTUP_WAIT_TIME_LISTENER_SID1 = 0 CONNECT_TIMEOUT_LISTENER_SID1 = 0 TRA

RE: Temporary Tablespace Design

I think you missed analyze operation. It is for this command is 4x may be required. Also space for temporary tablespaces can be on very cheap disks. Alex Hillman -Original Message- Sent: Thursday, April 12, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Chris, First let me

Re: lock modes

Partial answer only: See below for a code example (something I use to irritate users if run during normal data enty times!). It shows how how to lock a table for "mass update" while running in SQL*plus (amazing enough, it was probably originally found in an Oracle manual). Regards, Eric --

RE: Temporary Tablespace Design

Hi Chris, The entire sort may not take place in the memory, but having more memory for sorting minimizes disk usage, which can lead to disk I/O, space mgmt issues and may hamper performance. If there is enough free memory available when building indexes, it is okay to use it, as much as possible

Very Urgent -- Please Help

Hi Everybody I need to know that how much time will be taken by Oracle Database Upgradation from 815 to [ 816 and 817 ] with Oracle 816 and 817 both Oracle s/w already installed on the system. I had two database running on 815 and planning to move one of them to Oracle 816 and second to 817 Dat

RE: Basic logon architecture for multiple apps in a db

Ron, When they log in directly, do they access the tables by fully qualifying the owner, or do they use synonyms? Yosi > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 12, 2001 12:23 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:

Re:RE: Re[2]: Basic logon architecture for multiple apps in

Yosi, Your second case is how I prefer things done. As to how the application handles resolving objects, that I leave up to the programmer. Both methods work although if you expect the end user to do his own adhoc queries it's better to have a synonym. Dick Goulet Repl

RE: Temporary Tablespace Design

Kirti: The server is solely used for the Oracle Database and it has 2GB Ram. I didn't increase sort_area_size too much because I thought the table is so big, and probablay I could not run them in the memory. That's why I just try the temp tablespace. Thanks, Chris --- "Deshpande, Kirti" <[E

Re[2]:Temporary Tablespace Design

Chris, Some of what your saying would lead me to look at the wait_io in a the sar output. You may want to talk with your SA as it sounds like you maybe IO bound. That being the case it does not matter how much temp space you have, your just sitting around waiting on the drive(s). Kirti

Re:lock modes

As a rule I do not recommend explicitly locking anything inside the database. Let the kernel handle the locking for you as in all circumstances that I've seen to date the programmer takes out a heavier lock than really needed. Dick Goulet Reply Separator

lock modes

Can anyone explain the lock modes written below.What do they mean . And how will I open the lock? Regards Exclusive  Row Excl.   None     Bunyamin K.Karadeniz    Database Group / Information Systems Department     HAVELSAN Ankara /TURKEY    Tel : +903122873565 / 1681    Mobile Tel : +

How to get rid off file permanently?

Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how

Sseperate external procedure listeneers for 2 SIDS - Correction

Correction I have 2 SIDS running on my machine. I want to have a seperate external procedure listener for each SID. Can someone tell me what my listener.ora amd tnsnames.ora files should look like? Oracle is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

JDBC Drivers

Hi, With Oracle's JDBC drivers, we have some problems. Has anyone had problems with getting ResultMetaData from the oracle thin drivers. Specifically, getting the table name from the meta data? Has anyone used third party JDBC drivers with Oracle? What are they? Any site from which it can be

seperate external procedure listeneers for 2 SIDS

I have 2 SIDS running on my machine. I want to have 2 seperate external procedure listeners for each SID. Can someone tell me what my listener.ora amd tnsnames.ora files should look like? Oracle is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn

RE: Re[2]: Basic logon architecture for multiple apps in a db

Dick, Thanks. So a user can have two different logons? Say, YOSI_OE for when I log on to the Order Entry Application and YOSI_STAT for when I use the Statistics app? Is this what you mean? Or, as I've been doing, just user YOSI, who's assigned both the OE_USER and the STATS_USER roles, but then

RE: Temporary Tablespace Design

I would suggest that you increase (as much as possible) sort_area_size and sort_area_retained_size for your session when building indexes to minimize temporary tablespace use. Making temporary tablepspace of type temporary and adjusting default initial & next extent size can also help. HTH.. - K

NT: RE: Re: How to get jobs under WinAT to run as Oracle

Here's an untested hunch. create the batch file that you want to run. create an NT service for the batch file. in the services applet, modify the properties for the service to run as a user belonging to the local group ORA_DBA. schedule the service to run. see if it succeeds or fails. hth, Paul

RE: Problem with database link

I've found that it is the global_name, not the db_domain, which gets appended to the dblink. You can check the global_name by select * from global_name I've had problems with dblinks if the global_name is not the same as the db_domain. In that case, describing over a dblink fails. HTH, Gary Ga

Re: Problem with database link

You could try setting GLOBAL_NAMES to FALSE in your init.ora file. By default, it's set to TRUE. Once I set mine to FALSE, I was able to create public database links easily. - Dana --- Michal Zaschke <[EMAIL PROTECTED]> wrote: > AFAIK, parameter DB_DOMAIN is what appends to the database link

Re: Basic logon architecture for multiple apps in a db

Yosi The users at our location do both methods of logons. Some access the database directly with "create session" privileges and have a role granted to them that can access the data. Other applications have the user login from the application access the database and the table privileges are gr

Re:RE: Temporary Tablespace Design

Steve, Thanks for reminding me of that one other operation that does also take up temp. Again, I think that depends on how often you calculate statistics & if your using partitioning. We do statistics once a week, and do it partition by partition so it does not take up that much. Dick Goul

Re:Temporary Tablespace Design

Thanks Dick and Lisa for answering my question. I think I am going to either let the file auto-extend, or will try a smaller file as a start. I found my temp tablespace is too small(1GB) because it seems like takes forever to rebuild an index with nologging. I have 11 indexes on this tables, and i

Re: Open for suggestions:Oracle & Unx Install

I assume you meant unixware, since Oracle 8 isn't available for OpenServer. At 11:20 PM 4/11/01 -0800, you wrote: >Viraj, > >Forget SCO. You don't have to install on SCO. Deploy 8.1.7 on a 2.2.18 >Kernel on glibc 2.1. >Ask Jared. >Spend some time on Metalink examining the product lifecycle for Or

Re:

My immediate guess, based on this message, is that your environment and/or oratab file isn't set up properly (ORACLE_HOME, ORACLE_SID) At 12:30 AM 4/11/01 -0800, you wrote: > >ORA-09860: Message 9860 not found; product=RDBMS; facility=ORA Dennis Taylor Stereoty

Re:Temporary Tablespace Design

Chris, First let me say that I have a TON of respect for Mike and count him as a friend. That said, I also take exception to many of his pronouncements from a practical, not theoretical, point of view. Given infinite resources, like disk space and memory and CPU, he does have it absolutely

Re:RE: index on table with 3 million rows ???

Humm, Looks like someone did not plan accordingly. Easy to do, I've done that a couple of dozen times. Here is a quick rule of thumb that I use. It is NOT absolute but I've not had a problem with running out of space in TEMP. The sql is: select round(sum(nvl(vsize(),1))/1048576)*2 from dual;

Re: Should each partition have it's own tablespace and datafile?

One tablespace per partition. If you're not sure of the final size of the partition, consider putting each tablespace file with autoexend ON and specify max filesize (MAXSIZE). For example: if partition extent size is 10M, the autoextend value could be 100M to have room for 10 more extents.

Re[2]: Basic logon architecture for multiple apps in a db

I prefer having multiple logons. There should be a generic, self explanatory schema that owns the objects followed by one of more roles that grants are made to followed by individual user accounts. That way it's easy to find out who's plugging up the drain every once in a while. Also if you nee

Outlines in 8i

Hi all, Does anyone of any good papers on Outlines in 8i? I am going through the manuals, but would like to know more. Usually papers present a more hands-on approach and real life examples ... Thanks in advance Raj __ Rajendra Jamadagni

RE: Background Process

Hi Raj, These are I/O slaves. You get them by setting 'dbwr_io_slaves' and possibly other similar parameters. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Thursday, 12 April 2001 21:52 To: Multiple recipients of

purged data??

Hi Friends How can I calculate How much data is purged from a table?? TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -

Re: Problem with database link

Did you look in TNSNAMES.ORA? >>> [EMAIL PROTECTED] 04/11/01 09:10PM >>> Hi there! I'm having a problem with database links here. I am on my SPEEDY database and want to create a link that points to another database called SAM. create database link SAM connect to user identified by pasword usin

Re: Temporary Tablespace Design

I'd be tempted to make it 4 times your largest expected working set, but how you arrive at that figure is beyond me... >>> [EMAIL PROTECTED] 04/12/01 04:05AM >>> What's your experience about the temporary table design? I read Michael Ault's Orcale8 Administartion and Management , it says "For Co

Re: index on table with 3 million rows ???

That's an awfully strange extent size (514k). Why don't you make it bigger, and make it divisible by your database block size? This would reduce wasted space. Also, do you really need all 8 columns indexed? If it's just for performance, you might be able to get away with using fewer columns

RE: Temporary Tablespace Design

Title: RE: Temporary Tablespace Design Hi Chris, Yes there may be 'rules' like this, but realistically who has 64GB to spend on disk space?  I have one huge table similar to what you describe.  My temp tablespace is 20GB only because I have the disk.  Maybe you can take the route of determi

RE: Should each partition have it's own tablespace and

You would have to decide what tablespace ends up being the target for the merged partitions. This is obviously a design change and needs to be dealt with accordingly. >>> [EMAIL PROTECTED] 04/12/01 07:46AM >>> A little off topic from the subject line - I admit I have not even tried to RTFM o

RE: Oracle tuning sampling duration

The frequency of when a script should be run depends entirely on what the script does.. For instance - You may have a script that looks for space bound objects within your database (can't throw their next extent), depending on the number of objects within your database, this could be a REAL KILLER

Background Process

DBAs I facing severe IO on the server. I got no clue why. I find three oracle background processes which I never heard of. They are ora_i101_orcl, ora_i102_orcl, ora_i201_orcl. Any idea what is this? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Go

RE: Should each partition have it's own tablespace and

A little off topic from the subject line - I admit I have not even tried to RTFM on this. If you have each partition of a table in a seperate TS, what would happen if you wanted to MERGE the partitions? Would Oracle merge the TS? I don't use them, and am not going to either:) Just curious.. Chee

Re: Problem with database link

AFAIK, parameter DB_DOMAIN is what appends to the database link name (which must be DB_NAME of your remote database). SQLWKS> show parameter db_domain NAME TYPEVALUE -- --- -- db_domain

RE: Should each partition have it's own tablespace and

It depends on the situation. In a previous project (Oracle 8), I've put each partition in its own tablespace. I was lucky that for each fact tables the partition were the same size. If you're partitionning by time, it eases data suppression (drop partition and drop tablespace). If you have too m

RE: RMAN doubts

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. CASE1 - I thought RMAN did not backup TE

RE: Problem with database link

First you must create public database link and after that you can create private database link which you assign to the user. HTH, Sonja -Original Message- Sent: Thursday, April 12, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi there! I'm having a problem with databa

Temporary Tablespace Design

What's your experience about the temporary table design? I read Michael Ault's Orcale8 Administartion and Management , it says "For Cost-based optimization, it should be 4 times of the largest table". I have a table of 60 Million records, and it costs 16GB, should I have a 64GB temp tablespace(I d

NT: Re: How to get jobs under WinAT to run as Oracle

Bill, This one is much easier on W2K than on NT. There exists a RunAs Service on W2K. Last time I checked on WinNT Server 4.0, I couldn't switch the authority of the Schedule service from LocalSystem to another user. But you may still be able to get a "connect / as sysdba" to work. In the WinNT

Re: XML SQL (XSU) Errors

Hi, first and all, I haven't used the Java/XML stuff for Oracle yet. But as far as I can tell, it looks like your either missing a file with message mappings or a path for the Aurora environment is not set correctly. SQL> @test_xml ORA-29532: Java call terminated by uncaught Java exception: jav