dbasdiary.blogspot.com

DBA's Diary

Oracle Database 經驗分享

http://dbasdiary.blogspot.com/

OVERVIEW OF dbasdiary.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR DBASDIARY.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

July

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.8 out of 5 with 18 reviews

5 star

7

4 star

5

3 star

4

2 star

0

1 star

2

Hey there! Start your review of dbasdiary.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.9 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT DBASDIARY.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

10

SSL

EXTERNAL LINKS

1

SITE IP

172.217.3.33

LOAD TIME

0.859 sec

SCORE

6.2

PAGE TITLE

DBA's Diary | dbasdiary.blogspot.com Reviews

<META> DESCRIPTION

Oracle Database 經驗分享

<META> KEYWORDS

1 dba's diary

2 oracle database 經驗分享

3 rac 架構

4 oralce clusterware

5 hardware architecture

6 high availability

7 主要是透過以下特性來提供：

8 reliability

9 recoverability

10 error detection

CONTENT

Page content here

KEYWORDS ON PAGE

dba's diary,oracle database 經驗分享,rac 架構,oralce clusterware,hardware architecture,high availability,主要是透過以下特性來提供：,reliability,recoverability,error detection,continuous operations,scalability,posted at,以電子郵件傳送這篇文章,blogthis！,分享至 twitter,分享至 facebook,沒有留言

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

DBA's Diary | dbasdiary.blogspot.com Reviews

https://dbasdiary.blogspot.com

Oracle Database 經驗分享

INTERNAL PAGES

dbasdiary.blogspot.com

1

DBA's Diary: 效能調教概論 (Performance Tuning Overview)

http://dbasdiary.blogspot.com/2009/05/performance-tuning-overview.html

效能調教概論 (Performance Tuning Overview). 無庸置疑的，效能問題（Performance issue）一直是大部分 DBA 心中揮之不去的夢靨。遺憾的是，這夢靨是沒有終止的一天，能做的只是儘量去減少發生的頻率與程度以及持續的時間。廣義上來講，效能問題指的是系統回應（response time）時間過長或資料吞吐量（throughput）過低。而效能調教（performance tuning）便是找出造成效能問題的瓶頸（bottleneck）並採取適當的調整來減低或消除因瓶頸所造成的影響。兩大方向，但在實際進行調整前，若能先擬定一份效能規劃(Performance Planning). 包含了"效能設計開發"以及"效能改善方法"。最佳的效能設計開始於系統初始階段並持續在整個系統的生命週期。因此，在系統設計階段若能將效能問題納入規劃，將有助於系統上線後的效能調教。找出使用者認知上的系統預期效能並給予一個明確的定義是執行效能改善方法的前提。典型的使用者反應效能問題範例，大概如下：. 12288;1.1 取得使用者的回饋，決定調整的範圍與目標. 筆者目前從事 Oracle...

2

DBA's Diary: 六月 2009

http://dbasdiary.blogspot.com/2009_06_01_archive.html

淺談 Grid Computing and Oracle RAC - 2. Oracle RAC（Real Application Clusters）允許應用程式在不做改變的情況下來進行 clustered servers 上 Database 的存取。這樣的架構提供了高度的可用性（Highest Availability）及最大的擴充彈性（flexible scalability）。倘若有任何的一台 clustered server 故障，Database 仍可在剩餘的 clustered server上運作。當使用者需要更多運算能力，亦可在不要求使用者離線的情況下增加另一台 server 來滿足需求。 Clusterware（叢集軟體）是負責監控與管理 RAC 資料庫。當叢集內有任何一台主機啟動，所有其它的 instances、listeners 與相關 services 也會被一併自動啟動。當任何一個 instance 發生錯誤時，clusterware 會自主性的去重新啟動該 instance&#1...叢集使用 LAN 來提供應用程式與 database server 間的連線，...

3

DBA's Diary: 四月 2009

http://dbasdiary.blogspot.com/2009_04_01_archive.html

Windows 下刪除 archived log files. Archived log files 是當資料庫災難發生時，確保資料完整性不可獲缺的要素之一。然而，也因為 archived log files 會伴隨著 redo log switch 持續產生的特性，變成磁碟空間管理上需特別注意的問題。一般而言，當透過 rman 執行 full/incremental backup 時，就會一併將備份完成的全部或是某一特定時間前的 archived log files 刪除。這同時也是比較建議的作法。倘若使用 cold backup 搭配 third party 備份軟體時，archived log files 或許就需採用手動（系統排程）的方式來刪除。在 Unix-based 平台下，只需透過 find 指令搭配 ctime 或 mtime 參數便可達成。但是同樣的動作在 Windows 下，使用 VB Script 亦可大幅簡化執行的步驟。以下便列出執行的步驟：. 將虛線區塊內的 VB Script 存檔為 arch del.vbs. Const WhatchFolder = "C: temp".

