AFATKULIN.BLOGSPOT.COM

Alex Fatkulin's Blog

Saturday, March 07, 2015. Converting non-CDB database to a PDB when TDE is in use. Converting a non-CDB database to a PDB is a rather straightforward process. However once TDE (Transparent Data Encryption) gets involved certain things become not so obvious so I've decided to write a small guide on how to accomplish that. In order for a non-CDB database to be converted to a PDB it's version needs to be at least 12.1.0.2.0. My encryption wallet location is set to the following (sqlnet.ora):. Dbca -silent -...

http://afatkulin.blogspot.com/

OVERVIEW OF afatkulin.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR AFATKULIN.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

October

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 2.7 out of 5 with 3 reviews

5 star

0

4 star

1

3 star

1

2 star

0

1 star

1

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT AFATKULIN.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

18

SSL

EXTERNAL LINKS

154

SITE IP

0.0.0.0

LOAD TIME

0.546 sec

SCORE

6.2

PAGE TITLE

Alex Fatkulin's Blog | afatkulin.blogspot.com Reviews

<META> DESCRIPTION

Saturday, March 07, 2015. Converting non-CDB database to a PDB when TDE is in use. Converting a non-CDB database to a PDB is a rather straightforward process. However once TDE (Transparent Data Encryption) gets involved certain things become not so obvious so I've decided to write a small guide on how to accomplish that. In order for a non-CDB database to be converted to a PDB it's version needs to be at least 12.1.0.2.0. My encryption wallet location is set to the following (sqlnet.ora):. Dbca -silent -...

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 alex fatkulin's blog

4 encryption wallet location

5 create a cdb

6 utility

7 wallets

8 notice how db1

9 as well

10 to db1's

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,alex fatkulin's blog,encryption wallet location,create a cdb,utility,wallets,notice how db1,as well,to db1's,wallet,prepare db1,before db1,database,into a cdb,before pdb1,data dictionary,0 comments,test setup,second session

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Alex Fatkulin's Blog | afatkulin.blogspot.com Reviews

https://afatkulin.blogspot.com

Saturday, March 07, 2015. Converting non-CDB database to a PDB when TDE is in use. Converting a non-CDB database to a PDB is a rather straightforward process. However once TDE (Transparent Data Encryption) gets involved certain things become not so obvious so I've decided to write a small guide on how to accomplish that. In order for a non-CDB database to be converted to a PDB it's version needs to be at least 12.1.0.2.0. My encryption wallet location is set to the following (sqlnet.ora):. Dbca -silent -...

INTERNAL PAGES

afatkulin.blogspot.com

1

Alex Fatkulin's Blog: November 2013

http://afatkulin.blogspot.com/2013_11_01_archive.html

Tuesday, November 26, 2013. Result Cache Latch and PDBs. One interesting aspect of Oracle 12cR1 database when it comes to PDBs is how latching is done. For example, if all PDBs have to work under the same latch then contention in one PDB can easily affect users in other PDBs too. Continuing my series of posts on the Result Cache latch today I'll check what happens when you try to acquire RC latch from two different PDBs. The first session is connected under container name TEST. SQL select event, p1, to c...

2

Alex Fatkulin's Blog: December 2013

http://afatkulin.blogspot.com/2013_12_01_archive.html

Tuesday, December 03, 2013. Oracle 12cR1, UDF Pragma and HyperLogLog. One interesting enhancement in 12cR1 PL/SQL is UDF pragma. Which has the following description:. The UDF pragma tells the compiler that the PL/SQL unit is a user defined function that is used primarily in SQL statements, which might improve its performance. I though it would be very cool to try it out with my HyperLogLog post. I did recently and see if it results in any measurable performance improvement. In order to make in-memory PQ.

3

Alex Fatkulin's Blog: August 2014

http://afatkulin.blogspot.com/2014_08_01_archive.html

Tuesday, August 19, 2014. Zone Map Zone ID's. Just a quick follow up to my previous post. On how Zone ID's are calculated. Let's take the following example:. SQL select rid, sys op zone id(rid) zone id 2 from 3 ( 4 select chartorowid('AAAS5KAAHAAABYDAAA') rid 5 from dual 6 ); RID ZONE ID - - - - - - - - - - - - - - - AAAS5KAAHAAABYDAAA 324580438021. Recalling that extended ROWID. Has the following format (a nice picture from Oracle Documentation. In the binary format that would correspond to:. SQL select...

4

Alex Fatkulin's Blog: September 2014

http://afatkulin.blogspot.com/2014_09_01_archive.html

