Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DECLARE CURSOR c IS SELECT count(1) amount, pnd_index_owner OWNER FROM ctxsys.ctx_pending GROUP BY pnd_index_owner; pending_rec c%ROWTYPE; BEGIN OPEN c; LOOP FETCH c INTO pending_rec; EXIT WHEN c%NOTFOUND; DBMS_OUTPUT.PUT_LINE(rpad(pending_rec.owner, 15,'.') || pending_rec.AMOUNT); END LOOP; END;
Join the community of 500,000 technology professionals and ask your questions.