Feed aggregator

お菓子を学ぶなら、専門学校に行く!

Marian Crkon - Wed, 2022-08-17 20:55
一昔前は、何かを学ぶときには、学校に行くよりも実際に就職して、修行をしながら学んでいくというスタイルが主流でし...

お菓子を学ぶなら、専門学校に行く!

The Feature - Wed, 2022-08-17 20:55

一昔前は、何かを学ぶときには、学校に行くよりも実際に就職して、修行をしながら学んでいくというスタイルが主流でした。そのため専門的に学ぶには、高校などには進学せずにすぐに修行をする店に入ったものです。現在もそのスタイルで知識を学んでいく方法もありますが、今ではまず専門学校に入り、基本的な知識を学んだ後に修行に入るというスタイルをとる人も少なくありません。それは技術的なことももちろん必要ですが、技術的なことを身に着ける前には、まず基本的な知識が必要ですし、技術的な根拠を知らなくてはスキルアップをするのがなかなか難しいからなのです。

そこでお菓子を作るということにおいても、まず専門学校に通う人も少なくありません。お菓子といっても和菓子から洋菓子に至るまで様々なお菓子の世界があります。また見た目に楽しませるものを作るだけでなく、またその場の雰囲気に合ったお菓子を演出する、人を癒すお菓子など様々な効用があるのです。それらを作るにはいろいろな材料も使います。

基本的なものもありますが、季節に合わせたもの、またアレンジをする時に使用するものなど、いろいろなものを使用するので、それについて一つ一つの知識が必要になります。専門学校に行くと、それらの一つ一つについて知識をえることができるのです。また専用の道具を作って、自分の味を考えていくことも!そのため、もしも専門的な知識を身に着けて、これから仕事をしていきたいと考える場合には、専門学校に入るという方法もおすすめです。

Categories: APPS Blogs

Isaac of Syria in Dostoevsky

Greg Pavlik - Wed, 2022-08-17 11:32
My second (and more careful) read of Brothers Karamazov (this time the Pevear/Volokhonsky translation) established it as the most influential piece of world literature I have to date encountered. I regard it as the pinnacle of modern forms, but also amongst the most piercing of critiques of modernity as such. For years I have re-read it in part and in full, as well as numerous commentaries on the novel, Dostovesky's corpus en toto, and of course works on Dosteovsky himself more generally. Of the latter, I cannot imagine a finer literary biography than the work of the late Joseph Frank.

On recurring theme is an attempt to uncover the influences behind the portrait of the staretz Zosima. Many figures have been sited, including the famous Tikon of Zadonsk, of which there is an entire book dedicated to the topic. To my mind, however, the most obvious parallel to the teachings of Zosima is the 7th century ascetic Isaac of Syria. There could not be more clear parallels between his ascetic writings and the long chapter on Zosima's homilies in Karamazov. I liberally quote from two sites with supporting details and illustrations

------------------
There is an interesting connection between St Isaac of Syria and Dostoevsky. The latter owned an 1858 edition of the Slavonic translation of the Homilies by St Paisius Velichkovsky (Victor Terras, A Karamazov Companion: Commentary on the Genesis, Language, and Style of Dostoevsky’s Novel [Madison: U of Wisconsin, 1981], p. 22). Furthermore, Dostoevsky mentions St Isaac’s Ascetical Homilies by name twice in The Brothers Karamazov. The first time is in Part I, Book III, Chapter 1, ‘In the Servants’ Quarters’, where the narrator observes that Grigory Vasilievich, Fyodor Karamazov’s manservant, ‘somewhere obtained a copy of the homilies and sermons of “Our God-bearing Father, Isaac the Syrian”, which he read persistently over many years, understanding almost nothing at all of it, but perhaps precisely for that reason prizing and loving it all the more’ (Fyodor Dostoevsky, The Brothers Karamazov, trans. Richard Pevear and Larissa Volokhonsky [NY: Vintage, 1991], p. 96). Dostoevsky then mentions the book again in 4.11.8, this time in the rather more sinister context of Ivan’s third meeting with Smerdyakov, when the latter 'took from the table that thick, yellow book, the only one lying on it, the one Ivan had noticed as he came in, and placed it on top of the bills. The title of the book was The Homilies of Our Father among the Saints, Isaac the Syrian. Ivan Fyodorovich read it mechanically' (Dostoevsky, p. 625).

But more importantly, Victor Terras has pinpointed a number of St Isaac’s teachings that make a definite appearance in the words of Elder Zosima in II.VI.3, especially in (g) ‘Of Prayer, Love, and the Touching of Other Worlds’ (Dostoevsky, pp. 318-20), and (i) ‘Of Hell and Hell Fire: A Mystical Discourse’ (Dostoevsky, pp. 322-4). Terras quotes the following passage from ‘Homily Twenty-Seven’ as being ‘important for the argument of The Brothers Karamazov’ (Terras, p. 23):


