Antw: RE: select distinct values

2003-09-24 Thread Guido Konsolke
Hi Rich, same for me. Just one diference: my table is named surrogate_brain ;-) Greetings, Guido [EMAIL PROTECTED] 24.09.2003 00.29 Uhr Man, every time I think I have a handle on the analytic functions, someone bowls me over with it's power and simplicity. I was trying to do this using the

Tuning help required

2003-09-24 Thread New DBA
Hi All, I need help in tuning the following query. It takes around 6-7 minutes to run. I hope that someone will be able to go through the details and give me a few pointers. I have gathered a few statistics, but don't know where to go from here. Please view the mail in a fixed size font e.g.

RE: YEAAAAAAAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!, drop in number

2003-09-24 Thread Paul Vincent
A, these Yanks... such citizens of the world community, ain't they? Bless. -Original Message- Sent: 23 September 2003 21:50 To: Multiple recipients of list ORACLE-L in number I'll be happier when I see hi-tech workers arguing for a ban on Nike footwear unless made in the US and a

RE: Tuning help required

2003-09-24 Thread Stephane Faroult
Before checking stats, execution plans and the like take a look at your query. I presume that it is generated, otherwise you would probably say that a date belongs to a month by using a BETWEEN the first and the thirty first rather than listing all the 31 days, would you ? Now perhaps the

RE: Oracle8i, Failsafe and patchset 12

