 | | | Oracle List | | Just a guess - maybe the dba_segments view filters out dropped objects
(i.e. those in the recycle bin) while dba_extents does not?
Privileged/Confidential Information may be contained in this messagHi David
I actually did read most of your last post and I was going to reply.
But I got pulled into a meeting and sidetracked etc....
Anyhow to address your much simplified question No if Hi
We have a function that checks if the table exists in current schema if
specified without the schema name or all_tables if we specify the table
name as object_name.table_name and it looks like qu
My reply then was
Paula
We back up our Production databases with a hybrid approach. All of these
methods have proven valuable for recovering all or parts of data or
objects at various times. Our Production applicI was reading the link.
It is advising the use of cache hit ratios to measure the effectiveness of
the shared pool. An example calculates the hit ratio to be 99.9%. Also the
following
"Lastly a brOff the top of my head perhaps there 's an 'invisible ' control character
in there?
Try this
Select source dump(source) from sys.source$ where rowid
'AAAABHAABAAAHqVABL '
Do you see anything odd oI 'm pretty sure you want to fix those things BEFORE using CSALTER.
Let 's suppose that there is a lossy character in a column name. That allows
the logical possibility of identical column names after } I want to run a command on sqlplus without making re-connection. At the
} same time I also want to see the output.
With ksh93 (and pdksh on Linux for example) you can use co-processes
$ echo $KThe book "Forecasting Oracle Performance " was discussed here recently. I
just found that bookpool has it for $21.95 cheaper than Amazon.
http //www.bookpool.com/.x/SSSSSS_C606S609765D0705091058/sm/1On 5/9/07 John Dunn <JDunn@(protected) > wrote
> When I start the oracle 10 listener it shows an XDB service running.
> I don 't want it running and I am sure in previous versions I just removed
> theRemigiusz
A cruder method which might reduce the incident of these errors would be to
increase the SGA assuming you can allocate more memory.
Dennis Williams
<div >Remigiusz <br > <br >A cruder methoAlso try to find out what version of the client software you are running.
Older versions may not set this value on the client so you have to do this
by hand.
Anjo.
On 5/9/07 Edgar Chupit <chupit@On 5/9/07 Shivaswamy Raghunath <shivaswamykr@(protected) > wrote
>
>
> Hello.
> We are on RAC on 64 bit RedHat Linux 2.6.9-34 on 10.2.0.2.0 DB with ASM.
>
> I keep getting following message on Alert lHave you enabled "alternate client " restores as documented at h
<http //support.veritas.com/docs/196781 >
ttp //support.veritas.com/docs/196781 and in Metalink 209117.1 under the
heading "Redirecting aMy mentors
we are in the midst of migrating from 9i to 10g. we are a small shop and
unfortunatly are bound to the old hardware for the applications hitting the
new database. My question is for oWe are doing this with our situation. We have a BO user created that
connects with read only access to the databases. We grant specific
table access to this user (not all tables only those needed David
If ITL Waits are not a significant contributor to response time nor causing deadlocks can you think of a circumstance that justifies reducing ITL waits on an object? Must be my analness but INo each instance has it 's own thread#. From my 2-node rac db
SQL > select INST_ID THREAD# from gv$log
INST_ID THREAD#
---------- ----------
1 1
1 The objective is to move a DB to a set of new disks on the same host
with minimal downtime using RMAN then switch the application to using
the newly moved DB. My idea is to do is using COMPLETE dupAndrew
I 'm not aware of an issue with the data dictionary. Are you thinking of
tablespace fragmentation? Here is my thought
- Ensure these tables are in their own tablespace which is
locally-manSchauss Peter wrote
> I have an rman script which have been using on 8.1.7.4 for several
> years but when I run it on 10.2.0.2.0 I get the following error message
> for each channel
>
> RMAN-03009John
Check the alert log.
Dennis Williams
On 5/8/07 Bobak Mark <Mark.Bobak@(protected) > wrote
>
> This is generally a symptom of another problem. Is "TNS lost contact "
> the only error Greetings
SUN SOLARIS 5.8
When I execute Shell Commands with in SQL Plus with a (!) every time its
reading .profile and displays Banner etc. its very annoying
How can I get rid of this
--
John
Is there any possibility you use FTP in ASCII mode? In reviewing your
posting it seems you are getting a consitent result but you didn 't mention
whether you are trying different download methodIf you are creating a database on windows using dbca you have option to
deslect these features so these will not be a part of database.
Regards
Rafiq
From "Vincent verpoort " <vincent.verpoortHi
I am at a site which is a high intensive OLTP site doing more than 400 txns/sec on a 8 node cluster on 10.1.0.5 RAC. We are thinking of switching off bind variable peeking and looking into aHi All
I 've posted this on the OTN forums but haven 't had much help so apologies to
anyone who 's already seen this.
We 've come across a bug in our 10.1 instances when selecting from a view which
uHello
I 've been asked to create a dataguard environment with
the primary and standby (logical) residing on the same box.
I haven 't found a good document that explains the procedure.
I kno
2-node Rac on windows oracle version 10.2.02 crs version 10.2.03
I tried to start OracleCRService on one node and it faied (the other
node is OK).
C \oracle\product\10.2.0\crs\BIN >crsctl check |
|
|
