RE: Please help with ORA-01555 Snapshot too old

errors, you can rarely say fixed, but I think you are getting some good suggestions from the other postings on how to fix the underlying problem so your likelihood of receiving these errors is much reduced on either system. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: LMT Migration

LMT adventure. You don't want to have misunderstandings and then have to redo your work. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 22, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Hi! Make sure your

RE: Active Directory question

? My Active Directory administrator tells me this is not like a normal AD container. We've read the documents and are confused on this point. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: LMT

AK None that I'm aware of. That is how I moved my tables into LMT, a few at a time. You may want to check Metalink for any bugs related to your specific Oracle version. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday

RE: How to put both OID and Microsoft Active directory working???

to create the container called Oracle Context Structure in Active Directory. Have you done this? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 17, 2003 4:34 AM To: Multiple recipients of list ORACLE-L HI PEOPLE thanks

RE: RMAN SQL Backtrack

-by-step tutorials. Simple enough even I could understand. Robert has tutorials as well, but I haven't performed those. So if you get stuck getting the idea behind RMAN, consider this book. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: How to make SPFILE in sync with INIT.ORA ?

Niall I think that was the intention of the COMMENT parameter. As you point out, that isn't foolproof. An improvement might be if Oracle tagged each change with a date stamp. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday

Active Directory question

called Oracle Context Structure in Active Directory? My Active Directory administrator tells me this is not like a normal AD container. We've read the documents and are confused on this point. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see

RE: RE: should you separate indexes from tables in separate dataf

and indexes separate, you can criss-cross, i.e. put table A on device A and index A on device B, then table B on device B and index B on device A. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: RE: should you separate indexes from tables in separate dataf

R, Just to avoid confusion, that wasn't what I meant by batch program benchmarking. Are you rebuilding indexes? I've seen some strong benefits when rebuilding indexes of having the index and table on separate devices. But then that is really easy for you to test. Dennis Williams DBA, 80%OCP

RE: should you seperate indexes from tables in seperate datafiles

Matt Thanks so much for your posting. I especially appreciated your comment try not to be too smart. Would you consider writing a book on the topic of I/O Devices for the Oracle DBA? I would like to learn more, but don't know where to begin. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch

RE: How to make SPFILE in sync with INIT.ORA ?

a text configuration file seems very last century. I think with the pfile and spfile, Oracle was trying to give us the best of both worlds. How well they succeeded is a matter of judgement. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 15

RE: Estimating User Load on the system

be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general

RE: Oracle security question

Don Well, if you changed the password, then you should have the new password. Don't post them, because everyone on the internet will have them. What is your Oracle version? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday

RE: Oracle security question

Don Interesting web site. Well, I think you have enough information from us. Now it is just some detective work. The next subject you need to review is backup and recovery. Keep the information in those databases secure. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL

RE: Billing cpu usage on a monthly basis

around that obstacle would be to create a separate instance for each customer and have Oracle installed separately for each customer. That is about as profound as I can get on a Friday just returned from vacation. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Oracle security question

are and then audit the usernames they use to ensure the privileges granted are just what is required. This is also a good time to see about changing passwords, but first buy the book and read up on the basics of Oracle security. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Oracle security question

. And don't forget to buy a good Oracle DBA book like the one I suggested. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 11, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Dennis: Thanks for your message. Now I have

RE: Oracle security question

But when I try to login from sql plus window by using sys, I cannot successfully login. Also I get an error message. The message is something like connection to sys should be as sysdba or sysoper. So my question is what sys for? Thank you very much! Don DENNIS WILLIAMS wrote: Don If only you

Database benchmark

, the article mainly discusses why certain seemingly insignificant factors caused MS SQL and DB2 to perform poorly. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED

RE: Recommended Init File for Standby

work - make a pass or two at it, then move on to the next fire. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 11, 2003 4:35 PM To: Multiple recipients of list ORACLE-L I knew I would be providing more information. 1

RE: Do Not Call

Stephen From what I understand from our Web administrator, the netcraft site just reports the web server that is used, not the application server or database. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED

RE: Oracle DBA 9i Books ever needed.

. However, there are others on this list that can provide far more competent assistance than I, even including some book authors. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 3:40 AM To: Multiple recipients of list ORACLE

RE: RE: 9iAS admin certification

to match what you need with the menu word. Anybody that wanted to quit learning when they left school shouldn't have joined the software industry. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 10:50 AM To: Multiple

RE: Tech meetings

: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Drop Tablespace

