Rahul
Check out http://www.ixora.com.au/tips/max_multiblock_read.htm
Steve Adams mentions "The first trap to be aware of is that Oracle does not
complain about attempts to set the multiblock read count to values that are
larger than the maximum value allowed under the operating system"
Dennis W
That winface article makes a good read.
Thanks!
Patrice.
-Original Message-
Sent: Tuesday, November 12, 2002 7:09 AM
To: Multiple recipients of list ORACLE-L
Firstly, can I say that any NT/2K administrator that feels they need to
install Microsoft Office (or just Outlook), and feels th
Rahul,
I believe there is an O/S maximum setting of this parameter to be 64K (this
covers AIX and HP and and may affect others)
This fits in with your finding so I am sure it is correct
John
-Original Message-
Sent: 12 November 2002 09:11
To: Multiple recipients of list ORACLE-L
list !
Firstly, can I say that any NT/2K administrator that feels they need to
install Microsoft Office (or just Outlook), and feels they need to upgrade
the web browser for a production Oracle database system should be shot on
site! The same goes for things like IIS (Microsoft's integrated "web
server")
This is a multi-part message in MIME format.
--=002_Dragon206281065310_=
Content-Type: text/plain;
charset="GB2312"
Content-Transfer-Encoding: quoted-printable
Hussain Ahmed Qadri=A3=AC=C4=FA=BA=C3=A3=A1
=A1=A1=A1=A1Hi, take a look at what oracle is doing, from v$sql and alert=
l
list,
i'm doing benchmarking using two DB's with different block size
i run a count(*) on a 17 million row table, and compare the sql_trace file
and the v$filestat stats..
the db was bounced before each test, the init.ora params were identical,
EXCEPT
in DB1 (4k block size) the muldiblock read w
Title: Oracle taking 100% CPU
HI all,
We have a development server, a replica of the production. Some process produced a lot of archives and it ran out of archiving space. Now it was the only location specified for the archives and it was mandatory. So when no space was left on it to store t
list !!
my ora7.3.2 instance on AIX with a db_block_size of 4k has a
multi block read count of 16 !!
i thought i would create a new instance with a block size of 8k, so i can
set
the max multiblock read count to more than 16, BUT, after creating the new
instance
the db_multiblock_read_count *al
Hi,
First login as sys user and give command desc dbms_lock.
If it says does not exists then you have to compile it from dbmslock.sql
available in $ORACLE_HOME/rdbms/admin directory.
Regards
Darshan Singh
-Original Message-
Sent: Tuesday, November 12, 2002 7:58 AM
To: Multiple recipients o
dilmohan,
conn / as sysdba
grant execute on sys.dbms_lock to your_user;
and try again.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
=== 2002-11-11 22:58:00 ,you wr
The script /usr/oracle/backup.ksh should have all environment variables
such as ORACLE_HOME, ORACLE_SID, PATH etc defined at the beginning before
you start actual export. To debug the actual cause put logging in the
script log date and time at the start of the script to a file and use log
for exp
> Any clues why this is not working ...
Does the script have the right permissions?
Try:
chmod +x /usr/oracle/backup.ksh
--
/Nils Höglund, Naqua KB
Bioinformatic program designer
E-mail: [EMAIL PROTECTED]
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address
Hello,
How do we create an MDI form in D2k v6/6i ?
Deepa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting ser
101 - 113 of 113 matches
Mail list logo