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
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
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
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
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
>
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
---
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
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
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
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
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
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
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
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
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.
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
Hello everybody
Im trying to change the Oracle 8i Dedicated Server to Shared
(I dont 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 cant connect to the other one. If
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
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
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
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
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
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-
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
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
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
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
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
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
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
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
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
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
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
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
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
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
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
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
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
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
--
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
--
60 matches
Mail list logo