RE: Oracle DB Upgrade TO DO LIST

Ben - Thanks, I printed that for my checklists file. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 03, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Ken, Jared is probably right as far as a checklist

RE: Very Urgent

to just before the failure, or will you need to recover this tablespace on another server, then move it back to the production database? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 6:20 AM To: Multiple recipients

RE: Oracle's use of Indexes

Craig - Compare the init.ora file for these instances. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 8:45 AM To: Multiple recipients of list ORACLE-L OK, I'm confused. Maybe it's Monday morning and my brain's

RE: cannot allocate new log

Nuala - You didn't include your error number, so the following are some guesses: Is your database in archivelogmode? Check the path to the archive logs and make sure that drive hasn't filled. For the logs themselves, check the paths and permissions. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch

RE: Need help

when a table needs re-analyzed so it really lowers the system requirements. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Hi all, Can anyone tell me which

RE: Oracle's use of Indexes

the CBO to make a different decision. Are you using different usernames? Any chance one session is doing an ALTER SESSION? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 10:30 AM To: Multiple recipients of list

RE: cannot allocate new log

? Are there a lot of updates at that time? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 10:27 AM To: DENNIS WILLIAMS; Multiple ORACLE-L (E-mail) Hi Denis, Thanks for the quick reply, We're not getting an oracle

RE: use of reverse key index,cost based optimizer

Binley - Thanks for filling in the details. I suspected the answer might be more complicated than just balanced or unbalanced. Have you tried reverse key indexes yourself? Results? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday

RE: question about large pool

question. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 1:40 PM To: Multiple recipients of list ORACLE-L I think I read this somewhere, but I cant find it. Is it possible to use the large pool for a specific

RE: RE: question about large pool

That is pretty much my understanding. Here is a Web page that explains it pretty well: http://www.interealm.com/roby/technotes/tnlargepool.html Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 3:35 PM To: Multiple

RE: OCP Test Order

. Obviously the thrust of the questions are different, with the BR emphasizing integrity and Tuning emphasizing performance. Networking doesn't share anything with the other modules other than it touches on MTS. So I would vote to go ahead and hit the Tuning next. Dennis Williams DBA Lifetouch, Inc

J2EE for the DBA

/oracle/03-may/o33j2ee.html Not long ago my Java developers wanted a primary key on each table. I posted to this list and received very helpful replies. This article explains why J2EE needs that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official

RE: use of reverse key index,cost based optimizer

index, only fetch-by-key or full-index (table) scans can be performed. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, June 01, 2003 2:25 AM To: Multiple recipients of list ORACLE-L Skewed, yes. Unbalanced, no. Jared On Saturday

RE: use of reverse key index,cost based optimizer

Jared Nope, been burned on that one. I just couldn't think of an easy way to test this, but thought if I pointed it out and somebody knew it wasn't true it might irritate them into responding. Has anybody experienced success with reverse key indexes? Dennis Williams DBA, 80%OCP, 100% DBA

RE: Analyze table/index -- Interval ??

