Ryan,
check this out, if you haven't looked it already,
it might help.
http://www.orafaq.org/faqunix.htm#HIDEPSW
thanks,
senthil
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Friday, January 16, 2004 1:04
PM
Subject: how to
Google for hide.c
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
On 01/16/2004 01:34:45 PM, Tanel Poder wrote:
Few ideas:
1) sqlplus /nolog
connect user/[EMAIL PROTECTED]
This requres putting ASCII (non-encrypted) password in the SQL script.
Not very safe.
2) . $HOME/.orapwd
sqlplus user/[EMAIL PROTECTED]
This will actually show password
Rich,
As I had indicated in a previous post on a similar topic, you will need to
minimize writes to the SAN during a mirror split during FlashCopy (in IBM,
BCV in EMC and ShadowImage in Hitachi). In my limited understanding, once
the command to split is received by the SAN, it has to make sure
2) . $HOME/.orapwd
sqlplus user/[EMAIL PROTECTED]
This will actually show password because shell will interpret the ORAPWD
variable before passing the arguments to fork/exec combination. Password
will be clearly visible by ps -ef.
Yep, you're right... I missed this somehow...
Thanks,
Yes. As long as your KEY_STRING is same, the
encrypted value will be the same.
Consider:
SQL exec :i := rawtohex(utl_raw.cast_to_raw
(dbms_obfuscation_toolkit.DES3Encrypt (input_string='12345678',
key_string='123456789012345678901234')))
PL/SQL procedure successfully
completed.
SQL
One
more...
sqlplus EOFusername/password
statement1;
statement2;
exit
EOF
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004
12:35 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: how to hide oracle password from a unix ps
We have been using Hitachi and EMC SANs.
The procedure is
1. Issue BEGIN BACKUP commands for *ALL* the Tablespaces
2. Use the SAN's commands to split the ShadowImage or FlashCopy for
the DataFiles FileSystems
3. Issue END BACKUP commands
4. Issue an ARCHIVELOG CURRENT command [and we also
Title: Re: SLA/metrics for RFP for programming services
How about specific deliverables within a specific period of time for a total amount not-to-exceed? Cant think of any other metrics that matter...
on 1/16/04 2:19 PM, Thomas Jeff at [EMAIL PROTECTED] wrote:
If you were to write up a RFP
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 4:04 AM
Hi,
I've been asked by management to explore the pros and cons of Mysql vs Oracle. The
database in question will be a web
based text and multimedia retrieval
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC -
Teresita Castro wrote:
Hi!!
My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle
just to make queries, funtions some updates and create indexes or
tables, that all.
Now I am in a little difficult situation, here we have a DBA that do not
have much experience. He has been
jwiegand wrote:
Good Day.
Has anyone succeeded in this and care to share? I've tried sharing out
the directory containing the Oracle backup, tried setting the Oracle
services to run under a Windows domain user, but continue to get
failures.
Hello,
Oracle on Windows don't support network drives.
that's what I get for not testing but just reading the manual :)
remind me not to answer questions when I don't have a database
handy.
sounds like Dan's going to have to add a column.
--- Kirtikumar Deshpande [EMAIL PROTECTED] wrote:
Rahcel, Dan:
I played with such things a long time
hi
you write query in order of largest,larger,large table fashion
and input parameter column may be indexed
tlw
hernawan wrote:
Hi all,
I have process in Oracle apps 11.5.8 which need
very lot CPUs and long time to complete.
for about 17,000 invoices it takes 28 hours !!
I have open
Ideally you should filter current sid/serial# ... else you'll get error .. no?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
I am from the old school, doesn't use RMAN, but soon will w/ our 9i
upgrades. I recommend to use RMAN if you are starting out and buy this
book.
http://www.bookpool.com/.x/dt3bpjmwz1/sm/0072226625
hth,
Gene [EMAIL PROTECTED] 01/15/04 03:14AM
Teresita Castro wrote: Hi!! My
name is Tere
To do incremental backups of Oracle databases via NetBackup you need to
purchase the Veritas Agent for Oracle, which is an add-on to the NetBackup
client. Veritas charges for this component, per server. You have to hand
over more money to Veritas. This may not be an option at your site.
Obviously. The issue has been whether or not Oracle's data caching
worked well - and was read for prime-time in earlier versions.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of RyanSent:
Wednesday, January 14, 2004 5:14 PMTo: Multiple
read the docs. otn.oracle.com
click on search. do a search for hash join.
The docs are very good. read them.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 8:34 AM
Dear all,
I understand join is for joining two
On 01/14/2004 04:49:52 PM, Jesse, Rich wrote:
Expect to pay about the same for PostgreSQL support as you would for Oracle.
15% of the purchase price/year?
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL
Hi ,
I think that their dba should be adviced with following link.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/toc.htm
Rgds.
Arslan.
-Original Message-
Sent: Thursday, January 15, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L
List,
I have to be
-Have them run a stress test and monitor on a non-productional system with sufficient
volume of data : CPU, memory, disk utilization. (show newbie as you do this)
-Look at how the database was put together for maintainability - best practices, etc..
-Look at some of the SQL related to their
To hire a better DBA or enlist the help of the Hotsos Corp.
would be the most appropriate advice I can think of.
On 01/15/2004 09:59:25 AM, Ehresmann, David wrote:
List,
I have to be involved in a conference call this afternoon concerning a
client. They want advice on how to tune their
sarcasm
Wow, your buffer cache hit ratio for this query is better than
99.99%! With a BCHR like that, how could you possibly tune this
query to be better??
/sarcasm
Now, seriously, since I know nothing about your application or
environment, and you do not show execution plan, I can only
Jared/Bruce:
Is this still being worked on? I'm not seeing a lot of volume nor
anything I've sent recently.
Stephen
[EMAIL PROTECTED] 01/14/04 07:54AM
Folks,
It seems that a fair number of emails are not
being retransmitted to the list. Some of mine
and a few others have not appeared in
You should get nightly cold
backups working first as it is the easiest. Then look into setting the database
to do archive logging.
Right now you don't have
any valid backups and if you crash and your DB fails to start you are
potentially screwed.
Also you should do a full
database export
Well, at least he didn't marry Lara Croft. That would do him in
faster then Bill Gates.
On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote:
Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry
Ellison. This is from an article is today's WSJ print edition page B4.
Make a new account with a different username.
They funny like that...I think I have about three of four old OTN
accounts...
Brad
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 9:24 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Do you have
I have just done an Amazon search, I guess that Melanie Craft's book 'A Hard-Hearted
Man (Intimate Moments, No 870)' will bring some terrific change to my usual reading
list. Although one of her other masterpieces, 'Trust Me' looks terribly reminiscent of
the Oracle doc, doesn't it.
SF (almost
Hernawan,
Is this a custom or standard Concurrent request? If this is standard, there
may be a patch out for your module/level. If not, I would use a 10046 level
12 to look at the issue. As you can see from tkprof, you have a huge amount
of LIO... Is your init.ora parameters kosher as per Oracle
Teresita,
The first thing I would do is
to make sure and make full, coldbackups by
shutting down the database and doing a tape backup of the disk
your database files are on. This will keep you out of trouble
immediately.
Then, since you said you were
using Oracle 9.2.0.2,set up
Arslan,
Per the OTN webstie..
Q: How do I change the e-mail address in my membership profile?
A: OTN's membership management system does not let you change your
email address in your membership profile. Please create a new account
with the new email address you wish to use.
Ron
[EMAIL
True, but you can use a UNC address \\machine_name\shared_dir to copy a backup file
remotely. But you need to make sure that the user who fires off the copy command has
write access on the shared destination directory.
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred
Hi!!
TheCD's that we have saidOracle 9.2.0.1.0, but I
did not see any that said RMAN,( when I asked the DBA the version of Oracle that
we have and he said 9.2.0.2.1.) the RMAN is inside a specify
CD? [EMAIL PROTECTED] 01/14/04 09:49PM
Teresita,
What your
DBA is talking about is
Teresita,
You've gotten some good comments...even a quick tutorial on backups. My
recommendation to you (especially if you don't have any backups at all) is
that until you're more familiar with the tools you have that you should
initially avoid the complexities of incremental backups and
by: [EMAIL PROTECTED]
01/14/2004 11:34 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Reset sequence at midnight
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person
If you have the room, I would suggest doing a daily export of the
database until you get all the problems ironed out with Netbackup.
Especially if you are trying to do incremental backups. That way you
will at least have something to restore with if you find out your
Netbackup plan wasn't
Brad,
We're primarily using 9i with a third party time accounting system, so I
haven't had too much time with a lot of 9i, but the resumable transactions are a REAL
time energy saver. The Time accounting system has to do bulk data loads from our HR
system as well as it's own batch
:[EMAIL PROTECTED]Sent: Thursday, January 15,
2004 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Hi!! Veritas Backup
Question
Hi!!
TheCD's that we have saidOracle 9.2.0.1.0, but I
did not see any that said RMAN,( when I asked the DBA the version of Oracle
that we
Title: Message
He's
right, accessing the database is expensive. So is accessing from an app
server if you have to support concurrency, updataing, transaction
control,etc. Only if you consider the ACID properties of databases
of no use for your application is this line of argument correct.
Chris
I know from a previous assignment that PowerBuilder has no issues running
queries against a database using the CBO. In fact, PowerBuilder doesn't give
a rats backside what the database does to the query as long as it returns
what's expected.
As for redundant constraints, they will increase
try again...
-Original Message-
Chris
I know from a previous assignment that PowerBuilder has no issues running
queries against a database using the CBO. In fact, PowerBuilder doesn't give
a rats backside what the database does to the query as long as it returns
what's expected.
As for
Title: Message
Eric,
Try:
ALTER
TABLE scott.emp RENAME TO employee;
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to compensate him for what he is not, and a sense of humor was
provided to console him for what he is." --Unknown
You cannot specify a schema in the rename clause. Simply change your
statement to alter table scott.emp rename to employee. The table will
stay within the scott schema even if the command is executed by another
user.
Brad,
- External Tables have the potential to be WOW and when properly used
instead of SQLLDR can meet #1 4.
- Resumable transactions
Stephen
[EMAIL PROTECTED] 01/15/04 10:14AM
Hey listers
I am doing some research and would like to get (in very short answers)
features of 9iR2 that
Comments inline
On 01/15/2004 04:14:27 PM, Ryan wrote:
I was flipping through Tim Gorman's Data Warehouse and he has a short section on
using named pipes to kick off sql loader when you send files to your data
warehouse with ftps.
Tim is a resourceful guy. I scripted it once for export.
Title: Message
Rewrite the query without specifying the owner name and it
works.
Alter
table emp to employee;
-Original Message-From: eric king
[mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004
12:00 PMTo: Multiple recipients of list ORACLE-LSubject:
alter
Powerbuilder is a GUI. just like forms. This is what typically happens with
3rd party apps. They develop them some time in the past. Oracle adds new
features, they dont want to spend the money to test to see if it works. So
they tell customers not to use them. Its how they keep costs down. New
Consultant
print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]);
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of DENNIS WILLIAMS
Sent: Tuesday, January 06, 2004 3:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Convert
Repost ...
-Original Message-
Sent: Wednesday, January 14, 2004 9:14 AM
To: '[EMAIL PROTECTED]'
LG,
Has there been any issue monitoring and administering 8i databases using 9i
tools? I am seeing some strange behavior when using 9i OEM tools to monitor
8.1.7.0 database and
This is a good question. We've been running 9i instances for 18+ months
now. Here are my impressions:
I would say RESUMABLE, especially for bulk loads, export/import,
sqlloader is #1. This has saved HOURS!!!
Dynamically modifiable SGA parameters have helped us with reliability.
Less need to
On 01/15/2004 09:54:36 AM, Chris Stephens wrote:
There response was that it's a limitation of powerbuilder. I don't buy that
for a second. ...anyone know for sure?
I have slight experience with supporting Powerbuilder apps in 1996 and,
later, in 1998. At that time it was completely possible
Title: RE: alter table rename error
Eric,
No schemas allowed. Take out both of the scott. You need to be logged in as Scott to rename Scott's tables.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: eric king [SMTP
comments in line...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 11:04 AM
sarcasm
Wow, your buffer cache hit ratio for this query is better than
99.99%! With a BCHR like that, how could you possibly tune this
ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]cc:
ott.af.mil Subject: RE: alter table rename error
-Original
Message-From: Teresita Castro
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 15,
2004 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Hi!! Veritas Backup
Question
Hi!!
TheCD's that we have saidOracle 9.2.0.1.0, but I
did not see any that said RMAN
-Original
Message-From: Teresita Castro
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 15,
2004 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Hi!! Veritas Backup
Question
Hi!!
TheCD's that we have saidOracle 9.2.0.1.0, but I
did not see any that said RMAN
If the datafile is off-line? (Not tested, just a guess.)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Fri 1/16/2004 12:04 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Checkpoint ...
All,
Whenever checkpoint happens
]
cc:
Sent by: Subject: RE: kill session privilage
]
cc:
Sent by: Subject: RE: kill session
privilage
[EMAIL PROTECTED]
.com
14/01/2004
08:44
Please respond
to
ORACLE
Dunno how he does it. But I'd settle for my
replies from my ISP to make it here...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
How do you know they're nodding if they call you on the phone? Distinct
rattling sound? :-)
--
Please see the official ORACLE-L FAQ:
I the big motivation for the ol' SQL*Plus COPY command
was to improve upon this.
Of course COPY is disappearing as well isn't it?
Cheers
Connor
--- Jared Still [EMAIL PROTECTED] wrote: My
apologies if there are multiple copies of this.
Something funky going on with email from work.
Gene,
That's the purpose of read-only tablespaces. You make to changes you
need in the data, alter it to read only, and back it up to the backups
device(disk,tape) and but the backup on the shelf. That way your 500 Gig
datbase with 500 Meg active only requires the 500 Meg be backed up.
Ron
Perhaps you can query dba_tab_privs.
-Original Message-
Tracy Rahmlow
Sent: Tuesday, January 13, 2004 10:19 PM
To: Multiple recipients of list ORACLE-L
I am looking for a script that I can supply a table name and it returns
all users that have access to it (either directly, thru system
what is on the oracle website?
www.oracle.com
do a search for certification.
- Original Message -
From: Hemant K
Chitale
To: Multiple recipients of
list ORACLE-L
Sent: Tuesday, January 13, 2004 9:34 AM
Subject: Re: ** OCP for 9i requirements
Are you sure that the on-line version
Yes, I once imported a schema [Parametric Windchill] which had a few tables
with LONG datatypes.
It was one particular table that took ggg to import.
Import does import one-row-at-a-time for tables with LONGs . But I
couldn't explain
why one table took so much longer than the
If you
go to the Update 9i exam listing - there are no course
requirements.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Hemant K
ChitaleSent: Wednesday, January 14, 2004 9:09 AMTo:
Multiple recipients of list ORACLE-LSubject: Re: ** OCP
SyncSort is NOT a data unloader. It's purpose, and it does a damned good job of it,
is to sort large text files to improve data loading with tools like SQL*Loader. Your
user should have zero access to the datafiles, period. They need to be -rw-r so
that an ipc dedicated server process
]
cc:
Sent by: Subject: RE: kill session privilage
[EMAIL PROTECTED
Bill - Will you be administering the server or do you need to talk to the
administrator?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 14, 2004 10:15 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Does anyone have any good
Yes. Note that when you use MTS, sort area is taken from the SGA,
specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not.
With a dedicated server, sort area is a part of the process address space.
On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote:
Hi all ,
is sort are
Leng,
You didn't mention the frequency of the refresh.
I also don't see mention of which database is generating
the ora-1555 errors.
Jared
Kaing, Leng [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/13/2004 09:34 PM
Please respond to ORACLE-L
To:Multiple recipients of list
If you have the choice, look at PostgreSQL in addition to MySQL. From what
I've seen, it's more mature than MySQL.
My $.02,
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent:
To use program which will supply numbers, possibly as an external routine,
and not use an oracle sequence as it wasn't designed for that purpose.
On 01/14/2004 12:04:26 PM, Oracle wrote:
Hi,
I have a sequence which i want to reset to 0 at midnight everyday.
What is the best way to do this?
It comes out of the total memory of the server - separate from the shared pool - it is
allocated per session - if running parallel processes in a DSS environ. can quickly
consume memory avail. be wary wary careful.
-Original Message-
Mladen Gogala
Sent: Wednesday, January 14, 2004
drop sequence
create sequence
but why do you want to do that?
--- Oracle [EMAIL PROTECTED] wrote:
Hi,
I have a sequence which i want to reset to 0 at midnight everyday.
What is the best way to do this?
Db version - 9.2.0.1.0
Thanks
Imran
--
Please see the official ORACLE-L FAQ:
Dang ... he now shares my wedding anniversary (not the year) ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Raj,
If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
On 01/14/2004 12:44:25 PM, Jesse, Rich wrote:
If you have the choice, look at PostgreSQL in addition to MySQL. From what
I've seen, it's more mature than MySQL.
I second that. PostgresSQL supports transactions and uses perl as its
scripting language. From what little I read and saw (just a
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Very True ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts
Interesting, I've actually had to do this before.
Be forewarned that this is not a good method to use for a very busy
app, as it does introduce some level of serialization.
control access to the sequence through a package
Within the package use a function that sets a lock via dbms_lock.request
I guess jokes about Preferred Oracle Partners would be in bad taste...
Patrice.
-Original Message-
Sent: January 14, 2004 2:24 PM
To: Multiple recipients of list ORACLE-L
Dang ... he now shares my wedding anniversary (not the year) ...
Raj
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Why does he quit? I thought he likes to
fight...
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 14, 2004 1:59
PM
Subject: RE: Sorta OT: Uncle
Thanks Brad, Thanks Steve, The problem fixed after our DBA drop and
rebuild the primary key. It is so great to have people like you on this
list.
Thanks again,
--
Original Message
Date: Tue, 13 Jan 2004 08:59:24 -0800
At first stab...I would
I heard from an Oracle instructor that some idiots were bragging about how
they passed the OCP without logging in once. This distressed some important
people, so this requirement was added. I asked if this meant each instructor
was tasked with ensuring each student logged in, and he just smiled.
since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
John
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best
I'm going to make Mogens clean my garage ... I'm sorry, I meant further
team building ... when he visits for the Symposium in March!
Gary
(817)424-3443 Office
(817)296-8000 Cell
-Original Message-
Mogens Nørgaard
Sent: Tuesday, January 13, 2004 10:39 PM
To: Multiple recipients of
what is DBI?
is postgre free? Is it like linux where you pay for support? I cant find any
licensing info on the website. Most shops dont need oracle, sql server,
sybase, or DB2.
Most applications are small. I was on a project where the government had an
Oracle EE license on windows. They didnt
Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best answer is 'know thy application'. And in
this, knowledge of
bind var vs hardcoded value usage, looking at V$SQL
1) DBI is a perl module to handle the communication with various databases.
2) Postgres is free. I believe that you can buy commercial support, but I don't know
where. May be Rich can jump in with that.
3) DBI is free and so is perl. I'm cheap easy, but not free.
On 01/14/2004 02:34:52 PM,
DBI is an extension to perl language which can then be used by perl to talk with
various databases. DBI stands for database interface. With DBI you also have to
load in a specific database driver which is called DBD. For instance for oracle you
have to install DBI and DBD::Oracle. Its really
-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best answer is 'know thy application'. And in
this, knowledge of
bind var vs hardcoded value usage
I don't think MySQL is free for commercial application, for dev and test
purpose it is free.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 4:29 PM
DBI is an extension to perl language which can then be used by perl to
since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
John
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think
I'm suspicious about using MySQL or Postgres with a database 100 gigabytes
in size.
(Especially, when their main website appeared to be down when I wanted to
check some of their recent references).
Anyway, if you have availability requirements which don't allow you to take
down your system for
Ryan,
He has a point. If you look at 9IAS's architecture
there is a cache database at the apps server. The trick is to know when
the data your looking for in cache is no longer valid. A certain
children's apparel/toys site did that to me back in October. I'm still
torqued at them.
Dick
i thought postgre was a for profit company? how do they generate revenues?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 4:19 PM
1) DBI is a perl module to handle the communication with various
databases.
2) Postgres
There is a commercial arm of PostgreSQL (or at least a partner) for
businesses that require support. Surf on over to:
http://www.pgsql.com
Expect to pay about the same for PostgreSQL support as you would for Oracle.
I don't know of any support for DBI other than the Perl DBI mailing list
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Ryan
Sent: Thursday, 15 January 2004 09:05
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle vs Mysql
i thought postgre was a for profit company? how do they
generate revenues?
Don't
701 - 800 of 67344 matches
Mail list logo