2003-09-24 Thread Tim Onions
Jared The URL refers to an alert for NT 4.0, Patrice is talking about Windows 2000 (which is also the MS flavour I'm having problems on), am I being blind here but those are 2 different products? If there is a similar alert for Windows2000 I'd certainly like to hear about it. If anybody

RE: Tuning help required

2003-09-24 Thread Justin Cave
In addition, since you're using the cost-based optimizer (CBO), make sure that you've used dbms_stats to gather statistics on all the objects involved in the query recently. If you have any columns where histograms would be useful, make sure you've gathered histograms for those columns.

Re: Tuning help required

2003-09-24 Thread jo_holvoet
Well, I'd start by writing the date part as : MEPAI.MPAI_AS_OF_DATE between to_date('03/01/2003','MM/DD/') and to_date('03/31/2003','MM/DD/') It will at the very least make the query easier to read and understand (also for the optimizer : it will know it's filtering on a range instead

RE: Tuning help required

2003-09-24 Thread Steve Adams
Hi New DBA, Further to what Stephane has said below, the following two stats in your initial post are interesting ... consistent gets 559985 table fetch continued row 212027 That suggests that there is a fair amount of row

Re: Offshore protests

2003-09-24 Thread Nuno Souto
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hyderabad. USS Enterprise will have to be renamed to USS Utar Pradesh, with captain Sanjay and Mr. Spock at the helm. I can definitely see a value there. 'sOK. But I swear the first time I see anyone

RE: Cary's book -- Out of stock !

2003-09-24 Thread Rothouse, Michael
I ordered my copy from Bookpool on September 18 and it was out-of-stock at that time. I'm waiting patiently. -Original Message- Sent: Wednesday, September 24, 2003 1:40 AM To: Multiple recipients of list ORACLE-L i placed my order at bookpool on 20-09-2003. ...anxiously waiting for my

RE: Hiding passwords

2003-09-24 Thread Mercadante, Thomas F
Jared, You said: "One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable." This is true. But to accomplish the same functionality, you can dynamically create a temporary .bat file that creates the

RE: suggestion

2003-09-24 Thread Jamadagni, Rajendra
hmmm... here is what I did ... change user_dump_dest to a file system which has lots of space, 100G in our case modify a logon trigger and for a certain group of people (based on a role) "execute dbms_support.start_trace"; Create a logoff trigger that raises a alert user_logoff

RE: Hiding passwords

2003-09-24 Thread Boivin, Patrice J
In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Patrice. -Original

RAC for download

2003-09-24 Thread quriyat
Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com

RE: suggestion

2003-09-24 Thread Norris, Gregory T [ITS]
How did you go about determining the tracefile name within the trigger? I don't think I've ever seen an example for this... -Original Message- Sent: Wednesday, September 24, 2003 8:05 AM To: Multiple recipients of list ORACLE-L hmmm... here is what I did ... change user_dump_dest to

RE: shared server connections

2003-09-24 Thread Mladen Gogala
Well, to successfully use connection pooling, you need connection manager. My information is that pooling by the instance is rather buggy and slow. Here is an excerpt from the oracle documentation: Oracle Connection Manager, an Oracle Net Services component, enables multiple client network

RE: Oracle patch to fix ORA-00000

2003-09-24 Thread Mladen Gogala
ORA-00 is a normal, successful completion. I can give you some suggestions how to get ora-0001 or ora-0942. If I do my best, I can probably even successfully generate ora-01555. If you are not afraid of tinkering with the data dictionary, we can even generate some ora-00600 and ora-01578. I

Upgrade Plans

2003-09-24 Thread KENNETH JANUSZ
Would like to know where I can find some detailed plans on upgrading server, O/S, DB and applications to their new releases. Something like a TO DO list would be helpful. Any help will be greatly appreciated. Thanks much, Ken Janusz, CPIM

RE: how to check 32 or 64 bit?

2003-09-24 Thread Hallas, John, Tech Dev
Perhaps it is even simpler to describe V$session The first column SADDR is raw(8) on 64 bit and is raw(4) on 32 bit databases John -Original Message- Sent: 23 September 2003 22:25 To: Multiple recipients of list ORACLE-L Oracle DBA wrote: Also how to check whether my DB is 32 or 64

Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-24 Thread Hemant K Chitale
Tanel, Thanks ! Yes, your suggestion was the right fix. {I can't upgrade ALL the clients and remote databases to 9.2.0.3} I set event 10499. I referred to Note 241355.1 and Bugs 2235818 and 2960493 and set 10499 at level 4 [although any non-zero value should suffice] The Support Analyst had

Re: Hiding passwords

2003-09-24 Thread Nuno Souto
- Original Message - In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Here is a

Re: Upgrade Plans

2003-09-24 Thread Michael Boligan
http://metalink.oracle.com/metalink/plsql/ml2_gui.startup metalink top tech docs upgrade and migration KENNETH JANUSZ

Re: maturing monitoring scheme

2003-09-24 Thread Daniel Fink
Some random thoughts, with examples 1) Tracks historical information to determine when a value is out of normal range or when a value has suddenly increased. ex. - SQL*Net messages consume 85-95% of wait time. If this value drops to 75% or rises to 99% alarm. - AR_DATA tablespace is

RE: RAC for download

2003-09-24 Thread Mladen Gogala
Title: Message RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24,

Re: Upgrade Plans

2003-09-24 Thread KENNETH JANUSZ
Thanks Mike, but this won't work. I'm not a member of Metalink. Ken - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:44 AM http://metalink.oracle.com/metalink/plsql/ml2_gui.startup metalink top tech docs

RE: RAC for download

2003-09-24 Thread Hemant K Chitale
If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as

RE: Cary's book -- Out of stock !

2003-09-24 Thread Jesse, Rich
I've never had any problem of any sort with a half dozen or so orders from bookpool.com. It looks like they're just out of stock, for which I'm partly to blame. :) I ordered mine on the morning of the 16th and received an e-mail the night of the 16th that it shipped. GL! Rich Rich Jesse

RE: suggestion

2003-09-24 Thread Jamadagni, Rajendra
Title: RE: suggestion this is the format instancename_ora_ospid.trc perhaps this might help ... SELECT c.VALUE || '/' || LOWER(INSTANCE) || '_ora_' || LTRIM(TO_CHAR(a.spid,'fm999')) || '.trc' FROM v$process a, v$session b, v$parameter c, v$thread c WHERE a.addr = b.paddr AND

Java for Alpha Linux

2003-09-24 Thread Jesse, Rich
I'm looking for Java for Linux on an Alpha box. This really isn't OT because I need it in order to connect my Perl programs on the Alpha to Oracle via DBI/DBD::JDBC, which requires Java. I had downloaded it from www.compaq.com at one point, but it's gone from www.hp.com (

RE: maturing monitoring scheme

2003-09-24 Thread DENNIS WILLIAMS
Josh One idea for you to consider. Buy the book Oracle9i High-Performance Tuning with STATSPACK by Don Burleson. His book is chock full of ideas about overall database monitoring, regardless of whether you decide to use STATSPACK or not. As an example, he points out that the database sits atop

RE: 10g: SQL Plus

2003-09-24 Thread Bob Metelsky
Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began

RE: download metalink articles - save target as

2003-09-24 Thread Bob Metelsky
The grueling method is... grab the header, copy paste it into notepad.exe. That strips the weird formatting out of it. Grab the body text, but not all the way down, try to guess where the body text frame ends and stop just before that. It may take a few tries to find exactly where. copy

RE: Upgrade Plans

2003-09-24 Thread Mladen Gogala
You want to start an extensive product like switching to the new version and platform without support? Have you ever heard of the word kamikaze? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KENNETH JANUSZ Sent:

RE: OFA and Shared Storage

2003-09-24 Thread Matthew Zito
EMC storage is very reliable, no question. However, I have personally seen terrible SAN disasters on many vendors' SANs, but most of them on EMC (since I worked for them). Without going into specifics, the SAN problems I've seen were caused by (in rough order): 1) human error - changing SANs

