logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 10 / 1
gladier
hey guys... does anyone know where on earth in the new oracle site the downloads section is
cmug
http://www.oracle.com/technology/software/index.html what new oracle site?
RuslanPopov
can I convert BLOB to CLOB?
SQL> alter table treelike_dict add (item_clob clob);
Table altered.
SQL> update treelike_dict set item_clob=item_text;
update treelike_dict set item_clob=item_text
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected CLOB got BLOB
item_text is blob field with text (html)
gladier
i was just failing at navigating to the chunk of the site that i needed .. thanks
(Action) vanishes
RuslanPopov
update treelike_dict set item_clob=utl_raw.cast_to_varchar2(item_text)
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual:102865, maximum: 2000)
http://dpaste.com/170321/ - f1 f1!
solver
cofeineSunshine
i think you should inicialize local variable
RuslanPopov
http://radz.ya.ru/replies.xml?item_no=1439 - solution :)
Thumann
Hi guys, I have a question regarding a join in oracle 8. Is this an apropriate place to ask for help regarding it?
In any case! :)) http://pastebin.com/ZNx00c9k is my query.. it fetches the data i want. My issue is though.. If a record exist in t2 (the budget table) but there are no matching records in the balance table (t1) It's not showed in the result. How can i re-write the query so it will show this record aswell? (Several records exist in t1 with no matching records in t2, so it's not just a case of reversing the join)
JingleBells
hey don't suppose anyone can help we with an issue with Oracle Report Server?
help me*
i'm having fun with character sets and getting them to appear in output PDFs
         

dsdel
I have noc lue about the report server, but check your nls_language of the database :)
JingleBells
DB and Reports are the same, DB displays them fine Reports appear as garbled crap
damn welsh
The string tu€‚ƒ„…vwòóÝýxÿ is appearing as ŴżẬáº"áºáº’áºáº&ŶŷỲỳÃ"ýŸÿ :\
SilSila
Can anybody tell me the which HP DL series is good(Performance wise) for RHEL 4.8 with Oracle DB 10gR2 and another server RHEL 4.8 with Oracle Application Server 10gR2 (10.1.2.0.2)?
mator
SilSila, http://h18000.www1.hp.com/products/servers/linux/hplinuxcert.html
SilSila, and performance is depends on an application/db load and server hardware
SilSila
mator: thanks for link....yes performance depends on the load...but you people will be having an experience regarding the performance...i.e., for example you have selected the hp server which is having oracle 10gdb for 100 users or more....
so i will collec the user experience and also the certification matrix...then it will be easy for me to select the right one...
hali
SilSila: depends on what you want to do and how much money you have
380 or a 585 are fairly bog standard
SilSila
hali: we are hp partner so money is not an issue
hali
oracle licensing costs are
cmug
hmm, database usage stats show partitioning (system) being used? Is that a licensed feature? There is also Partitioning (user) but I have 0 uses there
hali
380 if you want two socket, 585 if you want four socket
SilSila
hali: you mean power socket?
hali
SilSila: no, CPU socket
how many multicore processors you want
SilSila
dual
hali
380 then
X5550 is a good price point cpu
SilSila
xeon or amd?
hali
380 is always xeon
SilSila
oh...ok
hali
amd ones are suffix with a 5
385
SilSila
so i can go for DL385 G6?
oh....sorry
hali
yes if you want slower amd's
unless you are either have a amd friendly IT policy or you are *very* IO bound
         

SilSila
what will be the difference between xeon and amd with oracle db?
hali
xeon is faster generally, but amd has a slight IO bus advantage
on two socket systems this is
on 4+ AMD is usually still in the lead
SilSila
now i have installed rhel4.8 and oas 10gR2 in DL 380 G5...will it be same steps while installing in X5550 4+ AMD?
also, 64 bit is better or 32 bit?
hali
yes
SilSila
hali: how about the processor 64 bit or 32 bit?
cmug
hali, 4+ Nehalem is worse than AMD ?
all my new boxes are nehalem..
hali
depends on workload, but generally yes
cmug: until nehalem-ex is out
plus you would pay more for ee licensing with amd's
cmug
hmm, can you detail a little about the workloads?
hali
cpu vs. io bound
cmug
yeah so the IO bus stuff is the only reason why AMD would be better?
hali
yes
cmug
how significant difference?
hali
depends on your workload :)
cmug
all my db's use NFS, so I guess it isn't actually relative
hali
buy an AMD box and test
SilSila
what is the diff between rack and raid? our current setup is raid 1 0?
cmug
I have AMD's, no time to test though
hali
if you are ok with NFS on gig cards you don't have to worry i would guess
if you run nfs on 10gig it may be another matter, i've never tested that
cmug
hali, yeah I have one box saturating the current network which needs better throughput
does the AMD IO bus affect network output aswell ?
hali
yes, everything touching the hypertransport i would guess
cmug
ok, I need to investigate on the subject. Thanks
hali
let me know if you do any 10gig nfs testing, interesting to know the results
cmug
I'd need to come up with a proper test first
(pointers welcome ;-) )
tijnie
SilSila, a rack is something you put servers in. Raid is a configuration of disk (to optimize speed/performance) or to optimize redundancy.
SilSila
tijnie: sorry typo mistake....RAC
tijnie
ah ok....RAC is real application cluster.
That is a few instances operating on the same database (datafiles)
(RAC is a high availability solution)
SilSila
So we can implement RAC in RAID structure?
tijnie
Well RAC needs ASM (automatic storage management), so if you configure the raid such that oracle can put ASM on it you will be fine.
SilSila
can we set RAC for both database server and oracle application server?
tijnie
RAC is a typical oracle RDBMS feature.
application server has other ways to implemend high availability
SilSila
oh ok...
tijnie
(btw.: you don't just set rac=on...it's quite complex if you've never worked with it.)
SilSila
tijnie: i am not going for RAC...i will go only for RAID 1 0
because i dont know RAC and also my company will not give training....
tijnie
Seems a wise choice then. :-)
Good luck
SilSila
RAID 1 0 means my netadmin itself can set...
how about OAS 10g? can i install both midtier and infrastructure in the same server or infra in one server and midtier in another server?
tijnie
SilSila, you can insert both on the same server. You should consider the performance in this case.
SilSila
ok thanks
realHans
Hi. V$SQL is reinitialised when a new dump is imported with imp command. Is there a way to avoid v$SQLs initialisation after import ?
I'm aware V$/SQL is a view.
:)
:|
tijnie
realHans, a lot of the things imp does is done via sql
hence...the v$sql will be altered.
realHans
you mean imp creates internal sql comands ?
tijnie
si senor
realHans
thank you tijnie.
tijnie
realHans, np. May I ask why you don't want the v$sql to change?
realHans
tijnie: We have large testscripts (with a robot) and it's often necessary to import our testdump during the test. Now we're looking for the worst sqls which are created when our test runs from start to end (takes about 30 hours)
tijnie
ah...ok. Keep in mind that sql's will eventually drop from the sql-area when it becomes full.
So if there is a lot of sql you probably do not have all sql to begin with
anyway....good luck. Seems like a interesting job :-)
realHans
thank you for your time :)
rjb
anybody knows about oc4j?
francogrex
Hi guys maybe someone cazn help me: I'm trying to access an oracle databse using a program (plain-odbc)
I'm having a hell of a time setting the tns thing
I keep getting errors of the type: ORA-12154: TNS:could not resolve service name

I am on windows XP by the way and the oracle database is on a shared network drive (secure) I have a read only access normally
ujjain
Hello, I am the Oracle and have a question.
What database does SAP use?
« prev next »