Title: Meddelelse
Rajesh,
SYSDATE is of datatype DATE (that's what the documentation says), i.e. it
contains century, year, month, day, hour, minute and second (without
decimals).
I have made a little test. FirstIdump a
SYSDATE to see the internal representation. Then Icreate a table with
Tanel,
Oracle 9-2 SQL Ref manual. Lob storage clause.
The options for lobs on creation are:
CACHE
NO CACHE
CACHE READS
I don't think the last one appeared until 9.2
I was wrong about caching only writes, though -
one of the joys of trying to quote everything from
memory.
The CACHE
It's just one example of my general suggestion that messing about
with block sizes rarely has any direct performance benefit. But
if you can put something out of the way where it can't do so much
damage then the performance of everything else might benefit.
Regards
Jonathan Lewis
Hi Jonathan,
I don't think the last one appeared until 9.2
I was wrong about caching only writes, though -
one of the joys of trying to quote everything from
memory.
Thank you for this note, I had somehow missed this important improvement.
The CACHE READS option means that the
LOB goes
Title: Meddelelse
Sorry! I was mixingformat-masks. The last SQL should read (i.e.
instead of ):
select to_char(systimestamp, '.MM.DD
HH24:MI:SS.'), dump(systimestamp)
from dual;
/Jesper
-Oprindelig meddelelse-Fra:
[EMAIL PROTECTED] [mailto:[EMAIL
i apologize if someone posted this answer(i missed it if you did), but why do cached
lobs require writes on the control file? and jonathan said that isnt 'necessarily'
bad. is that because there isnt alot of I/O?
so caching lobs are primarily useful for read only or read 'mostly' LOBs?
Hi!
i apologize if someone posted this answer(i missed it if you did), but why
do cached lobs require writes on the control file?
NOCACHE NOLOGGING LOBs require writes to controlfile, because last nologging
operation to a datafile has to be reflected somewhere, for being able to
determine which
Friday, January 30, 2004, 2:24:25 AM, Jesper Haure Norrevang ([EMAIL PROTECTED]) wrote:
JHN Certainly som conversion is going on here. This might be the reason why
JHN there has been confusion about 7 or 8 bytes in a DATE datatype.
That's really interesting, that switch between 7 and 8
bytes.
Go to the SERVICES and start the service.
Dharminder
Hallo,
I would like to write the code to atrigger that makes insert into another table inly
if there is the condition
PREFERED_NUMBER = 1 and TELEPHONE_TYPE_ID in (1,2, 5)
How can write this in a simple way?
Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ:
How does dba_jobs decide what it's nls_env values are?.
They seem to vary according to whether I queue the job from a windows client
or from unix.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi,
From Note: 69028.1 on Metalink
The datatype returned is 13 and not 12, the external DATE datatype.
This occurs because we rely on the TO_DATE function!
External datatype 13 is an internal c-structure whose length varies
depending on how the c-compiler represents the structure.
Note that
On 01/30/2004 09:29:26 AM, [EMAIL PROTECTED] wrote:
Hallo,
I would like to write the code to atrigger that makes insert into
another table inly if there is the condition
Oracle9i Application Developer's Guide - Fundamentals, Ch. 15. - Using
Triggers. There are examples there, too.
--
Please see
Thomas,
That is the real problem. I can start the database using Windows 2000
OracleServiceSID.
But I want to start up the database using OEM only.
Thanks.
-Original Message-
Thomas Day
Sent: Friday, January 30, 2004 9:19 AM
To: Multiple recipients of list ORACLE-L
start a
Go to the
Dharminder,
Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you to be able to start the database.
The service will stay running even if you shut the database down. Think of
the service as a backgrouond placeholder for the database.
Jared Still scribbled on the wall in glitter crayon:
A repost of a previous message.
This is the last day for this address folks.
good-bye fatcity my old friend, won't get to talk to you again...
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell
last post(its kinda like first post on slashdot.org)
joe
Thater, William wrote:
Jared Still scribbled on the wall in glitter crayon:
A repost of a previous message.
This is the last day for this address folks.
good-bye fatcity my old friend, won't get to talk to you again...
--
Bill
So, is anyone posting on the new list? I believe that I'm subscribed there
but I'm only getting fatcity posts.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Jared, I think you should ask the maintainers of orafaq.com to update their
information about oracle-l as well, it's the first hit in google when you
search for oracle-l.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 30,
We move an application that uses
OPTIMIZER_MODE=RULE from Oracle8 to 9i. Most of it is fine, but there are two
queries that have a very different execution plan. In one case, the execution
time increases from less than a minute to more than an hour. Neither query uses
any of the new Oracle
Title: Message
Keith,
To my
knowledge, RBO has not changed. That includes NOT dealing w/ IOT.
So, I think if you execute a query that references an IOT, you'll implicitly
invoke the CBO. That would explain why the plan is changing. So, did
you change a table from heap to IOT when you moved
Thanks Tanel, Frank is on top of it already.
Jared
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/2004 08:24 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: [Fwd: ! READ THIS - [EMAIL
The Windows service implements Oracle's VOS ( virtual OS )
This is not noticed on *versions, as there is no separate step.
See James Morle's book 'Scaling Oracle 8i'.
Jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/2004 07:44 AM
Please respond to ORACLE-L
There is not enough memory to start a dedicated connection. sochange the server mode from dedicated to shared, (you can do it change some parameters in init_sid.ora file see oracle documentation).
If you are going to change the server mode to shared and you have two databaseon the same machine,
Logic
says one thing, experience says another. Question one, are the tables
analyzed? If so, since RBO is deprecated in 9i even setting
OPTIMIZER_MODE=RULE will invoke the CBO.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Keith Moore
Hi,
In view v$log there is a column status. This changes from current (if the redo log is in use) to atcive then to inactive. Documentation says :
ACTIVE: The log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be
On 01/30/2004 01:24:26 PM, A Joshi wrote:
Hi,
In view v$log there is a column status. This changes from current
(if the redo log is in use) to atcive then to inactive. Documentation
says :
ACTIVE: The log is active but is not the current log. It is needed
for
crash recovery. It may be in use
Mauricio
I do
not think it is a memory issue because I can startup the database using Windows
2000 OracleServiceSID service and it does not fail.
Thanks.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Mauricio
VilezSent: Friday, January 30,
Tom,
As stated earlier, here the intention is to startup the database using OEM
only and without using windows service. As for as I understand if the
OracleServiceSID is properly setup and if startmode for the service is set
to automatic then it will startup the database automatically once you
That's true.
Dharminder
There is a pretty good explanation in this usenet thread:
Well, you can't. Windows is different from other systems in that you have
these services that have to be running in the background. Once the
services are running, you can use OEM to shutdown and startup the database.
But the service has to be running first.
Sorry.
Have you looked at OEM Jobs?
Dharminder,
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change the value to FALSE.
This way
Mladen,
Thanks for info. So all the dirty blocks need to be written to disk after eachcheckpoint. After that is donethe status becomes 'INACTIVE'. Just that sometimes this is very unpredictable.
My question : Ifa log switch always causes a implicit checkpoint then what is the need for this
-Original Message-
Igor Neyman
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change
David Hau explained this much better and in much more clear
fashion then me. Here is the most important part from the usenet
thread he was referring you to:
**
This makes sense if you think about where the various v$ dynamic
Igor,
What you have mentioned is right i.e. if I set ORA_SID_AUTOSTART to
FALSE for the database in question and set OraceServiceSID startmode to
Automatic then as windows starts it starts the OracleSID service (or I
should say background services needed for the database to run and I believe
I
Yes, I'm sure.
If in the services control panel you change OracleServiceSID starup
properties, it does not affect ORA_SID_AUTOSTART key in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 (and does not change the way
the database is started when the service is started).
What it does, it changes the
Thanks Mladen and David
It is great to get such detailed info.
If we take your example of three redo logs then you could have a situation where one is is 'CURRENT' status and two are in 'ACTIVE' status. As follows :
GROUP# STATUS-- 1 ACTIVE2 CURRENT3 ACTIVE
Now if group
Hello,
Ihave a procedure that open a cursor anddumps some data for last 24 monthsto a file. The date range is static condition definedinside the cursor. Procedure is working great, but Iwhat I'm havingproblemfiguring outisif there is a way to create not one file with all the data, but multiple
bye...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
[EMAIL PROTECTED] wrote:
|
| bye...
- --
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with
NOO!!
-Original Message-
Sent: Friday, January 30, 2004 7:44 PM
To: Multiple recipients of list ORACLE-L
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
[EMAIL PROTECTED] wrote:
|
| bye...
- --
Joseph S Testa
Chief Technology Officer
Data Management Consulting
It's the end of an era. How long was the list hosted here?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
I am running a query:
select
from
WHERE COMPANY=2000 AND LOCATION='CDJ01' AND
ITEMLOC.ACTIVE_STATUS='A' AND POVAGRMTLN.PROCURE_GROUP='SMAR'
AND RTRIM(LTRIM(POVAGRMTLN.VEN_AGRMT_REF)) = 'COM1-21-LARROC NANCY'
AND RTRIM(LTRIM(POVAGRMTLN.VENDOR))='21'
and in the next part of the where
LGWR will always write to the redo-logs in a round-robin
fashion. So, on completing Group2, it would wait
for Group3 to be INACTIVE. {One exception is when you ADD a new Log
Group. If you added a new log
file without specifying a Group#, it would be allocated Group#4, would be
set to status
My guess would be that company is not a number but because you do compare
it to a number company=2000 Oracle does an implicit conversion
to_number(company)=2000 and that fails when it hits a row where company
is not numeric.
If my guess is right try company='2000'
At 07:59 PM 1/30/2004, you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
Wolfgang Breitling wrote:
| My guess would be that company is not a number but because you do
| compare it to a number company=2000 Oracle does an implicit
| conversion to_number(company)=2000 and that fails when it hits a
| row where
drop list ORACLE-[EMAIL PROTECTED]
\rm r FATCITY
bye
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 30, 2004 5:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: Bye...
bye...
50 matches
Mail list logo