Multiple block sizes

2003-09-24 Thread Mladen Gogala
Title: Message Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently

RE: 10g: SQL Plus

2003-09-24 Thread Norris, Gregory T [ITS]
Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell And it can be minimized or moved out of the way while a query is active. -- This post may contain anti-SCO content sponsored secretly by IBM. Ssh!

RE: Java for Alpha Linux

2003-09-24 Thread Mladen Gogala
Have you tried jikes? That is IBM implementation of Java2 platform which was not checked by SUN, so it can't use name Java. It is the result of the same dispute that caused MS to stop supporting Java. Allegedly, jikes is much better software then the original sun's JDK. -- Mladen Gogala Oracle

RE: 10g: SQL Plus

2003-09-24 Thread Mladen Gogala
Will they have UFI in 10g? I'm sort of nostalgic. I cannot install my 3 360k 5.25 floppies with oracle 4.1 on any PC. How about oralink? Remarkably, it all used to run in 512k of RAM, which is less then the L3 cache size on any decent P4 system. How many hundreds of megabytes of RAM will I need

Re[2]: 10g: SQL Plus

2003-09-24 Thread Jonathan Gennick
Wednesday, September 24, 2003, 11:44:44 AM, you wrote: BM Ive actually began to like sqlplus (opposed to sqlplusw). One good BM feature is you have your command history using the up arrow like regular BM shell Scrolling back to see what you've done is a bit more problematic, though you can

RE: Multiple block sizes

2003-09-24 Thread Igor Neyman
Title: Message Dont have experience with that. But, dont forget to configure memory subcaches for multiple block sizes (along with specifying new block size for the tablespace). Check Oracle 9i New Features by R.Freeman (p.13). Igor Neyman, OCP DBA [EMAIL PROTECTED]

RE: Upgrade Plans

2003-09-24 Thread DENNIS WILLIAMS
Ken Having gone through this numerous times, I don't think there is such a thing as a detailed plan that has any use beyond the immediate task. I would concentrate first of all on your philosophical approach, the principles on which you work. Here are some ideas: - Create a staging/QA server

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Tanel Poder
Hi! Press F7 in windows command line sqlplus to see history of your sql commands (it's actually cmd.exe feature). And particularily nice feature is that you can search the F7 history list, by pressing the first letter of a command - you'll be navigate to alter command for example if you press a

Re: IBM AIX 32-Bit

2003-09-24 Thread Joan Hsieh
I think 64 bit application have to run on a 64 bit hardware. but can be booted as 32 bit mode. That at least apply to oracle 9i version. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Multiple block sizes

2003-09-24 Thread Mladen Gogala
Title: Message That part is done. Thanks. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor NeymanSent: Wednesday, September 24, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple

how to generate unique file names on Windows.

2003-09-24 Thread Murali_Pavuloori/Claritas
Hello, I am trying to write a script on windows that would export the db every night. Can someone tell me how to generate unique file names on windows... What I am looking for is the windows equivalent of echo `date +%m%d%y` Thanks in advance. Murali. -- Please see the official ORACLE-L

RE: Multiple block sizes

2003-09-24 Thread Avnish.Rastogi
Title: Message I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block

Re: RAC for download

2003-09-24 Thread Mogens Nørgaard
I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to

Re: 10g: SQL Plus

2003-09-24 Thread Mogens Nørgaard
Well, we have a good, working 5.25 floppy drive installed on our Oracle Museum PC (486, 25 MHz) now, and we're planning on installing WordPerfect 4.2, Lotus 1-2-3 (with the plug-in for Oracle, which Cary will bring over for the Database Forum next week), and other goodies. We have 5.1 running,

Re: Tuning help required

2003-09-24 Thread Jared . Still
In addition to the excellent advice you have already received, let me congratulate you on taking the time to format your code and trace data so that it is readable. There are folks that are known to skip long posts such as this when poorly formatted and difficult to read. ;) Jared New

