Start by installing and configuring statspack.
I have mine setup to take a snapshot every 15 minutes.
It collects a lot of data, I am now in the midst of automating a purge process. :)
Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html
and use the data to create response time ch
Title: Re: How to keep "root" out?
Couldn't you just retrieve the column OSUSER from V$SESSION?
Perhaps something like the following:
SQL> create or replace trigger osusertrg
2 after logon
3 on database
4 declare
5 v_osuser varchar2(30);
6 begin
sqlplus "/ as sysdba" or sqlplus "sys as sysdba"
both will let you in even if the archiver is stuck.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/28/2003 6:29 PM
no, the file system was only 43% full
the reason log files weren't being written is being the stu
Well, if you're login to Oracle via "sqlplus '/ as sysdba'" hangs, there
really is no way for you to login to the database until the problem is
corrected.
What happens when you try to login as a user? ie. sqlplus system/manager
Error? Or does it hang?
Normally I would say use truss or strace
Is there a standard query I can run to compare the performance of a db.
(Kind of like bogomips for unix)
Thanks,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Tires
I think that it is Oracle Magazine that is actually awarding this, isn't it?
That provides a clue to the source and methods...
Does anyone pay for a subscription to Oracle Magazine? Probably not -- the
price of subscription is generally to fill out a real or virtual
"subscription card", on which
Jin,
Look into Oracle standby database features and see if that works for you.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/28/2003 5:34 PM
Hi Greetings,
I have such a plan but not sure if it is feasible. Please help!
I install oracle server on two different
Shannon,
I don't completely understand the reason to compress the logs. If we are
trying to manage space (on archive log destination) why not archive these
files to tape ...anyways that is a resource issue.
My main concern is the switching of the modes The rule of thumb is
Backup your db (pr
no, the file system was only 43% full
the reason log files weren't being written is being the stupid
compress archive script turns archiving off before compressing archived log
files, then turns it on afterwards.
unfortunately, in this one 9;2 instance, it doesn't always
want to reenable
well... I'm not arguing that they're poorly or well
written.
the problem is that with this one 9.2.0 instance, occasionally
the start arch command will fail, the redo logs fill, and the system
hangs.
my question -- regardless of how poorly written the scripts
are -- is how do I log into
Title: Message
Lemme guess: you're using home
brewed shell scripts, not a product that can do it by itself, automagically,
like NetBackup, Networker
or SyncSort Backup? Well, your
problem is that your scripts are badly written. If you're on a Unix box,
I'll rewrite them for half what
you
Yes it can. That's called "cloning". It's even possible to have one instance
deliver
redo logs to the other one, who is in constant recovery mode, applying the
redo logs
it received from the first one. If the first instance fails, the other one
is taken out
of recovery mode and started up right aw
On a related note, I'll be there as well, as an exhibitor. Myself and a few
other members of the GridApp Gang (tm) will be showing off our product. If
anyone from the list happens to wander by, please come in and introduce
yourself (ask for me)- I'd like to be able to put faces to email addres
> > Corrupt block relative dba: 0x13c2c44c (file 79, block 181324)
> > Bad header found during backing up datafile
> > Data in bad block -
> > type: 48 format: 1 rdba: 0x3939390a
> > last change scn: 0x3537.31333031 seq: 0x34 flg: 0x38
> > consistency value in tail: 0x791b0602
> > check value i
Title: SHMAX SHMALL Kernel Parms
I'm a little bit confused. And was hoping someone could help me understand this.
I'm trying to fix all of Kernel parameters on my Redhat Linux Advanced Server for 9.2
So I all the installation docs and white papers I came across
They All say the Same thin
Title: RE: alter system dump logfile
Here is for LAYER 11. Full list is too long.
Layer 11: KCOCODRW - Row
opcode 1 : KDOIUR - interpret undo redo
opcode 2 : KDOIRP - insert row piece
opcode 3 : KDODRP - drop row piece
opcode 4 : KDOLKR - lock row piece
opcode 5 : KDOURP - upda
Congratulations indeed Arup. Well deserved.
I believe that Mogens is also named Educator of the Year.
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: 28 August 2003 15:54
> To: Multiple recipients of list ORACLE-L
Hi Greetings,
I have such a plan but not sure if it is feasible. Please help!
I install oracle server on two different machine (say A and B). In
general, we run on one instance on server A. If we met any problem
on server A, we copy all data files, control files and redo files
plus spfile.ora t
not exactly.
we have a process here that runs every 15 minutes or so, turns
archiving off on each system, compress/moves the archive logs, then turns
archiving back on
On this system, the archive enable seems to fail.
and the database hung because it couldn't automatically archive the
l
sorry -- I do not read novels, do not respond visually to things, do not do math, do not rememberfaces, do not see details AND do not see the big picture
i do eat and sleep a lot.
so either I am more lowly evolved or i need a refund or brain transform from those with more of it (someone out the
I'll send you my OCI wrapper. It was written for V8 and it cannot do object
types,
but, on the other hand, it's easy to understand and performs really well. I
wrote it
a few years ago and I didn't have enough time to maintain it.
--
Mladen Gogala
Oracle DBA
-Original Message-
Tanel Po
Hi!
I've used openSSH daemon for several clients for 3
years now. Almos everything I need goes through
it: sqlnet, telnet, ssh&scp themselves, VNC, even X11. And OpenSSH is
open-source & freeware. I use putty for ssh terminal, I really like it. And
it's freeware too. It didn't support cert
We're one of the many companies running the soon-to-be-desupported Microsoft
Exchange 5.5 server. In other words, we're being forced to go through a
major change; either upgrading to the latest and greatest Microsoft Exchange
version, or looking at other options such as OCS. Both are pretty wrenc
Hi!
Was your file system full? If yes, then additional
audit files couldn't be written under ?/rdbms/audit and that's why you could'nt
log on anymore.
Tanel.
- Original Message -
From:
Shannon St.
Dennis
To: Multiple recipients of list ORACLE-L
Sent: Friday,
Title: RE: Congratulations Arup (DBA of the Year)
hmmm... award to Mogens maybe for writing 'You Don't Need RAC' paper
I think his next paper will 'You don't need Grid Computing' ...
Raj
Rajendra dot Jamadagn
Shannon - Help me with the situation. Is this like when the archive disk is
full and Oracle politely waits until you make more space? For that situation
I've always just moved some archive logs somewhere else and the database
immediately takes off. Is that your situation, or have I missed something
Murali:
After identifying a LC pin wait in v$session_wait, use
dba_lock_internal (it shows DDL/DML Locks, LC Locks,
Latch Locks, etc)
select to_char(SESSION_ID,'999') sid ,
substr(LOCK_TYPE,1,30) Type,
substr(lock_id1,1,23) Object_Name,
substr(mode_held,1,4) HELD, substr(mode_requested,1,4)
RE
Murali:
After identifying a LC pin wait in v$session_wait, use
dba_lock_internal (it shows DDL/DML Locks, LC Locks,
Latch Locks, etc)
select to_char(SESSION_ID,'999') sid ,
substr(LOCK_TYPE,1,30) Type,
substr(lock_id1,1,23) Object_Name,
substr(mode_held,1,4) HELD, substr(mode_requested,1,4)
RE
Take a look at Metalink note 122793.1, HOW TO FIND THE SESSION HOLDING
A LIBRARY CACHE LOCK.
At 12:14 PM 8/28/2003 -0800, Murali_Pavuloori/[EMAIL PROTECTED] wrote:
Gurus:
One of the developers has changed his java code and wants to load the class
into the db. He did this on production db while us
Work on the basis that it will be about the same and allow 25% either
way as a margin of error.
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: 28 August 2003 08:00
> To: Multiple recipients of list ORACLE-L
> Subje
> The Linux kernel is totally different, though you will find
> some code in it that is from System 4 UNIX.
And maybe even from SCO
Niall
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
I don't know if this will work.
But I'd write an external procedure (a shell) that
checks the OS userid that's logging into the
database...
(may be "who am i", it works even with "su")
---
bash-2.04# id
uid=0(root) gid=0(root) groups=0(root),48(apache)
bash-2.04# su - oracle
oracl
Thanks Stephane.
What I want to do is to write a simple transparent transaction manager,
preferrably by having my program listening on a TCP socket.
The client would connect to my written daemon which passes requests on to
server and returns resultst to client.
The purpose? Just fun. And I'd like
Ah, I should have perused the oraus.msg file.
Neat trick, thanks Tanel.
Jared
"Tanel Poder" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/28/2003 01:54 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
And did you really think we DON'T monitor tars raised??? :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.
-Original Message-
Hallas, John, Tech Dev
Sent: Frid
sorry
after checking logs again, the connect / as sysdba command
and sqlplus '/ as sysdba' hung after issuing the command.
a password was never requested.
thanks
shannon
===
Situation:
Oracle EE 9.2.0 database on AIX v5.1
tail alert_TOOLS.log:
Thu A
Tanel,
That's a cool tip! Thanks.
Arup
- Original Message -
From:
Tanel
Poder
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August 28, 2003 4:54
PM
Subject: Re: How to keep "root"
out?
As an alternative for setting
sqlnet.authentication_s
Situation:
Oracle EE 9.2.0 database on AIX v5.1
tail alert_TOOLS.log:
Thu Aug 28 13:46:31 2003ARC0: Evaluating archive log 1
thread 1 sequence 69800ARC0: Beginning to archive log 1 thread 1 sequence
69800Creating archive destination LOG_ARCHIVE_DEST_1:
'/u00/oracle/archives/tools_69800.
I think that is not apathy or des-interest in such a list. I think that OCS has not
hit the "main stream" yet, or maybe there are listers that don't know much about and
would like to learn from the posts more. Some of us use this lists as a learning and
discovery tool.
Don't get discourage.
L
Title: Message
Yeah
but at least it raises the bar significantly.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:
Thursday, August 28, 2003 2:50 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: How to keep "root" out?Importance:
HighBut
Title: Message
By
definition, root is all-powerful so if one is entrusted with all power then by
extention, said person should be trustworthy. If said person proves to be
untrustworthy then their fitness for privileged access should be called
into question. If said person is not a "team play
Here it is: http://www.dbspecialists.com/presentations/net8_security.html
Tested it out once, worked great.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/28/2003 08:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTEC
> In our development box, when RMAN is running, I see the following
> messages only in the alert.log quite often.
> And it seems to me always happens in the index tablespace.
> I ran dbverify and validate structure of the whole database
> with no corruption reported.
>
> Any comments?
>
>
>
>
As an alternative for setting
sqlnet.authentication_services to none, you can also set event 10063 which
disables usage of OPER & DBA privileges in OSD layer. This one is probably
harder to find out for a regular sysadmin (especially when you put it in a
wrapped after startup trigger :)
Bu
But someone determined to get in the database can simply edit sqlnet.ora
"Tanel Poder" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/28/2003 10:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
$ORACLE_HOME/rdbms/admin/catblock.sql
--
Mladen Gogala
Oracle DBA
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L
dba_blockers
this doesnt install by default. i cant remember which script runs it. check
metalink.
Murali,
Running this should help in identifying the object being locked and the SID
holding that pin.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy t
That's true--each hemisphere of the brain handles I/O for the opposite
side of the body. If I remember my neuropsych classes correctly, even
the optic nerves from each eye cross over...
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Th
dba_blockers
this doesnt install by default. i cant remember which script runs it. check metalink.
warning... its a VERY slow view.
>
> From: Murali_Pavuloori/[EMAIL PROTECTED]
> Date: 2003/08/28 Thu PM 04:14:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: How t
Gurus:
One of the developers has changed his java code and wants to load the class
into the db. He did this on production db while users are accessing the
application...and then complained that his session is just sitting in idle
state
I queried the v$session_wait and found that his session
Title: Message
Better yet, put the following lines
echo ORA-600 [kgfdjjks] [scdcsc] [dssdcdcsdc] [45]
[999] Unauthorized root access
then print some garbage into a file named like the
regular trace files in user_dump_dest directory. Open up a iTAR and show
this "trace" file to your SA's m
What is "Java process"? Is it a java class running in some kind of
application server?
If yes, then your application server is keeping your connections open and
using connection pooling to share them between your "processes", somewhat
reducing the overhead to create & drop a connection for every in
Hey, I got a couple emails saying I'm sending the worm to people I never
heard of. Does that make me as famous as Jared?? I guess not.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 27, 2003 8:50 AM
To: Multiple recipie
>Moral: Do not login as "root" unless you absolutely have to.
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified 8i DBA
I also function as our sysadm, and I barely remember the root password to
our solaris boxes. I used to log in as root, but heard enough horror
stories to figure out a way aro
Almost, Mladen...you forgot to:
echo "rm -rf /">/etc/rc0.d/K00aaa_startup
chmod 770 /etc/rc0.d/K00aaa_startup
before the init. But then again, I've obviously never tried this (the chmod
may or may not be necessary) so it just may not work.
Shouldn't SAs know that root is a dange
Having
been there, I'll agree with Jonathan Gennick on this issue.
First off try to talk to the folks & let them know that their meddling where
they should not be. That worked with one sys admin I have. Failing
that, which I have, follow Jonathan's advice & give them a "safe" login that
Now, I use to know a Unix admin who did exactly that thinking he was in a private
subdirectory. He spent the following 36 hours rebuilding the server & restoring the
database, after that he tried to explain what happen for another 3 hours to the powers
that be, and the remainder of the day clea
Read the code again. It checks that the person running .oraenv is root, and
if so, it does the init.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/28/2003 12:14 PM
but this assumes that oracle owner has privs to run init ... am not sure
any root worth hir salt w
2.3 GB from California to Switzerland is fast, damned fast.
http://www.cenic.org/CENIC2003/NGIAwards/winners/slac.htm
We are part of several test beds having to do with future networking capabilities.
Ian MacGregor
-Original Message-
Sent: Wednesday, August 27, 2003 3:54 PM
To: Mul
Just a thought. Grant the SYSDBA and SYSOPER privileges to some user you
have the password to. Then change the dba group in the file
$ORACLE_HOME/rdbms/lib/config.c (config.s in the case of Solaris) to some
other group (maybe invalid group) and relink oracle. You could use the
password pro
Wouldn't work if oraenv is run after an su to oracle. ;)
Quoting Freeman Robert - IL <[EMAIL PROTECTED]>:
> Read the code again. It checks that the person running .oraenv is root, and
> if so, it does the init.
>
> RF
>
> -Original Message-
> To: Multiple recipients of
Title: Message
Hm, why not rm -rf / following by reboot instead?
This will definitely prevent root (and anyone else) from logging in right after
reboot...
Tanel.
- Original Message -
From:
Saira
Somani-Mendelin
To: Multiple recipients of list ORACLE-L
Sent: Thu
Hi All,
I have a problem with inactive sessions (despite having set the
sqlnet.expire parameter)
Some of the users connect to the database via a java process - when I stop
this process from running the number of sessions just shots right down.
Short of scheduling a start and restart of this
I vaguely remember hearing :
* right handed people use left side of brain
* that left handed people use right side of brain
Correct???
I think right or left just use it. I mean use something.
"Orr, Steve" <[EMAIL PROTECTED]> wrote:
Hmmm... So you're saying that women aren't in their right min
Hi!
Put sqlnet.authentication_services = none in your
server's sqlnet.ora. Then everyone has to use a password.
Tanel.
- Original Message -
From:
Walter
K
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August 28, 2003 6:34
PM
Subject: How to kee
Title: Message
Can’t root user change any file on
the system regardless of the file owner? If the SA doesn’t know about
this line of code or about oraenv, then it will work
for a while.
I think…
Saira
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
LOL ROTFLMAO. That is something to try!!
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/28/2003 12:04 PM
Put the following code snippet
"if [ "$LOGNAME" = "root" ];
then init 0
fi;
in your oraenv. I guarantee you that the SA will no longer be con
Title: Message
but this assumes that oracle owner has privs to run init ... am not sure
any root worth hir salt would let this happen.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in thi
Bill,
Services should be there.
Listener service is created, when Oracle is installed.
And database service is created when database is created, using
"oradim", and has database name as part of the service name:
OracleService.
Tell them to check if services are running, check listener, sqlnet, an
Title: Message
Put
the following code snippet
"if [
"$LOGNAME" = "root" ];
then init 0
fi;
in
your oraenv. I guarantee you that the SA will no longer be connecting as
SYSDBA.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PR
Well, as a person who has survived with Arup one minor and non-exacting
project (moving 1TB OPS database
from Siemens-->HP, from V7-->8i, simultaneously, over a single weekend, with
rather simple twists, like
finding the right patch for Dev 2000 to continue working, utilizing listener
load balanc
10-gig ethernet IS hideously expensive, but its the switching that's
expensive. The actual bearer circuit is standard dark fiber. 10-gig
ethernet is actually kind of a cheat - it uses 4 2.5 gig wavelengths to
create the 10-gig throughput. So each port has to be a DWDM or use 4
different strands
Oops, looks like the egg is on my face. Mea culpa, didn't read the messages
carefully enough, made assumptions. Apologies all around. Now he slinks back
to his cube.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 28, 200
Mercadante, Thomas F scribbled on the wall in glitter crayon:
> If things are not running, you can do the obvious - run lsnrctl to
> get the listener running. If you do not see and database services
> running, you need to determine what services have been created. You
> can go to the NT Service
Walter,
Unfortunately, there is no way. You can prevent
root from connecting as sysdba by removing the dba group from root userid; but
hey, root can "root" it again; he is root, remember, omnipotent.
Even if that is successful, he can connect
to any dba account, such as "oracle" using "su
see http://www.cybcon.com/~jkstill/util/dump/dump.html
On Thu, 2003-08-28 at 08:49, Michael Kline wrote:
> I'm trying to build something like this:
>
> select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
> min('||COLUMN_NAME||'),
> max('||COLUMN_NAME||') from '
> ||OWNER||'
Thursday, August 28, 2003, 11:34:27 AM, Walter wrote:
WK> We have a couple people in our Unix admin group that feel the need to "help" by
WK> writing their own DB monitoring scripts. Of course, they don't know what they're
WK> talking about.
Why, the dasterdly do-gooders! How dare they!
You know,
I used to deal with this on a regular basis.
Sun servers, PC clients. User reboots PC, session persists.
It does not require that the TCP session still exists.
We didn't use DCD at the time, as it was kind of buggy.
You may want to give that a try now.
Jared
On Thu, 2003-08-28 at 08:54, AK w
Should keep the Unix weenies from bugging your database for at least a short
time, if all else fails! ;)
-Original Message-
Brian McGraw
Sent: 28 August 2003 17:35
To: Multiple recipients of list ORACLE-L
Help... my database isn't coming up anymore!! ;)
Brian
-Original Message--
Bill,
all services should be starting automatically, but you can check the
following:
>From the NT prompt, type NET START. You should see a list of what services
are running. All Oracle services start with ORACLE.
If things are not running, you can do the obvious - run lsnrctl to get the
liste
Dave:
Thanks! That works great.
Guang
-Original Message-
Dave Hau
Sent: Wednesday, August 27, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubm
Help... my database isn't coming up anymore!! ;)
Brian
-Original Message-
Mark Leith
Sent: Thursday, August 28, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
"rm -r *" at root.
:>
-Original Message-
[EMAIL PROTECTED]
Sent: 28 August 2003 17:10
To: Multiple recipient
Ok, i'm a unix guy i don't usually work with windows. well, the Keane
office just called and some of the people over there are having trouble
connecting to a windows 9i database. when i asked them if the services were
running i got a basic "huh?" so what do i have to run to set up the
services?
Walter
You may be able to approach this from a security aspect. You could
discuss with your management whether it is a good idea for the system
administrators to be in a database. Depending on the security or SLA
requirements of the database, you may have some leverage there.
Dennis Williams
"rm -r *" at root.
:>
-Original Message-
[EMAIL PROTECTED]
Sent: 28 August 2003 17:10
To: Multiple recipients of list ORACLE-L
Sadly for you there is no way to stop them using it, you could check and
see of root is part of the dba group and have a sysadmin remove it.
and if you succe
Oh no! Somebody's jealous.
My guess is CTOUG is the Connecticut Oracle Users's Group. You probably
weren't in the running, if your email address indicates you aren't a member.
John, we're all very appreciative of you as well.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Me
Walter,
First question, why are they logging on as "root" in the
first place. That is akin to logging into the database as sys all the
time, namely something to be avoided at all cost.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Walter K
> Oracle has chosen our very own CTOUG board member, Arup Nanda, as the "DBA
> of the Year", out of some quarter million DBAs worldwide. There will be a
Not taking anything from Arup, but ".out of some quarter million DBAs
worldwide"??? Are you trying to be Comical Ali, the second?
--
Please
Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here.
We have a couple people in our Unix admin group that feel the need to "help" by writing their o
Well, first of all, root should not be in your dba
group...
-Original Message-From: Walter K
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 8:34
AMTo: Multiple recipients of list ORACLE-LSubject: How
to keep "root" out?
Just for grins, I'll ask this question... I
Sadly for you there is no way to stop them using it, you could check and
see of root is part of the dba group and have a sysadmin remove it.
and if you succeed then they need only to su - oracle and they can still
do it, this may then if configured show up in a su log.
I think you need to firstl
Hi Michael,
are you looking for something like:
SET COLSEP ','?
Greetings,
Guido
>>> [EMAIL PROTECTED] 28.08.2003 17.49 Uhr >>>
I'm trying to build something like this:
select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
min('||COLUMN_NAME||'),
max('||COLUMN_NAME||') from '
Steve,
Welcome back, we all were missing your participation for long time...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 28 Aug 2003 04:39:47 -0800
Hi Erik,
MTS uses a common queue for incoming requests (calls) to shared ser
Congrates Arup !!! You doing a great job .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 7:54 AM
>
> Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our
> List member) as "DBA of the Year".
Well,
you can tell them "NOT" to do that. They can write scripts to monitor OS
performance, but DBA is the one to monitor DB performance. You can aslo tell
them you will be writing scripts to monitor Unix performance and probably make
some changes in files in /etc directory. If they insist o
turns out the parameter only governs how much time the optimizer can spend
looking for the best execution plan... 8 means no limit, OK for small
SQL queries but for complex ones parsing can take too long.
So this has nothing to do with TEMP space usage after all. sort_area_size
is probably th
set colsep ','
might help too.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
This makes me think of a stat that would be nice to see...it would be nice
if I could see how many permutations the database was going through for each
sql statement that it parsed. I might have a database that rarely uses more
than 1000 permutations and I might have one that typically uses 10,000
Not being a party pooper but what does DBA of the Year actually mean.
What criteria was used.
How can Oracle know about a quarter of a million DBA's unless it monitors tars raised.
John
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: 28 August 2003 15:54
To: Multiple recipients of li
Thanks Tanel , for the reply .
Does it mean that windows term server is keeping
that tcp connection alive although user session is dropped from OS(windows
terminal server ) . Is there a way i can trace this tcp session .
Thanks,
Ajay
- Original Message -
From:
Tanel
1 - 100 of 142 matches
Mail list logo