RE: simple sql problem

Even using like this:- echo select * from v$instance; | sqlplus system/manager gives me the error :- SQL select * from v * ERROR at line 1: ORA-00942: table or view does not exist Though I can do the

RE: simple sql problem

If you are running it on Unix, you must escape the $ in v$instance. thus, you would do echo select * from v\$instance; | sqlplus system/manager Note the \ key before the $. Hemant Viraj Luthra [EMAIL PROTECTED] 04/12/2001 02:50 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L

RE: Message at the start of svrmgrl

Title: RE: Message at the start of svrmgrl What are the new things on oracle 8.1.7.2.1 patch. is't available on oracle downloads...? I'm much interested to know why should apply this patch is it for to rectify some bugs or something else... Rgds, Nirmal -Original

RE: simple sql problem

b'coz you have to type select * from v\$instance; you are passing arguments from shell. You have to escape $ like \$ HTH -Original Message- Sent: Tuesday, December 04, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Even using like this:- echo select * from v$instance; |

Error opening the database

Hi folks, On trying to open one of our development databases today morning, I get the following error : SQL alter database open; alter database open * ERROR at line 1: ORA-00333: redo log read error block 129347 count 1719 The database is 8.1.7 on Solaris and is running in NOARCHIVELOG

RE:simple sql problem

Create a file like sqlplus -s scott/tiger ! select * from emp; ! Then simply execute the file Binay --- Hello all, Why cannot I do :- sqlplus -s scott/tiger select * from emp; or sqlplus -s scott/tiger select * from emp; Both the cases I get :-

buffer busy wait latch free ( cache buffer chain )

In report.txt we are getting the wait buffer busy wait _ wait on latch free for cache buffer chain Could an excessively Large db_block_buffer cause this ? NOTE - Transaction OLTP in nature NOTE - freelists is set = 2* cpu_count Any oher advice ?

Re: buffer busy wait latch free ( cache buffer chain )

What are u seeing the buffer busy waits on is it for the read intensivity and latch free is showing that there are hot blocks why dont you find out the hot blocks and find what can be done about it From: VIVEK_SHARMA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of

RE: What is OAS ?

What do you think the next web server will be called? OWAS OAS IAS AS? I'm betting it will be called either iS or AS. The next one after that will be called just 'S'. Then there will be an application server with no name. Just a dot maybe. Maybe nothing at all. Regards, Patrice Boivin

Re: Error opening the database

first make a backup of the broken database, then try to use the init parameter _allow_resetlogs_corruption= true open the database and make an export. Let me know if you will win :-) by Claudio. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

Does this mean they weren't able to tune the JVM in the database? Pure speculation. We aren't using the JVM here, afaik. Why replace one with the other, when the database engine could hold both! Or install one or the other, at your convenience. Regards, Patrice Boivin Systems Analyst (Oracle

Re: Anybody heard Oracle will remove the JVM from Oracle in

Jared Still wrote: DBI is your friend :-) Now that they've combined svrmgrl into the sqlplus engine there isn't anything you can't do through DBD::Oracle (or the shell if really necessary). Yeah, this has some very cool implications. It would be possible to start and stop your databases

RE: Deleting Oracle8 on NT(cleaning Oracle8)

From: Raghu Kota [EMAIL PROTECTED] Date: Mon, 03 Dec 2001 15:57:04 + Subject: Deleting Oracle8 on NT(cleaning Oracle8) Hi Friends, I need to clean Oracle8 database size 3Gb on one of my NT server, Is it possible that shutdown the database and delete all datafiles and all directories???

RE: Error opening the database

Thanks Claudio.it has subsequently been detected that there is a bad media on the disk.the ufsdump utility confirmed thatit was the disk which was corrupted. We have logged a call with Sun and we might have to swap the whole disk and re-create the file systems. Samir Sarkar Oracle

RE: UTL_FILE_DIR problem

I typically set it to /tmp/oracle/$ORACLE_SID for each db that requires it. Never leave it *. Gene [EMAIL PROTECTED] 12/03/01 07:40AM if I set UTL_FILE_DIR = * would there be any security issue ? In a word yes...this allows read/write access to *all* directories and there is bound to be

RE: SQL Loader Commit Point?

