Probably you want to know how much memory it is needed to buy your TT server or you just wants to estimate what will happen if you’ve millions of rows in two months, you’re in lucky, there is a very easy way to do this, using a nice tool called ”ttSize”. ttSize is an utility program ...
Below the Oracle data types unsupported by TimesTen (Valid 7.0.x and up) 01. ROWID 02. UROWID 03. CLOB 04. NCLOB 05. BLOB 06. BFILE 07. REF “Any” types 08. XML types 09. Spatial types 10. Media types 11. TT_TINYINT 12. TT_SMALLINT 13. TT_INTEGER 14. TT_BIGINT 15. TT_VARBINARY 16. TIMESTAMP WITH TIME ZONE 17. TIMESTAMP WITH ...
Fast Application Notification (FAN) Yes, it’s recommended and it’s a good practice to use it in your RAC enviroment because Cache connect uses OCI integrated with FAN to receive notifications of Oracle events, believe or not, visiting some customers I could adivise that ons demons were disable or going down for known bugs. FAN is ...
Dealing with Windows in 32Bits Platforms ORA-004030 and others ugly errors like : ORA-27300: OS system dependent operation:CreateThread failed with status: 8 ORA-27301: OS failure message: Not enough storage is available to process this command. ORA-27302: failure occurred at: ssthrddcr Introduction Before start take your time read and understand Metalink Note ID: 1036312.6 Where is ...
A time ago I found this ONT tutorial that describes how to use ADDM in a RAC environment to identify database level issues, and drill down to affected database instances. Database ADDM for RAC is not just a report of reports but has independent analysis that is appropriate for RAC. Downlaod the tutorial scripts from ...
11g R1 11.1.0.6 (from my old blog) The big red has enhanced Real Application Clusters in Oracle11g and we see many exciting new features, great work ! Oracle 11g RAC parallel upgrades A very challenging and complex 11g new feature. Oracle RAC load balancing advisor – Was introduced in 10gr2, in 11g we see a ...
Probably after a while perhaps you need to add some packages to your OEL and Package Manager is not working properly when you select “Browse” or “Search”. Follow the next steps to enable the repository pointing to your cdrom. 1. mount -o loop rhel-5-server-dvd.iso /media/rhel 2. vi /etc/yum.repos.d/local.repo [Cluster] name=Oracle Enterprise Linux $releasever – $basearch ...
Oracle Orion is a simple but powerful tool lets you to simulate oracle stack workload without installing a database. Sometimes it’s really useful to compare local disk performance vs. SAN luns or other devices, so this tool makes the magic. Storage vendors can use Orion to understand how databases will impact on their storage arrays. Some cool features ...
Differences between Oracle 10.2.0.1 and Oracle 11.1.0.6 Detail 10.2.0.1 11.1.0.6 Supported Parameters 258 289 Unsupported Parameters 1127 1631 Supported Optimizer Environment Parameters 25 37 Unsupported Optimizer Environment Parameters 184 259 Dynamic Performance (V$) Views 393 481 Fixed (X$) Tables 597 767 Background Processes 157 212 Statistics Levels 16 24 Statistics 363 485 Segment Statistics 15 ...