RE: database hanging during mount

bin laden : you are right about drink and cd but now a days they tell you to open a metalink tar. unless this is production. seriously : is nfs mounted volume supported. on nt it does not recognize non local drives. Mladen Gogala [EMAIL PROTECTED] wrote: Get a drink, put some nice CD in the

Re: possible Bug in Oracle 9.2.0.2

Can you please list select emplid, empl_rcd, effdt, effseq, empl_status from ps_job where emplid = '3442' At 03:34 PM 8/6/2003 -0800, you wrote: While I am waiting for oracle support to respond to my tar update (2nd callback) I am just wondering if anybody has found this problem. We have the

Re: Standby database ORA-16016

Hi! I think archive log gap management is a new feature in 9i Data Guard. Check 9i's docs. You might have to build custom scripts for gap management in 8i. Also, I recommend you to use documentation from authentic location, http://tahiti.oracle.com Tanel. - Original Message - To:

RE: drop user

Everything looks like a big hammer to you, doesn't it Stephen? ;) On Mon, 2003-08-04 at 17:54, Stephen Lee wrote: Much faster: SQL select file_name from dba_data_files where tablespace_name = 'SYSTEM'; SQL !rm file_name POOF!! User gone. Very fast. -Original Message-

RE: Opatch

Looks like PERL5LIB is not set in your environment. If perl is installed under /usr/local, the libraries are located in PERL5LIB=/usr/local/perl/lib/perl ver# Regards, Sten -Original Message- Sent: Monday, August 04, 2003 7:34 PM To: Multiple recipients of list ORACLE-L I'm trying to

Re: Implementing different document types with different attributes

Tim, Are you using 9i? If so create a parent_t object type with the common attributes. Create child object types UNDER parent_t. You can then define a table of type parent_t able to accept rows of all types. Cheers, John Thomas In message [EMAIL PROTECTED], Vernaillen Tim [EMAIL

Re: Corrupt Inactive RedoLog Goup.

Hi! I think the command was alter database clear unarchived logfile 'xxx'; IIRC, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 08, 2003 7:54 PM Members, Production 8.1.6.3 database on Windows NT 4.0. We noticed an

ODBC Problem with @ sign

Title: Message Is anyone aware of a problem with the 8.1.7 Client ODBC driver handling the '@' sign? Ron Smith

RE: It's an Oracle Fun Friday!

Title: RE: It's an Oracle Fun Friday! or Stephen - something even worse -Original Message- From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: It's an Oracle Fun Friday! Interesting web

Change based recovery

Hi Guys and Gals, We are currently doing some testing to enable us to move our production database from one unix box to another. We are running a 7.3.4 db in archivelog mode. The approach that management want to use is to restore the database on the new server from a backup and then roll

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

Mladen, But then again, shmget and shmat use malloc/calloc internally, it just differs in that shmget/shmat create the memory space and then make a public handle so that multiple processes can access the memory allocated. (Very simplisticly put) So in a certain sense it is more than just a similar

Re: RE: why does block cleanout incur redo?

Excerpts from one of my notes, collated from excellent papers or websites by Steve Adams, Jonathan Lewis, and KGopal. The first block of every rollback segment, also called the segment header, has a structure called the transaction table, which keeps track of all the active transactions in

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

To continue down the Stephen's path, shutdown abort will complete very quickly and will drastically decrease the size of SGA. What is more, the very busy environment Will not be very busy any more. Perhaps very loud, but not very busy. -- Mladen Gogala Oracle DBA -Original Message-

test message eom

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Implementing different document types with different attributes

Tim, As soon as I sent this I saw my mistake. There's got to be one more table. Doc_Types and Doc_Attributes stay, but Documents gets changed and Document_Attributes gets created. Actually, if you wanted you could make a single integer PK column for Doc_Type_Attributes and use that as the FK

RE: IMP-00020: long column too large for column buffer size (22)

What about that buffer setting in imp...?? DOn't you have to set that higher than default when importing data that has binary fields? The exp file might be okay. THis is the BUFFER input parameter to imp. Brad O -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07,

Re: Oracle and Windows 2000 SP4 - any experiences to share

FWIW, I installed it on my P4 at work and it's caused no problems yet. 8.1.7.4 as well. But in my Athlon XP at home, it's made the system so unstable I had to upgrade all sorts of drivers! There you go, 6 of 1... Hi! I've used SP4 on Athlon XP for a week now (with Oracle 9.2.0.1). So far

RE: Multiple Datafiles and performance?

1). I don't know. But I always try to create datafile with same size (2G) and it is easier to estimate how many datafiles I can fit into one disk. 2). If all datafiles are on 1 disk, then 4 1G datafiles vs 2 2G. should not make much difference. If you could spread 4 1G datafiles into 4 different

Re: 100 instances on same server !!!

Hi! Disk IO: Providing, that idle Oracle accesses all controlfiles every three seconds, then with 100 instances/databases, you'll have about 33 random IOs per second. Can your disks. If you got three controlfiles per database, then it means 100 IOs/sec, which gives 10ms per access,

Re: SharePlex

I could access oraclestore today and didn't see neither DataGuard nor Streams in database additions section (where RAC, Data Mining and others are). Then did a product search on dataguard, data guard, standby - got no positive results... But maybe the sales guys have other story... I've luckily

Comparison between Oracle 9i SE SqlServer 2000 SE

Hello fellow Oraclers, Has any of you done a comparison study on Oracle 9i SE Sql Server 2000 SE??? If yes, will it be possible for you to share your findings with me. In case any of you know of a web link that provides an unbiased comparison study that too would be wonderful if you could send

Re: Record breaking query

WOW! How many googolbytes do you have devoted to your Undo Tablespaces? Jamadagni, Rajendra wrote: TICK : Fri Aug 8 09:06:03 2003 SEARCH in kdisti: tsn = 5, objd = 83525, rdba = 33588489 ORA-01555 caused by SQL statement below (Query Duration=1060347963 sec, SCN: 0x0011.05e003c2): TICK

RE: [stupid] vi question

There's the :set list and :set nolist commands. But in your case, I think you got ahold of a MSDOS/Windows text file. -Original Message- Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official

Help with 9iAS on Linux 8

Hello List, Has anyone successfuly installed Oracle 9iASrelease 2 (9.0.2.1) on Linux 8 i.e. SLES8 (Suse Linux Enterprise Server 8) Can you please provide me with basic (initial) settings for the installation. Any help in this will be highly appreciated. Thanks in advance. Nikunj Add photos