on 06-01-2009 10:07 AM
I know in some DB or ST transaction, one can run an arbitray sql. Can someone provide the transaction and detail on how to do it. Thanks a lot.,
ya.. you can run sql statements from sap..please find below tha path
DB02 transaction --> Performence --> Additional functions --> SQL command editor.
thanks sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The transaction mentioned is not "really" DB02. It is a new transaction called DBACOCKPIT that replaces ST04, DB03, DB13, DB14 and perhaps others.
Therefore, if you do not have at least basis 700 patch 13 (I think) that will not work.
In addition, the mentioned SQL editor does not allow you to select from the SAP* schema, only from sys. it is meant mainly for support for monitoring oracle.
Hi
But in DB02OLD you do not get the "SQL Editor" because it belongs to the DBACOCKPIT.
You can get similar tool on ST04N in not so recent systems. I'm not sure of the exact path (I do not have any at hand to check it) but you should look for a menut with "arbitrary Joins".
Same restrictions apply, only SELECT on SYS tables/views
Additionaly, you can use SE38 and report RSORADJV. Also with the same restrictions
Hi Fidel,
mainly that's true - but it works for some tables against the ABAP data dictionary
(i.e. you have to check some values from SAPR3 tables against data dictionary views:
Here I use RSTODS ( a BW table stroing ODS table information) as an input source for my IN clause on a DBA table in RSORADVJ to know the exact partition counts on every ODS table.
Ex.:
select table_name,
replace(To_char((sum(blocks) * 8192) / 1024/1024,'99999.99' ),'.',',') Mbyte,
sum(num_rows) numrows, sum(blocks) blocks ,
count(*) num_part
from dba_tab_partitions " <--------------------------- Oracle dict table
where table_owner ='SAPR3' and
TABLE_NAME in
( select odsname_tech from rstsods) " <----------------- BW table
group by table_name having ((sum(blocks) * 8192) / 1024/1024) >= 1
order by blocks desc
ok - it's somewhat limited what you can do (and it may a feature or a security bug )
but it works for me
bye yk
... it would be a security issue if everybody had the ST04 authority.
The possibility to select the Oracle administrative tables has proven to be useful in many cases.
For example, with the statement
select count(*) num_sessions from v$session
I retrieve the number of DB sessions that are currently in use.
- Rüdiger
try SQVI
or search Google with keywords:
run sql command from sapgui
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.