4

DBA's Diary: 淺談 Oracle Data Guard

http://dbasdiary.blogspot.com/2009/04/oracle-data-guard.html

淺談 Oracle Data Guard. Business continuity（營運持續）和 disaster recovery（災難復原）是大部分企業高階管理者的優先考量。伴隨著日趨複雜的經濟環境、急遽變動的市場潮流以及高度的競爭壓力，一個有運作效率並且能迅速反應不可預期中斷的 7*24 營運環境已經變成組織內不可獲缺的一環。 Oracle Data Guard 正是其中一個最有效率的解決方案。它提供一個保護企業核心資產，資料，的架構來維持 7*24 運作，以及任何可能的災難或系統中斷。什麼是 Oracle Data Guard：. 下圖為 Data Guard 架構：. Data Guard 的功能：. Data Guard 包含一個 production / primary database 以及一個或多少 standby database。Data Guard 使用 redo log 來維持 production 與 standby database 間資料的一致性。當在 production database 上有交易發生時， redo log ...Unix 檔案加密 (data en...

5

DBA's Diary: 淺談 Grid Computing & Oracle RAC - 1

http://dbasdiary.blogspot.com/2009/05/grid-computing-oracle-rac-1.html

淺談 Grid Computing and Oracle RAC - 1. RAC（Real Application Clusters）是 Oracle 能夠穩站資料庫市場寶座的一項重要創新，同時也是實現 Grid Computing（網格運算）的重要的里程碑。 Enterprise Grid Computing 主要是在 IT 架構下，提供一個更靈活（flexible）、更具彈性（resilient）與低成本（low cost）的企業 IT 資源運用。採用 Grid 將有助於 IT 去反應當前快速變化與不可預測的市場景氣狀況，並在管理成本、營運彈性與服務水準上取得最大的優勢。那到底什麼是 Grid Computing 呢？簡單的說，就是虛擬化與聯合化 IT 資源（EX:運算能力、儲存空間和網路傳輸等.）成為一個單一的 shared services，隨後並能根據不同的資源需求程度來進行分配或調整。 Grid Computing 主要是依據以下原則來建立：. 而 Grid Computing 可以帶來的效益大概可歸納為以下幾點：. 65293; 現今的應用系統大多綁定於特定的軟硬上，導致...

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

OTHER SITES

dbaschool.blogspot.com

Oracle Core and Apps DBA School

Oracle Core and Apps DBA School. Friday, 7 October 2011. Nice script to query current database instance all the active concurrent managers(queues) are connected to, this is usefull in PCP configuration to find out on which RAC instance FNDSM Is Currently Running? Labels: Apps Handy Scripts. Tuesday, 3 August 2010. Guest User End Dated. Guest user has lot of importance in EBS, E-Business Suite uses a guest account to represent a user session that is not yet authenticated, so when the account gets locked t...

dbascript.com

SQL Server Scripts for Database Administrators - dbascript.com

SQL Licensing and Pricing. Adventure Works for SQL Server 2012. SQL Server Scripts for Database Administrators. SQL Server Scripts for Database Administrators. Monitor Backup And Restore Progress In Sql Server. Sql Server And Clr Integration. Create Database Mail Private Profile In Sql Server. Export Sql Data Into Csv File With Header Using Sqlcmd. Export Xml Data Into Xml File. How To Import Data From Excel To Sql Server. Import Excel File Into Sql Server Table Using Powershell. Paging Function In Sql S...

dbascripting.com

DBAScripting.com

Welcome to DBAScripting.com. DBAScripting.com is an online resource dedicated to sharing database administration scripts for various DBMS platforms (Oracle, MySQL, PostgreSQL, and SQL Server). Although we specialize in the sharing of structured query language scripts, we also provide domain specific scripts for various DBMS's, scripts for different tools provided by those DBMS's, database administration scripts, and data loading scripts.

dbasculpt.com

Dirk B. Anderson | Fine Art Sculptor and Artificer — Idaho City Atelier

Dirk B. Anderson. Submit a Request for Bid. Dirk B. Anderson, Sculptor Based in Idaho City, ID. Dirk provides his talents to art lovers throughout the United States. Well versed in bronze, aluminum and steel, Dirk can provide art in many forms, from functional to just fantastic fine art. This slideshow requires JavaScript. Leave a Reply Cancel reply. You must be logged in. To post a comment. Fine Art Sculptor and Artificer Idaho City Atelier. Proudly powered by WordPress.

dbasdiary.blogspot.com

DBA's Diary

淺談 Grid Computing and Oracle RAC - 2. Oracle RAC（Real Application Clusters）允許應用程式在不做改變的情況下來進行 clustered servers 上 Database 的存取。這樣的架構提供了高度的可用性（Highest Availability）及最大的擴充彈性（flexible scalability）。倘若有任何的一台 clustered server 故障，Database 仍可在剩餘的 clustered server上運作。當使用者需要更多運算能力，亦可在不要求使用者離線的情況下增加另一台 server 來滿足需求。 Clusterware（叢集軟體）是負責監控與管理 RAC 資料庫。當叢集內有任何一台主機啟動，所有其它的 instances、listeners 與相關 services 也會被一併自動啟動。當任何一個 instance 發生錯誤時，clusterware 會自主性的去重新啟動該 instance&#1...叢集使用 LAN 來提供應用程式與 database server 間的連線，...

dbase-convert.com

You’re Not Stuck With dBase. We’re here to help you make a seamless switch. But don’t just take our word for it, watch what our clients have to say. . . Ven for the seasoned technology professional, the task of converting applications built on dBase onto something else like .NET can be daunting, to say the least. Our team has been working with dBase for more than 17 years. Ticomix is here with an experienced programming staff to ease the transition. Click to speak to an expert at no obligation.

dbase-designs.com

dbase-Designs | Creating Management Information Systems since 2002

Creating Management Information Systems since 2002. Customer & Vendor Contacts. Quotations for Service or Products. Sales of Services or Products. Order Management & Logistics. Customer & Vendor Contacts. Quotations for Service or Products. Sales of Services or Products. Order Management & Logistics. For the Medium-sized Business. Order Mgmt & Satisfied Customers. For the business that posseses solid applications for gathering data, the challenge may involve analyzing the data to to help make strategic b...

dbase-developer.com

Home | dbase-developer.com - Relationale Datenbanken

Umzug der dbase-developer beendet. Neue Anschrift: Zur Burg 15 , 65719 Hofheim-Wallau. ARGUS-DB steht kurz vor der Veröffentlichung! Fertigstellung der Sektion "Screenshots". Argus-DB geht offiziell in den Verkauf. Alle Datenbanken die wir bisher entwickelt haben und entwickeln werden sind ab sofort auch in der Version Filemaker Pro 12 erhältlich! Die Datenbank zur Verwaltung privater Belege, Rechnungen, Quittungen, Verträge, Versicherungspolicen u.v.m. Private-Bill geht in die Entwicklung. Sie können al...

dbase-journal.com

dBASE Journal - Das Magazin rund um dBASE und Datenbank-Programmierung

Informationen und Artikel rund um dBASE und Datenbank-Programmierung. 169; 2012 dBASE Journal Aktualisiert am 24.04.2012. DBASE Plus 2.8 ist da! 23042012 -Wie Michael J. Rozlog mitteilt, ist die neue Version dBASE Plus 2.8 heute erschienen. Die neue dBASE Company. 29032012 -Brief von Mike Rozlog, CEO of dBase LLC:. Visionary New Company Launched to Support dBASE Community. Promo-Aktion für dBASE PLUS 2.70.3 bis zum. Bitte beachten Sie auch die weiteren Meldungen in unserem. Startseite ] [ Literatur ].

dbase-journal.de

dBASE Journal - Das Magazin rund um dBASE und Datenbank-Programmierung

Informationen und Artikel rund um dBASE und Datenbank-Programmierung. 169; 2012 dBASE Journal Aktualisiert am 24.04.2012. DBASE Plus 2.8 ist da! 23042012 -Wie Michael J. Rozlog mitteilt, ist die neue Version dBASE Plus 2.8 heute erschienen. Die neue dBASE Company. 29032012 -Brief von Mike Rozlog, CEO of dBase LLC:. Visionary New Company Launched to Support dBASE Community. Promo-Aktion für dBASE PLUS 2.70.3 bis zum. Bitte beachten Sie auch die weiteren Meldungen in unserem. Startseite ] [ Literatur ].