Re: IN() question

Hello Lisa, Null values are excluded from search list for in statement. Saturday, May 04, 2002, 6:43:38 AM, you wrote: KL Slap me if this is a dumb question. KL Here's my pay methods SQL SELECT ASCII(PAY_METHOD), PAY_METHOD, COUNT(*) KL 2 FROM LEISURE_PLAN_MASTER_TEMP KL 3 WHERE

Steps in db opening from mount stage to open stage????

Dear Guru, I want to know all the internal steps happen during opening database from mount stage. For e.g. SMON cleans temp segment, block corruption check, SCN check.. etc.. etc.. Where can I find these details.. Any suggestion/input? TIA, Best Regards, Sandeep. -- Please see the

Re: Oracle - Access

Hello Roland, Check your system variables. You maybe miss it in your icon application. Friday, May 03, 2002, 9:48:30 PM, you wrote: RSis Hallo, anyone who has a good hint on this: RSis I have an appplication which goes against Oracle and when I am inthe application and run VBA code which

RE: Steps in db opening from mount stage to open stage????

THere are some numeric events (for example event 10015) to trace the SMON and Instance recovery. None of them are documented. Other than that I have not seen any external references/. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kurliye Sent: Sunday, May 05,

Re: Inactive sessions where program = dllhost.exe

Hello Rick, Do you have web access to your database? It looks like web sessions. Friday, May 03, 2002, 4:18:30 AM, you wrote: Rtc Hi All, Rtc In a particular instance there are some inactive sessions where program is Rtc dllhost.exe. It appears when user disconnects this dllhost.exe is Rtc

RE: Steps in db opening from mount stage to open stage????

The conecpts guide in the doc explains a lot about the startup mount and open stages... HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again.

RE: IN() question

Try this SELECT COUNT(*) from leisure_plan_master_temp where membership_class = 'D' AND (PAY_METHOD IS NULL or pay_METHOD NOT IN ('C','P')) ; -Original Message- Sent: Monday, May 06, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hello Lisa, Null values are excluded from

Oracle Presentation for Beginners!

Hello all, because I am an human being I am also looking for the easiest solution :-) So, I need to have a training session concerning basic oracle features. I wonder if anyone of you know place/site where I could download some powerpoint slides. Or if you have your own, pls. send me a copy

RE: slow SQL query, diagnosis using 10046 trace event

Suhen, Look at what you are doing : Query Plan select orgplvee.org_lvl_parent ,prdplvee.prd_lvl_parent , (NVL(invbalee.on_hand_qty,0)+NVL(to_intrn_qty,0)), (NVL(invbalee.on_hand_retl,0)+NVL(to_intrn_retl,0)), (NVL(invbalee.on_hand_cost,0)+NVL(to_intrn_cost,0)) from invbalee ,orgplvee

RE: Steps in db opening from mount stage to open stage????

Hi, Oracle document says very generic, and I need detailed steps. I need all information about database internal activity which carries out when db opens from mount stage. Any help/suggestion? Regards, Sandeep. -Original Message- Sent: Monday, May 06, 2002 11:08 AM To: Multiple

[no subject]

Hi, I am facing a very strange problem. Oracle 7.3.4.4.1 and HP 10.2 I do an analyze of a huge table (more than 46 million records) . The query which hits this table and 2 other table has an RULE hint . On the day analyze fails on the big table, performance is very very slow . But with

Re: Steps in db opening from mount stage to open stage????

Read the source code ;-) Why do you need it ? Is their a critical business function depending on this information ? Anjo. Sandeep Kurliye wrote: Hi, Oracle document says very generic, and I need detailed steps. I need all information about database internal activity which carries out when

RE: where to find Oracle Installation guide for HP-UX ? - THANKS

THANKS a lot , Brian , and all who replied !! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 06, 2002 1:22 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Next time include the release/version you're looking for, ya know!!! As

RE: Oracle IFS

