2018/10/08

여자에 대한 명언

마누라가 죽었다, 나는 자유다!
- 보들레르

부유한 독신주의자에게는 무거운 세금이 부과되어야 한다. 그런 사람만 남보다 행복하다는 것은 불공평하기 때문에
- 오스카 와일드

여자들은 나에게 있어서는 코끼리와 같다. 바라보는 것은 좋아하지만 집에까지 가져오고 싶지는 않다.
- 필즈

여자가 결혼할 때 보는 세 가지 조건이 있다. 첫째는 남자의 돈이고, 둘째는 남자 집안의 돈이며, 셋째는 자신에게 들어올 돈이다.
- 로마 격언

남자가 마누라한테 차 문을 열어줄 땐, 그 차가 새차거나 그 마누라가 새 마누라일 때 뿐이다.
-에든버러 공작 필립 왕자

여자와 포도주는 남자의 판단을 망친다.
- 스페인 격언

여자의 눈물을 믿지 마라. 마음대로 되지 않을 때 우는 것이 여자의 천성이기 때문이다.
- 소크라테스

그대는 가난한 남자를 사랑하는 여자를 본 적이 있습니까?
- 마르셀 파뇰

두 여자를 화해시키는 일보다 유럽을 통일하는 것이 더 쉽다.
- 나폴레옹

한 여자의 결점을 알고 싶다면 그녀의 친구들 앞에서 그녀를 칭찬해보라.
- 벤저민 프랭클린

미인은 떼를 지어 다니지 않는다.
- 아라비아 격언

2018/08/18

[기사] 테슬라 또 내부고발.."도난사건 은폐·직원 도청 등"

테슬라 또 내부고발.."도난사건 은폐·직원 도청 등"


일론 머스크 최고경영자(CEO)의 상장폐지 발언으로 미국 증권당국의 조사를 받게 된 테슬라가 이번에는 원자재 도난 사건과 마약거래 등을 은폐하고 직원들을 도청ㆍ감시해왔다는 논란에 휩싸였다.

CNBC 등 현지 언론에 따르면 테슬라의 리튬이온 전지공장인 기가팩토리에서 보안업무를 담당해온 전직 직원 칼 한센은 16일(현지시간) 이 같은 내용으로 증권거래위원회(SEC)에 테슬라를 고발했다. 앞서 엔지니어출신인 전직 직원 마틴 트립이 테슬라 차량에 들어간 일부 배터리에 문제가 있다고 밝힌 후 두 번째 내부고발이다.


한센은 테슬라가 올해 1분기 기가팩토리에서 3700만달러 규모의 구리, 원자재를 도난당한 사실을 주주들에게 숨기고, 휴대전화와 컴퓨터를 도청하거나 해킹하는 방식으로 직원들을 감시해왔다고 주장했다.

또한 테슬라가 기가팩토리의 직원이 마약거래에 관여했을 수 있다는 사실을 인지했음에도 현지 법 집행기관과 마약단속국(DEA)에 밝히지 않았다고 고발했다. 그는 내부적으로 이 같은 문제를 회사 측에 제기한 이후 자신이 7월 중순께 보복 해고됐다고도 덧붙였다.


출처 : https://news.v.daum.net/v/20180817091700834?f=m

2018/07/25

[DB] New Features of Oracle 12c

New Features of Oracle 12c Summarized

01. Pluggable Databases Through Database Consolidation:

Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database architecture through the introduction of Container Databases also called CBD and Pluggable Databases (PDB). The memory and process is owned by the Container Database. The container holds the metadata where the PDBs hold the user data. You can create upto 253 PDBs including the seed PDB.
In a large setup, it is common to see 20 or 30 different instances running in production environment. With these many instances, it is a maintenance nightmare as all these instances have to be separately
•Upgraded
•Patched
•Monitored
•Tuned
•RAC Enabled
•Adjusted
•Backed up and
•Data Guarded.
With Pluggable Databases feature, you just have to do all this for ONE single instance. Without this feature, prior to 12C, you would have to create separate schemas and there is always a thread of security how much ever the isolation we build into it. There are problems with namespace conflicts, there is always going to be one public synonym that you can create. With PDBs you can have a separate HR or Scott schema for each PDB, separate Emp, Dept Tables and separate public synonyms. Additionally, 2 PDBs can talk to each other through the regular DB Link feature. There is no high startup cost of creating a database any more. Instead of one instance per day, the shift is into one instance per many databases. For the developer community, you can be oblivious of all this and still continue to use the PDBs as if it were a traditional database, but for the DBAs the world would look like it has changed a lot.
Another cool feature is, you can allocate a CPU percentage for each PDB.
Another initiative being, it has announced a strategic tieup with salesforce.com during the first week of July 2013.

02. Redaction Policy:

This is one of the top features in Oracle 12C. Data Redaction in simple terms means, masking of data. You can setup a Data Redaction policy, for example SSN field in a Employee table can be masked. This is called redaction. From Sql Develop you can do this by going to the table: Employee->Right click on Security Policy->click on New->click on Redaction Policy->Enter SSN.
When you do a select * from employee, it will show that the SSN is masked.
The new data masking will use a package called DBMS_REDACT. It is the extension to the FGAC and VPD present in earlier versions.
By doing this, whoever needs to view the data will be able to see it where as the other users will not be able to view it.

