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 gkittelson 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. solara

    Performance of a query

    angiole, Read the sql statement first.
  2. solara

    How to drop an ARCHIVED-LOG file.

    Hi madhes, What are you trying to do? What view are you accessing the log file from? and what is their relationship i.e between the view and the arc log files. Olu
  3. solara

    Performance of a query

    Hi, What you should realise is that delete will always take longer time and it use a lot of resouces. Tell your DBA to make avaliable a new Huge rollback seg that will handle what your are doing. Also ask for the rollback tablespace intial extent and next extent to be eg 100MB max unlimited...
  4. solara

    How to drop an ARCHIVED-LOG file.

    Hi, Karluk has supplied you the very answer to solve the problem. But don't delete all. It should work but make sure you backup before deleting and also you can leave up to 4 to 5 days worth of log. Solara

Part and Inventory Search

Back
Top