I don't know if Oracle fixed the iFS memory requirements, it used to be brutal. 2G per two protocols with two concurrent sessions, if I remember correctly. That adds up quickly. I asked during the Oracle Technology Day here, and was told that it still requires a massive amount of memory

Re: Datawarehousing help

Rachel, Are you licensed for Oracle Designer? We put the estimated row counts for each table into Designer and it produces a nice report showing sizing estimates per table or index, tablespace, and database. Pretty painless. You still need to add on extra space for archives, exports,

RE: pl/sql is INTERPRETED?

Jared , no language as powerfull as Java (and it is VERY powerfull) is easy to learn. Yes , it is easy to pick up the basic syntax and write toy programs (which could be much more easily written in perl, tcl or even ksh). That's what i did - i learned some basic java and XML in a week or two and

RE: Reverse Key Index Performance

Hi Larry, I did some testing on RKI after seeing your post. It's not any different that normal indexes for unique lookups. I'm sure you have some other issue like change in execution plan or even a small difference like using/not using Oracle PQO. Regards, Waleed -Original Message-

Can Partition be set an Session Level

Hi All Can we able to set the Partition in the Session Level. I.e if I have a partition table and when I am querying can I set it in the session Level Rgds Ayyappan.S This communication contains information, which is

RE: DB Size

Physical --- CSW -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 7:33 PM To: Multiple recipients of list ORACLE-L Physical size (disk) or logical size (bytes of actual data)? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Simon

RE: Datawarehousing help

Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being collected, I can see them wanting data aggregated hourly. I greatly doubt the tech people will allow adhoc queries, they seem to do things right here. What

RE: DB Version upgrade with CreateDB/Import Risky???

James, As everyone else has already mentioned, either method is just fine. Preferable is in the eye of the beholder. It really comes down to whatever you are more comfortable with. I guess my final response to him would be - thanks for the input - and to go ahead and do it the way you want to.

Re: Datawarehousing help

Yechiel, have you used their tools? We are trying to decide whether or not to use them, so if anyone has had recent experience with them, I'd appreciate your thoughts on ease of use, understandability, quality of the product, etc Thanks Rachel |+--- ||

Re: Oracle IFS + removable media (CD)

It seems the memory requirement are comming out of Java implementation. Looks like iFS is made of mostly Java code eating a lot of memory. BTW, did anybody implement archiving system with Oracle iFS storing data offline on removable media? Using READ_ONLY_OPEN_DEALYED = TRUE looks like possible

RE: Re[2]: pl/sql is INTERPRETED?

All - I think one major point has been overlooked in this discussion of how hard it is to learn Java - OOD! Our company has been sending many developers to Java class. Almost everyone reports that the big hurdle is learning Object-Oriented Design. The Java syntax is relatively easy, simpler in

change a database connection in a stored procedure?

Hi List, Can someone tell me is it possible to change a database connection in a stored procedure? if so how? TIA Kranti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: your mail

DBMS_STATS.DELETE_TABLE_STATS On Mon, May 06, 2002 at 02:18:38AM -0800, [EMAIL PROTECTED] wrote: Hi, I am facing a very strange problem. Oracle 7.3.4.4.1 and HP 10.2 I do an analyze of a huge table (more than 46 million records) . The query which hits this table and 2 other

RE: pl/sql is INTERPRETED?

