ÕªÒª£º1.¼ì²âËùÓй鵵 RMAN> crosscheck archivelog all; 2.ÁгöËùÓÐÎÞЧµÄ¹éµµ RMAN> list expired archivelog all; 3.ɾ³ý¹ýÆڵĹ鵵 RMAN> delete noprompt expired archivelog all; ÔĶÁÈ«ÎÄ
oracle±í¿Õ¼ä×Ô¶¯À©ÈÝ[shell]
2023-02-07 17:07 by Ã÷³¯É¢·¢, 29 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼
ÕªÒª£º############################################################################################# # Version 1 20191021 # Manual # The purpose of this scri ÔĶÁÈ«ÎÄ
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
2023-02-07 14:19 by Ã÷³¯É¢·¢, 225 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼
ÕªÒª£º²é¿´×ÊÔ´ÏÞÖÆÐÅÏ¢ set pagesize 100; set linesize 100; col username for a15; col profile for a15; col resource_name for a30; col limit for a10; SELECT DISTINCT ÔĶÁÈ«ÎÄ
¡¾·ÖÇø±í¡¿·ÖÇø±í·ÖÇøË÷ÒýÖؽ¨
2023-02-06 16:03 by Ã÷³¯É¢·¢, 71 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼
ÕªÒª£ºSELECT 'alter index '||t2.owner||'.'||t1.INDEX_NAME||' rebuild partition '||t1.PARTITION_NAME||' online;', t1.STATUS FROM dba_ind_partitions t1, dba_i ÔĶÁÈ«ÎÄ
¡¾·ÖÇø±í¡¿·ÖÇø±í×î´ó·ÖÇø×Ö¶ÎÐÅÏ¢ÊÕ¼¯
2023-02-06 16:01 by Ã÷³¯É¢·¢, 44 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼
ÕªÒª£º·ÖÇø±í·ÖÇø×î´ó·ÖÇø×Ö¶ÎsqlÉú³É SELECT 'select nvl(to_char(max(' || column_name || ')),''0'') from ' || owner || '.' || name || ' union all' FROM DBA_PART_KEY_COLUMN ÔĶÁÈ«ÎÄ
pythonѧϰ£¨2£©ÔËËã·û
2019-09-24 13:20 by Ã÷³¯É¢·¢, 79 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼
ÕªÒª£º»ñÈ¡½á¹ûÊÇÖµ ËãÊýÔËËã·û£º ¸³ÖµÔËËã·û£º »ñµÃ½á¹ûÊDz¼¶ûÖµ ±È½ÏÔËËã·û£º Âß¼ÔËËã·û£º ³ÉÔ±ÔËËã·û£º Éí·ÝÔËËã·û£º ÔĶÁÈ«ÎÄ
pythonѧϰ£¨1£©ÈëÃÅ
2019-09-23 14:03 by Ã÷³¯É¢·¢, 113 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼
ÕªÒª£º±äÁ¿µÄÉêÃ÷ #!/usr/bin/env python # -*- coding: utf-8 -*- name = "sage" ±äÁ¿µÄ×÷Óãºêdzƣ¬Æä´úÖ¸ÄÚ´æÀïij¸öµØÖ·Öб£´æµÄÄÚÈÝ ±äÁ¿¶¨ÒåµÄ¹æÔò£º ±äÁ¿ÃûÖ»ÄÜÊÇ ×Öĸ¡¢Êý×Ö»òÏ»®ÏßµÄÈa56爆大奖在线娱乐â×éºÏ ±äÁ¿ÃûµÄµÚÒ»¸ö×Ö·û²»ÄÜÊÇÊý×Ö ÒÔϹؼü×Ö²»ÄÜÉùÃ÷Ϊ±äÁ¿ ÔĶÁÈ«ÎÄ