Re: about analyse table..

on NT - C:\> notepad D:\Oracle\Ora81\RDBMS\ADMIN\dbmsutil.sql in notepad - find "procedure analyze_schema" sqlplus> exec dbms_utility.analyze_schema('pr0n_kewlecshun','COMPUTE'); hth. > Saurabh Sharma wrote: > > hello, > > i'm not very familiar with the analyse table command. and not fully

about analyse table..

hello,   i'm not very familiar with the analyse table command. and not fully aware of it's advantage or limits to analyse the tables. could anyone pls help me with this cmd, how to see the analysed statistics, etc. any help is highly appreciated.   thanks in advance.   saurabh sharma

RE: 8i - Seeing which columns disabled

Voss, my guess is that the SET UNUSED command will drop the column !! and you cannot get the column back... i tried to run the command on a table created by SYS SQL> alter table t set unused column t1; alter table t set unused column t1 * ERROR at line 1: ORA-12988: cannot drop column from tabl

Re: Which is faster??

You can try the Bulk insert feature of Oracle. It is available from Oracle 8i onwards. It really reduces time. -- On Thu, 22 Mar 2001 18:35:21 CC Harvest wrote: >I have the following scripts: > >insert into table >select * from table2 >; > >So if use the about bulk statement in my >applicat

test please ignore

 

Which is faster??

I have the following scripts: insert into table select * from table2 ; So if use the about bulk statement in my application, and the table2 is big, say 10 million records, my concern is that it's going to fail because of the possible rollback segments failure. So then I have to use PL/SQL to c

RE: Tuning Matter ==> Parameter PCT_USED in a Table

Hi Bambang, Analyze the table and you'll find the average row length in USER_TABLES.AVG_ROW_LEN. Subtract 90 bytes from the block size before expressing that as a percentage and round it up. Also, the formula should be PCT_USED = 100 - (PCT_FREE + 1 row). There are scripts on the Ixora web site t

Re: imp

Hi Joseph , As far as I know when we import/export DB , there is something called "parameter conflict consideration" or something like that . parameter SHOW = Y will tell to Oracle that we want the List of syntax ONLY. the other parameter , FULL , will tell to Oracle that we want the records

Tuning Matter ==> Parameter PCT_USED in a Table

Dear Listers, I've download a presentation talking about Calculating PCT_USED . the formula is quite simple : PCT_USED + PCT_FREE < 100 PCT_USED = PCT_FREE + 1 row size but I have no idea to calculate the size of 1 row in a table . is there anyone who knows to calculate it ? or any alternativ

RE: Why is there [GIANT COW F*RTS IN THE] air?

Don't forget that some recent research supposedly indicates that bovine flatulence is a significant contributor to some major components of atmosphereic pollution. regards, ep (former ranch hand & factotum) On 22 Mar 2001, at 16:15, Jacques Kilchoer scribbled with alacrity and cogency: Date sen

RE: Move "LOBINDEX" etc from "DATA" tablespace to "SYSTEM" tables

Title: RE: Move "LOBINDEX" etc from "DATA" tablespace to "SYSTEM" tablespace? see answer below > -Original Message- > From: Guang Mei [mailto:[EMAIL PROTECTED]] > > System: Sun Solaris 2.7 > Oracle : 8.1.6 Enterprise Edition > > I just installed the oracle server software and creat

RE: email Problem in WINDOWS 2000 Server -off Topic

A great Win-NT/Win-2000 self-service support site: http://www.ultratech-llc.com/Personal/Files/?File=!Contents.TXT also: ---excerpt--- Date sent: Thu, 22 Mar 2001 16:44:34 -0500 Send reply to: Windows NT/2000 Discussion List <[EMAIL PROTECTED]> To:

do you use SQLJ ?

Dear List, I haven't really seen a question on this list regarding SQLJ, and it makes me wonder how many people on this list actually use SQLJ. A DBA friend of mine told me that eventually SQLJ will replace PL/SQL in preference, and I wanted to know the truth regarding his statement - so who bet