There is a big difference between LEARN and becoming an experienced programmer. I do not see any thing wrong when somebody says I learnt java or C in a day, week or month. I learnt Java in a day! I had to write a program that sends/receives a PL/SQL tables to an Oracle stored procedure (I

RE: Can Partition be set an Session Level

Ayyappan - I'm just trying to understand your question. Pardon me if I'm a little slow, it is Monday. Okay, you have a partitioned table. That is a physical object, nothing to do with the session. And then you query that partitioned table. Is your question how the query will be optimized by

RE: Oracle Presentation for Beginners!

Here's the slides! SQL/PL-SQL http://www.ecst.csuchico.edu/~melody/courses/Spg2001OraclePLSQL/PLSQL8iPPTS/ Default.htm Architecture and Admin http://www.ecst.csuchico.edu/~melody/courses/Fall2001CSCI379/TOC.html Performance Tuning

Re: DB Version upgrade with CreateDB/Import Risky???

The method that you propose is exactly the method that I used to upgrade a 10G Win NT database from 7.3.4 to 8.0.5. It worked flawlessly; though as I remember I had to use the 7.3.4 client to do the import. I also did an upgrade from 8.0.5 to 8.1.5 on a much larger database (couldn't

RE: I need to change the instance name

Eriovaldo - Often the lot of a DBA is to balance value and risk. Here, you must ask yourself - what is the value of retaining the same instance name, and what are the risks to my production environment? If you perceive the value to be high and the risks low, then go for it. But often (especially

RE: pl/sql is INTERPRETED?- java test

Sun Certified Programmer Practice Exam http://www.geocities.com/SiliconValley/Orchard/9362/java/javacert/newboone1-19.html http://www.geocities.com/SiliconValley/Orchard/9362/java/javacert/newboone20-39.html http://www.geocities.com/SiliconValley/Orchard/9362/java/javacert/newboone40-70.html

RE: Steps in db opening from mount stage to open stage????

Well, there might be if you're MS employee working on SQL*Server or IBM employee working on UDB (formerly DB2). -Original Message- From: Anjo Kolk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 6:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: Steps in db opening

Re:RE: Can Partition be set an Session Level

Dennis, In reading the question once again it appears that Ayyappan is asking if he an set which partition of the table will be queried in a specific session. Ayyappan, Obviously the answer is NO. Partitioning does not limit the amount of data a session can see, but rather the amount

RE:

Shreepad - Have you performed an EXPLAIN PLAN on this query? With and without the statistics? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 06, 2002 5:19 AM To: Multiple recipients of list ORACLE-L Hi, I am facing a very strange problem.

Re: SMJ, NL or HJ

By the way, when I added the ORDERED and USE_HASH hints to this query, I did not encounter the errors about the TEMP tablespace utilization, as with the MERGE SORT JOIN. Thanks a ton, Jonathan, for your inputs. Raj

DB Version Ugrade - Thank you

Dear List, First, I wanted to apologize for the redundant postings about the topic DB Version Upgrade with CreateDB/Import Risky???. I sent entries of the text of the message from my home accounts to my account at work and obviously screwed something up, such that it sent each to the LIST as

Re: ERD generation tool - Active SCM

Yechiel, here is additional information: white paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm WEBCAMS (4-6 mins) and screenshots: ActiveChangeManager: http://www.iraje.com/ActiveChangeManager_viewlet.html http://www.iraje.com/acommanbig.htm ActiveCompare:

RE: Oracle 9 Agent not starting

Hi, Ian, Try this: 1. remove *.q files from network/agent subdir 2. removeservices.ora from network/agent subdir 3. removesnmp_*.ora from network/admin subdir 4. restart agent HTH Vadim -Original Message-From: Biddell, Ian [mailto:[EMAIL PROTECTED]]Sent: Monday, May 06,

OT: Erwin - Does this thing work?

Hello all, I spent the weekend screwing around with Erwin. What a waste. I could not believe how poorly it generated DDL. Has anyone gotten this product to generate DDL in a readable, logical manner? I am using Version 4.0, SP1 Lisa Koivu Oracle Database Big Baby Oven Fairfield Resorts,

RE: In an Analyze Necessary?

John, You seem to be one of those lucky DBAs who don't have performance issues :) This is just one of the 150 databases. A DBA needs performance issues, backup failures, disk failures, 600 errors, dropped tables, et all, to justify wages above the minimum wages law ;-) Raj

RE: IN() question

Does this mean that you can't include Null as a value in an IN() clause? That is, would something like: SQL SELECT COUNT(*) 2 from leisure_plan_master_temp 3 where membership_class = 'D' 4 AND pay_METHOD IN (Null, 'C','P'); count rows where pay_METHOD is Null? (Disregarding for

RE: Erwin - Does this thing work?

Upgrade to 3.5.2...that is supposedly the final version that Platinum put out before CA butchered it. -Original Message- Sent: Monday, May 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Hello all, I spent the weekend screwing around with Erwin. What a waste. I could not

RE: Oracle IFS

Hi Patrice Document 182850.1 QuickStart Guide to installing 9iFS 9.0.1 recommends 1gig of RAM on a dual pentium 500mhz to support 50 users using all protocols moderately. This document is dated Apr 5 of this year. So either they fixed it or they are stretching the truth. Can you expand on your

RE: Re[2]: pl/sql is INTERPRETED?

If you develop a set of PL/SQL procedures that handle all access to the database and have your developers use them as objects, then your dream can come true. My experience is that the developers will want to pass embedded SQL to the Oracle calling object. It's much easier for the developers to

RE: Oracle Presentation for Beginners!

Awesome, I'll be checking these out ! --JoJo -Original Message- Edward Sent: Monday, May 06, 2002 7:33 AM To: Multiple recipients of list ORACLE-L Here's the slides! SQL/PL-SQL http://www.ecst.csuchico.edu/~melody/courses/Spg2001OraclePLSQL/PLSQL8iPPTS/ Default.htm Architecture and

Re: Datawarehousing help

Rachel, I haven't used their warehouse stuff and it has been a few years since I had to deal with people doing statistical analysis with SAS (by the way very good for that so if the reason considering this is the need for heavy duty statistical analysis that is a big plus) but the one thing that

RE: 9i Release 2 features/fixes

The big thing that I'm looking forward to is the logical standby database. This will allow you to apply logs between different versions of Oracle. Should allow us to drastically reduce downtime during upgrades. -Original Message- Sent: Friday, May 03, 2002 6:18 PM To: Multiple recipients

RE: Erwin - Does this thing work?

-I spent the weekend screwing around with Erwin A woman in your condition screwing around with Erwin!! The nerve of it all. ;o) -Original Message- Sent: Monday, May 06, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Hello all, I spent the weekend screwing around with

RE: Erwin - Does this thing work?

Hi Lisa, Yes. But its a little convoluted. It took me quite some time to do it. Depends what you want included. IE. storage paramters etc. This is the product I use to generate all of our models and YES, it drives me nuts. They had a bug in the last version that

RE: Paging problem in SunOS

My guess is that Mitra is not experience memory shortage if he has 1/2gb of ram and Oracle is the only thing running on it with SGA 50M. To verify, check whether the paging is actually doing swapping. Look for scan rate when doing vmstat. If it's not memory shortage then the high paging

Re: ERD generation tool - Active SCM

this is exactly my point. It would have been better to give your developer truncate only privileges, and that too only on a few tables... but NEVER the Oracle schema owner password! NEVER. But, you too gave it away! you too Brutus! Even though you are quite averse to doing so. Think about it,

RE: DB Version upgrade with CreateDB/Import Risky???

The migration method can be a bit tricky, but I'm curious as to what part of it was causing your problems. At a previous job I pored over the migration manual for about 6 weeks identifying which steps were necessary for our shop and which weren't, and then automating the whole thing for push

Re: I need to change the instance name

Well, if it's an 8i database and the need exists to change the database name for cosmetic reasons, you could not change anything and simply add DEVELOPER as one of it's service_names in init.ora. Then connections would be accepted as either DEVELOP or DEVELOPER, no surgery required. Eriovaldo

RE: Datawarehousing help

Rachel, If a DW is built and that users do not have access to a part of it in an ad hoc fashion, you gonna have a lot of political meetings They should have some data marts for their usage and keep most of them off the raw data. Regarding SAS tools, I've used SAS more than 10 years ago in

RE: Datawarehousing help

A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go to the DW, DW is used to build DM. A DW may in fact very much resemble an OLTP database, with a temporal component thrown in to track changes to data over

RE: IN() question

Dang, you're right--I just now tested it. I knew that MY_COL = NULL isn't evaluable--I'm not sure why I thought IN() would act differently. I guess it would be whiny of me to wish that I'd get a warning or error from the db when issuing such statements... Thanks! -Roy Roy Pardee

Good DBA vs. Bad DBA

I posted my list of Good DBA vs. Bad DBA on the DBA Pipeline (www.revealnet.com), and it was suggested I share it here, which I am doing comments most welcome. (If you saw this list on Revealnet, I've made some minor adjustments...) Roberts Rules of Good DBA vs. Bad DBA Good DBA -

Upgrade from 8.1.7 to 8.1.7.2

Hi Experts, I have download patch2 for 8.1.7 for Sun Solaris, just want to check with you is there any specific things I have to do for this upgrade or not. How much space(on oracle home) need for this upgrade? Hamid Alavi Office 818 737-0526 Cell818 402-1987

RE: IN() question

Yes, that's what it means. Using NULL in IN() would imply that NULL has equality with something. NULL is never equal to anything. NULL can only be checked with 'IS NULL' , 'IS NOT NULL', and in DECODE() statements. Jared Pardee, Roy E [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

New Thread: IRAJE toolset

At the expense of sounding like a sales person, let me point this out again for the benefit of the group: And, you certainly need to look at it: http://www.iraje.com/docs/ActiveSecureDesigner.htm I will find forward you some more info. Keith Ok Keith, I give. Let's get a

RE: IN() question

Roy, that is correct! null is null and cannot be compared to anything including itself. well, it can be compared to itself, but it never equals itself. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, May 06, 2002 12:54 PM To: Multiple recipients of list

Re: ERD generation tool - Active SCM

Yechiel, How did you give a responsible person the ability to truncate a table without granting delete any table. Very dangerious. There was a long dicsussion on the list a while ago that displayed the dangers of such a grant. I think it was followed up with an update your resume statement. Ron

RE: 9i Release 2 features/fixes

I have been trying, like you wouldn't believe, to get a list of new features in 9iR2. I have run into stone wall after stone wall. I think there has been some internal confusion and debate over what to include in 9iR2, based on some of what I've heard. I've even heard that Logical Stand-by will

RE: Oracle IFS

I just read the documentation, when the first incarnation of iFS was released. Looks like they made significant improvements. Oracle Internet File System Installation Guide, Release 1.0 for Windows NT, May 2000, page 1-3: Minimum configuration - - pentium III, 500MHz -

OT: 8i OCP questions

Hi, I cannot find any info on Oracle web site concerning time allowed between test and plans to retire 8i OCP. Does anyone know or have any links that may state if there is a time limit betweeen test and whether Oracle has plans to retire 8i certification. Thanks Rick -- Please see the

RE: DB Version upgrade with CreateDB/Import Risky???

This was a couple of years ago, so I don't have a distinct recollection of the problems. We are on Compaq Tru64. Most vendors seem to port to it last, so don't always test as well as the more popular platforms. Basically I couldn't get the migration tool to work, I called Oracle Support, they

RE: Datawarehousing help

Right now I'm collecting information.. I don't KNOW what this will be.. other than a learning experience of course. That which does not kill us makes us strong, right? rachel, anticipating great strength |+--- || | ||

Installing oracle 9.0.1 on Sparc

Hi, I have a problem when I am installing oracle 9.0.1 on Sparc: give me the error:not can create..ins_net_client.mk... not can create..ins_net_server.mk...etc After when I want to connect with SQLPLUS:

ORA-03113: end-of-file on communication channel

All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now

RE: 9i Release 2 features/fixes

RF: You must have missed my post from last week. Oracle has published the 9iR2 new features. And, yes A revolutionary improvement in Oracle9i Database Relase 2 is the introduction of the Oracle Data Guard - Logical Standby datbase (from the Oracle9i Database Release 2 New Features; An Oracle

Re: OT: 8i OCP questions

See http://www.oracle.com/education/certification/faq/index.html?faq4.html FAQ - Information on Time Restrictions to Finish your Certification Currently there are no time restrictions on how long you can take to complete your certification. However, if Oracle has announced the retirement of

RE: Datawarehousing help

Just wanted to reiterate the grain recommendation. The growth rate of our data warehouse increased app. 20x when the business side changed their mind from monthly to daily on our largest fact table. They did this one week after we got the monthly table into production as per their original

RE: Installing oracle 9.0.1 on Sparc

Title: RE: Installing oracle 9.0.1 on Sparc Natalia, Check your operating system version. Version 2.6 or 5.6 is required. -Original Message- From: Natalia Laracca [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject:

8.1.7.3 - Good or Bad?

Oracle Gurus, I seem to be running into memory leaks on an 8.1.7.0 database on Solaris 8. After searching metalink and reading some patch release notes, it looks like we might be having problems with the XML parser and/or LOBs. We are thinking of upgrading to 8.1.7.3, but I am a little

RE: 9i Release 2 features/fixes

Try this link: http://otn.oracle.com/products/ias/pdf/9iasr2newfeature.pdf Ben -Original Message- Robert Sent: Monday, May 06, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I have been trying, like you wouldn't believe, to get a list of new features in 9iR2. I have run into

Re: ORA-03113: end-of-file on communication channel

Doc ID: 17613.1 On Mon, May 06, 2002 at 12:18:18PM -0800, John Weatherman wrote: All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink

RE: Datawarehousing help

Cool!! Here comes Oracle Data Warehousing 101... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Right now I'm collecting information.. I don't KNOW what this will be.. other than a learning experience of

RE: ORA-03113: end-of-file on communication channel

I had this problem before in our Unix box. I have to use "ipcrm -m id" to remove the oracle process. You must use ipcs to find out the process first. Brian Chen -Original Message-From: John Weatherman [mailto:[EMAIL PROTECTED]]Sent: Monday, May 06, 2002 4:18 PMTo: Multiple

RE: Datawarehousing help

I've always been a cynic about storage -- too much is never enough. |+-- || | || | || JayMiller@tdwate| || rhouse.com | ||

Re: Datawarehousing help

[EMAIL PROTECTED] wrote: Cool!! Here comes Oracle Data Warehousing 101... um knowing the way the goddess feels about book writing, i wouldn't go there if i were you.;-) unless, of course, you're going to write the book for her to edit.;-) -- -- Bill Shrek Thater

Re: Installing oracle 9.0.1 on Sparc

Natalia Laracca wrote: Hi, I have a problem when I am installing oracle 9.0.1 on Sparc: give me the error:not can create..ins_net_client.mk... not can create..ins_net_server.mk...etc After when I

RE: Datawarehousing help

Hi Jared - I am a little confused about this - 1. A DW may be a true 'warehouse' of enterprise data from which DM may be built. This is a full blown DW architecture though, and you may only wish to start with some DM to get your feet wet, or maybe that's all that is actually needed. So DM

RE: 8.1.7.3 - Good or Bad?

Eeep! I missed that one! We're on 8.1.7.2 and I wanted to go to 8.1.7.3 because of bugfixes in CURSOR_SHARING=FORCE. Research mode: ON Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original

RE: Datawarehousing help

nuh uh, for two reasons, the first and foremost being, there already IS one the second is that I have no plans to write any new books |+--- || | || | || cgrabowy@fcg.| ||

RE: 9i Release 2 features/fixes

Robert, I downloaded a copy of the db_r2features.pdf from the link http://www.oracle.com/features/9i/index.html?t1db_unbreakable.html and the wish list is nice if I understand it correctly. It lists the secondary site for data guard as a logical copy of the production database. The info is

9i Automatic UNDO bugs

I have heard of 9i AMU bugs that cause database outages, but nothing shows up on metalink. Does anyone have any direct experience with 9i AMU causing database corruption and loss? If so, what platform was this on and what bug was identified as the culprit? Daniel W. Fink

RE: Datawarehousing help

I was hoping she would figure out the DW hard stuff, then write the book explaining everything with lots of big, colorful pictures...(big grin). If I were to write the book, and she be the tech editor, then she would drive down to Philly and kick myand shove the already burning manuscript

Re: ORA-03113: end-of-file on communication channel

Check and see if you still have a lock file in $ORACLE_HOME/dbs David A. Barbour Oracle DBA, OCP AISD 512-414-1002 John Weatherman

RE: 9i Automatic UNDO bugs

Ooooh Ye 9.0.1.0, 9.0.1.1 and fixed in 9.0.1.2... Nasty bug. I lost a database on AIX 64 Bit to the bug. Just applied to backport fix for 9.0.1.1 and 9.0.1.2 databases today as a mater of fact. (they are going 9.0.1.3 just as fast as I can get them there). Base bug : 1904199 RF

RE: Datawarehousing help

Someone's got to pick up Marlene's slack... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 5:44 PM To: Multiple recipients of list ORACLE-L nuh uh, for two reasons, the first and foremost being, there already IS one the second is that I have no plans to

RE: 9i Automatic UNDO bugs

Look for Bug # 1904199. The truth is out there... :) Brian -Original Message- Fink Sent: Monday, May 06, 2002 4:58 PM To: Multiple recipients of list ORACLE-L I have heard of 9i AMU bugs that cause database outages, but nothing shows up on metalink. Does anyone have any direct

RE: Datawarehousing help

Whether you start designing a full blown DW or start with some DM's really depends on a number of things: 1. experience 2. money 3. time Kimball et all suggest you start with projects that can be completed in 90 days, and assemble your DW piece meal. If you're starting from scratch, you may

RE: 9i Release 2 features/fixes

This is for 9iAS, not the RDBMS. RF -Original Message- Sent: Monday, May 06, 2002 4:55 PM To: Multiple recipients of list ORACLE-L Try this link: http://otn.oracle.com/products/ias/pdf/9iasr2newfeature.pdf Ben -Original Message- Robert Sent: Monday, May 06, 2002 3:14 PM To:

Re: 9i Automatic UNDO bugs

sparc, metalstink id: 1904199 joe Daniel Fink wrote: I have heard of 9i AMU bugs that cause database outages, but nothing shows up on metalink. Does anyone have any direct experience with 9i AMU causing database corruption and loss? If so, what platform was this on and what bug was

RE: 9i Release 2 features/fixes

I did miss it and judging from the response of the site, half the newsgroup has jumped onto the site... :-) Thanks, it's not up yet, but I'm sure it will be great! RF -Original Message- Sent: Monday, May 06, 2002 4:35 PM To: Multiple recipients of list ORACLE-L RF: You must have

Re: DB Size script

One more script from this list with slight changes. For 8i or up. SELECT 'The database size is '|| round( (df.sum + rd.sum + tm.sum) / ( 1024 * 1024 * 1024 ) ) || ' GB excluding INI, password and control files' FROM (SELECT SUM(bytes) sum FROM sys.dba_data_files) df, (SELECT SUM(bytes *

re: how to put ' on statement

hi I forget how to put single qutation on sql. somebody can help me. Mitchell I could't make it from following. select 'ALTER TABLESPACE rename file ' '||file_name||' to '||file_name||'';' from dba_data_files where tablespace_name = 'TBL_STATEMENT'; -- Please see the official ORACLE-L

re: how to put ' on statement

Use CHR(39) to place a single tic inline. --- mitchell [EMAIL PROTECTED] wrote: hi I forget how to put single qutation on sql. somebody can help me. Mitchell I could't make it from following. select 'ALTER TABLESPACE rename file ' '||file_name||' to '||file_name||'';' from

RE: Reverse Key Index Performance

Waleed, Thanks for doing a test. There could be cases where we don't benefit from buffering, and, where we will have to visit a lot more blocks, but surely not enough to account for the difference I was seeing. As far as the plans, the raw 10046 traces show them as being the same, and, there

  1   2   >