Hi Gurus,
I would like to group by the result of a select statement based on a particular
column.
But I am not using any aggregate function in the select list.
For eg. select deptno, empno from emp
group by deptno, empno;
I tried to do it in sqlplus by setting
BREAK ON column
Karthik,
To me it seems that you do not want any aggregate totals, just a list
grouping the employees of one department together.
For this if you could try ORDER BY DeptNo, EmpNo, I think it should work,
HTH!
Aleem
-Original Message-
Sent: Monday, September 23, 2002 1:28 PM
To:
USe select deptno, empno from emp
ORDER BY deptno, empno;
-Original Message-
Sent: Monday, September 23, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I would like to group by the result of a select statement based on a
particular column.
But I am not
Hello all,
DB: 8i
OS: solaris 2.7
can somebody post me reply for this.
is there any quick way to find which datablocks are
corrupted in my oracle database .
( other than dbverify and rman backup. )
b'coz we have BCV backup already implemented and we
cannot do a dbv every week for 500 gig
1.) Is HWM a segment oriented ? (ie) TS,TEMP,DATA SEGMENT etc.
2.)Process of Elimintaing HWM other than creation of a new table from the existing
table or by renaming tables ?
3.) Process of working of PCT increase ? is it related to data or table segment ?
Regards,
P.S.Mani.
Hi
Doesn't full export to /dev/null do this?
Jack
kommareddy
I'll endorse this (at a push ;P)..
Grab the DBATool (http://www.cool-tools.co.uk/products/dbatool.html), load
up the export file (taken with rows=n), and look under the PUBLIC users
information for roles, tablespaces etc.
DBATool is also related to another thread on this list as well (Copying
girish... give the manuals a try... and read about the sga.. and the
parameters affecting the sga size...
i';m sure you will come up with the answer to ur own question. ;-)
--
From: Girish[SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 3:35 PM
To:
Title: RE: quckways to find block corruption
Also check DBMS_REPAIR.
rgds
amar
http://amzone.netfirms.com
-Original Message-
From: Jack van Zanen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: quckways to
Hi
OLDALH Table has Total 100 Million Rows .
Each SQL Run may fetch about 2 Million Rows (for Respective SOL_ID Value) from OLDALH
Table
solgam is a Master Table Containing about 5 Million Rows
Thanks
-Original Message-
Sent: Friday, September 20, 2002 1:43 AM
To: Multiple
Bob,
All of the options stated by people from this list are excellent.
One thing that was not mentioned was that Excel can read any type of text
file. It will notice that it is a text file, and will provide you with the
opportunity to declare what the column delimiter is.
What this means is
Sun Storage Model 6960 (containing Multiple T3+ Units within) Allows a MINIMUM File
System(FS) Block Size of 16K.
DB Block Size 8K OR 16K , For Performance which is Advisable for a Hybrid Banking
Application ?
NOTE - Till Date we have been using 8K DB FS Block size for Our Banking
And do not forget to use ... WHERE ROWNUM65537 :-)))
JP
On Monday 23 September 2002 15:13, you wrote:
Bob,
All of the options stated by people from this list are excellent.
One thing that was not mentioned was that Excel can read any type of text
file. It will notice that it is a
Tom,
I did a quick test a couple of years ago (I think it was on 7.3.4) and found
that when starting up after a clean shutdown Oracle doesn't actually read
the redo logs, it just needs the files in the right location. Three step
test.
1. Clean shutdown (immediate) of small test db. Removed redo
Vivek - My understanding is that there it is usually not advisable to have
the Oracle block size smaller than the file system block size. The file
system must retrieve at least 16k at a time, so you may get less performance
if you choose 8k. Therefore, I would go with 16k myself.
Dennis
I have never thought that I would ever suggest using GUI tool over a command line.
Perhaps there is a first time for everything.
So, may I add to the list of good advices: use T.O.A.D. from http://www.quest.com/toad/
Disclaimer: I am not in any form affiliated with Quest Software nor I try to
Vivek - The first check is to ensure the username you are running the query
under has the correct temporary tablespace defined. This is not the default
in Oracle and is easy to overlook.
Once you've eliminated this, if you still have the error, you should run
EXPLAIN PLAN on your query and
I think your only option is to go with DB_BLOCK_SIZE=16384. If you leave it
at 8192, then every single-block read you perform will affect a 16K block in
the file-system and further down in the stack; a waste of resources. You
don't want to hurt the performance of random, single-block reads in
For small number of rows only.
JP
BTW: Free HTML report tool http://www.allroundautomations.com/bodyqr.html
On Monday 23 September 2002 16:23, you wrote:
I have never thought that I would ever suggest using GUI tool over a
command line. Perhaps there is a first time for everything.
So, may
Hi all,
First post since I begin a new job.
All my DBA contacts have played with Log Miner but
none of them have deployed it in a production
environment.
We want to set up LogMiner to be used across all
production DB (25+ db on Oracle 817).
The way I'm seeing this is the following :
- All
Does anyone know of some good resources about gathering statistics on Hash
Clusters. I am particularly interested in finding out how full our buckets
are and any chained links we have currently.
Thanks before hand for you help.
Tim Boles
DBA
Lockheed Martin Information Systems
[EMAIL
Good Morning/Afternoon/Evening!
I have been charged with implementing a data-archive strategy into an
existing, production system. The only issue I have remaining is that
damagement wants the developers programs to only see the active data when
they query the transaction table -- and the power
If you want to reduce the amount of time to check for block corruptions,
there are several approaches. These can be used individually or combined.
1) Only check the files for system, rollback and data tablespaces. Indexes
can be rebuilt and temp can be ignored.
2) Break up the checking so you do
Create the program to access the transaction table within its schema
directly and use a public synonym for power users. That should work.
If the transaction table is owned by another user, create a single synonym
within the program schema and a public synonym thereafter.
Thank You
Stephen P.
Hi folks,
just got asked about looking into migrating a production database from 7.2
to 9i,
will I need to add a flux capacitor to the server to achieve this ;-)
If not, can I migrate from 7.2 - 8i - 9i or are there additional steps
involved.
Kieran Murray
CardBASE Technologies®
BIM House,
Technically, after a consistent shutdown, the redo logs are not needed. All
transactions have been completed thus no redo is necessary.
However, I consider a full backup to include redo logs and control files.
The issue is not whether the database needs them for recovery, but whether
the dba
Kevin
I have always heard private synonyms are the preferred way to accomplish
what you want. If you prefer, you could assign developers the private
synonyms instead and everyone else gets the public one that gives access to
the entire table.
Looking at the larger issue, what is your goal
Srinivas
I think that as a minimum, to detect corruption you must read all data
blocks. There are several methods, most involve an Oracle process that will
error if a corrupt block is encountered. Export to /dev/null was mentioned
already. I have used ANALYZE TABLE VALIDATE STRUCTURE CASCADE,
Thanks Tim. That gives me somewhere to look. I'll set up a test table
sometime this week and try it out for future reference. If I come up with
anything I'll post it back here.
Jay
-Original Message-
Sent: Sunday, September 22, 2002 6:23 PM
To: Multiple recipients of list ORACLE-L
I have data files save under /export/home/oradata directory and this
directory shows 100% full disk space because of the growth of these files.
What should I do?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Agreed . though I have had disappointing results with 'ANALYZE ...
VALIDATE STRUCTURE ...' not detecting corruption only later to have an
application (i.e. user) encounter data block (or index block) corruption. My
last incidence ... I simply did a count(*) .. full table scan ... which
This seems to be coming up a lot lately, and I've had to do it myself
recently.
This is fairly easy to do with Perl. I think I posted something about
this within the past month, so you may want to dig in the archives
for some details.
Jared
On Friday 20 September 2002 14:03, Aponte, Tony
Sent: Monday, September 23, 2002 11:05 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
David - Do you have autoextend turned on for any of your datafiles? It is
pretty simple to relocate some of your datafiles to another disk drive if
that is your question. That datafile will be unavailable
Good morning list,
Environment HP-UX 11.0 Oracle 8.1.6
Can anyone help with this SQL.
I can get a result set of values from a table
that match a given list of values -
select code
from table
where code in ('A','B','C','D','E')
I can get a result set of values from a table
that do not match a
Here are possible options:
1) Export from 7.2 and import into 9i (may not be feasible for large
databases)
2) Upgrade to at least 7.3.3 and use Migrate Utility to go to 9i
3) Migrate to 8.1.7.0 and them upgrade to 9i.
Detail steps can be found in Oracle9i Database Migration Guide.
Good
Do you have recommendations on which chart to run, and at what interval?
The default interval in OEM 2.2. is every 15 seconds, but that caused my
quad-CPU Windows system to crash.
I reset it for every minute...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
Cache Management on Storage Box :-
Qs Which is Better ? Write-Behind OR AUTO Advantages of Each ?
Any Docs , Links on the Same ?
NOTE - Application is a Banking Product - Hybrid in Nature
i.e. both OLTP Batch Processing Operations Exist
Qs When Configured to AUTO is there an Overhead
alertSID.log if you have any corrupted block in your database and data is
being retrieved/accessed from that blockThis is the first place where
data block corruption is reported/recorded.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
A major down side of dbv is that it is strictly an offline tool. 'twould be
nice to have a low-impact online version (like has been eluded to in this
thread) to proactively check for corruption before it's effect is noticed.
But I suppose, like everything, that'll be in 10i. :)
Rich Jesse
It is a little awkward, but a union in an inline query may do the trick:
1 select a.code
2 from (select '10' code from dual union
3select '20' code from dual union
4select '30' code from dual union
5select '40' code from dual union
6select '50' code
Stephen
I missed one example...
Developer Connects
SELECT * FROM transaction; -- hits the transaction
table
I had thought of public synonym for user, private synonym for application.
But then I would have to create private synonyms for each developer.
I know, I know. The
Hello List,
I have a need to try an replicate a problem that has occured on our production
environment. It seems that occassionally our response time dives to the buttom
of the barrel in regards to our tuxedo application. When this occurs we have
found that many of the blocked sessions are
1700 values? I sure hope you like to type...
Could you create a text file of the table values and compare those against a
text files of the possible values? This would require O/S level privs.
-Original Message-
Sent: Monday, September 23, 2002 11:38 AM
To: Multiple recipients of list
Dennis:
The goal of the partitioning/archive are: better performance, faster and
fewer full-table scans, faster RMAN backups (move history to read-only
tablespaces), indexing history differently than active data to speed
research and to generally reduce the frequency of the the database is
Qs In sys.dba_tablespaces , Which is Better , ALLOCATION_TYPE USER OR SYSTEM with
EXTENT_MANAGEMENT being LOCAL for Both Cases ?
For Objects Existing in Locally managed Tablespaces having ALLOCATION_TYPE SYSTEM ,
NEXT_EXTENT has NO Value But EXTENTS has Values .
Qs Can Large Numbers of
Transfer few of the DataFiles to a separate disk.
To accomplish this, the Database should either be CLOSED but MOUNTed or the
DB should be OPEN but the datafile be OFFLINE. Once you ensure this, copy the
datafile to a different disk and use ALTER DATABASE RENAME FILE
'file_name_with_path' TO
Royce,
Just small correction
It is
Analyze table table_name validate structure cascade;
which checks for corruption of table and indexes based on that table and
error is written in alertSID log as well as producing trace file.
In my experience to check table/index level corruption this is
David,
Have you got autoextend on the datafiles?.
Are you sure the datafiles are growing and it is not that somebody has
placed an export dmp file there
(just guessing that from the name of the filesystem!!)
I am not sure what you when when you say you have datafiles saved there?.
Are they the
If the set of values is not too big and fixed you could do the minus using
dual
e.g.
(select 'A'
from dual
union
select 'B'
from dual
union
...
select 'Z'
from dual)
minus
select code
from table
-Original Message-
Sent: Monday, September 23, 2002 5:28 PM
To: Multiple
Dan (and Charlie),
Thanks.
Good suggestions, but the IN clause contains just
over 1700 values.
Puzzling, huh?
steve
--- Fink, Dan [EMAIL PROTECTED] wrote:
It is a little awkward, but a union in an
inline query may do the trick:
1 select a.code
2 from (select '10' code from dual
Dan et al,
I guess that is where I may head with it now. I
couldn't come up with an easier way.
Thanks all...
steve
--- Fink, Dan [EMAIL PROTECTED] wrote:
1700 values? I sure hope you like to type...
Could you create a text file of the table
values and compare those against a
text
Title: RE: SQL question
select *
from(select 'a' from dual union select 'b' from dual union select 'c' from dual ...)
minus
select distinct code
from table
/
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
dbv can be run on files that are part of an online database. It does present
a risk of providing a false alarm, but it is effective. In all the years I
have run it, I can recall only a handful of false alarms indicating block
corruption. This occurs when a block being read by dbv is written by
Hello all. I
need to provide a one page report on why it may be
beneficial for an
organisation with light usage, small DB to move
from Oracle to
SQL Server. Their request is purely
due to
having a
recognition of their charity status by Microsoft and therefore being able to
get
Couldn't you do this with a view
something like
create view trans_view
as
select *
from (select t.*
from transaction_all t,
user_roles u
where granted_role = 'POWER_USER'
union
select t2.*
from transactions)
-Original Message-
Sent: Monday,
Jonathan Gennick has an excellent article in Oracle magazine (sept./oct.),
which should help.
He demonstrates two approaches: with and without pivot table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Title: RE: SQL question
Steve,
select 'select a.code ' || chr(10) || ' from(' ||
from dual
union
select distinct 'select ' || || code || || ' code from dual ' || chr(10) || 'union' ||
from my_code_table
union
select ')' || chr(10) || 'minus' from dual
/
select 'select distinct
Raj,
It wasn't a question of coding the sql to create
all of the unions, but hitting a limitation on
the number of unions in the sql.
But, thanks to all for the effort.
steve
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote:
Steve,
select 'select a.code ' || chr(10) || ' from('
||
from
Hello All,
I am working on understanding the statspack report. To understanding it
better I would like to compare my report with a report on well tuned low
OLTP database . Some of you guys might have used the statspack to well tune
your DB and now it might be running at peak performance , if you
Sorry, forgot to provide a link:
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 2:33 PM
Jonathan Gennick has an excellent
Then use MySQL or PostGresSQL. These two are free (READ: LOW COST =
Charity Status you are looking for) and runs on multiple different OSes.
ltiu
Martin Kendall wrote:
Hello all. I need to provide a one page report on why it may be
beneficial for an organisation with light usage, small DB
Title: moving non system segments
I was playing around with Tim Gorman's hc.sql (health check) and
would like to move these objects into the USER tablespace. I would
like assistance in additional things to consider.
I haven't actualy used the command but believe I would use:
ALTER
what are the 1700 values
if the are all alphabetic and not too long you could do something like the
below though it's all getting a bit long-winded
select
chr(65+(floor((rownum-1)/676)))||chr(65+(floor((mod(rownum-1,676))/26)))||ch
r(65+(mod(rownum-1,26)))
from addresses -- any table big
Martin,
I'm making the assumption that your not keen on the vendor lock-in idea,
which has a lot of problems attached to it. But at the same time it appears
that your client does not care. Pity, I've seen several companies that died
due to being a MicroSlop only solution provider. But I
Sorry about the subject text typo. It should read Agnostic references for Oracle v SQl
Server 2000
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Martin
Kendall
Sent: 23
September 2002
19:34
To: Multiple recipients of list
ORACLE-L
Subject:
Hi,
In a test procedure I'm using successfully the default
feature for a parameter :
create or replace procedure testp1 (p1 in varchar2 :=
null) is
begin
if (p1 is null) then
dbms_output.put_line('il est null');
else
dbms_output.put_line('il est pas null');
end if;
end;
/
For incrementing sequence number, Oracle has to use an SQ enqueue latch. To
minimize the need for this latch, you can increase the cache size for the
Sequences. Additionally, you can also consider KEEPing the Sequence number
in Shared pool using dbms_shared_pool.keep() package procedure.
-
Martin - If I understand your first statement, the database is now on Oracle
and you are writing a paper on why they should move it to MS SQL Server. If
this is true, and given your other statements about the client, I would
think you could get plenty of reasons from the Microsoft web site. Or
List,
I have a new server that I installed Oracle 8.1.7.3 with partitions
and LMT. Some of the tables are quite large( in excess of 10 GIG) and I
was creating the indexes when the communication channel was lost. Of
course the rollback occurred but it was calculated to take in excess of
8 hours
Rafiq - But by then your users have experienced the corruption and you have
a crisis on your hands. I feel the idea is to find the corruption BEFORE the
users find it.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Monday,
Title: RE: SQL question
Maybe I think differently, I usually let server think about size or the number of clauses ...
if you have codes in a table what's wrong with ...
select distinct code
from my_code_table
minus
select distinct code
from my_data_table
/
???
Raj
Even though you control the extents with USER, the
underlying concept is still usage of bits (typically 5
x blocksize, unless you already had MINIMUM EXTENT set
on the tspace before migration from dict=lmt).
Thus, probably (assuming you don't want to use
uniform), an auto-allocate policy is best
-Original Message-
Sent: 23 September 2002 19:26
To: '[EMAIL PROTECTED]'
Hi Dick,
Thanks for your reply. This is quite an agonizing situation.
This client provides a service for their main benefactor in return for
the monies it receives. However it also has other customers that it
Ditto on PostgreSQL. I'm doing some benchmark testing and PostgreSQL
performs quite well in comparison to MySQL with the InnoDB table type. In my
artificial tests PostgreSQL is faster that MySQL (with InnoDB). Oracle 9.2
is about twice as fast as PostgreSQL when I crank up the number of
Just want to be picky. It is the SQ enqueue not the latch. There is an SQ
enqueue for each sequence. Increasing the cache size will help.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 9:14 PM
For incrementing
I am not sure how you can copy a regular file which is operating system
dependent to a row file which is managed by Oracle using dd. To me,
your only option may be export/import.
Regards,
Shakir
--- Gene Sais [EMAIL PROTECTED] wrote:
Another option is to shutdown db, backup the files to
Has anybody figures about the CPU cost of a consistent get vs a db block
get? I have always expected it to be higher but not extremely higher. I
have had a bad surprise today on a process-of-death which I am trying to
salvage (although it looks a bit more like the last sacrament rather
than a
How about trying
table_owner.table_name in your query where you specify the tablename
in your from clause?
Regards,
--- Van der Sande Patrick [EMAIL PROTECTED] wrote:
Dear,
As system I want to generate an explain plan of an end user query.
In this query a number of tables are defined
Hi Dennis,
Personally I would like them not to move.
Apart from all the Platform issues, they don't have ANY experience in
.NET
architecture and they only think it will be easier to administer the DB
because they do not have any experienced Oracle DBA's in their employ.
I am struggling to
Thanks, Anjo..
Me bad...
Not sure why I said 'enqueue latch' :(
Yes, it is SQ enqueue.
- Kirti
-Original Message-
Sent: Monday, September 23, 2002 3:03 PM
To: Multiple recipients of list ORACLE-L
Just want to be picky. It is the SQ enqueue not the latch. There is an SQ
enqueue
Yes, I have autoextend turned on for some of them. If I move them to a
different directory, how does oracle database recognize its new directory?
Is it something I need to setup in init.ora file?
Thanks,
David
-Original Message-
Sent: Monday, September 23, 2002 12:13 PM
To: Multiple
David - You will inform Oracle of the new location. Here is the sequence:
SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = '';
ALTER TABLESPACE OFFILNE;
move the data files
ALTER TABLESPACE RENAME DATAFILE 'old location' TO 'new location';
for each datafile in the
Stephane,
The cost of an LIO is determined by many things. It used to be that one row
access was one LIO. Now a days you will see that many rows are gotten in a
single LIO. That means that the single LIO is more expensive. You will see
that depending on the access plan oracle will access one or
Martin - Thanks for the clarification, but this prompts more questions. Is
there a single database involved that multiple clients share the use of, or
are you the vendor of a product that sits atop a database, but each client
has their own database installed at their location. If it is the
Stephane - I believe that Cary Millsap (www.hotsos.com) has studied this
issue in quite some detail.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 23, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L
David,
From he contents of the messages in this thread I conclude that you have not
had any DBA training, right?
Anyway, Yes you can move one or more of the datafiles while either the
database is shutdown or the tablespace is off line. If you have the database in
archive log mode you
List,
To solve the snapshot to old problem I created a new rollback segment
10 M /10 M without maxextents and increased my rollback tablespace to 8
GIG from 4 GIG. I should be able to handle it now without failing after
I offlined the other rollback segments. I am in the process of dropping
the
Oracle 8.1.7 docs state you have to own a job to remove it. I would
like to remove another users job. Is the only way to do by doing the
old swap user pw trick?
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
Try sys.dbms_ijob.remove
Also, remember a job must be broken before it can be removed.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 23, 2002 2:16 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7 docs state you
dbms_ijob allows you to remove any job.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
FWIW I like to do full exports in the middle of the night
just for this reason as a hot backup wont cut it.
If you find a corrupt block you can fix it using
either a PL/SQL or PRO*C rountine that can be
found on Metalink.
Search for corrupt blocks.
Mike
-Original Message-
Sent:
List - I am wrapping up my RMAN procedures so I can turn off conventional
backups and still sleep at night. I am on Oracle 8.1.6. Does anyone know the
answer to this question: If I do an RMAN backup to disk, then copy the RMAN
backup pieces to tape, and copy the archive logs to tape, do I need to
Hi List ,
What strategy you guys adapt for rolling back a
database patch ( I am talking about application patch not the oracle
software patch ) . For exampleif some table updates or some stored procs
are going in .. how you guysbackout patch if something doesn't work
after the patch . I was
Does anyone know of white papers or other documentation that shows
how to read an Active Directory server from within Oracle using the
supplied procedures?
Thanks,
Mike
---
===
Michael P. Vergara
Oracle DBA
Guidant
if a database link is not involved you can use
alter session set current_schema = end_user;
After you explain it, be sure to reset the current_schema back to what it was.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 23,
Beware, we had a corrupt block in an index. Big deal you say!? Every time
the client used the index
the database would crash! Not good. We now do exports, and dbverify. But
they don't catch bad index
blocks. We also learned to check the alertlog a couple of times a day.
R. Smith
On Mon, Sep 23, 2002 at 01:38:54PM -0800, MacGregor, Ian A. wrote:
Try sys.dbms_ijob.remove
Also, remember a job must be broken before it can be removed.
Thanks for the pointer, maybe not must be broken , this is 8.1.7.4:
SQL select job, what, broken from dba_jobs;
JOB WHAT
For those of you that are hitting corrupt blocks frequently enough to be
this current on it, I assume you are using the parameters introduced in
8.1.6 to keep on top of this,
db_block_checking
db_block_checksum
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL
Hi Dennis,
They have 5 databases, dating back to 7.1 and up to 8.1.7
They also have some very complex Oracle Forms and Reports.
What they do not realise at the moment is the amount of work
they will have to put in to convert the Apps. AND retrain the 4-5
members of staff who are more
Ron,
Are you rebuilding indexes frequently on this system using parallel clause?
With certian version of Oracle (7.3.4.3 on HP) there was a bug resulting in
index corruption when there were a composite index was involved. Work around
either remove parallel clause or upgrade to 7.3.4.5.
1 - 100 of 118 matches
Mail list logo