Feed aggregator

Mission accomplished: OpenHack: Migrating Microsoft Workloads to Azure

Dietrich Schroff - 5 hours 50 min ago

 After three days of hard work i got my first OPENHACK badge:


Authorized by Microsoft

Here the details from Microsoft:

Earners of the OpenHack: Migration badge understand how to execute an end-to-end migration through optimization. They have shown that they can utilize Azure Migrate to migrate virtual machines to Microsoft Azure and can modernize legacy applications by migrating to PaaS services such as Azure SQL Database and Azure App Service. They have also have a foundational understanding of Azure identity, including hybrid identity with Azure AD and how to leverage Azure RBAC to govern and secure workloads.

It was really a great challenge to discuss and implement all the goals. Thanks to the excellent coaches and for providing the infrastructure!

静岡で水道修理を依頼する場合の方法

The Feature - 14 hours 34 min ago

水道が故障した場合には、とても不便を感じると同時に水漏れや詰まりなどの状況で、住宅設備にも被害を与えてしまうおそれもあります。そのためにも速やかな水道修理が必要となりますが、ご自身で対処しようとお考えの方も少なくないでしょう。一般的な修理やつまりの解消などは、静岡にも多数あるホームセンター等で購入できる部品や補修材、パイプクリーナー等で対処できる場合もあります。作業には経験や技術が必要なために、手慣れている人や器用な人であれば比較的スムーズに水道修理ができるかもしれませんが、状況を悪化させてしまうことが心配な方や、失敗をしたくないという方であれば、やはり静岡の水道修理会社に連絡をして作業を行ってもらうことが最適解と言えます。

水道関係の作業を請け負っている会社は静岡に多数ありますので、依頼先を見つける方法としてはインターネットの情報サイトがお勧めです。実績が豊富で対応が良好な水道修理の会社は、静岡に多く存在していますので、それらの中からより信頼性が高く技術力のある会社を見つけることで快適な生活を守ることにも繋がります。普段から水道の不具合が生じた場合には、どこに連絡して修理依頼をすればよいのかを把握しておくこともおすすめです。インターネットのウェブサイトで適切な情報を集め、水道修理をきちんと行ってもらいましょう。

水道は誰もが毎日使う設備ですので、いつでも快適な状態に保つことがとても大切です。

Categories: APPS Blogs

静岡で水道修理を依頼する場合の方法

Marian Crkon - 14 hours 34 min ago
水道が故障した場合には、とても不便を感じると同時に水漏れや詰まりなどの状況で、住宅設備にも被害を与えてしまうおそれもあります。そのためにも速やかな水道修理が必要となりますが、ご自身で対処しようとお考えの方も少なくないでしょう。一般的な修理やつまりの解消などは、静岡にも多数あるホームセンター等で購入できる部品や補修材、パイプクリーナー等で対処できる場合もあります。作業には経験や技術が必要なために、手慣れている人や器用な人であれば比較的スムーズに水道修理ができるかもしれませんが、状況を悪化させてしまうことが心配な方や、失敗をしたくないという方であれば、やはり静岡の水道修理会社に連絡をして作業を行ってもらうことが最適解と言えます。 水道関係の作業を請け負っている会社は静岡に多数ありますので、依頼先を見つける方法としてはインターネットの情報サイトがお勧めです。実績が豊富で対応が良好な水道修理の会社は、静岡に多く存在していますので、それらの中からより信頼性が高く技術力のある会社を見つけることで快適な生活を守ることにも繋がります。普段から水道の不具合が生じた場合には、どこに連絡して修理依頼をすればよいのかを把握しておくこともおすすめです。インターネットのウェブサイトで適切な情報を集め、水道修理をきちんと行ってもらいましょう。 水道は誰もが毎日使う設備ですので、いつでも快適な状態に保つことがとても大切です。

BARC Survey confirms: #Exasol dominates Analytical Database Peers

The Oracle Instructor - 15 hours 8 min ago

Exasol leads the categories Performance, Platform Reliability and Support Quality for Analytical Database products. And we get a 100% recommendation score from the 782 customers in the survey.

So it’s not one of the big names in the industry who comes out on top of this survey. Not Oracle, not Teradata, not Snowflake, not SAP Hana leads in Analytical Databases but Exasol!

Customer quote: “Unbelievable query performance with almost zero administration effort. You just have to experience it yourself. Once you see it for yourself, you won’t want to work with any other database.”

 

 

 

To summarize:

  1. Exasol is the world’s fastest analytical database
  2. Exasol is reliable and easy to maintain
  3. Exasol’s services and attitude towards customers are highly appreciated

Compare that with your legacy platform: It’s time to contact us now!

Categories: DBA Blogs

Partner Webcast – Enterprise Features for Hosting Web Apps on OCI

