logs archiveIRC Archive / Freenode / #oracle / 2010 / June / 1 / 1
zasz
solved the immediate problem by adding a data file and resizing the old one, shows 10% free space now
i still want to know what was going on
RJarett:
read above :)
RJarett
okie dokie
8k blocksize?
zasz
yep
RJarett
which db version?
zasz
10.2
i just don't get why maxbytes didn't incrase
increase
ech0s7
how can i do to export ALL databse (also with data) ?
zasz
dba_tablespace_usage_metrics showed it at 100% full as well
ech0s7
exp/imp doesn't export also data
RJarett
SELECT round(4194303*value/(1024*1024*1024),2) MaxFileSizeGByte from v$parameter where name='db_block_size';
compare that # to the # of blocks in the datafile
your smallfile datafiles have like a 16GB (minus a few blocks) limit
         

zasz
32
the file was 16GB, grew it to 18
RJarett
yeah but if you hit your limit, #1 it wouldnt matter since it cant map more and #2 im amazed you didnt get an ora error thrown
zasz
i wonder if the blocksize on this tablespace is different
i did get an ora error, i posted it above
RJarett
no not that one
i mean an unable to extend datafile error
zasz
isn't that block count you gave me in the query from older versions
you've given me enough to figure this out, i'm sure you're right, one sec
let me just see how many blocks are in the data file.
RJarett
10gb with smallfile TS is still 4billion block limit
10g i mean
zasz
SQL> select blocks from dba_data_files where tablespace_name='xxxxx';
BLOCKS
----------
2108288
393216
hmmm.
RJarett
do a ulimit -f on the os
zasz
unlimited, just confirmed now unable to extend datafile errors in alert log
*no
RJarett
you doing this in oem or sqlplus?
zasz
sqlplus
ech0s7
how can i do to export ALL databse (also with data) ?
exp/imp doesn't export also data
zasz
exp/imp will export data
if you want the entire db why don't you just back it up
RJarett
dont use exp/imp they are deprecated
zasz
true, use data pump
hmmmm
ech0s7
rasz: and what i have to use ?
zasz
i am gonna go nuts if i don't figure this out
RJarett
expdp dbausername/pass full=y file=mybackup_date.exp dir=oracle_directory_name
you need to create the directory object pointer in the DB first so it knows where to put the dump and that you have perms as that user to it
exp/imp havent been officially supported in 2 releases
ech0s7
ok
zasz
rjarret the max_blocks for the file is 2,097,152 in dba_data_files, and many are at around 1 million
         

