Jerome -
I have heard that there is a problem with performance but... if you get to
5.2 with ML01, that is supposed to resolve the issue.
If anyone knows differently... I would appreciate the knowledge too.
Dave
- Original Message -
Anybody having problems with Oracle DB hanging up
I believe a role 'OEM_MONITOR' is created in 9i when you create a DB;
pre-9i you can create it yourself (via catsnmp.sql or something like that)
and you can use that instead of granting specific other privileges. Oracle
claims that it contains a minimum set of privileges for OEM use, but maybe
Yes, just where do those disk names in the Disk IO chart come from on HP UX
11.00? There is no -x option for iostat, and I haven't been able to find
out what source Oracle is using. Altogether it's hard to tie together the
output of (b)df and sar with the picture on the chart without knowing it.
I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know
atleast one other person from the list was there. Since Oracle is releasing details
and its going to be released(in theory) in the next 2 weeks, I was wondering if you
guys could talk about it.
1. does ASMs
That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give
it a directory and then just build tablespaces. The database picks the filenames for
you. Now mind you it does work, but I'll be damned if I use it in anything other than
a development environment. For some
Viktor, Ryan - Is what you are experiencing the result of companies moving
to open-systems Web-based architectures?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 18, 2003 8:34 PM
To: Multiple recipients of list ORACLE-L
I agree
no ASMs are considerably different. Its supposed to manage everything. You dont give
it a file, you give it entire disks and oracle does everything. Sets up files,
manages, I/O, everything.
you only look at the tablespace level. you dont even install any software on it. If
your on SAN, you
Hi folks,
Our server team has just upgraded a server from Windows NT4 to Windows
2000, and when I tried connecting to the database from my workstation,
using OEM or TOAD, I get an error message after half a minute or so:
ORA-12535: TNS: Operation Timed Out, and cannot complete the
connection.
Hello list, I am using 9.2.0.1.0 enterprise edition on windows.
Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release
1
I would get the following messages in French
c: sqlplus
Entrez le nom utilisateur :
But now when I specify nls_lang=French_France.US7ASCII , sqlplus
HUMM, That gives me an even worse feeling. Not something I'll use that's for sure.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, December 19, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
no ASMs are considerably different. Its
the last two projects I have been on we are using client server with .Net. Tons of
.net people, verify few database people.
oracle is pushing jdeveloper hard. You need skilled java people to use that.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/12/19 Fri AM 09:44:25 EST
To:
Can this be done a want to connect through ODBC, for a php web page
Can this be done if so how do I declare the username, password and db string
Currently i do
$username = name
$password = password
$dsn=dsn
Any help appreciated
Cheers
As with anything I suppose, if a single vendor can be
in control of more of the stack between application
and physical server structure then there is a greater
opportunity for benefits. For example, ASM offers the
ability to add disks to a stripe without needing to
redistribute(reload) the entire
Craig,
did you try:
$username = SYS
$password = syspassword AS SYSDBA
$dsn=dsn
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 19, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Can this be done a want to connect through ODBC, for a
The server was probably added to a domain (or moved to a different one) as part of the
upgrade. Try adding the following entry to your sqlnet.ora file.
SQLNET.AUTHENTICATION_SERVICES = (NONE)
-Original Message-
Paul Vincent
Sent: Friday, December 19, 2003 8:49 AM
To: Multiple
And the more that vendor, namely the database in this case, controls more and more of
the stack the more any performance problem must be a database problem. No thank you.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, December 19, 2003 10:34 AM
I have done that it works through SQLPLUS but through my page i can connect
to the dsn but now i get
Warning: odbc_exec(): SQL error: [Oracle][ODBC][Ora]ORA-03114: not connected
to ORACLE , SQL state S1000 in SQLExecDirect
From: Mercadante, Thomas F [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]'
Hi,
I sat in a presentation up here in Wisconsin. I got the distinct
feeling that most of the new features aren't optional. Either you
use them or you don't use 10g.
I can't remember if ASM was one of those mandatory features.
--
Joe Frohne
Rawson Oaks Consulting, Remote Oracle Admins
Craig,
the correct syntax is
sys/[EMAIL PROTECTED] as sysdba. So you might try:
$username = SYS
$password = syspassword
$dsn=dsn AS SYSDBA
PS - can you tell I'm guessing? :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 19, 2003 10:50 AM
Oh yes
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sys as sysdba with password through ODBC
Date: Fri, 19 Dec 2003 07:39:26 -0800
Craig,
did you try:
$username = SYS
$password = syspassword AS
I have a 9.2.0.3 DB running on AIX 4.3.3
An application running on W2K using SQLLDR to load approx 6g of data
using local managed tablespaces
ie..
CREATE TABLESPACE PARENTDAT
DATAFILE '/vol01/oradata/e450dev/parentdat01.dbf' SIZE 2000M REUSE,
I see this alot when people look for data warehouse people. any idea what is meant by
this? Not look for the obvious oxymoronic joke.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services--
I think so. Most of ourWebapps arewritten in Java, _javascript_, and Perl. Some minor web stuff is generated by PL/SQL.
Viktor
DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Viktor, Ryan - Is what you are experiencing the result of companies movingto open-systems Web-based architectures?Dennis
8.1.6?
Patrice.
-Original Message-
Sent: December 19, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Hi folks,
Our server team has just upgraded a server from Windows NT4 to Windows
2000, and when I tried connecting to the database from my workstation,
using OEM or TOAD, I get
[EMAIL PROTECTED] wrote:
I see this alot when people look for data warehouse people. any idea what is meant by this? Not look for the obvious oxymoronic joke.
This was briefly covered several days ago in c.d.o.misc
(watch for wrap)
Hi, Julio,
Windows doesn't have a nsswitch.conf equivalent. Windows hosts file is
equivalent to UNIX /etc/hosts. Imagine Windows has a nswitch.conf like this:
hosts: files dns
But it's missing other lines such as protocoles, services... in this file.
This topic is much less off-topic than some
Hello all,
Monday December 22 is my last day at Roche. It has been a wonderful experience working
and interfacing with all of the fantastic people at Roche and I hope I get to work
with many of you some time in the future. Thanks to all who provided support and
assistance many times. It will
Yong,
Thanks for the making that correction.
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College
-Original Message-
Yong Huang
Sent: Friday, December 19, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Hi, Julio,
Windows doesn't have a
I was using RMAN to duplicate a database -- my first time (please be
gentle).
Copied an on-disk rman backup to target box.
started clone instance nomount.
rman nocatalog
connect target abc/[EMAIL PROTECTED]
connect auxiliary xyz/[EMAIL PROTECTED]
@script (see below)
Everything was going OK until
Hi, Raj,
9i doesn't allow a user with select any table privilege to view any object
owned by SYS. So the sys.link$ risk is gone. But select any dictionary, a new
privilege in 9i, allows that. In practice, I always grant select_catalog_role
to any developer, but refrain from granting select any
Hi
Does anyone know good Linux administration book?
Can you guyes suggest any good linux user group?
thx
-Seema
_
Tired of slow downloads? Compare online deals from your local high-speed
providers now. https://broadband.msn.com
--
Awww...we love you too man! ;-)
--- Gordon, Emery {PGL~Palo Alto} [EMAIL PROTECTED] wrote:
Hello all,
Monday December 22 is my last day at Roche. It has been a wonderful
experience working and interfacing with all of the fantastic people
at Roche and I hope I get to work with many of you
Just a couple of comments on this which hopefully won't go down the
Marketing track too far. :)
1. I'm pretty sure Steve Adams agrees with you, since he co-presented
on ASM at OracleWorld in San Fran. Not sure if he monitors this group
actively or not, but I believe the presentation he did is
I was in Reston last night, too. Also, Tom repeatedly
emphasized RMAN, which I've not spent enough time
mastering, will be even more important in 10g. Does
everyone here use RMAN that is using 9i currently?
BTW. Tom mentioned SAME, as you say, but I can not
remember what he said about it. Sorry.
A possibly related question:
I'm curious if everyone allows your developers to see
V$SQL... views? If not, then ... whatever ... no
comment.
I'm disappointed with some perspectives in these
threads regarding developers. Rather than close doors,
why not use 'development' instances, and role based
I think a good start would be to do level 8 10046 trace and see what the waits are.
Probably disk waits, but the question of course is 'why?'. Before you can
ask that though, you need to be sure what you're waiting on.
Jared
John Blake [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
Right. Then the finger pointing will be contained within Oracle Corp.
I don't know whether ASM is a good idea, a bad one, or a mediocre one,
but I don't believe holding one vendor responible will help resolve issues
in a more timely manner.
Pete Sharman [EMAIL PROTECTED]
Sent by: [EMAIL
This could simplify life, particularly with wait event-based tuning. If
Oracle properly instruments these additional layers for timing, it makes
it easy to diagnose performance problems, not harder. Interested in
Cary's thoughts on this.
Adam
Goulet, Dick [EMAIL PROTECTED]
Sent by:
Maybe I'm a being a bit touchy here; but it seems that my comments about
having access to dba_users went completely unnoticed. Let's put it this
way: There is NO WAY you can prevent somebody from setting up their own
private oracle instance. It they have access to dba_users in your database,
Sure it does, just not by default. Check out the
07_DICTIONARY_ACCESSIBILITY parameter.
Enjoy!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Friday, December 19, 2003
SAME is stripe and mirror everything. There is a doc on otn by that name. ASMs will do
that for you, 'in theory'.
kyte is the technical face of oracle. This is why they pay him so much money.
presentation would have been better if people didnt play 'stump the dba'. It seems
like people were
Hi Gurus,
I don't understand the SAMPLE BLOCK behavior. Why is it giving different results for
the query?
[EMAIL PROTECTED] SQL select * from SALGRADE sample block (1);
GRADE LOSAL HISAL
-- -- --
2 1201 1400
[EMAIL PROTECTED] SQL
To All,
I'm feeling in a LAZY mood this afternoon so I'm going to ask the list if
someone has an answer to this. Otherwise I guess it will wait till Monday.
We have a before update trigger on a table to prevent assemblies on the line
from being unscrapped. But we also have a
Couldn't your trigger fire off a procedure to evaluate userenv and the
proceed or not?
-Original Message-
Sent: Friday, December 19, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
To All,
I'm feeling in a LAZY mood this afternoon so I'm going to ask the
list if someone
Is it possible to find how many DML operations have ocurred on a given table in
a given time period? I'd like to be able to rank the tables in a database based
on the number of DML actions performed on them in a given time period. It would
be interesting to see which are the 'hot spots' so to
You can identify the user via sys_context ('userenv', 'sessionid') and raise an exception,
or just exit the code block.
Jared
Goulet, Dick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/19/2003 11:49 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
Would this help?
CREATE OR REPLACE TRIGGER [schema].[trigger_name]
BEFORE [CONDITIONS] ON [table_name]
FOR EACH ROW WHEN ( ( USER != '[USERNAME]' )
AND ...
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, December 19, 2003 2:49
I think Jared means..
sys_context ('userenv', 'session_user')
to identify the username.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Who fired the trigger
Date: Fri, 19 Dec 2003 11:59:41 -0800
You can identify
Alter table table_name monitoring;
then look in DBA_TAB_MODIFICATIONS
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, December 19, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Is it possible to find how many DML operations have ocurred
Is there any significant overhead to leaving tables in monitoring mode? For example,
if I left them as such for a few days or two, and then gathered the stats on them?
Thanks again,
-- Dan
On Fri, 19 Dec 2003, Goulet, Dick wrote:
Alter table table_name monitoring;
then look in
Euphemism for Oracle Discoverer in many cases.
It is about the ability of mgt. to know how their company is doing, e.g.
sales reports, etc.
Someone posted an item on Wal-Mart and K-Mart recently, that kind of thing.
If Mgt. doesn't have accurate info on how their company is doing, the
company
it may be helpful if u take the stats from V$SEGMENT_STATISTICS and compare
them over a period of time.
I believe this view might be available only from 9i upwards.
regards
ratnesh
-Original Message-
Sent: Friday, December 19, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Is
It's the ability to use your operational data, such as invoicing, patient
visits, etc., and aggregate them in ways that tell you trends, good and bad.
What age group had the most doctor visits? What product sold the most? These
sound very simplistic and obvious but there are many nuances. For
I think Jared means..
sys_context ('userenv', 'session_user')
to identify the username.
Actually I didn't mean that, though it will also work.
John Weatherman had a better way to do it, in any case.
Jared
H elp_me [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/19/2003 12:19 PM
IIRC, Steve Adams said that the impact was 1%
Jared
Daniel Hanks [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/19/2003 01:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Finding the most actively
That's why we have scripts which give us a report every few days on users that have
db_links, any of the *_ANY_* privs (like alter any table), dba privs etc, also a list
of some sensitive schemas too.
Our application support needed to work with users to grant/revoke roles and private
synonyms.
Just thought I would share my hit ratio with y'all.
LOGICAL I/O PHYSICAL I/O BLOCK
HIT
USERNAME SID OS USERPROCESS BLOCKS BLOCKS CHANGES
RATIO
-- -- -
57 matches
Mail list logo