Web-based applications have become an essential component of business in today's world, be it Hosted, SaaS or on-demand applications. The majority of users is typically expecting easy, via a web...

We share our skills to maximize your revenue!
Categories: DBA Blogs

What are the alternatives for ORA_EXCEL (Oracle Excel) is a PL/SQL package for Oracle® database that produces Excel XLSX documents?

Tom Kyte - Wed, 2020-09-23 12:26
I wish to generate reports from my Oracle 11g database in an MS excel document(multiple tabs). Do we have a solution or a product from Oracle for this task? Thank you, Sunil
Categories: DBA Blogs

how to use profiler (similar to MS SQL Server) in Oracle SQL Developer

Tom Kyte - Wed, 2020-09-23 12:26
how to use profiler (similar to MS SQL Server) in Oracle SQL Developer
Categories: DBA Blogs

Split Records into Groups of N Rows

Tom Kyte - Wed, 2020-09-23 12:26
Got a SQL from the table with 100,000 + records , one particular varchar2 field contains strings like '12345', '56789', '1111'. I would like to create a table with split / chunks with appropriate comma seperate example in the live link ::: select listagg(id, ',') within group (order by id) from (select course_id as id from ad.AD_STUDENT_COURSE_DETAILS) Example :: 100 records each record has the following ids <code>1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99</code> Now Assume based on the above result sets I should be able to make my sequence dynamic and insert group of records into comma separated values (listagg) , on my own definition If I give 22 it should get values and distribute into 4 chunks and the remaining left based on the select query results and make the respective chunks of sequence. Here in this example the 99 records from my select query have been loaded into new table with 5 records (5 sequence number) each record carry the 22 records and the remaining. New Table <code>seq_number list_of_ids 1 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22 2 23,2425,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44 3 45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66 4 67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88 5 89,90,91,92,93,94,95,96,97,98,99</code> Is it possible to achieve the same in SQL query to who the results in above format or PL/SQL block? Appreciate your help.
Categories: DBA Blogs

impdp truncate date imported in timestamp

Tom Kyte - Wed, 2020-09-23 12:26
Hi, I created a table with a date column in an Oracle 18 database and I filled it with some date values: create table test_date (col1 date); insert into test_date values (sysdate); insert into test_date values (sysdate); select * from test_date; COL1 ------------------- 22.09.2020 16:33:05 22.09.2020 16:33:15 The same table is created in an Oracle 19 database but with a timestamp(6) column: create table test_date (col1 timestamp(6)) If I import the table from 18 to 19 the date values are truncated (I used a database link but the error occurs also with a dumpfile): impdp system/...@ora_instance CONTENT=DATA_ONLY TABLE_EXISTS_ACTION=TRUNCATE TABLES=user_in_18db.test_date network_link=db_link_from_19_to_18 remap_schema=user_in_18db:user_in_19db Import: Release 19.0.0.0.0 - Production on Tue Sep 22 16:45:26 2020 Version 19.5.0.0.0 ... . . "USER_IN_19DB"."TEST_DATE" 2 Zeilen importiert Job "SYSTEM"."SYS_IMPORT_TABLE_01" erfolgreich um Di Sep 22 16:45:37 2020 elapsed 0 00:00:10 abgeschlossen but select * from test_date; -- in the Oracle 19 database COL1 ------------------- 22.09.2020 00:00:00 22.09.2020 00:00:00 For output I am using: NLS_TIMESTAMP_FORMAT = 'DD.MM.YYYY HH24:MI:SS' NLS_DATE_FORMAT = 'DD.MM.YYYY HH24:MI:SS' YS Nicola
Categories: DBA Blogs

SQL Profiles Long Term Benefits and Issues

Tom Kyte - Tue, 2020-09-22 18:26
Hello, I researched your Q/A bank before asking this question. What are some of the things to keep in mind, where a benefit to using a sql profile turns into a curse. What are the things that can cause the use of sql profile to go bad or problems that can go un noticed as a result of using the profile ? Thank you.
Categories: DBA Blogs

Partition existing non-partitioned tables in 12.1.0.2.0

Tom Kyte - Tue, 2020-09-22 18:26
Which one is recommended in terms of performance(time taken to perform this activity) from below for a table with 18 GB data? https://oracle-base.com/articles/misc/partitioning-an-existing-table-using-exchange-partition or https://oracle-base.com/articles/misc/partitioning-an-existing-table
Categories: DBA Blogs

Grant privileges to add constraints on a table to other users

Tom Kyte - Tue, 2020-09-22 18:26
Hello, I create a table and grant ALL privileges on it to user B. User B can delete, select, insert, update on the table, but When user B uses ALTER TABLE ... ADD CONSTRAINT...PRIMARY KEY OR UNIQUE, it has a SQL Error: ORA-01031: insufficient privileges. How can I fix this error? Thanks, Duong
Categories: DBA Blogs