RJarett
should be 4194302 maxblocks
zasz
quotas?
RJarett
are you between 10-5% disk free?
or less?
just an fyi: maxblocks lies sometimes
many of my datafiles are marked as 0
zasz
the one i added shows zero
also, abotu 10% disk free
RJarett
ok depending on your filesystem, 5 or 10% will be reserved for root
zasz
it's asm
the diskgroup has a bit over 10% free
RJarett
hmmm
zasz
25 out of 225
hmm well ill ask the guys at work on monday, the immediate problem is fixed
I just want to understand what's going on.
RJarett
yeah pretty odd
zasz
An important thing for a new guy.
RJarett
i dont let anything grow bigger then 16000
MB
on manually handled datafile TSes
zasz
i've never seen it before, in my whole 7 months of Oracle experience!
lol
this is a 4 node rac cluster btw
that shouldn't matter though
alright enough of this,
need more coffee
and thanks for the tips
RJarett
np
zasz
I didn't consider that it was maxing out the blocks
RJarett
gotta think outside the blocks
plantain
so I have a table called employee's, and I want to be able to document each employee's (many) skills within each record, how should I approach this?
I could just do skill1, skill2, skill3 etc, but I'm sure there's a proper way to do this :/
is using a varray a good way?
AqD|Home
hmm
why within each record??
you would never need to query employees by their skills?
plantain
it doesn't have to be in the record I guess
I just thought that would be the logical way to approach it, either storing it in the record or with a foreign key to a skills table perhaps
AqD|Home
if you store it in varray, it'd be no different than serialized RAW, except that you can operate it in oracle, but not efficiently i believe
plantain
okay, how could I design it so I could efficiently query employee's by their skills?
AqD|Home
then put it to differnet tables
=> have Employee, Skill, EmployeeSkill tables
lunch time!
plantain
thanks
dddh
hmm
HunterX !
I need metalink access
>_>
dsdel
then get an oracle maintenance contract! :D
zasz
lol
sytse
or switch to postgres :P
(and get a postgres support contract if you're dying to get support)
dddh
dsdel: !
sytse: I do not have my own login there, engineer gave me patches to apply, but I need md5sums to check if everything is ok
sytse
hmm, yeah, that's a real deficiency of metalink, that you can't have it send the interested parties emails..
dddh
sytse: all engineers in your company have their own logins at metalink?
sytse
not everyone.. not sure what the situation is, I've only been working there since october
(before then, I didn't even know metalink *existed* :D)
dddh
:D
ok
sytse
nor did I have any oracle experience whatsoever.. I knew it existed though :D
(although I had only heard horror stories up till then)
dddh
sytse: you used postgres before?
sytse
not really, I've used mysql and postgres for a few hours each all my life before then
it was my first real SQL (or database, for that matter) experience :)
dddh
have you heard about intersystems cache database?
sytse
now I'm someone to go to when you have technical questions on the workfloor though, so I guess I did learn something over the past half year
zasz
ddh all the dbas at mine have oracle support logins
sytse
nope
who says dddh is a dba :)
dddh
zasz: :(
sytse
(hell, we don't even *have* a dba :S)
zasz
oracle dbas should patch oracle systems imo
sytse
(and we're supposedly the biggest oracle client in the country)
s/client/customer/
zasz
how many oracle databases do you have
dddh
sytse: I work as a network engineer at network logic department, so I am not a dba
zasz
Do you guys have Oracle DBA's
dddh
zasz: do you mean I should wait till my boss will be back to ask him about md5sumz?
zasz
I am just wondering if you guys have dbas
dsdel
never checkeed the md5sum up to now :D
and done thousands of patches hehe
zasz
same, I just download them from oracle and apply
dsdel
much more interesting than checking md5sum is the complete backup before applying the patches
zasz
nothing wrong with checking the sums though.
dsdel
and the pre-/post-steps
md5 is weak, also if it will say ok there is always a chance that it isn't ok
also if it happens only 1/1000000 times
sytse
(I think it's a bit odd though, that we, with millions in oracle contracts, don't even have a single dba.. ah well)
zasz
who does all the dba work sytse
sytse
some sysadmins and one or two developers
dsdel
mostly a company can't afford a dba only for managing databases
zasz
i guess that is common, oracle dbas are expensive... but if you have many databases or even one mission critical one i don't get why your company wouldn't invest in a dba
dsdel
especially with oracle 10g and upwards - he wouldn't have anything todo if he works 40 hours/week he would sleep around 30 :D
zasz
especially since you say your company is a large customer of oracle's
dsdel: that's horse sh*t
sytse
dsdel: well, we have millions of lines of PL/SQL code and forms PL/SQL code, that's got to be something he can crack his head at ;-)
zasz
although 10g does do a lot on it's own :)
dsdel
zasz: ah yes - so what does a dba do all the day?
reorganize datafiles/tablespaces?
watch the memory management all the time?
zasz
lol
sytse
make sure performance never drops below 'acceptable' rates?
zasz
you're a sys admin aren't you
dsdel
invest most time into memory management watching to boost up oracle to 120% by manually setting all memory parameters?
zasz: sys and certified oracle dba
for 10g, not 11
zasz
then you should know it all depends on the role and it's responsibilities
i shouldn't have to tell you this
dsdel
for big companies -> dba, yes
but for small and mid companies - the companies just can't afford it
zasz
i agree for small companies
dsdel
we're oracle partner and selling oracle to our erp customers (small and mid sized) - in the last past years they reduced the admins in nearly every company
zasz
but say it's a mid company that has a few oracle systems that are mission critical, i would hire a qualified guy to run it
sytse
indeed, we do have millions in oracle contracts, and manage two dozen or so oracle production databases, but we're only a reseller.. we're not a big company
dsdel
90% of small companies don't even have any admin anymore - most mid companies only have 1/2 admins for managing 'everything'
sytse
(a reseller of those oracle databases and our own product on top of them)
zasz
small companies probably shouldn't be running oracle to begin with
we have 5 oracle dbas, lol
dsdel
zasz: nah even they should run oracle - cause of recovery and so on
sytse
we're between small and mid-sized, but we're building a product on top of oracle that we sell to companies totaling more than a billion euros in revenue per year
dsdel
if i imagine that our customers have mssql/db2 running most of them would have lost already all data cause of stupid backup methods or never checked backups
sytse
(we have a little over 50 employees)
most work at the customers' sites is delegated to the sysadmins of our customers though
compared to the companies we put our databases in, we're *TINY*
zasz
do any of htem have dbas?
dsdel
hehe gotta check sap, later :)
zasz
lates
sytse
zasz: not that I know of
(Action) is going to bbl too
zasz
if it's a pre packaged solution i can see them not needing a dba
do you guys configure the backups and so on for them
just curious, also if the db goes down or someone deletes something who handles recovery
dsdel
then they call us :D
and I can work again a complete weekend to clean up the sh*t they've produced (last time had it 3 weeks ago) :D
zasz
lol if you can handle oracle installation, administration, performance tuning, and recovery... you can pretty much be a dba
i suppose you don't want to do JUST oracle though right
dsdel
zasz: you don't want to know what I have to do all in my job scope...
zasz
oh i've been the guy that does everything...
i was the ad, exchange, sql, linux, windows, and network admin at a mid sized company
dsdel
hehe same here :) from sap to sysadmin for win/linux/unix/series i5 to dba for oracle/maxdb/postgres/mysql (if you can call someone a dba for working with mysql:D) to coder...
ah forgot db2!
and network naturally...
but less I get certifications paid hehe
need todo my sap TADM 600 finally
« prev 1 2 next »