Hi Ranganath,
the query for ur first question is
update testtab t1 set t1.code = ( select t2.type from testtab t2
where t1.rowid = t2.rowid ) , t1.type= ( select t2.code from
testtab t2 where t1.rowid = t2.rowid )
...will let u know if i can get a query for ur second question.
Regards,
Prem
Title: Change NLS variables in logon trigger...
Hi there!
I' having a logon trigger on 9.2.0.2 which sets
DBMS_SESSION.set_nls('nls_language','''GERMAN''');
DBMS_SESSION.set_nls('nls_territory','''GERMANY''');
But I'm getting the following error message:
ORA-00604: error occurred at
Title: ORA-04098 Problem - Any Ideas??
Hi
Denham EVa
Try
SQL ALTER TRIGGER SYS.JIS$ROLE_TRIGGER$ COMPILE ; -- If recompilation fails or
if you are still not able to connect, disable the trigger SQL ALTER
TRIGGER SYS.JIS$ROLE_TRIGGER$ DISABLE ;
then your command
thanks
Banarasi Babu
Hi to all,
Please help me in this regard.
While I have installed Oracle 8.1.7 in P IV machine. after booting the
system it atomatically starts HTTP server service, then whatever work i
wated to do on that machine it's not allowing by givein message line
java.exe error.
whenever i stop the HTTP
Hi List,
I am answering my own questions. Sorry for posting the questions in a
haste.
1. Select e.empid, e.salary, m.mgr_id, m.salary from emp e, emp m where
e.mgr_id = m.empid
and e.sal m.sal
2. Select Code Type, Type Code from Table_Name;
Thanks and Regards,
Ranganath
-Original
Simpler
SQL select * from testab;
CODE TYPE
-- --
5 1
6 2
SQL UPDATE testab SET code = type, type = code;
2 rows updated.
SQL select * from testab;
CODE TYPE
-- --
1 5
2
Hi,
(B
(BThank you for your responses.
(BWhat kind of strategies should be followed while migrating data from Sybase to Oracle
(Band non-propriatory databases to Oracle so that the down time is as low as possible.
(BThe Sybase database size is 2TB and other DB's total make up to 400GB
(Bany
Solution to second query:
SQL SELECT * FROM emp;
EMPID MGRID SALARY NAME
-- -- -- --
1 1000 A
2 1500 B
3 1 1500 C
SQL SELECT *
2 FROM emp e1
3 WHERE mgrid IS NOT NULL
thanks
to all for the help.
I kept
the separate cache.
(Still
question comes to mind ,was there a majorissue in giving read access to
the block buffer, it would save lot of validation code)
Regards
Sameer
-Original Message-From: Duncan Mills
[mailto:[EMAIL PROTECTED]]Sent:
Thanks all,
My question was related more to the 'design' of SQL language. To my mind the
expression COUNT(DISTINCT a,b) looked a natural extension of the syntax
COUNT(DISTINCT a). Even COUNT(DISTINCT(a,b)) would look good enough to me.
Probably it's too trivial a thing to bother about. Using the
Title: Nachricht
Hi
Helmut,
did you grant
"ALTER SESSION" to your database users?
regards
Volker Schoen
INPLAN RUHR
Informationstechnik
GmbH Tel.:
+49 208 / 65 91 - 950 Fax: +49 208 / 65 91 - 980 E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche
guys,
can i find out the time when an index was last used in Ver
8.1.6 ?
Regards,
Prem Khanna J.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Title: ORA-04098 Problem - Any Ideas??
Thank
You, Banarasi Babu that worked fine.
Regards
Denham
-Original Message-From: BanarasiBabu Tippa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30,
2003 9:19 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-04098
Hi all,
I'm a bit confused by some OEM/Linux concepts. I'm trying to run a user
defined job which is a simple script:
#!/bin/ksh
env /tmp/envfile
However, my preferred credentials on the node are for myself, WBUCHAN.
The /tmp/envfile is created, owned by WBUCHAN, but contains lines
Hi Gopal,
Thanks for the information.
I was not aware of this.
Regards,
- Kirti
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Thu 1/30/2003 1:03 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: Global Stats
Hi Kirti:
I am happy up here in Halifax, Canada -- for the first time in a decade we
have a REAL winter!
Snow banks 4 feet high, about a foot of snow cover on the ground, the air is
crisp and cold, -10 degree Celsius outside during the day (colder than most
freezers).
Makes me want to go camping in the
Thankyou Ruth, What about Veritas Netbackup and Tivoli software for bakcups,
Which one do you think is best and effective in long term and easy to admin.
Thanks again for your only response.
From: Ruth Gramolini [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
Dispatchers and job queue processes read tnsnames.ora on process
startup in case they need to make an outound database link on behalf
of one of he sessions using that dispatcher.
If you make a change to the tnsnames.ora, dispatchers and job queue
processes won't register it unless you restart
I work for the State of Vermont and money is always an
issue. Rman is included with Oracle so there is no additional cost.
I have no experience with other backup software for Oracle. It has worked
for me and I have been using since I started here.
Ruth
- Original Message -
On Wed, Jan 29, 2003 at 11:24:07AM -0800, Jamadagni, Rajendra wrote:
Has anyone used
ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip
yet? I found it today and seems to be a nice utility. Sweet ... and it works
even if you are not running Oracle apps.
nice metalike
Thanks! I have the 8.1.7 scripts, do I have to install
them in the 8.0.6.3 databases? Ruth
- Original Message -
From:
DENNIS
WILLIAMS
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 29, 2003 2:49
PM
Subject: RE: STATSPACK
Ruth - I think you
Title: 8i: how to find current scn number?
Hi!
How do I find out the current scn number that the database is at?
In 9i I could use dbms_flashback package...
This is 8.1.7 on Solaris 8.
Thanks,
Helmut
Vladimir,
Thanks I hadn't considered || as a function, though it is.
At first, I was going to take your word for it, but then decided
this would be an interesting test. :)
But first, I agree, you must know what you're looking for, neither
of these would work in all situations.
First, I built
Thanks Scott! That's just what I need.
Ruth
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 29, 2003 5:19
PM
Subject: RE: STATSPACK
Beth,
Since your archiving process involves many tables, I think the best approach
for you would be as follows:
Create a work table that will hold the primary key value for the master
table.
the first step of your process would involve selecting the records to be
archived from the master table,
Dick,
PeopleSoft's methodology changes slightly in version 8. Instead of creating
an Oracle user for each PeopleSoft user, there is just a single Oracle user
created as the ConnectID (default username is 'people'). The people user
works just like all of the individual usernames created in earlier
Best option is to use bcp to get the data out of Sybase ino a flat file,
then use SQL*Loader to get the data into some Oracle staging tables. You can
then use pl/sql procs to move the data to it's final destination.
Ade
-Original Message-
Sent: 29 January 2003 12:49
To: Multiple
vijaya,
partition your bigger tables so that they can be loaded by sqlldr via direct path in parallel
drop indexes (especially global indexes) before loading
do some testing first to determine optimum number of parallel streams from a cpu usage standpoint and an io contention standpoint.
try
On Wednesday 29 January 2003 16:38, Viktor wrote:
Jared,
You've got all the knowledge, for real! Is there a possibility of
I wish.
performance decrease when running statspack in Oracle 8.0.5? Thanks,
I'm running level 0 snapshots every 15 minutes on 8.0.4 with
no noticeable impact.
Jared
Prem
That is a 9i feature. One way in 8i is to regularly sample the SQL in the
buffers, run explain plan on it, and scan the results for that specific
index name. Another way is to drop the index and see if anyone complains ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
Yes, thanks that's helpful but
Here is a job, Im trying to simply call some sql but apparently I cant
pass sql as an argument. Or my string variables in the sql are double
single quotes?? Im not sure if they should be double single quotes or
just double quotes
Should this work?? It submits
I'll echo that sentiment.
'shutdown abort', 'startup restrict' was a regular part of my
shutdown scripts beginning in 1994 with 7.0.16, as
'shutdown immediate' wasn't all that reliable, even in situations
where it should have worked.
Jared
On Wednesday 29 January 2003 15:53, John Kanagaraj
R - I haven't yet been the victim of .net (thankfully), and I hope someone
with direct experience will reply. But just in case, I'll mention a couple
of ideas.
Try to sample the SQL that is being inflicted on Oracle. Microsoft
interfaces tend to have default settings for the lowest common
Peter - Robert Freeman has instructions for configuring RMAN to both Veritas
Netbackup and Tivoli. The book is Oracle9i RMAN Backup Recovery. This
might give you some ideas. Someone on this list suggested that it was easier
to learn RMAN by backing up to disk, and you could then add an MML later.
I'm far more of a developer than a DBA, but when someone told me this it set off a big
red light in my head.
We are using an Oracle Backend with a .net front front. One of our .net guys told me
that the middle tier they are using 'spawns' sessions.
We have 2 pretty distinct skillsets here so
Prem,
I found this on Google. Some guy named Thomas Kyte? He sounds like
maybe he might know what he is talking about ;-) Unfortunately I don't
have his book here with me now so I am not sure exactly what code he is
talking about, but this should be a good start for you.
Question:
Has
Henry,
Thanks. I'll remember that, IF we ever upgrade to PeopleSoft8. Getting
migrated over from ManMan to PeropleSoft has been such a chore that there is a
move afoot to stay on 7.53 for a few years more.
Dick Goulet
Reply Separator
Author: Henry
Hi all,
I'm late to the party on this, but I'm trying to understand what the
results of Jonathon's query mean.
I have a database that I suspect has a too large buffer cache. Here's
the SGA:
SQL show sga
Total System Global Area 864323352 bytes
Fixed Size 280344 bytes
Bob,
I think the job is just missing the begin and end to make it a pl/sql
block.
dbms_job.submit
(:jobno, 'begin UPDATE TIME SET STATUS = ''O'' WHERE STATUS = ''I'' ;
end;',
trunc(sysdate+1),
'trunc(SYSDATE+1)',
TRUE, :instno);
(If there are no rows in TIME, the job will fail with an
Yeah! Put it in Oracle*Names.
-Original Message-
From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Making dispatchers re-read tnsnames.ora?
Dispatchers and job queue processes read
We use RMAN to backup to disk. From disk, our sysadmins backup the files to tape.
I believe they are using Legato Networker. They frequently have problems with their
backups - I don't know the specifics. I just know that there are many times that I
have been thankful that we never
I am looking to add
a unix box to my collection of wintel machines at home. It will be used solely
for running/testing Oracle, so I don't need bells whistles. My thoughts
are either Linux/intel or Sun Ultra workstation. While it would be convenient to
be able to network it into a DSL
We would not be able to feed our families on our physical abilities
but I definitely would try beating Lisa in the game of Ping Pong.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
It's nice to have four seasons.
As long as the temperature doesn't drop under 60 during any of those four
seasons.
Four feet of snow? Here in CT, we had few inches and the traffic collapsed.
What do you drive? Sherman tank?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Title: RE: Take Care of your DBAs
Hi Dennis, Point taken. Most of us can't feed ourselves on our physical abilities... my point was that most of the people I have met in IT are not into regular exercise of any type and thought I was crazy for going running over lunch.
Sorry I did not mean
OK, that's it. My mountain bike is coming out TODAY. I don't care if it's
10F out. There's no snow, so it won't be as fun, but that's alright.
And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a
week. I admit that I spent some time in Rehab afterwards for rough
cartilage
Legato Networker!
-Original Message-
From: Peter R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 7:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Best backup software for daily backups...
Thankyou Ruth, What about Veritas Netbackup and Tivoli
I guess I'll go with this method since I have a couple of cold backups that hang on
the SHUTDOWN IMMEDIATE and will remain hung until I rectify the situation. I have had
TAR's on this but this could not be resolved. I'm just more confident to see others
doing this. Does anyone have this
Dan,
I have an intel 850mz with 512 Ram 4 disks, 1-20g 2-40g and 1 80g and
a SCSI Cdrom and SCSI 4mm tape drive Loaded with RedHat 7.2 and Oracle
8.1.7.
It contains the same data as the production server and is faster by 3
fold. The production is Dell 6300 450 mz 1 Gig and 2 Raid1 and 5 Raid5
Hemlet,
SELECT * from V$LOG; will give the status of the logfiles and
numbers;
Ron
[EMAIL PROTECTED] 01/30/03 08:25AM
Hi!
How do I find out the current scn number that the database is at?
In 9i I could use dbms_flashback package...
This is 8.1.7 on Solaris 8.
Thanks,
Helmut
--
Please see
I know I am going to catch major grief for this, but I avoid shutdown abort
when possible. Shutdown immediate can take some time, as it will do
transaction rollback in serial (where recovery at startup can do it in
parallel and as needed). The main reason I avoid it is that there are known
bugs
How can I create this simple stored procedure
Obiviously I don't have much experience but I would not think this being
as difficult as it appears
I want to run an update on a table (eventually from a job) I just need
to get the sp working... Any examples Ive seen are much too complex for
this
Title: RE: Take Care of your DBAs
Dennis,
Or on our looks including this guy I see in the mirror every morning!
I do ride my bicycle quite a bit. Over 5000 miles last year including one 204 mile ride in under 15 hours on a 95 degree day. Enough of my braggingfor now.
Jerry Whittle
Hi Henry
I don't know anything about Peoplesoft, but it is very unlikely, that any
kind of java based installer needs Java 3D.
Java 3D is more comparable to the OpenGL libary and I just can't imagine the
need for it in an installer, unless you want some neat 3D features like
animated scenes of
I would like to ask a question of this esteemed and knowledgeable
audience about running
SIEBEL applications on Oracle. Siebel insists that their CRM
application will only run with
acceptable performance if rule-based optimization is chosen, yet, as we
all know, there are
documented examples of
250 connections from the middle tier does sound a bit suspect, way over the
top. I'm assuming 'spawns' relates to establishing connections as and when
required and then disconnecting when done. I think you will find that there
is quite an Oracle overhead in handling all of the connect/disconnect
I've got Suse8.1 setup at home with a DSL connection and am planning on
putting Oracle 8 onto the box. Good setup, easily installed. Go for it ;O)
-Original Message-
Sent: 30 January 2003 15:14
To: Multiple recipients of list ORACLE-L
I am looking to add a unix box to my collection of
For $500 you can build your own Intel/AMD machine with 1GB of RAM that will blow the
doors off the Sun Ultras. You may need to spend a little more if you need some hard
drives and a cheap video card.
Install Linux, Oracle and enjoy.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On
Hi,
I looking at implementing RMAN backup and recovery to disk (fast disk)
on a high avail. system...so recovery time is crucial..
Anybody know how fast I might restore a full backup of a 600gig to a
Terabyte database.
The machine probably will have 10+ cpus HP machine and EMC disk
Lisa,
From Steve Adams site:
Despite the potential for improved statistics gathering, many DBAs have not
yet adopted modification monitoring. One of the concerns that people have is
that the monitoring might have a significant performance overhead. In fact,
this is not the case. The
Title: RE: Creating a simple stored procedure
Have the owner of MyTab grant to appropriate privileges directly, it seems you have them through a role. Also check for a synonym for MyTable as well.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Is there any way you can specify that the only permissible values (is it
called a domain?) that can be entered in varchar2 field in an Oracle
table to, for example, A, B and C?
We can restrict what values users can enter at the application level,
but it would be nice to be able to also restrict
You are kind of on the right track. The number of sessions doesn't really
matter. What matters is that they logon/logoff all the time. That is the
worst thing that you can do in an Oracle database. Why? The session will
allocate the cursors, parse them, close them everytime the session will
I agree w/ Ron. Intel Linux is the least cost alternative. I
just dumped an old Sparc 5 and bought a PIII 450 128mb ram for $139 +
shipping. You can't beat the cost of old intel machines, plus I can get
hardware/software anywhere.
Gene [EMAIL PROTECTED] 01/30/03 11:30AM
Dan,I have an intel
You gentlemen do not know what it is like to have snow related traffic
problems.
In Atlanta a snow flake can cause a multi-car pileup with a 3 hour
commute delay. Why just having cold weather (20 degrees F) will cause
schools to close.
Boy I miss New England.
Transplanted CT Yankee,
Ron
[EMAIL
Title: RE: Restricting the range of values in a field
create or replace trigger my_restrictions on
my_table after insert or update as
declare
unacceptable_values exception;
begin
begin
if :new.my_restricted_column not in ('Blah1','blah2','Blah3') then
--- Grrr .. user errored
spank_user;
Title: RE: Debate on rc commands Solaris and Oracle
Okay so Jared - you had scripted the shutdown abort then startup restrict then shutdown immediate even on OLTP's in your rc's without even waiting to see what would happen with a shutdown immediate - right. Well, if it is good enough for
On Thu, 30 Jan 2003, Gogala, Mladen wrote:
Yeah! Put it in Oracle*Names.
Will it make a difference? Does a dispatcher really re-query Names
every time it tries to make a connection? No caching of service
addresses? You promise?
Off I go to convert my 300-instance organization to rely on a
Title: RE: Take Care of your DBAs
Hoops ??? they built a extremely nice Basketball court for us (open 24 hours) ... but I have never ever been there, no time. A new 4/5 thou sqft workout area is being built too. One in a while I go to the new cafe where they have those 63 plasma TVs
DBA's,
How can i see the last(date) access(DML) in a
table?
Thanks
Adriano
---BeginMessage---
Hi Russ,
When you run R3trans -d, it creates a trans.log file in the current
directory. This will help you debug this. Errors in that log file can be used
to look up possible problems in SAP's OSS.
On the app server I assume you've edited the .dbenv hidden files and are
Bob,
where does the table mytab exist? - probably not in the same account as
where you are creating the sp. in this case, you need to do two things.
change the sp to say:
update {schema}.mytab where {schema} is where the table exists.
secondly, from {schema} you need to : grant select,
Beer Pong is a lot of fun too. ;^)
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 1/30/2003 10:09 AM, Gogala, Mladen [EMAIL PROTECTED] wrote:
We would not be able to feed our families on our physical abilities
but I definitely would try beating Lisa in the game of Ping Pong.
You ought to see what happens in Phoenix when it rains. Wrecks, traffic
snarls, yuck. It must be the fact that they never see anything remotely
resembling water (except in pools).
Oh yeah, that's right. I left there years ago for Montana.
Never mind. Snow, rain, four seasons. This is living
Title: RE: Creating a simple stored procedure
Hi Bob,
first of all who are you creating the sp as?
If it's not the table owner, is there a synonym declared? Is update granted via a role? If it is, grant update directly to the procedure owner.
Or forget all this and run the proc as the
How about:
alter table my_table add (constraint domain_ck check (my_column in ('A',
'B', 'C') ) ) ;
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Thursday, January 30, 2003 8:34 AM
To: Multiple recipients of list
Lisa - My bad. I've gotta learn to put more emoticons in my messages. :-)
Actually I thought you had an excellent point, sorry for taking it in a
different direction. I run and lift weights regularly (no coordination
required) and feel regular exercise should be a part of the DBA's week.
Medically
I have had a SHUTDOWN IMMEDIATE hang for over 4 days on a test database that had
little if any activity going on it so it could not be doing rollbacks for 4 days. It
is something else that is a feature of 8i. I'm not keen on the SHUTDOWN ABORT
either but I cannot have my database hang
Dan, you won't be running alone. I had a bad corruption experience with 7.3
on NT (who hasn't), that I highly suspect was due to ABORT, but have never
confirmed. Yes, depending on the situation, I have used ABORT with a
followup IMMEDIATE many times without problem since then. My issue with
Hey
Dan;
I currently am running a Sun Sparc 20 at home with oracle 8.1.7.4 and am adding
9.0.2. I got mine off of e-bay as you were talking
about.
The Sun software wasprety easyto load and
configure so far. I have a DSL setup and its working just fine. I
can even get to the DB from here
At 08:10 AM 1/30/2003 -0800, Fink, Dan wrote:
I know I am going to catch major
grief for this, but I avoid shutdown abort
when possible. Shutdown immediate can take some time, as it will do
transaction rollback in serial (where recovery at startup can do it
in
parallel and as needed). The main
I used to see the shutdown immediate hang on OpenVMS (Oracle 7.x)
platforms, never did happen on my Unix machines, and I never did have to support
Oracle on Windoze :). I did notice if I stopped the developers from
submitting jobs via dbms_jobs and forced them to use VMS batch jobsthen
Hello All,
I have a requirement to update a table which is hash partitioned and having
a local prefixed index with keys (STORE,
SKU, ACTION_DATE, TRAN_TYPE) . I have to update only one column called
'WH' to a new value where store=store#, wh= 0 and tran_type = -1. Explain
plan shows me FULL
Hey Dan,
I picked up a Unix Workstation cheap (they were going to junk the 500Mhz
Alpha here at work), installed RH7.1, and it's been running at home ever
since. I've got a Linkys BEFSX41 fire-walling VPNing router that I plug my
PC (Winders/Linux) and Alpha into, which then in turn plugs into
alter system checkpoint;
select CONTROLFILE_CHANGE# from v$database;
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: 8i: how to find current scn number?
Hemlet,
As I recall, the act of executing a query will cause the value of the global
scn to change. SCN is used for 2 purposes, for querying and committing.
Someone on the list has a discussion of scns on their website, but I am
drawing a blank as to which guru it is.
-Original Message-
Sent:
Title: RE: "Take Care of your DBAs"
Me
offended, not possible. Maybe the offender, but not
offended.
Yea,
yea I know, take this to the OT list so we can take it straight to the
gutter!
Dave
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January
Michael:
Would you please post a summary of findings here on the list?
I
too have a Siebel implementation going on, and we are
experiencing performance issues, and have set all the
Siebel-specified initSID.ora parameters.
I am in California, and the database is 'across the pond'
in
Title: RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED?
Brian,
If time is of the essence and you have EMC BCV's, look at Time Finder. I believe that's EMC's piece of software that allows you to sync and split a third mirror. That will be much faster for recovery than
Check Constraint!
-Original Message-
Sent: Thursday, January 30, 2003 9:01 AM
To: Multiple recipients of list ORACLE-L
Is there any way you can specify that the only permissible values (is it
called a domain?) that can be entered in varchar2 field in an Oracle
table to, for example, A,
Dan
I
personally run Linux/Oracle on all of my own test/dev boxes. But I'd like
to vote for Solaris/Oracle.
I
would also recommand the Sun Blades, which are based on PC architectures and the
advantage
is it
uses PC RAM and IDE hard drive, so it's cheaper than the Sun parts. You
can get a
SELECT COUNT(*)
FROM ( SELECT DISTINCT col1, col2.
FROM ..)
--- Charu Joshi [EMAIL PROTECTED] wrote:
Thanks all,
My question was related more to the 'design' of SQL language. To my
mind the
expression COUNT(DISTINCT a,b) looked a natural extension of the
syntax
Title: RE: Debate on rc commands Solaris and Oracle
Yes on Solaris, Aix, etc.
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 10:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Debate on rc commands Solaris and Oracle
At 08:00 AM 1/30/2003 -0800, Ron Rogers wrote:
You gentlemen do not know what it
is like to have snow related traffic
problems.
In Atlanta a snow flake can cause a multi-car pileup with a 3 hour
commute delay. Why just having cold weather (20 degrees F) will
cause
schools to close.
I've got you
Read docs about CHECK constraint.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 11:00 AM
Is there any way you can specify that the only permissible values (is it
called a
http://www.ebooks.com/items/item-display.asp?IID=41070
http://www.wiley.com/remtitle.cgi?0-471-22436-7
-Original Message-
Sent: Thursday, January 30, 2003 12:04 AM
To: Multiple recipients of list ORACLE-L
Hi harvinder
Can you please point me to the
High-Performance Oracle: Proven
Any votes for startup force?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: RE: Middle Tier spawning sessions, possible performance issues
I read somewhere that for apps that constantly logon/logoff (like web apps), one possible thing to do is increase the cache size for the AUDSES$ sequence. Anyone done this and seen improvements?
Curiously,
Steve Orr
Sounds made to order for a check constraint on the column of interest.
Pat
Is there any way you can specify that the only permissible values (is it
called a domain?) that can be entered in varchar2 field in an Oracle
table to, for example, A, B and C?
We can restrict
On Thu, 2003-01-30 at 10:09, Gogala, Mladen wrote:
It's nice to have four seasons.
As long as the temperature doesn't drop under 60 during any of those four
seasons.
Four feet of snow? Here in CT, we had few inches and the traffic collapsed.
What do you drive? Sherman tank?
--
If
1 - 100 of 208 matches
Mail list logo