Tag Info

New answers tagged

0

@user129400 is right - replacing UNDO tbs is a good idea. You can also try: contact Oracle support disable parallel media recovery If you have at least two copies of redo logs you can also check whether they are identical. If not remove one of the copies bypass media recovery completely, start the database, export application schemas and import them into ...


0

Since the problem is in your undo tablespace. You can drop it and create a new one. Steps in this article: http://www.my-whiteboard.com/how-to-drop-and-recreate-oracle-undo-tablespace-and-its-data-files/


0

I have had success in general replacing lengthy IN operations with a join against a temporary table. This makes sense because RDBMS are optimized to perform JOIN's as efficiently as possible, and the handling of lengthy IN lists will most likely be done by repeating the query for every value in the IN list. The performance issue you see could easily be ...


-1

configure the listener using Net Configuration Assistant or delete and recreate the listener with the same name and port


1

You can do this with Soft-NUMA. Here's a Perfmon screen shot from a 4-CPU VM I set up to test using your settings, 2 soft NUMA nodes, 1 CPU to Node 0, 3 CPUs to Node 1. I'm running a CPU intensive query for 20 seconds on node 0, and then the same query on node 2. You can see the CPU activity swap over: I'm running the query via sqlcmd and connecting ...


1

Is there a way to make queries from a database to use only certain core on the host? One way is to use query hint OPTION (MAXDOP 1). The problem with above apporach is that you have to hint everything that you don’t want to be limited by the server-wide setting, or use 0 (i.e. unlimited) for the server-wide setting and hint everything that you do want ...


0

There are two problems here, which must be solved independently. Creating a slave With that size, 100GB, mysqldump is usually to slow too be done efficiently. Try using a binary backup. You have several options: @paul is telling you one, but it has the inconvenient that the master will be locked for the duration of the copy process. Additionally, rsync can ...


0

Do you have log backups or differential backups ? I did not find any information about them in your post. Since(I assume) you do not have transaction log backup point in time recovery is not possible and you cannot recover data changes done after 1 AM. Since your query executed in AUTO COMMIT mode its possible that transaction has committed and changes ...


2

That's called a Major Whoopsie. Assuming you didn't use transactions around the delete you are stuck with scanning the log files and redoing all the INSERT and UPDATE queries. If you don't have a query log then it's manual entry time. If it's any consolation the Government of Alaska had a similar issue a while ago, further compounded by the backup tapes ...


0

A major issue with recreating a database of that size is the indexes. It's going to take a while to index what I assume is rows in the billions. Solution is to copy the indexes along with the data, and that means skipping the dump. It also means skipping the move of >700Gb of data. Here's what you do now: full table read, write to disk (100Gb read, 100Gb ...


4

Would you be OK with having a single table that has these three immutable bookmarks, and then using a view that joins this table with the user's real bookmarks? immutable_bookmarks ------------------- id name URL (or whatever this is a bookmark to) user_bookmarks -------------- id name user_id URL And then define the view as: create ...


1

If the user has: Physical hardware access; Root / "Administrator" access to the system; or PostgreSQL superuser rights; then they effectively have total control and can do whatever they feel like. It's a little trickier when starting with superuser access, but the PostgreSQL superuser is not isolated from the underlying OS user that PostgreSQL its self ...


2

(My apologies for the SQL Server syntax - I don't have MySQL. Please treat as pseudo-code.) A scheme such as the following should work create table DefaultBookmark( TabNumber int not null ,URL nvarchar(2000) not null ) go create table Users( ID int identity not null primary key ,Name nvarchar(200) not null ) go ...


0

I'd say it's all based on the resource consumption (cpu / ram / concurrent disk activity) of each instance, as well as the overall health of the virtualization environment. Virtualization is all about resource queues. If it looks like physical environment might hit a bottleneck based on the cumulative resource consumption of three instances in one VM, it's ...


0

you can disable them via the following command: set GLOBAL event_scheduler=0; or dropping them one by one using the command: DROP EVENT [IF EXISTS] event_name;


0

Please try the below query, REPAIR TABLE 'nagios_servicechecks' Try the above query in terminal or check the below link to repair table or databases via phpmyadmin http://php.about.com/od/mysqladministration/qt/repair_mysql.htm


0

More detail about your environment and which make and version(s) would help greatly to provide a much more clear and accurate answer. I'll be a bad person and assume you're talking about MS SQL Server and provide the following: 1) Perform a trace to gather user and application data. 2) View the following link for a query to gather you the other data you ...



Top 50 recent answers are included