Hi all,
I have some problems with rman and Legato Networker on Win2000. I am
using a catalog and my oracle version is 8.1.7.
How rman/Legato knows which nsrnmo -script it will use, I mean I have
created script for each instance with filename nsrnmo_DBNAME.bat.
Also how do I specify which
Anyone whom has a good example on how to check how many rows (without opening the
file) does a text file consists of?
What is the command?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Title: RE: Unix - scheduling
Try
this one
select
distinct e.owner,f.file_name ,e.segment_name from DBA_EXTENTS E ,
DBA_DATA_FILES FWHERE E.FILE_ID = F.FILE_IDand f.file_name =
'insert your filename here'and e.owner
= 'insert the object owner here'
HTH
Lee
-Original
David,
I recall that there is a limit (42 characters?) on the name of the
dictionary file.
2 ways round it. Create the file in the top level ie /export/dict.ora or
create a symbolic link with a shorter name.
I have a page on my web site which mentions this problem
(www.hcresources.co.uk).
Anyone whom has a good example on how to check how many rows (without opening the
file) does a text file consists of?
What is the command?
I don't know about without opening the file.
However, you can use the utility 'wc' with the -l flag to count rows in a
file.
The syntax is: wc -l
Roland
wc -l filename (assuming you're in unix)
Mike Hately
-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L
Anyone whom has a good example on how to check how many rows (without
opening the file) does a text file consists of?
What is the
Try the following which will give the number of line in the file
cat filename | wc -l
HTH
John
-Original Message-
Sent: 03 July 2002 09:43
To: Multiple recipients of list ORACLE-L
Anyone whom has a good example on how to check how many rows (without
opening the file) does a text
Thank you Scott for supplying a well-written summary of SCN usage within OPS
nodes.
I was interested in If the gap in the log sequence gets to big Oracle will
force the idle node to do log switches
I was not aware of that and whilst I believe you, I cannot see what the
reason behind it is.
I'll happily stand corrected but I didn't think the
http component actually had its own assistant. Under
my ORACLE_HOME/bin (92) I can only see
dbca
netca
emca
hth
connor
--- Jonathan Gennick [EMAIL PROTECTED] wrote:
I'm trying to recover from an install that bombed.
The final step in
the
ha ha... funny
-Original Message-
Sent: 03 July 2002 03:05
To: Multiple recipients of list ORACLE-L
I would say it is unbreakable. Can't break what's already broke.
-Original Message-
Sent: Tuesday, July 02, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
In other
Can this be used to specify the allocation, autoallocate or uniform?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
I believe also that you can't actually run LogMiner against an 8.0
database but have to generate the dictionary file (which you can do)
and then run the mining procedure with the dictionary file against an
8.1.x database
--- [EMAIL PROTECTED] wrote:
David,
I recall that there is a limit
Hi,
I am not able to connect from my oracle client to an oracle db server (NT)
When i try to configure and test for the ora service(from my work station) it says
Connecting...ORA-12545: Connect failed because target host or
object does not exist The test did not succeed.(this particular
On Wed, Jul 03, 2002 at 01:53:25AM -0800, [EMAIL PROTECTED] wrote:
Try the following which will give the number of line in the file
cat filename | wc -l
You might find this interesting:
http://www.ling.helsinki.fi/~reriksso/unix/award.html#cat
:-)
Tim.
--
Please see the official
Does anyone have the bug number on this security bug?
Thanks,
Cherie Machler
Oracle DBA
Gelco Information Network
Connor
Rachel is right on target. You can create the package DBMS_LOGMNR_D in the
v8.0.x database to generate the dictionary file (after stealing the source
files from a v8.1.x database), but running DBMS_LOGMNR must be done in a
v8.1.x database.
If nothing else, create an extremely tiny v8.1.x
On Wed, Jul 03, 2002 at 09:02:34AM -0400, Ray Stell wrote:
I want to move a db to a different machine with a different disk
layout. If I create the db and tablespaces on the new machine, can I
use a dmp file created by exp full=y to move all the data? The dmp
tries to create the
List,
I have a question regarding db_block_lru_latches, I have read in some
book(can't remember) which the best number for this parameter is (number of
CPU)*6 or db_block_buffers/50.
But these two result is diffrent,anybody have any idea what's the best
configuration for this parameter.
In my
John,
No you can't. Here is an excerpt from one of Jonathan Lewis' articles on his
web site:
The final consequence of converting a dictionary tablespace to a locally
managed tablespace is that xxx_tablespaces will show the extent_mangement to
be LOCAL, but the allocation_type to be USER.
[EMAIL PROTECTED] on 07/03/2002 04:17:56 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Simon Anderson/SSplc)
Does anyone have the bug number on this security bug?
Thanks,
Cherie Machler
Oracle DBA
Gelco Information
Yes. You should have additional background processes for OPS. Second, you
can see if OPS is installed by looking at the banner of SQL*Plus. It will
indicate if OPS is installed.
You can also look at V$INSTANCE OR V$DATABASE to determine what status the
instance is. SHARED, RESTRICTED or
I know it means either logging or or searching a init.ora file but how about
select name,value from v$parameter where name = 'parallel_server';
I cannot see anything obvious from ps -ef
John
-Original Message-
Sent: 03 July 2002 16:18
To: Multiple recipients of list ORACLE-L
Is
Cutting and pasting from an old post: by Jonathan Lewis:
The upshot of it seems to be that anyone who can get an sql session can look at
any data, and given 'create view' as well can change data at will. You may be
able to use the database in production, but only if your users can't access it
I got the errors fixed. The reason the errors were generated because it
could not find time interval between July 1 and July 2. I was able read
redo log with LogMiner but now I come with another question why report
display output in HEX data and why it only shows username is SYS only? I
want
Roland,
How about counting black cats in the dark room without turning on the light?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 4:43 AM
Anyone whom has a good example on how
Not sure that I fully understand that.
Does that mean that tablespace_migrate_to_local does not actually give me
any of the advantages of locally managed tablespaces in terms of extent
management?
John
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: 03 July
Title: Accessing views across a db link
Great
hint. I didn't know that one existed. However, our local DB is V7.3.3 connecting
to our remote DB V8.1.7. That hint didn't exist back then. Oh well, I guess
we'll burn some DASD for a snapshot.
Thanx,
Alan
-Original Message-From:
Roland, under Unix you can use the Word Count(wc) command. Type in wc -l
filename.
-Original Message-
Sent: Wednesday, July 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L
Roland,
How about counting black cats in the dark room without turning on the light?
Igor Neyman,
Try wc txtfilename
It will return # of Chars, # of Words, # of lines
-Original Message-
Sent: Wednesday, July 03, 2002 4:43 AM
To: Multiple recipients of list ORACLE-L
Anyone whom has a good example on how to check how many rows (without opening the
file) does a text file consists of?
I import with show=y first with a log file ,
then analyze the log file . And change the create tablespace statements to
the disks I want to create my datafiles and then create tablespaces ..
Then import with ignore=y so that create tablespace statements give error
stating that tablespace is
John,
Funnily enough I was just looking at this in the docs.
It appears you can specify a extent size but not whether auto allocate or
uniform. But the docs do state
Tablespaces migrated to locally managed format are user-managed which I
think gives you the answer.
To migrate a tablespace 'TS1'
Oracle note: 120061.1
QUESTION:
Why is the table extending with the next extent that is specified even
though
it is a locally managed tablespace.
ANSWER:
Migrated tablespaces are not subject to the UNIFORM/SYSTEM policy of newly
created locally managed tablespaces. This would be too
hi roland!
if you're on unix and have bash use
$ wc
which has a lot of super options, see -- $ man wc
i think it's the same on ksh too, but am not sure.
if you're on w3, i would either install cygwin, then
use can use bash, too, or write a little perl script
daniel
[EMAIL PROTECTED]
John,
If you were to put that on usenet, Randal Schwartz would nail you
with 'another useless use of cat' award. ;)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/03/2002 02:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
How about counting black cats in the dark room without turning on the light?
You'll probobly see the reflextions of the cats eyes, even in the dark.
1) Count the number of eyes you see.
2) Divide that number in two.
Very easy. :)
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL
Did you run catalog.sql and catproc.sql on the new database?
Ray Stell wrote:
On Wed, Jul 03, 2002 at 09:02:34AM -0400, Ray Stell wrote:
I want to move a db to a different machine with a different disk
layout. If I create the db and tablespaces on the new machine, can I
use a dmp
I want to move a db to a different machine with a different disk
layout. If I create the db and tablespaces on the new machine, can I
use a dmp file created by exp full=y to move all the data? The dmp
tries to create the tablespaces under the old structure, and these
commands will fail,
gee, for simplicity's sake, I usually just count tails :)
--- Tim Gorman [EMAIL PROTECTED] wrote:
Count the eyes and divide by 2...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 9:18 AM
Roland,
How about
Where can I find info on this?
The documentation refers me to the Oracle 8i Administrators refence for
AIX but I cannot find it on-line
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Yes and no :-)
Yes - it uses a bitmap rather than hacking about with
FET$ and UET$
No - it does not solve extent fragmentation fully
since it does not limit the extent sizes in use in the
existing tablespace. Basically it finds the greatest
common divisor of all the existing extents in the
And Listener? Is it running?
JP
On Wednesday 03 July 2002 13:28, you wrote:
Hi,
I am not able to connect from my oracle client to an oracle db server (NT)
When i try to configure and test for the ora service(from my work station)
it says Connecting...ORA-12545: Connect failed because
Can you ping the host?
When I have a connectivity problem, I follow a set procedure that saves lots of time
in the long run.
1) ping host
2) tnsping sid
3) sqlplus user/name@sid
4) wing it (i.e. ODBC problem or other client program that won't connect).
If step 1 fails, you can try pinging
hi
has someone some idea where to find details for the format of SYLK formatting
instructions.
means i'm desperately looking for things like F;R1;FGOC;SM2 or P;FCourier New;M200
for the chars to use in the document etc...
hints, refs ... etc appreciated
kr
mreger
--
Please see the official
Count the eyes and divide by 2...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 9:18 AM
Roland,
How about counting black cats in the dark room without turning on the
light?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
No problem.
Just use infra red glasses.
Question:
What are infra red glasses?
Where can I get one.
Can someone give me an example?
:-)))
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 5:18 PM
Roland,
K.,
Please check your TNSNAMES.ora file under your ORACLE_HOME/NETWORK/ADMIN
directory. Review the connect string entry for the database you are trying
to connect to - especially the host name/IP address of the machine where the
database is. My guess is that this entry is incorrect.
hope this
This is fixed in 9.0.1.3. I have verified it.
-Original Message-
Sent: Wednesday, July 03, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
Cutting and pasting from an old post: by Jonathan Lewis:
The upshot of it seems to be that anyone who can get an sql session can look
at
Hi,
Follow the following configuration steps before you use the Legato Software for backup:
1. Install Legato NetWorker Software
2. Install BusinessSuite Module for Oracle (Integration between Oracle and Legato)
3. Configure Legato Neworker to use Tape Devices
4. Use RMAN to backup
On Wed, Jul 03, 2002 at 03:28:21AM -0800, karthikeyan S wrote:
Hi,
I am not able to connect from my oracle client to an oracle db server (NT)
When i try to configure and test for the ora service(from my work station) it says
Connecting...ORA-12545: Connect failed because target host or
What if they're one eyed cats?
-Original Message-
Sent: Wednesday, July 03, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Count the eyes and divide by 2...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002
Could it possibly be another bug using Oracle on a P4? I had been running
our backup Names on my pitiful P3-800 Win2K box under 8.1.7, and for months
now under 9.0.1 with no problems other than the usual Windohs flares.
Do you have the Event Log service started under Win2K (WinTuke) in order
to
prompt Currently Executing Packages
SELECT
substr(DECODE(o.kglobtyp,
7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13,
'CLASS'),1,15) TYPE,
substr(o.kglnaown,1,30) OWNER,
substr(o.kglnaobj,1,30) NAME,
s.indx SID,
s.ksuseser SERIAL
FROM
sys.X_$KGLOB o,
K.,
Please check your TNSNAMES.ora file under your ORACLE_HOME/NETWORK/ADMIN
directory. Review the connect string entry for the database you are trying
to connect to - especially the host name/IP address of the machine where the
database is. My guess is that this entry is incorrect.
hope this
John,
Here's the syntax from the Supplied PL/SQL Packages doc - refer to it for
details:
TABLESPACE_MIGRATE_TO_LOCAL(tablespace_name, allocation_unit, relative_fno)
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715
[EMAIL PROTECTED]
Hi,
Follow the following configuration steps before you use the Legato Software for backup:
1. Install Legato NetWorker Software
2. Install BusinessSuite Module for Oracle (Integration between Oracle and Legato
NetWorker)
3. Configure Legato Neworker to use Tape Devices
4. Test
Hi,
I'm not an OPS expert, but X$KCCCP.CPHBT is updated in each CKPT timeout,
which is typically 3 seconds. If it's being incremented, the thread is
mounted.
This will be explained in iOraDumpReader at
http://www.ubtools.com/products/ioradumpreader/ioradumpreader.html If I can
turn back to this
Yechiel,
Are you serious about support for 9.0.1 will go away about June 2003? :(
If that's true, I would reconsider my point to uprade to 9iR2.
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 6:08 PM
Hello Cherie
John, I actually have never sat down tested to see
when Oracle actually does the redo kick. I do have a
OPS and RAC test environment so I may have to see how
big the GAP gets before Oracle starts doing log
archive switches on the idle node.
The only reason I have heard why Oracle does this kick
I have experienced this error with MTS. And the solution is either entering
IP dbmachinename.domainname
to the host file in system32/drivers/etc/ to client .
OR
to the DNS of domain.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
add 10% for the ones that are asleep...
-Original Message-
Sent: Wednesday, July 03, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Count the eyes and divide by 2...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July
try surfing to shopping.yahoo.com and search for infra red glasses
(without the quotes) and you'll see a variety of products. May I recommend
that you instead get night vision goggles (search for night vision
goggles) Most of the better ons have built-in IR illumination that allows
you to see in
My wife recently bought a book called Unix for Dummies. I'm sure it documents the
command you need if you are using any flavor of Unix. For Micromonopoly operating
systems, either get a Unix shell emulator such as cygwin or find a Microsoft Press
book and see what it says.
Of course, any
Good day all -
I had a strange problem yesterday after the unix admin installed a new disk
drive to mirror existing disk. When trying to start the database from
svrmgrl or sqlplus, it would say 'database opened'. But when I try to query
against it, it said database not available, which is true
Seems like you have two choices.
1) Ignore the dbms_utility errors then run the catalog/catproc/etc scripts after the
import as if you were doing an upgrade (which, in effect, you are).
or 2) Import all non-oracle schemas individually.
Option 2 is cleaner but can be a lot more work since
You are assuming:
1) All cats are looking at you.
2) They all sitting still.
3) None of them are alseep.
:)
-Original Message-
Sent: Wednesday, July 03, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
How about counting black cats in the dark room without turning on the
Hello,
I have heard rumors that version 9.2 of the Oracle rdbms
will not support client-server mode. Does anyone have
more information regarding this? What exactly does this mean?
We are a datawarehouse using a combination of 3rd-party tools,
mainly Cognos, SAS, Toad, and we also have MS Access
Hi gurus,
Is there any way to know which SQL statement or procedure or
package is running actually.
I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and
could get the statement, the user but this process had already finished, it was
just in the SGA.
What I want to know is who is
But, it's obvious that he included the cat so that he could count the eyes!
Otherwise, I would agree that the cat was not needed.
Kevin Kennedy
First Point Energy Corporation
-Original Message-
Sent: Wednesday, July 03, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
John,
Roland,
Just go ahead and open the file. You know you want to. We both know that
it would be soo satisfying to just take a peek inside, right? That way
you can count lines. I'm sure you can handle up to ~20 or so with your
zipper up, right? No one needs to know...
Scott Shafer
San
Wow! ECS does end then, as was stated.
For those with a working Metalink (you'll need to join the URL pieces):
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=201685.1
Rich Jesse System/Database Administrator
[EMAIL
I had to find out more...
http://www.ling.helsinki.fi/~reriksso/unix/award.html
Ethan Post
perotdba (AIM), epost1 (Yahoo)
-Original Message-
Sent: Wednesday, July 03, 2002 12:19 PM
To: Multiple recipients of list
http://asktom.oracle.com and search for owa_sylk.
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
On Wed, Jul 03, 2002 at 03:43:20AM -0800, Tim Bunce wrote:
You might find this interesting:
http://www.ling.helsinki.fi/~reriksso/unix/award.html#cat
:-)
Ooh, that one is going into my bookmarks. :-)
--
Johan Hermansson +46-(0)709-919763
Naqua KB[EMAIL PROTECTED]
Title: RE: Count rows in textfile
If the room is dark, you may need to step on tails and count the YRss you hear. Of course, duplicates could still be a problem.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
false rumor.
don't think client/server goes anywhere.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 11:25 AM
Hello,
I have heard rumors that version 9.2 of the Oracle rdbms
Look folks, just setup your claymore mine, fire it, and then you can count
the cat hearts with your Rambo knife...it's easy.
-Original Message-
Sent: Wednesday, July 03, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
add 10% for the ones that are asleep...
-Original
in the dark? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 1:58 PM
gee, for simplicity's sake, I usually just count tails :)
--- Tim Gorman [EMAIL PROTECTED] wrote:
Ah, but what if some of the cats are the tailless kind (Manx?)
-Original Message-
Sent: Wednesday, July 03, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
gee, for simplicity's sake, I usually just count tails :)
--- Tim Gorman [EMAIL PROTECTED] wrote:
Count the eyes and
geez, my bad. I have all this scripted and just assumed it
worked. Turns out catrep.sql doesn't exist. I don't know
why, but I'm sure this is what caused the import errors.
Good thing it's Friday here in the U.S.
On Wed, Jul 03, 2002 at 09:13:27AM -0800, Suzy Vordos wrote:
Did you
Jamadagni
I am getting an error
sys.X_$KSUSE s
*
ERROR at line 12:
ORA-00942: table or view does not exist
Tested on 8.1.7 and 9.0.1 and the same error.
What script should I run to create that table or view ?
TIA
Ramon
- Original Message -
To: Multiple recipients of list
Partially False Explanation!!
Oracle 9i doesn't support client-server *deployment* for Oracle Forms 9i and
Reports 9i.
You can, however use Forms 6i and Reports 6i in Client Server Mode with
Oracle 9i database. I do not believe this applied to ODBC and JDBC
connection applications. Buy I'd
Imagine no client/server:
Only terminals (VT100).
No web apps.
No java/jdbc.
Only X-windows gui
It will be fun!
Waleed
-Original Message-
Sent: Wednesday, July 03, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L
false rumor.
don't think client/server goes anywhere.
Igor Neyman,
Title: RE: Count rows in textfile
We are
all missing the point. Without opening the file, it must be observed from the
outside. As such, from this observation point, it contains no rows. Thus, the
method is irrelevant as the answer will always be 'NONE'.
-Original Message-From:
Not at all true.
There is a 9.2 ODBC driver and the .NET provider is in
development for 9.2. SQL*Plus is a client/server
connection when using an alias as well... this
functionality is still the primary method of
connection.
Mike Sale
--- Bill Becker [EMAIL PROTECTED] wrote:
Hello,
I
Can we find how much roe is in a fish without opening it?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 1:58 PM
gee, for simplicity's sake, I usually just count tails :)
--- Tim Gorman [EMAIL PROTECTED] wrote:
http://www.ixora.com.au/scripts/sql/create_xviews.sql
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
if you're on unix and have bash use
$ wc
Actually wc isn't a part of the bash-shell, but an independent program.
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
useX$KSUSE instead of X_$KSUSE .
-Bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 12:43 PM
Jamadagni
I am getting an error
sys.X_$KSUSE s
*
ERROR at line 12:
ORA-00942: table or view does not
hi everybody ,
oracle provides guid function to generate unique
ids . My question is should one use that guid for synthetic primary key .So you
no longer need a sequence for generating unique values . Is it faster to do a
search on number comapred to varchar2 if it is indexed .
My just
X-ray?
-Original Message-
Sent: Wednesday, July 03, 2002 4:26 PM
To: Multiple recipients of list ORACLE-L
Can we find how much roe is in a fish without opening it?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002
On Wed, Jul 03, 2002 at 12:26:13PM -0800, Fink, Dan wrote:
We are all missing the point. Without opening the file, it must be observed
from the outside. As such, from this observation point, it contains no rows.
Thus, the method is irrelevant as the answer will always be 'NONE'.
Why is it it
Title: RE: Count rows in textfile
Something like Schrodinger's Cat!
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Fink, Dan [SMTP:[EMAIL PROTECTED]]
We are all missing the point. Without opening the file, it
If you aren't experiencing performance problems, the best thing to do
is nothing.
From the docs ( Designing and Tuning for Performance )
To determine whether your system is experiencing latch contention, begin
by determining whether there is LRU latch contention for any individual
latch.
What is zipper?
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Roland,
Just go ahead and open the file. You know you want to. We both know that
it would be soo satisfying to just take a peek inside,
Hi List,
How can I use statspack which already installed for an instance using for
another instance or I have to install it individualy for each instances, I
try to find some thing in the spdoc.txt but no hope.
I have installed statpack under one of my instances, but when I try to use
it for any
Title: RE: Count rows in textfile
I guess, Jared allows this thread to continue only because
it's pre-holiday :-)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Whittle Jerome Contr NCI
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
Dan, I think you're forgetting the Hiesenberg Uncertainty Principle.
According to that, we can know the contents of the file or its location but
not both at the same time. Therefore, if we know where the file is, we can't
be certain that the answer is none.
-Original Message-
AFAIK, it has to be installed on every instance to be monitored and it's not
support otherwise. Nevertheless, all the Statspack code is supplied and it's
easy to hack at. (Been there done that.) Basically all it's doing is reading
stuff out of the V$ tables so you could get at that data on other
Title: RE: Count rows in textfile
He is
probably on holiday already. :)
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 03, 2002 5:22
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Count rows in textfile
I guess, Jared allows
There is a package with a function that you can call.
John Dunn wrote:
Is there any easy way to tell whether an instance is running under OPS or
not?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network
1 - 100 of 117 matches
Mail list logo
