Re: ORA-12500

hi rajesh, i also face the same problem on AIX OS based machine, at that time ora-12500 error was b'cze of no. of OS process execeded from users no. of process limit, after increase the limit it's solved. may be it will be helpful for u. Vijay --- "Danisment Gazi Unal (Unal Bilisim)" <[EMAIL PR

orapwd - osoper help needed

> My goal is to have Oracle user JOHNQPUBLIC bounce a database from the > local host or remotely. Any UNIX account for that user would NOT be part > of the DBA group. > > I performed the following steps: > > orapwd file=$ORACLE_HOME/dbs/orapwXXX password=YYY > $ ls -l > -rwSr- 1 oracle d

Oracle communication errors

  We have many NT servers communicating with our Oracle 8 database (running on a SUN platform). The traffic is Net8 traffic, specifically SQL traffic over TNS over TCP (I was told).   When we do sniffer traces of converations with our Oracle database server, we notice that on a regular basis

RE: Oracle's pricing

so much of venting goin around here Why dont we folks (who get their paychecks for hving oracle db skills) instead of praising/*#@^ Oracle for its pricing start sending CC's for each "pricing rant" mail to larry/oracle marketing/oracle sales. Or write an open letter to larry. something to vent

RE: Oracle's pricing

Well that is very true but I feel its within my contract to kill them all off. Only a few left to go. Isn't that why they pay me the big bucks? -Original Message- Sent: Wednesday, April 25, 2001 2:25 PM To: Kimberly Smith; Multiple recipients of list ORACLE-L Kimberly, I'd whole

(Fwd) RE: Oracle Application Development Tools - Statement of

--- Forwarded message follows --- Date sent: Wed, 25 Apr 2001 13:57:43 -0800 T o : Multiple recipients of list ODTUG-DEV2K-L F r o m : "Openshaw, Michael" <[EMAIL PROTECTED]> Thanks for a little clarity, Bill; even if it's overloaded with Marketing-speak. Of course, this i

Re:Oracle's pricing

Kimberly, I'd whole heartedly agree with you, except that there are a lot of Pointy Haired ones (Dilburt style managers) out here who do look at that one item first. Dick Goulet Some mistakes are too much fun to only make once. Reply Separator Author:

OT: Reading the Oracle Tea Leaves

I foresee the database being sold as a turn key product configured by Oracle at a reduced price. In order to receive the discount the purchaser would have to agree not to mess with the init.ora parameters, nor take any action which would enable or disable any database options. "What?!, not c

RE: Script for reversing a string? - FYI

FYI: Apparently the reverse function exists in SQL Plus but not in PL/SQL (I couldn't compile a function that referenced it). utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK'))) worked perfectly though. -Original Message- Sent: Tuesday, March 13, 2001 3:46 AM To: Mul

Re: Oracle's pricing

I don't think your far from the mark. SQL Server is cheaper and on paper functionally equivalent to Oracle. But, for implementations of over 25 users you must buy a processor license for SQL Server, a license for which there is no upgrade path. So when MS pushes out "SQL Server 2000" (alrea

RE: MTS

It is a good idea, becuase you'll save a lot of memory. -Original Message- Sent: Wednesday, April 25, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi all! Oracle 8.1.7 EE on AIX. We have several hundred user which connect to the database in OLTP mode. I'm wondering is it goo

RE: RE: Oracle vs DB2

I agree, MySQL is a good way to start out. That's what we did here. It's fast and free. Our product runs with MySQL, SQL Server, and Oracle. The MySQL version allows us to sell to companies that want to use our product but could never afford an Oracle license. But, when it comes to larger compani

CPU/Parse Time Reported by SQL Trace

While working on application performance issues, I noticed significant discrepancy in time reported by SQL Trace and actual time taken by the application. Total Elapsed time reported by SQL Trace was 180 seconds, but it took 500 seconds to run it. (It was a PL/SQL procedure. I just measured the

Solaris Tuning

I am about to install Oracle 8i on an Ultra 10 with 2 9Gb Dirves and 512Mb ram runing Solaris 8. This will be for some very small development databases. Any tuning tips for Solaris or Oracle I should be aware of? Thanks Daniel Curry IT/Systems Adminstator [EMAIL PROTECTED] åy«±ç

Database and System Throughput

I have been tasked with gathering statistics which will detail the throughput on our Database Servers. In addition to 'performance' metrics, I am looking for scripts/commands in both the database and on unix (solaris) which will show me my system's potential. Things like 'io per hour', 'transact

Re: REP: Locally Managed Tablespaces

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

RE: Perl DBA Tools

If you are keeping any kind of statistics on connections using the listener.log, you have the potential of missing records between the time you copy it and empty it to /dev/null.  With my method, you won't loose any records.  The choice is yours.   HTH, John >>> [EMAIL PROTECTED] 04/25/01 12:

Re: Perl DBA Tools

Hi, well, what we are actually using right now is this: (Korn Shell): create 2 named pipes. create a sql*plus and redirect input/output to the pipes. have monitoring scripts sending sql requests to the input pipe. have reporting scripts reading the output from the output pipe. I tried to start

RE: Re[2]: Oracle vs DB2

I guess they can make their money by targeting the high end and having a few high paying customers, or be more reasonable and have a broader base. I get the feeling that Larry's ego (psychoanalysis from a distance, ain't it wonderful) would drive him to both the $ and the broad base. If you are co

RE: spool command: echo not work

You can't test the spool that way. Make a file of commands containing the following set echo off set hea off spool test.sql select sysdate from dual; spool off exit Now go into sqlplus and connect then execute the script by issuing the following command. This assumes that the above commands wer

Oracle's pricing

I find a lot of the discussions about Oracle's pricing be too much when not taking into account anything else way to funny. First off, yes I could get SQL Server for a whole lot less then Oracle but I sure would not be able to run the fab on it. You simply can't compare one thing to another thing

RE: running oidadmin

The "sl" file is in the "admin" directory? Shouldn't it be in the "lib" dir? Also, I thought that the LD_LIBRARY_PATH env var needed to include $ORACLE_HOME/network/lib dir. HTH! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inte

RE: memory

Kev, What exactly do you mean by "all hell breaks loose."? Is there a specific error? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Hi all, I have a developer running a procedure th

RE: Temorary tablespace problem

could be concurrent multiple sort operations... -Original Message- Sent: Wednesday, April 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema _

Statspack

While trying to understand the Statspack reports I read in a doc published by ORACLE 'If the average time per read in the IO sections is large, and the OS statistics indicate high service times or queue lengths, there is an IO problem'. My question is since large is a relative term how do I kn

Off Topic: OracleTuning.com call for papers

Greeting List, OracleTuning.com is a free Oracle Fan and Resource site. If you submit an article, script or whitepaper and we publish it on our site you will be listed as a contributor. Additionally, you will have the option of loading a personal web page on the site where you can detail your ba

Re:OT RE: HYPER VOLUMES - RE: "Never split index and data fi

Vena Babe Rules!!! > -- 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

No Subject

Hi List, How cleanup temporary segment temporary locally managed tablespace ? Thanks Alessandro -- 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

RE: spool command: echo not work

Greg - When I'm doing this sort of thing I run the following: set echo off termout off heading off verify off feedback off newpage none set echo - controls whether or not the command is displayed when the command is run by START or @ set termout - controls whether or not the output is displayed

(Fwd) Oracle Application Development Tools - Statement of Dire

--- Forwarded message follows --- Date sent: Wed, 25 Apr 2001 12:25:47 -0800 T o : Multiple recipients of list ODTUG-DEV2K-L F r o m : "William Dwight" < w i l l i a m . d w i g h t @ o r a c l e . c o m > > Oracle Application Development Tools > > Statement of Direction,

RE: memory

Jeez it took all day for that to get out! No, it would just suck up 100 percent of both processors and then a gig of ram. Figured out what it was, one of the developers had sort of an infinite loop in his code. A beleive it was a procedure that kept calling itself, all fixed now. But what I do

Re: ORA-12500

Hi, ora-12500 is not a good error to diagnose. is there any error in alert.log ? Rajesh Dayal wrote: > Hi All, > I have seen the error-manual for above > Error message, but it really doesn't state anything > clearly. > Env is Oracle 8.0.5 on NT 4.0. This problem > is not per

Re: cdump, bdump, udump

With the alert.log you are incorrect. Oracle only get a handle on the file when it writes to it. The rest of the time, it does not need nor keep a handle on the alert.log. You can move or delete the file and neither Oracle nor the OS care. A new alert.log will be created as soon as Oracle n

RE: Oracle vs DB2 - Oracle lost on cost

The client I work for (for the next 2 weeks at least) just made the decision to use UDB over Oracle due to the price of licenses from Oracle. And this is a startup with a big ol' pile of capital. Go figure, I thought startup's always picked the most expensive stuff. They must be saving on the DB

Re: Physical Data Layout

Hi, I think, "don't use RAID for..." is not a good approach. If there is no IO related wait event or there is no huge CPU cycles for software raids, it's not a problem to use RAID or not to use. There is an excellent paper of Carry Millsap who is a philosopher of Oracle+ComputerSciences. You ca

Re: Physical Data Layout

Without trying to offend anyone, I personally believe that any recommendation about "data", "indexes", "temp" being separate is missing the original point about what is actually being sought after - namely, even distribution of IO across all of the disks. All of the current theories (SAME, data s

RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b

May I ask, just what type of restrictions do you envision when the database software is made available at a reduced cost? - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] > Sent: Wedne

RE: Oracle vs DB2

This sorta reminds me of the "answer" I got when I asked why Oracle thought that they deserved all the extra money they were going to get from increasing annual support costs during the Oracle6 -> Oracle7 days (aprx. 50% increase each year for at least a couple of years). Oracle said that "someo

RE: Oracle vs DB2

|| When I asked my salescritter about this he said "Well we || sure are selling alot of licenses" - Go figure... LoL...you know what I think? I think there was an INTERNAL memo circulated around Oracle sales that basically acknowledged the problem, and decided that DAMAGE CONTROL would be to giv

Re: Listener.log

reboot listener with LSNRCTL |+> || "Ruth Gramolini" | || <[EMAIL PROTECTED]| || ate.vt.us>| ||| || 04/24/01 01:55 PM | || Pleas

FW: REP: Locally Managed Tablespaces

I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. -- Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the

Multimaster Replication setup

Hi I am trying to setup multimaster replication environment. I have two machines. On on windows NT and one on linux. I followed all the steps listed in oracle8i Api reference manuals till chapter 3. But when I update emp table. It corresponding updations are not reflected in second database. Can

RE: Oracle vs DB2

Greetings Friends in California! If you felt the earth shake, don't worry. It's not an earth quake, it just Larry Ellison's reaction to the IBM-Informix deal. The man needs to spend a lot less time picking fights with Bill and a lot more time paying attention to his market, and from being end-ru

monitoring listener.log

Title: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicat

MTS

Hi all! Oracle 8.1.7 EE on AIX. We have several hundred user which connect to the database in OLTP mode. I'm wondering is it good idea to configure MTS in such conditions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehov

FW: REP: Locally Managed Tablespaces

I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. -- Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the

Re: Physical Data Layout

Hi, I'm also looking for RAID / SAN / NAS technology used with databases. Do you know any recommended readings ? Saumya99 schrieb: > > Hi Chris, > The concern is the putting datafile on RAID system. Oracle documentation > recommends not to put datafiles on RAID because reading from a RAID devic

RE: spool command: echo not work

Thanks all for replay. I knew echo should work, but for some reason it does not. SQL> set echo off SQL> set hea off SQL> spool test.sql SQL> select sysdate from dual; 25-APR-01 SQL> spool off SQL> !more test.sql SQL> select sysdate from dual; 25-APR-01 SQL> spool off Any ideas? Thanks. Greg.

Re: cdump, bdump, udump

I tend to agree with you. I feel MUCH more comfortable reading paper. Terry [EMAIL PROTECTED] wrote: > Wow. I feel just the opposite. When I had the paper docs, I could > take one on the train, take it home, know what I read, feel like > I'd accomplished something when I'd read a chunk, etc. I

RE: DBA_FREE_SPACE - Problem gone

Well, this makes me really uncomfortable but the problem went away by itself. Dba_free_space is now showing the correct free space. -Original Message- Sent: Monday, April 23, 2001 5:19 PM To: Multiple recipients of list ORACLE-L One of the other DBAs here called me over to look at a we

RE: Oracle vs DB2

You are absolutely correct. Oracle's getting this price because they can. I wonder how much market share they will lose before Larry switches things around? When I asked my salescritter about this he said "Well we sure are selling alot of licenses" - Go figure... Thanks, Frank -Original Mes

Re: cdump, bdump, udump

It seems to work different for me. For the last 2 years, I have been deleting the old file and a new one appears with the very next message to be written. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipien

memory

Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's

RE: Anyone using Peoplesoft Financials 7.x on Oracle 8.0.x?

Hi Nuno, I'm new to the wonderful world of PeopleSoft, so I probably can't provide much insight. Why keep the discussion off list? Keeping it on the list helps us other newbies and allows the more experienced PS DBAs (Dick et al) a chance to comment on any replies you get. Just my 2 cents Mik

RE: Listener.log

Thank you, John. The best solution.   Vadim -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 7:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.log For those of you who did not see my response in the thread of

RE: cdump, bdump, udump

Yep, Oracle just keeps on chugging along. When it needs to write to the alert log it will create a new one if it needs to. On Wed, 25 Apr 2001, Ron Rogers wrote: > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the >database up and running, the oracle still thi

Column positionning in the table

Hi, I just want to make sure of something, since with Oracle 8i, some old habits are no longer needed. On Oracle 816 is the position of a column in a table important ? A lot of tables will change and most of the PK also. I will test the drop column a lot ;-) and I'll add some fields who will n

Re:RE: Oracle vs DB2

true, but when cost is the decisive factor w/ a startup, go with the one of the freebies. if the company was too cheap to buy the right product, time to find a company w/ deeper pockets. now w/ ibm buying informix, merging w/ db2, they will have a new product called db4mix :). the free db's

RE: Perl DBA Tools

Can I have these scripts if possible. Please post it on the list or e-mail it to [EMAIL PROTECTED] Alex hillman -Original Message- Sent: Wednesday, April 25, 2001 10:49 AM To: Multiple recipients of list ORACLE-L Hi Jared, A few things we use Perl for: - watchfs.pl This thing monito

Re: Temorary tablespace problem

Someone may be doing a large sort. RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 1:30 PM > Hi > Today I have seen thats the Temporary tablespace growth in my database is > high.What could be reasons? > Thanks > -S

running oidadmin

Title: running oidadmin I'm having problems getting the OID admin (v2.0.6) utility to run under hp-ux 11. When I try to start it, it get a java error no nldapj8 in shared library path The libnldapj8.sl file is in $ORACLE_HOME/network/admin and   this directory is in the $SHLIB_PATH envi

RE: cdump, bdump, udump

Nope. That's the way the listener.log works, but the alert log will be recreated if deleted or moved. -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the d

Virtual circuits

I just switched on of my databases to MTS and noticed I have a 75% miss rate when looking at the virtual circuit latches. Anyone dealt with this before and have any suggestions? Thanks, Dave Turner -- And you thought James B

RE: REP: Locally Managed Tablespaces

Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the tablespace will adere to those extent sizes no matter what you specifiy in the INITIAL storage parameter. I have a LMT already created with a UNIFORM extent size of 128k:

Buffer busy waits -- p3=1012 and 1016

Hi list,I'm analyzing parameter "p3" from trace 10046 level 8 and I've got some doubts about it.What is the difference between p3=1012 and p3=1016?According to some docs I've read, 1012="A modification is happening on a XCUR (or SCUR)buffer and it has not yet completed" (and I think thatthe

Re: Perl DBA Tools

Hi Jared, A few things we use Perl for: - watchfs.pl This thing monitors db related file systems and alerts (via our NOC) if thresholds are exceeded. Thresholds managed in dynamic config file. - process_ora_trace.pl A one off that helped us w/a vendor. Takes trace output files for a databas

RE: REP: Locally Managed Tablespaces

And what is x$ktfbue and how it is maintained if there is no info in data dictionary? Alex Hillman -Original Message- Sent: Tuesday, April 24, 2001 9:20 PM To: Multiple recipients of list ORACLE-L On Tuesday 24 April 2001 14:24, Henry Poras wrote: > Isn't it also in sys.uet$? Oops, tha

RE: Re[2]: Oracle vs DB2

I too would love to see somebody give Oracle a reality check in regards to the prices of their software, but as much as I hate to say it, I just don't see it happening. Why? Because the ONLY reality check that Oracle is going to actually LISTEN to and do something about would be for people to st

ORA-12500

Hi All, I have seen the error-manual for above Error message, but it really doesn't state anything clearly. Env is Oracle 8.0.5 on NT 4.0. This problem is not persistent and it comes intermittently. And it has come when I try to shutdown a Production through an automated scr

Re:RE: Oracle vs DB2

So isn't PostGres, but neither is a close competitor. Reply Separator Author: "Gene Sais" <[EMAIL PROTECTED]> Date: 4/24/2001 1:28 PM hmmm, mysql is free, best price of all. >>> [EMAIL PROTECTED] 04/24/01 04:27PM >>> At 10:46 AM 4/24/01 -0800, you w

RE: ORA-04030

Title: RE: ORA-04030 Hi All ! Thanks for help, I think i solve the problem, but I don't understand why it began work. I increased size if shared poll up to 100MB, but part of script doesn''t began work in SQL Plus but it starts work in SQL Navigator!!! So I run whole script in svrmgrl and

RE: REP: Locally Managed Tablespaces

Thanks Mark. -Original Message- Sent: Wednesday, April 25, 2001 12:56 PM To: Multiple recipients of list ORACLE-L I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. -- R

RE: cdump, bdump, udump

Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and e

This maybe interesting

TO ALL, I got the following in my daily copy of the Air Force News. It may be of interest to the group as a whole, since this if Oracle's HR application that's getting deployed, around the world. I hope at lease one person on the list is associated with this deployment as the tuning implica

RE: sort_area_size + temp tablespace extent sizing

Hi Luc, It depends on the size of your sorts. You can check the extents column in v$sort_usage, if it's always bigger than 1, it means the extent size is too small. --- "DEMANCHE Luc (Cetelem)" <[EMAIL PROTECTED]> a écrit : > Stephane, > > What situation would make you choose a certain value

Temorary tablespace problem

Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: ht

RE: This maybe interesting

I'll actually be a customer of the system, but unfortunately don't know a whole lot about it's implementation or tuning or anything like that. The system I maintain will have an interface to this new system so that we can keep our system updated with real-time information from their system throug

RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b

The most interesting part of the gaurantee is the proscription against customization. Ellison, at last year's OOW in San Franciso, spoke about the problem of supporting so many different configurations. I suspect the CRM offer is only the start, and that Oracle will eventually offer their da

Re: Physical Data Layout

Hi, I will recommend a combination of RAID 1 and RAID 0 over RAID 5 or other RAID's. Offcourse reading is slower but writing is faster. From your given information, I can see that I/O is evenly distributed. Never put archived logs and REDO logs in one disk. same ways index and data should not b

Re: Physical Data Layout

Hi, I will recommend a combination of RAID 1 and RAID 0 over RAID 5 or other RAID's. Offcourse reading is slower but writing is faster. From your given information, I can see that I/O is evenly distributed. Never put archived logs and REDO logs in one disk. same ways index and data should not b

Re: set dml_lock value without bouncing db?

dml_locks is not modifiable with and alter system or alter session command. You can check parameter for these attributes from v$parameter. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 1:35 AM > What was you

RE: Oracle vs DB2

We run our web servers on Oracle Standard Edition. 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

Re[2]: Oracle vs DB2

Tim, Thanks for the copy of the marketing speil, I had not heard that one before. But, I'll take great exception to the claim that: "It would make sense to select a database product based on price alone if database products were the predominant part of the overall information technology ex

async I/O with DB writer and LOG writer

Dear list,   I recently discussed the effect of using async I/O with DB writer and LOG writer with someone, I was told that async I/O is more beneficial to DB writer than LOG writer, what is your opinion?? Can the difference be quantify??  I thought aysnc I/O with DB writer can be compensa

RE: ORA-04030

Title: RE: ORA-04030 Thanks for response!! But I still have a problem.   I'm tring to install Advanced Replication Option on database. It fails on creating of package body. It was working on another  computer with same configuration (Oracle 8.1.7 and 128 MB) but it have Windows  NT on it.

Re: Listener.log

Hello,   Thank you very much for your responses. What i wanted to do was compressing the listener.log. It works fine as below : cp listener.log listener.log.$(date +%y%d%m) cat /dev/null > listener.log compress listener.log.$(date +%y%d%m)   Regards,   Nguyen Thanh-truc - Original Mes

RE: Perl DBA Tools

John,   Im my script for managing the listener.log, I copy the listener to an archive area and then cat /dev/null to to current one. Will this have the same effect as moving as in your example ? Do I need also to force the listener to point to a different log file ?   Maybe I need to test so

RE: sort_area_size + temp tablespace extent sizing

Hi Ade and list, This is folk lore. Please see http://www.ixora.com.au/q+a/0103/27075321.htm for the explanation. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 25 April 2001 1:01 To: Multiple recipients

Re: cdump, bdump, udump

Sinardy, I don't know if you've got access to Metalink, so why don't you go to the following URL: http://otn.oracle.com/index.html If you click on the membership link at the top right portion of the page, follow the instructions to sign up. It's free, they've never spammed me, and I ha

Re: Physical Data Layout

Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here.