\n
\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
\"\"<\/figure>\n\n\n\n

Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

Calculating the relation between AIX and INTEL using the TPM values:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n

An Excel comparison table between AIX and Linux concerning
\"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

Calculating the relation between AIX and INTEL using the TPM values:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n


Comparison Table:<\/strong><\/p>\n\n\n\n

An Excel comparison table between AIX and Linux concerning
\"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

Calculating the relation between AIX and INTEL using the TPM values:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n


CORE Scenario 1:
<\/strong>Purpose for Scenario 1: What's the actual value of a thread?
AIX with 2 Cores (equivalent to 16 Threads)
INTEL with 8 Cores (equivalent to 16 Threads)

CORE Scenario 2:
<\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


Comparison Table:<\/strong><\/p>\n\n\n\n

An Excel comparison table between AIX and Linux concerning
\"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

Calculating the relation between AIX and INTEL using the TPM values:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Efficiency ratio calculation:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

Testing Runs to be recorded:
<\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

We call it: MEMORY ONLY QUERY TEST

CORE Scenario 1:
SH Test run 1-6:
AIX 13:00-13:30
LINUX 13:30-14:00

CORE Scenario 2:
SH Test run 6-12:
AIX 14:00-14:30
LINUX 14:30-15:00

<\/p>\n\n\n\n

\"\"
works fine ..<\/figcaption><\/figure>\n\n\n\n

To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
<\/p>\n\n\n\n

\"\"
Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

CORE Scenario 1:
SOE_V2 Test run 1-6:
AIX 15:00-15:30
LINUX 15:30-16:00 <\/p>\n\n\n\n

CORE Scenario 2:
SOE_V2 Test run 1-6:
AIX 16:00-16:30
LINUX 16:30-17:00 <\/p>\n\n\n\n

Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our Customer is now Happy!<\/p>\n\n\n\n

Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

Bug or Feature ?<\/p>\n\n\n\n

\"\"
Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Info from Oracle: <\/p>\n\n\n\n


\n\n\n\n

Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

apex.util.defineTemplates([{<\/p>\n\n\n\n

    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

    template: \"#VAL#\"<\/p>\n\n\n\n

}]);<\/p>\n\n\n\n

apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

    VAL:=Hello World<\/p>\n\n\n\n

{apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


\n\n\n\n

Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

Lernen Sie uns direkt und live kennen!

Datum

Veranstaltung & Thema

Vortragender

Info

20 Feb 2024
praxistage

Praxistage 2024

Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

IMG_8454 scaled e1708456633598
Bernd Schellnast
Geschäftsführer / Head of Operations
20.-21 Mär 2024
Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
Nov 2024
doag_test

DOAG 2023

Data Governance

Thomas_bg e1706660317238
Thomas Petrik
Geschäftsführer / Head of Consulting
 

Unsere Kunden vertrauen auf unsere bewährte Expertise

 

Unsere Fachspezialisten im Fokus:
Das Managed Service Team

Termin Vereinbaren und sich überzeugen!

[contact-form-7 id="8788" title="Home Nine Contact Form"]
\n
  • Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


    CORE Scenario 1:
    <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
    AIX with 2 Cores (equivalent to 16 Threads)
    INTEL with 8 Cores (equivalent to 16 Threads)

    CORE Scenario 2:
    <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
    Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


    Comparison Table:<\/strong><\/p>\n\n\n\n

    An Excel comparison table between AIX and Linux concerning
    \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

    Calculating the relation between AIX and INTEL using the TPM values:
    <\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
    <\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Efficiency ratio calculation:
    <\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

    Testing Runs to be recorded:
    <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

    During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

    We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

    We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

    Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

    We call it: MEMORY ONLY QUERY TEST

    CORE Scenario 1:
    SH Test run 1-6:
    AIX 13:00-13:30
    LINUX 13:30-14:00

    CORE Scenario 2:
    SH Test run 6-12:
    AIX 14:00-14:30
    LINUX 14:30-15:00

    <\/p>\n\n\n\n

    \"\"
    works fine ..<\/figcaption><\/figure>\n\n\n\n

    To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
    <\/p>\n\n\n\n

    \"\"
    Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

    CORE Scenario 1:
    SOE_V2 Test run 1-6:
    AIX 15:00-15:30
    LINUX 15:30-16:00 <\/p>\n\n\n\n

    CORE Scenario 2:
    SOE_V2 Test run 1-6:
    AIX 16:00-16:30
    LINUX 16:30-17:00 <\/p>\n\n\n\n

    Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
    <\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Our Customer is now Happy!<\/p>\n\n\n\n

    Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

    Bug or Feature ?<\/p>\n\n\n\n

    \"\"
    Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Info from Oracle: <\/p>\n\n\n\n


    \n\n\n\n

    Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

    We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

    You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

    apex.util.defineTemplates([{<\/p>\n\n\n\n

        name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

        template: \"#VAL#\"<\/p>\n\n\n\n

    }]);<\/p>\n\n\n\n

    apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

        VAL:=Hello World<\/p>\n\n\n\n

    {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


    \n\n\n\n

    Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

    Lernen Sie uns direkt und live kennen!

    Datum

    Veranstaltung & Thema

    Vortragender

    Info

    20 Feb 2024
    praxistage

    Praxistage 2024

    Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

    IMG_8454 scaled e1708456633598
    Bernd Schellnast
    Geschäftsführer / Head of Operations
    20.-21 Mär 2024
    Thomas_bg e1706660317238
    Thomas Petrik
    Geschäftsführer / Head of Consulting
    Nov 2024
    doag_test

    DOAG 2023

    Data Governance

    Thomas_bg e1706660317238
    Thomas Petrik
    Geschäftsführer / Head of Consulting
     

    Unsere Kunden vertrauen auf unsere bewährte Expertise

     

    Unsere Fachspezialisten im Fokus:
    Das Managed Service Team

    Termin Vereinbaren und sich überzeugen!

    [contact-form-7 id="8788" title="Home Nine Contact Form"]
    \n
      \n
    1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


      CORE Scenario 1:
      <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
      AIX with 2 Cores (equivalent to 16 Threads)
      INTEL with 8 Cores (equivalent to 16 Threads)

      CORE Scenario 2:
      <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
      Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


      Comparison Table:<\/strong><\/p>\n\n\n\n

      An Excel comparison table between AIX and Linux concerning
      \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

      Calculating the relation between AIX and INTEL using the TPM values:
      <\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
      <\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Efficiency ratio calculation:
      <\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

      Testing Runs to be recorded:
      <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

      During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

      We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

      We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

      Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

      We call it: MEMORY ONLY QUERY TEST

      CORE Scenario 1:
      SH Test run 1-6:
      AIX 13:00-13:30
      LINUX 13:30-14:00

      CORE Scenario 2:
      SH Test run 6-12:
      AIX 14:00-14:30
      LINUX 14:30-15:00

      <\/p>\n\n\n\n

      \"\"
      works fine ..<\/figcaption><\/figure>\n\n\n\n

      To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
      <\/p>\n\n\n\n

      \"\"
      Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

      CORE Scenario 1:
      SOE_V2 Test run 1-6:
      AIX 15:00-15:30
      LINUX 15:30-16:00 <\/p>\n\n\n\n

      CORE Scenario 2:
      SOE_V2 Test run 1-6:
      AIX 16:00-16:30
      LINUX 16:30-17:00 <\/p>\n\n\n\n

      Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
      <\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Our Customer is now Happy!<\/p>\n\n\n\n

      Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

      Bug or Feature ?<\/p>\n\n\n\n

      \"\"
      Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Info from Oracle: <\/p>\n\n\n\n


      \n\n\n\n

      Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

      We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

      You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

      apex.util.defineTemplates([{<\/p>\n\n\n\n

          name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

          template: \"#VAL#\"<\/p>\n\n\n\n

      }]);<\/p>\n\n\n\n

      apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

          VAL:=Hello World<\/p>\n\n\n\n

      {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


      \n\n\n\n

      Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

      Lernen Sie uns direkt und live kennen!

      Datum

      Veranstaltung & Thema

      Vortragender

      Info

      20 Feb 2024
      praxistage

      Praxistage 2024

      Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

      IMG_8454 scaled e1708456633598
      Bernd Schellnast
      Geschäftsführer / Head of Operations
      20.-21 Mär 2024
      Thomas_bg e1706660317238
      Thomas Petrik
      Geschäftsführer / Head of Consulting
      Nov 2024
      doag_test

      DOAG 2023

      Data Governance

      Thomas_bg e1706660317238
      Thomas Petrik
      Geschäftsführer / Head of Consulting
       

      Unsere Kunden vertrauen auf unsere bewährte Expertise

       

      Unsere Fachspezialisten im Fokus:
      Das Managed Service Team

      Termin Vereinbaren und sich überzeugen!

      [contact-form-7 id="8788" title="Home Nine Contact Form"]
      \n

      B. Intel Platform Configuration<\/p>\n\n\n\n

        \n
      1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


        CORE Scenario 1:
        <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
        AIX with 2 Cores (equivalent to 16 Threads)
        INTEL with 8 Cores (equivalent to 16 Threads)

        CORE Scenario 2:
        <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
        Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


        Comparison Table:<\/strong><\/p>\n\n\n\n

        An Excel comparison table between AIX and Linux concerning
        \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

        Calculating the relation between AIX and INTEL using the TPM values:
        <\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
        <\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        Efficiency ratio calculation:
        <\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

        Testing Runs to be recorded:
        <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

        During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

        We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

        We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

        Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

        We call it: MEMORY ONLY QUERY TEST

        CORE Scenario 1:
        SH Test run 1-6:
        AIX 13:00-13:30
        LINUX 13:30-14:00

        CORE Scenario 2:
        SH Test run 6-12:
        AIX 14:00-14:30
        LINUX 14:30-15:00

        <\/p>\n\n\n\n

        \"\"
        works fine ..<\/figcaption><\/figure>\n\n\n\n

        To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
        <\/p>\n\n\n\n

        \"\"
        Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

        CORE Scenario 1:
        SOE_V2 Test run 1-6:
        AIX 15:00-15:30
        LINUX 15:30-16:00 <\/p>\n\n\n\n

        CORE Scenario 2:
        SOE_V2 Test run 1-6:
        AIX 16:00-16:30
        LINUX 16:30-17:00 <\/p>\n\n\n\n

        Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
        <\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        Our Customer is now Happy!<\/p>\n\n\n\n

        Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

        Bug or Feature ?<\/p>\n\n\n\n

        \"\"
        Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Info from Oracle: <\/p>\n\n\n\n


        \n\n\n\n

        Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

        We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

        You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

        apex.util.defineTemplates([{<\/p>\n\n\n\n

            name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

            template: \"#VAL#\"<\/p>\n\n\n\n

        }]);<\/p>\n\n\n\n

        apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

            VAL:=Hello World<\/p>\n\n\n\n

        {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


        \n\n\n\n

        Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

        Lernen Sie uns direkt und live kennen!

        Datum

        Veranstaltung & Thema

        Vortragender

        Info

        20 Feb 2024
        praxistage

        Praxistage 2024

        Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

        IMG_8454 scaled e1708456633598
        Bernd Schellnast
        Geschäftsführer / Head of Operations
        20.-21 Mär 2024
        Thomas_bg e1706660317238
        Thomas Petrik
        Geschäftsführer / Head of Consulting
        Nov 2024
        doag_test

        DOAG 2023

        Data Governance

        Thomas_bg e1706660317238
        Thomas Petrik
        Geschäftsführer / Head of Consulting
         

        Unsere Kunden vertrauen auf unsere bewährte Expertise

         

        Unsere Fachspezialisten im Fokus:
        Das Managed Service Team

        Termin Vereinbaren und sich überzeugen!

        [contact-form-7 id="8788" title="Home Nine Contact Form"]
        \n
      2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

        B. Intel Platform Configuration<\/p>\n\n\n\n

          \n
        1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


          CORE Scenario 1:
          <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
          AIX with 2 Cores (equivalent to 16 Threads)
          INTEL with 8 Cores (equivalent to 16 Threads)

          CORE Scenario 2:
          <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
          Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


          Comparison Table:<\/strong><\/p>\n\n\n\n

          An Excel comparison table between AIX and Linux concerning
          \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

          Calculating the relation between AIX and INTEL using the TPM values:
          <\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
          <\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Efficiency ratio calculation:
          <\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

          Testing Runs to be recorded:
          <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

          During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

          We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

          We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

          Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

          We call it: MEMORY ONLY QUERY TEST

          CORE Scenario 1:
          SH Test run 1-6:
          AIX 13:00-13:30
          LINUX 13:30-14:00

          CORE Scenario 2:
          SH Test run 6-12:
          AIX 14:00-14:30
          LINUX 14:30-15:00

          <\/p>\n\n\n\n

          \"\"
          works fine ..<\/figcaption><\/figure>\n\n\n\n

          To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
          <\/p>\n\n\n\n

          \"\"
          Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

          CORE Scenario 1:
          SOE_V2 Test run 1-6:
          AIX 15:00-15:30
          LINUX 15:30-16:00 <\/p>\n\n\n\n

          CORE Scenario 2:
          SOE_V2 Test run 1-6:
          AIX 16:00-16:30
          LINUX 16:30-17:00 <\/p>\n\n\n\n

          Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
          <\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Our Customer is now Happy!<\/p>\n\n\n\n

          Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

          Bug or Feature ?<\/p>\n\n\n\n

          \"\"
          Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Info from Oracle: <\/p>\n\n\n\n


          \n\n\n\n

          Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

          We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

          You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

          apex.util.defineTemplates([{<\/p>\n\n\n\n

              name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

              template: \"#VAL#\"<\/p>\n\n\n\n

          }]);<\/p>\n\n\n\n

          apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

              VAL:=Hello World<\/p>\n\n\n\n

          {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


          \n\n\n\n

          Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

          Lernen Sie uns direkt und live kennen!

          Datum

          Veranstaltung & Thema

          Vortragender

          Info

          20 Feb 2024
          praxistage

          Praxistage 2024

          Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

          IMG_8454 scaled e1708456633598
          Bernd Schellnast
          Geschäftsführer / Head of Operations
          20.-21 Mär 2024
          Thomas_bg e1706660317238
          Thomas Petrik
          Geschäftsführer / Head of Consulting
          Nov 2024
          doag_test

          DOAG 2023

          Data Governance

          Thomas_bg e1706660317238
          Thomas Petrik
          Geschäftsführer / Head of Consulting
           

          Unsere Kunden vertrauen auf unsere bewährte Expertise

           

          Unsere Fachspezialisten im Fokus:
          Das Managed Service Team

          Termin Vereinbaren und sich überzeugen!

          [contact-form-7 id="8788" title="Home Nine Contact Form"]
          \n
        2. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
        3. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

          B. Intel Platform Configuration<\/p>\n\n\n\n

            \n
          1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


            CORE Scenario 1:
            <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
            AIX with 2 Cores (equivalent to 16 Threads)
            INTEL with 8 Cores (equivalent to 16 Threads)

            CORE Scenario 2:
            <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
            Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


            Comparison Table:<\/strong><\/p>\n\n\n\n

            An Excel comparison table between AIX and Linux concerning
            \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

            Calculating the relation between AIX and INTEL using the TPM values:
            <\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
            <\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Efficiency ratio calculation:
            <\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

            Testing Runs to be recorded:
            <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

            During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

            We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

            We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

            Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

            We call it: MEMORY ONLY QUERY TEST

            CORE Scenario 1:
            SH Test run 1-6:
            AIX 13:00-13:30
            LINUX 13:30-14:00

            CORE Scenario 2:
            SH Test run 6-12:
            AIX 14:00-14:30
            LINUX 14:30-15:00

            <\/p>\n\n\n\n

            \"\"
            works fine ..<\/figcaption><\/figure>\n\n\n\n

            To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
            <\/p>\n\n\n\n

            \"\"
            Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

            CORE Scenario 1:
            SOE_V2 Test run 1-6:
            AIX 15:00-15:30
            LINUX 15:30-16:00 <\/p>\n\n\n\n

            CORE Scenario 2:
            SOE_V2 Test run 1-6:
            AIX 16:00-16:30
            LINUX 16:30-17:00 <\/p>\n\n\n\n

            Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
            <\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Our Customer is now Happy!<\/p>\n\n\n\n

            Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

            Bug or Feature ?<\/p>\n\n\n\n

            \"\"
            Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Info from Oracle: <\/p>\n\n\n\n


            \n\n\n\n

            Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

            We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

            You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

            apex.util.defineTemplates([{<\/p>\n\n\n\n

                name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                template: \"#VAL#\"<\/p>\n\n\n\n

            }]);<\/p>\n\n\n\n

            apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                VAL:=Hello World<\/p>\n\n\n\n

            {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


            \n\n\n\n

            Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

            Lernen Sie uns direkt und live kennen!

            Datum

            Veranstaltung & Thema

            Vortragender

            Info

            20 Feb 2024
            praxistage

            Praxistage 2024

            Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

            IMG_8454 scaled e1708456633598
            Bernd Schellnast
            Geschäftsführer / Head of Operations
            20.-21 Mär 2024
            Thomas_bg e1706660317238
            Thomas Petrik
            Geschäftsführer / Head of Consulting
            Nov 2024
            doag_test

            DOAG 2023

            Data Governance

            Thomas_bg e1706660317238
            Thomas Petrik
            Geschäftsführer / Head of Consulting
             

            Unsere Kunden vertrauen auf unsere bewährte Expertise

             

            Unsere Fachspezialisten im Fokus:
            Das Managed Service Team

            Termin Vereinbaren und sich überzeugen!

            [contact-form-7 id="8788" title="Home Nine Contact Form"]
            \n
              \n
            1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
            2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

              B. Intel Platform Configuration<\/p>\n\n\n\n

                \n
              1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                CORE Scenario 1:
                <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                AIX with 2 Cores (equivalent to 16 Threads)
                INTEL with 8 Cores (equivalent to 16 Threads)

                CORE Scenario 2:
                <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                Comparison Table:<\/strong><\/p>\n\n\n\n

                An Excel comparison table between AIX and Linux concerning
                \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                Calculating the relation between AIX and INTEL using the TPM values:
                <\/p>\n\n\n\n

                \"\"<\/figure>\n\n\n\n

                Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                <\/p>\n\n\n\n

                \"\"<\/figure>\n\n\n\n

                Efficiency ratio calculation:
                <\/p>\n\n\n\n

                \"\"<\/figure>\n\n\n\n

                The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                Testing Runs to be recorded:
                <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                We call it: MEMORY ONLY QUERY TEST

                CORE Scenario 1:
                SH Test run 1-6:
                AIX 13:00-13:30
                LINUX 13:30-14:00

                CORE Scenario 2:
                SH Test run 6-12:
                AIX 14:00-14:30
                LINUX 14:30-15:00

                <\/p>\n\n\n\n

                \"\"
                works fine ..<\/figcaption><\/figure>\n\n\n\n

                To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                <\/p>\n\n\n\n

                \"\"
                Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                CORE Scenario 1:
                SOE_V2 Test run 1-6:
                AIX 15:00-15:30
                LINUX 15:30-16:00 <\/p>\n\n\n\n

                CORE Scenario 2:
                SOE_V2 Test run 1-6:
                AIX 16:00-16:30
                LINUX 16:30-17:00 <\/p>\n\n\n\n

                Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                <\/p>\n\n\n\n

                \"\"<\/figure>\n\n\n\n

                Our Customer is now Happy!<\/p>\n\n\n\n

                Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                Bug or Feature ?<\/p>\n\n\n\n

                \"\"
                Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                \"\"<\/figure>\n\n\n\n

                Info from Oracle: <\/p>\n\n\n\n


                \n\n\n\n

                Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                apex.util.defineTemplates([{<\/p>\n\n\n\n

                    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                    template: \"#VAL#\"<\/p>\n\n\n\n

                }]);<\/p>\n\n\n\n

                apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                    VAL:=Hello World<\/p>\n\n\n\n

                {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                \n\n\n\n

                Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                Lernen Sie uns direkt und live kennen!

                Datum

                Veranstaltung & Thema

                Vortragender

                Info

                20 Feb 2024
                praxistage

                Praxistage 2024

                Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

                IMG_8454 scaled e1708456633598
                Bernd Schellnast
                Geschäftsführer / Head of Operations
                20.-21 Mär 2024
                Thomas_bg e1706660317238
                Thomas Petrik
                Geschäftsführer / Head of Consulting
                Nov 2024
                doag_test

                DOAG 2023

                Data Governance

                Thomas_bg e1706660317238
                Thomas Petrik
                Geschäftsführer / Head of Consulting
                 

                Unsere Kunden vertrauen auf unsere bewährte Expertise

                 

                Unsere Fachspezialisten im Fokus:
                Das Managed Service Team

                Termin Vereinbaren und sich überzeugen!

                [contact-form-7 id="8788" title="Home Nine Contact Form"]
                \n

                CPU Settings Preparation:
                This is essential to prevent automatic scaling.

                A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                  \n
                1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                  B. Intel Platform Configuration<\/p>\n\n\n\n

                    \n
                  1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                    CORE Scenario 1:
                    <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                    AIX with 2 Cores (equivalent to 16 Threads)
                    INTEL with 8 Cores (equivalent to 16 Threads)

                    CORE Scenario 2:
                    <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                    Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                    Comparison Table:<\/strong><\/p>\n\n\n\n

                    An Excel comparison table between AIX and Linux concerning
                    \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                    Calculating the relation between AIX and INTEL using the TPM values:
                    <\/p>\n\n\n\n

                    \"\"<\/figure>\n\n\n\n

                    Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                    <\/p>\n\n\n\n

                    \"\"<\/figure>\n\n\n\n

                    Efficiency ratio calculation:
                    <\/p>\n\n\n\n

                    \"\"<\/figure>\n\n\n\n

                    The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                    Testing Runs to be recorded:
                    <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                    During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                    We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                    We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                    Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                    We call it: MEMORY ONLY QUERY TEST

                    CORE Scenario 1:
                    SH Test run 1-6:
                    AIX 13:00-13:30
                    LINUX 13:30-14:00

                    CORE Scenario 2:
                    SH Test run 6-12:
                    AIX 14:00-14:30
                    LINUX 14:30-15:00

                    <\/p>\n\n\n\n

                    \"\"
                    works fine ..<\/figcaption><\/figure>\n\n\n\n

                    To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                    <\/p>\n\n\n\n

                    \"\"
                    Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                    CORE Scenario 1:
                    SOE_V2 Test run 1-6:
                    AIX 15:00-15:30
                    LINUX 15:30-16:00 <\/p>\n\n\n\n

                    CORE Scenario 2:
                    SOE_V2 Test run 1-6:
                    AIX 16:00-16:30
                    LINUX 16:30-17:00 <\/p>\n\n\n\n

                    Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                    <\/p>\n\n\n\n

                    \"\"<\/figure>\n\n\n\n

                    Our Customer is now Happy!<\/p>\n\n\n\n

                    Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                    Bug or Feature ?<\/p>\n\n\n\n

                    \"\"
                    Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n

                    Info from Oracle: <\/p>\n\n\n\n


                    \n\n\n\n

                    Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                    We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                    You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                    apex.util.defineTemplates([{<\/p>\n\n\n\n

                        name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                        template: \"#VAL#\"<\/p>\n\n\n\n

                    }]);<\/p>\n\n\n\n

                    apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                        VAL:=Hello World<\/p>\n\n\n\n

                    {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                    \n\n\n\n

                    Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                    Lernen Sie uns direkt und live kennen!

                    Datum

                    Veranstaltung & Thema

                    Vortragender

                    Info

                    20 Feb 2024
                    praxistage

                    Praxistage 2024

                    Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

                    IMG_8454 scaled e1708456633598
                    Bernd Schellnast
                    Geschäftsführer / Head of Operations
                    20.-21 Mär 2024
                    Thomas_bg e1706660317238
                    Thomas Petrik
                    Geschäftsführer / Head of Consulting
                    Nov 2024
                    doag_test

                    DOAG 2023

                    Data Governance

                    Thomas_bg e1706660317238
                    Thomas Petrik
                    Geschäftsführer / Head of Consulting
                     

                    Unsere Kunden vertrauen auf unsere bewährte Expertise

                     

                    Unsere Fachspezialisten im Fokus:
                    Das Managed Service Team

                    Termin Vereinbaren und sich überzeugen!

                    [contact-form-7 id="8788" title="Home Nine Contact Form"]
                    \n

                    Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                    CPU Settings Preparation:
                    This is essential to prevent automatic scaling.

                    A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                      \n
                    1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                    2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                      B. Intel Platform Configuration<\/p>\n\n\n\n

                        \n
                      1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                        CORE Scenario 1:
                        <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                        AIX with 2 Cores (equivalent to 16 Threads)
                        INTEL with 8 Cores (equivalent to 16 Threads)

                        CORE Scenario 2:
                        <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                        Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                        Comparison Table:<\/strong><\/p>\n\n\n\n

                        An Excel comparison table between AIX and Linux concerning
                        \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                        Calculating the relation between AIX and INTEL using the TPM values:
                        <\/p>\n\n\n\n

                        \"\"<\/figure>\n\n\n\n

                        Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                        <\/p>\n\n\n\n

                        \"\"<\/figure>\n\n\n\n

                        Efficiency ratio calculation:
                        <\/p>\n\n\n\n

                        \"\"<\/figure>\n\n\n\n

                        The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                        Testing Runs to be recorded:
                        <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                        During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                        We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                        We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                        Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                        We call it: MEMORY ONLY QUERY TEST

                        CORE Scenario 1:
                        SH Test run 1-6:
                        AIX 13:00-13:30
                        LINUX 13:30-14:00

                        CORE Scenario 2:
                        SH Test run 6-12:
                        AIX 14:00-14:30
                        LINUX 14:30-15:00

                        <\/p>\n\n\n\n

                        \"\"
                        works fine ..<\/figcaption><\/figure>\n\n\n\n

                        To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                        <\/p>\n\n\n\n

                        \"\"
                        Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                        CORE Scenario 1:
                        SOE_V2 Test run 1-6:
                        AIX 15:00-15:30
                        LINUX 15:30-16:00 <\/p>\n\n\n\n

                        CORE Scenario 2:
                        SOE_V2 Test run 1-6:
                        AIX 16:00-16:30
                        LINUX 16:30-17:00 <\/p>\n\n\n\n

                        Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                        <\/p>\n\n\n\n

                        \"\"<\/figure>\n\n\n\n

                        Our Customer is now Happy!<\/p>\n\n\n\n

                        Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                        Bug or Feature ?<\/p>\n\n\n\n

                        \"\"
                        Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                        \"\"<\/figure>\n\n\n\n

                        Info from Oracle: <\/p>\n\n\n\n


                        \n\n\n\n

                        Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                        We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                        You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                        apex.util.defineTemplates([{<\/p>\n\n\n\n

                            name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                            template: \"#VAL#\"<\/p>\n\n\n\n

                        }]);<\/p>\n\n\n\n

                        apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                            VAL:=Hello World<\/p>\n\n\n\n

                        {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                        \n\n\n\n

                        Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                        Lernen Sie uns direkt und live kennen!

                        Datum

                        Veranstaltung & Thema

                        Vortragender

                        Info

                        20 Feb 2024
                        praxistage

                        Praxistage 2024

                        Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

                        IMG_8454 scaled e1708456633598
                        Bernd Schellnast
                        Geschäftsführer / Head of Operations
                        20.-21 Mär 2024
                        Thomas_bg e1706660317238
                        Thomas Petrik
                        Geschäftsführer / Head of Consulting
                        Nov 2024
                        doag_test

                        DOAG 2023

                        Data Governance

                        Thomas_bg e1706660317238
                        Thomas Petrik
                        Geschäftsführer / Head of Consulting
                         

                        Unsere Kunden vertrauen auf unsere bewährte Expertise

                         

                        Unsere Fachspezialisten im Fokus:
                        Das Managed Service Team

                        Termin Vereinbaren und sich überzeugen!

                        [contact-form-7 id="8788" title="Home Nine Contact Form"]
                        \n

                        We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                        Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                        CPU Settings Preparation:
                        This is essential to prevent automatic scaling.

                        A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                          \n
                        1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                        2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                          B. Intel Platform Configuration<\/p>\n\n\n\n

                            \n
                          1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                            CORE Scenario 1:
                            <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                            AIX with 2 Cores (equivalent to 16 Threads)
                            INTEL with 8 Cores (equivalent to 16 Threads)

                            CORE Scenario 2:
                            <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                            Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                            Comparison Table:<\/strong><\/p>\n\n\n\n

                            An Excel comparison table between AIX and Linux concerning
                            \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                            Calculating the relation between AIX and INTEL using the TPM values:
                            <\/p>\n\n\n\n

                            \"\"<\/figure>\n\n\n\n

                            Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                            <\/p>\n\n\n\n

                            \"\"<\/figure>\n\n\n\n

                            Efficiency ratio calculation:
                            <\/p>\n\n\n\n

                            \"\"<\/figure>\n\n\n\n

                            The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                            Testing Runs to be recorded:
                            <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                            During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                            We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                            We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                            Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                            We call it: MEMORY ONLY QUERY TEST

                            CORE Scenario 1:
                            SH Test run 1-6:
                            AIX 13:00-13:30
                            LINUX 13:30-14:00

                            CORE Scenario 2:
                            SH Test run 6-12:
                            AIX 14:00-14:30
                            LINUX 14:30-15:00

                            <\/p>\n\n\n\n

                            \"\"
                            works fine ..<\/figcaption><\/figure>\n\n\n\n

                            To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                            <\/p>\n\n\n\n

                            \"\"
                            Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                            CORE Scenario 1:
                            SOE_V2 Test run 1-6:
                            AIX 15:00-15:30
                            LINUX 15:30-16:00 <\/p>\n\n\n\n

                            CORE Scenario 2:
                            SOE_V2 Test run 1-6:
                            AIX 16:00-16:30
                            LINUX 16:30-17:00 <\/p>\n\n\n\n

                            Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                            <\/p>\n\n\n\n

                            \"\"<\/figure>\n\n\n\n

                            Our Customer is now Happy!<\/p>\n\n\n\n

                            Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                            Bug or Feature ?<\/p>\n\n\n\n

                            \"\"
                            Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                            \"\"<\/figure>\n\n\n\n

                            Info from Oracle: <\/p>\n\n\n\n


                            \n\n\n\n

                            Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                            We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                            You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                            apex.util.defineTemplates([{<\/p>\n\n\n\n

                                name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                template: \"#VAL#\"<\/p>\n\n\n\n

                            }]);<\/p>\n\n\n\n

                            apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                VAL:=Hello World<\/p>\n\n\n\n

                            {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                            \n\n\n\n

                            Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                            Lernen Sie uns direkt und live kennen!

                            Datum

                            Veranstaltung & Thema

                            Vortragender

                            Info

                            20 Feb 2024
                            praxistage

                            Praxistage 2024

                            Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

                            IMG_8454 scaled e1708456633598
                            Bernd Schellnast
                            Geschäftsführer / Head of Operations
                            20.-21 Mär 2024
                            Thomas_bg e1706660317238
                            Thomas Petrik
                            Geschäftsführer / Head of Consulting
                            Nov 2024
                            doag_test

                            DOAG 2023

                            Data Governance

                            Thomas_bg e1706660317238
                            Thomas Petrik
                            Geschäftsführer / Head of Consulting
                             

                            Unsere Kunden vertrauen auf unsere bewährte Expertise

                             

                            Unsere Fachspezialisten im Fokus:
                            Das Managed Service Team

                            Termin Vereinbaren und sich überzeugen!

                            [contact-form-7 id="8788" title="Home Nine Contact Form"]
                            \n

                            Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                            We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                            Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                            CPU Settings Preparation:
                            This is essential to prevent automatic scaling.

                            A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                              \n
                            1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                            2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                              B. Intel Platform Configuration<\/p>\n\n\n\n

                                \n
                              1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                CORE Scenario 1:
                                <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                AIX with 2 Cores (equivalent to 16 Threads)
                                INTEL with 8 Cores (equivalent to 16 Threads)

                                CORE Scenario 2:
                                <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                Comparison Table:<\/strong><\/p>\n\n\n\n

                                An Excel comparison table between AIX and Linux concerning
                                \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                Calculating the relation between AIX and INTEL using the TPM values:
                                <\/p>\n\n\n\n

                                \"\"<\/figure>\n\n\n\n

                                Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                <\/p>\n\n\n\n

                                \"\"<\/figure>\n\n\n\n

                                Efficiency ratio calculation:
                                <\/p>\n\n\n\n

                                \"\"<\/figure>\n\n\n\n

                                The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                Testing Runs to be recorded:
                                <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                We call it: MEMORY ONLY QUERY TEST

                                CORE Scenario 1:
                                SH Test run 1-6:
                                AIX 13:00-13:30
                                LINUX 13:30-14:00

                                CORE Scenario 2:
                                SH Test run 6-12:
                                AIX 14:00-14:30
                                LINUX 14:30-15:00

                                <\/p>\n\n\n\n

                                \"\"
                                works fine ..<\/figcaption><\/figure>\n\n\n\n

                                To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                <\/p>\n\n\n\n

                                \"\"
                                Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                CORE Scenario 1:
                                SOE_V2 Test run 1-6:
                                AIX 15:00-15:30
                                LINUX 15:30-16:00 <\/p>\n\n\n\n

                                CORE Scenario 2:
                                SOE_V2 Test run 1-6:
                                AIX 16:00-16:30
                                LINUX 16:30-17:00 <\/p>\n\n\n\n

                                Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                <\/p>\n\n\n\n

                                \"\"<\/figure>\n\n\n\n

                                Our Customer is now Happy!<\/p>\n\n\n\n

                                Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                Bug or Feature ?<\/p>\n\n\n\n

                                \"\"
                                Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                \"\"<\/figure>\n\n\n\n

                                Info from Oracle: <\/p>\n\n\n\n


                                \n\n\n\n

                                Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                apex.util.defineTemplates([{<\/p>\n\n\n\n

                                    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                    template: \"#VAL#\"<\/p>\n\n\n\n

                                }]);<\/p>\n\n\n\n

                                apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                    VAL:=Hello World<\/p>\n\n\n\n

                                {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                \n\n\n\n

                                Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                 

                                Unsere Kunden vertrauen auf unsere bewährte Expertise

                                 

                                Unsere Fachspezialisten im Fokus:
                                Das Managed Service Team

                                Termin Vereinbaren und sich überzeugen!

                                [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                \n

                                Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                CPU Settings Preparation:
                                This is essential to prevent automatic scaling.

                                A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                  \n
                                1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                  B. Intel Platform Configuration<\/p>\n\n\n\n

                                    \n
                                  1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                    CORE Scenario 1:
                                    <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                    AIX with 2 Cores (equivalent to 16 Threads)
                                    INTEL with 8 Cores (equivalent to 16 Threads)

                                    CORE Scenario 2:
                                    <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                    Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                    Comparison Table:<\/strong><\/p>\n\n\n\n

                                    An Excel comparison table between AIX and Linux concerning
                                    \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                    Calculating the relation between AIX and INTEL using the TPM values:
                                    <\/p>\n\n\n\n

                                    \"\"<\/figure>\n\n\n\n

                                    Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                    <\/p>\n\n\n\n

                                    \"\"<\/figure>\n\n\n\n

                                    Efficiency ratio calculation:
                                    <\/p>\n\n\n\n

                                    \"\"<\/figure>\n\n\n\n

                                    The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                    Testing Runs to be recorded:
                                    <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                    During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                    We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                    We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                    Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                    We call it: MEMORY ONLY QUERY TEST

                                    CORE Scenario 1:
                                    SH Test run 1-6:
                                    AIX 13:00-13:30
                                    LINUX 13:30-14:00

                                    CORE Scenario 2:
                                    SH Test run 6-12:
                                    AIX 14:00-14:30
                                    LINUX 14:30-15:00

                                    <\/p>\n\n\n\n

                                    \"\"
                                    works fine ..<\/figcaption><\/figure>\n\n\n\n

                                    To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                    <\/p>\n\n\n\n

                                    \"\"
                                    Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                    CORE Scenario 1:
                                    SOE_V2 Test run 1-6:
                                    AIX 15:00-15:30
                                    LINUX 15:30-16:00 <\/p>\n\n\n\n

                                    CORE Scenario 2:
                                    SOE_V2 Test run 1-6:
                                    AIX 16:00-16:30
                                    LINUX 16:30-17:00 <\/p>\n\n\n\n

                                    Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                    <\/p>\n\n\n\n

                                    \"\"<\/figure>\n\n\n\n

                                    Our Customer is now Happy!<\/p>\n\n\n\n

                                    Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                    Bug or Feature ?<\/p>\n\n\n\n

                                    \"\"
                                    Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                    \"\"<\/figure>\n\n\n\n

                                    Info from Oracle: <\/p>\n\n\n\n


                                    \n\n\n\n

                                    Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                    We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                    You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                    apex.util.defineTemplates([{<\/p>\n\n\n\n

                                        name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                        template: \"#VAL#\"<\/p>\n\n\n\n

                                    }]);<\/p>\n\n\n\n

                                    apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                        VAL:=Hello World<\/p>\n\n\n\n

                                    {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                    \n\n\n\n

                                    Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                     

                                    Unsere Kunden vertrauen auf unsere bewährte Expertise

                                     

                                    Unsere Fachspezialisten im Fokus:
                                    Das Managed Service Team

                                    Termin Vereinbaren und sich überzeugen!

                                    [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                    \n

                                    Files<\/p>\n\n\n\n

                                    Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                    Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                    We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                    Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                    CPU Settings Preparation:
                                    This is essential to prevent automatic scaling.

                                    A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                      \n
                                    1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                    2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                      B. Intel Platform Configuration<\/p>\n\n\n\n

                                        \n
                                      1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                        CORE Scenario 1:
                                        <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                        AIX with 2 Cores (equivalent to 16 Threads)
                                        INTEL with 8 Cores (equivalent to 16 Threads)

                                        CORE Scenario 2:
                                        <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                        Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                        Comparison Table:<\/strong><\/p>\n\n\n\n

                                        An Excel comparison table between AIX and Linux concerning
                                        \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                        Calculating the relation between AIX and INTEL using the TPM values:
                                        <\/p>\n\n\n\n

                                        \"\"<\/figure>\n\n\n\n

                                        Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                        <\/p>\n\n\n\n

                                        \"\"<\/figure>\n\n\n\n

                                        Efficiency ratio calculation:
                                        <\/p>\n\n\n\n

                                        \"\"<\/figure>\n\n\n\n

                                        The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                        Testing Runs to be recorded:
                                        <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                        During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                        We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                        We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                        Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                        We call it: MEMORY ONLY QUERY TEST

                                        CORE Scenario 1:
                                        SH Test run 1-6:
                                        AIX 13:00-13:30
                                        LINUX 13:30-14:00

                                        CORE Scenario 2:
                                        SH Test run 6-12:
                                        AIX 14:00-14:30
                                        LINUX 14:30-15:00

                                        <\/p>\n\n\n\n

                                        \"\"
                                        works fine ..<\/figcaption><\/figure>\n\n\n\n

                                        To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                        <\/p>\n\n\n\n

                                        \"\"
                                        Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                        CORE Scenario 1:
                                        SOE_V2 Test run 1-6:
                                        AIX 15:00-15:30
                                        LINUX 15:30-16:00 <\/p>\n\n\n\n

                                        CORE Scenario 2:
                                        SOE_V2 Test run 1-6:
                                        AIX 16:00-16:30
                                        LINUX 16:30-17:00 <\/p>\n\n\n\n

                                        Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                        <\/p>\n\n\n\n

                                        \"\"<\/figure>\n\n\n\n

                                        Our Customer is now Happy!<\/p>\n\n\n\n

                                        Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                        Bug or Feature ?<\/p>\n\n\n\n

                                        \"\"
                                        Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                        \"\"<\/figure>\n\n\n\n

                                        Info from Oracle: <\/p>\n\n\n\n


                                        \n\n\n\n

                                        Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                        We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                        You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                        apex.util.defineTemplates([{<\/p>\n\n\n\n

                                            name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                            template: \"#VAL#\"<\/p>\n\n\n\n

                                        }]);<\/p>\n\n\n\n

                                        apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                            VAL:=Hello World<\/p>\n\n\n\n

                                        {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                        \n\n\n\n

                                        Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                         

                                        Unsere Kunden vertrauen auf unsere bewährte Expertise

                                         

                                        Unsere Fachspezialisten im Fokus:
                                        Das Managed Service Team

                                        Termin Vereinbaren und sich überzeugen!

                                        [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                        \n

                                        Erfahren Sie mehr in unserem Whitepaper!<\/strong><\/p>\n\n\n\n

                                        Files<\/p>\n\n\n\n

                                        Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                        Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                        We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                        Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                        CPU Settings Preparation:
                                        This is essential to prevent automatic scaling.

                                        A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                          \n
                                        1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                        2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                          B. Intel Platform Configuration<\/p>\n\n\n\n

                                            \n
                                          1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                            CORE Scenario 1:
                                            <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                            AIX with 2 Cores (equivalent to 16 Threads)
                                            INTEL with 8 Cores (equivalent to 16 Threads)

                                            CORE Scenario 2:
                                            <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                            Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                            Comparison Table:<\/strong><\/p>\n\n\n\n

                                            An Excel comparison table between AIX and Linux concerning
                                            \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                            Calculating the relation between AIX and INTEL using the TPM values:
                                            <\/p>\n\n\n\n

                                            \"\"<\/figure>\n\n\n\n

                                            Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                            <\/p>\n\n\n\n

                                            \"\"<\/figure>\n\n\n\n

                                            Efficiency ratio calculation:
                                            <\/p>\n\n\n\n

                                            \"\"<\/figure>\n\n\n\n

                                            The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                            Testing Runs to be recorded:
                                            <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                            During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                            We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                            We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                            Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                            We call it: MEMORY ONLY QUERY TEST

                                            CORE Scenario 1:
                                            SH Test run 1-6:
                                            AIX 13:00-13:30
                                            LINUX 13:30-14:00

                                            CORE Scenario 2:
                                            SH Test run 6-12:
                                            AIX 14:00-14:30
                                            LINUX 14:30-15:00

                                            <\/p>\n\n\n\n

                                            \"\"
                                            works fine ..<\/figcaption><\/figure>\n\n\n\n

                                            To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                            <\/p>\n\n\n\n

                                            \"\"
                                            Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                            CORE Scenario 1:
                                            SOE_V2 Test run 1-6:
                                            AIX 15:00-15:30
                                            LINUX 15:30-16:00 <\/p>\n\n\n\n

                                            CORE Scenario 2:
                                            SOE_V2 Test run 1-6:
                                            AIX 16:00-16:30
                                            LINUX 16:30-17:00 <\/p>\n\n\n\n

                                            Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                            <\/p>\n\n\n\n

                                            \"\"<\/figure>\n\n\n\n

                                            Our Customer is now Happy!<\/p>\n\n\n\n

                                            Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                            Bug or Feature ?<\/p>\n\n\n\n

                                            \"\"
                                            Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                            \"\"<\/figure>\n\n\n\n

                                            Info from Oracle: <\/p>\n\n\n\n


                                            \n\n\n\n

                                            Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                            We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                            You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                            apex.util.defineTemplates([{<\/p>\n\n\n\n

                                                name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                                template: \"#VAL#\"<\/p>\n\n\n\n

                                            }]);<\/p>\n\n\n\n

                                            apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                                VAL:=Hello World<\/p>\n\n\n\n

                                            {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                            \n\n\n\n

                                            Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                             

                                            Unsere Kunden vertrauen auf unsere bewährte Expertise

                                             

                                            Unsere Fachspezialisten im Fokus:
                                            Das Managed Service Team

                                            Termin Vereinbaren und sich überzeugen!

                                            [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                            \n
                                            \"Zielarchitektur\"\/<\/figure>\n\n\n\n

                                            Erfahren Sie mehr in unserem Whitepaper!<\/strong><\/p>\n\n\n\n

                                            Files<\/p>\n\n\n\n

                                            Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                            Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                            We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                            Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                            CPU Settings Preparation:
                                            This is essential to prevent automatic scaling.

                                            A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                              \n
                                            1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                            2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                              B. Intel Platform Configuration<\/p>\n\n\n\n

                                                \n
                                              1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                                CORE Scenario 1:
                                                <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                                AIX with 2 Cores (equivalent to 16 Threads)
                                                INTEL with 8 Cores (equivalent to 16 Threads)

                                                CORE Scenario 2:
                                                <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                                Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                                Comparison Table:<\/strong><\/p>\n\n\n\n

                                                An Excel comparison table between AIX and Linux concerning
                                                \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                                Calculating the relation between AIX and INTEL using the TPM values:
                                                <\/p>\n\n\n\n

                                                \"\"<\/figure>\n\n\n\n

                                                Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                                <\/p>\n\n\n\n

                                                \"\"<\/figure>\n\n\n\n

                                                Efficiency ratio calculation:
                                                <\/p>\n\n\n\n

                                                \"\"<\/figure>\n\n\n\n

                                                The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                                Testing Runs to be recorded:
                                                <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                                During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                                We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                                We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                                Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                                We call it: MEMORY ONLY QUERY TEST

                                                CORE Scenario 1:
                                                SH Test run 1-6:
                                                AIX 13:00-13:30
                                                LINUX 13:30-14:00

                                                CORE Scenario 2:
                                                SH Test run 6-12:
                                                AIX 14:00-14:30
                                                LINUX 14:30-15:00

                                                <\/p>\n\n\n\n

                                                \"\"
                                                works fine ..<\/figcaption><\/figure>\n\n\n\n

                                                To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                                <\/p>\n\n\n\n

                                                \"\"
                                                Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                                CORE Scenario 1:
                                                SOE_V2 Test run 1-6:
                                                AIX 15:00-15:30
                                                LINUX 15:30-16:00 <\/p>\n\n\n\n

                                                CORE Scenario 2:
                                                SOE_V2 Test run 1-6:
                                                AIX 16:00-16:30
                                                LINUX 16:30-17:00 <\/p>\n\n\n\n

                                                Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                                <\/p>\n\n\n\n

                                                \"\"<\/figure>\n\n\n\n

                                                Our Customer is now Happy!<\/p>\n\n\n\n

                                                Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                                Bug or Feature ?<\/p>\n\n\n\n

                                                \"\"
                                                Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                                \"\"<\/figure>\n\n\n\n

                                                Info from Oracle: <\/p>\n\n\n\n


                                                \n\n\n\n

                                                Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                                We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                                You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                                apex.util.defineTemplates([{<\/p>\n\n\n\n

                                                    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                                    template: \"#VAL#\"<\/p>\n\n\n\n

                                                }]);<\/p>\n\n\n\n

                                                apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                                    VAL:=Hello World<\/p>\n\n\n\n

                                                {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                                \n\n\n\n

                                                Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                                 

                                                Unsere Kunden vertrauen auf unsere bewährte Expertise

                                                 

                                                Unsere Fachspezialisten im Fokus:
                                                Das Managed Service Team

                                                Termin Vereinbaren und sich überzeugen!

                                                [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                                \n

                                                Wer sich f\u00fcr Exasol als Accelerator f\u00fcr sein Oracle DWH entscheidet und zu den Gl\u00fccklichen geh\u00f6rt, die den ODI im Einsatz haben, der hat schon gewonnen. Denn mit dem \u201eLink2Go\u201c Bundle von sphinx verbinden sich die beiden Technologien nahtlos zu einer hochperformanten und leicht wartbaren DWH-L\u00f6sung.<\/p>\n\n\n\n

                                                \"Zielarchitektur\"\/<\/figure>\n\n\n\n

                                                Erfahren Sie mehr in unserem Whitepaper!<\/strong><\/p>\n\n\n\n

                                                Files<\/p>\n\n\n\n

                                                Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                                Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                                We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                                Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                                CPU Settings Preparation:
                                                This is essential to prevent automatic scaling.

                                                A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                                  \n
                                                1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                                2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                                  B. Intel Platform Configuration<\/p>\n\n\n\n

                                                    \n
                                                  1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                                    CORE Scenario 1:
                                                    <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                                    AIX with 2 Cores (equivalent to 16 Threads)
                                                    INTEL with 8 Cores (equivalent to 16 Threads)

                                                    CORE Scenario 2:
                                                    <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                                    Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                                    Comparison Table:<\/strong><\/p>\n\n\n\n

                                                    An Excel comparison table between AIX and Linux concerning
                                                    \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                                    Calculating the relation between AIX and INTEL using the TPM values:
                                                    <\/p>\n\n\n\n

                                                    \"\"<\/figure>\n\n\n\n

                                                    Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                                    <\/p>\n\n\n\n

                                                    \"\"<\/figure>\n\n\n\n

                                                    Efficiency ratio calculation:
                                                    <\/p>\n\n\n\n

                                                    \"\"<\/figure>\n\n\n\n

                                                    The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                                    Testing Runs to be recorded:
                                                    <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                                    During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                                    We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                                    We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                                    Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                                    We call it: MEMORY ONLY QUERY TEST

                                                    CORE Scenario 1:
                                                    SH Test run 1-6:
                                                    AIX 13:00-13:30
                                                    LINUX 13:30-14:00

                                                    CORE Scenario 2:
                                                    SH Test run 6-12:
                                                    AIX 14:00-14:30
                                                    LINUX 14:30-15:00

                                                    <\/p>\n\n\n\n

                                                    \"\"
                                                    works fine ..<\/figcaption><\/figure>\n\n\n\n

                                                    To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                                    <\/p>\n\n\n\n

                                                    \"\"
                                                    Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                                    CORE Scenario 1:
                                                    SOE_V2 Test run 1-6:
                                                    AIX 15:00-15:30
                                                    LINUX 15:30-16:00 <\/p>\n\n\n\n

                                                    CORE Scenario 2:
                                                    SOE_V2 Test run 1-6:
                                                    AIX 16:00-16:30
                                                    LINUX 16:30-17:00 <\/p>\n\n\n\n

                                                    Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                                    <\/p>\n\n\n\n

                                                    \"\"<\/figure>\n\n\n\n

                                                    Our Customer is now Happy!<\/p>\n\n\n\n

                                                    Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                                    Bug or Feature ?<\/p>\n\n\n\n

                                                    \"\"
                                                    Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                                    \"\"<\/figure>\n\n\n\n

                                                    Info from Oracle: <\/p>\n\n\n\n


                                                    \n\n\n\n

                                                    Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                                    We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                                    You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                                    apex.util.defineTemplates([{<\/p>\n\n\n\n

                                                        name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                                        template: \"#VAL#\"<\/p>\n\n\n\n

                                                    }]);<\/p>\n\n\n\n

                                                    apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                                        VAL:=Hello World<\/p>\n\n\n\n

                                                    {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                                    \n\n\n\n

                                                    Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                                     

                                                    Unsere Kunden vertrauen auf unsere bewährte Expertise

                                                     

                                                    Unsere Fachspezialisten im Fokus:
                                                    Das Managed Service Team

                                                    Termin Vereinbaren und sich überzeugen!

                                                    [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                                    \n

                                                    Exasol als \u201eschnellste DWH Datenbank der Welt\u201c kann leicht in die bestehende DWH Landschaft integriert werden, braucht kein laufendes Tuning und kommt sogar mit teuren Ad-hoc Abfragen hervorragend zurecht. ODI als m\u00e4chtiges und flexibles ETL-Werkzeug ist eine gute L\u00f6sung, um den individuellen Anforderungen an die Datenintegration gerecht zu werden.<\/p>\n\n\n\n

                                                    Wer sich f\u00fcr Exasol als Accelerator f\u00fcr sein Oracle DWH entscheidet und zu den Gl\u00fccklichen geh\u00f6rt, die den ODI im Einsatz haben, der hat schon gewonnen. Denn mit dem \u201eLink2Go\u201c Bundle von sphinx verbinden sich die beiden Technologien nahtlos zu einer hochperformanten und leicht wartbaren DWH-L\u00f6sung.<\/p>\n\n\n\n

                                                    \"Zielarchitektur\"\/<\/figure>\n\n\n\n

                                                    Erfahren Sie mehr in unserem Whitepaper!<\/strong><\/p>\n\n\n\n

                                                    Files<\/p>\n\n\n\n

                                                    Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                                    Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                                    We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                                    Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                                    CPU Settings Preparation:
                                                    This is essential to prevent automatic scaling.

                                                    A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                                      \n
                                                    1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                                    2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                                      B. Intel Platform Configuration<\/p>\n\n\n\n

                                                        \n
                                                      1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                                        CORE Scenario 1:
                                                        <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                                        AIX with 2 Cores (equivalent to 16 Threads)
                                                        INTEL with 8 Cores (equivalent to 16 Threads)

                                                        CORE Scenario 2:
                                                        <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                                        Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                                        Comparison Table:<\/strong><\/p>\n\n\n\n

                                                        An Excel comparison table between AIX and Linux concerning
                                                        \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                                        Calculating the relation between AIX and INTEL using the TPM values:
                                                        <\/p>\n\n\n\n

                                                        \"\"<\/figure>\n\n\n\n

                                                        Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                                        <\/p>\n\n\n\n

                                                        \"\"<\/figure>\n\n\n\n

                                                        Efficiency ratio calculation:
                                                        <\/p>\n\n\n\n

                                                        \"\"<\/figure>\n\n\n\n

                                                        The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                                        Testing Runs to be recorded:
                                                        <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                                        During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                                        We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                                        We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                                        Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                                        We call it: MEMORY ONLY QUERY TEST

                                                        CORE Scenario 1:
                                                        SH Test run 1-6:
                                                        AIX 13:00-13:30
                                                        LINUX 13:30-14:00

                                                        CORE Scenario 2:
                                                        SH Test run 6-12:
                                                        AIX 14:00-14:30
                                                        LINUX 14:30-15:00

                                                        <\/p>\n\n\n\n

                                                        \"\"
                                                        works fine ..<\/figcaption><\/figure>\n\n\n\n

                                                        To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                                        <\/p>\n\n\n\n

                                                        \"\"
                                                        Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                                        CORE Scenario 1:
                                                        SOE_V2 Test run 1-6:
                                                        AIX 15:00-15:30
                                                        LINUX 15:30-16:00 <\/p>\n\n\n\n

                                                        CORE Scenario 2:
                                                        SOE_V2 Test run 1-6:
                                                        AIX 16:00-16:30
                                                        LINUX 16:30-17:00 <\/p>\n\n\n\n

                                                        Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                                        <\/p>\n\n\n\n

                                                        \"\"<\/figure>\n\n\n\n

                                                        Our Customer is now Happy!<\/p>\n\n\n\n

                                                        Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                                        Bug or Feature ?<\/p>\n\n\n\n

                                                        \"\"
                                                        Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                                        \"\"<\/figure>\n\n\n\n

                                                        Info from Oracle: <\/p>\n\n\n\n


                                                        \n\n\n\n

                                                        Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                                        We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                                        You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                                        apex.util.defineTemplates([{<\/p>\n\n\n\n

                                                            name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                                            template: \"#VAL#\"<\/p>\n\n\n\n

                                                        }]);<\/p>\n\n\n\n

                                                        apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                                            VAL:=Hello World<\/p>\n\n\n\n

                                                        {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                                        \n\n\n\n

                                                        Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                                         

                                                        Unsere Kunden vertrauen auf unsere bewährte Expertise

                                                         

                                                        Unsere Fachspezialisten im Fokus:
                                                        Das Managed Service Team

                                                        Termin Vereinbaren und sich überzeugen!

                                                        [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                                        \n

                                                        Mit dem \u201eLink2Go\u201c Bundle von sphinx verbinden sich die beiden Technologien nahtlos zu einer hochperformanten und leicht wartbaren DWH-L\u00f6sung.<\/h3>\n\n\n\n

                                                        Exasol als \u201eschnellste DWH Datenbank der Welt\u201c kann leicht in die bestehende DWH Landschaft integriert werden, braucht kein laufendes Tuning und kommt sogar mit teuren Ad-hoc Abfragen hervorragend zurecht. ODI als m\u00e4chtiges und flexibles ETL-Werkzeug ist eine gute L\u00f6sung, um den individuellen Anforderungen an die Datenintegration gerecht zu werden.<\/p>\n\n\n\n

                                                        Wer sich f\u00fcr Exasol als Accelerator f\u00fcr sein Oracle DWH entscheidet und zu den Gl\u00fccklichen geh\u00f6rt, die den ODI im Einsatz haben, der hat schon gewonnen. Denn mit dem \u201eLink2Go\u201c Bundle von sphinx verbinden sich die beiden Technologien nahtlos zu einer hochperformanten und leicht wartbaren DWH-L\u00f6sung.<\/p>\n\n\n\n

                                                        \"Zielarchitektur\"\/<\/figure>\n\n\n\n

                                                        Erfahren Sie mehr in unserem Whitepaper!<\/strong><\/p>\n\n\n\n

                                                        Files<\/p>\n\n\n\n

                                                        Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                                        Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                                        We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                                        Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                                        CPU Settings Preparation:
                                                        This is essential to prevent automatic scaling.

                                                        A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                                          \n
                                                        1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                                        2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                                          B. Intel Platform Configuration<\/p>\n\n\n\n

                                                            \n
                                                          1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                                            CORE Scenario 1:
                                                            <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                                            AIX with 2 Cores (equivalent to 16 Threads)
                                                            INTEL with 8 Cores (equivalent to 16 Threads)

                                                            CORE Scenario 2:
                                                            <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                                            Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                                            Comparison Table:<\/strong><\/p>\n\n\n\n

                                                            An Excel comparison table between AIX and Linux concerning
                                                            \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                                            Calculating the relation between AIX and INTEL using the TPM values:
                                                            <\/p>\n\n\n\n

                                                            \"\"<\/figure>\n\n\n\n

                                                            Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                                            <\/p>\n\n\n\n

                                                            \"\"<\/figure>\n\n\n\n

                                                            Efficiency ratio calculation:
                                                            <\/p>\n\n\n\n

                                                            \"\"<\/figure>\n\n\n\n

                                                            The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                                            Testing Runs to be recorded:
                                                            <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                                            During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                                            We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                                            We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                                            Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                                            We call it: MEMORY ONLY QUERY TEST

                                                            CORE Scenario 1:
                                                            SH Test run 1-6:
                                                            AIX 13:00-13:30
                                                            LINUX 13:30-14:00

                                                            CORE Scenario 2:
                                                            SH Test run 6-12:
                                                            AIX 14:00-14:30
                                                            LINUX 14:30-15:00

                                                            <\/p>\n\n\n\n

                                                            \"\"
                                                            works fine ..<\/figcaption><\/figure>\n\n\n\n

                                                            To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                                            <\/p>\n\n\n\n

                                                            \"\"
                                                            Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                                            CORE Scenario 1:
                                                            SOE_V2 Test run 1-6:
                                                            AIX 15:00-15:30
                                                            LINUX 15:30-16:00 <\/p>\n\n\n\n

                                                            CORE Scenario 2:
                                                            SOE_V2 Test run 1-6:
                                                            AIX 16:00-16:30
                                                            LINUX 16:30-17:00 <\/p>\n\n\n\n

                                                            Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                                            <\/p>\n\n\n\n

                                                            \"\"<\/figure>\n\n\n\n

                                                            Our Customer is now Happy!<\/p>\n\n\n\n

                                                            Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                                            Bug or Feature ?<\/p>\n\n\n\n

                                                            \"\"
                                                            Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                                            \"\"<\/figure>\n\n\n\n

                                                            Info from Oracle: <\/p>\n\n\n\n


                                                            \n\n\n\n

                                                            Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                                            We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                                            You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                                            apex.util.defineTemplates([{<\/p>\n\n\n\n

                                                                name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                                                template: \"#VAL#\"<\/p>\n\n\n\n

                                                            }]);<\/p>\n\n\n\n

                                                            apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                                                VAL:=Hello World<\/p>\n\n\n\n

                                                            {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                                            \n\n\n\n

                                                            Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                                             

                                                            Unsere Kunden vertrauen auf unsere bewährte Expertise

                                                             

                                                            Unsere Fachspezialisten im Fokus:
                                                            Das Managed Service Team

                                                            Termin Vereinbaren und sich überzeugen!

                                                            [contact-form-7 id="8788" title="Home Nine Contact Form"]
                                                            \n

                                                            Exasol und der Oracle Data Integrator sind ein geniales Team<\/strong><\/p>\n\n\n\n

                                                            Mit dem \u201eLink2Go\u201c Bundle von sphinx verbinden sich die beiden Technologien nahtlos zu einer hochperformanten und leicht wartbaren DWH-L\u00f6sung.<\/h3>\n\n\n\n

                                                            Exasol als \u201eschnellste DWH Datenbank der Welt\u201c kann leicht in die bestehende DWH Landschaft integriert werden, braucht kein laufendes Tuning und kommt sogar mit teuren Ad-hoc Abfragen hervorragend zurecht. ODI als m\u00e4chtiges und flexibles ETL-Werkzeug ist eine gute L\u00f6sung, um den individuellen Anforderungen an die Datenintegration gerecht zu werden.<\/p>\n\n\n\n

                                                            Wer sich f\u00fcr Exasol als Accelerator f\u00fcr sein Oracle DWH entscheidet und zu den Gl\u00fccklichen geh\u00f6rt, die den ODI im Einsatz haben, der hat schon gewonnen. Denn mit dem \u201eLink2Go\u201c Bundle von sphinx verbinden sich die beiden Technologien nahtlos zu einer hochperformanten und leicht wartbaren DWH-L\u00f6sung.<\/p>\n\n\n\n

                                                            \"Zielarchitektur\"\/<\/figure>\n\n\n\n

                                                            Erfahren Sie mehr in unserem Whitepaper!<\/strong><\/p>\n\n\n\n

                                                            Files<\/p>\n\n\n\n

                                                            Produktblatt_exasol_odi_deutsch.pdf<\/a>280.17 KB<\/p>\n\n\n\n

                                                            Produktblatt_exasol_odi_english.pdf<\/a>218.67 KB<\/p>\n","post_title":"Exasol und der Oracle Data Integrator sind ein geniales Team","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"exasol-und-der-oracle-data-integrator-sind-ein-geniales-team","to_ping":"","pinged":"","post_modified":"2023-12-13 10:28:03","post_modified_gmt":"2023-12-13 10:28:03","post_content_filtered":"","post_parent":0,"guid":"https:\/\/hyperpixel.world\/?p=9826","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":348,"post_author":"1","post_date":"2023-10-25 14:00:16","post_date_gmt":"2023-10-25 12:00:16","post_content":"\n

                                                            We aim to answer the question: How many Intel CPUs are needed to match the performance of my current Power CPUs while considering Oracle licensing implications?<\/p>\n\n\n\n

                                                            Previously, there were issues capturing CPU and IO metrics in Swingbench using vmstat on AIX. After discussing with the developer, a fix is on the horizon. We had the opportunity to test this fix, and we are thrilled. The need for SSH connect to synchronize OS statistics on Swingbench is eliminated.<\/p>\n\n\n\n

                                                            CPU Settings Preparation:
                                                            This is essential to prevent automatic scaling.

                                                            A. IBM POWER LPAR Configuration<\/p>\n\n\n\n

                                                              \n
                                                            1. Please use CAPT LPAR to ensure that no additional resources can be activated.<\/li>\n\n\n\n
                                                            2. SMT - please activate (8 Threads)<\/li>\n<\/ol>\n\n\n\n

                                                              B. Intel Platform Configuration<\/p>\n\n\n\n

                                                                \n
                                                              1. Activate Hyper-Threading (2 Threads)<\/li>\n<\/ol>\n\n\n\n


                                                                CORE Scenario 1:
                                                                <\/strong>Purpose for Scenario 1: What's the actual value of a thread?
                                                                AIX with 2 Cores (equivalent to 16 Threads)
                                                                INTEL with 8 Cores (equivalent to 16 Threads)

                                                                CORE Scenario 2:
                                                                <\/strong>Purpose for Scenario 2: Conversion of core performance (license relevant)
                                                                Equal number of Cores on AIX and INTEL<\/p>\n\n\n\n


                                                                Comparison Table:<\/strong><\/p>\n\n\n\n

                                                                An Excel comparison table between AIX and Linux concerning
                                                                \"Transactions Per Minute\" (TPM) for different numbers of active users (4, 8, 16, 32, 64) is provided to set the utilization in relation.<\/p>\n\n\n\n

                                                                Calculating the relation between AIX and INTEL using the TPM values:
                                                                <\/p>\n\n\n\n

                                                                \"\"<\/figure>\n\n\n\n

                                                                Efficiency calculation of the systems (average value from all test runs SH\/OE separated):
                                                                <\/p>\n\n\n\n

                                                                \"\"<\/figure>\n\n\n\n

                                                                Efficiency ratio calculation:
                                                                <\/p>\n\n\n\n

                                                                \"\"<\/figure>\n\n\n\n

                                                                The performance ratio we have calculated can serve as a rough indicator for how many Intel CPUs are required to match the performance of an AIX POWER CPU.<\/p>\n\n\n\n

                                                                Testing Runs to be recorded:
                                                                <\/strong>Tip: Oracle Software should be the same Release at minimum, better with the same Patchlevel.

                                                                During each test, the CPU performance should not exceed 80%! <\/p>\n\n\n\n

                                                                We use the Sales History Schema which is provided from swingbench, but we only install a little dataset approx 100MB.<\/p>\n\n\n\n

                                                                We load the config and start the test every 5 min with different active user#. <\/p>\n\n\n\n

                                                                Sales History SETTINGS (DEFAULT) every 5 min with 4,8,16,32,64 Users<\/p>\n\n\n\n

                                                                We call it: MEMORY ONLY QUERY TEST

                                                                CORE Scenario 1:
                                                                SH Test run 1-6:
                                                                AIX 13:00-13:30
                                                                LINUX 13:30-14:00

                                                                CORE Scenario 2:
                                                                SH Test run 6-12:
                                                                AIX 14:00-14:30
                                                                LINUX 14:30-15:00

                                                                <\/p>\n\n\n\n

                                                                \"\"
                                                                works fine ..<\/figcaption><\/figure>\n\n\n\n

                                                                To get another Memory Only Szenario we repeat it with a Small SalesOrderEntry (SOE) Schema. OE Settings (without DML) every 5 min with 4,8,16,32,64 Users
                                                                <\/p>\n\n\n\n

                                                                \"\"
                                                                Settiongs SOEV2<\/figcaption><\/figure>\n\n\n\n

                                                                CORE Scenario 1:
                                                                SOE_V2 Test run 1-6:
                                                                AIX 15:00-15:30
                                                                LINUX 15:30-16:00 <\/p>\n\n\n\n

                                                                CORE Scenario 2:
                                                                SOE_V2 Test run 1-6:
                                                                AIX 16:00-16:30
                                                                LINUX 16:30-17:00 <\/p>\n\n\n\n

                                                                Now we enter the results in our given EXCEL Sheet to see a good Comparsion:
                                                                <\/p>\n\n\n\n

                                                                \"\"<\/figure>\n\n\n\n

                                                                Our Customer is now Happy!<\/p>\n\n\n\n

                                                                Feel free to contact us!<\/p>\n","post_title":"Swingbench Analysis: Power versus Intel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"swingbench-analysis-power-versus-intel","to_ping":"","pinged":"","post_modified":"2023-10-25 14:00:16","post_modified_gmt":"2023-10-25 12:00:16","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=348","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":332,"post_author":"1","post_date":"2023-08-07 18:59:28","post_date_gmt":"2023-08-07 16:59:28","post_content":"\n

                                                                Bug or Feature ?<\/p>\n\n\n\n

                                                                \"\"
                                                                Should work in Cards Region.. but.. <\/figcaption><\/figure>\n\n\n\n
                                                                \"\"<\/figure>\n\n\n\n

                                                                Info from Oracle: <\/p>\n\n\n\n


                                                                \n\n\n\n

                                                                Currently, \u00a0the Template Components cannot be used inside a Cards region. The reason is that Template Components are rendered on the server and Cards on the client.<\/p>\n\n\n\n

                                                                We hope to lift this restriction in a future release, we\u2019d like to push the Template Components to the client when needed. We must make sure the functionality is equal, currently the templates behave slightly different.<\/p>\n\n\n\n

                                                                You can use the {with\/} and {apply\/} syntax in cards but this is undocumented. You first need to call apex.util.defineTemplates:<\/p>\n\n\n\n

                                                                apex.util.defineTemplates([{<\/p>\n\n\n\n

                                                                    name: \"MY_TEMPLATE \",<\/p>\n\n\n\n

                                                                    template: \"#VAL#\"<\/p>\n\n\n\n

                                                                }]);<\/p>\n\n\n\n

                                                                apex.util.applyTemplate(`{with\/}<\/p>\n\n\n\n

                                                                    VAL:=Hello World<\/p>\n\n\n\n

                                                                {apply MY_TEMPLATE \/}`);<\/p>\n\n\n\n


                                                                \n\n\n\n

                                                                Nice to know now.. i will try this solution.. <\/p>\n","post_title":"Oracle Apex 23.1 Template Component","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"open","post_password":"","post_name":"oracle-apex-23-1-template-component","to_ping":"","pinged":"","post_modified":"2023-08-07 18:59:28","post_modified_gmt":"2023-08-07 16:59:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.sphinx.at\/blog\/?p=332","menu_order":0,"post_type":"post","post_mime_type":"","comment_count":"0","filter":"raw"}],"next":false,"prev":false,"total_page":1},"paged":1,"column_class":"jeg_col_1o3","class":"epic_block_3"};

                                                                 

                                                                Unsere Kunden vertrauen auf unsere bewährte Expertise

                                                                 

                                                                Unsere Fachspezialisten im Fokus:
                                                                Das Managed Service Team

                                                                Termin Vereinbaren und sich überzeugen!

                                                                [contact-form-7 id="8788" title="Home Nine Contact Form"]

                                                                sphinx - IT-Sicherheitsgarantie

                                                                Managed IT-Services
                                                                für maximale Zuverlässigkeit

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                sphinx - Ihr Strategischer IT-Berater

                                                                Datengetriebene Entscheidungen
                                                                & Effizienzsteigerung

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                Live - Demo

                                                                Data Science & Self Service BI
                                                                & Branchenunabhängige Lösungen

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                sphinx - IT-Sicherheitsgartie

                                                                Leistungsmaximierung
                                                                & Betriebsstabilität

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                IT - Consulting

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                IT - BERATUNG

                                                                & SERVICES

                                                                Analytics

                                                                We transform
                                                                Data to Value

                                                                sphinx IT - Analytics / Intelligence

                                                                Transforming Data
                                                                into Value

                                                                Tel:
                                                                +43 1 599 31 - 0

                                                                Consistent & Reliable...

                                                                Business Solution

                                                                For Your Newly Started Company

                                                                Easy To Fast Starup Growth

                                                                Consistent & Reliable...

                                                                Business Solution

                                                                Consulting

                                                                We solve any
                                                                IT -Problem

                                                                Tel:
                                                                +43 1 599 31 - 0

                                                                Consistent & Reliable...

                                                                Business Solution

                                                                For Your Newly Started Company

                                                                Easy To Fast Starup Growth

                                                                Consistent & Reliable...

                                                                Business Solution

                                                                Managed Services

                                                                Effortless IT &
                                                                Endless Possiblities

                                                                sphinx IT - Managed Services

                                                                Effortless IT
                                                                Endless Possibilities

                                                                Tel:
                                                                +43 1 599 31 - 0

                                                                Consistent & Reliable...

                                                                Business Solution

                                                                For Your Newly Started Company

                                                                Easy To Fast Starup Growth

                                                                Consistent & Reliable...

                                                                Business Solution

                                                                Thomas_HD e1706660467325

                                                                Innovativste IT-Lösungen

                                                                Ihr zuverlässiger Partner
                                                                für Unternehmen jeder Größe

                                                                count 1 1
                                                                200+

                                                                Erfolgreiche Projekte

                                                                count 1 2
                                                                30+

                                                                Jahre Erfahrung

                                                                count 1 3
                                                                25+

                                                                IT-Experten

                                                                count 1 4
                                                                100+

                                                                Zufriedene Kunden

                                                                  TRENDING

                                                                Branchennews und Expertenblogs: Bleiben Sie informiert

                                                                Currently Playing

                                                                Lernen Sie uns direkt und live kennen!

                                                                Datum

                                                                Veranstaltung & Thema

                                                                Vortragender

                                                                Info

                                                                20 Feb 2024
                                                                praxistage

                                                                Praxistage 2024

                                                                Stärkung der IT-Resilienz im Mittelstand – die Vorteile von On-Premises und Cloud

                                                                IMG_8454 scaled e1708456633598
                                                                Bernd Schellnast
                                                                Geschäftsführer / Head of Operations
                                                                20.-21 Mär 2024
                                                                Thomas_bg e1706660317238
                                                                Thomas Petrik
                                                                Geschäftsführer / Head of Consulting
                                                                Nov 2024
                                                                doag_test

                                                                DOAG 2023

                                                                Data Governance

                                                                Thomas_bg e1706660317238
                                                                Thomas Petrik
                                                                Geschäftsführer / Head of Consulting
                                                                 

                                                                Unsere Kunden vertrauen auf unsere bewährte Expertise

                                                                 

                                                                Unsere Fachspezialisten im Fokus:
                                                                Das Managed Service Team

                                                                Termin Vereinbaren und sich überzeugen!

                                                                [contact-form-7 id="8788" title="Home Nine Contact Form"]