Daniel,
I have just finished reading your document on UNdo Internals and Tims
"Cats, Dogs and ORA-1555s".
Thanks for the documents they were both great.
There is something I don't understand and I am not sure about it.
You have said below:
"When a transaction is bound to an undo segment, it a
ODTUG-JAVA-L Digest Fri, 15 Aug 2003 Volume 2003, Number 227
In This Issue:
Subject Author
---
RE: Duplicate record function"Aaron Haimovitz" <[
I am using sqlldr conventional path to load some data.
My understanding is that I cannot use direct path since my users require
access to the table at the same time as the load is in progress. Is this a
correct assumption?
The speed of the upload is slow, or I think so10,000 rows is taking
20-
Well, you know something on thisI am not saying that all Indians are the
best in their
business either. During the hey-days of dotcom companies and IT when anybody
who just
could compile a simple program or even less were hired out, I have seen guys
emigrating
from India to the US purely bas
yeah thats what i figured... but having these certifications are good for my career.
thanks. I figured it was a stupid question.
>
> From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 01:14:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP
No, it's got the word "professional" in it. We can't be using that
company or they'd be done under the trade descriptions act!
Craig Healey
> -Original Message-
> From: Stephen Lee
> Sent: 14 August 2003 20:15
>
> No no! Not EDS. That was Ed's. As in:
> "Ed's plumbing, welding, and dat
Hallo,
I would like to get a goood example on how to do this in a pl/sql block, maybe this
is too simple but I cant get it work.
I would like to do a select from table A, like this
select id from A
where id > 10
This sql statement gives me about 10 rows. I want those rows(the id) to be inse
ive found through repeated use that its faster to direct path load the data to a
staging table then do an insert /*+ append */ to move the data over to the master
table.
speed of inserts will depend on how many indexes you have.
however, since you are on 9i you dont need to use either. use an
Try external tables or checkout a good article written by Stephen Andert from this
list which was a review for Jonathan Gennick's sqlloader book
The link is http://www.oreillynet.com/pub/a/oreilly/oracle/news/oraclesqlload_0401.html
Key factors are bindsize and rows settings
John
-Original
Title: RE: Oracle World anyone?
I'll be there.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
We are pentium of Intel. Division is futile.
You will be approximated.
-Original Message-
From: Steve McClure [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 14, 2003 9:24 PM
To: Mu
Ryan,
I will
research the answer but I have an urgent question.
Do you
have SelfTest Software for the SQL and PL/SQL test or do you have the
Architecure and Administration SelfTest Software?
Thanks,
Ed
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On B
Since both tables can't be called A, I will use A and B:
You can do this without a cursor:
begin
insert into B select id from A where id > 10;
end;
/
HTH,
Mike
Hello Roland,
Supposing that you want to select from table A and insert into B /or any ather table/.
here is
a samll example :
DECLARE
TYPE id_type IS TABLE OF A.id%TYPE;
t_id id_type;
BEGIN
SELECT id
BULK COLLECT INTO t_id FROM A where id > 10 ;
FORAll id IN
Title: RE: OT -- Boston Globe job listings
can't resist this, although i may regret it ... but ...
i have seen exactly what samir describes here, with similar outcomes for those involved.
however, i worked at an overseas subsidiary of what became one of the biggest dot com failures. i
i have all of it or 8i. this question was in architecture. I havent looked at the sql
and pl/sql stuff since the cert test for that was a blowoff.
>
> From: "Ed Sherman" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 09:00:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Su
I'm doing some departed user cleanup and the 'drop user cascade' hangs
for 2 -3 minutes before completeing. I ran a 10046 trace and it does a lot
of waiting for 'library cache pin' - 100 times for 308 centiseconds each
time. Dropped two different users, 100 library cache pin waits per user.
I'll be there! And judging from all of the responses you've gotten,
looks like I'll finally get to meet some of my favorite posters from the
list.
Brian
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED] |
-
-Origina
Hi,
I'm fairly new to the
area of JDBC and Orcale but I was hoping some of you may be able to help me out
with this one. I may have the wrong list as its a Java related question. If so
could someone please direct me to the correct list.
I'm trying to write a large file into a BLOB
co
1. Maybe,
maybe not. To make a point, take it to a ridiculous extreme: Suppose you
have a tablespace of 100M with two rollback segments made of 1M extents
sizes. Then each segment must use 2M each (minextents must be at least 2)
which means either segment could possibly grow to use 98M
Stephen,
Tim's statement is correct, but can be construed incorrectly if you read it and think
of TEMP segments. AUM still uses undo segments (same basic structure as rollback
segments). However, one of the space management steps is to allow an undo segment to
'steal' extents from another undo
Daniel, that make sense , thanks.
Stephen Hodgkinson
Oracle DBA
Total Gas & Power Ltd
Phone: 01737 27 5564
[EMAIL PROTECTED]
Allan, the world is changing rapidly and what we are faced with is nothing
less
then a complete failure of all social systems. The problem is that we need
less
human work then ever before. ATM's, industrial robots, smart farming
machines, internet
(how many shop attendants in bookstores have lost
A lot of those multiple choice question are best approached from a reverse
standpoint, much like a lot of my recent election experiences. You look at
the choices and cross out the ones which are definitely not it until you
whittled it down to the number of supposedly correct choices you need. If
Ryan
I have found the actual OCP questions to be clearer. I think it is very
hard to develop a good multiple choice exam. And these are tricky because
the objective is to test more than simple memorization. You need to
administer it to many people and find out which questions aren't clear or
are
Was a low cache hit ratio the only 'problem'?
Were jobs taking longer than normal?
Were users complaining of a slow system?
Did your average response time shoot up dramatically?
I'm afraid you may have succumbed to the dreaded disease,
CTD, or Compulsive Tuning Disorder.
This is the urge to tw
Robert,
If someone here knows the answer, they'll be glad to help you.
This list tends to be made up mostly of DBA types, or at least
centers mostly on DBA type topics, though some of us take
pleasure in telling developers how to do their jobs.
You might try one of the ODTUG lists. You can fi
that's rite . But what if you want to change something in param file for
this db .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 14, 2003 4:44 PM
> Hi!
>
> But it really doesn't matter much, which init file was used duri
Ah, the Sherlock Holmes method. I've often used the same method
on multiple choice tests with meaningless questions and obscure
answers.
"When you have eliminated the impossible, whatever remains, however
improbable, must be the truth"
I think this is how I passed the Oracle 7 Beta tests, which
Sorry Steve, I'm saving my money for HOTSOS and IOUG.
Would love to of gone just get a chance to meet friends
and eat in SF restaurants.
The timing is bad anyway, as it's right during my vacation,
and I intend to spend that doing non-work related stuff.
I even had a free pass.
Jared
On Thu,
Title: Redo Logs - Raid 1 or No Raid
Hello all
Oracle 8.1.7
Windoze 2000
Archive Mode - OLTP System
Which do you think is a better set up for the Redo Logs:
2 Groups on 2 Raid1 or 4 Groups on 4 separate non-raid disks?
Granted you gain fault tolerance with the mirriored pair, but
Then you'll go to the script which starts up the database and find out which
init.ora is used during next startup. And if the location not explicitly
set, you just edit the $OH/dbs/initSID.ora
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent
Any listers (when you have time) who were effected the Great Blackout of
2003 please share your experiences. UPS, Y2K backup generators fired up,
scramble to shutdown, communication issues etc... It would be good to hear
how folks handled the situation for future reference.
Brad O.
--
Please see
Title: Redo Logs - Raid 1 or No Raid
Hi!
If your system isnt very transaction active and
you want simplicity, then just go with one set or RAID-1 (2 disks) and put
all your groups onto this set. (no multiplexing). And use other 2 disks
elsewhere.
But if you have high transaction activity
Title: RE: GREAT SCOTT!! 1.21 GIGAWATTS!!
All our production databases stayed up ... people lost connection to one building, but all servers in RAC stayed up including network switches etc in the data centers.
Raj
---
Title: Message
If
there is a part of oracle database that you want protected at all times,
that part would be redo logs.
I love
my redo logs as they can help me to recover the database, if needed. If you go
on 4 non-RAID disks,
make
sure that each group has at least 2 members. The more gro
Hi Jared
I have reset to previous value and restarted the database anyway. Since I
have 8G Memory and I may set SGA more than 3G. Actually I did at our AIX
SP that set SGA total up to 5G of 8G memory.
Anyway I found a solution on metalink ( Note 115753.1 and 1028623.6. ) to
set SGA to higher.
Your subject line looks like a quote from "Back to the Future".
>From the perspective of (a) being in Dallas, and (b) having all our
database servers in hardened collocations with redundant onsite
generators, my experience was pretty much having a few beers. I felt
spiritually obligated to follow
I'll be presenting there.
Come see me on Monday for 9i goodies that aren't so
well known as some of the other more heavily marketed
features.
Its also a chance to see someone try get through 100
plus slides in an hour without taking a breath. Only
got to 98 last year at UKOUG so I'm keen to brea
Jared et al,
I was just told by my new boss that
I have to have any requests for any conferences/shows in by Sept. 5th (his
budget deadline). It's been years since I worked for a company that would
pay for me to go anywhere, so, for 2004, what would you (or others on the
list) recommend? It'd pro
Hello All,
We are upgrading the database from version 8.1.7.3 to 8.1.7.4. What if the Upgrade
fails ( I did it couple of times , but never failed for me), How to recover to
previous version??
Here is what I think , please correct me and add some more points here.
1. Backup the $ORACLE_HOME for
I can make a reservation at Chevy's again this year. We should cover the
rules on paying the tab, though.
For large groups, Chevy's requires 1 tab.
That means no one should leave the party without putting a reasonable
estimate of their part of the tab into the pot (including drinks) in cash.
No
> It's situations like this that make me love collocations. We basically
> get to be part of a co-op that pays someone else to worry about power,
> fire and physical security.
Sorry, I'm not a native english speaker, but what the heck does collocation
mean?
Tanel.
--
Please see the official OR
We had 45 minutes on our UPS which handles our
routers, switches, firewall, phone system, 1 RS6000
(dual processor), and 5 Windows 2000 servers.
We waited 10 minutes to find out what was going on,
all the while shutting down non-essential servers.
Then we proceeded to perform a graceful shutdown o
Title: RE: Oracle World anyone?
chevy's was good the previous time(s). but I happened to be part of the group that was left with a larger than normal "tab".. But, we'll find a "bouncer" and have them be the gate keeper for the cash:-)
greg
-Original Message-
From: Molina, Gerardo [m
Tanel,
A "co-location" site is a service provider that sells space to companies for
their systems so one large physical site could be hosting the servers of
dozens and dozens of companies. Picture one really huge computer room filled
with rows of cages and each cage houses servers for one compan
Paul this question rolls around every once in a while:
to summarize:
dog/pony shows, new features( the theory ) boatloads of people: go
to openworld
realistic implementation of new features, truths behind the marketing
hype, less people but alot more interesting group: go to IOUG
conferen
Connor,
So will those 9i goodies be available to those of us that are not going to make it???
Everyone seems to agree that the economy is starting to rebound except when you ask
for training funds
-Original Message-
Connor McDonald
Sent: Friday, August 15, 2003 12:34 PM
To: Multiple
I have a coordinator package that is going to run alot of long running batch processes
through dbms_job. Could be as many as 300 of them. I know to set my
job_queue_processes = 36.
however, I want to 'wait' until all of these are done. My concern is with concurrency.
here is pseudo code:
max
I just returned from the Hotsos Clinic, so that is a big MUST ATTEND
In terms of shows/conferences, #1 will be the Hotsos Symposium in March.
(www.hotsos.com). If I have to choose between this and IOUG, Hotsos wins hands down.
My #2 is RMOUG Training Days (www.rmoug.org) in February. It is he
Mitchell,
Which portion of the statspack report suggests increasing the cache size?
Maybe you could post that portion here.
The cause for poor performance needs to be located and corrected.
What are the user complaints specifically?
Have you checked to see where your system is spending its t
Hi Jared
This is the website http://www.oraperf.com/ . If you upload your
report ( utilb or statpack) , they will give you good suggestion.
Try and you will find it.
Mitchell
- Original Message -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECT
Hi!
In Europe, Tom Kyte is going to be in Denmark in
Jan 2004 :)
Check http://miracleas.dk/en/events.html#MasterClass
But yes, IMO the hottest courses delivered by
Oracle Education are the Data Server Internals series.
Tanel.
- Original Message -
From:
[EMAIL PROTECTED
Have you seen this before
15-AUG-2003 12:10:34 *
(CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=service_mts)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-
What's with all this performance stuff? This is a matter of principle. The
man paid for 8 Gig of memory, and BY GOD, the man ought to be about to use
his 8 Gig of memory!
-Original Message-
col event format a35 head 'EVENT NAME'
col total_waits format 999,999,999 head "TOTAL|WAITS"
c
Title: RE: using dbms_alert to manage multiple processes
Will all processes signal one named alert or a process specific alert? If it is one alert then keep counting as you receive, if they are individually named alerts, keep a local pl/sql table and mark as you receive them. When you have ale
Madhu,
Can you ping the host?
BTW, please use '!'s sparingly - I couldn't help but noticed that most of your message
carry a few. They should be used for emergencies not just attention grabbers.
Dennis
-Original Message-
Sent: Friday, August 15, 2003 1:14 PM
To: Multiple recipients of l
check listener.ora and the hostname of the box for resoltution problems.
-Original Message-
Sent: Friday, August 15, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Have you seen this before
15-AUG-2003 12:10:34 *
(CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB
Index tablespace has the most wasted space and yes, there are several
indices in those tablespaces. I need to keep it available or I'd just
drop and recreate the entire index.
good to know I wasn't hallucinating!
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Rachel - Right you are, as "Stop D
Madhu,
If you are sure you are starting all the listeners, not just the default
listener but named listeners as well (if any). I would look into the
HPUX error next. What is file or directory is it looking for? I would
examine the listener.ora closely and verify that the logging/tracing
directori
Tanel,
Could you please let me know where I can find info. about this data server
internal course ?
thanks,
> -Original Message-
> From: Tanel Poder [SMTP:[EMAIL PROTECTED]
> Sent: Friday, August 15, 2003 1:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Wor
The user probably has code objects (stored proc/pkgs) as well owns tables
which are being replicated elsewhere? The lib cache pins can be explained by
the need to lock/pin affected objects in the shared pool for invalidation.
These objects are code owned by the user or are referring the objects own
thanks. Im running the following test code from two different sessions. Odd thing is
when I run the signal routine once nothing happens. However, when i run it the second
time, my waiting routine executes on it?
I run this first:
declare
vname varchar2(10) := 'myalert';
vmessage varchar2(
Several possibilities:
The host you specified in listener.ora does not exist or your machine is
unable
to recognize it. That usually happens when hosts are known under many
nicknames
and, of course, the host recognizes only some of them.
You are trying to resolve the hostname by using a name se
Hello,
While user OPS$ORAQA2 running:
ANALYZE TABLE "SAPR3"."BSIS" COMPUTE STATISTICS FOR TABLE FOR ALL INDEXED COLUMNS SIZE
1 FOR ALL INDEXES
I had the following error:
SQL error -1652 at location stats_tab_collect-4
ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM
i always did like that about the internet, i can telnet to 127.0.0.1 on
ANY server and it knows my userid/passwd, total awesome.
joe
Mladen Gogala wrote:
Several possibilities:
The host you specified in listener.ora does not exist or your machine is
unable
to recognize it. That usually happen
Yeah, that host is always reachable. As for the telnet, I don't run that
thingy any more. It's ssh localhost, not telnet localhost. Telnet is
politically
incorect.
--
Mladen Gogala
Oracle DBA
-Original Message-
Testa
Sent: Friday, August 15, 2003 3:59 PM
To: Multiple recipients of list
very true and telnet service is usually disabled but localhost it just
doesn't have the confusion for the newbies as 127.0.0.1 does
joe
Mladen Gogala wrote:
Yeah, that host is always reachable. As for the telnet, I don't run that
thingy any more. It's ssh localhost, not telnet localhost. Telnet
Not on ANY server. MANY, perhaps, but not ANY. Doesn't work for our HP/UX
11.0 servers here, nor my RH7.2/RH8.0 boxes at home.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> -Original Message-
Let me rephrase it: it works on any machine which has telnet service up and
running in shape or form,
even on Windoze.
--
Mladen Gogala
Oracle DBA
-Original Message-
Jesse, Rich
Sent: Friday, August 15, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Not on ANY server. MANY, p
I need to export the data from an Oracle 8.1.7 database HPUX 64 and
import it back into an old 7.3.4 HPUX 32 database.
The 7.3.4 import doesn't like the 8.1.7 export file.
Any ideas?
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: [EMA
Ron
You could try getting the 7.3.4 export to run against the 8.1.7 database.
I don't know if the 32 vs 64 bit would affect you. Also, datafile formats
changed between Oracle 7 and 8 and I haven't tried this particular export.
Maybe somebody on the list has.
Dennis Williams
DBA, 80%OCP, 100% D
The only time I have seen this is when the server process could not be
started because the database shared segment did not exist or an
executable that was pointed to in the TNS entry actually did not exist.
HP-UX error 2 is file not found so I think you are looking at the later
case. It looks very
What does this query return?
select username, default_tablespace, temporary_tablespace
from dba_users
where username like 'OPS$%' or username = 'SAPR3'
Jared
"Roger Xu" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/15/2003 12:34 PM
Please respond to ORACLE-L
To:
"Smith, Ron L." wrote:
>
> I need to export the data from an Oracle 8.1.7 database HPUX 64 and
> import it back into an old 7.3.4 HPUX 32 database.
> The 7.3.4 import doesn't like the 8.1.7 export file.
>
> Any ideas?
>
> Ron Smith
I am unsure whether a 7.3.4 client can talk to a 8.1.7 databas
USERNAME DEFAULT_TABLESP
TEMPORARY_TABLE--- ---
---SAPR3
PSAPUSER1D
PSAPTEMPOPS$ORAQA2
SYSTEM
PSAPTEMPOPS$QA2ADM
SYSTEM
PSAPTEMP
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Ron,
Something I forgot and which Dennis' remark about format reminded me
of :
You'll probably have to run $ORACLE_HOME/rdbms/admin/catexp7.sql againts
your 8.1.7 database before you can use the Oracle7 exp against it (and
run catexp again once you're done). File formats should be OK if your
.dm
If 8.1.7 is production, then I would use selects, sql loader. If you are
REAL industrious, you can try exp with 8.1.7 exp, then imp with show=y to
generate a big nasty mess of text that you can try whipping up on with sed
and/or awk to clean up.
If 8.1.7 is a slam and bang around database, it mi
You need to change the default tablespace for those OPS$ users
alter user OPS$ORAQA2 default tablespace PSAPUSER1D;
and
alter user OPS$QA2ADM default tablespace PSAPUSER1D;
should do it.
The only user that should have the SYSTEM tablespace as a
default is the SYS user. All others should be s
Even if the default tablespace for user is other than 'SYSTEM' question is :
Where does the data from anlyze go? To some catalog table? What you can do is :
1) Check if 'SYSTEM' has any other user non-system/sys user objects. Move them away. I do not know if moving system objects out of 'system
Raju is right, it's late on a Friday, I had a brain fart.
This will tell you if you have other objects in your system tablespace.
select owner, 'TABLE' object_type, table_name
from
dba_tables
where owner not in ('SYS','MDSYS','OUTLN','WMSYS','SYSTEM','ORDSYS')
and tablespace_name = 'SYSTEM'
uni
Is there any way to get Oracle 8i (or 9i; we're planning to upgrade)
Enterprise Edition to authenticate against Active Directory, short of
buying Oracle Advanced Security?
My goal is to remove the need to maintain a separate database of
passwords. Ideally, we could do also do away with having t
I found I create a user and forgot to set tablespace. So it uses
the SYSTEM tablespace. Now I wonder if this is feasible:
1)use exp to export that schema,
2) drop schema,
3) recreate user/schema with another tablespace
4) imp data back
Can I have all data stored in the new tablespace?
Thanks,
--
Just one more step :
Before you import. You also have to reduce or make zero the quota of this user on 'system' tablespace. I do not know if zero works. and make sure the user does not have 'unlimited tablespace' priv implicitly or explicitly , either directly or thru a role.
Because when you i
I was playing around with org charts yesterday, and came up with a function
to use for drawing org charts with lines from sqlplus.
This has probably been done before, but I couldn't seem to find one via google.
The output from scott.emp looks like:
select
org_chart_line(level-1,3) || ename
f
Dang
!! and I thought micro$oft org chart had no competition ...
Thanks
Raj
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 9:04
PMTo: Multiple recipients of list ORACLE-LSubject: Org
chartsI was playing
around with org
The Hotsos Clinic 101 is better the 2nd time around, especially with a
spiral bound draft copy of Cary Milsap's forthcoming "Bugs" (actually
Yellow Jackets) book.
RMOUG is close to home so I have already marked my calendar with
February 11-12, 2004 for Training Days.
After attending the 1st Ho
86 matches
Mail list logo