Hi DBAs,
I followed the note in "Handling Block Corruptions in Oracle7 / 8 / 8i /
9i"
The following is one record in the orphan_key_table table. It is suppose
to help in determining
what records may need to be re-populated. It does not help me. Does any
one know how to use the below info to help determine what
records I need to reload. I used the DBMS_REPAIR pkg to get the following
info.
TEST
PK_TAB1
NULL
4821
TAB1
NULL
4820
AAABLUAHZAAL8EAAEA
*BAAAAAACwQcEMzAzMALBAwLBBgLBAwLBAgPCFFwCwQwCwRf+
17-AUG-04
SQL> DESC ORPHAN_KEY_TABLE
Name Null? Type
---------------------------- -------- -----------------
SCHEMA_NAME NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
IPART_NAME VARCHAR2(30)
INDEX_ID NOT NULL NUMBER
TABLE_NAME NOT NULL VARCHAR2(30)
PART_NAME VARCHAR2(30)
TABLE_ID NOT NULL NUMBER
KEYROWID NOT NULL ROWID
KEY NOT NULL ROWID
DUMP_TIMESTAMP NOT NULL DATE
Rick Cale
Database Administrator
Team Health, Inc.
[Email address protected]
|---------+--------------------------------------------------------->
| | ""Ganhão, Luís Manuel Martins, VF-PT" " |
| | <oracledba-ezmlmshield-x33362599.[Email Address Removed] | azyDBA.com> |
| | |
| | 08/18/2004 07:37 AM |
| | |
|---------+--------------------------------------------------------->
>---------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: RE: SGA size - Urgent |
>---------------------------------------------------------------------------------------|
Ok... my SQL Prompt, looks like an email :-)
ARBORDBA#SIEB.al37hp48>
(# = @)
Regards,
LG
-----Original Message-----
From: "Ganhão, Luís Manuel Martins, VF-PT" [mailto:oracledba-
ezmlmshield-x24889273.[Email address protected]
Sent: quarta-feira, 18 de Agosto de 2004 12:25
To: LazyDBA Discussion
Subject: RE: SGA size - Urgent
I think this answer your question...
[Email address protected] show sga
Total System Global Area 5941316072 bytes
Fixed Size 104936 bytes
Variable Size 3252654080 bytes
Database Buffers 2684354560 bytes
Redo Buffers 4202496 bytes
As you can see in SQL Prompt... it's an hp
Regards,
Luís Ganhão
Novabase Portugal
-----Original Message-----
From: Ofer Harel [mailto:oracledba-ezmlmshield-
x31000760.[Email address protected]
Sent: quarta-feira, 18 de Agosto de 2004 13:25
To: LazyDBA Discussion
Subject: SGA size - Urgent
Good morning,
I always thought that SGA size is limit to 2G in all
kind of
servers.
Also I thought that 3G or 4G options for SGA size are
general
options
After reading notes 46001.1 and 116076.1 which refers
to
Windows
only, I 'm
getting confused
Question:
1. Is there a limit to SGA size on Sun Solaris or HP
machine
2. Does the 3G and 4G option for SGA size are available
outside of
Windows
machines
TIA
regards
Ofer Harel
DBA team
013Barak
[Email address protected]
******************************************************************
****
The information contained in this e-mail message may be
privileged and confidential. The information is
intended
only
for the use of the individual or entity named above. If
the
reader of this message is not the intended recipient,
you are
hereby notified that any dissemination, distribution or
copying
of this communication is strictly prohibited. If you
have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the
message
from your computer. Thank you!
Unless otherwise stated, any views or opinions
expressed
in
this e-mail are solely those of the author and do not
represent
those of
Barak I.T.C (1995) The International Telecommunications
Services
Corp. Ltd.
******************************************************************
****
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
------------------------------------------
This message may contain confidential information or privileged
material,
and is intended only for the individual(s) named. If you are not
in the
named addressee you should not disseminate, distribute or copy
this e-mail.
Please notify the sender immediately by e-mail if you have
received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-
free as
information could be intercepted, corrupted, lost, destroyed,
arrive late
or incomplete, or contain viruses. The sender therefore does not
accept
liability for any errors or omissions in the contents of this
message
which arise as a result of e-mail transmission. If verification
is
required please request a hard-copy version.
Vodafone (Portugal)
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
------------------------------------------
This message may contain confidential information or privileged material,
and is intended only for the individual(s) named. If you are not in the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message
which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
Vodafone (Portugal)
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page