RE: Apps 11.5.8 and 9i

2003-09-24 Thread Jared . Still
My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L

RE: Hiding passwords

2003-09-24 Thread Jared . Still
Yes, I could to that, but I won't. I really don' like writing passwords out to a temp file. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 05:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Hiding passwords

2003-09-24 Thread Jared . Still
Yes, I could do that, but I won't. It's fraught with security problems. Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

Re: Hiding passwords

2003-09-24 Thread Jared . Still
Thanks, this bears investigating. Nuno Souto [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 07:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Hiding passwords - Original Message -

Re: how to generate unique file names on Windows.

2003-09-24 Thread Wolfgang Breitling
for /F tokens=2,3,4 delims=/ %I in ('date /t') do @set today=%K-%I-%J example: c:\date /t Wed 09/24/2003 c:\for /F tokens=2,3,4 delims=/ %I in ('date /t') do @set today=%K-%I-%J c:\echo %TODAY% 2003-09-24 c:\ At 09:44 AM 9/24/2003 -0800, you wrote: Hello, I am trying to write a script on

RE: Apps 11.5.8 and 9i

2003-09-24 Thread April Wells
on Windows... the product is supposed to INSTALL without MKS, but once you get it installed you can't run a bunch of the utilities. C++, I believe, is required to be there for the install. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \

RE: URGENT REPORTS

2003-09-24 Thread Paula_Stankus
Title: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.

RE: Hiding passwords

2003-09-24 Thread Jared . Still
Apparently my Windoze Command scripting skills are woefully inadequate. The past several years have been ksh heavy and windoze shell poor, not that I regret this in any way. :) Thanks Wolfgang, I'll have to play with this. Jared Wolfgang Breitling [EMAIL PROTECTED] Sent by: [EMAIL

RE: Apps 11.5.8 and 9i

2003-09-24 Thread Nelson, Allan
Title: Message Yep, on Windows platforms -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9iMy question was not clear. I realize what

RE: Apps 11.5.8 and 9i

2003-09-24 Thread Bonnie Finke
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

RE: Oracle8i, Failsafe and patchset 12

2003-09-24 Thread Jared . Still
Yes I posted the wrong link. Now I can't recall where I saw this info, and cannot find it. Though SP4 on Win2k is supposed to cause some serious network latencies. I will post the info if I come across it again. Jared Tim Onions [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003

RE: how to generate unique file names on Windows.

2003-09-24 Thread Khedr, Waleed
You can use sqlplus to generate the script for you. -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Hello, I am trying to write a script on windows that would export the db every night.

Re: Apps 11.5.8 and 9i

2003-09-24 Thread Tanel Poder
They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're

RE: Multiple block sizes

2003-09-24 Thread Mladen Gogala
Title: Message Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24,

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Jared . Still
This can be done with ksh as well. Someone else may have a link to the script that a rather good ksh coder put together and posted here a few years ago. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 09:44 AM Please respond to ORACLE-L To:

RE: Apps 11.5.8 and 9i

2003-09-24 Thread Jesse, Rich
Sounds like OiD. You can't install it on Windows unless you have a Unixish shell to do it in because of the command line utils like ldifwrite. As usual, this was on v9.0.1... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

RE: Apps 11.5.8 and 9i

2003-09-24 Thread April Wells
You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle

RE: Apps 11.5.8 and 9i

2003-09-24 Thread Nelson, Allan
Title: Message Probably meaning cygwin. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9i You can fake it out, though, if you get the free

