Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Work vs marriage
SHARED_POOL.KEEP('HAPPY')
SHARED_POOL.UNKEEP('FIGHT');
:)
Bhat
-----Original Message-----
From: Steve Orr [mailto:sorr_at_arzoo.com]
Sent: Friday, June 02, 2000 7:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Work vs marriage
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 mayReceived on Thu Jun 01 2000 - 21:28:15 CDT