jameshuangsj.wordpress.com
James Huang – Databases Consultant | Anything As A Database ConsultantAnything As A Database Consultant
http://jameshuangsj.wordpress.com/
Anything As A Database Consultant
http://jameshuangsj.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
1.1 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
4
SSL
EXTERNAL LINKS
30
SITE IP
192.0.78.12
LOAD TIME
1.109 sec
SCORE
6.2
James Huang – Databases Consultant | Anything As A Database Consultant | jameshuangsj.wordpress.com Reviews
https://jameshuangsj.wordpress.com
Anything As A Database Consultant
james huang | James Huang – Databases Consultant
https://jameshuangsj.wordpress.com/author/jameshuangsj
James Huang – Databases Consultant. Anything As A Database Consultant. Author Archives: james huang. How To Flush an Object Out The Library Cache by Using DBMS SHARED POOL Package. March 9, 2017. We know how to flash all shared pool by : SQL alter system flush shared pool; Sometime, we only want to flush certain objects, like a cursor for testing purpose to want the cursor to have different execution plan. DBMS SHARED POOL can do … Continue reading →. SQL Scripts For DBA. Alter system flush shared pool.
James Huang – Databases Consultant | Anything As A Database Consultant | Page 2
https://jameshuangsj.wordpress.com/page/2
James Huang – Databases Consultant. Anything As A Database Consultant. Newer posts →. ME ( Metric Extension ) Metric Is Not Collected For Some Databases. February 8, 2017. For one of the databases, ME ( Metric Extension ) is not collecting data. But for the rest databases, it is working fine. Checking the ME ( Metric Extension ) definition and found an advanced option is not selected. After creating a new version of this ME ( Metric Extension ) by checking this mentioned option, it works fine. Environmen...
ORA-16826: apply service state is inconsistent with the DelayMins property | James Huang – Databases Consultant
https://jameshuangsj.wordpress.com/2017/01/12/ora-16826-apply-service-state-is-inconsistent-with-the-delaymins-property
James Huang – Databases Consultant. Anything As A Database Consultant. CREATE INDEX COMPUTE STATISTICS. How to Apply Database Component Of a Patch Onto ORMB Database →. ORA-16826: apply service state is inconsistent with the DelayMins property. January 12, 2017. We received the OEM alert by complaining DataGuard status with error as “ORA-16826: apply service state is inconsistent with the DelayMins property”. Oracle official explanation is as below :. On standby database applying instance STDBYDB2. F...
CREATE INDEX COMPUTE STATISTICS | James Huang – Databases Consultant
https://jameshuangsj.wordpress.com/2017/01/05/create-index-compute-statistics
James Huang – Databases Consultant. Anything As A Database Consultant. Use Corrective Action ( CA ) to Automate Archivelog Backup When FRA Usage is Over Threshold of Metric Extension ( ME ) in OEM 12C. ORA-16826: apply service state is inconsistent with the DelayMins property →. CREATE INDEX COMPUTE STATISTICS. January 5, 2017. When creating an index, “COMPUTE STATISTICS” option is no longer required for 10g onwards databases. Here is a quick demonstration:. No statistics for newly created table:. And ta...
TOTAL PAGES IN THIS WEBSITE
4
How to Install MySQL on Linux Using RPM Packages | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/06/how-to-install-mysql-on-linux-using-rpm-packages
How to Install MySQL on Linux Using RPM Packages. Asymp; Leave a comment. James Huang - Databases Consultant. 1) Download RPM packages zip file V74391-01.zip for MySQL 5.6.23 with files below:. 2) unpack the zip file. Unzip V74391-01.zip Archive: V74391-01.zip extracting: MySQL-shared-advanced-5.6.23-1.el7.x86 64.rpm extracting: MySQL-test-advanced-5.6.23-1.el7.x86 64.rpm extracting: MySQL-devel-advanced-5.6.23-1.el7.x86 64.rpm extractin...Click to share on Twitter (Opens in new window). Next post →.
How to Install rlwrap on Linux | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/06/how-to-install-rlwrap-on-linux
How to Install rlwrap on Linux. Asymp; Leave a comment. James Huang - Databases Consultant. Rlwrap is an utility that allows you to use up and down arrows like in DOS environment. For Oracle commands like sqlplus, rman, adrci, we can do the same as in DOS environment to choose one of the history command instead of type the same command again. 1) Downloand and install as a package from http:/ rpm.pbone.net/. Or an alternative web sites. Click to share on Twitter (Opens in new window). Larr; Previous post.
Revoking OEM12c License Packs | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/01/revoking-oem12c-license-packs
Revoking OEM12c License Packs. Asymp; Leave a comment. Disabling a management pack is just as easy as enabling the pack in the first place. Go to the bottom of the Setup menu and select. Management Packs Management Pack Access. To completely disable the pack, click radio buttons. Licensable targets and dependent targets). Pack based Batch Update. Select the management pack from the list and move it to the right-hand panel. Verify that targets no longer have access to the pack by clicking on. Talip Hakan ...
How to Install MySQL on Unix/Linux Using Generic Binaries | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/06/how-to-install-mysql-on-unixlinux-using-generic-binaries
How to Install MySQL on Unix/Linux Using Generic Binaries. Asymp; Leave a comment. James Huang - Databases Consultant. 1) Download V74396-01.zip which contains:. There are two files ASC and MD5 for mysql-advanced-5.6.23-linux-glibc2.5-x86 64.tar.gz. A: Verify MD5 checksum:. Cat mysql-advanced-5.6.23-linux-glibc2.5-x86 64.tar.gz.md5 f2ace50e757f1a63736e8dcbf5cfeb19. Mysql-advanced-5.6.23-linux-glibc2.5-x86 64.tar.gz. B) Signature Checking Using GnuPG. To file mysql pubkey.asc. Larr; Previous post. Talip H...
How to Install Example Schemas in 12c by Using Templates and Creating a New PDB | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/06/how-to-install-example-schemas-in-12c-by-using-templates-and-creating-a-new-pdb
How to Install Example Schemas in 12c by Using Templates and Creating a New PDB. Asymp; Leave a comment. James Huang - Databases Consultant. In another post How to Install Example Schemas in 12c Database? It shows detail steps of how to install example schemas manually through SQL command line. Here we use another way to install example schemas by creating a PDB with example schemas and plug this PDB into a current CDB . 1) Start up DBCA, select Manage Pluggable Databases. 7)Review the template summary.
About | WatsupDBAz
https://watsupdbaz.wordpress.com/about
I, Bharani Kanth Sakhamuri an Orace DBA Proffessional wih good amount of experience dream to bring all like minded people to gather at a one place and help each other with their experiences and sharing knowledge. And i seem to be found that place as WatsupDBAz. Click to share on Twitter (Opens in new window). Share on Facebook (Opens in new window). Click to share on Google (Opens in new window). Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:.
WatsupDBAz | DBAz Network | Page 2
https://watsupdbaz.wordpress.com/page/2
Apply Database Patch Set Update 12.1.0.2.2 (Includes CPUJan2015) and Oracle JavaVM Component 12.1.0.2.2 Database PSU (Jan2015) onto CDB Database. Asymp; Leave a comment. James Huang - Databases Consultant. 1) Download and put in place opatch 12.1.0.1.6 as README required. 2)Download patch p20132434 121020 Linux-x86-64.zip which includes both database and JVM 12.1.0.2.2 PSU. 3)unzip p20132434 121020 Linux-x86-64.zip. Oracle@racnote1 20132434]$ ls -ltr. Drwxrwx . 1 root vboxsf 0 Jan 21 01:09 19769480.
Multi-Process Multi-Threaded Architecture in Oracle 12c | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/06/multi-process-multi-threaded-architecture-in-oracle-12c
Multi-Process Multi-Threaded Architecture in Oracle 12c. Asymp; Leave a comment. James Huang - Databases Consultant. In default Unix/Linux architecture, every Oracle process including background and foreground ones runs as a dedicated OS process. Configure Multi-Process Multi-Threaded for Background Processes. In default Unix/Linux architecture, every process runs as a dedicated OS process. Ps -eLo "pid tid comm args" grep cdb2 6163 6163. Ora pmon cdb2 ora pmon cdb2 6165 6165. 1,904 more words. Leave a R...
Using Automatic Workload Repository Warehouse for Generating Performance Reports | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/08/using-automatic-workload-repository-warehouse-for-generating-performance-reports
Using Automatic Workload Repository Warehouse for Generating Performance Reports. Asymp; Leave a comment. Using Automatic Workload Repository Warehouse for Generating Performance Reports. Click to share on Twitter (Opens in new window). Share on Facebook (Opens in new window). Click to share on Google (Opens in new window). Larr; Previous post. Next post →. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public).
Apply Database Patch Set Update 12.1.0.2.2 (Includes CPUJan2015) and Oracle JavaVM Component 12.1.0.2.2 Database PSU (Jan2015) onto CDB Database | WatsupDBAz
https://watsupdbaz.wordpress.com/2015/04/01/apply-database-patch-set-update-12-1-0-2-2-includes-cpujan2015-and-oracle-javavm-component-12-1-0-2-2-database-psu-jan2015-onto-cdb-database
Apply Database Patch Set Update 12.1.0.2.2 (Includes CPUJan2015) and Oracle JavaVM Component 12.1.0.2.2 Database PSU (Jan2015) onto CDB Database. Asymp; Leave a comment. James Huang - Databases Consultant. 1) Download and put in place opatch 12.1.0.1.6 as README required. 2)Download patch p20132434 121020 Linux-x86-64.zip which includes both database and JVM 12.1.0.2.2 PSU. 3)unzip p20132434 121020 Linux-x86-64.zip. Oracle@racnote1 20132434]$ ls -ltr. Drwxrwx . 1 root vboxsf 0 Jan 21 01:09 19769480.
TOTAL LINKS TO THIS WEBSITE
30
James Huang
Follow me on Twitter. Trading Below Cash Leaves Smartphone Brand With No Value bloom.bg/1N27PhO. About 6 days ago. From James Huang's Twitter. About a month ago. From James Huang's Twitter. Want to win Xbox One, Chromecast, Lifetime Plex Pass and an Amazon music g? I just entered to win and you can too. gvwy.io/oj3rhe6. About 3 months ago. From James Huang's Twitter. Is accepting earthquake aid from countries around the world but not from #Taiwan. About 4 months ago. From James Huang's Twitter. Design an...
James Huang
How to Audit (Part 19): Leaving Drinks. In every auditor’s life comes a day when checking bank statements no longer satisfies. And that feeling doesn’t go away even after some spreadsheet fun. On that day, he decides to leave. It could happen during the first week or after an illustrious career. But that time always comes. A lot of thought goes into deciding the next step. By contrast, the leaving process itself is straightforward because there are clear rituals to follow. Leaving drinks will be arranged...
James Huang - Home
James' Journal
Thursday, May 31, 2012. News: Awesome Wedding Proposals. SECRET MISSION" spotlighted on E! Did you happen to catch Juliana Rancic dish on 'Crazy Proposals'? Check out our segment here! Click to play E! News Segment on 'Secret Mission' (1min):. Watch the original 'Secret Mission' here (3 min):. Links to this post. Tuesday, December 6, 2011. James Huang and Elizabeth Sandy videos. Yellow Sun Films LLC. James Huang and Elizabeth Sandy are the creators of the award winning indie feature film.
James Huang – Databases Consultant | Anything As A Database Consultant
James Huang – Databases Consultant. Anything As A Database Consultant. ORA-16826: apply service state is inconsistent with the DelayMins property. January 12, 2017. We received the OEM alert by complaining DataGuard status with error as “ORA-16826: apply service state is inconsistent with the DelayMins property”. Oracle official explanation is as below :. Primary database side is good, the warning is from standby database side. DGMGRL show database "STDBYDB" "DelayMins" DelayMins = '0'. On standby databa...
James Hubbard Marketing » Maintenance Mode
This site is being redeveloped. I am still contactable at: info@jameshubbardmarketing.co.uk.
Welcome jameshubbardphoto.com - BlueHost.com
Web Hosting - courtesy of www.bluehost.com.
jameshubbardrecreationproducts.com
Site currently unavailable
Sorry, this site is currently unavailable. Please try again later.
Site Temporarily Unavailable
Uh oh Something's not right with this domain. Please contact your web hosting provider as soon as possible in order to get this issue resolved.
James T. Hubbell Fine Art Studio
Hubbell and Hubbell Architects. Santa Ysabel Art Gallery. Weaving Art and Beauty into Life. Bridging Works of James Hubbell. Weaving Art and Beauty into Life. Weaving Art and Beauty into Life. Radosti Wedding Chapel, Russia. James T. Hubbell Fine Art Studio.
SOCIAL ENGAGEMENT