Ferenc,
If I didn't say it before, I'll say it now: This was one of the better messages
I've seen for a very long time. Jolly good laugh, as the English would say.
Remind me to take you to lunch next time I'm in Melbourne (as if I'm in Australia
very often ... ).
Take care.
Mogens
I am running an Oracle v 8.1.7.3.0 version db on Sun solaris 2.6 and the problem I
face is that all of a sudden all new connections to the database just hang [ the conn
is not made ] and if at all a connection can be established using svrngrl [ only this
] I find that no queries can be
You may want to read up on table monitoring.
Jared
On Tuesday 28 January 2003 11:10, Koivu, Lisa wrote:
Hi everyone,
Back to the lovely world of Oracle :) I've been reading up on statistics.
Out of the 8.1.7 doco:
/*
Partitioned schema objects may contain multiple sets of statistics. They
Naveen,
What is symcjit.dll, what happen if not renaming it ?
Rgrds,
Sony
-Original Message-
From: Naveen Nahata [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Problem on P4 intel servers
The
Seema,
Yes, there is. On NT4 it was called MS Cluster Service, not so much cluster
'scalability-wise', but it allowed for failover. Oracle supplied some software on top
of that: Oracle Fail Safe. If you only want failover, it's sufficient to use those
product, you don't need RAC or OPS.
It
The person I know who can answer this is the guy who was Mr Replication
in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was
truly a pioneer with that stuff. I'll ask him and get back.
Mogens
DENNIS WILLIAMS wrote:
Chaim - I agree with your note, but isn't that basic
Hi Gurus,
We have an OLTP 8i database on Win 2K RAM 1GB with about 10 million rows,
Total size 100GB. Have done a bit of tuning here and there (see stats below).
What do you read of these stats?
SVRMGR Rem The init.ora parameters currently in effect:
SVRMGR select name, value from v$parameter
We have a 3rd party application [Parametric Technology
Windchill] where a new module has been implemented which
copies in files into the database using DBMS_LOB.WRITE
The LOBSEGMENT has a CHUNKsize of 32K and the Database
BlockSize is 16K.
There are high waits on direct path write. Queries
on
Guys,
one of my developers is using sequence to auto-increment the value
of a column while inserting.
he has created a sequence like this.
SQL create sequence testseq start with 1;
and then uses a INSERT statement as below in a JSP.
insert into testtab values ('BREAD'||testseq.nextval);
Jp:
Is the sequence cached? Check out Note:62002.1 on Metalink - Applications
which use Oracle sequences which have the CACHE option enabled will often
'skip' values. This article discusses the cache option, why numbers can be
lost and how to minimize this occurrance. You'll either want to pin
symcjit.dll is Symantecs's Just-In-Time Compiler dll, it is basically a
faster option to javai.dll for java app executions.
Another work around, is to copy the files from the install disks to your
hard drive, then search these directories for any occurrence of
symcjit.dll, and replace them with
Ther is something called 'cache' in a sequence definition which has a default
value of 20. Which means 20 values of the sequence will be pre-fetched and
kept in the memory.
this is done to avoid latching issues.
when u shutdown the instance the pre-fetched values are lost, and they are
not
Title: RE: Slightly OT: Development Vs. Production DBA
DITTO!
... I personally like it when they come screaming to me (Iam the
"production" dba for the most part)that the test database is all messed
up... couldn't be them... they haven't touched their code... all they did is
point the same
Probably you use the (default) 'cache 20' and shut down the database between the
'BREAD4' and 'BREAD21' insert.
Or you use OPS/RAC, which cause each instance to cache this '20' numbers.
This can be avoided by using the 'nocache' option, but then you serialize access to
the sequence number, which
Hi Jp
The gaps in sequences can most likely be attributed to the sequence being
cached. The cache option (default) pre-allocates a set of sequence numbes
and keeps them in memory so that sequence numbers can be accessed faster.
When the last of the sequence numbers in the cache has been used,
Title: "Take Care of your DBAs"
Thanks
for this article. I will forward to damagement.
Dave
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 28, 2003
3:24 PMTo: Multiple recipients of list ORACLE-LSubject:
"Take Care of your DBAs"
I have a high procedure (many INSERT's and UPDATE´s).
This procedure generate insert's in UNDO TableSpace for rollback.
I want to know if exists any way for don´t generate insert´s in UNDO
Tablespace.
Oracle 9i / NT
Thanks.
--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil
Guys,
one of my developers is using sequence to
auto-increment the value
of a column while inserting.
he has created a sequence like this.
SQL create sequence testseq start with 1;
and then uses a INSERT statement as below in a JSP.
insert into testtab values
('BREAD'||testseq.nextval);
Breno,
There's no way to do this because it's the central pillar of Oracle's read
consistency mechanism.
It's possible to minimise or suppress redo but undo is out of your control.
regards,
Mike Hately
-Original Message-
Sent: 29 January 2003 11:39
To: Multiple recipients of list
Hi List,
I have the below query which returns 13 records. In this I want to display
only the 1st row. Is it possible to do this through rownum or any other
function or pseudo column? If so, please let me know the same. Any help in
this regard is very much appreciated.
select 'shipment'
Title: "Take Care of your DBAs"
Here's
that "development DBA" alias again.
sigh.
Pat.
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
29, 2003 7:54 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: "Take Care of your DBAs"
Hi Friends,
We are going to upgrade our database(Oracle9i) with Unix server(AIX5.2), I
would like to know best backup software for new production server with
250-350Gb database size. Ours is 24X7 shop, so we are going to take daily
hotbackups. Any ideas and experiance from gurus!!!
Thanks
hi j.p.!
try with
SQL create sequence testseq start with 1 NOCACHE ORDER;
regards
daniel
oraora oraora wrote:
Guys,
one of my developers is using sequence to auto-increment the value
of a column while inserting.
he has created a sequence like this.
SQL create sequence testseq
Title: Peoplesoft & Oracle
HI
Lisa
Don't
worry too much about fixing up the database it will only benefit the
application.
You
can spread the tablespaces around, I have also found that the default install
scripts shove all the indexes into one tablespace, you can go ahead and add more
Yes you can go for Active-Active cluster configuration of RAC or else Active-Passive
configuration of Oracle Fail Safe on Windows Cluster. Both of these are available on
Windows 2000 cluster.
Let me know, if you want more info.
HTH,
Rajesh
-Original Message-
Sent: Tuesday,
Hi Everyone,
We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models
defer a lot.
Is there any tool available for this kind of migration. Can we do this migration with
out any tool.
If yes please let me know like how should we go about this migration.
If there are
When Oracle 'expects' to visit a buffer more than
once in a single call, it will hold the cache buffers
chains latch long enough to create a pin (in this
case a memory structure that associates the
session with the buffer) and link it into the linked
list of current users (x$bh.usprev, usnxt) of
Select * from
(
select 'shipment' table_name,ce.display_name,st.timestamp, sequence
from shipment_timestamp st, customer_event ce, xm_field xm
where shipment_id = 10402344721477
and ce.CUSTOMER_MOT_ID = 1040130035205
and xm.field_id = ce.field_id
nd st.event_id = xm.event_id
union
select
We are doing the same upgrade, and we will continue to use
rman for all backups.
Ruth
- Original Message -
From:
Peter R
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 29, 2003 7:39
AM
Subject: Best backup software for daily
backups...
Hi List,
I found the answer to my query myself and here goes the solution:
select x.* from (select 'shipment' table_name,ce.display_name,st.timestamp,
sequence
from shipment_timestamp st, customer_event ce, xm_field xm
where shipment_id = 10402344721477
and ce.CUSTOMER_MOT_ID = 1040130035205
Title: RE: tuning forms/reports application
Connor,
Forms is dumb ... I mean it doesn't think it is important to use dbms_application info, you have to do it manually. The statistics parameter ... gosh .. never got it to work right against 7x, 8x and 9x ...
For my developers, I tell them
Hi Roy,
I don't know if you solved your problem yet but I have a similar situation
here. I have an Oracle account used by PHP programs (third party programs)
to access some tables. I don't want anyone to log in to the database with
this account unless the connection comes from apache and
Mike,
I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is
is correct ?
When I execute a high procedure, many inserts in UNDO tablespace
ocurres, so many inserts in REDO´s are genereate.
I want to avoid this REDO´s generation.
My tables and
Title: RE: Perl
Okay ... a question from a colleague ...
How do you get python to work with Oracle ... for perl there DBD: and DBI: anything similar in Python? My knowledge of Perl is as good as my knowledge of Python ... /dev/null
Raj
__
David Lisa,
1st point is that were still on PeopleTools 7.53 so this may be somewhat
dated. Anyway, go to Peopletools, utilities, use Peopletools options. Uncheck
the Grant Access option low behold, PeopleTools will not try to create a
user via the grant connect to syntax that is so out
What privileges are needed for a "toad" user to view another users
packages.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204
Title: RE: Peoplesoft Oracle
David, David, David.
THANK YOU, THANK YOU, THANK YOU for your detailed response. Wish I could buy you a beer... a virtual beer will have to do :)
Have a great day
Lisa
-Original Message-
From: david davis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Hi,
the issue of database access from python is addressed here :
http://www.python.org/topics/database/
http://www.python.org/topics/database/
with specific modules (incliuding Oracle) listed here :
http://www.python.org/topics/database/modules.html
Title: RE: Global Stats
Hi Jared,
Actually I think monitoring won't work in my case. Data loads fire throughout the day and the docs say that in 8i, analyze can fire based upon table monitoring sometime within 3 hours after data changes. I would rather include a manual fire of analyze in
hi\
just in case you are still looking for a solution:
the entry for the INSO_LINK seem sto be alright. If the retry doesn't succeed, then
try to link the file manually
cd $ORACLE_HOME/ctx/lib/
/usr/bin/make -f ins_ctx.mk install
if this doesn't work then check the error log. I never had any
Title: RE: Peoplesoft Oracle
John, Henry, Lindsay, David,
Thanks for your responses. At least I don't feel like I'm completely out in the cold here.
John: My boy is huge, teething, not sleeping much, standing and taking his first steps, had his first bloody nose already. Sleep? What is
Dick,
The grant users option has been around since release 2 (was on installation
table back then). I had not tested turning it off. Our practice is create
the userid then change the default tablespaces then notify clients of new
userid. It works for us, because the DBA's happen to be the
think CAREFULLY about this as it invalidates your recovery procedures.
Nologging means there is nothing in the redo logs to be applied. and
your backup is invalid.
Other than that, I suggest you do some research in the Oracle docs. A
VERY brief check (search on nologging) brought me this
Breno,
100mb of redo in 20 minutes is not all that high. I have seen far
worse (as I am sure most on the list have as well). Why do you perceive this
as a problem? Are you seeing poor performance or waits?
Is the generation of redo (and archived logs) causing the system to
halt
On Wed, 2003-01-29 at 09:04, Jamadagni, Rajendra wrote:
Okay ... a question from a colleague ...
How do you get python to work with Oracle ... for perl there DBD: and
DBI: anything similar in Python? My knowledge of Perl is as good as
my knowledge of Python ... /dev/null
Python defines a
Title: RE: Perl
There are two resources:
http://www.zope.org/Members/matt/dco2
http://www.computronix.com/utilities.shtml
The installs are not as nice as DBI but the products work. We've been using cx_Oracle in production for over a year now and have no complaints. Here's an Oracle
I tried to grant select on column level security and failed (on 8.1.7
and 9.2). I heard some said column level security on work on insert
update and reference. Is it true? any other way to pass around?
SQL grant select (update_date) on pay_update to user1;
grant select (update_date) on
Because I'm picky. I ruled out OracleTool because it's web-based. While it
may be an advantage at times (don't need to install on every machine I use),
it's a whole number of layers I don't want to troubleshoot when in Crisis
Mode.
OraC is pretty cool. I looked at it when I got O'Reilly's
That's a great idea--many thanks. I bet I could put up a table of permitted
username/client program combinations just do a SELECT from it translate
the no_data_found exception into a 'connect via your program verboten!'
message...
Thanks again,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC
Title: RE: Perl
Good
question Raj! Hey Steve give us the run down on connecting to Oracle with
Python.
I've
downloaded the Activestate version to try!
Denham
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29,
2003 4:04 PMTo:
vijay,
oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects data from sybase to oracle.
however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you
Same as Oracle privs
...
If you give execute,
other user can see only package spec, if you grant 'create any procedure' they
can see the package body/procedure/function body as
well.
* to see
procedure/function/package spec you need on of
1. execute (if
grant is made to public)
2.
Robert,
Thanks for point that out. Also, if there is index on the table,
redo will still be generated for index.
Richard
-Original Message-
Sent: Tuesday, January 28, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
/*+ append */ alone does not prevent redo generation. Only
Title: RE: Debate on rc commands Solaris and Oracle
System Administrator says he doesn't trust that the rc commands will stop if the database doesn't want to shutdown and even if it does would want to shutdown with scripts beforehand so that a DBA could connect and resolve the issue. Other
You're correct in saying that your undo blocks are protected by your redo
files.
What type of operation are you performing on your table? I ask because only
a small subset of commands support the NOLOGGING feature; the remainder will
generate redo as usual.
If you're not using a syntax that
Create a view (including only columns you want user1 to see) and let user1
use this view instead of table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 10:24 AM
I tried to
I completely forgot all about this, but the install I just completed went
without a hitch. I'm running Win2K SP3 (bleah) and installed 9.2.0.1.0
downloaded from OTN last night.
Is it possible that someone (perhaps in SP3) fixed this?
Rich
Rich Jesse
Only 'Execute' right should be enough.
Regards
M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-2576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]
Jeffrey Beckstrom [EMAIL PROTECTED]
gcrta.org
Sent by: [EMAIL PROTECTED]
29.01.2003 15:48
Please
breno,
i believe the 'no logging' option only applies to data that is direct loaded into your tables
therefore, you may be able to bypass logging if you used sqlldr or 'create table as select'
good luck,
steve
Breno A. K. Magnago [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/29/2003
I agree in principal with Dan's thesis, but I'll add something.
Don't do things that generate unnecessary undo and redo, either.
One common example is SQL that updates a column to a value that it
already contains. For example, we see things like setting a flag='y'
without checking that the flag
Title: Take Care of your DBAs
I love
this article. I forwarded it to
damagement too because they havent been showing enough love for the DBAs
lately ;-).
Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency
Parkway,
Dan,
Is the generation of redo (and archived logs) causing the system to
halt due to the archive_dump_dest filling up?
YES
I'll work to minimize this situation. Thanks.
--
Breno A. K. Magnagomailto:[EMAIL PROTECTED]
Wednesday, January 29, 2003, 1:19:50 PM, you
Upgrade 8.1.6 to 8.1.7 and then apply the patch. Read
the docs carefully before applying the patch it is an
ugly puppy.
--- [EMAIL PROTECTED] wrote:
Im doing an upgrade from 8.1.6. to 8.1.7.4.
Is there any benfit of doing the upgrade from 8.1.6
to 8.1.7, using
ODMA then patching to
What is Buffer Cache Hit Ratio? LC Hit RAtio?
What's the hardware?
Run top or mpstat or sar to get the system stats...
We had seen somewhat somilar bstat estat data...
+Rachna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 29,
I believe the problem affects only 8i.
9i is ok.
--
Lyndon Tiu
Quoting Jesse, Rich [EMAIL PROTECTED]:
I completely forgot all about this, but the install I just
completed went
without a hitch. I'm running Win2K SP3 (bleah) and installed
9.2.0.1.0
downloaded from OTN last night.
Is
The problem was with lower versions of the database. The newer version
of symcjit.dll are included on the newer media. I am not sure what
version started to include the correct dll version. I am guessing 9i
release 1.
Don Bricker
Database Administrator / System Administrator
Illinois
Some of you will no doubt be interested in this:
http://www.knownow.com/cworld/dm/excel.html
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
AFAIK, in 8i+ tablespaces can be created with theNOLOGGING clause
LOGGING | NOLOGGING
Specify the default logging attributes of all tables, indexes, and
partitions within the tablespace. LOGGING is the default.
The tablespace-level logging attribute can be overridden by logging
Title: RE: Perl
Thanks a bunch ...
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but
having
Breno,
There is your problem. Don't try to solve it by trying to eliminate
undo. I have run into that situation several times. The key is to set up the
database management processes to handle the situation.
Things to think about:
1) Increase the size of the device where
Mike,
What type of operation are you performing on your table?
INSERT INTO A.TABLE1(COL1,COL2)
SELECT COL1,COL2
FROM B.TABLE2@DB_LINK;
I think that command support the NOLOGGING.Is is correct ?
The table B.TABLE2 and all indexes are in NOLOGGING Option.
--
Breno A. K. Magnago
Hi
Gurus
I am not a DBA,
but I have request from client to move their oracle 8.1.6 database from a
Unix server to W2K. Can somebody lead me to documentation in moving entire DB or
any other resource that will help me accomplish the task?
Thanks a ton in
advance
Regards
Shiva
Hello Listers,
How to find out the COUNT of DISTINCT values of multiple columns?
For eg.
SQL SELECT DISTINCT ename FROM emp;
-- This works.
SQL SELECT COUNT(DISTINCT ename) FROM emp;
-- So does this.
SQL SELECT DISTINCT ename, job FROM emp;
-- And this too.
SQL SELECT COUNT(DISTINCT ename,
A few days (or was that weeks??) ago, someone posted some
problems they were having connecting to a database defined in their tnsnames.ora
file. The problem was resolved when they found out that there was a rogue
tnsnames.ora file residing in the same directory as the binary. The
binary
1. Install software on W2K
2. Configure DB appropriately
3. Take a cold backup from your Unix DB
3.1 Make 4 copies, 1 for actual usage, one stand-by two for
off site backup
4. Import on W2K database
5. Start Database, add a dollop of Whipped Cream and enjoy
...
Raj
Why do they want to move to W2k? Was it running too quickly for them under Unix? ;^)
You can use export/import to move the database. Hopefully the database isn't very big.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 1/29/2003 12:59 PM, Baswannappa, Shiva [EMAIL PROTECTED] wrote:
Hello everyone,
I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3
instance?
Thanks in advance,
Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Has anyone run into this problem...
I created a standby database using RMAN and have found that there is an
archiving location defined for this standby database,
log_archive_dest_11 which points to the $ORACLE_HOME/dbs directory. I
didn't define a logging destination 11 and there isn't one
Here is a link that I found for a Perl script for hot backups. Just have seen a bunch
of chatter about perl on the list lately so just wanted to throw this out in case
someone finds it useful.
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci857677,00.html
Dave
--
Please see the
Hi Everyone!
I have been tasked with finding out how often connections are made between
databases using DB links. Does anyone know of a tracking or auditing
tool, or perhaps a audit methodology, that would provide this information?
Thanks,
Mike
---
In linux, it seems difficult, I have tried linux iostat and sysstat-iostat,
non of them seems to work properly with util column in iostat report. Though no
activity on the server at all, iostat always report utilization of the partitions
100% Why?
I also searched google and found
Title: RE: Rogue TNSNAMES.ORA files Revisited
Yup ... learned it the hard way !! At-least AIX is *normal* (fingers crossed).
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
Shiva
First I would suggest you consider whether this is a good use of your
client's money. This is a somewhat complex task that will be a good learning
experience for you personally, but may cost the client. You should also
consider how you will be able to confirm the quality of your work
Title: RE: Debate on rc commands Solaris and Oracle
Paula,
Shutdown abort is not recommended as the file
checkpointing is not done during shutdown abort. If you need to perform
shutdown abort, then, it is preferred to bring up the db with startup restrict
(so that the users wouldn't
Danny Thilaga,
You might find this useful. ;-)
...JIM...
[EMAIL PROTECTED] 1/28/03 2:10:28 PM
Here ya go:
create or replace package radix
is
/*
base code courtesy of Thomas Kyte
*/
function to_base( p_dec in number, p_base in number )
return
I believe that an 8.1.7 statspack can run on an Oracle8 or higher database.
Dave
-Original Message-
Sent: Wednesday, January 29, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Hello everyone,
I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3
-Original Message-
Is it better/faster than a ksh script?
--
Whether you use perl or ksh, the main purpose of the script is to build a
command line and run it for whatever backup method you are using. After
that, virtually all of the time is used
Charu,
The COUNT() function requires a single expression. ename, job is
not a valid expression. ename||job is a valid expression since it will
return a single value.
Another alternative would be
select count(*)
from (select distinct ename, job from emp);
Dan Fink
-Original
Perl People,
Boy that sounds like a blast from the past with the purple people
eater...
There is an interesting Perl hot backup script at
http://www.searchDatabase.com/tip/1,289483,sid13_gci876060,00.html
Not understanding Perl yet and liking to keep things simple, The code
seems link and
Brian,
The order in which the TNS connection searches are performed can also easily
be determined by using the 'truss' command on Solaris. I used this to prove
my case to a PHB of a smart-aleck Developer who was side-stepping our move
to an Oracle Name Service in a prior assignment.
I see what
Title: 10046 Tracing ...
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.
It is probably a better tkprof interface, but intuitive
Title: RE: SQL question
Joshi,
SELECT count(*)
FROM (SELECT count(*)
FROM flight_legs
GROUP BY d_actual_time, event_type);
SELECT count(*)
FROM (SELECT DISTINCT d_actual_time, event_type
FROM flight_legs );
The first one took about 37 seconds in returning a count of 357331.
And, can you have two columns as arguements for COUNT?
I guess its either one column or rows
+Rachna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 1:19 PM
Hello Listers,
How to find out the COUNT of DISTINCT
Title: RE: SQL question
Elegant or not, here's how I'd do it
select count(*) from
(select distinct ename, job from emp);
-Original Message-
From: Charu Joshi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: Re[4]: undo tablespace
I think it might be a typo, or I've not had enuf coffee yet today, but the nologging on b.table2 wouldn't impact the redo logging; nologging on a.table1 would, tho...
-Original Message-
From: Breno A. K. Magnago [mailto:[EMAIL PROTECTED]]
Sent:
I believe that Advanced Replication was just a name change,
introduced in either Oracle8 or Oracle8i.
PB
--- Mogens_Nørgaard [EMAIL PROTECTED] wrote:
The person I know who can answer this is the guy who was Mr
Replication
in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
shooting hoops? Just out of curiosity, how many people on the list have a
group of DBAs at their company that they shoot hoops with?
Some good points, some odd ones. I'll echo Patrice's sigh (as someone who
enjoys both parts of the job).
Jay
-Original Message-
Sent: Wednesday,
Ruth - I think you can, but you must run the 8.1.7 scripts there. Do you
have the 3 Oracle magazine articles that introduced STATSPACK? I think this
was mentioned there.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 29, 2003
Hello everyone,
For Tivoli (TSM) backups there is a file called inclexcl on each backup
client, which lists the directories which are included and excluded for
backup..(along with their management classes)..I was wondering if there is a
similar file in netbackup configuration which can give the
This sounds cool. You will of course share this, won't you?
Re Jareds_tools - I just made a suggestion and got my
name in the code. :)
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/29/2003 07:30 AM
Please respond to ORACLE-L
To: Multiple recipients of
1 - 100 of 152 matches
Mail list logo