Ken Did you look at the Sql*Loader log file? Maybe all your records were rejected and placed into the .bad file? Does a .bad file exist? Sql*Loader does not really consider rejected records an error - it just moves them there. Hope this helps. Tom Mercadante Oracle Certified Professional

RE: What is OAS ?

Maybe it will be known as the application server formally know as and have slave written all over the documentation -Original Message- Sent: 04 December 2001 12:45 To: Multiple recipients of list ORACLE-L What do you think the next web server will be called? OWAS OAS IAS AS?

Re: Anybody heard Oracle will remove the JVM from Oracle in future

Jared Still wrote: I think they do. Isn't it included now in the 9i version of iAS ? Jared not it the versions i have. but mod_perl is automatically include with the apache install. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED]

RE: rman oddities

Title: RE: rman oddities Yes I am aware of the importance of keeping previous incarnation backups. When I said orphan below I meant an rman datafile that was left out there from a backup that never completed, and therefore didn't register in the catalog. These incomplete rman datafiles are

RE: rman restore arclogs

Title: RE: rman restore & arclogs Lisa, I believe Oracle tries to restore the most recent version of the archivelogs, according to the timestamp in the catalog. But if that's corrupted or not found for whatever reason, you can get it from the other backupset. Jim P.S. Sorry for the vague

OT: perl q

Title: OT: perl q Good morning everyone, I apologize for the OT post. I was looking at the DBI. It suddenly occurred to me that I can only connect to sql*plus with this. I'm not minimizing it's usefulness, but I am wondering if I can use a perl script to fire off the rman backup, scan

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

I think they should also put structured BASIC in the database engine. You never know, it might come in handy. And PASCAL, for those who are just learning Oracle. Assembly for the die-hard database engine programmers out there. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)

Re: Listener

I'm inclined to think that NO ONE can explain it in this medium better than the documentation. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 2:25 AM Hallo, Can anybody tell me simply how the listener works?

RE: Deleting files on w2k

From: Koivu, Lisa [EMAIL PROTECTED] Date: Fri, 30 Nov 2001 14:48:55 -0600 Subject: Deleting files on w2k I'm trying to test out backup and recovery on w2k. However, I can't remove or rename a file while the database is running! It says file in use. Am I missing something or is there a

RE: simple sql problem

Viraj - Your SQL isn't terminated. You need to end your SQL with either a semicolon or a / on the next line. Jared - Thanks for passing along this technique. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 12:35 AM To: Multiple

RE: SQL Loader Commit Point?

I finally got it to work. The book is a great help, but you still need the old trial and error method. Thanks much for your help, Ken -Original Message- Sent: Tuesday, December 04, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject:RE: SQL Loader Commit

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

Basi? What is that? Is it edible? Does anybody except Micros*t do anything with that? -Original Message- Sent: Tuesday, December 04, 2001 9:05 AM To: Multiple recipients of list ORACLE-L futur I think they should also put structured BASIC in the database engine. You never know, it

RE: perl q

Title: OT: perl q You can not connect to SQL*Plus. You can connect to database and do some funky SQL.. As for RMAN and the rest, there are calls like "open","system","fork" (not cutlery) and "exec" that the more perverted among us would use to communicate with the OS. Is the Fairfield

Re: OT: perl q

-- Koivu, Lisa [EMAIL PROTECTED] Good morning everyone, I apologize for the OT post. I was looking at the DBI. It suddenly occurred to me that I can only connect to sql*plus with this. I'm not minimizing it's usefulness, but I am wondering if I can use a perl script to fire off the

RE: What is OAS ?

lol.. or just a ~ Oh what marketing potential! We don't feel a name is cool enough for our application server anymore said Ellison, at a recent IT conference. That is why we chose the stylish ~ sign - hey if Prince can do it, so can we! We truly ARE the cream of the RDBMS market! You never

RE: Error opening the database

Hi Rao, My database is running in NOARCHIVELOG mode. Would it still be possible for me to issue the 'recover database until cancel' command ?? I understand that this command applies all the archived logsbut since I do not have any archived logs, how will the database perform recovery ??

Re: Audit vs Logminer

I have used LogMiner once, and I was quite surprised at the Redo Log details. For example, all SQL that does not modify the database will not be captured into the Redo Log file. (eg, SELECT statement). But Auditing definitely can capture all these. Similarly if you issue the same update

Re: Listener