Sin, Gehenna, and Death do not exist at all with God, for they are effects, not substances. Sin is the fruit of free will. There was a time when sin did not exist, and there will be a time when it will not exist. Gehenna is the fruit of sin. At some point in time it had a beginning, but its end is not known. Death, however, is a dispensation of the wisdom of the Creator. It will rule only a short time over nature; then it will be totally abolished. Satan’s name derives from voluntarily turning aside [the Syriac etymological meaning of satan] from the truth; it is not an indication that he exists as such naturally. (Ascetical Homilies, p. 133)
Terras may, however, be on the wrong trail with this particular passage, though not perhaps with the rest of his parallels, since according to a note in the translation, this particular homily only exists in Syriac (Ascetical Homilies, p. 133), and does not appear to have been available in any translation Dostoevsky would have read (Introduction, Ascetical Homilies, pp. lxxvi-lxxvii). Another interesting, though less important, discrepancy, is that Pevear and Volokhonsky, in their note on the name of St Paisius (he is referenced in I.I.5 [Dostoevsky, p. 27], and footnoted on p. 780 of Pevear’s and Volokhonsky’s translation), date Dostoevsky’s edition of the Elder’s translation of St Isaac to 1854 rather than 1858. Furthermore, J.M.E. Featherstone lists among St Paisius's works, Svjatago otca našego Isaaka Sirina episkopa byvšago ninevijskago, slova duxovno-podvižničeskija perevedennyja s grečeskago.... (Moscow, 1854), thus making Pevear and Volokhonsky's date more likely, it would seem ('Select Bibliography', The Life of Paisij Velyčkovs'kyj, trans. J.M.E. Featherstone [Cambridge, MA: Harvard U, 1989], p. 163 ).

I just wanted to highlight briefly this interesting connection. At an even deeper level, however, it has been picked up on, for one, by Archimandrite Vasileios of Iveron. Having considered the ‘artistic’ gifts of St Isaac and the spiritual insight of Dostoevsky, he concludes, ‘Thus, whether you read Abba Isaac, or Dostoevsky, in the end you get the same message, grace and consolation’ (‘Από τον Αββά Ισαάκ’, p. 100).


source: http://logismoitouaaron.blogspot.com/2009/02/this-glory-of-orientst-isaac-syrian.html
------------------

Though the teachings of Elder Zosima from Dostoevsky’s Brothers Karmazov seem exotic to many western readers and possibly unorthodox, they in fact show a remarkable similarity to those of a favorite 7th century eastern saint, St Isaac the Syrian.   We know that Dostoevsky owned a newly-available translation of St Isaac’s Ascetical Homilies, and this volume is in fact mentioned by name twice in the novel, though in seemingly inconsequential contexts.  Dostoevsky was no doubt deeply affected by the saint’s spirituality, and I think Zosima’s principle views in fact reflect and are indebted to those of St Isaac.  Below I will list some of these distinctive views, with illustrating quotes from both the fictional Elder Zosima and St Isaac himself. (And note: these were simply the quotes that I could find very easily; I’m sure more digging would find even more striking parallels)

Love for all creation:

Elder Zosima: “Love God’s creation, love every atom of it separately, and love it also as a whole; love every green leaf, every ray of God’s light; love the animals and the plants and love every inanimate object. If you come to love all things, you will perceive God’s mystery inherent in all things; once you have perceived it, you will understand it better and better every day.  And finally you will love the whole world with a total, universal love.”

St Isaac: “What is a merciful heart? It is a heart on fire for the whole of creation, for humanity, for the birds, for the animals, for demons, and for all that exists. By the recollection of them the eyes of a merciful person pour forth tears in abundance. By the strong and vehement mercy that grips such a person’s heart, and by such great compassion, the heart is humbled and one cannot bear to hear or to see any injury or slight sorrow in any in creation. For this reason, such a person offers up tearful prayer continually even for irrational beasts, for the enemies of the truth, and for those who harm her or him, that they be protected and receive mercy. And in like manner such a person prays for the family of reptiles because of the great compassion that burns without measure in a heart that is in the likeness of God.”

 Responsibility for all:

Elder Zosima: “There is only one salvation for you: take yourself up, and make yourself responsible for all the sins of men. For indeed it is so, my friend, and the moment you make yourself sincerely responsible for everything and everyone, you will see at once that it is really so, that it is you who are guilty on behalf of all and for all. Whereas by shifting your own laziness and powerlessness onto others, you will end by sharing in Satan’s pride and murmuring against God. ”

St Isaac: “Be a partaker of the sufferings of all…Rebuke no one, revile no one, not even those who live very wickedly. Spread your cloak over those who fall into sin, each and every one, and shield them. And if you cannot take the fault on yourself and accept punishment in their place, do not destroy their character.”

 Love is Paradise on Earth:

Elder Zosima: “”Gentlemen,” I cried suddenly from the bottom of my heart, “look at the divine gifts around us: the clear sky, the fresh air, the tender grass, the birds, nature is beautiful and sinless, and we, we alone, are godless and foolish, and do not understand that life is paradise, for we need only wish to understand, and it will come at once in all its beauty, and we shall embrace each other and weep”

St Isaac: “Paradise is the love of God, wherein is the enjoyment of all blessedness, and there the blessed Paul partook of supernatural nourishment…Wherefore, the man who lives in love reaps life from God, and while yet in this world, he even now breathes the air of the resurrection; in this air the righteous will delight in the resurrection. Love is the Kingdom, whereof the Lord mystically promised His disciples to eat in His Kingdom. For when we hear Him say, “Ye shall eat and drink at the table of my Kingdom,” what do we suppose we shall eat, if not love? Love is sufficient to nourish a man instead of food and drink.”

Non-literal ‘fire’ of hell:

Elder Zosima: “Fathers and teachers, I ask myself: “What is hell?” And I answer thus: “The suffering of being no longer able to love.”…People speak of the material flames of hell. I do not explore this mystery, and I fear it, but I think that if there were material flames, truly people would be glad to have them, for, as I fancy, in material torment they might forget, at least for a moment, their far more terrible spiritual torment. And yet it is impossible to take this spiritual torment from them, for this torment is not external but is within them”

St Isaac: “As for me I say that those who are tormented in hell are tormented by the invasion of love. What is there more bitter and violent than the pains of love? Those who feel they have sinned against love bear in themselves a damnation much heavier than the most dreaded punishments. The suffering with which sinning against love afflicts the heart is more keenly felt than any other torment. It is absurd to assume that the sinners in hell are deprived of God’s love. Love is offered impartially. But by its very power it acts in two ways. It torments sinners, as happens here on earth when we are tormented by the presence of a friend to whom we have been unfaithful. And it gives joy to those who have been faithful.  That is what the torment of hell is in my opinion: remorse”

source: https://onancientpaths.wordpress.com/2013/07/27/the-elder-zosima-and-st-isaac-the-syrian/

Stacking im Pickleball – Kurzer Leitfaden

The Oracle Instructor - Wed, 2022-08-17 11:05

Beim Doppel im Pickleball wird die Position der einzelnen Spieler (linke Seite oder rechte Seite) normalerweise durch den Spielstand bestimmt. Stacking ist eine Methode die Seite unabhängig vom Spielstand zu wählen. Der Begriff (Stacking = Stapelung) kommt daher, dass dabei häufig zwei Spieler vorübergehend auf derselben Seite stehen. Bisher sehe ich in meinem Umfeld kaum Stacking – auch bei den Deutschen Pickleball Meisterschaften 2022 habe ich es bei keinem Doppel beobachtet. Liegt wohl entweder daran, dass ich überwiegend bei Level 2.5 und 3.0 zugeschaut habe, oder daran, dass Pickleball in Deutschland ganz allgemein noch in den Kinderschuhen steckt, während Stacking eher eine Technik für Fortgeschrittene ist. Vielleicht wird es durch diesen Beitrag ja populärer.

Warum Stacking?

Gründe für Stacking können sein

  • Wir haben als Spieler im Team eine Lieblingsseite
    • Linkshänder nach rechts
    • Frau im Mixed nach rechts
    • Stärkere Vorhand (bei Rechtshändern) nach links
  • Die Gegner wollen immer einen von uns anspielen
  • Als taktische Variante
Wichtig: Ausgangspositionen merken!

Grundsätzlich ist es beim Pickleball im Doppel wichtig, sich die Ausgangspositionen zu merken: Wer anfangs rechts steht, wird zukünftig bei geradem Teamscore als Aufschläger und als Rückschläger rechts stehen müssen. Das gleiche gilt für den Spieler, der beim Stand von 0-0-2 links steht: Bei geradem Teamscore muss er jetzt und zukünftig als Aufschläger und als Rückschläger auf der linken Seite sein. Ein Verstoß gegen diese Regel führt streng genommen zum Verlust des Punkts bzw. der Ralley. Durch die beim Stacking erfolgenden Stellungswechsel ist die Gefahr etwas höher, da durcheinander zu kommen.

Stacking beim Aufschlag

Wir betrachten zuerst Stacking beim Aufschlag. Das ist unsere Wunschposition:

Wir haben Aufschlag und stehen in Wunschposition bei 0-0-2: A links und B rechts. Unser Teamscore ist gerade: Alles ist wie sonst auch, kein Stacking nötig.

Wenn wir den Punkt gewinnen, steht es 1-0-2. Der Teamscore ist nun ungerade. Stacking passiert: A geht nur für den Aufschlag kurz nach links und wechselt dann wieder zurück nach rechts. B bleibt links:

Angenommen, im weiteren Spielverlauf verlieren wir das Aufschlagrecht, und es wechselt zu uns zurück beim Stand von 3-0-1. Unser Teamscore ist also ungerade. Bei ungeradem Score muss B rechts aufschlagen, daher erfolgt Stacking:

B geht nur für den Aufschlag kurz nach rechts und wechselt gleich danach wieder zurück auf die Lieblingsposition. A bleibt rechts stehen.

Zusammenfassung Aufschlag

Bei geradem Teamscore schlagen wir wie üblich auf, jeder ist in Wunschposition.

Bei ungeradem Teamscore (1,3,5,7,9) passiert Stacking:

Der Aufschläger steht mittig nur für den Aufschlag auf der ungeliebten Seite, der Partner außen daneben.

Stacking beim Return

Auch beim Return kann Stacking erfolgen. Bei geradem Teamscore haben wir ohnehin schon die Wunschposition und behalten die einfach bei, z.B. beim Stand von 3-2-1:

Bei ungeradem Teamscore passiert Stacking. Hier z.B. beim Stand von 3-1-1:

B muss den Return von der ungeliebten rechten Seite spielen. Er wird nach links wechseln und A nach rechts:

Angenommen, die Gegner machen den Punkt und servieren nun beim Stand von 4-1-1 von links. Zwar haben wir grad unsere Wunschposition (A rechts und B links) eingenommen, aber den Return von links muss beim Stand 4-1-1 zwingend A spielen. Also machen wir erneut Stacking:

Nach dem Aufschlag läuft A diagonal nach rechts an die NVZ, während B seitlich nach links wechselt.

Variante

Alternativ zum oben gezeigten Stacking kann der Partner auch schon direkt auf der bevorzugten Seite stehen:

Das macht unsere Absicht für den Gegner zwar offensichtlich, ist aber vielleicht etwas einfacher für uns in der Durchführung.

Zusammenfassung Return

Beim Return erfolgt also Stacking ebenfalls bei ungeradem Team-score: Der Rückschläger läuft diagonal zur bevorzugten Seite an die NVZ und der Partner wechselt die Seite, bzw. steht schon auf seiner Lieblingsseite außen.

Flexibles Stacking

Stacking kann auch nur von Fall zu Fall praktiziert werden. Mit Linkshändern im Team oder beim Mixed wird es häufig permanent während des ganzen Spiels gemacht. Flexibles Stacking kann benutzt werden, um dem Gegner das ständige Anspielen eines bestimmten Team-Mitglieds zu erschweren, oder als taktisches Mittel zwischendurch. Beim Aufschlag kann man sich absprechen und dann unmittelbar nach dem Service die Seiten wechseln. Beim Return kann der vorn stehende Partner Zeichen geben: Offene Hand hinter dem Rücken bedeutet: Ich wechsle die Seite. Der Rückschläger wird dann entsprechend diagonal auf die andere Seite laufen. Faust hinter dem Rücken bedeutet: Ich bleibe auf dieser Seite.

Stacking Pro & Contra

Sollte ich in meinen Doppelspielen Stacking einsetzen?

Pro

  • Es ist nützlich bei Vorliebe für bestimmte Seite
  • Man kann damit einen schwächeren Partner entlasten
  • Es kann gut als taktisches Mittel eingesetzt werden

Contra

  • Der Laufweg beim Return ist etwas länger
  • Der Partner ist auch in Bewegung, was seinen Schlag etwas schwieriger macht
  • Stacking erfordert ein eingespieltes Team
  • Es wird für alle vier Spieler schwieriger, Spielstand und Spielerpositionen korrekt mitzuhalten

Die Punkte unter der Rubrik Contra sind der Grund, warum sich Stacking nur für fortgeschrittene, häufig zusammenspielende Doppel empfiehlt.

Das Video erläutert Stacking ähnlich wie der Artikel und zeigt auch als Beispiel, wie Profis Stacking praktizieren:

 

Categories: DBA Blogs

Purpose of DGbroker Configuration Wide Service "primary_unique_name"_CFG

Tom Kyte - Tue, 2022-08-16 07:46
Hi team, Is it possible to explain the purpose of '%CFG' broker services and who and how is using it ? Regards Dejan
Categories: DBA Blogs

Need to purge the hystorical custom data

Tom Kyte - Tue, 2022-08-16 07:46
We have around 50 custom tables, which are using for the traces in db objects. Each table contains more than billion records.most of the tables don't have indexes. I want to delete data >sysdare-365 days. Which is not working it is taking very very long time. We can not go for renaming the table name. If we rename the table name, all our objects will be invalid.please suggest.
Categories: DBA Blogs

Database Recovery scenario

Tom Kyte - Tue, 2022-08-16 07:46
Hi team, i take Level-0 backup on Sunday, then from monday to saturday i take differential incremental backups. i want to restore backup on another machine, i have control file backup of Sunday. i can restore level-0 backup easily using control file of Sunday because Sunday control file has information of level-0 backup. how can i apply Monday to Saturday differential incremental backup on level-0 backup of Sunday ? Thanks & Regards Fahd
Categories: DBA Blogs

Configure CMU for all PDBs in the CDB

Tom Kyte - Tue, 2022-08-16 07:46
Has anyone setup CMU to work for all the PDBs within a CDB ? I have it working for a single PDB but when I created a new wallet based off the GUID it doesn't work I get an ora-1017 but it works for the 1st PDB I setup. I'm running Oracle 19.14 on Windows 2019. I don't have an override in the SQLNET.ora, my wallet is in the C:\ORACLE_BASE\admin\<CDB>\<PDB>\wallet as is the dsi.ora file for each PDB. The Create user IDENTIFIED GLOBALLY is in each PDB. And CMU_WALLER_DIR is set in each PDB pointing to it correct directory. So what am I missing to get it to work for the 2nd PDB ? Should it be setup at the CDB level vs. the PDBs level ? If so then should the user be created in the CDB as a common user ? I have a SR open with Support but I'm not getting anywhere. Any help is greatly appreciate. Thanks, Barb.
Categories: DBA Blogs

silent connection to sqlplus in Korn shell

Tom Kyte - Tue, 2022-08-16 07:46
Test case is connect to sqlplus in silent mode in korn shell and run a bunch of sql queries in one single sqlplus session..and where the out would be seen.. tried the following in test.ksh #!/usr/bin/ksh CURR_DIR=`pwd` echo "current directory is:" $CURR_DIR . $CURR_DIR/db.env echo "start time:" `date` cd $ORACLE_HOME/bin echo "location is: "`pwd` sqlplus -s EMDBO?EMDBO@hr92u017 |& OUT="" print -p "set heading off;" print -p "set feedback off;" print -p "set pagesize 0;" print -p "set linesize 500;" print -p "SELECT count(*)FROM dba_invalid_objects;" print -p "show con_name;" read -p OUT read -p OUT 2>/scratch/oracle/null ## when run , script is not progressing further as below, need help here.. $ sh testksh.ksh current directory is: /u01/app/dynamicscripts start time: Fri Aug 12 11:32:10 GMT 2022 location is: /u01/app/oracle/product/testdbh/bin
Categories: DBA Blogs

COMMA_TO_TABLE not found/ Invalid identifiers

Tom Kyte - Tue, 2022-08-16 07:46
<code> declare v_list varchar2(4000); begin begin v_list := :P4_STATES; exception when no_data_found then v_list :='0'; end; for y in (select * from(table(DBMS_UTILITY.comma_to_table(:P4_STATES)))) loop INSERT INTO COVIDAPI(STATES_NO) values(y.COLUMN_VALUE); end loop; for y in (select * from(table(comma_to_table(:P4_POSITIVE)))) loop insert into COVIDAPI(POSITIVE) values(y.column_value); end loop; for y in (select * from(table(comma_to_table(:P4_NEGATIVE)))) loop insert into COVIDAPI(NEGATIVE) values(y.column_value); end loop; end; </code> error:ORA-06550: line 9, column 47: PL/SQL: ORA-00904: : invalid identifier <code> select * from all_objects where object_name ='COMMA_TO_TABLE' </code> result: no data found question: how to install or create the COMMA_TO_TABLE package? I use apex on cloud, it's not installed in my laptop!
Categories: DBA Blogs

Odd behavior with predicate order, json_textcontains, and OR

Tom Kyte - Tue, 2022-08-16 07:46
Database Version 19.16.0.0.0 I have a JSON document with "address", "address_name", and "state" keys among others. I'm searching for a user input in either "address" OR "address_name" in the JSON document. I also have an AND for the "state" key. Depending on the order of the predicate, I get results or no results. What am I missing here? My script is in LiveSQL Also, is there a way to rank/score the results when using JSON_TEXTCONTAINS? If I wanted to use some of the other operators, like NDATA, SDATA, MDATA, FUZZY, WITHIN, or INPATH, do I use CONTAINS, or is it possible with JSON_TEXTCONTAINS. I would appreciate some example statements which show how to use these operators and SQL/JSON Path Expressions with JSON_TEXTCONTAINS. Thanks
Categories: DBA Blogs

Dynamic UI in Django with Alpine.js

Andrejus Baranovski - Mon, 2022-08-15 08:11
Django generates static HTML UI, this requires a full request submit to the server. But you can build dynamic UI's, by including and using Alpine.js library. With Alpine.js you can open dialogs, hide content or disable UI controls. This helps to improve Django app UI usability.

 

お菓子作りには専門学校に通う

Marian Crkon - Sun, 2022-08-14 20:54
料理は色々なアレンジをして楽しむことが出来ますが、お菓子作りはアレンジを行うと美味しい物を作ることが難しいです...

お菓子作りには専門学校に通う

The Feature - Sun, 2022-08-14 20:54

料理は色々なアレンジをして楽しむことが出来ますが、お菓子作りはアレンジを行うと美味しい物を作ることが難しいです。美味しいお菓子を作るためには基礎を勉強をする必要がありますが、独学では限界があるので、専門学校に通うことをお勧め致します。専門学校なら美味しいお菓子の作り方を基礎から全て教えてもらう事が可能です。プロを目指す場合にも有効ですし、趣味でお菓子を作りたい方にもお薦めです。

専門学校なので費用は学校によって違いますが、様々なコースが用意されている場合が多くありますので、自分が目指すお菓子作りのコースを選ぶようにして下さい。プロを目指す場合は本格的な勉強が必要になりますので、数年かかる場合もあります。学校によっては海外留学をする事もありますので、本格的な事を学ぶことが可能です。趣味で専門学校に通う場合は短期で通えるコースを選びましょう。

短期コースなら基礎を重点的に教えてくれるので、基礎を学ぶ事で、様々な物を作ることが可能になります。アレンジまで教えてくれる専門学校もありますが、趣味で長期間通うと費用が大きくかかってしまうので、注意が必要です。基礎を習って覚えて作る物は今まで作っていた物と比べ物になりませんので、作るのが楽しくなります。まるでパティシェになった気分を味わうことが出来るので、ホームパーティーを開いて楽しむことも可能です。

華やかなケーキやデザートが作れる様になると異性にアピールしやすくなります。

Categories: APPS Blogs

Direct Path Inserts and Locks

Hemant K Chitale - Sun, 2022-08-14 04:40

 In my previous post I had demonstrated how a Direct Path Insert in one session blocks another Direct Path Insert from another session, except when the two sessions explicitly name separate target Partitions.

Here, I will lock at how Oracle creates Locks for such operations.  In the output below, the SQLPrompt is set to either 'Sesn_1' or 'Sesn_2' or 'SYSTEM' (the DBA session) to indicate which session is executing the SQL statement.

First, running the Direct Path Insert without specifying the target Partition name.



SYSTEM>l
1 select object_name, subobject_name, object_type, object_id, data_object_id
2 from dba_objects
3 where owner = 'HEMANT'
4 and object_name in ('MY_PART_TABLE')
5 and object_type in ('TABLE','TABLE PARTITION')
6* order by 1, 2 nulls first, 4
SYSTEM>/

OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE OBJECT_ID DATA_OBJECT_ID
---------------- ---------------- ----------------------- ---------- --------------
MY_PART_TABLE TABLE 81817
MY_PART_TABLE P_100 TABLE PARTITION 81818 81827
MY_PART_TABLE P_200 TABLE PARTITION 81819 81828
MY_PART_TABLE P_300 TABLE PARTITION 81820 81820

SYSTEM>
SYSTEM>truncate table hemant.my_part_table;

Table truncated.

SYSTEM>
SYSTEM>select count(*) from v$locked_object;

COUNT(*)
----------
0

SYSTEM>



Sesn_1>select distinct sid from v$mystat;

SID
----------
138

Sesn_1>
Sesn_1>l
1 insert /*+ APPEND */ into my_part_table
2 select rownum, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
Sesn_1>/

50 rows created.

Sesn_1>



Sesn_2>select distinct sid from v$mystat;

SID
----------
384

Sesn_2>
Sesn_2>l
1 insert /*+ APPEND */ into my_part_table
2 select rownum+101, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
Sesn_2>/
---------- Sesn_2 is now in a Wait



SYSTEM>select event from v$session where sid=384;

EVENT
----------------------------------------------------------------
enq: TM - contention

SYSTEM>
SYSTEM>select session_id, object_id, locked_mode
2 from v$locked_object
3 /

SESSION_ID OBJECT_ID LOCKED_MODE
---------- ---------- -----------
138 81817 6
384 81817 0

SYSTEM>
---------- Object ID 81817 is the Table itself, locked by Session 138 -- Sesn_1
SYSTEM>select sid, type, id1, id2, lmode, request, block
2 from v$lock
3 where sid in (138,384)
4 order by 1
5 /

SID TY ID1 ID2 LMODE REQUEST BLOCK
---------- -- ---------- ---------- ---------- ---------- ----------
138 TM 81817 0 6 0 1
138 AE 134 4057974068 4 0 0
138 TX 393246 7880 6 0 0
384 AE 134 4057974068 4 0 0
384 TM 81817 0 0 6 0

SYSTEM>
---------- Session 138 has TM Lock Mode6 on Object 81817 -- the Table itself
---------- Session 384 (Sesn_2, Waiting) is requesting a TM Lock Mode6



So, it is clear that Session 1 (SID 138) had a TM Lock (Mode->6) on the Table, blocking Session 2 (384) (which is requesting the same Mode->6 lock) when the Direct Path Insert specified the Table name alone.
The TX lock by SID 138  is the Transaction Row Exclusive Lock.  What is blocking Session 2 (SID 384) is that it is requesting a Mode->6 lock on the same Object (the Table) as already held by Session 1 (SID 138)

Then, when I issue a Rollback (or Commit) from Sesn_1, the Insert by Sesn_2 goes through.

Before this next test, I rollback both the Inserts

Next, with the target Partition named



Sesn_1>l
1 insert /*+ APPEND */ into my_part_table partition (p_100)
2 select rownum, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
Sesn_1>/

50 rows created.

Sesn_1>



Sesn_2>l
1 insert /*+ APPEND */ into my_part_table partition (p_200)
2 select rownum+101, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
Sesn_2>/

50 rows created.

Sesn_2>



SYSTEM>select event from v$session where sid=384;

EVENT
----------------------------------------------------------------
SQL*Net message from client

SYSTEM>
SYSTEM>select session_id, object_id, locked_mode
2 from v$locked_object
3 /

SESSION_ID OBJECT_ID LOCKED_MODE
---------- ---------- -----------
138 81817 3
138 81818 6
384 81817 3
384 81819 6

SYSTEM>
SYSTEM>l
1 select sid, type, id1, id2, lmode, request, block
2 from v$lock
3 where sid in (138,384)
4* order by 1,2,3
SYSTEM>/

SID TY ID1 ID2 LMODE REQUEST BLOCK
---------- -- ---------- ---------- ---------- ---------- ----------
138 AE 134 4057974068 4 0 0
138 TM 81817 0 3 0 0
138 TM 81818 0 6 0 0
138 TX 65540 6296 6 0 0
384 AE 134 4057974068 4 0 0
384 TM 81817 0 3 0 0
384 TM 81819 0 6 0 0
384 TX 458781 6211 6 0 0

8 rows selected.

SYSTEM>
---------- Both sessions SIDs 138 (Sesn_1) and 384 (Sesn_2) have the Table Object (81817) locked in Mode3, not Mode6
---------- But the Partitions (Objects 81818 and 81819) are locked in Mode6
---------- Neither is SID 138 Blocking any other session nor is SID 384 being blocked


Now we see that the Table (object 81817) is locked in Mode->3 and not Mode->6  by by *both sessions* while the respective Partitions P_100 (object 81818) and P_200 (81819) are locked in Mode->6 without session 384 (Sesn_2) waiting for a block.

Thus, as the Table itself is not locked in Mode->6, Sesn_2 is allowed a Direct Path Insert into another Partition -- only so as long as it explicitly names the Target Partition. (If Sesn_2 attempts to do a Direct Path Insert without naming a Target Partition, it will, again begin waiting on Sesn_1 without the REQUEST being evident in v$lock)

Mode 6 is Lock Table in Exclusive Mode in the first case.
In the second case, the Table is locked in Mode 3 which is Row-Exclusive, not Table level.

The "TX" is a Transaction Enqueue 

The "AE" Lock type is "Edition Enqueue" --- which we are not concerned with in this test, as it relates to Editioning (which I am not currently using) and will appear even if Editioning is not being used.


Categories: DBA Blogs

TIME part in CAST (value AS DATE)

Tom Kyte - Fri, 2022-08-12 12:26
I am trying compare dates. Following SQL returns one row <code>SELECT COUNT(1) FROM ( SELECT 1 FROM DUAL WHERE TRUNC(CAST(CAST('13-JUN-22 05.47.49.000000000 PM' AS TIMESTAMP) AS DATE)) = TO_DATE('13-JUN-22','DD-MON-YY') );</code> where as the same query without TRUNC returns zero rows <code>SELECT COUNT(1) FROM ( SELECT 1 FROM DUAL WHERE (CAST(CAST('13-JUN-22 05.47.49.000000000 PM' AS TIMESTAMP) AS DATE)) = TO_DATE('13-JUN-22','DD-MON-YY') );</code> I believe (maybe I am wrong) that although the CAST convert the TIMESTAMP into DATE, in the first SQL, nevertheless ,there is a TIME part that still remains in it, which is eliminated by the TRUNC . Is this conclusion correct and what is value of the TIME part?
Categories: DBA Blogs

Resume failed rman duplication

Tom Kyte - Fri, 2022-08-12 12:26
I tried to duplicate source database to create physical standby database using the below command duplicate target database for standby FROM ACTIVE DATABASE USING COMPRESSED BACKUPSET SPFILE nofilenamecheck; I have a very big database size with multiple big data files. After finish 70% of database duplication, i discovered one of the big data files will take very long time to be finished. So i want to use section size to speed up the duplication using the below command duplicate target database for standby FROM ACTIVE DATABASE SECTION SIZE 500M USING COMPRESSED BACKUPSET SPFILE nofilenamecheck; My question: ============ if i cancel the running duplication script and re_run it again, i will lose all the progress done before. - It will start duplication from scratch? - The big file which reach to around 50% of duplication, it will resume or starting from scratch. regards,
Categories: DBA Blogs

Direct Path Insert into a Partitioned Table

Hemant K Chitale - Fri, 2022-08-12 09:45

 Normally a Direct Path Insert that is not committed blocks other concurrent Direct Path Inserts.  This behaviour also extends to Partitioned Tables.

Thus :


--------- From Session 1 : inserting only into the first Partition p_100
SQL> l
1 create table my_part_table (id_col number, data_col varchar2(25))
2 partition by range (id_col)
3 (partition p_100 values less than (101),
4 partition p_200 values less than (201),
5 partition p_300 values less than (301)
6* )
SQL>
SQL> /

Table created.

SQL>
SQL> l
1 insert /*+ APPEND */ into my_part_table
2 select rownum, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
SQL> /

50 rows created.

SQL>

---------- From Session 2 : where we know that the rows will actually be inserted into a different Partition p_200
SQL> l
1 insert /*+ APPEND */ into my_part_table
2 select rownum+101, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
SQL> /

-- Yet, Session 2 is blocked and has to wait untill Session 1 does a COMMIT or ROLLBACK


Even though the 2 sessions will be inserting into separate Partitions (i.e. separate Segments). the first session blocks  the other Direct Path Insert.

However, this blocking can be avoided by explicitly naming the target Partition

Thus :


--------- From Session 1 : inserting only into the first Partition p_100 explicitly named 
SQL> l
1 insert /*+ APPEND */ into my_part_table partition (p_100)
2 select rownum, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
SQL> /

50 rows created.

SQL>
---------- From Session 2 : inserting into the second Parition p_200 explicitlly named
SQL> l
1 insert /*+ APPEND */ into my_part_table partition (p_200)
2 select rownum+101, dbms_random.string('X',12)
3 from dual
4* connect by rownum < 51
SQL> /

50 rows created.

SQL>
-------- Of course, both sessions can't requery until they COMMIT or ROLLBACK
--- note : Session 2 can query and see rows inserted by Session 1 and vice-versa, but not their own rows
SQL> select count(*) from my_part_table;
select count(*) from my_part_table
*
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel


SQL>
SQL> commit; -- issued by both sessions so as to be able to see their own rows as well

Commit complete.

SQL>
SQL> select count(*) from my_part_table;

COUNT(*)
----------
100

SQL>
SQL> select count(*) from my_part_table partition (p_100);

COUNT(*)
----------
50

SQL> select count(*) from my_part_table partition (p_200);

COUNT(*)
----------
50

SQL>


Thus, although there is general advice not to explicitly name a target Partition, I find this method useful if I have multiple concurrent Direct Path Inserts.




Categories: DBA Blogs

パティシエの専門学校に通う必要性と学費について

The Feature - Thu, 2022-08-11 20:54

パティシエというのはあくまでもお菓子作りをする職人を指すものであり、国家資格などの有資格者を指すものではありません。なので、普通の学校を卒業してケーキ屋へ就職するという手順でもなることができる職業です。しかし、現場では知識や経験がある方が求められている場合が多いため、一般的には専門学校などを卒業した上で就職をするというケースが多いと言えるでしょう。パティシエの学校では、お菓子作りの基礎的なことを勉強するだけではなく、お菓子の伝統なども学ぶことができますし、お菓子作りに関するさまざまな資格を取得することもできます。

なので、実際に仕事をする際にそれらの幅広い知識や資格を活かすことができると言えるでしょう。しかし気になるのは、パティシエの専門学校に通うための学費がどれぐらいかかるのかということです。一般的には、2年間学校へ通う場合だと300万~400万円程度の学費がかかるのが相場だと言われています。この金額は、他の専門学校より高いと言えますが、これは授業の中で使われる材料費が高くなるという理由があるからです。

それに大手の学校の場合だと、良い材料を使うことが重要視されることが多いため、より材料費が高くなる傾向があると言われています。また、パティシエの専門学校では、本場であるフランスへの留学がプログラムとして組まれていることも多く、その場合だと留学費用がさらにかかることになるでしょう。留学期間が2ヵ月程度の場合だと、50万円程度の費用が必要になると言われています。

Categories: APPS Blogs

パティシエの専門学校に通う必要性と学費について

Marian Crkon - Thu, 2022-08-11 20:54
パティシエというのはあくまでもお菓子作りをする職人を指すものであり、国家資格などの有資格者を指すものではありま...

Pages

Subscribe to Oracle FAQ aggregator