11g Supports upgrades from 9i Releases 1 and 2 and Oracle Database Release 1 and 2. From Any version <= 9.0.1.4 You must upgrade to Oracle 10.2 using a supported upgrade path(s). It is not supported to upgrade to Oracle 11g from a direct migration unless you use import/export or SQL*Plus method. From: Any version ...
Worried about how to trace shared connections?, relax, Oracle provides the trcsess command-line utility that consolidates tracing information based on specific criteria, trcsess is useful for consolidating the tracing of a particular session for performance or debugging purposes. The syntax for the trcsess utility is: trcsess [output=output_file_name] [session=session_Id] [clientid=client_Id] [service=service_name] [action=action_name] [module=module_name] [trace_files] where: output ...
To understand re-mastering please read in my blog the previous post explaining differences between versions. 1. Log in as SYSDBA and find the segment object number SELECT data_object_id FROM dba_objects WHERE owner = ‘JVALERIO’AND object_name = ‘TESTDRM1′; data_object_id ————— 23098 data_object_id: Object number of the segment which contains the object. If you want to remaster at ...
Remastering is the ability to move the ownership of a resource between instances of Real Application Clusters. Dynamic resource remastering is used to implement resource affinity for increased performance. Resource affinity optimizes the system in situations where update transactions are being executed on one instance. When activity shifts to another instance the resource affinity will ...
Updates Added on Jun 30, 2010: Global Cache Waits http://jose-valerio.com.ar/blog/?p=790 Added on March 23, 2010: If you have doubts about the “Oracle Query Processing” please take a look to my post http://jose-valerio.com.ar/blog/?p=502 . In this post you will find information about sysstat view to understand what is going on in your database on the fly, ...
How to ? 1. If it is possible, avoid reading uncommitted blocks on the remotes nodes. 2. Increase the number of LMS processes(depends of Oracle version) 3. Minimizing the transactions sizes on the remote node. …more ? ok, tuning the hardware can help you. 4. Try to reduce the interconnect latency 5. Change your disks, ...
(From my old blog, very popular !) A very trivial procedure to do this: # José Valerio – April, 2007 # Before: Stop cluster database # 1. Mount your cluster DB in the node where you # will perform the backup. # 2. Modify backup and format destinations (show channel) # 3. Connect RMAN (nocatalog ...
OpenSolaris ...
The Enqueues are locks that serialize access to database resources. In general this indicates that the session is waiting for a lock that is held by another session. –******************************************************* – – H O L D E R S & W A I T E R S — http://jose-valerio.com.ar – – ******************************************************* SELECT inst_id, DECODE(request,0,’Holder: ‘,’Waiter: ...
Thanks Hernan for invite me !. I will enjoy getting envolved in the group. In my first research I’ll try to get some of light to the Open HA Cluster and share all learned with the group. As you probably know my final insterest is to install a cheap Oracle RAC cluster, secure and stable, unfortunately RAC is not free Regards, ...