on 8.1.7.3.0 under
Win2k.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, April 26, 2002 1:18 AM
Yes!
Jack C. ApplewhiteDatabase
Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent:
, so we've not needed it. However, like any kind
of insurance (e.g., backups), as long as it doesn't cost too much, aren't
you glad to pay to leave it unused? ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin
Rakesh,
Yes. You can certainly export a single partition at a time for logical
backups. If you put each partition in its own tablespace, you can
physically back up individual partions as well.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
Cool! A PL/SQL procedure that responds to your every wish! I want one of
those too!
Seriously Gilbert, be a bit more specific about your desirements.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
it that way so it's more obvious what my intent is.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
David M
Sent: Monday, April 01
Seema,
Probably Last_DDL_Time in DBA_Objects, though that just tells you the last
time any DDL was executed on the object.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
Ron,
The easiest way to do that is use the Oracle Net8 Configuration Assistant.
It's under Programs/Oracle - OraHomeYour8iHome/Network Administration and
a snap to use.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc
User_Refresh
;
You need to do a little reading in the Oracle SQL Reference under Datatypes
to find out details of the Date datatype and Date arithmetic.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
Seema,
What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time in
DBA_Objects *does* show when an Index last had an Alter Index xxx
Rebuild executed against it. I just now tested to verify that.
Jack
Jack C. Applewhite
Database Administrator/Developer
. If you make
the Java developers aware of these issues up front, maybe they'll go ahead
and learn how to code it right initially.
Sorry I can't give details, 'cause all I know about Java is how to spell it!
;-)
Jack
Jack C. Applewhite
Database Administrator
that returns that value and takes :b1 - :b9 as input arguments
could be tuned to be faster. It could be used in the SQL Select. Check out
the docs for the use of stored functions in SQL statements.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
with the RowIDs of the rows that
violate the Check. See the Constraint_Clause section of the SQL Reference
for details.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327
is equivalent to a Shutdown
Abort?
Try increasing ORA_sid_SHUTDOWN_TIMEOUT and see what happens.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original
Jared,
Thanks for the links. However, we should be wary since the document at the
end of the first link states (near the bottom) 1000 microseconds make one
second!
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin
. and references to papers on
the MS site. I went through that investigation a while back, but the exact
details have left my brain cell. ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
processes releases that memory and is an OK workaround.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Eskridge
Sent: Wednesday
Title: Standby Database Problem
Hussain,
As long as none of your datafiles were corrupted by
what I assume was the crash of your Standby Instance, you can reinstall 8i and
bring up the Standby just as you describe. The datafiles don't care at all
where Oracle Home is.
Irecently had to
Ayyappan,
You can use the procedures in DBMS_APPLICATION_INFO to publish and
interrogate the states and actions of modules.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Bill
Sent: Tuesday, March 19, 2002 7:58 AM
To: Multiple recipients of list ORACLE-L
Hi,
Is there a way
Antonio,
We use LMTs for all tablespaces - except for System, of course. No issues,
problems, etc. We're happy.
8.1.7.2.5 on Win2k; ~340GB in 29 tablespaces.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin
Big
Planet,
Whoa,
now there's a can of worms!
In a
word - no. Not unless you pass that info. in as an
argument.
Think
about what you're asking. Since PL/SQL procedures can be called from, not
only other PL/SQL procedures and functions, but the SQL*Plus command line, ODBC
calls, Java
Ouch! Looks like I need to RTFM, not only before asking a question, but
before answering one - shoot from the hip = shot in the foot. 8-(
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
(for cold backups, for instance), do
it right before shutdown.
It's just a quick thought...which I probably absorbed from someone else's
posting on this very valuable list. ;-) If so, then my thanks to the
originator.
Jack
Jack C. Applewhite
Database Administrator
Ayyapps,
Use the DBMS_SPACE_ADMIN supplied PL/SQL package.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED
recommendation is to have one or a few standard extent sizes in
locally-managed tablespaces.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message
that knowledgeable, so who
cares if they're happy?!?! ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Singh
Sent: Thursday, March 07, 2002 11
/imported.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Singh
Sent: Thursday, March 07, 2002 10:18 AM
To: Multiple recipients
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Wednesday, March 06, 2002 1:29 PM
To: Multiple recipients of list ORACLE-L
Hi
Our
block can belong to one and only one
Extent.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED]
Sent: Monday
Rodd,
Oracle8i
Reference
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
:20 2002
Restarting dead background process SNP3
SNP3 started with pid=11
...
---
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327
Plan reports is purely relative and can't be
used for comparison across different queries.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original
. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services
Andrey,
You can't make a PL/SQL variable value visible to all sessions.
You'll have to put the value in a row in a table and commit it.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
the latest version of PKZip?
Command line PKZip would be my first choice.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Worley
)
I think I've learned about as much as if I'd sat in a bunch of classes - and
saved a pile of money. ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
Shibu,
Go
to
http://www.orapub.com
Craig
Shallahamer is THE Guru on the subject. I took his course a couple years
ago - excellent!
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Texaswww.iNetProfit.com[EMAIL
Lance,
Truncate Table YourTableHere ;
This deletes all the rows in the table without the cost of rollback.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327
-friendly interface
for the query operators, you need N programmers (and DBAs) writing M lines
of code - in our case Cold Fusion, Java, and PL/SQL.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
available.
BTW, it didn't hurt that I spread the datafiles of the tablespaces that hold
the DR$$X segments across 2 drives, instead of just 1. That boosted
re-syncs from 600 CLOBs per minute to 750. I/O distribution never hurts.
Jack
Jack C. Applewhite
Database
segments are in
yet another tablespace.
BTW, we have about 15 million CLOB documents, so we're not talking a tiny
amount of data here.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
, it doesn't write to the online redo logs - it waits until
it's reading from DR$$X segment before it writes to the redo logs. I
wonder why it doesn't do the writes to redo in parallel with the writes to
DR$$X.
Thanks.
Jack
Jack C. Applewhite
Database Administrator
. interMedia
even supports section searching, so you can search only between selected
tags within a CLOB.
Check out the interMedia Text docs. It's even available in Standard
Edition. You (and your users) will love it.
Jack
Jack C. Applewhite
Database Administrator
Title: Message
Jerry,
If
they want to pay you to reduce their extents, then let 'em!
;-) "A fool and his money are soon
parted."
If
they employ youand want you to work weekends on this, then it's worth the
effort to educate them. I'm surprised an official Oracle white paper
didn't
The latter.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Wednesday, January 16, 2002 3:07 PM
To: Multiple recipients
access to table partitions automatically - your code does
not have to be modified.
I was attempting to answer your question in a succinct manner - sorry for
not being clear enough.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc
.
---
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Wilton
Sent: Friday, January 04, 2002 2:10 PM
To: Multiple recipients of list
works nicely - it was a dog (in my
limited trials) on 8.1.6.
Our DB is spread across about 340GB of datafiles on 20 disks, so there's a
significant amount of data.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City
Ramon,
You've
declared the Procedure SELECCIONAR differently in the package spec and
body. Oracle must think you're creating an overloaded procedure with
different arguments for each version. The spec and body declarations must
match.
Jack
Jack C.
Seema,
Several possible solutions - you pick.
- Delete Data
- Drop Tables
- Drop Indexes
- Drop Tablespaces
That ought to get you started. ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
trivia
absolutely WON'T.
Respectfully,
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Friday, December 07, 2001 8:20 AM
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
WILLIAMS
Sent: Friday, December 07, 2001 10:40 AM
To: Multiple recipients of list
Group By MyColumn
Having Count(*) 1
)
;
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Thursday, December 06, 2001 3:34 PM
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
JAMES W [IT/1000]
Sent: Thursday, December 06, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Begin Backup command and get instantaneous results -
which I had to do recently to restore some datafiles to the Standby after
one of its disks failed. I wonder why you get such slow response?
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
logs, as well as backup
control files, and you've got it covered. Oh, and don't back up your online
redo logs - they'll be worthless for a recovery and can cause you grief if
you restore them over your current, good, ones.
Jack
Jack C. Applewhite
Database
Ken,
Check the Loader log file. The records are being rejected for some reason
and Loader only tells you in the log.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED
Sunil,
If there are multiple
duplicates foreven a few SKU_Num values, you're doing multiple scans (full
table or full index) to get all the dups out. You might reconstruct the
SQL to not use a looping construct if there are lots of duplicate rows for each
SKU_Num
Delete From
FMS_Test
Title: rman disk channel destination
Lisa,
You
specify the destination directory with the FORMAT keyword, by which you both
format the backup piece files and specify their destination.
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8
Title: svrmgrl and W2k
Lisa,
I'm
running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time
via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl
using internal@test or internal@dev. Works just fine.Am I
missing part of the problem?
Jack
FGAC and Application Context successfully to enforce complex
security, but the more I think about it, you could really do some fiendish
tricks with it - if you were the fiendish kind. ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
currently on 8.1.6.0.0 under Win2k) and I'm
hoping the problem will just go away.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2001 4:37 PM
To: Multiple recipients of list ORACLE-L
Does
to
implement FGAC properly.
Both worked very nicely for me - at least in 8.1.6.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent
to recompile...
Alter Function x Compile ;
Alter Package x Compile ;
Alter Package x Compile Body ;
...
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327
Samir,
interMedia Text, Audio, Image, Video? What version of Oracle? What
platform? We need more info.
We use interMedia Text heavily (Oracle 8.1.6 on Win2k) and I've never seen
the ctxhx process.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
words are. I have also
tried Metalink and could not find a definitive list.
Any help would be appreciated.
Dave Leach
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
Narender,
Transportable Tablespaces might allow you to load data in an offline
instance then quickly plug in the new data to the production instance.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Kendall
Sent: Thursday, October 04, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Hello all,
Although I
do now.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Thursday, October 04, 2001 5:36 PM
To: Multiple recipients of list
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, October 02, 2001 12:15 PM
To: Multiple recipients
arguments to your public cursors
and specifying that they return Table%RowType records. That further
isolates your code from table changes.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
Title: RE: Physical access to servers for maintenance
Me
too. We've got our 4 Production Win2k servers (2 Oracle8i servers, 2
Webservers) at a colocation facility and have used either PCAnywhere or Terminal
Services to access them over the Internet for the last 9
months.
The
developers
= Re-Enabled_PK_Name
;
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Singh
Sent: Wednesday, September 26, 2001 11:40 AM
, then, it is a question pulling all the records with
the surrogation key + (all the generation numbers).
Thanks,
Rao
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
David,
I've
used Designer (and Oracle*CASE before it) for about 10 years now. I've
always used it for logical data modelling and physical database
implementation. In my Developer past, I've done a ton of Oracle Forms and
Reports generation from Designer, as well as Web Server Generator
or Group By Code1,Code2,Date? In
other words, do you want just one resultant row representing the aggregate
of all rows with Date InputDate, or a resultant row for every Date?
We need more info.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8
Jeffrey,
What version(s) of Oracle? Are you
using RMan?
We use Veritas NetBackup Data Center 3.4GA because our colocation facility
supplies it. We run Oracle8i 8.1.6 under
Win2k (dual 500MHz CPUs, 2GB RAM) and see in the neighborhood of 300MB/min (
about 200GB of backup in about 10 hrs),
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Applewhite
Sent: Wednesday, September 12, 2001 7:40 PM
To: Multiple recipients of list ORACLE-L
Hi,
8.1.6.0.0
Andrea,
Search for the file outlook.pst. That's the single file in which Outlook
stores all emails, notes, addresses, everything. It's a pain, but what do
you expect from Micros**t.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
. WinNT DB.
Has anyone else experienced this? I'm rebuilding the index now (for the 2nd
time this week! - takes 7.25 hours) and want to know if this fix will work.
Thanks for any advice or suggestions.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
BigP,
You
could have an If Then ElsIf...Else statement that tested the input arguments of
interest (looks like p_loginid and p_firstname), each part having an appropriate
Select that did not use NVL if that input argument was Not Null. In
essence, you'd be tailoring your Ref Cursor to the
Girls there knew how to Jitterbug.
However, all in all, it wasn't worth the trip. That was my last OOW.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Friday, September 07, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
I don't have an NT database
Anjan,
Look
in Oracle_Home/RDBMS/admin for the dbmsrand.sql file. The package is
better documented there, at least for the 8.1.6 release.
I used
it last year to generate a Session ID for a Web-accessible application to
maintain state across a User's multiple page hits.
Jack
Title: Stored Procedure Performance Problem --- Please Help
Viral,
Are
you saying your entire database is on one 13GB drive? If so, it's no
wonder this operation takes a very long time - you're I/O bound in a big
way! The inserts and updates of tables and indexes, not to mention disk
sorts
) for Windows. There you'll also find out other goodies, like how to
set up for the instance to Shutdown Immediate when the server is shutdown.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
Rob
(Jo?),
This
is from the Oracle8i docs (Chapter 5 of "Oracle8i Standby Database Concepts and
Administration"), but it's so basic that I believe it would apply to
8.0
...
9.Write a script that you can periodically run to check
the log files in the managed recovery directory and
move
You're dang right it's an no-brainer! ;-)
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday
happen, then each Oracle process would indeed
correspond to an Oracle database.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message
Paul,
For acouple of projects that I've
worked on, several Java programmers have liked having Ref Cursors returned from
PL/SQL stored procedures. They could work with those much more easily than
PL/SQL tables.
Can't remember if we even tried VArrays. I
don't think I'd like them for
in the Create
Table command.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
T (Richard)
Sent: Monday, August 13, 2001 12:50 PM
?
Thanks.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, August 06, 2001 2:24 PM
To: Multiple
uses a customized
version of the view. It's a handy technique!
BTW, create the variable with a default value (Null or some real value)
such that the view will work as desired even if the variable is not
explicitly assigned a value.
Jack
Jack C. Applewhite
Database
Saurabh,
Check out the DBMS_LOB package. There are lots of
procedures and functions for manipulating BLOBs and
CLOBs.
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Texaswww.iNetProfit.com[EMAIL
index is not
maintained. Check out the docs on IOTs.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Tuesday, July 24, 2001 8
Joe,
The Oracle-supplied "Oracle8i
Recovery Manager User's Guide and Reference" has served me
well.
I'd advise experimenting with
the various backup and recovery options and RMan commands on a little test DB to
get the hang of it. RMan works very nicely. It's been much more
reliable than
Schema), plus all the usual default schemas like ctxsys/ctxsys...
Needless to say, I closed those holes pretty quickly!
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512
1 - 100 of 170 matches
Mail list logo