Re: Row cache locks on INSERTs with a sequence
Correct - I was sure that I had a set of test results to prove my point, but I didn't - so I've just run a series of tests on enqueue and buffer busy waits on an 8.1.7.4 system and you are absolutely right - the seconds_in_wait does not reset as the wait completes. Thanks, Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 22 December 2002 02:28 It is a common error to assume that v$session_wait is showing a wait time - however if the STATE is __not__ WAITING then the SECONDS_IN_WAIT column is the time since the last wait ended. It's actually the time since the last wait *began*, right? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: Bizzare behaviour of set oracle_sid=mysid
You would be getting the TNS protocol adapter error if the instance hasn't been started -- it is configured to start as a service. Hemant At 08:45 AM 19-12-02 -0800, you wrote: Humm obivioiously Im missing a few brain cells here Yes, I should know there isnt an exe called connect that would be native to the envioriment outside of oracle. Yes, there was a connect.bat in the path Duh... Ok, so lets see how many more vacant brain cells I have now if I log on to sql+ with a dba account (has all privilidges) ### LOCDB SQL connect / as sysdba Or LOCDB SQL connect / internal ERROR: ORA-12560: TNS:protocol adapter error Warning: You are no longer connected to ORACLE. LOCDB SQL select * from global_name; Not connected ### Why does this happen? The bottom line is Im trying to connect as internal w/o the password ### C:\set oracle_sid=LOCDB C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SVRMGR connect internal Password: I can however connect internal/password Thanks for being paitent bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: What Bonnie's benchmark should we expect for RAID 0+1
What is Bonnie's benchmark ? Is it some standard test suite ? Hemant At 08:09 AM 19-12-02 -0800, you wrote: Hello, We have a Compaq AlphaServer 8400 with 8 GB RAM, 8 dual 625mhz CPUs and two HSZ70 Array Controllers. Each Controller is connected to 24 36GB 10K rpm Ultr SCSI disk divers. In the system, some volums are configured as RAID 1, and the others are configured as RAID 0+1 with 3 striping. However, we can't see significant performance improvement in RAID 0+1 volums except random seek. The following are the Bonnie's benchmarks for two kinds of volums: For RAID 1: ---Sequential Output ---Sequential Input-- --Random-- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- MachineMB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU RAID11024 9029 55.1 9108 14.3 8956 15.6 15700 89.4 115531 99.9 2535.2 65.9 For RAID 0+1: ---Sequential Output ---Sequential Input-- --Random-- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- MachineMB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU RAID01 1024 9780 58.8 9872 17.1 14067 25.7 15990 89.7 56037 59.5 5374.3 169.9 Is there something wrong? What Bonnie's benchmark should we expect for RAID 0+1? Thanks, Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: help me find out why rac instance died
Thanks for your suggestion, i checked that article, but still unable to solve the problem. The same time the next day, another instance in the cluster died, with the same reason. ora-29740, still with reason 2. The cluster runs quite stable in the past month(since the patchset is installed, it is just about 30 days). When i check the linux /var/log/messages, i found at the exact same time, syslogd restarted in both node in the two days , when rac instance died. Whould there be some relations between them?Unix did not rebooted ,I checked uptime value. From the trace file, i found it said the dead instance failed to transfer heart beat: first day, from the alive instace rac1: *** 2002-12-21 04:01:54.227 kjxgrnbrisalive: (1, 2) not beating, HB: 479418910, 479418910 *** 2002-12-21 04:01:54.239 kjxgrnbrdead: Detected death of 1, initiating reconfig kjxgrrcfgchk: Initiating reconfig, reason 2 *** 2002-12-21 04:01:59.256 kjxgmrcfg: Reconfiguration started, reason 2 kjxgmcs: Setting state to 6 0. *** 2002-12-21 04:01:59.258 Name Service frozen kjxgmcs: Setting state to 6 1. from the trace file of the second day, from the alive instance rac2: *** 2002-12-22 04:01:56.457 kjxgrnbrisalive: (0, 1) not beating, HB: 479438832, 479438832 *** 2002-12-22 04:01:56.457 kjxgrnbrdead: Detected death of 0, initiating reconfig kjxgrrcfgchk: Initiating reconfig, reason 2 *** 2002-12-22 04:02:01.486 kjxgmrcfg: Reconfiguration started, reason 2 kjxgmcs: Setting state to 9 0. *** 2002-12-22 04:02:01.495 Name Service frozen I wonder if anyone here have the experience of dealing with rac system. What shall i check to verify why rac instance failed to update the controlfile. I already enabled event: event=29740 trace name errorstack level 3 in one instance. shall i enable the undocumented parameter _imr_active=false in the system? Hi Chao: THe Instance 2 in your Cluster (rac2) was dead during the fast reconfiguration (Check the reason in the alert log file.. which says reason 2). You generally do a reconfig (or fast reconfig) when you add/remove instances from the Cluster setup, which is not (I hope) in your case. THere are some kernel events to trace the reconfigurations, and an underscore parameter (I think it is _imr_active !) to disable the 29740 usually not recommended. For investigation , review the check point, LMON trace files and check the OS log files. Best Regards, K Gopalakrishnan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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).
6i FormServer socket or http
We have apps 11.5.6 and FS 6i patch 8 (6.0.8.17.1) and we have been using mode=socket because Oracle recommended that. Now we have another Oracle support guy suggesting mode=http because we have some users on our WAN in europe who are saying the system is kind of slow. Oracle says switching to http mode will make the WAN users much happier. Does anyone have any recommendations before we start testing? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: tony ynot INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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).
VB Objectives needed please !
I am facing lot of difficulties with out VB objective questions and Answers and oracle objective questions and Answers.Can any one help me by sending it Its my humble request Regards, [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: guess who INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: Happy Holidays
But how long did it take to wrap??? :-) [EMAIL PROTECTED] 21/12/2002 0:03:50 This message has been scanned by MAILSweeper. Speaking of house ... Congratulations !! Yesterday my wife and I celebrated our 5th wedding anniversary. I was looking for what gift to give on a 5th anniversary. So my boss googled for a while and said ... he found the gift and a nice gift as well. He says, traditional gift is wood, so just give your wife the house you built. That was easy ... no shopping involved and she already loves the gift. Happy Holidays everyone !! 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! -Original Message- Sent: Thursday, December 19, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Well I've got another excuse. We just moved into our newly constructed house. I tell the kids that they get their own room for Christmas and they just say, Oh Dad! So even though we're still living out of boxes I have to got get more junk and put it in fancier boxes... very strange. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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).
Indentifying Redundant Indexes
Dear List, Firstly - Merry Christmas to those who have not already departed for the holiday season. I'm currently doing some investigation based around indexes and would like everyone's opinion: What is everyone's preferred approach to identify redundant (as in never used by Oracle) indexes? I believe Oracle 9 might have a feature to set a flag on objects and then check back later to see if they have been accessed however we're still stuck on 8.1.7.4 (Solaris). Some of my thoughts include: * Can query for physical disk i/o at a tablespace level easily, however more difficult to go to an object level. * Could create a trace file and then inspect explain plans for existence of index accesses, however trace file probably not practical to capture for a long period of time. * Ideal statistic would be something along the lines of index x used y times in last 24 hours, however a simple index x was used in the last 24 hours would be ok. Obviously we are searching for indexes to remove and identifying those which aren't queried over a set period of time would be good candidates for a starting point. Any advice you might have would be greatly appreciated. Regards, Mark. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: Out of topic -Unx question
Not easily done in Unix. However, if you've got an Oracle db running on the same server you might want to get yesterday's date from Oracle (within a shell script). ... ... YESTERDAY=`sqlplus -s / -EOF set head off feed off pages 0 select trunc(sysdate - 1) from dual; exit EOF` echo YESTERDAY is $YESTERDAY ... ... hth, Ross -Original Message- Sent: Saturday, 21 December 2002 7:51 To: Multiple recipients of list ORACLE-L Hi All, I want to get previous date from today's date.Is there any cmd for this. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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.net -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: Indentifying Redundant Indexes
Mark, The way we do it is by what you might call extreme brute force: 1. Capture all SQL from the applications (not just the stuff you've run in the past month, but the stuff you'll run in the future too, like period-end close processes, and so on). 2. Generate execution plans in production for all this SQL. Store the plans. 3. In a structural replica system (that is, a full-schema test instance; you don't need real application data, but you do need schema and db statistics imported from the production system), drop the index. 4. Generate execution plans on the replica system for all the SQL. Store the plans. 5. Compare the two sets of plans from steps 2 and 4. 6. Decide whether the different in 4 that are different from the plans in 2 are better or worse than the plans in 2. Like I said, it's a big hammer method, but it has its reliability advantages, and the only step that we haven't automated is #6. (I'm assuming that you already have a valid test system as described in #3.) The tool we use that does steps 2, 4, and 5 is called Project Laredo (www.hotsos.com/products/laredo). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Richard Sent: Sunday, December 22, 2002 10:54 PM To: Multiple recipients of list ORACLE-L Dear List, Firstly - Merry Christmas to those who have not already departed for the holiday season. I'm currently doing some investigation based around indexes and would like everyone's opinion: What is everyone's preferred approach to identify redundant (as in never used by Oracle) indexes? I believe Oracle 9 might have a feature to set a flag on objects and then check back later to see if they have been accessed however we're still stuck on 8.1.7.4 (Solaris). Some of my thoughts include: * Can query for physical disk i/o at a tablespace level easily, however more difficult to go to an object level. * Could create a trace file and then inspect explain plans for existence of index accesses, however trace file probably not practical to capture for a long period of time. * Ideal statistic would be something along the lines of index x used y times in last 24 hours, however a simple index x was used in the last 24 hours would be ok. Obviously we are searching for indexes to remove and identifying those which aren't queried over a set period of time would be good candidates for a starting point. Any advice you might have would be greatly appreciated. Regards, Mark. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: Out of topic -Unx question
Search the archive of this list. This has been discussed before. You can use a trick such as this: yesterday=$(TZ=EST26EDT date +%a) but beaware that this is not a portable solution. You can write your own script. E-mail me off line and I can send you mine yesterday script. -Original Message- Sent: Monday, December 23, 2002 12:09 AM To: Multiple recipients of list ORACLE-L Not easily done in Unix. However, if you've got an Oracle db running on the same server you might want to get yesterday's date from Oracle (within a shell script). ... ... YESTERDAY=`sqlplus -s / -EOF set head off feed off pages 0 select trunc(sysdate - 1) from dual; exit EOF` echo YESTERDAY is $YESTERDAY ... ... hth, Ross -Original Message- Sent: Saturday, 21 December 2002 7:51 To: Multiple recipients of list ORACLE-L Hi All, I want to get previous date from today's date.Is there any cmd for this. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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.net -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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: RE: help me find out why rac instance died
Thanks for friends, I found the reason of my rac down.There is a cron that runs daily to sync the time with the time server. My sa added it without telling me. And if i set the time back in one node, the instance on another node went down, with the same trace information. I tested it today. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(ChinaOracle User Group) === 2002-12-23 00:38:00 ,you wrote£º=== Thanks for your suggestion, i checked that article, but still unable to solve the problem. The same time the next day, another instance in the cluster died, with the same reason. ora-29740, still with reason 2. The cluster runs quite stable in the past month(since the patchset is installed, it is just about 30 days). When i check the linux /var/log/messages, i found at the exact same time, syslogd restarted in both node in the two days , when rac instance died. Whould there be some relations between them?Unix did not rebooted ,I checked uptime value. From the trace file, i found it said the dead instance failed to transfer heart beat: first day, from the alive instace rac1: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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).
echo `date`
Dear List, I have Korn shell Script that show the date of execution. echo `date` - Start shutdown of oracle DB. Could any body tell me how to display this char ` the quotation for date. I mean which key I have to press in Unix to get this quotation character. I'm working with Unixware7.1 Regards, Ashraf __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself 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).