Hamid Is there any chance this was created as an Oracle Managed File (OMF)? http://otn.oracle.com/products/oracle9i/daily/04.html They have special file names. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 3

RE: service name

Interesting. From the Oracle Net8 Class Notes, page 2-4 A service name is an alias for a destination address. The service name directly maps to a connect descriptor. I always find networking confusing. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: What are the restrictions in naming an Oracle SID/Database?

issues like this is why the more experienced DBAs tend also to be fairly conservative. Usually you have to solve enough problems without creating your own. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 10:50 AM

RE: RMAN Recovery Question: Restore with loss of control files an

first. 2. I have not been able to convince RMAN to use a different backup location. Fortunately with Unix it is easy to create a link that looks like the original location. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 30

RE: Oracle unlimited concurrent license

Peter Concurrent licenses were offered years ago. I have not heard of an unlimited concurrent, but it may well be that Oracle Sales sold them one. The key would be finding the sales agreement they and Oracle signed and seeing what it says. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc

RE: salary question

Didn't someone earlier this week post another site besides salary.com? Something with the word pay in it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Whatever

RE: ORA-04031

Peter You might take a look at Note 146599.1 on Metalink, Diagnosing and Resolving Error ORA-04031. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 2:30 PM To: Multiple recipients of list ORACLE-L One of our

RE: opinion of listers on product(s)

Greg - The following note was posted to this list awhile back. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Check on Oracle streams in 9iR2

RE: Re: 9i OCP Details

Totally agree. Make the pitch that this class alone could push your skills up to the next level. It is a real eye-opener. I'll bet it is much less than an Oracle Education class. As a bonus I think they usually let you use their tools for a month. Use your negotiating skills. Dennis Williams

RE: Index question

] Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 9:04 PM To: Multiple recipients of list ORACLE-L Hi!! Let explain more about my situation. The company that I work for is a chain of stores around some city's

RE: explain plan

start with id=0 connect by prior id = parent_id / truncate table plan_table / Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L List , does anybody

RE: nfile parameter problem

, just a gut feeling. Myself I would tend to lean on the system administrators to fix their problem at least as a start. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 3:00 PM To: Multiple recipients of list ORACLE-L

RE: SQL*Loader Help -- Multiple rows into single column

versions of the Unix utilities floating around. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 3:40 PM To: Multiple recipients of list ORACLE-L Gurus, I have a special scenario to load data into tables with SQL

RE: Help Needed regarding partitioning

involves dictionary manipulations. It can be used for other purposes like renaming columns, changing the owner of a table, etc. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 6:15 AM To: Multiple recipients

RE: SELECT Output Default Ordering ?

that entirely depends on this principle. Crude but nevertheless effective. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 8:33 AM To: Multiple recipients of list ORACLE-L When NOT Giving any Order by Clause

RE: Dynamic SQL: where do you draw the line?

to a halt. On the plus side you end up with a good story you can tell developers when they think you are just crying wolf. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 10:05 AM To: Multiple recipients of list ORACLE-L

RE: SORT_AREA_SIZE question

, it is used most efficiently. With a data mart, you may have some really large sorts that will always be too large for memory sorts. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 9:39 AM To: Multiple

RE: Statistics problem

. 3. Is is possible that you have skewed data in some columns, and you should be considering histograms? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Hi All

RE: nfile parameter problem

). 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-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 9i OCP Details

will announce that in 6 months the 8i path will be closed. This has already happened with Oracle 8. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi Group, I wanted

RE: 9i OCP Details

nobody gets out of your class without logging in?. My reply was a sly grin. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 2:05 PM To: Multiple recipients of list ORACLE-L You'll want to verify

RE: SORT_AREA_SIZE question

on the list of priorities. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 1:31 PM To: Multiple recipients of list ORACLE-L Since we are talking of Sort area sizes here, I tried to collect some statistics

RE: SELECT Output Default Ordering ?

: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: Migrating 8i OPS to RAC 9.2

employees monitor this list, because I've received feedback through Oracle. If I were you, I would take it as a lesson, with pretty mild repercussions at that, shrug it off and keep on keeping on. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: nfile parameter problem

have a big server with hundreds of dedicated connections and hundreds of files, and don't have this issue. Hopefully I won't encounter it anytime soon. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 4:59 PM

RE: LOCALLY MANAGED TABLESPACE

Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Oracle Collaboration Suite Licensing.

Ali, This announcement may be of interest to you. http://www.infoworld.com/article/03/06/24/HNoraclecollaboration_1.html Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:35 AM To: Multiple recipients of list