Procedures Output Parameters vs Debug Compile

Tom Kyte - Tue, 2020-09-22 18:26
Hi Tom, On your website I didn't find anything about this topic that could help me, so I decided to write. We detect a situation in the execution of a procedure that is not expected to happen. The output parameters are returned with values, when it was not supposed to. The situation became even stranger, when after several tests we concluded that the way the package was compiled influenced the behavior of the function's execution in what refers to the output parameters. That is, if the package is compiled in debug mode, the results are as expected. The same does not happen if the package is not compiled in debug. The scenario: when executing a function that results in an error, it is not expected that the output parameter will be filled in (unless the code is not well written). But the case in point is that the code does not point to the output parameters being filled. Furthermore, if we manipulate the OPTIMIZE LEVEL defined in the database, the behavior on the output parameters is also influenced. The optimize levels 0 and 1 (corresponding to the debug), everything works fine. Level 2 always works poorly and with Level 3, depending on the complexity of the code, sometimes it works well and sometimes badly. Simple examples were created to highlight the anomaly detected. The attached script creates two functions and the call / execution of "FCOUTPUT_TEST_LEVEL_1" It should be noted that this situation was detected and tested in oracle 12c and oracle 19c (PDB) In advance I appreciate the help you can give.
Categories: DBA Blogs

How to move the Jobs(Present in user_scheduler_jobs table) from one User to another User ,Present in the same DB server

Tom Kyte - Tue, 2020-09-22 18:26
Team, Very Good Monday Morning !! The Version of Oracle we use is : <i>Oracle Database 11g Release 11.2.0.4.0 - 64bit </i> No peculiar data or table design requried over here . This request is on behalf of Data and DB Objects Migration in our project. <i>we have 2 users by name User_1 and User_2 present in the same DB Server. </i> Entire Data Migration including table data, procedures,function,views ,sequence etc ....apart from Scheduled jobs has been done. <i>User_1 has 5 Jobs by name Job_1,Job_2,Job_3 ,Job_4 and Job_5 These Jobs are available under the system table user_scheduler jobs, with their corresponding procedure names, start time ,time of execution, status etc. </i> Now I would like to move these 5 Jobs into User_2. Can someone just how to move these jobs from User_1 to User-2 <b>from a PL/SQl Developer Perspective</b>. Thanks and Regards !!
Categories: DBA Blogs

ANSI SQL is slower than Oracle SQL notation

Tom Kyte - Tue, 2020-09-22 18:26
Hello, I've noticed that sometime a query of an Insert statement written in ANSI SQL runs slightly slower than a query constructed using Oracle native syntax. But recently I had a case when a native SQL executed within seconds, while the ANSI SQL could not complete. I resolved the problem by converting the ANSI SQL to Oracle native, but wanted to understand why it was happening and whether any guidelines could be offered on when not to use ANSI SQL. The long running query was pulling data from one huge fact table and a a few not so big dimension tables. The fact table is partitioned by date range and sub-partitioned by list, and was created with PARALLEL 16 clause. The /*+ FULL */ hint in the query is used to force Exadata smart scan. The query looked like that: <code> SELECT /*+ FULL (fact) */ fact.partition_key_date, fact.subpartition_col, SUM(CASE WHEN fact.col = 'S' THEN (ABS (sale_amt)) END) OVER PARTITION (fact.col_a, fact.col_b) as SALE_AMT, SUM(CASE WHEN fact.col = 'O' THEN (sale_amt) END) OVER PARTITION (fact.col_a, fact.col_b) as OTHER_AMT FROM dim1 JOIN fact ON dim1.key = fact.attr1 JOIN dim2 ON fact.attr2 = dim2.key AND dim2.col = 'ABC' WHERE fact.partition_key_date = :dt_parm AND fact.subpartition_col = 'KYZ' AND fact.attr2 = 'X' AND NVL(fact.attr3, 'N') <> 'Y' AND NOT EXISTS ( SELECT 1 FROM dim3 WHERE fact.attr4 = dim3.key); </code> It was queued for parallel execution for more than an hour before starting the 32 parallel slaves. It was running for many hours and never completed. But when the analytical SUM function was removed from the selected column list it completed within seconds. Yet with the same analytical function and with Oracle SQL syntax, as shown below, the query also completed in 5 seconds. <code> SELECT /*+ FULL (fact) */ fact.partition_key_date, fact.subpartition_col, SUM(CASE WHEN fact.col = 'S' THEN (ABS (sale_amt)) END) OVER PARTITION (fact.col_a, fact.col_b) as SALE_AMT, SUM(CASE WHEN fact.col = 'O' THEN (sale_amt) END) OVER PARTITION (fact.col_a, fact.col_b) as OTHER_AMT FROM dim1, fact, dim2 WHERE fact.partition_key_date = :dt_parm AND fact.subpartition_col = 'KYZ' AND fact.attr2 = 'X' AND NVL(fact.attr3, 'N') <> 'Y' AND dim1.key = fact.attr1 AND fact.attr2 = dim2.key AND dim2.col = 'ABC' AND NOT EXISTS ( SELECT 1 FROM dim3 WHERE fact.attr4 = dim3.key); </code>
Categories: DBA Blogs

