Re: Performance Issue on 817 !!!

Hi guys Compliments of the new season. We have a database running on Oracle 817 and there are around 4 to 5 applications running there. Initially the platform was Windows NT, service pack 6. Everything was working fine, now recently, the O/S was upgraded to Windows 2000. Then our problems

Re: * Oracle 8i DBA Needed in New York City..

There are many exciting projects on which you would participate including an SAP implementation, CRM applications implementations, and data migrations from other databases to ORACLE.=20 We musn't have the same definition of 'exciting'. -- Diese E-Mail wurde mit http://www.mail-inspector.de

Re: function based index

hi everyone we have a query with several max functions in it. The performance of the query is not so well, can i achieve better performance with function based index on max(columnname)? according the manuals this is not allowed because max is a group function. anyone with a solution for this

Re: Need help rewriting SQL with TRUNC function

I think that the following statement is keeping this application from using an index in my cost-based execution plan. This is an 8.0.4 database so I don't have the option of creating a function-based index. I'm not that great with SQL. Can anyone help me rewrite this statement so that I don't

Re: Re: sys.v_$parameter

There is only one case when you should use V_$something instead of V$SOMETHING, which is when connected as SYS (or INTERNAL) to grant SELECT to a user who needs to create a stored procedure or view involving the said V$something. As Vladimir said, V$xxx is a synonym for V_$xxx, which is a

Re: OFA Question

Is there ANY reason at all not to use spare space on oradata 3,4,6,7 to store other files ? They won't be read or written during times when the database is under load. Cheers GS Can't see any. Regards Stephane Faroult Oriole Corporation -- Diese E-Mail wurde mit

Re: urgent !!

Hi all gurus.. I want to create my database on NT . but svrmgrl gives error of=20 SVRMGR startup nomount pfile=3DD:\oracle\ora816\admin\uybs\inituybs.ora LRM-00109: could not open parameter file = 'D:\oracle\ora816\admin\uybs\inituybs.ora' ORA-01078: failure in processing system parameters

Re: Export and at the same time import via named pipe.

Hi All, Someone mentioned to me today that it is possible do an export and pipe= the output to the oracle import utility to import the data into another database. Does anybody know if this is indeed possible and if so, how and what ar= e the things to be aware of? TIA Jack mkfifo mypipe

Re: OT-Passing variables to a awk/sed script

Hello List, This must be piece of cake for the UNIX gurus. Trying to pass parameters to a simple awk script. Getting stuck.=20 First q., can we do that.=20 If yes I need to solve the foll. problem, In a huge text file locate for abc/xyz and replace it with a supplied = parameter value. This

Re: stupid question about indexes and partitions

htmlDIVOk i have a table range partitioned on date./DIV DIVnbsp;/DIV DIVI have prefixed local indexes also.nbsp; so far so good./DIV DIVnbsp;/DIV DIVI created an index, non partitioned, using simple /DIV DIVnbsp;/DIV DIVcreate index index_name on table(field20);/DIV DIVnbsp;/DIV DIVIs that now

Re: RE: How to prevent oracle from committing a transaction?

Alternatively, you can also use QUIT. Stephane Faroult What you're seeing is an implicit commit !To prevent it - before exiting the session , issue ROLLBACK; then EXIT vikas -Original Message- Sent: Tuesday, June 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Dear DBA

Re: RE: How to prevent oracle from committing a transaction?

Sinardy, I am afraid that you are under a number of misconceptions, and confusing writing to disk and commiting. The former is something physical, and the later more logical, althought it is also accompanied by a physical write. Whenever a disk flush occurs, the 'state' of your transaction

Re: Re: RE: How to prevent oracle from committing a transaction?

] sfaroult@orio le.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc