Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Work vs marriage
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFCC8E.DC8B132C
Content-Type: text/plain;
charset="iso-8859-1"
alter system set compliments = high;
alter system set giveup = never;
-----Original Message-----
From: LBhat_at_LEVI.com [mailto:LBhat_at_LEVI.com]
Sent: Thursday, June 01, 2000 10:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Work vs marriage
SHARED_POOL.KEEP('HAPPY')
SHARED_POOL.UNKEEP('FIGHT');
:)
Bhat
-----Original Message-----
Sent: Friday, June 02, 2000 7:15 AM
To: Multiple recipients of list ORACLE-L
All things worthwhile in life require a little tuning now and then... not just database systems. Consider the following syntax:
ALTER SYSTEM SET CAREER_RESOURCE_LIMIT = TRUE;
ALTER SYSTEM SET FAMILY_RESOURCE_LIMIT = FALSE;
If you ever get in an argument try...
ALTER SESSION ADVISE NOTHING;
DROP ROLE MACHO;
DROP PROFILE COMBATIVE;
Generally you want to avoid the following:
REVOKE ALL PRIVILEGES ON BANKACCOUNT FROM SPOUSE CASCADE CONSTRAINTS FORCE;
or...
ALTER USER SPOUSE ACCOUNT LOCK;
Be faithful...
ALTER SYSTEM SET PARALLEL_ADAPTIVE_MULTI_USER = FALSE;
To patch things up don't try...
STARTUP FORCE;
rather...
ALTER OUTLINE HAPPYMARRIAGE REBUILD;
SET ROLE LOYALSPOUSE IDENTIFIED BY HUGSNKISSES;
Of course the most important of all is:
COMMIT;
Except for the first two, these are syntactically correct. Any more?
Steve Orr
-----Original Message-----
Gramolini
Sent: Thursday, June 01, 2000 9:57 AM
To: Multiple recipients of list ORACLE-L
I would change jobs, a computer isn't going to be very much comfort when
you get old. IMHO Ruth
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Thursday, June 01, 2000 10:36 AM
>
> work 1 marriage 0 and getting worse.
>
> --
> Bill Thater Certified ORACLE DBA
> Telergy, Inc. thaterw_at_telergy.net
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Do or not do. There is no try. -- Yoda
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> You can get more with a kind word and a gun than you can with a kind word
alone. - Al Capone (1899-1947)
>
>
>
>
>
> --
> Author: bill thater
> INET: thaterw_at_telergy.net
>
> 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: ListGuru_at_fatcity.com (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).
>
-- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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: ListGuru_at_fatcity.com (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). -- Author: Steve Orr INET: sorr_at_arzoo.com 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: ListGuru_at_fatcity.com (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). -- Author: INET: LBhat_at_LEVI.com 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01BFCC8E.DC8B132C Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0"> <TITLE>RE: Work vs marriage</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>alter system set compliments = high;</FONT> <BR><FONT SIZE=2>alter system set giveup = never;</FONT> </P> <BR> <BR> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: LBhat_at_LEVI.com [<A HREF="mailto:LBhat_at_LEVI.com">mailto:LBhat_at_LEVI.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Thursday, June 01, 2000 10:44 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: RE: Work vs marriage</FONT> </P> <BR> <P><FONT SIZE=2>SHARED_POOL.KEEP('HAPPY')</FONT> <BR><FONT SIZE=2>SHARED_POOL.UNKEEP('FIGHT');</FONT> </P> <P><FONT SIZE=2>:)</FONT> </P> <P><FONT SIZE=2>Bhat</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>Sent: Friday, June 02, 2000 7:15 AM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=2>All things worthwhile in life require a little tuning now and then... not</FONT> <BR><FONT SIZE=2>just database systems. Consider the following syntax:</FONT> </P> <P><FONT SIZE=2>ALTER SYSTEM SET CAREER_RESOURCE_LIMIT = TRUE;</FONT> <BR><FONT SIZE=2>ALTER SYSTEM SET FAMILY_RESOURCE_LIMIT = FALSE;</FONT> </P> <P><FONT SIZE=2>If you ever get in an argument try...</FONT> <BR><FONT SIZE=2>ALTER SESSION ADVISE NOTHING;</FONT> <BR><FONT SIZE=2>DROP ROLE MACHO;</FONT> <BR><FONT SIZE=2>DROP PROFILE COMBATIVE;</FONT> </P> <P><FONT SIZE=2>Generally you want to avoid the following:</FONT> <BR><FONT SIZE=2>REVOKE ALL PRIVILEGES ON BANKACCOUNT FROM SPOUSE CASCADE CONSTRAINTS FORCE;</FONT> </P> <P><FONT SIZE=2>or...</FONT> <BR><FONT SIZE=2>ALTER USER SPOUSE ACCOUNT LOCK;</FONT> </P> <P><FONT SIZE=2>Be faithful...</FONT> <BR><FONT SIZE=2>ALTER SYSTEM SET PARALLEL_ADAPTIVE_MULTI_USER = FALSE;</FONT> </P> <P><FONT SIZE=2>To patch things up don't try...</FONT> <BR><FONT SIZE=2>STARTUP FORCE;</FONT> </P> <P><FONT SIZE=2>rather...</FONT> <BR><FONT SIZE=2>ALTER OUTLINE HAPPYMARRIAGE REBUILD;</FONT> <BR><FONT SIZE=2>SET ROLE LOYALSPOUSE IDENTIFIED BY HUGSNKISSES;</FONT> </P> <P><FONT SIZE=2>Of course the most important of all is:</FONT> <BR><FONT SIZE=2>COMMIT;</FONT> </P> <BR> <P><FONT SIZE=2>Except for the first two, these are syntactically correct. Any more?</FONT> </P> <P><FONT SIZE=2>Steve Orr</FONT> </P> <BR> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>Gramolini</FONT> <BR><FONT SIZE=2>Sent: Thursday, June 01, 2000 9:57 AM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=2>I would change jobs, a computer isn't going to be very much comfort when</FONT> <BR><FONT SIZE=2>you get old. IMHO Ruth</FONT> <BR><FONT SIZE=2>----- Original Message -----</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>Sent: Thursday, June 01, 2000 10:36 AM</FONT> </P> <BR> <P><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> work 1 marriage 0 and getting worse.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> --</FONT> <BR><FONT SIZE=2>> Bill Thater Certified ORACLE DBA</FONT> <BR><FONT SIZE=2>> Telergy, Inc. thaterw_at_telergy.net</FONT> <BR><FONT SIZE=2>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</FONT> <BR><FONT SIZE=2>> Do or not do. There is no try. -- Yoda</FONT> <BR><FONT SIZE=2>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</FONT> <BR><FONT SIZE=2>> You can get more with a kind word and a gun than you can with a kind word</FONT> <BR><FONT SIZE=2>alone. - Al Capone (1899-1947)</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> --</FONT> <BR><FONT SIZE=2>> Author: bill thater</FONT> <BR><FONT SIZE=2>> INET: thaterw_at_telergy.net</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>> San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>> --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>> To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>> the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>> (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>> also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>></FONT> </P> <P><FONT SIZE=2>--</FONT> <BR><FONT SIZE=2>Author: Ruth Gramolini</FONT> <BR><FONT SIZE=2> INET: rgramolini_at_tax.state.vt.us</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT> </P> <P><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Steve Orr</FONT> <BR><FONT SIZE=2> INET: sorr_at_arzoo.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: </FONT> <BR><FONT SIZE=2> INET: LBhat_at_LEVI.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>Received on Fri Jun 02 2000 - 07:33:07 CDT
![]() |
![]() |