Re: HOTSOS Conference

2004-01-05 Thread Tanel Poder
I'll be there as well, listening, speaking, also attending the 1-day Steve Adams class. A list evening/dinner would be great. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 06, 2004 3:59 AM > > > While perusing the HOT

RE: HOTSOS Conference

2004-01-05 Thread Bobak, Mark
I will be there. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Mon 1/5/2004 8:59 PM To: Multiple recipients of list ORACLE-L Cc: Subject:HOTSOS Conference While perusing the HOTSOS site, I noticed that the deadline for the discounted registrat

RE: oaktable people

2004-01-05 Thread Bobak, Mark
No, I'm an American, a member of the OakTable, and I do not now, nor have I ever worked for Oracle. Also, I'm pretty sure the same is true of Mark Powell. Also, WRT to James Morle, he's got a new white paper out, "Brewing Becnchmarks". It's available at http://www.oaktable.net/ -Mark -Or

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread zhu chao
Hi, Tanel: If you have plenty of downtime, everything will be ok. If you want to further limit the downtime, here is some suggestions: 1. I think manual parallel will always be better than oracle parallel. So I always use script, that means, I split the move table nologging script to 10 sc

Re: Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Fenng
I can see you everywhere :D >Hi, >Think what benefit can you get via such reorg before doing this reorg. >Since only a small database, I won't change it as performance benefit via reorg > will be small. >As others said, exp/imp is the most easy way, as movetable/rebuild index has >

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Jared Still
Tanel, That's a good idea. I briefly considered this, but didn't really dig into it. The systems I need to do this on is our SAP systems, and downtime is a precious commodity, especially for production. I just may try this on our test system. The problem with SAP of course, and many other ERP

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread zhu chao
Hi, Think what benefit can you get via such reorg before doing this reorg. Since only a small database, I won't change it as performance benefit via reorg will be small. As others said, exp/imp is the most easy way, as movetable/rebuild index has trouble sometimes when you have long c

HOTSOS Conference

2004-01-05 Thread Jared Still
While perusing the HOTSOS site, I noticed that the deadline for the discounted registration for the HOTSOS conferences ends after tomorrow. If you're thinking of going, you may want to check it out. Along those same lines, how many listers will be there? We could get together on Tuesday evenin

RE: sql trace - forward attribution

2004-01-05 Thread Anjo Kolk
They write all to the same trace file. So there should be different sid.serial# combinations. -Original Message- Boris Dali Sent: Monday, January 05, 2004 9:49 PM To: Multiple recipients of list ORACLE-L Right, but the new session (that inherits the sql trace attribute) - wouldn't it pro

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Tanel Poder
A small addition, PK/UQ constraints have to be disabled in order to drop their indexes (and index definitions should be exported before disabling constraints, because implicitly created indexes will be automatically dropped if a constraint is disabled (without keep indexes option)). Tanel. > I'm

Re: oaktable people

2004-01-05 Thread Jared . Still
He didn't, but nonetheless I thought it was something that you and others might be interested in. Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/05/2004 04:19 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTE

Re: oaktable people

2004-01-05 Thread Jared . Still
That would be nice.  It's already indispensible. "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/05/2004 04:19 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        Re: oakta

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Tanel Poder
Hi! > This is what I will need to use on our systems, as there are about 400 gig > of data and indexes. 200 gig of data is too large to export/import, at least > it is for this project. So dbms_space_admin it will be. I'm about to do a reorg+conversion of a 250GB 8.1.6 database in next week, he

Re: oaktable people

2004-01-05 Thread Ryan
oh yeah. James Morle sent me an email today and said he may expand his really good book to 2 volumes... - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, January 05, 2004 6:49 PM Subject: Re: oaktable people I'v

Re: oaktable people

2004-01-05 Thread Ryan
when did fuerstein join oaktable?   http://www.oaktable.net/pageServer.jsp?body=members.jsp   btw, are the only Americans members of Oracle or former members of Oracle?   - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monda

Re: oaktable people

