Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nassrin5

    V$ view showing objects accessed by a session

    Very useful scripts dbalearner. Thanks
  2. nassrin5

    Update record if exists, otherwise insert a new row

    I am not sure you can merge the same table to itself. With PK constraint the first record goes through and the second record is rejected. So the whole transaction is aborted.
  3. nassrin5

    A very good book on Sybase Transact SQL up to ASE 12.5.2!

    Thanks dbalearner. I have got a copy of Transact SQL Programming Guidelines and it is by far the best Transact SQL practical book I have seen for years.
  4. nassrin5

    Problem with spfile

    Thanks Guru, it worked fine.
  5. nassrin5

    Problem with spfile

    I changed a parameter in Oracle with scope spfile. I had to shutdown Oracle and when I startup I get startup error. How can I sort out the problem. I need to remove the wrong parameter setting from spfile. My problem is that my pfile makes a reference to spfile as follows...
  6. nassrin5

    Retrieving error messages in Oracle

    Thanks Sybaseguru. That was what I needed.
  7. nassrin5

    Retrieving error messages in Oracle

    Can someone tell me how to retrieve error messages including suggested actions in Oracle8 Thanks in advance
  8. nassrin5

    Swap space usage

    Thanks for your explanation sybaseguru and your tip alexhu
  9. nassrin5

    Swap space usage

    What is the optimum size in setting up swap space for Oracle host. Dowe require swap space for Oracle? thks
  10. nassrin5

    How to find out semaphore usages

    Well I got a bit of help from my mate. Someone else may find it useful
  11. nassrin5

    How to find out semaphore usages

    Hi A semaphore is an interprocess communication (IPC) in UNIX. Semaphore is basically is a hardware or software flag used to prevent processes from accessing the same shared memory space at the same time. When a process has control of a shared memory resource, all other processes are locked out...
  12. nassrin5

    How to find out semaphore usages

    Hi, I am finding out about my oracle environment and I want to know the command utility on Solaris 8 to know what semaphores being used. What is a simple description of semaphore. thanks
  13. nassrin5

    PMON processes taking all CPU, why?

    I would be interested in answer to this problem as well. It appears that may be memory swapping going on with 4 Oracle instances
  14. nassrin5

    Oracle 8i Installation Roadblock

    Have you looked at the registary? Try deleting Oracle info from registery and re-installing it again
  15. nassrin5

    Where do I see the value of Maxdatafiles

    That is the best example of a command line utility within Oracle I have seen for a long time as long as I remember the directory path!
  16. nassrin5

    Migrating to 9i, watch dbms_utility.analyze_database

    Hi Sybaseguru, Thanks for the tip. That might explain our current performance problem with Oracle 9i. I will mention it to our DBA to check

Part and Inventory Search

Back
Top