. You may (Balso send the HELP command for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: DENNIS WILLIAMS (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego,

RE: HELP URGENT RMAN FAILS - FILE?????

? Sorry this isn't much help, hopefully you've made more progress by now. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 5:45 PM To: Multiple recipients of list ORACLE-L methinks resync - could I be write? I

RE: archiving data

User Guide and your port specific documentation to determine if this is feasible or not. Also, I haven't seen where anyone has suggested that transportable tablespace might meet your requirement. Have you considered that? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: archiving data

you. Better spend the time while the tape is loading planning a comp day to spend some well-rested time with them. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 7:45 PM To: Multiple recipients of list ORACLE-L

RE: Need Help for 9i OCP

are to the point of arguing with the author, you are ready to pass the exam. Trying Jared's tiny url suggestion, otherwise go to Amazon and search for Couchman Oracle9i. http://tinyurl.com/d1wt Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: randomly generate unique key

chose mod 10, then our check digit is 8. So our new number is 1234567898. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Hi List, Originally, Our next generate

RE: Need to Log on 2000 users

Munish - Don't forget to change the init.ora parameter PROCESSES greater than 2000. I didn't see where anyone mentioned that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 4:15 AM To: Multiple recipients of list

RE: use of reverse key index,cost based optimizer

those statistics. Does that answer your questions? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 1:25 AM To: Multiple recipients of list ORACLE-L hai gurus please tell use of using reverse key index and what

RE: RMAN - Remote vs Local Backups

no problem. But, what I'm trying to get at is it better, worse or indifferent to run the backup from B or A. I would think there is extra network traffic to run the backup from B. DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Walter - What you describe is the standard RMAN configuration. Box B contains

RE: RMAN - Remote vs Local Backups

server is 8.1.6, and would need an O.S. upgrade to move to 9.2. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Dennis, The cron job can run on B only

RE: C++ Issues

Ethan - Is this a technical issue or a licensing issue? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 12:30 AM To: Multiple recipients of list ORACLE-L From the Oracle C++ Call Interface Programmer's Guide

RE: Function Based Index - Not Used ???

for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: DENNIS WILLIAMS (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web

RE: SAP Hands SAP DB over to MySQL

is. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Maybe it is just so they can continue to say they're not a database company (insert sound of condescension

RE: is this DBA's only mailing list?

, so can probably answer the operational type of questions. And there are a lot of people on this list that prefer to be called developers rather than DBAs. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 7:46 AM

RE: Diff between 7.x,8,9

You can find the Oracle documentation at technet.oracle.com. This is free, but you must register. Each new version of the Oracle documentation has a section titled New Features. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday

RE: Which method is more efficient

Jared - Thanks. Wow, I learn a new trick each day on this list! Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 6:15 PM To: Multiple recipients of list ORACLE-L There are easier ways to test redo generation than

RE: [Q] Benchmark rate and ORACLE database?

with database choice as NASCAR has to do with automobile choice. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Oracle doesn't do heavy maths so integer benchmarks should

RE: 10i

Robert - Does this mean we can expect a new book Oracle10i New Features by that respected Oracle author Robert Freeman coincident with the 10i release? I'm ready! Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 10

RE: RMAN - Remote vs Local Backups

that the catalog method may not suit everyone's situation and the control file method may best suit your needs. As others on this list have pointed out, not all conference speakers have gotten that message. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

RE: SAP Hands SAP DB over to MySQL

that wouldn't understand this. Day after day he would harangue Bob. One day he called up and icily said that the Oracle salesman had agreed to apply his Sybase license fee toward Oracle. When he hung up Bob smiled sweetly and said he's all yours now. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch

RE: Tablespace management.

Thomas - Oracle recommended Local and Uniform, so that is what I use for everything. It has worked out great. I even use autoextend and that hasn't bitten me but a couple of times. This is on 8.1.6 and 9.2. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: 10i

wouldn't want IBM to make it easier. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 3:00 PM To: Multiple recipients of list ORACLE-L I thought the database was going to manage itself! Now I'm disappointed, I

RE: 64-bit upgrade

Terry - My principle is always if the database is small enough and the downtime window is large enough, use exp/imp. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:05 PM To: Multiple recipients of list ORACLE-L

RE: RMAN - Remote vs Local Backups

Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch

RE: Oracle Error Message syntax

David - You could go to the documentation on http://technet.oracle.com and look up the error message manual for the Oracle version you are using. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:40 PM

RE: thanks all

the actual exam. But I would rather have it that way. I tried some other practice exams and they were quite a bit easier which could mislead you into thinking you were prepared when you weren't. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: skip scan index

List - If I wanted to know whether my query was taking advantage of index skip scans, how would I know? Is there something different in the EXPLAIN PLAN that I should look for? The discussion just made me curious. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Hidden Columns

Bill - Try Google. A quick search yielded the fact this has something to do with creating columns of objects, nested table, varray, or REF type. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 9:45 AM To: Multiple

RE: maxextents unlimited - value in dba_tables, dba_indexes

Jerry - I did a quick survey of some of my databases and only found a single table that had a null MAX_EXTENTS and it was not partitioned. Its name was ATEMPTAB$ owned by SYS. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday

RE: Which method is more efficient

significantly more redo. But don't trust my recollection on this issue, test it yourself. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Hello everyone, I have

RE: skip scan index

Thanks Waleed. Something even I can understand! Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 1:52 PM To: Multiple recipients of list ORACLE-L Easy test case: CREATE TABLE TEST_SKIP ( C1 NUMBER NOT NULL

RE: which util do I use to see oracle's execution plan?

/1904347010/qid%3D1054149206/sr%3D11-1 /ref%3Dsr%5F11%5F1/103-6975634-9907034 Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 2:15 PM To: Multiple recipients of list ORACLE-L I am so novice it'll probably take me years

RE: index-organized table question

Roy - This could be a good IOT candidate, but I haven't used them myself. My suggestion would be to test it. Here is a good paper on how to decide: http://www.peled.com/white_papers/iot.pdf A more recent edition is available on http://www.orapub.com (free but must register) Dennis Williams DBA

RE: Search engine

Text (interMedia Text in Oracle8i) http://technet.oracle.com/products/text/content.html - Don't use ColdFusion. It is easy but difficult to scale. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 3:45 PM To: Multiple

RE: Transaction Isolation levels in Oracle!

handles transactions extremely well and trying to help it only causes degradation. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 27, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi Oracle (I do NOT mean Rdb

RE: RE: ocp discount

When you signed up for the exam, there was a question as to whether you had any discount codes. It is the same screen that asks if you are an Oracle employee. If you enter the code on that screen, then you receive the discount. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL

RE: Oracle, IBM fight of whose DB is more manageable

Patrice Take a look at: http://www.pcmag.com/article2/0,4149,7275,00.asp It is about a year old, but is the review that comes close to your request. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 27, 2003 10:20 AM

RE: Space Remaining in Current Extent

average row length. This shouldn't change much unless some operation is performed that would alter that. Then by getting the number of rows in the table you could get a very close estimate of the table size at any time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Space Remaining in Current Extent

Kevin - The following may be useful in your quest as well: Diego Cutrone posted this 1/18/2002 This query will count how many blocks have data (at least one row) and are below the HWM: select count(distinct substr(rowid,15,4)||substr(rowid,1,8)) from TABLE; Dennis Williams DBA, 80%OCP, 100

RE: Cannot allocate new log - checkpoint not complete

these people are really saying. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 04, 2003 4:14 AM To: Multiple recipients of list ORACLE-L So do you think the following distribution will contribute to a better

RE: Rollback and what table's DML caused an ORA-1555?

can be done within hours. Modifying the application may take between a couple of days and never. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 04, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Hey all, Fighting

RE: RMAN Catalog: 1 vs. many - Opinions

problems across all your databases, you will use a single catalog. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 04, 2003 2:09 PM To: Multiple recipients of list ORACLE-L We are in the process of moving from traditional hot

Full table scan difference

anyone have a theory for this discrepancy? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Full table scan difference

Cary, Denny - Thanks very much. I was running out of ideas on a Friday afternoon, then I just ran out. Have a good weekend, will try these suggestions Monday. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 04, 2003 3:54 PM

RE: Cannot allocate new log - checkpoint not complete

Fermin - Connor's reply sparked an idea. By any chance do you have your redo logs on the same device as your data files? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 5:04 AM To: Multiple recipients of list

RE: oracle full table scan

Arvind - If you want to locate tables that are being scanned and the SQL statement, I have found the following script posted by Mohammed to work quite effectively. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] REM From: Mohammed Shakir [mailto:[EMAIL PROTECTED] REM

RE: Oracle OCI JDBC Driver Not Recommended for Multiprocessor Mac

/isbnInquiry.asp?userid=6WIANMIL 0Hisbn=059600088Xitm=2 isbn=059600088Xitm=2 Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 10:44 AM To: Multiple recipients of list ORACLE-L The performance of JDBC OCI vs Thin

RE: certifications was Re: Remote DBA

John - Thanks for the encouragement. I'll get cracking on the next exam this weekend!! Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Say what you think Joe

RE: Table Size?

Hamid Be sure to read How to Stop Defragmenting and Start Living very carefully so you really understand the concepts. These concepts free you from being overly concerned about details. Myself, I try to plan for 1 year of growth. The future gets too unpredictable past that. Dennis Williams

RE: RMAN: What blocks are backed up with a full backup?

and such. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Our RMAN backup is backing up much more than the actual data blocks when doing a full backup. I know

RE: upgrade q

be acceptable. I think either route would work fine. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 10:54 AM To: Multiple recipients of list ORACLE-L We're running Oracle 8.0.5 for 3 years now and want to go to Oracle9i

RE: dbshut script - shutdown or shutdown immediate

. I've seen it take 20 minutes to clean everything up and shut down. When a problem has occurred, that can be a LONG 20 minutes. That is part of the DBA skill set -- how to divert the attention of the people standing around your desk while you wait :-) Dennis Williams DBA, 40%OCP, 100% DBA

RE: RMAN: What blocks are backed up with a full backup?

Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 3:26 PM To: DENNIS WILLIAMS; 'Multiple recipients of list ORACLE-L ' Actually this is how RMAN works. It writes all blocks up to the HWM of a given table, even empty ones. So

RE: how to find INDEX CORRUPTION ???

). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: DENNIS WILLIAMS (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B

RE: Db. Upgrade Assistant - any bad stories?

, then repeat the exact steps on production. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 02, 2003 4:59 AM To: Multiple recipients of list ORACLE-L Hi I'm about to upgrade 8.1.7 db

RE: RMAN question.... (figured out if anywone is interested)....w

Chris - Congratulations on finding your problem. I have the RMAN log file emailed to me for each backup. This means more to look through. What you describe doesn't sound hard though. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: Remote DBA

tasks as you desire. For example, if your site doesn't have the staff to upgrade to a newer Oracle version, they can plan that task and perform the upgrade. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 02, 2003 2:34 PM

RE: Remote DBA

on a Windows platform, but I'm sure someone on the list does it. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 02, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Thanks Goulet,Dennis for the feedback. I have

RE: RMAN question....

book. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 7:24 AM To: Multiple recipients of list ORACLE-L Dennis, I wasn't actually restoring the control file. Only 'validating' that RMAN could do it. I also

RE: RMAN - Some basic Qs.

beginning by backing up to disk. Buy Robert Freeman's Oracle9i RMAN Backup Recovery. It covers MML integration. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 9:19 AM To: Multiple recipients of list ORACLE-L

RE: backup strategy for a database over 1 TB running SAP R/3

Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hi, What is the backup

RE: Index usage in 8.1.6

a definite indication that your application is over-indexed, this effort may be worth your trouble. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 10:59 AM To: Multiple recipients of list ORACLE-L How do you

RE: Lies, damn lies and statistics

Congratulations Stephane -- a good lesson for us all. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 3:14 PM To: Multiple recipients of list ORACLE-L The case is not as bad as the subject may let you believe

RE: sql query

/oracle/02-sep/o52sql.html Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 12:09 AM To: Multiple recipients of list ORACLE-L hi, i have a table with indent number and quantity with 10 rows ex ind_no qty

RE: Rman disk and tape work

for recovery. If it is just a report, you could use the TAG parameter when you perform backups so the disk backups and tape backups could easily be listed differently. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 9:44

RE: help

Jose - Not enough allocated or too much allocated (from the Oracle perspective)? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Hi! You didn't send your

RE: Which process is taking up so much CPU???

confirm this is correct, but it has provided me the information I've needed to resolve problems. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Dennis, you

RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

Jared - I agree with you. My understanding is that an Oracle upgrade just changes the data dictionary. An Oracle migration (like Oracle 7 to Oracle 8) involves changes to the tablespaces. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: Rman disk and tape work

. Do you have Robert Freeman's book Oracle9i RMAN Backup Recovery? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I am using RMan with and without the Catalog

RE: RMAN question....

could happen if you did that. I could see backing it up just to be safe. Was this a test database? Anyway I'm always willing to learn. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 3:54 PM To: Multiple

RE: Which process is taking up so much CPU???

Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 6:24 AM To: Multiple recipients of list ORACLE

RE: Week - Date function!

Stephane There are days when I just feel lucky if I can understand your code, let alone come up with something smarter. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list

RE: big disks..OFA??

performance is required of this database? As was discussed yesterday on this list, a lower-performance database will be okay on a single device. Put control files, redo on separate devices. If really good performance / high transaction rates are required, then lobby for more devices. Dennis Williams DBA

RE: Unable to lock file

that to the script cron is executing and then manually execute the script. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following

RE: Which process is taking up so much CPU???

Thanks Jeremiah. My bad. T early on Friday. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 9:19 AM To: Multiple recipients of list ORACLE-L On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add

RE: snapshot too old

AK Take a look at this. It explains it better than I could. http://home.clara.net/dwotton/dba/snapshot2.htm http://home.clara.net/dwotton/dba/snapshot2.htm Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 12

RE: Configuring Oracle with RAID and OFA

on how much performance this system requires. Gaja and Kirti explain this nicely in Oracle Performance Tuning 101. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 6:59 AM To: Multiple recipients of list ORACLE-L

RE: Oracle encouraging Linux software developers

Microsoft has an initiative to provide limited source code to a college. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 7:44 PM To: Multiple recipients of list ORACLE-L For those not interested in marketing

RE: Configuring Oracle with RAID and OFA

with your single RAID device. But then, if all your archive logs were on that device, I suppose you wouldn't be doing a recovery to the point of failure anyway ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 8:54 AM

RE: Which process is taking up so much CPU???

Fermin The spid column in the v$process column matches the Unix process i.d. You may need to track it back through the Oracle shadow process. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 9:14 AM

RE: Oracle encouraging Linux software developers

? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Interesting... whatever happened to HP/UX? Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems

RE: index on null column

AK Yes, it will benefit the non-null records. Just remember that the null values aren't indexes. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 5:19 PM To: Multiple recipients of list ORACLE-L I have

RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND

Hemant - If you've got to rework your backup script anyway (and retest it), why not consider switching to RMAN at this time? In my experience, negligible interference with production during a hot backup. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: moving away from mainframe

re-engineering. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 4:49 AM To: Multiple recipients of list ORACLE-L hi list Is there somebody on this wonderfull list considering to move away from the mainframe

RE: Reorganizing tables

. I notice that he spends almost as much time discussing the people aspects of tuning as the technical aspects. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 12:59 AM To: Multiple recipients of list ORACLE-L We have a new manager

RE: SQL Problem - Merging Result sets

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services

<    1   2   3   4   5   6   7   8   9   10   >