 | | | Oracle List | | We have ORACLE 9ir2 on Redhat 4.3 and plan to change
Redhat from 32 bits O.S. to 64 bits Redhat AS4.
Does anyone have ORACLE 9ir2 or 10Gr2 "32 " bits under
Redhat AS4 64 bits environment?
does it ORA87.6 hours downtime per year 3.65 days per year 99% uptime Two 9s.
Four 9s 99.99% uptime 53 mins downtime per year.
Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data ProcesHi all
A developer asked me a question I couldn 't give any answer to.
Our application connect through a connection pool (hibernate) to the
database and the application should shut down if it can 't crOn 5/23/06 Baumgartel Paul <paul.baumgartel@(protected) > wrote
>
> Yes query the view ALL_POLICIES.
>
>
> *Paul Baumgartel*
> *CREDIT SUISSE*
>
and v$vpd_policy
--
Connor McDonald
> no its not the DBA 's job a dba is a DATABASE administrator. An Oracle dba
> won 't know about every single product oracle makes why should they
> automatically know about the the app server? The > The script is stopping after doing sqlplus what am I missing?
Check my answer on oracle-db-l.
Dimitre
--
http //www.freelists.org/webpage/oracle-l
Someone has to mention this..
I hope that isn 't your prod password. -)
On 5/23/06 Jeffrey Beckstrom <JBECKSTROM@(protected) > wrote
>
> I am trying to make a script to stop the OMS and restart it I am trying to make a script to stop the OMS and restart it after
running sqlplus. Right now testing with select from DUAL.
# set Oracle_home
ORACLE_HOME /home/oracle/OracleHomes/db10g
export ORACLYep. Looks like it.
2006/5/23 LS Cheng <exriscer@(protected) >
> Tue May 23 12 10 48 2006
> Beginning log switch checkpoint up to RBA [0x4f7.2.10] SCN 0x0336.77684e1c
> ...
> Tue May 23 12 26 10 200Alex
Unless you determine what is the cause of your performance issue
setting different options for filesystems would probably not get you
much. (Classic example Souping up your engine won 't helpOn 5/23/06 Ray Stell <stellr@(protected) > wrote
>
> On Tue May 23 2006 at 08 38 15AM -0700 GovindanK wrote
> > I could not lay hands on Metalink doc due to response. This is due to
> enhanced
> >Dhimant
>Here is my small -) problem. We are a small company with tight budget and I need to come up with
>Oracle standby database for our 2 CPU SE license. Any ideas? I read good amount of documentAFAIK it 's actually segment level. I.e. partitioned object can have
its partitiones mastered by different instances.
2006/5/24 Tanel P?der <tanel.poder.003@(protected) >
> > the objects. Only 10gR2 hasHi
I am trying to understand the wait event 'KSV master wait '.
I run 'drop tablespace TBSNAME including contents and datafiles ' from
sqlplus and I see that my session waits (for a long time) on 'K
I was just curious as to how prevalent Oracle Data Warehouse and App
Server software usage was amongst this group. I also have some
questions as to how DW and AS are managed/configured administeredDoes anyone have experience in moving SQL-Server data to Oracle 10g?
If so it willl be greatly appreciated if you could post your experience.
TIA
Nirmalya
--
http //www.freelists.org/webpage/oraclWorking (almost) fine for me as well.
The only 'glitch ' I have is when I sort on the "Last Login " column (I 'm
one of the admins for our agency) it 's sorted on a character version of
the date i.e.There is couple of chapters on how to backup a 10GAS installation in
the "Oracle
10gAS administration " manual.
There are nice "Perl " scripts to execute them as well.
HTH
Nirmalya
Quoting Jared StHi
I could log in after I had changed the name to my email but for the last
couple of hours I havent been able to get back in it just hangs on the
login page and nothing happens until I get a noticHi
Having been forewarned I logged into MetaLink this morning confirmed my
email address to use as the login name and got an automatic email basic with
the new initial password. But ever since it hHow many rows Oracle is considering for the first_rows optimizing goal?
30%?
Then 54/4 12 times penalty can be understandable.
-----Original Message-----
From oracle-l-bounce@(protected) [Hello
I searched for it on Oracle-l archives but I could not find an
answer. Has SGA management through SGA_TARGET parameter become commonly
accepted without any major problems in 9i. Does it meGreetings!
Now is your opportunity to add a book to your resume. I 'm looking for folks
to pen one chapter in our upcoming Oracle Database 10g RMAN Backup and
Recovery book from Oracle Press.
Yes thDid I miss something?
You don 't need to guess any thing.
To my mind the answer is straightforward one
SELECT s.VALUE
FROM v$sesstat s
v$statname n
WHERE s.statistic# n.statistic#
AND > 2006/5/21 Alex Gorbachev <gorbyx@(protected) >
> > Anyone knows what are these processes in ASM instance?
Parallel slaves.
select slave_name status from v$pq_slave
Regards
Dimitre
--
http //www.Hi Gene
There are many types of locks.
see
http //oraclesvca2.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#BABCJIAJ
Some are not compatible with others.
Performing an ALTER TABLE woMySqlAB.com
_____
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Roger Xu
Sent Friday May 19 2006 5 38 PM
To Oracle-L@(protected) Org (E-mail)
Subjectyou might try rlwrap http //utopia.knoware.nl/~hlub/rlwrap/
I 've tried it in the past but ran into a couple of issues using
vim on linux when editing from sqlplus.
Most of the issues were cleared Hmmm....
Well you *could* try something like this...
Change
> $cat `echo $DUMPDIR/vald2000_NGE_1904_05162006_*.dmp.gz | sort` |
> gunzip > /VMP1/archive/ngepipe.dmp &
>
to
for x in `ls $DUMPDIR/vIf you restore your database to a point in time in the past than
transactional integrity is preserved. However your application should
be done in such a ways that business transaction is done as data |
|
|
