Search: For:
Browsing Single Category

some LFU one liners

Topic ID: 269
Created By: 2003-DEC-05 19:12:03 [Oper01]
Updated By: 2003-DEC-05 19:12:28 [Oper01]
Status: Closed
Severity: Normal
Read Only: No
1089
2003-DEC-05 19:12:03
User
 
 
Registered On: Mar 2006
Total Posts: 143
some least frequently used "one liners"


select * from v$resource_limit;
SET TRANSACTION USE ROLLBACK SEGMENT rbsbig01;
ALTER SYSTEM SET sort_area_size=8388608 DEFERRED;
alter system set log_checkpoint_interval=330000;
alter system enable restricted session;
alter system disable restricted session;
select * from V$PWFILE_USERS;
alter session set nls_date_format='RRRR-MON-DD hh24:mi:ss';

-- setting undocumented parameters
alter session set "_push_join_predicate"=true;

ALTER SESSION DISABLE PARALLEL DML;
1090
2003-DEC-05 19:12:28
User
 
 
Registered On: Mar 2006
Total Posts: 143
.