dbakerber.wordpress.com
Andrew Kerber's Oracle DBA Weblog | The World of the Oracle DBAThe World of the Oracle DBA
http://dbakerber.wordpress.com/
The World of the Oracle DBA
http://dbakerber.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.3 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
10
SSL
EXTERNAL LINKS
37
SITE IP
192.0.78.12
LOAD TIME
0.267 sec
SCORE
6.2
Andrew Kerber's Oracle DBA Weblog | The World of the Oracle DBA | dbakerber.wordpress.com Reviews
https://dbakerber.wordpress.com
The World of the Oracle DBA
dbakerber.wordpress.com
Using DBMS_REDEFINITION with DBMS_METADATA to Redefine a Table | Andrew Kerber's Oracle DBA Weblog
https://dbakerber.wordpress.com/2015/04/09/using-dbms_redefinition-with-dbms_metadata-to-redefine-a-table
Andrew Kerber's Oracle DBA Weblog. The World of the Oracle DBA. Laquo; Update on Hugepages (rewrite to fix formatting issues). Running Jobs in Parallel Using DBMS SCHEDULER (part 1). Using DBMS REDEFINITION with DBMS METADATA to Redefine a Table. This is an update to the previous post, that allows the layout of the column mapping string and the interim table to be table driven. This allows more flexibility, though the preparation is more extensive. SQL desc col map table Name Null? Type - - - - - - - - -...
Enabling ASM Filter Driver | Andrew Kerber's Oracle DBA Weblog
https://dbakerber.wordpress.com/2014/11/25/enabling-asm-filter-driver
Andrew Kerber's Oracle DBA Weblog. The World of the Oracle DBA. Laquo; Oracle Trace/Log File Cleanup using ADRCI. Testing the ASM Filter Driver (AFD). Enabling ASM Filter Driver. Note that the example here is the more complex ASM case of the OCR and Voting Disks being stored in ASM. So, here is the process. In the Grid Infrastructure home prior to patching, and the post patch script when complete. Etc/init.d/oracleasm querydisk -d `/etc/init.d/oracleasm listdisks -d` cut -f2,10,11 -d perl -pe 's/...3 Add...
DBMS_REDEFINITION Package | Andrew Kerber's Oracle DBA Weblog
https://dbakerber.wordpress.com/2014/12/23/213
Andrew Kerber's Oracle DBA Weblog. The World of the Oracle DBA. Laquo; Timestamp Comparison. 8212;————————————– ——– ——————-. RENCOL13 NOT NULL CHAR(26). RENCOL12 NOT NULL CHAR(1). RENCOL11 NOT NULL CHAR(2). RENCOL10 NOT NULL CHAR(2). RENCOL9 NOT NULL CHAR(8). RENCOL8 NOT NULL CHAR(8). RENCOL7 NOT NULL CHAR(10). RENCOL6 NOT NULL CHAR(10). RENCOL5 NOT NULL CHAR(8). RENCOL4 NOT NULL CHAR(10). RENCOL3 NOT NULL CHAR(21). RENCOL2 NOT NULL CHAR(25). RENCOL1 NOT NULL CHAR(30). RENCOL13 NOT NULL CHAR(26). 2 Modif...
Testing the ASM Filter Driver (AFD) | Andrew Kerber's Oracle DBA Weblog
https://dbakerber.wordpress.com/2014/11/25/testing-the-asm-filter-driver-afd
Andrew Kerber's Oracle DBA Weblog. The World of the Oracle DBA. Laquo; Enabling ASM Filter Driver. Testing the ASM Filter Driver (AFD). Testing the Oracle ASM Filter Driver (AFD). In my previous post I converted from standard Oracle ASM to the ASM Filter Driver (AFD). According to Oracle, the ASM Filter Driver will prevent non-oracle software from updating the AFD devices. Let’s test that out. First we try this as the owner of the GI installation grid:. Grid@vmrh65node1 ]$ dd if=/dev/zero of=/dev/sdf1.
Timestamp Comparison | Andrew Kerber's Oracle DBA Weblog
https://dbakerber.wordpress.com/2014/12/19/timestamp-comparison
Andrew Kerber's Oracle DBA Weblog. The World of the Oracle DBA. Laquo; Testing the ASM Filter Driver (AFD). Several weeks ago I determined a need to do some arithmetic based on a timestamp value on the database. I needed to perform certain actions if the difference in the two timestamps was five minutes or greater. This was really a fairly trivial problem, until I discovered that for some reason Oracle does not have an easy to use function to get the difference between two timestamp values. From your own...
TOTAL PAGES IN THIS WEBSITE
10
Oracle 12c pluggable and “common” directory recreation issue. | dmitry remizov's weblog
https://dmitryremizov.wordpress.com/2016/09/08/oracle-12c-pluggable-and-common-directory-recreation-issue
Dmitry remizov's weblog. Oracle 12c pluggable and “common” directory recreation issue. Oracle 12c pluggable and “common” directory recreation issue. September 8, 2016. Recently I did a stupid thing. DROP DIRECTORY DATA PUMP DIR; - issues from CDB$ROOT. Before that my PDBs was able to see this standard directory:. SELECT directory name FROM dba directories WHERE directory name='DATA PUMP DIR';. I’ve almost immediate recreate the directory as:. CREATE DIRECTORY DATA PUMP DIR as '/tmp';. SELECT directory na...
Small PID oneliner | dmitry remizov's weblog
https://dmitryremizov.wordpress.com/2016/04/07/small-pid-oneliner
Dmitry remizov's weblog. April 7, 2016. December 18, 2016. Here is a small dtrace oneliner which I believe good to start to investigate what is doing your oracle session:. Dtrace -n ‘profile-497/pid = $target/ { @u[ustack(40, 2000)] = count(); } tick-5s {printa ( @u);} tick-60s { exit(0); }’ -p PID. It’s just print user stack (sampled 497 times per second) each 5 second and exit after 1 minute. One more oneliner: count calls for all Oracle internal functions by pattern “kgl*”. Leave a Reply Cancel reply.
dmitry remizov's weblog | Oracle Solaris Linux | Page 2
https://dmitryremizov.wordpress.com/page/2
Dmitry remizov's weblog. Effectiveness of CU compression and inmemory imcu source maxbytes. December 27, 2015. It seems quite obvious that effectiveness of compression depends on unit size considered for compression. The amount of data loaded in-memory seems driven by inmemory imcu source maxbytes hidden parameter. I decided to create a quite artificial example. Let’s create an uniform size TABLESPACE as:. EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;. Let’s create a segment with about 1M size:. Ie 4M and 16M...
Howto know the processor type (Power 5, power6 or power7) on AIX | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/howto-know-the-processor-type-power-5-power6-or-power7-on-aix
My technical work (Oracle Database, Scripting, Linux, etc …). Howto know the processor type (Power 5, power6 or power7) on AIX. Lsattr -E -l proc0. Output should be similar to:. Frequency 3000000000 Processor Speed False smt enabled true Processor SMT enabled False smt threads 4 Processor SMT threads False state enable Processor state False type PowerPC POWER7 Processor type False. Always check the OS level (version) using:. January 20, 2016. Posted by Luis on January 20, 2016. Leave a Reply Cancel reply.
Luis | Luis's Blog
https://luiscalvolopez.wordpress.com/author/cen2038
My technical work (Oracle Database, Scripting, Linux, etc …). All posts by Luis. Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Posted by Luis on February 24, 2016.
Check CRC errors on Emulex HBA | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02/24/check-crc-errors-on-emulex-hba
My technical work (Oracle Database, Scripting, Linux, etc …). Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Posted by Luis on February 24, 2016. Enter your comment here.
NUMA related | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/numa-related
My technical work (Oracle Database, Scripting, Linux, etc …). Nfob is a variable used to determine the size of numa pool size parameter. Nfob=1 ( 0.1*nprocs)*nfiles). January 20, 2016. Posted in Oracle Database. Posted by Luis on January 20, 2016. Https:/ luiscalvolopez.wordpress.com/2016/01/20/numa-related/. Ssh still ask for password in spite of a passwordless configuration. Obtain all locks and resource information from a RAC instance (also works for standalone). Leave a Reply Cancel reply. Christoph&...
Obtain all locks and resource information from a RAC instance (also works for standalone) | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/obtain-all-locks-and-resource-information-from-a-rac-instance-also-works-for-standalone
My technical work (Oracle Database, Scripting, Linux, etc …). Obtain all locks and resource information from a RAC instance (also works for standalone). This will dump all information needed to locate locks and resources hold on different instances:. Sqlplus "/ as sysdba" oradebug setmypid oradebug unlimit oradebug -g all lkdebug -A res oradebug -g all lkdebug -A lock oradebug -g all hanganalyze 3 oradebug -g all dump systemstate 267 quit. Destinations for new files. Lkdebug -O 0x0 0x0 CF. Please log in ...
TOTAL LINKS TO THIS WEBSITE
37
dbaker14 (Derek Baker) - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 8 Years. This deviant's full pageview. Last Visit: 207 weeks ago. This is the place where you can personalize your profile! Window&...
Dbaker14999's Blog | Just another WordPress.com weblog
April 29, 2010. 8212; dbaker14999 @ 2:55 pm. I do not like the fact that flash is supposedly going out of style. I like flash and i think its an easy tool to use to enhance what a web page looks like. This allows even the most amatuer web designers to ad some really good flair to a web site. However the most complaints i see about flash are from mac users. I do not hate Apple or the Macbooks they make, they are very good products, however the only people i see complaining about flash are Mac Users? Card ...
dbaker1972 | 4 out of 5 dentists recommend this WordPress.com site
4 out of 5 dentists recommend this WordPress.com site. It seems we can’t find what you’re looking for. Perhaps searching can help. Blog at WordPress.com. Create a free website or blog at WordPress.com.
A little of this and a tad of that...some a bit random while others a bit thought out
A little of this and a tad of that.some a bit random while others a bit thought out. Just a taste of my every day life. This is where I'll share little bits of what goes on in the every day of Denise Baker. * * WARNING* * May be a bit boring at times. This one isn't a dance frame but I don't think I shared it here on the blog. A custom baby frame.this was given as a baby shower gift but is available as a special order. What I've been up to. Lets see.where have I been? What have I been up to? And with hon...
David Baker | artist | landscape paintings
Andrew Kerber's Oracle DBA Weblog | The World of the Oracle DBA
Andrew Kerber's Oracle DBA Weblog. The World of the Oracle DBA. Oracle Restart On File System. November 7, 2017. Many people may not be aware of the fact that Oracle restart (OHAS) can be configured on databases that are storing their data on a file system. ASM is not required. The installation and configuration process took some work to figure out, since Oracle does not document too well, but I did track it down eventually. For instructions on how to do silent installation and database creation. The fol...
Baker Family Dentistry
Welcome to Baker Family Dentistry. Our website is currently undergoing some contruction, so please be patient with us while we complete it. If you have any question, please feel free to choose contact us on the left, or call us using the number below. Thank your for your patience, and we look forward to serving you!
david baker's blurb lounge
David baker's blurb lounge. Monday, 3 August 2009. Everybody loves a creative and funny advert. Here are just a few. Is an agency with a difference. Image specialists for the music and fashion industry, Factory311 is a photographic and arts agency that provide imagery that pushes digital imagery to new boundaries. I first found out about Factory311 when Belin, street artist and graffiti writer, came to Manchester to promote his arrival along with Factory311 to Manchester. Too Many Design Graduates? Why c...
David Baker Design - Denver graphic design firm David Baker Design 303.377.2930
FOR BRANDING, ENVIRONMENTS,.
DBAKER HOOPS
Sport Zone Sport Portal. Com The site for the next Big Superstar. If you are serious about playing professional basketball, then DBAKERHOOPS will help set you apart from the pack, and provide you the keys to a prosperous career. College: Oklahoma Baptist 2011,Position: SG/PG/SF-Measurements: 6'4, 200 lbs. Date of Birth: 8/27/87 Player Comparison: Dwayne Wade. PG 6'2 190 Ada, Oklahoma. Height 6'2, Weight 198lbs, Postion; Guard. Dhoops news coming soon.t. Dhoops news coming soon. Dhoops news coming soon.
Baker Heating & Cooling - HVAC Contractor | Dayton, OH
Your 1st choice and your complete choice. Get an HVAC specialist that has been the Dayton area's complete provider for more than 60 years! We stand for quality! Get prompt service when you need it. With heating equipment, time is of the essence. Trust our team to be on-time and get your system running promptly. Start saving on your heating costs today! When it's time for an upgrade to a better system, choose the energy-efficient experts at Baker Heating and Cooling. Solid warranties backing everything.
