Re: Best method to move Filesystems to RAW Devices.

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816

Re: Explain plan of a table you do not own

party tool ! Kind Regards, Ing. Patrick Van der Sande Managing Director ANDES Consulting BVBA www.andes-consulting.be = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

RE: Setting Cursor Sharing = Force in 8.1.7.3

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

Re: Library object/cache locks?

). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New DSL Internet Access

RE: Table Scans

for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http

Re: Loading tables from XML files

EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East

Re: Recreate database script

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816

Re: FW: Problem upgrading Oracle 8.1.7 on MS2000

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft

RE: Install: 9i on 2000, TNS Listener service not installed

). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! - Official partner

RE: STATSPACK

want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo

RE: 8.1.7 LMTs Autoallocate vs Uniform Extents

subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see

Lietral

= Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see

Literal SQL and sys.dual

appreciate if you could let me know. Thanks Mohammed Shakir = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing

RE: Literal SQL and sys.dual

. ***1 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir

Re: Literal SQL and sys.dual

. Not to mention saving in CPU processing by not parsing SQL scripts. Anybody, aware of such function in PL/SQL? Is there any other way to do calculations other than 'select 1 + 1 from dual' ? I would really appreciate if you could let me know. Thanks Mohammed Shakir

Re: Literal SQL and sys.dual

gone. Thanks for yours and every one elses response. Your advices are supporting the ideas I have in the back of my mind to do it right. --- Stephane Faroult [EMAIL PROTECTED] wrote: Mohammed Shakir wrote: I am working on a database optimization project. My Shared pool is filled with SQL

RE: Literal SQL and sys.dual

and delete this e-mail message from your computer, Thank you. *2 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

RE: Literal SQL and sys.dual

. ***1 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http

RE: Literal SQL and sys.dual

. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 = Mohammed Shakir

RE: Literal SQL and sys.dual

= Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ

Re: Pl/SQL debug

in advance Roland S ATTACHMENT part 2 application/octet-stream name=newregicapriceroland.sql = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo

RE: Literal SQL and sys.dual

. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Mohammed Shakir [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002

RE: Literal SQL and sys.dual

am back to SQUARE ONE. Thanks however for a great try. Shakir --- Mohammed Shakir [EMAIL PROTECTED] wrote: Thanks so much for your time and effort. Correct code was found in the attachement. It compiles and runs as you described. You found a very innovative way of converting the string

Re: How to tune SQL and CPU usage

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

RE: WHICH UNIX FOR ORACLE?

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

Re: Moving From Rule-Based to Cost-Based

for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http

Re: Insert append generating redo

send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing

Re: UWIN 3.0 and ORA-12560 error

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell

Re: package in sqlarea

entry in sqlarea . TIA Bp = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http

RE: redo_size values in v$sysstat

] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East

RE: ORACLE 9i doesn't start on Linux

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11

Re: insert performance

instances, and the machines themselves are nearly identical (one has 6 CPUs, one 4, but in neither case are the CPUs anywhere near maxed out), what could be causing the discrepancy? PB --- Mohammed Shakir [EMAIL PROTECTED] wrote: data block waits is the indicator of freelists contention

RE: What block size are you using for your new 9i data warehouse?

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

RE: CPU Pegged at 100%

, I will work on it. So check the buffer gets and find out SQL that are doing it and work on them. Shakir = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo

Re: tns error

name it is not succesful and therefor i cant connect help me what should i do to solve this problem and also what i must set up for my jdeveloper thanks artemis zarnegar = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001

Re: Insert is very slow

:53 PM To: Multiple recipients of list ORACLE-L Subject: Which FM??? I'm looking for descriptions of the more cryptic columns in some of the V$'s. Anyone know which FM those are in? TIA Rodd = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East

Re: tkprof plan missing rows

also send the HELP command for other information (like subscribing). ATTACHMENT part 2 application/ms-tnef name=winmail.dat = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

RE: SOFT PARSE RATIO?

command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http

RE: ORACLE TUNING

you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You

RE: Need a delete trigger that tracks deletes.

to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies

Need to customize execution plan for a cross table.

and this should work. However, the query is a view and therefore, I need to look into other possibilities. Any ideas? I am using oracle 8i(64 bits)(81.7.4) on Solaris(2.8). Also using cost based optimizer. = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732

Optimizer tuning parameter not working?

it in my sql session without any change in results. I tried it on NT/Oracle 8.1.7.4.1 I noticed that my execution plans do not change for the following tuning parameters either. 1. Optimizer_index_cost_adj=50 2. Optimizer_max_permutations=7 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East

RE: slowish query causing problems...

part 2 application/octet-stream name=plan_table.csv = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: Excessive SQL*Net message from client waits

problem with the network or sqlnet either. Hope this helps Mohammed Shakir --- Mark Richard [EMAIL PROTECTED] wrote: I think you can relatively safely argue that Oracle is spending 90% of it's time waiting for the client (by that a user pressing a button or the application processing some logic

Re: Any tips to installing Designer 9i?

(like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http

RE: enterprise manager console and sqlplus worksheet can't work

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: passing ref cursor on a procedure

I used the following program to learn bind variables and ref cursor long time ago. This might help. Put this code into a file called getstaff.sql and then run it. Bottom lines show how to declare a cursor and pass it to a procedure using SQL. HTH Mohammed Shakir -- rem filename

RE: query run time vs IN list elements

, because the cost-based optimizer is required to calculate costs for each of the concatenated subqueries. Only thing I would suggest is to remove first Order by Clause if you have any to remove sort step and see if it helps. HTH Mohammed Shakir --- gmei [EMAIL PROTECTED] wrote: RE: query run

RE: StoredProc SQL statistics

Gorman website, and Steve Adams website you could try. HTH Mohammed Shakir --- Cary Millsap [EMAIL PROTECTED] wrote: The information you need is all in the extended (10046 level 8) SQL trace file. You just have to know how to determine all the recursive SQL parent-child relationships. Tkprof

RE: Benchmarking of ASP.NET with Oracle v/s MSSQL

that would put Oracle on the same footing as SQL Server. I have not had a chance to follow up on that. Mohammed Shakir --- Niall Litchfield [EMAIL PROTECTED] wrote: What do you wish to discover? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: Unix root account remote access

! Search - Faster. Easier. Bingo. = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

from this parameter. It sets an instance-wide upper limit for the memory used by sorting, hashing processes. Hope this helps.. - Kirti --- Mohammed Shakir [EMAIL PROTECTED] wrote: I am little confused about this issue to. I am working on Oracle 9.2.0.3 on Solaris 9 (64 bits

RE: End of communication channel

spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick

Re: dropping materialized view

to disable these constraints before dropping your table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot