-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
declare task_id number; name varchar2(100); descr varchar2(100); obj_id number; -- get the min and max snap id from AWR CURSOR… READ MORE
Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the… READ MORE
— Set default tablespace for all users, so when users are created without specifying default tablespace it will be user’s… READ MORE
|
One can’t move the temp tablespace during mount stage like other datafiles using “ALTER DATABASE RENAME FILE..” so a workaround… READ MORE
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
Nice way to extract the DDL for all tablepaces.. This also can be used for other objects as well. SQL>set… READ MORE
Here is a nice script if you need to move your datafiles to a new location. SQL>spool rename_datafile.sql set line… READ MORE
— If sorting is performed on permanent tablespace it can affect performance because it’s in nologging mode, reduces backup and… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 