RE: SQL Tuning - How to avoid TOCHAR function against a date

Tom, It is probably too late for this original design but it is not too late for a new data warehouse that is in development. Jared has made a recommendation for better date columns that may help eliminate these problems. I have forwarded that table design on to the application owner.

Re: Re[2]: SQL Tuning - How to avoid TOCHAR function against a date

Bob, Thanks for your reply. I am testing this afternoon. Cherie Robert

RE: two listeners problem ???

Why not post the latest of your listener.ora file. It should be quite a bit different then the original that made it to the list. -Original Message- Sent: Monday, April 08, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Hi, After I issued lsnrctl start ORACL816, the 816

RE: Using OID

OiD! After several weeks of pain, here's what I've learned: 1) Create your database(s) manually. The GUI creates the traditional the least we need to get it going without a real DBA database. Note 159031.1 on Metalink will guide you thru the basic create. 2) If you intend on using

Re: two listeners problem ???

Check your tnsnames.ora and verify in CONNECT_DATA you have SERVICE_NAME (instead of SID) and the value of SERVICE_NAME=db_name.db_domain. For example, if your db_name=orcl01 and db_domain=world then SERVICE_NAME=orcl01.world. Janet Linsy wrote: Hi, After I issued lsnrctl start ORACL816,

RE: Foreign Objects in the System Tablespace.

I was not referring to you personally Paul. I obviously have no idea what you set your pctincrease to. -Original Message- Paul R. Sent: Monday, April 08, 2002 12:22 PM To: Multiple recipients of list ORACLE-L Hello, Well, I'm puzzled. I have pctincrease set to 0, so I guess I'm not

Re: Decyphering LMT space bitmap

Hi Jeremiah, How is the LMT bitmap organized? I did some research about the bitmap structure for an LMT tablespace a while ago. The first 2 blocks are Block 1 - For File Header Block 2 - For File Space Bitmap Header The bitmap itself is stored in 6 blocks after that , blocks 3 thru 8.

How to read user dump file

Hi: Can anyone of you tell me what tool to use in orderto get areport outfromuser dump file? Many thanks!

Test Message - Please ignore

--- Madhavan Amruthur See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City

Re: Decyphering LMT space bitmap

That looks the way it should be. You have 30 extents in the tablespace, and 30 bits near the start of the bitmap are set. You'll have to create a bitmap tablespace and use extents in it one at a time, but quite literally from the block 3 onwards the bitmap is one bit per extent - it's just a

IOUG conference get together

So for those of us going to the IOUG Conf, do we want to plan a get together? Throwing this out for ideas, etc. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

[Re: two listeners problem ???]

Check your tnsnames.ora and verify in CONNECT_DATA you have SERVICE_NAME (instead of SID) and the value of SERVICE_NAME=db_name.db_domain. For example, if your db_name=orcl01 and db_domain=world then SERVICE_NAME=orcl01.world. Janet Linsy wrote: Hi, After I issued lsnrctl start

RE: IOUG conference get together

I'm all for it - anyone have a suggestion for a time and location? Brian -Original Message- Sent: Monday, April 08, 2002 5:18 PM To: Multiple recipients of list ORACLE-L So for those of us going to the IOUG Conf, do we want to plan a get together? Throwing this out for ideas, etc.

RE: IOUG conference get together

Joe, So for those of us going to the IOUG Conf, do we want to plan a get together? For sure!! As far as I could determine, the following are going to be there (other feel free to add): 1. Joe Testa 2. Gaja Vaidyanatha 3. Kirti Deshpande 4. Rachel Carmichael 5. Ari Kaplan (On the IOUG

Re: Decyphering LMT space bitmap

I think you'll find that generally the initial amount of file allocated is 64K (including the two header blocks) - the fact that you noted the bitmap was in the next 6 blocks suggests you were using an 8K block size. The actual space allocated at file creation time is dependent on the file

RE: How to read user dump file

vi. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Yahoo [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Subject: How to read user dump file Hi: Can anyone of you tell me what tool to use in

Re: Decyphering LMT space bitmap

There's a funny thing about the: | Tail portion of Bitmap Blocks M blocks It doesn't really exist despite Oracle documents to the contrary. Try creating a file with some waste space at the end of it so that the 'Tail' points to the start of the waste space; then increase the file size

Insert append generating redo

Hi, I'm trying the following insert /*+ append */ into t1 as select * from t2; t1 is created with nologging attribute. The insert is not using the hint at all. I can select on t1 (before any commit) which I should not be able to do if the append hint was used. Any ways to get the hing used ?

UWIN 3.0 and ORA-12560 error

Hello, I am getting this ORA-12560: TNS Protocol Adapter error, while connecting to the local database on my Windoze NT Workstation. This happens when using the ksh environment in UWIN 3.0. I have done all the debugging I can think of. Everything works fine via DOS Command window. I have checked

RESOLVED : UWIN 3.0 and ORA-12560 error

Never mind... Found out that when variable LOCAL is set to $ORACLE_SID, this error goes away ! Now I can retire for the night :) - Kirti -Original Message- Sent: Monday, April 08, 2002 9:51 PM To: '[EMAIL PROTECTED]' Hello, I am getting this ORA-12560: TNS Protocol Adapter error,

RE: Cold NT backups

You may want to look at robocopy.exe from the NT resource kit. mark -Original Message- George A. Sent: Tuesday, April 02, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Group, We are doing a cold backup to a remote server. I am using OCOPY that fails intermittently with the

<    1   2