the URL
http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right,
the additional row cache objects latch gets are for synonym translations,
particularly public synonym translations.
Yong Huang
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing
objects latch contention.
Yong Huang
Jonathan Lewis wrote:
...
Code that issues a parse call may:
Invoke the whole parse/optimize cycle
Invoke a permissions cycle on an existing statement
Invoke a search and execute cycle on an existing statement with valid
permission
Invoke
effect of turning it on.
Yong Huang
Tanel Poder wrote:
Hi! Statistics level ALL means TYPICAL + row source execution stats +
timed_os_statistics. If you want to switch to ALL for performance reasons, you
can switch only row source stats on with parameter setting
_rowsource_execution_statistics
recently used again and again to show the inadequacy of the BCHR tuning
method.
Yong Huang
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
{} \; for page cache.
In any tuning practice, Oracle or OS, artificially distorting usage patterns
invalidates your numbers even if you're using a well respected tuning method.
So only play pranks on a play box, not production.
Yong Huang
At 11:14 22-12-03 -0800, you wrote:
My BCHR is currently 96.62
in checking database
health, although other indicators such as wait events should be given a greater
weight.
Yong Huang
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
Please see the official ORACLE-L FAQ: http
.
Could you try on your databases and show how you do it? As I said, this may be
a security problem. I'm just too ignorant of it and can't reproduce it for now.
Yong Huang
Norris, Gregory T [ITS] wrote:
There's no reason I can see that he couldn't create the dblink first, and then
reset
Jared,
I see you log out and log back in as SYSTEM to DB2. But how do you know the
password for SYSTEM to log back in with after you change it?
What if you don't log out? When I tried that (i.e. not logging out), I got
ORA-1017.
Yong Huang
--- Jared Still [EMAIL PROTECTED] wrote:
Environment
Hi,
I'm not sure why your RMAN output says
LOGFILE
GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf',
'/z02/oradata/DEVL/redo_01b.dbf',
GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf',
Where's the ) reuse shown in your RMAN script? Are you sure the script you
showed here was run?
Yong Huang
you
. Then what?
(He can still create a link owned by SYSTEM from another account such as SYS
using a little bit hacking. But he won't know SYSTEM's password. I don't know
how security of the production database is compromised in any way)
Yong Huang
you wrote:
Maybe I'm a being a bit touchy here
others. Thanks for reminding
everybody.
Yong Huang
QuijadaReina, Julio C wrote:
Mladen,
The equivalent of nsswitch.conf on Win2K is the hosts file in
winnt\system32\drivers\etc. You'd probably say: the /etc directory in M$
...But, well this is way off
the topic we are dealing with. Like Jared
dictionary or select any
table. As DBAs, we should encourage developers to make full use of data
dictionary views and open the database to them as much as they can study it. I
would help the consultant in your case instead of just throw back a NO to
him.
Yong Huang
Jamadagni, Rajendra wrote:
Dennis
.
Yong Huang
Jonathan Lewis wrote:
Can you clarify a couple of points for me.
The SDU (session data unit) is presumably the
packet size that the Oracle client and server
want to pass back and forth - which is presumably
the maximum size the one synchronous dialogue unit
will be.
The TDU
Hi, Tanel,
Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2
documentation. If the index is on strictly monotonically increasing numbers,
won't a new node be added to the right without a block split?
Yong Huang
I wonder why does statistic leaf node 90-10 splits
is an overkill. (Some
people use Expect to simply ftp files without knowing that ftp -n allows you to
use a here document; an Expect ftp script is necessary only if you need to
respond differently to each of the ftp errors).
Yong Huang
Daniel Hanks wrote:
I think Perl with Expect.pm could likely
Jared,
Thanks for correcting me that shutdown is a sqlplus command. I wanted to make
the point that piping strings to sqlplus can do more than Perl DBI can. (But
Perl DBI has advantages in many cases)
Yong Huang
[EMAIL PROTECTED] wrote:
All *SQL* commands will work work with the DBI
I used to document database objects (including columns) with the COMMENT
commands. I stopped doing that because I think it unnecessarily increases the
size of data dictionary. It's just a little, though.
Yong Huang
Daniel Hanks wrote:
How about in each database itself.
COMMENT ON TABLE|COLUMN
.
Yong Huang
Guang Mei wrote:
I have never worked on Network stuff. But is there any easy parameters we
could set in sqlnet.ora so that we could increase the DB performance by
increase the network transfer rate (without doing anything else)? BTW my
sqlnet.ora (on a Sun Box) has only two lines
production databases
in the world that are not 24x7. The individual DBA needs to do his control
study and conclude, using experts' opinions as reference.
Yong Huang
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com
such as explain plan, shutdown... and read
its output.
Yong Huang
One BIG advantage of Perl is DBI. Via shell you can't use bind variables
which sometimes come in handy. An admin dweeb here developed a
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading
the
OSI level, the faster assembling and disassembling those protocol data units is
done.
Yong Huang
With TCP over standard ethernet the maximum transfer unit (MTU) is about
1500 bytes, this means if you want to send 2000 bytes over network, you have
to fragment it in 2 packets and send them
it but not
deny it. Similarly, when Mike says queries run 10 to 50% faster after index
rebuild, we can't deny unless we find his measurement is wrong. Wouldn't it be
nice if Oracle researchers write articles with sections like Abstract -
Experimental - Results - Discussion in that order?
Yong Huang
, you need to
clarify what you mean by affect; it changes the notification (posting)
behavior of LGWR therefore changes the behavior of waiting processes (*when*
they stop waiting). Just semantics.
Yong Huang
--- Tanel Poder [EMAIL PROTECTED] wrote:
Anjo,
I also thought it affects only lgwr sync
for LGWR to write redo records.
Yong Huang
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services
of LGWR,
notification or not. Correct me if I'm wrong again.
I'm still interested in Tanel's benchmark, though. Only that is scientific.
Yong Huang
--- Yong Huang [EMAIL PROTECTED], i.e. myself, wrote a few minutes ago:
Tanel,
Did you observe better performance? By how much? Do please let us
Murali,
Could you point us to a document about the TAF and database link issue? Thanks.
Yong Huang
--- Murali_Pavuloori/[EMAIL PROTECTED] wrote:
we implemented RAC (not me personally --but my predecessors) It did not
work for us. Oracle RAC does not support TAF for sessions coming through
Just a congratulations is nothing. For one, Arup should tell us the secret of
achieving the .03 second transaction goal on a 7-terabyte OLTP database. How is
that done? What advice can he give?
Yong Huang
--- [EMAIL PROTECTED] wrote:
Congratulations to the following folks that appeared
to check all libraries under $ORACLE_HOME/lib: cd
$ORACLE_HOME/lib; file * | grep 64; file * | grep 32. If they're mixed, you
need to relink.
Yong Huang
--- Grant Allen [EMAIL PROTECTED] wrote:
Hi all,
Looking for possible causes for a ELFCLASS64 version of
/oracle/product/8.1.7/lib
:27
...
Yong Huang
--- Tanel Poder [EMAIL PROTECTED] wrote:
Well, it's code is:
select io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj
Maybe use HTP, HTF and OWA_UTIL packages? You still need to do some writing in
using them.
Yong Huang
--- AK [EMAIL PROTECTED] wrote:
I am looking for a utility package for throwing output in html format from a
query . This should use utl_file to write the file ( no sqlplus markup
Tim,
I checked v$reserved_words. At least in 9.2.0.1, INTERNAL is not in there.
Oracle should address this issue.
When I trace the SQL GRANT SELECT ON SOMETABLE TO INTERNAL, it stops in
parsing.
Nonetheless, it's confusing to say the least to create a role called internal.
Yong Huang
--- Tim
Gopal,
Are you saying with an undocumented parameter or command, I can alter database
(national) character set us7ascii even if my current (national) character set
is utf8?
Yong Huang
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
INTERNAL_USE is an keyword (to enable an undocumented feature
,
It's not always easy to have a futuristic view to avoid potential problems. The
developer probably shouldn't have granted anything to internal back then. But
it wasn't obvious at that time that doing so could cause a problem later.
Yong Huang
--- Barry Deevey [EMAIL PROTECTED] wrote:
This would
. If changing to a lower
character set works, what's the syntax? Personally, I can't imagine how that's
possible.
Thanks.
Yong Huang
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
INSERT STANDARD DISCLAIMERS
Yes. You can use INTERNAL_USE keyword to convert the database character set.
I think
AK,
Do you get INVALID_MAXLINESIZE exception? Documentation says it maxes at 32767.
I didn't find file size limit. UTL_FILE.FOPEN also has a max_linesize that can
be set to 32767.
Yong Huang
--- AK [EMAIL PROTECTED] wrote:
what is max filesize for utl_limit.fopen ? I am unable to past beyond
I think there's another complication in using buffer cache (x$bh or v$bh). If
the index is scanned in parallel, the blocks are not cached in buffer cache.
To avoid counting buffers created due to index update, maybe we can simply say
where v$bh.status in ('CR','READ').
Yong Huang
--- Tanel
. Faan can comment.
Yong Huang
--- Carel-Jan Engel [EMAIL PROTECTED] wrote:
Hi List,
One of my customers gets HP Servicedesk 4.5 implemented. The database that
has been created by on of the DBA's for the application is Oracle 8.1.7.4,
on AIX 4.3.
The database has characterset UTF8, which
Gogala,
I've been searching for a /proc filesystem implementation on HPUX for years. I
don't think it's there yet.
Yong Huang
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Your process has parts of SGA attached to it. The only way to actually find
out
is to examine the process address space wia
Here's a wild guess. If the character set is changed, a 10 MB segment (from the
first extent to high water mark) may become 20 MB or 5 MB. Then CBO changes the
plan and it happens to be a bad one.
Yong Huang
--- Carel-Jan [EMAIL PROTECTED] wrote:
At 10:34 17-11-03 -0800, you wrote
KamYee,
Can we take a look at the SQL*Loader control file? Also the output of
select * from v$sql where lower(sql_text) like '%yourstagingtable%' and
invalidations 0
Yong Huang
--- Jonathan Gennick [EMAIL PROTECTED] wrote:
I wonder whether the invalidation comes about from the use
.
Yong Huang
--- Ron Rogers [EMAIL PROTECTED] wrote:
Daniel,
I understand what is you are saying and what you tested but I don't
the why or what it means. Does it mean that the sql command is not
going to work? Does it means that you have to issue it again to get it
to work?
Ref:
Doc ID
://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
)
Typ=1 Len=17: 73,67,79,78,73,88,92,89,79,78,71,72,85,65,78,71,0
Yong Huang
--- Chris Stephens [EMAIL PROTECTED] wrote:
SQL select sys_context('userenv','session_user'),
2 dump(sys_context('userenv
, as well as Jonathan Gennick's article on 10g
regular expressions.
Yong Huang
--- Naveen, Nahata (IE10) [EMAIL PROTECTED] wrote:
Not until 10g
Regards
Naveen
-Original Message-
From: Shiva Maran [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 12:50 PM
To: Multiple
transaction, i.e. not just a regular query, then
their own SCN's at the time the transaction started as shown in v$transaction
may be used as a uniqur identifier. But the session can't use a savepoint and
hope that has another number in v$transaction; that's not a common requirement
though.
Yong Huang
Saira,
How about use the same method as suggested in another thread, i.e. pipe and
remove unwanted text? In your case
whatever comes in | sed -n '/^BEGIN/,/^ORA-06512: at line/!p'
Yong Huang
--- Saira Somani-Mendelin [EMAIL PROTECTED] wrote:
List,
I have a shell script that executes a sql
. Please post your report of performance change. Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
Jared : I think it is fragmented based on scripts and knowing that there have
been lot of deletes.
One script uses the table index_stats and looks at field del_lf_rows which
should be less
space management in
your LMT's, you can ask him why he doesn't use 'alter index rebuild'. ;)
Jared
Yong Huang [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2003 02:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
so.
So show us some timing data.
Yong Huang
--- zhu chao [EMAIL PROTECTED] wrote:
Hi,
In some case, rebuild index can help, this is from my work log on my
Datawarehouse project.
The effect of rebuiding index:
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks
though.
In your college student case, changing primary keys is rare so it's not a big
problem.
Yong Huang
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
Jonathan,
I think your idea of a paper is a good one. But I think we need to back th
question up to what the requirements are.
First
). Wouldn't these perform better?
Yong Huang
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
At one site I worked at, the programmers insisted on using Java
milliseconds as the primary key -- so that they wouldn't have to hit
the database twice (once to get the sequence number, once to insert the
row
observation). If somebody reads that differently,
please correct me.
Yong Huang
--- Igor Neyman [EMAIL PROTECTED] wrote:
As it was recently discussed,
Insert /*+ append */ into destination_table select * from
source_table
will produce minimum redo/undo if destination_table specified as
nologging
own table doesn't do
that.
Yong Huang
--- Cary Millsap [EMAIL PROTECTED] wrote:
Hit a table that keeps a counter will not scale (will not perform at
high concurrency). It will cause you no end of buffer busy waits
waits, latch free waits for a cache buffers chains latch (even
I see. Sorry for misreading.
How about direct path load? sqlldr direct=true. But this means your data source
is on the filesystem.
What is M.b.?
Yong Huang
--- Igor Neyman [EMAIL PROTECTED] wrote:
Yong,
M.b. my question was not clear.
I know, nologging doesn't work with IOTs.
What I'd
Thanks, Denny. That's it. I imagine Tom's test database is running in
noarchivelog mode and the tablespace is logging.
Yong Huang
--- Denny Koovakattu [EMAIL PROTECTED] wrote:
Yong,
If the database is in ARCHIVELOG mode, then the table must be set to
NOLOGGING
for append hint to work
I'm fully convinced. SSN should not be used as a PK.
Can we also conclude that natural keys in general are only good if you sit in
an ivory tower and do unrealistic lab test?
Yong Huang
--- Bellow, Bambi [EMAIL PROTECTED] wrote:
Having worked for the government in a situation where we were
Yes, direct-path load works on IOTs, at least in 9.2 running in Solaris 2.8.
Yong Huang
--- Igor Neyman [EMAIL PROTECTED] wrote:
Unfortunately my source is another table.
By the way (btw.), will sqlldr direct=true work with IOT?
m.b - may be.
Igor Neyman, OCP DBA
[EMAIL PROTECTED
Jerry,
There shouldn't be any problem. It's better to use different log files or run
them in different directories.
Yong Huang
--- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote:
Hi,
We were just wondering if you can IMP into two instances using the same dmp
file at the same time? We
actually makes much
difference. (I don't know the answer but am very interested to know). Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
Hello,
I have to rebuild some primary key indexes due to excessive fragmentation.
It is rebuild not drop and create. We have multi master replication
Hi, Ryan,
Where's the 20 billion rows? There's 1 G rows and 20 G bytes.
What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for
TABLE2? Did you analyze using ANALYZE command or DBMS_STATS?
Yong Huang
--- [EMAIL PROTECTED] wrote:
I cant sql trace it now. I hae run statspack
Oracle evaluates
predicates in the WHERE clause. Not sure if that's true. You can try switching
the predicates around and look at the execution plan for each.
Documentation is wrong in saying that you should be put that hint in the WHERE
clause.
Yong Huang
--- A Joshi [EMAIL PROTECTED] wrote
-- T. Schick Jr
Other than Lazy Dba (www.lazydba.com) and others, you can think of
otn.oracle.com or Metalink forums or even asktom.oracle.com as forums. Only
on-topic messages are allowed on these forums.
Yong Huang
--- A Joshi [EMAIL PROTECTED] wrote:
Hi,
Can someone post a list of other
are running on Linux
now.
Yong Huang
--- [EMAIL PROTECTED] wrote:
Found a site with some 10g new features.
http://www.adp-gmbh.ch/ora/misc/10g.html
I'm sure some will like the new 'alter tablespace rename'
http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux
Jared
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
with 10g.
Must be a joke here somewhere I'm missing.
Jared
On Mon, 2003-11-03 at 20:09, Yong Huang wrote:
Gopal was joking about the fact that Jared only said 'alter tablespace
rename'
instead of ALTER TABLESPACE RENAME DATAFILE.
In fact, 9.2 SQL Reference has this
Moving
: your transaction end marker says it's not rolling back; i.e.
it's committing.
Yong Huang
--- Andy Rivenes [EMAIL PROTECTED] wrote:
Looks sort spillage to disk due to the where clause.
Andy Rivenes
[EMAIL PROTECTED]
At 06:44 AM 10/30/2003 -0800, Tim Onions wrote:
Gurus
I've applied many
$sort_usage if you can run that DELETE again.
XCTEND rlbk=0: your transaction end marker says it's not rolling back;
i.e.
it's committing.
Yong Huang
--- Andy Rivenes [EMAIL PROTECTED] wrote:
Looks sort spillage to disk due to the where clause.
Andy Rivenes
[EMAIL PROTECTED
table? Does the delete have cascaded delete on other tables?
Yong Huang
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Tim,
As you have seen, this is due to writes to and reads from the TEMPORARY
tablespace of that user. This could be due to both SORT segments
(SORT_AREA_SIZE overflow) as well
, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
-Original Message-
From: Yong Huang [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003
be used, I don't think a row showing in there always indicates a library
cache pin (executing) on the object.
Yong Huang
--- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote:
David,
You could use Steve Adam's script Executing_packages.sql at
http://www.ixora.com.au/scripts/misc.htm to see what
invalidation) and DL (direct loader) locks also use ID1 for
object number.
Yong Huang
--- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote:
I don't think v$sql will give you the same information - it would show the
top level actual package being executed, but not those which are called by
that package
If there're already hints like ordered and use_nl that tell Oracle how to join,
lack of statistics is less of a problem. In fact, you may need to use those two
hints in some queries against data dictionary even in pre-9i Oracle.
Yong Huang
--- Tanel Poder [EMAIL PROTECTED] wrote:
Hi!
Just
this problem.
This test is done with block dumps on 8.1.7 on NT.
Yong Huang
[EMAIL PROTECTED]
Miller, Jay wrote:
Actually char has some minor performance advantages over varchar2 when the
column is frequently updated to a larger size since the full space is
already claimed within the block
,
indicate where the pause happens)
Also let us know if there's anything special in alert.log and any new file in
udump.
Yong Huang
[EMAIL PROTECTED]
you wrote:
PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND
2286 oracle 1 00 1844M 1814M run 9:44 13.90% oracle
11068
what Sun
does).
Yong Huang
[EMAIL PROTECTED]
Jonathan Lewis wrote:
Cary Millsap has an article on his website
www.hotsos.com which describes a case
where upgrading the CPUs to a higher
speed (same number) resulted in the OLTP
users complaining about a drop in performance
I remember in slightly older versions of Oracle,
delayed_logging_block_cleanouts is by default true, so redo won't be written
immediately at block cleanout. Correct me if I'm wrong.
Yong Huang
[EMAIL PROTECTED]
Jonathan Lewis wrote:
bear in mind that a scan after deleting 100,000
rows would
Ian and Riyaj,
These table_... objects look like Java classes. The way to find this out is
matching the kgl handle address and looking at the indx column of x$kglob.
Matching this indx column with dba_objects.object_id.
Yong Huang
[EMAIL PROTECTED]
you wrote:
I use the following statment when
Interesting. In 8.1.7 32-bit oracle binary, select * from v$type_size where
type = 'UB4' tells me it's 4 bytes. So it's 32 bit and the maximum is 4
billion.
Glad to see Jonathan on this forum.
Yong Huang
[EMAIL PROTECTED]
you wrote:
From: K Gopalakrishnan
Welcome Jonathan,
I think most
and add 1970 to it.
The above perl one-liner is just a convenient way to call stat(2).
Yong Huang
[EMAIL PROTECTED]
you wrote:
But the year replaces the time in the 8th field only when the last
modification time for the file is more than 6 month (even if it is in the
current year :)
For example
_
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
S
Hi, Connor,
The append hint to insert does not disable generating rollback info. It does
stop redo generation for a nologging table.
Yong Huang
[EMAIL PROTECTED]
you wrote:
If you're on 8.0 or higher, try
insert /*+ APPEND */
into table
select * from other_table;
where "table"
email) can
contain fractured blocks. Maybe Jeremiah Wilton can give a better answer.
Yong Huang
[EMAIL PROTECTED]
you wrote:
I have a datafile in my production box (a user data tablespace), when I run
dbv against it, it showed that 5 blocks are "influxed"
Page 458784 is influx - most li
).
Also note that Oracle documention says:
You can view all tables with columns marked as unused in the data dictionary
views USER_UNUSED_COL_TABS, DBA_UNUSED_COL_TABS, and ALL_UNUSED_COL_TABS
Yong Huang
[EMAIL PROTECTED]
you wrote:
I found though that once marked unused U couldn't find
be
hard to measure but I have not done it.
Yong Huang
[EMAIL PROTECTED]
you wrote:
We have a situation where are no relationships are
defined at the database level. i.e no foreign keys
constraints have established at the Database. The
application is still at the Development Stage.
Everything
Hi, Ron,
Is this because you run batch files as CMD /K? If so, change it to CMD /C. If
you're not using CMD command and if your script is not too long, please post it
and we'll examine it for you.
Yong Huang
[EMAIL PROTECTED]
you wrote:
We have several NT Dos batch scripts that execute sql
l
come out.
Yong Huang
[EMAIL PROTECTED]
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
INET: [EMAIL PROTECTED]
Hi, Bipin,
The statistic# is the same as in v$statname or v$sysstat or v$sesstat.
By the way, select distinct sid from v$mystat is not as fast as select sid from
v$mystat where rownum = 1, which is the fastest way I've known to get your own
SID.
Yong Huang
[EMAIL PROTECTED]
you wrote
87 matches
Mail list logo