Archive for the ‘SQL and Databases’ Category
Oracle – obtain the amount of redo files
Posted by cornel | Filed under SQL and Databases
I found a query which can be used to estimate what is the amount of storage for database log files and also identify when you have peak periods:
1: SELECT Start_Date,
2: Start_Time,
3: Num_Logs,
4: Round(Num_Logs * (Vl.Bytes / (1024 * 1024)),
5: 2) AS Mbytes,
6: Vdb.NAME AS Dbname
7: FROM (SELECT To_Char(Vlh.First_Time,
8: 'YYYY-MM-DD') AS Start_Date,
9: To_Char(Vlh.First_Time,
10: 'HH24') || ':00' AS Start_Time,
11: COUNT(Vlh.Thread#) Num_Logs
12: FROM V$log_History Vlh
13: GROUP BY To_Char(Vlh.First_Time,
14: 'YYYY-MM-DD'),
15: To_Char(Vlh.First_Time,
16: 'HH24') || ':00') Log_Hist,
17: V$log Vl,
18: V$database Vdb
19: WHERE Vl.Group# = 1
20: ORDER BY Log_Hist.Start_Date,
21: Log_Hist.Start_Time;
IBM DB2 9.5 strikes again
Posted by cornel | Filed under Events, SQL and Databases
Today, I visited the TPC website and I saw that IBM is again number one on the TPC-C benchmark. Take a look at the server configuration: 4TB of RAM and 730TB of disk storage – I’m wonder what the next winning configuration will be.