Re: High availability and real time data warehosuing
Where I work we use TIBCO rendez-vous messaging software for trading feeds and transactions. On Wed, 6 Aug 2003, [iso-8859-1] hrishy wrote: > Hi > > I was wundering if any of your shops are using High > avaliability solutions . > > 1)Can you tell me how these solutions like datamirror > are superior to oracle9i RAC ? > > 2)Has anybody implemented real time data warehousing > solution ?If so what were the enabling technologies > used like > > 1)Java Messaging servcies > 2)Mq series > 3)Oracle streams > > 3)Has anybody implemented oracle 9i datagaurd what has > been your experinces so far > > regards > Hrishy > > > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?iso-8859-1?q?hrishy?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antwort: clustering
Hi oracle running on sun cluster or MC/service guard is usually a failover solution. If the node running oracle fails the standby node takes over by executing customized start scripts. With RAC both nodes have instances of the same database up and running. If one node fails the other is still up and running. Of course you can run RAC on top of a failover cluster. HTH alex "AK" <[EMAIL PROTECTED] An: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> l.com> Kopie: Gesendet von:Thema: clustering [EMAIL PROTECTED] y.com 28.07.2003 18:14 Bitte antworten an ORACLE-L Hi Guys , I am new to this clustering concept. Just trying to understand few basics . Need ur help . what is differece between oracle running on sun /hp cluster with 2 nodes and oracle with RAC running on 2 nodes ? thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Who Says Oracle does not listen
RE: Who Says Oracle does not listenAgree.
One can improve EXCEPTION section to ignore only relevant errors.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 21, 2003 6:19 AM
That's not good enough.
I don't want to discard ANY exception.
When dropping table, I don't want to see error messages only if there is
nothing to drop. While if let's say there is a problem with privileges, it
will go unnoticed.
Or, when adding a table, it's fine not be getting an error, if table already
exists. But, if there is no room to create a table, or to add a partition
to the table, I want to see this error message.
So, I still prefer my way of doing it (see scripts in my original message)
comparing to Oracle's script, you refer to.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L
>From ORACLE own script:
Rem
Rem Drop tables without raising errors if they do not exist
Rem
declare
PROCEDURE drop_force(tab varchar2) IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || tab;
EXCEPTION WHEN OTHERS THEN
NULL;
END;
begin
drop_force('utl_recomp_invalid');
drop_force('utl_recomp_sorted');
drop_force('utl_recomp_compiled');
drop_force('utl_recomp_backup_jobs');
drop_force('utl_recomp_log');
end;
/
Alex.
-Original Message-
Sent: Friday, July 18, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Sure, I would.
But I can't wait till Oracle "turns around".
My scripts are executed by our "field" engineers, who know next to nothing
about Oracle, and the only thing they can do is to check log files for error
messages (and even this is done automatically).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Goulet, Dick
Sent: Friday, July 18, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Igor,
True enough, but wouldn't you like it as part and parcel of the
command?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, July 18, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
To avoid those errors in my scripts I'm checking data dictionary for the
"existence" of the object (fortunately, dynamic sql helps here):
REM Dropping synonym
DECLARE lCounter integer;
begin
SELECT COUNT(*) INTO lSyn
FROM dba_synonyms WHERE synonym_name = 'PRCPV_REPORT_INFO' AND OWNER
= 'PUBLIC'; IF (lSyn = 1) THEN
EXECUTE IMMEDIATE 'drop PUBLIC SYNONYM PRCPV_Report_Info'; END IF;
end; /
or:
REM Adding column
DECLARE lCounter integer;
begin
SELECT count(*) INTO lCounter
FROM DBA_TAB_COLUMNS
WHERE table_name = 'PRCP_MENU'
AND column_name = 'MENU_NAME'
AND owner = 'IPN_DBA';
IF (lCounter = 0) THEN
EXECUTE IMMEDIATE 'ALTER TABLE prcp_menu ADD menu_name
VARCHAR2(50) NULL';
END IF;
end;
/
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Feinstein
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: perl DBI/DBD: can I pass in an array as parameter?
LOL
I offered a solution to pass an array. Getting results are for the upgrade.
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tuesday, July 01, 2003 6:24 PM
>
>Responses to 2 emails below:
>
>Alex wrote:
>>
>> not sure if this is what you want. one sql call
>>
>> select tab1.col1, tab2.col2 from tab1, tab2
>> where tab1.ID1 = tab2.ID2
>> and tab1.X = ?
>> and tab1.X = ?
>> and tab1.X = ?
>> ;
>>
>> @my_array = (1,2,3);
>> sth->execute(@my_array);
>>
>
>Errm, no rows will be returned. Think about this one a little more.
>
>Steve Ollig wrote:
>> ok - that makes more sense. sorry for misinterpreting the
>> question. i've
>> never done it, but my first instinct would be to explore
>> using an in clause
>> in the query -
>>
>> select tab1.col1, tab2.col2 from tab1, tab2
>>where tab1.ID1 = tab2.ID2
>>and tab1.X in (1, 2, 3)
>>
>> can you simply pass an array to the prepared statement that
>> way? i'd try it
>> but don't have a sandbox with the DBI/DBD modules handy.
>>
>> perhaps one of the great Perl gurus of the list will offer
>> some insight...
>>
>
>I'm not a Perl guru, but I can think of 2 solutions:
>
>#build an array with the keys you want to look for:
>my @my_array = (1, 2, 3);
># then add that many ?s to the query
>
>#the 'in' solution:
>my $query = '
> select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X in (' . join(',',('?') x @my_array) . ')';
>
># or the 'union' solution
>my $subquery = '
> select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X = ?';
>
>my $query = join(' union ', ($subquery) x @my_array);
>
># pick only one of the above!
># and then
>
>my $sth = $db->prepare($query);
>$sth->execute(@my_array);
>
># then get the data back your favorite way: fetchall_arrayref, fetch_array,
etc
>
>But is it really worth the trouble? As long as you are using bind
variables, the overhead of multiple executes should not be very high.
>
>warning: these are typed from memory - I may have typos in the perl code.
But the concept should work.
>
>-Chris
>
>
>LEGAL NOTICE:
>Unless expressly stated otherwise, this message is confidential and may be
privileged. It is intended for the addressee(s) only. Access to this e-mail
by anyone else is unauthorized. If you are not an addressee, any disclosure
or copying of the contents or any action taken (or not taken) in reliance on
it is unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Sarnowski, Chris
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-----
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: perl DBI/DBD: can I pass in an array as parameter?
not sure if this is what you want. one sql call
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ?
and tab1.X = ?
and tab1.X = ?
;
@my_array = (1,2,3);
sth->execute(@my_array);
On Tue, 1 Jul 2003, Guang Mei wrote:
> No. I want to reduce the numebr of sql calls.
>
> For example,
>
> @my_array = (1,2,3);
>
> I don't want to do
>
> select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X = 1;
>
> select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X = 2;
>
> select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X = 3;
>
> because that would require three calls to Oracle. I want to pass @my_array
> in so the sql statment only run once and return all the rows. Similar to
> "forall ..." in PL/SQL situation.
>
> Guang
>
> -Original Message-
> STEVE OLLIG
> Sent: Tuesday, July 01, 2003 2:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> if i get you right - you're trying to treat the resultset from a query as an
> array in Perl. That's the way it works. Try something like this:
>
> $sth = $dbh->prepare (" select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X = ? ");
> my $resultset = $sth->execute("value for X");
> foreach (@$resultset) {
> my($col1, $col2) = @$_;
> # do more stuff
> }
>
> -Original Message-
> Sent: Tuesday, July 01, 2003 11:20 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi:
>
> Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
> that I get result set from Oracle?
>
> Specifically, I want do something like in perl:
>
>
> $sth = $dbh->prepare (" select tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and tab1.X = ? ");
>
> my @my_array;
>
> # filling in my_array with data here
>
> $sth->execute(@my_array);
>
> my ($col1, $col2);
> while(($col1, $col2) = $sth->fetchrow_array()) {
>
> # do processing of $col1 and $col2;
> }
>
> I am hoping to save repeated sql calls, do only one call and get all the
> rows back.
>
> Is it possible in any version DBI/DBD? I looked at
>
> http://perldoc.com/perl5.6.1/lib/DBI.html
>
> and I does not seem to be able to figure it out. If it is possible, any
> simple example code somewhere?
>
> Thanks.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: STEVE OLLIG
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -----
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.o
Re: Need Script!!
you can use perl from activestate.com. run your awk script through a2p and see if it works. there are many mail modules... Mime::Lite, Mail::Send to name a couple. On Tue, 1 Jul 2003, Senthil Kumar D wrote: > Hi Group, > > In one of our client place we are having Oracle 8.1.7 (std Ed) on NT. > > Here we need to send mails if the DB is down or if the listener is down or > any errors in the alert log is found. In Unix we can use shell scripts and > awk to do this. What about in NT/ > > Guru's do you have any scripts to do the same. > > Please help me in this. > > TIA, > Senthil. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Senthil Kumar D > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Is there a simple perl utility or program similar to Oracle's
If you're asking for a profiler of your perl code you can try dprof and dbiprof. On Tue, 3 Jun 2003, gmei wrote: > Hi: > > I have a perl program which calls lots of subroutines, and plus it calls > sqls through DBI/DBD. I am wondering if there are some utilities or programs > similar to Oracle's dbms_profiler that I could use to identify parts that > are heavy-hitters? > > TIA. > > Guang > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: gmei > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle full table scan
Hello Arvind, Thursday, April 3, 2003, 5:58:38 AM, you wrote: AK> Dear All, AK> is there any way to find which tables (table name) are suffering from AK> full table scan ,so that i can create indexes on them to enhance the AK> performance. AK> Thanks AK> Arvind AK> -- AK> Please see the official ORACLE-L FAQ: http://www.orafaq.net Use SQL_TRACE feature to find all statements which used FTS. -- Best regards, Alexmailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to use small oracle database in my program
What are you going to be doing? You probably can use an embedded database like BerkeleyDB or Sqlite On Tue, 1 Apr 2003, liujd wrote: > What do you thinke of how the OutLook express handle the data (email)? > I think they are stored in database . > Now ,I am going to program by visual c++ , > In order to process large data , I want to use oracle . > But I don't want to tell my users: " to get a oracle database 9i and > install it .The program needs them". > If there is some way to get the core parts of oracle that you only > install it you can use them? > I just need some table and index to make my processing data fast. > Thank you ! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: liujd > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: make utility in Solaris 8
what's the error that make generates? As long as make is on your PATH then all you have to do is type make. Also, there are different versions of make that use a different syntax in the Makefile. What make do you have? On Tue, 25 Mar 2003, Ross Collado wrote: > Thanks Dennis. > I only happen to suspect make is not properly installed because comparing it > with the other Sun boxes we have, make is in /usr/ccs/bin whereas with this > particular box, it's in /usr/local/bin. How it got there, I don't know. > Anyway, I'll try reinstalling the Sun package with make on it. Another > lister posted the package I was after. > Rgds, > Ross > > > -Original Message- > Sent: Wednesday, 26 March 2003 1:06 AM > To: Multiple recipients of list ORACLE-L > > > Ross - I'm far from a Solaris guru, but since I don't see where you received > a reply, here goes. The Oracle install may fail because it can't complete > the make process. This happens, and requires a fix. But what makes (no pun > intended) you think the root cause is that the Solaris make utility was > improperly installed? Now if you are coming from a Micro$oft background, > that might be a reasonable reaction. ;-) >Are you receiving some error messages during make? > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, March 25, 2003 12:04 AM > To: Multiple recipients of list ORACLE-L > > > Env. Solaris 8 Oracle 817 > > My apologies for this OT posting. I know we have quite a lot of Solaris > gurus here. > It appears the "make" utility was not installed properly as the Oracle > install keeps failing. > Can anyone tell what the SUN package name where make is in? > Apologies again. > > Rgds, > Ross > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ross Collado > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ross Collado > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Value of OCP
Certifications are good for self marketing just like a degree from a prestigious school. Does a certification mean anything? It means the person took time to study and pass a test. It shows a little dedication. A certification by itself means the individual is competent enough for an entry level job. Given enough time and rote memorization many people could pass a certification without ever actually touching the technology...the jailhouse lawyers of IT. On Wed, 19 Mar 2003, DENNIS WILLIAMS wrote: > > Foote Partners surveys the value of certifications. They support that over > the past two years, the OCP pay premium increased by nearly 40%. In the same > period, the value of Microsoft MCP declined by nearly 60%. > > A good article on the value of certifications. > http://www.eweek.com/article2/0,3959,936853,00.asp > I don't see where they included the Foote data online. It is in the eWeek > magazine 3/17/03 edition, page 50. > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Autoallocate (was Re: LMT monitoring)
How about UNDO tablespace in 9.2? It gets created with "autoallocate", and there is no way to change it or specify any parameters for undo segments. Each segment extended as needed, and when shrinked deallocated some extents not necessary the last, than allocate new extent. Alex. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 2:22 PM You do get odd results. The last time I tested on a clean tablespace, an initial of 65MB gave me a consistent result which I recall as: Extent 0 at 8MB Extents 1 - 56 at 1MB each Extent 57at 8MB - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 6:23 AM case when initial_extent < 1m then case when extents < 16 then next = 64k, when extents < 80 then next = 1m, when extents < 200 then next = 8m, else next = 64m when initial_extent >= 1m then case when extents < 64 then next = 1m, when extents < 184 then next = 8m, else next = 64m ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Development Suite for Linux?
RS> On Mon, Mar 10, 2003 at 08:28:50PM -0800, Charles Hart wrote: >> I installed 9.2 on redhat 8.0 with great luck. I installed on a 700 PC >> with 756 megs of memory. I was using forms 6i running on NT client and >> could not tell when I was pointed at this instance verus one running on a >> HP machine. The document I found that was helpful in the install was >> http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf RS> I believe the real problems where with 8i on a 2.4 kernel. There is a RS> miss-match is the glibc versions used for the kernel and oracle. What RS> a mess. This seemed to work on 8.1.7-rh7.1 combination. rh7.1 is the RS> last free version in the support matrix if that matters. RS> http://www.tldp.org/HOWTO/Oracle8-on-RH7X-HOWTO-3.html RS> On an error with a 9.0 install: RS> Error when invoking /9.0/plsql/lib/ins_plsql.mk RS> Doc ID: 197301.995 OK Lads, there are good responses. Thank you. Just clarify something... I have installed Oracle Database Server 9.2.0.1 on RH 7.3 without any major problems as well. Now I look at Application Server and Development Tools (such as Forms and Reports). I see 2 options for me: Linux (preferable) or Windows. It will be "test" installation - performance is not an issue. The main call for me is time I spent to get it work. Is Linux installation is more time consumed than Windows now (before it took more time and involved more complex procedure to get it working under Linux)? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Development Suite for Linux?
Hello List, Has somebody had any luck or problems to install Oracle development suite v9.0.2 under RH Linux? How good it is there now? I found that previous versions run much better under Windows. Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: remote / as sysdba
Jared, Look at Note 60634.1 on MetaLink. OSAUTH_PREFIX_DOMAIN = TRUE is default for 8.1 and 9. Alex. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, March 09, 2003 10:08 PM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: perl DBI question: fetchrow_array
try using fetchrow_arrayref and see if its faster or less resource
intensive.
On Thu, 6 Mar 2003, gmei wrote:
> I have some perl code which selects table data and write it into a file. I
> have something like:
>
> ---
> $dbh->{RowCacheSize} = 1;
> open(DATA, ">$tn") || die "Can't open file\n";
> $dat=$dbh->prepare("select id||chr(9)||FUNCTIONID||chr(9)||GENEID from
> FUNCTION2GENE");
> $dat->execute();
> while(($row) = $dat->fetchrow_array) {
> print DATA "$row\n";
> }
> close(DATA);
> -
>
> I am trying to see if there is any way to speed up the process.
>
> So here is my question:
>
> Is "fetchrow_array" the fatest way to get the data?
>
> TIA.
>
> Guang
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: gmei
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: multiple oracle homes
Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT' and /usr/local/bin/oracle_setup.ksh will source oraenv and do some additional customization. Alex. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 7:14 PM Better yet, have one single generic .profile with aliases defined for each instance running on the server. Want to change env for another instance? Just type it's name. It is that simple. We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w. The .profile file sources the alias' file as .local.aliases. This file has entries as below: #Add Database name here using the following format alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv;' alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK="NO";. oraenv;' alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D;' alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv;' alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK="NO";. oraenv;' alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK="NO";. oraenv;' alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK="NO";. oraenv;' alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv;' alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK="NO";. oraenv;' PRMT --> IWVT are the instances running on the server. And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !! HTH, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: How to start with Oracle Financial?
Hello Mike, Friday, February 28, 2003, 11:48:49 AM, you wrote: HMNI> To be honest if you can't download manuals, books or software you don't HMNI> leave yourself many options. HMNI> It's not clear whether you've been unable to download manuals or won't. The HMNI> manuals are all available at HMNI> http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html. HMNI> You can't download Oracle Financials but you can order Oracle Financials HMNI> from the Oracle Store? It's pretty cheap (look under "CD Packs"). Thanks a lot for link above. Unfortunately I was asked about user name and password there :( Do you know it? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: How to start with Oracle Financial?
Hello Folks, Many thanks for your help. I found this in Oracle Store: * We do not offer trial licenses for our E-Business Suite Applications >From Mike's letter it is avoidable ;) But this... OracleR Applications 11i Release 8 CD Pack for Linux Intel NOTE: This CD Pack is only for existing 11i customers. CD Pack contains the Doc Library CD and Maintenance Pack CDs Does it mean I would be asked about some key during ordering? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: RE: newbie dba question - THANKS AGAIN!
Darrell Landrum <[EMAIL PROTECTED]> wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present?Thanks again!"Godlewski, Melissa" <[EMAIL PROTECTED]>wrote:Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify t! he issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOLM.Godlewski-///Alex,Melissa has some good advice here. Your issue is too vague and broad for any reasonable assistance. It seems you're kind of in a trial by fire situation. There are so many things you need to look at and know for trouble shooting performance that, without more information, the most likely offering is a book(s). Unless someone has specifically backported statspack, it is only available from 8! .1.6 forward, so you're stuck with bstat/estat.I haven't read Oracle 101 performance tuning, but I saw Gaja speak at the hotsos symposium and based on that would second Melissa's recommendation for this book. Also, "Expert One-on-One" by Tom Kyte and "Practical Oracle 8i" by Jonathan Lewis (I know it says 8i and you're on 8.0, but there are a lot of concepts and applications the same or similar.) There are probably many other good books which I haven't read.Some sites you should get into very soon (in any order)...http://www.jlcomp.demon.co.uk http://asktom.oracle.com http://www.hotsos.com In the meantime, try and get some traces of troublesome sessions and post those to the list, as well as any stat reports, and we'll offer what help we can. Also, please include any platform information you can get (operating system, etc.). Are your tables getting analyzed?Folks on the list weren't ignoring you, there just wasn't enough information to get ! started.We'll try not to let you have to deal with this alone.Good luck!Darrell Landrum>>> [EMAIL PROTECTED] 02/27/03 05:53PM >>>Note: forwarded message attached.-Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and more-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Darrell LandrumINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso! send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
How to start with Oracle Financial?
Hello List, Have the one question from subj please. I'd like to get some initial experience with Oracle Financial. What is the best way to do so? I couldn't download this package or manuals/books from OTN for practise... But I need to have some knowledge of it to get new job. Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: RE: newbie dba question - another try
Note: forwarded message attached.Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more--- Begin Message --- Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present? Thanks again! "Godlewski, Melissa" <[EMAIL PROTECTED]> wrote: Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify the issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOL M.Godlewski -Original Message-From: Alex Dashko [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 26, 2003 10:54 PMTo: Multiple recipients of list ORACLE-LSubject: newbie dba question Hello Gurus, I heard that if I can get great ORACLE advice, this is the place, so here is my question. I've been asked to take over an existing db in production. What would be the right way to get a "quick" understanding on what's happening in it in terms ways for proactive tuning? I am just getting started while trying to be ahead of the curve. Is this something I should be looking into, or is it more like if it ain't broke, don't fix it? :). It'd be nice to get started and have a good view on what's going on. Also, can someone can share their experience on what can be done when customers report intermittent, but rather dramatic slowdowns in the system. Please note, the slowdowns are reported to be occurring in the entire system. What would be a good place to look when this happens and get some quick feedback? Thank you very much! Best regards, Alex Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and moreDo you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more--- End Message ---
RE: newbie dba question
Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present? Thanks again! "Godlewski, Melissa" <[EMAIL PROTECTED]> wrote: Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify the issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOL M.Godlewski -Original Message-From: Alex Dashko [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 26, 2003 10:54 PMTo: Multiple recipients of list ORACLE-LSubject: newbie dba question Hello Gurus, I heard that if I can get great ORACLE advice, this is the place, so here is my question. I've been asked to take over an existing db in production. What would be the right way to get a "quick" understanding on what's happening in it in terms ways for proactive tuning? I am just getting started while trying to be ahead of the curve. Is this something I should be looking into, or is it more like if it ain't broke, don't fix it? :). It'd be nice to get started and have a good view on what's going on. Also, can someone can share their experience on what can be done when customers report intermittent, but rather dramatic slowdowns in the system. Please note, the slowdowns are reported to be occurring in the entire system. What would be a good place to look when this happens and get some quick feedback? Thank you very much! Best regards, Alex Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and moreDo you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
newbie dba question
Hello Gurus, I heard that if I can get great ORACLE advice, this is the place, so here is my question. I've been asked to take over an existing db in production. What would be the right way to get a "quick" understanding on what's happening in it in terms ways for proactive tuning? I am just getting started while trying to be ahead of the curve. Is this something I should be looking into, or is it more like if it ain't broke, don't fix it? :). It'd be nice to get started and have a good view on what's going on. Also, can someone can share their experience on what can be done when customers report intermittent, but rather dramatic slowdowns in the system. Please note, the slowdowns are reported to be occurring in the entire system. What would be a good place to look when this happens and get some quick feedback? Thank you very much! Best regards, AlexDo you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
Re: Perl Modules
search.cpan.org look for database or oracle or dbi On Tue, 25 Feb 2003, sstefick wrote: > I've done some basic Perl programming for UNIX Sys admin kinda tasks, but now > I'm looking to get more into the DB functionality of it. I was wondering if > anyone could give me a list of Perl Modules I should have for effective DB > programming in Perl. > > Jared, I know this is definitely your area > > Thanks, > Scott > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: sstefick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
I think thats the goal of .NET CLI. Write in anything ... mix and match. On Fri, 21 Feb 2003, Nelson, Allan wrote: > Now this thread has gone on for a while so its time for my contribution > :-). PL/SQL is such a necessary although pedestrian language that its > not interesting. Of the scripting languages TCL, PERL, and Python all > include facilities for embedding them into other code or adding other > code to them. What we should do is mount an Open Source project to > embed Perl and TCL into Python so that we could create one large > abomination in which any syntax or facility that pleases us could be > used. Concealing your intellectual property would be simple. Write > whatever suites you at the time, no one, not even you, will be able to > figure out what you wrote after you've been away for it a week. > > Allan > > -Original Message- > Sent: Thursday, February 20, 2003 11:59 PM > To: Multiple recipients of list ORACLE-L > > > > Assembler. > > > On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > > I wonder if I can throw in a further caveat to the choices people > > would make? > > > > If you had to choose a programming language in which to write a > > program or application in which you wished to conceal your > > intellectual property, which would you use? > > > > peter > > edinburgh > > > > -Original Message- > > Sent: Tuesday, February 18, 2003 10:56 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > On top of learning Oracle, which programming languages would also > > benefit some1 learning Oracle? Perl? Java? How would these languages > > > be used? > > > > > > > > * > > This e-mail message, and any files transmitted with it, are > > confidential and intended solely for the use of the addressee. If > > this message was not addressed to you, you have received it in error > > and any copying, distribution or other use of any part of it is > > strictly prohibited. Any views or opinions presented are solely those > > of the sender and do not necessarily represent those of the British > > Geological Survey. The security of e-mail communication cannot be > > guaranteed and the BGS accepts no liability for claims arising as a > > result of the use of this medium to transmit messages from or to the > > BGS. The BGS cannot accept any responsibility for viruses, so please > > scan all attachments.http://www.bgs.ac.uk > > * > > > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: quoted-printable > Content-Description: > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > > > > __ > This email is intended solely for the person or entity to which it is addressed and > may contain confidential and/or privileged information. Copying, forwarding or > distributing this message by persons or entities other than the addressee is > prohibited. If you have received this email in error, please contact the sender > immediately and delete the material from any computer. This email may have been > monitored for policy compliance. [021216] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nelson, Allan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ----- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and i
RE: best way to provide GUI outside of telnet
HTML is the easiest solution On Tue, 18 Feb 2003 [EMAIL PROTECTED] wrote: > Guys, > > Here is an interesting dilemna. Support Oracle (On Unix and/or Windows) and > SQL Server (on Windows) and idea is to come up with a common GUI interface > for looking at logs, schedule jobs even if it means using crontab > -graphics for trend analysis > -GUI console > > Any ideas on best architec. language for this? > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
What's your goal? If you are writing scripts then use perl or python. IMO, python is more maintainable when your codebase gets bigger. If you're writing a system or application python is still good. If your goal is to get on the hype then go java, xml, .net, and throw in a webservice API. Also, you don't need to know how these work, but you do need to know how to use the wizards that can generate code for these. On Tue, 18 Feb 2003, Les Ayudo wrote: > On top of learning Oracle, which programming languages would also benefit some1 >learning Oracle? Perl? Java? How would these languages be used? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
If you are using C/C++ look into www.swig.org to make your life easier On Tue, 18 Feb 2003 [EMAIL PROTECTED] wrote: > C > Shell Scripting > Perl > Pl/SQL - "not really a programming language" > Java > > Now, if the more developer-minded DBA's amongst us could rate them as % > important that would be cool! > > -Original Message- > Sent: Tuesday, February 18, 2003 11:56 AM > To: Multiple recipients of list ORACLE-L > > > On top of learning Oracle, which programming languages would also benefit > some1 learning Oracle? Perl? Java? How would these languages be used? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix research source ???
No. They are both free. BSD is basically pure ATT unix; Linux is a kernel with GNU's tools thrown on. On Thu, 13 Feb 2003, Lyndon Tiu wrote: > Difference between Unix and Linux is $$$. > > -- > Lyndon Tiu > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Lyndon Tiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off Topic: Where is the software industry headed?
India then China On Thu, 13 Feb 2003, KENNETH JANUSZ wrote: > Does anyone know of an article(s) that discuss the future direction of the software >industry (available on the web)? > > Thanks much, > Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question about RMAN and recovery scenario.
Hello Folks, Thank you everybody for help. Sorry to confuse you I forgot to show what version I am using for testing... It is 9iR2. I just realized why I got unexpected behavior of recovery scenario during my testing. I removed datafiles with started instance. And when my script tried to login to rman error happened. Not I tried same scenario with stopped instance and it worked in proper way. Hm, I tried to login as sysdba to rman (user in target DB should be sysdba). Did I need to access SYSTEM tablespace when I logged in as SYSDBA? It means if instance started and SYSTEM tablespace gone I couldn't login as SYSDBA even to stop instance with SHUTDOWN ABORT??? Am I right? Monday, February 10, 2003, 3:13:56 PM, you wrote: AA> Hello Folks, AA> I am just working with recovery scenarios and have question about AA> rman. AA> Consider following situation: AA> 1. Use recovery manager without catalog only control file. AA> 2. Have level 0 database backup + level 1 backup. AA> If we lost all datafiles except datafiles from SYSTEM it is not a AA> problem to recover database. Also if RMAN uses catalog it works good. AA> But in scenario if we lost all datafiles (including all files from AA> SYSTEN tablespace) how to recover database? AA> Thank you for your help. AA> -- AA> Best regards, AA> Alex mailto:[EMAIL PROTECTED] -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Question about RMAN and recovery scenario.
Hello Folks, I am just working with recovery scenarios and have question about rman. Consider following situation: 1. Use recovery manager without catalog only control file. 2. Have level 0 database backup + level 1 backup. If we lost all datafiles except datafiles from SYSTEM it is not a problem to recover database. Also if RMAN uses catalog it works good. But in scenario if we lost all datafiles (including all files from SYSTEN tablespace) how to recover database? Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: RMAN - delete obsolete?
Hello Lads, Thanks a lot for useful answers. -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antwort: Re: Dump table to file, edit and reimport
hi aidan,
the following script will create .ctl and .dat files for each table of
OWNER.
These files can then be used with sqlldr.
HTH alex
#!/bin/ksh
###
#
# Desc: create CTL and DAT files for sqlldr usage
#
###
#set -x
USR=user/password
echo "set feedback off
set pagesize 0
select table_name from all_tables where owner like 'OWNER';" | sqlplus -s
$USR | while read TABL
do
STR1="nothing"
STR="nothing"
COLUM="nothing"
TYPE="nothing"
echo "desc $TABL" | sqlplus -s $USR | awk '{print $1 " " $2}' |
tail +3 | grep "[A-Z]" | while read COLUM TYPE
do
if [ "$STR" = "nothing" ]
then
STR=$COLUM
STR1=$COLUM
else
if [ "$TYPE" = "DATE" ]
then
STR="$STR || '|' ||
to_char($COLUM,'DD-MON-YY:HH24:MM:SS')"
STR1="$STR1,$COLUM DATE
'DD-MON-YY:HH24:MM:SS'"
else
STR="$STR || '|' || $COLUM"
STR1="$STR1,$COLUM"
fi
echo $STR > STR
echo $STR1 > STR1
fi
done
echo "set feedback off
set pagesize 0
set linesize 3000
select `cat STR`|| '|' from $TABL;" | sqlplus -s $USR >> $TABL.dat
echo "LOAD DATA" > $TABL.ctl
echo "INFILE '$TABL'" >> $TABL.ctl
echo "INTO TABLE $TABL" >> $TABL.ctl
echo "FIELDS TERMINATED BY '|'" >> $TABL.ctl
echo "(`cat STR1`)" >> $TABL.ctl
done
# END OF SCRIPT
Daniel Wisser
apyrus.com> Kopie:
Gesendet von: Thema: Re: Dump table to file,
edit and reimport
[EMAIL PROTECTED]
06.02.2003 16:28
Bitte antworten an
ORACLE-L
hi!
unload and load work like that
SQL> exp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable)
SQL> imp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable)
but i don't think you will have a good time editing the file.
if you want a | delimited file, you should use spool and gerenate
the file you need.
daniel
Aidan Whitehall wrote:
>
> In Sybase's ASA there was an "unload" command which wrote to a text file
> the SQL to recreate a table, along with all it's data which running the
> SQL then imported. This allowed you to very easily dump a table, edit
> it's structure and suck the data back in.
>
> The closest thing I've found in Oracle is right-clicking on a table |
> Data Management | Export. However, we're not running the Oracle
> Management Server (just because we don't know how to set that up yet),
> so this functionality isn't available.
>
> Barring installing OMS, is there a quick and dirty way to do this?
>
> And, if the answer is "no", is OMS easy to
Antwort: SAN, Heterogenous environments, Backups
Hemant, have you considerd HP Openview Omniback or related products form Veritas ?? cheers alex Hemant K Chitale t.com.sg>Kopie: Gesendet von:Thema: SAN, Heterogenous environments, Backups [EMAIL PROTECTED] 06.02.2003 02:33 Bitte antworten an ORACLE-L We are considering implementing a SAN, using Sun StorEdge SS9970 [OEM from Hitachi], where database servers will be a mix of Sun Solaris and HP HPUX running Oracle 8i, 9i, 9iRAC [in phase-2]. As the database files will be on File Systems [Sun or HP], the solutions provider says that backups of the HP file systems cannot be done by the backup server running Solaris. The proposal is to use "shadow copies". The Sun Engineer says that the "shadow copy" must be mounted as a file system on the backup server and as the backup server is a Sun server it wouldn't be able to mount the HP file system. How are Heterogenous implementations on a SAN done ? How are backups done ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antwort: OT: HPUX SCSI Performance
Hi david, of course there is something you can do First tell your sysadmin to stop being so negative !!! Transfererate is data/time, where time is the sum of three steps - seek: time to position the heat to the right location - latency: then r/w head has to wait for the correct sector - transfer: actual transfer of data First you have to do tests to find out where you loose the biggest percetage of time. If transfer is your biggest problem the solution is easy : place the files on the out side sectors of the discs ( outer sectors are up to 4 times faster that inner sectors ). pls refer to man pages of mkfs/lvm to see how you can set up partitions or luns on hp-ux. If seek is your problem than a reorganizing of the data into a more sequential way or setting up bufferpages (kernel parameter in hp-ux) might give you an advantage if the inodes are used frequently and therfore are stored in the bufferpages so no physical read takes place. But of course setting up bufferpages takes away memory so there is a trade off when working with oracle. more or less the same is true for latency. hmmm just said "same" ... google for same and you will find some interesting white papers (S.A.M.E = stripe and mirror everything) HTH alex david hill ateau.ca>Kopie: Gesendet von:Thema: OT: HPUX SCSI Performance [EMAIL PROTECTED] 05.02.2003 17:38 Bitte antworten an ORACLE-L Hi Guys I'm hoping there is sysadmin in the list that can help me. We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec These should be up around 60 - 80 megs right? My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere? Thanks. David Hill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN - delete obsolete?
Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery Solutions - URGENT
Hello Jai, Tuesday, February 4, 2003, 4:13:51 AM, you wrote: Jic> Dear friends, Jic> Could someone enlighten me on the steps to be carried out using RMAN Jic> and using OS commands for Recovery if : Jic> 1. A current redo log file is corrupted. Jic> 2. The System TS is corrupted. Jic> Thanks for your help in advance. Jic> Best Regards Jic> Jai Do you have any previous backups? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antwort: How to create a new oracle database from SVRMGRL??
majid o.com> Kopie: Gesendet von:Thema: How to create a new oracle database from SVRMGRL?? [EMAIL PROTECTED] 04.02.2003 16:50 Bitte antworten an ORACLE-L >1)how can I create a new database frm SVRMGRL ? pathes have to exist with the right owner and permissions as well as init.ora. If you use dbassist you can create all the scripts. #!/bin/ksh ORACLE_SID=yourdb export ORACLE_SID /oracle/8.1.6/bin/svrmgrl << EOF spool /oracle/8.1.6/admin/yourdb/create/crdb1.log connect internal startup nomount pfile = "/oracle/8.1.6/admin/yourdb/pfile/inityourdb.ora" CREATE DATABASE "yourdb" maxdatafiles 128 maxinstances 8 maxlogfiles 32 character set US7ASCII national character set US7ASCII DATAFILE '/oracle/8.1.6/oradata/yourdb/system01.dbf' SIZE 54M AUTOEXTEND ON NEXT 640K logfile '/oracle/8.1.6/oradata/yourdb/redo01.log' SIZE 1000K, '/oracle/8.1.6/oradata/yourdb/redo02.log' SIZE 1000K, '/oracle/8.1.6/oradata/yourdb/redo03.log' SIZE 1000K; disconnect spool off exit EOF >2)can I have more than one database running in >oracle8i? jep >thanks --- [EMAIL PROTECTED] wrote: > You can use DBCA(Database Config Assistant) to > create a new Oracle DB or > issue the > commands starting from Create database . from > SVRMGRL. > > > > > > majid <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 02/04/03 08:43 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:How to create a new oracle > database > > > Hi, I am new to oracle, I just installed oracle8i in > windows2000, durring the installation I called the > default database "test", I wrote a small java class > using the JDBC, everything is working fine, my > question please : > > 1)can I create another database in oracle (leave the > database "test")so I will have two databases in > oracle > ? > > 2)How can I create a database ? > > Thanks, your help is appreciated. > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: majid > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Antwort: RE: OT: Cron not working
Vladimir: "fuser /var/log/cron" and "lsof" might be a starting point to find out what went wrong. It will give you a list of programs that currently have this inode open. If one of these programs has opened the logfile in blocking mode then other programs will simply sit there and wait or time out depending on the implementation ( ioctl,termio ) when they try to open the logfile. Under some circumstances it is possible that the kernel (who keeps the list of open inodes and their condition) does not get notified when the program owning this inode died, rarly happens as kernels are quite robust. Therefor I am sure a reboot would have solved the problem as well allthought not recomended. So you would have to inspect the relevant kernel tables (adb on hp-ux, maybe the /proc directory under red hat offers help here). The reason why it worked when you deleted and touched the file was because it then has received a new inode as "ls -i" would show and therefore the related lock is pointing to another destination. After the fopen only the inode is relevant not the name any more. of course if cron is not working the first thing you should check is if the daemon is running :-))) HTH cheers alex An: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Gesendet von: Kopie: [EMAIL PROTECTED] Thema: RE: OT: Cron not working 04.02.2003 15:39 Bitte antworten an ORACLE-L Vladimir, I have seen 2 replies to questions today that were less than tactful, yours and one regarding awk & ksh If you post a message asking for help and someone tries to help then it is bad manners to be critical of that help. I am replying to this because I also replied to your post with some basic info on the use of cron, the same as Robert did. If we both read your mail and thought you had minimal knowledge of cron then perhaps your post was at fault , not those who offer help. Glad to hear you have sorted the problem anyway John -Original Message- Sent: 04 February 2003 13:19 To: Multiple recipients of list ORACLE-L Oh, really? I'm not beginner... Anyway, thanks... Solution was weird... When I deleted /var/log/cron file, then touched /var/log/cron and then started cron - everything went back to normal. Why the f&(#$^%* it wasn't working, I don't understabd... /var/log/cron was small (~30k), "df -k /var/log" gave me about 1 Gig of free space... Yet, cron was not working... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 04, 2003 13:23 > $ps xea | grep crond > > Will show you if the cron process is running or not > > -rje > > > VB> Hello to everyone... > > VB> Red Hat 6.2 > > VB> How do I find out what is wrong with cron? From January 15th until today > VB> cron is not working... My (oracle's) crontab file HAS not changed... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Re: Restricting the range of values in a field
Hello Aidan,
Thursday, January 30, 2003, 4:00:40 PM, you wrote:
AW> Is there any way you can specify that the only permissible values (is it
AW> called a domain?) that can be entered in varchar2 field in an Oracle
AW> table to, for example, A, B and C?
AW> We can restrict what values users can enter at the application level,
AW> but it would be nice to be able to also restrict what can be entered at
AW> the database level, in case other means of entering data are ever used
AW> or if the application layer fails, for whatever reason, to trap an
AW> unwanted value.
AW> Thanks
Use CHECK constraint.
Like
ALTER TABLE a1
ADD CONSTRAINT CHECK column1 IN ('A','B','C')
--
Best regards,
Alexmailto:[EMAIL PROTECTED]
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Andriyashchenko
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Perl - Was Unix time conversion function
You can always outsource your perl development to me. :) On Tue, 28 Jan 2003, Hately, Mike (NESL-IT) wrote: > Perl kind of makes sense but I haven't reached the point where it clicks and > becomes natural. I still need to think about it very hard when I'm writing > it. Hence, a lot of the time I fall back on shell scripts supplemented by > pre-written (some would say shamelessly ripped off) perl code for the stuff > that would get really messy is ksh. > > Regards, > Mike Hately > > > -Original Message- > <mailto:[EMAIL PROTECTED]> ] > Sent: Tuesday, January 28, 2003 1:40 AM > To: Multiple recipients of list ORACLE-L > > > Cary I once thought I wanted to do some Perl coding... So I bought a > book and started to play with it. It made my head bleed... literally I had > little droplets of blood emerging from my head They rushed me to the > hospital and put me in the Perl ward where I languished for days on IV's of > Mountain Dew and pulverized Ritz crackers. it was close. > > In my mind there is nothing obvious about Perl, this coming from and old C > coder who did pointers and linked lists in his sleep years ago. I don't > know, maybe I was having a bad day and it's time to get my "learning Perl" > book out again > > Anyone else feel that way about Perl or am I a lone wolf in a Perl world? > > RF > > > > > > ** > > The information contained in this e-mail is confidential and > intended only for the use of the addressee. If the reader of > this message is not the addressee, you are hereby notified > that you have received this e-mail in error and you must not > copy, disseminate, distribute, use or take any action as a > result of the information contained in it. > > If you have received this e-mail in error, please notify > [EMAIL PROTECTED] (UK 01384 275454) and delete it > immediately from your system. > > Neither Npower nor any of the other companies in the > Innogy group from whom this e-mail originates accept any > responsibility for losses or damage as a result of any viruses > and it is your responsibility to check attachments (if any) for > viruses. > Npower Limited > Registered office: Windmill Hill Business Park, Whitehill > Way, Swindon SN5 6PB. Registered in England and Wales: > number 3653277 > This e-mail may be sent on behalf of a member of the Innogy > group of companies. > ** > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hately, Mike (NESL-IT) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Perl - Was unix time conversion function
; convert a standard unix seconds-since-Jan-1970 epoch > > time (stored as a number) to a readable date? > > > > It would save me a lot of time not having to re-invent the > > wheel. > > > > Matt > > > > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > > My computer beat me at chess, but I won > > when it came to kick boxing. > > > > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > The information contained in this communication, > including attachments, is strictly confidential > and for the intended use of the addressee only; > it may also contain proprietary, price sensitive, > or legally privileged information. Notice is > hereby given that any disclosure, distribution, > dissemination, use, or copying of the information > by anyone other than the intended recipient is > strictly prohibited and may be illegal. If you > have received this communication in error, please > notify the sender immediately by reply e-mail, delete > this communication, and destroy all copies. > > > Corporate Systems, Inc. has taken reasonable precautions > to ensure that any attachment to this e-mail has been > swept for viruses. We specifically disclaim all liability > and will accept no responsibility for any damage sustained > as a result of software viruses and advise you to carry out > your own virus checks before opening any attachment. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: April Wells > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Orawomen (staffing)
On Thu, 9 Jan 2003, Boivin, Patrice J wrote: > People gravitate toward comfort first and foremost. Why hire someone who > knows more than you and keeps telling you management is incompetent? Think > about it. You will have to work with these new hires on a daily basis, life > is hard enough as it is... Problems never happen... In any case hiring > people is such a hassle... That's right. As hire As, Bs hire Cs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Orawomen
At firms where intelligence is all that matters you can look like a pig and you'll still be respected. Most people are not that smart and work for companies where you are judged on looks and personality. On Wed, 8 Jan 2003, Rachel Carmichael wrote: > > very technical, very detailed, and very dedicated. The fact that > > they were both attractive didn't hurt either. One majored in math > > I'm about to start a flame war here, I just know it. > > WHY does it matter to mention the attractiveness of the female DBAs? > When I talk about someone I work with, I don't comment on how > attractive he or she is. I talk about whether or not the person can do > the work and I can learn from him or her. > > It's the subtle things that promote the attitude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Perl DBI/SQL question - For those who use it...
What do you have so far.
You can read in a script like so...
#perl dbicode.pl < script.sql
while () {
chomp;
$sql .= $_;
}
print $sql;
On Fri, 3 Jan 2003, Koivu, Lisa wrote:
> Hi everyone,
>
> This may be a stupid question. If so please humor me with a stupid answer.
> However:
>
> I FINALLY have the fun fun fun chance to change one of my data loads to use
> the DBI instead of the procedures I hacked together. In true ksh style I
> had written my loads to fire a sql script (calling a stored proc) that was
> stored separately. It seems to me the DBI wants the text of the sql script
> embedded piece by piece in the code. I have looked around for examples
> because even though the DBI seems straightforward, it doesn't take much to
> confuse me. I don't see examples of firing a sql script from the DBI (like
> this sqlplus /@dbname < @script.sql > logfile.log ... Gosh do I miss unix,
> everything was SO EASY)
>
> So my questions to you, my learned friends, are:
>
> 1. is it not perl-style to store the sql in a separate file? I understand I
> may be missing the opportunity for more specific error handling here but
> honestly at this point it does not matter. The thing fails, I restart the
> whole script.
>
> 2. Does anyone have an example of firing the DBI and calling a sql script
> like I could so easily do in ksh?
>
> Any and all comments are welcome. Thank you
>
> I wish everyone a rested and relaxing weekend.
>
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Java to Database Basics
First do you know how to program? Really program; not talk about how to program but actually type in code and get what you want. If you do then learning 85% of java or any language won't take too long. I sugest you download some JDBC examples and try them out. Change stuff then try again. On Mon, 23 Dec 2002, VIVEK_SHARMA wrote: > > More & More people are Accessing the Oracle Database Thru Java Calls , programs etc. > > What basics , related Database performance issues etc. are part of this Java game >with respect > to the Database ? > > How can a structured learning be done on this ? > > Total Novice on Java here though familiar with Oracle Databases (DBA) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Regular Expressions in SQL
owa_pattern package On Wed, 18 Dec 2002 [EMAIL PROTECTED] wrote: > What's the easiest way to do regular expressions in an SQL query? > > If the answer is creating a function, does anyone have one they wouldn't mind > sharing? > > Thanks, > Chris > > Christopher Beckley > OCPDBA, MCDBA, MCSD, EIEIO > ThirdParadigm LLC > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OEM email problems (unix)
More info needed. But see if you can ping the mail server. Make sure you are actually using the mail server you think you are and not solaris's sendmail. Try putting MS exchange host and IP in /etc/hosts On Sun, 15 Dec 2002, Don wrote: > we are stumped. > > We have installed OEM 9.2, the console, the OMS, and 9.2 repository on a > solaris 5.9 box. > > So far, we are not able to send any email from the console, no matter what > we try. The messages generally indicated that the email SMPT host (a MS > exchange server) can not be found. > > We found some info on Metalink that led us through some command line tests, > which were all successful. > > The Unix admin, the network folks, the Exchange people, and even a > consultant that wondered by, have all given up. > > any ideas? > > Don > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SLOW SITE
On Mon, 9 Dec 2002, Seema Singh wrote: > Hi > One of my client website is slow and they are running AOL server for > application.Can any one suggest what are the things need to look for better > performance? Everything. Network, database, code, OS, machine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with Java
My condolences to you.
On Tue, 3 Dec 2002, DENNIS WILLIAMS wrote:
> John - I forwarded your message to one of our newly-trained Java
> programmers. He replied with:
>The code is incomplete, how are they handling the connection.
>Obviously the while loops are messing each other up.
>There are multiple ways of handling this.
>If I see the complete code I can be more specific.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, December 03, 2002 12:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> All,
>
> I am beginning the journey into JAVA and have hit an odd behavior
> (well, probably not, but I can't see any reason for it). I am
> building a list of tablespaces and the datafiles that belong to them.
> The open to the database is working fine. When I use:
>
> ResultSet myTablespaces = myStatement.executeQuery(
> "SELECT tablespace_name " +
> "FROM dba_tablespaces " +
> "WHERE contents = 'PERMANENT'"
> );
>
> while (myTablespaces.next()) {
> // retrieve the user from the row in the ResultSet using the
> // getString() method
> ct = ct + 1;
> String tablespace = myTablespaces.getString(1);
> System.out.println("Tablespace " + ct + " is: " + tablespace);
> }
> myTablespace.close();
>
> I am generating a list of tablespaces and the output is as expected.
> When I add a second result set, the first datafile of the first tablespace
> returns and then the program completes:
>
> ResultSet myTablespaces = myStatement.executeQuery(
> "SELECT tablespace_name " +
> "FROM dba_tablespaces " +
> "WHERE contents = 'PERMANENT'"
> );
> while (myTablespaces.next()) {
> // retrieve the user from the row in the ResultSet using the
> // getString() method
> ct = ct + 1;
> String tablespace = myTablespaces.getString(1);
> System.out.println("Tablespace " + ct + " is: " + tablespace);
>
> ResultSet myDataFiles = myStatement.executeQuery(
> "SELECT file_name " +
> "FROM dba_data_files " +
> "WHERE tablespace_name = '" + tablespace + "'"
> );
>
> while (myDataFiles.next()) {
> String filename = myDataFiles.getString(1);
> System.out.println(" " + filename);
> }
> myDataFiles.close();
> }
> myTablespaces.close();
>
>
> Anybody with some Java experience have any insite?
>
> As always, TIA,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Help with Java
comment out
myDataFiles.close();
and see what happens.
On Tue, 3 Dec 2002, John Weatherman wrote:
> All,
>
> I am beginning the journey into JAVA and have hit an odd behavior
> (well, probably not, but I can't see any reason for it). I am
> building a list of tablespaces and the datafiles that belong to them.
> The open to the database is working fine. When I use:
>
> ResultSet myTablespaces = myStatement.executeQuery(
> "SELECT tablespace_name " +
> "FROM dba_tablespaces " +
> "WHERE contents = 'PERMANENT'"
> );
>
> while (myTablespaces.next()) {
> // retrieve the user from the row in the ResultSet using the
> // getString() method
> ct = ct + 1;
> String tablespace = myTablespaces.getString(1);
> System.out.println("Tablespace " + ct + " is: " + tablespace);
> }
> myTablespace.close();
>
> I am generating a list of tablespaces and the output is as expected.
> When I add a second result set, the first datafile of the first tablespace
> returns and then the program completes:
>
> ResultSet myTablespaces = myStatement.executeQuery(
> "SELECT tablespace_name " +
> "FROM dba_tablespaces " +
> "WHERE contents = 'PERMANENT'"
> );
> while (myTablespaces.next()) {
> // retrieve the user from the row in the ResultSet using the
> // getString() method
> ct = ct + 1;
> String tablespace = myTablespaces.getString(1);
> System.out.println("Tablespace " + ct + " is: " + tablespace);
>
> ResultSet myDataFiles = myStatement.executeQuery(
> "SELECT file_name " +
> "FROM dba_data_files " +
> "WHERE tablespace_name = '" + tablespace + "'"
> );
>
> while (myDataFiles.next()) {
> String filename = myDataFiles.getString(1);
> System.out.println(" " + filename);
> }
> myDataFiles.close();
> }
> myTablespaces.close();
>
>
> Anybody with some Java experience have any insite?
>
> As always, TIA,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: OT: Password Generator...
what language? random() or rand() is usually a part of every language. On Thu, 21 Nov 2002, Loughmiller, Greg wrote: > Hey folks- > I have a question that was presented to me by a web development team.. > > Does anyone know of products,procedures,etc that would generate a random > password for a user? For example-similar to that at MetaLink when you forget > your password-and they send you a new one that is just a string of > characters/numeric digits... > > Thanks! > > Greg Loughmiller > Sr Manager - Enterprise Data Architecture > gloughmiller (IPS) > 678.893.3217 (office) > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New development in Cobol or PL/SQL - please help
On Wed, 20 Nov 2002, Babette Turner-Underwood wrote: > As far as staff and skills, the current job market > has an excess of persons with PL/SQL skills. > So I don't think the decisions was made with any > respect to how many people will be able to maintain > this over the next 10 years. The number of people > with COBOL skills is declining at the organization. > But if they keep doing new development in COBOL, > then maybe they will be able to convince the younger > programmers to learn it :-P Only if the younger programmers are in their fifties. COBOL is a maintainance programmers language. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Too many db calls
Does anybody knows if it possible to implement something like bulk binds and bulk collection facilities using VB - like ADO. Alex Hillman -Original Message- McDonald Sent: Saturday, November 16, 2002 1:19 PM To: Multiple recipients of list ORACLE-L With the advent of bulk bind and bulk collection facilities in PL/SQL, you can get very close to the "correct" SQL mechanisms...its just that not many people tend to do it, and you end up with a gazillion 'one-row-at-a-time' applications out there. Cheers Connor --- Cary Millsap <[EMAIL PROTECTED]> wrote: > Greg, > > That's one case. PL/SQL is a really poor language in > which to write an > application. The language tricks you into believing > that writing a > scalable application can be accomplished in just a > few lines of 4GL > code, but it's really not true. To write scalable > PL/SQL, you need to > use DBMS_SQL. The resulting code is even more > cumbersome than the same > function written in Pro*C. > > Any language can be abused, though. We see a lot of > Java, Visual Basic, > and Powerbuilder applications that do stuff like... > > 1. Parse inside loops, using literals instead of > bind variables. > 2. Parse *twice* for each execute by doing > describe+parse+execute. > 3. Manipulate one row at a time instead of using > array processing > capabilities on fetches or inserts (this one, > ironically, raises a > system's BCHR while it kills response time). > 4. Join result sets in the application instead of in > the database. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic, Dec 9-11 Honolulu > - 2003 Hotsos Symposium on OracleR System > Performance, Feb 9-12 Dallas > - Jonathan Lewis' Optimising Oracle, Nov 19-21 > Dallas > > > -Original Message- > Sent: Saturday, November 16, 2002 2:38 AM > To: Multiple recipients of list ORACLE-L > > Cary, > > Thank you. > > Could you elaborate on the issue of excessive > database calls, which show > up > as excessive network traffic? > > I can picture a PL/SQL loop, which executes an SQL > statement over and > over > again. This would produce many database calls, and > it might be possible > to > remove the loop altogether, replacing it with a > single SQL statement. > This > would reduce the database calls. > > Is this the "classic" type of situation that > produces too many db calls? > Or > are there other situations I'm missing that are more > likely to be the > source > of this problem? > > Thanks again. > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Friday, November 15, 2002 4:13 PM > > > > Greg, > > > > I believe that the cultural root cause of the > excessive LIO problem is > > the conception that physical I/O is what makes > databases slow. Disk > I/O > > certainly *can* make a system slow, but in about > 598 of 600 cases > we've > > seen in the past three years, it hasn't. ["Why you > should focus on > LIOs > > instead of PIOs" at www.hotsos.com/catalog] > > > > The fixation on PIO of course focuses people's > attention on the > database > > buffer cache hit ratio (BCHR) metric for > evaluating efficiency. The > > problem is that the BCHR is a metric of INSTANCE > efficiency, not SQL > > efficiency. However, many people mistakenly apply > it as a metric of > SQL > > efficiency anyway. > > > > Of course, if one's radar equates SQL efficiency > with the BCHR's > > proximity to 100%, then a lot of really bad SQL is > going to show up on > > your radar wrongly identified as really good SQL. > ["Why a 99% buffer > > cache hit ratio is not okay" at > www.hotsos.com/catalog] > > > > One "classic" result is that people go on search > and destroy missions > > for all full-table scans. They end up producing > more execution plans > > that look like this than they should have: > > > > NESTED LOOPS > > TABLE ACCESS BY INDEX ROWID > > INDEX RANGE SCAN > > TABLE ACCESS BY INDEX ROWID > > INDEX RANGE SCAN > > > > This kind of plan produces great hit ratios > because it tends to > revisit > > the same small set of blocks over and over again. > This kind of plan is > > of course appropriate in many cases. But sometimes > it is actually less > > work in the database to use full-table scans. > ["When to use a
RE: OT ksh day of week yesterday
same thing. time offset. This may not work on all systems because of how TZ is used. On Wed, 13 Nov 2002, Sherman, Edward wrote: > My TZ is EST5EDT and I think the 5 implies GMT-05:00 > What does the 26 in EST26EDT imply? > > Just curious. > Ed > > -Original Message- > Sent: Wednesday, November 13, 2002 2:24 PM > To: Multiple recipients of list ORACLE-L > > > yesterday=$(TZ=EST26EDT date +%a) > > On Wed, 13 Nov 2002, Barbara Baker wrote: > > > > > Will someone take pity on this poor VMS'er lost in a unix world?? > > > > I'm trying to create a script (ksh) that reads a log file created > > yesterday. The log files are created with `date +%a` appended to the > > end of the log file name. Last night a log file was created called > > arc_indexlog.Tue It's easy enough to get today > > > >TDAY="`date +%a`" > >grep -i "ora" /orasrv/ops/maint/logs/arc_indexlog.$TDAY > >grep -i "ora" /orasrv/ops/maint/logs/adv_indexlog.$TDAY > > > > but how do I get yesterday in the same format? (i.e., Tue instead of Wed) > I man'd date, but it was no help. > > > > Thanks for any help. > > > > Barb > > > > > > > > - > > Do you Yahoo!? > > U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sherman, Edward > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT ksh day of week yesterday
yesterday=$(TZ=EST26EDT date +%a) On Wed, 13 Nov 2002, Barbara Baker wrote: > > Will someone take pity on this poor VMS'er lost in a unix world?? > > I'm trying to create a script (ksh) that reads a log file created yesterday. The >log files are created with `date +%a` appended to the end of the log file name. Last >night a log file was created called arc_indexlog.Tue It's easy enough to get today > >TDAY="`date +%a`" >grep -i "ora" /orasrv/ops/maint/logs/arc_indexlog.$TDAY >grep -i "ora" /orasrv/ops/maint/logs/adv_indexlog.$TDAY > > but how do I get yesterday in the same format? (i.e., Tue instead of Wed) I man'd >date, but it was no help. > > Thanks for any help. > > Barb > > > > - > Do you Yahoo!? > U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE
try kill -TERM On Thu, 31 Oct 2002 [EMAIL PROTECTED] wrote: > Reboot and open a TAR. > > Jared > > > > > > "Sinardy Xing" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 10/31/2002 12:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Unkillable Background process "SHUTDOWN ABORT LEAVES >UNKILLABLE > PROCESSES" > > > Hi, > > I am using solaris 8 > > > Sinardy > > -Original Message- > Sent: 31 October 2002 15:43 > To: Multiple recipients of list ORACLE-L > PROCESSES" > > > Hi all, > > When I do shutdown abort my LGWR and CKPT still around and also kill -9 > cannot get rid of them anyone know why ? > > because of this my cluster fail to failover > > Thanks > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix Q: Substring-ing an output.
ps -ef|grep [p]mon | awk '{ print $7 }' | sed 's/ora_pmon_//'
On Sun, 27 Oct 2002, Ross Collado wrote:
>
> Hi All,
>
> I want to feed my shell script with the names of currently running
> databases. I thought of using ps -ef|grep [p]mon. What I got was the
> following:
> oracle 20113 1 0 Oct 25 ?0:01 ora_pmon_TLDEV
> oracle 898 1 0 Jul 22 ?0:06 ora_pmon_TLQA
> oracle 944 1 0 Jul 22 ?0:07 ora_pmon_TLQAVAR
> oracle 19588 1 0 Oct 25 ?0:00 ora_pmon_DBMON
> oracle 13509 1 0 12:16:13 ?0:00 ora_pmon_RMAN
> oracle 20450 1 0 Oct 25 ?0:00 ora_pmon_PRDINF
> oracle 13026 1 0 Oct 26 ?0:00 ora_pmon_TLDVVAR
>
> What I wanted is get only the db name part eg. TLDEV, RMAN, DBMON,etc. I
> don't want to rely on oratab file.
> I was thinking of using 'cut' to cut out the last field and do some ${X##}
> (variable pattern substitution) to get to the dbname bit. The trouble is
> the number of fields in a ps -ef output is not consistent. As you can see
> I've just restarted RMAN and now it only has 8 fields as compared to 9 for
> the others.
>
> Any suggestions? Or another way of doing it?
> Using KSH on Solaris 8.
>
> Thanks.
> Ross
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ross Collado
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle DBA vs JAVA programmer???
DBA would be a safer bet. As far as programmer, don't pigeon hole yourself as a Java programmer but rather someone who knows how to program. But if you only have a few years of VB then you'll wind up doing maintenance. On Fri, 25 Oct 2002, Janet Linsy wrote: > Hi all, > > I need your idea. I got laid off as an Oracle DBA (3 > yrs experience), and it's hard to find a DBA position > here(I'm in Colorado). I had couple of years > experience programming (3 yrs) in VB, and currently > learning JAVA. I'd like to know is JAVA market still > hot? (I can relocate to New Jersey, any memeber in > New Jersey? how is the market over there, for Oracle > DBA or JAVA programmer?) > > What do you think which position is better, Oracle DBA > or Java programmer? Based on compensation, workload, > market demand, etc, etc ... > > Thanks a lot! > > Janet > > > __ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Janet Linsy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Theory v Practice
On Wed, 23 Oct 2002, Mandar A. Ghosalkar wrote: > 3 yrs after ur developers code the VB app, the original team vanishes(they start >working on .net .. or maybe java) > The new team even after going through the docs and vb application libraries, forget >the right joins and insert invalid data/update rows in the master without taking care >of the details/ delete some master records, etc. > > What next happens at the call center of ur company ? > > Believe me there would always be a legitimate need (not hack) to correct some data >using sql*plus like tools. At that point you would need to depend on RI. > > -Mandar Great, jobs for everybody. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle or mssql
It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: > Hi list > > Please input why my boss must invest into oracle rather than the cheaper > mssql. > His opinion is that most features are almost the same but mssql does that at > half the price as oracle does. > So why he should not choose mssql is the question > > > > > g.g. kor > rdw ict groningen > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD ?
You need oracel client on your PC can you connect from sqlplus? On Fri, 30 Aug 2002, Seema Singh wrote: > > Hi > I want to use QUEST TOAD software free version.I have Databases on UNIX and > I want to connect from my desk top to UNIX DB box but I am unable to.can > Some one help me if they have? > Thx > -Seema > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: basic Unix question ???
On Thu, 29 Aug 2002, Janet Linsy wrote: > Hi all, > > I have two questions. First, how to find out > information about my unix box, like version, etc. uname -a > > In my box, I can use hostname to get the machine name. > I remember there is a command called version, but I > got "Ksh: version: not found." Any other useful > commands to know about my machine? anything in /bin /usr/bin /usr/local/bin /usr/sbin man man man -k some_keyword_you_are_looking_for > > Actually when I use top, it also returns "ksh: top: > not found." My second question is where does ksh > usually reside, which value should I set for PATH. > > Thank you in advance. > > Janet > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Janet Linsy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: JBDC thin driver
just put the zip file on your path On Tue, 30 Jul 2002, Daniel Wisser wrote: > hi! > > anyone knows an answer to this: > > i want to user JDBC thin driver. i can install it from the > CD on windows using the manually configured installation. > > since thin driver is said to be purely java, i want to use > it on linux, too. which are the necessary files? > > are they in > $ORACLE_HOME\jdbc\lib\classes111.zip > > could not find help in metalink > > thx & regards > > daniel > > -- > Daniel Wisser, Mag. > Papyrus Quality Assurance > DB Team > > ISIS Information Systems > Alter Wienerweg 12 > A-2344 Ma. Enzersdorf, Austria > > Phone: +43-2236-27551-149 > Fax: +43-2236-21081 > E-mail: [EMAIL PROTECTED] > > Hotline: +43-2236-27551-111 > > Visit the ISIS Website: http://www.isis-papyrus.com > > --- > This e-mail is only intended for the recipient and not legally > binding. Unauthorised use, publication, reproduction or > disclosure of the content of this e-mail is not permitted. > --- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Daniel Wisser > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Chart generation tool for db monitoring scripts
perl with GD module On Mon, 29 Jul 2002, Seefelt, Beth wrote: > > MRTG is one. > > -Original Message- > Sent: Monday, July 29, 2002 2:14 PM > To: Multiple recipients of list ORACLE-L > out > > > Does anyone know of any simple utility that will take a data file and > generate a quick chart. I'd like to generate a chart of number of > transactions per time period. I can generate the output through a SQL > query. > > Actually I'd like to do this for more data, but this is just an example. > > Thanks > Raj > __ > Rajendra JamadagniMIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of ESPN > Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seefelt, Beth > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Function
Look for
owa_pattern.match()
On Thu, 18 Jul 2002, Hamid Alavi wrote:
> Hi List,
>
> Is there any way that I can check to see if the value in a variable is a
> number?
>
> Example:
>
> is_number('100') = TRUE
> is_number('ABC') = FALSE
>
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
>
>
>
>
>
> === Confidentiality Statement ===
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> = End Confidentiality Statement =
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT
On Mon, 15 Jul 2002, Johnson, Michael wrote: > Everyone should have been smart enough to sell stocks and > put their money into cash or better yet short stocks > when it was very clear that in the Fall of 2000 after the > initial March 2000 sell off that we were going into > a prolonged Bear market. It's always easy to play monday morning quarterback. I assume you are now retired because you made so much money from the very clear and prolonged Bear market you forcasted in Fall 2000. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT - unix vs linux vs windows - the future
On Mon, 15 Jul 2002, ltiu wrote: > But do all these matter though? Everyone's moving to MS software and *nixes Who is "everyone"? And what software in particular? > are getting rarer and rarer. The fact is that everyone's losing money (Sun, > IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it > or not. > > ltiu > > On Monday 15 July 2002 08:33, Andrey Bronfin wrote: > > "Good bet that smaller Unix vendors will run to Linux before vendors like > > Sun do." > > Not exactly , just look at homepages of sun , ibm , oracle . > > There are more appearences of the word "linux" there than any word in > > Britannica ;-) > > > > > > DBAndrey > > > > * 03-9254520 > > * 058-548133 > > * mailto:[EMAIL PROTECTED] > > > > > > > > > > > > -Original Message- > > Sent: Mon, July 15, 2002 4:13 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Jared - Good point. In addition, other costs to an independent Unix vendor > > are: > >- Staff costs of a large development staff. This cost doesn't vary, > > regardless of the number of customers. Therefore, vendors with a small > > market share have proportionally higher costs. > >- Costs of attracting software vendors. If the Unix version has a large > > market share, application software vendors (like Oracle) will gladly port > > their product to your O.S. However, if your market share is low, vendors > > are reluctant to support your O.S. Then you are trapped in the > > chicken-and-egg syndrome (similar to "nobody will give me a job because I > > don't have experience, but how can I get experience without a job"). Good > > bet that smaller Unix vendors will run to Linux before vendors like Sun do. > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Monday, July 15, 2002 12:53 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > I'm sure that many vendors welcome an opportunity > > to stop paying royalties to AT&T for unix code. I believe > > that all mainstream vendor implementations of unix have > > AT&T base. > > > > Jared > > > > On Sunday 14 July 2002 11:58, Andrey Bronfin wrote: > > > hi ! > > > i might start another war , but i can't resist a part of me which wants > > > to ask : > > > what do you , seasoned gurus, think of everybody's (as it seems to be) > > > plans to abandon the "classic" unix for linux ? > > > In particular , most database vendors (as well as other enterprise > > > > software > > > > > vendors) name linux as the future #1 platform for their DBs (especially > > > given the fact that a DB cluster is not rare any more). > > > It also looks like many development shops shift their efforts to develop > > > > on > > > > > windows (or , in some rare cases, linux ) instead of unix . > > > What do you think about this ? > > > > > > > > > DBAndrey > > > > > > * 03-9254520 > > > * 058-548133 > > > * mailto:[EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT - unix vs linux vs windows - the future
Development shops that actually write native code will target an OS with market share. Now, seeing that alot of code written today is interpreted the move to linux, windows, or beatnix is irrelevent. As far as DB vendors targeting linux they move in herds and have just finished their linux port from when "linux" was a buzzword. On Sun, 14 Jul 2002, Andrey Bronfin wrote: > hi ! > i might start another war , but i can't resist a part of me which wants to > ask : > what do you , seasoned gurus, think of everybody's (as it seems to be) plans > to abandon the "classic" unix for linux ? > In particular , most database vendors (as well as other enterprise software > vendors) name linux as the future #1 platform for their DBs (especially > given the fact that a DB cluster is not rare any more). > It also looks like many development shops shift their efforts to develop on > windows (or , in some rare cases, linux ) instead of unix . > What do you think about this ? > > > DBAndrey > > * 03-9254520 > * 058-548133 > * mailto:[EMAIL PROTECTED] > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: listener configuration on HP serviceguard clusters
Title: RE: listener configuration on HP serviceguard clusters Yes, I do. IP of the node on which listener is running. Like I sad, listener belongs to the none, not package. Alex. - Original Message - From: Adams, Matthew (GEA, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Friday, July 12, 2002 5:43 AM Subject: RE: listener configuration on HP serviceguard clusters Do you have a listener.ora file? Which ip address is in it? Matt Adams - GE Appliances - [EMAIL PROTECTED]Enter any 11 digit prime number to continue. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 11, 2002 10:38 PMTo: Multiple recipients of list ORACLE-LSubject: RE: listener configuration on HP serviceguard clusters Matt, We have two nodes cluster with three packages; two of them have more than one database. Oracle software installed on each node. Each listener belongs to node, not to package. When packaged started on the node it will startup instance(s) and each instance will automatically registered with listener. In client's TNSNAMES.ORA we use package name, which resolved to proper IP address. Alex. -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Subject: listener configuration on HP serviceguard clusters If anybody out there is using HP ServiceGuard for non-OPS/RAC, I would be interested to know how you configure the listeners. Do you use the machine IP address or the package address in the listener.ora (or do you not have a listener.ora and use dynamic registration) One of the sys admins here instists that the following scenerio will not work. three nodes - two with one package each (containing Oracle) and one standby node. When the first package fails over to the standby node, it starts a listener using no listener.ora file, allowing the instances to dynamically register. When the second package fails over to the standby node, it does not start a listener. All client tnsnames.ora files use package names for HOST. Do the instances in the second package register successfully with the listener and can clients connect to them? Matt Adams - GE Appliances - [EMAIL PROTECTED] Enter any 11 digit prime number to continue.
Re: slightly OT, permissions unix/oracle puzzler
for your permissions and umask use all four digits and see what happens. On Mon, 8 Jul 2002, Kathy Duret wrote: > Ok, I log in as oracle, touch a file I get 664 permission on it. > > But when I create a file through OEM or a plsql procedure I get 644 permissions. > > My umask is 02. > > On another system - solaris everything ok. > > Both .profiles are the same. > > Sys admins no help. > > Any clues? > > Thanks, > > Kathy > > Confidential > This e-mail and any files transmitted with it are the property > of Belkin Components and/or its affiliates, are confidential, > and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one > of the named recipients or otherwise have reason to believe > that you have received this e-mail in error, please notify the > sender and delete this message immediately from your computer. > Any other use, retention, dissemination, forwarding, printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kathy Duret > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Perl Question - Split using |
my $HeaderAttributes = "abc|defgh|123"; $HeaderAttributes =~ s/\|/\\|/g; On Fri, 5 Jul 2002, Celine John wrote: > After seeing the e-mails about "Perl for Oracle-DBAs", > I presume, my question wouldn't be completely > inappropriate for this list. > So if you Oracle Gurus, can help me with this Perl > problem, I would greatly appreciate it. > I have a problem with "split" when my delimiter is > "|". > I know that if I escape the pipe, split should work, > that is only when it is a literal like > split(/\|/, "abc|def|123) > > But when my delimiter is to be dynamically read from a > file, I have it in a variable. Then this escaping > stuff doesn't work.. > eg: > my $HeaderAttributes = "abc|defgh|123"; > print "$HeaderAttributes\n"; > my $Delimiter = "\|"; > (@Fields) = split(/$Delimiter/, $HeaderAttributes); > print "Delimiter = $Delimiter Field[0] = > $Fields[0]\n"; > > prints > a > instead of > abc. > > Does somebody have a solution to this. > Thanks much. > > __ > Do You Yahoo!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Celine John > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix - scheduling
http://www.superscripts.com/tutorial/crontab.html On Tue, 2 Jul 2002 [EMAIL PROTECTED] wrote: > Hallo, > > anyone who has a good example on how to write in the crontab if you want to schedule >a job to run every four week. > Is it possible to do that in unix cron job schedule. > > Thanks in advance > > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Things to do when writing scripts in the Korn Shell
Anna Kornikova On Thu, 27 Jun 2002, Jenkins, Michael - EDS wrote: > Just some humor to pass the day. Top things you can do while writing > scripts in the Korn Shell: > > * Listen to a Korn CD > * Eat some popKorn > * Munch on a roasted ear of Korn > * Rub the Korns on your feet > * Have a Cream Korn fight with your mate in the next cube. > * See how many Korn Chips you can burn in a glass ashtray before it expodes > from the heat. > > Ok, so I had two seconds to think of these things as I was listening the new > Korn CD, writing a Korn Shell script. > > --Michael > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jenkins, Michael - EDS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: GNU or [G]NU (Pronunciation of...)
The G sounds like the G in "Good question" On Mon, 24 Jun 2002, mkb wrote: > Ok, how is this pronounced? Is the G in GNU slient or > not? > > mkb > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mkb > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix related - need some info
uname -a top dmesg df -h On Sat, 22 Jun 2002, Ray Stell wrote: > On Sat, Jun 22, 2002 at 09:38:25AM -0800, Vladimir Barac - posao wrote: > > Good day to everyone... > > > > I have two questions related to Linux and Solaris... > > > > * I need do find memory usage (physical, virtual...) of a particular > > proccess. PID is given by by "ps", but what aditional parameters I have to > > provide? At a first glance, output of "man ps" vas confusing... > > > try using top > > > > * How do I find computer's configuration - what CPU, numbers of CPUs, clock, > > amount of memory, number of harddrives, what version of OS, what OS patches > > are applied...? > > look at /etc/syslog.conf which will tell you where your system messages > are, there should be some helpful info there. > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Connecting as sysdba via ODBC / VB
>From where did you download it? Maybe there exist new version of OLEDB provider for ADO? Alex Hillman -Original Message- Bruce (CALBBAY) Sent: Monday, June 10, 2002 11:08 PM To: Multiple recipients of list ORACLE-L Someone in the last few days requested info on connecting as sysdba from VB. I deleted the email at the time but I just downloaded the ODBC driver version 8.1.7.6.0 and found the following: "NEW FEATURES ODBC 8.1.7.6.0 Added support for connection syntax "/ as sysdba" and "/ as sysoper". The "as sysdba" and "as sysoper" string can also be contained in the password field. (Bug 2114033) Added support for the statement attribute SQL_ATTR_RETRIEVE_DATA. (Bug 2165706) ODBC 8.1.7.5.0 Added support for / syntax to be used as username to log on. (as requested by Bug 1094170) " I hope this might be of use and perhaps will work via OCI etc from VB. HTH, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Remove Duplicates
Ferenc, what happened with your web site - at least with Oracle version of it? Alex Hillman -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ferenc MantfeldSent: Tuesday, June 04, 2002 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Remove Duplicates Tom. Replies below. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia -Original Message-From: Terrian, Tom [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 4 June 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: Remove Duplicates I know I have seen this posted before... We have a large range partitioned table that has duplicates in it. What is the fastest way to remove the dups.? I have the following scripts which do it but may be fast or slow. What do you guys use? DELETE FROM tablename WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM tablename GROUP BY fieldnames); [Ferenc Mantfeld] This will be your fastest way, provided you have an index on the columns searched for. Actually the format of the statement would be delete from INVOICE_DETAILS A where A.rowid > (select min(rowid) from INVOICE_DETAILS B where B.INV_NUM=A.INV_NUM and B.LINE_NUM=A.LINE_NUM ) ; Ensure you have a composite index on INVOICE_DETAILS (INV_NUM, LINE_NUM). Or alter table &table_name add constraint duplicate_cons unique key (&column_name) exceptions into exception table;[Ferenc Mantfeld] Problem with this is when you want to delete the duplicates, you have no way of telling, unless you code the min function again. If you have triplicates, and want to keep one of them and blow away the other two, this is a tedious way, and all this does is to help you identify the duplicates. How to find duplicates: select &column_name, count(&column_name) from &table_name group by &column_name having count(&column_name) > 1; [Ferenc Mantfeld] Same as above. only identifies the duplicates, does nothing to remove them. Tom
connect as SYSDBA using ADO
I am trying to find out how to connect as SYSDBA using ADO in Visual Basic. Did not see any mention of sysdba in the doc. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Archiver process in 7.3.4
Anybody knows how to get status of archiver process programmatically in Oracle 7.3.4? This information is available from v$instance in Oracle 8+. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL versus Oracle
This depends on what the interview is for. MySQL, Oracle, Access, PostgresSQL, and SQLServer are all databases and can be accessed with SQL. Other than that, they are all completely different. On Fri, 31 May 2002, Joe Testa wrote: > Anyone on the list done a comparison(or worked with both) MySQL and > Oracle and can give me the good/bad points of My SQL? > > Doing interviewer thing and someone has My SQL who would like to move > into the oracle world and i know nothing about mySQL and am wondering if > the transition from one to the other is easily done. > > thanks, joe > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to find current ORACLE_HOME programmatically
Looks like no takers, except one whos great advice was to find it somewhere in the registry. Alex Hillman -Original Message- Hillman Sent: Monday, May 20, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that client. I understand that it is in the registry somewhere. I have 2 client installations - one is 8.1.7 and another is 9 on the same client. Apparently EM from 9 installation knows that needed tsnames.ora is in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation. And my VB program select tsnames.ora from 8.1.7 installation Any ideas? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to find current ORACLE_HOME programmatically
Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that client. I understand that it is in the registry somewhere. I have 2 client installations - one is 8.1.7 and another is 9 on the same client. Apparently EM from 9 installation knows that needed tsnames.ora is in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation. And my VB program select tsnames.ora from 8.1.7 installation Any ideas? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle version usage
I am especially interested in percentage of 7.3 and 8.0 installation. Maybe it is a good idea to mail me directly and I then will post the results. Alex Hillman -Original Message- Hillman Sent: Monday, May 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex > Hillman > Sent: Saturday, May 11, 2002 12:03 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle version usage > > > Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 > and prognosys in an year. > > Alex Hillman > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alex Hillman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle version usage
Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex > Hillman > Sent: Saturday, May 11, 2002 12:03 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle version usage > > > Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 > and prognosys in an year. > > Alex Hillman > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alex Hillman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle version usage
Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Response time analysis and TKPROF
Anjo, you mentioned third party tool using instead of 10046 event trace files. What is the tool and how it works - if you have this info of cource. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anjo Kolk > Sent: Sunday, May 05, 2002 8:08 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Response time analysis and TKPROF > > > Yes, > > I think that we are talking about different things: > > 1) I don't feel that we are abusing the queue theory by borrowing > terms like > service time and wait time. > Actually when I did the YAPP method, it was back in 1996 on > a project that > involved Tuxedo and the > programmers on the project wanted more processes. I had to > convince them to > do it with less and I > could do that with the service and wait time model (calculating the > response time in the Oracle server for sessions). And it really > works well. > > 2) The problem with tuning by hit ratios and tuning by counting > (like number of > buffer gets and number of physical I/O from > v$sqlarea) is that we ignore the cost or the time they take. > We assume that > each Logical I/O or buffer get is the same > cost. Which is not true. So the statement with a 1000 LIO > could be more > expensive than the statement with a 1200 LIO. > The same is true for the Physical I/O. Not each physical I/O > has the same > cost or response time. Again the statement with > 1000 I/Os may be more expensive than the 1200 I/Os, because > one is going > after different disks. I have run tests that show LIO for the same > statement to be all most twice as slow (depending on some > settings, but > the SQL is the same, same plan) > > 3) If you now take the service time (which is CPU) and that part > is 80 percent > of the total response time, we can tell management > that a 50 percent faster CPU will make roughly a 40 percent > difference. > That is not to say that is the right approach, because > the opposite may also happen (20 percent CPU and 80 percent > wait, 50 percent > faster will only make a 10 percent improvement). > I have seen customers with response time problems that > consisted for over 80 > percent of I/O problems (I/O too slow). They needed a > 50 percent improvement but couldn't fix the I/O. So they > wanted to find 50 > percent some where else. That didn't happen ofcourse > and they had to fix the I/O problem. Now that really helped > management to > understand where the priorities were: Yeeh, this is not > a database problem but a disk array problem. > > 4) I believe that 80-90 percent of all Oracle applications out > there in the > field are highly inefficient. And that doesn't mean that they > don't use bind variables or that they do many logical I/Os. > And that the > only way to fix them is faster CPU's (open to flames here ;-)) or do > some serious redesigning. > > 5) Oracle provides many interesting statistics, but most of them > only count. Now > in Oracle 9i they have added some long overdue response time or > timing statistics. But still it is lacking very important > information. For > example, how can we tell what a SQL statement waited for a particular > session between 2 AM and 3 AM (without 10046 tracing) or for > all sessions ? > If the session performs a business function, what resources did > the session > use in that period for that business function ? That > information is hard to > come by, or with very high overhead with the traditional Oracle tools. > > 6) probably the most important point. The database doesn't decide > WHAT SQL to > execute. The database decides HOW SQL should be executed. The application > decides WHAT to execute. Many fast SQL statements can still > result in a > slow business function, because do we need all those functions ? > I have another > favorite formula for that: Amount * Cost => total cost. So > either reduce > the cost or reduce the amount of SQL statements. Showed this formula to > bunch of people at an Oracle user group in the netherlands. 2 > days later, I > got an email from someone saying that they concentrated on the > amount instead of > cost > They reduced the batch job time from 2 hours to 10 minutes > without tuning > the SQL statement, but tuned the function. > > 7) The response time model gives the end-user perspective > (without actually > having to go to the coffee machine, unless you want coffee ;-)), > but talking to > them > is very valuable. That doesn't mean they are right ;-) > > An
Re: pl/sql is INTERPRETED?
You must be pretty smart then. I wonder why rates for java are not $6/hr seeing that it only takes a week to learn. You could probably say any language is easy to learn; it is just ifs, elses, and loops. On Thu, 2 May 2002 [EMAIL PROTECTED] wrote: > It ain't that tough. We're not talking about taking a programming > class without any experience, I've done a bit of it before. > > Learning all the API's, etc.: that would take some time. > > The language? It isn't that difficult, though I would be > hard put to write any at the moment. The job I was going > to use Java on was at Enron, and we all know what happened > to that. > > It's been a year since I took the class, and I *much* prefer > Perl. It can run circles around Java for most stuff. > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 08:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: pl/sql is INTERPRETED? > > > It took you a week to learn it? Then you obviously do not know it. > Syntax is one thing design is another. I would love to know what you > learned in that week. > > > On Thu, 2 May 2002, Jared Still wrote: > > > > > Hold on Lisa! > > > > Java is not complex. It's a very simple language > > actually. It took me a week to learn it, though I'm > > not using it now: I much prefer Perl. > > > > Getting a handle on all of the libraries and API's is > > another story, but Java as a language is pretty simple. > > > > Jared > > > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > > learned fairly easily in comparison to the many other choices out > there. > > > However, it takes a bit of database savvy to do it correctly. (Not > much > > > tho) > > > > > > I was amazed in my "database" class in college that the same people > failing > > > the simple entity-relationship modeling portion of the class that had > aced > > > the Op Systems and networking classes we took. I nearly failed both > > > classes, they were so complex. I was the teacher's pet in the db > class > > > because I asked him questions that made him think, and he sometimes > > > couldn't answer. (And I had to wear a skirt - night student, straight > from > > > work.) > > > > > > What's easy for who is dependent on the person's strengths. > > > > > > Lisa Koivu > > > Oracle Database Monkey Mama > > > Fairfield Resorts, Inc. > > > 5259 Coconut Creek Parkway > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -Original Message- > > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > > To:Multiple recipients of list ORACLE-L > > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > > > 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 that knew what they were doing. > > > > > > > > Granted, if a smart developer sits down and reads Feuerstein's > Learning > > > > PL/SQL and Best Practices books, then perhaps they will be good. But > who > > > > the hell has free time? There is no free time on any project or > effort > > > > that > > > > I know of!! I'm struggling with trying to improve my Oracle DBA > skills, > > > > plus some developers skills so I can speak their language when they > blow > > > > out > > > > OPEN_CURSORS or something. My head is swimming in the stupid > technical > > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, > BC4J, > > > > JDBC, > > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me > what > > > > all > >
Re: pl/sql is INTERPRETED?
explicit/implicit > > > > > > > cursors, under pl/sql. What on earth? > > > > > > > > Can someone elaborate, namely, Connor?? Please help me understand > > > > > > this... > > > > > > > My "green" may be showing, but my gosh. > > > > > > > > Lisa Koivu > > > > Oracle Database Baby Oven > > > > Fairfield Resorts, Inc. > > > > 5259 Coconut Creek Parkway > > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Koivu, Lisa > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > > > > > > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Stefan Jahnke > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Koivu, Lisa > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Mercadante, Thomas F > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Grabowy, Chris > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX Courses
I suggest you download linux or bsd and play around. On Thu, 25 Apr 2002, Simon Waibale wrote: > Hi all, > What Unix courses/modules would you recommend for a budding Oracle DBA > Thanx, > --- > CSW > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Simon Waibale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cronjob
-e Edit the current crontab using the editor specified by the VISUAL or EDITOR environment variables. The specified editor must edit the file in place; any editor that unlinks the file and recreates it cannot be used. After you exit from the editor, the modified crontab will be installed automatically. He wants to delete the job. If he kills the process the job will run again next time so editing the crontab file is th eonly way. On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote: > crontab -e is bad! > > 1000 points if you can figure out why. > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: Cronjob > > > crontab -e > > On Wed, 24 Apr 2002, bill thater wrote: > > > [EMAIL PROTECTED] wrote: > > > > > Anyone whom can tell me how to delete a job that is created by > crontab. > > > > > > Thanks in advance > > > > > > > > > Roland > > > > > > > > > > man crontab > > > > > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cronjob
crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL vs. Oracle database
I did not say MySQL was like Access. I said it is more like Access than it is like Oracle. On Wed, 17 Apr 2002, Gurelei wrote: > Alex, > > Just wondering why do you think MySQL is closer to > Access than to Oracle. I have played with MySQL a > little and it is a relational database like Oracle > (not sure if access is one), uses a SQL, can have > logging and archiving just like Oracle. Again I'm not > sure whether access have all this. To me, if Oracle is > a BMW and MySQL is a Chevy (as someone else compared), > access would be a horse cart at best. Am I wrong? > > Gene > --- Alex <[EMAIL PROTECTED]> wrote: > > Check google. Anyway they are completely different. > > MySQL is more like > > Access than Oracle. > > > > On Wed, 17 Apr 2002, Nguyen, David M wrote: > > > > > What is different between MySQL and Oracle > > database? Someone says they are > > > the same as they are just database. From DBA or > > developer point of view, > > > what do you say? > > > > > > Thanks, > > > David > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Nguyen, David M > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > > (or the name of mailing list you want to be > > removed from). You may > > > also send the HELP command for other information > > (like subscribing). > > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Alex > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gurelei > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL vs. Oracle database
Check google. Anyway they are completely different. MySQL is more like Access than Oracle. On Wed, 17 Apr 2002, Nguyen, David M wrote: > What is different between MySQL and Oracle database? Someone says they are > the same as they are just database. From DBA or developer point of view, > what do you say? > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Please ignore: Internet DBA'ng
thanks for posting your solution On Mon, 15 Apr 2002, Sujatha Madan wrote: > Solved this issue. > > > -Original Message- > > From: Sujatha Madan > > Sent: Tuesday, 16 April 2002 2:55 PM > > To: Multiple recipients of list ORACLE-L (E-mail) > > Subject:Internet DBA'ng > > > > Hi, > > > > We have a network/web hosting shop, and one of our customers is asking for > > a firewall to be opened for DBA access over the internet. They want two > > non-Oracle specific ports opened so that their Oracle Databases can be > > administrated via the internet. > > > > Has anyone heard of any vulnerabilities associated with this? Or is there > > anything that I should be aware of in terms of security? Or should I be > > asking them any questions? > > > > Thanks > > > > Sujatha > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sujatha Madan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: interview questions
It really depends on what the job entails. On Mon, 15 Apr 2002, Maria Aurora VT de la Vega wrote: > Hello Gurus. > > I would like to ask anyone who were at one point worked as Oracle > Developers... > or anyone who can give their opinion... > I will be interviewing applicants for Oracle Developer position. > Since I'm the only Oracle person in this shop, I was tasked to handle > this interview. > I have 0 experience with the use of any Oracle Development tools... > And for me, as long as they know how to SQL and PLSQL...and respects > their DBA... > they're OK. > I am not sure if there are other things I should ask.. > > Inputs Please! > > thanks. > -- > Maria Aurora VT de la Vega (OCP) > Database Specialist > Philippine Stock Exchange, Inc. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: No DBAs needed on AS400
So you can cover his ass when a problem happens. On Thu, 11 Apr 2002, Jay Hostetter wrote: > We are going through a merger, and management is looking to eliminate positions. >Here is a brief summary of my discussion with the new director of IT: > > Director: "Back when I we were using an AS400, we didn't need a DBA." > Me: "Then you probably were just using files." > Director: "No, it was a database." > Me: "Could you issue SQL commands?" > Director: "Yes. But we didn't need a DBA. I guess it was just one of those >mysteries of life." > > > My thoughts are that he is using the term "database" in the generic sense of the >word (our "files" are our database), or he was using some proprietary database that >doesn't even begin to compare to Oracle. > > For those of you who know AS400s, I would appreciate some insight that would >demonstrate why he needs to keep me as a DBA. > > Thanks, > Jay > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jay Hostetter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does index need rebuilding when table is truncated
Table need to be reanalyzed and with table - indexes. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, April 09, 2002 5:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Does index need rebuilding when table is truncated > > > Hi All, > > I know if you delete lots of data using delete the indexes may need > rebuilding. Is this the case if the table is truncated? > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
