text:
Feed aggregator
PFCLScan Updated and Powerful features
We have just updated PFCLScan our companies database security scanner for Oracle databases to version 1.2 and added some new features and some new contents and more. We are working to release another service update also in the next couple....[Read More]
Posted by Pete On 04/09/13 At 02:45 PM
Oracle Security Training, 12c, PFCLScan, Magazines, UKOUG, Oracle Security Books and Much More
It has been a few weeks since my last blog post but don't worry I am still interested to blog about Oracle 12c database security and indeed have nearly 700 pages of notes in MS Word related to 12c security....[Read More]
Posted by Pete On 28/08/13 At 05:04 PM
Bordering Text
A tough little question appeared on one of our internal mailing lists today that piqued my interest. A customer wanted to place a border around all data fields in their BIP output. Something like this:
Naturally you think of using a table, embedding the field inside a cell and turning the cell border on. That will work but will need some finessing to get the cells to stretch or shrink depending on the width of the runtime text. Then things might get a bit squirly (technical term) if the text is wide enough to force a new line at the page edge. Anyway, it will get messy. So I took a look at the problem to see if the fields can be isolated in the page as far as the XSLFO code is concerned. If the field can be siolated in its own XSL block then we can change attribute values to get the borders to show just around the field. Sadly not.
This is an embedded field YEARPARAM in a sentence.
translates to
<fo:inline height="0.0pt" style-name="Normal" font-size="11.0pt" style-id="s0" white-space-collapse="false" font-family-generic="swiss" font-family="Calibri" xml:space="preserve">This is an embedded field <xsl:value-of select="(.//YEARPARAM)[1]" xdofo:field-name="YEARPARAM"/> in a sentence.</fo:inline>
If we change the border on tis, it will apply to the complete sentence. not just the field.
So how could I isolate that field. Well we could actually do anything to the field. embolden, italicize, etc ... I settled on changing the background color (its easy to change it back with a single attribute call.) Using the highlighter tool on the Home tab in Word I change the field to have a yellow background. I now have:
This gives me the following code.
<fo:block linefeed-treatment="preserve" text-align="start" widows="2" end-indent="5.4pt" orphans="2" start-indent="5.4pt" height="0.0pt" padding-top="0.0pt" padding-bottom="10.0pt" xdofo:xliff-note="YEARPARAM" xdofo:line-spacing="multiple:13.8pt"> <fo:inline height="0.0pt" style-name="Normal" font-size="11.0pt" style-id="s0" white-space-collapse="false" font-family-generic="swiss" font-family="Calibri" xml:space="preserve">This is an embedded field </fo:inline> <fo:inline height="0.0pt" style-name="Normal" font-size="11.0pt" style-id="s0" white-space-collapse="false" font-family-generic="swiss" font-family="Calibri" background-color="#ffff00"> <xsl:attribute name="background-color">white</xsl:attribute> <xsl:value-of select="(.//YEARPARAM)[1]" xdofo:field-name="YEARPARAM"/> </fo:inline> <fo:inline height="0.0pt" style-name="Normal" font-size="11.0pt" style-id="s0" white-space-collapse="false" font-family-generic="swiss" font-family="Calibri" xml:space="preserve"> in a sentence.</fo:inline> </fo:block>
Now we have the field isolated we can easily set other attributes that will only be applied to the field and nothing else. I added the following to my YEARPARAM field:
<?attribute@inline:background-color;'white'?> >>> turn the background back to white
<?attribute@inline:border-color;'black'?> >>> turn on all borders and make black
<?attribute@inline:border-width;'0.5pt'?> >>> make the border 0.5 point wide
<?YEARPARAM?> >>> my original field
The @inline tells the BIP XSL engine to only apply the attribute values to the immediate 'inline' code block i.e. the field. Collapse all of this code into a single line in the field.
When I run the template now, I see the following:
Its a little convoluted but if you ignore the geeky code explanation and just highlight/copy'n'paste, its pretty straightforward.
Capturing SQL Server IO Latencies for a Period of Time with PowerShell
Today's blog post is a demonstration of the PowerShell approach to Paul Randal's recent blog post, Capturing IO Latencies for a Period of Time. Since wait statistics were properly implemented in SQL Server, it turned into a powerful resource to diagnose and troubleshoot SQL Server issues.
Paul Randal is, IMHO, one of the best names in this technology. I requested his approval to use and modify his code to demonstrate another approach that can be used not only in this situation, but in others where you need to capture data in an interval and don't want to use SQL Server resources. Paul, as always, was very kind to allow me to use his implementation to demonstrate mine—thanks a lot, Paul.
In his excellent blog post Capturing IO Latencies for a Period of Time, Paul demonstrates how to capture the wait stats in an interval of 30 minutes using only T-SQL.
If you have a very busy system perhaps leaving this job to trigger the gathering to another resource than SQL Server may be a good idea. Those who know me, know that I am PowerShell lover, so let's take a look how to do that using PowerShell.
Before we proceed, I strongly encourage readers to check out my good friend Ed Wilson's fantastic blog post Use Asynchronous Event Handling in PowerShell to understand timer event handlers, asynchronous .NET events, or the cmdlets to work with events.
A quick note about .NET System.Timers.Timer class.
It is simple—the namespace System.Timers fires an event in a specific interval and the class Timer generates recurring events. In other words, I can set up an event to be fired on each x unit of time (milliseconds.)
The first thing to do it it is to create the object System.Timers.Timer and define the interval that we want. For now, let's use 500 milliseconds by setting the property interval.
$Timer= New-Object System.Timers.Timer -Property @{ Interval = 100;autoreset=$true }
We instanced the timer and set up the interval. Now we need to register the object (in the case object $timer) that will fire the event and execute the action. For that we will use the Register-Objectevent cmdlet The parameter Eventname we will use Elapsed that is detailed in Use Asynchronous Event Handling in PowerShell and also in Manage Event Subscriptions with PowerShell.
First, let's just print something on the screen:
Register-ObjectEvent -InputObject$timer -Action { Write-Host'Holy PowerShell. It Worked!!!! '} -EventName Elapsed -SourceIdentifier stateful
Id Name State HasMoreData Location Command
– —- —– ———– ——– ——-
1 93ce50c3-6f5… NotStarted False Write-Host 'Holy Powe…
If you simply run this code, you will realize that after 30 seconds nothing happens.
Wait, PowerShell is broken? No my dear friend, the .net class is so beautiful that it allows you start and stop the suppression of the event. Yes, you can start the event and will be recurring every 30 seconds, and also stop it.
So let's start:
Holy PowerShell. It Worked!!!!
Holy PowerShell. It Worked!!!!
Holy PowerShell. It Worked!!!!
Holy PowerShell. It Worked!!!!
Holy PowerShell. It Worked!!!!
Holy PowerShell. It Worked!!!!
Holy PowerShell. It Worked!!!!
And to stop it :
And to Unregister the event use :
Unregister-Event -SourceIdentifier stateful
How PowerCool is that?
Let's get back to our example. Using Paul's code, let's first create the table to store the data. I did some changes to store the date and time so you also can have the historical data if you want and the table is physical.
SELECT [database_id], [file_id], [num_of_reads], [io_stall_read_ms],
[num_of_writes], [io_stall_write_ms], [io_stall],
[num_of_bytes_read], [num_of_bytes_written], [file_handle]
INTO IOLatency
FROM sys.dm_io_virtual_file_stats(NULL, NULL);
alter table IOLatency add [TimeCapture] datetime default getdate()
alter table IOLatency add [Identifier] bigint
I added this column identifier because my TSQL it is not so great and I want (like Paul's example) to get the difference between the last top samples between 30 minutes, so this column will have the same value for the last two gatherings and I can easily create the TSQL condition for that.
Now let's play with PowerShell: We need to import the module SQLPS to use the invoke-sqlcmd cmdlet . Also in the Action parameter of the Register-Objectevent cmdlet I am using a scriptblock variable to be more friendly readable. Also I am using the interval as Paul, 30 minutes, so the difference always will be in the 2 last same date times with 30 minutes of difference.
$Timer=New-Object System.Timers.Timer -Property @{ Interval = 1800000 ;autoreset=$true } #1800000 30 minutes in milliseconds
#Create the ScriptBlock variable to run in the action parameter in the register-objectevent cmdlet
$Action= {
#Import the SQLPS Module
Import-Module SQLPS -ErrorAction SilentlyContinue -DisableNameChecking;
#variable to counter the numb er of the events
$Script:counter+= 1;
#if the events is more than 2 , increase the the identity
if ($counter-eq 3) {
$script:Identity+= 1;
$counter= 1
#Define the TSQL
$Tsql =@"
insert into IOLatency ([database_id], [file_id], [num_of_reads], [io_stall_read_ms],
[num_of_writes], [io_stall_write_ms], [io_stall],
[num_of_bytes_read], [num_of_bytes_written], [file_handle],[Identifier])
SELECT [database_id],[file_id], [num_of_reads], [io_stall_read_ms],
[num_of_writes], [io_stall_write_ms], [io_stall],
[num_of_bytes_read], [num_of_bytes_written], [file_handle],$($Identity)
FROM sys.dm_io_virtual_file_stats (NULL, NULL);
#Invoke the TSQL
invoke-sqlcmd -ServerInstance vader -Database Test -Query$Tsql
Register-ObjectEvent-InputObject$timer -Action $Action -EventNameelapsed -SourceIdentifierstateful
Not it is juts start ….
And every 30 minutes the table IOLatency will be populated. If you want to stop the gathering but not unregistered the event :
This way if you want to start again, just timer.start().
Now it is time to get the data. Using The Paul´s query with a change to get the same identifier :
WITH [DiffLatencies] AS
– Files that weren't in the first snapshot
FROM IOLatency AS [ts2]
LEFT OUTER JOIN IOLatency AS [ts1]
ON [ts2].[file_handle] = [ts1].[file_handle]
and ts2.Identifier = ts1.Identifier
WHERE [ts1].[file_handle] IS NULL
– Diff of latencies in both snapshots
[ts2].[num_of_reads] – [ts1].[num_of_reads] AS [num_of_reads],
[ts2].[io_stall_read_ms] – [ts1].[io_stall_read_ms] AS [io_stall_read_ms],
[ts2].[num_of_writes] – [ts1].[num_of_writes] AS [num_of_writes],
[ts2].[io_stall_write_ms] – [ts1].[io_stall_write_ms] AS [io_stall_write_ms],
[ts2].[io_stall] – [ts1].[io_stall] AS [io_stall],
[ts2].[num_of_bytes_read] – [ts1].[num_of_bytes_read] AS [num_of_bytes_read],
[ts2].[num_of_bytes_written] – [ts1].[num_of_bytes_written] AS [num_of_bytes_written]
FROM IOLatency AS [ts2]
LEFT OUTER JOIN IOLatency AS [ts1]
ON [ts2].[file_handle] = [ts1].[file_handle]
and ts2.Identifier = ts1.Identifier
WHERE [ts1].[file_handle] IS NOT NULL)
DB_NAME([vfs].[database_id]) AS [DB],
LEFT([mf].[physical_name], 2) AS [Drive],
[num_of_reads] AS [Reads],
[num_of_writes] AS [Writes],
[ReadLatency(ms)] =
CASE WHEN [num_of_reads] = 0
THEN 0 ELSE ([io_stall_read_ms] / [num_of_reads]) END,
[WriteLatency(ms)] =
CASE WHEN [num_of_writes] = 0
THEN 0 ELSE ([io_stall_write_ms] / [num_of_writes]) END,
/*[Latency] =
CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)
THEN 0 ELSE ([io_stall] / ([num_of_reads] + [num_of_writes])) END,*/
[AvgBPerRead] =
CASE WHEN [num_of_reads] = 0
THEN 0 ELSE ([num_of_bytes_read] / [num_of_reads]) END,
[AvgBPerWrite] =
CASE WHEN [num_of_writes] = 0
THEN 0 ELSE ([num_of_bytes_written] / [num_of_writes]) END,
/*[AvgBPerTransfer] =
CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)
(([num_of_bytes_read] + [num_of_bytes_written]) /
([num_of_reads] + [num_of_writes])) END,*/
FROM [DiffLatencies] AS [vfs]
JOIN sys.master_files AS [mf]
ON [vfs].[database_id] = [mf].[database_id]
AND [vfs].[file_id] = [mf].[file_id]
– ORDER BY [ReadLatency(ms)] DESC
ORDER BY [Identifier],[WriteLatency(ms)] DESC;
If you want to to get only one sample , just add a
ON [vfs].[database_id] = [mf].[database_id]
AND [vfs].[file_id] = [mf].[file_id]
AND [vfs].identifier = <IdentifierNumber>
This way you also can know what time was made this gathering, just checking the timecapture column in the identifier number. In other words, you also have a historical data that you can query and get the differences or make any calculations that you need.
The data is stored—you can play with whatever query you want and need.
If you are thinking of gathering perfmon counters, it is possible too. Take a look at my blog post on Simple-Talk, The PoSh DBA – Specifying and Gathering Performance Counters and just play with the timer class.
I guess that you realize you can use this approach in any scenario that you need to capture data in a busy system without using any kind (or a minimum) of SQL Server resources. IMHO, that can be a good approach in those kind environments
Again, I would like to thank Paul Randal for kindly allowing me to use and modify to use his code and blog post to demonstrate my approach, and of course the Hey, Scripting Guy! blog.
Remember kids… If it is PowerCool, it is PowerShell!
Android Update: 5.0
After this upgrade, many things changed, like the system settings:
But everything is slower than before.... ;-(
For a complete history of all updates visit this posting.
Gilbane Conference 2014 - Boston
Oracle is proud to be a sponsor of the 2014 Gilbane Content and Digital Experience Conference. The Gilbane Conference brings together industry experts, content managers, marketers, marketing technologists, technology and executive strategists to share experiences and explore the most effective technologies and approaches to help enterprises build agile, sustainable digital experiences.Event Details: Oracle Sponsors Gilbane 2014: Content and the Digital Experience Dec. 2nd – 4th Renaissance Boston Waterfront Hotel 606 Congress Street, Boston, MA 02210 Show Registration | Evite
Oracle Presence:
- Oracle Booth: Oracle WebCenter: Creating Next-Gen Digital Experiences
- Oracle Presentation & Product Lab: Creating Next-Gen Digital Experiences - Wednesday, December 3, 12:40 p.m. – 1:25 p.m.
- Presented by: Chris Preston, Senior Director, Oracle & Gary Matsell, Principal Sales Consultant WebCenter, Oracle
- Attendees will learn how to:
- Attract and engage customers with relevant, interactive, and intuitive experiences
- Deliver self-service experiences that are personalized, integrated, and secure
- Engage and convert customers with consistent, contextual, and multi-channel experiences
Better Ed Tech Conversations
This is another follow-up to the comments thread on my recent LMS rant. As usual, Kate Bowles has insightful and empathetic comments:
…From my experience inside two RFPs, I think faculty can often seem like pretty raucous bus passengers (especially at vendor demo time) but in reality the bus is driven by whoever's managing the RFP, to a managed timetable, and it's pretty tightly regulated. These constraints are really poorly understood and lead to exactly the predictable and conservative outcomes you observe. Nothing about the process favours rethinking what we do.
Take your focus on the gradebook, which I think is spot on: the key is how simply I can pull grades in, and from where. The LMS we use is the one with the truly awful, awful gradebook. Awful user experience, awful design issues, huge faculty development curve even to use it to a level of basic competence.
The result across the institution is hostility to making online submission of assignments the default setting, as overworked faculty look at this gradebook and think: nope.
So beyond the choosing practice, we have the implementation process. And nothing about this changes the mind of actual user colleagues. So then the institutional business owner group notices underuse of particular features—oh hey, like online submission of assignments—and they say to themselves: well, we need a policy to make them do it. Awfulness is now compounding.
But then a thing happens. Over the next few years, faculty surreptitiously develop a workable relationship with their new LMS, including its mandated must-use features. They learn how to do stuff, how to tweak and stretch and actually enjoy a bit. And that's why when checklist time comes around again, they plead to have their favourite corner left alone. They only just figured it out, truly.
If institutions really want to do good things online, they need to fund their investigative and staff development processes properly and continuously, so that when faculty finally meet vendors, all can have a serious conversation together about purpose, before looking at fit.
This comment stimulated a fair bit of conversation, some of which continued on the comments thread of Jonathan Rees' reply to my post.
The bottom line is that there is a vicious cycle. Faculty, who are already stretched to the limit (and beyond) with their workloads, are brought into a technology selection process that tends to be very tactical and time-constrained. Their response, understandably, tends to be to ask for things that will require less time from them (like an easier grade book, for example). When administrators see that they are not getting deep and broad adoption, they tend to mandate technology use. Which makes the problem worse rather than better because now faculty are forced to use features that take up more of their time without providing value, leaving them with less time to investigate alternatives that might actually add value. Round and round it goes. Nobody stops and asks, "Hey, do we really need this thing? What is it that we do need, and what is the most sensible way of meeting our needs?"
The only way out of this is cultural change. Faculty and administrators alike have work together toward establishing some first principles around which problems the technology is supposed to help them solve and what a good solution would look like. This entails investing time and university money in faculty professional development, so that they can learn what their options are and what they can ask for. It entails rewarding faculty for their participation in the scholarship of teaching. And it entails faculty seeing educational technology selection and policy as something that is directly connected to their core concerns as both educational professionals and workers.
Sucky technology won't fix itself, and vendors won't offer better solutions if customers can't define "better" for them. Nor will open source projects fare better. Educational technology only improves to the extent that educators develop a working consensus regarding what they want. The technology is a second-order effect of the community. And by "community," I mean the group that collectively has input on technology adoption decisions. I mean the campus community.
The post Better Ed Tech Conversations appeared first on e-Literate.
Partner Webcast – Business Continuity with Oracle Weblogic 12c
We share our skills to maximize your revenue!
12c: Enhancements to Partition Exchange Load
RSS content
Statistics for Partitioned Tables
Gathering statistics on partitioned tables consists of gathering statistics at both the table level and partition level. Prior to Oracle Database 11g, whenever a new partition was added, the entire table had to be scanned to refresh table-level statistics which could be very expensive, depending on the size of the table.
Incremental Global Statistics
With the introduction of incremental global statistics in 11g, the database, instead of performing a full table scan to compute global statistics, can derive global statistics from the partition level statistics. Some of the statistics, for example the number of rows, can be accurately derived by aggregating the values from partition statistics . However, the NDV of a column cannot be derived by aggregating partition-level NDVs. Hence, a structure called synopsis is maintained by the database for each column at the partition level which can be viewed as a sample of distinct values. The synopses for various partitions are merged by the database to accurately derive the NDV for each column.
Hence, when a new partition is added to a table, the database
- gathers statistics and creates synopses for the newly added partition,
- retrieves synopses for the existing partitions of the table and
- aggregates the partition-level statistics and synopses to create global statistics.
Thus, the need to scan the entire table to gather table level statistics on adding a new partition has been eliminated.
However, if partition exchange loads are performed and statistics for source table are available, statistics still need to be gathered for the partition after the exchange to obtain its synopsis.
Enhancements in Oracle 12c
Oracle Database 12c introduces new enhancements for maintaining incremental statistics. Now, DBMS_STATS can create a synopsis on a non-partitioned table as well. As a result, if you are using partition exchange loads, the statistics / synopsis for the source table will become the partition level statistics / synopsis after the load, so that the database can maintain incremental statistics without having to explicitly gather statistics on the partition after the exchange.
Let's demonstrate …
Source non-partitioned table : HR.SRC_TAB
Destination partitioned table: HR.PART_TAB
Destination partition : PMAR
– Create a partitioned table HR.PART_TAB with 3 partitions
- only 2 partitions contain data initially
- set preference incremental = true
- gather stats for the table – gathers statistics and synopses for 2 partitions
– create a non partitioned table HR.SRC_TAB which will used to load the 3rd partition using partition exchange
- Set table preferences for HR.SRC_TAB
- Gather stats for the source table: DBMS_STATS gathers table-level synopses also for the table
– Perform the partition exchange
– After the exchange, the the new partition has both statistics and a synopsis.
– Gather statitstics for PART_TAB – Employs partition level statistics and synopses to derive global statistics.
– Create and populate partitioned table part_tab with 3 partitions
PJAN, PFEB and PMAR
SQL>conn hr/hr drop table part_tab purge; create table part_tab (MNTH char(3), ID number, txt char(10)) partition by list (mnth) (partition PJAN values ('JAN'), partition PFEB values ('FEB'), partition PMAR values ('MAR')); insert into part_tab values ('JAN', 1, 'JAN1'); insert into part_tab values ('JAN', 2, 'JAN2'); insert into part_tab values ('JAN', 3, 'JAN3'); insert into part_tab values ('FEB', 2, 'FEB2'); insert into part_tab values ('FEB', 3, 'FEB3'); insert into part_tab values ('FEB', 4, 'FEB4'); commit;
– Note that
- partition PMAR does not have any data
- there are 4 distinct values in column ID i.e. 1,2,3 and 4
select 'PJAN' Partition, mnth, id from part_tab partition (PJAN) union select 'PFEB' Partition, mnth, id from part_tab partition (PFEB) union select 'PMAR' Partition, mnth, id from part_tab partition (PMAR) order by 1 desc; PART MNT ID ---- --- ---------- PJAN JAN 1 PJAN JAN 2 PJAN JAN 3 PFEB FEB 2 PFEB FEB 3 PFEB FEB 4
– Set preference Incremental to true for the table part_tab
SQL>begin dbms_stats.set_table_prefs ('HR','PART_TAB','INCREMENTAL','TRUE'); end; / select dbms_stats.get_prefs ('INCREMENTAL','HR','PART_TAB') from dual; DBMS_STATS.GET_PREFS('INCREMENTAL','HR','PART_TAB') ---------------------------------------------------- TRUE
-- Gather statistcs for part_tab
SQL> exec dbms_stats.gather_table_stats('HR','PART_TAB');
– Note that global statistics have been gathered and the table has been analyzed at 16:02:31
SQL>alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss'; col table_name for a12 select table_name, num_rows, last_analyzed from user_tables where table_name='PART_TAB'; TABLE_NAME NUM_ROWS LAST_ANALYZED ------------ ---------- -------------------- PART_TAB 6 17-nov-2014 16:02:31
– A full table scan was performed and stats were gathered for each of the partitions
All the partitions have been analyzed at the same time as table i.e. at 16:02:31
SQL> col partition_name for a15 select partition_name, num_rows,last_analyzed from user_tab_partitions where table_name = 'PART_TAB' order by partition_position; PARTITION_NAME NUM_ROWS LAST_ANALYZED --------------- ---------- -------------------- PJAN 3 17-nov-2014 16:02:31 PFEB 3 17-nov-2014 16:02:31 PMAR 0 17-nov-2014 16:02:31
– NUM_DISTINCT correctly reflects that there are 4 distinct values in column ID
SQL> col column_name for a15 select TABLE_NAME, COLUMN_NAME, NUM_DISTINCT from user_tab_col_statistics where table_name = 'PART_TAB' and column_name = 'ID'; TABLE_NAME COLUMN_NAME NUM_DISTINCT ------------ --------------- ------------ PART_TAB ID 4
– Create source unpartitioned table SRC_TAB
– Populate SRC_TAB with records for mnth = MAR
and introduce two new values for column ID i.e. 0 and 5
SQL>drop table src_tab purge; create table src_tab (MNTH char(3), ID number, txt char(10)); insert into src_tab values ('MAR', 0, 'MAR0'); insert into src_tab values ('MAR', 2, 'MAR2'); insert into src_tab values ('MAR', 3, 'MAR3'); insert into src_tab values ('MAR', 5, 'MAR5'); commit;
– Set preferences for table src_tab
SQL>begin dbms_stats.set_table_prefs ('HR','SRC_TAB','INCREMENTAL','TRUE'); dbms_stats.set_table_prefs ('HR','SRC_TAB','INCREMENTAL_LEVEL','TABLE'); end; / col incremental for a15 col incremental_level for a30 select dbms_stats.get_prefs ('INCREMENTAL','HR','SRC_TAB') incremental, dbms_stats.get_prefs ('INCREMENTAL_LEVEL','HR','SRC_TAB') incremental_level from dual; INCREMENTAL INCREMENTAL_LEVEL --------------- ------------------------------ TRUE TABLE
– Gather stats and synopsis for table SRC_TAB and note that table is analyzed at 16:06:03
SQL>exec dbms_stats.gather_table_stats('HR','SRC_TAB'); col table_name for a12 select table_name,num_rows, last_analyzed from user_tables where table_name='SRC_TAB'; TABLE_NAME NUM_ROWS LAST_ANALYZED ------------ ---------- -------------------- SRC_TAB 4 17-nov-2014 16:06:33
– Exchange partition –
SQL>alter table part_tab exchange partition PMAR with table SRC_TAB;
– Note that table level stats for part_tab are still as earlier
as stats have not been gathered for it after partition exchange
SQL> col table_name for a12 select table_name, num_rows, last_analyzed from user_tables where table_name='PART_TAB'; TABLE_NAME NUM_ROWS LAST_ANALYZED ------------ ---------- -------------------- PART_TAB 6 17-nov-2014 16:02:31
– NDV for col ID is still same as earlier i.e. 4 as stats
have not been gathered for table after partition exchange
SQL> col column_name for a15 select TABLE_NAME, COLUMN_NAME, NUM_DISTINCT from user_tab_col_statistics where table_name = 'PART_TAB' and column_name = 'ID'; TABLE_NAME COLUMN_NAME NUM_DISTINCT ------------ --------------- ------------ PART_TAB ID 4
– Note that stats for partition PMAR have been copied from
src_tab. Last_analyzed column for Pmar has been updated
and shows same value as for table src_tab i.e. 16:06:33
Also, num_rows are shown as 4
SQL> col partition_name for a15 select partition_name, num_rows,last_analyzed from user_tab_partitions where table_name = 'PART_TAB' order by partition_position; PARTITION_NAME NUM_ROWS LAST_ANALYZED --------------- ---------- -------------------- PJAN 3 17-nov-2014 16:02:31 PFEB 3 17-nov-2014 16:02:31 PMAR 4 17-nov-2014 16:06:33
– Gather stats for table part_tab
SQL>exec dbms_stats.gather_table_stats('HR','PART_TAB');
– While gathering stats for the table, partitions have not been
scanned as indicated by the same value as earlier in column LAST_ANALYZED.
SQL> col partition_name for a15 select partition_name, num_rows,last_analyzed from user_tab_partitions where table_name = 'PART_TAB' order by partition_position; PARTITION_NAME NUM_ROWS LAST_ANALYZED --------------- ---------- -------------------- PJAN 3 17-nov-2014 16:02:31 PFEB 3 17-nov-2014 16:02:31 PMAR 4 17-nov-2014 16:06:33
– Note that num_rows for the table part_tab has been updated by adding up the values from various partitions using partition level statistics
Column LAST_ANALYZED has been updated for the table
SQL> col table_name for a12 select table_name, num_rows, last_analyzed from user_tables where table_name='PART_TAB'; TABLE_NAME NUM_ROWS LAST_ANALYZED ------------ ---------- -------------------- PART_TAB 10 17-nov-2014 16:11:26
– NDV for column ID has been updated to 6 using the synopsis for partition PMAR as copied from table src_tab
SQL> col column_name for a15 select TABLE_NAME, COLUMN_NAME, NUM_DISTINCT from user_tab_col_statistics where table_name = 'PART_TAB' and column_name = 'ID'; TABLE_NAME COLUMN_NAME NUM_DISTINCT ------------ --------------- ------------ PART_TAB ID 6
– We can also confirm that we really did use incremental statistics by querying the dictionary table sys.HIST_HEAD$, which should have an entry for each column in the PART_TAB table.
SQL>conn / as sysdba col tabname for a15 col colname for a15 col incremental for a15 select o.name Tabname , c.name colname, decode (bitand (h.spare2, 8), 8, 'yes','no') incremental from sys.hist_head$ h, sys.obj$ o, sys.col$ c where h.obj# = o.obj# and o.obj# = c.obj# and h.intcol# = c.intcol# and o.name = 'PART_TAB' and o.subname is null; TABNAME COLNAME INCREMENTAL --------------- --------------- --------------- PART_TAB MNTH yes PART_TAB ID yes PART_TAB TXT yes
I hope this post was useful.
Your comments and suggestions are always welcome.
Related Links:
Comments: 0 (Zero), Be the first to leave a reply!
You might be interested in this:
- 11g R2 RAC: ADD A NODE
- 12c: USE_SID_AS_SERVICE_listener_name
- DOCUMENTED PARAMETERS IN 12c
- DATABASE 12c INDEX
The post 12c: Enhancements to Partition Exchange Load appeared first on ORACLE IN ACTION.
My DOAG session re:Server-side JavaScript
Will post shortly ablog re: JavaScript Stored Procedures.
Configuring Python cx_Oracle and mod_wsgi on Oracle Linux
The Web Server Gateway Interface (WSGI) is a standardized interface between web servers and Python web frameworks or applications. Many frameworks including Django support WSGI.
This post is a brief how-to about configuring Apache's mod_wsgi with Python's cx_Oracle driver for Oracle Database. The steps are for Oracle Linux.
Download Instant Client Basic & SDK ZIP files from OTN. For cx_Oracle, use the ZIPs, not the RPMs.
As root, unzip the files to the same directory, e.g.
mkdir /opt/oracle cd /opt/oracle unzip /tmp/instantclient-basic-linux.x64-126.96.36.199.0.zip unzip /tmp/instantclient-sdk-linux.x64-22.214.171.124.0.zip
Configure Instant Client:
cd /opt/oracle/instantclient_12_1 ln -s libclntsh.so.12.1 libclntsh.so
Install the pip package management tool for Python by following pip.readthedocs.org/en/latest/installing.html and downloading
get-pip.py. Then run:
python get-pip.py
Install cx_Oracle:
export LD_RUN_PATH=/opt/oracle/instantclient_12_1 export ORACLE_HOME=/opt/oracle/instantclient_12_1 pip install cx_Oracle
The key here is the use of
LD_RUN_PATH. This obviates the need to later set
LD_LIBRARY_PATHor configure
ldconfigfor cx_Oracle to find the Instant Client libraries. On Oracle Linux 7, which has Apache 2.4, setting
LD_LIBRARY_PATHisn't practical since
suEXECis used. Configuring
ldconfigis commonly used but has a potential problem that if multiple Oracle products exist, with possibly differing versions of Oracle libraries on the same machine, then there might be library clashes.
The cx_Oracle installer overloads the meaning of
ORACLE_HOME. This variable is not normally used for Instant Client installations.
LD_RUN_PATHneeds to be set at runtime.
Install mod_wsgi:
yum install mod_wsgi
Add this line to
WSGIScriptAlias /wsgi_test /var/www/html/wsgi_test.py
On Oracle Linux 7, start the web server with:
systemctl start httpd.service
On Oracle Linux 6 use:
service httpd start
Create a test file
/var/www/html/wsgi_test.pythat connects to your database:
#-*- coding: utf-8 -*- def query(): import cx_Oracle db = cx_Oracle.connect("hr", "welcome", "localhost/orcl") cursor = db.cursor() cursor.execute("select city from locations where location_id = 2200") return cursor.fetchone()[0] def wsgi_test(environ, start_response): output = query() status = '200 OK' headers = [('Content-type', 'text/plain'), ('Content-Length', str(len(output)))] start_response(status, headers) yield output application = wsgi_test
http://localhost/wsgi_testin a browser. The city of the queried location id will be displayed.
That's it. Let me know how it works for you.
Information on cx_Oracle can be found here.
Information on Oracle Linux can be found here.
Information on Oracle Database can be found here.
Off May Not Be Totally Off: Is Oracle In-Memory Database 12c (18.104.22.168.0) Faster?
Most Oracle 12c installations will NOT be using the awesome Oracle Database in-memory features available starting in version 188.8.131.52.0. This experiment is about the performance impact of upgrading to 12c but disabling the in-memory features.
Every experiment I have performed comparing buffer processing rates, clearly shows any version of 12c performs better than 11g. However, in my previous post, my experiment clearly showed a performance decrease after upgrading from 184.108.40.206.0 to 184.108.40.206.0.
This posting is about why this occurred and what to do about it. The bottom line is this: make sure "off" is "totally off."
Turn it totally off, not partially off
What I discovered is by default the in-memory column store feature is not "totally disabled." My experiment clearly indicates that unless the DBA takes action, not only could they be a license agreement violation but a partially disabled in-memory column store slightly slows logical IO processing compared to the 12c non in-memory column store option. Still, any 12c version processes buffer faster than 11g.
My experiment: specific and targeted
This is important: The results I published are based on a very specific and targeted test and not on a real production load. Do not use my results in making a "should I upgrade decision." That would be stupid and an inappropriate use of the my experimental results. But because I publish every aspect of my experiment and it is easily reproducible it is a valid data point with which to have a discussion and also highlight various situations that DBAs need to know about.
You can download all my experimental results HERE. This includes the raw sqlplus output, the data values, the free R statistics package commands, spreadsheet with data nicely formatted and lots of histograms.
The instance parameter settings and results
Let me explain this by first showing the instance parameters and then the experimental results. There are some good lessons to learn!
Pay close attention to the inmemory_force and inmemory_size instance parameters.
SQL> show parameter inmemory
------------------------------------ ----------- ------------------------------
inmemory_clause_default string
inmemory_force string DEFAULT
inmemory_max_populate_servers integer 0
inmemory_query string ENABLE
inmemory_size big integer 0
inmemory_trickle_repopulate_servers_ integer 1
optimizer_inmemory_aware boolean TRUE
SQL> show sga
Total System Global Area 7600078848 bytes
Fixed Size 3728544 bytes
Variable Size 1409289056 bytes
Database Buffers 6174015488 bytes
Redo Buffers 13045760 bytes
In my experiment using the above settings the median buffers processing rate was 549.4 LIO/ms. Looking at the inmemory_size and the SGA contents, I assumed the in-memory column store was disabled. If you look at the actual experimental result file "Full ds2-v12-1-0-2-ON.txt", which contain the explain plan of the SQL used in the experiment, there is no mention of the in-memory column store being used. My assumption, which I think is a fair one, was that the in-memory column store had been disabled.
As you'll see I was correct, but only partially correct.
The parameter settings below are when the in-memory column store was totally disabled. They key is changing the default inmemory_force parameter value from DEFAULT to OFF.
SQL> show parameter inmemory
------------------------------------ ----------- ------------------------------
inmemory_clause_default string
inmemory_force string OFF
inmemory_max_populate_servers integer 0
inmemory_query string ENABLE
inmemory_size big integer 0
inmemory_trickle_repopulate_servers_ integer 1
optimizer_inmemory_aware boolean TRUE
SQL> show sga
Total System Global Area 7600078848 bytes
Fixed Size 3728544 bytes
Variable Size 1291848544 bytes
Database Buffers 6291456000 bytes
Redo Buffers 13045760 bytes
Again, the SGA does not show any in-memory memory space. In my experiment with the above "totally off" settings, the median buffers processing rate was 573.5 LIO/ms compared to "partially off" 549.4 LIO/ms. Lesson: Make sure off is truly off.
It is an unfair comparison!
It is not fair to compare the "partially off" with the "totally off" test results. Now that I know the default inmemory_force must be changed to OFF, the real comparison should be made with the non in-memory column store version 18.104.22.168.0 and the "totally disabled" in-memory column store version 18.104.22.168.0. This is what I will summarize below. And don't forget all 12c versions showed a significant buffer processing increase compared to 11g.
The key question: Should I upgrade?
You may be thinking, if I'm NOT going to license and use the in-memory column store, should I upgrade to version 220.127.116.11.0? Below is a summary of my experimental results followed by the key points.
1. The non column store version 184.108.40.206.0 was able to process 1.1% more buffers/ms (median: 581.7 vs 573.5) compared to to "totally disabled" in-memory column store version 188.8.131.52.0. While this is statistically significant, a 1.1% buffer processing difference is probably not going to make-or-break your upgrade.
2. Oracle Corporation, I'm told, knows about this situation and is working on a fix. But even if they don't fix it, in my opinion my experimental "data point" would not warrant not upgrading to the in-memory column store version 22.214.171.124.0 even if you are NOT going to use the in-memory features.
3. Visually (see below) the non in-memory version 22.214.171.124.0 and the "totally off" in-memory version 188.8.131.52.0 samples sets look different. But they are pretty close. And as I mentioned above, statistically they are "different."
Note for the statistically curious: The red color 126.96.36.199.0 non in-memory version data set is highly variable. I don't like to see this in my experiments. Usually this occurs when a mixed workload sometimes impacts performance, I don't take enough samples or my sample time duration is too short. To counteract this, in this experiment I captured 31 samples. I also performed the experiment multiple times and the results where similar. What I could have done was used more application data to increase the sample duration time. Perhaps that would have made the data clearer. I could have also used another SQL statement and method to create the logical IO load.
What I learned from this experiment
To summarize this experiment, four things come to mind:
1. If you are not using an Oracle Database feature, completely disable it. My mistake was thinking the in-memory column store was disabled when I set it's memory size to zero and "confirmed" it was off by looking at the SGA contents.
2. All versions of 12c I have tested are clearly faster at processing buffers than any version of 11g.
3. There is a very slight performance decrease when upgrading from Oracle Database version 220.127.116.11.0 to 126.96.36.199.0.
4. It is amazing to me that with all the new features poured into each new Oracle Database version the developers have been able to keep the core buffer processing rate nearly at or below the previous version. That is an incredible accomplishment. While some people may view this posting as a negative hit against the Oracle Database, it is actually a confirmation about how awesome the product is.
All the best in your Oracle performance tuning work!
Upgrading system's library/classes on 12c CDB/PDB environments
0 Mon Jul 07 09:12:54 ART 2014 META-INF/
71 Mon Jul 07 09:12:54 ART 2014 META-INF/MANIFEST.MF
3501 Mon Jul 07 09:12:30 ART 2014 oracle/ODCI/ODCIArgDesc.class
3339 Mon Jul 07 09:12:32 ART 2014 oracle/ODCI/ODCIArgDescList.class
1725 Mon Jul 07 09:12:32 ART 2014 oracle/ODCI/ODCIArgDescRef.class
2743 Mon Jul 07 09:12:52 ART 2014 oracle/ODCI/ODCIStatsOptions.class
1770 Mon Jul 07 09:12:54 ART 2014 oracle/ODCI/ODCIStatsOptionsRef.classThe complete list of classes do not reflect the list of object types that latest 12c RDBMS have, this list is about 38 types expanded later to more than 60 classes:SQL> select * from dba_types where type_name like 'ODCI%'
38 rows selectedso there is a clear difference between the classes included at ODCI.jar and the actual list of object types included into the RDBMS.Obviously these classes could be re-generated using JPublisher but I'll have to provide an input file with a template for case sensitive names, typically used in Java.To quickly create a JPublisher input file I'll execute this anonymous PLSQL block on JDeveloper logged as SYS at the CDB:set long 10000 lines 500 pages 50 timing on echo on
set serveroutput on size 1000000
for i in (select * from dba_types where type_name like 'ODCI%' order by type_name) loop
if (i.typecode = 'COLLECTION') then
dbms_output.put('SQL sys.'||i.type_name||' AS ');
FOR j in (select * from dba_source where owner=i.owner AND NAME=i.type_name) loop
if (substr(j.text,1,4) = 'TYPE') then
dbms_output.put(substr(j.text,6,length(j.name))||' TRANSLATE ');
dbms_output.put(upper(substr(j.text,instr(upper(j.text),' OF ')+4,length(j.text)-instr(upper(j.text),' OF ')-4))||' AS '||substr(j.text,instr(upper(j.text),' OF ')+4,length(j.text)-instr(upper(j.text),' OF ')-4));
end if;
end loop;
dbms_output.put('SQL sys.'||i.type_name||' AS ');
FOR j in (select * from dba_source where owner=i.owner AND NAME=i.type_name) loop
if (substr(j.text,1,4) = 'TYPE') then
dbms_output.put(substr(j.text,6,length(j.name))||' TRANSLATE ');
end if;
if (substr(j.text,1,1) = ' ') then
dbms_output.put(upper(substr(j.text,3,instr(j.text,' ',3)-3))||' AS '||substr(j.text,3,instr(j.text,' ',3)-3)||', ');
end if;
end loop;
end if;
end loop;
end;finally editing this file manually to remove latest coma sign I'll get this ODCI.in mapping file for JPublisher.With above file is possible to use an Ant task calling JPublisher utiliy as: description="Generate a new ODCI.jar file with ODCI types wrappers using JPublisher">
by executing above Ant task I'll have a new ODCI.jar with a content like:oracle@localhost:/u01/app/oracle/product/22.214.171.124.0/dbhome_1/rdbms/jlib$ jar tvf ODCI.jar
0 Sun Nov 16 21:07:50 ART 2014 META-INF/
106 Sun Nov 16 21:07:48 ART 2014 META-INF/MANIFEST.MF
0 Sat Nov 15 15:17:40 ART 2014 oracle/
0 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/
102696 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/AnyData.class
1993 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/AnyDataRef.class
17435 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/AnyType.class
1993 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/AnyTypeRef.class
3347 Sun Nov 16 21:07:46 ART 2014 oracle/ODCI/ODCIArgDesc.class
2814 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/ODCIArgDescList.class
2033 Sun Nov 16 21:07:46 ART 2014 oracle/ODCI/ODCIArgDescRef.class
2083 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/ODCITabFuncStatsRef.class
2657 Sun Nov 16 21:07:48 ART 2014 oracle/ODCI/ODCIVarchar2List.classWell now the new ODCI.jar is ready for uploading into the CDB, to simplify this task I'll put directly in a same directory as the original one:oracle@localhost:/u01/app/oracle/product/18.104.22.168.0/dbhome_1/rdbms/jlib$ mv ODCI.jar ODCI.jar.orig
oracle@localhost:/u01/app/oracle/product/188.8.131.52.0/dbhome_1/rdbms/jlib$ mv /tmp/ODCI.jar ./ODCI.jarNOTE: These next paragraph are examples to show that it will fail, see next paragraph to see the correct way.
To upload this new file into the CDB logged as SYS I'll execute:SQL> ALTER SESSION SET CONTAINER = CDB$ROOT;
SQL> exec sys.dbms_java.loadjava('-f -r -v -s -g public rdbms/jlib/ODCI.jar');to check if it works OK, I'll execute:SQL> select dbms_java.longname(object_name) from dba_objects where object_type='JAVA CLASS' and dbms_java.longname(object_name) like '%ODCI%';
63 rows selected.I assume a this point that a new jar uploaded into the CDB root means that all PDB will inherit this new implementation as a new binary/library file patched at ORACLE_HOME does, but this is not how the class loading system works into the multitenant environment, to check that I'll re-execute above query but using the PDB$SEED container (the template used for new databases):SQL> ALTER SESSION SET CONTAINER = PDB$SEED;
SQL> select dbms_java.longname(object_name) from dba_objects where object_type='JAVA CLASS' and dbms_java.longname(object_name) like '%ODCI%';
28 rows selected.similar result will be displayed in any other PDB running/mounted on that CDB, more on this if I'll check a Java code on some PDB this exception will be thrown:Exception in thread "Root Thread" java.lang.IncompatibleClassChangeError
at oracle.jpub.runtime.MutableArray.getOracleArray(MutableArray.java)
at oracle.jpub.runtime.MutableArray.getObjectArray(MutableArray.java)
at oracle.jpub.runtime.MutableArray.getObjectArray(MutableArray.java)
at oracle.ODCI.ODCIColInfoList.getArray(ODCIColInfoList.java)
at com.scotas.solr.odci.SolrDomainIndex.ODCIIndexCreate(SolrDomainIndex.java:366)this is because a code was compiled with latest API and the container have an oldest one.So I'll re-load the new ODCI.jar into PDB$SEED and my PDBs, using similar approach as in the CDB for example:SQL> ALTER SESSION SET CONTAINER = PDB$SEED;
SQL> exec sys.dbms_java.loadjava('-f -r -v -s -g public rdbms/jlib/ODCI.jar');
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable databasethis is because the PDB are blocked from altering classes inherit from the CDB.
As I mentioned early above way are incorrect when dealing in multitenant environments.To fix that there is Perl script named catcon.pl, it automatically takes care of loading on ROOT first, then on PDB$SEED, then any/all open PDBs specified in the command line.In my case I'll execute:# $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS -d $ORACLE_HOME/rdbms/admin -b initsoxx_output initsoxx.sqlbefore doing that is necessary to open all PDB (read write, or in restrict mode) or specifying which PDB will be patched. Note that I used initsoxx.sql script, this script is used by default during RDBMS installation to upload ODCI.jar.Now I'll check if all PDBs have consistent ODCI classes.SQL> ALTER SESSION SET CONTAINER = PDB$SEED;
Session altered.
SQL> select dbms_java.longname(object_name) from dba_objects where object_type='JAVA CLASS' and dbms_java.longname(object_name) like '%ODCI%';
63 rows selected.
Session altered.
SQL> select dbms_java.longname(object_name) from dba_objects where object_type='JAVA CLASS' and dbms_java.longname(object_name) like '%ODCI%';
63 rows selected.Finally all PDBs where patched with a new library.More information about Development Java within RDBMS in multitenant environments are in this presentation, The impact of MultiTenant Architecture in the develop of Java within the RDBMS, for Spanish readers there is video with audio at YouTube from my talk at OTN Tour 14 ArOUG:
Enabling Agents of Change
The Oracle Value Chain Summit is rapidly becoming the premier Supply Chain event in the industry. Our upcoming 2015 Value Chain Summit marks the third year that this great event has been held, and we expect this summit to be bigger and better than ever. This event is all about you, our customer. You empower your supply chain, and the Value Chain Summit promises to provide you with the insight, contacts and tools you need to become "Agents of Change" for your supply chain.
Watch this video
(by Oracle's Jon Chorley, pictured left) to learn more about the great things we have planned for the 2015 Value
Chain Summit. Plus, you can take advantage of the Early Bird rate
through the end of November, and save $300 off the regular rate. Combine
this offer with special group rates, and save BIG!
"Why Not Oracle Cloud?" for Fast-Growing, Mid-Sized Organizations
In the past, mid-size and smaller companies have had to settle for "lightweight or scoped down ERP solutions." Generally, these tier-2 solutions don't have the functionality that a company needs to grow and operate globally.
In this article in Profit magazine, Oracle's Rondy Ng, Senior Vice President of Applications Development, advises companies to choose wisely when looking at cloud-based ERP solutions to avoid expense, risk, and disruption down the road.
Ng asserts that Oracle ERP Cloud is the ERP solution for Fortune 500 companies, as well as for those who don't have any designs to be one. There's no need to settle. He makes a great case for choosing cloud and choosing Oracle.
New Interaction Hub Data Sheet Available
In support of the recently released Revision 3 of the PeopleSoft Interaction Hub, we've just produced the latest data sheet for the Hub, which can be found here. This paper covers the highlights of the new release, and describes the our overall direction for the product. The prime topics we cover are as follows:
- Setting up and running a cluster of PeopleSoft applications using the Interaction Hub
- Content Management
- Branding and the User Experience
- Using the Hub with the new Fluid User Interface
Visualization on How the undergraduate tuition has increased over the years
Average undergraduate tuition and fees and room and board rates
Source: http://nces.ed.gov/
These figures are inflation adjusted and look how just the tuition fees have increased compared to the Dorm and Board rates
Now comparing the rate increase for 2-year program
So for the 2 year program, the board rates have remained at the same level compared to the dorm rates.
Now check out the interesting graph for 4 year program below
Comparing the slope of 2 year Board rates to the 4 year Board rates, the 4 year has significant increase
If price of meals is same for both programs then both 4 year and 2 year programs should have the same slope. So why is the 4 year slope different than 2 year?
Now, let see about the Dorm rates
And finally the 4 year vs 2 year Tuition rates
Here is the data table for the above visualization
Musings on Samsung Developer Conference 2014
This year some of us at the AppsLab attended the Samsung Developer Conference aka #SDC2014. Last year it was Samsung's first attempt and we were also there. The quality and caliber of presentations increased tenfold from last year. Frankly, Samsung is doing it really hard to resist to join their ecosystem.
Here are some of the trends I observed:
Wearables and Health:
There was a huge emphasis in Samsung's commitment with wearable technology. They released a new Tizen based smartwatch (Samsung Gear S) as well as a biometric reference design hardware and software called SIMBAND. Along with their wearable strategy they also released S.A.M.I, a cloud repository to store all this data. All this ties together with their vision of "Voice of the Body."
Voice of the Body from Samsung on Vimeo.
During the second day keynote we got to hear from Mounir Zok Senior Sports Technologist of the United States Olympic Committee. He told us of how wearable technology is changing they way Olympic athletes are training. It was only a couple years ago when athletes still had to go to a lab and "fake" actual activities to get feedback. Now they can actually get real data on the field thanks to wearable technology.
Virtual Reality:
Samsung released the Gear VR in partnership with Oculus. This goggles can only work with a mounted Galaxy Note 4 in the front. The gaming experiences with this VR devices are amazing. But they are also exploring other cases like virtual tourism and virtual movie experiences. They released a 3D 360+spherical view camera called "Project Beyond."
IoT – Home Automation:
Samsung is betting big with IoT and Home Automation and they are putting their money where their mouth is by acquiring SmartThings. The SmartThings platform is open sourced and has the ability to integrate with a myriad of other home automation products. They showcased a smart home powered by SmartThings platform.
Mobile Innovation:
I actually really like their new Galaxy Note Edge phablet. Samsung is showing true innovation here with the "edge" part of the device. It has it's own SDK and it feels great on the hand!
Overall I'm pretty impressed with what Samsung is doing. It seems like their spaghetti-on-the-wall approach (throwing a bunch spaghetti and see what sticks) is starting to pay off. Their whole UX across devices looks seamless. And in my humble approach they are getting ready to take off on their own without having to use Android for their mobile devices. Tizen keeps maturing, but I shall leave that for another post!
Please feel free to share your experience with Samsung devices as well!Possibly Related Posts:
- Friday Links
- Even More Internet of Things, SmartThings
- PBS Off Book on the Future of Wearable Computing
- See You at Kscope 13
- Monday, More Links
Asteroid Hackathon – The Winning Team
Editorial Note: This is a guest post by friend of the 'Lab and colleague DJ Ursal. Also be sure to check out our Hackathon entry here:
EchoUser (@EchoUser), in partnership with SpaceGAMBIT, Maui Makers, the Minor Planet Center, NASA, the SETI Institute, and Further by Design, hosted an Asteroid Hackathon. The event was in response to the NASA Grand Challenge, "focused on finding all asteroid threats to human populations and knowing what to do about them."
I had a wonderful opportunity to participate in the Asteriod Hackathon last week. MY team name was NOVA. Our team comprised for 4 team members – DJ Ursal, Kris Robison, Daniel Schwartz, Raj Krishnamurthy
We were given live data from NASA and Minor Planet site and literally just had 5 hours to put together a working prototype and solution to the Asteroid big data problem. We created a web application (works not only on your MAC or PC but also on your iPad and your latest Nexus 7 Android devices) which would help scientists, astronomers and anyone who is interested in Asteriods discover, learn and share information in a fun and interactive way.
Our main them was Finding Asteroids Before They Find Us. The goal was to help discover, learn and share Asteroids information to increase awareness within the community. We created an interactive web app that allowed users to make use of chart filters to find out about the risk for possibilities of future impact with Earth. Find out about the distance of the asteroids to Earth, absolute brightness and rotation of the Asteroid. It allowed users to click and drag on any chart to filter, so that they could transform the filters in multidimensional way in order to explorer, discover , interesting facts and share data on asteroids with riends and community. We made use of Major Tom who is an astronaut referenced in David Bowie's songs "Space Oddity. "Space Oddity" depicts an astronaut who casually slips the bonds of the world to journey beyond the stars. Users could post questions to Major Tom and could also play his song.
The single most important element about WINNING this hackathon strategically was team composition. Having a team that is effective working together. Collaboration and communication skills were the two of most critical personal skills demanded of all members as time was limited and communication and coordination of utmost importance.
Winning TEAM NOVA- DJ Ursal, Kris Robison, Daniel Schwartz, Raj Krishnamurthy Possibly Related Posts:
- Asteroid Hackathon
- Interesting Data Pr0n
- On Hiring a Web Developer
- Do You Learn on Your Own?
- A View of Android Fragmentation


text:
- 04.
Coordinator Speak: Mangino Talks Texas Tech
/ AllCyclones Beat WriterFull Story
- 01.
Catching Up With Diante Garrett
/ AllCyclones Beat WriterFull Story
- 04.
Coordinator Speak: Mangino Talks Texas Tech
/ AllCyclones Beat WriterFull Story
- 01.
Catching Up With Diante Garrett
/ AllCyclones Beat WriterFull Story
Cyclones Seeking Improvement Despite Victory
Iowa State is seeking improvement despite moving past Drake with a 17-point victory Tuesday nightFULL STORY
Iowa State Women Sign Three For 2015
Iowa State signed three players to its 2015 Class, earning the best ranking in program history along the wayFULL STORY
Rhoads Favors Early Signing Opportunity
While recruits must wait until Feb. 4, 2015 to make their commitments official, Paul Rhoads would favor an early signing opportunityFULL STORY
Added Depth Coming for Cyclones
The starting lineup has accounted for most of the production through two games, but Iowa State will add depth next Monday in Kansas CityFULL STORY
Iowa State Passes Early-Season Test
Georgia State was no early-season slouch on Iowa State's schedule, and the Cyclones left Hilton Coliseum on Monday with an 81-58 win in handFULL STORY
Quotebook: Texas Tech
Texas Tech coach Kliff Kingsbury talked about his quarterbacks and looked ahead to Iowa State in his Monday news conferenceFULL STORY
Press Coverage: Week 13
Iowa State enters Week 13 coming off its final bye of the season awaiting Texas Tech and with quarterback Sam Richardson's shoulder improvingFULL STORY
Bibbs Named John Mackey Award Semifinalist
Iowa State tight end E.J. Bibbs was named a semifinalist for the John Mackey Award on MondayFULL STORY
New Offer For Commissoing
Iowa State is the newest offer for junior college defensive lineman Darius Commissiong.FULL STORY
Iowa State Knocks Off Oakland in Opener
Iowa State started off on the right foot Friday night with a 93-82 win against Oakland in its season-openerFULL STORY
Ozigbo Remains Solid for Cyclones
Despite three recruits decommitting from Iowa State in recent days, one of the Cyclones' prized commits remains a solid verbalFULL STORY
Where Things Stand: D-Line Recruiting
While Iowa State has seen two JUCO defensive linemen decommit this week, it's possible the Cyclones could get visits from multiple D-linemen on Nov. 22FULL STORY
181 Fans online
- Great opportunity for Fred
- Iowa State beats Georgia State 81-58
- BIG WEEKEND: Nov. 22 vs. Texas Tech
- Any news on some recruits?
- JUCO O-Tackle offered...
- DE Terry BecknerPosition Rank: 05
- S Kenneth McGruderPosition Rank: 22
- WR Tony BrownPosition Rank: 36
- CB Javaris DavisPosition Rank: 36
- DE Anthony FotuPosition Rank: JC
- MLBPosition Rank: 37
- OLBPosition Rank: 75
- SPosition Rank: 121
- OTPosition Rank: 125
- DEPosition Rank: 140
01.AlabamaCommits: 21Points: 4,116Conference: SEC
02.GeorgiaCommits: 23Points: 3,916Conference: SEC
- Commits: 20Points: 3,538Conference: ACC
04.TennesseeCommits: 26Points: 3,500Conference: SEC
05.Texas A&MCommits: 21Points: 3,428Conference: SEC
- Commits: 26Points: 3,300Conference: SEC
07.AuburnCommits: 19Points: 3,182Conference: SEC
08.Ohio StateCommits: 21Points: 3,135Conference: Big Ten
09.Notre DameCommits: 21Points: 3,129Conference: Indep
10.USCCommits: 17Points: 3,070Conference: Pac-12
81.Iowa StateCommits: 11Points: 599Conference: Big 12

subset: commoncrawl


text:
37:02I Who Got It On With My Wifes Younger Sister 1
93%Views: 1,258,927
37:32I Who Got It On With My Wifes Younger Sister 4
93%Views: 1,251,505
38:02I Who Got It On With My Wifes Younger Sister 2
91%Views: 1,579,988
41:00My wife younger sister attended the funeral
91%Views: 243,335
40:27my wifes younger sister is a high student 2
92%Views: 1,411,750
31:57my wife younger sister is a high student
89%Views: 1,070,036
29:49Farewell With Wifes Elder Sister Ryoko Nagase
82%Views: 18,901
23:00I meet with Younger sister at the home of my wife
91%Views: 692,858
39:22My wife's younger sister took part in the home party
97%Views: 507,090
42:45My wife 's younger sister attended the funeral
94%Views: 642,157
I Who Got It On With My Wifes Younger Sister 3
Comments (28)
her name is haruki sato.
i just can't get over her breasts/nipples lmao. I honestly don't know if i've seen better!
What is her's name?
@tinman1 i don't think it's ren azumi, her face is different.. also curious about this girl's name though, i had seen her other videos
Great video
very nice
Anyone has more videos of this Girl?? I think she is Ren Azumi. She is THE BEST. If you get more vids of Ren Azumi.. plz post.
pain pls put #4 section we want see the rest of thsi video
more to come
What a wonderful three they will make and his cock will never ever not be ready for action.
where is #4 last clip girl was HOT .
Hey, if a traditional marriage is what ya want--everyone gotta give or fuck it--take what ya need--Is good acting.
hate these censcored fucking vids..so many good ones ruined.
not bad for censored


text:
Product Description
Fiberglass Rear Bumper for all 1967-1968 Mustangs.Looking to save some weight on the drag strip or add a custom look to your restomod Mustang? The fiberglass rear bumper is the ticket.
This rear bumper is a direct replacement for the factory chrome bumper and is made from high quality fiberglass. Holes must be drilled for bumper bolts and to properly mount the bumper to the factory brackets. Bumper must be painted prior to installation.
Hand made in the USA!
Similar Mustang PartsMore Mustang Bumpers
Installation Instructions
Product Reviews
- Not Yet Rated
- 0 Reviews | Write a Review
Overall Rating: 0 / 5
0 Reviews
You Might Also Like
Regular Price: $13.99
Special Price: $9.79
Regular Price: $103.99
Special Price: $77.99
Regular Price: $166.99
Special Price: $133.59
Regular Price: $179.99
Special Price: $152.99
CJ's Low Price:$409.99


text:
Local Organization Assisting People Affected By Big Sur Fire
Updated On: Dec 27 2013 11:33:49 PM CST
A local organization is shipping supplies overnight to help people affected by the Big Sur Fire.
Darren Woodhead packs boxes to help those in need.
"I've probably packed ten, maybe twenty thousand," Woodhead said.
The boxes are filled with supplies to assist those affected by poverty and disaster.
"We work with over 1,000 health clinics in all 50 states," said Woodhead.
While many of the items packed up are shipped out of state or even internationally, this time help is needed a little closer to home -- for those affected by the Big Sur Fire.
Direct Relief is an organization where, once a call is placed for help, staff members immediately generate a plan of how to get supplies to where they need to go quickly.
"We create a transfer order out here in the warehouse, and pick it, and then it has to be double, tripled-checked for accuracy," said Woodhead.
Volunteers and staff members filled boxes with things such as medicines and supplies for people with asthma for a health clinic in Salinas. The items will be shipped overnight, and if more are needed, staff members say that's not a problem.
"We now have these type of supplies in stock at our warehouse at all times so that on a whim if we get a call from partners like this who say they're in need, we can ship it right away," said Hannah Rael, who works for Direct Relief.
If you want to be part of the efforts, there is more information online: http://www.directrelief.org/
Copyright © 2013 KEYT - NPG of California, LLC. All rights reserved. This material may not be published, broadcast, rewritten or redistributed.


text:
FRR Mink Fur Sailor HatMink Fur Sailor Hat. Made from ranch raised mink. Only the best grade mink is selected to manufacture this sporty hat. Made with a soft jersey lining for added comfort. A great casual look for everyday and fun to wear.
Mink fur is one of the most elegant and highly demanded furs. Its beautifully soft, silky fur gives a look like none-other. Mink fur keeps you warm and keeps you looking you very best.
This item is
Made in USA
There are currently no product reviews.


text:
Find records of Florence Flickinger
Find birth, death, marriage, military, and other records of Florence I Flickinger at Ancestry.com.Search for records
Biography & Family History Add details
Florence I Flickinger (1924 - 2003) was born on August 7, 1924. She was born into the Flickinger family.
There are no known spouses or children on file for Florence. Florence died on November 23, 2003 at 79 years old.
Florence I Flickinger's last known residence is at Grand Rapids, Kent County, Michigan.
This record of Florence I Flickinger comes from the United States Social Security Death Index. According to information provided to the SSDI, this death record has been verified by a family member of the deceased. This data can be considered very accurate. What is the SSDI?
This genealogy of Florence I Flickinger's past was created by the AncientFaces community Contribute any information you have to reach the people who know her. Some things we would like to know about Florence's genealogy:
- Where was Florence born?
- Where did Florence die?
- Who was Florences family?
- What did Florence look like? Add some photos of their life.
Family Tree & Genealogy Add / Edit People
You can add or remove people from this genealogy by clicking here.
History of Florence I Flickinger Add details
- Given name
- Florence
- Surnames
- Flickinger family history
- Last Known Residence
- Grand Rapids, Kent County, Michigan
- Born
- Death
- Gender
- Female
Do you know more about Florence I Flickinger?
You can add details to this page and share Florence's story.
Obituary Add details
We don't know information regarding Florence's obituary records. You can add obituary information about Florence I Flickinger by clicking "Add Details".
Discuss Florence
Share your memories below with the rest of Florence's family. We'll notify anyone else who is searching for Florence of your message.
Find records of Florence Flickinger
Find birth, death, marriage, military, and other records of Florence I Flickinger at Ancestry.com.Search for records
Possible Relatives
- Conrad Flickinger
- ·
- Myrtle Flickinger
- ·
- Gladys M Flickinger
- ·
- Stella F Flickinger
- ·
- Ben E Flickinger
- ·
- Doris Flickinger
- ·
- David Flickinger
- ·
- Florence M Flickinger
- ·
- Robert J Flickinger
- ·
- Reo M Flickinger
- ·
- Clyde Flickinger
- ·
- Ronald Flickinger
- ·
- Herschall Flickinger
- ·
- Lyndon Flickinger
- ·
- Barbara M Flickinger
- ·
- Cleon Flickinger
- ·
- Bernard Harry Flickinger
- ·
- David B Flickinger
- ·
- Hugh Flickinger
- ·
- Shirley N Flickinger
- ·


text:
- Publisher: Menno Spijkstra
- Release Date: Jan 8, 2013
- Summary: ????? TOP RANK IN 54 COUNTRIES ????? __________________________________________ 'So Cool How The Characters Can Be Sliced' 'Love The Graphics, Motion And Controls' 'I Keep Slicing Those Guys Like a True Ninja!' 'This Game Is Addicting and Keeps Me Going!' __________________________________________ If you enjoy slicing up all kinds of stuff, you will totally love OFFICE NINJA! Slice up all the Wall Street brokers that are being served up and make sure not a single one escapes in one piece. But be careful not to hit the pretty and innocent secretary, because that means game over! Awesome graphics and addicting gameplay will make you slice up like a true MASTER over and over again. Through Game Center you can check how you are doing compared to your friends, and the rest of the world. This game is excellent to fight stress that the economic crisis might cause. Experience how it feels to eliminate the bad guys from Wall Street. Slice up as many as you can and earn the most points. This game concept was recently chosen best game of the year by several blogs. So come on board, see how your friends perform online and try to beat them! JOIN THE OFFICE NINJA COMMUNITY TODAY! ??? ADDICTIVE GAME FEATURES ??? - 14 different characters to slice up - FREE version supported by ads - Super cool graphics and motion - Addicting game concept - Several combo cuts to earn rewards - Great sound effects - Leaderboard through GAME CENTER - Invite your Facebook friends to play - Turn on/off music and sound effects - Upgrade to ad-free version optional - Available on iPhone and iPad ??? SUPPORT ??? - Website: www.pogiplay.com - Facebook: www.facebook.com/pogiplay - Twitter: www.twitter.com/pogiplay… Expand
- Developer: Menno Spijkstra
- Genre(s): Action
- Cheats: On GameFAQs
- More Details and Credits »
Score distribution:
Positive: 0 out of
Mixed: 0 out of
Negative: 0 out of


text:
10 tips to get your Homepage Video earning for your business
Some homepage videos don't deliver on the promise of increased earnings and profitability. They don't convert into leads or sales very well. So here's 10 tips we think it'll pay you to know. 1. Have it professionally produced This is … Read more


text:
Food & Recipes
"Key Lime" PuddingMay 31st, 2014UnfeaturedWeekly Recipe:NonWeeklySERVES 4
1/3 cup light agave nectar, plus more to taste
½ cup freshly squeezed lemon juice
½ cup freshly squeezed lime juice
2 ripe avocados, pitted and peeled
2 bananas, chopped
2 teaspoon finely grated lemon zest
1 teaspoon finely grated lime zest
Throw all of the ingredients into your blender and puree on high for 1 to 2 minutes, until well combined. You may need to stop your machine and scrape down the sides of the container to ensure everything is incorporated evenly. Tweak the sweetener to taste. Divide the pudding among four serving glasses and chill in the fridge for about 3 hours to thicken. Serve the same day, chilled, to avoid oxidation.
Source: The Blender Girl
Food and Brain HealthApril 30th, 2014
We are inundated today with dietary suggestions. It seems like each week a new diet book comes out, each with its own wrinkle on what it means to eat healthy. When I searched Amazon for books tagged with the word diet I got 91,783 results.A discussion with David Perlmutter, MDBy Adam Swenson
Meatless: Meatloaf RevisitedApril 30th, 2014
Maybe you recently went vegan. Maybe you are trying out Meatless Mondays, a day when you choose to avoid meat to reduce your risk of chronic conditions like cancer, cardiovascular disease, and diabetes. Or maybe it's as simple as wanting to find unique alternatives to common foods.Try this delicious childhood meal
Dragons at NightApril 30th, 2014
In Thailand, a moonflower blooms after dark, sprouting from the arms of a tall, thin cactus of the genus Hylocereus. It will bloom only for one night. If the flower becomes pollinated, a bizarre looking, distinctly tropical pink fruit will grow. The interior of this fruit will be either white or red and full of seeds—like a kiwi, but more so.Health benefits of the hot pink, armor-plated dragonfruitBy Adam Swenson
Easy and Gluten-freeApril 30th, 2014
Sourdough has a unique flavor that stems from the preparation of its leavener. Rather than tearing open a packet of commercially cultured yeast to provide a quick burst of CO2, sourdough relies on protracted fermentation to give the bread lift while at the same time creating its unique (sour) flavor profiles.A sourdough loaf worth the effortBy Craig Gustafson
In Season: StrawberriesApril 30th, 2014
Strawberries are one of the many gifts that May has to offer us. This is when they are at their peak, giving us a fragrantly sweet taste that fits well in many recipes. Keep in mind that strawberries are very perishable, so only purchase them a few days before you use them!
>>Hempanana Smoothie
Tea for Your: DetoxApril 30th, 2014
Detoxification, the process of removing harmful toxins from the body, is a great way to achieve a higher level of health. Detoxes can last from a few days to a few weeks and can include drinking juices, cutting out sugar and flour, or eating a diet high in fiber.
Cancer FightersApril 30th, 2014
Garlic, leeks, yellow onions, dark green veggies, and cruciferous veggies have been shown to powerfully counteract cancer cell growth, according to a recent study in Food Chemistry. If you need a refresher, cruciferous vegetables come from the family Cruciferae (also called Brassicaceae).
Salty TalkApril 30th, 2014
The FDA's recommendation for adults is 2,400 mg of sodium per day or less—the equivalent of a teaspoon of table salt. If a food has 5 percent or less of your daily sodium, it's a low-sodium food. If it has 20 percent or greater, it is high in sodium.
75% of sodium in the American diet comes from packages and restaurant foods
Nachos GrandeApril 30th, 2014UnfeaturedWeekly Recipe:NonWeeklySERVES: 6
8 corn tortillas, quartered
Cooking spray
1 1/2 teaspoon cumin, divided
1/4 teaspoon salt
3/4 pound ground beef
1 tablespoon chili powder
1 teaspoon dried oregano
1/2 teaspoon garlic salt
1 can refried black beans
3 cups shredded cheddar cheese
Salsa, for serving
Sour cream, for serving
Chopped fresh cilantro, for serving
Sliced jalapeno peppers, for serving
Preheat oven to 425 degrees. Arrange the tortilla wedges in a single layer on a large baking sheet coated with cooking spray. Generously coat the tortilla wedges with cooking spray and sprinkle with 1/2 teaspoon cumin and salt. Bake 8 to 10 minutes or until crisp. Meanwhile, cook the ground beef in a large skillet over medium-high heat, stirring occasionally, until brown; drain if necessary. Stir in the chili powder, 1 teaspoon cumin, the oregano, and garlic salt.
Meanwhile, heat the refried beans in another large skillet, coated with cooking spray, until warm. Preheat broiler. Place tortilla chips on a large oven-safe platter or baking sheet. Spread the warm beans over each chip and spoon the meat mixture on top of the beans; top evenly with the cheese. Broil for one minute or until the cheese melts. Remove from the oven; top with salsa, sour cream, cilantro, and jalapenos. Serve immediately. Source: Fast and Simple Gluten-Free (Fair Winds Press) by Gretchen F. Brown, RD


text:
chromium etchant
Chromium etchant standard | Sigma-Aldrich
Sigma-Aldrich offers Aldrich-651826, Chromium etchant for your research needs. Find product specific information including CAS, MSDS, protocols and references.View
Chromium Etchant Etching Mixtures - MicroChemicals
Chromium Etchant N°1 ((NH 4) 2 [Ce(NO 3) 6]/HClO 4). Mixture of perchloric acid and ceric ammonium nitrate. For further information please refer to: Chromium Etchant.pdfView
Wet etching of chromium - microtechweb.com
WET ETCHING OF CHROMIUM. A number of characteristics make chromium a popular contrast medium for high-quality mask fabrication: - excellent adherence to glass and ...View
Chromium or chrome etchants | Transene
Etchant chemistries for chrome include ceric ammonium nitrate (CAN)-nitric acid, CAN-acetic acid, and CAN-perchloric acid, effective for chromium films andView
MATERIAL SAFETY DATA SHEET - University of Colorado Boulder
TRANSENE COMPANY INC. Emergency Telephone Number CHEMTREC 24HR# 1-800-424-9300 ... CHROMIUM ETCHANT 1020AC PAGE 3. Title: Microsoft Word - Chromium Etch 8002A Author:View
CR-14 Chromium Etchant Transene — Stanford ...
CR-14 Chromium Etchant Transene; MSDS files; Liquid; Gas; MSDS ALD Precursors; Stanford MSDS Page; Process or Materials Review Requests (PROM) and Form Info. CR-14 ...View
CHROMIUM ETCHANT TYPE 1020 AC.pdf — Materials ...
CHROMIUM ETCHANT TYPE 1020 AC.pdf — PDF document, 18Kb Document Actions. Send this; Print thisView
chromium etching - MicroChemicals
Chromium Etching Revised: 2013-11-07 ... is dissolved in the etchant. Selectivity Copper, ... Our Chromium Etch Our chromium etch "Chrome etch n° 1" has the composition:View
Transene thin film metal and semiconductor etchants ...
Etchants for thin metals films, semiconductors, and dielectrics. Wet etch solutions are available for nearly any substance.View
transene -- chromium etch 1020 12-05-00 - start - UCLA ...
lungs and respiratory system. material is corrosive to eyes, skin, and mucous membranes. emergency and first aid procedures: eye contact: immediately get medical ...View
etchant for chromium grain size - Nova Wave Software
| Home | Consumables | MSDS | Procedures | Equipment | Etchants | Contact ... Common grain size measurements ... the formation of chromium carbide on the grain ...View
Etching Mixtures, Aluminium Etchant, Chromium Etchant ...
Photoresists, Ancillaries, Etchants, Solvents, and Technical Support for all Stages of MicroStructuring and LithographyView
Chromium Etch - Home - Engineering - Tufts University
2.1.4 Carefully pour some of the Transene Chromium Etchant Type 1020 into the Petri dish such that the dish is a little over half full.View
Chemical Etchants Commercially Available Etchants Transene
Transene Company, INC. www.transene.com Other Chemcial Etching Companies ... Chromium Cermet Etchant - TFE: 1000 Å/min at 50°C : Cu: Copper Etch 100 Copper Etch 200View
MATERIAL SAFETY DATA SHEET - Binghamton University
rev 3 chromium etchant 1020 ghs version page 1 material safety data sheet section 1. product and company identification manufacturer: transene company, inc.View
CHROMIUM ETCHANT - ChemicalBook
Visit ChemicalBook To find more CHROMIUM ETCHANT information like chemical properties,Structure,melting point,boiling point,density,molecular formula,molecular weight ...View
Taekwang - Chromium Etchants
APPLICATION: Chromium Etchant CRE-473 is a ready-to-use solution specifically designed to remove chromium films from metal substrates such as copper, gold ...View
CR-14 Material Safety Data Sheet - Columbia University
CYANTEK CORPORATION Page 1 of 4 CR-14 MSDS 17-055 Rev. C Dated 9/8/03 Material Safety Data Sheet 1 Product and Company Identification: Product name: CR-14 Chromium ...View
Chromium Etch - LNF Wiki - University of Michigan
CR-14 Chromium etchant: CAS Number does not exist. Instead the ingredients have individual CAS Numbers, because this is considered a "mixed solution."View
chromium etchant - Home - Nesat.net
chromium etchant, Sigma-Aldrich offers Aldrich-651826, Chromium etchant for your research needs. Find product specific information including CAS, MSDS, protocols and ...View
Cyantek Corporation Global Electronics Supplier
Global Suppliers, Cyantek Suppliers, Cyantek Manufacture, Chemical Suppliers, electronic manufacture . Om Group Cyantek CorporationView
Chromium-free Etching and Palladium-free Plating of Plastics :
The chromium-free etchant is very convenient as it is operated at room temperature (20-30°C) and it emits no fumes. The process sequence is the same as ...View
Etching (microfabrication) - Wikipedia, the free encyclopedia
Etching is used in microfabrication to chemically remove layers from the surface of a wafer during manufacturing. Etching is a critically important process module ...View
Gold etchant , standard | Sigma-Aldrich
Sigma-Aldrich offers Aldrich-651818, Gold etchant, standard for your research needs. Find product specific information including CAS, MSDS, protocols and references.View
Resources: Standards & Properties - Copper & Copper Alloy ...
Chromium copper alloys are high copper alloys, containing 0.6 to 1.2% Cr. The chromium copper alloys are used for their high strength, corrosion resistance and ...View
Chromium Etch - LNF Wiki - University of Michigan
Transene Chromium Etchant 1020 (ceric ammonium nitrate and nitric acid) ... For Cr Etchant 1020, the etch time is ~2 minutes. Rinse in QDR for 4 cycles.View
MSDS - Sheets - University of Colorado Boulder
Material Safety Data Sheets (MSDS) are provided by the manufacturer of chemicals. ... Transene chromium etchant type 1020AC; Transene chromium cermet etchant type TFE;View
Etching of Forged Cobalt-Chromium-Molybdenum Alloy
Ongoing discussion on The Home Page of the Finishing Industry®: Etching of Forged Cobalt-Chromium-Molybdenum AlloyView
Etch rates for micromachining processing-part II ...
Photoresist can be used as an etch mask for this etchant. CR-7: Chromium etchant CR-7 from Cyantek is a commer-cial mix of % (NH ) Ce(NO ) % HClO H O [17].View
Chromium Cermet Etchant TFE Page 2 . SECTION X: DOT SHIPPING INFORMATION DOT Shipping Information: Potassium Hydroxide Solution, UN1814, PGIII, Class 8 POISONView
Tungsten Etchant TFW, Chromium Cermet Etchant-TFE
Tungsten Etchant TFW, Chromium Cermet Etchant-TFE MSDS File 237.pdf Type. Cas Number. 13746-66-2; 1310-58-3. Ingredients alkaline (koh) [1310-58-3] ferricyanide ...View
Chromium wet etch: View - MEMS and Nanotechnology Exchange
Chromium wet etch: View. Process Hierarchy. Bonding; Clean; Consulting; Deposition; Doping; Etch; Anisotropic etch; Deep RIE; ... Etchant. Solutions and their ...View
grain etchant for chromium
work of chromium carbides along the grain boundaries. ... The thermal etching was performed in the Vacutherm on the temperature of ... Cobalt chromium L605 chemical ...View
CHROMIUM ETCHANT TYPE 1020 - Georgia Institute of Technology
Material Safety Data Sheet U.S. Department of Labor May be used to comply with Occupational Safety and Health Administration OSHA's Hazard Communication Standard ...View
Electropolishing & Chemical Etching of Cobalt Chromium for ...
Ongoing discussion on The Home Page of the Finishing Industry®: Electropolishing and Chemical Etching Processes for Cobalt Chromium L605 coronary stentsView
ETCHING SOLUTIONS - University of Central Florida
Those are a list of solutions specific for etching metallic films ALUMINUM ETCHANT Aluminum Etchant Type A (Transene Co., Inc.)View
Chromium(III) oxide - Wikipedia, the free encyclopedia
Chromium(III) oxide is the inorganic compound of the formula Cr 2 O 3. It is one of principal oxides of chromium and is used as a pigment. In nature, it occurs as the ...View
chromium etchant standard
chromium etchant standard, Sigma-Aldrich offers Aldrich-651826, Chromium etchant for your research needs. Find product specific information including CAS, MSDS ...View
Semiconductor Wet Process Table - IMTEC
Material Compatibility with Common Chemistries. ... Chromium etchant CR-7 from Cyantek (9% (NH 4)2Ce(NO3)6) + 6% HClO4 + H2O) Etch Chromium: Quartz static or ...View
chromium etchant
chromium etchant, IC and HPLC Technical Notes; TN 707: Injection Routines Explained: Effectively Using a User Defined Program: TN 519: Extending the Performance of LC ...View
CHROMIUM ETCHANT, Information for CHROMIUM ETCHANT ...
Information for CHROMIUM ETCHANT including CHROMIUM ETCHANT , CHROMIUM ETCHANT Suppliers, CHROMIUM ETCHANT Manufacturers, related products of CHROMIUM ETCHANT.View
Chemical Etch - Scribd
CR-14: Chromium etchant CR-14 from Cyantek is a com% CH COOH H O mercial mix of % (NH ) Ce(NO ) (room temperature). it should be mixed just before use.View
CR-7 Material Safety Data Sheet - Princeton University
Product name: CR-7 Chromium Etchant Manufacturer: CYANTEK CORPORATION 3055 Osgood Court Fremont, CA 94538 (510) 651-3341 24 Hour Emergency Telephone Number:View
Chapter 1.10 - Miscellaneous Etchants - Marvell ...
Chromium Etchant ; Chromium/Nichrome Etchant ; Cobalt ; Columbium ; ... EDP etchant can be used on p-type wafers with orientation, masked with either siliconView
Chrome (Cr) Etching Instructions - Columbia University
Chrome (Cr) Etching Instructions The CEPSR Clean Room stores CR-1A, a pre-made product used for removing or etching away chrome. This etchant is stored inside the ...View
16 oz. PCB Etchant Solution : Etchant Solutions ...
PCB Etchant Solution: PCB Etchant Solution works extremely well when removing the old aluminum coatings from precision made optical mirrors.View
Patent US5904859 - Applying etchant solution to metal ...
... a high pH etchant containing a copper complexing ingredient to prevent passivation of the copper constituent by the chromium etchant solution.View
Chromium Etch Chemical Standard Operating Procedure
Chromium Etch Chemical Standard Operating Procedure ... CR-14 Chromium etchant: CAS Number does not exist. Instead the ingredients have individual CAS Numbers, ...View
chromium etchant standard
chromium etchant standard, Chromium copper alloys are high copper alloys, containing 0.6 to 1.2% Cr. The chromium copper alloys are used for their high strength ...View
chromium etchant 1020
chromium etchant 1020, Transene Company, INC. www.transene.com Other Chemcial Etching Companies This page displays information on chemical etchants for various thin ...View
- chromium
- etchant


text:
Scarlett Johansson Stars in Upcoming Movie "Lucy"
This seems like a slightly different version of the movie "Limitless," but hey at least it has Scarlett Jo in it. Plus, I'll never turn down a chance to watch Morgan Freeman in a movie.
Official Trailer for "Sex Tape Movie" Starring Cameron Diaz & Jason Segel
Ever accidentally send a risque video to the wrong person or upload one to the internet on accident? If so, you might know how Cameron Diaz & Jason Segel feel in this upcoming movie, Sex Tape Movie. Expect it to be in theaters on July 25th.
Teenage Mutant Ninja Turtles Return to the Big Screen
I just really, really hope that they use Vanilla Ice's "Go Ninja" song for the soundtrack on this one. I can't see this comparing to "The Secret of the Ooze," but I'll definitely still have to check this out. Michael Bay & Megan Foxx, such a dynamic duo. Expect the Teenage Mutant Ninja Turtles to return to the big screen in August of this year.
Check Out the Trailer for Hercules Starring The Rock
Here's the first look at the upcoming movie, Hercules, starring The Rock. I'd like to think it's going to be good, but I just don't know. At least it looks like my girl Irina Shayk is in it.
The Giver – Official Trailer (Video)
There is a pretty good chance that everyone reading this was forced to read The Giver when they were younger. I definitely had to. As much as I hated reading as a kid, I actually enjoyed this book. I never imagined it would be turned into a movie but the trailer looks surprisingly good. The film is based on Lois Lowry's award winning novel and takes place in a seemingly perfect community. All that changes when Jonas, the star of the book/movie, starts questioning the society he lives in.
Watch the Latest Official Trailer for the New Godzilla Movie (Video)
Judging by this new trailer, the Godzilla movie is going to be epic. It's filled with destruction, anxiety inducing action scenes and even a few glimpses of the monster itself. The movie is set to hit theaters on May 16th. I don't about you, but I've already purchased my ticket.
Official Trailer for Sin City: A Dame to Kill For
Here's a look at the follow-up to the 2005 movie, Sin City. The movie was directed by Frank Miller & Robert Rodriguez, and seems to feature quite an all-star cast. Sin City: A Dame to Kill For is set to release on August 22nd, 2014.
Here's the Official Trailer for the Upcoming "Godzilla" Movie
Fresh off the finale of Breaking Bad, Bryan Cranston will play the lead in the upcoming modern-day rendition of Godzilla. I feel like this is just a non-POV version of Cloverfield though. Release date set for May 16th.
Anchorman 2 to be Re-released with 763 New Jokes
So, for one week only they're releasing another version of Anchorman 2 in theaters. This time around it gets the "R" rating, and features 763 new jokes. Brilliant.
Official Trailer for First Guardians of the Galaxy
This looks awesome! Jimmy Kimmel premiered this trailer for the First Guardians of the Galaxy recently. The movie is set to release on August 1st this year.
Brick Mansions Official Trailer Starring Paul Walker
Here's a look at one of Paul Walker's posthumous movies called, Brick Mansions. I'm not going to say it looks like an amazing movie, but it definitely looks entertaining.
SNL & Jonah Hill Parody the Trailer for "Her"
Jonah Hill and Leo both stopped by SNL this past weekend. This is definitely one of the highlights from the episode. There's been a lot of jokes mocking the movie "Her", but it was actually a solid movie.
Visual Effects Highlights from The Wolf Of Wall Street
Brainstorm Digital put together this reel of some of the more challenging shots they did for The Wolf of Wall Street. If you haven't seen the movie out you need to go check it out. 3 hours of Leo being Leo.
Party With the Real Wolf of Wall Street (Video)
With the upcoming movie The Wolf of Wall Street being based on a true story, here's a look at the real Jordan Belfont's life. The 90's seemed to be a hell of a time for this guy. Can't wait to see the movie.


text:
The Valspar Corporation has elected Peter McCausland to the Valspar Board of Directors. McCausland is chairman and CEO of Airgas, Inc. Based in Radnor, PA, Airgas distributes industrial, medical and specialty gases, as well as welding, safety and other MRO supplies.
Thomas R. McBurney, Valspar's chairman, said, "Peter McCausland has built Airgas through a highly successful acquisition strategy, complementing organic growth with more than 330 acquisitions over the past 24 years. We believe Peter's experience in growing Airgas' core packaged industrial gas distribution business will be a terrific asset and we are pleased to welcome him to our board."
McCausland Elected to Valspar Board
By Jason Lawton
Published April 20, 2006
Related Breaking News
- BASF Divests Omega-3 Production Plant for Natural Fish Oils to Marine Ingredients
- PPG Showcases Liquid, Powder, Pretreatment, E-Coat Products at FABTECH 2014
- Lonza Industrial Solutions Strengthens Relationship with KODA Distribution Group
- Benjamin Moore & Co. Appoints Ron Schuller As Chief Marketing Officer
Related Paint & Coatings Manufacturer News
Related Products


text:
Buy online front row tickets for all Concert, Theater and Sporting events, and tickets to all sold out major events.
Sport, Concert and Theater tickets are hot and Frontrow.com has tickets to all your favorite events, including the Miami Heat Games, College Football and Super Bowl. We can get you "In the door" or the best seats to all games and events. Talk to one of our specialists or order online 24/7. Frontrow.com has a solid reputation of 22 years in the business selling tickets. Front row can get you tickets for all the, Playoffs and all NBA Games.
Hiroshima is always a great hit with every crowd. We stock all Hiroshima tickets to every Hiroshima show! Frontrow.com is your souce for premium Hiroshima tickets. Let us put you right up front and see Hiroshima like you've never seen before, up close and personal. Order online or call toll free at 800-881-7691 and speak to a frontrow concert experts.
BUY - SELL Hiroshima Tickets
Sell Your Hiroshima Tickets
Frontrow.com provides the ervice of finding and obtaining tickets to events worldwide. We are a private company not affiliated with any venue, stadium, promoter, theater or box office, the MLB, NBA, NFL, NCAA, NHL,NBA or any of their teams. Trademark, trade names, and copyrights, used in this web site are only for descriptive purposes. We Do not act with the permission or on behalf of any of above mentioned organizations.. We provide Hiroshima tickets through a range of sources and contacts. Prices for Hiroshima tickets are often higher than the ticket's face value, reflecting costs of finding and aquiring premium Hiroshima Tickets.
About us
Front Row is a quality ticket broker for all concerts, theater, and sporting events. Front Row sells the finest Hiroshima packages and tickets. If tickets you are searching for are not available, please check back as we always update and list new tickets in our huge inventory. Hiroshima schedules are on our web site. Just click to see our real-time online concert, sport and theater tickets.
Frontrowcom has the largest inventory of Hiroshima Tickets on the secondary ticket market. Call today for up to the latest information on ticket availability and prices since we constantly purchase new event tickets. If you want to go to a special Hiroshima event; we are your ticket broker for sold out Tickets. Front Row welcomes corporate accounts seeking premium tickets for entertaining clients.
Front Row has been a ticket broker for over two decades. Our mission statement is to give our clients the best service, lowest prices and reliability. When searching for Hiroshima Tickets or other events, Call Frontrow.com where our professional team can offer you the ultimate Hiroshima Tickets experience.
Front Row.com is for all of your other ticketing needs. Frontrow.com sells tickets to all concert tours nationwide. Not only do we sell Hiroshima tickets but we also buy Hiroshima tickets, NFL tickets, NCAA tickets, NHL tickets, NBA, MLB, all golf tickets, tennis, title fight tickets, concerts, family show tickets, and theater tickets including Broadway and Las Vegas shows. Call Frontrow.com today for Hiroshima Tickets ; and all of your entertainment needs! Frontrow.com strives to provide our patrons the utmost quality service and competitive pricing. If any event isn't listed; please phone us for any hard to find or special requests.
PURCHASING AND AVAILABILITY OF Hiroshima Tickets
Click the above link for Hiroshima info and front row tickets to events across the country and globe. You can buy tickets for Hiroshima on our web site by selecting your specific venue and time. When searching for Hiroshima tickets that are unavailable or sold-out from other sources, contact Frontrowcom, your source of front row tickets. If you don't see tickets on our frontrow web site or don't want to order online, don't hesitate to call us toll free at 800-881-ROW-1. We are ticket pro's and offer data about buying tickets, schedules and venue maps. Frontrow.com offers an vast inventory of theater, concert, sport event tickets with constant updates. At Frontrow.com; our goal is offering the largest selection of Hiroshima tickets on the secondary market. Use "Click Here" links to check future events, schedules and seating charts. Our Hiroshima inventory has up to the hour accuracy. However, if tickets you want are not available, please contact us and our staff will guide you through available options in the same or similar category to your original ticket choice.
Ticket delivery
All tickets are sent via Federal Express. Once you locate Hiroshima tickets you want to buy, they can be purchased online via our secure encrypted server. If you prefer more personal service, call us today and speak to any of our ticket brokers. Hiroshima tickets are usually sent within 6-24 hours. Your shipping address must match the billing address of your credit card. If you wish to ship to an alternate address; we require ID. Please contact one of our ticket experts to provide you with excellent service.
Ticket refund policy
All Hiroshima sales and all other event tickets are final.
Times of Oman
Japan embassy to host photography exhibition
Times of Oman
Muscat: The Embassy of Japan will co-host a photography exhibition titled 'Hiroshima, City of Peace' in association with the city of Hiroshima, Oman-Japan Friendship Association (OJFA), and the Hiroshima-Oman Friendship Association, from November 30 to ...
OMIYAGE FROM JAPAN: Local sauces complement Michelin-rated ...
Asahi Shimbun
The Hiroshima-style okonomiyaki is characterized by the batter, which is thinly spread like a crepe. Generous amounts of shredded cabbage and bean sprouts are placed on the batter to be cooked with meat. Boiled noodles are then added, which are crisped ...
Jazzercise Celebrates 30 Years in Japan With Getaway This Weekend
Broadway World
CARLSBAD, CA - Jazzercise, Inc. will celebrate thirty years of dance fitness in Japan with an international fitness getaway in Hiroshima, Japan's City of Peace, this weekend, November 22-24th, 2014. Thousands of Jazzercise customers and instructors will ...
Musalman Times
can u write my research paper
Musalman Times
Hiroshima is much more a book about community than it is about family. Applying online is just as serious as applying "the old-fashioned way. Some colleges do offer a "my space" section, you would think so too), Dianne Ruyffelaere, suggesting that you have ...
and more »
The new Jacob Bronowski archive
Financial Times
n the November of 1945, Jacob Bronowski went to Hiroshima and Nagasaki as part of the British team which, in the immediate aftermath of the second world war, travelled to Japan to document the effects of the atom bombs that had been dropped on those ...
Check out Frontrow.com for all your tickets needs. We've got great sources for any event ranging from concert tickets to World Series tickets, Book of Mormon tickets, and Las Vegas show tickets. And don't forget the chance to score big on Broadway tickets and once in a lifetime events like the National Final Rodeo, the 2015 Super Bowl or the Daytona 500. Our inventory covers all types of entertainment and special events. With the biggest selection of concerts, sports, and theater tickets around, you can't go wrong with tickets from Frontrow.com.


text:
Hoping to connect with lost family late 1940's early 1950's.
Al P. Young & Wife Lillian Avis Young often visited family (?) in Galveston. The Galveston family really enjoyed baseball, and were big fans of the "Houston Buffs".
The Galveston Family moved to Texas City at some point.
Al and his family lived in the Heights, Houston,TX.
had 2 children.
Notify Administrator about this message?
|Home | Help | About Us | Site Index | Jobs | PRIVACY | Affiliate
|© 2007 The Generations Network


text:
- Exchange: -
- Sector: Materials
- Industry: Construction Materials
- Sub-Industry: Non Wood Building Materials
CIM:BBTicker Delisted
Company Profile for Cimescaut (CIM)
Cimescaut (originally Societe Generale des Ciments Portland de l'Escaut) makes and sells cement. The Company processes sand, gravel and related products. Cimescaut operates in Belgium, France and Holland.
Contact Information
Rue du Coucou, 37
Antoing, 7640
Phone: 32-69-44-67-50
Fax: 32-69-44-67-89
Key Executives for Cimescaut (CIM)
|Paul BertrandManaging Director
|Pierre BertrandManaging Director
Quotes delayed, except where indicated otherwise. All prices in local currency. Time is ET.
Recommended Symbols:
- 1
- 2
- 3
- 4
- 5