Title: Serial# changes when rolling back
Jared,Deepak
I did not see a reply on this. From a brief experiment I don't see the serial# changing when rolling back a transaction.
The code posted by Jared certainly works as the number of blocks to rollback reduces as the job nears completion.
If
Under 8.0.X you can use log_archive_duplex_dest. It is
also available on 8i. However, if you use
log_archive_dest_n on 8i, you cannot set
log_archive_duplex_dest.
Similarly, on 9i, if you use log_archive_dest, you
could not set log_archive_dest_n.
Finally and regarding rman on 9i, you can
Check this Oracle Note :
Or check whether u have a large pool too..reduce the large_pool_size
parameter.
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957
Hi List,
is there a possibility to set the expiry date of the password to a date ?
Background: After a migration to Oracle 8.0.6 we set the expire password option to all
users but when the user logs on
ORA-1841 ((full) year must be between -4713 and +, and not be 0
Only after the user
Title: The Oracle List Archive?
Hi,
Forgive the rather dumb newbie question.
However I regularly see people on this list refer to the archive.
How can I access this? I have poked around at fatcity.com and not found much help!
TIA
Denham
This e-mail message has been scanned for Viruses
db_domain in init.ora is commented out in both cases. I also set it
to:
db_domain =
but it didn't make any difference.
Setting GLOBAL_NAMES to false helped but someone mentioned
that it is not a good practice. Can anybody explain little bit why?
Thanks
Witold
On 10 Dec 2001 at 21:50,
Hi
Anyone now which 2 V$ views can be accessed while in nomount mode ?
Also what is a tempfile ?
TIA
Saj Iqbal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sajid Iqbal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hi,
as I remember, it was always recommended to avoid the use of views upon
views upon views in the design of an Oracle DB (as for version 7/8),
since the optimizer might get confused.
Does that still apply ?
I'm supposed to give some guidelines to developers about the usage of
views.
My point
Title: The Oracle List Archive?
Hi
Eva,
Try
the following link to access the archives. http://www.fatcity.com/ListGuru/login.php
I
can't remember where you get the password from (I think it might be blank) - it
validates on your e-mail address I believe
John
-Original
Hi Saj,
I just tried at least 4 on 8.1.7
v$instance
v$sga
v$sgastat
v$parameter
There are probably more, don't know where the two number is coming from.
John
[EMAIL PROTECTED] wrote:
Hi
Anyone now which 2 V$ views can be accessed while in nomount mode ?
Also what is a tempfile ?
TIA
Title: RE: nomount
Is this some sort of OCP test for us listers??
-Original Message-
From: Sajid Iqbal [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 12:20
To: Multiple recipients of list ORACLE-L
Subject: nomount
Hi
Anyone now which 2 V$ views can be accessed while in
Uh Oh ...
I have a forms application that is built on views that are built on views
that are built on views ... up to 5 levels deep. The fun part is we have to
go to CBO now ... and the tables underlying the views range from 10 rows
to 20M rows.
Talk about fun ...
Raj
Hi Witold,
if you use oracle replication you're limited to use global_name=true
I don't know any other restrictions.
Regards,
Ed
db_domain in init.ora is commented out in both cases. I also set it
to:
db_domain =
but it didn't make any difference.
Setting GLOBAL_NAMES to false
lol looks like it eh?
I know that you can view v$instance while the database is not mounted - not
sure about the other one..
And - straight from the Oracle Concepts Manual (page 126)
Locally managed temporary tablespaces have temporary datafiles (tempfiles),
which
are similar to ordinary
Must I have RMAN back up the archive log files?
We are at the delicate position of getting acquainted with RMAN. We
are using it but not yet ready to completely trust it, or rather trust that
our setup is entirely correct (we production DBAs tend to be a conservative
lot). We are just
Thanks to everyone that shared their thoughts on this issue.
Steven - Thanks very much for your insight of throughput vs. latency. I
think this reduces the concepts to a simple enough level that I can explain
them to others. The system administrators also do our wide-area networks and
the focus
Something I learned today, but haven't seen it documented anywhere and would
like to see whether anybody has come across it.
We have a Sun server (call it oracle.acme.com). It came to life by
combining two machines (oracle1.acme.com and oracle2.acme.com). So now it
has two IP addresses: hme0:
Forget the optimizer, what about the developer?
This just doesn't seem like a good idea, or in
the words of Wayne Brady 'That is just wrong on
so many levels'.
Jared
On Tuesday 11 December 2001 04:30, Stefan Jahnke wrote:
Hi,
as I remember, it was always recommended to avoid the use of
Hope I'm not being blunt here, ( I will admit to being frank, but not Frank )
What you're suggesting here is to put a patch on a bad design.
15 indexes? That's too many.
Your table is undoubtedly highly denormalized and has too
many columns. How many columns does this table have?
You
No, the password is not blank. You have to
supply one the first time you use it.
Jared
On Tuesday 11 December 2001 05:00, you wrote:
Hi Eva,
Try the following link to access the archives.
http://www.fatcity.com/ListGuru/login.php
http://www.fatcity.com/ListGuru/login.php
I can't
Try with TIMESTAMP literal. Like this:
create materialized view mv_test
enable query rewrite
as
select * from birthdays
where birth= timestamp '1971-05-03 09:00:00 PM' at
time zone 'Europe/London';
Regards.
--- elain he [EMAIL PROTECTED] wrote:
Hi,
Does anyone know how can I create a
I would avoid views based on view. As well, I would avoid using views
where you will later turn around and throw a distinct or a group by
or anything else on it (especially if you are dealing with a lot of data).
Basically, You cannot be assured that the optimizer will pick the proper
path once
v$parameter
v$sga
v$option
v$process
v$session
v$version
v$instance
nomount stage, right from my Oracle Admin book published by Oracle.
David Ehresmann
Oracle DBA 8 8i OCP
MCI Worldcom
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sajid Iqbal
Hi,
Views that can be read in the nomount stage are:
v$parameter, v$sga, v$option, v$process, v$session, v$version and
v$instance.
And tempfile is latest method of defining Oracle database temporary files
for Temp tablespaces.
Mujeeb Chowdhry
[EMAIL PROTECTED] 12/11/01 07:20AM
HiAnyone
Hi
Thnq for responding.
I am mistaken, in understanding the request.
I am supposed to create a trigger that will do update onto a target
table con2 whenever the contract is updated.
15 indexes on a table:
There are several tables that have 15 indexes. All such tables will have
10-20,000
No, these are questions I have been asked but couldn't readily find the
information on... so I thought someone out there must know :-)
Regards
Saj
On Tue, 11 Dec 2001, Mark Leith wrote:
lol looks like it eh?
I know that you can view v$instance while the database is not mounted - not
When I run this code both columns I get no rows returned. When I do a desc
on one of the tables I see both columns. So, why am I not getting any data?
select table_name, column_name
from dba_tab_columns
where
(column_name = 'REGISTRATION_NUMBER' and
column_name = 'DOCUMENT_NUMBER')
Thanks,
Somehow I deleted the TEMP tablespace but not the datafile. How do I go
about recreating this tablespace?
Thanks,
Ken Janusz, CPIM
Database Conversion
Lead Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET:
And you believed it ?
-Original Message-
Sent: Tuesday, December 11, 2001 9:10 AM
To: Multiple recipients of list ORACLE-L
v$parameter
v$sga
v$option
v$process
v$session
v$version
v$instance
nomount stage, right from my Oracle Admin book published by Oracle.
David Ehresmann
Oracle
Well ...
According to a document on Metalink .. it is pretty safe to assume the cost
of a DML action on an index as 3 times of that of on the table. So, if
inserting one record costs you one unit, on your table with 15 indexes it
would be
(1 * 1 table) + (3 * 15 indexes) = 46 units.
And this
Hi lists,
I need to load the excel sheet data to oracle tables. A date column is
improperly entered by users.
In the excel sheet the date column was filled up without using hyphens
or slashes
the data is like this
todays date: 10th Dec 2001
(it is supposed to be 10/12/2001 or 10-Dec-2001
Hi,
I have this sql statement:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
id,
car_make
from
carmake
order by
car_make;
So this selects a blank record and then the records from carmake. But I
want the blank record to
appear at the top of the
Change the 'and' to 'or'.
Ken Janusz wrote:
When I run this code both columns I get no rows returned. When I do a desc
on one of the tables I see both columns. So, why am I not getting any data?
select table_name, column_name
from dba_tab_columns
where
(column_name =
This was returned by the mailer-daemon because of a
locking problem ??
-Oorspronkelijk bericht-
Van: Jeroen van Sluisdam
Verzonden: dinsdag 11 december 2001 17:08
Aan: '[EMAIL PROTECTED]'
Onderwerp: RE: Why is this code not working?
You need an or-clause because one row has either
I guess this is what you want:
select table_name, column_name
from dba_tab_columns
where (column_name = 'REGISTRATION_NUMBER' or column_name =
'DOCUMENT_NUMBER')
or
select table_name, column_name
from dba_tab_columns
where column_name in ('REGISTRATION_NUMBER', 'DOCUMENT_NUMBER')
If you want to be able to restore your database to a point in time or do a
complete recovery you database you must have all of the archive logs you
need. If you don't include them in a backup you must keep them in the
archivelog destination,
Ruth
- Original Message -
To: Multiple
U - cause one row cannot have both values in the same column???
How about changing it to:
select table_name, column_name
from dba_tab_columns
where
(column_name = 'REGISTRATION_NUMBER' or
column_name = 'DOCUMENT_NUMBER')
or
where
(column_name in
You are trying to look for a column name be equal to two different names...
I assume you want an OR instead of the AND...
select table_name, column_name
from dba_tab_columns
where (column_name = 'REGISTRATION_NUMBER' OR column_name =
'DOCUMENT_NUMBER')
-Original Message-
Sent:
I think you are confusing the logical and with the fact that you want
both columns. Try using or in place of and
(column_name = 'REGISTRATION_NUMBER' or
column_name = 'DOCUMENT_NUMBER')
Pat
When I run this code both columns I get no rows returned. When I do a desc
Have you considered to use findreplace tool in excel and replace all the
th string with nothing, and then reformat the cell as you need.
Iulian
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 6:00 PM
To: Multiple recipients of list ORACLE-L
funny, i run it in my database (mutatis mutandis for column names, natch)
and it works JUST FINE with AND.
buti am hoping an acknowledged SQL guru will step in and say this
-Original Message-
Change the 'and' to 'or'.
--
Please see the official ORACLE-L FAQ:
Hi
Workaround: Treat the Column as text (within Excel) and transform it
with a little VBA Macro into the format you want to use in Oracle.
Tatireddy, Shrinivas (MED, Keane) schrieb:
Hi lists,
I need to load the excel sheet data to oracle tables. A date column is
improperly entered by
it's not so much a feature of the listener as it is of DNS as far as I
know. One of the reasons it's best not to hard-code IP addresses into
the listener.ora is because when you do a failover, or combine machines
as you have, the listener.ora and tnsnames.ora files need to be
updated.
If you use
Hi,
you can try:
exp file=
log=
tables=
owner = A
imp file=
log=
ignore=y
tables=
fromuser=A touser=B
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 5:35 AM
Hi list.
I
Hi,
I am trying to generate some generic CREATE DATABASE scripts from the Oracle
Database Configuration assistant and I cannot see the Generate Database
Creation Scripts option that is mentioned in the HELP. It is not listed on
the screen with the Create Database and Save as a Database Template
Hi
Assuming that you actually use the TEMP tablespace as a real temp
tablespace and didn't put any actual data in it, you can just go ahead
recreate it by reusing the old datafile.
Ken Janusz schrieb:
Somehow I deleted the TEMP tablespace but not the datafile. How do I go
about
Does this suit you?
select
to_number(null) as id,
to_char(null) as car_make,
0 ordcol
from
dual
union
select
id,
car_make,
1 ordcol
from
carmake
order by
ordcol,
car_make;
Iulian
-Original Message-
Sent: Tuesday, December 11, 2001 5:45 PM
To: Multiple recipients of
Use the REUSE option on the CREATE TABLESPACE command.
Ken Janusz
ken.janusz To:
Change the and in your WHERE clause to an or.
Kevin L. Bass
Database Administrator
Americal Corporation
-Original Message-
Sent: Tuesday, December 11, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L
When I run this code both columns I get no rows returned. When I do a desc
on
Ken - I assume you dropped the TEMP tablespace, which doesn't delete the
datafile. I'm assuming you are on Unix. Just remove the data file and
recreate the TEMP tablespace the same way as you originally did. I believe
that the temp tablespace settings for all users will be unaffected, but you
one column (COLUMN_NAME) can't have two separate and distinct values.
I think you want an or not an and in the query
--- Ken Janusz [EMAIL PROTECTED] wrote:
When I run this code both columns I get no rows returned. When I do
a desc
on one of the tables I see both columns. So, why am I not
Hi
I did this (don't know wether it's documented or not), but somebody
recommended to split it up into 2 listeners (1 for each interface) to
have a better way of controlling the workload (especially with multiple
instances).
Made sense to me.
Djordje Jankovic schrieb:
Something I learned
Title: RE: sql query
add NULLS FIRST after the ORDER BY CAR_MAKE:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
id,
car_make
from
carmake
order by
car_make NULLS LAST;
Tony Aponte
-Original Message-
From: Steven Hovington
Steve,
Use the NULLS FIRST option of the ORDER BY (and you probably want to change
your UNION to a UNION ALL). Note that you could also include a constant in
each select to enforce order, do an order by nvl(col,looow value), etc. Lots
of ways, but, the NULLS FIRST option seems clearest to me.
Title: ORA 0600 on histgrm$ after computed statistics on database
Hello,
I keep getting numerous ORA 600 since I have launched:
dbms_utility.analyze_database
and
dbms_stats.gather_database_stats
Has anybody run into this type of problem ?
PS: get ORA 600 on :
select /*+ rule */
Title: RE: sql query
Oops. The statement was wrong. I'll try it gain:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
id,
car_make
from
carmake
order by
car_make NULLS FIRST;
Tony Aponte
-Original Message-
From: Aponte, Tony
I agree with Christian. We had the same memory leak
problem here before. It turned out there are some
heavily used sql statement without the bind variables.
--- Christian Trassens [EMAIL PROTECTED] wrote:
Answering your first message about the shrink of
free
space in shared pool. Check the
Stephan,
Contrary to what has been mentioned, the optimizer actually performs a
number of transformations on the submitted query using the Query transformer
- this includes 'view merging' which basically rewrites the query by merging
the view query block into the query block that contains the
Title: RE: Lookup table design thoughts needed
I would start by considering how the application is deployed. For code that is easily deployed (E.I.. executables are located on a few application servers or a shared drive) I would consider compiling the rule data along with the logic. It
Thanks, Ruth. Because we aren't yet ready to bet the farm on RMAN, we are
keeping them in both locations. And since we only do a weekly cold backup,
we keep a week's worth on disk. I'm thinking that for the time being we can
forgo RMAN backing up the archive logs. Thanks.
Dennis Williams
DBA
Hi guys and gals,
OK - so who's going to be going to the UKOUG on Monday? And who wants to
meet up for a beer? I have a partial list of people, but if we could all
confirm now that would great! The thoughts on the venue were Broad Street -
maybe somewhere like Ronnie Scotts? Or the
Hi guys and gals,
OK - so who's going to be going to the UKOUG on Monday? And who wants to
meet up for a beer? I have a partial list of people, but if we could all
confirm now that would great! The thoughts on the venue were Broad Street -
maybe somewhere like Ronnie Scotts? Or the
We are trying to get an idea of how much disk we'll need to roll out the
MySAP suite to about 200 users on Oracle 8.1.7/HP-UX 11. We're planning on
using most of the core SAP package and not CRM or APO. Can anyone else give
me a guess on how much disk space we might need?
Jon Behnke
Applications
Title: ORA 0600 on histgrm$ after computed statistics on database
Hi, I think you should not analyze sys
schema.
- Original Message -
From:
SAURY Alain
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, December 11, 2001 6:10
PM
Subject: ORA 0600 on histgrm$
I have a P4 - which I actually had the below problem with on both 8.1.7, and
9i. The below problem fixed the install problems with 8.1.7, but 9i STILL
won't install on my machine (Win2K O.S.). It keeps complaining that it cant
find jrew.exe, and that I need to install JRE 1.2.1(?) or greater.. I
I tried doing this but had problems running two listener that listen on the
same port number on two different IPs. One of the two did not want to
start.
Djordje
-Original Message-
From: Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 12:01 PM
To: Multiple
WOW!! They got through!! I only sent these last Wednesday!!!
-Original Message-
Sent: 11 December 2001 17:55
To: Multiple recipients of list ORACLE-L
Hi guys and gals,
OK - so who's going to be going to the UKOUG on Monday? And who wants to
meet up for a beer? I have a partial list of
I am not talking whether putting DNS entry works, but am just pointing to
the fact that oracle behaves differently if you put hardcoded IP - it than
listens to one IP only, and if you put the dns name - listens to all IPs.
Djordje
-Original Message-
From: Rachel Carmichael
Dennis,
To perform media recovery using RMAN, it is necessary that u backup
archived log files too since it is the key to a successful recovery.
I suggest that u store the RMAN recovery catalog on a different machine
cos if ur machine crashes thus crashing the database, ur RMAN catalog
goes
Hi all,
I'm trying to ruin netasst in a linux box running RH7.2, but it only sits
there doing nothing.
Does anybody know if I have to set something before?
I was able to create the DB w/o a problem.
any help greatly appreciated
TIA
--Yohans
--
Please see the official ORACLE-L FAQ:
well yeah...
that's the whole point of USING DNS, so that it will work like that
--- Djordje Jankovic [EMAIL PROTECTED] wrote:
I am not talking whether putting DNS entry works, but am just
pointing to
the fact that oracle behaves differently if you put hardcoded IP - it
than
listens to
I used to define it on localhost (127.0.0.1) and this worked great with all
ip addresses (only on Solaris).
Did not work on NT!
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 11, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L
Something I learned today, but haven't
Title: 9i install.
Hi,
I am trying to run dbca (the new name for dbassist) on Sun Solaris 2.7 and I get the following
java.lang.NoClassDefFoundError: org/omg/CORBA/UserException
at oracle.sysman.emSDK.common.registry.PropertiesFileRegistry.get(Proper
tiesFileRegistry.java:44)
at
Well, I think the issue is two-fold.
1. They have been tinkering with user sessions, and the trace file
output below is discussed on Steve Adams' website.
PMON unable to acquire latch 80002060
modify parameter values
I always find it amusing that the SDD_ELEMENTS table
which is part of an Oracle product meant to encourage
good design (ie Designer) has more than this number of
indexes :-)
--- Jared Still [EMAIL PROTECTED] wrote:
Hope I'm not being blunt here, ( I will admit to
being frank, but not Frank
Ditto.
In addition, DNS will use multiple IP's in a round robin fashion
as a crude form of load balancing.
Jared
Rachel
I have to share this post I got on another list. Someone had asked a
question about how Oracle locks work, here is the question...
Q: i'd like to understand the lock modes (share exclusive)
how to make them on table in DML transaction why locking is
automatically use the lowest
I've seen a 14 page (9 point Courier point) SQL which
was generated by my ol' favourite Discoverer! It
actually ran fine, it was more of Discover's penchant
for writing code along the lines of:
select column_list from
( select column_list from
( select column_list from
( select
Title: 9i install.
I hate
Java!
-Original Message-From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001
2:20 PMTo: Multiple recipients of list ORACLE-LSubject:
9i install.
Hi, I am trying
to run dbca (the new name for dbassist) on Sun Solaris 2.7
Title: 9i install.
can
you check javaversion...as i recall it should be
1.1.7
or better for 9i.
-Original Message-From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001
2:20 PMTo: Multiple recipients of list ORACLE-LSubject:
9i install.
Hi, I am
I did something similar on 9i recently and I believe there was a check
button in DBCA for Create Scripts, in addition to Create Template. Did you
follow DBCA through to the last screen? I think it is there.
I tried to use the 9i DBCA to create a custom database with rollback
segments instead
Title: 9i install.
Hi,
java
-versionjava version "1.1.7"
Yuval.
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001 3:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
9i install.
can
you check javaversion...as i
Title: 9i install.
ah
well, a swing and a miss.
-Original Message-From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001
4:25 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: 9i install.
Hi,
java
-versionjava version "1.1.7"
Yuval.
OS Environment HP-UX
11.0
Oracle Version
8.0.5.2.1
A situation arose whereby the DBA issued a shutdown
immediate, which did not complete in what was considered
a reasonable time period, so a shutdown abort was
issued. I believe there was active transaction(s) running at the
time.
The
Title: 9i install.
Check
the required O/S patches (in Oracle installation doc), required Java release,
CLASSPATH env variable.
-Original Message-From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001
2:20 PMTo: Multiple recipients of list
Title: 9i install.
Is
your classpath set?
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001 3:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
9i install.
I
hate Java!
-Original Message-From: Yuval
Hello,
The application frequently (several times per day) hangs. Restarting
the MTS (Microsoft Transaction Server) (Package shutdown) resolves the
problem and the users are able to work again. The database appears to
be unaffected and appears ready to process.
The Oracle ODBC version is
Absolutely tremendous.
No mention of core dumps, I noticed
-Original Message-
Sent: 11 December 2001 20:10
To: Multiple recipients of list ORACLE-L
I have to share this post I got on another list. Someone had asked a
question about how Oracle locks work, here is the
this was treat man .. cool and imaginative for sure!!
--- Farnsworth, Dave
[EMAIL PROTECTED] wrote:
I have to share this post I got on another list.
Someone had asked a
question about how Oracle locks work, here is the
question...
Q: i'd like to understand the lock modes
yeah i did read this thread but still wonder why
oracle needs to use serial# column at all. Does the
SID not gaurentee uniqueness for a session ... damn
the name says so atleast (session identifier)..
or maybe they just coded it like that and make some
use of the serial #
Deepak
--- [EMAIL
Hi,
We inserted data into 1 of the column as
test 1 abc
while the actual value is
test1abc without spaces.
There are about 1 million rows in a table.
Is there a way to update the table column and remove the extra space .
Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ:
Hey Anita!
Thanks for the useful info.
Actually, after the stats were hanging I started querying various tables and
those queries also started hanging; queries on v$latch and a couple of others.
I finally shutdown abort and got an ORA-600 error.
I looked it up on the extremely handy ORA-600
One explanation I had heard for the combination of Sid+Serial# goes
something like this ...
say you identify a particular session to monitor ... you then decide to
kill it.
However, it could so happen that that user logged out between the time you
decided to kill the session and the time you
Hello everybody,
My team is currently evaluating Oracle monitoring tool
from a company called PROGNOSIS. Is there anybody
currently using this tool or evaluated the tool
before?
May I get some feedback about the Oracle monitoring
tools of PROGNOSIS from any one of you?
Your insight would be
intresting ...
--- [EMAIL PROTECTED] wrote:
One explanation I had heard for the combination of
Sid+Serial# goes
something like this ...
say you identify a particular session to monitor ...
you then decide to
kill it.
However, it could so happen that that user logged
out between the time
Hi all,
How to broadcast a message to all user who
running Forms 6i ?
we use Sun as the database server.
I use 'wall' command from root to user when we still
use Forms 3.0 ( they login via telnet).
regards
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: hernawan
Hi Gurus,
How can I set up a time zone for each region that connect on
SAME Database 8i
Case: Database in NewYork. Clients in San Franciso, Paris ..
When they use select sysdate from dual ; ( on Client or server side )
They should see their local time .??
Thanks in advance
Tran
--
Please
Can't , not in 8i.
9i has introduced a TIMEZONE datatype where time can be reported offset by
the UTC+/- offset.
You'd have to build the logic in your application to increment/decrement
the sysdate, depending
on the user/client location (use a lookup table for location and
timezone-offset) when
I have to share this post I got on another list.
Excuse me but what List is this ?
Thanks
Robert Chin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 3:10 PM
I have to share this post I got on another list. Someone
1 - 100 of 109 matches
Mail list logo