RE: [Q] any one know ORACLE A/D connector?

what information Oracle expects to find in the LDAP. I think the main impediment to LDAP at this time is a lack of understanding, which manifests itself in the form of asking the wrong questions. Hopefully someone more knowledgeable in LDAP will post. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch

RE: DATAFILE SIZE

Jerome - Check Metalink Note 112011.1 which I believe Steve Orr brought up recently. As I recall, 8.1.7.4 and above is not affected, but it is worth verifying to make sure. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June

RE: (OT) RE: Look's like Larry's at it again...

might want to meet Bill Gates up in the wild blue yonder. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Well, what will happen if Oracle acquires a nucular

RE: ora-4030 out of memory error

LeRoy Check out Metalink Note 199746.1 Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 3:00 PM To: Multiple recipients of list ORACLE-L All - I have a user receiving this error on several different Unix boxes

RE: got EXP-00091 warning

. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, June 21, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, I wonder if I can find whether or not there is any problem in that schema, because that could

RE: controlfile backup obsolete above 2 days

Offhand it sounds to me like you may have uncovered an error. I would search metalink and if you don't find an error matching this situation, I would file a TAR. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 9:34

RE: Development projects: Multiple databases v/s multiple schemas

of multiple instances - Can bring instances up/down independently - Can tune instance independently - If a project requires a different Oracle version because of another constraint, like a front-end tool, different projects can have different Oracle versions. Dennis Williams DBA, 80%OCP, 100% DBA

RE: Partition

Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 12:00 PM To: Multiple

RE: got EXP-00091 warning

Jin I cured this one with STATISTICS=NONE. Inelegant, but effective nonetheless. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 10:21 AM To: Multiple recipients of list ORACLE-L Greetings, When I export

RE: how to handle client installs w/o admin privs

Joe If your administration group controls the machines to this extent, I would hand the administrators a CD with Oracle client on it and say go for it, your baby now. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20

RE: Partition

distance off. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Hey Dennis: I created a range partition table with the last high_value being maxvalue. The partition key

RE: Partition

interested in exporting the new data. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Jacques, the version is 9.0.1.1.1. Dennis, Thanks for the confidence I totally

RE: Oracle releases by the different platforms...

sure Hicks is not anticipating a management career with IBM. I would speculate that he has his golden parachute all loaded and ready. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 9:13 AM To: Multiple recipients

RE: INDEX REBUILD

Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance. Dennis Williams DBA, 80%OCP, 100% DBA

RE: data architecture/conferences/documents/lists

. Gregory For Star schema I think Ralph Kimball is the place to start. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 2:11 PM To: Multiple recipients of list ORACLE-L Interested in data architecture issues beyond

RE: INDEX REBUILD

Guang - Below is what Jared said on this topic: Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 26, 2002 9:14 PM To: Multiple recipients of list ORACLE-L Though I have published a script for determining indexes

RE: copy a datafile to a raw device

in the Oracle Manuals. Just thought I should mention this in case you hadn't considered it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Well heck. Nobody else has

RE: data architecture/conferences/documents/lists

reasons for not choosing some alternatives. Made me look a lot less dumb in a pinch. And if the modeler wants to argue you can just state that you are just providing information so it isn't you against them, but them against some noted authors. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc

RE: Partitions of table read only

step or two (something I never like in a recovery). Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Jack, It is possible to have some partitions of a table

RE: MySQL in the future?

Dick So does that mean that MySQL could do the famous Microsoft maneuver? Give it to them free/cheap until they're hooked, then raise the price? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 18, 2003 4:25 PM

RE: JDBC and MTS

). It connects directly to the listener. One possibility to test would be to switch to the thick client. That may be better in your situation. Good luck and keep us posted. We DBAs are all facing this webbified/Javafied/.netified world and we've got to stick together. Dennis Williams DBA, 80%OCP, 100% DBA

RE: World premier performance of the BAARF party logo

Mladen - Thanks for the clarification. Gee, does this mean no book? Well, maybe the movie would be some compensation. Cary - Thanks always for your willingness to share your knowledge. Looking forward to your book. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Re: Opinions of high-volume DDL and data population

is a great candidate for partitioning. The points about chaining are excellent. If you decide to add the column to the current table, there is a way to identify chained (technically migrated) rows and fix them by just moving those rows. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL

RE: World premier performance of the BAARF party logo

tests? What type of tests would be most useful? If I choose the wrong test, and RAID5 looks just as good as RAID1+0, I'm sunk. Then for years to come when I try to make a point at a meeting someone will say yeah, is this another RAID1+0 theory? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc

RE: RE: Fragmentation ?

of fragmentation, read the introduction. It explains which chapter discusses which type of fragmentation. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 13, 2003 9:15 AM To: Multiple recipients of list ORACLE-L

RE: index partition

Hamid On a partitioned table you can create either global (normal) indexes or local (partitioned) indexes. There are advantages and disadvantages to each, but you could start with normal indexes and then switch to partitioned indexes as you find the need. Dennis Williams DBA, 80%OCP, 100% DBA

Oracle Names

that Oracle Names is going away in favor of LDAP. Is this imminent, or just a scare tactic? I had held off using Names because of this, but the company has made a commitment to MS Active Directory, which I gather from the list postings isn't very compatible with Oracle's LDAP. Dennis Williams DBA

RE: Oracle Names

is WONDERFUL!! Thanks everyone. Even if we choose not to implement Names, it will give me some incentive to study those chapters for the OCP Net Administration module, which is the only one I have left. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

RE: dbms_stats via dbms_job - syntax question SOLVED

John Then be sure to set the init.ora parameter _do_what_I_mean=true It solved most of my problems. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 4:35 AM To: Multiple recipients of list ORACLE-L

RE: Fragmentation ?

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-- 858-538-5051 http://www.fatcity.com San

RE: high cpu

Ak - Were the processes you killed doing updates? If so the work is probably rolling back changes. Then it won't make much difference whether the process rolls it back or smon does. You could take a look at the wait statistics to get an idea of what is going on. Dennis Williams DBA, 80%OCP

RE: Deleting Statspack tables.

from stats$snapshot to determine which snapshots to remove. It runs slowly (because of all the child tables?), so I just remove a hundred or so at a time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 10, 2003 2:15 PM

RE: anyone have any soundex scripts?

Have you checked out the Oracle SOUNDEX() function? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 09, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I was on a project a few years ago where we used a soundex

RE: RE: anyone have any soundex scripts?

are endless. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 09, 2003 11:30 AM To: Multiple recipients of list ORACLE-L one that is already written to find duplicates. like I stated earlier. you have to write quite a bit of logic

RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink o

and to create a loader control file if that is the fastest method. For the many small files, just use exp/imp. Please update me on any conclusions you reach since this topic is of significant interest to me. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: Setting database owner to sid

process and the user shadow processes. You may find it simpler to install Oracle under each of these accounts. This takes up more space, but will allow you to upgrade each database independently. Or you may find what you are trying to accomplish is more trouble than it is worth. Dennis Williams

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

measurements just in case you caught the system at a bad moment. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L As subject line indicates standard (level 5) snapshots

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

the problem clears itself up. You can take a couple of STATSPACK snapshots and do damage control on the people side in between. But man are those snapshots SLW when the system is about belly up. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Steve - Is there a Metalink note on this? What would a person search for? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 12:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Nevermind, a search on 2gb yielded Note 112011.1, which seems to explain it all. Oh well, one more item for my to do list. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 2:30 PM To: Multiple recipients of list

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Steve Personally I am VERY glad you mentioned this today. Since I run 64-bit Unix, I didn't think this applied to me, but after reading the note, I ran their formula and found a file on one of my databases that was very close to the limit. Plenty happy to dodge that bullet. Dennis Williams DBA

RE: cannot allocate new log -- Problem Solved

Naula - Don't worry about it. You've given me something to look for the next time. I'd rather learn from someone else's problems. :-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 03, 2003 5:25 AM To: Multiple recipients

RE: Schedule Analyze using DBMS_STATS ???

-- (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: Re: question about large pool

devices. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 03, 2003 8:02 AM To: Multiple recipients of list ORACLE-L you only want DBWR_IO_SLAVES or multiple DBWRn if you have datafiles spread over multiple I/O points correct

RE: performance questions

for the users. Either somebody can buy another server, or somebody can agree to a higher SLA, etc. The point is that you're talking, getting issues aired, rather than you guys saying @#$% users and the users saying @#$% DBAs. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Unix host name change - what happens to db?

Carmen - I haven't had this happen, but I think the main issue would be in your listener.ora and tnsnames.ora files. If you are referencing the host name in those files, then those will need to be changed. Is the IP address changing? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc

RE: Re: question about large pool

them fill that network link to capacity that much quicker. My way of working around the problem was to move hot files to direct attached storage. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 03, 2003 11:56 AM To: Multiple

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