Oracle Networking Guide at http://technet.oracle.com [EMAIL PROTECTED] wrote: Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S _ Do You Yahoo!? Get your free @yahoo.com address at

RE: perl q

Title: RE: perl q Hi Mladen, thanks. An illustrious friend of mine also reminded me of that famous backtick operator. No. If you are thinking of Fairfield Inns, I work for a different company. Fairfield Resorts has offices in Las Vegas, Little Rock gag, Orlando and here in Ft. Lauderdale.

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

The Commodore PET used to run on ROM BASIC. Aah, the lovely green monochrome. We used to poke the ROM, and we could make the screen look like a glass of pop, with bubbles running upward. Ok, time for the OT listserv... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)

Re: simple sql problem

From the unix command line you can run: sqlplus -s scott/tiger EOF select * from emp; EOF Viraj Luthra wrote: Hello all, Why cannot I do :- sqlplus -s scott/tiger select * from emp; or sqlplus -s scott/tiger select * from emp; Both the cases I get :- Usage: SQLPLUS [option]

Re: Question on dba_ts_quotas

Thanks Jared and others who replied. Best regards, Prasad Jared.Still@r

Export question - appending date to dmp file

Hello All, I am trying to append date to dmp file while exporting it , no luck any ideas.. exp userid=user/passwd imp file=EXPDATA$DATE.dmp (I need to have system date and if possible time (TIMESTAMP ) appended to it .) TIA Cheers RK

Oracle OpenWorld dispatches

The first of my OpenWorld dispatches is up, and you can read it at: http://oracle.oreilly.com/news/openworld_day1_1201.html. It covers Sunday, which is a light day. My dispatch covering Monday should be up later today, and you'll be able to navigate to it from the same URL. Best regards,

RE: simple sql problem

As Scott said, in Unix you can use Input Redirection. If you are in windows, you could always build the command as a .sql file and use the sqlplus -s scott/tiger @myfile.sql Command. -Original Message- Sent: Tuesday, December 04, 2001 10:01 AM To: Multiple recipients of list ORACLE-L

RE: Error opening the database

Hi Rao, I tried the steps u mentioned. I get the following errors : SVRMGR recover database until cancel; ORA-00279: change 3412601 generated at 11/30/2001 09:43:43 needed for thread 1 ORA-00289: suggestion : /usr/local/oracle/admin/sid1/archive/60_0001.arc ORA-00280: change 3412601

RE: Listener

Bubba, Wow! That was a GREAT explanation! -Barbie -Original Message- Oracle Networking Guide at http://technet.oracle.com [EMAIL PROTECTED] wrote: Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S -- Please see the

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

