Hi
This client has Oracle 8.1.7 OPS with 2 nodes.
Every now and then sessions hang with this event being the only one that
accumulates more time. How long can this downgrade/upgrade take?
There is a bug in 8.1.7 related to this? Has anybody experienced it (Bug
1916409) and how can be proven w/o a
Load up a sample set of rows, check the number of
blocks used (analyze, then look at user_tables), then
multiply by the expected increase factor
hth
connor
--- Hamid Alavi <[EMAIL PROTECTED]> wrote: >
Dear List,
>
> I have a question regarding Table size, I want to
> put the small size of
> tab
I second this.
Last year a developer put together a scenario in one of our data warehouses involving
a big base table, hierarchies, and 8 MVs as summaries of that data, with query
rewrite, etc. Supporting it has taken some getting used to, but now I like it and am
on the lookout to take advanta
Hello Ashok
What are u seeing to make you believe that you need separate temp segements
per instance?
Murali Vallath
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 20 Mar 2003 17:14:18 -0800
Is there a way in RAC that I can create 2 T
I often use proc precompile to make .cpp file from
.pc .
And the same time ,these programs are all multi-threads .
But the default environment configure
of proc precompile is .c and single-thread
So precompiling one , configing
one .
Is there
some way to conifg the evironment. And make
Title: Message
A
fan!!
The
Red Green Man's
Prayer:
"I'm a
man... But I can change... If I have to... I guess..."
Motto
of Possum Lodge:
"Quando omni flunkus moritati"
Note: Roughly translated, this means "When all else fails, play dead"
OK,
done with OT.
-Original Messag
Guys,
help me here.
This SQL [below] returns the error :
connecting to AM3C01
declare
*
ERROR at line 1:
ORA-01729: database link name expected
ORA-06512: at line 16
[AM3C01] is the first db_link fetched.
tti 'Database Sizes (excluding TEMPFILEs) ' center
spool DB_Sizes
set serveroutput on s
Is there a way in
RAC that I can create 2 TEMP tablespaces which can be explicitly assigned to
separate instances of RAC. Or is there a way that to specify the size
of the instance-specific temp segments? If I have a TEMP tablespace
with a size of 10GB, how can i split it between 2 instances
Thank you for your regard
You are right ,and the .lis file show all meesages to me .
Thanks for your help
I don’t understand what mean errtype is .and I once try to point one
file err.log
and then precompile one proc file .but there is nothing happened.
Can you tell me about what is errtype .
Tha
Ahh I completely forgot that sqlloader needed to be used with direct to
bypass logging. He actually told me he couldn't use direct because some of
the data he was loading was date related. All in all it is easier for me to
deal with extraneous redo rather than have him modify his tables.
Thanks
Since you mentioned Standby database and depending on the version of Oracle
you have (9202 here), have you disable NOLOGGING at the database level by
using "ALTER DATABASE FORCE LOGGING" (If I remember the syntax).
We have done exactly that to prevent any NOLOGGING operations since there's
a stan
First thought -
which table would you want the new data to go into ?
If you really need to implement this type
of thing check "instead of" triggers.
Be warned, though, that this is okay for
small inserts- but if you are planning to
do batch/array inserts, any trigger turns
a fast array proce
Performance of selects and non-direct path inserts. I no longer have the
exact data as it was left at my former employer when I left. Significantly
is relative -- it wasn't like performance went to the pots, I'm talking
between about 5% and 10%. So a 1 minute query would run a couple seconds
longer
Alec,
Have a look at the 2 explain plans and see how they are different.
Have a look at wait stats / 10046 trace for the two and see how they are different.
What version of Oracle?
Do you have histograms?
If 8i or below and using the function then you will be using bind values and not
getting be
The really cute thing about the need for global statistics
to be reasonable - a few pages further on you'll find the
comment that in 8i you can't generate global histograms !
(Fixed in 9i)
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
One-day tutorials:
(see http://www.jlcomp.demon.co.
One of the options for materialized views
is to 'create MV on prebuilt table'
If you want to use the table for direct queries,
then you can - if you enable query rewrite then
suitable queries against the base tables can
be rewritten to take advantage of the MV.
It's a technique I've advised cli
My off the cuff response is "did you have direct=yes" set in
the parm file or on the command line?
IIRC this is basically the same as using the '/*+ APPEND *'
hint in an INSERT statement.
Jared
"Steve McClure" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/20/2003 03:13 PM
Please resp
Kevin,
Performance of what? SELECT, INSERT, DELETE, UPDATE?
And why?
Jared
"Kevin Toepke" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/19/2003 03:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject
1. set audit_trail = db in init.ora
2. login as a dba and issue the command "audit session;"
3. select * from dba_audit_session
Also, this is not a political forum, so please do not include political
slogans or messages in emails to this forum.
Jared ( the list owner )
Joshua Becker <[EMA
I have written a function to return a drug price from our database. If I use
this function in a SQL statement it take a long time to return a value.
However running the main cursor in the function in SQL returns a value
immediately. DOing a little debugging I find that the function does 6000
physic
Hi list
I need help on this. Trying to create a view with select
union all as part of it.
SQL> @view01b
SQL> create table t1 (ind1 varchar2(02) , rundate1 date)
2 /
Table created.
SQL> create table t2 (ind2 varchar2(02) , rundate2 date)
2 /
Table created.
SQL> insert into t1 values('T1'
Allright I have a developer that is loading a few gig of historical data,
that will only be used for a very short period of time. I wanted to avoid
dealing with all the redo this is going to create. I created a new
tablespace using the nologging option. The table and it's indexes were
created wi
Paula,
I'm not sure what would an MV on top of an aggregate
give me. I mean, I have a base table and I need to
aggregate. I can see doing it via an aggregate table
or (as someone suggested) via an MV. But you are
suggesting both. What benefit do you see from that?
What am I missing?
thanks
--- [
Title: RE: Weekly aggregates
What about materialized view on top of the partitioned table aggregated by week? I don't remember is there a restriction that the material. view must be partitioned same as table? If not it might be a bit of a perf. hit but only once. Also, can determine how to
Brad, you're absolutely correct. Explain plan is what is intended, but isn't what
always happens. It probably is most of the time, but not always. I recently had a
circumstance in which a long running job (the explain plan of) was telling me it was
reading from a big partitioned table and usi
Title: RE: RE: Value of OCP
You sure that isn't spackle you are talking about?
Oracle OCP DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 20, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Value of OCP
Go
Oracle Designer is a very powerful tool.
In a previous life, everything was handle in Designer, even shell scripts
(via Samba), word docs,...
We were using the version control to manage dev, test, qa, prod,...
Each version was containing DDL, word docs, shell, C programs,...
We were 2 dev dba/arch
I think you can trust the STAT lines in a SQL trace file to give you
accurate information about what execution plan *did* take place. The test I
would suggest is to compare the information in these lines to what EXPLAIN
PLAN shows you. You'll need to look at the raw trace data, though, because
tkpr
If you are using 9i, you can use the dbms_metadata procedure to generate
DDL for your database objects.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/20/2003 2:03 PM
Hi
How do you document your databases? The only DBA tool that I have at my
disposal is Designe
"Odland, Brad" wrote:
>
> Hello,
>
> Heres a question to ponder. While tuning a SQL statment for a user I noticed
> that the explain plan from SQL Analyze was not the same plan that was found
> when I used OEM Top Sessions (9.2.0.1) upon executing to collect execution
> stats. Database is on HP/
Ben
Two ideas:
1. A site like yours probably has a source code control system. Use it.
2. Learn ITIL.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, March 20, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Hi
Ho
No, although I've come close with Superglue/Krazy Glue (btw, to remove
that use any nail polish remover with acetone, works like a charm)
Jared forgive me, we are way off topic here but...
I had a scratching post for my cats that was falling apart. And a hot
glue gun. I decided I could be Martha
I've used both methods at different sites for different reasons.
If you need the performance of the
partition-wise join, then you keep
the weekly aggregates in monthly
partitions, and work around the
problems of not being able to do
a single week
create as select / exchange partition
If
Hello,
Heres a question to ponder. While tuning a SQL statment for a user I noticed
that the explain plan from SQL Analyze was not the same plan that was found
when I used OEM Top Sessions (9.2.0.1) upon executing to collect execution
stats. Database is on HP/UX 11 version Oracle 8.1.7
The stats
Hi
How do you document your databases? The only DBA tool that I have at my
disposal is Designer but I have not used it yet. Is it adequate to
completely document the life cycle of a database design? I am sure it can
create and retain pretty straight forward DDL. Does it allow build levels?
What do
Gurelei
Absolutely you can partition by week. The creative DBA is a top DBA! You
keep mentioning aggregation. Have you considered Materialized Views?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, March 20, 2003 1:19 PM
To:
Title: Good to be back
I don't know, but it seems, I was bumped off the list due to some problems. Glad to be back it's like being out in fresh air. No list messages for 5 days was killing me.
Raj
-
Rajendra dot Jamadagni at es
Hi all:
An application I'm supporting needs weekly aggregates.
Nothing wrong with that except I'm thinking of how to
partition that aggregate table. The requirement is to
keep 3 year history of data. I have been partitioning
other aggregate tables (monthly etc) by month. This
makes it easy to drop
Rachel,
You didn't glue your fingers together, now did you??
Did that many years ago. We were using super glue, the older slower drying
stuff, to hold a gasket on the bottom of a radar beacon case. Well using an
open top bottle and flux brush to apply that stuff is messy at best. Got j
remind me to tell you about my glue-gun related accident.. never ever
try to brush the hot glue off your hand!
--- [EMAIL PROTECTED] wrote:
> Personally I like the old glue gun - well okay, watch out for
> electricity
> surges whilst deploying the glue gun method. However, really useful
> for
>
We are living it now.
You are "supposed" to go to 9.2 before you go to 5L, then install the 5L
version of the binaries after you upgrade the OS and before you open the
database.
want some REAL creativity? Add Apps to the mix and it gets real ugly real
fast.
April
-Original Message-
Se
Thanks all. I thought the "crash" problem in rootpre.sh maybe affect
something.
Another question, I know that this one had been discussed sometime ago.
regarding how to approach the upgrade path from 817.4 to 9.2. Currently
we run it on 4.3.3 32-bit mode. What is best path to cooperate AIX
upgrade
In what way is it not working ?
Are you getting an error message, or not
getting the results you expect.
In the latter case, this may be because
you are cancelling the outer join by not
echoing it through all the necessary
points in the WHERE clause.
e.g.
>
> (substr(pcmacaddress,10,2) ||
> sub
There are entry level DBA positions, although I will admit they are few and far
between. We had one, filled it & now have promoted the guy. He did not come
from an IT related area (actually was a "bean counter" before). A couple of
years ago I'd probably have said it was a mistake to open up suc
I will admit to getting mine simply as part of an ego trip. I figured that
after 15 years of being an developer/DBA with Oracle I should have one. Has it
made a difference to my salary or employment potential? Not one bit.
Dick Goulet
Reply Separator
Aut
Joan,
I BELIVE Henry's right. With the 8i binaries you should only have to
relink. With 9.2 you have to get all new binaries.
-Original Message-
Sent: Thursday, March 20, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
Joan,
I would just relink the oracle executables.
Henry
Title: RE: RE: Value of OCP
Personally I like the old glue gun - well okay, watch out for electricity
surges whilst deploying the glue gun method. However, really useful for
most kid related things - wip up a costume in no time, fix that plastic toy,
diaper to cheap to stick - the glue gun c
Title: Message
If the
ladies can't find you handsome, at least let them find you
handy!
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:54
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
RE: Value of OCP
Red Green, m
I wouldn't really expect to get any
significant benefit from partition
elimination when using hash partitions.
In fact, apart from the administrative
convenience, I think the only benefit
is likely to come from partition wise
joins using partition iterators.
Can you give us any details of the
Title: RE: RE: Value of OCP
Red Green, my hero!!!
http://www.ducttapeforever.com/forever.html
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 20, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Value of OCP
Good ol
You can get significant benefit from hash partitioning if you have 2 or more
tables that are equi-partitioned. The benefit comes when you join the tables
together -- you get partition-wise joining! In effect, you perform multiple
small table joins instead of 1 join of 2 large tables!
This works fo
Title: RE: Value of OCP
I held out for 8 years as an Oracle DBA. I had been sent to training and interviewed Oracle DBA's and worked for Oracle as a DBA consultant w/o having the certification. It was based on my personal reputation, experience, network and interview. Those I believe still
Pat, you don't become a DBA, you get consecrated into the order.
You have to master ways of the force, unix kernel, shell programming,
perl, C/C++, application tuning and geek humor before you can be safely
inducted among the immortals. Live long and prosper!
-Original Message-
Sent: Wedne
Title: RE: Try Again: Outer Join with SUBSTR
SQL> select * from t ;
V
ABCD
WXYZ
SQL> select * from t2 ;
V
--
ABQCDR
WXQYRZ
SQL> select a.v, b.v
2 from t a, t2 b
3 where a.v = substr (b.v(+), 1, 2) || substr (b.v(+), 4, 2) ;
V V
--
ABCD ABQCDR
WXYZ
-Origi
Dear List,
I have a question regarding Table size, I want to put the small size of
tables in a small TBS,But don't know the size of table do I have to
calculate the size for which period, Assume we want to keep the data for 5
years so do I have to calculate the size of table for 5 years then decid
Looks like a Platinum plated version of an apps server.
Dick Goulet
Reply Separator
Author: =?iso-8859-1?q?Joshua=20Becker?= <[EMAIL PROTECTED]>
Date: 3/20/2003 3:38 AM
Is anyone using this product, could I please hear your
comments and thoughts.
Is
Joan,
I would just relink the oracle executables.
Henry
-Original Message-
Sent: Thursday, March 20, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Hi listers,
I have a relative simple qusestion regarding upgrading AIX os system.
Our current enviroment is 4.3.3 32bit with 817
Oh Stephane, your such a woos. I absolutely hate the OCI interface, talk about
a place to blow your head off! 99.9% of the time that the C compiler tosses
a fur ball is something you've done in C that is wrong, although I'll admit is
sometimes gets real hairy trying to find it. If the Proc p
We had a case where the hardware revision level of an I/O device was not at
the correct version, and we would get random error messages about corrupt
blocks during a select when there were, in fact, no corrupt blocks. This
was on Tru64, not HPUX, but it might be something to investigate.
> -
Quoting Stephen Lee <[EMAIL PROTECTED]>:
> > -Original Message-
> > Did you learn anything from the previous crash to prevent it from
>
> > happening again?
> >
>
> Yes. Duct tape the power cord to the floor.
>
Whoa!
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.
Santosh,
If that's what your after I'd suggest you get into WEB development mode.
Using Access means using ODBC which means installing the Oracle client. Take a
look at ColdFusion, or 9IAS or some Java based approach. In any case your going
to need a WEB server and browser on the client sid
We have BAAN IVc4 and Oracle Enterprise edition at our site. Enterprise
Edition has got some advantages over the Standard Edition which would be too lenghty
to explain here, but we are not taking advantage of them and, besides, baan does not
exploit Oracle's facilities too much and Stan
[BUG:458336]
UTL_FILE.WRITE_ERROR RAISED DOING MULTIPLE PUTS OF <1023 CHARS
EACH (TOTAL>1023)
[BUG:385936]
UTL_FILE.PUT WITH BUFFER > 1023 CHARACTERS CAUSES ERROR
I'm not able to read these bugreports in metalink, anybody familiar with
these problems?
Details: Oracle 7.3.4 HP-UX 10.20
Tia,
Dick,
Just for the example I stated. Sometimes, the sql I want to run is
variable, depending upon something that happens in the .BAT file. This way,
I can construct the sql file using NT substitution environmental's, and the
sql statement changes with each run. The most common thing I due is to
Peter,
I've not had very good luck with hash partitioning either, but range works
damn nicely both from a data insertion/update and query point of view. CBO also
runs very consistently.
Dick Goulet
Reply Separator
Author: Peter Barnett <[EMAIL PROTECT
> -Original Message-
> Did you learn anything from the previous crash to prevent it from
> happening again?
>
Yes. Duct tape the power cord to the floor.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network
Good old Duct Tape, the "handyman's secret weapon"!!
Reply Separator
Author: Stephen Lee <[EMAIL PROTECTED]>
Date: 3/20/2003 6:34 AM
> -Original Message-
> Did you learn anything from the previous crash to prevent it from
> happening again?
>
Quoting Rachel Carmichael <[EMAIL PROTECTED]>:
> well the last one we had, I learned that I need to teach the
> sysadmins
> to verify that they are not assigning two volumes to the same
> physical
> disk! :)
>
Ooops! duh!
> yea I learn techniques, and things to check and not to panic no
> matter
As we have discovered, hash partitioning does not
always give you partition elimination nor does CBO
always work as expected. One of our DBAs has a tar
open with Oracle on this issue and we are finding that
no one appears to understand the complete
ramifications of using hash partitions when a que
Hi listers,
I have a relative simple qusestion regarding upgrading AIX os system.
Our current enviroment is 4.3.3 32bit with 8174 32 bit oracle instances.
If we upgrade AIX 4.3.3 to AIX 5.1, booted in 32 bit mode. Do we need to
reinstall the 817 software or do nothing?
Thanks,
Joan
--
Please se
"audit connect whenever unsuccesful"
or thereabouts, assuming you have auditing set up via
the appropriate init.ora parameters.
hth
connor
--- Joshua Becker <[EMAIL PROTECTED]> wrote: >
> Hi all,
>
> could someone give me an example how could I set up
> auditing on for failure logins.
>
> Th
Thom,
If your going to go to all that trouble, why not simply create a .sql file &
call it on the command line.
Dick Goulet
Reply Separator
Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]>
Date: 3/20/2003 4:53 AM
Chuan,
What I do is the follo
Switching archive logs will only switch redo logs
and change the status of the file that was used to "need archiving".
Archive log current, on the other hand, will switch logs and archive
any logs that needs archiving.
-Original Message-
Sent: Wednesday, March 19, 2003 9:14 AM
To: Multipl
>Oh Stephane, your such a woos. I absolutely hate
>the OCI interface, talk about
>a place to blow your head off! 99.9% of the
>time that the C compiler tosses
>a fur ball is something you've done in C that is
>wrong, although I'll admit is
>sometimes gets real hairy trying to find it. If
>th
My script does an
SWITCH LOGFILE
ARCHIVE LOG CURRENT
SWITCH LOGFILE
SWITCH LOGFILE
sleep 180seconds
The script has been built up over the years -- it initially started off with
SWITCH LOGFILEs and therefore I put in the sleep to ensure that the
archive logs were written. As I only actually need th
Dennis,
Actually I was quite fortunate that I started off as a DBA, not a developer.
I wasn't in IT at my first job. there was no IT department and IT services
were being provided by the consultants who were rolling out the systems
for us. Once the organisation grew large enough [from 15 to 50 pe
Does anyone use the Oracle Forms and Reports services to serve Forms and
Reports apps through the web? We have a setup running here on a Solaris
system and there are quirks (like starting the Reports service under a
VNC session) and frequent crashes. I'm wondering whether there are
preferred
Hello, List:
I'm doing a outer join with SUBSTR, but can't get it to work. Is there a way to get correct or get around it? Thanks in advance
SELECT rtrim(komp.inventar), rtrim(komp.typ), rtrim(komp.herst), rtrim(sysstand.so_nr), rtrim(person.vname), rtrim(person.nname), rtrim(li
There is no such thing as an entry level DBA. This has been a myth for a while. Alot
of training companies offering incredibly expensive classes are duping people into
believing these jobs exist. Oracle DBA is a real buzzword term so people think there
are lots of entry level positions.
DBAs st
No, it is not necessary to switch or archive the log file at every tablespace.
I, too, run the switch and archive commands _after_ the last tablespace.
Hemant
At 10:26 AM 19-03-03 -0800, you wrote:
I use switch logfile exclusively within my hot backups (because at the time
I wrote the scripts I was
Pat
Not to be impolite, but what makes you think this is the next logical
career move for you? Before you become a DBA it is good if you have a lot of
other computer experience, such as development or system administration. You
really need to understand how large computer systems work and how al
Santosh - Yes, you can create an Oracle table, have MS Access link to that
table (ODBC) and create a Access form for the user to enter data which will
be stored in Oracle. This is will look good to your user and be pretty easy
for you to create.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc
Chuan,
What I do is the following:
set DBA_TEMP=\sometempdirectory
echo connect test/test > %DBA_TEMP%\run.sql
echo alter sesion set sql_trace=true>>%DBA_TEMP%\run.sql
echo select count(*) from product_temp p, invoice_temp i>>
%DBA_TEMP%\run.sql
echo where p.invpsid=i.invoice
Hi,
Unfortunately I'm stil stuck to Oracle 7.3.4 and there is a limit of 1023
characters
per line. I know it is raised in 8.05 as mentioned on metalink. Are there
any trics
in 7.3.4 available?
Tia,
Jeroen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeroen van Slui
Is anyone using this product, could I please hear your
comments and thoughts.
Is there other links than this
http://www.metilinx.com/default.cfm
rgds
Joshua
_
Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Se mer på: http
In your script file, put:
SHOW ERRORS
after the procedure text.
-Original Message-
Sent: 20 March 2003 06:49
To: Multiple recipients of list ORACLE-L
This is a multi-part message in MIME format.
--=002_Dragon236182704230_=
Content-Type: text/plain;
charset="GB2312"
Conten
well the last one we had, I learned that I need to teach the sysadmins
to verify that they are not assigning two volumes to the same physical
disk! :)
yea I learn techniques, and things to check and not to panic no matter
who is breathing down my neck to get the database back up
experience tea
I've had Ab Initio accessing my databases at several uk based large telcos.
It was used to pre-process extremely high volumes of call data records. It
can scale very well and runs across many platforms - UNIX, OS390, NT.
On UNIX it essentially generates multiple shell scripts which call bespoke
ex
On Thursday 20 March 2003 05:18, Santosh Varma wrote:
> Hello list,
Hi,
>
> Could anyone of you tell me good sites where i can find
> questions/FAQ's related to oracle pl/sql, sql. triggers.
>
here are some Links for Oracle
http://web.singnet.com.sg/~petermag/oracle.html
http://www.orafaq.com/
Install Cygwun (http://www.cygwin.com/). Then there wouldn't be a need
for format change and you could use (almost)all your UNIX scripts .
Best Regards
MILEN
-Ursprüngliche Nachricht-
Von: Chuan Zhang [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 20. März 2003 04:19
An: Multiple recipi
connect as owner of procedure to sqlplus
select
* from user_errors where name = 'X'
(X
= procedure name)
-Original Message-From: liujd
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 20, 2003 12:34
AMTo: Multiple recipients of list ORACLE-LSubject:
My oracle
Anyone using HP K-class servers connected to IBM ESS running HP-UX 11.0 and
Oracle 8i successfully - if so maybe you can shed some light on the
following :-
We have a test HP K460 (9000/889) connected to an IBM ESS for storage which
we are currently testing to see if we can connect all our test a
See notes on
http://www.jlcomp.demon.co.uk/faq/num_size.html
There's also a note on the site (though not in the FAQ)
about reading internal formats and working out what
number it represents.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based
>My oracle using version is 8.0.0.5.
>Now , I'm programming proc .
>When I precompile them and fail. But I can't see
>what happened .and
>where the errors are.
>So I look carefully for errors in large file.
>Is there some way to show where the error is .and
>what the error is .
>Can you give me y
The index name shows that this is the LOBINDEX.
Each out of line LOB item is broken into CHUNKs,
and a bitmap in the LOB (DATA) SEGMENT is used
to map where in the SEGMENT there are free
spaces that can take the CHUNKS, but there is
also a LOBINDEX stored in the same tablespace
that links together
95 matches
Mail list logo