| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> real-world experience with Oracle doc storage, intermedia etc.
I have been advocating the "if it can be done in the database, do it
in the database" philosophy for some time and am beginning to have
some success with it. Most recently, I pointed out Oracle's capability
of storing blobs and clobs etc. and to my surprise, the People in
Power were enthusiastic about it.
They did request, however, that I provide some "testimonials" from folks who have done this and I too, am concerned as to what I'm getting into here, e.g. performance issues, additional resources, and my prime concern, backup. I have emphasized or course that as we put more of our existence into the database, we must improve HW, personnel training, procedures etc. I have read Tom Kyte, Steven Feuerstein and others and have played with CLOBS and Intermedia a bit but don't have much feel for what it will involve from a DBA perspective.
We are currently running 9.2.0.4 Enterprise on a HP/Compaq Alpha but are probably going to move to Linux/Intel. I am trying to plan with 10g in mind.
So, any "war stories," good or bad? White papers are useful to me too, but the PIP would like to see some "we use it do do this and it works great/horrible" or whatever.
As much as I want to do this, I am stretched pretty thin, partly because I have a tendency to let my enthusiasm get the better of me, so I want to be realistic. I can back off and let them do some kludge and not be responsible but don't want to take that route if I can do it right using Oracle. Of course, I have no idea what requirements will be but probably initially small, i.e. a few Gb.
Thanks for any feedback you can provide.
Fred Pierce Oracle OCP DBA (forgive me!), developer, Oracle apologist, etc.
 |
 |