Scott, Java is buried deep inside the entire Oracle Apps 11i product suite, making it literally impossible to get it out of the RDBMS in the future. Getting rid of the 'java-fied' installer may be easier and that could be the only utility that they will be able to get out of - if at all :( John

RE: Export question - appending date to dmp file

Try the following example: TMD=`date '+%Y/%m/%d'` TMS=`date '+%Y%m%d%H%M%S'` sqlplus -s internal whisky set verif off pages 0 echo off feed off term off lines 200 spool $SHELLSRCDIR/dbcontents.$TMS.log select 'alter database rename file '''||name||''' to '''||name||''';' fromv\$datafile;

Re: Listener

Flattery will get you everywhere... --Bubba Mohan, Ross wrote: Bubba, Wow! That was a GREAT explanation! -Barbie -Original Message- Oracle Networking Guide at http://technet.oracle.com [EMAIL PROTECTED] wrote: Hallo, Can anybody tell me simply how the listener

RE: Export question - appending date to dmp file

RK - The system nicely timestamps the file automatically for you. Isn't that good enough? Another idea - on Unix, tar several files and it will keep the system timestamps on them. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04,

DBA position in Denver???

Hi all, Does anyone know some Oracle DBA openning in Denver and vincinity? I'm seriously looking for a job. Thank you! Janet __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the

8i Index question

List, I have created tables using partioning that is ranged by the saledate column. second column in the table. The partitions contain data by year; 1993,1994,etc. ex: CREATE TABLE GLCOWSR ( RETNBR NUMBER(16) , SALEDATE DATE, GAMECODE

8i Index Question - ANSWER

List, I finally got through to Metalin... and the answer is 42. When you use partitioned indexes the status is displayed in the DBA_IND_PARTITIONS. I wish they would group associated info together in the books. Thanks in advance Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ:

RE: Has anyone heard of Mirror Accessible?

Title: RE: Has anyone heard of Mirror Accessible? Just got back from OOW and that 'might' be available in Release 2 of 9i. Which is due out in Spring 2002. Nick. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:45 PM To: Multiple

Index Question

Hi All, If I have an index on a key field of type VARCHAR and double its size from 15 to 30, how will this impact performance? By performance, I mean data retrieval. I think that if we are talking about small quantities of data ( 500MB maybe?) things would slow some but not appreciably. Am

Virus Warning

Do not open messages with a Hi subject and a screensaver attachment. Its a virus circling around our company now. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919)

Off Topic: Australian Visa

Sorry for the off-topic. I'm from Argentina, and I'm finding out what the steps I should follow to get a visa (for working) or may be a sponsor in Australia. (A friend of mine told me that Oracle proffesionals have a good chance of getting a job in this country) I hope that someone can

December Oracle Newsletter - too funny

The following bit regarding the 'Unbreakable' appeared in my December copy of a newsletter I receive from Oracle. The part enclosed in appeared in bold print. :) Jared --- When it comes to your mission-critical information, an ounce of prevention is worth tons of

RE: Changes to db after renaming mount points

Sujatha, You could do this in two ways --- either through recreating the control file -- (alter database backup controlfile to trace) and then make modfifications of new disk locations to the control file (trace file). Then from cold backup, copy the databse files to those new locations and

Hi

How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! attachment: gone.scr

RE: BMC Patrol DBXray / CA Unicenter

Title: RE: BMC Patrol DBXray / CA Unicenter Hi Lisa, CA Unicenter has been a source of many nightmares and sleepless nights in the past for me. I was very glad when I quit that job... Just my .02 Lisa Koivu Certified Monkey Fairfield Resorts, Inc. 954-935-4117 -Original

RE: buffer busy wait latch free ( cache buffer chain )

Vivek: To combat the latch free- cache buffer chain problem, I would first check in v$latch_children if the contention is even across all cache buffer chain latches. If this is the case case (most of the time it is not) , I would add more cache buffer latches. If this is not the case, as ARUN

BMC Patrol DBXray / CA Unicenter

Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but

RE: Export question - appending date to dmp file

Try this: DUMPFILE=EXPDATA_$(date '+%m%d%Y%H%M').dmp echo $DUMPFILE should return something like: EXPDATA_120420011626.dmp Which means export started on Dec. 4, 2001 at 4:26 PM. do 'man date' to customize it further for your specific needs HTH Ed __ _

RE: LOCKS - Reading Block Dumps

Hey Larry, With all that free time you got, I got some databases over here that need to be upgraded...a couple of developers that need their hands held (or smacked) while they code their SQL...and some production tables that need to be rebuilt...then I can poke around hex dumps of the

Re: Export question - appending date to dmp file

Yes, I agree, but I have a valid reason for doing this in this way.. any sugesstions.. Ramana - Original Message - From: DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 04, 2001 12:01 PM Subject: RE: Export question - appending

RE: total tranx ran

You're right Shrinivas. I'm sorry. I think you can try with v$sysstat -- user commits + user rollbacks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 01, 2001 1:15 AM This will give the peak usage of

RE: December Oracle Newsletter - too funny

Yea, and I bet that behavior scales up too. ;-) -Original Message- Sent: Tuesday, December 04, 2001 2:35 PM To: Multiple recipients of list ORACLE-L The following bit regarding the 'Unbreakable' appeared in my December copy of a newsletter I receive from Oracle. The part enclosed

RE: LOCKS - Reading Block Dumps

Hi Larry, the lb (lock byte) in the row piece of the block points to an ITL entry. As for the ITL entry, there is a slight confusion in that the headings don't line up exactly with values. In your case, when uncommitted, the contents are : Itl 0x01

contradictory information in v$session_wait?

I had a process showing what I think is contradictory information in v$session_wait. The event was direct path read. The state showed WAITED SHORT TIME. The time_waited showed -1. The puzzling thing was that SECONDS_IN_WAIT was continuously increasing (it was in the 8000 range while I was

Re: Off Topic: Australian Visa

Try http://www.immi.gov.au/ Srini Chavali Oracle DBA Cummins Inc Diego Cutrone [EMAIL PROTECTED]@fatcity.com on 12/04/2001 02:10:19 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sorry for the

Re: Hi

This is a virus. [EMAIL PROTECTED] 12/04/01 03:05PM How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat

RE: BMC Patrol DBXray / CA Unicenter

Lisa, What are you trying to monitor - just Oracle databases, the OS as well (if so which OS) and anything else? We use the Watchdog functionality (part of CA Unicenter) to monitor our VMS servers (where we don't run Oracle) and it good for that. It depends on what you are trying to achieve.

virus alert

FYI. Don't open an email with 'subject: hi'.Our mail servers were attacked by this virus. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: BMC Patrol DBXray / CA Unicenter

Title: RE: BMC Patrol DBXray / CA Unicenter That's the kind of .02 I'm looking for. I don't need any more nightmares .was it bad from an installation perspective or usage? thanks! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 04,

Re: Export question - appending date to dmp file

Try exp ... file=expdat.`date +%j`.dmp ... or whatever format is desired. Note that those are NOT quote marks, but grave marks. They mean the result of whatever command is inside them. You might want to do something like this in a script: JDATE=`date +%j' exp ... file=expdat.${JDATE}.dmp ...

RE: Off Topic: Australian Visa

Diego, Have a look at http://www.monster.com.au http://www.monster.com.au as well. John Kanagaraj -Original Message- Sent: Tuesday, December 04, 2001 11:10 AM To: Multiple recipients of list ORACLE-L Sorry for the off-topic. I'm from Argentina, and I'm finding out what the steps

ASI Oracle Security Alert: Oracle Home Environment Variable Validation

This electronic message contains information which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the named recipient(s). If you are not a named recipient, any review, disclosure, copying, distribution or use of this

ASI Oracle Security Alert: Oracle Home Environment Variable Validation

This electronic message contains information which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the named recipient(s). If you are not a named recipient, any review, disclosure, copying, distribution or use of this

RE: Export question - appending date to dmp file

file=expdata`date '+%y%m%d'`.dmp -Original Message-From: ASCI [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 04, 2001 2:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Export question - appending date to dmp file Yes, I agree, but I have a valid reason for

Re: Virus Warning

Hi David Do you know what kind of virus we are talking about ? David Wagoner wrote: Do not open messages with a Hi subject and a screensaver attachment. Its a virus circling around our company now. David B. Wagoner Database Administrator

RE: BMC Patrol DBXray / CA Unicenter

Title: RE: BMC Patrol DBXray / CA Unicenter Lisa, We are now concluding a very lengthy selection process, and it looks like we will go with BMC Patrol/DB X-Ray. We refuse to do business with CA, and had a very bad experience with Quest I/Watch. None of these are easy to roll-out enterprise

Re: December Oracle Newsletter - too funny

Oh...give them a *break*, will ya. Robert - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 3:45 PM Yea, and I bet that behavior scales up too. ;-) -Original Message- Sent: Tuesday, December 04, 2001 2:35

RE: Changes to db after renaming mount points

Hi Maheswara, Thanks for all your help. I know I missed writing all the steps for moving datafiles (I got a bit lazy). Regards, Sujatha -Original Message- Sent: Wednesday, 5 December 2001 6:21 AM To: Multiple recipients of list ORACLE-L Sujatha, You could do this in two ways ---

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

Of course, you can already call Perl from oracle via extproc_perl. I've done it, it works. Be aware that setting it up is not trivial, as the documentation is somewhat incomplete. That is being remedied however... http://www.cpan.org/modules/by-authors/Jeff_Horwitz/ Jared

ASI Oracle Security Alert: Oracle Home Environment Variable Validation

This electronic message contains information which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the named recipient(s). If you are not a named recipient, any review, disclosure, copying, distribution or use of this

RE: LOCKS - Reading Block Dumps

Paul, Thanks for the response -- and a good recommendation, I refer to those sites quite often. I had been searching at the Adams site and browsing Lewis's site prior to sending the email. For whatever reason, I missed/skipped the details on *interpreting* a block dump at the Adams site. I went

Re: Anybody heard Oracle will remove the JVM from Oracle in future

Steven, If if Oracle does support it, there are other sources from which you could probably get better support for Perlish stuff. Jared Steven Lembark

RE: BMC Patrol DBXray / CA Unicenter

Ideally, we'd like to find a common tool to monitor Oracle, Sybase and SQL Server databases running on both NT and Unix platforms. There are separate groups that are responsible for NT support and Unix support. If we could all use the same tool, we'd be delighted, but if not, then one tool for

Re: Hi

This is a new virus. Do not open the attachment. virus text** How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wilfred Li, Ph.D.

Rollbacks - ORA-1555

Title: RE: BMC Patrol DBXray / CA Unicenter Greetings All I am some what new to the list, so forgive me if I don't have the proper etiquette in addressing my issue. I have a database, 8.1.6, running on Windows NT, that currently has 5 rollback segments. The specs are as follows for each

RE: virus alert (OT)

Title: RE: virus alert (OT) You can read more about this virus at: http://www.antivirus.com/vinfo/virusencyclo/default5.asp?VName=WORM_GONE.A=T Nick -Original Message- From: Anne Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 12:36 PM To: Multiple recipients of

RE: LOCKS - Reading Block Dumps

Chris, And I always thought the answer was 42 ;-) And other than a 3 day gig next week, I've got lots of time on my hands. So, do you want me to dial in or fly out ;-) The reason for asking the question was in relation to a back-channel discussion with someone on locks. I'm familiar with

Re: OT: perl q

Lisa, What gives you that idea? Seriously. Is there some piece of documentation that is telling you that? If so I would love to see it. DBI is a database interface for Perl. DBD::Oracle is the module that allows DBI to talk to Oracle databases. Sqlplus has nothing to do with this.

Re: Index Question

For OLTP, one key factor is whether the index is in memory. If you double the size of a primary key field from varchar2(15) to varchar2(30), there will probably not be any change for the header and branch blocks of the index -- if they were in memory before they'll probably still be in memory.

RE: Message to Session Users - How's it done in your org ?

If the database server is a Windows server and you want to send to Windows clients on a LAN / WAN how about something like the following -- start here -- netsend.sql -- -- Send a message to all connected machines, using net send. -- -- 20-Mar-2000 , Bruce Reardon : Creation. -- -- set heading

Re: Hi

Everyone: The email from Alan had the newest Internet worm on it! Please don't open ANY scr files. Here's a link to the virus info: http:[EMAIL PROTECTED] Have a great evening. adam Alan Dewey wrote: How are you ? When I saw this screen saver, I immediately thought about you I am in a

RE: buffer busy wait latch free ( cache buffer chain )

If on 8.1.7, there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging. One is 1967363, and at least two others are still open after applying that patch. Changing cache buffer latches/buckets is not mentioned in those bugs,

Re: LOCKS - Reading Block Dumps

Larry fb: indicates the flags.H means header in this rows. F means First piece of the row. L means last piece of the row. Since both FL are present in here there is no row-chaining. lb: lock byte indicates the ITL array index of the transaction that is holding the lock on the row. It is

New 8.1.7 LEAD operator

Below is a sumary of some testing I did on the new LEAD operator that I sent to our Apps developers. Any feedback from you're brain dead to wow would be appreciated. Thanks, Ron [EMAIL PROTECTED] Class is in session. This

RE: simple sql problem

After testing prompted by Jared's reply, you can use 1 of the 2 alternatives from Windows. That is, under windows the following works: echo select * from dual; | sqlplus scott/tiger@abcd I often use this type of syntax under NT to (say) log the time as below, but had never thought to try it

RE: LOCKS - Reading Block Dumps

Riyaj, Thanks for taking the time to provide this information. After running across a few comments from people talking about the need to dump a block to get at the nitty gritty, I decided it was time to explore this area and learn. You and others have been a great help in this effort. And the

Re: Rollbacks - ORA-1555

Hi Christine, Your rollback segments look large to me based on the description you have given for your application. One way of eliminating header waits is to increase the number of rbs .. try this and post if this helps your stats.. 1. Create total of 20 rollback segments 2. Specification for

Re: Anybody heard Oracle will remove the JVM from Oracle in futur

Thanks, I know. We have some other Apps dba's trying to get 11i GHR up and running. It would be nice to get rid of all the jvm crap embedded in the db, however unrealistic that may be... --S - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

  1   2   >