Tag Info

Hot answers tagged

2

Which Database Version do you have? From Oracle 11g onward you should be using the SCAN listener. The SCAN listener knows where the database is located in the RAC and how much load is on that node. Further more you should define services for long ops and short ops for better load balancing.


1

This (old) Oracle document 67137.1 Load Balancing and DESCRIPTION_LISTs1 says the following about the effects of multiple DESCRIPTION elements: When SQL*Net reads a TNS alias with a DESCRIPTION_LIST, it flips a coin to select which description to use to connect. This randomization is what provides us with our Load Balancing feature. It further ...


1

Just from Oracle side there is nothing to worry about. You could even do this operation during normal business hours. BUT! most Applications are not cluster ready. They cannot deal with this situation and will crash. All services are still available since they are migrated to the second node. But the session does not get migrated that's why the client will ...


1

The duplicate database ... from active database is designed to work without any existing backup. I would expect Oracle to clean up the archivelogs which were used during the clone process. So I would say this is an unexpected behavior. Try to log a Service Request at Oracle. I cannot recall if I had to clean up archivelogs after a clone processes. Well, I ...


1

The problem is the locking in the SGA that effectively cause the the concurrency is going down. This kind of apps make the database a close to single user platform instead of a highly scalable and concurrent accessible database. The cause of this is that the connections have to be maintained in a shared memory table where inserting and deleting means locking ...


1

The notes about this in Oracle 12.1.0.2 state that it is not required to move/copy the files from the primary during the plugin. The note also states that in this release the copy of the standby files of the source can be postponed using the standbys=none clause. This makes it possible to plugin a large primary database in a primary container database and ...


1

If you don't have any database internal mechanisms like auditing in place, you could also look at the listener log. You can even search it via SQL if you use it as external table – Have a look at The Oak Table or this blog entry


1

Take a look at it this thread on AskTom: Auditing of course would be the easiest way You could possibly get something from the DBA_HIST views (part of AWR/ASH - workload repository and active session history) but bear in mind they are sampled snapshots - not 100% of everything is in there many of them are "top" reports only - ...



Only top voted, non community-wiki answers of a minimum length are eligible