Monday, September 08, 2014. Zone Maps On Commit Refresh Oddities. One of the ways Zone Maps can be refreshed when the underlying table data is changed is fast on commit. This is similar to how materialized views can be refreshed with the exception that a Zone Map does not need a materialized view log to do so. It can also lead to some peculiar side effects. Let's begin by creating a test table with the on commit refresh materialized zone map:. Zone Staleness (first session). So what happens if some other...

5

Alex Fatkulin's Blog: July 2013

http://afatkulin.blogspot.com/2013_07_01_archive.html

Thursday, July 25, 2013. Just a quick note that I'll be presenting at this year's Enkitec E4. Conference. You can find the schedule here. I did some under the hood investigation regarding how the whole DBFS stack works from the performance perspective and, needless to say, some findings simply left me startled. If you want to see a session which will forever change the way you look at DBFS then this will definitely be the one to attend. Posted by Alex Fatkulin. Links to this post. Tuesday, July 23, 2013.

UPGRADE TO PREMIUM TO VIEW 13 MORE

TOTAL PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

orastory.wordpress.com

Epoch | OraStory

https://orastory.wordpress.com/2015/06/26/epoch

Dominic Brooks on Oracle Performance, Tuning, Data Quality and Sensible Design … (Now with added Sets Appeal). SQL Plan Baseline Manual Evolution. SQL Plan Management Choices →. June 26, 2015. Note to self because it’s just one of those date/timezone-related topics which just doesn’t seem to stick…. Epoch/Unix time – See https:/ en.wikipedia.org/wiki/Unix time. Firstly when converting from Oracle date or timestamp – we need to work from UTC not local time. Assuming that this timestamp is in milliseconds:.

juanjosemtz.blogspot.com

Juan Jose Martinez: Transparent Data Encryption Parte 1 de 2

http://juanjosemtz.blogspot.com/2009/03/transparent-data-encryption-parte-1-de.html

Stephen Hawking alguna vez dijo -The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge- Asi que este Blog esta creado para compratir mis experiencias en el campo de Tecnologías de Información para las áreas de Base de Datos Oracle, Administración del Desempeño y Planeación de la Capacidad. Viernes, 6 de marzo de 2009. Transparent Data Encryption Parte 1 de 2. 9632; Columnas con índices que no sean del tipo B-tree. 9632; Tipos de datos LONG, BLOB, CLOB. Para este artículo anali...

weidongzhou.wordpress.com

My Big Data World | Page 2

https://weidongzhou.wordpress.com/page/2

My Big Data World. Newer posts →. Disabling Firewall after Turning off Firewall. October 4, 2016. Many applications requires to disable firewall on Linux. The most common used commands are as follows:. Stop the ipchains service. Stop the iptables service. Stop the ipchains service after reboot. Stop the iptables service after reboot. Another popular one is to set SELINUX=disabled. File to disable some extra security restrictions. On a Red Hat Linux VM and connect it to an Oracle Big Data Appliance. Root@...

aprakash.wordpress.com

Silent Upgrade Oracle GoldenGate 12.1.2.0.0 to 12.1.2.1.2 | Anand's Blog

https://aprakash.wordpress.com/2015/04/21/silent-upgrade-oracle-goldengate-12-1-2-0-0-to-12-1-2-1-2

My experiences and views on Oracle Database. Silent Upgrade Oracle GoldenGate 12.1.2.0.0 to 12.1.2.1.2. April 21, 2015. April 21, 2015. Today I worked on silent upgrade of Oracle GoldenGate from 12.1.2.0.0 to 12.1.2.1.2, so thought to blog it which might help some of you. These are the steps I performed. Current GoldenGate Home – /oracle/app/product/ogg12.1.2. 1 Gather the details of GoldenGate Processes before stopping them. 2 Backup the existing binaries and associated files needed for your environment.

tonguc.wordpress.com

My Favorite Links | Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

https://tonguc.wordpress.com/my-favorite-links

Extract(Read) Transform(Test&Apply) Load(Learn) Blog. Oracle body building – oracle-l. Http:/ www.freelists.org/archives/oracle-l/feed.rss. Ixora by Steve Adams(Unix and Oracle form a powerful combination.). Http:/ www.ixora.com.au. Do you really want to be an Oracle-(wo)man? Http:/ asktom.oracle.com. Morgan Daniel’s Oracle SQL and PL/SQL Library. Http:/ www.morganslibrary.org/library.html. Joe Fuda’s Oracle SQL Snippets/Tutorials. Http:/ www.sqlsnippets.com/. Cary Millsap’s Oracle blog. Http:/ afatkulin...

