Oracle Informations | SAPBASISINFO

Find Active HANA Ports via SQL Queries

If you want to list “Active HANA Ports” on OS or HANA Admin Tool via SQL, then you can try to use below SQL queries to do it...
SAP HANA Status Check via SAPCONTROL

You can easily check you SAP HANA system’s status on Linux system via “sapcontrol” command…To do this...
List all Connected Applications to SAP HANA

You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor. ...
LIST & KILL Sessions on HANA

If you need to LIST all sessions or KILL a specific active session on HANA then you can use the following SQL queries to do these kind of actions...
Check Memory Usage and DB Size on HANA via SQL

You can use the following SQL queries to check your HANA system’s memory usage details… ...
Activate / Deactivate user in SAP HANA DB

The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the...
CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update

You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In...
HANA Backup and Recovery SQL Queries

You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation. ...
Useful Python Scripts for HANA

All python scripts can be found in exe/python_support directory. These scripts can affect the system therefore it’s better to check with...
HANA Cleaner Python Script – hanacleaner.py

SAP HANA cleanup tasks like purging the backup catalog or deleting old trace files need to be implemented individually.SAP created a Python script...