Outer join inside decode syntax

Tom Kyte - Tue, 2020-09-22 18:26
Hi Tom, Could you please clarify why the following simple sql is returning the result? <code> select a.dummy, b.dummy, decode ( a.dummy, 'X', null, b.dummy ) from dual a, dual b where decode ( a.dummy, 'X', null, b.dummy (+) ) = a.dummy ; </code> At first it looks like satisfied null = 'X' condition. Is it true that using (+) after default value in decode is an equivalent of left outer joining on entire decode? Is the following query the equivalent of the former one? <code> select a.dummy, b.dummy, decode ( a.dummy, 'X', null, b.dummy ) from dual a left outer join dual b on decode ( a.dummy, 'X', null, b.dummy ) = a.dummy ; </code>
Categories: DBA Blogs

静岡で水道修理を依頼するには

The Feature - Mon, 2020-09-21 05:57

水道工事には新築の際に行う給水管の引き込み工事や室内の配管、下水道排水工事などがあります。道路側の工事を行うには自治体の許可が必要で、自治体の指定を受けた水道工事の業者が行います。敷地内の工事や修理も同じで、自治体の指定を受けた事業者に敷地の所有者が依頼して行います。一般家庭で使用している上下水道は、各自治体の水道局が管理しています。

その水道局が管理している上下水道で工事を行えるのは、自治体が指定を与えた事業者と水道法により定められています。静岡市内で水道修理の工事を行うためには、静岡市の上下水道局の指定給水装置工事事業者に依頼する必要があります。静岡市の水道局に認定された指定給水装置工事事業者以外に依頼して水道修理を行うと、後でトラブルが起こる可能性があります。最悪の場合、法律に違反したとして給水を止められる可能性もあるので注意してください。

台所やお風呂場など水回りの部品の交換を、居住者が行うことに問題はありません。蛇口のパッキンやカートリッジなどの部品は、正しいサイズのものを取り寄せれば誰でも交換することが可能です。しかし配管を伴う水道修理は、大掛かりな工事になる可能性があり素人が行うのは危険です。地域の水道局の指定給水装置工事事業者に修理を依頼した方が安全です。

指定給水装置工事事業者は身元も確かで、トラブルが起こる可能性は低くなります。もし仮にトラブルが起きたとしても、水道局に相談できるので安心して修理を依頼することができます。

Categories: APPS Blogs

静岡で水道修理を依頼するには

Marian Crkon - Mon, 2020-09-21 05:57
水道工事には新築の際に行う給水管の引き込み工事や室内の配管、下水道排水工事などがあります。道路側の工事を行うには自治体の許可が必要で、自治体の指定を受けた水道工事の業者が行います。敷地内の工事や修理も同じで、自治体の指定を受けた事業者に敷地の所有者が依頼して行います。一般家庭で使用している上下水道は、各自治体の水道局が管理しています。 その水道局が管理している上下水道で工事を行えるのは、自治体が指定を与えた事業者と水道法により定められています。静岡市内で水道修理の工事を行うためには、静岡市の上下水道局の指定給水装置工事事業者に依頼する必要があります。静岡市の水道局に認定された指定給水装置工事事業者以外に依頼して水道修理を行うと、後でトラブルが起こる可能性があります。最悪の場合、法律に違反したとして給水を止められる可能性もあるので注意してください。 台所やお風呂場など水回りの部品の交換を、居住者が行うことに問題はありません。蛇口のパッキンやカートリッジなどの部品は、正しいサイズのものを取り寄せれば誰でも交換することが可能です。しかし配管を伴う水道修理は、大掛かりな工事になる可能性があり素人が行うのは危険です。地域の水道局の指定給水装置工事事業者に修理を依頼した方が安全です。 指定給水装置工事事業者は身元も確かで、トラブルが起こる可能性は低くなります。もし仮にトラブルが起きたとしても、水道局に相談できるので安心して修理を依頼することができます。

Oracle 19c Automatic Indexing: CBO Incorrectly Using Auto Indexes Part II ( Sleepwalk)

Richard Foote - Mon, 2020-09-21 02:39
As I discussed in Part I of this series, problems and inconsistencies can appear between what the Automatic Indexing processing thinks will happen with newly created Automatic Indexing and what actually happens in other database sessions. This is because the Automatic Indexing process session uses a much higher degree of Dynamic Sampling (Level=11) than other […]
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator