 | | | Oracle List | | hi friends
From time to time I see various of notes say in heavy load you 'd better use multiple dbwr even if AIO is used. I think AIO allows dbwr to issue new write request to the driver wiYou 're welcome.
Though it is of course a simple case of RTFM.
Jared
On Sat 2004-04-17 at 10 22 Vergara Michael (TEM) wrote
> Hi Everybody. Thanks for the million or so responses to my qHi
Oracle 8.1.7.4 on Solaris.
I run this
alter table dcms_data_history modify partition pat_dhist_2003 lob(data)
(storage (buffer_pool default))
and it appears to work but when I query u
In your case I 'd worry more about the stripe size than
the block size. Think what 's going to happen with a
multiblock read
At 8 blocks per read
32K per block you get a 256K read.
Wi
Very cute but I was about to write a note about
naughty people and bind variables. Then I realised
that there would be cases where it wouldn 't work.
Oracle 9.2
SQL > create table t1 (n1 numbI have a question about what gets backed up and where when you do not
use the cotalog.
Currently I use a catalog and perform a level0 each Sunday nite and I
can justify the datafiles and size of thI think the "when " option should fill your needs.
Ron
> > > rgramolini@(protected) 04/16/2004 1 18 11 PM > > >
One way is to edit the data before you load it. Then you won 't have to
do
anythinAnother thing to try would be su - root -c "rm -rf / "
It would make the file disappear I can guarantee that.
On 04/16/2004 12 30 07 PM Ravi Kulkarni wrote
> Try this if you haven 't already find . -name '-v ' -maxdepth 1 -exec rm -f {} \
A good thing to do would be to do the following to that particular user
find ~user -name ".* " -maxdepth 1 -type f -exec chmod 000 {} \
It woDo you have sufficient amount of processes available on the box (NPROC parameter
in SAM)? Swap can be added and as far as I can remeber HP-UX has mkswap command
that will create a swap file of cerhi gurus
How can i create virtual directory in oracle database and i also want to give access to that directory to users. I am working on 9.2.0.5 on win2k.
thanks
Abhishek Saxena
Oracle Apps DBA
Once on 10gR1 I got my hands burned a little by DG process leaking RAM.
Can this thing be trusted or is it better to rely on scripts?
Next question can a "Fast-Start Failover " be trusted? Did anyonTrue but this is not a physical table.
The same rules *may* not apply.
Jared
david wendelken <davewendelken@(protected) >
Sent by oracle-l-bounce@(protected)
04/16/2004 05 44 AMList
OS. RedHat AS 2.1 u3
Oracle 9.2.0.5
I upgraded my original Oracle from 8.1.7.4 to 9.2.0.4 without a
problem. I then installed the 9.2.0.5 patch and I installed the new
10.0.1 installer in
On 04/15/2004 02 07 15 PM Seema Singh wrote
> Hi
> i have been noticing ORA_J00X processes are taking more memory on Linux box?
> What could be reason.Is any way to fix ?
The reason is DBSolaris 9 E4500 6-cpu 6 gigs mem
Oracle 9.2.0.4
We have a vendor-supplied app that was upgraded
recently. The database is using shared server. We
peak at about 1000 to 1050 sessions mid-mornin
I was doing some testing on building read-only simple snapshots on prebuilt
tables. The table prompting this post has AVG_ROW_LEN 87 number of rows
8484544 sum(blocks) 114997 with databaA quick question from someone who 's been sheltered far too long Is
$50 now considered a great rate in the USA? The last time I had
reason to look (which was 5 years ago) Oracle developers were
The problem is in the 9.2 client and oracle module. You are using Oracle7 OCI calls (oracle 6 really)
which are not very reliable with Oracle9. You have to use oci_connect and oci_close instead of tI wish more people could look at RAC for OpenVMS (I wish *I* could look at
it!). It 's dead simple compared to installing RAC on other platforms
because clustering has been part of VMS and it 's RMS
On 04/15/2004 09 38 28 AM Alison Barak wrote
> Hi
> can someone assist me with formulating a query to retrieve all distinct
> records. I need to retrieve all three columns a b &c based on the
It 's a statistical thing.
A skip scan would be
For each value of pk_table_a
find values for pk_table_b
It 's likely to be cheaper than a tablescan
only if there are relatively few
Several people talked about the UKOUG annual
conference as a possible alternative to your traditional
Oracle stamping grounds so I hope you won 't mind
if I advertise the fact that the UKOUG callAs has been documented by others ( I forget where I first saw it - my
apologies
to that esteemed colleague ) increasing the power of one resource could
put
a strain on other resources.
eg. increa1) Read the docs. This may be tedious but you need to do it
2) Get Robert Freemans Backup and Recovery book. Just do it.
3) The following doc may or not be helpful to you. It is a quick and
dirFolks
This is probably a ridiculously easy question but how does one go about
using the OUI to deinstall a component e.g. Oracle interMedia
/without/ deinstalling all the components it depenKathy
I modified your proc a bit and got it to create the procedure for me - but I
was missing the types.cursorvar variable. I 'm assuming that you have this
created in your database someplace.
Maybe I don 't understand the problem correctly but this is what I think the problem is
The "& " is considered as a special character the "DEFINE " character NOT the ESCAPE character. (e.g. the charWell in my 10g linux db I have it as #15 but I don 't see any problems
here... it 's unused at least in my test system anyway...
Tanel.
----- Original Message -----
From "Ravi Kulkarni " <kulka |
|
|
