oracledbasupport.co.uk
Oracle Dataguard | Oracle RAC | Oracle PerformanceEveryday practical solutions for an Oracle/SQL Server DBA
http://oracledbasupport.co.uk/
Everyday practical solutions for an Oracle/SQL Server DBA
http://oracledbasupport.co.uk/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Monday
LOAD TIME
2.2 seconds
PAGES IN
THIS WEBSITE
0
SSL
EXTERNAL LINKS
17
SITE IP
188.65.117.67
LOAD TIME
2.203 sec
SCORE
6.2
Oracle Dataguard | Oracle RAC | Oracle Performance | oracledbasupport.co.uk Reviews
https://oracledbasupport.co.uk
Everyday practical solutions for an Oracle/SQL Server DBA
IT 研究室 ( 前IT DBA's 資訊站): FW: MSSQL Step-by-Step Approach to Differential Backup and Recovery
http://jaychu649.blogspot.com/2015/08/fw-mssql-step-by-step-approach-to.html
IT 研究室 ( 前IT DBA's 資訊站). 星期一, 8月 03, 2015. FW: MSSQL Step-by-Step Approach to Differential Backup and Recovery. 2BACKUP LOG WITH TRUNCATE ONLY :. Point in time recovery or transaction log recovery from backup. Or recover to log sequence(. Or recover to contain marked transaction. Sql server 2014 full recovery model. Full recovery model or bulk-logged recovery model, simple recovery model. Point in time recovery ,. Step-by-Step Approach to Differential Backup and Recovery. Jul 26, 2011. Differential backu...
IT 研究室 ( 前IT DBA's 資訊站): FW: SQL Server Connection Strings
http://jaychu649.blogspot.com/2015/08/fw-sql-server-connection-strings.html
IT 研究室 ( 前IT DBA's 資訊站). 星期四, 8月 06, 2015. FW: SQL Server Connection Strings. Ref: http:/ weblogs.sqlteam.com/dang/archive/2011/07/10/sql-server-connection-strings.aspx. SQL Server Connection Strings. In this post, I’ll provide a connection string overview and discuss SqlClient connection strings and examples. I’ll discuss OLE DB and ODBC (used via ADO or ADO.NET) and JDBC in more detail the future articles. The purpose of a connection string is to supply a SQL Server provider/driver with the information...
IT 研究室 ( 前IT DBA's 資訊站): [轉貼]linux 清理緩存
http://jaychu649.blogspot.com/2012/04/linux.html
IT 研究室 ( 前IT DBA's 資訊站). 星期五, 4月 13, 2012. Http:/ www.360doc.com/content/11/1028/15/1162697 159865156.shtml. Echo 3 /proc/sys/vm/drop caches. Writing to this will cause the kernel to drop clean caches, dentries and inodes from memory, causing that memory to become free. Echo 1 /proc/sys/vm/drop caches. To free dentries and inodes:. Echo 2 /proc/sys/vm/drop caches. To free pagecache, dentries and inodes:. Echo 3 /proc/sys/vm/drop caches. This tunable was added in. Vmdirty ratio = 1. Vmdirty ratio = 1.
IT 研究室 ( 前IT DBA's 資訊站): Oracle User profile --使用PROFILE來限制使用者資源
http://jaychu649.blogspot.com/2011/12/oracle-user-profile.html
IT 研究室 ( 前IT DBA's 資訊站). 星期四, 12月 01, 2011. Oracle User profile - 使用PROFILE來限制使用者資源. Http:/ www.itpub.net/viewthread.php? 1．動態地使用alter system或使用初始化參數resource limit使資源限制生效。 SQL show parameter resource limit. Resource limit boolean FALSE. SQL alter system set resource limit=true;. SQL show parameter resource limit;. Resource limit boolean TRUE. 2．使用create profile創建一個定義對資料庫資源進行限制的profile。 3．使用create user 或alter user命令把profile分配給使用者。 LIMIT { resource parameters. LOGICAL READS PER SESSION. Oracle資料庫以有利的方式計算cp...
IT 研究室 ( 前IT DBA's 資訊站): [轉載] Windows Server (FailOver Cluster) + SQL 2012 AlwaysOn 的注意事項
http://jaychu649.blogspot.com/2015/08/windows-server-failover-cluster-sql.html
IT 研究室 ( 前IT DBA's 資訊站). 星期一, 8月 10, 2015. 轉載] Windows Server (FailOver Cluster) SQL 2012 AlwaysOn 的注意事項. Http:/ www.dotblogs.com.tw/mis2000lab/archive/2013/12/16/sql 2012 alwayson availability group-again.aspx. Windows Server 2008 2012. Http:/ msdn.microsoft.com/en-us/library/hh781257.aspx. 時，使用「一般安裝」即可. 權限要夠高，不然會卡關（難怪大部分的網路文件，他們都用. 65288;靜態、固定）. 的「電腦名稱」或是相關的人員帳號。 如果會用到，請您要打開，不然就會卡關。例如. 步驟，是最簡單、最好實現的。 MVP - - Edwin Sarmiento. Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group. Simple範本...
IT 研究室 ( 前IT DBA's 資訊站): VMware vSphere 6.0 升版與降版問題
http://jaychu649.blogspot.com/2015/08/vmware-vsphere-60.html
IT 研究室 ( 前IT DBA's 資訊站). 星期二, 8月 04, 2015. VMware vSphere 6.0 升版與降版問題. VMware vSphere 6.0. Downgrade/ upgrade if you want. Http:/ www.techezone.com/question/downgrade-vsphere-esxi-6-0-entplus-license-to-esxi-5-entplus-2/. You can up- and downgrade your license in your MyVMware portal as required. How to downgrade license keys in My VMware (2006975). Http:/ kb.vmware.com/selfservice/microsites/search.do? How to upgrade license keys in My VMware (2006974). VSphere驚爆大漏洞，恐讓ESXi 6.0主機網路突然中斷.
IT 研究室 ( 前IT DBA's 資訊站): GoldenGate: Oracle 資料庫表格同步測試步驟
http://jaychu649.blogspot.com/2011/12/goldengate-oracle_01.html
IT 研究室 ( 前IT DBA's 資訊站). 星期四, 12月 01, 2011. 如果同步10.2.0.5 , 11.2.0.2 之後版本的資料庫, 請先參考以下連結. Http:/ www.askmaclean.com/archives/goldengate-parameter-suppresstriggers-deferrefconst.html. Http:/ oracleabout.blogspot.tw/2013/06/goldengate-user-creation.html. Http:/ jaychu649.blogspot.tw/2015/11/ogg-tuning-tips.html. 1Target replicate 端 需 disable triggers. And disable cascade delete constraints. 否則extract端執行一次delete，replicat端會執行兩次 delete，造成進程abend. When target triggers : AFTER/before INSERT OR UPDATE OR DELETE).
IT 研究室 ( 前IT DBA's 資訊站): Linux tcp session 處於 ESTABLISHED狀態 且無法釋放
http://jaychu649.blogspot.com/2012/03/linux-webserver-tcp-timeout.html
IT 研究室 ( 前IT DBA's 資訊站). 星期五, 3月 02, 2012. Linux tcp session 處於 ESTABLISHED狀態 且無法釋放. Netstat -an grep ".5555" awk '{print $5}' cut -d '.' -f 1-4 sort uniq -c sort -nr. 291 192.168.xx.1. 281 192.168.xx.2. 255 192.168.xx.3. 214 192.168.xx.4. 43 192.168.xx.5. 27 192.168.xx.6. 10 192.168.xx.7. 8 192168.xx.8. 6 192168.xx.9. 敘述發生在有NAT的環境 , 看起來蠻符合的 ,. 加入以下參數, 修改linux timeout. Netipv4.netfilter.ip conntrack tcp timeout established = 432000 = 預設為五天. Ip conntrack 3024 4090 384 409 409 1 (. 13 6160.xx.xx. Netstat -...
IT 研究室 ( 前IT DBA's 資訊站): [轉載] Oracle 11g new feature Pivot 和 Unpivot
http://jaychu649.blogspot.com/2013/12/oracle-11g-new-feature-pivot-unpivot.html
IT 研究室 ( 前IT DBA's 資訊站). 星期一, 12月 23, 2013. 轉載] Oracle 11g new feature Pivot 和 Unpivot. Oracle 11g new feature Pivot. Http:/ www.oracle.com/technetwork/cn/articles/11g-pivot-101924-zhs.html. 如您所知，關係表是表格化的，即，它們以列. Select cust id, state code, times purchased. Order by cust id;. CUST ID STATE CODE TIMES PURCHASED. 注意資料是如何以行值的形式顯示的：針對每個客戶，該記錄顯示了客戶所在的州以及該客戶在商店購物的次數。當該客戶從商店購買更多物品時，列. 現在，假設您希望統計一個報表，以瞭解各個州的購買頻率，即，各個州有多少客戶只購物一次、兩次、三次等等。如果使用常規. Select state code, times purchased, count(1) cnt. CT NY NJ . 3 32978 ...
TOTAL LINKS TO THIS WEBSITE
17
oracledbaservice.com
Uzantısı sadece 56.99 TL. Bu web sayfası TURKTICARET.Net. Tarafından ücretsiz park edildi. İletişime Geç - oracledbaservice.com. Satılık Domain Alan Adı. Türkçe Domain Alan Adı. Mobil Ödeme ile Domain. Alan Adı Tahsis Formu. TR Domain İçin Gerekli Belgeler. Tek Sayfa Web Sitesi. Marka Tescili Nasıl Yapılır? Marka Tescil için Gerekli Evraklar. Online Marka Tescili Sorgulama. Yurt Dışı Marka Tescili. Bilg Prog. ve Veritabanı Tescili. Marka Tescil Belgesi Nasıl Alınır? Telif Hakkı Nasıl Alınır?
oracledbaservices.wordpress.com
DBA Support & Services | Remote Oracle DBA Support and Services
DBA Support and Services. Remote Oracle DBA Support and Services. What is Remote DBA Service? The Remote DBA Services you opt for should aim at providing solutions through right-sizing technology aligned with your business needs and management goals. It should bring you the vast pool of resources with technical expertise and practical experience, in an endeavor to consistently help you align your IT investments with business objectives. Installation, Configuration and Upgrades. The DBA Service provider s...
Domain Expires
This domain name has expired. In order to restore the domain and continue the service you will have to contact your registrar immediately.
Oracle Dataguard | Oracle RAC | Oracle Performance
Call Detail Record Generator. Import ERWin Data Model into Visio. SQL Queries for DMVs. IBM Web Server Plug-in Analyzer for WebSphere Application Server. Installing Tivoli Common Agent Services Agent/Manager. DMGR HA: How to backup websphere deployment manager for a Disaster Recovery. Jython Script to list websphere ports. Adding Another IBM Http Server Instance at Websphere. Cloning Oracle Clusterware (Applicable only to 11.2.0.2.0 and not for any previous Releases). Scripts Available for Download.
Oracle dbateam - expert Oracle database services and solutions, Oracle consulting, remote dba services in Greece and Europe.
15 years Oracle services. Commited to build a safer, faster and better Oracle database server, we provide professional Oracle DBA services to corporate customers since 2003. As continuously trying to cover in total your business IT needs, we have extended our knowledge and expertise to the administration and maintenance of the Oracle Weblogic Server, the leading and new standard in the enterprise application servers. Thank you for visiting dbateam SMPC. Dbateam SMPC Athens Greece.
DBA Technologies - Home
Online Training Only - Call Us: 91 984-999-8237. 18 Years Corporate Experience in USA and India. Online Core DBA Training. Online RAC DBA Training. Online Apps DBA Training. ORACLE APPS DBA R12. ORACLE DBA 12c from 13th-April-2018 5.30PM IST - 8 Weeks (Fri and Sat) - Oracle RAC DBA 11gR2 from 17th-Mar-2018 8.00AM EST /5.30PM IST! Avail Live Sessions Online on Core,RAC and APPS DBA at your convenient time - Reach us at. Oracle DBA 12c Training. RAC DBA Online Training. You will be proficient in the succes...
oracledbatipsntricks.blogspot.com
Tips and Tricks for the Oracle DBA
Tips and Tricks for the Oracle DBA. Notes from my day to day dba activities. Tuesday, January 22, 2013. Applying 11gR2 database patch. Apply the latest CPU patches for 11gR2 (11.2.0.2) using opatch. 1: Install the latest OPATCH. 2: Apply the DB patches. Check current version of opatch. Opatch lsinv grep -i version. Oracle Interim Patch Installer version 11.2.0.3.0. Delete the OPatch directory from $ORACLE HOME. Download the latest Opatch, and unzip it in $ORACLE HOME. Verify the new version of opatch.
oracledbatolearnmssql.blogspot.com
Oracle DBA to learn MS SQL
Friday, March 30, 2012. Order of cursor walk. I have table Stock which represents products in stock. When new order came (table orders) I must reserve items in stock for that. The way I work is, that I first find all appropriate stock for my order,. Walk through it and reserve the quantity until I reach. Declare @.stockQ decimal(15,5),@.orderQ decimal(15,5),@.orderID int,@.stockID. Int,@.orderIDold int,@.work bit,@.quantity decimal(15,5). Set @.orderIDold=0. Declare cCur cursor local for. Instead I reser...
SOCIAL ENGAGEMENT