Hi
List,
Can someone give a SQL query to retuen all values in paricular column in comma
separed format.
e.g. suppose I
fire "select deptno from dept" the output would be like
Deptno
10
20
30
40
I want the output
like 10,20,30,40.
I am just
wondering can it be done in a single query.
Heh,
never claimed it was a good idea, just that it's possible =)
Mike
-Original Message-
Sent: Monday, April 29, 2002 7:33 PM
To: Multiple recipients of list ORACLE-L
On Mon, Apr 29, 2002 at 09:29:31AM -0800, Hately Mike wrote:
create tablespace disks_and index
datafile
It cannot. You have to write a PL/SQL function which returns a VARCHAR for that.
- Original Message -
From: kranti pushkarna
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 29 Apr 2002 23:48:20
Hi List,
Can someone give a SQL query to
I think Oracle9i went into GA, on a limited set of platforms, in June 2001.
The 9i beta program hadn't even started two years ago. Anyone with two
years experience with it was likely on the Oracle development team. The
requirement probably came from some HR person who simply adds requires
two
Saw some basic demo's at a BMC/Simulus seminar
revealed that compiled units were certainly faster
than their interpreted counterparts - I can't remember
off hand but it was in the order of 20-30% maybe? Of
course, typically the main performance problems with
PL/SQL are:
a) poor SQL within the
$ cp dumpfile /dev/rmt0
--
From: Raghu Kota[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 11:48 PM
To: Multiple recipients of list ORACLE-L
Subject: export to tape!!
Hi Friends,
I need to export some 40
Yup - its compiled into (if I recall correctly)
p-code which is a tokenized and optimized version of
the source. You can see a number of IDL prefixed
tables under SYS which contain the compiled code.
You'll see the term DIANA floating about which is
related to this as well.
hth
connor
---
Saw some basic demo's at a BMC/Simulus seminar
revealed that compiled units were certainly faster
than their interpreted counterparts - I can't
remember
off hand but it was in the order of 20-30% maybe?
Of
course, typically the main performance problems
with
PL/SQL are:
a) poor SQL within the
virus info.html
Sandeep Kurliye
Certified Oracle DBA
Almoayyed International Group
Almoayyed Computers,
PO Box 26259, Manama, Bahrain.
Ph. 973-700777 Fax.973-701211
Email. [EMAIL PROTECTED]
Title: McAfee - AVERT
Buy Products
Try Products
Download Updates
Don't forget
ALTER MOTHER SET BREAST_FEED_MODE=TRUE
Dave
-Original Message-
Sent: Monday, April 29, 2002 7:33 PM
To: Multiple recipients of list ORACLE-L
Alter Mother Set Morhpine_Level = 10;
Alter Mother Have_Baby_Now = TRUE;
Alter Father Learn_To_Change_Diapers = TRUE;
Hi,
Thanks to all those who replied. Just clearing the structure.
I have Hp LVM and the tables and indexes are on different tablespaces and
different disks .
Since the growth pattern has changed drastically , the no of extents have
increased tremendously . Hence the need to
rebuild the
Are you working with toad version 7.2?
I compared 2 schemas and got a complete list of differences.
Right click on the difference and you get the SQL to implement it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April
HELP
-Original Message-
Sent: Tuesday, April 30, 2002 5:48 AM
To: Multiple recipients of list ORACLE-L
virus info.html
Sandeep Kurliye
Certified Oracle DBA
Almoayyed International Group
Almoayyed Computers,
PO Box 26259, Manama, Bahrain.
Ph. 973-700777 Fax.973-701211
Email. [EMAIL
Thank you so much mike!! I find it the same from asktom web site!! But If I
want to restore different tables from the same export,should I able to do
that??
From: Hately Mike [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE:
Oh Shreepad, you've opened another can of worms there. =)
You shouldn't see any performance difference between 1 extent and 5 extents
or more.
The best option for extent sizing in my opinion is to keep all extents
within a tablespace the same size. This increases the manageability of the
Tim,
Thank you for your reply.
There are two issues that I cannot use pipe. One is two databases are in two
different isolated network. Second is we need the flat files for archives.
BTW, whenever we
can use PIPE, we can use database link. Is it right?
I understand that SQLPlus is just a
Hmm - this seems to be a particularly powerful and dangerous infection, three
times more powerful than the 'standard'. Luckily, the 'V-word' virus causes no
damage other than slightly clogging up mailboxes. The fact that this example
uses the word 3 times would make it particularly bad, but
Shreepad,
There is no problem with a segment having more than 1 extent. It is a common
misconception (another of those Myths, if you please) that all tables and
indexes should reside in 1 extent, or less than 10 extents even. There is a
paper available from the web - that many say is the
This may be my favorite Oracle 8i bugs (and no, I don't have the bug#s.)
Performing a sort sometimes causes wildly inefficient execution plans.
I'm guessing that if you run the explain plans for the query without the
DISTINCT and with the DISTINCT you will get completely different results. If
Stephane,
pdqout does give me a real good impression, not only the speed but also the
interface. I can see it uses parallel query. However, I, as a production
DBA, intend to change the application which come from a third party as a
package as small as possible. It takes 4hours to extract data at
Title: Database Metrics
Hello Yuval Arnon
I will use three graphs:
1) Number of SQL statements executed per
day.
2) Mean response time.
2) CPU usage per day.
In both cases add a reference point that is the
mean of the last 30-40 days
so they can see any abnormal behavior.
The space
Do you know how to see the threads in NT?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 8:24 PM
oracle.exe spawns out threads, which you will not see running in the task
manager.
Each DBWR process
Use non-Windoze workstation!
JP
On Tue 30. April 2002 13:33, you wrote:
HELP
-Original Message-
Sent: Tuesday, April 30, 2002 5:48 AM
To: Multiple recipients of list ORACLE-L
virus info.html
Sandeep Kurliye
Certified Oracle DBA
Almoayyed International Group
Almoayyed
Can anyone please recommend/advise on NT/W2K compliant solutions which can
generate ERD's by interogating the DB.
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
This message,
Are you an idiot?
:-)
On Tue 30. April 2002 13:33, you wrote:
HELP
-Original Message-
Sent: Tuesday, April 30, 2002 5:48 AM
To: Multiple recipients of list ORACLE-L
virus info.html
Sandeep Kurliye
Certified Oracle DBA
Almoayyed International Group
Almoayyed Computers,
PO
Title: RE: ERD generation tool
When I was in an NT shop, we used Visio (I know...I know), but given that I was not architecting at the time, I can't compare with the Erwin that I am using now.
I remember at the time though, the ERDs created using Visio were accurate for what we were doing
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without touching Oracle 8i?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Dave,
Thanks for the good article. I am trying for two separate instances on the
same box, 8i and 9i. I am not installing anything just adding 9i.
Thanks
Rick
Both Designer and ERwin can reverse engineer enough information from an
existing
database to generate an ERD.
Cherie Machler
Oracle DBA
Gelco Information Network
I'd say Tim is stuck in Buddhist nondoing-ness
while simultaneously missing the point (It's the
SageLogix server, STOOPID) and calling the kettle
black (don't call me names from your playbook; instead
denigrate via condecension and superciliousness)
Brown? Maybe this guy needs a good, relaxing
Yes, there is ERWin. You load the sql*plus scripts into it and it will then
re-engineer the diagrams.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 7:24 AM
Can anyone please recommend/advise on NT/W2K
Reposting as I forgot to include a subject line on previous post.
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without touching Oracle 8i?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
BM? Bone massage? ROTFL
-Original Message-
Sent: 30 April 2002 14:13
To: Multiple recipients of list ORACLE-L
A
I'd say Tim is stuck in Buddhist nondoing-ness
while simultaneously missing the point (It's the
SageLogix server, STOOPID) and calling the kettle
black (don't call me names
There Should Be No Problems in this.
Run the Universal Installer and Go to nstalled Products and Remove 9i.
That should do the trick.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
[EMAIL PROTECTED] wrote:
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without touching Oracle 8i?
Thanks
Rick
how about reading the documentation that came with the damn software?
--
--
Bill Shrek Thater
Jeremiah,
Thanks for the informative description of the spawning process.
The operational manual is not to be found and the instructions are
written in an unknown language.
Ron
ROR mô¿ôm
[EMAIL PROTECTED] 04/29/02 05:53PM
RTFM.
http://www.bcpl.net/~rgarriqu/babyman.html
--
Jeremiah Wilton
Lisa,
What you said about Atlanta and the New York of the south is correct
in my opinion.
12 years ago it was different when I moved here from Conn. The cost of
housing has doubled and the cost of the produce has caught the Conn.
prices for food staples. Granted the cost of gasoline is cheaper
9i on XP Prof. on DELL PC (no network)
I tried to use DBCA to create a DB on my PC.I have never
used this tool before. It appeared to run OK with no errors.
However, when I query the V$ views I don't see it and I cannot connect to
it. I ran DBCA twice to create the DB and the second time I
Rick,
how about using the installer?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, April 30, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Reposting as I forgot to include a subject line on previous post.
I have Oracle 8i with 4 instances
http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
What platform are you working on? Windows or Unix?
-Joe
--- [EMAIL PROTECTED] wrote:
Reposting as I forgot to include a subject line on previous post.
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without touching Oracle 8i?
ERWin www.ca.com
ERStudio www.embarcadero.com
Active Designer http://www.iraje.com/ad_fsmain.htm
HTH
Mark
-Original Message-
Sean
Sent: 30 April 2002 13:24
To: Multiple recipients of list ORACLE-L
Can anyone please recommend/advise on NT/W2K compliant solutions which can
generate
Greetings,
If I remember correctly after the install of Oracle 8i, we can delete some of the
files(*O and *o) from some directory under $ORACLE_HOME. Probably from
$ORACLE_HOME/bin or $ORACLE_HOME/lib or some directory.
Could you please confirm this and is there any white paper or any
On Tue 30. April 2002 15:33, you wrote:
[EMAIL PROTECTED] wrote:
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without touching Oracle 8i?
Thanks
Rick
how about reading the documentation that came with the damn software?
Lisa,
It is both true false at the same time. Obviously any anonymous blocks
you submit to the database are fully interpreted. PL/SQL that you store in the
database as procedures, functions, and packages get partially compiled into a
p-code. This makes the code ready for execution, but
Nt 4.0
Rick
Joe Raube
jraube@yahooTo:
Unfortunately there are duplicates so they do need the distinct clause. I
have tried several permutations of the query and distinct clauses including
the most popular alternative:
select distinct wrecks
from
(select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||'
Hi
I
don't use dbca, but did it even create the data dictionary ?
Run
catalog.sql and catproc.sql (and whatever you need) to create it
manually.
Regards,
Stefan
-Ursprüngliche Nachricht-Von: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Gesendet: Dienstag, 30. April 2002
I assume you're talking about the dbassist tool.
If it's working as on unix, you should find the log
files in $ORACLE_BASE/admin/$ORACLE_SID/create.
I prefer the old way, using scripts, this way I can
rerun the scripts for all the different
environnements.
HTH
--- KENNETH JANUSZ [EMAIL
Tom,
I started with using the installer. It appears it installed Oracle
software. Of course this does nothing with the registry,services,etc. When
I go back into
installer it still shows some 9i installed. When I try to uninstall it
insist on un-installing some oracle 8i software. I have been
Universal Installer can do this for you. Click the deinstall software button.
I've done this a million times(over exaggeration) on both Unix and NT.
ltiu
On Tuesday 30 April 2002 07:13, you wrote:
On Tue 30. April 2002 15:33, you wrote:
[EMAIL PROTECTED] wrote:
I have Oracle 8i with 4
Sean - Does your schema have all relationships like foreign keys defined?
Otherwise you just end up with a bunch of disconnected boxes. Hardly worth
the trouble.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 30, 2002 9:04 AM
To: Multiple
Having seen a number of people come to grief because they tried to delete
unnecessary files, I have a bad feeling about this one. I can't imagine
that space on a server where you've installed Oracle is so tight that this
is necessary. Disk is so cheap today. Good grief, what happens if you need
I have been reading/searching the DAMN documentation like I always do
before posting a question. It is frustrating enough to get this to
work correctly. I do not need this type of reply so keep it to yourself.
All it does is add to the frustration. I greatly appreciate the
constructive
help I
Stephane,
pdqout does give me a real good impression, not
only the speed but also the
interface. I can see it uses parallel query.
However, I, as a production
DBA, intend to change the application which come
from a third party as a
package as small as possible. It takes 4hours to
extract data
Ross,
Please pay more attention to which list you are sending posts to.
Jared
On Tuesday 30 April 2002 06:13, Mohan, Ross wrote:
I'd say Tim is stuck in Buddhist nondoing-ness
while simultaneously missing the point (It's the
SageLogix server, STOOPID) and calling the kettle
black (don't
Hi all,
I need to insert special charecter into the database through sql loader.
i.e., I have a table with LONG datatype field and data should read:
[Cancellation]
IF ServiceDate = sysdate THEN
Chargepercent(100)
ELSEIF ServiceDate sydate THEN
Lisa - Its all relative, FL may not be as cheap as MN, but it sure is cheaper than NY
:-). Never again, would I live in NY, but don't ask my wife (she misses her roots).
[EMAIL PROTECTED] 04/29/02 04:48PM
I have been told that Atlanta is the New York of the south. The cost of
living in
Bill,
It isn't necessary to resort to this.
Just press DELETE if you don't like it.
Jared
On Tuesday 30 April 2002 06:33, bill thater wrote:
[EMAIL PROTECTED] wrote:
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without
Hi
how about Java within Oracle. What do you think about it ?
When does it make sense to use Java instead of PL/SQL ?
The problem is that I dislike a mix of different languages
within an application. It messes things up.
But maybe it makes sense to use PL/SQL for most stuff and
Java for some
The destination address you specified for your message could not be
reached because of a locking problem. Your message is being returned to
you so that you can resend it if you desire. The locking problem should
be resolved within a few minutes. Sorry for the inconvenience.
geez... have a
Hi Rick,
I would first shut down the 9i versions of the services for
any database, listeners, intelligent agents, etc.
Then using the installer I would deinstall all 9i software.
Then using regedt32 I would remove the home key for
the Oracle9i home.
That should just about do it.
John
Thanks Thomas.
Jared
On Monday 29 April 2002 14:53, Thomas Day wrote:
This message bounced back to me as undeliverable. Just in case it got
through, the 3rd link was bad and I have replaced it with the correct URL.
I had copies still on my hard drive so I uploaded them. I emphasize that
- Original Message -
From: Shaw John-P55297 [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 30 Apr 2002 06:13:42
Unfortunately there are duplicates so they do need
the distinct clause. I
have tried several permutations of the query and
distinct
here's one for the partitioning gurus out there
I have an INVOICE table that I want to partition for performance and
purging. The way I want to partition it is to do range partitioning on the
INVOICE_STATE column, then sub-partition some of the partitions by
UPDATE_DATE.
The logic behind
How about sending it just ONCE ???
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 3:33 PM
[EMAIL PROTECTED] wrote:
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of
Stefen:
I have to apologize, I goofed. In dbca the final wizard
window has an OK button at the bottom. It was below my lower screen edge
and I didn't see it. So, I didn't press it and of course didn't create the
DB. On my third time through the process I noticed this button, pressed it
and
RANT
This has all been tried before, and the predictions are the
same: financial nirvana, big savings in technology costs,
no pesky holier-than-thou DBA's baffling poor damagers
with stuff they can't possibly understand.
/RANT
Very few executive, managers or DBA's are going to want
to place
Hi Ken,
When you run the database configuration assistant (DBCA) it asks you to
provide the sid for the database. You should be able to see the service
associated with this database by looking at the "services". Don't know ANY
XP but the service should be named "OracleServiceSID". Check to
This is something that's been debated on the list in the past. The general
consensus was:
For manipulating data in the database, nothing beats pl/sql. It is well
suited for this purpose.
For everything else, java could beat it.
I am sure fellow list members will post links describing
My daughter works for a large retailer here in Minneapolis, MN. They got
one of these big outfits that promised them the moon, etc. The companies
initials are IBwhatever. Guess who the call when they can't figure out
something? The IS staff. Big deal!
Ken Janusz, CPIM
- Original
Jared,
The other problem with outsourcing, which we've run head on into, is that an
ASP wants you to run the application plain vanilla. Customization of an
application to fit your business/needs is one area they really do not like to
handle. Makes upgrading a pain in the *^, which means
Jared,
Sorryjust did a reply all to what I thought was a private conversation.
Guess we all have to pay attention to who/what is in the address list!
Cheers,
-- Ross
-Original Message-
Sent: Tuesday, April 30, 2002 9:55 AM
To: [EMAIL PROTECTED]; Mohan, Ross
A
Ross,
Please
Hi
Oracle forms is time delay sensitive?
Delay sensitive traffic is stuff like video or voice traffic.
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
Please see the official
We have been having some heavy discussions about
system failures, root cause analysis and developing
some proactive metrics. Generally, our problems
revolve around frequently late nights for the On Call
DBA because something out of our control goes wrong.
The damagement folks want to fix the
Several things. One, you can indicate (RTFM, don't remember the details) that your
physical record is terminated by something else than a carriage return. Second, if
what you want to store is PL/SQL code, then carriage returns are useless - they are
'for your eyes only' (which is why you have
Lisa,
You are right about the debate between PL/SQL Java (or anything else
outside of the db).
In my mind, the deciding factor (and something that is *never* mentioned) is
what programming langauage the organization is satisfied with/settled upon.
In my little opinion, *any* programmer can
FYI, Oracle Canada is supposedly putting instructions together for me on how
to secure iAS on NT, that should be interesting.
Waiting patiently.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services
Check memory on your server, you need to have enough physical RAM to hold
your SGA and the Oracle processes.
The services applet lies, sometimes it will say that a database NT service
is running when in fact it is in a half-opened state. An easy way to test is
to connect from the command line
My browser says page not found.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO |
Peter - I can see your desires going in two directions:
1. Operational procedures - Things like how do I know I'm running out of
disk space before I've run out.
2. Change management. Most failures come from changes to the software. Like
somebody adds some programs and that affects other
Thanks for the links.
We are now in the process of tuning a database, on NT, without any option
to change the application code (3rd party).
I downloaded the docs and hope they will help me.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Hi Robert,
When I signed on at cybersurf the webserver (apache/perl/DBI) was
handling 500 - 900 clients at any one time and the listener process
took the most CPU as defined by top. The database server was pinned
and everything was failing.
By adding mod-perl to the mix (for caching
Good points all.
Reminds me of Larry E's statement last year that businesses
should be run the way the software works: no customizations.
Can you see why he said that? :)
Oracle corp knows best.
Jared
On Tuesday 30 April 2002 07:58, [EMAIL PROTECTED] wrote:
Jared,
The other problem
Hello Rick
I think that you should start with DBCA and remove
your 9i DB
and then follow the steps in John
letter.
Yechiel Adar
Mehish
- Original Message -
From:
Ora NT
DBA
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 30, 2002 4:59
PM
Hi.
I'm running oracle 817 on Numa-Q Dynix 4.5.2.
Everything seems to be OK - the database is up,
listener is up, connectivity is OK. But when I run
oiconnect /@instance it coredumps. No Oracle errors or
anything is on the screen. What could be the problem?
thanks
Gene
Thanks for the idea - however the alternative you suggested actually ran
slower.
It's seems to be the size of the distinct sort.
-Original Message-
Sent: Tuesday, April 30, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
- Original Message -
From: Shaw John-P55297
Kevin - This sounds similar to a partitioning issue that I was able to
resolve. My suggestion is to consider partitioning on a concatenated key,
INVOICE_STATE, UPDATE_DATE. You'll have to play with it, the partitions
don't work the way you think they do. As I recall, if you say less than
'AL',
I have installed it. I got the code and the documentation via a tar. They
then placed it all on their ftp site. I also had to upgrade to 9.0.1.2.
-Original Message-
Sent: Monday, April 29, 2002 5:38 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Is there anybody among you who
Oracle8.1.7 on
Solaris8
I am trying to
create a tablespace on a raw device and the SQL*Plus session that performs the
tablespace creation is waiting on a 'file identify'. A quick search on metalink
and other docs did not indicate the root cause of the wait event.
I have used the
raw
And if you want to see the Diana-code (it's an Ada-term as I recall) all
you have to do is take some wrap'ed code and "Dec" it, since wrap'ed code
is nothing but Diana-code that has been Hex'ed. Guess who told me that...
Mogens
Connor McDonald wrote:
Yup - its "compiled" into (if I recall
Hi All,
I was wondering if any of you out there are using the tools that are
provided by Iraje (i.e the Active tools)? If so, what are you thoughts,
and comments on these tools (good or bad)?
Thanks
Mark
===
Mark Leith | T: +44
Me thinks this is related to all the other hot topics out there...
Centralize the computers, then another CIO comes in, decentralize all the
computers...every division gets there own...a genius.
IT is outsourced, problems, slow response, a new CIO comes in, let's bring
everything in house under
Im running sql loader with the following parameters
sqlldr userid=user/password@instance control=C:\filename.ctl
Run this from a command window and in about 10 seconds a window pops up
to the effect
SQL Loader has generated errors and will be closed by windows and
error log is being created
-- Peter Barnett [EMAIL PROTECTED]
We have been having some heavy discussions about
system failures, root cause analysis and developing
some proactive metrics. Generally, our problems
revolve around frequently late nights for the On Call
DBA because something out of our control goes
Make sure that the volume group underlying the
logical volume is ONLINE?
To test, I like to do something quick like "dd
if=raw-device of=/dev/null count=100" to test the readability of the raw
device. If this fails, you can go to the SysAdmin with something that is
pure UNIX...
-
IMHO, I don't believe that you can properly learn PL/SQL in a very short
period of time, or for that matter, any other language.
I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and he
tore into many real-life examples of PL/SQL. Supposedly, these were written
by developers
AIX, oracle 8.1.7.2, all 3 tables compute statistics, first_rows
optimizer_mode
a simple 3 table join, joined on the appropriate columns, works fine.
add a fixed constant to the mix and poof, 2 merge-join cartesian.
Here is first query w/o the fixed value:
select T1.EVENT# c1,
For NT tuning check out www.arstechnica.com, they have an NT tuning guide
buried on their site.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch
Sigh. I wish I understood half the words used in this exchange. Or maybe
not. But I still think Tim is a cool guy and I'm looking forward to drinking
beer with him next time we meet. The first time I met with Tim was in Denver
where he tricked me into eating something he called Rocky Mountain
1 - 100 of 188 matches
Mail list logo