Тёмный

Is DBMS_JOB de-supported? How to work around it 

SQL and Database explained!
Подписаться 14 тыс.
Просмотров 1,9 тыс.
50% 1

DBMS_JOB is listed as deprecated which raises fears that it might disappear one day. Here are some easy options on how to deal with this.
Follow me!
blog: connor-mcdonald.com
twitter: / connor_mc_d
The Podcast!
podcasts.apple.com/au/podcast...
open.spotify.com/show/5dqVVft...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
www.oracle.com/cloud/free
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #sql #performance

Наука

Опубликовано:

 

2 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@hadarpaiss3240
@hadarpaiss3240 Год назад
One can register a procedure agent directly on the queue that will ne fired automatically when messgae arrive, and eliminate the need for scheduled dequeue
@goranpaues7454
@goranpaues7454 Год назад
Cool, I didn't know this! But I can imagine that a scheduled dequeue would provide the best performance for high loads in many cases. Similar to how a scheduled refresh is often better for materialized views rather than a refresh on commit.
@hadarpaiss3240
@hadarpaiss3240 Год назад
@@goranpaues7454 registering stored procedure is very scalable. i use it for emailing, texting and more. The on-commit mechanism for mv is different😃. It had a terrible implementation, but it realy improved lately, to a usable degree.
@DatabaseDude
@DatabaseDude Год назад
True, but last time I checked (if using PLSQL callback) we're launching a new job to run the handler, so there is an overhead to manage. Negligible for most usages.
Далее
Hidden feature - TIMERS in SQL Plus
1:00
Просмотров 1,1 тыс.
The FASTEST way to unload data to CSV
12:37
Просмотров 4,4 тыс.
СПРАВКА ДЛЯ УНИВЕРА
00:44
Просмотров 251 тыс.
😍😂❤️ #shorts
00:12
Просмотров 716 тыс.
Whose action is better?🥹 #filaretiki #shorts
01:00
Просмотров 854 тыс.
3M❤️ #thankyou #shorts
00:16
Просмотров 8 млн
The Rise of Oracle, SQL and the Relational Database
22:19
Microservices with Databases can be challenging...
20:52
Top 10 V$ views for DBAs and Developers
8:55
Просмотров 2,2 тыс.
Scheduling Jobs with DBMS_SCHEDULER
22:12
Просмотров 38 тыс.
Internal queries KILLING my database!
7:22
Просмотров 1,5 тыс.
Reclaim space from tablespaces ONLINE with ONE command
5:01
Fastest way to delete data?
7:27
Просмотров 3,3 тыс.
YOTAPHONE 2 - СПУСТЯ 10 ЛЕТ
15:13
Просмотров 150 тыс.