Description:
Oracle database administration/server topics.
|
|
|
SYS login possible in sqlplus, but not in Enterprise Manager
|
| |
Hi everybody! After restoring a RMAN backup to another machine (database and applikation running fine with no probs) I'm experiencing the following problem: I can logon using sqlplus and login SYS or SYSTEM. Not problems here, but I can't login (using the same credentials) via Enterprise Manager (neither on... more »
|
|
|
shell scripts issue
|
| |
Hi all, My scripts looks like this .. when i execute this script its says file does not exist even though file is present physically and if the file does not present in the file system then the output is null. I am wrong somewhere .. ?? echo " enter file " read name for i in `find /apps12i -type f -name $name -printf %f `... more »
|
|
|
Hash cluster, parameter SIZE
|
| |
Hi everyone. I have a table with transactions of customers. There are about 20 transactions per month for a customer, I need to store history of 24 months. There is about 1 500 000 customers. Average length of row is 300 bytes. The only select statements on this table would be count of transactions, balance of transactions, etc., etc of one customer.... more »
|
|
|
Books For Sale
|
| |
I have listed these on eBay for my spouse. I hope that I am not being a horrible spammer, but wasn't sure where to post them. [link] Peace Jo
|
|
|
performance issue after upgrade to oracle 11.2.0.1 linux 32 bit
|
| |
Hi All, I have one insteresting performance issue about 11.2.0.1. Any comments are appreciated. When I use A JOIN B and A JOIN C, the optimizer choose index scan on table C. When I use A JOIN B and B JOIN C, the optimizer choose full table scan on table C. 1. The query that uses index scan SELECT X.SERV_PROV_CODE,... more »
|
|
|
Table Partition Count
|
| |
Hi, I have a table T1. I have 5 partitions in that table, say : PART1, PART2, PART3, PART4, PART5. I need to take individual row count for these 5 partitions present in the table T1. How can i do that ? Please help. With Regards, Raja.
|
|
|
Oracle PGA sizing and ORA-4030
|
| |
Hello, we use Oracle 10.2.0.4 on Windows 32 Bit platform and run sometimes into ORA-4030 problems. Current memory settings are : sga_max_size : 1504M sga_target : 1304M pga_aggregate_target : 400 M According this configuration I should not hit the 2 Gbyte limit on 32 bit platforms. However, if I look to statistics "maximum PGA allocated" it seems PGA... more »
|
|
|
DASD Disk Layout Advice
|
| |
For the last few years, I've largely been laying out Oracle storage on SAN's, rather than on DASD, so I'm feeling a bit out of practise with today's drives and drive arrays. To make a long story short, I've got a new Oracle server in a remote data center that I didn't order or configure; it comes like it comes.... more »
|
|
|
|