2004-01-05 Thread Jared . Still
I've heard that Steven Feuerstein has a new book on the way, though I have been unable to find any reference to it. Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/05/2004 02:34 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Jared . Still
On a gig of data, you could easily export the data and re-import into new locally managed tablespaces. An alternative is to use the dbms_space_admin package to convert DD managed tablespaces to locally managed. This is what I will need to use on our systems, as there are about 400 gig of data

Convert to Locally-Managed Tablespaces

2004-01-05 Thread Paula Winkler
Hi all, I'm not sure if this question has been posted or not.  I inheritated an Oracle9i (9.2.0.4) database which contains all dictionary-managed tablespaces.  This small database is approx. 1 GB and resides on a HP server.  I plan to convert all the dictionary-managed tablespaces to Locally Manage

oaktable people

2004-01-05 Thread Ryan
Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: sql trace - forward attribution

2004-01-05 Thread Boris Dali
Tanel, What I see in the trace file header is something like the following: ... *** SESSION ID:(22.9304) 2003-12-29 15:04:45.743 ... Which is sid.serial# isn't it? If "session switching" occurs, handled by the same shadow process and the new session with a different sid.serial# continues to wri

Re: stress testing

2004-01-05 Thread tjambu_fatcity
Hi Tim Tony Jambu here. Saw your posting to Oracle-l with regards to your sp_vmstat.sh script. I am not sure if know but I write a regular hints & tips column for Select Journal. I read your article and would like to mention your script and point people to the script. Do you mind if I mention it

Re: sql trace - forward attribution

2004-01-05 Thread Tanel Poder
Trace file has server process number in it's name, not session number, thus as long as the sessions are served by the same server process, the contents will be written into one single file. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: M

RE: Upgrade

2004-01-05 Thread Ron Rogers
Dick, What kind of a nautical person are you??? the NT box will not even make a good anchor because the sides are flat and it will drag on the bottom during a small wind or current. Ron >>> [EMAIL PROTECTED] 01/05/2004 12:39:36 PM >>> Look on the Documentation CD for the upgrade manual. Safest w

RE: sql trace - forward attribution

2004-01-05 Thread Boris Dali
Right, but the new session (that inherits the sql trace attribute) - wouldn't it produce a **separate** trace file? In my case there's only one trace file with sid.serial# clearly stated at the begining of the trace file and WAIT #0 scattered all over the trace. ..Or am I missing something? ---

RE: sql trace - forward attribution

2004-01-05 Thread Boris Dali
Anjo, I suppose your test-case involved more than just use of sqlplus. Probably some middle tier with connection/session pooling of some sort? --- Anjo Kolk <[EMAIL PROTECTED]> wrote: > I actually build a testcase for this and it still > failed on 9.2 without > any patches. It is supposed to be

Re: Apps 11.5.9 D.R. Site -- MetaLink Note 216212.1 ??

2004-01-05 Thread Ron Thomas
Looks fairly close. I'll be doing this over the next couple of weeks. If interested, I'll let you know how it all turns out. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

ora 01548

2004-01-05 Thread Gene Gurevich
Hi. I getting ora-01548 error trying to drop an old undo tablespace under oracle 9204. I have shut down the database and brought it back (as metalink recommended), but I still see some segments created in the old undo tablespace and therefore I can't drop it. What could be the reason, does anyone

RE: sql trace - forward attribution

2004-01-05 Thread Anjo Kolk
I actually build a testcase for this and it still failed on 9.2 without any patches. It is supposed to be fixed in some later patch. I don't have the patches -Original Message- Anjo Kolk Sent: Monday, January 05, 2004 6:49 PM To: Multiple recipients of list ORACLE-L Cursor 0 also happe

RE: sql trace - forward attribution

2004-01-05 Thread Anjo Kolk
No, Each session will have its own sid and serail#, but they all run in the same process. Basically the client side tells oracle, that it wants to switch from session to session and oracle will keep the state of the switched out session. So you don't have to commit or rollback on every switch that

Re: Price is right

2004-01-05 Thread Ryan
www.bestbookbuys.com everyone should have that link. beware the 'used' books. Make sure they have atleast 1000 reviews with 99% positive. Its easy to create your own reviews. Look at what people say negative. Alot of people complain about silly stuff like 'book came 3 days late' or a page was wrin

RE: sql trace - forward attribution

