Recent content by DrSeussFreak

Oracle 8 client can NOT connect Oracle 10. Just go download the oracle 10 client (or oracle 11 if you want) from http://www.oracle.com/technology/software/index.html

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 appreciate the response anyways :)

nevermind, we recently upgraded from oracle 10.1 to 10.2 and since we made a new oracle home, I had to copy the oracle pw file from the old home to the new home.

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;

if/when it returns a tablespace name, we either alter the existing datafile, or add a new one

We have other scripts that look for non-autoextensible files. This script was specifically meant for autoextensible files. For the non-autoextensible files, I have a script written that looks for how many extents are left, and when there are 4 or less it lets me know. I will share this script...

SantaMufasa, I bow to your knowledge. With 1 small change your code is the perfect solution to my problem select tablespace_name||' '|| sum(bytes)||' '|| sum(maxbytes) "Tablespace Approaching Full" from dba_data_files where autoextensible = 'YES' having sum(maxbytes)-sum(bytes)...

that looks great, but every day I am going to have this report run, how could I make it just return the ones that need attention?

Basically, I need the script to tell me when all the files in tablespaces that are autoextensible are full, and a new file needs to be added.

Ok, What I would like is for the script to see that yes, this file is at it;s capacity, BUT there is a second file that is not at it's capacity (or a 3rd) and so the tablespace can still actually continue to grow.

From Oracle Meta-Link

Mufasa, As always your scripts are amazing. This particular script seems to pull A LOT more data than we actually want to see. Could you possible vie wmy original code SELECT FILE_NAME||' '||BYTES||' '||MAXBYTES FROM DBA_DATA_FILES WHERE autoextensible = 'YES' AND maxbytes-bytes < 2097152...

I have also tried joining the table to itself, but I have no idea where to go with that SELECT a.FILE_NAME, a.BYTES, a.MAXBYTES FROM DBA_DATA_FILES a, dba_data_files b WHERE a.FILE_NAME = b.FILE_NAME AND a.autoextensible = 'YES' AND a.maxbytes-a.bytes < 2097152 order by bytes;