I'll be there
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
While perusing the HOTSOS site, I noticed that the deadline
for the discounted registration for the HOTSOS conferences
ends after tomorrow. If you're thinking of going, you may
want to
Title: RE: HOTSOS Conference
I will be there as well primarily listening and also speaking. It is a great idea for a list dinner.
Joze
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 06, 2004 2:59 AM
To: Multiple recipients of list ORACLE-L
Tanel
I am curious - why are you forced to keep
segments in specifically named tablespaces.
I did come across one system that would
actually reject (application) upgrades if the
database didn't have exactly the right two
tablespaces (E_DATA and E_INDX or
some such) but I can't think of any
I'll be there.
Getting together on Tuesday sounds good.
I won't be around on Thursday, though as
I'm planning to stop off in Charlotte to do a
one day event for the user group there.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can
Hi list
Happy new year for u all.
Could you explain what is recreatable /freeable
chunks and
once recreatable chunks is removed from memory
where it is kept.
Thanks in advance
Syed
Jared,
I'll be there.
Raj
-Original Message-
Sent: Monday, January 05, 2004 8:59 PM
To: Multiple recipients of list ORACLE-L
While perusing the HOTSOS site, I noticed that the deadline
for the discounted registration for the HOTSOS conferences
ends after tomorrow. If you're thinking
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.
Could anyone tell me how to avoid that message?.
This is how my sql looks like
set linesize 200
set trimspool on
Daniel
How can i use the v$undostat.maxquerylen value to configuure the undo
tablespace?
Also, how can I tell what the longest transaction is actually doing?, i.e
what sql is being run?
John
-Original Message-
Sent: 05 January 2004 17:54
To: Multiple recipients of list ORACLE-L
set feedback off
Raj
-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.
Could anyone
SET FEEDBACK OFF
Regards,
Charu.
-Original Message-
Behalf Of
Mudhalvan, Moovarkku
Sent: 06 January 2004 14:19
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.
Dear Raj
Thank you so much. Yeah it is working fine
-Original Message-
Sent: Tuesday, January 06, 2004 6:05 PM
To: Multiple recipients of list ORACLE-L
set feedback off
Raj
-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list
Hi Mudhalvan ,
set feed off ;
did u try this ? not sure though : )
Regards,
Prem.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mudhalvan, Moovarkku
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am
-
From: Mudhalvan, Moovarkku
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 06 Jan 2004 00:49:25
Hi,
I am trying to spool the result from PL/SQL
procedure. At the
end of result I am getting PL/SQL successfully
completed.
Could
Hi,
Well, since I can't sleep, I may as well try solving a problem.
This is a bit odd, and I'm trying to think of the most efficient way to do
it. I've set up some bitmaps in my app. Consider we have documents that
we want to sell. In order to be able to sell a given doc, we need to have it
John,
Since I'm up, I'll give this a shot. The v$undostat.maxquerylen is,
not surprisingly, the maximum length of time it took to satisfy a query.
It's quite useful information when it's time to pick a value for
UNDO_RETENTION. Much larger than maxquerylen, and you'll (potentially)
suffer from
Sorry, first time I sent this, I typoed the mailing list address, when I
cut-and-paste to resend, I forgot the title.
-Original Message-
From: Bobak, Mark
Sent: Tue 1/6/2004 4:39 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:
Hi,
Well, since I can't
try this out
select a, b
from (select a from tab1 group by a having count(*)=1) alias
where a in alias;
regds,
Rohan
From: elain he [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: rewrite group by query
Date: Mon, 05 Jan 2004
Mark,
This is what spontaneously comes to my mind and may not make a lot of sense in your
case, but why do you need TWO bitmaps in the first place? Your second (Permission)
bitmap uses 2 bits to store three states (no permission/P1/P2). This is enough to hold
the STORAGE information as
Hi Stephane,
I of course simplified the problem a bit. However, the bitmaps are actually
artificial entities which I'm building up from some underlying tables and
some clever indexing schemes. The problem is, I don't have total data model
control, and the permissions and storage info are stored
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I'll be there. I have the distinction (dubious or otherwise) of being
the first to register :)
--- Jared Still [EMAIL PROTECTED] wrote:
While perusing the HOTSOS site, I noticed that the deadline
for the discounted registration for the HOTSOS conferences
ends after tomorrow. If you're
I guess he is currently busy in polishing SWYG a new interface to write
better code.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
Hi
I am curious - why are you forced to keep
segments in specifically named tablespaces.
This Concorde XAL application has an internal repository which stores information
about physical segment structures (as tablespace name, initial next extent etc).
And it can start reorganizing segments
I guess Dick really meant 'paper weight', a rather large, bulky and ugly one and the
only paper weight that needs to be reboot twice a day to hold your papers steady.
Raj
Rajendra dot Jamadagni at nospamespn dot com
I'm confused:
did you REALLY expect anything
out of microslop to work according
to expectation?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Dick,
What kind of a nautical person are you??? the NT box will not even
make a good anchor because the sides are flat and it will
Mark,
wouldn't it be better to keep the bitmaps separate than merge? You could have upper 8
bits for storage bitmap and lower 8 bits for permissions.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
The answer is in my book.
Assume your original setting for pctfree is correct,
by the time rows are full length, they are filling
the block. If any rows are still part-grown, there
will be the right amount of space left in the block
for them to grow. If all the rows are new, there
will be
How is the bit-stream presented ?
If it's a string, you could do something like:
select replace(replace('11010','1','11'),'0','00') from dual;
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
But will you be the first there .
-Original Message-
Rachel Carmichael
Sent: Tuesday, January 06, 2004 11:44 AM
To: Multiple recipients of list ORACLE-L
I'll be there. I have the distinction (dubious or otherwise) of being
the first to register :)
--- Jared Still [EMAIL PROTECTED]
Two questions for you:
1. The export file is binary format. Can you tell me
which editor you use?
2. How to manually parallel?
Thanks.
--- zhu chao [EMAIL PROTECTED] wrote:
Hi, Tanel:
If you have plenty of downtime, everything will
be ok.
If you want to further limit the
Mark,
All right, I see it better. If I were you I would try arithmetic methods. To take
your example, when you start with
10110011
it means
power(2,7) + power(2,5) + power(2,4) + power(2,1)
+ power(2,0)
What you want is nothing else than
3 * power(4,7) + 3 *
perhaps, as I booked my flights last night, and I arrive on Saturday
the 6th :)
of course, there are those who are attending who live in Dallas, so I
can't arrive before them!
--- Anjo Kolk [EMAIL PROTECTED] wrote:
But will you be the first there .
-Original Message-
Rachel
Hi,
I planned this answer a short one, but...
Could you explain what is recreatable /freeable
chunks and
once recreatable chunks is removed from memory
where it is kept.
Memory allocations from shared pool heap or its subheaps are done in chunks. When
allocating a chunk from shared pool
Now now all you MS bigots. Just leave us alone. There are several of us on
this list who are forced into using MS because of management decisions. And
our systems are running just fine.
Just leave us alone. You don't see us posting all of the other op systems
problems (all 2 of them).
thank
I'll be there, trying to set a record for the longest
time on a plane by any attendee
Cheers
Connor
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
perhaps, as I booked my flights last night, and I
arrive on Saturday
the 6th :)
of course, there are those who are attending who
live in
Nuno Souto scribbled on the wall in glitter crayon:
I'm confused:
did you REALLY expect anything
out of microslop to work according
to expectation?
you just have to remember to take the cover off when using it as an
anchor.;-)
--
Bill Shrek Thater ORACLE DBA
I'm going to work my
I'll assume that you're talking about shared pool chunks. The pieces that you're
talking
about are probably procedures/cursors that are closed and not used any longer. Those
pieces get deleted without backing them up anywhere. My understanding is that
oracle never swaps out pieces of active
As a first cut, bit 'i' appears to map to a new value
of power(2,i*2-1)*1.5
eg
8th bit set
= 1000 binary
= 128 decimal
= 1100 under new scheme
= 49152 decimal
= power(2,8*2-1)*1.5
so you could have something like:
new_num := 0;
x := 1;
for i in 0 .. 7 loop
if
Lucky you ;-)
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
I'll be there, trying to set a record for the longest
time on a plane by any attendee
Cheers
Connor
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
perhaps, as I booked my flights
I'm in too and my company popped for the Adams seminar. I went last
year and it was superb!
Allan
-Original Message-
Carel-Jan Engel
Sent: Tuesday, January 06, 2004 7:39 AM
To: Multiple recipients of list ORACLE-L
Lucky you ;-)
Regards, Carel-Jan
===
If you think education is
Hi,
I am getting little confussion how the memory is
allocated for
top-level heaps and subheaps in shared
pool.
How can we know what are all the top-level heaps
and subheaps and their hierarchy.
Is it possible to get it from any X$
tables.
Freeable chunks can be flushed out?If yes ,then
Title: Message
To
quote Steve's book, aka "The Bible":
freeabl:
Freeable chunks contain objects that are normally needed for the duration
of a session or call, and are freed thereafter. However, they can
sometimes be freed earlier, either in whole or in part. Freeable chunks
are not
Maybe a lookup table filled once with 256 input/output pairs ?
mvg/regards
Jo
Connor McDonald [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/06/2004 14:29
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Hi
Statspack exceptionally showing the following on a particular day :-
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs)
Wt Time
modify the sql file and change the format string ... ### indicates value overflow.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have
So YOU beat me to it.
I'll be there as well. Registered for Steve's seminar as well.
At 03:44 AM 1/6/2004, you wrote:
I'll be there. I have the distinction (dubious or otherwise) of being
the first to register :)
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
Do you at least arrive before you leave?
At 06:09 AM 1/6/2004, you wrote:
I'll be there, trying to set a record for the longest
time on a plane by any attendee
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official
Title: Message
However, give serious thought to reading Jonathon Lewis' book Practical
Oracle 8i prior to the Adams book unless you understand virtually everything in
Jonathon's book. Steve's book is excellent but verbosity is not one of his
problems.
Allan
-Original
Would you like me to bring a couple of
bottles of Blackadder to take home with
you.
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
Just go in the spreport.sql ($ORACLE_HOME/rdbms/admin) and change the time
format for that output. On my W2K install it's at line 579 and then again
line 635 for the full wait events list.
At 07:14 AM 1/6/2004, you wrote:
Hi
Statspack exceptionally showing the following on a particular day :-
set feedback off
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL
Well, since my usage of my boat is primarily for fishing, I really like Lake trout
Pickerel, an anchor that drags smoothly is a benefit. Besides that old Windoze OS
adds a lot of weight to the system. *-)
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent:
Hi,
I have posted a problem before
which I can only solve with a workaround but because I'm not getting
satisdactory answers from Oracle I'm trying
alternatives.
-
problem is a batch pl/sql package which ends
with ora-4030
-
batch runs fine on oracle 7.3.4, we migrated to oracle
True, but some of use linux to manage those databaeses on MS.
On Tue, 2004-01-06 at 04:44, Mercadante, Thomas F wrote:
Now now all you MS bigots. Just leave us alone. There are several of us on
this list who are forced into using MS because of management decisions. And
our systems are
Citrix Metaframe, rdesktop, and TightVNC help a bunch, too. :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Tuesday, January 06, 2004 8:59 AM
To: Multiple recipients of
An additional consideration: If you convert the tablespaces in place with
dbms_space_admin, check the default storage for initial and next extent.
When you do the conversion with dbms_space_admin, a space header is created
and the extent allocation for the space header will be whatever the
Hi!
I wrote about recreatable chunk handling from memory and mixed up chunk
freeing routines and chunk's data recreation routines:
A callback routine is used when a process wants to free a recreatable
chunk - it can't reuse it just like that, because the original allocator
(parent object) still
Title: 11.5.8 AIX database tier clone issue
Okay... this is really cool... although the coolness is almost funny (ALMOST... I have been trying to autoconfig clone for 2 months... )
Have looked on metalink and have an ITAR in progress... but wanted to know if anyone had ever seen this
Alternate solution:
Don't run it for an hour. One would expect the accumulated wait times to be
smaller then and not leading to the value overflow.
At 07:14 AM 1/6/2004, you wrote:
Statspack taken from a Production Database for a 1 hour period on Oracle
8.1.7.4 version
Wolfgang Breitling
Title: Message
I
won't argue that, Allan. The guy writes two sentences, and it takes a week
for the full implications of what he said to sink in.
Jonathan's book is excellent as well. They are both at the top of
my reference list, as well as my recommended list.
Mark J.
Bobak Oracle DBA
Tanel:
You are right. But the actual freeing process (from the re-creatable
chunks) is quite different from what you have explained. The
recreatable chunks (they are freeable, but can be re-creatable if
required as you have explained) will be falling in two catagories.
They are either pinned or
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given that you don't have the
problem when you disable p_a_t and w_p,
it may be that there is some buggy event
occurring where the workarea_policy code
is being infringed by an abuse of pga memory.
Hi,Thank you all for your prompt suggestions. I was leaning towards EXP/IMP due to its small size. I will test out some of your suggestions in our test environment nevertheless.
- Paula W.
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
I'll be there... A get together would be great...
Tim
-Original Message-
Sent: Monday, January 05, 2004 8:59 PM
To: Multiple recipients of list ORACLE-L
While perusing the HOTSOS site, I noticed that the deadline for the
discounted registration for the HOTSOS conferences ends after
Well, a heap is just a bunch of memory (allocated
incontiguous extents) and you can practically allocate any size of chunk
of memory from it (with some restrictions). A regular heap has freelist and LRU
list mechanismsfor managing space init as well as memory
allocation/releasing routines
Title: ORA-01578 data block corrupted
I got ORA-01578 error while querrying info for below table. How do I fix this error?
SQLSelect count(*) from GATEWAYCALLSTATS;
*
ERROR at line 2:
ORA-01578: ORACLE data block corrupted (file # 3, block # 2683299)
ORA-01110: data file 3:
Has anyone encountered the ORA-600[kcbnew_3] error after resizing and LMT in
Oracle9i?
A vendor install script created tablespaces really large, and I started to
resize them smaller, but checked Metalink. There is a bug 2747978 that says
in versions below 9.2.0.4 you can encounter an ORA-600
Yes, I find it highly amusing that the Linux client
for Windows Terminal Services (rdesktop) is in some
ways easier to use than the Windows client.
Have not had need for TightVNC. How do you use it?
On Tue, 2004-01-06 at 07:09, Jesse, Rich wrote:
Citrix Metaframe, rdesktop, and TightVNC help a
When I increase the pga_aggregate_target to 2Gb and the
smm_max_size also the program fails around the following numbers from
pgastat
I'm not advocating fiddling with hidden parameters here, but there is one
more parameter which limits PGA usage, it's _pga_max_size and defaults to
200M.
Title: 11.5.8 AIX database tier clone issue
I
suppose if it's going to panic, it's only fair that you should too.
:)
I ran
into something similar in Oracle Financials last year. Wewere never
able to get a satisfactory answer from Oracle as to what was happening or why,
but theydid send
Title: Message
1.)
Restore datafile from backup.
2.)
recover datafile;
3.)voila!
Of
course, you mileage may vary. Do you have a valid backup? Is it hot
or cold? RMAN/conventional? etc,etc
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to
Title: Message
Hi
all,
Why
would anybody care about all these heap stuff? How does it help
performance
Thanks.
Abraham Guerra
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004
10:04 AMTo: Multiple recipients of list
Title: ORA-01578 data block corrupted
Run dbv on the datafile.
Also there is a document on Metalink which describes how to handle data
block corruption.
Use the folliwng query to get segment name
SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAMEFROM
DBA_EXTENTSWHERE FILE_ID =
You are right. But the actual freeing process (from the re-creatable
chunks) is quite different from what you have explained. The
Yup, I didn't want to get too much in details about different LRU lists,
otherwise the post would have got too long.
recreatable chunks (they are freeable, but
Title: 11.5.8 AIX database tier clone issue
Did you try to relink all executables using adadmin
first?
Tanel.
- Original Message -
From:
April Wells
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 06, 2004 4:59
PM
Subject: 11.5.8 AIX database
If you have access to Metalink:
Check Note:28814.1
Haven't had to use it, hopefully never will.
HTH,
Mike
Nguyen, David M
if you got rman backup and 9i, you can do block level recovery.
joe
Bobak, Mark wrote:
1.) Restore datafile from backup.
2.) recover datafile;
3.) voila!
Of course, you mileage may vary. Do you have a valid backup? Is it
hot or cold? RMAN/conventional? etc,etc
Mark J. Bobak
Title: 11.5.8 AIX database tier clone issue
Also, is your context.xml file ok, did you edit it
using context editor or manually?
Tanel.
- Original Message -
From:
April Wells
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 06, 2004 4:59
PM
I'm also attending, hoping to have room left in my
brain for Steve Adams' seminar.
Only Tuesday for drinks? :)
Paul
-Original Message-
Sent: Monday, January 05, 2004 8:59 PM
To: Multiple recipients of list ORACLE-L
While perusing the HOTSOS site, I noticed that the
deadline
Jared,
I'm not into TightVNC just yet, but I do use VNC. It's damned nice over a
dial up line as there is less chatter between the server the client. I also prefer
it over PCAnyWhere as it runs in less memory. Much easier to set up as well. OH,
BTW; did anyone mention that it's
I've done a LOT of resizing of LMT tablespaces (9.2.0.1) and have never
gotten that error..
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Has anyone encountered the ORA-600[kcbnew_3] error after resizing and
LMT in
Oracle9i?
A vendor install script created tablespaces really large, and I
http://www.tightvnc.org It's VNC, but with compression levels that can be
set by the server and/or client. I use it to access my Windoze box here at
work from my Gentoo desktop and while VPN'd into work from home. Even
though it's not a server, my Windoze box has some tools on it that I'm
Thanks to Anjo, Cary, Tanel, and everybody who
provided feedback back channel.
Just to rule out the possibility of a collection error
(somebody suggested that cursor #0 is simply not
captured) I bounced the DB today, enabled a DB-wide
trace ... and as expected
grep -i cursor #0 *
returned
[EMAIL PROTECTED] writes
I won't argue that, Allan. The guy writes two sentences, and it
takes a week for the full implications of what he said to sink in.
Jonathan's book is excellent as well. They are both at the top of
my reference list, as well as my recommended list.
Hi Vivek,
I am not a statspack expert but your problem is simply an SQL issue. The
### means that the field format is not big enough for the value being
returned in the SQL. Simply open the SQL file and find the SQL that
prints this and look for the column format somewhere above that. Change
the
Thought I'd throw this out again now that more of the list is back from
holiday...
-Original Message-
Sent: Friday, January 02, 2004 12:29 PM
To: Multiple recipients of list ORACLE-L
Anyone messed with Rocks (http://www.rocksclusters.org) in an Oracle
capacity?
Rich
Rich Jesse
you may not be seeing parse etc entries for cursor #0 merely because maybe by design,
cursor#0 gets invoked before trace gets activated. This way, you will never get cursor
#0 info.
You can tell, I am guessing but to get similar experience, start trace in an already
active session and you'll
Title: 11.5.8 AIX database tier clone issue
Don't HAVE adadmin on my database tier
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/
\
\
\ \
Few people really enjoy the simple
pleasure of flying a kite Adam
Wells age 11
-Original
Title: 11.5.8 AIX database tier clone issue
context editor
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/
\
\
\ \
Few people really enjoy the simple
pleasure of flying a kite Adam
Wells age 11
-Original Message-From: Tanel
2) since waits #0 appear only before the calls to a
stored code - I don't know if they deliberatly switch
sessions in the code that runs on the app server and
run the stored code as the schema owner (similar to
switching current schema as an alternative to using
synonyms) or it is a feature
Rich,
Citrix Metaframe, rdesktop, and TightVNC help a
bunch, too. :)
opinion
This is the biggest reason why people badmouth Windows
for use with Oracle. You install Citrix MetaFrame on
the same server as you run Oracle Database Server? Get
real.
You probably have IIS, RRAS, IPSec, numerous
Ugh ... you mentioned disable all that crap ... but that included windows .. no? That
would solve a lot of problems ... right?
sorry, I am in an exceptionally good mood today just because computer room woke me up
at 3:30am to fix something!! Aah... the joys of being on-call.
Raj
We had some issues with using a TightVNC client
against vnc server v3.3.7, whereby the server process
would crash and not restart, requiring a server
reboot. So TightVNC got tossed as a client in our
environment.
Its nice to have Terminal Services enabled so that one
can attempt to restart a
* to satisfy curiosity
* to have a better understanding of how Oracle works
Most DBA's probably don't need to know this stuff. Most
performance problems will not likely require you to know
any of this.
If you spend a lot of time solving other people's 'unsolvable'
Oracle performance problems,
Thanks, Tanel.
I did checked v$session_connect info, but it doesn't
tell me much, except authentication_type='PROXY' which
is less than useful as it doesn't tell to whom.
v$session.client_identifier is empty.
Thanks,
Boris Dali.
Check V$SESSION_CONNECT_INFO view.
CLIENT_IDENTIFIER in
Actually, no. If we had any Oracle servers on Windohs, I would only feel
comfortable with TightVNC server on it, and even then I would insist on no
more than 800x600 and 256 colors (hopefully the Installer works with that!),
due to the transmission overhead involved.
And if you can set up an
Is there any way to check on the progress of an index rebuild? (Oracle 8i). I.e., it
would be nice to get some indicator as to how far an index rebuild has gone, something
like 75% done
As a rough indicator, I've noticed when rebuilding/moving an index to a different
tablespace, Oracle
Have you checked v$session_longops ... ??? regular index builds show up there, so I
guess rebuilds will show up as well ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Title: 11.5.8 AIX database tier clone issue
Do you have correct JDK installed
(J2SE1.3.1+)?
IIRC, autoconfig uses java as well...
Tanel.
- Original Message -
From:
April Wells
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 06, 2004 7:19
PM
Hi,
Here is an easy one hopefully, but I've been unable to figure it out
via Google or Metalink. When selecting data from an AL32UTF8 database,
sqlplus has problems formatting output on the screen. When I select both
English (1-byte, A-Z) date and Unicode (2,3, or 4-byte) data, the
1 - 100 of 185 matches
Mail list logo