logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 26 / 1
Xgc
tijnie: Your idea of client is fine.
KeiKurono
morning
happy friday
pigoz
hello, I'm new to oracle-pl/sql: is it possible to declare a variable that contains something like ('v1','v2','3','4'), so that I can use it as the argument of the IN operator?
tijnie
pigoz, IN pl/sql you can make a collection, maybe you can utilize some of that idea. Have a look at : http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/collections.htm#CIHIEBJC
pigoz
thank you tijnie I'll have a look :)
boos
hello
KeiKurono
i have to port a 34m postgis schema to oracle8i :( :(
Trengo
why oracle8i? do you have a perpetual license?
sinesio
is there any tutorial on how to configure Oracle Enterprise Edition with ASM?
do I need a separate disk to creat ASM volumes?
os can I create from a folder
         

sytse
hmmmm... is there absolutely no way to get runtime information about a clob, like if it's char- or nchar-based, in PL/SQL?
(apart from inferred types of course, which you can make by using e.g. VARCHAR2 CHARACTER SET var%CHARSET as a type)
I suppose I'll just do: procedure proc(p_param in clob character set any_cs) as p_cset_test varchar2 character set p_param%charset; p_is_nclob boolean; begin p_cset_test := 'x'; p_is_nclob := lengthb(p_cset_test) > 1; [...] end;
tijnie
sinesio, You at least need a separate (raw) volume
steelnwool
anyone know where I could download a "test database", that is about a gig. I'm playing with flash back recovery , RMAN etc and just want a quantity of testing data.
heck even a hundred megs would do it. just some datapump file i can chuck in there
hali
on your local machine after you download and install a test version of Oracle?
steelnwool
yup.
oh, look at that demo/schema ...
in $ORACLE_HOME
tijnie
steelnwool, Isn't it easier to fill up a schema with some random data. (10 tables of 100m)
steelnwool
tijnie: it probbaly is. i was hoping there was just a sample datapump file kicking aroud somewhere. but i can make my own
tijnie
hehe, it never hurts to ask I suppose. But creating them yourself is not that difficult :-)
RJarett
random data is not useful usually
tijnie
RJarett, for some playing around whith flash recovery I don't think it's an issue
steelnwool
yeah, i just want a quantity of data. so when i do backups, or huge deletes for testing , i know i'm actually doing something :)
i'll probably just make a table and load it with the path and size of every file on disk or something. that will be a decent enough start.
or install something like mnogosearch and make it spider a random corner of the internet.
usn_work
steelnwool,
http://pastebin.com/FWJZLjNV
But for random data, just do CTAS from all_objects and insert from this table again and again
so data amount will double in each iteration, should do for your purpose
steelnwool
heh, nice. i'll play wit this.
thanks
forgive me, what is CTAS?
ah, i see.
usn_work
create table as select * from all_objects; for example
sinesio
refreshing my question, so basically if I want to create a disk group for ASM I will need a separate disk from the disk where I installed Oracle software?
is this correct?
hali
sinesio: what is the purpose of ASM in this case? testing?
there isn't much point of using asm unless you do have a load of disks hanging around
disks/luns
sinesio
no... because on the other side I'm running a RAC with dataguard
hali
for testing you can use asm on files on a filesysten, but obviously worsens performance
this is the standby box?
sinesio
yes, the standby is a single node
with two disks but mirrored
hali
so either use asm on separate disks or just map the names to the standby files
ok, then map
using db_file_name_convert and log_file_name_convert
to a local directory
         

sinesio
but you are saying not to use ASM on standby?
hali
yes, as you don't have the hardware to do so
sinesio
right...
usn_work
there's another fact
using ASm may make the duplicate database with RMAn way easier, since you don't have to rename that much
sinesio
yes thats for sure
I tried the dataguard configuration on two single nodes, and made those db_file_name_convert and log_file_name_convert
hali
you could run ASM on a couple of partitions
just to keep it simple i guess
usn_work
I'd say, you should run ASM on at lease one, seperate Disk or LUN
sinesio
but now with RAC I don't know how to configure Dataguard
usn_work
at least
hali
yes, running the db on the same disk as the os will have performance hits
usn_work
please read the appropriate MAA whitepaper, they are REALLY good
hali
get at least four drives in the standby box
usn_work
http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm
sinesio
thanks a lot guys
i'm really new to all this oracle stuff, and its really dificult for me to understand all these new concepts
RAC, ASM, Dataguard, etc
don't know if I can manage all this stuff
domgon
sinesio, welcome to Oracle world
dsdel
sinesio: everyone starts with 0 knowledge
you just have to want to learn oracle, then the time increase your knowledge
sinesio
yes but I could have stated with a more simple thing :)
dsdel
mysql? :D
kidding hehe
hali
at least with a single instance oracle
rac to start out with is a *very* steap lurning curve
sinesio
no... an oracle entrerprise edition single node.......
dsdel
yes
domgon
after understanding what are you doing, oracle stuff are easy
:)
hali
just make sure you have enough test systems
it's pretty key
even if it's just some VM's somewhere
sinesio
yes
how can I create a disk group for ASM (what software)
I installed Oralce EE software only
and I don't have the asmca
11gR2
RJarett
why do you feel you need ASM?
sinesio
because on the other side of Dataguard I have a RAc with ASM
so I think on the standby I should have ASM also
I wanted to try it in lab environment with some VMs or something
so I need to know what software do I need to install in order to have 'asmca'
avaia
sinesio: you need grid infrastructure
RJarett
ugh
rac and grid should be banned words here
they are so freakin abused
usn_work
hehe, why "abused"?
RJarett
because most people with it dont need it. and they are suckers for letting oracle sales sell it to them
and they then bi**h about performance since the money should have been reallocated to hardware or tuning instead of licensing
steelnwool
RJarett: amen.
I think most people under estimate how much data a decent db can deal with.
RJarett
yeah i run hundreds of gb a night in change through a single instance non rac
rac slows a setup down
steelnwool
so many people don't even need oracle.
sure , lots do. but not as many as think they do.
RJarett
eh. ill argue that one lol
if you care about your data you do ;)
steelnwool
I wasn't suggesting MySQL heh.
DiscordianUK
(Action) misses proper databases like mainframe ones
RJarett
yeah cause i love packed numbers and odd formats
DiscordianUK
(Action) laughs
disks were expensive back then
dsdel
(Action) runs cause DiscordianUK said mainframe
DiscordianUK
IDMS ++
dsdel
ah only working on i/series z/series :)
DiscordianUK
actually it was an ICL Mainframe
back in the 1980s when I was a junior A/P
avaia
disk is still expensive now
cheap disk is even more expensive...
I just hate hearing "disk is cheap" and someone going off about their 2T SATA drive
steelnwool
back when i was your age, we carved foreign keys on rocks... and we LIKED it.
DiscordianUK
I once paid 5000 quid for a 330Mb MFM drive
Needed two of us to lift it
avaia
and you were probably overjoyed
DiscordianUK
Indeed
steelnwool
my only "look how old i am" story about disks, is getting a 1gig western digital caviar, for high school gradutation. it was 350$ cad.
RJarett
$450 for 4 gig. $750 for 100meg tandy
DiscordianUK
My first disk for 386 cost 600 quid for 20Mb
steelnwool
hehe.
DiscordianUK
(Action) is old enough to remember and having used punch cards and paper tape
usn_work
eeeeh
steelnwool
my father in law regails me with punch card stories.
and waiting his damn turn to use a computer.
RJarett
i used them when i was a little kid
;)
DiscordianUK
aye that too
RJarett
same with a basic interpreter w/ toggles
but those were given to me to be toys
DiscordianUK
PDP-8?
usn_work
Oracle OFN, a new product: Old Fart's Network *gdr*
DiscordianUK
I'll shut up
steelnwool
i think you have to be old to use oracle. i'm not qualified yet, but should be in 20 years.
usn_work
nots, but you become old with using oracle.
all those felt ages ;)
DiscordianUK
I think I did my DBA at the age 35
usn_work
(Action) is 30
RJarett
i was working for oracle at like 20
well 19
no im 32 now lol i was 20-22
thats right
DiscordianUK
(Action) is nearly 54
steelnwool
(Action) is same age as rjarrett
hehe, at 22 i owned half of PostgreSQL Inc.
RJarett
you had like 1-2 old people per group at oracle. just because the group needed someone overpaid, burnt out, on weed, and called a technologist or sr tech analyst
steelnwool
then promptly realized the other half of PostgreSQL inc, tho technologically gifted, had no business running a business. As evidenced by the fact that I owned the other half.
RJarett
then you had 2 really stupid guys (or usually a gal) who were jr analysts. and they basically just picked up the phone and took into
steelnwool: are ya rich?
if you still now any of them, tell them http://www.pgsql.com/ pushes a 500 error ;)
DiscordianUK
haha
steelnwool
RJarett: i sold my 110,000 shares for .01cents each. so i got 1100 bucks.
DiscordianUK
CA still seem to be selling Ingres
steelnwool
and i designed the pgsql.com site in 2002, that they still use.
Marc is a not a business man.
RJarett
lol
steelnwool
I can tell you why its throwing a 500 error.
Marc probably installed a beta kernel, or a beta driver, or some beta software that wasn't nearly ready for production.
and forgot to test, or tell anyone about it.
RJarett
yeah one reason i dont like running something like pg in production
steelnwool
and is now lying in a diabetic stuper.
RJarett: pgsql inc != the oss software. pgsql inc , is a really weak attempt at being a support company.
RJarett
ahh
steelnwool
companies like enterprisedb actually take it seriously.
RJarett
yeah
im trying to get a full testcase built for our main DB
DiscordianUK
(Action) used also to run Multivalue DBMSes like Reality,Pick
RJarett
and also one to try gcgpu computation in a tesla outside the DB from a shared lib
DiscordianUK
Using CUDA or something?
RJarett
yeah
and a small jcuda attempt
but im a sucky coder at low level stuff
DiscordianUK
I wouldn't even try
(Action) is a sysadmin/dba
RJarett
me too
MaL0_
hi
RJarett
but... i still have to meet certain performance
and more cores of licensing and more spindles or new sans are expensive
if i could compute 5-10x more in gpu that would save me alot
steelnwool
I'm moving in that direction.for the last 10 years, i was a small business owner, so i coded , adminned, and managed , wrote specs etc. but now i got hired as a sysadmin. so happy.
MaL0_
thank you RJarett for your answer, the other day.
what's about how to disable oas cluster.
RJarett
when i started here it sucked. the network was in major disarray
steelnwool
RJarett: what are you usuing gpu's for ? [do you mean graphics cards?]
RJarett
all the systems
took me years to fix it
« prev 1 2 3 next »