2004-01-05 Thread Boris Dali
Thanks, Anjo. When session switching occurs does the new session get the same sid and serial#? And what happens with the session being "switched/replaced" - does the transaction it was performing get commited/rollbacked? I don't see XCTEND markers before those pesky WAIT #0 in the trace file. Also

Re: Problem with changing Dedicated Server to Shared Server

2004-01-05 Thread Reginald . W . Bailey
Try ensuring that they have different port numbers. One port number for the shared servers and a different one for the dedicated server. If they are going to use the same port number for dedicated, then it will be listed in the listener.ora file for reference. If each database is using a shared s

RE: rman restore question

2004-01-05 Thread Ruth Gramolini
If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem.

Re: sql trace - forward attribution

2004-01-05 Thread Tanel Poder
Oracle Portal uses session switching as well (and Apps 11i uses Portal...) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 7:49 PM > > > Cursor 0 also happens in oracle due to session switching (multiple > sess

Problem with changing Dedicated Server to Shared Server

2004-01-05 Thread Vélez
Hello everybody    I’m trying to change the Oracle 8i Dedicated Server to Shared (I don’t have problems with memory, so I ‘ve configured the large pool well).   There are two databases on the same server (NT Server) , when I change one to shared server, the users can’t connect to the other one. If

Re: undotbs01.dbf just keeps growing

2004-01-05 Thread Daniel Fink
Jared, It sure is nice to be missed. I'll make sure my secretary calls you about my future vacation plans...:) You've nailed the problem. Autoextend, automatic undo and high undo retention is a recipe for high disk usage. The aum algorithm is such that preference is given to extending over reuse

RE: sql trace - forward attribution

2004-01-05 Thread Anjo Kolk
Cursor 0 also happens in oracle due to session switching (multiple sessions in the same process), oracle apps uses that but it also could happen with certain other application servers (haven't investigated it). Anjo. -Original Message- Boris Dali Sent: Monday, January 05, 2004 3:59 PM

Re: Upgrade

2004-01-05 Thread Joe Testa
patch guide that comes with the patch set, for extended reading check out the migration guide, oracle docs or on technet.oracle.com joe Hamid Alavi wrote: Dear List, I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way to do this upgrade. If any body knows any url or hav

RE: **BLOCKED-BY-IHATESPAM** Upgrade

2004-01-05 Thread Freeman Robert - IL
Alavi, It amazes me Please read the Oracle8i Upgrade manual and you will know all you need to know. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 1/5/2004 11:24 AM Dear List, I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way to do th

RE: Upgrade

2004-01-05 Thread Goulet, Dick
Look on the Documentation CD for the upgrade manual. Safest way would be to 1) get a Linux box, 2) do a FULL DB export. 3) Create new DB on the Linux server & Import the data there. 4) Use the old NT box as a boat anchor or upgrade it to Linux. Dick Goulet Senior Oracle DBA Oracle Certified 8i

Upgrade

2004-01-05 Thread Hamid Alavi
Dear List, I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way to do this upgrade. If any body knows any url or have any kind of document it would be very helpful. Thanks & happy new year to all of you. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-

Upgrade your OCP

2004-01-05 Thread DENNIS WILLIAMS
Awhile back on this list someone asked whether someone with an Oracle 7 or 8 OCP could upgrade their certification directly to 9i. I don't recall that question receiving an answer. If you are interested, the Jan/Feb issue of ORACLE magazine (otn.oracle.com/oraclemagazine) has an article named Upgra

RE: stress testing

2004-01-05 Thread Poras, Henry R.
Good catch on the array. I never noticed that. Henry -Original Message- Jared Still Sent: Monday, January 05, 2004 10:59 AM To: Multiple recipients of list ORACLE-L The patch I refer to is one I made that didn't make it into the most recent version of yapppack. YP uses an array as in

XP SP2 beta is out

2004-01-05 Thread Boivin, Patrice J
See www.arstechnica.com for more info. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Bug with automatic undo management?

2004-01-05 Thread Goulet, Dick
Ryan, I agree with OTS. If you had dropped the rollback segment(s) before creating the object then you'd probably never have seen the error. I have found that SCN's do get cached by your session and sometimes don't get updated correctly. Therefore even though you had switched to undo