leonotes.wordpress.com

LEO Notes | 第2页

https://leonotes.wordpress.com/page/2

Get partition definition using function. 一月 13, 2017. 获取所有RANGE分区的表分区的定义，脚本运行环境为Oracle 11.2.0.4，Oracle 10g去掉INTERVAL字段。 Insert log data into clob using plsql. 一月 13, 2017. 今天开发的一个同事想用PLSQL插入一些数据到CLOB字段，字符串较长，报错PLS-00172: string literal too long。 Orace Text Index-part4-contains query. 一月 10, 2017. 例如我想查询Blue Smith，Oracle Text index就无法返回Smith Blue这种记录。对于这种时候，我们可能希望全文索引能返回给我们Smith Blue或者Blue A Smith。 SQL commit; 提交完成。 SQL execute ctx ddl.sync index('IDX1 T LEXER'); PL/SQL 过程已成功完成。 SQL select id, create dat...

leonotes.wordpress.com

Oracle Text Index-part3 | LEO Notes

https://leonotes.wordpress.com/2016/12/30/oracle-text-index-part3

Orace Text Index-part4-contains query →. 十二月 30, 2016. 包含smith的记录ID为8，9，11，12，从DR$IDX1 T LEXER$I中获得到的TOKEN起始为8-12，TOKEN COUNT有4行，下面的输出记录了这些信息。 SQL COL TOKEN TEXT FOR A10 SQL COL TOKEN LASR FOR A10 SQL select token text,TOKEN TYPE,TOKEN FIRST,TOKEN LAST,TOKEN COUNT from DR$IDX1 T LEXER$I WHERE TOKEN TEXT = 'SMITH'; TOKEN TEXT TOKEN TYPE TOKEN FIRST TOKEN LAST TOKEN COUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - SMITH 0 8 12 4. Orace Text Index-part4-contains query →. Address never made public).

UPGRADE TO PREMIUM TO VIEW 147 MORE

TOTAL LINKS TO THIS WEBSITE

154

OTHER SITES

afatknackercycles.blogspot.com

A Fat Knacker Cycles

A Fat Knacker Cycles. My journey from 16 stone 7 llbs back to somewhere near normality using my bike. Thursday, 7 May 2015. I visited Bicycle doctor. Wednesday, 6 May 2015. The GT rides again. My GT in the works bike store. Wednesday, 29 April 2015. Let there be light. Saturday, 25 April 2015. I passed by and called into Gatley bikefest today. Gatley is near Stockport and had a chat with the owners of these two bikes. Different ends of the spectrum but both interesting. A Surley big dummy. I probably won...

afatkulin.blogspot.com

Alex Fatkulin's Blog

Saturday, March 07, 2015. Converting non-CDB database to a PDB when TDE is in use. Converting a non-CDB database to a PDB is a rather straightforward process. However once TDE (Transparent Data Encryption) gets involved certain things become not so obvious so I've decided to write a small guide on how to accomplish that. In order for a non-CDB database to be converted to a PDB it's version needs to be at least 12.1.0.2.0. My encryption wallet location is set to the following (sqlnet.ora):. Dbca -silent -...

afatl.com

Alliance Française d'Atlanta: French Cultural and Language Center -

Alliance Française d'Atlanta: French Cultural and Language Center. Summer Camps & Youth Programs. French Clubs in Atlanta. News & Around Town. Join Our Mailing List. Staff & Board. Jobs & Internships. Learning and Travel Resources. Choose from a variety of unique classes combining French with other topics and activities. Learn more about Culturethèque, the French e-library included in your Alliance Française membership! Come talk to faculty and staff, and lovers of language, arts and culture. Live, dange...

afatlady.com

A Fat Lady | Take the journey of a healthier life and smaller waist with A Fat Lady

Get me outta here! Take the journey of a healthier life and smaller waist with A Fat Lady. June 30, 2013. Hi world, fat lady here. As I am want to do, I have failed again in my search for a healthier me. June 2013 is nearly past (my original date for something to be done), and I am looking the same as before. Ho Hum. My issue today is, that although I have failed and have done so many times before, perhaps if I was more upset about this, then I would be more motivated? Click to share on Twitter. So, I&#8...

afatlanta.extranet-aec.com

Extranet Alliance Française d'Atlanta :

A French-American cultural center and non-profit organization. Email to the Student. Id or email box. And use the new password. Are a new student. Class, click on Register. To login in the future. Please login to access your account :. See your classes, grades obtained and register in the next class. Student Id. or e-mail. First time visiting :. And register online in the class of your choice. See the product list.