RE: how to generate unique file names on Windows.

2003-09-24 Thread Jamadagni, Rajendra
Title: RE: how to generate unique file names on Windows. IIRC (this is from memory) type somefile.bat for /f tokens=1-4 delims=/ %%a in ('date /t') do set newdate=%%b%%c%%d rename abc.txt abc.txt_%newdate% this will append mmdd to the file but it will work in batch file only. Raj

Re: shared server connections

2003-09-24 Thread bulbultyagi
Mladen, aren't you talking about connection multiplexing and not connection pooling ? Isn't pooling is supposed to carried out by the dispatchers themselves. Let me know if I should rtfm. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday,

RE: RAC for download

2003-09-24 Thread Mladen Gogala
My dear friend, you're wrong. That practice has stopped with 8i. Partitioning option *is* an integral part of 9iEE without an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA

RE: Apps 11.5.8 and 9i

2003-09-24 Thread April Wells
Title: Message Yeah... that's the one. I have it on good authority that if you install that, it will get past the installer April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite

ROW CACHE HIGH - Priority 1

2003-09-24 Thread Muqthar Ahmed
Hi, I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX. Currently I am seeing very high number for ROW CACHE LOCK in statspack. Top 5 Timed Events ~~ % Total Event WaitsTime (s)

Re: Apps 11.5.8 and 9i

2003-09-24 Thread Tanel Poder
Title: Message Aha, thats a good idea. But Apps loses support probably if you're using cygwin or anything else than MKS. (Btw, I wouldn't call it Unix on windows, it's just a unix toolset runnable on windows). Tanel. - Original Message - From: Nelson, Allan To:

RE: URGENT REPORTS

2003-09-24 Thread Paula_Stankus
Title: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent:

RE: shared server connections

2003-09-24 Thread Mladen Gogala
Connection multiplexing is, at least how I understand it, the same thing. Both names mean that several client sessions can simultaneously use the same connection. Anyway, I didn't see any effect from turning POOL=ON in MTS_DISPATCHERS parameter and I did see sharing when pooling was activated in

RE: Tuning help required

2003-09-24 Thread Jacques Kilchoer
', 'MMDD'), to_date ('20030919', 'MMDD'), to_date ('20030920', 'MMDD'), to_date ('20030921', 'MMDD'), to_date ('20030922', 'MMDD'), to_date ('20030923', 'MMDD'), to_date ('20030924', 'MMDD'), to_date ('20030925', 'MMDD'), to_date ('20030926', 'MMDD

RE: ROW CACHE HIGH - Priority 1

2003-09-24 Thread Mladen Gogala
General answer: upgrade to 9.2.0.4 and hope that the bug has been fixed. Row cache locks are data dictionary locks. You can see the contents of row cache by inspecting v$rowcache. You may need to increase shared pool. Last but not least, how fast is your private network connection between the two

RE: URGENT REPORTS

2003-09-24 Thread Johnston, Tim
Title: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients

RE: how to generate unique file names on Windows.

2003-09-24 Thread Branimir Petrovic
-Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: September 24, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Subject: how to generate unique file names on Windows. Hello, I am trying to write a script on

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Kirtikumar Deshpande
http://www.orafaq.net/faqscrpt.htm #12 under Unix Shell Scripts - Kirti --- [EMAIL PROTECTED] wrote: This can be done with ksh as well. Someone else may have a link to the script that a rather good ksh coder put together and posted here a few years ago. Jared Tanel

Re: 10g: SQL Plus

2003-09-24 Thread bulbultyagi
In nt cmd shell , you could make copy pasting easy by going into properties and selecting 'quick edit mode' . In fact you could make this behaviour the default by choosing 'save properties for future windows with same title'. Then you need not select mark and copy , etc . Just use the right and

RE: Multiple block sizes

2003-09-24 Thread John Kanagaraj
Title: Message Mladen/Avinish, I would just be a little careful about keeping 'hot' indexes in 32K blocks. The chances of encountering buffer busy waits during multiple, simultaneous INSERTs and DELETEs would be higher as root blocks and branch blocks that need to be updated would now hold

Re: Hiding passwords

