 | | | Oracle List | | Hi are you sure you are actually killing the session because you can 't
kill your own session with alter system kill session. But anyway any
unhandled exception in logon trigger will prevent usersAll
I 'm fairly new in the DBA realm. Can anyone tell me what a good standard to
follow would be for the length of time to keep *.trc files. I 'm moving
these to a separate file system to fre
On 02/13/2004 08 17 14 AM Carmen Rusu wrote
> Oracle install guide recommends the minimum value
>
> set shmsys shminfo_shmmaxB94967295
>
> How does this number depend on the the available phyOracle install guide recommends the minimum value
set shmsys shminfo_shmmaxB94967295
How does this number depend on the the available physical RAM on the
box?
Does this number depend on the
Think about what happens if the
session you are about to kill decides
to end itself and a new session starts
with the same sid (which means the
next value for serial#).
Regards
JonathanI have an application where data is never deleted I have just rebuilt an
index which was previously 4gb in size and its now 3gb in size. Can anybody
explain?
--
http //www.freelists.org/webHere is one example
SELECT p.username S.SID S.SERIAL# S.STATUS
s.username ora DECODE(l2.type 'TX ' 'TRANSACTION ROW-LEVEL '
'RT ' 'REDO-LOG ' 'TS ' 'TEMPORARY SEGMENT ' 'TD ' 'TABLE LOCK ' 'TM '
Session 1 grabs an ITL slot
Session 2 grabs an ITL slot
Session three see all slots full so picks and ITL
slot 'at random ' and (in version 9) sits on the
transaction table entry (in the Undo
> Traditional hashing uses an array for the hash
> then a linked list for the collisions.
I believe this is exactly what Oracle does when
building the hash table (build table) for a hash
joCarmen I give the thumb up for the JServer. Oracle 7.3.4 has nothing
to do with Java but Java is an ubiquitous programming language and
can do useful things which are much harder to do in PL/SQLWe use MRTG to do some monitoring of our 8.1.7 databases that are
running on Solaris 9 Sparcs mostly as a visual tool to look back and
see when certain things started to happen.
Our MRTG config Hi all
here 's the background to my problem I have 4 large tables (40 mill records) - each with an id (same id for all of them) and lots (100-300) of low-cardinality columns ( 'classification '-columnGuys
I want to be able to have two different directories for source code - forms/reports connections to different databases. I figure that I don 't need an additional infrastructure database - doOn 02/12/2004 03 54 41 PM "Smith Ron L. " wrote
> Is anybody running Oracle on Intel type hardware running Linux?
Is this a joke?
> On 02/12/2004 02 40 20 PM Michael Fontana wrote
>
> What methods do most on this list use to back up stored database
> procedures?
>
> I am familiar with exporting the SYS user only and importA person would think (silly me) that a sites like that would (I would
say should) have some level of redundancy build (either as standby or
replicated database or copy of the database) as a part of On 02/12/2004 01 16 22 PM Jacques Kilchoer wrote
> I 'm sure that with proper management etc. a Windows database server
> can > be reliable. But one thing that puzzles me - when you install a > MicIn addition when your company has offices in time zones all over the
globe
the idea of 'after hours ' gets a bit muddy.
Mladen Gogala <mladen@(protected) >
Sent by oracle-l-bounce@(protected)Be sure to run antivirus edition of oracle or your database may be
doomed...
On 02/13/2004 01 48 42 PM "Koivu Lisa " wrote
> Hi Don
>
> I can 't say that I have the experience you are lookinI 'm sure that with proper management etc. a Windows database server can be reliable. But one thing that puzzles me - when you install a Microsoft security patch the dialog box at the end (almost) alwNo "- Familiarity with ORACLE patches. "????
Nikhil Khimani wrote
> Dear List
>
> With Jared 's blessing I am posting following ... please send all
> correspondence with same subject line dOn 02/12/2004 11 11 08 AM "Jesse Rich " wrote
> Just downloading patches from Oracle (oracle-updates-east.conxion.
> com)
> and
> am getting 2MB/s down. Kudos! Less than a minute to download
On Mandrake 9.2 I had to set LD_ASSUME_KERNEL to "2.4.1 " because of
the NPTL (threads & glibc). In other words yes I did have to use some
acrobatics. On the other hand to install cooker I hav
Jonathan
The statistics from yesterday were for a 4-hour period.
Some more statistics today
For the 5minute period
Snap Id Snap Time Sessions
-What happens with the host sys/system schema when you do this full
import?
I know that the sys schema is not imported but the system schema is.
Doesnt that modify the system schema in the new
The counts tell you how many objects are covered
by each latch and it 's a fairly even distribution it
doesn 't tell you anything about how often the objects
are being accessed.
Given your pre
This end-user correction stuff is easy.
You just have to tell the end-users that whenever
they 're planning to make a mistake they should
first check the current SCN before they make it.
RegThis is the no-spin zone fair and balanced view of the Windoze
platform.
On 02/12/2004 08 46 21 AM "Jamadagni Rajendra " wrote
> Remind me again .. is this oracle-l forum or slashdot ??
>
On 02/11/2004 10 21 15 PM Jay wrote
> so I can not write into file system directory which is created using
> "create
> Directory " command. Right?
Probably not because nothing gets created i |
|
|