Re: rewrite group by query

2004-01-05 Thread Boris Dali
How about select * from (select tab1.*, count(a) over(partition by a) a_count from tab1) where a_count =1; ... would probably save you one pass over tab1. Thanks, Boris Dali. --- elain he <[EMAIL PROTECTED]> wrote: > Hi, > Does anyone have a better way of rewriting the > following query? I'm t

RE: sql trace - forward attribution

2004-01-05 Thread Cary Millsap
In-line... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Boris Dali

RE: stress testing

2004-01-05 Thread Jared Still
The patch I refer to is one I made that didn't make it into the most recent version of yapppack. YP uses an array as internal storage, and walks through it with a for i in 1..n loop. Since arrays are sparsely populated there is a fair chance of hitting an array element that does not exist. The

Re: Job question

2004-01-05 Thread Jared Still
I can answer that for you, as I had a discussion with them 2+ years ago. 2 reasons: * They don't pay nearly enough for a senior DBA. The job requirement is really for a junior, and the pay is probably OK for that position. * They lost 50% of their business last year, and unless they do somethin

RE: OFA document

2004-01-05 Thread Jesse, Rich
One of the things I really like about this doc is that it helps in the separation of software and the data more than the standard OFA does. I still prefer separate top-level dir for maximum safety, but it's close. :) Rich Rich Jesse System/Database Administrator [EMAIL

rewrite group by query

2004-01-05 Thread elain he
Hi, Does anyone have a better way of rewriting the following query? I'm trying to avoid querying the table, tab1 twice. select a, b from tab1 where a in (select a from tab1 group by a having count(*)=1); Thanks. elain _ Make your h

RE: sql trace - forward attribution

2004-01-05 Thread Boris Dali
Thanks, Cary. Could you elaborate what do you mean by "wait events associated with COMMIT processing"? Why does Oracle need this "exchange of messages" with the client (well, with the app server really in my case of a 3-tier deployment) to perform a commit? In any event, as I described earlier i

test - please ignore

2004-01-05 Thread Paula Winkler
  Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

RE: stress testing

2004-01-05 Thread Poras, Henry R.
John, Thanks for the tip. I've used sar and vmstat, but not in enough depth to have any preferences. So far I don't have permissions for sar at this site, but I should be able to get that. Henry -Original Message- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recip

RE: stress testing

2004-01-05 Thread Poras, Henry R.
Jared,   Are you talking about yapppack? I've been using that for a while (nice display. Though like statspack it is system wide so I usually just look for high level stuff and changes). Not aware of a patch though.   With most peoplesoft applications I have seen, the bottlenecks aren't dat

RMAN options (was: Deleting database)

2004-01-05 Thread QuijadaReina, Julio C
Title: Re: Deleting database Yechiel,   I am letting RMAN do that for me. I have several scripts that help me accomplish this.    The first one does a full export of production. This logical backup is just in case that I need to recreate my production database from s

RE: freebie. Summarize Oracle Listener logs

2004-01-05 Thread Hallas, John, Tech Dev
Sorry - meant to send just to Steve Please ignore -Original Message- Hallas, John, Tech Dev Sent: 05 January 2004 11:19 To: Multiple recipients of list ORACLE-L Steve, I have an awk script which does something similar - see code and example below However I can put your file on my s

RE: freebie. Summarize Oracle Listener logs

2004-01-05 Thread Hallas, John, Tech Dev
Steve, I have an awk script which does something similar - see code and example below However I can put your file on my site where I have already stored your Perl script for getting the DDL out of an export file ( www.hcresources.co.uk) if you wish. Cheers John Service :Host :User :tcp:i

Diff. execution plans

2004-01-05 Thread Vladimir Barac
Hello to everyone Info: - oracle 9.0.1.4 64bit on Solaris 8 - Sun Fire 15000 Here is the query select * from glcomponents where (glorder = 1 and compvalue in ( select glcomp02 from chartofaccounts where glaccount like '01-_-__-__-__-___-___%' and (disabled is null or disabled

Re: ORACLE-L Digest -- Volume 2004, Number 005 (Out of Office

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