Database Analyst Tasks
Hi all! Can you guys, clear me up about what are the tasks of a database analyst. I mean something like a job description. I know they are likely to be different from case to case but just to make an ideea. Thanks in advance. Iulian Ilies ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Select from Long Datatype Field to INSERT into a Varchar2 Datatype Field
Qs How is Select of Data from a Long Datatype Field to INSERT into a Varchar2 Datatype Field in another Table possible ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Performance Tuning on RAC with Digital Unix
We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3 Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Oracle on Linux ..... Red Hat vs. Suse
No, it's not certified, but I know the guy who successfully installed 9.2 on the cooker. Certificates are of limited value in the Linux world. A product can be certified and yet you may suffer when installing. We're still living in the early days of linux. Later on, RH will become another Microsoft and we'll have 2 Behemoth companies instead of one. -Original Message- Sent: Monday, July 22, 2002 11:23 PM To: Multiple recipients of list ORACLE-L On Mon, Jul 22, 2002 at 03:04:03PM -0800, ltiu wrote: > Mandrake 8.1/8.2 works really well with Oracle 9i Release 2. but is not certified by Oracle. > > It's RH compatible, meaning applications are numerous but it does not have the > faulty compiler and it's still free unlike Suse. Downloads are easy to get at as > well. A lot easier than RH and Suse. > > ltiu > > Quoting "Gogala, Mladen" <[EMAIL PROTECTED]>: > > > Well, I switched from RH 6.2 to SuSE 7.2 (now I'm running 8.0) > > and here are my impressions: > > 1) RH was using a proprietary compiler (gcc 2.96) and libraries > >were incompatible with many independent pieces of software. > >In particular, Oracle installation was a genuine nightmare. > >No way I'm going back to RH while they're using that @#$! > >compiler. > > 2) Availability of software for SuSE is very poor. Nothing on the > > rpmfind.net, > >their website is lousy and they are working very hard to make it even > >worse. In particular, they used to have a subdirectory called > > "full-names" > >where one could find all rpm packages that were officially available for > > a > >given release. That was far too easy, so they removed that directory and > >replaced it with the file "INDEX.gz" which you are supposed to download, > > > > "zgrep" for the given package and then download it from it's location. > > 3) SuSE technical support is bad and less then useless. RH wasn't a shining > >example of customer service either, but SuSE really shows you what the > > word > >untermensch really means. > > 4) SuSE kernel is tainted and is not reporting version the way it's > > supposed > > to. > >That confuses the heck out of the utilities like OSS sound drivers. When > > I > >asked SuSE for help they told me to use ALSA (I've paid for OSS and with > > ALSA > >my mic was dead as dodo). When further pressed, they told me that kernel > > relinking > >is for gurus only and to stay away from that nasty stuff. Eventually, I > > downloaded > >a standard kernel, linked it to fit my HW, installed OSS and it worked > > perfectly. > >SuSE kernel has completely unexpected dependencies and cannot be > > compiled > > easily > >without the help from SuSE. The latter is impossible to get. > > 5) Software is installed in curious places (xmms is installed under > > /usr/X11 > > so that > >you cannot use plugin rpms) and is always at least a version behind. > > Ximian GNOME > >doesn't work quite well and one needs an expert to do so, otherwise, > > only > > KDE is > >left. > > 6) SuSE has memory test as one of the booting options which was an > > extremely > > > >convenient thing when I was installing additional memory and my DIMM was > > bad. > > 7) The latest RH betas are done with gcc 3.1 which is an official gcc > > release. > >As soon as that hits production, I'm switching back to RH, especially > > now > > when > >RH and Oracle Corp. resolved their differences. > > > > Mladen Gogala > > Oracle DBA > > Phone: (203) 459-6855 > > Email: [EMAIL PROTECTED] > > > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, July 22, 2002 4:10 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Oracle on Linux . Red Hat vs. Suse > > > > > > > > > > > > > > > -- Christopher Royce <[EMAIL PROTECTED]> on 07/22/02 08:53:32 -0800 > > > > > > > Have been unable to arrive at a definitive position > > > > > > There isn't one. There are tradeoffs between the two distro's. > > > Most of it comes down to which one you are more comfortable > > > with or which one does more things (including the installation) > > > that you cannot fathom. > > > > > > -- > > > Steven Lembark 2930 W. Palmer > > > Workhorse Computing Chicago, IL 60647 > > >+1 800 762 1582 > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a l
Re: Rant - Oracle Security
Whenever I talk about database security, I put the emphasis on the much more common accidental damage. If the focus is on preventing external attack, everyone dozes off - few have had (known, at least) penetrations that got to the DB server. However, how many DBAs have NOT had a case of someone calling them and saying something like "Ooops! I dropped the ORDERS table in PROD. I thought I was in DEV." or "Can you restore the 20 records I accidentally deleted?" or ... ... or have never done something themselves like "lsnrctl stop" and discovered that they actually shut down the listener on a node other than the one intended? This kind of stuff probably happens a million times more often than things like SQL injection attacks. Sound security practices make both accidental and malicious damage much more difficult. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 11:13 PM I agree that the "glory" is in tuning, but I also think backup/recovery gets a sufficient amount of respect. It's nice now that advocating RMAN isn't considered snake-oil... Where I get funny looks these days is when I discuss database security. I try to defuse the tension by quoting the old saw about "just because you're paranoid doesn't mean they're not out to get you", but people still fidget and look away in pity as if I've lost my mind. I asked two audiences recently how many people utilize the SYSOPER role, and only one person in the second audience raised his hand. Similar effect if you ask about password management... ...I have to admit that some of the scarier folks are the ones who agree totally, though... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 8:28 PM > mkb, you're right, the "glory" is in tuning nowadays, but i beg to > differ, since if you can't/won't do recovery when the chips are down, > then the point is moot. > > I specialize in backup/recovery but getting damagement to think its > important today when the db is running fine, is tough. Its only when > its time to do recovery does damagement all of a sudden think its important. > > Joe > > > mkb wrote: > > >Ok, I need to vent a little. > > > >Last week, I was asked to do some tech interviews over > >the phones for a mid level DBA position. Someone with > >about 2-3 years experience. > > > >I don't consider myself a real smart DBA, nor do I > >think that I ask particularly tough questions. The > >questions that I ask potential candidates are soley > >based on what is on the resume. So I figure if > >someone has, say, hot backups or SQL tuning on their > >resumes, I'd expect them to be able to hold a fairly > >intelligent conversation about these topics. No such > >luck! > > > >What really frustrated me, and what I really want to > >get out of my system, is that nobody that I talked to, > >had a real good concept of hot backups. Forget about > >recovery. I asked each and every candidate who > >claimed to have done hot backups, just give me a high > >level overview of how you do a hot backup. Don't care > >about syntax, just give me the mechanics. The answers > >I got were completely off base, baffling and > >frustrating. Some of these folks claimed to have 5 > >years experience!!! > > > >'Well, we use scripts to do these, so I'm not sure how > >these are done...' (But it says on your resume you've > >done this???) > > > >'Oh, I take the tablespace offline, and copy the > >datafile to tape...' (Unless I'm mistaken, that's not > >how a hot backup is done, right?) > > > >'Well, I use the export utility, and as the backup > >starts, it is written to the dump file.' (Huh? What?) > > > >'During this time, everything is written to the redo > >logs and not to the tablespace...' (You've been > >reading one of those books, haven't you?) > > > >I also asked them how they'd put a tablespace in > >backup mode. Simple enough, right? Not one of them > >got it right. Not even close. Didn't have clue as to > >what I was talking about. Fair enough, you don't > >know. Well how about a simple recovery scenario. I > >asked every candidate how they would do an online > >recover of a datafile while the database was still in > >use. No ideas. Not even close. > > > >I dunno, perhaps I'm spoilt by being a member of this > >list? Perhaps I expect every candidate to be as > >knowledgeable as you guys? Perhaps I'm asking too > >much? > > > >Rant over. Thanks for listening. > > > >mkb > > > > > >__ > >Do You Yahoo!? > >Yahoo! Health - Feel better, live better > >http://health.yahoo.com > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet acce
Unix Q: ksh scripting
Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus /
RE: Index performance
What is the selectivity of the columns emp_st, emp_status and match?
If there are just 3-4 distinct values in the column, do not use b-tree index
on them. Just drop the Indexes on those columns and try again. If still slow
then try bitmap indexes on those low selectivity columns.
Sanjay
-Original Message-
Sent: 23 July, 2002 11:24 PM
To: Multiple recipients of list ORACLE-L
Hi
I am executing following query adn this query hits a number of indices on
this table.let me know what is wrong please.all in where clause are having
indexes.
select name,last_access, reg_date from empmaster where emp_id<100
and reg_date>to_date('2001-01-01','-MM-DD') and
emp_st='valid' and last_access>to_date ('2001-01-01','-MM-DD')
and emp_status='S' and match='FIRST'
Here all conditions in where clause are having indexes.
How to rewrite this query.
The primary key is emp_id.
Thanks
-Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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.com
--
Author: G Sanjay
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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).
View error msg
Hi, I created a view as a join of two tables, each of which has a primary key defined on it. When I am trying to insert values into the view I see the following error msg, ORA-01779: cannot modify a column which maps to a non key-preserved table What could the error be? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vandana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Recompiling blocked package - locating blocking session
Jay, Don't know for sure but you could try Ixora's script to show executing packages available at http://www.ixora.com.au/scripts/misc.htm You could also look for blocked "internal" locks - try the following: select * from dba_lock_internal where ( mode_held = 'Null' OR mode_held = 'None' ) AND ( mode_requested <> 'None' ) ; dba_lock_internal is created by catblock.sql but blocks that are in there do not show up in dba_blockers. >From catblock.sql for dba_lock_internal " * NOTE: This view can be very, very slow >depending on the size of your * shared pool area and database activity." We haven't found this an issue on (low concurrent load) database. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 24 July 2002 1:24 Had a problem this morning where a package was invalid and it would hang when we tried to recompile. We assumed that some other session was trying to recompile it but was hanging for some reason. I have plenty of ways to look at table locks but don't have a query to show locked packages. Frantic searching through the index of the SQL & PL/SQL Annotated Archives didn't help. I ended up searching the Active sessions that looked likely and killing them (and needing to do a kill -9 on the OS level as well) until I was able to recompile the package. Does anyone have a query that will save the random searching next time? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Converting Longs
Hello: Since everyone has forwarded a comment about their war stories I would like to offer up my Monday. The a programmer on a client I am working at asked me to convert all of the long data types since Oracle recommends that you do not use them. Since we use no longs I asked what he was referring to. He said please run a DESC on ALL_TRIGGERS, Then commented that I do not know my database. ALTER SYSTEM DROP STUPID_USER user does not seem to be working in this situation any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
type of join in sql
can some body shed some light on how does the optimizer decides to choose the kind of join i.e. nested loop, sort merge or hash join . In one of queries if i tweak the join condition it changes the type of join and start using index , otherwise it doesn't . I thought it depends on statistics .. if optimize finds that are more qualifying records in inner table then it will prefer to go for sort merge and will do full scan of inner table , but if it thinks there are less records in inner table it will user nested loop . am I correct ? TIA , bp
RE: IO wait
Top is a I/O good indicator, but too broad. You need to start with the SQL, both logical and physical (sequential and scattered reads). Always use histograms, this can do great things with minimal effort. With OLTP, there is parsing cost component you need to consider. With DW, this is a non-event compared with the savings you can gain from sensible CBO decisions. From the logic of the SQL, then you can assist the CBO by trying different partitioning schemes, range/hash combined, to enable pruning, or at least enable partition-wise joins. Then you can look at all the file-system/physical volume I/O topics that people have written papers about. Sun's site is good place to start. >>> [EMAIL PROTECTED] 07/24/02 07:44a.m. >>> Jack - Is your load process CPU-bound (high CPU utilization), or I/O-bound (high I/O statistics)? My guess is that from waits you want to confirm that I/O is your high wait statistic, to rule out any other problems that may be slowing down your load time. Then you may want to make a list of ideas that may speed your load and benchmark them (run the same load multiple times under the same circumstances) and see what change or combination of changes reduces the load time. Once you have a new approach that is yielding better load performance, you may want to check the wait times again to confirm that another problem isn't slowing your load. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 10:58 AM To: Multiple recipients of list ORACLE-L All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: how to force the DB to SKIP tx recovery ?
If data >>> [EMAIL PROTECTED] 07/23/02 10:23p.m. >>> Rahul, Instance recovery requires Rollforward and Rollbackwards. If the transaction is not committed it has to be rollbacked once the instance gets started. Let us assume that there are no committed transactions which were left in the buffer cache to be flushed back on to datafiles. This means I am left with Uncommitted txns to get them rollbackwards. This is done by SMON in the background or Server process which needs those blocks but the Instance and the db are opened and ready for use. The db is opened ie. what u wanted and that's the way Oracle does work. -Original Message- Sent: Tuesday, July 23, 2002 2:10 PM To: '[EMAIL PROTECTED]' Cc: 'Oracle List I' Vikas, even if the parameters were set for the checkpoint to happen often, all the transactions *not* commited would still be rolled back !! for example, when i shut down the PC in the middle of doing an update of 1/2 a million rows !!! (how would these parameters help?) > -- > From: Vikas Khanna[SMTP:[EMAIL PROTECTED]] > > No, Instance recovery has to take place internally, SMON has to recover > the > committed transactions which were left hanging in the cache to datafiles > so > that the files become synchronized. > > After that the db gets opened and roll backwards takes its own time. It > depends SMON does this job in the background and any other Server process > if > needs that block can rollback the uncommitted transaction and proceed with > the block. > > If you wish to recover the instance recovery very fast then set the > LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET > parameters to force the checkpoints quite often, this would open the > instance under crash quite fast as it has to perform less work. But more > the > checkpoints initiated more the performance degradations as B'ground > processes would be under tremendous work. > > Hope it clarifies. > Vikas Khanna > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: how to force the DB to SKIP tx recovery ?
Avoid deletes, updates, inserts - replace with create table/index nologging, insert+append where you can. Then the recovery/rollback problem dissappears. >>> [EMAIL PROTECTED] 07/23/02 09:28p.m. >>> No, Instance recovery has to take place internally, SMON has to recover the committed transactions which were left hanging in the cache to datafiles so that the files become synchronized. After that the db gets opened and roll backwards takes its own time. It depends SMON does this job in the background and any other Server process if needs that block can rollback the uncommitted transaction and proceed with the block. If you wish to recover the instance recovery very fast then set the LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET parameters to force the checkpoints quite often, this would open the instance under crash quite fast as it has to perform less work. But more the checkpoints initiated more the performance degradations as B'ground processes would be under tremendous work. Hope it clarifies. Vikas Khanna -Original Message- Sent: Tuesday, July 23, 2002 1:48 PM To: Multiple recipients of list ORACLE-L List, ...was doing a looog update, was taking forever, i rebooted the PC, as expected, the *open* of the instance is taking a very long time.. and i cannot wait... is there a way to open the DB *without* letting oracle perform the thread recovery ?? i just to open the DB data lose is acceptable.. TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident that the debris will not puncture my tires. If I'm in a big hurry and driving by the construction site is significantly quicker, then I will consider it. But, I don't go out of my way looking for trouble. Does anyone have a better argument than "I've been doing this for years and it has always worked?" Kevin KennedyFirst Point Energy Corporation -Original Message-From: Christopher Royce [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I would have to agree with Rich ... For years I have been using startup force restrict, shutdown normal prior to cold backups with the assumption that I want a completely 'static' and normal shutdown prior to the backup. Because of applications that maintain persistent connections, daemons that re-connect, etc. etc. that do not 'let loose' of the database . I have on numerous occasions had shutdown immediate 'hang'. I believe the operative process is the startup force restrict that enables auto-recovery and then the normal shutdown. I have never had an subsequent problems. Why chance any anomalous conditions that could be introduced to the recovery process or rebuild of a database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gesler, RichSent: Tuesday, July 23, 2002 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm You are assuming that shutdown immediate is a fix amount of time. If there is a lot to rollback it may take longer to rollback (via shutdown immediate) than the parallel crash recovery (the startup after a shutdown abort). It depends on the system. The question was why is immediate better than abort? I wanted to challenge the assumption that it is not safe to do an abort. You are relying on Oracle's recovery mechanisms which I have to assume are reliable. It is after all one of the reasons I prefer Oracle. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the c
Re: IO wait
Hi Jack, > questions: > > 1) is top a valid measure of IO wait? In my opinion sar is a better tool to look at IO waits. sar -d and sar -b will give you information on how the disk activity and I/O is. > 2) Is a high io wait an issue to be concerned about? Here is a nice note from Dave Miller with regards to Solaris though Just a note on iowait. On any multi-cpu machine, this number is not very useful, especially before Solaris 8. The algorithm for calculating it was changed in Solaris 8 but still is not really helpful. Prior to Solaris 8, iowait was defined as follows. When the scheduler attempted to schedule a process on a cpu, if there were no tasks that were runnable, but any task was marked as waiting for I/O, instead of counting as idle it counted as iowait. The problem on multi-cpu systems is that a single process waiting on I/O could count as iowait on ALL otherwise idle cpus. With Solaris 8 that was scaled down a bit (I don't have the exact details in front of me), but still is a bad gauge of I/O problems. I nearly always consider iowait to just be idle time and look for I/O problems elsewhere, like looking at iostat and looking at the %busy and service times on individual disks. That's much more indicative of a real problem and also will help you find out if you're hot-spotting on any disks. You also can monitor your networks using netstat because I believe iowait gets counted on processes waiting for network I/O, too. > 3) how else can it be accurately measured? sar I think gives a good idea > 4) How can I link IO wait to what is happening inside > the database? I think v$filestat will be the starting link. Hope this helps. Regards, Madhavan http://www.dpapps.com -- Madhavan Amruthur DecisionPoint Applications -- Please don't use http://fastmail.fm (I like feeling special.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate You forgot an option: pressing the power switch! Sorry the market is killing me! Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company
Rman duplicating failing when setting redo logs
One for the rman smarties I am duplicating a database with rman and it get to the section where it does an alter database open reset logs and it fails as there appears to be a path error. I then go into server manager and do the same and the path is '/u01/oracle/product/8.1.7/dbs/ /u07/oracle/oradata/mimstrn/log1a.log' If I do a backup control file to trace on this now created database the path for the logs is like above for all log files If I now edit that and use it to generate a new control file I am able to open the database with a resetlogs. Question is there something I have wrong with rman or am I doing something wrong with my setup Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate I would have to agree with Rich ... For years I have been using startup force restrict, shutdown normal prior to cold backups with the assumption that I want a completely 'static' and normal shutdown prior to the backup. Because of applications that maintain persistent connections, daemons that re-connect, etc. etc. that do not 'let loose' of the database . I have on numerous occasions had shutdown immediate 'hang'. I believe the operative process is the startup force restrict that enables auto-recovery and then the normal shutdown. I have never had an subsequent problems. Why chance any anomalous conditions that could be introduced to the recovery process or rebuild of a database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gesler, RichSent: Tuesday, July 23, 2002 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm You are assuming that shutdown immediate is a fix amount of time. If there is a lot to rollback it may take longer to rollback (via shutdown immediate) than the parallel crash recovery (the startup after a shutdown abort). It depends on the system. The question was why is immediate better than abort? I wanted to challenge the assumption that it is not safe to do an abort. You are relying on Oracle's recovery mechanisms which I have to assume are reliable. It is after all one of the reasons I prefer Oracle. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The
9i RMAN configuration setting
Hi, Does anyone know how I can specify in RMAN the size of the backup data files to be copied to each channel? For eg. if I have a 500MB database and would like to backup 100MB to channel 1 and 400MB to channel 2, how can I configure that? Thanks. elain RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 2; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\1\%U' MAXPIECESIZE 50 M; CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\2\%U' MAXPIECESIZE 50 M; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE\SNCFTEST.ORA'; # default _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re:ORA-00600: ???
Hi Ron, Thank you! Actually the "Dropping TS" only happened on 7/15. There are no other special actions since 7/15. And after 7/15, the error shows after "alter database open". Sorry didn't make it clear. --- Ron Rogers <[EMAIL PROTECTED]> wrote: > Leslie, > You say the message appears at 18:20 each day. > Check and see what jobs > have been added to the system since 7/15 that would > effect the database. > Perhaps an erronious, undocumented action has been > added that is > altering your system and dropping a critical > tablespace. > Why would you want to drop a tablespace the same > time every day? Are > you using partitioning and used the wrong command to > drop the partition? > Just a thought. > Ron > ROR mô¿ôm > > >>> [EMAIL PROTECTED] 07/23/02 04:21PM >>> > open an iTAR. > > Reply > Separator > Author: Leslie Lu <[EMAIL PROTECTED]> > Date: 7/23/2002 11:54 AM > > Hi all, > > I have a 817 db on NT. In the alter log, I have the > following error since 7/15. (The error repeats > about > 30 times.) > > Mon Jul 15 16:11:32 2002 > Errors in file > D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC: > ORA-00600: internal error code, arguments: [18062], > [], [], [], [], [], [], [] > > The actions before the error were ALTER SYSTEM SET > global_names=FALSE; and drop a tablespace. > > And after 7/15, the same message shows every day > around 18:20pm.(The error repeats about 30 times.) > > in the related trace file, I got: > > *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156 > *** 2002-07-15 16:15:01.156 > ksedmp: internal or fatal error > > What does this mean and what I should do? The > metalink doesn't help too much. > > Thank you. > > Leslie > > > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Leslie Lu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: 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.com > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: How to notify the password expiration in oracle using email?
Oh, I forgot to mention (although it should be obvious) that the table employee contains ids linked to dba_users.username as well as a column for email. -Original Message- Sent: Tuesday, July 23, 2002 5:43 PM To: Multiple recipients of list ORACLE-L email? This is what I use to send an email 3 days before and 1 day before (obviously this is on a Unix box): passwd_exp.sh: cd /oracle/oper sqlplus < pw_send_mail.sh chmod ug+x pw_send_mail.sh pw_send_mail.sh passwd_exp.sql: select 'mail '||email||' 'LOCKED'; spool off; pw_exp_message_1.txt: Your Oracle password will expire in 1 day. -Original Message- Sent: Tuesday, July 23, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have a standard code or process for sending email from oracle to address the following issue. Thanks, Ashoke -Original Message- Sent: Monday, July 22, 2002 3:37 PM To: Multiple recipients of list ORACLE-L Not sure it would be the best but... logically I would: 1. get sysdate 2. get expiration date 3. if expiration date - sysdate <= 7 (let's say you wanted to warn them 7 days in advance) send them e-mail. I have not done e-mail from Oracle but there are plenty examples everywhere. Or, I think you could create a screen in your app. and display that screen for them any time they get close to expiration date. You can even let them change their password through that screen, too. -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Greetings, As I understand that from Oracle 8 onward we have the feature of password management like account locking, password aging and expiration, password history and password complexity requirements. My understanding is that if the password is expired for an user then that user will be notified during his first attempt to login to the oracle database. Instead of waiting for the user to login and then know about his password expiration, we are trying to find out a way by which the oracle can automatically send an email to the respective user as it is close to the password expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
RE: Had to get this off my chest
Thanks to everyone. After laughing my way through these I feel a lot better about the assignment :) I guess the 96 degree weather was eroding my sense of humor. Jay -Original Message- Sent: Tuesday, July 23, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Use some stickers and some gold colored macaroni as well Kathy -Original Message- Sent: Tuesday, July 23, 2002 1:39 PM To: Multiple recipients of list ORACLE-L _ _ | | | | | | | | | | | | | OLD Location |-| NEW Location | | | | | | | | | |_| |_| Use above template. (WORD ClipArt even better). still like the crayon idea Once we were told that management wanted everything including a dancing peanut for a product demo (ie, they wanted everything)! AHEAD of deadline etc etc and NOW (ie yesterday). We did it. even found an animated DANCING PEANUT.. the VP almost choked on his drink when it popped up on screen:> Point was well taken. Least he had a sense of humor. Sorry, lame I know.. but long day needed a wind down:> Hannah > > We need to move our standby database to a new location. > I put together a plan for this. > My boss said that I needed to draw pictures in Visio showing the old > location and new location since his boss won't approve a plan that doesn't > have pictures. > I'm ready to move to a new company please. > > Jay Miller > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate I have had this happen on a test system where nobody else and no apps where making any transactions. My cold backups 'shutdown immediate' cammand hang for the whole weekend. I did a shutdown abort on Monday morning. I find it just about impossible to believe that any rollbacks where happening. And like in April's posts, Oracle corp seems to think that doing a shutdown abort is the fix. That is a flaw to me. Dave -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 3:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm You are assuming that shutdown immediate is a fix amount of time. If there is a lot to rollback it may take longer to rollback (via shutdown immediate) than the parallel crash recovery (the startup after a shutdown abort). It depends on the system. The question was why is immediate better than abort? I wanted to challenge the assumption that it is not safe to do an abort. You are relying on Oracle's recovery mechanisms which I have to assume are reliable. It is after all one of the reasons I prefer Oracle. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediat
RE: Had to get this off my chest
>-Talk like you are talking to a five-year old See Dick import/export See Jane use SQL Loader See Spot code in java Code Spot code You can make the illistrations. Dave -Original Message- Sent: Tuesday, July 23, 2002 3:12 PM To: Multiple recipients of list ORACLE-L What are you upset about? He/his boss don't understand what you are talking about until he/they see pictures. Talk like you are talking to a five-year old... :) -Original Message- Sent: Tuesday, July 23, 2002 2:45 PM To: Multiple recipients of list ORACLE-L We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: RE: Rant...DOCUMENTATION
List, If you have problems with the CD's then the Doc's are available for download at http://download-west.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm Just like "Alice's Restaurant". Ron ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: How to notify the password expiration in oracle using email?
This is what I use to send an email 3 days before and 1 day before (obviously this is on a Unix box): passwd_exp.sh: cd /oracle/oper sqlplus < pw_send_mail.sh chmod ug+x pw_send_mail.sh pw_send_mail.sh passwd_exp.sql: select 'mail '||email||' 'LOCKED'; spool off; pw_exp_message_1.txt: Your Oracle password will expire in 1 day. -Original Message- Sent: Tuesday, July 23, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have a standard code or process for sending email from oracle to address the following issue. Thanks, Ashoke -Original Message- Sent: Monday, July 22, 2002 3:37 PM To: Multiple recipients of list ORACLE-L Not sure it would be the best but... logically I would: 1. get sysdate 2. get expiration date 3. if expiration date - sysdate <= 7 (let's say you wanted to warn them 7 days in advance) send them e-mail. I have not done e-mail from Oracle but there are plenty examples everywhere. Or, I think you could create a screen in your app. and display that screen for them any time they get close to expiration date. You can even let them change their password through that screen, too. -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Greetings, As I understand that from Oracle 8 onward we have the feature of password management like account locking, password aging and expiration, password history and password complexity requirements. My understanding is that if the password is expired for an user then that user will be notified during his first attempt to login to the oracle database. Instead of waiting for the user to login and then know about his password expiration, we are trying to find out a way by which the oracle can automatically send an email to the respective user as it is close to the password expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: shutdown abort / startup restrict / shutdown vs. shutdown imm
> April Wells wrote: > > Yes, I WHOLE heartedly agree, and we do a shutdown immediate now, but the > point is... Oracle SUPPORT seems to be of the opinion that rather than trying > to figure out what is 'wrong' we should just do a shutdown abort it 'Is a > valid solution'. I'm guessing there IS a REASON it is doing this... and that > it is only doing it in one of my three financials instances CONSISTENTLY... > and NOT the one that was the source of the recent clone. > > ajw > April -- Yes, this is a valid "work-around". And, No, in _my_ opinion, this should not consider the problem "solved". There is (obviously) a bug somewhere that is causing the instance to "hang" when you do a "shutdown immediate". That bug should be addressed and/or corrected. I seem to remember a time when some of the "conventional wisdom" stated that you should ONLY do shutdown abort and NEVER do shutdown immediate. However, when I started digging into the "whys" of this statement, what I was able to come up with was a bug in a particular release of the Oracle RDBMS on HP/UX (I think it was 7.1.3, but I'm not sure). Interestingly enough, the DBA's I was speaking to that *SWORE* you should never do shutdown immediate were all on HP/UX. So, from my standpoint, (and the stated purpose of each of the shutdown commands), SHUTDOWN IMMEDIATE is the correct shutdown. Abort/Startup/Shutdown Normal *will* work in your situation as a valid work-around. However, the bug should still be investigated and corrected. Have you investigated pro-actively upgrading the RDBMS to a (slightly) more current version? (I'm not suggesting 9i here, but as I recall you're 8.1.7.3. I believe that an 8.1.7.4 exists, just maybe not on AIX). -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA "The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Windohs client problems
OK, my hair is thinning fast enough without this. On WinTuke SP2, I've got a 9.0.1 full install of EE. I also have an install of the 8.1.7 client in a second ORACLE_HOME. I've been using this setup fine and well until I installed Oracle Warehouse Builder into a separate ORACLE_HOME, then de-installed it after finding out it needs 9iAS. Then Quest products started flaking out, so Quest had me fiddle with the "LAST_HOME" registry entry. After that, the Microslop ODBC for Oracle driver fails to find the Oracle driver, stating: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr) And now, after uninstalling the 8.1.7 client, cleaning the registry, reinstalling and rebooting, I can only connect *HALF OF THE TIME* using 9i. The other half I get a TNS-12154, net name not found error. I'm using ONames for names resolution, but I don't understand what the hell is going on here. And seeing that it'll take me days to uninstall, reinstall, and reconfig I'd just as soon not do it. Anyone else have to deal with this hoo-ha that has a solution? I'd rather be at home diazinoning earwigs... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: Loading tables from XML files
Yes, it is called XML-SQL(XSU) Utility. I ran a test this morning and it worked. It is much simpler. I did not have to write anycode. I needed to specify a different connect string to get it working. I loaded JDeveloper 3.2.3 to do it. I believe, I could have done it by downloading jdk 1.2 and using libraries that came with Oracle. My notes are shown below. You can see the document in 'Oracle Application Developer's Guide -XML Release 3(8.1.7). Regards, Shakir XML file load into oracle 8000 Smith CLERK 7902 12/17/2002 0:0:0 800 20 Install JDeveloper for java.exe or download jdk1.2 from web Add to classpath.bat. Files shown here are from JDeveloper First three files are needed for XML load. The last three added to run java set CLASSPATH=c:\Program Files\Oracle\Jdeveloper 3.2.3\lib\xsu12.jar; c:\Program Files\Oracle\JDeveloper 3.2.3\lib\xmlparserv2.jar; C:\Program Files\Oracle\JDeveloper 3.2.3\jdbc\lib\oracle8.1.7\classes12.zip; c:\Program Files\Oracle\JDeveloper 3.2.3\java1.2\dt.jar; C:\Program Files\Oracle\JDeveloper 3.2.3\java1.2\lib\jvm.lib; C:\Program Files\Oracle\JDeveloper 3.2.3\java1.2\lib\jvm_g.lib; C:\Program Files\Oracle\JDeveloper 3.2.3\java1.2\lib\tools.jar run Classpath.bat Following command worked on amd1400 oracle 8.1.7 personal with patch 8.1.7.3 java OracleXML putXML -user 'scott/tiger" -conn "jdbc:oracle:thin:@amd1400:1521:amd1400" -user "scott/tiger" -filename "c:\emp.xml" emp java OracleXML putXML -user 'scott/tiger" -conn "jdbc:oracle:thin:scott/tiger@amd1400:1521:amd1400" -user "scott/tiger" -filename "c:\emp.xml" emp emp - table name -conn Url --- "Schauss, Peter" <[EMAIL PROTECTED]> wrote: > Is there a utility similar to SQLLDR which will load tables > from XML files? > > I found the Java and PL/SQL APIs for loading tables from > XML files and wrote a trivial Java application to load data so > my immediate problem is solved. I just wanted to make sure > that I hadn't missed a simpler way to do it. > > thanks, > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2
Hello Listers, We are about to call veritas for a netbackup businessserver solution for our databases on hp k570 10.2 boxes A Veritas Vendor is proposing Netbackup BusinessServer 4.5 on hp 10.2 Any of ull implemented ver Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2 ? Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Had to get this off my chest
Ron, Great idea. Don't forget to include pictures of the movers and their truck. An interactive map showing the route to be taken (showing all coffee shops along the way) would also be helpful. And pictures of happy users continuing their tasks when the primary database has failed over. -Original Message- Sent: Tuesday, July 23, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Jay, Come on it can't be all that bad... drawing boxes and adding labels can be fun. Why you could even use a digital camera and take pictures of the old location and then add pictures of the new location to show your boss what it would/could look like. Be creative and you might set a standard. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 07/23/02 03:44PM >>> We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Had to get this off my chest
Use some stickers and some gold colored macaroni as well Kathy -Original Message- Sent: Tuesday, July 23, 2002 1:39 PM To: Multiple recipients of list ORACLE-L _ _ | | | | | | | | | | | | | OLD Location |-| NEW Location | | | | | | | | | |_| |_| Use above template. (WORD ClipArt even better). still like the crayon idea Once we were told that management wanted everything including a dancing peanut for a product demo (ie, they wanted everything)! AHEAD of deadline etc etc and NOW (ie yesterday). We did it. even found an animated DANCING PEANUT.. the VP almost choked on his drink when it popped up on screen:> Point was well taken. Least he had a sense of humor. Sorry, lame I know.. but long day needed a wind down:> Hannah > > We need to move our standby database to a new location. > I put together a plan for this. > My boss said that I needed to draw pictures in Visio showing the old > location and new location since his boss won't approve a plan that doesn't > have pictures. > I'm ready to move to a new company please. > > Jay Miller > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
STS
Where can I get pricing and information on STS? Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: RE: Rant
Don't forget the neat stuff you find by accident while thumbing through the books trying to find something else. Henry - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 1:03 AM CDs have some advantages - expense, searchability, and storage space primarily, but... 1) CDs are more difficult to read in bed, on a plane, waiting in the terminal, etc. 2) Books are easier to read, require less equipment, and are more portable than a computer and a CD 3) Try having six different CD manuals open to related sections spread out in front of you - reading them while you work against the database. 4) An open book shows two full pages of information. An open PDF about half a page. 5) I could usually grab a manual and flip through it to the relevant info about 10x faster than a computer search - and with a lot less extraneous (click/point/scroll/type) activity. 6) Highlighters, margin notes, and sticky-note bookmarks don't work at all with CDs I miss hardcopy manuals! Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 3:18 PM RE: RE: RantNot me. I LOVE the cds. I copy them onto my hard drive and use the pdf versions. they are SEARCHABLE. I can find things much more quickly in the pdf's than paper. Oracle is the only product that I feel this way about .. probably because they have more documentation than the library of congress! -Original Message- <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Myers-Briggs
The "C" is for Sales-"C"ritter. The "High" part? Well, remember, the rule is: puff, puff, pass. Don't bogart the good stuff, 'kay? ;-) Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 23, 2002 11:28 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Myers-Briggs > > We used to use these at my last company, and I turned out to be a "High > C".. > Which actually meant that I was a classic sales person profile.. Funny.. I > always thought of myself as more of a techie in a sales persons role.. ;) > > -Original Message- > Carmichael > Sent: 23 July 2002 16:18 > To: Multiple recipients of list ORACLE-L > > > do a search for Meyers-Briggs and there are sites > > A lot of companies use this as a way of finding out what "type" a > person is so you can learn how to deal with the people you work with. > It's supposed to help with management styles etc > > > --- Rodd Holman <[EMAIL PROTECTED]> wrote: > > Where do you take this profile to find out what you are? I'm curious > > now. Is there someplace on-line that will let you do this? > > > > Rodd Holman > > On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: > > > > That's very funny. INFP DBA... Wow! You do what you want with > > verve and to > > Hell the consequences whenever you blow up. Being a P, you are > > pragmatic > > about your outbursts... ? > > > > I am an INTJ most of the time. > > > > I - I am stubborn > > N - I follow my own inner sense of direction > > T - I mull things over before I act > > J - I have an opinion about everything. > > > > E-Mail: [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Monday, July 22, 2002 5:49 PM > > To: Multiple recipientsBoth my parents are psychologists, go > > figure. > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > Systems Admin & Operations | Admin. et Exploit. des systhmes > > Technology Services| Services technologiques > > Informatics Branch | Direction de l'informatique > > Maritimes Region, DFO | Rigion des Maritimes, MPO > > > > of list ORACLE-L > > Subject:RE: Rant-Rant > > > > FYI: SJs make up about 40% of the population (app. 10% for each > > sub-division). > > > > Jay Miller > > infp (yeah, I know, what's an infp doing in a technical job... :) > > > > -Original Message- > > Sent: Monday, July 22, 2002 1:23 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > That is why I use the > > machinist analogy: somebody who is satisfied with a career > > spending 25 > > years doing essentially the same thing. If you are into > > Myers-Briggs type > > indicator, I think the personality dimension is SJ and roughly > > 25% of the > > population fits this profile. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Miller, Jay > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > > 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > (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.com > > -- > > Author: Boivin, Patrice J > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > > 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > in > > the message BODY, include a line containing: 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). > > > > -- > > Rodd Holman > > Enterprise Data Systems Engineer > > LodgeNet Entertainment Corporation > > [EMAIL PROTECTED] > > (605) 988-1373 > > > > > > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of
Re: Index performance
The SQL appears to be fine. If it uses "too many indexes" then perhaps all the indexes are on a single column. Perhaps you need to create a concatenated index. At any rate, if it runs too slowly, post the SQL again with an explain plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re:ORA-00600: ???
Leslie, You say the message appears at 18:20 each day. Check and see what jobs have been added to the system since 7/15 that would effect the database. Perhaps an erronious, undocumented action has been added that is altering your system and dropping a critical tablespace. Why would you want to drop a tablespace the same time every day? Are you using partitioning and used the wrong command to drop the partition? Just a thought. Ron ROR mô¿ôm >>> [EMAIL PROTECTED] 07/23/02 04:21PM >>> open an iTAR. Reply Separator Author: Leslie Lu <[EMAIL PROTECTED]> Date: 7/23/2002 11:54 AM Hi all, I have a 817 db on NT. In the alter log, I have the following error since 7/15. (The error repeats about 30 times.) Mon Jul 15 16:11:32 2002 Errors in file D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC: ORA-00600: internal error code, arguments: [18062], [], [], [], [], [], [], [] The actions before the error were ALTER SYSTEM SET global_names=FALSE; and drop a tablespace. And after 7/15, the same message shows every day around 18:20pm.(The error repeats about 30 times.) in the related trace file, I got: *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156 *** 2002-07-15 16:15:01.156 ksedmp: internal or fatal error What does this mean and what I should do? The metalink doesn't help too much. Thank you. Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: ORA-00600: ???
It means you should patch to 8.1.7.4. On Tue, Jul 23, 2002 at 11:54:14AM -0800, Leslie Lu wrote: > Hi all, > > I have a 817 db on NT. In the alter log, I have the > following error since 7/15. (The error repeats about > 30 times.) > > Mon Jul 15 16:11:32 2002 > Errors in file > D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC: > ORA-00600: internal error code, arguments: [18062], > [], [], [], [], [], [], [] > > The actions before the error were ALTER SYSTEM SET > global_names=FALSE; and drop a tablespace. > > And after 7/15, the same message shows every day > around 18:20pm.(The error repeats about 30 times.) > > in the related trace file, I got: > > *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156 > *** 2002-07-15 16:15:01.156 > ksedmp: internal or fatal error > > What does this mean and what I should do? The > metalink doesn't help too much. > > Thank you. > > Leslie > > > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Leslie Lu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: Had to get this off my chest - yet another off topic thread.
Please people! I get enough mail as it is without dealing with all the junk that's coming through here!! [EMAIL PROTECTED] wrote: >Use comic sans font and hightlight with crayons.. then give him the real one > > > >> -Original Message- >>From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Miller, Jay" ><[EMAIL PROTECTED]> >>Sent: Tuesday, July 23, 2002 3:45 PM >>To: Multiple recipients of list ORACLE-L >>Subject: Had to get this off my chest >> >>We need to move our standby database to a new location. >>I put together a plan for this. >>My boss said that I needed to draw pictures in Visio showing the old >>location and new location since his boss won't approve a plan that doesn't >>have pictures. >>I'm ready to move to a new company please. >> >>Jay Miller >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Miller, Jay >>INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: 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). >> >> -- Jesse W. Asher [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse W. Asher INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Had to get this off my chest
_ _ | | | | | | | | | | | | | OLD Location |-| NEW Location | | | | | | | | | |_| |_| Use above template. (WORD ClipArt even better). still like the crayon idea Once we were told that management wanted everything including a dancing peanut for a product demo (ie, they wanted everything)! AHEAD of deadline etc etc and NOW (ie yesterday). We did it. even found an animated DANCING PEANUT.. the VP almost choked on his drink when it popped up on screen:> Point was well taken. Least he had a sense of humor. Sorry, lame I know.. but long day needed a wind down:> Hannah > > We need to move our standby database to a new location. > I put together a plan for this. > My boss said that I needed to draw pictures in Visio showing the old > location and new location since his boss won't approve a plan that doesn't > have pictures. > I'm ready to move to a new company please. > > Jay Miller > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: Had to get this off my chest
If you have an HP roll plotter you can make it 3 ft. wide and 20 ft. long. Make all the boxes real big with 50 point text. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 3:11 PM Use comic sans font and hightlight with crayons.. then give him the real one > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Miller, Jay" <[EMAIL PROTECTED]> > Sent: Tuesday, July 23, 2002 3:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Had to get this off my chest > > We need to move our standby database to a new location. > I put together a plan for this. > My boss said that I needed to draw pictures in Visio showing the old > location and new location since his boss won't approve a plan that doesn't > have pictures. > I'm ready to move to a new company please. > > Jay Miller > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: Had to get this off my chest
Jay, Come on it can't be all that bad... drawing boxes and adding labels can be fun. Why you could even use a digital camera and take pictures of the old location and then add pictures of the new location to show your boss what it would/could look like. Be creative and you might set a standard. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 07/23/02 03:44PM >>> We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re:ORA-00600: ???
open an iTAR. Reply Separator Author: Leslie Lu <[EMAIL PROTECTED]> Date: 7/23/2002 11:54 AM Hi all, I have a 817 db on NT. In the alter log, I have the following error since 7/15. (The error repeats about 30 times.) Mon Jul 15 16:11:32 2002 Errors in file D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC: ORA-00600: internal error code, arguments: [18062], [], [], [], [], [], [], [] The actions before the error were ALTER SYSTEM SET global_names=FALSE; and drop a tablespace. And after 7/15, the same message shows every day around 18:20pm.(The error repeats about 30 times.) in the related trace file, I got: *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156 *** 2002-07-15 16:15:01.156 ksedmp: internal or fatal error What does this mean and what I should do? The metalink doesn't help too much. Thank you. Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate You are assuming that shutdown immediate is a fix amount of time. If there is a lot to rollback it may take longer to rollback (via shutdown immediate) than the parallel crash recovery (the startup after a shutdown abort). It depends on the system. The question was why is immediate better than abort? I wanted to challenge the assumption that it is not safe to do an abort. You are relying on Oracle's recovery mechanisms which I have to assume are reliable. It is after all one of the reasons I prefer Oracle. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: Had to get this off my chest
Title: RE: Had to get this off my chest Jay, Just have fun with it. Make the old location look like the Arctic and the new a sunny beach somewhere. Better yet print it up like a comic book with you as the superhero DBA-Man. Then move to a new company. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Miller, Jay [SMTP:[EMAIL PROTECTED]] We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller
RE: Had to get this off my chest
Use comic sans font and hightlight with crayons.. then give him the real one > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Miller, Jay" ><[EMAIL PROTECTED]> > Sent: Tuesday, July 23, 2002 3:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Had to get this off my chest > > We need to move our standby database to a new location. > I put together a plan for this. > My boss said that I needed to draw pictures in Visio showing the old > location and new location since his boss won't approve a plan that doesn't > have pictures. > I'm ready to move to a new company please. > > Jay Miller > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: RE: Rant
I like the idea of the new search, but I don't like the requirement of Internet access to be able to use it. The useless 2nd doc CD should include an exported TS and the init.ora and scripts to recreate the OracleText DB that Oracle probably uses to do the search. I suppose that it would have to include the 9iAS setup, too, although I'm not as keen on that one. Then again, that's assuming it would even fit on a CD or two... :) You *can* "write" your own notes, but it takes a lot of work (editing of HTML and/or PDFs) and the search results won't point to your edited docs. Unless you dump the contents of the CD to a webserver like OSU for VMS (I haven't had time to setup Apache yet, but CGIs in DCL *rock*!), and do your own custom highlights, editing, and searches... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 23, 2002 1:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Rant > > > I like the hyperlinks on the CD docs. > > I like the improved master index and the search facility > > I HATE not being able to write my own notes on the page or reading the > docs on the train -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Kevin, Shutdown immediate must be a preferred option but under some senarios like distributed databases involving diffrent machines has no option but to use shutdown abort , startup restrict and shutdown immediate otherwise you will not be able to shutdown all of your databases in a defined time frame..Before using shutdown abort it is suggested to use alter system checkpoint I am using it for couple of years through scripts and never seen any problem. It applies to ver 7.3.4.5 to 9i Production databases on HPUX 11.0 involving size from 40 to 80GB databases. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 23 Jul 2002 11:33:57 -0800 Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 23, 2002 11:14 AM To: Multiple recipients of list ORACLE-L imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message- Sent: Tuesday, July 23, 2002 1:14 PM To: Multiple recipients of list ORACLE-L immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Monday, July 22, 2002 7:53 PM To: Multiple recipients of list ORACLE-L immedia > -Original Message- > From: April Wells [ mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict) _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Had to get this off my chest
What are you upset about? He/his boss don't understand what you are talking about until he/they see pictures. Talk like you are talking to a five-year old... :) -Original Message- Sent: Tuesday, July 23, 2002 2:45 PM To: Multiple recipients of list ORACLE-L We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: How can I check the time when any table is updated under a sc
Ops, I misread the statement:
during the execution of HIS application.
WOW... I would not let that developer to mess with dba tables...
-Original Message-
Sent: Tuesday, July 23, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
It is common situation. He/she is probably a GUI developer. Most front end
developers are not too familiar with dba tables.
Mandal, you can do run this query next time you have a similar queston:
1 select column_name, comments
2 from dba_col_comments
3 where table_name='DBA_OBJECTS'
4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED')
SQL> /
COLUMN_NAME COMMENTS
---
---
CREATED Timestamp for the creation of the object
LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and
REVOKE) to the object
TIMESTAMP Timestamp for the specification of the object
Look for more help on TIMESTAMP column, if it is not what you are looking
for and there are only a few tables you need information about, may be
creating trigger would help.
SQL> -Original Message-
Sent: Tuesday, July 23, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
I am surprised that the developer doesn't know the code s/he
wrote/maintains.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
--- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> One of my developer wants to know what are the tables or any other
> objects being modified during the execution of his application.
>
> dba_objects have following 3 date fields. But I am not sure if any of
> these date fields will capture the last DML(update, insert or delete)
> time.
>
> CREATED
> LAST_DDL_TIME
> TIMESTAMP
>
> Any idea?
>
> Thanks in advance,
> Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyuda Hoska
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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.com
--
Author: Lyuda Hoska
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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).
RE: Had to get this off my chest
Jay Nah. He's just a Visual Learner. If you are like most programmers, you are a Tactile Learner. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 2:45 PM To: Multiple recipients of list ORACLE-L We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Rant-Rant
Really? I had you pegged as an E given how well you organize all the NYOUG events/people. The J part was obvious :) Jay -Original Message- Sent: Monday, July 22, 2002 10:18 PM To: Multiple recipients of list ORACLE-L hey, I'm an infj -- according to the out placement company, I'd make a good nun (Robert, did you see my test results?) --- "Miller, Jay" <[EMAIL PROTECTED]> wrote: > FYI: SJs make up about 40% of the population (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a technical job... :) > > -Original Message- > Sent: Monday, July 22, 2002 1:23 PM > To: Multiple recipients of list ORACLE-L > > > > That is why I use the > machinist analogy: somebody who is satisfied with a career spending > 25 > years doing essentially the same thing. If you are into Myers-Briggs > type > indicator, I think the personality dimension is SJ and roughly 25% of > the > population fits this profile. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
ORA-00600: ???
Hi all, I have a 817 db on NT. In the alter log, I have the following error since 7/15. (The error repeats about 30 times.) Mon Jul 15 16:11:32 2002 Errors in file D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC: ORA-00600: internal error code, arguments: [18062], [], [], [], [], [], [], [] The actions before the error were ALTER SYSTEM SET global_names=FALSE; and drop a tablespace. And after 7/15, the same message shows every day around 18:20pm.(The error repeats about 30 times.) in the related trace file, I got: *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156 *** 2002-07-15 16:15:01.156 ksedmp: internal or fatal error What does this mean and what I should do? The metalink doesn't help too much. Thank you. Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: new OEM / Re:RE: Rant
Title: RE: new OEM / Re:RE: Rant I'm good at cron and scripting too, however OEM is convenient at times, for instance, when dealing with advanced replication setup. Alan Martin Defense Logistics Information Service Battle Creek, MI -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: new OEM / Re:RE: Rant Eric, I learned OEM and decided it just wasn't worth it. I saw nothing of added value there. I can and do everything that OEM does via either Cron or any other scheduling tool. The product makes no sense to me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 23, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Hold on does that mean that since I never learned it, I should just wait for the new one? :) Will it support 8.1.7 in client-server mode? :):) (Or "just" Oracle9i?) regards, ep On 22 Jul 2002 at 10:13, [EMAIL PROTECTED] wrote: > YUP, Saw the new version at an Oracle event in Boston a couple of months ago. > Seems that nothing is sacred anymore. BTW: Installer changes too, now you need > a full multimedia terminal, 4 channel audio & VR headset recommended. :o) > > Dick Goulet > > Reply Separator > Author: Rachel Carmichael <[EMAIL PROTECTED]> > Date: 7/22/2002 9:53 AM > > you can see how often I use the GUI :) > > OBTW.. for those of you who are OEM fans... I heard a rumor (from a > fairly well-informed, usually accurate source) that Oracle's changing > it all again. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: IO wait
Jack - Is your load process CPU-bound (high CPU utilization), or I/O-bound (high I/O statistics)? My guess is that from waits you want to confirm that I/O is your high wait statistic, to rule out any other problems that may be slowing down your load time. Then you may want to make a list of ideas that may speed your load and benchmark them (run the same load multiple times under the same circumstances) and see what change or combination of changes reduces the load time. Once you have a new approach that is yielding better load performance, you may want to check the wait times again to confirm that another problem isn't slowing your load. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 10:58 AM To: Multiple recipients of list ORACLE-L All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: RE: Rant
Depends what version of Adobe you have. I believe I had version five at my last job and you could add notes and bookmarks.. Just most of us are using Adobe reader, Free but not containing the editing abilities! > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Rachel Carmichael ><[EMAIL PROTECTED]> > Sent: Tuesday, July 23, 2002 2:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Rant > > I like the hyperlinks on the CD docs. > > I like the improved master index and the search facility > > I HATE not being able to write my own notes on the page or reading the > docs on the train > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Had to get this off my chest
We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Yes, I WHOLE heartedly agree, and we do a shutdown immediate now, but the point is... Oracle SUPPORT seems to be of the opinion that rather than trying to figure out what is 'wrong' we should just do a shutdown abort it 'Is a valid solution'. I'm guessing there IS a REASON it is doing this... and that it is only doing it in one of my three financials instances CONSISTENTLY... and NOT the one that was the source of the recent clone. ajw -Original Message-From: Ishrat Jehan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm The differences are 1. shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted. 2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactions terminated are rollbacked, recovery would not happen at restart 3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever. So shutdown immediate is much quicker and safer. ...Ishrat -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict) The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment.
RE: How can I check the time when any table is updated under a sc
It is common situation. He/she is probably a GUI developer. Most front end
developers are not too familiar with dba tables.
Mandal, you can do run this query next time you have a similar queston:
1 select column_name, comments
2 from dba_col_comments
3 where table_name='DBA_OBJECTS'
4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED')
SQL> /
COLUMN_NAME COMMENTS
---
---
CREATED Timestamp for the creation of the object
LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and
REVOKE) to the object
TIMESTAMP Timestamp for the specification of the object
Look for more help on TIMESTAMP column, if it is not what you are looking
for and there are only a few tables you need information about, may be
creating trigger would help.
SQL> -Original Message-
Sent: Tuesday, July 23, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
I am surprised that the developer doesn't know the code s/he
wrote/maintains.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
--- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> One of my developer wants to know what are the tables or any other
> objects being modified during the execution of his application.
>
> dba_objects have following 3 date fields. But I am not sure if any of
> these date fields will capture the last DML(update, insert or delete)
> time.
>
> CREATED
> LAST_DDL_TIME
> TIMESTAMP
>
> Any idea?
>
> Thanks in advance,
> Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyuda Hoska
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Well. I'll agree with you only on the basis that shutdown immediate sometimes hangs and in those cases it is quicker to do the abort/start/shut normal combination. However, based on a quick review of my logs from last night (cold backup), I see the shutdown immediate took about 12 seconds. The following startup (which needed no recovery) took about a minute. Had I used the shut abort technique, I expect I would have seen, let's say 5 seconds for the shut abort, 60 seconds or so for the startup restricted, then about 12 seconds for the shutdown normal. Hmmm. Doesn't seem so cut and dried to me. I think I'll keep using my shutdown script that tries shutdown immediate and only does the abort, etc. if immediate takes too long. At this site, the shutdown immediate only seems to fail about once a month. I can live with that unless someone comes up with a more compelling reason why the shutdown abort is better than a shutdown immediate. So far, all I've seen is the argument that shutdown abort is not evil -- I'm not one who thinks it is evil, I'm just not convinced that it is somehow better. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Gesler, Rich [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
Re: How can I check the time when any table is updated under a
Ashoke, Any programer worth their salt should know what tables or objects are modified by their applications. They documented and wrote it and should know what happens when an "update, delete, insert, etc" happens to the data. If they do not know what happens, How did they write the application?. If it is an inherited application and the documentation is not available, that is a different story. Then you will have to use auditing or the "trigger to table" method. I know that I sound harsh in my statements but in the old school that's how we had to work, documentation, test, documentation I have found in today's programming world that to many times it is easier to cut and paste code to get the project running and not even do the documentation. PS( I retired from an ISO9001/2 company) ROR mª¿ªm >>> [EMAIL PROTECTED] 07/23/02 02:33PM >>> none of them will capture DML changes you have two choices: 1) turn on auditing... this will tell you at a macro level what has been touched, but won't necessarily tell you who did it or if it was done by the execution of his app 2) add an update_dt and an updated_by column to all tables and create a trigger which fires on insert/update/delete to fill the column of the row with sysdate and the userid of the user. This is very detailed, down to the row level but may also not give you whether or not the change was made during the execution of his application --- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote: > Hi, > > One of my developer wants to know what are the tables or any other > objects being modified during the execution of his application. > > dba_objects have following 3 date fields. But I am not sure if any of > these date fields will capture the last DML(update, insert or delete) > time. > > CREATED > LAST_DDL_TIME > TIMESTAMP > > Any idea? > > Thanks in advance, > Ashoke > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Myers-Briggs - Too many off topic topics!
Maybe during these stressful times of financial market chaos and job uncertainty, some people just need to clear the air and get stuf off their chest. The rest of us are just goofs. ;o) -Original Message-From: Jesse W. Asher [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Myers-Briggs - Too many off topic topics!There have been a lot of off topic topics lately. I finally had to add the "Rant" thread to my filters so I wouldn't get any more of it. Can we please stick to things Oracle??Boivin, Patrice J wrote: I think this is funny, corporations relying on the Myers-Briggs which is based on Jung's depth psychology - archetypes, synchronicity, collective consciousness, alchemy and magic... I don't believe most HR realize this. Bureaucracies are supposed to be "rational" and here they rely on knowledge that comes from studying the subconscious and alchemy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Myers-Briggs do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what "type" a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman <[EMAIL PROTECTED]> wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L That is why I use the machinist analogy: somebody who is satisfied with a career spending 25 years doing essentially the same thing. If you are into Myers-Briggs type indicator, I think the personality dimension is SJ and roughly 25% of the population fits this profile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Jesse W. Asher "They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety." - Benjamin Franklin
RE: RE: Rant
I like the hyperlinks on the CD docs. I like the improved master index and the search facility I HATE not being able to write my own notes on the page or reading the docs on the train --- kkennedy <[EMAIL PROTECTED]> wrote: > AMEN!!! Those yellow stickies all over the CD case just don't cut it > and there is not enough screen space on any terminal I've seen that > replaces multiple books open at the same time or books with paper > weights holding them open to two separate sections for quick > flipping. > > On the other hand, the CDs are easier to come by and I've learned to > live with them. > > Kevin Kennedy > First Point Energy Corporation > > -Original Message- > Sent: Monday, July 22, 2002 10:03 PM > To: Multiple recipients of list ORACLE-L > > > CDs have some advantages - expense, searchability, and storage space > primarily, but... > > 1) CDs are more difficult to read in bed, on a plane, waiting in the > terminal, etc. > > 2) Books are easier to read, require less equipment, and are more > portable > than a computer and a CD > > 3) Try having six different CD manuals open to related sections > spread out > in front of you - reading them while you work against the database. > > 4) An open book shows two full pages of information. An open PDF > about half > a page. > > 5) I could usually grab a manual and flip through it to the relevant > info > about 10x faster than a computer search - and with a lot less > extraneous > (click/point/scroll/type) activity. > > 6) Highlighters, margin notes, and sticky-note bookmarks don't work > at all > with CDs > > I miss hardcopy manuals! > > Don Granaman > [certifiable OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 22, 2002 3:18 PM > > > RE: RE: RantNot me. I LOVE the cds. I copy them onto my hard drive > and > use the pdf versions. they are SEARCHABLE. > > I can find things much more quickly in the pdf's than paper. > > Oracle is the only product that I feel this way about .. > probably > because they have more documentation than the library of congress! > > -Original Message- > <[EMAIL PROTECTED]> > Sent: Monday, July 22, 2002 3:54 PM > To: Multiple recipients of list ORACLE-L > > I can see why they stopped distributing them though, it must have > been > costly. > > It doesn't remove the fact that it would be handy to have paper > copies of > the manuals. It's hard to put yellow sticknote tabs on a CD. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- > Author: > INET: [EMAIL PROTECTED] Fat City Network Services -- (858) > 538-5051 > FAX: (858) 538-5051 San Diego, California -- Public Internet access / > Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message to: > [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message > BODY, include a line containing: 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.com > -- > Author: Don Granaman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com > -- > Author: kkennedy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate The Backup & Recovery Handbook has a great treatment of what happens in the various shutdown methods. Here is a quick summary: ABORT - Disallow new connections, drop file locks, terminate processes IMMEDIATE - Disallow new connections, terminate current connections and rollback active transactions, flush db block and redo log caches, update file headers, close files, synchronize control files, terminate processes TRANSACTIONAL - Disallow new connections, allow active transactions to complete, terminate current connections, flush db block and redo log caches, update file headers, close files, synchronize control files, terminate processes NORMAL - Disallow new connections, allow current connections to be completed and sessions logged out, flush db block and redo log caches, update file headers, close files, synchronize control files, terminate processes. Obviously, if the users did not log out of the sessions, the db would not come down. If ABORT is used, transactions will be rolled back upon startup (which is why it may take longer to open). In 9i, there was (is?) a known bug where an ABORT would cause the database to not open. Also note that the caches are not flushed. The database will be in an inconsistent state and is not valid for a backup if it is not in archivelog mode (though you may get lucky...). -Original Message-From: Ishrat Jehan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 12:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm The differences are 1. shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted. 2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactions terminated are rollbacked, recovery would not happen at restart 3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever. So shutdown immediate is much quicker and safer. ...Ishrat -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: How can I check the time when any table is updated under a sc
I am surprised that the developer doesn't know the code s/he wrote/maintains. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! --- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote: > Hi, > > One of my developer wants to know what are the tables or any other > objects being modified during the execution of his application. > > dba_objects have following 3 date fields. But I am not sure if any of > these date fields will capture the last DML(update, insert or delete) > time. > > CREATED > LAST_DDL_TIME > TIMESTAMP > > Any idea? > > Thanks in advance, > Ashoke *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Rant-Rant
Actually I'd think entj would be just about the ideal for a dba or sa. You have the leadership ability to ride herd on people (such as developers), are driven to keep up on the technical stuff, are well-organized enough to keep track of everything... I very aware of working against my natural instincts when I set up my backup and recovery plans, since improvisation and leaving things open is generally *not* advisable. "Oh, we'll figure it out as we go along" isn't a good choice there :), despite being my being rather good at doing just that. Jay -Original Message- Sent: Monday, July 22, 2002 5:25 PM To: Multiple recipients of list ORACLE-L How about an ENTJ as a DBA and System Admin... I'm loads of fun with a bunch of touchy feely type SP's here at the college I work for ;-) Joe On Mon, 22 Jul 2002, Miller, Jay wrote: > FYI: SJs make up about 40% of the population (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a technical job... :) > > -Original Message- > Sent: Monday, July 22, 2002 1:23 PM > To: Multiple recipients of list ORACLE-L > > > > That is why I use the > machinist analogy: somebody who is satisfied with a career spending 25 > years doing essentially the same thing. If you are into Myers-Briggs type > indicator, I think the personality dimension is SJ and roughly 25% of the > population fits this profile. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: RE: Rant
oh goodie, now I can stop feeling badly over it :) I've learned that whenever I log into a database as a superuser (connect internal or / as sysdba) the FIRST command I issue is "select * from v$database" so that I confirm that I am in the database I think I'm in. just a habit, but one that stopped me cold from shutting down the forward-facing database, which would have effectively shutdown the website. --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > That happens even to us SAs who are also DBAs (or vice versa). About > five > years ago, I was explaining DCL and VMS to a new co-worker and > describing > how I help protect against accidental file deletion by having > "DEL*ETE :== > DELETE/LOG/CONFIRM" in my SYS$LOGIN:LOGIN.COM. So, I confidently > issued a > "DEL *.*.*" -- in SYS$LIBRARY -- after running AUTOGEN. Seasoned VMS > SAs > know that AUTOGEN quietly deletes all global symbols, including those > protecting accidental file deletes. > > After a "Putz!" comment from our Operations group, the files were > given an > emergency restore. The thing is that I knew better. Doing DBA work > in > Oracle, however, has made me even more paranoid. Hasn't happened > since and > I don't rely on site addons to protect me from myself. > > "Now I know, and knowing is half the battle." > -- G.I.Joe, a real American Hero > > :) > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, > WI USA > > > -Original Message- > > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 22, 2002 9:14 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:RE: Rant > > > > > > you betcha. > > > > okay, I'll tell a story on myself. I really am usually very careful > > about doing something that is a sweeping change without > > checking either > > the directory I'm in or doing it so that I have to confirm. > > > > VAX/VMS, in my home directory. I could have SWORN I was in a temp > > directory, my login was supposed to be set up to tell me the > directory > > I was in. It wasn't, 'cause I did the VMS equivalent of "rm *" and > > deleted EVERYTHING in my home directory (scripts, notes, > > login profile) > > > > I very meekly called the data center and asked them to please > please > > restore my directory from the prior night's backup tape. After they > > stopped laughing, they made it a rush. See, I used to buy > > them pizza if > > I had to ask them to work late and do extra stuff. > > > > I know my limitations. I'm a pretty good general DBA but I ain't an > SA > > > > Rachel > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: new OEM / Re:RE: Rant
Eric, I learned OEM and decided it just wasn't worth it. I saw nothing of added value there. I can and do everything that OEM does via either Cron or any other scheduling tool. The product makes no sense to me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 23, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Hold on does that mean that since I never learned it, I should just wait for the new one? :) Will it support 8.1.7 in client-server mode? :):) (Or "just" Oracle9i?) regards, ep On 22 Jul 2002 at 10:13, [EMAIL PROTECTED] wrote: > YUP, Saw the new version at an Oracle event in Boston a couple of months ago. > Seems that nothing is sacred anymore. BTW: Installer changes too, now you need > a full multimedia terminal, 4 channel audio & VR headset recommended. :o) > > Dick Goulet > > Reply Separator > Author: Rachel Carmichael <[EMAIL PROTECTED]> > Date: 7/22/2002 9:53 AM > > you can see how often I use the GUI :) > > OBTW.. for those of you who are OEM fans... I heard a rumor (from a > fairly well-informed, usually accurate source) that Oracle's changing > it all again. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Rant-Rant
what a nice way to put that :) maybe they are taking mental age into account and so think I'm about 16? either that or they have you confused with someone else, it was my understanding that they tag you as soon as you hit 50 --- "Toepke, Kevin M" <[EMAIL PROTECTED]> wrote: > Hmmm... thats intersting. I'm somewhat your junior and I've been > getting > their propaganda for a couple of years already. > > -Original Message- > Sent: Tuesday, July 23, 2002 9:34 AM > To: Multiple recipients of list ORACLE-L > > > so sweet. so deluded. > > I'm one of the chronological seniors here.. not the oldest I've found > but close > > on the other hand, AARP (American Association of Retired People) > hasn't > started sending me their propaganda yet > > > --- [EMAIL PROTECTED] wrote: > > I didn't know that they gave Managers jobs to people under 20 :-) > > > > Cheers > > > > > > -- > > = > > Peter McLarty E-mail: [EMAIL PROTECTED] > > Technical ConsultantWWW: http://www.mincom.com > > APAC Technical Services Phone: +61 (0)7 3303 3461 > > Brisbane, AustraliaMobile: +61 (0)402 094 238 > > Facsimile: +61 (0)7 3303 3048 > > = > > A great pleasure in life is doing what people say you cannot do. > > > > - Walter Bagehot (1826-1877 British Economist) > > = > > Mincom "The People, The Experience, The Vision" > > > > = > > > > This transmission is for the intended addressee only and is > > confidential > > information. If you have received this transmission in error, > please > > delete it and notify the sender. The contents of this e-mail are > the > > opinion of the writer only and are not endorsed by the Mincom Group > > of > > companies unless expressly stated otherwise. > > > > > > > > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 22-07-2002 07:08 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Fax to: > > Subject:RE: Rant-Rant > > > > > > Oh I know. I was lucky my last job, we had two full-time DBAs (one > > senior - me, and one junior/mid) and one senior DBA consultant. > > > > I *did* look at my boss last week and said "I no longer work 20 > hour > > days". > > > > Not that I had to. He's good, he's very adamant about the fact that > > if > > there is too much work for one person, we will either hire > > consultants > > or the deadlines will be changed. I'd fall in love with him but > he's > > way too young for me. :) > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > Rachel, > > > > > > you are actually proving my point - that a company does not have > > the > > > luxury > > > (or common sense) to have more than one DBA on staff. > > > > > > Robert's utopia just doesn't fly in todays world. hire one > person > > > and > > > work-em till they drop is the current motto. > > > > > > Tom Mercadante > > > Oracle Certified Professional > > > > > > > > > -Original Message- > > > Sent: Monday, July 22, 2002 3:24 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > >The only problem with your idea that I see is that a typical > > > >organization > > > >will only keep one (or so) DBA on staff per project - they > rarely > > > have > > > > > > > > > > > > excuse me while I wipe the Diet Coke off the screen that I spit > out > > > when I read this. One DBA per project? Oh God that would be a > > luxury > > > beyond belief. > > > > > > As I type this I am the DBA for: > > > > > > a new data mart/data warehouse project > > > a new content management system project > > > a new ecommerce project > > > the existing "universal login" project AND the replacement > project > > > the existing asset management application > > > the existing "community" site (bulletin boards) > > > > > > and anything else that needs a DBA ... and I am it, ain't no > other > > > DBAs > > > around .. > > > > > > oh yeah, I'm the data architect and data modeler on half these as > > > well... which is REALLY funny as I have almost zero data modeling > > > experience, other than "common sense" > > > > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > > OMG! A Socialist in the group! > > > > > > > > "I believe that if we think about these things in a way that we > > ask > > > > > > > ourselves how can I maximize the potential of this person in > our > > > > organization, pay him/her a fair wage for what they can do, and > > > free > > > > up my > > > > time to address the really gnarly stuff we can help our entire > > > > society > > > > better transition to the information era and not marginalize a > > > bunch > > > > of
RE: Myers-Briggs
well, I've done a number of test, both under trained supervision and ones like this (and yes, I do discount a lot of the online stuff) I've also worked with a therapist for years to get to really understand me. I'm pretty sure I'm not mis-stating who I am :) --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > Beware of self-reports! > > They are notoriously innacurate. > > e.g. ask people what they will be doing in the next three years, they > are > almost always wrong. > > Ask them what they are like, ask them their traits, and often they > are > wrong. Wishful thinking kicks in, perhaps. Also when people think > something is a big concern, often it is because they focus on that > particular trait - most people probably don't pay attention to it as > much. > E.g. my mother-in-law keeps saying she can't do anything right, that > it > takes her longer than everyone else to get things done properly... > turns out > she is a perfectionist! > > Same thing with the enneagram, people's self-image tends to discard > chief > feature, they think their personality revolves around something else. > > : ) > > anyway, back to DBA work. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Tuesday, July 23, 2002 12:29 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Myers-Briggs > > Here is the online test, very interesting. I am INTJ > as well. > > http://www.humanmetrics.com/cgi-win/JTypes1.htm > > > Jack > > > That's very funny. INFP DBA... Wow! You do what > > you want with verve and to > > Hell the consequences whenever you blow up. > > Being a P, you are pragmatic > > about your outbursts... ? > > > > I am an INTJ most of the time. > > > > I - I am stubborn > > N - I follow my own inner sense of direction > > T - I mull things over before I act > > J - I have an opinion about everything. > > > > E-Mail: [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Monday, July 22, 2002 5:49 PM > > To: Multiple recipientsBoth my parents are > > psychologists, go figure. > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > Systems Admin & Operations | Admin. et Exploit. > > des systèmes > > Technology Services| Services > > technologiques > > Informatics Branch | Direction de > > l'informatique > > Maritimes Region, DFO | Région des > > Maritimes, MPO > > > > of list ORACLE-L > > Subject:RE: Rant-Rant > > > > FYI: SJs make up about 40% of the population > > (app. 10% for each > > sub-division). > > > > Jay Miller > > infp (yeah, I know, what's an infp doing in a > > technical job... :) > > > > -Original Message- > > Sent: Monday, July 22, 2002 1:23 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > That is why I use the > > machinist analogy: somebody who is satisfied > > with a career spending 25 > > years doing essentially the same thing. If you > > are into Myers-Briggs type > > indicator, I think the personality dimension is > > SJ and roughly 25% of the > > population fits this profile. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Miller, Jay > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > (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.com > > -- > > Author: Boivin, Patrice J > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > > an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: > > 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). > > > > -- > > Rodd Holman > > Enterprise Data Systems Engineer > > LodgeNet Entertainment Corporation > > [EMAIL PROTECTED] > > (605) 988-1373 > > > > > > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FA
RE: (memes) not making much headway with critiquing "elitist" dba
Eric, Huh? Tom (you lost me at hallo) -Original Message- Sent: Tuesday, July 23, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Robert, I got into computers after being in the fertilizer industry, a segue which has many times seemed quite apt. A year or two ago, I noticed that Oracle Education had a training/certification track for something they called "Database Operator" (DBO) that was quite similar to what you are talking about. The trainee was to know how to conduct routine, basic tasks under the supervision of a senior dba (on "big" databases), or would be a SA running a 3rd party type application that ran on top of Oracle where the 3rd party app people would provide dba technical consulting/support, or a SA that was running a small/non-critical database, etc. (the web site education.oracle.com doesn't seem to be working right now, so I can't confirm if they still have a "DBO" track.) Re: critiquing of the cultish/elitist mentality that predominates in DBA circles? ha haaa haa. The thing is to make crucial distinction between: "good elitism": - high level specialization, - expertise required, - capacity of an individual to absorb tecnical complexity/theory and learn to apply it to problem solving, etc. and: "bad elitism": - arrogant/selfish attitude, greedy, etc. Presumably the worst case scenario is having a person that exhibits "bad elitism" with little or no sign of any of the attributes of "good elitism". I support your efforts at articulating a more "populist" scenario for defining technical job positions. You of course realize that any sort of populist argument, libertarian or otherwise, will get caught in the hellish middle of a cultural landscape that is mainly defeined by snobby *ssholes in either the "politically correct" (liberal) or "country club" (conservative) camps. Besides retreating to a libertarian position (which I think is an honorable approach, if somewhat stasist), there is also another alternative: embrace a holistic, integrative (transcendant/universal) paradigm that recognises the evolutionary limits (and evils) of both "classic" liberalism and conservatism. http://members.ams.chello.nl/f.visser3/wilber/mgm2.html Explanation of color schemes used in "Spiral Dynamics" type Memetic theory: http://members.ams.chello.nl/f.visser3/wilber/wilber_sd.html regards, ep On 22 Jul 2002 at 9:23, Robert Monical wrote: ... > It seems that the implicit expectation is that every DBA should be or > should aspire to be a Master Technical DBA. > I have a slightly different take on the situation. It is a little > convoluted but I believe that the DBA world needs some additional job > classifications. In a decent sized organization, the day to day management > functions should be accomplished by an Admin DBA who might be someone who > was perfectly happy spending his/her working career operating a precision > milling machine at Boeing. Since the machinist jobs are going away, I see > no reason why a competent machinist could not become a competent admin DBA. > Such a person is not suited by aptitude or disposition to become a Master > Technical DBA, but would do a great job at the admin level. > > I'll extend the analogy a little more: the manufacturing organization does > not expect the machinist to program the machine. They either have on staff > or bring in a numerical control programming specialist. Similarly, the > Admin DBA should know which tasks he/she can perform and which tasks should > be kicked up or out to the next level. > > So maybe some of the energy spent on this list about relevance of the OCP > and discussing qualifications of DBAs (against an unspecified standard) > could be spent defining organizational strategies for getting the best use > out of human capital represented by "Admin DBAs" and pricing the skill set > appropriately. The worst possible thing is to get an Admin DBA into a > Technical DBA position. > > I think the key breakthrough is the notion that there is a DBA track that > does not inevitably lead to Master Technical DBA. That is why I use the > machinist analogy: somebody who is satisfied with a career spending 25 > years doing essentially the same thing. If you are into Myers-Briggs type > indicator, I think the personality dimension is SJ and roughly 25% of the > population fits this profile. > > I believe that if we think about these things in a way that we ask > ourselves how can I maximize the potential of this person in our > organization, pay him/her a fair wage for what they can do, and free up my > time to address the really gnarly stuff we can help our entire society > better transition to the information era and not marginalize a bunch of > great people in the process. (Sez the man operating a three person > software company). ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMA
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate The differences are 1. shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted. 2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactions terminated are rollbacked, recovery would not happen at restart 3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever. So shutdown immediate is much quicker and safer. ...Ishrat -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
Re: How can I check the time when any table is updated under a schema?
none of them will capture DML changes you have two choices: 1) turn on auditing... this will tell you at a macro level what has been touched, but won't necessarily tell you who did it or if it was done by the execution of his app 2) add an update_dt and an updated_by column to all tables and create a trigger which fires on insert/update/delete to fill the column of the row with sysdate and the userid of the user. This is very detailed, down to the row level but may also not give you whether or not the change was made during the execution of his application --- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote: > Hi, > > One of my developer wants to know what are the tables or any other > objects being modified during the execution of his application. > > dba_objects have following 3 date fields. But I am not sure if any of > these date fields will capture the last DML(update, insert or delete) > time. > > CREATED > LAST_DDL_TIME > TIMESTAMP > > Any idea? > > Thanks in advance, > Ashoke > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: Myers-Briggs - Too many off topic topics!
There have been a lot of off topic topics lately. I finally had to add the "Rant" thread to my filters so I wouldn't get any more of it. Can we please stick to things Oracle?? Boivin, Patrice J wrote: I think this is funny, corporations relying on the Myers-Briggs which is based on Jung's depth psychology - archetypes, synchronicity, collective consciousness, alchemy and magic... I don't believe most HR realize this. Bureaucracies are supposed to be "rational" and here they rely on knowledge that comes from studying the subconscious and alchemy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Myers-Briggs do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what "type" a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman <[EMAIL PROTECTED]> wrote: Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this? Rodd Holman On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the time. I - I am stubborn N - I follow my own inner sense of direction T - I mull things over before I act J - I have an opinion about everything. E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, July 22, 2002 5:49 PM To: Multiple recipientsBoth my parents are psychologists, go figure. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO of list ORACLE-L Subject: RE: Rant-Rant FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L That is why I use the machinist analogy: somebody who is satisfied with a career spending 25 years doing essentially the same thing. If you are into Myers-Briggs type indicator, I think the personality dimension is SJ and roughly 25% of the population fits this profile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists (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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Jesse W. Asher "They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety." - Benjamin Franklin
RE: IO wait
Jack, You can run 'iostat -x 5 5' to see which disk are being used. In this example, the arguments state "5 sec increments, 5 times". This output may show a need to spread your data amongst your disk differently. -reggie > -Original Message- > From: Jack Silvey [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 23, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > Subject: IO wait > > All, > > We are tuning a new vital process on our data > warehouse, and it is IO intensive - lots of parallel > direct reads and writes. During our testing we are > driving IO wait to ~60% (per top). > > questions: > > 1) is top a valid measure of IO wait? > 2) Is a high io wait an issue to be concerned about? > 3) how else can it be accurately measured? > 4) How can I link IO wait to what is happening inside > the database? > > Thanks, > > Jack > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack Silvey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com -- Author: Beavers, Reginald INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Index performance
Title: RE: Index performance
Seema,
It would really help to see your index scripts also. If you have an index that includes emp_id, reg_date, emp_st, last_access, emp_status, and match, that index should work best. Use a hint on that index.
You say that this query hits a number of indices on this table. Do you have the explain plan that shows which and how the indexes are hit? You can't assume that just because you have an index that it is being used. If you have a bunch of indexes each on a different column or two, the indexes are probably not doing this SQL any good and surely making inserts and updates take a lot longer.
Also how big is the table? How big is it expected to become? When's the last time it was analyzed?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Hi
I am executing following query adn this query hits a number of indices on
this table.let me know what is wrong please.all in where clause are having
indexes.
select name,last_access, reg_date from empmaster where emp_id<100
and reg_date>to_date('2001-01-01','-MM-DD') and
emp_st='valid' and last_access>to_date ('2001-01-01','-MM-DD')
and emp_status='S' and match='FIRST'
Here all conditions in where clause are having indexes.
How to rewrite this query.
The primary key is emp_id.
Thanks
-Seema
Re: error when acessing table_privileges
Not a problem under 8.1.5 or 9.2. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 12:58 PM > > Select using a column list, excluding the CREATED column. ORA-24328 > means 'illegal attribute value', so I think the CREATED column is the > problem because it's defined as a varchar2(0). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Suzy Vordos > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well. - Rich -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: IO wait
Have you considered trying StorageXpert from Quest? - Kirti -Original Message- Sent: Tuesday, July 23, 2002 10:58 AM To: Multiple recipients of list ORACLE-L All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top). questions: 1) is top a valid measure of IO wait? 2) Is a high io wait an issue to be concerned about? 3) how else can it be accurately measured? 4) How can I link IO wait to what is happening inside the database? Thanks, Jack __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Index performance
Also do you know what is the most selective part of the query. If you know
that one index will bring back the fewest rows then try hinting to use it.
-Original Message-
Sent: Tuesday, July 23, 2002 5:59 PM
To: Multiple recipients of list ORACLE-L
why do you think hitting the indexes is a bad thing? what is the
performance of this query? What's the explain plan?
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> I am executing following query adn this query hits a number of
> indices on
> this table.let me know what is wrong please.all in where clause are
> having
> indexes.
> select name,last_access, reg_date from empmaster where emp_id<100
> and reg_date>to_date('2001-01-01','-MM-DD') and
> emp_st='valid' and last_access>to_date ('2001-01-01','-MM-DD')
> and emp_status='S' and match='FIRST'
> Here all conditions in where clause are having indexes.
> How to rewrite this query.
> The primary key is emp_id.
> Thanks
> -Seema
>
>
>
>
>
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: 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).
__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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.com
--
Author: Nicoll, Iain (Calanais)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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).
RE: PTFM? / Re:RE: RE: Rant
How about PARTFM (pronouned 'PartyFM' ;) ? - Kirti -Original Message- Sent: Tuesday, July 23, 2002 12:34 PM To: Multiple recipients of list ORACLE-L You can get a color laser printer cheaper than that. besides RTFM, is there going to now be PTFM? On 22 Jul 2002 at 12:36, [EMAIL PROTECTED] wrote: > Patrice, > > You can still get them, you just have to order them seperatly at a platinum > plated cost. Last time I looked is was $1500 per set. > > Dick Goulet > > Reply Separator > Author: "Boivin; Patrice J" <[EMAIL PROTECTED]> > Date: 7/22/2002 11:53 AM > > I can see why they stopped distributing them though, it must have been > costly. > > It doesn't remove the fact that it would be handy to have paper copies of > the manuals. It's hard to put yellow sticknote tabs on a CD. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: shutdown abort / startup restrict / shutdown vs. shutdown imm
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Check this out too :) http://www.speakeasy.org/~jwilton/oracle/shutdown-abort-bad.html - Kirti -Original Message-From: kkennedy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
RE: Myers-Briggs
Title: RE: Myers-Briggs I have been subjected to this rubbish repeatedly for the last 20 years or so, including being forced to do my senior project in college on non-sense related to this test and the results. My personal opinion: it's a bunch of crapola. One of the major precepts of this test is that, if admististered correctly, the results will not change over time (you are what you are). I wholeheartedly disagree. I find the 16 possible permutations to be shallow and insufficent. I could go on and on, but I really don't think it even worth the effort. this probably need to be moved to the off-topic list. -- Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: "Let the programmers by many and the managers few, Then all will be productive" - The Tao of Programming -Original Message- From: kkennedy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Myers-Briggs About 15 years ago, I was working as a contractor for a federal agency. The director got this bright idea to have everyone, both fed and contract, take the Myers-Briggs. I got through about the first 10 questions before I gave up in disgust and frustration. I was able to answer about 1 or 2 of the questions. On the rest, my answer was "two or more of the selections depending on the situation". Naturally, the situational background was never given. I decided I was too flexible to be pigeonholed. My boss was sympathetic. He pointed out that there is a Myers-Briggs pigeonhole for people who don't like the Myers-Briggs test. I'm still trying to figure out if he was pulling my leg 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 23, 2002 8:18 AM To: Multiple recipients of list ORACLE-L do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what "type" a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman <[EMAIL PROTECTED]> wrote: > Where do you take this profile to find out what you are? I'm curious > now. Is there someplace on-line that will let you do this? > > Rodd Holman > On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: > > That's very funny. INFP DBA... Wow! You do what you want with > verve and to > Hell the consequences whenever you blow up. Being a P, you are > pragmatic > about your outbursts... ? > > I am an INTJ most of the time. > > I - I am stubborn > N - I follow my own inner sense of direction > T - I mull things over before I act > J - I have an opinion about everything. > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, July 22, 2002 5:49 PM > To: Multiple recipientsBoth my parents are psychologists, go > figure. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services | Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > of list ORACLE-L > Subject: RE: Rant-Rant > > FYI: SJs make up about 40% of the population (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a technical job... :) > > -Original Message- > Sent: Monday, July 22, 2002 1:23 PM > To: Multiple recipients of list ORACLE-L > > > > That is why I use the > machinist analogy: somebody who is satisfied with a career > spending 25 > years doing essentially the same thing. If you are into > Myers-Briggs type > indicator, I think the personality dimension is SJ and roughly > 25% of the > population fits this profile. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) > 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > > (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) > 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTE
Re:How to notify the password expiration in oracle using ema
What version? Reply Separator Author: "Mandal; Ashoke" <[EMAIL PROTECTED]> Date: 7/23/2002 8:53 AM Hi All, Does anybody have a standard code or process for sending email from oracle to address the following issue. Thanks, Ashoke -Original Message- Sent: Monday, July 22, 2002 3:37 PM To: Multiple recipients of list ORACLE-L Not sure it would be the best but... logically I would: 1. get sysdate 2. get expiration date 3. if expiration date - sysdate <= 7 (let's say you wanted to warn them 7 days in advance) send them e-mail. I have not done e-mail from Oracle but there are plenty examples everywhere. Or, I think you could create a screen in your app. and display that screen for them any time they get close to expiration date. You can even let them change their password through that screen, too. -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Greetings, As I understand that from Oracle 8 onward we have the feature of password management like account locking, password aging and expiration, password history and password complexity requirements. My understanding is that if the password is expired for an user then that user will be notified during his first attempt to login to the oracle database. Instead of waiting for the user to login and then know about his password expiration, we are trying to find out a way by which the oracle can automatically send an email to the respective user as it is close to the password expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: RE: Rant
AMEN!!! Those yellow stickies all over the CD case just don't cut it and there is not enough screen space on any terminal I've seen that replaces multiple books open at the same time or books with paper weights holding them open to two separate sections for quick flipping. On the other hand, the CDs are easier to come by and I've learned to live with them. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Monday, July 22, 2002 10:03 PM To: Multiple recipients of list ORACLE-L CDs have some advantages - expense, searchability, and storage space primarily, but... 1) CDs are more difficult to read in bed, on a plane, waiting in the terminal, etc. 2) Books are easier to read, require less equipment, and are more portable than a computer and a CD 3) Try having six different CD manuals open to related sections spread out in front of you - reading them while you work against the database. 4) An open book shows two full pages of information. An open PDF about half a page. 5) I could usually grab a manual and flip through it to the relevant info about 10x faster than a computer search - and with a lot less extraneous (click/point/scroll/type) activity. 6) Highlighters, margin notes, and sticky-note bookmarks don't work at all with CDs I miss hardcopy manuals! Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 3:18 PM RE: RE: RantNot me. I LOVE the cds. I copy them onto my hard drive and use the pdf versions. they are SEARCHABLE. I can find things much more quickly in the pdf's than paper. Oracle is the only product that I feel this way about .. probably because they have more documentation than the library of congress! -Original Message- <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Myers-Briggs
I'm: ENTJ (Extroverted, Intuitive, Thinking, Judging) slightly expressed extrovert slightly expressed intuitive personality moderately expressed thinking personality slightly expressed judging personality LOL I'm a "Field Marshall".. -Original Message- Sent: 23 July 2002 16:29 To: Multiple recipients of list ORACLE-L Here is the online test, very interesting. I am INTJ as well. http://www.humanmetrics.com/cgi-win/JTypes1.htm Jack > That's very funny. INFP DBA... Wow! You do what > you want with verve and to > Hell the consequences whenever you blow up. > Being a P, you are pragmatic > about your outbursts... ? > > I am an INTJ most of the time. > > I - I am stubborn > N - I follow my own inner sense of direction > T - I mull things over before I act > J - I have an opinion about everything. > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, July 22, 2002 5:49 PM > To: Multiple recipientsBoth my parents are > psychologists, go figure. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. > des systhmes > Technology Services| Services > technologiques > Informatics Branch | Direction de > l'informatique > Maritimes Region, DFO | Rigion des > Maritimes, MPO > > of list ORACLE-L > Subject: RE: Rant-Rant > > FYI: SJs make up about 40% of the population > (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a > technical job... :) > > -Original Message- > Sent: Monday, July 22, 2002 1:23 PM > To: Multiple recipients of list ORACLE-L > > > > That is why I use the > machinist analogy: somebody who is satisfied > with a career spending 25 > years doing essentially the same thing. If you > are into Myers-Briggs type > indicator, I think the personality dimension is > SJ and roughly 25% of the > population fits this profile. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > > To REMOVE yourself from this mailing list, send > an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: > 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). > > -- > Rodd Holman > Enterprise Data Systems Engineer > LodgeNet Entertainment Corporation > [EMAIL PROTECTED] > (605) 988-1373 > > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re:RE: Rant
Jerry, Don't laugh! I did an interview a couple, or has it been longer, of years ago at a financial institution in my neighborhood (northern Mass). Anyway, the interviewer who was the head of the DBA group suggested I show him how I would troubleshoot a problem that they were having. OK, so I give them a couple of pointers that make things better, no problem I pass those out here all the time. Anyway, he had me sit down at a terminal & was going to call one of his staff to create me an account. Well no one was available so I tried system/manager on their PROD database. Was I ever surprised when it worked, so was the interviewer especially when sys/change_on_install worked too! Can you say "AW S&^%"!! To say the least, I do not work for them even though they laid a very nice offer on the table. Dick Goulet Reply Separator Author: "Cunningham; Gerald" <[EMAIL PROTECTED]> Date: 7/23/2002 8:48 AM Has anybody ever come across a virus that affects Oracle db's via sqlnet? Just curious how such a thing would work (have some ideas). There have to be thousands of vulnerable db's out there (sys/change_on_install, system/manager, etc.) (I've been reading Tom Clancy lately... Getting even more paranoid!) - Jerry -Original Message- Sent: Tuesday, July 23, 2002 7:39 AM To: Multiple recipients of list ORACLE-L Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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). This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
How can I check the time when any table is updated under a schema?
Hi, One of my developer wants to know what are the tables or any other objects being modified during the execution of his application. dba_objects have following 3 date fields. But I am not sure if any of these date fields will capture the last DML(update, insert or delete) time. CREATED LAST_DDL_TIME TIMESTAMP Any idea? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Rant
Gerald, Contact SANS, they are working on an Oracle step-by-step guide, they are looking for people who might want to volunteer as test sites. SANS Research Office [[EMAIL PROTECTED]] Send e-mail with subject line: Oracle bench test. They are just collecting names for now, waiting for feedback on the last draft. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 23, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Subject:RE: Rant Has anybody ever come across a virus that affects Oracle db's via sqlnet? Just curious how such a thing would work (have some ideas). There have to be thousands of vulnerable db's out there (sys/change_on_install, system/manager, etc.) (I've been reading Tom Clancy lately... Getting even more paranoid!) - Jerry -Original Message- Sent: Tuesday, July 23, 2002 7:39 AM To: Multiple recipients of list ORACLE-L Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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). This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: Myers-Briggs
strange I seem to have changed somewhat I'm now an ISFJ... hm, it still seems to fit me Okay, no more on this here... it needs to move to the OT list now! --- Jack Silvey <[EMAIL PROTECTED]> wrote: > Here is the online test, very interesting. I am INTJ > as well. > > http://www.humanmetrics.com/cgi-win/JTypes1.htm > > > Jack > > > That's very funny. INFP DBA... Wow! You do what > > you want with verve and to > > Hell the consequences whenever you blow up. > > Being a P, you are pragmatic > > about your outbursts... ? > > > > I am an INTJ most of the time. > > > > I - I am stubborn > > N - I follow my own inner sense of direction > > T - I mull things over before I act > > J - I have an opinion about everything. > > > > E-Mail: [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Monday, July 22, 2002 5:49 PM > > To: Multiple recipientsBoth my parents are > > psychologists, go figure. > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > Systems Admin & Operations | Admin. et Exploit. > > des systèmes > > Technology Services| Services > > technologiques > > Informatics Branch | Direction de > > l'informatique > > Maritimes Region, DFO | Région des > > Maritimes, MPO > > > > of list ORACLE-L > > Subject:RE: Rant-Rant > > > > FYI: SJs make up about 40% of the population > > (app. 10% for each > > sub-division). > > > > Jay Miller > > infp (yeah, I know, what's an infp doing in a > > technical job... :) > > > > -Original Message- > > Sent: Monday, July 22, 2002 1:23 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > That is why I use the > > machinist analogy: somebody who is satisfied > > with a career spending 25 > > years doing essentially the same thing. If you > > are into Myers-Briggs type > > indicator, I think the personality dimension is > > SJ and roughly 25% of the > > population fits this profile. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Miller, Jay > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > (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.com > > -- > > Author: Boivin, Patrice J > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > > an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: > > 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). > > > > -- > > Rodd Holman > > Enterprise Data Systems Engineer > > LodgeNet Entertainment Corporation > > [EMAIL PROTECTED] > > (605) 988-1373 > > > > > > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack Silvey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROT
PTFM? / Re:RE: RE: Rant
You can get a color laser printer cheaper than that. besides RTFM, is there going to now be PTFM? On 22 Jul 2002 at 12:36, [EMAIL PROTECTED] wrote: > Patrice, > > You can still get them, you just have to order them seperatly at a platinum > plated cost. Last time I looked is was $1500 per set. > > Dick Goulet > > Reply Separator > Author: "Boivin; Patrice J" <[EMAIL PROTECTED]> > Date: 7/22/2002 11:53 AM > > I can see why they stopped distributing them though, it must have been > costly. > > It doesn't remove the fact that it would be handy to have paper copies of > the manuals. It's hard to put yellow sticknote tabs on a CD. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re: error when acessing table_privileges
Select using a column list, excluding the CREATED column. ORA-24328 means 'illegal attribute value', so I think the CREATED column is the problem because it's defined as a varchar2(0). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
Re[2]: Rant-Rant
Well, just watch your mailbox for when the "American society of Morticians" starts sending you funeral planning information. Now you know your REALLY old. Dick Goulet Reply Separator Author: "Ruth Gramolini" <[EMAIL PROTECTED]> Date: 7/23/2002 7:38 AM AARP has already stopped sending me propaganda. I think I am the oldest on the list. RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 9:33 AM > so sweet. so deluded. > > I'm one of the chronological seniors here.. not the oldest I've found > but close > > on the other hand, AARP (American Association of Retired People) hasn't > started sending me their propaganda yet > > > --- [EMAIL PROTECTED] wrote: > > I didn't know that they gave Managers jobs to people under 20 :-) > > > > Cheers > > > > > > -- > > = > > Peter McLarty E-mail: [EMAIL PROTECTED] > > Technical ConsultantWWW: http://www.mincom.com > > APAC Technical Services Phone: +61 (0)7 3303 3461 > > Brisbane, AustraliaMobile: +61 (0)402 094 238 > > Facsimile: +61 (0)7 3303 3048 > > = > > A great pleasure in life is doing what people say you cannot do. > > > > - Walter Bagehot (1826-1877 British Economist) > > = > > Mincom "The People, The Experience, The Vision" > > > > = > > > > This transmission is for the intended addressee only and is > > confidential > > information. If you have received this transmission in error, please > > delete it and notify the sender. The contents of this e-mail are the > > opinion of the writer only and are not endorsed by the Mincom Group > > of > > companies unless expressly stated otherwise. > > > > > > > > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 22-07-2002 07:08 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Fax to: > > Subject:RE: Rant-Rant > > > > > > Oh I know. I was lucky my last job, we had two full-time DBAs (one > > senior - me, and one junior/mid) and one senior DBA consultant. > > > > I *did* look at my boss last week and said "I no longer work 20 hour > > days". > > > > Not that I had to. He's good, he's very adamant about the fact that > > if > > there is too much work for one person, we will either hire > > consultants > > or the deadlines will be changed. I'd fall in love with him but he's > > way too young for me. :) > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > Rachel, > > > > > > you are actually proving my point - that a company does not have > > the > > > luxury > > > (or common sense) to have more than one DBA on staff. > > > > > > Robert's utopia just doesn't fly in todays world. hire one person > > > and > > > work-em till they drop is the current motto. > > > > > > Tom Mercadante > > > Oracle Certified Professional > > > > > > > > > -Original Message- > > > Sent: Monday, July 22, 2002 3:24 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > >The only problem with your idea that I see is that a typical > > > >organization > > > >will only keep one (or so) DBA on staff per project - they rarely > > > have > > > > > > > > > > > > excuse me while I wipe the Diet Coke off the screen that I spit out > > > when I read this. One DBA per project? Oh God that would be a > > luxury > > > beyond belief. > > > > > > As I type this I am the DBA for: > > > > > > a new data mart/data warehouse project > > > a new content management system project > > > a new ecommerce project > > > the existing "universal login" project AND the replacement project > > > the existing asset management application > > > the existing "community" site (bulletin boards) > > > > > > and anything else that needs a DBA ... and I am it, ain't no other > > > DBAs > > > around .. > > > > > > oh yeah, I'm the data architect and data modeler on half these as > > > well... which is REALLY funny as I have almost zero data modeling > > > experience, other than "common sense" > > > > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > > OMG! A Socialist in the group! > > > > > > > > "I believe that if we think about these things in a way that we > > ask > > > > > > > ourselves how can I maximize the potential of this person in our > > > > organization, pay him/her a fair wage for what they can do, and > > > free > > > > up my > > > > time to address the really gnarly stuff we can help our entire > > > > society > > > > better transition to the information era and not marginalize a > > > bunch > > > > of > > > > great people in the process." > > > > > > > > The only problem with you
RE: Myers-Briggs
I sit corrected... Intuitive = stuborn. Intraverted = leave me alone, I need to recharge. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject:Re: Myers-Briggs um the I doesn't mean stubbornness it's where you get your energy -- from yourself (Introvert) or from others (Extrovert) it's the Feeling part that makes me wonder about the DBA/computer stuff... aren't geeks supposed to be loners? --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > That's very funny. INFP DBA... Wow! You do what you want with verve > and to > Hell the consequences whenever you blow up. Being a P, you are > pragmatic > about your outbursts... ? > > I am an INTJ most of the time. > > I - I am stubborn > N - I follow my own inner sense of direction > T - I mull things over before I act > J - I have an opinion about everything. > > Both my parents are psychologists, go figure. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, July 22, 2002 5:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Rant-Rant > > FYI: SJs make up about 40% of the population (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a technical job... :) > > -Original Message- > Sent: Monday, July 22, 2002 1:23 PM > To: Multiple recipients of list ORACLE-L > > > > That is why I use the > machinist analogy: somebody who is satisfied with a career spending > 25 > years doing essentially the same thing. If you are into Myers-Briggs > type > indicator, I think the personality dimension is SJ and roughly 25% of > the > population fits this profile. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
new OEM / Re:RE: Rant
Hold on does that mean that since I never learned it, I should just wait for the new one? :) Will it support 8.1.7 in client-server mode? :):) (Or "just" Oracle9i?) regards, ep On 22 Jul 2002 at 10:13, [EMAIL PROTECTED] wrote: > YUP, Saw the new version at an Oracle event in Boston a couple of months ago. > Seems that nothing is sacred anymore. BTW: Installer changes too, now you need > a full multimedia terminal, 4 channel audio & VR headset recommended. :o) > > Dick Goulet > > Reply Separator > Author: Rachel Carmichael <[EMAIL PROTECTED]> > Date: 7/22/2002 9:53 AM > > you can see how often I use the GUI :) > > OBTW.. for those of you who are OEM fans... I heard a rumor (from a > fairly well-informed, usually accurate source) that Oracle's changing > it all again. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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).
RE: Myers-Briggs
I think this is funny, corporations relying on the Myers-Briggs which is based on Jung's depth psychology - archetypes, synchronicity, collective consciousness, alchemy and magic... I don't believe most HR realize this. Bureaucracies are supposed to be "rational" and here they rely on knowledge that comes from studying the subconscious and alchemy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, July 23, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject:Re: Myers-Briggs do a search for Meyers-Briggs and there are sites A lot of companies use this as a way of finding out what "type" a person is so you can learn how to deal with the people you work with. It's supposed to help with management styles etc --- Rodd Holman <[EMAIL PROTECTED]> wrote: > Where do you take this profile to find out what you are? I'm curious > now. Is there someplace on-line that will let you do this? > > Rodd Holman > On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote: > > That's very funny. INFP DBA... Wow! You do what you want with > verve and to > Hell the consequences whenever you blow up. Being a P, you are > pragmatic > about your outbursts... ? > > I am an INTJ most of the time. > > I - I am stubborn > N - I follow my own inner sense of direction > T - I mull things over before I act > J - I have an opinion about everything. > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, July 22, 2002 5:49 PM > To: Multiple recipientsBoth my parents are psychologists, go > figure. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > of list ORACLE-L > Subject: RE: Rant-Rant > > FYI: SJs make up about 40% of the population (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a technical job... :) > > -Original Message- > Sent: Monday, July 22, 2002 1:23 PM > To: Multiple recipients of list ORACLE-L > > > > That is why I use the > machinist analogy: somebody who is satisfied with a career > spending 25 > years doing essentially the same thing. If you are into > Myers-Briggs type > indicator, I think the personality dimension is SJ and roughly > 25% of the > population fits this profile. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > the message BODY, include a line containing: 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). > > -- > Rodd Holman > Enterprise Data Systems Engineer > LodgeNet Entertainment Corporation > [EMAIL PROTECTED] > (605) 988-1373 > > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: 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.com -- Author: Boivin, Patrice J INE
Re: Rant-Rant
oh, thanks, but they'll start sending me stuff next year and I can wait until then :) --- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote: > What's your mailing address? I can make the arrangements for you. > > Ken Janusz,CPIM > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, July 23, 2002 8:33 AM > > > > so sweet. so deluded. > > > > I'm one of the chronological seniors here.. not the oldest I've > found > > but close > > > > on the other hand, AARP (American Association of Retired People) > hasn't > > started sending me their propaganda yet > > > > > > --- [EMAIL PROTECTED] wrote: > > > I didn't know that they gave Managers jobs to people under 20 :-) > > > > > > Cheers > > > > > > > > > -- > > > = > > > Peter McLarty E-mail: [EMAIL PROTECTED] > > > Technical ConsultantWWW: http://www.mincom.com > > > APAC Technical Services Phone: +61 (0)7 3303 3461 > > > Brisbane, AustraliaMobile: +61 (0)402 094 238 > > > Facsimile: +61 (0)7 3303 3048 > > > = > > > A great pleasure in life is doing what people say you cannot do. > > > > > > - Walter Bagehot (1826-1877 British Economist) > > > = > > > Mincom "The People, The Experience, The Vision" > > > > > > = > > > > > > This transmission is for the intended addressee only and is > > > confidential > > > information. If you have received this transmission in error, > please > > > delete it and notify the sender. The contents of this e-mail are > the > > > opinion of the writer only and are not endorsed by the Mincom > Group > > > of > > > companies unless expressly stated otherwise. > > > > > > > > > > > > > > > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 22-07-2002 07:08 PM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > cc: > > > Fax to: > > > Subject:RE: Rant-Rant > > > > > > > > > Oh I know. I was lucky my last job, we had two full-time DBAs > (one > > > senior - me, and one junior/mid) and one senior DBA consultant. > > > > > > I *did* look at my boss last week and said "I no longer work 20 > hour > > > days". > > > > > > Not that I had to. He's good, he's very adamant about the fact > that > > > if > > > there is too much work for one person, we will either hire > > > consultants > > > or the deadlines will be changed. I'd fall in love with him but > he's > > > way too young for me. :) > > > > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > > Rachel, > > > > > > > > you are actually proving my point - that a company does not > have > > > the > > > > luxury > > > > (or common sense) to have more than one DBA on staff. > > > > > > > > Robert's utopia just doesn't fly in todays world. hire one > person > > > > and > > > > work-em till they drop is the current motto. > > > > > > > > Tom Mercadante > > > > Oracle Certified Professional > > > > > > > > > > > > -Original Message- > > > > Sent: Monday, July 22, 2002 3:24 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > >The only problem with your idea that I see is that a typical > > > > >organization > > > > >will only keep one (or so) DBA on staff per project - they > rarely > > > > have > > > > > > > > > > > > > > > > excuse me while I wipe the Diet Coke off the screen that I spit > out > > > > when I read this. One DBA per project? Oh God that would be a > > > luxury > > > > beyond belief. > > > > > > > > As I type this I am the DBA for: > > > > > > > > a new data mart/data warehouse project > > > > a new content management system project > > > > a new ecommerce project > > > > the existing "universal login" project AND the replacement > project > > > > the existing asset management application > > > > the existing "community" site (bulletin boards) > > > > > > > > and anything else that needs a DBA ... and I am it, ain't no > other > > > > DBAs > > > > around .. > > > > > > > > oh yeah, I'm the data architect and data modeler on half these > as > > > > well... which is REALLY funny as I have almost zero data > modeling > > > > experience, other than "common sense" > > > > > > > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > > > OMG! A Socialist in the group! > > > > > > > > > > "I believe that if we think about these things in a way that > we > > > ask > > > > > > > > > ourselves how can I maximize the potential of this person in > our > > > > > organization, pay him/her a fair wage for what they can do, > and > > > > free > > > > > up my > > > > > time to address the really gnarly stuff we can
RE: shutdown abort / startup restrict / shutdown vs. shutdown immedia
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin KennedyFirst Point Energy Corporation -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 7:53 PMTo: Multiple recipients of list ORACLE-LSubject: shutdown abort / startup restrict / shutdown vs. shutdown immedia > -Original Message- > From: April Wells [mailto:[EMAIL PROTECTED]] > > The solutions (the ones that I got) aren't good ones. > > Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID > solution'???) This might be a naive question, but why is -> shutdown immediate better than -> shutdown abort / startup restrict / shutdown normal ? (That is assuming of course that no user / job will try to sneak in after you do the startup restrict)
Re: Index performance
why do you think hitting the indexes is a bad thing? what is the
performance of this query? What's the explain plan?
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> I am executing following query adn this query hits a number of
> indices on
> this table.let me know what is wrong please.all in where clause are
> having
> indexes.
> select name,last_access, reg_date from empmaster where emp_id<100
> and reg_date>to_date('2001-01-01','-MM-DD') and
> emp_st='valid' and last_access>to_date ('2001-01-01','-MM-DD')
> and emp_status='S' and match='FIRST'
> Here all conditions in where clause are having indexes.
> How to rewrite this query.
> The primary key is emp_id.
> Thanks
> -Seema
>
>
>
>
>
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: 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).
__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: 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).
