Re: Cache Management on Storage Box

I assume that write behind means that when the write I/O request gets to the controller cache the controller returns ok to the computer and then write the data to the disk in its own time, like DASD fast write on the mainframe. If this assumption is wrong don't read any more. I think that it all

OEM 2.2 using wrong time

Hi, We having a problem with OEM as follows: We have OEM 2.2 on Windows 2000. Production database and OEM database (8.1.7.2.1) running in the same server. It is a new server just went live in few days ago. First few days all the scheduled jobs in OEM ran OK. 5 days ago I added a job and discov

Re: Group By - Without using aggregate functions

Check if ROLLUP or CUBE helps. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 01:28 AM 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 aggrega

RE: DBA work load

I'm in a 24x7 shop where I am the only DBA ... and I have lasted over 2 years! I look after about 12 Oracle production databases - all of which have a 98% rebatable SLA attached to them. I also have 6 SQL Server databases with the same rebatable SLA. Thankfully, our environment is stable (knock

RE: Group By - Without using aggregate functions[Scanned]

Thanks a lot for your help. The Java programmers have decided to format the output themselves. K. -Original Message- Sent: Monday, September 23, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Karthik, To me it seems that you do not want any aggregate totals, just a list gro

How to reproduce a hanging connect attempt

Dear List, As an example for an article I'm working on, I'm showing how a hanging connect can be timed out in a Perl script via the alarm() call. By 'hanging connect' I mean a connection attempt that never connects and never returns an error code. I have one right now on my Linux box. I star

Re: moving non system segments

Title: moving non system segments Richard,   First of all, that "hc.sql" script is *really* old, not well written, and liable to produce all kinds of absurd advice.  Please take *anything* that it says with a large grain of salt (at least a grain large enough to be a salt lick for a herd of d

Re: DBA work load

Sadly this is one of those "How long is a piece of string" questions, It relates to what are you doing with those databases what support is required on a daily basis for those databases I can have a single database that requires 2 full time DBA's and another DBA supporting 20 or 50 databases.

Re: DBA work load

As metrics, Gb per DBA or databases per DBA are quite irrelevant. A single DBA, well-rested, experienced, and with proper planning and support, can manage hundreds of databases and dozens of Tb of data. On the other hand, some database production environments are so chaotic as to consume several

RE: ALLOCATION_TYPE USER or SYSTEM for a Locally Managed Tablespace ?

I'm not sure I understand what you exactly want but here is what I do/believe. Since 815 and up to 817, I use LMT with uniform extent size. I kept the number of extents by objects below 100. On a 8K block size, you should not have more than 505 extents for an object because that's the number of e

DBA work load

I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want "Industry Standards", like how many Databases can one DBA manage. Or how many GB/DBA or endusers/DBA? Does anyone keep these kind of stats? thanks _

Re: User / Synonym Question

Check into the RDBMS feature of "row-level security" (a.k.a. PL/SQL supplied package DBMS_RLS, a.k.a. "virtual private database"), which is an integral part of the "multi-org" functionality in Oracle Apps R11i. It's perfectly suited for your requirements... I've a paper and a quickie little demo

Re: quckways to find block corruption

Sorry for not noticing this email thread earlier, so I apologize for chiming in late... --- The original poster (Srinivas) disqualified RMAN as a possibility because he said that they were "already getting backups via BCVs". My question is: are you splitting off BCVs and then calling it good, w

RE: quckways to find block corruption

yes, but you can recreate an index without losing any data. fwiw. mike -Original Message- Sent: Monday, September 23, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Beware, we had a corrupt block in an index. Big deal you say!? Every time the client used the index the databas

RE: Agnostic references for Pracle v SQl Server 2000

Hi Maybe you need to talk with a Developer to quickly do a rough estimate of costs involved in taking one on the more complex form/reports systems to VB/.net platforms. make sure they don't scrimp on cost but be realistic. I don't think a 1 page report is fair or does justice to the question

Storage Box Cache Management - for the Storage Gurus

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 Wit

RE: ALLOCATION_TYPE USER or SYSTEM for a Locally Managed Tablespace ?

Missed your Point Can u explain ? NO MIN_EXTENTS Set at Tablespace OR Object Level when migrating from Dict to LMT Does Excessive Fragmentaion of Objects in Locally Managed Tablesspaces have a Performance Overhead OR does it have only a Space overhead ? Thanks -Original Message- Sen

Re: dbms_job.remove

No. Try using DBMS_IJOB.REMOVE. It is an undocumented package that can be used by SYS or a DBA to remove other user's jobs. It is one of the DBAs secret tools and should not be shared with lesser mortals. If this code is violated, we will find you! :) RWB Ray Stell <[EMAIL PROTECTED]>@f

RE: quckways to find block corruption

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. Rega

RE: Agnostic references for Pracle v SQl Server 2000

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 scientists

RE: quckways to find block corruption

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]

