RE: Mass updates to production tables (NULL to non-NULL)

er to scan (read) the segment and find the > > rows that need to be > > updated. these rows get communicated back to the > > master process using the > > rowid. The master process starts to update rows > > serially using the rowid for > > update and this proce

RE: Mass updates to production tables (NULL to non-NULL)

-- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from).

OT - 9i DB for HP-UX Available On Technet

Listers, Since there was some discussion about the next platform on which 9i might be released, I thought some might be interested in knowing that 9i for HP-UX is now available on TechNet. Regards, Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

9iAS Forms Stability Follow-up

Listers, I asked about this question a while back (9iAS 1.0.2 / Forms 6i Patch 2 / Apache / connect mode = http / HP-UX 11.0). I thought I would give an update since a few people showed interested in the subject. They were seeing the Forms server crash numerous times a day in a test environment.

OT - Books Covering Partitioning in 8i

Listers, I might end up on a Data Warehouse and Data Mart project using 8i. I've read various white papers, Oracle doc's, etc on partitioning capabilities of 8/8i. And I've dinked around on my test machine a bit trying things out. Are there any books out there that you would recommend for digging

RE: 9iAS Forms Server Stability

Jared, Thanks for taking the time to reply. I don't know if they are working on any contingency plans, but, I guess they could stay on OAS and Forms 5.0 if things don't stabilize. I'm hoping that it is just a little configuration issue here, a tweak there, and so on. We will see -- they don't pla

RE: 9iAS Forms Server Stability

Jenny, Just to make sure we are on the same page, when I was talking about web deployed, I was talking strictly internal networks, lan, wan, etc using the "web forms" approach. Anyway, I don't know that you should nervous based on just my comments alone. It is kind of interesting, though, that n

RE: Performance of views

Helmut, Oracle *can* "push" the criteria down into the view definition in many situations. Certain operations, though, will not allow this to happen. You can find some info on Metalink, and, in the Oracle 8i Designing and Tuning for Performance manual. There are other source as well. Here is a li

9iAS Forms Server Stability

Listers, 6i Forms Server in a test environment is crashing quite frequently, 3 to 4 times a day. I'm relaying this question, and I'm not real familiar with the back end configuration details, so I might be off on some things. They have an 8.1.7 test environment with 9iAS 1.0.2. Platform is HP-UX

Forms 6i - Java Bean (Org Chart)

Listers, Users are desiring an org chart representation of data. Forms 6i Web Deployed (9iAS 1.0.2, 8.1.7, HP-UX, Forms 6i Patch2). One thought is to use a Java Bean since Forms 6i supports those. I have no problem doing a google search and digging up a few Java Beans that say they will do it, b

OT: LazyDBA List Owner?

Listers, Since I know there are folks on this list who also follow the LazyDBA list, who is the list owner of LazyDBA? I'm thinking it is Henry something, but, I can't remember the last name. I couldn't come up with any contact info at the LazyDBA site. I haven't been receiving emails from the L

RE: Pinning Packages Question

Steve, Thanks for the insight on how the kept status is managed during an invalidation. Regards, Larry G. Elkins [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Adams > > Hi Larry and list, > > > When a library cache object i

RE: Pinning Packages Question

Rafiq, Thanks for taking the time to address this aspect. Those are the type of details that help me in some of the areas I am trying to get my arms around and better understand. I was aware of how the objects could become invalidated, but, I didn't know it would be "re-pinned". It's something I

RE: Pinning Packages Question

Thanks to all who replied. An aging out mechanism for pinned packages didn't sound right. But, it seems like there are exceptions to almost everything, and many times contradictions, in Oracle docs. Just wanted to make sure I wasn't missing something obvious, or obscure. The 2 DBA's in the meetin

Pinning Packages Question

Listers, I was involved in a meeting today, strictly as a listener (no pun intended). A consultant made the statement that pinned packages are subject to being aged out of the shared pool, using an LRU type of mechanism. My understanding is that if you pin a package, it stays pinned (except maybe

RE: Developer 1 to 6/6i migration strategies ?

Mohammad, http://technet.oracle.com/products/forms/ "Upgrade Developer Forms 4.5 to Oracle Forms 6" towards the bottom of the page (or click the migration link towards the top of the page to take you there. Larry G. Elkins [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED]

RE: 9iAS -- Boxes on which to run

Eric, Thanks for the feedback, and yes, the Intel boxes would be running NT. The DB will still be on the HP V2500. And where did you get the info on 8.1.7 and Forms Server not being able to be on the same NT / W2K machine? I am about to try to install 9iAS on my W2K box at home. I already have 8

RE: 9iAS -- Boxes on which to run

Jared, Even though it was easier to support (which can add up to cost savings) was the performance a problem for you where on the Intel boxes? Regards, Larry G. Elkins [EMAIL PROTECTED] > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 12, 2001

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: Easy Doubt in sql/plus

Eriovaldo, If you don't want to have to mess around with your SQL adding chr(10), and since you said in SQL*Plus, you could use column commands: SQL> column dname newline SQL> column loc newline 1* select * from dept SQL> / 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS You can

RE: 8.0 / 8i Bang for the Buck Features

Paul, Thanks for the heads up. The application in question uses a lot of in-line views, sometimes nested quite a few levels deep. On 7.3, they encountered various aliasing problems -- needing to alias the column names in the in-line views even if the name remained the same as the column name when

RE: 8.0 / 8i Bang for the Buck Features

Diana, Good to see you back on the list. One of the DBA's has that book and will review it for applicable performance related info. I was able to get a couple of examples from Technet where they benchmarked a procedure using bulk binds against the same procedure not using bulk binds. The same ty

8.0 / 8i Bang for the Buck Features

Listers, We will be upgrading from 7.3.4.3 to 8.1.7 (HP-UX 11.0 V2500). And this is a bit of a broad question. Anyway, does anyone know of a paper, web site, etc that goes through each of the features of 8.0 through 8.1.7 and provides guidelines for estimating the potential performance return gai

RE: Deadlock Interpretation Assistance Requested

Riyaj, Thanks for responding. This is the first deadlock they have seen in 6 months (they used to see a lot due to an application coding issue). So I agree with waiting and seeing if this problem comes up again before putting a *lot* of time or resources into it, but, I still needed to put *some*

Deadlock Interpretation Assistance Requested

Listers, HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY Deadlock graph: -Blocker(s) -Waiter(s)-- --- Resource