Oracle work record

Job

Describe the INTERVAL parameter valu

12:00 midnight every day at 'TRUNC (SYSDATE + 1)'

At 08:30 every morning, 'TRUNC (SYSDATE + 1) + (8' 60'/ (24'60)'

Every Tuesday at 12:00 'NEXT_DAY (TRUNC (SYSDATE),' 'TUESDAY'') + 12 Compact 24'

12:00 at midnight on the first day of every month. 'TRUNC (LAST_DAY (SYSDATE) + 1)'

11:00 on the evening of the last day of each quarter 'TRUNC (ADD_MONTHS (SYSDATE + 2Acer 24,3),' Q')-1Accord 24'

Every Saturday and Sunday 06:10 'TRUNC (LEAST (NEXT_DAY (SYSDATE,' 'SATURDAY "), NEXT_DAY (SYSDATE," SUNDAY ")) + (6 × 60 × 10) / (24 × 60)'

-- Tablespace utilization

SELECT Upper (F.TABLESPACE_NAME) "tablespace name"

D.TOT_GROOTTE_MB Tablespace size (M)

D.TOT_GROOTTE_MB-F.TOTAL_BYTES "Space used (M)"

To_char (Round ((D.TOT_GROOTTE_MB-F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,2), '990.99')

| |'%'"usage ratio" |

F.TOTAL_BYTES "Free Space"

F.MAX_BYTES "maximum Block (M)"

FROM (SELECT TABLESPACE_NAME

Round (Sum (BYTES) / (1024 * 1024), 2) TOTAL_BYTES

Round (Max (BYTES) / (1024 * 1024), 2) MAX_BYTES

FROM SYS.DBA_FREE_SPACE

GROUP BY TABLESPACE_NAME) F

(SELECT DD.TABLESPACE_NAME

Round (Sum (DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB

FROM SYS.DBA_DATA_FILES DD

GROUP BY DD.TABLESPACE_NAME) D

WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME

ORDER BY 1

Alter tablespace ARVATOWMS add datafile'/ opt/oracle/oradatas/otwb/WMS03.dbf' size 8000m

Table size

Select round (BYTES/1024/1024,2) | |'M' from user_segments where segment_name='OMS_ORDER_LOG'

Calculate the time difference

(year (CURRENT_DATE ()) * 365*24+month (CURRENT_DATE ()) * 30*24+day (CURRENT_DATE ()) * 24+hour (CURRENT_TIME ()) + 8+minute (CURRENT_TIME ()) / 60)-(year (lastRemindDate) * 365*24+month (lastRemindDate) * 30*24+day (lastRemindDate) * 24+hour (lastRemindDate) + minute (lastRemindDate) / 60)

List the dates in the range

SELECT TRUNC (TO_DATE ('2014-01-01-01,' yyyy-MM-dd')) + ROWNUM-1 AS DATES

FROM ALL_OBJECTS

WHERE TRUNC (TO_DATE ('2014-01-01-01),' yyyy-mm-dd') + ROWNUM-1