 | | | Oracle List | | Sounds like the same problem I see almost every week with bind variable
peeking in my Baan & Oracle 9i+ systems - maybe someone ran the
query(ies) with a bind variable value that indicated a large amoDo you use a bind variable for the ssn column in the query?
If so it could be that because of bind variable peeking you are now using a different access plan.
regards
Freek D 'Hooge
Uptime
OracleAll
Running on 9.2.0.7 on Aix.
I have a database table with 18 million rows in it. There is an SSN
column in the table. Only 625 000 rows have an SSN populated. I also
have an index on thiAbdul
If you don 't have the original DDL stored anywhere for the diskgroup (we dump all our DDL to separate scripts each night) then I suggest checking the underlying physical disks / raw slices fo
_____
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)]
On Behalf Of Senthil Subramanian
Sent Monday October 01 2007 9 56 PM
To Carel-Jan Engel
Cc oracle-l@(protected)
10-15% compression mentioned in documentation is only for metadata and then doc goes on to say that compress has been added at data level as well in 11g. So definitely compress ratio will lot higherThe following recent thread on cdos might be of help
http //groups.google.fr/group/comp.databases.oracle.server/browse_frm/thread/dfe6832548fed5a1/ecf4d0744cd86331
On 10/1/07 Sam Bootsma <sbootsma@On 10/1/07 Prasad <p4cldba@(protected) > wrote
> Hi Jerome.
>
> There is no error on the output .
Ah.
> it just say that file not found .
That 's an error isn 't it?
>somehow
> it is not able to catOn 10/2/07 Senthil Subramanian <skumar.sen@(protected) > wrote
>
> Hi Carel-Jan
>
> Thanks for your valuable input on this.
> I did try switching roles on a small 9i test database back in 2002 but
> Create schema1 grant select on dba_source to schema1 (need to do
this as sys)
create a view v_source as select * from dba_source where owner in
( 'A ' 'B ' ... etc.)
create schema2 with create sessioHi Carel-Jan
Thanks for your valuable input on this.
I did try switching roles on a small 9i test database back in 2002 but
never really implemented in a real production environment.
We have a sounJust have them check the code out of your Source Code Control system.
On 10/1/07 Sam Bootsma <sbootsma@(protected) > wrote
>
> We would like our developers to see source code for all objects in
1) Make sure that the network interconnect is negotiating at
1gigabit full duplex. Don 't accept the answer that 'the hardware
supports it ' but VERIFY that it is negotiating at that speed.
2) Sam
Is there a way to enable developers to view all source code for selected
schemas without providing additional privileges? I 'd like to avoid
giving dba_source privileges.
Try granting thWe would like our developers to see source code for all objects in
selected schemas in our production database. I believe I have read that
granting execute privilege on a stored procedure will also mWe have a diskgroup that won 't mount due to a missing disk. Is there anyway to get a mapping of disks to diskgroups for unmounted diskgroups to find out which disk is missing? The v$asm_disk view on
As a FYI you can use the network_link option using an import and this
will import data into database A thru a link connecting to database B.
No need to have the data go to disk first. I have done tHi Jerome.
There is no error on the output . it just say that file not found . somehow
it is not able to catch the backup piece that was done on standby server .
any ideas.
On 10/1/07 Vitalis JerHello
It should work if the directory name is the same and the backup pieces
are all there.
Please post RMAN output with the error.
On 10/1/07 Prasad <p4cldba@(protected) > wrote
> the backup pieceQihua
Others are more knowledgeable than myself on this but I will give this
a shot. As I understand it whenever Oracle is waiting on IO the
instrumentation is such that this time is reported toHi Senthil
Role transition is working very well generally. I 've done and seen this
dozens of times at various sites varying from Windows Solaris Linux
to AIX using all Oracle versions between 8Hi
I can see both databases spend the majortiy of the time on 'db file
sequential read ' from the AWR. Another possiblity is that there are more
disk contention on production than on the test databaHi All
I would like to know if anyone has tried the role transition between primary
and the physical standby in a real production environment.
We have a situation to switch the roles for couple of d
What versions of database CRS what is the network configuration like how are the cards negotiating with the switches etc.? We need more details before we can weigh in with anything useful.
GoodDoes anyone have any experience using UCM software to manage DDL scripts
for development on 2 separate code releases?
We are using ClearCase for version control and have been managing
difference iIf anyone has done the IPMP setting Is this need to be done after Clusterware Installation or before Clusterware installation.
TIA
Sanjay
Sanjay Mishra <smishra_97@(protected) > wrote
Hi
Thanks to everybody for comments on this.
I think what I was looking for could be achieved by marking packages
with EDITION. It looks like this feature was available in 11g beta
but is not availableThank you all for valuable information.
Kevin Closson wrote a few articles about this. Maybe you 've already read
them but just in case...
http //kevinclosson.wordpress.com/2007/08/09/nearly-free-or-not-gridsql-for-enterprisedb-is-simply-We evaluated it a few months ago and found that the compatibility was
not great in several areas. In the case of PL/SQL stored procedures
for example they lacked support even for the most basic |
|
|
