Search results for query: *

There is a job called 'GATHER_STATS_JOB' that can be found by running select job_name from dba_scheduler_jobs where owner = 'SYS' order by 1 I was wondering if anyone knows how to edit sys owned jobs/packages so I can have it skip a tablespace when it runs.

I am running a grant and look below for all the details Meta-Link says but when I look at the parameter, I get Any ideas?

How do I put a PL/SQL block into JavaScript. Using JavaScript, I need that when a link is clicked, the following PL/SQL block is executed. declare begin execute immediate 'ALTER SYSTEM SET ENCRYPTION WALLET CLOSE'; commit; end;

I have a script running on a server that runs Oracle 9i and it looks for auto extensible files that can not extend anymore. SELECT FILE_NAME||' '||BYTES||' '||MAXBYTES FROM DBA_DATA_FILES WHERE autoextensible = 'YES' and maxbytes-bytes < 2097152 order by bytes; I need this code to be modified...

I am just starting Perl for the first time in my professional life. I am reading "Beginning Perl" published by WROX, and I hit page 50. The 'not' operator or ~ . What the heck is it used for? ~85 = 4294697210 ~4294697210 = 85 000000000000000000000000010101010 = 85...

I have written a script that checks each drive letter on a server and if that drive letter has less than 10% free space left, it sends me an e-mail (per drive). My boss asked that it also send 1 e-mail a day if all the drives are ok. Below is my script, I need help to re-think the logic and...

Each day a new file named 'bkuparcfiles_09062007.log' is produced, and I need to e-mail it to myself and a co-worker. The problem is that, as you see that their is a date at the end, and it changes each day. How can I pick the file that has been most recently modified?' Const ForReading = 1...

I am copying some files from 1 location to another, and would like to (when I copy them) tack on a date/time on it. objFSO2.CopyFile "D:\oracle\admin\mrf1\bdump\alert_mrf1.log" , "D:\dba_util\scripts\log\alert_mrf1.log" Instead of just becoming "D:\dba_util\scripts\log\alert_mrf1.log" I would...

where I run the below code objFSO2.CopyFile "D:\oracle\admin\mrf1\bdump\alert_mrf1.log" , "D:\dba_util\scripts\log\alert_mrf1.log", OverwriteExisting I need to then clear out the original file from which I copied (or delete it), except that it is in use. How can I clear the contents of the...

I am running a script, and between steps Dim lStart Set lStart=createobject("wscript.shell") lStart.run "D:\dba_util\scripts\listener_start.bat" set lStart=Nothing and Dim lCheck Set lCheck=createobject("wscript.shell") lCheck.run "D:\dba_util\scripts\listener_check.bat" set lCheck=nothing I...

Look for the << >> and read what is inside to see what I need/want it to do. Const ForReading = 1 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.OpenTextFile("D:\oracle\dba_util\scripts\log\listener.log", _ ForReading) strSearchThis = objTextFile.ReadAll...

Ok, so any ideas on how to make this work? const ForReading = 1 dim strSearchThis dim objFS dim objTS set objFS = Server.CreateObject("Scripting.FileSystemObject") set objTS = objFS.OpenTextFile(Server.MapPath("D:\oracle\dba_util\scripts\log\tspace.log"), _...

I have a sql statement that I will be running, and I need to do 1 of 2 things. 1) Run this in a vb script and somehow find out the results (send an e-mail if "no rows selected" is listed after each select statement syaing all is ok) and (send an e-mail if it is not listed after each select...

I have this cmd file @ECHO OFF set backup_dir1=L:\ORACLE\MARSDATA\ARCHIVE set backup_dir2=K:\hot_backup\oraob10 c: cd "\Program Files\tivoli\tsm\baclient" dsmc incremental -optfile=dsm.opt %backup_dir1%\*.* %backup_dir2%\*.* > c:\adsmlogs\bkuparcfiles_%date:~4,2%%date:~7,2%%date:~10,4%.log...

I am using this code to check for any drives that are more than 89.9999% free. What I need is to add an e-mail function to my script so that when (pFree > "89.9999999") pulls a value, it lets me know. Any ideas? Thanks. Set objFSO = CreateObject("Scripting.FileSystemObject") Set colDrives =...

I was running Windows XP on 1 partition and Red Hat Enterprise on a separate partition. A co-worker blew away my red hat partition for some reason and now whenever I try to boot up (which only windows exists) I get Any thoughts how to get it to boot? I already tried running Windows XP recovery.

So over the last 2 weeks I have been working on Meta-Link with oracle about some issues with 10g. After 2 weeks and the 3rd oracle employees eyes I get this response We have 100+ servers all starting with 'u'. What a kick in the butt.

I know there has got to be a canned Oracle way in OEM to have a notification go out to all of the administrators when the alert logs get an error. For the life of me though, I am unable to figure it out. I have scripts from 9i that can do it, but anyone know of a way to do it internally to...

I am using Windows 2k3 and I am in OEM trying to get a new os command for a notification. 1) I go to Notification Methods 2) Click Go (Add Command) 3) Fill out form a) Name = MRF Test b) whatever c) OS Command = c:\mrf\ip.bat c:\mrf\ip.bat contains the following ipconfig /all >...

So I had 9i Installed and then someone installed 10g without creating a new local user account. I changed the varible in the registry for system path to be all 9i instead of 10g When I log in to sqlplus, it shows it is 9.0.6.0 but when I logout it shows that it is version 10. Any ideas?