 | | | Oracle List | | Having recently started looking into the possible deployment of
Enterprise Manager 10g Grid Control I notice that version 2 (v10.2.x)
is currently available for Linux x86 Solaris (SPARC) HP-UX and Hello all
Oracle 9206 on windows.
I got a call from the system people that oracle is using 50% cpu.
50% cpu because the computer have 2 cpu so it was looping and using
100% of one cpu.
I checked Oracle Version 8.1.7.0
Solaris 2.8
We ran into an issue using database links and mv 's. It seemed to work to recreate instead of refreshing mv 's but I am thinking that that might be causing anWe had a good experience but it was during an implementation of a new
server so there wasn 't a whole log of pre-CIO data to compare to
however we did do some before/after testing and had improvement > While trying to determine what command a third party application is
> using to change users ' passwords I discovered that the ALTER USER <name >
> IDENTIFIED BY statement is getting truncated when wriIs there a way you can store comments about an oracle user in the database (like table column operator comments) ?
Thanks
Couple o ' things. First the AWE/PAE/etc stuff only allows you to move
db_block_buffers/data buffers above and beyond the 3gb limit. If that 's
not the part of the SGA you want to grow it won 't helpI agree with Ric that it should be possible. However there is a
possibility that apply process will go crazy as object_id and
data_object_id will be changed in LSTBY database (as mentioned - test
teHi Pete
For me 9.2.0.7 agent worked only with SNMPv1 (on AIX5.2L) .
It DIDN 'T work with SNMPv2. May be that 's true in your case too .
Did you try with SNMPv1 ?
Just my $0.02.
Regards | Jp.
---Our production database is of version 9.2 but still using DMT because it is upgraded from 8174. And we want to move the table to a LMT tablespace althougth we can use some oracle package to convert DI 've got a monster join (27 tables) coming from my Baan ERP app. It 's
taking 0.00 seconds to parse and only .05 seconds to fetch but is
taking 15.05 seconds for the execute phase - see below from tkHi
Anybody runs DG in a SAP environment? Does extra license required?
Any experience can be shared?
Thanks
Roger
This e-mail is intended solely for the person or entity to which it is addressThis sounds similar to a known bug with ASSM tablespaces. The stats job
updates tables in SYSAUX. Those tables have indexes and up to 10.2.0.2 if
an instance does massive DML (which the stats job doDuration 1151404820? That 's like 36+ years... a bit odd uh? )
Anyway ORA-1555 is often thrown regardless space availability in UNDO
tablespace. You can get it any time for read only transaction (oOracle 8.1.7.4.1
Windows 2000 SP4
Intermittent error that (so far) is only resolved with a server reboot.
Error manifests itself many ways but the most obvious are inability to
connect to the databasDear DBAs
I have this recent error in alert log coming from the
stats update job. Though the SQL is given partly not
able to find the EXACT database object that had
problem. Any clue?
..
....
Tue > Is it a good idea to use ASM across two storage arrays? What are pros and
> cons?
You might find this one interesting -
http //blog.oracloid.com/2006/05/vldb-with-asm. Also you could have
located iSalem
no the INSERTs are done between 00 30 and 02 30 o 'clock at night. The
DELETEs are done between 17 30 and 18 00 o 'clock in the evening. Other
processes only read the table.
Regards
Markus K?hMarius
Thanks for your hint. I 'll examine Jonathan Lewis 's website.
Regards
Markus K?hn
LBS Landesbausparkasse Baden-W?rttemberg
Abteilung OI
Gruppe Datenbanken und Konfigurationsmanagement
J?gerRjamya
I checked 3329096.8 which exactly described our problem. I 'll run
segment_fix_status and see if it does anything good.
Regards
Markus K?hn
LBS Landesbausparkasse Baden-W?rttemberg
AbteilungSalem
no LOBS in this table only DATE NUMBER and VARCHAR2 columns. Other tips ?
Regards
Markus K?hn
LBS Landesbausparkasse Baden-W?rttemberg
Abteilung OI
Gruppe Datenbanken und KonfigurationsmanJoel
other segments are in this tablespace. These segments are not very large so
they are using small extents (128 blocks 1 MB each) which are reused.
Thinking about your answer it seems to me thais anyone is running that combination please contact me off list. i
have a few questions i need answered.
thanks.
--
--
Bill "Shrek " Thater ORACLE DBA
shrekdba@(protected)Hi Markus
According to OPatch I 've only installed patch 3406977 which is about
SQL versioning in V$SQL. Not that it helps *you* but it 's wierd that I
can 't reproduce it.
Of course this doesn 'tAs a hint you might dump the blocks out of those freed extents in the
beginning of the segment and see what 's really there.
I hope you will solve this as one of those 150.000 records inserted
daily tI don 't because grant them any special priviledges
I need to know what the developers are up to... this keeps me in the loop I have to have all the scripts anyway to put new columns etc into pwhen I make this query in sql*plus
sql > select describe from categories where name courses
I get the following data
NAME DESCRIBE >On Behalf Of Nigel Thomas
>To be fair the sentence continues (my bold from 10gR1)
> "...a full table scan might be cheaper than an index range scan "
>or by implication it might not. Or they could b
On 06/27/2006 08 30 02 AM dba1 mcc wrote
> Anyone has web site for ORACLE interview questions?
>
> Thanks.
One of the Oracle questions not without contemporary overtones is
the following
Shoul |
|
|
