basis_consultant's articles:

Items(42) /5 Next >> Last >|

Index Information used_space and dba_segments 3 5 (4/29/2013 3:24:19 PM) comp.databases.oracle.server Hi, In Oracle 11g, I analyzed an index and checked index_stats. dba_segments indicates that the size of an index was about 420MB. used_space in index_stats indicated that the index used about 30MB, an... basis_consultant

Maximum Usage of Temp Tablespaces Since Database Started 6 73 (7/23/2012 2:34:01 PM) comp.databases.oracle.server Hi, We are running a large ERP system on Oracle 10g (I know that we should not be on 10g-Will be upgrading to Oracle 11 soon). There are 6 temporary tablespaces with a size of 16GB each. Is there any... basis_consultant

On 5.10, limit resources of processes of specific users without zones? 4 52 (7/11/2012 3:37:55 PM) comp.unix.solaris Hi, On a powerful 5.10 server that is not setup with zones, we are looking to limit the maximum amount of resources (Mainly CPU) taken up by all processes of 2 specific userids (Say, to 50% or 60% of the ... basis_consultant

ORA-01031 Errors in Oracle Client for Third-Party Application 2 44 (7/4/2012 8:38:00 PM) comp.databases.oracle.server Hi, I installed a third party application in a Windows 7 server. That application uses a corporate Oracle 11 database. On the Windows server, as per the recommendation of the vendor's application, I i... basis_consultant

csh: Execute Unix program at 15 minute intervals From External Source 1 66 (9/30/2011 6:37:47 PM) comp.unix.programmer Hi, We are running SAP/Oracle on Solaris 5.10. SAP can be setup to run Unix commands on csh. If possible, we would like to trigger a Unix script from SAP that will execute another command on the hour, 15 minu... basis_consultant

Combining Two Text Files in Bourne Shell 2 186 (5/17/2011 3:51:27 PM) comp.unix.solaris Hi, In Solarix 5.9, Bourne shell, I would like to combine 2 text files on a common key. Any ideas will be greatly appreciated. The files as follows: File1 has 2 fields KEY1 and TEXT1 (Text1 has spacing) File... basis_consultant

Set MSSQL 2005 to Favor Returning First Rows of a Query 2 41 (9/23/2010 1:28:22 PM) comp.databases.ms-sqlserver Hi, I am not sure whether I am posting to the correct group; If not, please tell me which groups are better. My experience has been mainly with Oracle. In Oracle (9i+) there is an optimizer mode name FIRST_RO... basis_consultant

Why Increase PermSize and MaxPermSize Crashes VM? 1 256 (8/8/2008 9:55:02 PM) comp.lang.java.machine Hi, Please tell me if I am posting to the wrong group.. We are running a SAP Portal/Oracle system in Win2003 on Sun JDK 1.4.2_17. We have 2 servers, with the following JDK parameters: -XX:MaxNewSize... basis_consultant

Detecting Heap Memory Leaks/Displaying Memory Maps on JDK 1.4.2_17 0 157 (7/30/2008 6:18:02 PM) comp.lang.java.gui Hi, Is there a way, on Sun JDK 1.4.2_17 (Or a later version of JDK 1.4.2) on Win2003, of displaying the classes in the heap memory, along with how much memory they use, without installing any utilities? (I do... basis_consultant

SAP Script and 'Find' Miss Text File in Link 1 111 (6/25/2008 5:47:50 PM) comp.unix.solaris Hi, We are running an SAP Portal on v5.9. Our filesystem is setup as follows: There is a directory name /usr/sap/SID/JC00 which has a few subdirectories. One of them, named SDM, is a link to another directory... basis_consultant

basis_consultant's replies:

Items(10) /1

Sun SDK v1.3.1_09 '..javaw.exe ' command hangs on Win2000 MSSQL/SAP Install 2 46 (11/13/2003 9:05:03 PM) comp.lang.java.programmer Hello, As somebody much more knowledgeable about SAP than Java, I have the following question.. In order to Install SQL Server 2000 SP#3 on Win2000 SP#4 with the latest version of SAP R/3, I had (to As per S... basis_consultant (53)

Query Runs Much Longer in 9i than in 8i 4 50 (12/23/2003 5:22:27 PM) comp.databases.oracle.server Hi, We migrated parts of an 8i database to 9i, as a test. The OS is AIX v5.2. We did so by creating a new 9i instance and then exporting and importing selected data. The test worked; all of the necessary dat... basis_consultant (53)

Information on Reorganizing Large Tables on 8i and 9i 5 40 (4/5/2004 6:52:33 PM) comp.databases.oracle.server Hello, Thanks to all those who took the time to answer my previous question regarding the rebuilding of online indexes. I have reorganized small and medium sized tables (Say, up to 500MS or so) in Oracle 7.x... basis_consultant (53)

History of Oracle 10g 6 43 (11/4/2004 10:16:32 PM) comp.databases.oracle.server Hello, Thanks to the folks who answered my question regarding moving a system datafile. I searched (Both google and Oracle's Website) for a document describing the history of Oracle 10g (When it was first r... basis_consultant (53)

Copying v8.1.5 NT Database to 10g Win2003 Server? 5 39 (11/29/2004 10:36:39 PM) comp.databases.oracle.server Hello, I installed Oracle 10g on Win2003. I created a database with the same name (Say TEST) as a v8.1.5/NT database on another server. I used a similar init.ora for both databases, though I had to adapt some ... basis_consultant (53)

lsnrctl on Win2003 Not Picking Up listener.ora file 3 48 (12/6/2004 11:22:14 PM) comp.databases.oracle.server Hi, On 10g Win2003, listener.ora, sqlnet.ora (Which is blank), and tnsnames.ora in $ORACLE_HOME/network/admin are fine, as they worked for a couple of weeks, and the Oracle clients were able to access the data... basis_consultant (53)

How to Check Whether Tables Have Updated Statistics? 7 70 (2/25/2005 6:04:46 PM) comp.sys.ibm.as400.misc Hi, As a Newbie coming from an Oracle world..How would I check whether certain tables which are being frequently accessed have updated statistics? How would I check for the last time they were reorganized, or ... basis_consultant (53)

Why Error-04063 in Queue Table QS.WS_ORDERS_SQTAB? 4 38 (5/17/2005 2:08:14 PM) comp.databases.oracle.server Hi, We installed a standard 9.2.0.6 database on Windows 2000. It was a standard installation, with the possible exception that the demo tables were installed. However, when we tried exporting some schemas yes... basis_consultant (53)

ORA-01031 Errors in Oracle Client for Third-Party Application 2 44 (7/4/2012 8:38:00 PM) comp.databases.oracle.server Hi, I installed a third party application in a Windows 7 server. That application uses a corporate Oracle 11 database. On the Windows server, as per the recommendation of the vendor's application, I i... basis_consultant (53)

On 5.10, limit resources of processes of specific users without zones? 4 52 (7/11/2012 3:37:55 PM) comp.unix.solaris Hi, On a powerful 5.10 server that is not setup with zones, we are looking to limit the maximum amount of resources (Mainly CPU) taken up by all processes of 2 specific userids (Say, to 50% or 60% of the ... basis_consultant (53)