We are taking steps to make our moderation process friendlier while ensuring that SAP Community continues to comply with the Digital Services Act (DSA). Learn more in this What’s New post.
Hi all,
i need some help with the transaction sm37
I know that i can use the * for zero or more unknown characters. That's working as the % in Oracle and other databases.But i want something like the _ from Oracle, for exact 1 unk...
Hi all,we start upgrading our development System to 750.Now we faced the problem that the transaction se38 dumps with "ora-01403 no data found" if you start writing the name of the report you're looking for.The underlying view for this input is the v...
Hi all,i'm trying to use the SQL Command Editor in Transaction st04 / Performance / Additional Functions.But a simple "select sysdate from dual" will cause the following message:"Exception CX_DBA_ROOT in class CL_ORA_SQL_EXECUTOR method line 0"The s...
Hi,today i investigate a performance Problem we faced this night.So i check the "Display historical Statements" in the st04 Statement Cache.But no historical snapshot was available. In the SAP Collector Profile i have this values, so i expect it has ...
Hi,the last days i faced the problem that i can't display the bind variables in the execution plan in systems that running SAP Netweaver 7.40.I push the button "Bind Variablen" and get the message "An SQL-Error is occured: 936".Looking into sm21 i se...
Thanks Sandra, but i'm only a poor lonesome DBA. I only want to use the sm37. And i have to use it on systems on slient side, so no chance to modify or create my own sm37.regardsKay
Hi all,after submitting a service request the SAP support answers this:"the mentioned issue seems to be a known ORACLE bug. Please check the following note: 2174705 - Session variablesand implement oracle client version 12.1.0.2.0, V2 (currently V1 i...
Hi all,i did a new test with another 750 system. Identical software- and productcomponents, identical DBSL-lib. Both views use the SYS_CONTEXT.And here it works as expected. The se16 shows both german and english entries of table SEDT_PROG_VIEW.So i ...
Hallo Oliver, no, i don’t mean that i’m able to open 5 Forums on a single screen. It was something like a stream, you see the topics, the name of the forum and counts for views and replies. It looks more than the old usenet. And now we get more and ...
oops, i forget the MANDT column. But now you get a weird plan because the statistics shows that the table is empty, it has 0 rows.So every index is a good access because the optimizer expects that no row match with the MANDT column. If your statistic...
