There is no truly automated way to do this. Why Oracle doesn't make
this a builtin SQL*Plus option, I have NO idea. Seems to me like
something that ought to have been there since day one.
Anyhow, one work around I have seen is:
Create conn.sql
put 'connect 1' as the first line
add in the lines
the DB is *not* experiencing any waits... i'm trying to bring down the run
time of the
insertion process, currently it takes around 9 hrs... the management wants
to bring it
down to 5-6 hrs...again.. i OD NOT see any wait events while the process is
running..
there are no indexes on the tables
Dennis,
Did he publish any figures? I mean, it seems common-sense that adding the
first index will hurt but adding 11th index to a table won't hurt that much.
As stephane pointed out, cost of an index is 2.5 times more than the cost of
insert in a non-indexed table.
So assuming cost is 1,
i am using oracle
8.1.7
and have a product
ready for release to the customer in my office.
in the client's
place, only the oracle is installed.
next step i presume
is database creation to which my application will interact .. right
??
how do i make sure
that the database i create is the
copy the init.ora
look at the size of the redo logs, size of the datafiles.
make all the directories on the new machine.
Wait, how did you create the first database? I'm 99% sure you didnt
type create database.
use the same scripts
and oh yes READ THE DOCUMENTATION.
Most of the people here
Well said Joe! I liked the second part.
Regards
Naveen
-Original Message-
Sent: Saturday, October 26, 2002 6:33 PM
To: Multiple recipients of list ORACLE-L
copy the init.ora
look at the size of the redo logs, size of the datafiles.
make all the directories on the new machine.
Wait,
Title: tnsnames and sqlnet connectivity question
suppose I have an entry like this in tnsnames.ora ...
ESSNCS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo)(PORT = 6521))
(ADDRESS = (PROTOCOL = TCP)(HOST = aquarius)(PORT = 6521))
)))
I try
Can you display to the list the output from one of the queries, just for
fun?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, October 26, 2002 1:33 AM
the DB is *not* experiencing any waits... i'm trying to bring down the run
time of the
I've not seen this particular error. Over the years I've found SQL*Plus
COPY to be buggy. I just did a search on Metalink for sqlplus copy error.
Your problem is not addressed directly, but other problems point to bugs in
the GUI version of SQL*PLUS. Oracle's advice is to use the command line,
Hi all !
I'm new in this group :)
I'm new in Oracle for Linux too :)
Previously i used to Oracle for NT.
Now i have to start manage Oracle for Linux.
After successful instalation what should i do to
start my database (created during instalation).
And ... forgive me my english - this is not my
My query was executed on an Oracle installed, Oracle created Oracle 9i
version 2 database on Windows 2000. Oracle really started following OFA on
Windows starting with version 8i.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 25,
Is timed_statistics set to true?
Regards
Naveen
-Original Message-
Sent: Saturday, October 26, 2002 8:48 PM
To: Multiple recipients of list ORACLE-L
Can you display to the list the output from one of the queries, just for
fun?
- Original Message -
To: Multiple recipients of
Title: tnsnames and sqlnet connectivity question
The socket 6521 cannot be active on "apollo", so
you'll either have to take the TNS Listener down along with the instance or
restart the TNS Listener so that it is not listening on that socket after taking
the instance down. Taking the entire
Janet,
When I was laid off a year and a half ago, I created
three resumes:
- one which emphasized my programming experience.
- one which emphasized my DBA experience
- one which emphasized my UNIX SA experience
Then I looked for jobs in all three categories.
Good luck,
Peter Schauss
I got well, you know Ingres, that's a database so you're the Oracle
DBA
read and re-read and re-read the Oracle docs (all two books, this was
version 5) until the lightbulb went off... went VERY gingerly into the
database to look at things.
And prayed. A lot
Reading the manual is NEVER a bad
I seem to be missing part of this thread, and have been
gone most the week.
Re SNMP: I haven't played with it myself, but there are ~100
Perl modules dealing with SNMP. It would take some research
to determine which are the most useful, and go from there.
Definitely doable. Maybe Perl for
Dan,
I've done it, so I know it's possible. :)
The learning curve on this can be fairly steep, as there's
several pieces of technology that must be setup and working.
iAS needs to be configured. When I did this, it was with OAS.
I hope it's become easier since then. Unix is easier to setup
This documentation is found under the 'Oracle Enterprise Manager'
section of the documentation.
Jared
On Thursday 24 October 2002 08:08, Kevin Lange wrote:
Raj;
Here is a link to the SNMP Support Reference Guide that Ray talked about
for 8.1.7. I am sure its probably somewhere on your
I was going to suggest MD5 as well. Though I was thinking of the Perl version.
The DBMS_OBFUSCATION version is fine, but I was thinking of the unload
method.
Chris, how are you creating the flat files? UTL_FILE? SqlPlus?
Perl is much faster than sqlplus, dunno about UTL_FILE, as I haven't
I agree 100%. I recommend starting w/ the least read and most useful
piece of documentation a newbie can be exposed to. That would be the
concepts manual.
-Mark
On Sat, 2002-10-26 at 15:03, Rachel Carmichael wrote:
I got well, you know Ingres, that's a database so you're the Oracle
DBA
Hi all
Just a friendly enquiry
Who else is running Siebel + Oracle on Sun,
Would you mind sharing your system configuration. What spec hardware, HD
layout. Table distribution
I will start:
Oracle 8.1.6.3 EE (32 bit) + Solaris 2.6 fully patched.
E10K Domain #1, OLTP Siebel DB Domain
8 CPU
Anyone HERE actually get SCO 7.3.4 working on Linux? If so, anyone got a
copy - I would love to take a pop at it (never had the opportunity).
Yeah, I had SCO Oracle 7.x ( forget what the x was ) running on Linux about
7 years ago. Yeah, I was on the bleeding edge. :)
There were
Weeny. Try using a very small magnet on your hard drive.
On Wednesday 23 October 2002 14:49, Stephane Faroult wrote:
Joe Testa wrote:
Hack the oracle kernel to fix those errors. Use your favorite binary
editor.
joe
Binary editors are for sissies. You probably can do it with cat and
Paul,
I don't understand the question.
What are you trying to do actually?
Use sqlplus and retrieve the passwords in
the command line?
If you're using Perl utilities from the book, there
isn't any sqlnet connect string.
Maybe an example of what you are trying to do would help.
Jared
On
SQL%rowcount
cursorname%rowcount
RTFM the PL/SQL Users Guide and Reference, available
at tahiti.oracle.com
Jared
Read the Application
On Monday 21 October 2002 14:23, Smith, Ron L. wrote:
Within an update or load procedure, is there any way to return the
transaction count for the number
of
John,
Yes, it would be nice to meet.
I'm not planning anything, I'll let someone else do it.
I won't be available during the day at the conference, so
it would be best if someone else put's something together.
My previous post didn't make it to the list: I'm attending a
couple of Veritas
que?
On Thursday 24 October 2002 12:05, Alexander Ordonez wrote:
Ups colegas !
@lex
Lic. Alexander Ordóñez Arroyo
Soporte Tru64Unix BD Oracle
Caja Costarricense del Seguro Social
Telefono: 295-2004, San José,
And I don't have proof, but I am absolutely positive that using UTL_FILE is
faster then Perl...I just know it isit's gotta be...
:)
I'm currently working on a little project for someone to create a table
unloader in PL/SQL. Before you ask, I can't share on this one, it's
Hi Jared
Someone mentioned that you have a perl+dba tool set, would you mind telling
us more about it, etc etc.
Sorry guys but it is 02:56 and I am monitoring a db build, (100GB) need
things to amuse me.
Thx
Ps: thx for all the people that send me scripts on how to monitor rollback
segment
Hey Jared,
The current thinking is using a PL/SQL package to create the external flat file.
And I don't have proof, but I am absolutely positive that using UTL_FILE is faster
then Perl...I just know it isit's gotta be...
I will take a look at sqlunldr.pl, thanks.
CG
*no* waits?
How is this possible?
Is intantaneous computing now a reality?
Sorry for the sarcasm. Wait, no, not really. ;)
Seriously, all databases wait, all operations take
time. The question on everyone's lips is
'How long are *yours* taking?'
Jared
On Saturday 26 October 2002 00:33,
31 matches
Mail list logo