starting/stopping trace in session

Folks, I've noticed -- at least on our 9.2 instances, that it does not seem possible to generate two trace files from the same session. Meaning, if I start a trace in a session, then stop it, use tkprof to run some analysis, and then erase that trace file, a second start_trace does /not/ gener

RE: Happy new year

Hi guys, HAPPY AND A PROSPEROUS NEW YEAR TO ALL OF U Regds, Rohan From: "Yechiel Adar" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Happy new year Date: Wed, 31 Dec 2003 14:24:25 -0800 It is now officially 2004 here so:

RE: SQL*Loader to load mutiple languages from the single

Did you set it just to French, or did you specify a particular character set? From the symptoms you're describing, it sounds like your data file has problems. The French characters may be encoded using a different character set than the Japanese characters. If you want to load the file, you'll

RE: SQL*Loader to load mutiple languages from the single

Justin,Thanks for your reply. When the French characters are loaded properl I did set NLS_LANG=French -Original Message- Justin Cave Sent: Friday, January 02, 2004 7:14 PM To: Multiple recipients of list ORACLE-L When the French characters are loaded properly, are you setting NLS_LANG to

Re: SQL*Loader to load mutiple languages from the single

When the French characters are loaded properly, are you setting NLS_LANG to FRANCE_FRENCH.UTF8, or are you using a different character set? Justin Cave At 01:39 PM 1/2/2004, [EMAIL PROTECTED] wrote: Dear All, Happy New Year! I have to load both French and Japanese characters from the same data

Re: stress testing

And when you're doing stress testing, make sure you load your system for quite long time. Stress testing shouldn't only verify system performance, but it should also test system's reliability. One of my clients had a problem with Oracle Apps, where they did a stress test for just one hour and conc

RE: encrypt back-up data

Thanks! David. -Original Message- Sent: Friday, January 02, 2004 3:49 PM To: Multiple recipients of list ORACLE-L Hi The data in the database is not changed, the data is encrypted in the sql*net layer. Ehresmann, David wrote: >I realize that. Is the data in the table left in its "no

Re: encrypt back-up data

Hi The data in the database is not changed, the data is encrypted in the sql*net layer. Ehresmann, David wrote: I realize that. Is the data in the table left in its "normal format"? Then when it is used it is encrypted by one of the algorithms? thanks, David. -Original Message- Sent:

RE: Sqlplus and HTML

Works like a charm ! Thanks Darren -Original Message- Sent: Friday, January 02, 2004 12:09 PM To: Multiple recipients of list ORACLE-L Browett, Darren wrote: > Happy new year to all !. > > I am trying to create some html reports using set markup html, and have > one question, > when

SQL*Loader to load mutiple languages from the single datafile

Dear All, Happy New Year! I have to load both French and Japanese characters from the same datafile into tables using SQL*loader. DB character set is UTF8 (version 8.1.7.3) Client : Unix (Sun Solaris) If I set NLS_LANG=AMERICAN_AMERICA.UTF8 then French characters are NOT getting loaded proper

RE: encrypt back-up data

I realize that. Is the data in the table left in its "normal format"? Then when it is used it is encrypted by one of the algorithms? thanks, David. -Original Message- Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L Hi It is only the data that is passed

Re: encrypt back-up data

Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256

RE: stress testing

Henry: John is partially correct. SAR, in concert with VMSTAT / IOSTAT, will provide you with a wealth of information. However, something is missing from the equation here. LoadRunner will generate scattered statistics on overall performance of an application (sorry: biased because Compuwar

Re: Sqlplus and HTML

Browett, Darren wrote: Happy new year to all !. I am trying to create some html reports using set markup html, and have one question, when doing a select col1,col2 … from some_table, I would like the field names to be a different colour/shade. Is that possible doing style sheets. I did fin

RE: encrypt back-up data

Title: RE: encrypt back-up data Thanks, I will pass it along.  Next question:  If you are using Oracle's Advanced Encryption standard with one of the following standards:     encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key 3DES.   Does the

RE: encrypt back-up data

Title: RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for     STORAGE MANA

RE: stress testing

Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a p

Sqlplus and HTML

Title: Sqlplus and HTML Happy new year to all !. I am trying to create some html reports using set markup html, and have one question, when doing a select col1,col2 … from some_table,  I would like the field names to be a different colour/shade.   Is that possible doing style sheets. 

Re: stress testing

As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/.  The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared "Poras, Henry R." <[EMAIL PROTECT

stress testing

We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically

RE: Cache a table

In addition to Jared's latest comment, what Oracle version are you on? Have you considered multiple buffer pools, which are often a much cleaner solution? -Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Fri 1/2/2004 12:54 PM To: Multiple recipien

Rocks, anyone?

Anyone messed with Rocks (http://www.rocksclusters.org) in an Oracle capacity? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse

RE: Cache a table

This thread started on 10/21/2003, with a *lot* of comments. No time to read it all, so I'll just work with what appears here. Have considered that this table is simply used a lot and remains in the cache because it belongs there due to frequent access? SQL with high LIO's? Jared Ravi

RE: Should we stop analyzing?

Jared, I think your conclusions must have assumptions: 1) The SQL was written "correctly". 2) The data structures wrer designed and layed out properly. Here, we can AssUMe neither. :) Food for thought... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED

RE: encrypt back-up data

David - I haven't heard of this feature in Oracle. For one thing, there are many ways to back up Oracle data. Many of these methods are simply direct O.S. file copies. But most O.S.'s offer a file encryption utility that you could easily incorporate into your backup script. But if you choose to do

RE: Cache a table

That was what we expected. This is a highly active PeopleSoft Database. Will it take several months to push those blocks out ? Though not true, it appears the nocache had no effect at all .. -Ravi. --- "Bobak, Mark" <[EMAIL PROTECTED]> wrote: > Well, that's not really a surprise, is it? If you >

Re: rman restore question

Hi! As Stephen pointed out, rman searches for a file named "/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman", but can't find it. Is this file a newer backupset which rman is automatically trying to use? If you want to skip this file, you could use "change backupset unavailable" command for temp

encrypt back-up data

Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring th

RE: rman restore question

I have never attempted what you are doing, so I must confess some ignorance. But, looking at your error message, it appears that rman knows what file it needs and is unable to get it. One must assume there is no file named /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman available on the hard

Re: ORACLE-L Digest -- Volume 2004, Number 002 (Out of Office

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Miller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

db_link timeout

Hi All Happy New Year In my plsql program i am connecting to two remote DBs and using db_links sequentially. Sometimes if the first remote db is not available or there is some network problem then it stays there for quite some time and then throws an error (which is captured in exception sect

RE: Hardware for RAC?

Title: Message I'd also ask myself am I 'evaluating' RAC in which case presumably whatever hardware you can lay your hands on will be fine, or am I 'testing' RAC in which case I'd suggest that you need to purchase the same hardware as you would be using in a live environment, which would mos

RE: order by

> Aside from SQL brain-teasers, I cannot imagine a practical > use for ORDER BY > <>. If your real number is an integer, then that would mean order by the column in that position in the select list. Sorry If I missed this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- A