SQLPLUS on UNIX

Dear Friends, ed command in SQLPLUS( on UNIX ports )not working. I hope there is some EDITOR setting to use VI editor, but forgot where to do that. Can somebody give a thought. Thanks Rajuveera ** This email (including any

RE: SQLPLUS on UNIX

Hi Rajuveera, Put these two lines in your .profile EDITOR=vi export EDITOR HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Saturday, September 13, 2003 11:09 AM To: Multiple recipients of list

RE: SQLPLUS on UNIX

Ave ! Set environment variable EDITOR=vi Br.Jorma -Original Message- Sent: 13 September, 2003 10:09 To: Multiple recipients of list ORACLE-L Dear Friends, ed command in SQLPLUS( on UNIX ports )not working. I hope there is some EDITOR setting to use VI editor, but forgot where to do

Re: SQLPLUS on UNIX

Rajesh, On the SQL*Plus prompt type the follwoing define _editor = vi Note the underscore before editor. This will make the editor vi for the SQL*Plus session. To make it permanent, put the line in $ORACLE_HOME/sqlplus/admin/glogin.sql, so that it will be executed evey time the SQL*Plus

RE: _cpu_count vs cpu_count

_cpu_count As per metalink, meant for those exceptional Operating Systems, where OS does not support a system call so that Oracle can get the number itself. So normally this value is not required to be set by DBAs. You have to set this when cpu_count is not showing the actual number of CPUs.

RE: SQLPLUS on UNIX

define _editor=vi Keep the above statement in login.sql / glogin.sql -Original Message- Sent: Saturday, September 13, 2003 2:09 AM To: Multiple recipients of list ORACLE-L Dear Friends, ed command in SQLPLUS( on UNIX ports )not working. I hope there is some EDITOR setting to use VI

Re: 9.2.0.4 anyone

Hi! Which platform is it? I checked on one 4CPU Linux server with 160MB shared pool it defaulted to 1. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 13, 2003 1:49 AM On the 9.2.0.3 databases I checked, it is 3.

RE: SQLPLUS on UNIX

Thanks for all your responces... -- From: Veeraraju_Mareddi Reply To: [EMAIL PROTECTED] Sent: Saturday, September 13, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: SQLPLUS on UNIX Dear Friends, ed command in SQLPLUS( on UNIX ports

Chris Date Edinburgh seminar for Oracle World Paris attendees

For those of you who plan to attend Oracle World in Paris and might be tempted by the Chris Date seminar in Edinburgh on October 24th : http://www.ebookers.com/compagnies/bd/bmi.html?VERSION=FRLANG=FRCURRENCY=EURCOM=Flash030912 (I received this _after_ having booked :-() Won't go to Oracle

Re: Trapping of Rogue Statement

Title: Re: Trapping of Rogue Statement If using 9i, you can use DBMS_FGA for fine-grain auditing. Another way (for any version) is to search V$SQLTEXT for that phrase in an UPDATE statement, record the hash value of the SQL statement, and then use that hash value to search V$OPEN_CURSOR to

Re: How to speed up index creation

Tanel, Tried it out -- I stand corrected! Thanks for the heads up! -Tim on 9/8/03 9:14 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Tim, AFAIK, when doing a rebuild the whole index is read using fast full scan, the branch blocks are just ignored. And sorting does occur, since fast full

Re: db_file_multiblock_read_count

There is a MetaLink article #131530.1 on the constant SSTIOMAX which may provide some interesting reading on this topic surround max I/O size and the setting of DBFMRC. The article is over 2 years old -- not sure if it pertains to 9i or above... Wolfgang, please let us know how those 8-byte

Re: How to speed up index creation

This is nothing compared to your work's contribution to my knowledge, but you're welcome, any time :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 13, 2003 6:49 PM Tanel, Tried it out -- I stand corrected! Thanks

Re: ora 1575?

I'm very sorry. By some error I never got this message sent. So here it is, over a month too late. Fantastic... Mogens == Ah, good to be back online with Tim Gorman on the old and wonderful 1575. 1575 was introduced in 7.1. Not as an

Re: db_file_multiblock_read_count

How can we find the value of SSTIOMAX ?(What is it for 9i ?) Thanks, Ravi. --- Tim Gorman [EMAIL PROTECTED] wrote: There is a MetaLink article #131530.1 on the constant SSTIOMAX which may provide some interesting reading on this topic surround max I/O size and the setting of DBFMRC. The

Re: db_file_multiblock_read_count

I've performed nm -o oracle and strings -a oracle on the Oracle executable, searching for the phrase sstiomax to no avail. To me, that implies that SSTIOMAX is not a variable in the C program that is Oracle. Instead, by C programmer conventions, any name expressed in all upper-case would most

Re: db_file_multiblock_read_count

Great. Can keep lots of blocks in the buffer pool. Hit ratio is at 110% Try it out some time. At 07:49 AM 9/13/2003 -0800, you wrote: Wolfgang, please let us know how those 8-byte database blocks work for you, OK? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com --

Re: ora 1575?

information without value - there are so many things I haven't seen yet, like lizards playing chess or Cary taking a quick shower). oh the questions and thoughts this brings to mind! as in: has Mogens SEEN Cary taking a shower? or does he infer that Cary takes long showers by the amount of

Re: db_file_multiblock_read_count

Another member of this list was once (possibly still is?) responsible for an application with a database whose DB_BLOCK_SIZE was set to 4608. Mind you, it was most certainly not their choice, but instead was mandated by the vendor. The reasoning for the setting? A very important table in this

Re: db_file_multiblock_read_count

Connor rules. Tim Gorman wrote: I've performed nm -o oracle and strings -a oracle on the Oracle executable, searching for the phrase sstiomax to no avail. To me, that implies that SSTIOMAX is not a variable in the C program that is Oracle. Instead, by C programmer conventions, any name

Re: ora 1575?

Well, no I haven't seen him actually take a shower, but one must hope that the sound of running water for 42 minutes followed by silence for another 21 minutes must mean that water has run down Cary and not just down the drain. And although I haven't seen him take the shower, we're many

Re: ora 1575?

Well, regardless of Mr. Millsap's hygiene and the details of how he maintains it, you *have* seen an unretouched photograph of a lizard playing chess, with my son... ...and the lizard was cheating by taking too much time to make his first move and eventually forfeited. Never turn your back on a

RE: 9.2.0.4 anyone

Tru64 5.1A. 12 CPU box. Two different instances on the box. -Original Message- Hi! Which platform is it? I checked on one 4CPU Linux server with 160MB shared pool it defaulted to 1. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen

Checking for code using hints(from database)

Env OPEN VMS ALPHA 7.3 Database 8.1.7.4 Optimizer = Choose Application written for Rule but use of lot of Hints in code. Reason of using cost based optimizer to create/use function based indexes. Selected tables are analyzed as all tablles(except sys) resulted in bad performance. This is the