Jump to content

ORA-LO

Members
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ORA-LO

  • Rank
    Newbie
  1. query Find TABLE fragmentation problem

    Thank you for the answer, but maybe i'm not explaining my problem right. I've got tables with a weekly massive delete and update rows which cause fragmentation. i try to build a report which after this statement tell me the status of this table and advise me to make a REORG (ALTER TABLE .... MOVE ....). this table are partitioned and subpartitioned and compressed; how can i check the fragmentation of this table? i use the query in the first post but in my opinion something is wrong because the original size is less than "num_rows * avg_row_len" . ; where is my mistake? Thanks for all. Lorenzo
  2. Hi All, one question: with this query i can check if my table need REORG: SELECT owner, table_name, ROUND ( (blocks * 32), 2) || 'kb' "Fragmented size", ROUND ( (num_rows * avg_row_len / 1024), 2) || 'kb' "Actual size", ROUND ( (blocks * 32), 2) - ROUND ( (num_rows * avg_row_len / 1024), 2) ||'kb', ( ( ROUND ( (blocks * 32), 2) - ROUND ( (num_rows * avg_row_len / 1024), 2)) / ROUND ( (blocks * 32), 2)) * 100 "reclaimable space % " FROM dba_tables WHERE table_name = '&table_Name' AND OWNER LIKE '&schema_name' / But on SOME table the query result is totally WRONG because the field "Actual size" is greater than "Fragmented size"; is thats because the table i check is COMPRESS or anything else? how can i resolve this problem? Thx!! Lorenzo
  3. Hi everyone, someone know what kind of wait event/lock is generate if i do a MERGE/UPDATE and an INSERT on the same TABLE in the same moment? is possibile a“enq: TM – contention”? In an AWR i've got this reporting on a merge/update and insert statement and reading in internet i find only answer on foreign keys but in my case i heven't foreign keys....so why i've got that wait event? thx for the answers! Lorenzo
  4. Who automatic purge SYSAUX TBS?

    OK! so the Optimizer statistics gathering and the purge of the sysaux are totally independent ,right? but the Optimizer statistics gathering stored his data in the object in the sysaux tbs, right? last question: if the scheduled job Optimizer statistics gathering end with STOPPED STATUS , what that means? that means during the WINDOW it not be able to get the statistics of the whole DB (or the object in DBA_TAB_MODIFICATIONS)? what it can't do and why? THX AGAIN!!
  5. Hi MASTERS! one simply question: ORACLE 11g which job automatic purge in night-time the stats collected in SYSAUX? maybe the "Optimizer statistics gathering" job? if is it true, if i found it in status STOPPED on dba_autotask_job_history for WINDOWS CLOSED that means the purge is FAILED? i hope in an answer. Bye Lorenzo
  6. "DBTIME" ORA11g

    Hi everyone! i need some help: i want know how oracle calculate the "DB TIME" presents in awr report; what kind of query calc this awr's voice and which tables/ views are impacts in this query or in this calc. thanks for the answers!!! BYE!! Lorenzo
  7. UNDOTBS PROBLEM

    Hi everyone! ORACLE 11g on AIX node. for FS space problem i create a new UNDOTBS: ALTER SYSTEM SET undo_TABLESPACE = UNDOTBS1 scope = both; (OLD UNDO tablespace named UNDOTBS2) i execute a query on dba_rollback_segs to see all the segment OFFLINE: SELECT segment_name, owner, tablespace_name, status FROM dba_rollback_segs WHERE tablespace_name LIKE '%UND%2' SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU257_2797902178$ UNDOTBS2 OFFLINE _SYSSMU258_1356039928$ UNDOTBS2 OFFLINE _SYSSMU259_3707472416$ UNDOTBS2 OFFLINE _SYSSMU260_2138716273$ UNDOTBS2 OFFLINE _SYSSMU261_543067897$ UNDOTBS2 OFFLINE _SYSSMU262_3489920640$ UNDOTBS2 OFFLINE _SYSSMU263_795359048$ UNDOTBS2 OFFLINE _SYSSMU264_3768542508$ UNDOTBS2 OFFLINE _SYSSMU265_2834496910$ UNDOTBS2 OFFLINE _SYSSMU266_4079169967$ UNDOTBS2 OFFLINE _SYSSMU267_3238347942$ UNDOTBS2 OFFLINE _SYSSMU268_3970256515$ UNDOTBS2 OFFLINE _SYSSMU269_2262652573$ UNDOTBS2 OFFLINE _SYSSMU270_2451670192$ UNDOTBS2 OFFLINE _SYSSMU271_396836159$ UNDOTBS2 OFFLINE _SYSSMU272_1668438716$ UNDOTBS2 OFFLINE _SYSSMU273_3949953323$ UNDOTBS2 OFFLINE _SYSSMU274_3338521876$ UNDOTBS2 OFFLINE _SYSSMU275_1998191175$ UNDOTBS2 OFFLINE _SYSSMU276_2930393544$ UNDOTBS2 OFFLINE _SYSSMU277_4141993682$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU278_1080994513$ UNDOTBS2 OFFLINE _SYSSMU279_2434896771$ UNDOTBS2 OFFLINE _SYSSMU280_1723421736$ UNDOTBS2 OFFLINE _SYSSMU281_3893289277$ UNDOTBS2 OFFLINE _SYSSMU282_2176659273$ UNDOTBS2 OFFLINE _SYSSMU283_1669894120$ UNDOTBS2 OFFLINE _SYSSMU284_1796375321$ UNDOTBS2 OFFLINE _SYSSMU285_1241589912$ UNDOTBS2 OFFLINE _SYSSMU286_3839995440$ UNDOTBS2 OFFLINE _SYSSMU287_2614199963$ UNDOTBS2 OFFLINE _SYSSMU288_3161132063$ UNDOTBS2 OFFLINE _SYSSMU289_1524366218$ UNDOTBS2 OFFLINE _SYSSMU290_3267841599$ UNDOTBS2 OFFLINE _SYSSMU291_1331313891$ UNDOTBS2 OFFLINE _SYSSMU292_685452890$ UNDOTBS2 OFFLINE _SYSSMU293_497908054$ UNDOTBS2 OFFLINE _SYSSMU294_1115103313$ UNDOTBS2 OFFLINE _SYSSMU295_3071100565$ UNDOTBS2 OFFLINE _SYSSMU296_2789071238$ UNDOTBS2 OFFLINE _SYSSMU297_3004337895$ UNDOTBS2 OFFLINE _SYSSMU298_2637102210$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU299_2306056098$ UNDOTBS2 OFFLINE _SYSSMU300_1361512638$ UNDOTBS2 OFFLINE _SYSSMU301_3049894433$ UNDOTBS2 OFFLINE _SYSSMU302_4082237114$ UNDOTBS2 OFFLINE _SYSSMU303_3071741468$ UNDOTBS2 OFFLINE _SYSSMU304_3147888477$ UNDOTBS2 OFFLINE _SYSSMU305_1601616211$ UNDOTBS2 OFFLINE _SYSSMU306_3848190200$ UNDOTBS2 OFFLINE _SYSSMU307_3660258734$ UNDOTBS2 OFFLINE _SYSSMU308_1736299777$ UNDOTBS2 OFFLINE _SYSSMU309_4205509321$ UNDOTBS2 OFFLINE _SYSSMU310_117207912$ UNDOTBS2 OFFLINE _SYSSMU311_4251515902$ UNDOTBS2 OFFLINE _SYSSMU312_1760327492$ UNDOTBS2 OFFLINE _SYSSMU313_2334835389$ UNDOTBS2 OFFLINE _SYSSMU314_362896596$ UNDOTBS2 OFFLINE _SYSSMU315_444149725$ UNDOTBS2 OFFLINE _SYSSMU316_3082034450$ UNDOTBS2 OFFLINE _SYSSMU317_2541575720$ UNDOTBS2 OFFLINE _SYSSMU318_2391950445$ UNDOTBS2 OFFLINE _SYSSMU319_3137714207$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU320_905216880$ UNDOTBS2 OFFLINE _SYSSMU321_3394554614$ UNDOTBS2 OFFLINE _SYSSMU322_1666454038$ UNDOTBS2 OFFLINE _SYSSMU323_210814317$ UNDOTBS2 OFFLINE _SYSSMU324_1643113442$ UNDOTBS2 OFFLINE _SYSSMU325_493171787$ UNDOTBS2 OFFLINE _SYSSMU326_2571687184$ UNDOTBS2 OFFLINE _SYSSMU327_149333000$ UNDOTBS2 OFFLINE _SYSSMU328_303196830$ UNDOTBS2 OFFLINE _SYSSMU329_1049801963$ UNDOTBS2 OFFLINE _SYSSMU330_2718212055$ UNDOTBS2 OFFLINE _SYSSMU331_4241130191$ UNDOTBS2 OFFLINE _SYSSMU332_218494630$ UNDOTBS2 OFFLINE _SYSSMU333_659029652$ UNDOTBS2 OFFLINE _SYSSMU334_1301340461$ UNDOTBS2 OFFLINE _SYSSMU335_548981020$ UNDOTBS2 OFFLINE _SYSSMU336_904801591$ UNDOTBS2 OFFLINE _SYSSMU337_3343491655$ UNDOTBS2 OFFLINE _SYSSMU338_4017075537$ UNDOTBS2 OFFLINE _SYSSMU339_3087394418$ UNDOTBS2 OFFLINE _SYSSMU340_424142415$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU341_119046242$ UNDOTBS2 OFFLINE _SYSSMU342_2553590671$ UNDOTBS2 OFFLINE _SYSSMU343_128736450$ UNDOTBS2 OFFLINE _SYSSMU344_3301588376$ UNDOTBS2 OFFLINE _SYSSMU345_1602459200$ UNDOTBS2 OFFLINE _SYSSMU346_3542321715$ UNDOTBS2 OFFLINE _SYSSMU347_3120700039$ UNDOTBS2 OFFLINE _SYSSMU348_3248214227$ UNDOTBS2 OFFLINE _SYSSMU349_1129636549$ UNDOTBS2 OFFLINE _SYSSMU350_3384752966$ UNDOTBS2 OFFLINE _SYSSMU351_4083241123$ UNDOTBS2 OFFLINE _SYSSMU352_1570963011$ UNDOTBS2 OFFLINE _SYSSMU353_4086896311$ UNDOTBS2 OFFLINE _SYSSMU354_2165898165$ UNDOTBS2 OFFLINE _SYSSMU355_3233180657$ UNDOTBS2 OFFLINE _SYSSMU356_509340118$ UNDOTBS2 OFFLINE _SYSSMU357_2942126883$ UNDOTBS2 OFFLINE _SYSSMU358_2827262110$ UNDOTBS2 OFFLINE _SYSSMU359_2578790324$ UNDOTBS2 OFFLINE _SYSSMU360_2319800341$ UNDOTBS2 OFFLINE _SYSSMU361_2017830087$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU362_644332508$ UNDOTBS2 OFFLINE _SYSSMU363_1250909455$ UNDOTBS2 OFFLINE _SYSSMU364_565572949$ UNDOTBS2 OFFLINE _SYSSMU365_3181664236$ UNDOTBS2 OFFLINE _SYSSMU366_796046102$ UNDOTBS2 OFFLINE _SYSSMU367_1578692298$ UNDOTBS2 OFFLINE _SYSSMU368_3880587175$ UNDOTBS2 OFFLINE _SYSSMU369_2446239280$ UNDOTBS2 OFFLINE _SYSSMU370_3385199314$ UNDOTBS2 OFFLINE _SYSSMU371_2260013392$ UNDOTBS2 OFFLINE _SYSSMU372_3064093784$ UNDOTBS2 OFFLINE _SYSSMU373_4122464412$ UNDOTBS2 OFFLINE _SYSSMU374_3182987282$ UNDOTBS2 OFFLINE _SYSSMU375_3679953573$ UNDOTBS2 OFFLINE _SYSSMU376_4187078179$ UNDOTBS2 OFFLINE _SYSSMU377_3416872892$ UNDOTBS2 OFFLINE _SYSSMU378_2476494992$ UNDOTBS2 OFFLINE _SYSSMU379_571408501$ UNDOTBS2 OFFLINE _SYSSMU380_2876777561$ UNDOTBS2 OFFLINE _SYSSMU381_3723111715$ UNDOTBS2 OFFLINE _SYSSMU382_1163583506$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU383_4048571359$ UNDOTBS2 OFFLINE _SYSSMU384_1494578091$ UNDOTBS2 OFFLINE _SYSSMU385_1576821748$ UNDOTBS2 OFFLINE _SYSSMU386_1105446073$ UNDOTBS2 OFFLINE _SYSSMU387_4064466624$ UNDOTBS2 OFFLINE _SYSSMU388_101949540$ UNDOTBS2 OFFLINE _SYSSMU389_790904732$ UNDOTBS2 OFFLINE _SYSSMU390_1983506726$ UNDOTBS2 OFFLINE _SYSSMU391_835283210$ UNDOTBS2 OFFLINE _SYSSMU392_966167398$ UNDOTBS2 OFFLINE _SYSSMU393_108627484$ UNDOTBS2 OFFLINE _SYSSMU394_2963833668$ UNDOTBS2 OFFLINE _SYSSMU395_3142513022$ UNDOTBS2 OFFLINE _SYSSMU396_1226176196$ UNDOTBS2 OFFLINE _SYSSMU397_1014305868$ UNDOTBS2 OFFLINE _SYSSMU398_1666960913$ UNDOTBS2 OFFLINE _SYSSMU399_2626001519$ UNDOTBS2 OFFLINE _SYSSMU400_3644775766$ UNDOTBS2 OFFLINE _SYSSMU401_1181477694$ UNDOTBS2 OFFLINE _SYSSMU402_4136053471$ UNDOTBS2 OFFLINE _SYSSMU403_1426404378$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU404_3316066255$ UNDOTBS2 OFFLINE _SYSSMU405_1703596417$ UNDOTBS2 OFFLINE _SYSSMU406_2494491204$ UNDOTBS2 OFFLINE _SYSSMU407_1395894329$ UNDOTBS2 OFFLINE _SYSSMU408_3299522874$ UNDOTBS2 OFFLINE _SYSSMU409_649596690$ UNDOTBS2 OFFLINE _SYSSMU410_1567385791$ UNDOTBS2 OFFLINE _SYSSMU411_2396747753$ UNDOTBS2 OFFLINE _SYSSMU412_390190237$ UNDOTBS2 OFFLINE _SYSSMU413_2228436437$ UNDOTBS2 OFFLINE _SYSSMU414_3449135584$ UNDOTBS2 OFFLINE _SYSSMU415_4118499558$ UNDOTBS2 OFFLINE _SYSSMU416_932954985$ UNDOTBS2 OFFLINE _SYSSMU417_1897630241$ UNDOTBS2 OFFLINE _SYSSMU418_2358854197$ UNDOTBS2 OFFLINE _SYSSMU419_426701487$ UNDOTBS2 OFFLINE _SYSSMU420_162799489$ UNDOTBS2 OFFLINE _SYSSMU421_2298901194$ UNDOTBS2 OFFLINE _SYSSMU422_2891340640$ UNDOTBS2 OFFLINE _SYSSMU423_981348735$ UNDOTBS2 OFFLINE _SYSSMU424_1189574484$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU425_892486116$ UNDOTBS2 OFFLINE _SYSSMU426_2350077926$ UNDOTBS2 OFFLINE _SYSSMU427_893600785$ UNDOTBS2 OFFLINE _SYSSMU428_387106256$ UNDOTBS2 OFFLINE _SYSSMU429_3344074696$ UNDOTBS2 OFFLINE _SYSSMU430_4152908829$ UNDOTBS2 OFFLINE _SYSSMU431_1032641905$ UNDOTBS2 OFFLINE _SYSSMU432_164145002$ UNDOTBS2 OFFLINE _SYSSMU433_3205369085$ UNDOTBS2 OFFLINE _SYSSMU434_2825178496$ UNDOTBS2 OFFLINE _SYSSMU435_2996201644$ UNDOTBS2 OFFLINE _SYSSMU436_2270616726$ UNDOTBS2 OFFLINE _SYSSMU437_1452859319$ UNDOTBS2 OFFLINE _SYSSMU438_3820761486$ UNDOTBS2 OFFLINE _SYSSMU439_4133640889$ UNDOTBS2 OFFLINE _SYSSMU440_4050047423$ UNDOTBS2 OFFLINE _SYSSMU441_433122303$ UNDOTBS2 OFFLINE _SYSSMU442_2865275868$ UNDOTBS2 OFFLINE _SYSSMU627_808215357$ UNDOTBS2 OFFLINE _SYSSMU628_750745117$ UNDOTBS2 OFFLINE _SYSSMU629_1500498867$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU630_552754740$ UNDOTBS2 OFFLINE _SYSSMU631_1703519380$ UNDOTBS2 OFFLINE _SYSSMU632_2866138468$ UNDOTBS2 OFFLINE _SYSSMU633_3070916184$ UNDOTBS2 OFFLINE _SYSSMU634_1410594955$ UNDOTBS2 OFFLINE _SYSSMU635_3437735445$ UNDOTBS2 OFFLINE _SYSSMU636_412417207$ UNDOTBS2 OFFLINE _SYSSMU637_2114306879$ UNDOTBS2 OFFLINE _SYSSMU638_3300705474$ UNDOTBS2 OFFLINE _SYSSMU639_1854226717$ UNDOTBS2 OFFLINE _SYSSMU640_3382214929$ UNDOTBS2 OFFLINE _SYSSMU641_3615840322$ UNDOTBS2 OFFLINE _SYSSMU642_1256346590$ UNDOTBS2 OFFLINE _SYSSMU643_185223274$ UNDOTBS2 OFFLINE _SYSSMU644_2022437108$ UNDOTBS2 OFFLINE _SYSSMU645_694837358$ UNDOTBS2 OFFLINE _SYSSMU646_2809445821$ UNDOTBS2 OFFLINE _SYSSMU647_2672854505$ UNDOTBS2 OFFLINE _SYSSMU648_1913688378$ UNDOTBS2 OFFLINE _SYSSMU649_1204487932$ UNDOTBS2 OFFLINE _SYSSMU650_442227742$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU651_3737703649$ UNDOTBS2 OFFLINE _SYSSMU652_3671120567$ UNDOTBS2 OFFLINE _SYSSMU653_2762235440$ UNDOTBS2 OFFLINE _SYSSMU654_616729869$ UNDOTBS2 OFFLINE _SYSSMU655_2023250866$ UNDOTBS2 OFFLINE _SYSSMU656_145656138$ UNDOTBS2 OFFLINE _SYSSMU657_4066766518$ UNDOTBS2 OFFLINE _SYSSMU658_2213192185$ UNDOTBS2 OFFLINE _SYSSMU659_2224626974$ UNDOTBS2 OFFLINE _SYSSMU660_4225833303$ UNDOTBS2 OFFLINE _SYSSMU661_1780259820$ UNDOTBS2 OFFLINE _SYSSMU662_2669529737$ UNDOTBS2 OFFLINE _SYSSMU663_3709079355$ UNDOTBS2 OFFLINE _SYSSMU664_2812484144$ UNDOTBS2 OFFLINE _SYSSMU665_2327079395$ UNDOTBS2 OFFLINE _SYSSMU666_3891629475$ UNDOTBS2 OFFLINE _SYSSMU667_4279384012$ UNDOTBS2 OFFLINE _SYSSMU668_2389143128$ UNDOTBS2 OFFLINE _SYSSMU669_1850364901$ UNDOTBS2 OFFLINE _SYSSMU670_2556144900$ UNDOTBS2 OFFLINE _SYSSMU671_3213232716$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU672_2373009327$ UNDOTBS2 OFFLINE _SYSSMU673_2954248710$ UNDOTBS2 OFFLINE _SYSSMU674_1244825537$ UNDOTBS2 OFFLINE _SYSSMU675_3316891531$ UNDOTBS2 OFFLINE _SYSSMU676_82392956$ UNDOTBS2 OFFLINE _SYSSMU677_1580676346$ UNDOTBS2 OFFLINE _SYSSMU678_3017623553$ UNDOTBS2 OFFLINE _SYSSMU679_3411263567$ UNDOTBS2 OFFLINE _SYSSMU680_227193575$ UNDOTBS2 OFFLINE _SYSSMU681_1841145577$ UNDOTBS2 OFFLINE _SYSSMU682_2239271949$ UNDOTBS2 OFFLINE _SYSSMU683_2070377212$ UNDOTBS2 OFFLINE _SYSSMU684_2252442521$ UNDOTBS2 OFFLINE _SYSSMU685_2096437865$ UNDOTBS2 OFFLINE _SYSSMU686_3620516586$ UNDOTBS2 OFFLINE _SYSSMU687_1652067513$ UNDOTBS2 OFFLINE _SYSSMU688_1558946052$ UNDOTBS2 OFFLINE _SYSSMU689_1191310861$ UNDOTBS2 OFFLINE _SYSSMU690_4233887472$ UNDOTBS2 OFFLINE _SYSSMU691_3265480162$ UNDOTBS2 OFFLINE _SYSSMU692_1381369963$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU693_3983704301$ UNDOTBS2 OFFLINE _SYSSMU694_3319511011$ UNDOTBS2 OFFLINE _SYSSMU695_4270706741$ UNDOTBS2 OFFLINE _SYSSMU696_990054895$ UNDOTBS2 OFFLINE _SYSSMU697_2265139$ UNDOTBS2 OFFLINE _SYSSMU698_672710915$ UNDOTBS2 OFFLINE _SYSSMU699_315895000$ UNDOTBS2 OFFLINE _SYSSMU700_506493058$ UNDOTBS2 OFFLINE _SYSSMU701_240775262$ UNDOTBS2 OFFLINE _SYSSMU702_2667446774$ UNDOTBS2 OFFLINE _SYSSMU703_1099908504$ UNDOTBS2 OFFLINE _SYSSMU704_1483340113$ UNDOTBS2 OFFLINE _SYSSMU705_3661872822$ UNDOTBS2 OFFLINE _SYSSMU706_3190954811$ UNDOTBS2 OFFLINE _SYSSMU707_4118271394$ UNDOTBS2 OFFLINE _SYSSMU708_1838823043$ UNDOTBS2 OFFLINE _SYSSMU709_1647336755$ UNDOTBS2 OFFLINE _SYSSMU710_3164056504$ UNDOTBS2 OFFLINE _SYSSMU711_1651127068$ UNDOTBS2 OFFLINE _SYSSMU712_4120621199$ UNDOTBS2 OFFLINE _SYSSMU713_1351814957$ UNDOTBS2 OFFLINE SEGMENT_NAME TABLESPACE_NAME STATUS ------------------------------ ------------------------------ ---------------- _SYSSMU714_3408150751$ UNDOTBS2 OFFLINE _SYSSMU715_807233972$ UNDOTBS2 OFFLINE _SYSSMU716_53600027$ UNDOTBS2 OFFLINE _SYSSMU717_3325081247$ UNDOTBS2 OFFLINE _SYSSMU718_2402073878$ UNDOTBS2 OFFLINE 278 rows selected. all the segment are offline. befeore execute the drop statement i put the UNDOTBS2 (the OLD undo tablespace) OFFLINE (ALTER TABLESPACE UNDOTBS2 OFFLINE --> tablespace altered) but after some minutes some oracle procedure terminate in error with ORA-00376 . if i put the old UNDO tablespace ONLINE the oracle procedure terminate in succesfull. why this behavior? i must drop the tablespace without put it offline? thx for the answer. BYE!
×