2003-09-24 Thread bulbultyagi
In ntfs you can set permissions on a file . But that wouldn't stop a member of the adminstrator group. What you need to do is to aditionally encrypt the file or folder as well. Then no one else can even list the contents of the folder, not even another administrator. In xp its as easy as right

guidance

2003-09-24 Thread bulbultyagi
List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL

RE: URGENT REPORTS

2003-09-24 Thread Paula_Stankus
Title: RE: URGENT REPORTS Thanks. -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 4:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it

RE: guidance

2003-09-24 Thread DENNIS WILLIAMS
Give or take the exam? Makes a big difference ;-) Is this your first OCP module? If not, which other modules have you taken? What are you using as study materials? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 24,

Re: URGENT REPORTS

2003-09-24 Thread Tanel Poder
Title: RE: URGENT REPORTS Setting up vnc server and directing DISPLAY to that is easier, I think.I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. - Original Message - From: Johnston, Tim To: Multiple recipients of list

RE: Multiple block sizes

2003-09-24 Thread Avnish.Rastogi
Title: Message Not really, except to watch closely your hit ratio for no default cache other than that we used alter table move and alter index rebuild online option to move tables/indexes. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday,

RE: Apps 11.5.8 and 9i

2003-09-24 Thread April Wells
Title: Message granted... but Babette was just trying to install this on her pc and use it for learning... not sure how much supportthat support would be in her circumstance... and MKS is a little pricey if you are just trying to learn. April Wells Oracle DBA/Oracle Apps DBA Corporate

RE: URGENT REPORTS

2003-09-24 Thread Ron Thomas
You can't. As of about a year or so ago, there must be a buffer available for reports. vnc works nicley for this. Many notes/articles on Metalink concerning this. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: guidance

2003-09-24 Thread Mladen Gogala
Realx and feel the force. Only if you open your mind, you can master the force. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:05 PM To: Multiple recipients of

RE: Apps 11.5.8 and 9i

2003-09-24 Thread Rodd Holman
I think the product you are talking about is Cygwin. http://www.cygwin.com/ On Wed, 2003-09-24 at 14:24, April Wells wrote: You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep

Storage Frust....

2003-09-24 Thread Piet de Visser
Group, After another run-in with Storage, need to Vent Some frustrations: BAARF Thank you. While I'm at it, let me add some other RAD ideas: Frustrated by vendors and manuals, we were about to turn BAARF into: battle against any Raw Filesystems (Yes, Yes, I know, a raw-dev is not a

Re: guidance

2003-09-24 Thread Tanel Poder
Forget the modern tuning skills and when you're asked what shows the best that your database works optimally; 1) Buffer cache hit ratio is 99% 2) Buffer cache hit ratio is 99,999% 3) Buffer cache hit ratio is 99% 4) Users aren't complaining Then answer 3 for sure ;) Tanel. - Original

Re: Storage Frust....

2003-09-24 Thread Vladimir Begun
Piet de Visser wrote: CCCP: USSR: :) -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City

Re: guidance

2003-09-24 Thread AK
In US it is called take the exam while in INDIA it is give the exam . ug need ANSI english . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:14 PM Give or take the exam? Makes a big difference ;-) Is this

RE: guidance

2003-09-24 Thread Orr, Steve
Is that where questions are answered before they are asked? I need a database like that on the stock market. -Original Message- Sent: Wednesday, September 24, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Forget the modern tuning skills and when you're asked what shows the

RE: URGENT REPORTS

2003-09-24 Thread Jesse, Rich
If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL

RE: RAC for download

2003-09-24 Thread Johnston, Tim
Um... I'd definitely get that in writing... I just looked at the oracle store and it looks like partitioning is still an extra cost item... I also checked the price guide... http://www.oracle.com/corporate/pricing/ePLext.PDF This also listed partitioning as an Enterprise Edition Option...

RE: URGENT REPORTS

2003-09-24 Thread Gene Sais
What I like about VNC, is that all you need for a client is a browser. http://ip.address:5800 gets you a nice java client connection. Gene [EMAIL PROTECTED] 09/24/03 06:14PM If y'all do choose a VNC route, I'd highly recommend the free and GPL'dTightVNC from http://www.tightvnc.com/Better

  1   2   >