03. Top N Query and Fetch and offset Replacement to Rownum:

With the release of Oracle Database 12c, Oracle has introduced this new SQL syntax to simplify fetching the first few rows. The new sql syntax "Fetch First X Rows only" can be used.

04. Adaptive Query Optimization and Online Stats Gathering:

With this feature, it helps the optimizer to make runtime adjustments to execution plan which leads to better stats. For statements like CTAS (Create Table As Select) and IAS (Insert As Select), the stats is gathered online so that it is available immediately.

05. Restore a Table easily through RMAN:

Earlier if you had to restore a particular table, you had to do all sorts of things like restoring a tablespace and or do Export and Import. The new restore command in RMAN simplifies this task.

06. Size Limit on Varchar2, NVarchar2, Raw Data Types increased:

The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement.

07. Inline PL/SQL Functions and Procedures:

The in line feature is extended in Oracle 12C. In addition to Views, we can now have PL/SQL Procedures and Functions as in line constructs. The query can be written as if it is calling a real stored procedure, but however the functions do not actually exist in the database. You will not be able to find them in ALL_OBJECTS. I think this will be a very good feature for the developers to explore as there is no code that needs to be compiled.

08. Generated as Identity/Sequence Replacement:

You can now create a col with 'generated as identity' clause. Thats it. Doing this is equivalent to creating a separate sequence and doing a sequence.nextval for each row. This is another handy and a neat feature which will help developer community. This is also called No Sequence Auto Increment Primary Key.

09. Multiple Indexes on a Single Column:

Prior to 12C, a column cant be in more than one index. In 12C, you can include a column in B-tree index as well as a Bit Map index. But, please note that only one index is usable at a given time.

10. Online Migration of Table Partition or Sub Partition:

You can very easily migrate a partition or sub partition from one tablespace to another. Similar to how the online migration was achieved for a non-partitioned table in prior releases, a table partition or sub partition can be moved to another tablespace online or offline. When an ONLINE clause is specified, all DML operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. In contrast, no DML operations are allowed if the partition|sub-partition is moved offline.

11. Temporary UNDO:

Prior to 12C, undo records generated by TEMP Tablespace is stored in the undo tablespace. With Temp undo feature in 12C, temp undo records can be stored in temporary table instead of UNDO TS. The benefit is - reduced undo tablespace and reduced redo log space used.
SQL> ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=2G;
SQL> ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=0; --disables the hard limit

12. In Database Archiving:

This feature enables archiving rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression but are not visible to the application. These records are skipped during FTS (Full Table Scan).

Other Features:

Advanced Replication and Streams are Dead. It is being replaced with Oracle Golden Gate.
Invisible Columns. You can now have a invisible column in a table. When a column is defined as invisible, the column won’t appear in generic queries
PGA Aggregate Limit setting:
In 12c, you can set a hard limit on PGA by enabling the automatic PGA management, which requires PGA_AGGREGATE_LIMIT parameter settings. Therefore, you can now set the hard limit on PGA by setting the new parameter to avoid excessive PGA usage.
DDL Logging:
The DDL statements will automatically get recorded in xml/log file if ENABLE_DDL_LOGGING is set to True. ALTER SYSTEM|SESSION SET ENABLE_DDL_LOGGING=TRUE

2018/07/20

[명언] 군자삼계(君子三戒), 군자삼외(君子三畏), 군자삼락(君子三樂)

군자삼계(君子三戒) - 《논어》〈계씨편(季氏篇)〉


      원 문 해 설

子曰 君子有三戒 군자에게는 경계해야 할 일이 세 가지 있으니

少之時 血氣未定 戒之在色 젊을때는 혈기가 잡히지 않은지라 경계할 것이 여색이고

及其長也 血氣方剛 戒之在鬪 장성하여 혈기가 강해지면 경계할 것이 싸움이며

及其老也 血氣旣衰 戒之在得 나이가 들어 혈기가 쇠진하면 경계할 것이 물욕이다.

군자삼외(君子三畏) - 《논어》〈계씨편(季氏篇)〉


       원 문 해 설

子曰 君子有三畏 군자에게는 두려운 것이 세 가지 있으니

畏天命 하늘의 명을 두려워하고,

畏大人 대인(자신보다 학덕이 높은 사람)을 두려워하고,

畏聖人之言 성인의 말씀을 두려워한다.

군자삼락(君子三樂) - 《맹자(孟子)》〈진심편(盡心篇)〉


       원 문 해 설

君子有三樂 군자에게는 세 가지 즐거움이 있으니,

而王天下不與存焉 천하의 왕이 되는것은 여기에 넣지 않는다.

父母俱存 兄弟無故 一樂也 부모님이 모두 살아계시고 형제들이 무고한 것이 첫째 즐거움이요,

仰不愧於天 俯不怍於人 二樂也 하늘을 우러러 부끄럽지 않고, 사람들을 굽어보아 부끄럽지 않은것이 두 번째 즐거움이며,

得天下英才 而敎育之 三樂也 천하의 영재를 얻어 가르치는 것이 세 번째 즐거움이다.