Think of Object Oriented, then 1 db can be an Object, better security, easy to upgrade
or downgrade, easy to change any setting as you like.
Think of memory, overhead, administration, 1 instance will be better (I think,
specially backup and recovery)
Think of performance, you can tune each db ind
Dear : All
First and foremost , if i ask stupid question pls
forgive me coz i new to oralce. I have a question
here.
I have a server, and this server contains 5 oracle
database. Each database contains 5 web application
that are running on live ( production server ). As i
understand abt oracle , e
Exactly.
select * from v$statname where name like '%gets%'
is simple evidence of that.
Cheers
Connor
--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote: >
> Why do people still talk about "THE"
> buffer cache hit ratio ? There are lots
> of them.
>
> The one you can get from v$sysstat,
> the ones
Thanks, Jonathan.
Of course you are right :-)
Playing with this a little longer, I can get up to 4
versions (child_number from 0 to 3) of the same pl/sql
cursor by changing bind variable sizes. It ceases
being sharable when bv size changes from 32 to 33,
from 128 to 129 and from 2000 to 2001:
1-3
FWIW. The database crashed again.I managed to get in a 10466:
BEGIN
GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ;
END;
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse 2737
Looks like they're using VMS's algorithm. *That's* a shocker!
-Original Message-
Sent: Tuesday, December 23, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L
Actually, the concatenated string of userid and password is hashed. So if
that is same, you got yourself the same hashed pas
Take a look at Metalink note 227010.1. It provides a script with the
hash values for the default passwords. It's good for checking database
security.
Dennis
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dennis Heisler
INET: [EMAIL PROTECTED]
Fat City Network
Why do people still talk about "THE"
buffer cache hit ratio ? There are lots
of them.
The one you can get from v$sysstat,
the ones you can get from v$buffer_pool_statistics,
and the ones you can get from v$segstat.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is
Notes in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see htt
Hi,
I'm using oracle 9.2.0.4. I put it off tonight with the statement
You mentioned and unfortunately no success.
Maybe interesting to know that I started without the event 4030 set
And I get the following ora-600 in my alert file:
Tue Dec 23 16:46:42 2003
Errors in file /var/opt/oracle/product/a
Very Nice. I didn't know how the 2 values were used within the hashing
algorithm.
I would have thought it was a little more complex.
-
Alan Davey
Senior Analyst/Project Leader
Oracle 9i OCA; 3/4 OCP
w) 973.267.5990 x458
w) 212.295.3458
-Original Mes
You could conceivably do this, much like lopht or crack.
It would take a rather large password database, and a
cracker with some intelligence. This is the same reason
that unix now uses shadow passwords.
Jared
On Tue, 2003-12-23 at 12:29, Norris, Gregory T [ITS] wrote:
> Not really... you coul
Try running the 2nd statement first, just after
logon to the database, and see what happens.
Then read the fine manual for sequences. ;)
Jared
On Tue, 2003-12-23 at 12:49, [EMAIL PROTECTED] wrote:
> Hello list , why does :
>
> insert into test values (mysequence.nextval, mysequence.currval ) ;
High LIO's require create a lot of latch activity, which
can result in high CPU usage if there is latch contention,
so reducing LIO's will reduce CPU usage.
Jared
On Tue, 2003-12-23 at 12:34, [EMAIL PROTECTED] wrote:
> the cpu right now is high because they are not-using bind variables. Which is
Actually, the concatenated string of userid and password is hashed. So if
that is same, you got yourself the same hashed password.
Consider this:
SQL> create user ABC identified by DEF;
User created.
SQL> create user ABCD identified by EF;
User created.
SQL> select password from dba_users whe
I wonder if there is a pre-encrypted list available of all Monty Python
words, Babylon 5 words, Star Trek words, etc. etc. Actually, I can't think
of any better password than LEXADOIG.
> -Original Message-
>
> Not really... you could easily compile a list of passwords
> and their assoc
...and all this time I thought Cary was a man! :)
...now all the talk of showers and Cary's cleanliness from Mogens makes
sense!!
...(I'm 99.99% sure Cary IS a man...at least he looked it at IOUG a few
years back) :)
merry xmas everyone!
-Original Message-
Sent: Tuesday, December 23
SORRY!! Regrettably e-mail does not provide the required info, namely a picture. The
only other Cary I know is female, in every sense of the word.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, December 23, 2003 3:45 PM
To: Multiple recipients o
Ah, you're right... the username is taken into account when the password is hashed.
Quite a few applications have forced usernames, however, so I'm still a bit uneasy.
It's clearly not as bad as I thought, however.
-Original Message-
Davey, Alan
Sent: Tuesday, December 23, 2003 2:59 PM
because the second insert is returning the result of the first insert.
try running each one twice in a row and see what happens.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, December 23, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L
Hello li
No. Two different users with the same password would have different hash
values.
So you would have to loop through a "dictionary list" for each user within
your local database. Once you got a match, then you could logon to the
target database with that user/password combo.
--
Hello list , why does :
insert into test values (mysequence.nextval, mysequence.currval ) ;
have the same effect as
insert into test values (mysequence.currval, mysequence.nextval ) ;
where
1. mysequence is
create sequence mysequence increment by 1 start with 1 maxvalue 1000
nocycle nocache
Not really... you could easily compile a list of passwords and their associated
hashes. Once this is done, it's just a simple matter of matching the hashes.
-Original Message-
Jared Still
Sent: Tuesday, December 23, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L
As long Oracle c
Jonathan,
Wouldn't bind variable issue that prevents cursor from
sharing be visible in bind_mismatch?
How can one simulate this?
var v varchar2(1)
begin select count(5) into :v from dual; end;
/
select address, sql_text from v$sql where sql_text
like '%count(5)%';
ADDRESS SQL_TEXT
At 12:04 23-12-03 -0800, you wrote:
Jared,
I'm going to take some exception to what Cary has said on the
subject, but I believe in the end she'll agree with me.
She? Cary, you didn't tell us about this surgery ;-)
Dick, last time I saw Cary (October) he was very masculin. I bet this
has
In addition to the fine solution from Bambi, Here's another approach that I
think will work. I did only minimal testing (in TRUE development tradition.
But ... But ... It worked OK in test!). One caveat: This relies on
recursion, so on a big directory tree you might get swatted with OS resource
the cpu right now is high because they are not-using bind variables. Which is being
fixed. So I was ignoring CPU usage.
Ive read that article. I dont remember any CPU material in there. I just focused on
LIOs and didnt realize I needed to monitor CPU. However, high LIOs will lead to high
CPU r
Title: STATSPACK interpretation
Using
dbms_application_info package also causes that there are several versions of
same statement - but they share same execution plan. You can check if
this is the case by querying v$sqlarea (module and action
columns).
Regards,
Joze
-Original Mes
One place I can think of (the only place?) where BCHR may be useful,
is as a lower bound for the OPTIMIZER_INDEX_CACHING parameter. This
parameter pretty much asks the question that Cary posed in his email.
I say that the BCHR should be the lower bound for this value because
the question that OP
Jared,
I'm going to take some exception to what Cary has said on the subject, but I
believe in the end she'll agree with me.
LIO's are inherently cheaper than PIO's simply because you have to complete
the LIO before asking for a PIO. And no you can't work with data that has not
Cary's being diplomatic, as well as engaging in some wishful thinking.
:)
They appear to be quite prevalent. There are other microcosms of
Oracle users that you will find from time to time that realize
how Oracle works, and how to go about fixing performance problems.
If though you consider th
Thanks Jonathan.
I was wondering about those memory columns possibly
acting in that manner. I've never used them to
track memory though, and wasn't sure how they might
act. Google and MetaLink didn't turn up anything
too useful in the regard.
Now that you mention it, I recall reading recently
As long Oracle can manage to keep its modified DES algorithm
secret, this should make it somewhat difficult to crack passwords
in the manner that can be done with unix passwords.
It could still be done, but the time required would make
it just too time consuming IMO.
Jared
On Tue, 2003-12-23
Ryan,
Take a look at "Why you should focus on LIOs instead of PIOs" at
www.hotsos.com/e-library. If you have access to the book "Optimizing
Oracle Performance," check out chapter 9.
If an application is written not to crash into some kind of
serialization barrier (latch free, enqueue, etc.), then
Here's a freebie...
Bambi.
=
#!/bin/ksh
LEVEL=1
INCREMENT=FALSE
ls -lR|grep -v ^total|while read i
do
echo $i|grep ^d >/dev/null 2>/dev/null
if [ $? -eq 0 ] ;
then
continue
fi
FILE=`echo $i|awk '{print $NF}'`
echo $i|grep "\/" >/dev/null 2>/dev
I hope not, but I think so.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message
I recall James Morle saying something about
code not being sharable if the declared sizes
of the bind variables don't match. If Informatica
is using a 3GL to call anonymous pl/sql blocks
with different bind variables every time, perhaps
it is causing a bind variable mismatch.
As for the 400MB -
The softwrae engineers are measuring CPU usage. I usually ignore this and dont care
about that value. I dont have any docs on it. anyone have any docs on this? or am I
wrong?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Well,
When your declared intentions is to do one thing and one thing only there are a
whole lot less places to make mistakes. Conversly when your intentions are
to "rule the world" you also open up the world of oops's. Humm, Wonder if
there's a lesson in that for Cousin BillyG???
Dick Go
are there really that many people who use hit ratio?
>
> From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/12/23 Tue AM 11:49:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Hit Ratio
>
> Yong,
>
> Connor's script is not a joke, it's a proof by counterex
grep -v try
will give you all the lines which do not contain "try"
cat |sed "s/try//g" > newfile
will strip the characters "try" from all lines
HTH,
Bambi.
-Original Message-
Sent: Monday, December 22, 2003 6:54 AM
To: Multiple recipients of list ORACLE-L
Hallo all of you,
Is ther
http://www.eweek.com/article2/0,4149,1420487,00.asp
When I brought the issue up, I didn't know if one could in fact maliciously
use that info. And, as I originally stated, it was something I had not
tried. But paranoia (healthy, I think) dictates there's gotta be a way.
When one looks at the Unix password world which brought about the necessity
f
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set workarea_size_policy=manual;
Jared
On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote:
> Hi,
>
> I have an ora-4030 problem related to pga memory alloc
Thomas,
The version count is the number of child cursors
present in the cache for this SQL. The cursor is
not being shared for some reason with 456 versions.
The 400m of memory seems a bit excessive.
There is a script at Jonathan's site with some info
about v$sqlarea and a script you can run th
Yong:
I have not seen all the threads on this. So there are chances some body
might have
covered this/I may be missing some interesting things..But the issue is,
tuning or measuring the
database performance ONLY with Hit Ratios. By high hit ratios Damagement
will tend to understand , that percent
Barbara,
You might try tossing the following snippet in a shell script. I call it
dtree and you can pass a parameter of a directory.
=== snip
D=${1:-`pwd`}
(cd $D; pwd)
find $D -type d -print | sort |
sed -e "s,^$D,,"\
-e "/^$/d"\
-e "s,[^/]*/\([^/]*\)$,\:-\1,"\
-e "s,[^/]*/
Hi Barb,
You can use tree/dtree to do this. Windows also has a tree dos command
to do the same.
HTH
Mark
-Original Message-
Barbara Baker
Sent: 23 December 2003 08:49
To: Multiple recipients of list ORACLE-L
Hi, listers.
As documentation for a project, I would like to
display some u
Hi
Qs Does a Pro-C application (Banking) need to be compiled with Standard
Edition as Oracle Libraries are being used in the Compilation OR can it
be compiled with the Enterprise Edition & simply deployed elsewhere at
Customer site containing the Standard Edition?
NOTE Application is making OCI
Yong,
Connor's script is not a joke, it's a proof by counterexample that the
advice "You SQL is tuned if and only if it has a high hit ratio" is
rubbish.
The buffer cache hit ratio is a tool. Used properly, nobody's objecting.
It's proper use? To answer the question, "What percentage of LIO calls
Hi, listers.
As documentation for a project, I would like to
display some unix directories in hierarchical format
and add the output to the documentation set.
(Solaris 9)
Either flowchart-like or explorer-like will do. Sorta
like what is shown below. Does anyone know of a
freebie tool that will
Hi
Qs Does a Pro*C application (Banking) need to be compiled with Standard
Edition as Oracle Libraries are being used in the Compilation OR can it
be compiled with the Enterprise Edition & simply deployed elsewhere at
Customer site containing the Standard Edition?
NOTE Application is making OCI C
Hi
Qs Does a Pro*C application (Banking) need to be compiled with Standard
Edition as Oracle Libraries are being used in the Compilation OR can it
be compiled with the Enterprise Edition & simply deployed elsewhere at
Customer site containing the Standard Edition?
NOTE Application is making OCI C
Sorry. I read your email twice and
still have not seen a question. Are you wondering if this is normal?
:)
Tom Mercadante Oracle Certified
Professional
-Original Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: Tuesday, December 23, 2003 10:39
AMTo: Multip
Mark is right,
Ping uses ICMP Echo_Request and Echo_Response. Since ICMP sit on the
Network Layer along with ARP and the IP protocols, it does not need to
use any TCP or UDP port number. TCP and UDP protocols need a number to
differentiate from the rest of protocols, therefore the expression "port
Yesterday, we received the below message in our alert log.
Normally, we do not see such messages in an alert log. It might be a
spurious message since in the associated trace file it first says: FATAL
ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error.
Maybe just had a
This is scary,
I'm planning to upgrade 9.2.0.4 from 9.2.0.2.
I don't know how
removing pga_aggegrate_target will help reducing
memory!!
Does the program
have any memory tables, etc?
Did you monitor
the PGA size from the Oracle side using v$sesstat?
A sql by itself
can't consume thi
Yesterday, we received the below message in our alert log.
Normally, we do not see such messages in an alert log. It might be a
spurious message since in the associated trace file it first says: FATAL
ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error.
Maybe just had a
Hi, Carel-Jan and Rich,
Connor's script to bump up buffer cache hit ratios is meant to be a humor. Only
if you carefully comtemplate it will you see that there's no relevance of the
fact that you can get any hit ratio to the fact that hit ratios are
insufficient in performance tuning.
It would be
Hi,
I have an ora-4030 problem
related to pga memory
allocation, at least I have concluded sofar
This program is batch written
in pl/sql and after an hour or so it crashes. PGA allocated is slowly exceeding
2Gb and when I monitor with
top I see the process size rising uptill 2 Gb som
Same here...
SQL> select password from dba_users where username = 'SCOTT';
PASSWORD
--
F894844C34402B67
-Original Message-
Michael Thomas
Sent: Monday, December 22, 2003 10:44 PM
To: Multiple recipients of list ORACLE-L
Hi,
Okay. I'm almost a believer of th
EE has enterprise on the CD, but it's an extra cost option. Make sure the license
fees have been paid first, otherwise it could be a messy thing to rip out. BTDT.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, December 22, 2003 7:14 PM
To: Multip
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Have you looked up on Metalink? there is ton of information out
there.
Raj
Rajendra dot Jamadagni at nospamespn dot
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Hi there,
I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied th
PING doesnt actually use a port number, as it's not TCP/IP based - it's a
part of the ICMP protocol..
Mark
-Original Message-
Ganesh Raja
Sent: 23 December 2003 13:40
To: Multiple recipients of list ORACLE-L
TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping
will use
TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping
will use..
HTH
Regards,
Ganesh R
HP : (+65)9067-8474
Mail : [EMAIL PROTECTED]
==
All Opinions expressed are my own and do
not in anyway reflect those of my employer
===
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Hi there,
I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied th
[EMAIL PROTECTED]> . oraenv
ORACLE_SID = [OLDNCS1] ? DEVL
[EMAIL PROTECTED]> sys
SQL*Plus: Release 9.2.0.2.0 - Production on Tue Dec 23 08:30:45 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
W
This is what I got, Oracle 8.1.7.4 on Sun Solaris (I dropped the user):
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL> create user scott identified by tiger;
User created.
SQL> select password
2
9.2.0.2 on Sun Solaris... and yes, I got the same encrypted password
--- Michael Thomas <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Okay. I'm almost a believer of this as a problem. How
> about 9.2.0.4 on RH9.3.
>
> 1) What does anyone/everyone get for my this query (my
> results shown):
>
> connect
ANd one more thing about Ping vs Tnsping when going thru a firewall. Some
firewalls are setup to not allow a Ping to pass thru, but sql connections
are allowed. So a Ping will return not found, while a tnsping will return
ok. I have that situation here all over the freakin place.
Tom Mercadante
Jared,
Digging into it more, I found out that it's called from an
Informatica client. Apparently, the gist of the client-side
algorithim is as follows:
For each row in (some view)
Call generate_product_keys
MERGE (upsert) into product table
end loop
CREATE OR REPLACE PROCEDURE generat
On Sat, Dec 20, 2003 at 02:34:26PM -0800, Paul Drake wrote:
> --- Seema Singh <[EMAIL PROTECTED]> wrote:
> > Hi
> > Does anyone know good Linux administration book?
> > Can you guyes suggest any good linux user group?
> > thx
> > -Seema
>
> Matt Welsh's "Running Linux" is now out in 4th
> Edition.
I came across just this last week with one of our monitoring tools. We set
up an execution of a script that was using PING to check whether the status
of a list of remote POS devices to make sure they were available. The
collection worked fine - until we shutdown the POS device, and physically
swit
This type of activity is intended to be done only when there is no DML
activity on the table. If that isn't feasible, then I'm afraid you'd have
to do conventional deletes.
-Original Message-
From: Naveen, Nahata (IE10) [mailto:[EMAIL PROTECTED]
Sent: Tue 12/23/2003 1:00 AM
To: M
75 matches
Mail list logo