 | | | Oracle List | | This ought to be doable. (Refer to Wolfgang 's advice.)
I have a funny feeling that this might also induce RMAN to retain all
archivelogs for three years. (I 'm assuming your backups are online.)
ChTanel Koen
I do not think that Oracle would ever request a space from a datafile that is
offline.
Yes - you need to start up the database as follows
* STARTUP MOUNT
* ALTER DATABASE ARCHIVELOG
* ALTER DATABASE OPEN
Simply providing the log_archive% parameters in the initialization file
is noI 'll take a pass at summarizing
1) As Tanel mentioned if there is no OS HW/SW fault and the quite unlikely
event that DBWR dying itself in the middle of a write request is not what
kills the instJust to develop that at bit further allowing your switches / NICs to
autodetect /
auto-negotiate can do a lot worse than that... I 've personally seen
situations where
a 100Mbit NIC was "maxing outJuan
Just a guess here but I bet it has more to do with "FOR ALL COLUMNS SIZE
SKEWONLY "
than the percentage change from 1% to 50% 100%.
Try with "FOR ALL COLUMNS SIZE 1 " or "FOR ALL COLUMNS SIZEOn 22/12/05 Radoulov Dimitre <cichomitiko@(protected) > wrote
>
> > "the query must be (hard) parsed and it must be parsed by the CBO ". Maybe
> the original poster is missing these requirements.
>
> IExporting a Windoze database from Linux will work without any problem.
What might give you problems
Different Oracle versions
Incorrect NLS_LANG settings.
Export will complain about both.
ExpoFriends
How do i find the find file_id or block_id from data block address in v7.3.4 ?
i.e. I have the data block address. I want to know the the find
file_id or block_id .
Can someone help me on This probably isn 't exactly what you want but might be a good starting point
select a.snap_time round((100*(b.value/(c.value+d.value))) 2) rb_per_tx from stats$snapshot a stats$sysstat b stats$BEGIN/END does not avoid split blocks.
It merely caused the generation of more redo to recover from split blocks.
Anyone seen this happen? We did not when we patched our test system
but I wonder if it is waiting until I patch prod to raise its head
http //www.sunmanagers.org/pipermail/sunmanagers/2005-Decembyou can have a look at v$open_cursor
On 12/22/05 Onkar N Tiwary <onkarnath.tiwary@(protected) > wrote
>
> hi guys
>
> how to find total no of cursors opened in the memory at any point of
> time????Hi Sriram -
It 's not clear to me from your message who told (or pushed) you into
HMP. Was it Oracle folks? If yes who?
Mogens
Sriram Kumar wrote
> Hi Gurus
>
> We are presently using a HPAllen
If I understand Oracle failsafe correctly it does not shutdown the
database when you manually failover the cluster group to another node
(unless I have missed a config setting) it simply stoThe author mentioned that he did try it after database bounce.
Perhaps I am missing something about delayed block cleanout but that
would be valid explanation only when instance hasn 't been bounced.On Tue 2005-12-20 at 21 16 +0000 David Sharples wrote
> umm whats wrong with the installation guide?
>
> or
>
> puschitz.com. But if you have no RAC knowledge your company and you
> are in forlinux has done that since at least redhat 2.1 - very useful
On 12/20/05 Paul Drake <bdbafh@(protected) > wrote
>
> RHEL 4 AS U 2 x86
> Oracle 10g R1 (10.1.0.4)
>
>
>
> Is this common knowledge or was RHEL 4 AS U 2 x86
Oracle 10g R1 (10.1.0.4)
While testing some scripts in a lazy fashion with username / password
supplied on the command line (for expdp exp sqlplus) I noticed that
the username andThis looks like a pretty decent review. It was pretty difficult to read
around all the advertising though. (I don 't recall Tom 's Hardware
being that heavy on ads but I haven 't visited there in qu
Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers whWe currently have a EVA8000 and are planning on getting a second one for
redundancy so when doing firmware upgrades we can stay up.
We are considering using ASM mirroring on the arrays but are toldhi all
I want to find out what are the stored procedures exists in the database
which are used frequently. Any Suggestion.
DB Oracle 9i rel 2(9.2.0.6.0)
OS Solaris 5.9
--
Thanks & Regards
T. OAnswered some of my own questions...more RIF. o)
> >but *why* is asynch-IO not the default
This note explains it all...I think I have been confusing and expecting what
I got from UNIX world in the LENV
Oracle 9205 -on- RHEL3 -on- EXT3
All
I have been reading previous post my own notes and some info on the
internet.
I 'm primarily interested in Oracle and using "filesystemio_options asynch "
err still broken
Error ERR-1016 Application "125 " Page "50 " not found (requested
language "en-us ")
but yeah it 's faster at least for login
On 12/19/05 Jared Still <jkstill@(protected) > wrote
>
use text mode installer
On 12/19/05 ryan_gaffuri@(protected) <ryan_gaffuri@(protected) > wrote
>
> This is sort of Oracle related. I want to play with oracle on redhat. I
> have a DELL Pentium M la--
Chris Marquez
Oracle DBA
<br clear "all " > <br >-- <br >Chris Marquez <br >Oracle DBA
Is it possible to receive an ORA-04031on a large_pool that is too small? I
did not think so until I stumbled across the following note (62140.1) on
Metalink
MTS and the Large Pool
~~~~~~~~~~~~~~~Hi Rich
It seems SYS.SUMDELTA$ is explicitly excluded from automatic
statistics collection.
If you turn on SQL tracing for the GATHER_STATS_JOB session you 'll
find a statement which writes |
|
|