RE: DBMS_REPAIR package usage

I do run the dbv against a down database. The same result happened. If FTP, copy are all okey, it means that the block is not a media corrupted block. It does not stop it from being a software corrupted block. If exp works fine, it only tells us that there is currently no data/object in that "co

RE: Single Code Table or Separate Code tables dilemma

at last i convinced my duhvelopers to go for individual tables. > -Original Message- > From: Steve Orr [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 22, 2001 5:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Single Code Table or Separate Code tables dilemma > > > R

RE: Why is there air?

If there wasn't, we'd all explode like someone jettisoned into space for cheap thrills in the sci-fi movie of your choice. Also, the oceans would vaporize. This means the fish would be in for a pretty bad day as well, and there would be no water to clean up the mess made by the 6 billion explodi

Move "LOBINDEX" etc from "DATA" tablespace to "SYSTEM" tablespace?

System: Sun Solaris 2.7 Oracle : 8.1.6 Enterprise Edition I just installed the oracle server software and created an instance manually. Everything seems to be fine except there is one problem. The problem is that there are some objects owned by user "SYSTEM" end up in tablespace "DATA" (see t

RE: DBMS_REPAIR package usage

since does not change datablock u can run it against online datafiles. but it would report blocks as corrupted which are being changed. offline or shutdown is the best way. if u cant bring it down, try running analyze table validate structure cascade -Mandar > -Original Message- > From:

RE: Why is there air?

Title: RE: Why is there air? > -Original Message- > From: Maser, Donna (SEA) [mailto:[EMAIL PROTECTED]] > >   I am still waiting/hoping for an answer... >   Why IS there air? The solar nebula which formed the solar system was composed of a gas cloud rich in volatiles (aka primordia

RE: Why is there air?

To burn up Mir so it doesn't bonk us on the head... Oops, need more air... Where's my hardhat? -Original Message- Donna (SEA) Sent: Thursday, March 22, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Jared, I am still waiting/hoping for an answer... Why IS there air? - Donna

[Fwd: RE: Log writer] - that box holds 6 internal drives + cd

Hi. I would have like to have jumped in on this earlier. Kevin - do you have a RAIDPort card in there, or is it just the onboard U2W SCSI controller? Dell 410 Precision? That's Dev, Test, and lots of workstations around here, and my box at home. Those have a nice removable cage that hold 4 DRIVE

RE: Single Code Table or Separate Code tables dilemma

Preface: I am a developer! If the DBA wants to have 1 tables, no skin off my nose. A generic maintenance form and LOV form for a set of tables all with the same format is not that huge a task. The best developer argument AGAINST a centralized code table is that eventually someone will reque

Re: Why is there air?

On Thu, 22 Mar 2001 [EMAIL PROTECTED] wrote: > Maybe I wasn't clear? And I've always considered > my articulate. :) ^^ Guess my assumption was incorrect. :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City N

RE: Why is there air?

Jared, I am still waiting/hoping for an answer... Why IS there air? - Donna -Original Message- Sent: Thursday, March 22, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Hmmm I thought my post said that I was in no way trying to discourage off-topic posts. Maybe I wasn

RE: Max phy I/O size on Hp-UX

Hi Prasad, A new tuneable scsi_maxphys was introduced in patch PHKL_13552 in response to SR 4701376087. The patch notes say ... This value was previously fixed at 1MB (1048576). On V-Class systems, this value can be set as high as 32MB (33554432) for large raw SCSI

RE: Oracle Warehouse Builder (OWB)

check out DataJunction also. > -Original Message- > From: Majumdar, Uttam [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 22, 2001 4:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Warehouse Builder (OWB) > > > OWB is relatively new in the ETL market. We did us

Re: DBMS_REPAIR package usage

I would not decide whether a block is corrupted or not, just using dbv utility. dbv reports corruption, even when analyze, exp and FTS goes through fine without any problem. dbv reported a data dictionary corruption in our case. We ran analyze, exp and FTS, no problem. But still dbv was reporting

RE: Single Code Table or Separate Code tables dilemma

> -Original Message- > From: Michael Netrusov [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 22, 2001 4:23 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Single Code Table or Separate Code tables dilemma > > > > > > > Referential integrity is still present if you cre

Re: Max phy I/O size on Hp-UX

As per the HP docs, MAXPHYS can be >= (64K or 256K) and HP silently enforces it. ( Note the >= ). It could depend on whether the hardware supports it. We are using V-Class servers and here is a reference to it in one of the header files. scsi_ctl.h - /* ** Size of SCSI Passthrough I/O

RE: Oracle Warehouse Builder (OWB)

OWB is relatively new in the ETL market. We did use OWB, ACTAWORKS and INFORMATICA in our enterprise. We are sticking with INFORMATICA because of its flexibility to integrate data from different oracle/non-oracle databases and ERPs. regards: Uttam Majumdar -Original Message- Sent: Thur

RE: OLAP info

go to www.olapreport.com for more info. Regards; Uttam Majumdar -Original Message- Sent: Thursday, March 22, 2001 4:11 PM To: Multiple recipients of list ORACLE-L BusinessObjects and MicroStrategy are the top OLAP tools. -Daniel -Original Message- Iwaniec Sent: Thursday, Mar

Re: Single Code Table or Separate Code tables dilemma

> > Referential integrity is still present if you create Master lookup table > > with type attribute > This requires a "composite referential integrity constraint" such as: > alter table tname > add constraint fk_whatever > foreign key (extra_column_for_code_table_key, >

imp

I've exported the entire database and while using the interactive imp (import), would also like to get a listing. Is this possible? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: dbms_obfuscation package

Try this link... http://www.oradba.freeserve.co.uk/tips/des_hint.htm hth connor --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > help! I am by no means the world's best PL/SQL > programmer (heck, I can > barely program in it, PL/SQL 101 is on my desk at > home) > > I am trying to see how h

RE: Migration from 7.3.4 to 8.1.6

Dan: What kinds of problems ? I am beginning a migration of a hybrid OLTP / OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6 We are planning to take 6 weeks to "clean up" the database and fix the chained /migrated rows before we migrate (mainly on the big tables). We will spend a month tes

DBMS_REPAIR package usage

To all, I have a datafile in my production box (a user data tablespace), when I run dbv against it, it showed that 5 blocks are "influxed" Page 458784 is influx - most likely media corrupt *** Corrupt block relative dba: 0x24070020 file=0. blocknum=458784. Fractured block found during dbv: Dat

Using HS

Hi, Back from vacation and trying to make HS work between Oracle 816/Solaris and MS SQl Server 6.5 or Oracle 817/Solaris MS SQl Server 6.5. The ODBC driver is Merant 360. On 816 I'm having : ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Transparent gateway f

RE: email Problem in WINDOWS 2000 Server -off Topic

Title: email Problem in WINDOWS 2000 Server -off Topic Yeah, that's probably a true statement.  I wish I could say it was that easy to find answers to problems with Oracle.  It's not like I can just log in to Metalink and find what I need.  I consider it a good day if I can get it to load jus

Re: Inserting data from long table into wide table

Thanks Regina. It works! Erma >From: Regina Harter <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Inserting data from long table into wide table >Date: Thu, 22 Mar 2001 11:56:30 -0800 > >I believe a decode and group by w

RE: Log writer

Title: RE: Log writer buffer size > redo log size.     That in itself is painful. -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, March 22, 2001 3:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Log writer So was it that th

RE: OLAP info

BusinessObjects and MicroStrategy are the top OLAP tools. -Daniel -Original Message- Iwaniec Sent: Thursday, March 22, 2001 2:52 PM To: Multiple recipients of list ORACLE-L Hi all I would like to learn about OLAP in Oracle. I have looked at OTN and found Express Objects and other Exp

Re:

Oracle docs at technet.oracle.com joe >From: "Chesebro, Eric" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: Thu, 22 Mar 2001 12:10:28 -0800 >MIME-Version: 1.0 >Received: from localhost (localhost [127.0.0.1])by parents.the

Migration from 7.3.4 to 8.1.6

We just migrated the first of our environments from 7.3.4 to 8.1.6 ( Solaris 2.6 ). We have run into a couple of problems that only seem to appear when processing large tables or large amounts of data. This is kind of what we expected because we did not have the resources to do full-blown

RE: Log writer

I should have explained more, sorry about that. These are actually only two drives, F and G are actually the same hard disk, just logical partitions because some bone head thought it would be better to buy one 36 gig scsi as opposed to two 18 gig scsi's, and no it wasn't me. -Original Messag

Max phy I/O size on Hp-UX

This question regarding max physical I/O size for hp-ux v11. When we were talking to unix sys admin, she searched in HP knowledge base and found that 256k is the maximum physical I/O for hp-ux. When I was looking at Q&A on Steve Adams's web site, the answer is 1M for max physical i/o size for

Re:

"Oracle 8i Utilities" Witold On 22 Mar 2001, at 12:10, Chesebro, Eric wrote: > Any one know where to find good documentation on sqlloader? > > Thanks, > Eric > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chesebro, Eric > INET: [EMAIL PROTECTED] > > Fa

Oracle Warehouse Builder (OWB)

Hi, Have installed OWB 2.1 on NT workstation(128 MB RAM) and is connected to a small database (8.1.6) with 35MB SGA. There is no other activity going on against this database. OWB takes a long time to come up and is very slow afterwards. Is anyone using this tool and if so what is the configurat

Re: Using HS

Looks like you did not setup the DSN name correctly. Merant cannot find the DSN name that HS passed to it. Look at their ODBCINI file to verify that the DSN appears there. I would suggest, however, that you get the enterprise gateway to SQL server. Performance will be better too... I hope you had

RE:

Start with "Oracle8 Server Utilities" that comes with the Oracle Documentation Set. You may be able to find it at http:\\docs.oracle.com. Michael Armstead Database Administrator, OCP-Certified Corporate & Finance Information Systems Glaxo SmithKline > -Original Message- > From:

Re: DNS vs. Oracle Names vs. tnsnames.ora

I see Oracle heading towards LDAP. >>> [EMAIL PROTECTED] 03/22/01 03:26PM >>> Can anyone shed some light on this? I heard that Oracle is going toward a DNS solution and going away from tnsnames.ora and the Oracle Naming Service. Is this true? We are looking to place a naming solution in our env

RE: Single Code Table or Separate Code tables dilemma

> Referential integrity is still present if you create Master lookup table > with type attribute This requires a "composite referential integrity constraint" such as: alter table tname add constraint fk_whatever foreign key (extra_column_for_code_table_key, c

RE:

This'll give you a running start, Eric: http://www.smckearney.com/oracle/sqlloader.php -Original Message- Sent: Thursday, March 22, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Any one know where to find good documentation on sqlloader? Thanks, Eric -- Please see the offici

DNS vs. Oracle Names vs. tnsnames.ora

Can anyone shed some light on this? I heard that Oracle is going toward a DNS solution and going away from tnsnames.ora and the Oracle Naming Service. Is this true? We are looking to place a naming solution in our environment and I want to know which direction to head in. Also, if possible, I wo

RE: Log writer

Title: RE: Log writer So was it that the buffer was too big and the log files themeselves were too big for the disk to handle? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Thursday, March 22, 2001 11:02 AMTo: Multiple recipi

Re: Sql Loader documentation

Eric, O'Reilly has a good book out soon. http://www.oreilly.com/catalog/orsqlloader/index.html I reviewed the book and found a lot of great information. I really liked the chapter on tuning. I put a couple of the things I found there into place on some regular jobs that I have and saw som

RE: Log writer

I agree that the log buffer is too big. But why do you want to decrease the log file size from 32M to 5MB. This will increase the checkpoint frequency and will create performance hit due to increased checkpoints. Also, I would add log files to use all three disks rather than just 2 disks.

No Subject

Any one know where to find good documentation on sqlloader? Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Inserting data from long table into wide table

Title: RE: Inserting data from long table into wide table see answer below > -Original Message- > From: Erma Fernando [mailto:[EMAIL PROTECTED]] > > I have a table A with the following data  (Table A has 3 > columns id, name, > value) > > id name  value > 10  P1  

Re: Why is there air?

Hmmm I thought my post said that I was in no way trying to discourage off-topic posts. Maybe I wasn't clear? And I've always considered my articulate. :) Oh well. I was not trying to put a stop to off topic posts, I was merely reminding everyone that this forum is a valuable troublesho

OLAP info

Hi all I would like to learn about OLAP in Oracle. I have looked at OTN and found Express Objects and other Express ... tools. Is it a place to start or someone can recommend something better Thanks Witold == Witold Iwaniec Senior Software Developer Nov

Re: Inserting data from long table into wide table

I believe a decode and group by would work well for you, something like: insert into tableb select id, sum(decode(name,'P1',value,0)), sum(decode(name,'P2',value,0)), ... from tablea group by id; At 11:19 AM 3/22/01 -0800, you wrote: >I have a table A with the following data (Table A has 3 colu

RE: Log writer

Oh so then I did do it right. -Original Message- Bricker Sent: Thursday, March 22, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Kevin, Oracle recommends placing the different members of each group on different disks. This will allow the instance to keep running if you lose

RE: But all is not gloom and doom for Oracle...

Good points. The only thing I know about (as a non-expert) that might be worth adding is that that there are some people in the "legitimate" investment sector that supposedly ran some extremely unethical (and large scale) "pump-and-dump" type operations (short sales, and so forth) on high-te

RE: Log writer

Title: RE: Log writer Uh.67,676 kb. ?   as in   67 MB?  for a redo log buffer?  Is this a result of our new president being a texan?   On your system,   1) one by one add three (3) new groups of redo log files. Make them 5MB in size, each.    2) ALTER system switch logfile until all t

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

BCV = Business Continuation Volume Geez, this was obviously the work of some marketing drone so it would sound impressive to clueless clients. I know the concept, but have never heard it called by his acronym. Thanks all fro the explanations. Jared On Thu, 22 Mar 2001, Tim Sawmiller wrote:

Re: Somewhat OT: Db2 Vs Oracle

listed is an interesting quote from the "DB2 Magazine Email Newsletter: Volume 2, Issue 3" "DB2 TCO: Two studies weigh in on total cost of ownership Two independent surveys, one by research company D.H. Brown Associates and another by consulting company Yevich Lawson & Associates, evaluated I

Inserting data from long table into wide table

I have a table A with the following data (Table A has 3 columns id, name, value) id name value 10 P1 20 10 P2 60 10 P3 12.5 10 P4 26 20 P1 100 20 P2 90 20 P3 15 20 P4

RE: report.txt

Use www.oraperf.com Alex Hillman -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Subject:report.txt A

Re: Log writer

Kevin, Oracle recommends placing the different members of each group on different disks. This will allow the instance to keep running if you lose a disk. If all members are on one disk and you lose the disk you have lost all of the redo for that group. Don Bricker Information Systems Anal

Re: Single Code Table or Separate Code tables dilemma

Referential integrity is still present if you create Master lookup table with type attribute: lookup_id varchar2(20) pk lookup_type varchar2(20) pk description varchar2(255) > 1. specific attributes for a particular code type is logically and physically >separated from o

RE: email Problem in WINDOWS 2000 Server -off Topic

Here is the address of a mailing lists that may be more related to your topic. http://e-newsletters.internet.com/mailinglists.html Eric -Original Message- Sent: Thursday, March 22, 2001 12:58 PM To: Multiple recipients of list O

Re: Re[2]: Re: OFF-TOPIC SUN vs. HP

I would say that's because of security reasons. oli [EMAIL PROTECTED] wrote > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, March 21, 2001 16:37 > > To: Multiple recipients of list ORACLE-L > > Subject: Re[2]: Re: SUN vs. HP > > > > ..

Re: report.txt

Dave, There is a great site to analyze the report.txt: www.oraperf.com For those on this list that have used oraperf before, there is now a primary and secondary site, so it *should* be operational. Enjoy, _ Ari Kaplan PocketDBA Systems

RE: email Problem in WINDOWS 2000 Server -off Topic

Title: email Problem in WINDOWS 2000 Server -off Topic That looks like an exchange server problem possibly.  I would think the easiest way to solve this is to go to microslops web site and type in the error.  I am sure someone else has come across this and solved it already.  Or, as funny as

RE: Log writer

Title: RE: Log writer thanks Ross,     MTS, I didn't know it was on?  Isn't that just an init.ora setting?  I am looking in to finding out about the cache, but no luck yet.  The redo log buffer is 67,676 kb.  Yes, this isn't some normal little system where the duhvelopers are just querying t

RE: report.txt

Title: RE: report.txt try Anjo Kolk's web site. Sorry, but i don't remember the new URL, although i am certain other listers will. -Original Message- From: David Turner [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 12:46 PM To: Multiple recipients of list ORACLE-

RE: email Problem in WINDOWS 2000 Server -off Topic

Right click on the default smtp server (in IIS manager) and choose properties. Under the "delivery" tab there is an entry for smart host. You must enter the ip address of your mail server there. I would check your old settings and copy them over. Eric -Original Message- Sent: Thu

Re: email Problem in WINDOWS 2000 Server -off Topic

convert to linux and use smtp joe >-- >Author: Adi Murugaian INET: [EMAIL PROTECTED] > >Please tell me, where do I find a user group for Windows 2000 Server: > > >If any one help me to solve the following problem, greatly appreciated: > > >We were using II4 on Windows NT 4 for Web server. >Th

Re: oracle training

dbbasics and New Horizons offer Oracle training in NC. DBbasics is in Raleigh and Greensboro. New Horizons is located in Greensboro. It may be in other cities as well. Hope that helps --- "Streeter, Lerone A LBX" <[EMAIL PROTECTED]> wrote: > aren't there some people from north carolina here

email Problem in WINDOWS 2000 Server -off Topic

Title: email Problem in WINDOWS 2000 Server -off Topic Please tell me, where do I find a user group for Windows 2000 Server: If any one help me to solve the following problem, greatly appreciated: We were using II4 on Windows NT 4 for Web server. Through ASP program using 'CDONT' we were

report.txt

Anyone have a shell script that can read a report.txt and list some of the items that need to be looked at. I'm lazy and don't want to start from scratch. Thanks, Dave Turner -- And you thought James Bond's watch was cool...

RE: Re[2]: Couple of questions

I'd even give latitude to someone who might not know everything, but who has a basic understanding and will logically and carefully research a problem as opposed to hacking away at it until he/she figures it out. >>> [EMAIL PROTECTED] 03/22/01 12:13PM >>> Gosh I keep mine hush-hush. It is at

RE: Log writer

Title: RE: Log writer Kev,   Pure shot from hip:   I'd say you have more network/app response tuning than log tuning. I'd say you have more disk tuning ( for table/index reads) than log tuning. I would DEFINITELY turn the silly ass MTS off.   I'd find out how to make sure disk cache

Using HS

Hi, Back from vacation and trying to make HS work between Oracle 816/Solaris and MS SQl Server 6.5 or Oracle 817/Solaris MS SQl Server 6.5. The ODBC driver is Merant 360. On 816 I'm having : ORA-28500: connection from ORACLE to a non-Oracle system returned this mess age: [Transparent gateway f

Somewhat OT: Db2 Vs Oracle

Due to price only (ANYONE FROM ORACLE LISTENING) my current client is considering moving to DB2(UDB?) from Oracle. They really don't have much of an investment, if any in Oracle (startup using licenses from parent co.). Now that they see how expensive Oracle will be they are reconsidering th

RE: Re[2]: Couple of questions

Title: RE: Re[2]: Couple of questions Gosh I keep mine hush-hush.  It is at the very bottom of my resume...  Yes I have it but so what?  I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE.  Yes, Gene, y

Re[2]: Couple of questions

Someone coming into where I work with only their OCP as their claim to fame will most likely not get an interview whereas someone with a number of years Oracle experience will. We were pretty badly burned in the recent past by someone who had their OCP as their sole claim to fame. This particula

RE: Replicating between Solaris / NT

Yes, It works perfectly.  We tried it for a one-directional replication.  Master site on a Unix box and the snapshot on an NT (both have 7.3.4 of Oracle engine). -Message d'origine-De : Rahul Dandekar [mailto:[EMAIL PROTECTED]]Envoyé : jeudi 22 mars 2001 17:38À : Multiple rec

RE: Couple of questions

True, but it probably looks good on a resume! -Original Message- Dandekar Sent: Thursday, March 22, 2001 11:02 AM To: Multiple recipients of list ORACLE-L > Also for those who have Oracle certification how much database experience > (Oracle in particular) did you have before you obtaine

RE: Single Code Table or Separate Code tables dilemma

Code tables... been there done that (with PowerBuilder/Oracle) and I don't like it. Here's why... Large apps may consist of 100's or 1000's of lookup tables so duhvelopers like the "master code table" idea because they only have to build one front end for maintaining all the "lookup" values. But

RE: Log writer

Title: RE: Log writer Jeez, Seagate Cheeta 18 and 36, 10k RPM   ahhh UNFORMATTED CAPACITY (GB) 22.54   FORMATTED CAPACITY (GB) __18.21   AVERAGE SECTORS PER TRACK 213 rounded down   ACTUATOR TYPE ROTARY

Replicating between Solaris / NT

Nandini,   Can we replicate between two databases on different OS? Should not be a problem I guess. But still curious... Has anyone tried?   816 Solaris <>816 NT   -Rahul

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

Just make sure you have a mirror on each side of the fault line... >>> [EMAIL PROTECTED] 03/22/01 10:56AM >>> I believe fiber channel makes this possible because it allow drives to be separated by about 60 kilometers (or is it 100?) without having any latency problems. I read somewhere that so

Load LOB's w/ SQL*Loader problem

8.1.7/Win2000 While loading a table with small tiff images (6k - 15K, out of line Blob) and supporting data using SQL*loader we experienced a problem that some of the images getting loaded aren't matching up with the supporting data. Row 95 has the images from Row 1985, etc. Appears to be rando

RE: But all is not gloom and doom for Oracle...

Which is why, when you put all your eggs into that basket, you WATCH THAT BASKET!!! >>> [EMAIL PROTECTED] 03/22/01 09:45AM >>> I don't know if I necessarily agree with that. What if their financial report from the past 3 years shows a lot of growth. Well if you don't investigate the company an

Re: Couple of questions

> Also for those who have Oracle certification how much database experience > (Oracle in particular) did you have before you obtained certification? > What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be peop

Latch 'event group latch'

Anyone know what this latch is for and what causes waits on it ??? Cheers Connor = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue"

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

I believe fiber channel makes this possible because it allow drives to be separated by about 60 kilometers (or is it 100?) without having any latency problems. I read somewhere that some shops have been able to roll their own SRDF/BCV-like triple mirror solution without having to buy huge, expensi

RE: dbms_obfuscation package

bless you both! >From: Thomas Jeff <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: dbms_obfuscation package >Date: Thu, 22 Mar 2001 05:25:23 -0800 > >FWIW: This is something I played with a long time ago: > > >DECLARE

RE: Log writer

Title: RE: Log writer Disk mfr? rpm? seek/access times? diskperf -y set already? CPU,I/O, or diskbound system? log buffer size? log file size? what else is on the "separate" disks? anything? separate disks share a controller? select event, time_waited from v$system_event order by 2 desc; resu

  1   2   >