linux, Oracle, RedHat Oracle [ JOBS AND PROCEDURE Consult ] 3:16 PM Unknown No comments 1 - select job,what from dba_jobs resul: owner.name_procedure 2 - select text from dba_source where owner='OWNER' and name='NAME_PROCEDURE'; Good reading !!! Share This: Facebook Twitter Google+ Stumble Digg Email ThisBlogThis!Share to XShare to Facebook Related Posts:Perl - [ Mail::Sendmail ]#!/usr/bin/perl use strict; use warnings; use Mail::Sendmail; my $to ='xxxx@xxx.com'; my $from ='yyy… Read MoreOracle [ db_recovery_file_dest_size ] SQL> SELECT * FROM V$RECOVERY_FILE_DEST; NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------------------------… Read MoreOracle [ ADD USER ] Create user CommandLine identified by password; Grant dba to CommandLine; … Read MoreUser in lock [ Oracle ] sqlplus /nolog connect sys as sysdba select * from dba_users; select * from dba_profiles; alert user name account unlock; … Read MoreRman / Oracle / Backuprman target / catalog rman/pass@rmandb >crosscheck archivelog all;… Read More
0 comentários:
Post a Comment