 | | | Oracle List | | I 've pasted this stuff into my dba question list ~ I guess I should
research the answers next <g >.
OT I 've received a number of very good responses off-list. I don 't
post frequently here Hi
I get the ORA- 01722 error (invalid number string) when I try to convert
varchar2 to number using to_number function.
Case 1
I have all numbers in varchar2 but it seems there is some charaHi Ethan....
I tend more towards trying to determine if the candidate has honest to
goodness real world experience or is it all book knowledge and passed
the OCP.
An OCP is good (don 't get mHi all
Just wanted to give you the heads up that or those of you who use rman. I am trying to get up-to-speed on it in 9.2.0.6 rman fails in OEM. Found out it 's due to rman executable being in uHi
A simple way is to enable 10046 trace level 8 for the session in
question.
Then you can see in the trace file what the session is doing/waiting
for.
/karsten
-----Original Message---Hi
I know I could get this info from an Oracle Rep but does anyone have some
idea of how much does it cost? I would like to have some idea before calling
rep. I googled and it is difficult to fHi Jeffrey
No you are not stucked to 32-bit RDBMS.
What you do is that you have your APPS home incl. 8.0.6 oracle home.
Then as another UNIX user e.g. applora you install you oracle RDBMSSeems to me that the fetch-across-commit is not actually the problem in this
case. There is no DML activity on that table. Hence the blocks in the
buffer cache are never made 'dirty '. On the otherAre you archiving?
If so what is your archive destination path? Found in your initSID.ora
file
What is the output of 20
Select * from v$logfile
-----Original Message-----
From oracPaul
I suppose in the case 1. and 2. you mentioned you have
SQL 's running much much longer then you need for the
parsing.
Why are you bother what is the library cache hit rate?
I have thathttp //groups.google.com/groups?hl en&lr lang_en&frame right&th 2d8740062881
951c&seekm pan.2004.11.22.08.37.19.353551%40sbcglobal.net#link1
--
Mladen Gogala
Ext. 121
-----Original Message-----On Wed 24 Nov 2004 12 30 27 +0000 Mladen Gogala <gogala@(protected) > wrote
> There was an article discussed recently on comp.databases.oracle.server
> which can be used for a decent management There was an article discussed recently on comp.databases.oracle.server
which can be used for a decent management presentation for the PHB and 20
friends.
The article in question is full of grossHello list
Can any one me advice me a very good book/s on 9i data guard that
covers A-Z of 9i data guard (standby database) includes
administration performance tuning routine checking scriptSurprised to see somebody still uses the word 'grok '. I reread the book by
Heinlein last summer and found it still worth reading although it is from
1961 (before computers almost). Not that I read i Remove the parameters from your init.ora file.
Regards
Stephane Faroult
RoughSea Ltd
http //www.roughsea.com
On Tue 23 Nov 2004 23 50 phani krishna <dbaphani@(protected) > sent
I just installed TDP for Oracle 5.2 on AIX 5.2 64 bit. I intend to use
RMAN and am trying to configure this with the tdpo.opt file.
For the parameter TDPO_FS the documentation suggests that you sWhy reinvent the wheel?
perldoc -f sprintf
My advice would be to talk to the users to find which processes
are unbearably slow or if there are many which are the most
important to resolve as well.
Then work from there. Trace an isolate
Ross
IIRC it also disables System triggers a manual step
(_system_trig_enabled false) in the last 8.1.7.4
upgrade I did many moons ago.
Mike
-----Original Message-----
From Mohan You are fetching into mal_doc_month_rec but using matl_doc_month.
--
Ron Reidy
Lead DBA
Array BioPharma Inc.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounceOn 28/11/05 Norman Dunbar <norman.dunbar@(protected) > wrote
>
> Morning Tony
>
> I notice from a few of your subsequent postings that you got some
> replies - I didn 't see them so apI guess you can do so if you have "Microsoft ODBC Driver ".
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Thomas Day
Sent Tues
Analyze estimate with anything over 49% results in automatic
compute. DBMS_STATS estimate option will estimate to the percentage you
request.
Gj
-----Original Message-----
From Jesse RHi
> I did find the table mlog$_ <table_name >. I assume this
> gets created when the mv log is created.
Yes. 20
> When I delete the mv log then I assume all objects that
> depend on the mv lThe only thing that bothers me with MSSQL is the row length limits. 8000 something bytes/char max.
Oracle is just too expensive that 's where MSSQL somes in.
--
Lyndon Tiu
--
http //www.freeHi All
I am gathering some data on the amount of time that Oracle took to read
and write (IO statistics). I am using v$filestat/x$kcfio for this
purpose. I would like to know how reliable are the We 're about to convert a HP box running about 4-5 databases running
8.1.7.4 to 9.2.0.4.
(HP-UX fl016d49 B.11.11 U 9000/800 3352025259 unlimited-user license)
Going to
Oracle9i Enterprise Editperldoc -f length
perldoc -f sprintf
BTDT head for PostGreSql. We have. I spend more time on PostGres than
Oracle now a days. 20
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From Nick Til |
|
|
