There is a big chunk sitting for free inside the iLearning area of Oracle's
own web sites.
This is free for the Trial and they have most of the Architecture and
Administration stuff there... including an overview of how to prepare for
the exam...
Mark
-Original Message-
Ling Catherine
hi,
but where to find the audited data..
pls tell in detail.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 3:30 AM
SQL audit connect;
works for me on V8.1.6
[EMAIL PROTECTED] wrote:
Hi,
we would
Hi,
the documentation for Oracle Intermedia (formerly ConText) is included
in the Oracle server's documentation set. If you don't have it available
yet, take a look at technet.oracle.com. There you can find all
documentation sets online.
MOHAMMAD AMER schrieb:
hi oracle gurus,
does anyone
O.P.S. Setup in Benchmark Runs :-
--
2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6
3rd APP Server -
Thanks
for those
Regards
Lee
-Original Message-From:
Miguel Farenzena [mailto:[EMAIL PROTECTED]]Sent: 20
April 2001 18:15To: Multiple recipients of list
ORACLE-LSubject: RES: Compaq Tru64 Kernel Parameters for Oracle
8.1.6.2
Lee,
Try:
Another option could be to write event based triggers for
User Logon/Logoff events(provided you are on 8i).
Rajesh
Hi,
we would like to log all the connections made to the
database. currently I can only find the users who logged
in from the client using net8 tcp/ip. BUT Which log
Hi,
i want to know that how will i get to know how many users (along with their
identities) who are logged in at any one particular moment of time.
mainak
__
123India.com - India's Premier Portal
Get your Free Email Account at
On Sun, 22 Apr 2001,Cyril Thankappan scribbled on the wall in glitter crayon:
-
-Hi!..
-
- DOes any one here have any information of
- where I could possibly find some information
- on Cold fusion and Oracle
-
- Thanks
we are using that combination here in several applications, feel free to
This is the script we use for sessions; edit out anything you don't need.
select s.sid sid,
s.serial# serial#,
s.lockwait lockwait,
0 blkby,
0 blkcnt,
s.username session_user,
s.program program,
s.osuser osuser,
s.status status,
Use this script:
rem Display Active User Sessions on the Data Base
rem
column username format a11
column the_command format a22
column serial# heading 'SER#'
column serial# format 99
column process heading Unix Process
select username, sid, serial#, process, command || '-' || ACT.name
John:
Check out this link ...
http://asktom.oracle.com/pls/ask/f?p=4950:8:64994::NO::F4950_P8_DISPLAYID,F4
950_P8_CRITERIA:1346602827682,{java}
Be sure to get both lines!
Kevin Toepke
-Original Message-
Sent: Monday, April 23, 2001 7:25 AM
To: Multiple recipients of list
Cylir
Check the CF docs on the Allaire web site. It's been a while for me, however
set up a data source on the CF server using ODBC and Net80, then use that
data source name in the CF SQL. Something like datasource name = XXX.
Like I say, It's been awhile. Oh, I think the enterprise version of
Yes, I have used with very good success it's all documented in T(ht)
F(ine) M(anual). Or just open up $ORACLE_HOME/rdbms/admin/dbmsjob.sql ...
this file itself is pretty good at explaining things.
HTH
Raj
__
Rajendra Jamadagni
Title: RE: ORA-04030
Hi Anton -
The error is exactly what it says it is. The OS is out of memory to allocate to this once process.
Are you using PL/SQL tables or anything that could go wild with memory in your PL/SQL scripts? I've had this happen before when I first started messing with
You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have
access.
[EMAIL PROTECTED] 04/20/01 05:27PM
If I remember correctly the user can set autotrace on in the session and the output if
sent to the terminal after the sql command is completed.
Give it a try.. You
Hi,
could some one help me, how can I send an attachment within a mail with the
Oracle 8i's built in SMTP or TCP package? The file to be attached is on the
server side. Java in the database or shell script is not an option for me
right now.
Every help or hint will be highly appreciated.
Best
Title: RE: SQLTrace
Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them.
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess
[EMAIL
Title: Kdb database engine
Anyone out there using the Kdb database?
I am executing a SQLLDR shell file from a server :: sourceserv; RDBMS 7.3.2.3
AIX 4.3.2
into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3
using a SQL*Net connect string destserv_destSID.
This connect string is defined in the local tnsnames.ora and works. I confirmed
this by doing
Hi listeners,
I would like to know if any of you have tried this before. I would like
to know if any one has tried to setup an application that would do a
dual commit to two Oracle Databases, and be able to keep the database in
sync should an outage occur on one of the databases without using
I thought that kdb was a kernel debugger?
-Original Message-
Sent: Monday, April 23, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Anyone out there using the Kdb database?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET:
You can also set _trace_files_public=TRUE in the init. ora file.This will
create trace files with 644 file permissions..
Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
My opinions. Use at your risk
You probably have the releasable locking which is much more CPU intensive
then the static (hashed) locking. Try with setting hashed locking on the
tablespaces that you do not write too often (this assumes that your
reference
tables like ZIP codes, states, countries or discovered bugs in
How big is your shared pool size ? Do you have many dynamic SQLs ? You may
want to keep the sys packages in the shared pool, so that your shared pool
won't be fragmented by dynamic SQLs.
Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Ok,maybe i am lazy or a poor reader, but are you
using 732 sqlldr binaries to load an 815 db?
Why not the 815 sqlldr binaries?
I mean, it sounds like you have to ship data over the
wire no matter what you do, so...why not use the latest
version of the sqlldr bits?
== -Original
You can also use _trace_files_public=TRUE in your init.ora file too. I
know it works with Oracle 8.0 and above on Solaris.
Kevin Toepke
snip
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: RE: ORA-04030
Hi Riyaj,
I think you are referring to the ORA-4031 error? 4031 refers to a fragmented SGA. 4030 is the OS.
Correct me if I am wrong.
qodd bar:/oracle/localoerr ora 4030
04030, 0, out of process memory when trying to allocate %s bytes (%s,%s)
// *Cause:
Title: RE: SQLTrace
Hi Riyas,
I had used this in previous versions. I'm on 8.1.6 now. I looked before sending this response and I didn't see this in v$parameter. What version are you on?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April
What did you try and resize it to? Remember, you only have 128 mbs.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, April 23, 2001 12:02 PM
To: Multiple recipients of list ORACLE-L
How big is your shared pool size ? Do you have many dynamic SQLs ? You may
want to keep the sys
On 20 Apr 2001, at 19:15, Jared Still wrote:
Date sent: Fri, 20 Apr 2001 19:15:20 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Well, why would you *not* want to denormalize during design? It seems
to me that (theoretically) ***if***
Well, in reality, there is only one way. You must shamelessly advertise
yourself and invent some legends about yourself (I saved Priceline...).
-Original Message-
Sent: Friday, April 20, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L
installations?
I've thought that it would
On Monday 23 April 2001 09:53, Eric D. Pierce wrote:
I guess I've been under the impression that a good design
process would be done with proper methods, including having
(legitimately tested) performance metrics.
Are you saying that is an overly idealistic approach for most
real world
I'd be curious to see your definitions of un-normalized and de-normalized...
[EMAIL PROTECTED] 04/23/01 01:55PM
On 20 Apr 2001, at 19:15, Jared Still wrote:
Date sent: Fri, 20 Apr 2001 19:15:20 -0800
To: Multiple recipients of list ORACLE-L [EMAIL
fyi:
--- Forwarded message follows ---
Date sent: Mon, 23 Apr 2001 08:55:31 -0800
T o : O D T U G - D E V 2 K - L O D T U G - D E V 2 K - L @ f a t c i t y . c o m
F r o m : R o b e r t M o n i c a l m o n i c a l @ r m i . n e t
I'm not a guru, but I just received
Slightly off-topic:
Has anybody used the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure? If so
what's the syntax etc. to use this?
Cheers
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, April 23, 2001 04:56
To: Multiple recipients of list ORACLE-L
You can also set
I don't know about the other stuff, but Developer/2000 r.2x was
priced by Oracle sales people at about USA $4,000 per seat. I
think they went up to USA $5,000 or more since I last asked for
a precise price quote.
I have a vague recollection that Designer was more than that,
but that higher price
Title: RE: Kdb database engine
M'Laddy of Gogala,
Yes, good catch, the acronym can refer to some kernel
debuggers, too.
In this case, Kdb is the moniker for a superfast no-frills
in-memory db. (Praps our own Mr. Adams knows something
of this product, since it has sold to Telstra, where
No you are reading correctly. I have the data on a server with a 7.3.2.3
database and am using that databases' binary sqlldr to load into the 8.1.5
database. The problem is a timing issue. I need to execute the load from the
7.3.2.3 server as part of a larger script. I cannot ensure that the
Thanks Trivedi and Brian,
I think that you may be right about chained blocks,
I'll check this out.
- Original Message -
From:
Brian
MacLean
To: '[EMAIL PROTECTED]' ; 'Diego
Cutrone'
Sent: Friday, April 20, 2001 4:34
PM
Subject: RE: dbms_space.free_blocks does
Please look up 'AUDIT' in the documentation.
If you don't have the docs locally, they are available
at otn.oracle.com.
Jared
On Monday 23 April 2001 01:45, Saurabh Sharma wrote:
hi,
but where to find the audited data..
pls tell in detail.
saurabh
- Original Message -
To:
You can't send attachments from within Oracle, but you
can send MIME encoded email. Don't ask me how to
do that, cuz I don't know. I suppose I will find out if I
ever need to do it, or I will just ask you, as you will have
already done it. ;)
Here's a link that may help.
To set on:
REM Script to turn TRACE MODE on for a selected SID.
set serveroutput ON size 2000;
set verify OFF;
DECLARE
r_sid NUMBER;
v_sid NUMBER;
v_serial NUMBER;
v_usernameVARCHAR(30);
v_status VARCHAR2(8);
v_server VARCHAR2(9);
p_server_pid
I don't you *can* avoid the larger issue. Oracle 8 has undergone some radical changes
underneath the covers. I would expect SQLLDR to have changed just as radically...
[EMAIL PROTECTED] 04/23/01 02:06PM
No you are reading correctly. I have the data on a server with a 7.3.2.3
database and
Have you run catexp7 on the 8.1.5 instance?
Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]
On Mon, 23 Apr 2001, Mohan, Ross wrote:
Ok,maybe i am lazy or a poor reader, but are you
using 732 sqlldr binaries to load an 815 db?
Why not the 815
Are you using uniform extents? We are told they are not really = and actually are not
the same at all over time.
Thanks,
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 19 Apr 2001 15:25:31
Peter Barnett wrote:
We are using LMTs with several of our databases. No problems. With these
128MB of memory is killing you! Oracle's stated minimum requirements are
128MB (but they recommend 256MB). In fact, the Oracle Installer won't even
run without 128MB (in 8.1.6 and higher).
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Monday, April 23, 2001 12:56
Hello List,
For those of you that use Perl or would like to use Perl for your
regular DBA tasks, I have a request.
Do you have any tasks you perform with a series of SQL scripts,
shell scripts, etc, that you feel are somewhat of a kludge?
Have you every asked yourself There must be a
Should work perfectly on the following platform:
---
| IBM mainframe IMS database communicating EDI that runs in a legacy
| Z80 serial port simulator mode and boots off 8 floppies while
| communicating out to the operator console in morse code and in via
| manual register switches borrowed from
Steve,
Thanks for sharing your experiences! Quick question: In the end, once the
new hardware was purchased and properly setup, how was the performance of
the DB and backup? Were you able to meet the requirement of the 3 hour
backup window?
Ed Haskins
Oracle DBA
Verizon Wireless
On Monday 23 April 2001 11:15, Tim Sawmiller wrote:
I'd be curious to see your definitions of un-normalized and
de-normalized...
I'll take a quick stab at that.
Denormalized refers to a schema that began it's life in a normalized
state, and then thoughtful consideration was given to
Bill,
Do you know if CF is compatible with Oracle 8.1.6.2.1 on Solaris? We can't get them to
return our phone calls and we can't get CF to connect.
TAI
...JIM...
[EMAIL PROTECTED] 4/23/01 7:25:28 AM
On Sun, 22 Apr 2001,Cyril Thankappan scribbled on the wall in glitter crayon:
-
-Hi!..
-
-
Gogala
OK , Will Check Revert Results
It is True However that we have Set up Releasable Locks Primarily (
gc_releasable_locks=8)
Qs. 1 Oracle lmd process on DB Server is taking About 30% of the CPU During
the Benchmark Run period (of 1 Hour) . How can this be minimized ?
Qs 2 Please
The missing verb is think, as in I don't think you can avoid
[EMAIL PROTECTED] 04/23/01 02:46PM
I don't you *can* avoid the larger issue. Oracle 8 has undergone some radical changes
underneath the covers. I would expect SQLLDR to have changed just as radically...
[EMAIL PROTECTED]
Hi Tom,
Have you tried setting TWO_TASK variable instead of using the connect
string? I vaguely remember one of my co-workers mentioning it to me when
they ran into performance problems when loading from the appl server to the
database server. The performance issue was related to bindsize and
And just who is it that told you that?
[EMAIL PROTECTED] 04/23/01 02:40PM
Are you using uniform extents? We are told they are not really = and actually are not
the same at all over time.
Thanks,
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 19 Apr 2001 15:25:31
Peter Barnett wrote:
Acutally, 8.1.5 won't install either. I mean it will, but it will tell you
that it is a bad idea.
Kev
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, April 23, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
128MB of memory is killing you! Oracle's stated minimum
I'm an admitted purist...I look at denormalized and unnormalized as being the same.
I've been on projects that wanted to introduce denormalization because the developers
expected a performance issue. After I look at it and disagree, then the war begins.
On the other hand, on my latest
On Mon, 23 Apr 2001,James Howerton scribbled on the wall in glitter crayon:
-Bill,
-
-Do you know if CF is compatible with Oracle 8.1.6.2.1 on Solaris? We can't get them
to return our phone calls and we can't get CF to connect.
-
-TAI
-...JIM...
works for us here with no problem. are you
So, there I am, trying to find out what client a connection to an 8.1.7 DB
on Solaris is coming from. Naturally, I SELECT USERNAME, MACHINE, TERMINAL
FROM V$SESSION; Lo and behold, there is a generic login for the username,
column MACHINE in all rows contains jdbcclient and TERMINAL contains
My boss has to prepare a report for our board about change management and
asked me to look at some documentation of PVCS ERP change manager. Have
any of you ever used this product and what are your opinions of it.
TIA.
Lisa
* Lisa Yates
Hi!
really sorry if I am 'dragging u back'!
But can someone help me with Oracle's licensing
policy (policies!) for servers
and particularly the
terms
CONCURRENT USERS
Does 'concurrent users' mean that if 1 user
has 3 concurrent sessions , is he counted once
or thrice?
You should set your lm_locks parameter according to the instructions
for your specific platform and try putting all locks into releasable
mode first, by setting the number of locks to 0 in gc_files_to_locks
-Original Message-
Sent: Monday, April 23, 2001 2:46 PM
To: Multiple recipients
Hi Lisa
This is an underscore parameter. Hence v$parameter will not show this
parameter.. You got to look at x$ksppi and x$psppcv fixed tables to see
this parameter..Here is the SQL used if you are interested:
--cut
set linesize 80 pagesize 50 newpage 0
col param_dflt form a5 head
My understanding, obtained from arguing with my new licensing rep every 6
months, is that if 1 user has 3 connections, 1 concurrent license will
cover.
Highwater would count the above 3 connection user as 3 towards its
highwater mark, so the highwater is not a perfect 1-1 with the number of
(continuing with 100% wild *ss speculation)
Tim,
I thought this might be of interest to the person that asked the
original question, so am replying via the list.
My take is that human nature does *not* automatically support an
organizational culture that values esoteric theories and/or
Hello:
I'm trying to spool out couple of files from my temp table. Part of the file name is coming from a variable from the temp table. I use:
spool C:\CYCLE_COUNT_$temp_variable.DAT
but it's only one physical name instead of using the variable.
How can I code the variable name as part of (spool)
Well, I'm 75% of the way through creating scripts to automatically clone a
database. It's all in the korn shell and yes, I've been thinking 'there
must be a better way'! (besides the fact that soon I'm gonna need to put
this through end-to-end testing and would like help)
Linda
(re: purists/normalization)
Another thing I have wondered about:
Why doesn't Oracle (or other RDBMS vendors) enforce normalization in
it's products?
Since they don't enforce normalization, does that mean it isn't
important? Also, I note that there is very little mention of
normalization in
Nope, I believe that Mr. Adams used to to work for HP, not for Telstra.
Another participant of
this group (Leng Kaing) used to work for Telstra. Leng is also an excellent
DBA, with vast
experience.
-Original Message-
Sent: Monday, April 23, 2001 1:06 PM
To: Multiple recipients of list
Hi,
I don't quite understand your question, so here's
what I understood:
Just enclose the variable name with "{ }" , here's
an example
/home/oracle export
temp_variable=TEST/home/oracle echo
"this_is_a_$temp_variable_only"this_is_a_
-- wrong/home/oracle echo
One of the other DBAs here called me over to look at a weird situation.
We resized some datafiles, the size of the datafiles increased on the OS and
in dba_data_files but there are no entries for that tablespace in
dba_free_space. Currently:
DBA_DATA_FILES - 11451M total size of datafiles
what RMAN version?
i'm using 8.1.6 for several months, to backup 5 remote db's.
Never heard something like that.
Do you unregister using packagedbms_rcvcat.unregisterdatabase ??
And then new registration?, did you make any backups after new registration?
It seems a kinda bug.
- Original
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hello Guys,
i hv been trying to tune our RBS. i was using Steve's query
http://www.ixora.com.au/scripts/sql/sub_optimal.sql
to calculate the optimal size.
on the page http://www.ixora.com.au/scripts/rbs.htm
it says This script suggests raising the OPTIMAL setting if rollback
segments of that
I just am starting into the perl land.
*
my project/tool:
From oracle forms, call perl to remote login into a HOST(vms, sun,
whatever)
once i've login, run a script on the host with args.
exit back to forms.
-
scan the host when-timer-expire to see the
Hi Guys,
You are both right. In the early 90's I worked for Telstra directly as a
developer (on an Informix application). I later went back there working for HP
and then IBM as a Unix performance specialist. I also applied for an Oracle DBA
job there once, but was not successful :-(. I did not
I've written Perl scripts that telnet to another host and run a command
remotely using the Expect module. I haven't programmed in oracle forms but
that part should be doable (most gui's let you execute external programs).
I can send you a sample perl script if you like.
Gerardo
-Original
Helmut Daiminger wrote:
Hi there!
I am on a brandnew box with a brandnew Win2k Server installed on it. Then I
run the Oracle 8.1.6 installer and then try to create a database (i.e. use
my batch and SQL files).
When I log into SQLPLUS as internal/oracle, I get an
ORA-12560 TNS:
Hi!
How Do I create a second listener service on Windows NT/2000?
Any ideas anybody?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hi Helmut,
From memory, 3 stages as below:
1) setup the new listener correctly in your listener.ora file
suppose your first one is called listener and listens on port 1521
you might call the 2nd one l1526 and have it listen on port 1526
2) Use lsnrctl to start the second listener, that is:
Hi,
You have to set the oracle_sid in the path and the sid_name in the value in
the environment tab of my computer. Once you set this you won't get the
error. Alternatively you can set the same in the registry as well.
Hope this helps,
Muthaiah
At 03:30 PM 4/23/01 -0800, you wrote:
Hi
Title: RE: Kdb database engine
How about that! :-)
Yea, I would have sworn that I remembered a ...telstra.au or
somesuch on your mail addy at some point, long long ago, when
the galaxy was young.
-Original Message-
From: Steve Adams
To: Multiple recipients of list ORACLE-L
Sent:
Dick,
Thanks!
SAME also suggests using the outer half of each disk for data storage...as
I/O performance is increased due to the natural circular shape of the
platter. My question...how do you specify which sections of each disk are
utilized? From what I've been able to read, I'm guessing
Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA?
Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */
David A. Barbour
Oracle DBA
Sinardy Xing wrote:
Hi DBAs and SAs,
I had a task to do housekeep ...\bdump\alertSID.log
What logs usually Oracle system
DBMS_system.set_sql_trace_in_session(sid,serial#,true/False);
u have to get the sid and serial# for which u want to set the trace.
HTH
--
On Mon, 23 Apr 2001 08:55:33
Mark Leith wrote:
Slightly off-topic:
Has anybody used the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure? If so
what's the
Thank You
-Original Message-
Barbour
Sent: Tuesday, 24 April 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA?
Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */
David A. Barbour
Oracle DBA
Only way you could do that is to write a standalone function/procedure that
would call the packaged function/procedure. Sorry there is no (documented)
way. You must prefix the package name to the function or procedure when you
execute.
Maybe this is due to name resolution algotithms ... what
88 matches
Mail list logo