Hi, If you got slowness complaint from customer, you need to monitor SQL Server Instance and database which sql is consuming a lots of resource.
Read More »Tag Archives: MEHMET SALİH DEVECİ
SQL Server Collection Inventory Script -1
Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.
Read More »ORA-01031: insufficient privileges with SYSDBA Priviliges
Hi, Although sys user is most priviliged user in Oracle database but also you can get ORA-01031: insufficient privileges SYSDBA.
Read More »ORA-12545 connect failed because target host or object does not exist
Hi, You can get ” ORA-12545 connect failed because target host or object does not exist ” error when connect to database via Toad or PLSQL Developer.
Read More »ORA-19809: limit exceeded for recovery files
Hi, You can get ORA-19809: limit exceeded for recovery files error during the rman operations or database startup.
Read More »Oracle Performance TOP SQL Scripts -4
Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.
Read More »CLSRSC-507: The root script cannot proceed during root.sh Oracle 12c RAC installation
Hi, When I install Oracle 12c RAC ( Real application cluster ) i got ” CLSRSC-507: The root script cannot proceed on this node Node2 because either the first-node operations …
Read More »Oracle Performance TOP SQL Scripts -3
Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.
Read More »Oracle Performance TOP SQL Scripts -2
Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.
Read More »Oracle Top Tables Segment Size and Schema Size Scripts
Hi, You want to learn which table is biggest in database or which schema is biggest in database.
Read More »