 | | | Oracle List | | Hi List
Does anybody know where to download this ASM library ?
I don 't see version for above mentioned kernel on
http //www.oracle.com/technology/software/tech/linux/asmlib/rhel3.html.
--
Regards Hi listers
Perhaps someone can explain this behavior. I move partition of a table using
alter table <owner >. <table > move partition <partition > tablespace
<tablespace > parallel 8 nologging
OracleHi All
So this means that in the statspack reports CTAS is not listed among the top SQL statements even if it could have been one on the top sql statements !!!
Regards
Joseph > We have been having severe performance problem with Oracle Apps 11i.10.2
> core modules running on servlets. We are also noticing hiccups which hang
> the user sessions for 40-60seconds.
>
> ForOracle Secure Backup released 3 days ago ...
Raj
On 4/28/06 Ray Stell <stellr@(protected) > wrote
> Someone at IOUG said that Oracle Corp had announced a product
> that could be used to replace theTom
You may be missing a couple things.
As Jared has pointed out it is the the OTN development license that is
ineligible for support. The software is *identical* to that which comes off
thWe have 2 SRs currently open for this same issue and
ever since we set the param to FALSE we haven 't seen
the issue repeat (so yes it 's mutex related). We saw
a case where 1 session blocks anotheI 'm guessing this is a table issue not a SQL Loader issue. For example
could you insert this number directly into the table via SQL*Plus?
Try setting NLS_NUMERIC_CHARACTERS " . " and retrying the Bertrand
Okay to put it into simple terms
- You currently do the batch task during off-hours and now you are being
asked to move the task to the times when the database is busy?
- Most of We are using this in 9.0.2.7 and it is working great! You can use it in a
trial basis before you purchase the license. That is what we did. If it
works for you then you can purchase the product if
I agree with the other members who responded that probably it 's just a
case of SMON having to do a lot of work - and not using old-school
tablespace types. There is one other possibility perhaps TYou can query on v$session_event or v$system_event and find out which event is taking the most time and then try to reduce the time spent on that event.
regards
Joseph
BN <bnsarma@(protected)I am hitting ora-31202 Size limit exceeded error when walking the
whole tree. I need all records (few thousand) and you get this error
if you try to retrieve more than 1000 entries at a time it seems.I ran into a problem yesterday with NLS parameters.
(Below is the problem and remedial steps thus far.)
I 've only had this machine a few weeks. I 'm using
Windows XP. When it was originally set up
On 04/27/2006 11 24 41 AM Shreeni wrote
> Hi List
>
> I have a semantic question in a DWH environment. At the current place I
> work the tables have been de-normalized to such an extent that theThere 's another reason that you can 't (or don 't want to) open the database
on the backup server -- you would have to license Oracle there. In saying
this I 'm assuming you 're doing more than 10 backuHello Gurus
Environment 10.1.0.4
OS Solaris 9 (Sunfire V440)
Was casually checking process listing of oracle id and found a lot (about
70-80 processes) of <defunct > processes and most of these pRegarding function based indexes.
Is this feature documented or am I hitting a bug see bellow
Example
Create table T (n number)
Insert into T values (1)
--This is Function-based index
creatDon 't know whether you can find it somehow for all run but for each
individual table and index you can look at sample_size vs num_rows.
Gints
2006/4/27 arul kumar <arul76_2000@(protected) >
> All
>Hi Arul
Try selecting sample_size / num_rows from dba_tables.
@ Regards
@ Steve Adams
@ http //www.ixora.com.au/ - For DBAs
@ http //www.christianity.net.au/ - For all
arul kumaI recently set up Oracle Management Server on a server in order to
switch to the full 3-tier mode of Enterprise Manager after years of
using it in stand-alone mode. The version of Oracle we 're usingThere were two questions.
Can we leave the event in place?
If we set the tablespaces to read write will we be able to change them
back to read only?
Database is 8.1.6 on Solaris 5.8(Pretty sure).
Another thing to watch out for in this scenario is database triggers. (This
is a common situation in Oracle Forms shops where the default behavior of
forms is to update all of the selected database From what I can recall...
You must be using a character set that supports the currency symbol in
question. The default (I think) is US7ASCII - which is not helpful. Try
using something like
WE8ISO
On 04/26/2006 03 12 59 PM genegurevich@(protected) wrote
> All
>
> This is probably an easy question but I 'm having problem with it.
There were some problems with switching to oppositeThere are lots of ways to do this -- some supported most not.
The supported ways basically amount to one of
- CREATE PFILE ... FROM SPFILE
- ALTER SYSTEM SET xxxx yyyyyyyy SCOPE SPFILE
I
Hi Jonathan I think you missed a couple of bits out of your article
about the DBA with 15 minutes to get through the todo list
<BEGIN HUMOUR >
It 's 11 45 and you need to be done by 12 00 so ...
Indeed Ruth
In Yosemite you are always at risk from something coming up behind you
and biting you on the ass !!!
-)
-----OriginaHi all I 'm working with sql stored procedure and I created these one
CREATE OR REPLACE PROCEDURE today (tbl_name IN VARCHAR2 old_key IN NUMBER) AS
loop_count NUMBER
BEGIN
SELECT COUNT(*) INTO lDave
If you are applying the Apr security patch Metalink states that the patch for 10.2.0.2 will not be available untile May 1 - you might be trying to apply the patch for 10.2.0.1. I am in the s |
|
|
