Thanks Dennis ,
But I am looking something for oracle application server .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 10:14 AM
AK - My favorite for people that are new to Oracle, or even databases for
that
Listers,
8.1.7.4. Anyone use the _subquery_pruning_cost_factor and
_subquery_pruning_reduction hidden parameters to make the CBO a bit more
aggressive about using recursive SQL and the TBL$OR$IDX$PART$NUM internal
function to get partition pruning on hash joins (for example, when the
value(s)
Oops, my bad. I didn't notice the AS. Ignore that last message.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 06, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
AK - My favorite for people that are new to
Prasad,
You can use SKIP_UNUSABLE_INDEXES=Y as an import parameter. But then again,
why do that? Why not just impirt with INDEXES=N and then rebuild the indexes
in parallel and with NOLOGGING?
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Lisa,
Shut
down your production database and FTP the control files over also. This
will make your control files waaayyy ahead of your data files, thus forcing a
recovery.
Right
now, your database does not need recovery - everything is in synch. Your
control files don't know anything
attribute is a specific part of an index-file, but those attributes are different for
all document types
-Original Message-
Sent: donderdag 7 augustus 2003 16:15
To: Multiple recipients of list ORACLE-L
attributes
What do you have as an example of an attribute?
how about 2 tables w/ a 1:many relationship? document_types each with many
document_type_attributes. read up on data modeling. i think several good
books were mentioned on this list recently.
-Original Message-
Sent: Thursday, August 07, 2003 8:34 AM
To: Multiple recipients of list
While fault tolerance is certainly one of the features of RAC,
it isn't correct to say that it is not also for scalability.
Buy a bigger box? That works fine until you're in the biggest
box you can get, then what? I realize that it's a small market
segment that requires that kind of hardware,
..sounds like a IPC problem.
Check ora network and listener config.
relink client
relink utilities
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
No, There is no log generated. Below is the only
Title: Message
I'm
very interested in finding out how will you import LOB's, Java classes, function
based indexes, IOTand ADT objects into V7 database,
especially if it is V7.1 and not 7.3.4 or 7.3.5. Please, keep us
posted.
--Mladen GogalaOracle DBA
-Original Message-From:
A quick update. Having multiple ORA-600 errors thrown at me randomly when I
try to do a select from any of the V$ tables. Not always. 3 out of 5
attempts spew out ORA-600's and while this is in progress, the database
freezes for a few seconds. Oracle Support says its coz of the
Hi,
When you are restoring from a cold backup
you dont have to recover and your database will be old.
If you want to bring it to current time
then recreate the control file and recover it using RECOVER DATABASE
USING BACKUP CONTROLFILE UNTIL CANCEL; this will ask you for archive
and SPFILE Autobackup at
07-AUG-03piece
handle=D:\BACKUP\ORACLE\HOTBACKUP\CF_C-1770609602-20030807-02.BAK
comment=NONEFinished Control File and SPFILE Autobackup at
07-AUG-03
RMAN
Thanks in
Advance,
Scott Stefick
MILPDS OCP Oracle
DBA [EMAIL PROTECTED]
Announcing my new book... How to Gain Professional Wisdom and Become an
Oracle Sage in Just 24 Hours.
-Original Message-
Sent: Wednesday, August 06, 2003 4:59 AM
To: Multiple recipients of list ORACLE-L
I stumbled by chance into the following article
Title: RE: ora-600 when analyzing IOT
Only missing data in *_TABLES is avg_row_len which, probably, can be used for estimating hash area for hash join.
Also, columns statistics will not be generated, probably more important.
Alex.
-Original Message-
Does it mean, that if I don't
Hi!
This is troubleshooting, not performance tuning ;)
As far as Ixora states, v$sesstat opened cursors current shows PL/SQL
cached cursors as well, even when they are explicitly closed (assuming that
session_cached_cursors is set).
But v$open_cursor doesn't show the number of cursor structures
There were discussions about this before. You can
search the archive for it. v$open_cursor and the statistic
opened cursor current doesn't always agree.
v$open_cursor show cursors parsed and not closed, while
the opened cursor current shows cursors opened and not closed.
v$open_cursor doesn't
Ryan,
Yes it is, as long you limit the results based on SID. The same goes for
v$open_cursor.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 08, 2003 1:54 AM
really? I thought v$sesstat was session based statistics?
Title: RE: ** is there PL/SQL for case
You are wrong ... SQL is NOT a subset of PL/SQL ...
declare
szVar varchar2(50);
begin
SELECT CASE WHEN state = 'CA' THEN 'Almost Bankrupt'
WHEN state = 'CT' THEN 'Ridiculously High Tax Rates for no particular reason'
WHEN state = 'PA' THEN 'We
Hi All,
One of our developer ftp'ed the export (dmp) file from UNIX to NT in ASCII
mode. He didn't know that it supposed to be done in BINARY mode. Now, he
ftp'ed the dmp file back to UNIX in ASCII mode and tried doing the import.
Looks like dmp file has been corrupted and Import is giving
Below
is an example (with Oracle 8173),"case" works in sql, not in
pl/sql.
Guang
[EMAIL PROTECTED] create table
t1 (name varchar2(30), salary number );Table
created.[EMAIL PROTECTED] insert into t1
(name,salary) values ('Bill', 1000);1 row
created.[EMAIL PROTECTED] insert into t1
Title: Message
Tell them ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
really? I thought v$sesstat was session based statistics?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 5:39 PM
I should have known to check Steve's site first (is he still lurking
around
here?).
One thing I noticed
Title: RE: last column in a table is added with a DEFAULT
as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value.
Raj
Rajendra
RTFM on DECODE:
DECODE(state, 1, CA, 2, OR,
3, WA, 4, AR)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of A
Joshi
Sent: Thursday, August 07, 2003 3:24
PM
To: Multiple recipients of list
Tim,
How about this?
Table Doc_Types
Doc_Type_IDNumberPK
,Doc_Type_Descr VarChar2(100)
Table Doc_Attributes
Doc_Attrib_ID NumberPK
,Doc_Attrib_Descr VarChar2(100)
Table Doc_Type_Attributes (Intersect table of the above
Hi,
I got this error when I run my procedure:
!-- SQL ERROR:ORA-00600: internal error code, arguments: [15212], [1], [],
[], [], [], [], [] --
Errors in file /ora817/app/oracle/admin/ORCL/udump/orcl_ora_4345.trc
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15212],
I don't mean to be argumentative, but every time I see assertions like
these, I suspect someone has been reading some rather discredited books...
So, my apologies in advance, but comments are inline below...
In my experience, spreading datafiles across volumes (specially if you are
careful
I am not sure but based on the definition of an IOT I would think you would
have to ANALYZE TABLE since the primary key data is not duplicated in
a separate index.
Rick
Starting with Oracle9i, PL/SQL
supports the use of case statements
Title: RE: last column in a table is added with a DEFAULT
David,
Nope. Your programmer is wrong.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Ehresmann, David
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 3:09
PMTo: Multiple recipients of
31 matches
Mail list logo