Re: dbms_job.remove

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

RE: quckways to find block corruption

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 -Origi

RE: Explain plan of a table you do not own

if a database link is not involved you can use alter session set current_schema = ; 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, 2002 1:09

HP-UX 11i/8.1.7.x/Oracle-to-AD

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 Corporati

patch backout

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 example if some table updates or some stored procs are going in .. how you guys backout patch  if something doesn't work after the patch . I

RMAN need for alter system archive log all

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

RE: quckways to find block corruption

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: Mon

Re: dbms_job.remove

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

RE: dbms_job.remove

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_job.remove

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 -

Re: excessive SMON on openvms update...

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 T

Re:RE: Data file size growing causing high disk space.

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

RE: db block get vs consistent gets

Stephane - I believe that Cary Millsap (www.hotsos.com) has studied this issue in quite some detail.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 3:14 PM To: Multiple recipients of list ORACLE-L

RE: Agnostic references for Pracle v SQl Server 2000

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 latter,

Re: db block get vs consistent gets

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 m

RE: Data file size growing causing high disk space.

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 tabl

RE: Data file size growing causing high disk space.

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 re

RE: Lock on a sequence

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 fo

RE: Agnostic references for Pracle v SQl Server 2000

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 under

Re: Explain plan of a table you do not own

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 def

db block get vs consistent gets

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 cure

Re: Best method to move Filesystems to RAW Devices.

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 ta

Re: Lock on a sequence

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 incrementin

RE: Agnostic references for Oracle v SQl Server 2000

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 concurrent

FW: Agnostic references for Pracle v SQl Server 2000

-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 pr

Re: ALLOCATION_TYPE USER or SYSTEM for a Locally Managed Tablespace ?

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 be

RE: SQL question

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 _

RE: quckways to find block corruption

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] -Original Message- Sent: Monday, Se

excessive SMON on openvms

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 to

RE: Agnostic references for Pracle v SQl Server 2000

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 did

RE: Lock on a sequence

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. - Kirt

Using Log Miner across all DB : problem with using parameters default

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; / T

RE: Agnostic references for Pracle v SQl Server 2000

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

Re:Agnostic references for Pracle v SQl Server 2000

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

RE: SQL question

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 enough

moving non system segments

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 . MOVE

Re: Agnostic references for Pracle v SQl Server 2000

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 D

Re: SQL question

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 excel

Statspack Report !!!

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

RE: SQL question

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(' > ||

RE: SQL question

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 c

Re: SQL question

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:

RE: User / Synonym Question

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,

Agnostic references for Pracle v SQl Server 2000

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 everythi

RE: quckways to find block corruption

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 dbw

RE: SQL question

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

RE: SQL question

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 >

RE: SQL question

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 fro

RE: SQL question

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 recipient

RE: Data file size growing causing high disk space.

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 c

RE: quckways to find block corruption

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 is

RE: Data file size growing causing high disk space.

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 'ne

ALLOCATION_TYPE USER or SYSTEM for a Locally Managed Tablespace ?

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 Ex

RE: User / Synonym Question

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 runni

Lock on a sequence

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 t

RE: SQL question

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 O

RE: User / Synonym Question

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 d

RE: SQL question

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 f

RE: quckways to find block corruption

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

Cache Management on Storage Box

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 Wit

Re: quckways to find block corruption

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 PROT

OEM Performance Manager

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 & Oper

RE: Back to the Future - Migration from 7.2 to 9i!!!

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 luck.

SQL question

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

RE: Data file size growing causing high disk space.

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

Re: Spool Oracle Tables into Excel Format

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 wro

RE: quckways to find block corruption

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 n

Data file size growing causing high disk space.

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] Fa

RE: ALTER TABLE DROP COLUMNS CONTINUE - how far has it gotten

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 J

RE: quckways to find block corruption

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, w

RE: User / Synonym Question

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 wi

Backing up redo logs WAS: Lost ofall redo logs

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 need

Back to the Future - Migration from 7.2 to 9i!!!

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, C

RE: User / Synonym Question

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. K

RE: quckways to find block corruption

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 1

User / Synonym Question

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

Hash Cluster Statistics

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 PROTECTE

Using Log Miner across all DB

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 d

Re: Spool Oracle Tables into Excel Format

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,

  1   2   >